<?php
/** @author: Gorazd Veselič
*
* @Desc: za upravljanje z profili statusov za podatke in izvoze
*
*/
session_start();
class SurveyConditionProfiles
{
static private $sid = null; # id ankete
static private $uid = null; # id userja
static private $currentProfileId = null; # trenutno profil
static private $profiles = array(); # seznam vseh profilov od uporabnika
static private $inited = false; # ali so profili ze inicializirani
static private $_HEADER = null; # Header podatki
static private $awkConditions = array(); # array z pogoji za awk
static function Init($sid, $uid = null) {
# nastavimo sid
self::$sid = $sid;
if (isset($uid) && $uid > 0) {
self :: $uid = $uid ;
} else {
global $global_user_id;
self :: $uid = $global_user_id;
}
SurveyUserSetting :: getInstance()->Init(self::$sid, self::$uid);
if (self::$inited == false) {
self::$inited = self :: RefreshData();
}
}
static function RefreshData() {
self::$profiles = array();
# dodamo sistemske profile, skreiramo jih "on the fly"
self :: addSystemProfiles();
# preberemo podatke vseh profilov ki so na voljo in jih dodamo v array
$stringSelect = "SELECT * FROM srv_condition_profiles WHERE sid='" . self::$sid . "' AND uid='" . self::$uid . "' ";
$querySelect = sisplet_query($stringSelect);
if (mysqli_num_rows($querySelect)) {
while ( $rowSelect = mysqli_fetch_assoc($querySelect) ) {
self::$profiles[$rowSelect['id']] = $rowSelect;
}
}
# poiscemo privzet profil
self::$currentProfileId = SurveyUserSetting :: getInstance()->getSettings('default_condition_profile');
if (!self::$currentProfileId) {
self::$currentProfileId = 1;
}
# ce imamo nastavljen curent pid in profil z tem pid ne obstaja nastavomo na privzet profil
if (self::$currentProfileId != 1) {
if (!isset(self::$profiles[self::$currentProfileId])) {
self::$currentProfileId = 1;
self::setDefaultProfileId(self::$currentProfileId);
}
}
# ce ne obstajajo podatki za cpid damo error
if (!isset(self::$profiles[self::$currentProfileId])) {
die("Profile data is missing!");
return false;
} else {
return true;
}
}
public static function getSystemDefaultProfile() {
return (int)1;
}
public static function getCurentProfileId() {
return (int)self::$currentProfileId;
}
public static function setCurrentProfileId($id) {
if (isset(self::$profiles[$id]))
{
self::$currentProfileId = $id;
}
}
public function getProfileName($pid) {
return self::$profiles[$pid]['name'];
}
/* Vrne ID in ime trenutno izbranega profila
*
*/
function getCurentProfile() {
return array('id'=>self::$currentProfileId,'name'=>self::$profiles[self::$currentProfileId]['name']);
}
static function setDefaultProfileId($pid = 0) {
if (!$pid) {
$pid = 1;
}
# profila inspect ne pustimo nastavit za privzetega, ker je tako izbran preko inspect, pustimo pa urejanje
if( self::$profiles[$pid]['type'] != 'inspect') {
# če smo izbrali drug profil resetiramo še profil profilov na trenutne nastavitve
SurveyUserSetting :: getInstance()->saveSettings('default_profileManager_pid', '0');
SurveyUserSetting :: getInstance()->saveSettings('default_condition_profile', $pid);
self::$currentProfileId = $pid;
}
return true;
}
static function addSystemProfiles() {
global $lang;
# skreiramo sistemske profile za vse spremenljivke
self::$profiles['1'] = array('id'=>'1','uid'=>self::$uid,'name'=>$lang['srv_condition_profile_all'],'system'=>1, 'if_id'=>0);
}
static function DisplayLink($hideAdvanced = true) {
global $lang;
// profili statusov
$allProfiles = self :: $profiles;
$css = (self :: $currentProfileId == SCP_DEFAULT_PROFILE ? ' gray' : '');
if ($hideAdvanced == false || self :: $currentProfileId != SCP_DEFAULT_PROFILE) {
echo '<li class="space"> </li>';
echo '<li>';
echo '<span class="as_link'.$css.'" id="link_condition_profile" title="' . $lang['srv_condition'] . '" onClick="conditionProfileAction(\'showProfiles\');">' . $lang['srv_condition'] . '</span>'."\n";
echo '</li>';
}
}
static function getProfileData($pid) {
// preverimo ali smo v razredu že lovili podatke za ta profil, potem jih preberemo čene jih osvežimo
if ( isset( self::$profiles[$pid] ) ) {
return self::$profiles[$pid];
} else {
self::$inited = self :: RefreshData();
return self::$profiles[$pid];
}
}
static function ajax() {
$pid = $_POST['pid'];
switch ($_GET['a']) {
case 'show_condition_profile' :
self :: showProfiles($pid);
break;
case 'change_condition_profile' :
# if (isset($_POST['condition_label']) && $_POST['condition_label'] != '') {
# self :: setConditionLabel($pid,$_POST['condition_label']);
# }
if (isset($_POST['condition_error']) && $_POST['condition_error'] != '') {
self :: setConditionError($pid,$_POST['condition_error']);
}
self :: setDefaultProfileId($pid);
break;
case 'condition_remove' :
self :: conditionRemove();
break;
case 'create_condition_profile' :
self :: createNewProfile();
break;
case 'delete_condition_profile' :
self :: deleteProfile();
break;
case 'rename_condition_profile' :
self :: renameProfile();
break;
default:
echo 'ERROR! Missing function for action: '.$_GET['a'].'! (SurveyConditionProfile)';
break;
}
}
static function showProfiles ($pid = -1) {
global $global_user_id, $lang;
if ($pid > 0) {
$_currMPID = $pid;
} else {
// poiščmo uporabniški privzeti profil
$_currMPID = self::$currentProfileId;
}
// Naslov
echo '<h2>'.$lang['srv_condition_settings'].'</h2>';
echo '<div class="popup_close"><a href="#" onClick="conditionProfileAction(\'cancle\'); return false;">✕</a></div>';
if ( self :: $currentProfileId != SCP_DEFAULT_PROFILE ) {
echo '<div id="not_default_setting">';
echo $lang['srv_not_default_setting'];
echo '</div><br class="clr displayNone">';
}
echo '<div class="condition_profile_holder">';
echo '<div id="condition_profile" class="select">';
foreach (self :: $profiles as $key => $value) {
echo ' <div class="option' . ( $_currMPID == $value['id'] ? ' active' : '') . '" id="condition_profile_' . $value['id'] . '" value="'.$value['id'].'">';
echo $value['name'];
if($_currMPID == $value['id']){
if ( self :: $profiles[$_currMPID]['if_id'] != 0) {
echo '<a href="#" title="'.$lang['srv_delete_profile'].'" onclick="conditionProfileAction(\'deleteAsk\'); return false;"><span class="faicon delete floatRight"></span></a>';
}
if ( self :: $profiles[$_currMPID]['if_id'] != 0) {
echo '<a href="#" title="'.$lang['srv_rename_profile'].'" onclick="conditionProfileAction(\'renameAsk\'); return false;"><span class="faicon edit floatRight spaceRight"></span></a>';
}
}
echo '</div>';
}
echo '</div>';
echo '<div class="clr"></div>';
echo '</div>';
// tukaj prikazemo vsebino ifa
echo '<div id="div_cp_preview">';
echo ' <div id="div_cp_preview_content">';
if (self :: $profiles[$_currMPID]['if_id'] > 0) {
$b = new Branching(self::$sid);
$b->condition_editing(self :: $profiles[$_currMPID]['if_id'], -2);
}
else {
echo $lang['srv_filter_profiles_note'];
}
echo ' </div>';
echo '</div>';
echo '</div>';
echo '<div id="conditionProfileButtons">';
// gumbi: preklici, ustvari nov, pozeni trenutni
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="conditionProfileAction(\'run\'); return false;"><span>'.$lang['srv_run_selected_profile'].'</span></a></span></span>';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="conditionProfileAction(\'newName\'); return false;"><span>'.$lang['srv_create_new_profile'].'</span></a></span></span>';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="conditionProfileAction(\'cancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
echo '</div>';
// cover Div
echo '<div id="conditionProfileCoverDiv"></div>';
// div za shranjevanje novega profila
echo '<div id="newProfile">'.$lang['srv_missing_profile_name'].': ';
echo '<input id="newProfileName" name="newProfileName" type="text" size="45" />';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="conditionProfileAction(\'newCancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="conditionProfileAction(\'newCreate\'); return false;"><span>'.$lang['srv_save_profile'].'</span></a></span></span>';
echo '</div>';
// div za preimenovanje
echo '<div id="renameProfileDiv">'.$lang['srv_missing_profile_name'].': ';
echo '<input id="renameProfileName" name="renameProfileName" type="text" value="' . self :: $profiles[$_currMPID]['name'] . '" size="45" />';
echo '<input id="renameProfileId" type="hidden" value="' . self :: $profiles[$_currMPID]['id'] . '" />';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="conditionProfileAction(\'renameCancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="conditionProfileAction(\'renameConfirm\'); return false;"><span>'.$lang['srv_rename_profile_yes'].'</span></a></span></span>';
echo '</div>';
// div za brisanje
echo '<div id="deleteProfileDiv">'.$lang['srv_missing_profile_delete_confirm'].': <b>' . self :: $profiles[$_currMPID]['name'] . '</b>?';
echo '<input id="deleteProfileId" type="hidden" value="' . self :: $profiles[$_currMPID]['id'] . '" />';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="conditionProfileAction(\'deleteCancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="conditionProfileAction(\'deleteConfirm\'); return false;"><span>'.$lang['srv_delete_profile_yes'].'</span></a></span></span>';
echo '</div>';
}
static function createNewProfile() {
$name = isset($_POST['name']) ? $_POST['name'] : 'Nov profil';
$sql = sisplet_query("INSERT INTO srv_if (id) VALUES ('')");
if (!$sql) echo '-1';
$if_id = mysqli_insert_id($GLOBALS['connect_db']);
sisplet_query("INSERT INTO srv_condition (id, if_id, vrstni_red) VALUES ('', '$if_id', '1')");
$sql = sisplet_query("INSERT INTO srv_condition_profiles (id, sid, uid, name, if_id) VALUES ('', '".self::$sid."', '".self::$uid."', '$name', '$if_id')");
if (!$sql) echo '-2';
$pid = mysqli_insert_id($GLOBALS['connect_db']);
echo $pid;
}
static function deleteProfile() {
$pid = $_POST['pid'];
if ($pid > 0 ) {
$sql = sisplet_query("SELECT * FROM srv_condition_profiles WHERE id = '$pid'");
$row = mysqli_fetch_array($sql);
$if = $row['if_id'];
# če je inspect pobrišemo inspect profil
if ($row['type'] == 'inspect') {
#preverimi ali imamo nastavljen pogoj za inspect
$if_id = (int)SurveyUserSetting :: getInstance()->getSettings('inspect_if_id');
if ($if_id > 0) {
#odstranimo zapis za inspect
SurveyUserSetting :: getInstance()->removeSettings('inspect_if_id');
}
}
/* pobrisemo se za ifom*/
$sql = sisplet_query("SELECT * FROM srv_condition WHERE if_id = '$if'");
while ($row = mysqli_fetch_array($sql)) {
if ((int)$row[id] > 0) {
sisplet_query("DELETE FROM srv_condition_vre WHERE cond_id='$row[id]'");
}
}
if ((int)$if > 0) {
sisplet_query("DELETE FROM srv_condition WHERE if_id = '$if'");
sisplet_query("DELETE FROM srv_if WHERE id = '$if'");
}
/*-- pobrisemo se za ifom*/
$deleteString = "DELETE FROM srv_condition_profiles WHERE id = '" . $pid . "' ";
$sqlDelete = sisplet_query($deleteString);
if (!$sqlDelete) echo mysqli_error($GLOBALS['connect_db']);
}
$pid = 1;
SurveyUserSetting :: getInstance()->saveSettings('default_condition_profile', $pid);
self::$currentProfileId = $pid;
}
static function renameProfile() {
global $lang;
$sqlInsert = -1;
$name = isset($_POST['name']) ? $_POST['name'] : 'Nov profil';
$pid = $_POST['pid'];
if ( $pid != null && $pid != "" && $pid > 1) {
if ( $name == null || $name == "" ) {
$name = $lang['srv_new_profile_ime'];
}
$updateString = "UPDATE srv_condition_profiles SET name = '" . $name . "' WHERE id = '" . $pid . "'";
$sqlInsert = sisplet_query($updateString);
}
return $sqlInsert;
}
static public function setHeader($_header) {
self::$_HEADER = $_header;
}
static function getAwkConditionString($if_id = null) {
$awkFilter = '';
if ($if_id != null)
{
$awkFilter = self :: generateAwkCondition($if_id);
}
else
if (self :: $currentProfileId > 1 && (int)self::$profiles[self :: $currentProfileId]['condition_error'] == 0)
{
$awkFilter = self :: $currentProfileId;
$stringSelect = "SELECT if_id from srv_condition_profiles where id = '".self :: $currentProfileId."'";
$querySelect = sisplet_query($stringSelect);
list($if_id) = mysqli_fetch_row($querySelect);
if ($if_id > 0) {
$awkFilter = self :: generateAwkCondition($if_id);
}
}
return $awkFilter;
}
/**
* @desc zgenerira pogoje za AWK branching
*/
static function generateAwkCondition ($if) {
global $lang;
$echo = '';
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$i = 0;
while ($row = mysqli_fetch_assoc($sql)) {
$_spr_id = $row['spr_id'];
if ($i++ != 0)
if ($row['conjunction'] == 0)
$echo .= '&&';
else
$echo .= '||';
for ($i=1; $i<=$row['left_bracket']; $i++)
$echo .= '(';
# imamo spremenljivke (ni kalkulacija ali modercnum)
if ($_spr_id > 0) {
$echo .= self::getAWKSpremenljivka($row);
// recnum
} elseif ($_spr_id == -1) {
$echo .= '('.MOD_REC_FIELD.' % '.$row['modul'].'=='.$row['ostanek'].')';
// naprava
} elseif ($_spr_id == -4) {
foreach (self::$_HEADER['meta']['grids'] as $vkey => $variables) {
if ($variables['variables'][0]['variable'] == 'Device') {
$sequence = $variables['variables'][0]['sequence'];
$echo .= '($'.$sequence.' == ';
$device = $lang['srv_para_graph_device'.$row['text']];
# ta tekstovne
if (IS_WINDOWS) {
# za windows
$echo .= "\\\"".$device."\\\"";
}
else {
# za linux
$echo .= '"'.$device.'"';
}
$echo .= ')';
}
}
// calculations - TODO
} elseif ($_spr_id == -2) {
/*$_calc = self :: generateCalculationAWK($row['id']);
$echo .= '(';
$echo .= $_calc;
# dodoamo operacijo
$echo .= self::echoOperator($row['negation'], $row['operator']);
$echo .= $row['text'];
$echo .= ')';*/
}
for ($i=1; $i<=$row['right_bracket']; $i++)
$echo .= ')';
}
// failsafe, ce se poklika if, pa se ne nastavi pogoja
if ($echo == '') {
$echo .= ' true ';
}
else {
$echo = '('.$echo.')';
}
return $echo;
}
private static function getAWKSpremenljivka($row) {
$_spr_id = $row['spr_id'];
$row2 = self :: select_from_srv_spremenljivka($_spr_id);
$_spr_tip = $row2['tip'];
$echo = '';
// radio, checkbox, dropdown in multigrid, in multi check
if ( $_spr_tip <= 3 || $_spr_tip == 6 || $_spr_tip == 16 || $_spr_tip == 17) {
#radio, drop, checkbox
if ($_spr_tip <= 3) {
$sql3 = sisplet_query("SELECT * FROM srv_condition_vre c, srv_vrednost v WHERE cond_id='$row[id]' AND c.vre_id=v.id");
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
$j = 0;
# pogoje z več opcijami združenimi z OR dodamo v oklepaj zaradi pravilnosti
if (mysqli_num_rows($sql3) > 1) {
$echo .= '(';
}
while ($row3 = mysqli_fetch_assoc($sql3)) {
if ($j++ != 0) {
$echo .= '||';
}
if ($_spr_tip == 1 || $_spr_tip == 3|| $_spr_tip == 17) { # radio, dropdown
$seq = self ::getSequenceForAWKCondition(array('spr'=>$_spr_id));
} else if ($_spr_tip == 2) { # checkbox
$seq = self ::getSequenceForAWKCondition(array('spr'=>$_spr_id,'vre'=>$row3['vre_id']));
}
$echo .= '$'.$seq;
# dodoamo operacijo
$echo .= self::echoOperator($row['negation'], $row['operator']);
# dodamo vrednost ali 1 za checkbox
if ($_spr_tip == 1 || $_spr_tip == 3 || $_spr_tip == 17) {
$echo .= $row3['variable'];
} else if ($_spr_tip == 2) {
$echo .='1';
}
}
# pogoje z več opcijami združenimi z OR dodamo v oklepaj zaradi pravilnosti
if (mysqli_num_rows($sql3) > 1) {
$echo .= ')';
}
// multigrid tip = 6,16
} elseif ( $_spr_tip == 6 || $_spr_tip == 16 || $_spr_tip == 17) {
$sql3 = sisplet_query("SELECT * FROM srv_condition_grid c WHERE cond_id='$row[id]'");
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
$sqlMgrid = sisplet_query("SELECT id FROM srv_vrednost WHERE id = '$row[vre_id]'");
if (!$sqlMgrid) echo mysqli_error($GLOBALS['connect_db']);
$rowMgrid = mysqli_fetch_assoc($sqlMgrid);
$j = 0;
# pogoje z več opcijami združenimi z OR dodamo v oklepaj zaradi pravilnosti
if (mysqli_num_rows($sql3) > 1) {
$echo .= '(';
}
# preverimo ali je dvojna tabela
$isDouble == false;
if ($row2['enota'] == 3 ) {
$isDouble=true;
}
while ($row3 = mysqli_fetch_assoc($sql3)) {
if ($j++ != 0) $echo .= '||';
if ($isDouble == false || 1) {
$seq = self ::getSequenceForAWKCondition(array('spr'=>$_spr_id, 'vre'=>$rowMgrid['id'], 'grd'=>$row3['grd_id'], 'isDouble' => $isDouble));
$echo .= '$'.$seq;
# dodoamo operacijo
$echo .= self::echoOperator($row['negation'], $row['operator']);
if ($row2['tip'] == 16) {
$echo .= '1';
} else {
if (!$isDouble) {
$echo .= $row3['grd_id'];
} else {
$str = "select variable from srv_grid where spr_id='$_spr_id' AND id= '$row3[grd_id]'";
$qry = sisplet_query($str);
list($variable) = mysqli_fetch_row($qry);
$echo .= $variable;
}
}
} else {
echo 'Error! (SurveyConditionProdiles)';
var_dump($_spr_id);
var_dump($rowMgrid['id']);
var_dump($row3['grd_id']);
}
}
# pogoje z več opcijami združenimi z OR dodamo v oklepaj zaradi pravilnosti
if (mysqli_num_rows($sql3) > 1) {
$echo .= ')';
}
}
// textbox, number in compute majo drugacne pogoje in opcije
}
elseif ($_spr_tip == 4 || $_spr_tip == 7 || $_spr_tip == 18 || $_spr_tip == 19 || $_spr_tip == 20 || $_spr_tip == 21 || $_spr_tip == 22 || $_spr_tip == 25)
{
if ($_spr_tip == 7 || $_spr_tip == 18 || $_spr_tip == 19 || $_spr_tip == 20 ) {
$grd = $row['grd_id'];
} else {
$grd = null;
}
if (isset($row['vre_id'])) {
$vre = $row['vre_id'];
} else {
$vre = null;
}
$seq = self ::getSequenceForAWKCondition(array('spr'=>$_spr_id, 'vre'=>$vre, 'grd'=> $grd));
$echo .= '$'.$seq;
# dodoamo operacijo
$echo .= self::echoOperator($row['negation'], $row['operator']);
# za numerične
if ($_spr_tip == 7 || $_spr_tip == 18)
{
$echo .= $row['text'];
}
else
{
# ta tekstovne
if (IS_WINDOWS) {
# za windows
$echo .= "\\\"".$row['text']."\\\"";
} else {
# za linux
$echo .= '"'.$row['text'].'"';
}
}
}
#DATUM
elseif ($_spr_tip == 8)
{
$grd = $row['grd_id'];
if (isset($row['vre_id'])) {
$vre = $row['vre_id'];
} else {
$vre = null;
}
$seq = self ::getSequenceForAWKCondition(array('spr'=>$_spr_id, 'vre'=>$vre, 'grd'=> $grd));
$echo .= 'substr($'.$seq.',7,4)substr($'.$seq.',4,2)substr($'.$seq.',1,2)';
# dodoamo operacijo
$echo .= self::echoOperator($row['negation'], $row['operator']);
$echo .= date("Ymd", strtotime($row['text']));;
#$echo .= $row['text'];
}
return $echo;
}
/** Vrne awk matematični operator glede na polje operator in negacijo
*
* @param (0,1) $negation
* @param (0,1) $operator
*/
private static function echoOperator($negation = 0, $operator= 0) {
$echo = '==';
if ($negation == 0) {
if ($operator == 0)
$echo = '==';
elseif ($operator == 1)
$echo = '!=';
elseif ($operator == 2)
$echo = '<';
elseif ($operator == 3)
$echo = '<=';
elseif ($operator == 4)
$echo = '>';
elseif ($operator == 5)
$echo = '>=';
} else {
if ($operator == 0)
$echo = '!=';
elseif ($operator == 1)
$echo = '==';
elseif ($operator == 2)
$echo = '>';
elseif ($operator == 3)
$echo = '>=';
elseif ($operator == 4)
$echo = '<';
elseif ($operator == 5)
$echo = '<=';
}
return $echo;
}
private static $select_from_srv_spremenljivka = array();
/**
* pobere in zakesira podatke o spremenljivki (ker se to zlo velikokrat bere)
*
* @param mixed $spremenljivka
*/
static function select_from_srv_spremenljivka ($spremenljivka) {
if (array_key_exists($spremenljivka, self::$select_from_srv_spremenljivka)) {
return self::$select_from_srv_spremenljivka[$spremenljivka];
}
// tole se splaca tam kjer se itak vse spremenljivke preberejo, sam vprasanje, ce se povsod??
$sql = sisplet_query("SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='".self::$sid."'");
while ($row = mysqli_fetch_assoc($sql)) {
self :: $select_from_srv_spremenljivka[$row['id']] = $row;
}
if (array_key_exists($spremenljivka, self :: $select_from_srv_spremenljivka)) {
return self :: $select_from_srv_spremenljivka[$spremenljivka];
}
$sql = sisplet_query("SELECT * FROM srv_spremenljivka WHERE id = '$spremenljivka'");
self::$select_from_srv_spremenljivka[$spremenljivka] = mysqli_fetch_assoc($sql);
return self::$select_from_srv_spremenljivka[$spremenljivka];
}
static function getSequenceForAWKCondition ($options = array()) {
$spr_id = (isset($options['spr']) && $options['spr'] != null) ? $options['spr'] : null;
$vre_id = (isset($options['vre']) && $options['vre'] != null) ? $options['vre'] : null;
$grd_id = (isset($options['grd']) && $options['grd'] != null) ? $options['grd'] : null;
$isDouble = (isset($options['isDouble']) && $options['isDouble'] != null) ? $options['isDouble'] : false;
$tip = self::$_HEADER[$spr_id.'_0']['tip'];
if ( $spr_id != null && count(self::$_HEADER[$spr_id.'_0']['grids']) > 0 ) {
switch ($tip) {
case 1 :
case 3 :
$grd = 0;
$var = 0;
break;
case 2:
case 21:
case 17:
case 18:
$grd = 0;
if ($vre_id > 0 && count(self::$_HEADER[$spr_id.'_0']['grids'][$grd]['variables']) > 0) {
foreach (self::$_HEADER[$spr_id.'_0']['grids'][$grd]['variables'] AS $vkey =>$variables) {
if ($variables['vr_id'] == $vre_id && $variables['other'] != 1) {
$var = $vkey;
}
}
} else {
$var = 0;
}
break;
case 7:
$grd = 0;
$var = $grd_id;
break;
case 8:
$grd = 0;
$var = $grd_id;
break;
case 6:
case 16:
case 19:
case 20:
if ($isDouble == true) {
#polovimo part
$str = "select part from srv_grid where spr_id='$spr_id' AND id= '$grd_id'";
$qry = sisplet_query($str);
list($part) = mysqli_fetch_row($qry);
} else {
$part = 1;
}
if (count(self::$_HEADER[$spr_id.'_0']['grids']) > 0) {
foreach (self::$_HEADER[$spr_id.'_0']['grids'] AS $gkey => $grids) {
if (count ($grids['variables']) > 0) {
foreach ($grids['variables'] AS $vkey => $variables) {
if (($tip == 6 && $variables['vr_id'] == $vre_id && $variables['other'] != 1 && $part == $grids['part'])
|| (
($tip == 16 || $tip == 19 || $tip == 20)
&& $variables['vr_id'] == $vre_id && $grd_id == $variables['gr_id']) && $variables['other'] != 1) {
$grd = $gkey;
$var = $vkey;
}
}
}
}
}
break;
}
if ($grd !== null && $var !== null) {
return self::$_HEADER[$spr_id.'_0']['grids'][$grd]['variables'][$var]['sequence'];
}
}
return;
}
# static function setConditionLabel($pid,$condition_label) {
# if ((int)$pid > 0 ) {
# $updateString = "UPDATE srv_condition_profiles SET condition_label = '" . $condition_label . "' WHERE id = '" . $pid . "'";
# $sqlInsert = sisplet_query($updateString);
# }
# }
static function setConditionError($pid,$condition_error) {
if ((int)$pid > 0 ) {
$updateString = "UPDATE srv_condition_profiles SET condition_error = '" . $condition_error . "' WHERE id = '" . $pid . "'";
$sqlInsert = sisplet_query($updateString);
}
}
static function getConditionString($if_id = null)
{
global $lang;
# $condition_label = self::$profiles[self::$currentProfileId]['condition_label'];
ob_start();
$b = new Branching(self::$sid );
if ($if_id == null || (int)$if_id == 0)
{
$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">';
#if (self::$profiles[self :: $currentProfileId]['type'] == 'inspect') {
# echo '<span class="floatLeft">'.$lang['srv_profile_data_is_filtred_zoom'].'</span>';
#} else {
echo '<span class="floatLeft">'.$lang['srv_profile_data_is_filtred'].'</span>';
#}
echo '<span class="floatLeft spaceLeft clr_if"><b>('.self::$profiles[self :: $currentProfileId]['name'].')</b></span>';
echo '<span class="floatLeft spaceLeft">'.$condition_label.'</span>';
// ali imamo napake v ifu
if ((int)self::$profiles[$if_id]['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" id="link_condition_edit">'.$lang['srv_profile_edit'].'</span>';
echo '<span class="as_link spaceLeft" id="link_condition_remove">'.$lang['srv_profile_remove'].'</span>';
#if (self::$profiles[self :: $currentProfileId]['type'] == 'inspect') {
# echo '<span class="as_link spaceLeft" onclick="window.location=\'index.php?anketa='.self::$sid.'&a=data&m=quick_edit&quick_view=1\'">'.$lang['srv_zoom_link_whoisthis'].'</span>';
#}
echo '</div>';
echo '<br class="clr" />';
return true;
}
return false;
}
/**
* @desc zgenerira kalkulacijo za vstavitev v AWK
*/
# TODO!!!!
# kalkulacije so rešene samo za silo (delujejo samo za tip radio
function generateCalculationAWK ($condition) {
$result = '';
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$condition' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$i = 0;
while ($row = mysqli_fetch_assoc($sql)) {
$_tmp_result = '';
$_valid = false;
$_spr_id = $row['spr_id'];
if ($i++ != 0) {
if ($row['operator'] == 0)
$_tmp_result .= '+';
elseif ($row['operator'] == 1)
$_tmp_result .= '-';
elseif ($row['operator'] == 2)
$_tmp_result .= '*';
elseif ($row['operator'] == 3)
$_tmp_result .= '/';
}
for ($j=1; $j<=$row['left_bracket']; $j++) {
$_tmp_result .= '(';
}
// obi�ajne spremenljivke
if ($_spr_id > 0) {
$_tmp_result .= self::getAWKSpremenljivka($row);
// konstante
} elseif ($row['spr_id'] == -1) {
$_tmp_result .= $row['number'];
$_valid = true;
}
for ($j=1; $j<=$row['right_bracket']; $j++) {
$_tmp_result .= ')';
}
if ($_valid === true) {
$result .= $_tmp_result;
}
}
return $result;
}
static function conditionRemove() {
# nastavimo privzet profil oziroma brez pogojev.
#Če pa je izbran profil bil slučajno inspect, ga v celoti odstranimo, da pobrišemo predhodne nastavitve zaradi gnezdenja
if (isset($_POST['pid']) && (int)$_POST['pid'] > 0) {
$currentProfileId = (int)$_POST['pid'];
} else {
$currentProfileId = SurveyUserSetting :: getInstance()->getSettings('default_condition_profile');
}
echo ($currentProfileId);
# preberemo podatke o profilu
$stringSelect = "SELECT * FROM srv_condition_profiles WHERE sid='" . self::$sid . "' AND uid='" . self::$uid . "' AND id = '".$currentProfileId."'";
$querySelect = sisplet_query($stringSelect);
# če je if_profil inspect, ga v celoti zbrišemo
if (mysqli_num_rows($querySelect)) {
$rowSelect = mysqli_fetch_assoc($querySelect);
# če je inspect
if ($rowSelect['type'] == 'inspect') {
$if_id = $rowSelect['if_id'];
if ((int)$if_id > 0) {
$delStr = "DELETE FROM srv_if WHERE if = '".(int)$if_id."'";
sisplet_query($delStr);
}
# zbrišemo še condition_profil
if ($currentProfileId > 0) {
$delStr = "DELETE FROM srv_condition_profiles WHERE sid='" . self::$sid . "' AND uid='" . self::$uid . "' AND id = '".$currentProfileId."'";
sisplet_query($delStr);
}
sisplet_query("COMMIT");
}
# če smo izbrali drug profil resetiramo še profil profilov na trenutne nastavitve
SurveyUserSetting :: getInstance()->saveSettings('default_profileManager_pid', '0');
SurveyUserSetting :: getInstance()->removeSettings('default_condition_profile');
}
# drugače samo nastavimo na privzet profil = 1
$currentProfileId = 1;
SurveyUserSetting :: getInstance()->saveSettings('default_condition_profile', $currentProfileId);
self::$currentProfileId = $currentProfileId;
}
/** preveri obstoj profila in vrne enak id če obstaja, če ne vrne id privzetega profila
*
* @param unknown_type $pid
* @return unknown
*/
function checkProfileExist($pid)
{
if (isset(self::$profiles[$pid]))
{
return true;
}
return false;
}
}
?>
