<?php
/**
* Created on 6.4.2009
*
* @author: GOrazd Vesleič
*/
class SurveyInfo
{
static private $instance;
static private $inited;
static private $surveyId = null;
static private $cntUsers = null;
static private $cntAnswers = null;
static private $cntApropriateAnswers = null; // ustrezni odgovori (status = 4,5)
static private $cntValidSurveys = null; // hrani stevilo ustrezno izpolnjenih vprasalnikov (status = 6)
static private $cntPartiallyValidSurveys = null; // hrani stevilo delno izpolnjenih vprasalnikov (status = 5)
static private $cntInvalidSurveys = null; // hrani stevilo neustrezno izpolnjenih vprasalnikov (status = 3 ali 4)
static private $cntGroups = null;
static private $cntQuestions = null;
static private $cntVarables = null;
static private $access_users = null;
static private $rowSurveyInit = null;
static private $rowUserInsertInfo = null;
static private $rowUserEditInfo = null;
static private $rowVsiUpo = null;
static private $rowFirstLast = null;
static private $surveyModules = null;
static public $dateTimeSeperator = ', ';
static private $enkaVersion = null;
protected function __construct() {}
private function __clone() {}
/** Poskrbimo za samo eno instanco razreda
*
*/
static function getInstance()
{
if(!self::$instance)
{
self::$instance = new SurveyInfo();
}
return self::$instance;
}
/**
* ob inicializaciji samo nastavimo survey ID, podatke bomo polovili, ko jih bomo rabili
*
* @param mixed $_surveyId
*/
static function SurveyInit($_surveyId)
{
self::$surveyId = $_surveyId;
self::$cntUsers = null;
self::$cntAnswers = null;
self::$cntApropriateAnswers = null;
self::$cntValidSurveys = null;
self::$cntPartiallyValidSurveys = null;
self::$cntInvalidSurveys = null;
self::$cntGroups = null;
self::$cntQuestions = null;
self::$cntVarables = null;
self::$access_users = null;
self::$rowSurveyInit = null;
self::$rowUserInsertInfo = null;
self::$rowUserEditInfo = null;
self::$rowVsiUpo = null;
self::$rowFirstLast = null;
self::$dateTimeSeperator = ', ';
self::$surveyModules = null;
self::$enkaVersion = null;
self::$inited = true;
return true;
}
/**
* Vsilimo ponovno branje podatkov iz baze. (Uporabljamo po updejtih srv_anketa)
*/
static function resetSurveyData() {
self::$rowSurveyInit = null;
}
/**
* vrne stolpec ($key) iz tabele srv_anketa za inicializirano anketo
*
* @param mixed $key stolpec v tabeli srv_anketa
* @return vrednost v stolpcu $key
*/
static function getSurveyColumn ($key) {
$row = self::getSurveyRow();
return $row != null ? $row[$key] : null;
}
static function getSurveyRow () {
if (!self::$rowSurveyInit) {
$querySurveyInit = sisplet_query("SELECT * FROM srv_anketa WHERE id = '".self::$surveyId."'");
self::$rowSurveyInit = mysqli_fetch_assoc($querySurveyInit);
// Dodatno ciscenje texta naslova ankete - ne smemo imeti nobenih tag-ov
self::$rowSurveyInit['naslov'] = strip_tags(self::$rowSurveyInit['naslov']);
self::$rowSurveyInit['akronim'] = strip_tags(self::$rowSurveyInit['akronim']);
}
return self::$rowSurveyInit;
}
static function getUserInsertInfo ($key) {
if (!self::$rowUserInsertInfo) {
$sqlUserInsertInfo = sisplet_query("SELECT name, surname, id, email FROM users WHERE id='".self::getSurveyInsertUid()."'");
self::$rowUserInsertInfo = mysqli_fetch_assoc($sqlUserInsertInfo);
}
return self::$rowUserInsertInfo[$key];
}
static function getUserEditInfo ($key) {
if (!self::$rowUserEditInfo) {
$sqlUserEditInfo = sisplet_query("SELECT name, surname, id, email FROM users WHERE id='".self::getSurveyEditUid()."'");
self::$rowUserEditInfo = mysqli_fetch_assoc($sqlUserEditInfo);
}
return self::$rowUserEditInfo[$key];
}
static function getEnkaVersion($key) {
if (!self::$enkaVersion) {
$sqlEnkaVersion = sisplet_query("SELECT value FROM misc WHERE what='version' ");
self::$enkaVersion = mysqli_fetch_assoc($sqlEnkaVersion);
}
return self::$enkaVersion[$key];
}
/*
static function getVsiUpo () {
if (!self::$rowVsiUpo) {
$sqlVsiUpo = sisplet_query("SELECT id AS usr_id FROM srv_user WHERE ank_id = '".self::$surveyId."' AND preview = '0'");
self::$rowVsiUpo = mysqli_fetch_assoc($sqlVsiUpo);
}
return self::$rowVsiUpo;
}
*/
static function getFirstLast ($key) {
if (!self::$rowFirstLast) {
$sqlFirstLast = sisplet_query("SELECT min( time_insert ) as frst, max( time_insert ) as lst FROM srv_user WHERE ank_id = '".self::$surveyId."' AND preview ='0' AND deleted='0'");
self::$rowFirstLast = mysqli_fetch_assoc($sqlFirstLast);
}
return self::$rowFirstLast[$key];
}
// te funkcije ohranimo, da se obdrzi kompatibilnost za nazaj. Za naprej se lahko uporabi kar direktno getSurveyColumn (v primerih kjer se lahko)
static function getSurveyId() { return self::$surveyId; }
static function getSurveyHash() { return self::getSurveyColumn('hash'); }
static function getSurveyTitle() { return strip_tags(is_string(self::getSurveyColumn('naslov')) ? self::getSurveyColumn('naslov') : ''); }
static function getSurveyAkronim() { return strip_tags(is_string(self::getSurveyColumn('akronim')) ? self::getSurveyColumn('akronim') : ''); }
static function getSurveyActive() { return self::getSurveyColumn('active'); }
static function getSurveyFolder() { return self::getSurveyColumn('folder'); }
static function getSurveyInfo() { return self::getSurveyColumn('intro_opomba'); }
static function getSurveyType() { return self::getSurveyColumn('survey_type'); }
static function getSurveyShowIntro() { return self::getSurveyColumn('show_intro'); }
static function getSurveyShowConcl() { return self::getSurveyColumn('show_concl'); }
static function getSurveyIntro() { return strip_tags(is_string(self::getSurveyColumn('introduction')) ? self::getSurveyColumn('introduction') : ''); }
static function getSurveyConcl() { return strip_tags(is_string(self::getSurveyColumn('conclusion')) ? self::getSurveyColumn('conclusion') : ''); }
static function getSurveyCountType() { return self::getSurveyColumn('countType'); }
static function getSurveyInsertUid() { return self::getSurveyColumn('insert_uid'); }
static function getSurveyInsertName() {
if (trim(self::getUserInsertInfo('name')) || trim(self::getUserInsertInfo('surname'))) {
return self::getUserInsertInfo('name').(trim(self::getUserInsertInfo('name')) || trim(self::getUserInsertInfo('surname')) ? ' ' : '').self::getUserInsertInfo('surname');
} else {
global $lang;
return $lang['srv_anonymous'];
}
}
static function getSurveyInsertNameShort(){
return substr(self::getUserInsertInfo('name'),0,1).substr(self::getUserInsertInfo('surname'),0,1);
}
static function getSurveyInsertEmail() {
if (trim(self::getUserInsertInfo('email'))) {
return self::getUserInsertInfo('email');
} else {
global $lang;
return $lang['srv_anonymous'];
}
}
static function getSurveyInsertDate() { $insertDateTime = explode(" ", self::getSurveyColumn('insert_time')); $tmpDate = explode('-',$insertDateTime[0]); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0]; }
static function getSurveyInsertTime() { $insertDateTime = explode(" ", (self::getSurveyColumn('insert_time'))); return $insertDateTime[1]; }
static function getSurveyEditUid() { return self::getSurveyColumn('edit_uid'); }
static function getSurveyEditName() {
if (trim(self::getUserEditInfo('name')) || trim(self::getUserEditInfo('surname'))) {
return self::getUserEditInfo('name').(trim(self::getUserEditInfo('name')) || trim(self::getUserEditInfo('surname')) ? ' ' : '').self::getUserEditInfo('surname');
} else {
global $lang;
return $lang['srv_anonymous'];
}
}
static function getSurveyEditNameShort(){
return substr(self::getUserEditInfo('name'),0,1).substr(self::getUserEditInfo('surname'),0,1);
}
static function getSurveyEditEmail() {
if (trim(self::getUserEditInfo('email'))) {
return self::getUserEditInfo('email');
} else {
global $lang;
return $lang['srv_anonymous'];
}
}
static function getSurveyEditDate() { $editDateTime = explode(" ", (self::getSurveyColumn('edit_time'))); $tmpDate = explode('-',$editDateTime[0]); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0]; }
static function getSurveyEditTime() { $editDateTime = explode(" ", (self::getSurveyColumn('edit_time'))); return $edit_time = $editDateTime[1]; }
static function getSurveyStartsDate() { $tmpDate = explode('-',(self::getSurveyColumn('starts'))); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0]; }
static function getSurveyExpireDate() { $tmpDate = explode('-',(self::getSurveyColumn('expire'))); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0]; }
static function getSurveyFirstEntryDate() {
if (self::getFirstLast('frst') == '0000-00-00 00:00:00' || self::getFirstLast('frst') == null)
return null;
$firstDateTime = explode(" ", self::getFirstLast('frst')); $tmpDate = explode('-',$firstDateTime[0]); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0];
}
static function getSurveyLastEntryDate() {
if (self::getFirstLast('lst') == '0000-00-00 00:00:00' || self::getFirstLast('lst') == null)
return null;
$lastDateTime = explode(" ", self::getFirstLast('lst')); $tmpDate = explode('-',$lastDateTime[0]); return $tmpDate[2].".".$tmpDate[1].".".$tmpDate[0];
}
static function getSurveyFirstEntryTime() {
if(!is_string(self::getFirstLast('frst')))
return '';
$firstDateTime = explode(" ", self::getFirstLast('frst'));
$tmpDate = explode(':',$firstDateTime[1]);
return $tmpDate[0].":".$tmpDate[1].":".$tmpDate[2];
}
static function getSurveyLastEntryTime() {
if(!is_string(self::getFirstLast('lst')))
return '';
$lastDateTime = explode(" ", self::getFirstLast('lst'));
$tmpDate = explode(':',$lastDateTime[1]);
return $tmpDate[0].":".$tmpDate[1].":".$tmpDate[2];
}
static function getSurveyGroupCount() {
if (!self::$cntGroups) {
$sqlg = sisplet_query("SELECT count(*) FROM srv_grupa WHERE ank_id='".self::$surveyId."'");
$rowg = mysqli_fetch_row($sqlg);
self::$cntGroups = $rowg[0];
}
return self::$cntGroups;
}
/*
static function getSurveyUsersId() { return self::getVsiUpo(); }
static function getSurveyUsersCount() { return count(self::getVsiUpo()); }
*/
static function getSurveyAnswersCount() {
if (!self::$cntAnswers) {
# ročno preštrejemo odgovore
$str_qry_all_users = "SELECT count(u.id) AS user_count FROM srv_user AS u " . "WHERE u.ank_id = '".self::getSurveyId()."' AND u.preview = '0' AND u.deleted='0'";
$qry_all_users = sisplet_query($str_qry_all_users);
$row_all_users = mysqli_fetch_assoc($qry_all_users);
self::$cntAnswers = $row_all_users['user_count'];
}
return self::$cntAnswers;
}
static function getSurveyApropriateAnswersCount() {
//@Uroš je 31.8.2017 dodal v funkcijo refreshData() v classSurveyList.php izkljucevanje lurkerjev v stolpcu approp
//v DB tabeli srv_survey_list. Prej so bili v approp vkljuceni vsi userji s parametri "preview = '0' AND deleted='0' AND last_status IN (5,6)"
//zaenkrat se se naj uporablja ta funkcija, ker bi drugace prislo do razhajanja v stevilu ustreznih enot, ker se
//podatki za stare ankete ne bi posodobili (bi bili se vedno vkljuceni lurkerji)
//enkrat v prihodnosti, bi se lahko klicalo samo SELECT approp FROM srv_survey_list WHERE id='self::getSurveyId()'
//tocen datum, kdaj se bo yadeva updatala na produkcijo, glej datum prvega updata po tej spremembi
if (!self::$cntApropriateAnswers) {
# ročno preštrejemo veljavne odgovore
$sqlStringAll = "SELECT count(*) as cnt FROM srv_user WHERE ank_id = '" . self::getSurveyId() . "' AND preview = '0' AND deleted='0' AND last_status IN (5,6) AND lurker = 0"; // samo veljavne statuse
$qry_AppAnsw = sisplet_query($sqlStringAll);
$row_AppAnsw = mysqli_fetch_assoc($qry_AppAnsw);
self::$cntApropriateAnswers = $row_AppAnsw['cnt'];
}
return self::$cntApropriateAnswers;
}
static function getValidSurveysCount() {
if (!self::$cntValidSurveys) {
# rocno prestejemo veljavno (ali delno) veljavne vprasalnike
$sqlStringAll = "SELECT count(*) as cnt FROM srv_user WHERE ank_id='" . self::getSurveyId() . "' AND last_status = '6' AND lurker = '0' AND deleted='0' AND preview = '0' AND testdata='0'"; // samo Completed status ali Partially completed
$qry_ValidSurveys = sisplet_query($sqlStringAll);
$row_ValidSurveys = mysqli_fetch_assoc($qry_ValidSurveys);
self::$cntValidSurveys = $row_ValidSurveys['cnt'];
}
return self::$cntValidSurveys;
}
static function getPartiallyValidSurveysCount() {
if (!self::$cntPartiallyValidSurveys) {
# rocno prestejemo veljavno (ali delno) veljavne vprasalnike
$sqlStringAll = "SELECT count(*) as cnt FROM srv_user WHERE ank_id='" . self::getSurveyId() . "' AND last_status = '5' AND lurker = '0' AND deleted='0' AND preview = '0' AND testdata='0'"; // samo Completed status ali Partially completed
$qry_PartiallyValidSurveys = sisplet_query($sqlStringAll);
$row_PartiallyValidSurveys = mysqli_fetch_assoc($qry_PartiallyValidSurveys);
self::$cntPartiallyValidSurveys = $row_PartiallyValidSurveys['cnt'];
}
return self::$cntPartiallyValidSurveys;
}
static function getInvalidSurveysCount() {
if (!self::$cntInvalidSurveys) {
# rocno prestejemo neveljavne vprasalnike
//$sqlStringAll = "SELECT count(*) as cnt FROM srv_user WHERE ank_id='" . self::getSurveyId() . "' AND last_status IN (0,1,2,3,4,5l,6l) AND deleted='0' AND preview = '0' AND testdata='0'"; // samo invalid
$sqlStringAll = "SELECT count(*) as cnt FROM srv_user WHERE ank_id='" . self::getSurveyId() . "' AND last_status IN (0,1,2,3,4,'5l', '6l') AND lurker = '1' AND deleted='0' AND preview = '0' AND testdata='0'"; // samo invalid
$qry_InvalidSurveys = sisplet_query($sqlStringAll);
$row_InvalidSurveys = mysqli_fetch_assoc($qry_InvalidSurveys);
self::$cntInvalidSurveys = $row_InvalidSurveys['cnt'];
}
return self::$cntInvalidSurveys;
}
static function getSurveyQuestionCount(){
if (!self::$cntQuestions) {
# zato ročno preštrejemo vprašanja
$str_qry_Questions = "SELECT s.id FROM srv_grupa g, srv_spremenljivka s WHERE g.ank_id='".self::getSurveyId()."' "." AND g.id=s.gru_id ";
$qry_Questions = sisplet_query($str_qry_Questions);
self::$cntQuestions = mysqli_num_rows($qry_Questions);
}
return self::$cntQuestions;
}
static function getSurveyVariableCount(){
if (!self::$cntVarables) {
#ročno preštrejemo variable
$str_qry_variables = "SELECT s.id, s.tip, s.size, s.enota FROM srv_grupa g, srv_spremenljivka s WHERE g.ank_id='".self::getSurveyId()."' "." AND g.id=s.gru_id ";
$qry_variables = sisplet_query($str_qry_variables);
self::$cntVarables = self::doVariablesCount($qry_variables);
}
return self::$cntVarables;
}
static function getDateTimeSeperator(){
return self::$dateTimeSeperator;
}
// preverimio še kdo ima dostop
static function getSurveyAccessUsers() {
if (!self::$access_users) {
self::$access_users= array();
$sqlDostop = sisplet_query("SELECT u.id, u.name, u.surname, u.email, dostop.alert_complete FROM users as u "
." RIGHT JOIN (SELECT sd.uid, sd.alert_complete FROM srv_dostop as sd WHERE sd.ank_id='".self::$surveyId."') AS dostop ON u.id = dostop.uid WHERE u.id != '".self::getSurveyInsertUid()."'");
while ($rowDostop = mysqli_fetch_assoc($sqlDostop)) {
self::$access_users[] = $rowDostop;
}
}
return self::$access_users;
}
/** Polovimo datume prvega aktiviranja in zadnjega deaktiviranja ankete
*
* @return unknown_type
*/
static function getSurveyActivity() {
$activity = array();
$sql = sisplet_query("SELECT starts, expire FROM srv_activity WHERE sid='".self::getSurveyId()."'");
if(mysqli_num_rows($sql) > 0){
$row = mysqli_fetch_assoc($sql);
$activity[] = array('starts'=>$row['starts'],'expire'=>$row['expire']);
}
return $activity;
}
static function DisplayInfoBox($showIcons = false) {
global $lang;
global $site_url;
global $global_user_id;
// Ce smo v seznamu anket upostevamo splosni jezik in ne jezik ankete
if(isset($_GET['a']) && $_GET['a'] == 'surveyList_display_info'){
$lang_orig = $lang['id'];
$sql = sisplet_query("SELECT lang FROM users WHERE id = '$global_user_id'");
$row = mysqli_fetch_array($sql);
$lang_admin = $row['lang'];
// Naložimo jezikovno datoteko
if($lang_admin != $lang_orig){
$file = '../../lang/'.$lang_admin.'.php';
include($file);
}
echo '<div class="popup_close">';
echo ' <a style="position:absolute; right:10px; top:10px" href="#" title="'.$lang['srv_zapri'].'" onclick="$(\'#survey_list_info\').hide(); return false;">✕</a>';
echo '</div>';
}
echo '<span class="survey_info_title">'.$lang['srv_status_osnovni'].'</span><br /><br />';
// spremenljivk
echo '<span class="space">' . $lang['srv_info_name'] . ':</span>' . self::getSurveyTitle() . '<br/>';
echo '<span class="space">' . $lang['srv_info_type'] . ':</span>' . $lang['srv_vrsta_survey_type_'.self::getSurveyType()] . '<br/>';
echo '<span class="space">' . $lang['srv_info_questions']. ':</span>' .self::getSurveyQuestionCount().'<br/>';
echo '<span class="space">' . $lang['srv_info_variables']. ':</span>' .self::getSurveyVariableCount().'<br/>';
echo '<span class="space">' . $lang['srv_info_answers']. ':</span>' .self::getSurveyAnswersCount().'<br/>';
echo '<span class="space">' . $lang['srv_info_answers_valid']. ':</span>' .self::getSurveyApropriateAnswersCount().'<br/>';
# jezik izpolnjevanja
echo '<span class="space">' . $lang['srv_info_language']. ':</span>'.self::getRespondentLanguage().'<br/>';
echo '<span class="space">' . ($showIcons ? '<span class="sprites user" title="'.$lang['srv_info_author'].'"></span> ' : '' )
. $lang['srv_info_author']. ':</span>' .self::getSurveyInsertEmail();
if (self::getSurveyInsertDate() && self::getSurveyInsertDate() != "00.00.0000")
echo self::$dateTimeSeperator . self::getSurveyInsertDate();
if (self::getSurveyInsertTime() && self::getSurveyInsertTime() != "00:00:00")
echo self::$dateTimeSeperator . self::getSurveyInsertTime();
echo '<br/>';
echo '<span class="space">' . ($showIcons ? '<span class="sprites user_edit" title="'.$lang['srv_info_modify'].'"></span> ' : '' )
. $lang['srv_info_modify']. ':</span>' .self::getSurveyEditEmail();
if (self::getSurveyEditDate() && self::getSurveyEditDate() != "00.00.0000")
echo self::$dateTimeSeperator . self::getSurveyEditDate() ;
if (self::getSurveyEditTime() && self::getSurveyEditTime() != "00:00:00")
echo self::$dateTimeSeperator . self::getSurveyEditTime();
echo '<br/>';
$dostop = self::getSurveyAccessUsers();
// dostop, Kdo razen avtorja ima dostop
if ($dostop) {
$cnt=0;
foreach ( $dostop as $user) {
if ($cnt==0) {
echo '<span class="space">';
echo ($showIcons ? '<span class="sprites user_add" title="'.$lang['srv_info_access'].'"></span> ' : '');
echo $lang['srv_info_access']. ': </span>'.$user['name']." (".$user['email'].")<br/>";
}
else
echo '<span class="infoData">'.$user['name']." (".$user['email'].')</span><br/>';
$cnt++;
}
}
// aktivnost
echo '<span class="space">';
echo ($showIcons ? '<span class="sprites clock_play" title="'.$lang['srv_info_activity'].'"></span> ' : '');
echo $lang['srv_info_activity']. ': </span>';
$activity = self:: getSurveyActivity();
if (is_countable($activity) && count($activity) > 0 ) {
$prefix = '';
foreach ($activity as $active) {
$_starts = explode('-',$active['starts']);
$_expire = explode('-',$active['expire']);
echo $prefix.$_starts[2].'.'.$_starts[1].'.'.$_starts[0].'-'.$_expire[2].'.'.$_expire[1].'.'.$_expire[0];
$prefix = '; ';
}
}
else {
echo $lang['srv_anketa_noactive2'].'!';
}
echo "<br />";
// prvi / zadnj vnos
if (trim(self::getSurveyFirstEntryDate()) != '') {
echo '<span class="space">';
echo ($showIcons ? '<span class="sprites date_previous" title="'.$lang['srv_info_first_entry'].'"></span> ' : '');
echo $lang['srv_info_first_entry']. ': </span>' . self::getSurveyFirstEntryDate() . self::$dateTimeSeperator .self::getSurveyFirstEntryTime() . '<br/>';
}
if (trim(self::getSurveyLastEntryDate()) != '') {
echo '<span class="space">';
echo ($showIcons ? '<span class="sprites date_next" title="'.$lang['srv_info_last_entry'].'"></span> ' : '');
echo $lang['srv_info_last_entry']. ': </span>' . self::getSurveyLastEntryDate() . self::$dateTimeSeperator . self::getSurveyLastEntryTime() . '<br/>';
}
echo '<br class="clr"/>';
$link = $site_url.'admin/survey/index.php?anketa=' . self::$surveyId.'&a=reporti';
echo '<span style="text-transform:capitalize; font-weight:600;"><a class="link" href="'.$link.'">'.$lang['srv_more'].' >></a></span>';
// Ce smo v seznamu anket upostevamo splosni jezik in ne jezik ankete
if(isset($_GET['a']) && $_GET['a'] == 'surveyList_display_info'){
// Naložimo originalno jezikovno datoteko
if($lang_admin != $lang_orig){
$file = '../../lang/'.$lang_orig.'.php';
include($file);
}
}
}
static function doVariablesCount($query){
// zloopamo skozi vprašanja in za vsako vprašan je preberemo št variabel
$cnt= 0;
while ($rowVprasanje = mysqli_fetch_assoc($query)) {
$spr_id= $rowVprasanje['id'];
// v odvisnosti od tipa vprašanja pohandlamo podatke
switch ( $rowVprasanje['tip'] ) {
case 1: // radio
case 3: // dropdown
$cnt++; // za sam header
$sqlSrvVred = self::select_sql_vrednost($rowVprasanje['id']);
while ( $rowSrvVred = mysqli_fetch_assoc($sqlSrvVred) ) {
if ($rowSrvVred['other'] == 1)
{
$cnt++; // za text polje
}
}
break;
case 2: // checkbox
case 6: // multigrid
case 18: // vsota
case 17: // ranking
case 21: // text*
$sqlSrvVred = self::select_sql_vrednost($rowVprasanje['id']);
while ( $rowSrvVred = mysqli_fetch_assoc($sqlSrvVred) ) {
$cnt++; // za vsako variablo
if ($rowSrvVred['other'] == 1) {
$cnt++; // za text polje (polj edrugo še ima tekstovni vnos
}
}
break;
case 4: // text
case 8: // datum
case 7: // number
case 22:// compute
case 25:// kvota
$cnt++;
if ( $rowVprasanje['tip'] == 7 && $rowVprasanje['size'] != 1 ) {
$cnt+=2;
}
break;
case 16: // multicheckbox
case 19: // multitext
case 20: // multinumber
$cnt++; // za sam header
$sqlSrvVred = self::select_sql_vrednost($spr_id);
//gridi s katerimi sestavljamo header (vrstica_grid)
while ( $rowSrvVred = mysqli_fetch_assoc($sqlSrvVred) ) {
//loop cez gride znotraj ene vrstice - ponovimo za vsako vrstico
$sqlSrvGrid = self::select_sql_grid($spr_id);
while ( $colSrvVred = mysqli_fetch_assoc($sqlSrvGrid) ) {
$cnt++;
}
if ($rowSrvVred['other'] == 1) {
$cnt++;
}
}
break;
// lokacija
case 26:
if($rowVprasanje['enota'] == 3){
$sqlSrvVred = self::select_sql_vrednost($rowVprasanje['id']);
while ( $rowSrvVred = mysqli_fetch_assoc($sqlSrvVred) ) {
$cnt++; // za vsako variablo
}
}
else
$cnt++; // moja lokacija in multilokacija je 1
break;
// heatmap
case 27:
$cnt++; // za koordinate
$sqlSrvVred = self::select_sql_vrednost($rowVprasanje['id']);
while ( $rowSrvVred = mysqli_fetch_assoc($sqlSrvVred) ) { //za morebitna obmocja
$cnt++; // za vsako variablo
if ($rowSrvVred['other'] == 1) {
$cnt++; // za text polje (polj edrugo še ima tekstovni vnos
}
}
break;
} // end switch
} // end while
return $cnt;
}
// pointerji do vrednosti zaradi hitrosti
/**
* @desc vrne sisplet_query za podan spr_id. v bistvu kesramo queryje, ker jih uporabljamo (zlo pogosto) v izpisu
*/
//static private $otherCondition = ' AND other NOT IN (99,98,97,96)';
static private $otherCondition = '';
private static $_select_sql_vrednost = array();
static function select_sql_vrednost ($spr_id) {
if ( isset(self::$_select_sql_vrednost[$spr_id]) ) {
// resetiramo pointer in vrnemo ke�iran query
if (mysqli_num_rows(self::$_select_sql_vrednost[$spr_id]))
mysqli_data_seek(self::$_select_sql_vrednost[$spr_id], 0);
return self::$_select_sql_vrednost[$spr_id];
}
else {
self::$_select_sql_vrednost[$spr_id] = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='".$spr_id."' AND vrstni_red > 0".self::$otherCondition." ORDER BY vrstni_red ASC");
return self::$_select_sql_vrednost[$spr_id];
}
}
/**
* @desc vrne sisplet_query za podan spr_id. v bistvu kesramo queryje, ker jih uporabljamo (zlo pogosto) v izpisu
*/
private static $_select_sql_grid = array();
static function select_sql_grid ($spr_id) {
if ( isset(self::$_select_sql_grid[$spr_id]) ) {
// resetiramo pointer in vrnemo ke�iran query
if (mysqli_num_rows(self::$_select_sql_grid[$spr_id]))
mysqli_data_seek(self::$_select_sql_grid[$spr_id], 0);
return self::$_select_sql_grid[$spr_id];
}
else {
self::$_select_sql_grid[$spr_id] = sisplet_query("SELECT * FROM srv_grid WHERE spr_id='".$spr_id."' ORDER BY vrstni_red");
return self::$_select_sql_grid[$spr_id];
}
}
/**
* vrne URL naslov ankete (lahko je lep :) )
*
*/
static private $surveyLink = array();
static function getSurveyLink ($anketa = false, $uporabnost = true) {
global $site_url;
if ($anketa == false)
$anketa = self::$surveyId;
$anketa_string = self::getSurveyHash();
if ( ! isset( self::$surveyLink[$anketa_string] ) ) {
$sqll = sisplet_query("SELECT link FROM srv_nice_links WHERE ank_id = '".$anketa."' ORDER BY id ASC LIMIT 1");
if (mysqli_num_rows($sqll) > 0) {
$rowl = mysqli_fetch_array($sqll);
$link = $site_url . $rowl['link'] ;
}
else {
if (self::checkSurveyModule('uporabnost') && $uporabnost == true) // na redirectih pa v form action ne sme it na uporabnost (ker se odpira znotraj frama)
$link = $site_url.'main/survey/uporabnost.php?anketa=' . $anketa_string;
else
$link = $site_url.'a/' . $anketa_string ;
}
self::$surveyLink[$anketa_string] = $link;
}
return self::$surveyLink[$anketa_string];
}
static function getRawSurveyLink ($uporabnost = true) {
global $site_url;
$anketa_string = self::getSurveyHash();
if (self::checkSurveyModule('uporabnost') && $uporabnost == true) // na redirectih pa v form action ne sme it na uporabnost (ker se odpira znotraj frama)
return $site_url.'main/survey/uporabnost.php?anketa=' . $anketa_string;
else
return $site_url.'a/' . $anketa_string ;
}
static function getRespondentLanguage() {
global $lang;
$lang_resp = SurveyInfo::getSurveyColumn('lang_resp');
if ($lang['id'] <> $lang_resp && $lang_resp > 0) {
$lang_old= $lang;
$file = dirname(__FILE__).'/../../../lang/'.$lang_resp.'.php';
if (file_exists($file)) {
include($file);
$_lang_name = $lang['language'];
$lang = $lang_old;
}
} else {
$_lang_name = $lang['language'];
}
$p = new Prevajanje(self::$surveyId);
$arr = $p->get_all_translation_langs();
$dodatni = '';
foreach ($arr AS $l) {
if ($dodatni != '') $dodatni .= ', ';
$dodatni .= $l;
}
if ($dodatni != '') $_lang_name .= ' ('.$dodatni.')';
return $_lang_name;
}
/**
* Polovimo vse module, ki so vklopljeni na anketi
*/
public static function getSurveyModules($ime = null) {
global $global_user_id;
if (!self::$surveyModules) {
$modules = array();
$userAccess = UserAccess::getInstance($global_user_id);
$sql = sisplet_query("SELECT modul, vrednost FROM srv_anketa_module WHERE ank_id='".self::getSurveyId()."'");
while($row = mysqli_fetch_array($sql)){
$module_availible = true;
// Preverimo, ce je modul omogocen v placljivem paketu
switch($row['modul']){
case 'uporabnost':
if(!$userAccess->checkUserAccess($what='uporabnost'))
$module_availible = false;
break;
case 'quiz':
if(!$userAccess->checkUserAccess($what='kviz'))
$module_availible = false;
break;
case 'voting':
if(!$userAccess->checkUserAccess($what='voting'))
$module_availible = false;
break;
case 'social_network':
if(!$userAccess->checkUserAccess($what='social_network'))
$module_availible = false;
break;
case 'slideshow':
if(!$userAccess->checkUserAccess($what='slideshow'))
$module_availible = false;
break;
case 'phone':
if(!$userAccess->checkUserAccess($what='telephone'))
$module_availible = false;
break;
case 'chat':
if(!$userAccess->checkUserAccess($what='chat'))
$module_availible = false;
break;
case 'panel':
if(!$userAccess->checkUserAccess($what='panel'))
$module_availible = false;
break;
}
// Ce je modul na voljo v paketu, ga dodamo v array
if($module_availible)
$modules[$row['modul']] = $row['vrednost'];
}
self::$surveyModules = $modules;
}
if(!is_null($ime) && isset(self::$surveyModules[$ime]))
return self::$surveyModules[$ime];
elseif(!is_null($ime) && sizeof(self::$surveyModules) == 0)
return 0;
else
return self::$surveyModules;
}
/**
* Preverimo, ce je specificen modul vklopljen na anketi
*/
public static function checkSurveyModule($module, $anketa_id = null) {
global $global_user_id;
if(is_null($anketa_id))
$anketa_id = self::getSurveyId();
if($anketa_id > 0 && $module != ''){
// Preverimo, ce je modul omogocen v placljivem paketu
$userAccess = UserAccess::getInstance($global_user_id);
switch($module){
case 'uporabnost':
if(!$userAccess->checkUserAccess($what='uporabnost'))
return false;
break;
case 'quiz':
if(!$userAccess->checkUserAccess($what='kviz'))
return false;
break;
case 'voting':
if(!$userAccess->checkUserAccess($what='voting'))
return false;
break;
case 'social_network':
if(!$userAccess->checkUserAccess($what='social_network'))
return false;
break;
case 'slideshow':
if(!$userAccess->checkUserAccess($what='slideshow'))
return false;
break;
case 'phone':
if(!$userAccess->checkUserAccess($what='telephone'))
return false;
break;
case 'chat':
if(!$userAccess->checkUserAccess($what='chat'))
return false;
break;
case 'panel':
if(!$userAccess->checkUserAccess($what='panel'))
return false;
break;
}
if (!self::$surveyModules) {
$sql = sisplet_query("SELECT EXISTS (SELECT 1 FROM srv_anketa_module WHERE ank_id='".$anketa_id."' AND modul='".$module."')");
$row = mysqli_fetch_array($sql);
if($row[0] > 0)
return true;
else
return false;
}
else{
if(isset(self::$surveyModules[$module]) && self::$surveyModules[$module] > 0)
return true;
else
return false;
}
}
else
return false;
}
// Vrnemo pripeto ime tabele s podatki ce gre za arhivsko ali aktivno anketo (_active, archive1, archive2...)
public static function getSurveyArchiveDBString() {
$db_table = self::getSurveyColumn('db_table');
switch($db_table){
// Arhivska 1
case '0':
$db_table_string = '_archive1';
break;
// Arhivska 2
case '2':
$db_table_string = '_archive2';
break;
// Arhivska 3
case '3':
$db_table_string = '_archive3';
break;
// Aktivna anketa
case '1':
default:
$db_table_string = '_active';
break;
}
return $db_table_string;
}
// Preverimo, ce je anketa ze potekla oz. bi se morala avtomatsko aktivirati
public static function checkSurveyActive(){
$anketa = self::$surveyId;
$active = self::getSurveyActive();
$starts = self::getSurveyStartsDate();
$expire = self::getSurveyExpireDate();
$currentDate = new DateTime();
$startDateTime = new DateTime($starts . ' 00:00:00');
$endDateTime = new DateTime($expire . ' 23:59:59');
// Anketa je aktivna - pogledamo, ce jo moramo deaktivirati
if($active == '1' && ($currentDate < $startDateTime || $currentDate > $endDateTime)){
// pretecena anketa, kontroliramo datum na: starts in expire
sisplet_query("UPDATE srv_anketa SET active='0' WHERE id='".$anketa."'");
SurveyInfo:: getInstance()->SurveyInit($anketa);
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
$active = '0';
}
// Anketa ni aktivna - pogledamo, ce jo moramo aktivirati
/*elseif($active == '0' && $currentDate >= $startDateTime && $currentDate <= $endDateTime){
// neaktivna anketa, kontroliramo datum na: starts in expire
sisplet_query("UPDATE srv_anketa SET active='1' WHERE id='".$anketa."'");
SurveyInfo:: getInstance()->SurveyInit($anketa);
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
$active = '1';
}*/
return $active;
}
}
?>
