diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyZoom.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyZoom.php | 915 |
1 files changed, 915 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyZoom.php b/admin/survey/classes/class.SurveyZoom.php new file mode 100644 index 0000000..593a1ee --- /dev/null +++ b/admin/survey/classes/class.SurveyZoom.php @@ -0,0 +1,915 @@ +<?php
+define('ZOOM_DEFAULT_PROFILE', 0);
+class SurveyZoom
+{
+ static private $sid; # id ankete
+ static private $uid = null; # id userja
+ static private $db_table; # katere tabele uporabljamo
+ static private $enabled = false; # ali imamo vklopljen zoom
+ static private $profiles = array(); # profili zooma
+ static private $currentProfileId = 0; # trenutno profil
+ static private $extended = true; # ali imamo razširjen prikaz (privzeto)
+ static private $showVariables = true; # ali prikazujemo okno z variablami
+
+ function __construct($sid) {
+ global $global_user_id;
+
+ self::$sid = $sid;
+ self::$uid = $global_user_id;
+
+ session_start();
+ if (isset($_SESSION['surveyZoom'][self::$sid])) {
+ if (isset($_SESSION['surveyZoom'][self::$sid]['extended'])
+ && $_SESSION['surveyZoom'][self::$sid]['extended'] == false) {
+ self::$extended = false;
+ } else {
+ self::$extended = true;
+ }
+
+ if (isset($_SESSION['surveyZoom'][self::$sid]['showVariables'])
+ && $_SESSION['surveyZoom'][self::$sid]['showVariables'] == false) {
+ self::$showVariables = false;
+ } else {
+ self::$showVariables = true;
+ }
+ } else {
+ self::$extended = true;
+ self::$showVariables = true;
+ }
+
+ self::getProfiles();
+ }
+
+ function getProfiles() {
+ global $lang;
+
+ # inicializiramo datoteko z nastavitvami
+ SurveyUserSetting :: getInstance()->Init(self::$sid, self::$uid);
+
+ # polovimo profile iz baze
+ $stringSelect = "SELECT * FROM srv_zoom_profiles WHERE sid='" . self::$sid . "' AND uid='" . self::$uid . "'";
+ $querySelect = sisplet_query($stringSelect);
+
+ #prvi profil je privezti - brez zooma
+ self::$profiles[0] = array('id'=>0, 'name'=>$lang['srv_default_without']);
+
+ # če obstajajo profili iz baze jih dodamo
+ if (mysqli_num_rows($querySelect)) {
+ #najprej dodamo sejo če obstaja
+ session_start();
+ if (isset($_SESSION['surveyZoom'][self::$sid])) {
+ self::$profiles[-1] = $_SESSION['surveyZoom'][self::$sid];
+ }
+
+ while ( $rowSelect = mysqli_fetch_assoc($querySelect) ) {
+ self::$profiles[$rowSelect['id']] = $rowSelect;
+ self::$profiles[$rowSelect['id']]['vars'] = unserialize($rowSelect['vars']);
+ self::$profiles[$rowSelect['id']]['conditions'] = unserialize($rowSelect['conditions']);
+ }
+ } else {
+ # v bazi ni profilov
+
+ #nato dodamo sejo če obstaja
+ session_start();
+ if (isset($_SESSION['surveyZoom'][self::$sid])) {
+ self::$profiles[-1] = $_SESSION['surveyZoom'][self::$sid];
+ }
+
+ }
+
+
+ # preverimo ali ima uporabnik nastavljen privzet profil
+ $dzp = SurveyUserSetting :: getInstance()->getSettings('default_zoom_profile');
+ if ($dzp == -1 || $dzp > 0 ) {
+ self::$currentProfileId = $dzp;
+ } else {
+ self::$currentProfileId = 0;
+ self::SetDefaultProfile(0);
+ }
+
+
+
+ # če uporabnik nima profilov, in obstajajo demografske spremenljivke naredimo nov DM profil
+ if (count(self::$profiles) == 1 ) { # 1profil je vedno (privzeti)
+ $all_spr = Cache::cache_all_srv_spremenljivka(self::$sid);
+ $variables_to_add = array();
+ if (is_countable($all_spr) && count($all_spr) > 0) {
+ foreach ($all_spr AS $id => $spr) {
+ if (in_array($spr['variable'], array('XSPOL','XIZOBRAZBA','XSTAROST','DMspol','DMizobrazba','DMstarost'))
+ || Demografija::getInstance()->isDemografija($spr['variable'])) {
+ $variables_to_add[] = $id;
+ }
+ }
+ }
+
+ if (count ($variables_to_add) > 0 ) {
+ # dodamo profil in ga izberemo za privzetega
+
+ $_SESSION['surveyZoom'][self::$sid] = array('id'=>-1, 'name'=>$lang['srv_zoom_profile_demografija'],'vars'=>$variables_to_add, 'conditions'=> '', 'if_id'=>0);
+ self::$profiles[-1] = array('id'=>$pid, 'sid'=>self::$sid, 'uid'=>self::$uid, 'name'=>$lang['srv_zoom_profile_demografija'], 'vars'=>$variables_to_add,'conditions'=>'');
+ if (!isset($_POST['pid']) && !((int)$_POST['pid'] > 0)) {
+ #self::SetDefaultProfile(-1);
+ #self::$currentProfileId = -1;
+ }
+ }
+ }
+
+ }
+
+ static function DisplayLink($hideAdvanced = true) {
+ global $lang;
+
+ $css = (self::$currentProfileId == 0 ? ' gray' : '');
+
+ if ($hideAdvanced == false || self::$currentProfileId != 0) {
+ echo '<li class="space"> </li>';
+ echo '<li>';
+ echo '<span class="as_link'.$css.'" id="link_zoom" title="'.$lang['srv_zoom_setting'].'" onclick="showZoomSettings();">'.$lang['srv_zoom_setting'].'</span>';
+ echo '</li>';
+
+ }
+ }
+
+ function ajax() {
+ switch ($_GET['a']) {
+ case 'showProfile':
+ self::showProfile();
+ break;
+ case 'changeProfile':
+ self::changeProfile($_POST['pid']);
+ break;
+ case 'saveProfile':
+ self::saveProfile();
+ break;
+ case 'deleteProfile':
+ self::deleteProfile($_POST['pid']);
+ break;
+ case 'renameProfile':
+ self::renameProfile();
+ break;
+ case 'changeZoomCheckbox':
+ self::changeZoomCheckbox();
+ break;
+ case 'removeZoomCheckbox':
+ self::removeZoomCheckbox();
+ break;
+ case 'createNewProfile':
+ self::createNewProfile();
+ break;
+ case 'togleExtended':
+ self::togleExtended();
+ break;
+ case 'toggleShowZoomVariables':
+ self::toggleShowZoomVariables();
+ break;
+
+ case 'doZoomFromInspect':
+ self::doZoomFromInspect();
+ break;
+
+ default:
+ print_r("<pre>");
+ print_r($_GET);
+ print_r($_POST);
+ print_r("</pre>");
+ break;
+ }
+ }
+
+ static function getCurentProfileId() { return self::$currentProfileId; }
+ /** Ponastavi id privzetega profila
+ *
+ */
+ static function SetDefaultProfile($pid) {
+ self::$currentProfileId = $pid;
+ $saved = SurveyUserSetting :: getInstance()->saveSettings('default_zoom_profile',$pid);
+ }
+
+ function changeProfile($pid) {
+ $tmp_profiles = self::$profiles;
+ # če profil z pid ne obstaja nastavimo prvega iz baze (ki pa ni demografija)
+ if (!isset($tmp_profiles[$pid]) && count($tmp_profiles) > 0) {
+ if (isset($tmp_profiles[-1]) && (int)$pid != -1) {
+ unset($tmp_profiles[-1]);
+ }
+ if (count($tmp_profiles) > 0){
+ $pid = key(self::$profiles);
+ } else {
+ $pid = 0;
+ }
+
+ }
+ self::SetDefaultProfile($pid);
+ }
+
+ function showProfile() {
+ global $lang;
+
+ echo '<div class="popup_close"><a href="#" onClick="zoomProfileAction(\'cancel\'); return false;">✕</a></div>';
+
+ // Naslov
+ echo '<h2>'.$lang['srv_zoom_setting'].'</h2>';
+
+ if ($current_pid == null) {
+ $current_pid = self::getCurentProfileId();
+ }
+
+ $currentFilterProfile = self::$profiles[$current_pid];
+ if ( self::$currentProfileId != ZOOM_DEFAULT_PROFILE ) {
+ echo '<div id="not_default_setting">';
+ echo $lang['srv_not_default_setting'];
+ echo '</div><br class="clr displayNone">';
+ }
+
+ echo '<div id="zoom_profiles_left">';
+ echo '<span id="zoom_profiles_holder">';
+ # zlistamo vse profile
+ echo '<span id="zoom_profiles" class="select">';
+ if (count(self::$profiles)) {
+ foreach (self::$profiles as $id => $profile) {
+
+ echo '<div class="option' . ($current_pid == $id ? ' active' : '') . '" id="zoom_profile_' . $id . '" value="'.$id.'" '.($current_pid == $id ? '' : ' onclick="zoomChangeProfile(\''.$id.'\')"').'>';
+
+ echo $profile['name'];
+
+ if($current_pid == $id){
+ # sistemskega ne moremo izbrisati
+ if ($current_pid != 0) {
+ echo '<a href="#" title="'.$lang['srv_delete_profile'].'" onclick="zoomProfileAction(\'showDelete\'); return false;"><span class="faicon delete_circle icon-orange_link floatRight" style="margin-top:1px;"></span></a>'."\n";
+ }
+
+ # sistemskega in seje ne moremo preimenovati
+ if ($current_pid > 0) {
+ echo '<a href="#" title="'.$lang['srv_rename_profile'].'" onclick="zoomProfileAction(\'showRename\'); return false;"><span class="faicon edit icon-as_link floatRight spaceRight"></span></a>'."\n";
+ }
+ }
+
+ echo '</div>';
+ }
+ }
+ echo '</span>'; # zoom_profilea
+ echo '</span>'; # zoom_profiles_holder
+
+ echo '</div>'; # zoom_profiles_left
+
+
+ echo '<div id="zoom_profiles_right">'."\n";
+ if ($current_pid == 0) {
+ echo '<div id="zoom_note">';
+ echo $lang['srv_change_default_profile'];
+ echo '</div>'; // zoom_profile_note
+ echo '<br class="clr" />'."\n";
+ }
+
+ echo '<div id="zoom_content">';
+ self::DisplayProfileData($current_pid);
+ echo '</div>'; // zoom_profile_content
+
+ echo '</div>'; // zoom_profile_right
+
+
+ echo '<div id="zoom_button_holder">'."\n";
+ if ((int)$current_pid <= 0 ) {
+ echo '<span class="floatRight" title="'.$lang['srv_run_as_session_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="zoomProfileAction(\'run_session_profile\'); return false;"><span>'.$lang['srv_run_as_session_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_create_new_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'newName\'); return false;"><span>'.$lang['srv_create_new_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_close_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'cancel\'); return false;"><span>'.$lang['srv_close_profile'] . '</span></a></div></span>';
+ } else {
+ echo '<span class="floatRight" title="'.$lang['srv_save_run_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="zoomProfileAction(\'runProfile\'); return false;"><span>'.$lang['srv_run_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_run_as_session_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'run_session_profile\'); return false;"><span>'.$lang['srv_run_as_session_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_create_new_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'newName\'); return false;"><span>'.$lang['srv_create_new_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_close_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'cancel\'); return false;"><span>'.$lang['srv_close_profile'] . '</span></a></div></span>';
+
+ }
+ echo '</div>'."\n"; // zoom_button_holder
+
+
+ // cover Div
+ //echo '<div id="zoom_cover_div"></div>'."\n";
+
+ // div za kreacijo novega
+ echo '<div id="newProfileDiv">'.$lang['srv_missing_profile_name'].': '."\n";
+ echo '<input id="newProfileName" name="newProfileName" type="text" value="" size="45" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="zoomProfileAction(\'newCreate\'); return false;"><span>'.$lang['srv_analiza_arhiviraj_save'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'newCancel\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+
+ // div za preimenovanje
+ echo '<div id="renameProfileDiv">'.$lang['srv_missing_profile_name'].': '."\n";
+ echo '<input id="renameProfileName" name="renameProfileName" type="text" value="' . $currentFilterProfile['name'] . '" size="45" />'."\n";
+ echo '<input id="renameProfileId" type="hidden" value="' . $currentFilterProfile['id'] . '" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="zoomProfileAction(\'doRename\'); return false;"><span>'.$lang['srv_rename_profile_yes'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'cancelRename\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+
+ // div za brisanje
+ echo '<div id="deleteProfileDiv">'.$lang['srv_missing_profile_delete_confirm'].': <b>' . $currentFilterProfile['name'] . '</b>?'."\n";
+ echo '<input id="deleteProfileId" type="hidden" value="' . $currentFilterProfile['id'] . '" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="zoomProfileAction(\'doDelete\'); return false;"><span>'.$lang['srv_delete_profile_yes'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="zoomProfileAction(\'cancelDelete\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+ }
+
+ /** Funkcija prikaze osnovnih informacije profila
+ *
+ */
+ function DisplayProfileData($current_pid=null) {
+ global $lang;
+ if (isset($_POST['error'])) {
+ echo '<span class="red">* '.$lang[$_POST['error']].'</span><br/>';
+ }
+ # podatki profila
+ if ($current_pid == null) {
+ $current_pid = self::$currentProfileId;
+ }
+ $cp = self::$profiles[$current_pid];
+ $vars = $cp['vars'];
+
+ $all_spr = Cache::cache_all_srv_spremenljivka(self::$sid,true);
+
+ echo '<span>'.$lang['srv_zoom_choose'].'</span>';
+
+ if (count($all_spr) > 0)
+ foreach ($all_spr AS $id => $spremenljivka) {
+ if ( in_array($spremenljivka['tip'], array(1,2,3) ) ) {
+ echo '<div class="zoom_var">';
+
+ echo '<label>';
+ echo '<input name="zoom_vars" id="zoom_var_'.$spremenljivka['id'].'" value="'.$spremenljivka['id'].'" type="checkbox"'
+ .(is_array($vars) && in_array($spremenljivka['id'],$vars) ? ' checked' : '').'>';
+ echo strip_tags($spremenljivka['variable']).' - '.strip_tags($spremenljivka['naslov']).'</label>';
+
+ echo '</div>';
+ } else if ( in_array($spremenljivka['tip'], array(6,16,17))) {
+ echo '<div class="zoom_var">';
+
+ # izpišemo glavno spremenljivko
+ echo '<label style="margin-left:20px;">';
+ echo strip_tags($spremenljivka['variable']).' - '.strip_tags($spremenljivka['naslov']).'</label>';
+
+ # izpišemo gride (zamaknjeno)
+ $sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id='$id' AND other = 0 ORDER BY vrstni_red");
+ while ($row = mysqli_fetch_assoc($sql)) {
+ echo '<label style="margin-left:25px; margin-top:5px;">';
+ echo '<input name="zoom_vars" id="zoom_var_'.$spremenljivka['id'].'_'.$row['id'].'" value="'.$spremenljivka['id'].'_'.$row['id'].'" type="checkbox"'
+ .(is_array($vars) && in_array($spremenljivka['id'].'_'.$row['id'],$vars) ? ' checked' : '').'>';
+ echo strip_tags($row['variable']).' - '.strip_tags($row['naslov']).'</label>';
+ }
+ echo '</div>';
+ }
+ }
+
+ echo '<br class="clr"/>';
+ }
+
+ /* Shranimo izbrane variable in resetiramo if na 0, ter pobrišemo morebitni pogoj če obstaja
+ *
+ */
+ static function SaveProfile() {
+ global $lang, $global_user_id;
+ $pid = isset($_POST['pid']) && (int)$_POST['pid'] > 0
+ ? (int)$_POST['pid'] # normaln profil
+ : -1; #seja
+ $profil_data = self::$profiles[$pid];
+
+ # preverimo ali je star profil imel kak if če ja ga pobrišemo
+ if ((int)$profil_data['if_id'] > 0 ) {
+ if ((int)$if_id > 0) {
+ $delStr = "DELETE FROM srv_if WHERE id = '$if_id'";
+ sisplet_query($delStr);
+ $delStr = "DELETE FROM srv_condition WHERE if_id = '$if_id'";
+ sisplet_query($delStr);
+ sisplet_query("COMMIT");
+ }
+ }
+
+ # ali delamo preko seje ali baze
+ if ($pid > 0) {
+ # shranimo v bazo
+ $vars = serialize(isset($_POST['vars']) ? $_POST['vars'] : '');
+ $updateString = "UPDATE srv_zoom_profiles SET vars = '$vars', conditions='', if_id=0 WHERE id='$pid'";
+ $updatequery = sisplet_query($updateString);
+ sisplet_query("COMMIT");
+
+ } else {
+ session_start();
+ # shranjujenmo v sejo
+ $pid=-1;
+ #LANG
+ $_SESSION['surveyZoom'][self::$sid] = array('id'=>-1,'vars'=>$_POST['vars'], 'conditions'=> '', 'if_id'=>0);
+ if (!isset($_SESSION['surveyZoom'][self::$sid]['name']) || $_SESSION['surveyZoom'][self::$sid]['name'] == '') {
+ $_SESSION['surveyZoom'][self::$sid]['name'] = $lang['srv_zoom_profile_session'];
+ }
+
+ session_commit();
+ }
+ self::SetDefaultProfile($pid);
+ }
+
+ /** shranimo nov profil
+ *
+ * Enter description here ...
+ */
+ function createNewProfile() {
+ global $lang,$global_user_id;
+ $return = array('newId' => -1, 'error'=>'1','msg'=> 'Profila ni bilo mogoče kreirati!' );
+
+ #LANG
+ $name = isset($_POST['name']) ? $_POST['name'] : 'Nov profil';
+ $vars = serialize(isset($_POST['vars']) ? $_POST['vars'] : '');
+
+ $iStr = "INSERT INTO srv_zoom_profiles (sid, uid, name,vars,conditions) VALUES ('".self::$sid."', '".self::$uid."', '$name','$vars','')";
+ $sql = sisplet_query($iStr);
+ $return['msg'] =$iStr;
+ if (!$sql) {
+ $return['error'] = '1';
+ $return['msg'] = 'Pri kreiranju profila so bile težave!';
+ } else {
+ $pid = mysqli_insert_id($GLOBALS['connect_db']);
+ sisplet_query("COMMIT");
+ $return['newId'] = $pid;
+ self::getProfiles();
+ self::SetDefaultProfile($pid);
+ $return['error'] = '0';
+ $return['msg'] = 'Profil je bil uspešno kreiran:'.$pid;
+ }
+ echo json_encode($return);
+ exit;
+
+ }
+
+ static function deleteProfile($pid = 0) {
+
+ #pobrišemo pogoj če obstaha
+ $if_id = self::$profiles[$pid]['if_id'];
+ if ((int)$if_id > 0) {
+ $stringUpdate = "DELETE FROM srv_if WHERE id = ".$if_id;
+ $updated = sisplet_query($stringUpdate);
+ sisplet_query("COMMIT");
+ }
+
+ if (isset($pid) && $pid == -1) {
+ session_start();
+ unset($_SESSION['surveyZoom'][self::$sid]);
+ session_commit();
+ } else if (isset($pid) && $pid > 0) {
+ // Izbrišemo profil in nastavimo privzetega
+ $stringUpdate = "DELETE FROM srv_zoom_profiles WHERE id = ".$pid;
+ $updated = sisplet_query($stringUpdate);
+ sisplet_query("COMMIT");
+ }
+ # nastavimo privzet profil
+ self::getProfiles();
+ self::SetDefaultProfile('0');
+ }
+
+ static function displayZoomConditions($showDiv = true) {
+ global $lang;
+
+ $vars = self::$profiles[self::$currentProfileId]['vars'];
+
+ $all_spr = Cache::cache_all_srv_spremenljivka(self::$sid);
+
+ if (is_countable($vars) && count($vars) > 0) {
+ $conditions = self::$profiles[self::$currentProfileId]['conditions'];
+ if ($showDiv == true) {
+ echo '<div id="div_zoom_condition" '.(self::$showVariables == false ? ' style="display:none"' : '').'>';
+ }
+ echo '<span class="" style="display:inline-block; width:100%">';
+ echo '<b>'.$lang['srv_zoom'].'</b>';
+ echo ' "'.self::$profiles[self::$currentProfileId]['name'].'"';
+ echo '<span class="as_link spaceLeft" onclick="showZoomSettings();">'.$lang['srv_profile_edit'].'</span>';
+ echo '<span class="as_link spaceLeft" id="span_zoom_condition_remove" onclick="removeZoomProfile();">'.$lang['srv_profile_remove'].'</span>';
+
+ # dodamo še +/- za razpiranje variabel
+ echo '<span class="floatRight spaceLeft">';
+ echo '<span id="zoomSpritesMinus" class="'.(self::$extended == true ? '' : ' displayNone').'">';
+ echo '<span class="pointer faicon icon-blue minus" onClick="toggleAllZoom(\'1\')" > </span>';
+ echo '</span>';
+ echo '<span id="zoomSpritesPlus" class="'.(self::$extended == true ? ' displayNone' : '').'">';
+ echo '<span class="pointer faicon icon-blue plus" onClick="toggleAllZoom(\'0\')"> </span>';
+ echo '</span>';
+ echo '</span>';
+
+ echo '</span>';
+ echo '<br/>';
+ echo '<span class="floatLeft'.( self::$extended == false ? ' displayNone': '').'" >';
+ echo '<ul >';
+ IF (count($vars) > 0 && is_array($vars)) {
+ foreach ($vars AS $_spr) {
+ $_spr_tmp = explode('_',$_spr);
+
+ $spr = $_spr_tmp[0];
+ $vre = $_spr_tmp[1];
+ $_conditions = $conditions[$spr];
+
+ if (isset($vre) && $vre > 0) {
+ $sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE id='$vre'");
+ $row = mysqli_fetch_assoc($sql);
+ } else {
+ $row = Cache::srv_spremenljivka($spr);
+ }
+ echo '<li id="zoom_var_condition_'.$_spr.'">';
+ echo '<div class="zoom_short_text" title="('.strip_tags($row['variable']).') '.strip_tags($row['naslov']).'">';
+ echo '(<b>'.strip_tags($row['variable']).'</b>) ';
+ echo strip_tags($row['naslov']);
+ echo '</div>';
+ echo '<div class="zoom_short_text">';
+ #echo '<div class="zoom_short_text'.( self::$extended == false ? ' displayNone': '').'">';
+
+ if (isset($vre) && $vre > 0) {
+ # imamo multigride polovimo grids
+ $sql = sisplet_query("SELECT id, naslov, variable FROM srv_grid WHERE spr_id='$spr' AND other = 0 ORDER BY vrstni_red");
+ while ($row = mysqli_fetch_assoc($sql)) {
+ echo '<label title="'.strip_tags($row['variable']).' - '.strip_tags($row['naslov']).'">';
+ echo '<input name="zoom_cond_'.$spr.'[]" id="zoom_cond_'.$spr.'_'.$vre.'_'.$row['id'].'" value="'.$spr.'_'.$vre.'_'.$row['id'].'" type="checkbox" onchange="changeZoomCheckbox(); return false;"';
+ if (is_array($_conditions) && isset($_conditions[(int)$vre])) {
+ if (in_array($row['id'],$_conditions[(int)$vre])) {
+ echo 'checked="checekd"';
+ }
+ }
+ echo ' autocomplete="off">';
+
+ echo strip_tags($row['variable']).' - '.strip_tags($row['naslov']).'</label>';
+ echo "<br>";
+ }
+
+ } else {
+ # imamo navaden polovimo vrednosti
+ $sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id='$spr' AND other = 0 ORDER BY vrstni_red");
+ while ($row = mysqli_fetch_assoc($sql)) {
+ echo '<label title="'.strip_tags($row['variable']).' - '.strip_tags($row['naslov']).'">';
+ echo '<input neme="zoom_cond_'.$spr.'[]" id="zoom_cond_'.$spr.'_'.$vre.'_'.$row['id'].'" value="'.$spr.'_'.$vre.'_'.$row['id'].'" type="checkbox" onchange="changeZoomCheckbox(); return false;"';
+ if (is_array($_conditions) && isset($_conditions[(int)$vre])) {
+ if (in_array($row['id'],$_conditions[(int)$vre])) {
+ echo 'checked="checekd"';
+ }
+ }
+ echo '>';
+ echo strip_tags($row['variable']).' - '.strip_tags($row['naslov']).'</label>';
+ echo "<br>";
+ }
+ }
+ echo '</div>';
+ echo '</li>';
+ }
+ }
+
+ echo '</ul>';
+ echo '</span>';
+
+ if ($showDiv == true) {
+ echo '</div>';
+ }
+
+ }
+ }
+
+ function removeZoomCheckbox() {
+ #odstranimo if
+ $if_id=(int)self::$profiles[self::$currentProfileId]['if_id'];
+ if ( $if_id> 0)
+ {
+ if(self::$currentProfileId == -1)
+ {
+ session_start();
+ $_SESSION['surveyZoom'][self::$sid]['if_id'] = 0;
+ $_SESSION['surveyZoom'][self::$sid]['conditions'] = null;
+ }
+ else
+ {
+ $update = "UPDATE srv_zoom_profiles SET if_id = 0, conditions='' where id='".self::$currentProfileId."'";
+ $sql = sisplet_query($update);
+ sisplet_query("COMMIT");
+ }
+
+ if ((int)$if_id > 0)
+ {
+ $delStr = "DELETE FROM srv_if WHERE id = '$if_id'";
+ sisplet_query($delStr);
+ sisplet_query("COMMIT");
+ }
+ }
+ }
+
+ function changeZoomCheckbox()
+ {
+ if (isset($_POST['vars']) && is_array($_POST['vars']) && count($_POST['vars']) > 0 )
+ {
+ $spr_groups = array();
+ foreach ($_POST['vars'] AS $tmpvar) {
+ $_var = explode('_',$tmpvar);
+ # med posameznimi sub grupami imamo OR pogoje med grupami pa AND
+ #zgrupiramo po spremenljivkah in grupah
+ if (isset($_var[1]) && $_var[1]!=null) {
+
+ $spr_groups[$_var[0]][$_var[1]][] = $_var[2];
+ } else {
+ $spr_groups[$_var[0]][0][] = $_var[2];
+ }
+ }
+ self::createZoomCondition($spr_groups);
+ # še shranimo checkboxe
+ session_start();
+ #če seja ne obstaja nastavimo privzet porfil na 0 - default
+ if(self::$currentProfileId == -1) {
+ session_start();
+ $_SESSION['surveyZoom'][self::$sid]['conditions'] = $spr_groups;
+ } else {
+ $conditions = serialize($spr_groups);
+ $update = "UPDATE srv_zoom_profiles SET conditions = '$conditions' where id='".self::$currentProfileId."'";
+ $sql = sisplet_query($update);
+ sisplet_query("COMMIT");
+ }
+ } else {
+ #odstranimo if
+ $if_id=(int)self::$profiles[self::$currentProfileId]['if_id'];
+ if ( $if_id> 0) {
+ if(self::$currentProfileId == -1) {
+ session_start();
+ $_SESSION['surveyZoom'][self::$sid]['if_id'] = 0;
+ } else {
+ $update = "UPDATE srv_zoom_profiles SET if_id = 0, conditions='' where id='".self::$currentProfileId."'";
+ $sql = sisplet_query($update);
+ sisplet_query("COMMIT");
+ }
+ if ((int)$if_id > 0) {
+ $delStr = "DELETE FROM srv_if WHERE id = '$if_id'";
+ sisplet_query($delStr);
+ sisplet_query("COMMIT");
+ }
+ }
+
+ }
+ SurveyAnalysis::Init(self::$sid);
+ SurveyAnalysis::Display();
+
+ }
+
+ function createZoomCondition($spr_groups) {
+ global $lang,$global_user_id;
+
+ #najprej skreiramo nov if če še ne obstaja
+ if ((int)self::$profiles[self::$currentProfileId]['if_id'] > 0) {
+ $if_id = (int)self::$profiles[self::$currentProfileId]['if_id'];
+ # preverimo dejanski obstoj ifa
+ if ((int)$if_id > 0) {
+ $chks1 = "SELECT id FROM srv_if WHERE id='$if_id'";
+ $chkq1 = sisplet_query($chks1);
+ if (mysqli_num_rows($chkq1) == 0) {
+ $if_id = 0;
+ }
+ }
+ }
+
+ if ( (int)$if_id == 0 || $if_id == null) {
+ // if še ne obstaja, skreiramo novga
+ $sql = sisplet_query("INSERT INTO srv_if (id) VALUES ('')");
+ $if_id = mysqli_insert_id($GLOBALS['connect_db']);
+ sisplet_query("COMMIT");
+ }
+
+ if ((int)$if_id > 0) {
+ # updejtamo še zoom profil
+ self::$profiles[self::$currentProfileId]['if_id'] = (int)$if_id;
+ if ((int)self::$currentProfileId > 0 ) {
+ # v bazi
+ $updateString = "UPDATE srv_zoom_profiles SET if_id=".(int)$if_id." WHERE id='".(int)self::$currentProfileId."'";
+ $sql = sisplet_query($updateString);
+ sisplet_query("COMMIT");
+ } else {
+ # v seji
+ session_start();
+ $_SESSION['surveyZoom'][self::$sid]['if_id'] = (int)$if_id;
+ }
+
+
+ #poiščemo katere condition_id-je lahko obdržimo, ostale pobrišemo
+ if (is_array($spr_groups) &&count($spr_groups ) > 0 ) {
+ $spr_vre = array();
+ foreach ($spr_groups AS $spr_id => $spr_group) {
+ $cids = array();
+ foreach($spr_group AS $key => $values) {
+ $cids[] = (int)$key;
+ }
+ # pobrišemo predhodne ife
+ if (count($cids) > 0) {
+ $spr_vre[] = "(spr_id = '$spr_id' AND vre_id IN (".implode(',',$cids)."))";
+ }
+ }
+ $delStr = "DELETE FROM srv_condition WHERE if_id = '$if_id' AND NOT (".implode(' OR ',$spr_vre).")";
+ sisplet_query($delStr);
+ sisplet_query("COMMIT");
+
+ # dodamo pogoje za posamezne skupine spremenljivk
+ $vrstni_red = 1;
+ foreach ($spr_groups AS $spr_id => $spr_group) {
+ $vrstni_red = self::createSubCondition($if_id,$spr_id,$spr_group,$vrstni_red);
+ }
+ } else {
+ $delStr = "DELETE FROM srv_condition WHERE if_id = '$if_id'";
+ sisplet_query($delStr);
+ sisplet_query("COMMIT");
+ }
+ }
+ }
+
+ function createSubCondition($if_id,$spr_id,$spr_group,$vrstni_red) {
+ foreach($spr_group AS $key => $values) {
+ # če imamo vrednosti
+ if ((int)$key == 0) {
+ # preverimo ali že obstaja condition id
+ $sStr = "SELECT id FROM srv_condition WHERE if_id='$if_id' AND spr_id='$spr_id'";
+ $sQry = sisplet_query($sStr);
+ if (mysqli_num_rows($sQry) > 0) {
+ # cond_id že obstaja uporabimo obstoječega
+ $sRow = mysqli_fetch_assoc($sQry);
+ $cond_id = $sRow['id'];
+ } else {
+ #vstavimo nov pogoj
+ $istr = "INSERT INTO srv_condition (if_id, spr_id, vrstni_red) VALUES ('$if_id', '$spr_id', '$vrstni_red')"
+ . " ON DUPLICATE KEY UPDATE spr_id='$spr_id', vrstni_red = '$vrstni_red'";
+ $sql = sisplet_query($istr);
+
+ if (!$sql) {
+ echo '<br>-3 :: '.$istr;
+ echo mysqli_error($GLOBALS['connect_db']);
+ }
+ $cond_id = mysqli_insert_id($GLOBALS['connect_db']);
+ }
+
+ # pobrišemo vrednosti
+ if ($cond_id > 0) {
+ $delStr = "DELETE FROM srv_condition_vre WHERE cond_id = '$cond_id'";
+ sisplet_query($delStr);
+ }
+ foreach ($values AS $value) {
+ if ((int)$value > 0 || (int)$cond_id > 0) {
+ $istr = "INSERT INTO srv_condition_vre (cond_id, vre_id) VALUES ('$cond_id', '$value')";
+ $sql = sisplet_query($istr);
+
+ if (!$sql) {
+ echo '<br>-4 :: '.$istr;
+ echo mysqli_error($GLOBALS['connect_db']);
+ }
+ }
+ }
+ } else {
+ # če imamo grupe
+ # preverimo ali že obstaja condition id
+ $sStr = "SELECT id FROM srv_condition WHERE if_id='$if_id' AND spr_id='$spr_id' AND vre_id='$key'";
+ $sQry = sisplet_query($sStr);
+ if (mysqli_num_rows($sQry) > 0) {
+ # cond_id že obstaja uporabimo obstoječega
+ $sRow = mysqli_fetch_assoc($sQry);
+ $cond_id = $sRow['id'];
+ } else {
+ $istr = "INSERT INTO srv_condition (if_id, spr_id, vre_id, vrstni_red) VALUES ('$if_id', '$spr_id', '$key', '$vrstni_red')"
+ . " ON DUPLICATE KEY UPDATE spr_id='$spr_id', vrstni_red = '$vrstni_red'";
+ $sql = sisplet_query($istr);
+ if (!$sql) {
+ echo '<br>-3 :: '.$istr;
+ echo mysqli_error($GLOBALS['connect_db']);
+ }
+ $cond_id = mysqli_insert_id($GLOBALS['connect_db']);
+ }
+ # pobrišemo gride
+ if ($cond_id > 0) {
+ $delStr = "DELETE FROM srv_condition_grid WHERE cond_id = '$cond_id'";
+ sisplet_query($delStr);
+ }
+
+ foreach ($values AS $value) {
+ if ((int)$value > 0 || (int)$cond_id > 0) {
+ $istr = "INSERT INTO srv_condition_grid (cond_id, grd_id) VALUES ('$cond_id', '".$value."')";
+ $sql = sisplet_query($istr);
+ if (!$sql) {
+ echo '<br>-4 :: '.$istr;
+ echo mysqli_error($GLOBALS['connect_db']);
+ }
+ }
+ }
+
+ }
+ sisplet_query("COMMIT");
+ $vrstni_red++;
+ }
+
+ return $vrstni_red;
+ }
+
+ function togleExtended() {
+ session_start();
+
+ if (isset($_POST['what']) && $_POST['what'] == 1) {
+ $_SESSION['surveyZoom'][self::$sid]['extended'] = false;
+ } else {
+ $_SESSION['surveyZoom'][self::$sid]['extended'] = true;
+ }
+ }
+ function toggleShowZoomVariables() {
+ session_start();
+
+ if (isset($_POST['what']) && $_POST['what'] == 1) {
+ $_SESSION['surveyZoom'][self::$sid]['showVariables'] = false;
+ } else {
+ $_SESSION['surveyZoom'][self::$sid]['showVariables'] = true;
+ }
+ }
+
+ function renameProfile() {
+ $pid = $_POST['pid'];
+ $name = $_POST['name'];
+ if (isset($pid) && $pid > 0 && isset($name) && trim($name) != "") {
+ // popravimo podatek za variables
+ $stringUpdate = "UPDATE srv_zoom_profiles SET name = '".$name."' WHERE id = '".$pid."'";
+ $updated = sisplet_query($stringUpdate);
+ sisplet_query("COMMIT");
+ return $updated;
+ } else {
+ return -1;
+ }
+
+ }
+
+
+
+ static function generateAwkCondition() {
+ global $global_user_id;
+
+ $zoom_if_id = (int)self::$profiles[self::$currentProfileId]['if_id'];
+
+ if ($zoom_if_id > 0 ) {
+ SurveyConditionProfiles :: Init(self::$sid, $global_user_id);
+ return SurveyConditionProfiles:: generateAwkCondition($zoom_if_id);
+ } else {
+ return null;
+ }
+ }
+
+ static function getConditionString() {
+ global $lang;
+
+# $condition_label = self::$profiles[self::$currentProfileId]['condition_label'];
+ ob_start();
+ $b = new Branching(self::$sid );
+ $if_id = (int)self::$profiles[self::$currentProfileId]['if_id'];
+ $b->display_if_label($if_id);
+ #$condition_label = mysqli_escape_string(ob_get_contents());
+ $condition_label = ob_get_contents();
+ ob_end_clean();
+
+ if ( $if_id > 0 && $condition_label != '') {
+ echo '<div id="conditionProfileNote" class="segmenti">';
+ echo '<span class="floatLeft spaceRight">';
+ # dodamo še +/- za razpiranje variabel
+ echo '<span id="zoomSpritesMinus1" class="'.(self::$showVariables == true ? '' : ' displayNone').'">';
+ echo '<span class="pointer faicon icon-blue minus" onClick="toggleShowZoomVariables(\'1\')" > </span>';
+ echo '</span>';
+ echo '<span id="zoomSpritesPlus1" class="'.(self::$showVariables == true ? ' displayNone' : '').'">';
+ echo '<span class="pointer faicon icon-blue plus" onClick="toggleShowZoomVariables(\'0\')"> </span>';
+ echo '</span>';
+ echo '</span >';
+
+ echo '<span class="floatLeft">'.$lang['srv_zoom_filter_note'].'</span>';
+ echo '<span class="floatLeft spaceLeft">'.$condition_label.'</span>';
+/*
+ // ali imamo napake v ifu
+ if ((int)self::$profiles[self :: $currentProfileId]['condition_error'] != 0) {
+ echo '<br>';
+ echo '<span style="border:1px solid #009D91; background-color: #34D0B6; padding:5px; width:auto;"><img src="img_0/error.png" /> ';
+ echo '<span class="red strong">'.$lang['srv_profile_condition_has_error'].'</span>';
+ echo '</span>';
+ }
+ */
+ echo '<span class="as_link spaceLeft" onclick="showZoomSettings();">'.$lang['srv_profile_edit'].'</span>';
+ echo '<span class="as_link spaceLeft" onclick="removeZoomCheckbox();">'.$lang['srv_profile_remove'].'</span>';
+ echo '</div>';
+ echo '<br class="clr" />';
+ return true;
+ }
+
+ return false;
+ }
+
+ function doZoomFromInspect() {
+ global $lang;
+ # polovimo id-je variabel iz inspect profila in nastavimo zoom profil
+ $SI = new SurveyInspect(self::$sid);
+ $variables_to_add = $SI->getInspectVariables();
+
+ session_start();
+ # shranjujenmo v sejo
+ # dodamo profil in ga izberemo za privzetega
+
+ $_SESSION['surveyZoom'][self::$sid] = array('id'=>-1, 'name'=>$lang['srv_zoom_profile_session'],'vars'=>$variables_to_add, 'conditions'=> '', 'if_id'=>0);
+ self::$profiles[-1] = array('id'=>$pid, 'sid'=>self::$sid, 'uid'=>self::$uid, 'name'=>$lang['srv_zoom_profile_session'], 'vars'=>$variables_to_add,'conditions'=>'');
+ self::SetDefaultProfile(-1);
+ self::$currentProfileId = -1;
+ session_commit();
+
+
+ # prikažemo segmente
+ $showDiv = ((int)$_POST['showDiv'] == 1)?true:false;
+ self::displayZoomConditions($showDiv);
+ }
+}
\ No newline at end of file |