diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyInfo.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyInfo.php | 851 |
1 files changed, 851 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyInfo.php b/admin/survey/classes/class.SurveyInfo.php new file mode 100644 index 0000000..5e24766 --- /dev/null +++ b/admin/survey/classes/class.SurveyInfo.php @@ -0,0 +1,851 @@ +<?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() {}
+
+ final 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[$key];
+ }
+
+ static function getSurveyRow () {
+ if (!self::$rowSurveyInit) {
+ $querySurveyInit = sisplet_query("SELECT * FROM srv_anketa WHERE id = '".self::$surveyId."'");
+ self::$rowSurveyInit = mysqli_fetch_assoc($querySurveyInit);
+ }
+
+ 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 getSurveyTitle() { return strip_tags(self::getSurveyColumn('naslov')); }
+ static function getSurveyAkronim() { return strip_tags(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(self::getSurveyColumn('introduction')); }
+ static function getSurveyConcl() { return strip_tags(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() { $firstDateTime = explode(" ", self::getFirstLast('frst')); $tmpDate = explode(':',$firstDateTime[1]); return $tmpDate[0].":".$tmpDate[1].":".$tmpDate[2]; }
+ static function getSurveyLastEntryTime() { $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 vse datume aktivnosti ankete
+ *
+ * @return unknown_type
+ */
+ static function getSurveyActivity() {
+ $activity = array();
+ if ( self::getSurveyColumn('active') == 1 ) {
+ $_starts = self::getSurveyColumn('starts');
+ $_expire = self::getSurveyColumn('expire');
+
+ // izberemo samo unikatne zapise ki niso enaki trenutni aktivnosti
+ $str = "SELECT DISTINCT starts, expire FROM srv_activity WHERE not(starts = '".$_starts."' AND expire = '".$_expire."') AND sid = '".self::getSurveyId()."'";
+ $qry = sisplet_query($str);
+ while ($row = mysqli_fetch_assoc($qry)) {
+ $activity[] = array('starts'=>$row['starts'],'expire'=>$row['expire']);
+ }
+ // dodamo trenutno nastavljeno aktivnost
+ $activity[] = array('starts'=>$_starts,'expire'=>$_expire);
+
+ } else {
+ // anketa ni aktivna, preberemo samo iz tabele aktivnosti
+ $str = "SELECT DISTINCT starts, expire FROM srv_activity WHERE sid = '".self::getSurveyId()."'";
+ $qry = sisplet_query($str);
+ while ($row = mysqli_fetch_assoc($qry)) {
+ $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 ( 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'];
+ switch ( $rowVprasanje['tip'] ) { // v odvisnosti od tipa vprašanja pohandlamo podatke
+ 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*
+// $cnt++; // za sam header
+ $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;
+ case 26: // lokacija
+ 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;
+ case 27: // heatmap
+ $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;
+
+ // V get-u ni vec id ankete ampak string (zaradi zascite, da en more kdorkoli dostopati do vseh anket)
+ $anketa_string = Common::encryptAnketaID($anketa);
+
+ 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 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(self::$surveyModules[$module] > 0)
+ return true;
+ else
+ return false;
+ }
+ }
+ else
+ return false;
+ }
+}
+?>
\ No newline at end of file |