'; // #placeholder
$this->toolbox();
}
// forma in glasovanje - hitre nastavitve na desni - ce imamo odprto knjiznico ne prikazemo zaradi prekrivanja
if ( $this->survey_type == 1 || $this->survey_type == 0 ) {
echo '
';
}
if ($row['popup'] == 0) { // default je true
?>getSurveyRow();
# preverimo ali imamo ife. Če so, izpisujemo vse ikonce
$sql_select = "SELECT count(*) AS if_count FROM srv_branching WHERE element_if > 0 AND ank_id = '".$this->anketa."'";
$sql_query = sisplet_query($sql_select);
$row_query = mysqli_fetch_array($sql_query);
$has_if = (int)$row_query['if_count'] > 0 ? true : false;
# ali prikazujemo vse ikonice ali samo "simpl" ikonice
$sql_select_fv = "SELECT count(*) AS full_view FROM srv_user_setting_for_survey WHERE sid='".$this->anketa."' AND uid='".$global_user_id."' AND what='display_full_toolbox' AND value='1'";
$sql_query_fv = sisplet_query($sql_select_fv);
$row_query_fv = mysqli_fetch_array($sql_query_fv);
$full_view = (int)$row_query_fv['full_view'] == 1 ? true : false;
$full_view = true;
// prikaz blokov kot zavihke
echo '
';
$sql = sisplet_query("SELECT i.* FROM srv_if i, srv_branching b WHERE i.tab='1' AND i.tip='1' AND i.id=b.element_if AND b.ank_id='$this->anketa' ORDER BY b.parent, b.vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$i = 0;
while ($row = mysqli_fetch_array($sql)) {
if ($i++ != 0) echo ' | ';
$label = ($row['label'] == ''?$lang['srv_blok'].' ('.$row['number'].')':$row['label']);
echo ''.$label.' ';
}
echo '
';
echo ' ';
}
/**
* zamenja full_view = 1/0 za toolbox
*
*/
function toogle_toolbox_nastavitve() {
global $global_user_id;
# ali prikazujemo vse ikonice ali samo "simpl" ikonice
$sql_update_fv = "INSERT INTO srv_user_setting_for_survey (sid,uid,what,value) VALUES ('$this->anketa', '$global_user_id', 'display_full_toolbox', '1') ON DUPLICATE KEY UPDATE value = !value";
$sql_query_fv = sisplet_query($sql_update_fv);
$this->display_toolbox_nastavitve();
}
/**
* prikaze izbrani toolbox
*
*/
function toolbox () {
$row = SurveyInfo::getInstance()->getSurveyRow();
echo '
';
// Mobile add question
MobileSurveyAdmin::displayAddQuestion($this->anketa);
}
/**
* novi toolbox s tipi vprašanj
*/
function toolbox_basic2 () {
global $lang;
global $admin_type;
global $global_user_id;
$row = SurveyInfo::getInstance()->getSurveyRow();
$this->survey_type = SurveyInfo::getInstance()->getSurveyColumn("survey_type");
$hierarhija = SurveyInfo::getInstance()->checkSurveyModule('hierarhija');
echo '
';
echo '';
// normalna anketa
if ($this->survey_type != 1){
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
echo '
';
echo '';
// normalna anketa
if ($this->survey_type != 1){
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
echo '
';
}
/**
* prikaze popup z vsemi tipi vprasanj
*
*/
function toolbox_add_advanced($popup=false) {
global $lang;
global $site_url;
global $admin_type;
global $global_user_id;
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
echo '
';
}
/**
* preview
*
*/
private function getTipPreviewHtml(){
global $lang;
global $global_user_id;
// Predpregled tipa vprašanj - prikazujemo samo kadar smo v urejanju ankete
if (!$this->anketa > 0)
return;
if ( ($_GET['a'] != '' || !isset($_GET['anketa'])) && $_GET['a'] != 'branching' )
return;
echo '
';
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
// tip 9999 - IF
echo '
';
}
/**
* izrise linke za dodajanje demografskih vprasanj pri novi prazni anketi
*
*/
function demografija () {
global $lang;
echo '
';
echo '';
echo '
';
}
/**
* Vrne ID bloka z demografijo
*
*/
function get_demografija_id () {
global $lang;
$sql = sisplet_query("SELECT i.* FROM srv_branching b, srv_if i WHERE b.ank_id = '$this->anketa' AND b.parent='0' AND i.id=b.element_if AND i.tip='1'");
if (mysqli_num_rows($sql) == 1) {
$row = mysqli_fetch_array($sql);
if ($row['label'] == $lang['srv_demografija']) {
return $row['id'];
}
}
return 0;
}
/**
* preveri, ce so v bloku z demografijo samo demografska vprasanja
*
*/
function check_only_demografija($id) {
$sql = sisplet_query("SELECT element_spr FROM srv_branching WHERE parent = '$id'");
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0) {
$sql1 = sisplet_query("SELECT sistem FROM srv_spremenljivka WHERE id = '$row[element_spr]'");
$row1 = mysqli_fetch_array($sql1);
if ( ! $row1['sistem']==1 ) // bomo rekl, da kr ce ni sistemska
return false;
} else {
return false;
}
}
return true;
}
/**
* preveri, ce je izbrana variabla ze dodana kot demografija
*
* @param mixed $variable
*/
function check_demografija_exists($variable) {
$if_id = $this->get_demografija_id();
$sql = sisplet_query("SELECT COUNT(*) AS count FROM srv_branching b, srv_spremenljivka s WHERE b.ank_id='$this->anketa' AND b.element_spr=s.id AND b.parent='$if_id' AND s.variable='$variable'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
if ($row['count'] > 0)
return true;
return false;
}
/**
* nova branching struktura
*
*/
function branching_struktura () {
global $lang;
global $global_user_id;
// naenkrat preberemo vse spremenljivke, da ne delamo queryja vsakic posebej
Cache::cache_all_srv_spremenljivka($this->anketa, true);
// enako za srv_branching
Cache::cache_all_srv_branching($this->anketa, true);
// cachiramo tudi srv_if
Cache::cache_all_srv_if($this->anketa);
// cache vseh spremenljivk
//$this->find_all_spremenljivka();
#$this->survey_type = SurveyAdmin::getSurvey_type($this->anketa);
$this->survey_type = SurveyInfo::getInstance()->getSurveyColumn("survey_type");
//$this->toolbox_nastavitve();
// prikaz blokov kot zavihke
$sqlB = sisplet_query("SELECT i.* FROM srv_if i, srv_branching b WHERE i.tab='1' AND i.tip='1' AND i.id=b.element_if AND b.ank_id='$this->anketa' ORDER BY b.parent, b.vrstni_red");
if (!$sqlB) echo mysqli_error($GLOBALS['connect_db']);
if(mysqli_num_rows($sqlB) > 0){
echo '
';
$parent = 0;
if ($_GET['parent_if'] != 0) $parent = (int)$_GET['parent_if'];
// navaden prikaz
if ($parent == 0) {
// uvod - pri formi ga ni
if ($this->survey_type != 1) {
// napis uvod na začetku
echo '
';
echo '
';
echo '
'.$lang['srv_intro_page'].'
';
echo ' ';
echo '
';
echo '
';
echo '
';
echo ' ';
echo '
';
// Ce imamo slucajno GDPR preduvod
if(GDPR::isGDPRSurvey($this->anketa)){
$gdpr_settings = GDPR::getSurveySettings($this->anketa);
if($gdpr_settings['1ka_template'] == '1'){
echo '
';
if ($this->expanded)
$this->gdpr_introduction();
else
echo $lang['srv_gdpr_survey_gdpr_1ka_template_title'];
echo '
';
echo '
';
echo ' ';
echo '
';
}
}
echo '
';
if ($this->expanded)
$this->introduction_conclusion(-1);
else
echo ''.$lang['srv_intro_label'].'';
echo '
';
}
$sql = sisplet_query("SELECT COUNT(*) AS count FROM srv_branching WHERE ank_id = '$this->anketa' AND parent = '0'");
$row = mysqli_fetch_array($sql);
$first = $row['count'];
// prazen div - ko se ni nobenega vprasanja
if ($first <= 0) {
echo '
';
}
if ($first > 0) {
// Uvodni element (pri formi ga ni)
if ($this->survey_type != 1) {
echo '
';
echo ' ';
echo '
';
$first = $this->find_first_spr();
echo '
';
// Zaenkrat imamo vedno isti text za strani
if ($first > 0){
$gr = $this->getGrupa4Spremenljivka($first);
$naslov = $lang['srv_stran'].' '.$gr['vrstni_red'];
}
else
$naslov = $lang['srv_stran'].' 1';
echo '
';
echo '
'.$naslov.'
';
echo ' ';
echo '
';
echo '
';
}
echo '
';
echo ' ';
echo '
';
}
// Dodani elementi v anketi (vprasanja, pogoji...)
foreach (Cache::srv_branching_parent($this->anketa, $parent) AS $k => $rowQ) {
$this->display_element($rowQ['element_spr'], $rowQ['element_if']);
}
// Gumb za dodajanje vprasanja
if ($first > 0 && !$this->locked) {
echo '
';
echo '
';
echo ' ';
echo '
';
echo '
';
}
// Zakljucek - pri formi ga ni
if ($this->survey_type != 1) {
// napis zakljucek prikazemo tukaj in ne za zadnjo spremenljivko da je lepse
echo '
';
echo '
';
echo '
'.$lang['srv_end_page'].'
';
echo ' ';
echo '
';
echo '
';
echo '
';
echo ' ';
echo '
';
echo '
';
if ($this->expanded)
$this->introduction_conclusion(-2);
else
echo ''.$lang['srv_end_label'].'';
echo '
';
}
}
// prikaz samo bloka - zavihek
else {
$this->display_if($parent);
}
echo '
';
// Pri formi na dnu izpisemo dodaten text
$this->showVprasalnikBottom();
if (isset($_GET['spr_id']) && $_GET['spr_id'] > 0) {
?>
0)
$this->display_spremenljivka($element_spr);
else
$this->display_if($element_if);
}
function display_spremenljivka ($spremenljivka) {
global $lang;
$row = SurveyInfo::getInstance()->getSurveyRow();
$this->survey_type = SurveyInfo::getInstance()->getSurveyColumn("survey_type");
if ($row['flat'] == 0)
$zamik = ( $this->level($spremenljivka,0) > 0 ? ' style="padding-left:'.($this->level($spremenljivka,0)*32).'px"' : '' );
else
$zamik = '';
$row = Cache::srv_spremenljivka($spremenljivka);
$row1 = Cache::srv_branching($spremenljivka, 0);
echo '
';
if ($this->pagebreak($spremenljivka)) {
$gr = $this->getGrupa4Spremenljivka($this->find_next_spr($spremenljivka));
if ($gr['id'] > 0) {
echo '
';
echo ' ';
echo '
';
// ++ zadnji pagebreak prikazan izven ifa //
// ce je spremenljivka zadnja v IFu, ne prikazemo PB, ker ga bomo za ENDIFom
$rows = Cache::srv_branching($spremenljivka, 0);
if ( $this->find_last_in_if($rows['parent']) != $spremenljivka ) {
echo '
';
echo '
';
echo '
'.$lang['srv_stran'].' '.$gr['vrstni_red'].'
';
echo '
'.$lang['srv_rem_pagebreak'].'
';
echo ' ';
echo '
';
echo '
';
echo '
';
echo ' ';
echo '
';
}
}
// -- zadnji pagebreak prikazan izven ifa //
elseif($this->survey_type != 1) {
echo '
';
}
// pri formi ne dovolimo dodajanja page-breakov
elseif ($this->survey_type != 1) {
// tuki pustimo, da se PB lahko dodaja za spremenljivko in za ifom (pol se prikaze za ifom)
// -- v zadnji spremenljivki za ifom ne prikazemo dodajanja
$rows = Cache::srv_branching($spremenljivka, 0);
if ( $this->find_last_in_if($rows['parent']) != $spremenljivka ) {
echo '
';
echo '
';
echo '
'.$lang['srv_add_pagebreak'].'
';
echo ' ';
echo '
';
echo '
';
}
// zadnji spremenljivki v ifu izpisemo PB izven ifa (da je bolj pregledno in lepse)
else {
echo '
';
$row1 = Cache::srv_branching(0, $if);
// ++ zadnji pagebreak prikazan izven ifa //
$spr = $this->find_last_in_if($if);
if($spr > 0)
$rows = Cache::srv_branching($spr, 0);
$rowi = cache::srv_branching(0, $if);
// preverimo, da ni na zadnjem mestu ifa se en if (ker potem se 2x izpise PB)
$sqle = sisplet_query("SELECT ank_id, parent, element_spr, element_if FROM srv_branching WHERE parent='{$rowi['parent']}' AND vrstni_red>'{$rowi['vrstni_red']}' AND ank_id='$this->anketa'");
if (isset($rows['pagebreak']) && $rows['pagebreak'] == 1 AND (mysqli_num_rows($sqle)>0 || $rowi['parent']==0) ) {
$gr = $this->getGrupa4Spremenljivka($this->find_next_spr($spr));
if ($gr['id'] > 0) {
echo '
';
echo ' ';
echo '
';
echo '
';
echo '
';
echo '
'.$lang['srv_stran'].' '.$gr['vrstni_red'].'
';
echo '
'.$lang['srv_rem_pagebreak'].'
';
echo ' ';
echo '
';
echo '
';
}
}
// zadnji spremenljivki v ifu, tudi dodamo PB izven pagebreaka (da se doda, tam kjer se potem prikaže)
// ce gre za zadnji if v anketi ne pustimo dodajanja page breaka
if (isset($rows['pagebreak']) && $rows['pagebreak'] == 0
&& (mysqli_num_rows($sqle) > 0 || $rowi['parent'] == 0)
&& ($if != $this->find_last_if_branching())
){
echo '
';
}
// Ce je zaklenjeno ampak ga lahko ureja ker je admin ali avtor
elseif($row['locked']){
$string .= ''.$lang['srv_locked_text'].'';
}
// Ce je onemogoceno vprasanje
$disabled_vprasanje = $spremenljivkaParams->get('disabled_vprasanje') ? $spremenljivkaParams->get('disabled_vprasanje') : 0;
if($disabled_vprasanje){
$string .= ''.$lang['srv_disabled_text'].'';
}
echo $string;
echo '
';
echo '
'; // - spremenljivka_settings
// --- Zgornja vrstica pri editiranju vprasanj -->
// pri multigridu ne pustimo spremembe orientacije
if ( ($row['orientation'] == 0 || $row['orientation'] == 2) && $row['tip'] != '6') {
$cssFloat = ' floatLeft';
$divClear = '';
if ($row['orientation'] == 2) {
# pri vodoravni orientaciji z prelomom vrstice
$line_break = " ";
}
} else {
$cssFloat = '';
$divClear = '';
}
// kalkulacija
if ($row['tip'] == 22) {
$row['naslov'] = ''.$this->calculations_display(-$spremenljivka).' ('.$lang['srv_vprasanje_tip_long_'.$row['tip']].')';
}
// Kvota
else if($row['tip'] == 25){
$SQ = new SurveyQuotas($this->anketa);
$row['naslov'] = ''.$SQ->quota_display(-$spremenljivka).' ('.$lang['srv_vprasanje_tip_long_'.$row['tip']].')';
}
// Inline ifi so disablani ce nimamo ustreznega paketa
$userAccess = UserAccess::getInstance($global_user_id);
echo '
';
// kalkulacija
if ($row['tip'] == 22) {
echo '
';
echo $row['naslov'];
echo '
';
}
// Kvota
elseif($row['tip'] == 25){
echo '
';
echo $row['naslov'];
echo '
';
}
// GDPR vprasanje in prevajanje - prevedemo v anglescino
elseif($prevajanje && $row['variable'] == 'gdpr'){
// nastavimo na jezik za respondentov vmesnik
$language_id_bck = $lang['id'];
$file = ($this->lang_id == '1') ? '../../lang/1.php' : '../../lang/2.php';
@include($file);
$gdpr_naslov = GDPR::getSurveyIntro($this->anketa);
echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id, naslov FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
';
$sql2 = sisplet_query("SELECT id, naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
echo '
';
if ($row['enota'] == 6){
echo '
';
echo '
';
$bg++;
}
echo '';
echo '
';
}
//izrisemo multigride s select box namesto checkbox
elseif($row['tip'] == 16 && $row['enota'] == 6) {
echo '
';
echo ' ';
// urejanje vrednosti
echo '
';
echo '
';
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT id, naslov, vrstni_red, variable FROM srv_grid WHERE spr_id='$row[id]' AND vrstni_red>0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
for ($i = 1; $i <= $row['grids']; $i++) {
if ($row2['vrstni_red'] == $i) {
echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id, naslov FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
';
$sql2 = sisplet_query("SELECT naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
echo '
';
if ($row['enota'] == 6){
echo '
';
echo '
';
$bg++;
}
echo '';
echo '
';
}
//izrisemo double multigride
elseif(($row['tip'] == 6 || $row['tip'] == 16) && $row['enota'] == 3){
$colspan = $row['grids'];
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0 AND part='1'");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
$colspan += mysqli_num_rows($sql_grid_mv) + 1;
}
echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id, naslov FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0 AND part='1'");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
';
//DRUGI DEL GRIDA
//$sql2 = sisplet_query("SELECT naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 AND part='2' ORDER BY vrstni_red");
$sql2String = "SELECT id, naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 AND part='2' ORDER BY vrstni_red";
$sql2 = sisplet_query($sql2String);
//$sql2 = sisplet_query("SELECT naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 AND part='1' ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
for ($i = 1; $i <= $row['grids']; $i++) {
if ($this->lang_id != null) {
//$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row2['idrow2['id']);
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $i);
if ($naslov != '') $row2['naslov'] = $naslov;
}
if ($row2['vrstni_red'] == $i+$row['grids']+mysqli_num_rows($sql_grid_mv)) {
//echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id, naslov FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0 AND part='2'");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
' . $row_grid_mv['naslov'] . '
';
}
}
echo '
';
echo ' ';
echo ' ';
$bg++;
//$orderby = Survey::generate_order_by_field($spremenljivka);
//$sql1 = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY FIELD(vrstni_red, $orderby)");
$sql1 = sisplet_query("SELECT id, naslov, hidden, if_id, other FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red");
while ($row1 = mysqli_fetch_array($sql1)) {
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslov = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id']);
if ($naslov != '') $row1['naslov'] = $naslov;
}
echo '
';
//PRVI DEL GRIDA
//razlicni vnosi glede na tip multigrida
for ($i = 1; $i <= $row['grids']; $i++) {
if($row['tip'] == 6)
echo '
';
elseif($row['tip'] == 16)
echo '
';
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0 AND part='1'");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
//DRUGI DEL GRIDA
//razlicni vnosi glede na tip multigrida
for ($i = 1; $i <= $row['grids']; $i++) {
if($row['tip'] == 6)
echo '
';
elseif($row['tip'] == 16)
echo '
';
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0 AND part='2'");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT id, variable FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
echo '
' . $row2['variable'] . '
';
echo '
';
$row2 = mysqli_fetch_array($sql2);
echo '
' . $row2['variable'] . '
';
echo '
';
echo '';
$bg++;
$sql1 = sisplet_query("SELECT id, naslov, naslov2, if_id, other FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red");
while ($row1 = mysqli_fetch_array($sql1)) {
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslov = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id']);
if ($naslov != '') $row1['naslov'] = $naslov;
$naslov2 = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id'], true);
if ($naslov2 != '') $row1['naslov2'] = $naslov2;
}
echo '
';
//ali
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
//echo '
';
echo ' '; //začetek glave oz. naslovne vrstice tabele
// urejanje vrednosti
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT id, variable FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
echo '
' . $row2['variable'] . '
';
$row2 = mysqli_fetch_array($sql2);
echo '
';
echo '
' . $row2['variable'] . '
';
echo '
';
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT id, naslov, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
//risanje naslovov stolpcev
for ($i = 1; $i <= $row['grids']; $i++) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row2['id']);
if ($naslov != '') $row2['naslov'] = $naslov;
}
if ($row2['vrstni_red'] == $i) {
//echo '
';
$label_text = ($row2['id'] % 2 == 0 ? $lang['srv_maxdiff_label1'] : $lang['srv_maxdiff_label2']);
//ce je default besedilo "Vpišite besedilo" spremeni labelo v "Najmanj pomemben" in "Najbolj pomemben", drugace pokazi v labelah, kar je v bazi
echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id, naslov FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
//echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
';
echo ''; //konec glave oz. naslovne vrstice tabele
echo ''; //zacetek telesa tabele
$bg++;
$sql1 = sisplet_query("SELECT id, naslov, hidden, if_id, other FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red");
while ($row1 = mysqli_fetch_array($sql1)) {
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslov = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id']);
if ($naslov != '') $row1['naslov'] = $naslov;
}
echo '
'; //začetek vrstice
// levi del radio button
//echo '
';
echo '
';
//sredinski del z besedilom
echo '
';
echo '';
echo '
';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
echo '
';
//ce je other, ga izrisi drugace
$style = ($row1['other'] == 1) ? 'style="flex-grow: 0;margin-left: auto;"' : '';
echo '
';
//urejanje navpicnega dela grupiranja radio button - vodoravni je urejen po defaultu s pomočjo atributa name
echo'
';
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
//echo '
';
// koda za notranji IF
if ($row1['if_id'] > 0) {
echo ' *';
echo ' ';
$this->conditions_display($row1['if_id']);
echo '';
if ($this->condition_check($row1['if_id']) != 0)
echo ' ';
}
echo '
';
}
echo '
';
//izris desne strani**************************************************************************************
//***********za skatlasto obliko
$display_drag_and_drop_new_look = ($spremenljivkaParams->get('display_drag_and_drop_new_look') ? $spremenljivkaParams->get('display_drag_and_drop_new_look') : 0); //za checkbox
//***********za skatlasto obliko - konec
echo '
';
$sql2 = sisplet_query("SELECT id, naslov, variable, vrstni_red FROM srv_grid WHERE spr_id='$spremenljivka' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
echo '
';
for ($i = 1; $i <= $row['grids']; $i++) {
if ($row2['vrstni_red'] == $i) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row2['id']);
if ($naslov != '') $row2['naslov'] = $naslov;
}
echo '
';
//razlicni vnosi glede na tip multigrida
for ($i = 1; $i <= $row['grids']; $i++) {
if($row['tip'] == 6) {
if($row['enota'] != 9){ //ce ni postavitev drag and drop, pokazi radio buttone
$sqlTrak = sisplet_query("SELECT spr_id, variable, vrstni_red FROM srv_grid WHERE spr_id='$row[id]' AND other=0 AND id='$i'");
$rowTrak = mysqli_fetch_array($sqlTrak);
echo '
';
if($row['enota'] == 11){
echo '';
}elseif($row['enota'] == 12){
echo '';
}else {
echo '';
}
if($diferencial_trak == 1 && ($row['enota'] == 1 || $row['enota'] == 0)){ //ce je trak vklopljen in je diferencial ali klasicna tabela, dodaj se label z ustreznimi stevilkami za trak
echo '';
}
echo '
';
}
}
elseif($row['tip'] == 16) {
echo '
';
}
elseif ($row['tip'] == 19) {
echo '
';
}
elseif ($row['tip'] == 20) {
if ($row['ranking_k'] == 1) { //ce je slider
echo '
';
}
}
$izris_droppable_grid = 1; //izris ene vrstice droppables se je izvedel
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
//echo '
';
}
if ($row['ranking_k'] != 1) { //ce ni slider
// Zadnja bela celica kjer se nahajajo ikone za mouseover
echo '
';
echo '
';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
echo '
';
echo '
';
echo '
';
}
$bg++;
$varIndex++;
if($diferencial_trak == 1 && ($row['enota'] == 1 || $row['enota'] == 0) ){ // ce je diferencial ali klasicna tabela s trakom, dodaj se prazno vrstico med razlicnimi odgovori
echo '
' . "\n";
}
}
echo ' ';
echo '
';
//ce je drsnik in moramo urediti opisne labele #########################################################
if ($row['ranking_k'] == 1 && $slider_VmesneDescrLabel){ //ce je slider in se ureja opisne labele
echo ''; //za urediti prostor med zadnjimi opisnimi labelami in njihovim urejanjem
if($slider_DescriptiveLabel_defaults&&$prevajanje==false){
$tabelaOpisneStyle = 'display:none;';
}else{
$tabelaOpisneStyle = '';
}
echo '
';
echo '';
//moznosti brez urejanja ureditev opisnih label drsnika - konec
//js koda za ustrezno skrivanje in prikazovanje delov za urejanje custom opisnih label
?>
';
}
//ce je drsnik in moramo urediti opisne labele - konec ##################################################
}
// textbox -- not any more
}
elseif ($row['tip'] == 4) {
$taSize = ($spremenljivkaParams->get('taSize') ? $spremenljivkaParams->get('taSize') : 1);
$taWidth = ($spremenljivkaParams->get('taWidth') ? $spremenljivkaParams->get('taWidth') : -1);
//default sirina
if($taWidth == -1)
$taWidth = 30;
if ($taSize > 1)
echo '';
else
echo '';
// dodamo checkboxe za druga polja
$sql1 = sisplet_query("SELECT id, naslov FROM srv_vrednost WHERE spr_id='$row[id]' AND other>0");
while ($row1 = mysqli_fetch_array($sql1)) {
echo '
';
//ce je drsnik in moramo urediti opisne labele #########################################################
if ($slider_VmesneDescrLabel){ //ce se ureja custom opisne labele
echo ''; //za urediti prostor med zadnjimi opisnimi labelami in njihovim urejanjem
if($slider_DescriptiveLabel_defaults&&$prevajanje==false){
$tabelaOpisneStyle = 'display:none;';
}else{
$tabelaOpisneStyle = '';
}
echo '
';
// dodamo checkboxe za druga polja
$sql1 = sisplet_query("SELECT id, naslov, other FROM srv_vrednost WHERE spr_id='$row[id]' AND vrstni_red>0 AND other != 0");
while ($row1 = mysqli_fetch_array($sql1)) {
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslov = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id']);
if ($naslov != '') $row1['naslov'] = $naslov;
}
// Ce je variabla ne vem in imamo vklopljen prikaz ob opozorilu -> rdec
$missing_warning = '';
if(($row1['other'] == '-97' && $row['alert_show_97'] > 0)
|| ($row1['other'] == '-98' && $row['alert_show_98'] > 0)
|| ($row1['other'] == '-99' && $row['alert_show_99'] > 0)){
$missing_warning = ' red';
}
echo '
';
MobileSurveyAdmin::displayAddQuestionCategory($this->anketa, $spremenljivka, $row['tip']);
}
}
// kjer so vsi divi floatani, da se raztegne okvir vprasanja
if ($row['orientation']==0 || $row['orientation']==2 || $row['tip'] == 17)
echo '';
echo '';
if ($this->displayKomentarji !== false) {
$sc = new SurveyComments($this->anketa);
$sc->display_vprasanje_komentarji($spremenljivka);
}
echo ' ';
}
function vprasanje_grid_multiple ($spremenljivka) {
global $lang;
global $lang1;
global $global_user_id;
$row = Cache::srv_spremenljivka($spremenljivka);
$spremenljivkaParams = new enkaParameters($row['params']);
// Ce je vprasanje ali anketa zaklenjena
$locked = ($this->locked) ? true : false;
// Inline ifi so disablani ce nimamo ustreznega paketa
$userAccess = UserAccess::getInstance($global_user_id);
echo '
';
echo ' ';
// podnaslovi gridov
$sql2 = sisplet_query("SELECT s.id, s.naslov, s.grids FROM srv_spremenljivka s, srv_grid_multiple m WHERE s.id = m.spr_id AND parent = '".$row['id']."' ORDER BY m.vrstni_red");
if ($row['grid_subtitle1'] == '1' && mysqli_num_rows($sql2) > 0) {
echo '
';
echo '
';
echo '
';
$col = 1;
$tip_prev = 0;
$id_prev = 0;
while ($row2 = mysqli_fetch_array($sql2)) {
if ($id_prev == 0) $id_prev = $row2['id'];
if ($tip_prev != $row2['tip']) $col++;
$tip_prev = $row2['tip'];
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$rowl = \App\Controllers\LanguageController::srv_language_spremenljivka($row2['id']);
if (strip_tags($rowl['naslov']) != '') $row2['naslov'] = $rowl['naslov'];
}
echo '
';
?>
';
}
$id_prev = $row2['id'];
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
}
// Zadnja bela celica kjer se nahajajo ikone za mouseover
echo '
';
echo '
';
$bg++;
}
echo ' ';
echo '
';
}
//generira dropdown in menu za missinge
public function missings_menu($spremenljivka){
global $lang;
if($_GET['a'] !== 'komentarji' && $_GET['a'] !== 'komentarji_anketa'){
$row = Cache::srv_spremenljivka($spremenljivka);
$spremenljivkaParams = new enkaParameters($row['params']);
# preberemo missing vrednosti iz class.SurveyMissingValues - kateri so na voljo v anketi
$smv = new SurveyMissingValues($this->anketa);
$missing_values = $smv->GetUnsetValuesForSurvey();
# kateri missingi so nastavljeni
$already_set_mv = array();
$sql_grid_mv = sisplet_query("SELECT naslov, other FROM srv_vrednost WHERE spr_id='".$spremenljivka."' AND other != 0");
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
$already_set_mv[$row_grid_mv['other']] = $row_grid_mv['naslov'];
}
$missing_menu_items = '';
if (count($missing_values) > 0) {
foreach ($missing_values AS $mv_key => $mv_text) {
$missing_menu_items = '
';
// napaka v ifih
if ($code['type'] == 'if') {
$sql = sisplet_query("SELECT id, number FROM srv_if WHERE id = '$code[id]'");
$row = mysqli_fetch_array($sql);
$output .= '
';
}
// napaka v podifih, ki so nastavljeni na vrednosti spremenljivk
elseif ($code['type'] == 'podif') {
$sql = sisplet_query("SELECT id, naslov, variable FROM srv_spremenljivka WHERE id = '$code[id]'");
$row = mysqli_fetch_array($sql);
$output .= '
';
}
// napaka z imeni variabel
elseif ($code['type'] == 'variable') {
foreach ($code['vars'] AS $var) {
$output .= ''.$var.' ';
};
}
// napaka z vrednostmi v gridu
elseif ($code['type'] == 'grid_value') {
foreach ($code['vars'] AS $var) {
$output .= ''.$var.' ';
};
}
return $output;
}
/**
* preveri celo anketo, ce so loopi pravilno postavljeni
* gleda pa to, da loopi niso vgnezdeni en znotraj drugega
* za PB ne rabimo preverjat, ker se delajo ze sproti v check_loop()
*
*/
function check_loops () {
// vseeno se enkrat popravimo pagebreake...
$this->check_loop();
$sql = sisplet_query("SELECT b.element_spr, b.element_if FROM srv_branching b, srv_if i WHERE b.ank_id='$this->anketa' AND b.element_if > '0' AND b.element_if=i.id AND i.tip='2' ORDER BY b.vrstni_red ASC");
while ($row = mysqli_fetch_array($sql)) {
// trenutni loop ima nekega parenta ki je tudi loop
if ( $this->find_parent_loop($row['element_spr'], $row['element_if']) > 0 ) {
return array('type' => 'loop', 'code' => '6', 'id' => $row['element_if']);
}
}
return true;
}
/**
* preveri za celo anketo, če so vse validacije OK
*
*/
function check_validation () {
// najprej gremo cez vse ife
$sql = sisplet_query("SELECT if_id, spr_id FROM srv_validation v, srv_branching b WHERE v.spr_id=b.element_spr AND b.ank_id='$this->anketa' AND b.element_spr > 0 ORDER BY b.vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
$condition_check = $this->condition_check($row['if_id']);
if ($condition_check != 0) {
//$this->check_pogoji_id = $row['element_if'];
//return $condition_check;
return array('type' => 'validation', 'code' => $condition_check, 'id' => $row['spr_id']);
}
}
return true;
}
/**
* preveri, da se imena spremenljivk (vprašanj) v anketi in imena variabel znotraj vprasanja ne ponavljajo
*
*/
function check_variable () {
$spremenljivke = array();
$vrednosti = array();
$spr_errors = array();
$var_errors = array();
// Napolnimo array z vprasanji
$sql = sisplet_query("SELECT s.id, s.variable FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa'");
while ($row = mysqli_fetch_array($sql)) {
$spremenljivke[$row['id']] = $row['variable'];
// Napolnimo array z variablami znotraj vprasanj
$sqlV = sisplet_query("SELECT id, variable FROM srv_vrednost WHERE spr_id='".$row['id']."'");
while ($rowV = mysqli_fetch_array($sqlV)) {
$vrednosti[$row['id']][$rowV['id']] = $rowV['variable'];
}
}
$vars = array();
// Preverimo in izpišemo napake za imena vprasanj (spremenljivk)
if ( count($spremenljivke) != count(array_unique($spremenljivke)) ) {
$sql = sisplet_query("SELECT variable FROM srv_spremenljivka s, srv_grupa g WHERE gru_id=g.id and g.ank_id='$this->anketa' GROUP BY variable HAVING COUNT(variable) > 1");
while ($row = mysqli_fetch_array($sql)) {
$vars[] = $row['variable'];
}
$spr_errors['type'] = 'question_variable';
$spr_errors['code'] = '7';
$spr_errors['vars'] = $vars;
}
// Preverimo in izpišemo napake se za imena variabel znotraj vprasanj - ce je vklopljen modul kviz, dovolimo iste vrednosti
if(!SurveyInfo::getInstance()->checkSurveyModule('quiz')){
foreach($vrednosti as $spr_id => $vrednost){
if ( count($vrednost) != count(array_unique($vrednost)) ) {
$sql = sisplet_query("SELECT variable FROM srv_vrednost WHERE spr_id='".$spr_id."' GROUP BY variable HAVING COUNT(variable) > 1");
while ($row = mysqli_fetch_array($sql)) {
$vars[] = $spremenljivke[$spr_id] . ' - ' . $row['variable'];
}
$var_errors['type'] = 'variable';
$var_errors['code'] = '7';
$var_errors['vars'] = $vars;
}
}
}
if(count($var_errors))
return $var_errors;
return true;
}
/**
* preveri, da vrednosti gridov (multigrid vprasanja) v anketi niso prazne
*
*/
public function check_grid_value () {
$spr_errors = array();
$vars = array();
// Poiscemo gride, ki imajo prazno vrednost
$sql = sisplet_query("SELECT grid.vrstni_red, s.id AS spr_id, s.variable AS spr_variable
FROM srv_grid grid, srv_spremenljivka s, srv_grupa g
WHERE grid.spr_id=s.id AND s.gru_id=g.id AND g.ank_id='".$this->anketa."'
AND (grid.variable='' OR grid.variable=' ')
");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
$vars[] = $row['spr_variable'] . ' - ' . $row['vrstni_red'];
}
if(count($vars)){
$spr_errors['type'] = 'grid_value';
$spr_errors['code'] = '7';
$spr_errors['vars'] = $vars;
return $spr_errors;
}
return true;
}
/**
* @desc preveri ali je IF pravilno nastavljen
* error code: 0 - ok
* 1 - oklepaji so narobe
* 2 - spremenljivka ni postavljena
* 3 - spremenljivka nima vrednosti nastavljene
* 4 - number vrednost ni nastavljena
* 5 - kalkulacija ni v redu postavljena
* 6 - datum ni v pravilni obliki
*/
function condition_check ($if) {
$row = Cache::srv_if($if);
if ($row['tip'] == 1 || $row['tip'] == 2) return 0; // ce je blok je vse ok, ker ne more biti narobe nastavljen
if ( !$this->condition_check_bracket($if))
return 1;
if (!$this->condition_check_spremenljivka($if))
return 2;
if (!$this->condition_check_spremenljivka_vre($if))
return 3;
if (!$this->condition_check_number($if))
return 4;
if (!$this->condition_check_calculation($if))
return 5;
if (!$this->condition_check_date($if))
return 6;
if (!$this->condition_check_device($if))
return 7;
return 0;
}
/**
* za podani IF preveri, ce ima pravilno nastavljene vse kalkulacije
*
* @param int $if
*/
function condition_check_calculation ($if) {
$sql1 = Cache::srv_condition($if);
while($row1 = mysqli_fetch_array($sql1)) {
if ($row1['spr_id'] == '-2') {
if ( $this->calculation_check($row1['id']) != 0 )
return false;
}
}
return true;
}
/**
* @desc preveri ali so oklepaji pravilno postavljeni (presteje predoklepaje in zaklepaje)
*/
function condition_check_bracket ($if) {
//$sql = sisplet_query("SELECT * FROM srv_condition WHERE if_id='$if' ORDER BY vrstni_red");
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$bracket = 0;
while ($row = mysqli_fetch_array($sql)) {
$bracket = $bracket + $row['left_bracket'] - $row['right_bracket'];
if ($bracket < 0)
return false;
}
if ($bracket == 0)
return true;
else
return false;
}
/**
* @desc preveri ali imajo vsi pogoji izbrane spremenljivke
*/
function condition_check_spremenljivka ($if) {
//$sql = sisplet_query("SELECT * FROM srv_condition WHERE if_id='$if'");
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if (!($row['spr_id'] > 0 || $row['spr_id'] == -1 || $row['spr_id'] == -2 || $row['spr_id'] == -3 || $row['spr_id'] == -4))
return false;
}
return true;
}
/**
* @desc preveri ali imajo vse spremenljivke izbrane vrednosti
*/
function condition_check_spremenljivka_vre ($if) {
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['spr_id'] > 0) {
$row1 = Cache::srv_spremenljivka($row['spr_id']);
if ($row['vre_id'] == 0) {
if ($row1['tip'] <= 3) {
$sql2 = sisplet_query("SELECT * FROM srv_condition_vre WHERE cond_id='$row[id]'");
if (mysqli_num_rows($sql2) == 0)
return false;
}
} elseif ($row['vre_id'] > 0) {
// tabela radio, tabela checkbox
if ($row1['tip'] == 6 || $row1['tip'] == 16 || $row1['tip'] == 17) {
$sql2 = sisplet_query("SELECT * FROM srv_condition_grid WHERE cond_id='$row[id]'");
if (mysqli_num_rows($sql2) == 0)
return false;
// textbox
} else {
// ok... besedilo ima samo polje za vnos, ki pa je lahko prazno
}
}
}
}
return true;
}
/**
* @desc preveri ali imajo datumi pravilno obliko
*/
function condition_check_date ($if) {
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql))
{
if ($row['spr_id'] > 0)
{
$row1 = Cache::srv_spremenljivka($row['spr_id']);
if ($row1['tip'] == 8) {
if (empty($row['text']) || trim($row['text']) == '')
{
return false;
}
else if ((int)$row['text'] <= 0)
{
return false;
}
else
{
#preverimo obliko datuma
$fields = explode('.',$row['text']);
if (!is_numeric($fields[0]) || (int)$fields[0] == 0
|| !is_numeric($fields[1]) || (int)$fields[1] == 0
|| !is_numeric($fields[2]) || (int)$fields[2] == 0)
{
return false;
}
return checkdate((int)$fields[1],(int)$fields[0],(int)$fields[2]);
}
}
}
}
return true;
}
/**
* @desc preveri ali je naprava ustrezno nastavljena
*/
function condition_check_device ($if) {
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['spr_id'] == -4 && !in_array($row['text'], array('0','1','2','3'))){
return false;
}
}
return true;
}
/**
* @desc preveri ali imajo number polja z numeri�nim operatorjem vpisano �tevilko
*/
function condition_check_number ($if) {
// number
$sql = sisplet_query("SELECT c.* FROM srv_condition c, srv_spremenljivka s WHERE s.id=c.spr_id AND s.tip IN (7, 18, 20) AND c.if_id='$if'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ( ! (is_numeric($row['text']) || $row['text'] == '') )
return false;
}
// calculation
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['spr_id'] == -2) {
if (!is_numeric($row['text']))
return false;
}
}
return true;
}
/**
* @desc preveri ali so oklepaji pravilno postavljeni v kalkulacijah (presteje predoklepaje in zaklepaje)
* in pa ce je izbrana spremenljivka
*/
function calculation_check ($condition) {
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id='$condition' ORDER BY vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
if (mysqli_num_rows($sql) == 0) return 1; // ni sploh se izbrana spremenljivka (ker ni calculation sploh se inicializiran z default vrstico)
$bracket = 0;
while ($row = mysqli_fetch_array($sql)) {
if ($row['spr_id'] == 0) // ce ni izbrana spremenljivka v eni od vrstic
return 2;
$bracket = $bracket + $row['left_bracket'] - $row['right_bracket'];
if ($bracket < 0)
return 3; // oklepaj
}
if ($bracket == 0)
return 0; // vse ok
else
return 3; // zaklepaj
}
/**
* @desc izpise form za urejanje pogojev
* @param int ID ifa, ki mu urejamo pogoje
* @param int Pri urejanju podifov (na multigridih, radio,..) podamo tudi ID vrednosti na katero se if navezuje
*/
function condition_editing ($if, $vrednost=0, $edit_fill_value=0) {
global $lang;
// Pogoj na vrednost
if($vrednost > 0){
echo '
'; // -- div_condition_editing_float
}
// klasicen popup v #div_condition_editing, uporablja se npr pri ifih za obvescanje
elseif ($vrednost == -3) {
echo '
';
if (true) {
$sql = sisplet_query("SELECT count(*) AS count FROM srv_user WHERE ank_id='$this->anketa' AND deleted='0'");
$row = mysqli_fetch_array($sql);
if ($row['count'] > 10) {
?>vrstni_red($this->find_before_if($row['if_id']));
}
elseif ($vrednost == -1 or $vrednost == -2 or $vrednost == -3) { // filter v DisplayData.php (prikazemo vse spremenljivke)
$vrstni_red = PHP_INT_MAX;
}
elseif ($vrednost == -4) { // validacija
if (!$this->spremenljivka > 0) {
$sqlv = sisplet_query("SELECT spr_id FROM srv_validation WHERE if_id = '$row[if_id]'");
$rowv = mysqli_fetch_array($sqlv);
$this->spremenljivka = $rowv['spr_id'];
}
$vrstni_red = $this->vrstni_red($this->spremenljivka);
}
else { // ce imamo podif na vrednosti
$sqlv = sisplet_query("SELECT spr_id FROM srv_vrednost WHERE if_id='$row[if_id]'");
$rowv = mysqli_fetch_array($sqlv);
$vrstni_red = $this->vrstni_red($rowv['spr_id']);
}
$sql_count = sisplet_query("SELECT COUNT(*) AS count FROM srv_condition WHERE if_id='$row[if_id]'");
if (!$sql_count) die();
$row_count = mysqli_fetch_array($sql_count);
// form
echo '';
}
/**
* @desc napolni select z vrednostmi izbrane spremenljivke -- $vrednost je pa za multigrid
*/
function fill_value($condition, $spremenljivka, $vrednost, $grid=0, $edit_value = false) {
global $lang;
$sql = sisplet_query("SELECT * FROM srv_condition WHERE id='$condition'");
$row = mysqli_fetch_array($sql);
$row1 = Cache::srv_spremenljivka($spremenljivka);
// navadne spremenljivke (vkljucno z multigrid)
if ($spremenljivka > 0) {
$preview = '';
// zato, da z JS vemo kaj poslat po AJAXu, ID vrednosti ali text
echo '';
// operator
echo ' '."\n\r";
echo '
';
// number in textbox, vsota imajo textovni input (ter compute in kvota)
if ($row1['tip'] == 4 || $row1['tip'] == 21 || $row1['tip'] == 7 || $row1['tip'] == 22 || $row1['tip'] == 25 || $row1['tip'] == 18)
{
echo '';
echo '';
// select input za datum
} else if ( $row1['tip'] == 8){
echo '';
echo '';
// select input za spremenljivke
} else {
// obicajna spremenljivka
if ($vrednost <= 0) {
echo '';
$sql1 = sisplet_query("SELECT COUNT(*) AS count FROM srv_condition_vre WHERE cond_id='$condition'");
$row1 = mysqli_fetch_array($sql1);
echo ''.$lang['srv_note_vrednost'].':';
$sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id='$spremenljivka' ORDER BY vrstni_red ASC");
while ($row = mysqli_fetch_array($sql)) {
$sql1 = sisplet_query("SELECT * FROM srv_condition_vre WHERE cond_id='$condition' AND vre_id='$row[id]'");
if (mysqli_num_rows($sql1) > 0)
$selected = ' checked="checked"';
else
$selected = '';
echo '';
if ($selected != '')
$preview .= '('.$row['variable'].') '.strip_tags($row['naslov']).'';
}
// Ce je bilo vprasanje na prejsnji strani imamo tudi pogoj -1 (neodgovor)
$sqlC = sisplet_query("SELECT if_id FROM srv_condition WHERE id='$condition'");
$rowC = mysqli_fetch_array($sqlC);
$current_grupa = $this->getGrupa4If($rowC['if_id']);
$selected_grupa = $this->getGrupa4Spremenljivka($spremenljivka);
if(isset($selected_grupa['vrstni_red']) && isset($current_grupa['vrstni_red']) && $selected_grupa['vrstni_red'] != $current_grupa['vrstni_red']){
$sql1 = sisplet_query("SELECT * FROM srv_condition_vre WHERE cond_id='$condition' AND vre_id='-1'");
if (mysqli_num_rows($sql1) > 0)
$selected = ' checked="checked"';
else
$selected = '';
echo '';
if ($selected != '')
$preview .= '(-1) '.$lang['srv_mv_Ni odgovoril'].'';
}
echo '';
echo '
';
if ($spremenljivka > 0 && ($tip==2 ||$tip==3)) { // spremenljivka je izbrana in ne gre za sn-imena
if ($advanced) {
echo '
'.$lang['srv_loop_checked'].'
'.$lang['srv_loop_notchecked'].'
'.$lang['srv_loop_always'].'
'.$lang['srv_loop_never'].'
';
}
$sql2 = sisplet_query("SELECT id, naslov, variable, vrstni_red FROM srv_vrednost WHERE spr_id='$spremenljivka' ORDER BY vrstni_red ASC");
while ($row2 = mysqli_fetch_array($sql2)) {
$sql3 = sisplet_query("SELECT * FROM srv_loop_vre WHERE if_id='$if' AND vre_id='$row2[id]'");
$row3 = mysqli_fetch_array($sql3);
if ($advanced) {
if (mysqli_num_rows($sql3) == 0) $row3['tip'] = 3;
echo '
';
// Nastavitev, kako se obravnava missing v kalkulaciji (kot 0 ali za celo kalkulacijo kot -88)
$newParams = new enkaParameters($row['params']);
$calcMissing = $newParams->get('calcMissing', '0');
echo '
';
echo ' ';
echo '';
echo '
';
echo '
';
echo '
';
echo '
';
// kalkulacija kot spremenljivka (lahko jo zbrisemo)
if ($condition < 0)
echo ' ';
echo ' ';
echo ' ';
echo '
';
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$condition' ORDER BY vrstni_red");
if (mysqli_num_rows($sql) == 0) {
sisplet_query("INSERT INTO srv_calculation (id, cnd_id, vrstni_red) VALUES ('', '$condition', '1')");
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$condition' ORDER BY vrstni_red");
}
while ($row = mysqli_fetch_array($sql)) {
$this->calculation_edit($row['id'], $vrednost);
}
echo '
';
}
/**
* @desc vrstica v urejanju kalkulacij
*/
function calculation_edit ($calculation, $vrednost=0) {
global $lang;
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE id = '$calculation'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
$sql1 = sisplet_query("SELECT * FROM srv_condition WHERE id = '{$row['cnd_id']}'");
$row1 = mysqli_fetch_array($sql1);
if ($row['cnd_id'] > 0) { // kalkulacija znotraj pogoja
$vrstni_red = $this->vrstni_red($this->find_before_if($row1['if_id']));
} else { // kalkulacija kot spremenljivka
$vrstni_red = $this->vrstni_red(-$row['cnd_id']) - 1; // -1 je da ne prikaze se trenutne kalkulacije
}
$sql_count = sisplet_query("SELECT COUNT(*) AS count FROM srv_calculation WHERE cnd_id='$row[cnd_id]'");
if (!$sql_count) die();
$row_count = mysqli_fetch_array($sql_count);
// form
echo '';
}
/**
* @desc generira ime variable za novo spremenljivko
*/
function generate_variable ($preset = null) {
$variable_array = array();
// Dodaten loop po spremenljivkah, ki so znotraj kombinirane tabele (gru_id == -2)
$sql = sisplet_query("SELECT s.id AS id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip='24' ORDER BY g.vrstni_red, s.vrstni_red");
if(mysqli_num_rows($sql)){
while ($row = mysqli_fetch_array($sql)) {
$sqlM = sisplet_query("SELECT s.id, s.variable, s.variable_custom FROM srv_spremenljivka s, srv_grid_multiple m
WHERE m.parent='".$row['id']."' AND m.ank_id='$this->anketa' AND s.id=m.spr_id
ORDER BY m.vrstni_red");
while ($rowM = mysqli_fetch_array($sqlM)) {
$variable_array[$rowM['id']] = $rowM['variable'];
}
}
}
$sql = sisplet_query("SELECT s.id, variable, variable_custom FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip!='9' ORDER BY g.vrstni_red, s.vrstni_red");
while ($row = mysqli_fetch_array($sql)) {
$variable_array[$row['id']] = $row['variable'];
}
$i = 1;
do {
if ($preset === null) $preset = 'Q';
$variable = $preset . $i++;
$variable_ok = true;
foreach ($variable_array AS $spr => $var) {
if ($var == $variable) {
$variable_ok = false;
}
}
} while ( ! $variable_ok );
return $variable;
}
/**
* @desc preveri ime variable za novo spremenljivko in doda številko če je potrebno
*/
function append_variable ($variable) {
$variable_array = array();
$sql = sisplet_query("SELECT s.id, variable, variable_custom FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip!='9' ORDER BY g.vrstni_red, s.vrstni_red");
while ($row = mysqli_fetch_array($sql)) {
$variable_array[$row['id']] = $row['variable'];
}
if ( ! in_array($variable, $variable_array) )
return $variable;
$i = 1;
do {
$variable_new = $variable . $i++;
if ( ! in_array($variable_new, $variable_array) )
return $variable_new;
} while ( true );
}
/**
* @desc vpise novo spremenljivko v bazo (lahko je skopirana)
*
* kopiranje je urejeno, da deluje z bazo ver 10.11.24, za nadaljne spremembe je potrebno dodati samo nove tabele, ker se celotna vsebina obstojecih tabel kopira avtomatsko cela
*/
function nova_spremenljivka($grupa, $grupa_vrstni_red, $vrstni_red, $kuki = 0) {
global $lang;
if ($kuki == 0 && isset($_COOKIE['srv_clipboard_' . $this->anketa]))
$kuki = $_COOKIE['srv_clipboard_' . $this->anketa];
$variable = $this->generate_variable();
$variable_custom = 0;
// skopirali bomo spremenljivko
if ($kuki > 0) {
$spr = $kuki;
$row = Cache::srv_spremenljivka($spr);
if ($row['id'] != $spr) return;
// zakaj je bilo to ??
//$variable = $row['variable'] . '_' . $variable;
// pri sistemskih se variable ohrani, ker jih nekje identificiramo po variable-i
// in pri kopiranju iz in v knjiznico tudi
if ($row['sistem'] == 1) {
$variable = $row['variable'];
$variable_custom = $row['variable_custom'];
if ($grupa > 0) {
$variable = $this->append_variable($variable);
}
}
// kalkulacija ima svoj custom tip
if ($row['tip'] == 22) {
$sql1 = sisplet_query("SELECT s.variable FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip='22'");
if (!$sql1) echo 'err453'.mysqli_error($GLOBALS['connect_db']);
$c = 0;
while ($row1 = mysqli_fetch_array($sql1)) {
$row1['variable'] = (int)str_replace('C', '', $row1['variable']);
if ($row1['variable'] > $c)
$c = $row1['variable'];
}
$c++;
$variable = 'C'.$c;
}
// name generator
if ($row['tip'] == 9) {
$sql1 = sisplet_query("SELECT s.variable FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip='9'");
if (!$sql1) echo 'err453'.mysqli_error($GLOBALS['connect_db']);
$c = 0;
while ($row1 = mysqli_fetch_array($sql1)) {
$row1['variable'] = (int)str_replace('G', '', $row1['variable']);
if ($row1['variable'] > $c)
$c = $row1['variable'];
}
$c++;
$variable = 'G'.$c;
}
global $connect_db;
SurveyCopy::setSrcSurvey($this->anketa);
SurveyCopy::setSrcConectDb($connect_db);
SurveyCopy::setDestSite(0);
// spremenljivka
$qry_src_spremenljivka = sisplet_query("SELECT * FROM srv_spremenljivka WHERE id = '$row[id]'");
$pre_set = array( 'id' => "NULL",
'gru_id' => "'$grupa'",
'naslov' => "'".mysqli_real_escape_string($GLOBALS['connect_db'], $row['naslov'])."'",
'variable' => "'".mysqli_real_escape_string($GLOBALS['connect_db'], $variable)."'",
'variable_custom' => "'$variable_custom'",
'vrstni_red' => "'$vrstni_red'",
'thread' => "'0'",
'edit_graf' => "'0'", // naknadno popravimo editiranje grafov - po kopiranju je onemogoceno
);
$spr_array = SurveyCopy::preformCopyTable('srv_spremenljivka', 'id', SurveyCopy::sql2array($qry_src_spremenljivka), $pre_set);
$spremenljivka = $spr_array[$row['id']]; // vrne v obliki arraya [star_id] => [nov_id]
// if - podifi na vrednostih
$new_if_ids = array ();
$qry_src_vre_if = sisplet_query("SELECT * FROM srv_vrednost v WHERE v.if_id>0 AND v.spr_id='$spr'");
while ($row_vre_if = mysqli_fetch_array($qry_src_vre_if)) {
// IF-i, tabela srv_if
$qry_src_if_ = sisplet_query("SELECT * FROM srv_if WHERE id = '".$row_vre_if['if_id']."'");
//$qry_src_if = self::arrayfilter($arr_src['srv_if'], 'id', $row['id']);
$pre_set = array('id' => "NULL");
$tmp_if_ids = SurveyCopy::preformCopyTable('srv_if', 'id', SurveyCopy::sql2array($qry_src_if_), $pre_set);
$new_if_ids += $tmp_if_ids;
}
// vrednost
$qry_src_vrednost = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$spr' ORDER BY vrstni_red");
$pre_set = array( 'id' => "NULL",
'spr_id' => "'$spremenljivka'",
'if_id' => array('field'=>'if_id', 'from'=>$new_if_ids)
);
$tmp_vrednosti_ids = SurveyCopy::preformCopyTable('srv_vrednost', 'id', SurveyCopy::sql2array($qry_src_vrednost), $pre_set);
// maps - choose
if ($row['tip'] == 26 && $row['enota'] == 3){
$new_vrednosti_ids = array();
// shranimo stare in nove id-je spremenljivk
if ( count($tmp_vrednosti_ids) > 0 )
foreach ($tmp_vrednosti_ids as $key => $value)
$new_vrednosti_ids[$key] = $value;
$qry_src_vrednost_map = sisplet_query("SELECT * FROM srv_vrednost_map WHERE spr_id='$spr' ORDER BY vrstni_red");
$pre_set = array('id' => "NULL",
'spr_id' => "'$spremenljivka'",
'vre_id' => array('field'=>'vre_id', 'from'=>$new_vrednosti_ids));
SurveyCopy::preformCopyTable('srv_vrednost_map', 'id', SurveyCopy::sql2array($qry_src_vrednost_map), $pre_set);
}
// grid
$qry_src_grid = sisplet_query("SELECT * FROM srv_grid WHERE spr_id='$spr' ORDER BY id");
$pre_set = array( 'spr_id' => "'$spremenljivka'",
);
SurveyCopy::preformCopyTable('srv_grid', null, SurveyCopy::sql2array($qry_src_grid), $pre_set);
// srv_grid_multiple
$new_sub = array();
$sqlm = sisplet_query("SELECT * FROM srv_grid_multiple WHERE parent = '$spr'");
while ($rowm = mysqli_fetch_assoc($sqlm)) {
$new_sub[$rowm['spr_id']] = $this->nova_spremenljivka(-2, 0, 0, $rowm['spr_id']);
}
$qry_src_grid_multiple = sisplet_query("SELECT * FROM srv_grid_multiple WHERE parent='$spr' ORDER BY vrstni_red");
// Ce dodajamo kombinirano tabelo v knjiznico nastavimo ank_id v srv_grid_multiple na -1
$multiple_ank_id = ($grupa == -1) ? '-1' : $this->anketa;
$pre_set = array(
'ank_id' => $multiple_ank_id,
'parent' => "'$spremenljivka'",
'spr_id' => array('field'=>'spr_id','from'=>$new_sub),
);
SurveyCopy::preformCopyTable('srv_grid_multiple', null, SurveyCopy::sql2array($qry_src_grid_multiple), $pre_set);
// srv_condition
$qry_src_condition = sisplet_query("SELECT * FROM srv_condition WHERE if_id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT v.if_id FROM srv_vrednost v WHERE v.spr_id='$spr' AND v.if_id>0")).")");
if (!$qry_src_condition) echo mysqli_error($GLOBALS['connect_db']);
$pre_set = array('id' => "NULL",
'if_id' => array('field'=>'if_id', 'from'=>$new_if_ids)/*,
'spr_id' => array('field'=>'spr_id', 'from'=>$new_spremenljivke_ids),
'vre_id' => array('field'=>'vre_id', 'from'=>$new_vrednosti_ids)*/);
$condition = SurveyCopy::preformCopyTable('srv_condition', 'id', SurveyCopy::sql2array($qry_src_condition), $pre_set);
// condtition grid, tabela srv_condition_grid
if (is_countable($condition) && count($condition) > 0) {
foreach ($condition AS $orig => $bckp) {
// condtition grid, tabela srv_condition_grid
$qry_src_condition_grid = sisplet_query("SELECT * FROM srv_condition_grid WHERE cond_id = '".$orig."'");
//$src_srv_condition_grid = SurveyCopy::arrayfilter($arr_src['srv_condition_grid'], 'cond_id', $orig);
$pre_set = array('id'=>"NULL",
'cond_id' => "'".$bckp."'");
$new_condition_grid_ids = SurveyCopy :: preformCopyTable('srv_condition_grid', 'id', SurveyCopy::sql2array($qry_src_condition_grid), $pre_set);
}
}
// condtition vrednost, tabela srv_condition_vre
if (is_countable($condition) && count($condition) > 0) {
foreach ($condition AS $orig => $bckp) {
$qry_src_condition_vre = sisplet_query("SELECT * FROM srv_condition_vre WHERE cond_id = '$orig'");
//$src_srv_condition_vre = SurveyCopy::arrayfilter($arr_src['srv_condition_vre'], 'cond_id', $orig);
$pre_set = array('cond_id' => $bckp/*,
'vre_id' => array('field'=>'vre_id', 'from'=>$new_vrednosti_ids)*/);
SurveyCopy::preformCopyTable('srv_condition_vre', null, SurveyCopy::sql2array($qry_src_condition_vre), $pre_set);
}
}
// kopiranje kalkulacije
$sql2 = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '-$spr'");
if (!$sql2) echo mysqli_error($GLOBALS['connect_db']);
while ($row2 = mysqli_fetch_array($sql2)) {
$qry_src_calculation = sisplet_query("SELECT * FROM srv_calculation WHERE id = '$row2[id]'");
$pre_set = array( 'id' => "NULL",
'cnd_id' => "'-$spremenljivka'",
'spr_id' => "'".$this->if_copy_spremenljivka($row2['spr_id'])."'",
'vre_id' => "'".$this->if_copy_vrednost($row2['vre_id'])."'"
);
SurveyCopy::preformCopyTable('srv_calculation', null, SurveyCopy::sql2array($qry_src_calculation), $pre_set);
}
// kopiranje kalkulacije v podifu
$sql2 = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT c.id FROM srv_vrednost v, srv_condition c WHERE c.if_id=v.if_id AND v.if_id >0 AND v.spr_id='$spr'")).")");
if (!$sql2) echo mysqli_error($GLOBALS['connect_db']);
while ($row2 = mysqli_fetch_array($sql2)) {
$qry_src_calculation = sisplet_query("SELECT * FROM srv_calculation WHERE id = '$row2[id]'");
$pre_set = array( 'id' => "NULL",
'cnd_id' => array('field'=>'cnd_id', 'from'=>$condition)/*,
'spr_id' => "'".$this->if_copy_spremenljivka($row2['spr_id'])."'",
'vre_id' => "'".$this->if_copy_vrednost($row2['vre_id'])."'"*/
);
SurveyCopy::preformCopyTable('srv_calculation', null, SurveyCopy::sql2array($qry_src_calculation), $pre_set);
}
}
// nova (prazna) spremenljivka
else {
// pri glasovanju ustvarimo samo prvic novo spr. z default 2 variablami
if(isset($_POST['survey_type']) && $_POST['survey_type'] == 0)
$size = 2;
else
$size = 3;
$sql = sisplet_query("INSERT INTO srv_spremenljivka (id, gru_id, naslov, variable, size, vrstni_red) VALUES ('', '$grupa', '
$lang[srv_new_vprasanje]
', '$variable', '$size', '$vrstni_red')");
if (!$sql)
echo mysqli_error($GLOBALS['connect_db']);
$spremenljivka = mysqli_insert_id($GLOBALS['connect_db']);
}
// vnesemo -4 tag v podatke, ki oznacuje novo spremenljivko
$sql = sisplet_query("SELECT id FROM srv_user WHERE ank_id = '$this->anketa'");
$query_values = "";
while ($row = mysqli_fetch_array($sql)) {
if($query_values != "") $query_values .= ", ";
$query_values .= " ('$spremenljivka', '-4', '$row[id]') ";
}
if (mysqli_num_rows($sql) > 0)
sisplet_query("INSERT INTO srv_data_vrednost".$this->db_table." (spr_id, vre_id, usr_id) VALUES $query_values");
// Preverimo ce smo presegli limit za stevilo vprasanj
$check = new SurveyCheck($this->anketa);
$check->checkLimitSpremenljivke();
return $spremenljivka;
}
/**
* @desc ustvari nov IF (lahko je skopiran)
*/
function if_new ($endif, $parent, $if_id, $vrstni_red, $spremenljivka, $if, $copy=0, $no_content=0, $include_element=true) {
$cookie = 0;
if ($copy > 0)
$cookie = $copy;
elseif(isset($_COOKIE['srv_clipboard_'.$this->anketa]))
$cookie = substr($_COOKIE['srv_clipboard_'.$this->anketa], 3);
// Dodaten pogoj da nikoli ne vstavimo v srv_branching elementa ki ima element_spr=0 in element_if=0 (potem lahko pride do neskoncnega loopa kjer se dodajajo grupe v anketo)
if ($if_id == 0) die('copy error2');
// skopiran if
if ($cookie > 0 && $this->if_copy_check($parent, $cookie)) {
sisplet_query("UPDATE srv_branching SET vrstni_red=vrstni_red+1 WHERE parent='$parent' AND vrstni_red>='$vrstni_red' AND ank_id='$this->anketa'");
sisplet_query("INSERT INTO srv_branching (ank_id, parent, element_spr, element_if, vrstni_red) VALUES ('$this->anketa', '$parent', '0', '$if_id', '$vrstni_red')");
$this->if_copy($if_id, $cookie, false, $no_content);
// ob pastanju zbrisemo clipboard
setcookie('srv_clipboard_'.$this->anketa, '', time()-3600);
}
// navaden nov if (pri ENDIFu je nov if prazen, zato ne dodamo nicesar)
else {
$s = sisplet_query("INSERT INTO srv_condition (id, if_id, vrstni_red) VALUES ('', '$if_id', '1')");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
if (!$include_element) { // ce vstavimo if, moramo vrstne rede ostalih povecati (sicer pa ne, ker 1 element postavimo v IF)
sisplet_query("UPDATE srv_branching SET vrstni_red=vrstni_red+1 WHERE parent='$parent' AND vrstni_red >= '$vrstni_red' AND ank_id='$this->anketa'");
}
sisplet_query("INSERT INTO srv_branching (ank_id, parent, element_spr, element_if, vrstni_red) VALUES ('$this->anketa', '$parent', '0', '$if_id', '$vrstni_red')");
if ( $include_element && ($spremenljivka > 0 || $if > 0) ) {
// v if dodamo se spremenljivko oz if (karkoli je bilo pod crto)
sisplet_query("UPDATE srv_branching SET parent='$if_id', vrstni_red='1' WHERE element_spr='$spremenljivka' AND element_if='$if' AND ank_id='$this->anketa'");
}
}
$this->repare_branching($parent);
}
/**
* @desc preverimo da ne kopiramo v isti IF (ker se rekurzivno kopira naprej zarad algoritma)
* @param parent od elementa kamor kopiramo
* @param if iz katerega bomo kopiral (v kukiju)
*/
function if_copy_check($parent, $kuki) {
if ($parent == $kuki)
return false;
if ($parent == 0)
return true;
$sql = sisplet_query("SELECT parent FROM srv_branching WHERE element_if='$parent' AND ank_id='$this->anketa'");
$row = mysqli_fetch_array($sql);
if ($row['parent'] > 0)
if (!$this->if_copy_check($row['parent'], $kuki))
return false;
return true;
}
/**
* @desc skopira vsebino enega ifa v drugega
*
* kopiranje je urejeno, da deluje z bazo ver 10.11.24, za nadaljne spremembe je potrebno dodati samo nove tabele, ker se celotna vsebina obstojecih tabel kopira avtomatsko cela
*
* @param if v katerega bomo kopiral
* @param if iz katerega bomo kopiral
* @param library pove, ce kopiramo v knjiznico, da ima ank_id -1
*/
function if_copy($if, $if_copied, $library=false, $no_content=0) {
// ce kopiramo v knjiznico, tukaj nardimo nov if
if ($if == 0) {
$sql = sisplet_query("INSERT INTO srv_if (id) VALUES ('')");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$if = mysqli_insert_id($GLOBALS['connect_db']);
}
// popravimo if, ki je bil skreiran ze v funkciji ajax
$sql = sisplet_query("SELECT * FROM srv_if WHERE id = '$if_copied'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
$s = sisplet_query("SHOW columns FROM srv_if");
$update = '';
while ($r = mysqli_fetch_array($s)) {
if ($r['Field'] != 'id' && $r['Field'] != 'folder') {
if ($update != '') $update .= ',';
$update .= $r['Field']." = '".$row[$r['Field']]."' ";
}
}
sisplet_query("UPDATE srv_if SET $update WHERE id = '$if'");
global $connect_db;
SurveyCopy::setSrcSurvey($this->anketa);
SurveyCopy::setSrcConectDb($connect_db);
SurveyCopy::setDestSite(0);
// skopiramo pogoje
$sql = Cache::srv_condition($if_copied);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
$qry_src_condition = sisplet_query("SELECT * FROM srv_condition WHERE id = '$row[id]'");
$pre_set = array( 'id' => "NULL",
'if_id' => "'$if'",
'spr_id' => "'".$this->if_copy_spremenljivka($row['spr_id'])."'"
);
$cond_array = SurveyCopy::preformCopyTable('srv_condition', 'id', SurveyCopy::sql2array($qry_src_condition), $pre_set);
$cond_id = $cond_array[$row['id']];
$vre_id = array();
$sql2 = sisplet_query("SELECT * FROM srv_condition_vre WHERE cond_id = '$row[id]'");
while ($row2 = mysqli_fetch_array($sql2)) {
$vre_id[$row2['vre_id']] = $this->if_copy_vrednost($row2['vre_id']);
}
if (mysqli_num_rows($sql2) > 0) mysqli_data_seek($sql2, 0);
$pre_set = array( 'cond_id' => "'$cond_id'",
'vre_id' => array('field'=>'vre_id', 'from'=>$vre_id)
);
SurveyCopy::preformCopyTable('srv_condition_vre', null, SurveyCopy::sql2array($sql2), $pre_set);
$sql2 = sisplet_query("SELECT * FROM srv_condition_grid WHERE cond_id = '$row[id]'");
$pre_set = array( 'cond_id' => "'$cond_id'",
);
SurveyCopy::preformCopyTable('srv_condition_grid', null, SurveyCopy::sql2array($sql2), $pre_set);
$sql2 = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$row[id]'");
while ($row2 = mysqli_fetch_array($sql2)) {
$vre_id[$row2['vre_id']] = $this->if_copy_vrednost($row2['vre_id']);
}
if (mysqli_num_rows($sql2) > 0) mysqli_data_seek($sql2, 0);
$pre_set = array( 'id' => "NULL",
'cnd_id' => "'$cond_id'",
'spr_id' => array('field'=>'spr_id', 'from'=>$this->if_copy_spremenljivke),
'vre_id' => array('field'=>'vre_id', 'from'=>$vre_id)
);
SurveyCopy::preformCopyTable('srv_calculation', null, SurveyCopy::sql2array($sql2), $pre_set);
}
$vre_id = array();
// zanka
// srv_loop
$qry_src_loop = sisplet_query("SELECT * FROM srv_loop WHERE if_id = '$if_copied'");
$pre_set = array( 'if_id' => "'$if'",
'spr_id' => array('field'=>'spr_id','from'=>$this->if_copy_spremenljivke)
);
SurveyCopy::preformCopyTable('srv_loop', null, SurveyCopy::sql2array($qry_src_loop), $pre_set);
// srv_loop_vre
$qry_src_loop_vre = sisplet_query("SELECT * FROM srv_loop_vre WHERE if_id = '$if_copied'");
while ($row2 = mysqli_fetch_array($qry_src_loop_vre)) {
$vre_id[$row2['vre_id']] = $this->if_copy_vrednost($row2['vre_id']);
}
if (mysqli_num_rows($qry_src_loop_vre) > 0) mysqli_data_seek($qry_src_loop_vre, 0);
$pre_set = array( 'if_id' => "'$if'",
'vre_id' => array('field'=>'vre_id','from'=>$vre_id)
);
SurveyCopy::preformCopyTable('srv_loop_vre', null, SurveyCopy::sql2array($qry_src_loop_vre), $pre_set);
// srv_loop_data
$qry_src_loop_data = sisplet_query("SELECT * FROM srv_loop_data WHERE if_id = '$if_copied'");
while ($row2 = mysqli_fetch_array($qry_src_loop_data)) {
$vre_id[$row2['vre_id']] = $this->if_copy_vrednost($row2['vre_id']);
}
if (mysqli_num_rows($qry_src_loop_data) > 0) mysqli_data_seek($qry_src_loop_data, 0);
$pre_set = array( 'id' => "NULL",
'if_id' => "'$if'",
'vre_id' => array('field'=>'vre_id','from'=>$vre_id)
);
SurveyCopy::preformCopyTable('srv_loop_data', 'id', SurveyCopy::sql2array($qry_src_loop_data), $pre_set);
// ali kopiramo tudi vsebino ifa
if ($no_content != 1) {
// gremo cez njegove childe in jih kopiramo
$sql = sisplet_query("SELECT * FROM srv_branching WHERE parent = '$if_copied' ORDER BY vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$values = '';
while ($row = mysqli_fetch_array($sql)) {
if ($library) // ce kopiramo v library
$anketa = -1;
elseif ($row['ank_id'] == -1) // ce kopiramo iz librarija v anketo
$anketa = $this->anketa;
else
$anketa = $row['ank_id'];
// element je spremenljivka -- kreiramo novo spremenljivko
if ($row['element_spr'] > 0) {
// Dobimo id strani
$sqlGrupa = sisplet_query("SELECT g.id, g.vrstni_red FROM srv_grupa g, srv_spremenljivka s WHERE s.id='".$row['element_if']."' AND s.gru_id=g.id");
if (!$sqlGrupa) echo mysqli_error($GLOBALS['connect_db']);
$rowGrupa = mysqli_fetch_array($sqlGrupa);
//$element_spr = $this->nova_spremenljivka($anketa, 0, $row['vrstni_red'], $row['element_spr']);
$element_spr = $this->nova_spremenljivka($rowGrupa['id'], $rowGrupa['vrstni_red'], $row['vrstni_red'], $row['element_spr']);
$element_if = 0;
$this->if_copy_spremenljivke[$row['element_spr']] = $element_spr;
// element je if --
} elseif ($row['element_if'] > 0) {
$sql1 = sisplet_query("SELECT * FROM srv_if WHERE id = '".$row['element_if']."'");
if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
$row1 = mysqli_fetch_array($sql1);
$sql2 = sisplet_query("INSERT INTO srv_if (id, label) VALUES ('', '".$row1['label']."')");
$element_spr = 0;
$element_if = mysqli_insert_id($GLOBALS['connect_db']);
// skopiramo rekurzivno se podif
$this->if_copy($element_if, $row['element_if'], $library);
}
$sql3 = sisplet_query("SELECT * FROM srv_branching WHERE ank_id='".$row['ank_id']."' AND parent='".$row['parent']."' AND element_spr='".$row['element_spr']."' AND element_if='".$row['element_if']."'");
$pre_set = array( 'ank_id' => "'$anketa'",
'parent' => "'$if'",
'element_spr' => "'$element_spr'",
'element_if' => "'$element_if'"
);
SurveyCopy::preformCopyTable('srv_branching', null, SurveyCopy::sql2array($sql3), $pre_set);
}
}
return $if; // to je ko kopiramo v library, da dobimo ID ifa
}
private $if_copy_spremenljivke = array(); // povezave originalnih spremenljivk s skopiranimi (da lahko spremenimo pogoje)
/**
* @desc za podano spremenljivko vrne skopirano spremenljivko, ce smo jo skopiral. ce ne, vrne original
*/
function if_copy_spremenljivka ($spr) {
if ($spr < 0)
return $spr;
if (isset($this->if_copy_spremenljivke[$spr]) && $this->if_copy_spremenljivke[$spr] > 0)
return $this->if_copy_spremenljivke[$spr];
$sql = sisplet_query("SELECT g.ank_id FROM srv_spremenljivka s, srv_grupa g WHERE s.id = '$spr' AND s.gru_id=g.id");
$row = mysqli_fetch_array($sql);
if ($row['ank_id'] == $this->anketa)
return $spr;
return 0;
}
/**
* @desc za podano vrednost v (podani) spremenljivki vrne skopirano vrednost (skopirane spremenljivke)
* ce ni bila skopirana v tej rundi vrne original (to pomeni, da se if nanasa na spremenljivko izven bloka ki se kopira)
*/
function if_copy_vrednost ($vre) {
$sql = sisplet_query("SELECT spr_id, vrstni_red FROM srv_vrednost WHERE id = '$vre'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
$spr_copy = (isset($this->if_copy_spremenljivke[$row['spr_id']])) ? $this->if_copy_spremenljivke[$row['spr_id']] : 0;
if ($spr_copy > 0) {
$vrstni_red = $row['vrstni_red'];
$sql = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$spr_copy' AND vrstni_red = '$vrstni_red'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
return $row['id'];
}
else {
$sql = sisplet_query("SELECT g.ank_id FROM srv_vrednost v, srv_spremenljivka s, srv_grupa g WHERE v.id='$vre' AND v.spr_id=s.id AND s.gru_id=g.id");
$row = mysqli_fetch_array($sql);
if ($row['ank_id'] == $this->anketa)
return $vre;
else
return 0;
}
}
/**
* @desc preveri ali lahko droppamo spremenljivko na to mesto (da se ne unicijo pogoji)
* @param spremenljivka ki jo droppamo
* @param parent kamor smo droppal spremenljivko
* @param vrstni_red znotraj parenta kamor smo droppal
* Pogledamo kam bo padla spremenljivka in potem za vse pogoje pred novo pozicijo spremenljivke
* preverimo, da nimajo v condition-u te spremenljivke
*/
function check_dropped_spremenljivka ($spremenljivka, $parent, $vrstni_red) {
// vrstni red kam bo prisla spremenljivka
$vrstni_red = $this->check_vrstni_red($parent, $vrstni_red);
$sql = sisplet_query("SELECT i.id, i.tip FROM srv_branching b, srv_if i WHERE i.id=b.element_if AND b.element_if > '0' AND b.ank_id='$this->anketa' ORDER BY b.vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
// ce je pogoj pred novo pozicijo spremenljivke
if ($this->vrstni_red_branching($row['id']) <= $vrstni_red)
if ($row['tip'] == 0) { // if
if (!$this->check_if($row['id'], $spremenljivka))
return false;
} elseif ($row['tip'] == 2) { // zanka
if (!$this->check_loop_spremenljivka($row['id'], $spremenljivka))
return false;
}
}
return true;
}
/**
* @desc preveri ali lahko droppamo if na to mesto (da se ne unicijo pogoji)
* Najprej poiscemo novo pozicijo IFa in potem za vse spremenljivke za novo pozicijo pogoja (in pred staro)
* preverimo da ni spremenljivka v katerem od pogojev IFa (in tudi podifov tega IFa)
* Potem pa se za vse IFe pred droppanim IFom preverimo, da nimajo v pogoju kaksne spremenljivke
* iz droppanga IFa
*/
function check_dropped_if ($if, $parent, $vrstni_red) {
// vrstni red kam bo prsu if
$vrstni_red = $this->check_vrstni_red($parent, $vrstni_red);
// spremenljivke za IFom
foreach ($this->get_subifs($if) AS $ifs) {
//echo $ifs.': ';
$sql = sisplet_query("SELECT tip FROM srv_if WHERE id = '$ifs'");
$row = mysqli_fetch_array($sql);
$tip = $row['tip'];
$sql = sisplet_query("SELECT element_spr FROM srv_branching WHERE element_spr > '0' AND ank_id='$this->anketa' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
// ce je spremenljivka za novo pozicijo ifa (in pred staro)
if ($this->vrstni_red_branching(0, $row['element_spr']) > $vrstni_red &&
$this->vrstni_red_branching(0, $row['element_spr']) < $this->vrstni_red_branching($if))
if ($tip == 0) { // if
if (!$this->check_if($ifs, $row['element_spr']))
return false;
} elseif ($tip == 2) { // zanka
if (!$this->check_loop_spremenljivka($ifs, $row['element_spr']))
return false;
}
}
}
// IFi pred droppanim IFom
$sql = sisplet_query("SELECT element_if FROM srv_branching WHERE element_if > '0' AND ank_id='$this->anketa' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
// gledamo samo za tiste IFe, ki niso vgnezdeni v droppanem IFu
if (!in_array($row['element_if'], $this->get_subifs($if)))
// ce je pogoj pred novo pozicijo droppanga ifa
if ($this->vrstni_red_branching($row['element_if']) <= $vrstni_red)
foreach ($this->get_subspr($if) AS $spr)
if (!$this->check_if($row['element_if'], $spr))
return false;
}
return true;
}
/**
* @desc poisce vrstni red kamor bo paddel dropped element
*/
function check_vrstni_red ($parent, $vrstni_red) {
// spustil smo na prvi element v IFu (ki ima vrstni red 0)
if ($vrstni_red == 0) {
return $this->vrstni_red_branching($parent);
} else {
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$parent' AND ank_id='$this->anketa' AND vrstni_red='$vrstni_red'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
// spustil smo pod spremenljivko
if ($row['element_spr'] > 0) {
return $this->vrstni_red_branching(0, $row['element_spr']);
// spustil smo pod ENDIF, zato poiscemo zadnji element v ifu (ker je isti globalni vrstni red -- endif nima vpliva)
// oz. ce je ta IF prazen poiscemo kar vrstni red tega IFa
} else {
return $this->find_last_elm_in_if($row['element_if']);
}
}
}
/**
* @desc preveri, da ni spremenljivka v pogoju IFa. Vrne true, ce spremenljivke ni med pogoji
*/
function check_if ($if, $spremenljivka) {
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['spr_id'] == $spremenljivka)
return false;
}
return true;
}
/**
* preveri, da spremenljivka ni nastavljena, da se loopa po njej v zanki
*
* @param mixed $if
* @param mixed $spremenljivka
*/
function check_loop_spremenljivka ($if, $spremenljivka) {
$sql = sisplet_query("SELECT if_id, spr_id FROM srv_loop WHERE if_id = '$if'");
$row = mysqli_fetch_array($sql);
if ($row['spr_id'] == $spremenljivka) return false;
return true;
}
/**
* @desc vrne vse podife podanega ifa (vkljucno s podanim ifom)
*/
function get_subifs ($if) {
$array = array();
array_push($array, $if);
$sql = sisplet_query("SELECT element_if FROM srv_branching WHERE parent = '$if' AND ank_id='$this->anketa' ORDER BY vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_if'] > 0) {
foreach ($this->get_subifs($row['element_if']) AS $key)
array_push($array, $key);
}
}
return $array;
}
/**
* @desc vrne array vseh spremenljivk vgnezdenih v podanem ifu
*/
function get_subspr ($if) {
$array = array();
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent = '$if' AND ank_id='$this->anketa' ORDER BY vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0)
array_push($array, $row['element_spr']);
else
foreach ($this->get_subspr($row['element_if']) AS $key)
array_push($array, $key);
}
return $array;
}
/**
* @desc popravi vrstne rede v obicajnem urejanju (srv_spremenljivka) ob premikanju v branchingu (srv_branching)
*/
var $spremenljivka_grupa = null; // cache trenutnih vrednosti, da izvedemo query, samo pri tistih, kjer je razlika
var $repare_vrstni_red_values = ''; // kesiramo update query, da se tudi pri rekurzivnih klicih te funkcije, izvede samo 1x
function repare_vrstni_red ($parent=0, $spr_vr=1, $gru_vr=1) {
if ($parent == 0) sisplet_query("BEGIN");
// preberemo cel branching, ker dostopamo iz $this->pagebreak();
if ($parent == 0)
Cache::cache_all_srv_branching($this->anketa);
if ($this->spremenljivka_grupa == null) {
$sql = sisplet_query("SELECT s.id, s.gru_id, s.vrstni_red FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa'");
while ($row = mysqli_fetch_array($sql)) {
$a = array('vrstni_red' => $row['vrstni_red'], 'gru_id' => $row['gru_id']);
$this->spremenljivka_grupa[$row['id']] = $a;
}
}
// gremo cez vse v srv_branching
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE ank_id='$this->anketa' AND parent='$parent' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$values = "";
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0) {
$gru_id = $this->find_grupa($gru_vr);
if (!isset($this->spremenljivka_grupa[$row['element_spr']]) || $this->spremenljivka_grupa[$row['element_spr']]['vrstni_red'] != $spr_vr || $this->spremenljivka_grupa[$row['element_spr']]['gru_id'] != $gru_id) {
if ( $gru_id > 0 ) {
sisplet_query("UPDATE srv_spremenljivka SET vrstni_red = '$spr_vr', gru_id='$gru_id' WHERE id = '$row[element_spr]'");
if ($values != "") $values .= ", ";
$values .= "('$row[element_spr]', '$gru_id', '$spr_vr')";
}
}
// ce je za njim pagebreak, poiscemo novo grupo
if ($this->pagebreak($row['element_spr'])) {
$gru_vr++;
$spr_vr = 1;
// naslednja spremenljivka je na isti strani
} else {
$spr_vr++;
}
} else if ($row['element_if'] > 0){
// rekurzivni klic iste funckije, ki gre cez ife
$arr = $this->repare_vrstni_red($row['element_if'], $spr_vr, $gru_vr);
$spr_vr = $arr[0];
$gru_vr = $arr[1];
}
}
if ($this->repare_vrstni_red_values != "" && $values != "") $this->repare_vrstni_red_values .= ",";
$this->repare_vrstni_red_values .= $values;
if ($this->repare_vrstni_red_values != "" && $parent == 0) {
//$s = sisplet_query("INSERT INTO srv_spremenljivka (id, gru_id, vrstni_red) VALUES ".$this->repare_vrstni_red_values." ON DUPLICATE KEY UPDATE gru_id=VALUES(gru_id), vrstni_red=VALUES(vrstni_red)");
//if (!$s) echo 'e007'.mysqli_error($GLOBALS['connect_db']);
}
if ($parent == 0) sisplet_query("COMMIT");
$a = Array($spr_vr, $gru_vr);
return $a;
}
/**
* @desc poisce grupo s podanim vrstnim redom
*/
var $find_grupa = array();
function find_grupa ($gru_vr) {
global $lang;
if (isset($this->find_grupa[$gru_vr])) {
return $this->find_grupa[$gru_vr];
}
$sql = sisplet_query("SELECT id FROM srv_grupa WHERE ank_id='$this->anketa' AND vrstni_red = '$gru_vr'");
$row = mysqli_fetch_array($sql);
if ($row['id'] > 0) {
$this->find_grupa[$gru_vr] = $row['id'];
return $this->find_grupa[$gru_vr];
}
$sql = sisplet_query("INSERT INTO srv_grupa (ank_id, naslov, vrstni_red) VALUES ('$this->anketa', '$lang[srv_stran] $gru_vr', '$gru_vr')");
$this->find_grupa[$gru_vr] = mysqli_insert_id($GLOBALS['connect_db']);
// Ce dodamo 4. stran vklopimo progress indicator (pri 3 straneh ali manj je po default izklopljen)
$sql2 = sisplet_query("SELECT id FROM srv_grupa WHERE ank_id='$this->anketa'");
$vrstni_red = mysqli_num_rows($sql2);
if($vrstni_red == 4){
$sqlP = sisplet_query("UPDATE srv_anketa SET progressbar='1' WHERE id='$this->anketa'");
}
return $this->find_grupa[$gru_vr];
}
/**
* @desc odstrani prazne grupe (strani) na koncu ankete
*/
function trim_grupe () {
// pogledamo, ce je zadnja grupa prazna in nato rekurzivno klicemo funkcijo dokler so prazne
$sqlG = sisplet_query("SELECT id FROM srv_grupa WHERE ank_id='$this->anketa' ORDER BY vrstni_red DESC");
// Ce imamo samo se 1 grupo je ne smemo pobrisati - izstopni pogoj
if(mysqli_num_rows($sqlG) > 1){
$rowG = mysqli_fetch_array($sqlG);
$sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE gru_id = '$rowG[id]'");
if (mysqli_num_rows($sql) == 0) {
sisplet_query("DELETE FROM srv_grupa WHERE id = '$rowG[id]'");
$this->trim_grupe();
}
}
}
/**
* zgenerira strukturo za hitrejse delovanje find_next_spr() in find_prev_spr()
* TODO - ni v uporabi...
*/
private $find_all_spr = null;
function find_all_spremenljivka () {
$sql = sisplet_query("SELECT s.id AS id, g.naslov AS grupa_naslov FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' ORDER BY g.vrstni_red, s.vrstni_red");
while ($row = mysqli_fetch_assoc($sql)) {
$this->find_all_spr[$row['id']] = $row;
}
}
/**
* @desc poisce naslednjo spremenljivko za podano spremenljivko
*/
function find_next_spr ($spremenljivka) {
$sql = sisplet_query("SELECT vrstni_red, gru_id FROM srv_spremenljivka WHERE id = '$spremenljivka'");
$row = mysqli_fetch_array($sql);
$vrstni_red = $row['vrstni_red'];
// naslednij je na isti strani
$next = $vrstni_red + 1;
$sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE vrstni_red='$next' AND gru_id='$row[gru_id]'");
if (mysqli_num_rows($sql) > 0) {
$row = mysqli_fetch_array($sql);
return $row['id'];
}
// naslednik je na naslednji strani
$sql = sisplet_query("SELECT g.vrstni_red FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND s.id='$spremenljivka'");
$row = mysqli_fetch_array($sql);
$grupa_red = $row['vrstni_red'];
$next = $grupa_red + 1;
$sql2 = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND g.vrstni_red = '$next' ORDER BY s.vrstni_red ASC LIMIT 1");
$row2 = mysqli_fetch_array($sql2);
if(isset($row2['id']))
return $row2['id'];
return 0;
}
/**
* @desc poisce predhodnjo spremenljivko za podano spremenljivko
*/
var $find_prev_spr = array();
function find_prev_spr ($spremenljivka) {
if (array_key_exists($spremenljivka, $this->find_prev_spr)) {
return $this->find_prev_spr[$spremenljivka];
}
$sql = sisplet_query("SELECT vrstni_red, gru_id FROM srv_spremenljivka WHERE id = '$spremenljivka'");
$row = mysqli_fetch_array($sql);
$vrstni_red = $row['vrstni_red'];
// predhodnik je na isti strani
$prev = $vrstni_red - 1;
$sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE vrstni_red='$prev' AND gru_id='$row[gru_id]'");
if (mysqli_num_rows($sql) > 0) {
$row = mysqli_fetch_array($sql);
$this->find_prev_spr[$spremenljivka] = $row['id'];
return $row['id'];
}
// predhodnik je na prejsnji strani
$sql = sisplet_query("SELECT g.vrstni_red FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND s.id='$spremenljivka'");
$row = mysqli_fetch_array($sql);
$grupa_red = $row['vrstni_red'];
$prev = $grupa_red - 1;
$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND g.vrstni_red = '$prev' ORDER BY s.vrstni_red DESC LIMIT 1");
if(mysqli_num_rows($sql) > 0){
$row = mysqli_fetch_array($sql);
$this->find_prev_spr[$spremenljivka] = $row['id'];
return $row['id'];
}
return 0;
}
var $prev_srv_branching = 0; // zacasna spremenljivka
/**
* poisce predhodnjo spremenljivko v srv_branching tabeli
*
* @param mixed $spremenljivka
*/
function find_prev_spr_branching ($spremenljivka, $parent=0) {
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE ank_id='$this->anketa' AND parent='$parent' ORDER BY vrstni_red ASC");
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0) {
if ($row['element_spr'] == $spremenljivka) return $this->prev_srv_branching;
$this->prev_srv_branching = $row['element_spr'];
} else {
$r = $this->find_prev_spr_branching($spremenljivka, $row['element_if']);
if ($r > 0) return $r;
}
}
return 0;
}
/**
* @desc Poisce zadnjo spremenljivko v anketi
*/
var $find_last_spr = 0;
function find_last_spr () {
if ($this->find_last_spr > 0)
return $this->find_last_spr;
$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' ORDER BY g.vrstni_red DESC, s.vrstni_red DESC LIMIT 1");
if ( mysqli_num_rows($sql) > 0 ){
$row = mysqli_fetch_array($sql);
$this->find_last_spr = $row['id'];
return $row['id'];
}
return 0;
}
/**
* poisce zadnjo spremenljivko v tabeli srv_branching
*
*/
function find_last_spr_branching ($parent = 0) {
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE ank_id='$this->anketa' AND parent='$parent' ORDER BY vrstni_red DESC LIMIT 1");
if ( mysqli_num_rows($sql) > 0 ){
$row = mysqli_fetch_array($sql);
if ($row['element_spr'] > 0)
return $row['element_spr'];
else
return $this->find_last_spr_branching($row['element_if']);
}
return 0;
}
/**
* poisce zadnji if v tabeli srv_branching
*
*/
private function find_last_if_branching ($parent = 0) {
$sql = sisplet_query("SELECT element_if FROM srv_branching WHERE ank_id='$this->anketa' AND parent='$parent' ORDER BY vrstni_red DESC LIMIT 1");
if ( mysqli_num_rows($sql) > 0 ){
$row = mysqli_fetch_array($sql);
return $row['element_if'];
}
return 0;
}
/**
* vrne array grupe za podano spremenljivko
*
* @param mixed $spremenljivka
* @return array
*/
function getGrupa4Spremenljivka($spremenljivka) {
$sql = sisplet_query("SELECT g.* FROM srv_grupa AS g WHERE g.id = (SELECT s.gru_id FROM srv_spremenljivka as s WHERE s.id = '$spremenljivka')");
if ( mysqli_num_rows($sql) > 0 ){
$row = mysqli_fetch_assoc($sql);
return $row;
}
return 0;
}
/**
* vrne array grupe za podan if
*
* @param mixed $if_id
* @return array
*/
function getGrupa4If($if_id) {
$row = array();
// Najprej preverimo, ce imamo v ifu kaksno vprasanje - potem je 1. vprasanje na isti strani
$spr_in_if = $this->get_subspr($if_id);
if(count($spr_in_if) > 0){
$row = $this->getGrupa4Spremenljivka($spr_in_if[0]);
return $row;
}
// If nima znotraj se nobenega vprasanja - moramo poiskati prejsnje vprasanje in ugotoviti stran - NI SE CISTO OK - JE TREBA DODELATI
$sqlBr2 = sisplet_query("SELECT vrstni_red, parent FROM srv_branching WHERE ank_id='$this->anketa' AND element_if='$if_id'");
if(mysqli_num_rows($sqlBr2) > 0){
$rowBr2 = mysqli_fetch_assoc($sqlBr2);
$vrstni_red_if = isset($rowBr2['vrstni_red']) ? $rowBr2['vrstni_red'] : null;
$parent_if = isset($rowBr2['parent']) ? $rowBr2['parent'] : null;
if($vrstni_red_if == 1){
$sql = sisplet_query("SELECT * FROM srv_grupa WHERE ank_id='$this->anketa' AND vrstni_red='1'");
$row = mysqli_fetch_assoc($sql);
}
else{
$sqlB = sisplet_query("SELECT element_spr, pagebreak
FROM srv_branching
WHERE ank_id='".$this->anketa."' AND vrstni_red<'".$vrstni_red_if."' AND parent='".$parent_if."' AND element_spr>'0'
ORDER BY vrstni_red DESC
");
$rowB = mysqli_fetch_assoc($sqlB);
if(isset($rowB['pagebreak']) && $rowB['pagebreak'] == 0 && $rowB['element_spr']){
$row = $this->getGrupa4Spremenljivka($rowB['element_spr']);
}
else{
$prev_grupa = $this->getGrupa4Spremenljivka($rowB['element_spr']);
$row['id'] = $this->find_grupa($prev_grupa['vrstni_red']+1);
$row['vrstni_red'] = $prev_grupa['vrstni_red']+1;
}
}
}
return $row;
}
/**
* @desc Poisce prvo spremenljivko v anketi
*/
var $find_first_spr = 0;
function find_first_spr () {
if ($this->find_first_spr > 0)
return $this->find_first_spr;
$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' ORDER BY g.vrstni_red ASC, s.vrstni_red ASC LIMIT 1");
if(mysqli_num_rows($sql) > 0){
$row = mysqli_fetch_array($sql);
$this->find_first_spr = $row['id'];
}
return $this->find_first_spr;
}
/**
* @desc vrne (globalni) vrstni red spremenljivke, uposteva tudi stran
*/
var $vrstni_red = array();
function vrstni_red($spremenljivka) {
if ($spremenljivka == 0) return 0;
//$this->repareAnketa();
if (array_key_exists($spremenljivka, $this->vrstni_red)) {
return $this->vrstni_red[$spremenljivka];
}
$sql = sisplet_query("SELECT id, gru_id, vrstni_red FROM srv_spremenljivka WHERE id = '$spremenljivka'");
$row = mysqli_fetch_array($sql);
$vrstni_red = $row['vrstni_red'];
$sqlg = sisplet_query("SELECT vrstni_red FROM srv_grupa WHERE id = '$row[gru_id]'");
$rowg = mysqli_fetch_array($sqlg);
$sql1 = sisplet_query("SELECT id FROM srv_grupa WHERE vrstni_red < '$rowg[vrstni_red]' AND ank_id='$this->anketa'");
while ($row1 = mysqli_fetch_array($sql1)) {
$vrstni_red += $this->prestej_grupo($row1['id']);
}
$this->vrstni_red[$spremenljivka] = $vrstni_red;
return $this->vrstni_red[$spremenljivka];
}
/**
* @desc presteje spremenljivke v grupi
*/
var $prestej_grupo = array();
function prestej_grupo ($grupa) {
if (array_key_exists($grupa, $this->prestej_grupo)) {
return $this->prestej_grupo[$grupa];
}
$sql2 = sisplet_query("SELECT COUNT(*) AS count FROM srv_spremenljivka WHERE gru_id = '$grupa'");
$row2 = mysqli_fetch_array($sql2);
$this->prestej_grupo[$grupa] = $row2['count'];
return $row2['count'];
}
/**
* poisce naslednji element (spremenljivko, if, blok) in vrne njegov row (parent, vrstni_red, element_spr, element_if)
* v primeru ENDIFA, vrne prazno
*
*/
function find_next_element($parent, $vrstni_red) {
$sql = sisplet_query("SELECT parent, vrstni_red, element_spr, element_if FROM srv_branching WHERE parent='$parent' AND vrstni_red>'$vrstni_red' AND ank_id='$this->anketa' ORDER BY vrstni_red ASC LIMIT 1");
if (mysqli_num_rows($sql) > 0) {
$row = mysqli_fetch_array($sql);
return $row;
}
return null;
}
/**
* @desc poklice funkcijo za poiskat spremenljivko pred podanim ifom
*/
function find_before_if ($if) {
$a = $this->find_before_if_fun($if);
return $a[1];
}
/**
* @desc poisce spremenljivko pred podanim ifom
*/
function find_before_if_fun ($if, $parent=0, $prev=0) {
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE ank_id='$this->anketa' AND parent='$parent' ORDER BY vrstni_red");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_if'] > 0) {
if ($row['element_if'] == $if) {
$a[0] = 1;
$a[1] = $prev;
return $a;
}
$a = $this->find_before_if_fun($if, $row['element_if'], $prev);
if ($a[0] == 1) {
return $a;
}
$prev = $a[1];
} else {
$prev = $row['element_spr'];
}
}
$a[0] = 0;
$a[1] = $prev;
return $a;
}
/**
* @desc vrne vrstni red zadnjega elementa v ifu (spremenljivka ali if -- ce je prazen, drugace je zadnja v vsakem primeru spremenljivka)
*/
function find_last_elm_in_if ($if) {
$sql1 = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$if' AND ank_id='$this->anketa' ORDER BY vrstni_red DESC LIMIT 1");
// if ni prazen, gremo dalje
if (mysqli_num_rows($sql1) > 0) {
$row1 = mysqli_fetch_array($sql1);
// zadnja je spremenljivka -- vrnemo jo
if ($row1['element_spr'] > 0) {
return $this->vrstni_red_branching(0, $row1['element_spr']);
// na zadnjem mestu je if -- gremo rekurzivno naprej
} else {
return $this->find_last_elm_in_if($row1['element_if']);
}
// if je prazen, vrnemo kar vrstni red ifa
} else {
return $this->vrstni_red_branching($if);
}
}
/**
* @desc poisce zadnjo spremenljivko v IFu
*/
function find_last_in_if ($if) {
if ($if == null) return null;
if (!$this->find_spr_in_if($if)) return null;
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$if' AND ank_id='$this->anketa' ORDER BY vrstni_red DESC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0)
return $row['element_spr'];
else {
$r = $this->find_last_in_if($row['element_if']);
if ($r != null)
return $r;
}
}
}
/**
* @desc poisce prvo spremenljivko v IFu
*/
function find_first_in_if ($if) {
if ($if == null) return null;
if (!$this->find_spr_in_if($if)) return null;
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$if' AND ank_id='$this->anketa' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0)
return $row['element_spr'];
else {
$r = $this->find_first_in_if($row['element_if']);
if ($r != null)
return $r;
}
}
}
/**
* @desc preveri ali so kaksne spremenljivke v IFu
*/
function find_spr_in_if ($if) {
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$if' AND ank_id='$this->anketa'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0)
return true;
elseif ($row['element_if'] > 0)
if ($this->find_spr_in_if($row['element_if']))
return true;
}
return false;
}
/**
* @desc presteje koliko spremenljiv je v IFu
*/
function count_spr_in_if ($if) {
$count = 0;
$sql = sisplet_query("SELECT element_spr, element_if FROM srv_branching WHERE parent='$if' AND ank_id='$this->anketa'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['element_spr'] > 0)
$count++;
elseif ($row['element_if'] > 0)
$count += $this->count_spr_in_if($row['element_if']);
}
return $count;
}
private $vrstni_red_branching = null;
/**
* vrne vrstni red elementa v branching strukturi (uposteva tudi ife itd..)
*
* @param mixed $if
* @param mixed $spremenljivka
*/
function vrstni_red_branching ($if, $spremenljivka=0) {
if ($this->vrstni_red_branching === null) {
Cache::cache_all_srv_branching($this->anketa);
$vrstni_red = 1;
$this->vrstni_red_branching_fun(0, $vrstni_red);
}
if(isset($this->vrstni_red_branching[$if][$spremenljivka]))
return $this->vrstni_red_branching[$if][$spremenljivka];
else
return null;
}
/**
* zgenerira array z vrstnimi redi elementov (rekurzivno)
*
* @param mixed $parent
* @param mixed $vrstni_red
*/
function vrstni_red_branching_fun ($parent, &$vrstni_red) {
foreach (Cache::srv_branching_parent($this->anketa, $parent) AS $k => $row) {
$this->vrstni_red_branching[$row['element_if']][$row['element_spr']] = $vrstni_red;
$vrstni_red++;
if ($row['element_if'] > 0) {
$this->vrstni_red_branching_fun($row['element_if'], $vrstni_red);
}
}
}
/**
* @desc poklice repareAnketa, ki popravi celotno anketo
*/
function repareAnketa () {
Common::repareAnketa($this->anketa);
}
/**
* pri repare branching bomo šli zdej vedno čez celo strukturo, ker drugace zgleda da nekaj ni ok
*
* @param mixed $parent
*/
function repare_branching ($parent=0) {
$this->repare_branching_do();
}
/**
* @desc rekurzivno popravi vrstne rede v branchingu
*/
function repare_branching_do ($parent=0) {
$vrstni_red = 1;
$sql = sisplet_query("SELECT element_spr, element_if, vrstni_red FROM srv_branching WHERE parent='$parent' AND ank_id='$this->anketa' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
if ($row['vrstni_red'] != $vrstni_red) {
sisplet_query("UPDATE srv_branching SET vrstni_red='$vrstni_red' WHERE element_spr='$row[element_spr]' AND element_if='$row[element_if]' AND ank_id='$this->anketa'");
}
$vrstni_red++;
if ($row['element_if'] > 0)
$this->repare_branching_do($row['element_if']);
}
}
/**
* @desc preveri ali je spremenljivka zadnja na strani (pagebreak)
*/
var $pagebreak = array();
function pagebreak ($spremenljivka) {
if (array_key_exists($spremenljivka, $this->pagebreak)) {
return $this->pagebreak[$spremenljivka];
}
$row = Cache::srv_branching($spremenljivka, 0);
if ($row['pagebreak'] == 1) {
$this->pagebreak[$spremenljivka] = true;
return true;
} else {
$this->pagebreak[$spremenljivka] = false;
return false;
}
}
/**
* @desc vrne nivo (level) spremenljivke v strukturi branchinga
*/
var $level = array();
function level ($element_spr, $element_if=0) {
if (isset($this->level[$element_spr][$element_if])) {
return $this->level[$element_spr][$element_if];
}
$row = Cache::srv_branching($element_spr, $element_if);
if ($row['parent'] == 0) {
$this->level[$element_spr][$element_if] = 0;
return 0;
} else {
$value = $this->level(0, $row['parent']) + 1;
$this->level[$element_spr][$element_if] = $value;
return $value;
}
}
/**
* @desc popravi vrstne rede v conditionu
*/
function repare_condition ($if) {
$sql = Cache::srv_condition($if);
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$vrstni_red=1;
while ($row = mysqli_fetch_array($sql)) {
if ($row['vrstni_red'] != $vrstni_red)
sisplet_query("UPDATE srv_condition SET vrstni_red='$vrstni_red' WHERE id = '$row[id]'");
$vrstni_red++;
}
}
/**
* @desc popravi vrstne rede v calculationu
*/
function repare_calculation ($condition) {
$sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id='$condition' ORDER BY vrstni_red ASC");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$vrstni_red=1;
while ($row = mysqli_fetch_array($sql)) {
if ($row['vrstni_red'] != $vrstni_red)
$s = sisplet_query("UPDATE srv_calculation SET vrstni_red='$vrstni_red' WHERE id = '$row[id]'");
$vrstni_red++;
}
}
/**
* @desc
*/
function dropped_alert($text = null) {
global $lang;
if ($text === null)
$text = $lang['srv_dropped_alert'];
echo '
';
}
}
/**
* vrne array vseh spremenljivk, ki se pojavljajo v loopu
*
* @param mixed $ank_id
*/
function spremenljivke_in_loop ($anketa = null) {
if ($anketa == null) {
$ank_id = $this->anketa;
} else {
$ank_id = $anketa;
}
$a = array();
$sql = sisplet_query("SELECT b.element_if FROM srv_branching b, srv_if i WHERE b.ank_id='$ank_id' AND b.element_if=i.id AND i.tip='2'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
$a[$row['element_if']] = $this->get_subspr($row['element_if']);
}
return $a;
}
/**
* preveri, ce obstajajo loopi in ce so PB na loopih pravilno postavljeni ter jih popravi
* - pagebreak mora biti pred in za loopom, ter nobenega pb v loopu -- se pravi: loop je na svoji strani
*/
function check_loop () {
$change = false;
$a = $this->spremenljivke_in_loop();
// loop cez vse loope :)
foreach ($a AS $loop => $spremenljivke) {
// spremenljivka pred loopom - mora imet pb
$pred = $this->find_before_if($loop);
$row = Cache::srv_branching($pred, 0);
if ($row['pagebreak'] == 0) {
sisplet_query("UPDATE srv_branching SET pagebreak = '1' WHERE element_spr = '$pred' AND ank_id='".$this->anketa."'");
$change = true;
}
// zadnja spremenljivka v loopu
$za = $this->find_last_in_if($loop);
// loop cez spremenljivke v loopu
foreach ($spremenljivke AS $spr) {
if ($spr != $za) {
// spremenljivke v loopu nimajo pb (razen zadnje)
$row = Cache::srv_branching($spr, 0);
if ($row['pagebreak'] == 1) {
sisplet_query("UPDATE srv_branching SET pagebreak = '0' WHERE element_spr = '$spr' AND ank_id='".$this->anketa."'");
$change = true;
}
}
}
// zadnja spremenljivka v loopu - mora imet pb
$row = Cache::srv_branching($za, 0);
if ($row['pagebreak'] == 0) {
sisplet_query("UPDATE srv_branching SET pagebreak = '1' WHERE element_spr = '$za' AND ank_id='".$this->anketa."'");
$change = true;
}
}
if ($change) {
$this->repare_vrstni_red();
$this->trim_grupe();
$this->pagebreak = array();
Cache::clear_branching_cache();
}
}
/**
* preveri, ce je podani element loop, ali pa ima parenta, ki je loop
*
*/
function find_loop_parent ($parent) {
if ($parent == 0) return 0;
$sql = sisplet_query("SELECT id FROM srv_if WHERE id = '$parent' AND tip = '2'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
if (mysqli_num_rows($sql) > 0)
return $parent;
$sql = sisplet_query("SELECT parent FROM srv_branching WHERE element_spr = '0' AND element_if = '$parent' AND ank_id='$this->anketa'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
return $this->find_loop_parent($row['parent']);
}
/**
* preveri, ce je podani element loop, ali pa ima childa, ki je loop
*
*/
function find_loop_child ($if) {
$sql = sisplet_query("SELECT id FROM srv_if WHERE id = '$if' AND tip = '2'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
if (mysqli_num_rows($sql) > 0)
return $if;
$sql = sisplet_query("SELECT element_if FROM srv_branching WHERE parent = '$if' AND element_if > '0' AND ank_id='$this->anketa'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
while ($row = mysqli_fetch_array($sql)) {
return $this->find_loop_child($row['element_if']);
}
return 0;
}
/**
* poisce, ce ima podani element parenta, ki je loop
*
*/
function find_parent_loop ($element_spr, $element_if=0) {
$sql = sisplet_query("SELECT parent FROM srv_branching WHERE element_spr = '$element_spr' AND element_if = '$element_if' AND ank_id='$this->anketa'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
$row = mysqli_fetch_array($sql);
if ($row['parent'] == 0) return 0;
$sql = sisplet_query("SELECT id FROM srv_if WHERE id = '$row[parent]' AND tip = '2'");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
if (mysqli_num_rows($sql) > 0)
return $row['parent'];
else
return $this->find_parent_loop(0, $row['parent']);
}
function displayKomentarji($displayKomentarji = true) {
$this->displayKomentarji = $displayKomentarji;
}
//funkcija za izris hotspot
//radio grid
function vprasanje_hotspot($spremenljivka, $tip, $enota_orientation){
global $lang;
$row = Cache::srv_spremenljivka($spremenljivka);
$spremenljivkaParams = new enkaParameters($row['params']);
$hotspot_image = ($spremenljivkaParams->get('hotspot_image') ? $spremenljivkaParams->get('hotspot_image') : "");
// Ce je vprasanje ali anketa zaklenjena
$locked = ($this->locked) ? true : false;
//zaslon razdelimo na dva dela - izris leve strani***************************************
echo '
';
//$sql1 = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red");
$sql1 = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' AND other = 0 ORDER BY vrstni_red");
$sql1_missing = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' AND other != 0 ORDER BY vrstni_red");
$sqlR = sisplet_query("SELECT * FROM srv_hotspot_regions WHERE spr_id='$row[id]' ");
if($_GET['a'] == 'prevajanje'){ //ce se izvaja prevajanje
if (mysqli_num_rows($sqlR) != 0){ //ce so obmocja
//pokazi shranjena obmocja
while ($rowR = mysqli_fetch_array($sqlR)) {
//ureditev izbire imena obmocja glede na jezik ankete
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslovObmocja = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($rowR['vre_id']);
if ($naslovObmocja == ''){
$naslovObmocja = $rowR['region_name'];
}
//echo "naslovObmocja: ".$naslovObmocja;
}
echo '
'.$naslovObmocja.'
';
}
}
}
else{ //ce ni prevajanje pokazi:
//GUMB za nalaganje in urejanje slike
if ( ($hotspot_image == '') || substr($hotspot_image, 0, 4) != '';
//Slika
echo '
'.$hotspot_image.'
';
}
//skrita varianta od koder poberem height in width za urejanje obmocij
//izbira ustreznega radio ali checkbox za prikazovanje ob missingu
if ($tip == 1){
$input = "radio";
}
else if ($tip == 2){
$input = "checkbox";
}
echo '
'.$hotspot_image.'
';
echo '
';
if (mysqli_num_rows($sql1) == 0){
echo '
';
echo '
';
}
else{
while ($row1 = mysqli_fetch_array($sql1)) {
echo '
';
?>
';
//************************* Izris leve strani - konec
//************** Izris desne strani za grid
if($tip == 6){ //ce je radio grid izrisi desno stran
echo '
';
echo '
';
echo ' ';
// urejanje vrednosti
echo '
';
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT * FROM srv_grid WHERE spr_id='$row[id]' AND other=0 ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
for ($i = 1; $i <= $row['grids']; $i++) {
if ($row2['vrstni_red'] == $i) {
echo '
';
}
}
#kateri missingi so nastavljeni
$sql_grid_mv = sisplet_query("SELECT * FROM srv_grid WHERE spr_id='".$spremenljivka."' AND other != 0");
if (mysqli_num_rows($sql_grid_mv) > 0 ) {
echo '
';
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
if ($this->lang_id != null) {
$naslov = \App\Controllers\LanguageController::srv_language_grid($row['id'], $row_grid_mv['id']);
if ($naslov != '') $row_grid_mv['naslov'] = $naslov;
}
echo '
';
echo '';
echo '';
$bg++;
//$sql1 = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY FIELD(vrstni_red, $orderby)");
$sql1 = sisplet_query("SELECT id, naslov FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red");
while ($row1 = mysqli_fetch_array($sql1)) {
if ($this->lang_id != null) {
save('lang_id', $this->lang_id);
$naslov = \App\Controllers\LanguageController::getInstance()->srv_language_vrednost($row1['id']);
if ($naslov != '') $row1['naslov'] = $naslov;
}
$bg++;
}
echo ' ';
echo '
';
echo '
';
}
//************** Izris desne strani za grid - konec
//************** Izris desne strani za image hotspot razvrscanje
if($tip == 17 || $row['design'] == 3){ //ce je razvrscanje z image hotspot izrisi desno stran
echo '
';
echo '
';
echo ' ';
// urejanje vrednosti
echo '
';
echo '
';
$bg = 1;
$sql2 = sisplet_query("SELECT * FROM srv_hotspot_regions WHERE spr_id='$row[id]' ORDER BY vrstni_red");
$row2 = mysqli_fetch_array($sql2);
for($indeks=1;$indeks <= mysqli_num_rows($sql2);$indeks++){
echo '
' . $row2['vrstni_red'] . '
';
$row2 = mysqli_fetch_array($sql2);
}
echo '
';
echo '
';
echo '
';
$bg = 1;
echo '
';
echo '
';
echo '';
echo '
';
echo '
';
}
//************** Izris desne strani za image hotspot razvrscanje - konec
//***********************Image hot spot konec*************************************************************
}
//funkcija za izris heatmap
//radio grid
function vprasanje_heatmap($spremenljivka, $tip){
global $lang;
$row = Cache::srv_spremenljivka($spremenljivka);
$spremenljivkaParams = new enkaParameters($row['params']);
$hotspot_image = ($spremenljivkaParams->get('hotspot_image') ? $spremenljivkaParams->get('hotspot_image') : "");
$spremenljivkaParams->set('multi_input_type', 'marker');
// Ce je vprasanje ali anketa zaklenjena
$locked = ($this->locked) ? true : false;
echo '
';
$sql1 = sisplet_query("SELECT id, naslov, other FROM srv_vrednost WHERE spr_id='$row[id]' AND other = 0 ORDER BY vrstni_red");
$sql1_missing = sisplet_query("SELECT id, naslov, other FROM srv_vrednost WHERE spr_id='$row[id]' AND other != 0 ORDER BY vrstni_red");
//GUMB za nalaganje in urejanje slike
if ( ($hotspot_image == '') || substr($hotspot_image, 0, 4) != '';
echo '
'.$hotspot_image.'
';
//skrita varianta od koder poberem height in width za urejanje obmocij
//izbira ustreznega radio ali checkbox za prikazovanje ob missingu
$input = "checkbox";
echo '
'.$hotspot_image.'
';
echo '
';
if (mysqli_num_rows($sql1) == 0){
echo '
';
echo '
';
}
else{
while ($row1 = mysqli_fetch_array($sql1)) {
echo '
';
?>
';
//***********************Heatmap konec*************************************************************
}
// Vrnemo string orientacije za vprasanje
private function getVprasanjeOrientationString($type, $orientation){
global $lang;
// Prva stevilka je tip vprasanja, druga tip orientacije
switch($type.'-'.$orientation){
case '1-0':
case '2-0':
case '21-0':
case '7-0':
case '8-0':
$orientation_string = $lang['srv_orientacija_horizontalna'];
break;
case '1-2':
case '2-2':
case '21-2':
$orientation_string = $lang['srv_orientacija_horizontalna_2'];
break;
case '21-3':
$orientation_string = $lang['srv_orientacija_vertikalna'];
break;
case '1-4':
case '3-1':
case '6-2':
$orientation_string = $lang['srv_dropdown'];
break;
case '1-6':
case '2-6':
$orientation_string = $lang['srv_select-box_radio'];
break;
case '1-7':
case '2-7':
$orientation_string = $lang['srv_orientacija_vertikalna_2'];
break;
case '1-8':
case '2-8':
$orientation_string = $lang['srv_drag_drop'];
break;
case '1-9':
case '6-12':
$orientation_string = $lang['srv_custom-picture_radio'];
break;
case '1-10':
case '2-10':
case '6-10':
$orientation_string = $lang['srv_hot_spot'];
break;
case '1-11':
case '6-11':
$orientation_string = $lang['srv_visual_analog_scale'];
break;
case '6-1':
$orientation_string = $lang['srv_diferencial2'];
break;
case '6-3':
case '16-3':
$orientation_string = $lang['srv_double_grid'];
break;
case '6-4':
$orientation_string = $lang['srv_one_against_another'];
break;
case '6-5':
$orientation_string = $lang['srv_max_diff'];
break;
case '6-6':
case '16-6':
$orientation_string = $lang['srv_select-box_radio'];
break;
case '6-8':
$orientation_string = $lang['srv_orientacija_tabela_da_ne'];
break;
case '6-9':
case '16-9':
$orientation_string = $lang['srv_drag_drop'];
break;
default:
$orientation_string = '';
break;
}
return $orientation_string;
}
}
?>
';
echo '
';
echo '';
echo '
';
echo '
';
echo '
';
echo '
';
echo '!['.$lang['srv_preglejspremenljivko'].'](img_'.$this->skin.'/palete_green.png)
!['.$lang['srv_editirajspremenljivko_fs'].'](icons/icons/arrow_out.png){kind=icon}
!['.$lang['srv_predogled_spremenljivka'].'](img_'.$this->skin.'/preview_green.png)