From 19985dbb8c0aa66dc4bf7905abc1148de909097d Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= <anton@sijanec.eu>
Date: Tue, 11 Jan 2022 12:35:47 +0100
Subject: prvi-commit

---
 .../export/xmlClasses/class.XmlSurveyElement.php   | 433 +++++++++++++++++++++
 1 file changed, 433 insertions(+)
 create mode 100644 admin/survey/export/xmlClasses/class.XmlSurveyElement.php

(limited to 'admin/survey/export/xmlClasses/class.XmlSurveyElement.php')

diff --git a/admin/survey/export/xmlClasses/class.XmlSurveyElement.php b/admin/survey/export/xmlClasses/class.XmlSurveyElement.php
new file mode 100644
index 0000000..630cdca
--- /dev/null
+++ b/admin/survey/export/xmlClasses/class.XmlSurveyElement.php
@@ -0,0 +1,433 @@
+<?php
+
+/**
+ *
+ *	Class ki skrbi za izris posameznega vprasanja za vprašalnik
+ *
+ *
+ */
+
+include('../../vendor/autoload.php');
+
+define("MAX_STRING_LENGTH", 60);
+define("LINE_BREAK_AT", '7 cm');
+define("RADIO_BTN_SIZE", 0.13);
+define("CHCK_BTN_SIZE", 0.13);
+define("PIC_SIZE_ANS", "\includegraphics[width=3cm]"); 	//slika dolocene sirine
+define("DROPDOWN_SIZE", 0.8);
+
+ 
+class XmlSurveyElement{
+	
+	public $anketa;				// ID ankete
+	public static $spremenljivka;
+	public $spremenljivkaParams;
+	public $stevilcenje;
+	public $showIf = 0;			// izpis if-ov
+	public $numbering = 0; 		// ostevillcevanje vprasanj
+	public $export_format;
+	public $questionText;
+	protected $usr_id = null;			// id userja ki je odgovarjal (na katerega so vezani podatki)
+	protected $db_table = '';
+	protected $loop_id = null;	// id trenutnega loopa ce jih imamo
+	protected $userAnswer = array();
+	//protected $userDataPresent = array();
+	//protected $userDataPresent = 0;
+	protected $xml;
+	
+	
+	function __construct($anketa=null, $export_format='', $usr_id=null, $export_subtype='', $xml=null){
+		global $site_path, $global_user_id, $admin_type, $lang;
+		
+		$this->anketa = $anketa;
+		
+		$this->xml = $xml;
+/* 		$this->spremenljivka = $spremenljivka;
+		$this->stevilcenje = $stevilcenje; */
+
+		$this->numbering = (int)SurveySetting::getInstance()->getSurveyMiscSetting('export_numbering');
+
+		$this->export_format = $export_format;
+		
+		//$this->usr_id = $_GET['usr_id'];
+		$this->usr_id = $usr_id;
+			
+		
+		if ( SurveyInfo::getInstance()->SurveyInit($anketa))
+		{
+			SurveyUserSetting::getInstance()->Init($anketa, $global_user_id);
+			
+			if (SurveyInfo::getInstance()->getSurveyColumn('db_table') == 1)
+				$this->db_table = '_active';
+		}		
+		else{
+			return false;			
+		}
+		
+	}
+	
+	#funkcija, ki pripravi xml za posamezene element vprasalnika glede na tip vprasanja ################################################################
+	public function displaySurveyElement($spremenljivke=null, $export_subtype='', $preveriSpremenljivko=null, $loop_id=null){	
+		switch ($spremenljivke['tip']){
+			case 1: //radio
+				return RadioXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 2: //check
+				return CheckboxXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 3: //select -> radio
+				return RadioXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 6: //multigrid
+/* 			case 16:// multicheckbox
+			case 19:// multitext
+			case 20:// multinumber */
+				return MultiGridXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 21: //besedilo
+				return BesediloXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 7: //stevilo
+				return SteviloXml::getInstance()->export($spremenljivke, $this->db_table, $preveriSpremenljivko, $export_subtype, $loop_id, $this->xml);
+			break;
+			case 8:	//datum
+				//return DatumLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $loop_id);
+			break;
+			case 17: //ranking
+				//return RazvrscanjeLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $export_data_type, $loop_id);
+			break;
+			case 18: //vsota
+				//return VsotaLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $loop_id);
+			break;
+			case 24: // kombinirana tabela
+				//return GridMultipleLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $export_data_type, $loop_id);
+			break;			
+			case 26: //lokacija
+				//return LokacijaLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $loop_id);
+			break;
+			case 27: //heatmap
+				return HeatmapLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $this->getUserId(), $this->db_table, $export_subtype, $preveriSpremenljivko, $loop_id);
+			break;
+			case 5:	//nagovor
+				//return NagovorLatex::getInstance()->export($spremenljivke, $this->export_format, $this->questionText, $this->fillablePdf, $this->texNewLine, $export_subtype, $preveriSpremenljivko, $loop_id);
+			break;
+			case 22: //kalkulacija
+				//return KalkulacijaLatex::getInstance()->export($spremenljivke, $this->export_format, $this->fillablePdf, $this->texNewLine, $export_subtype, $this->db_table, $this->getUserId(), $loop_id);
+			break;
+			case 25: //kvota
+				//return KvotaLatex::getInstance()->export($spremenljivke, $this->export_format, $this->fillablePdf, $this->texNewLine, $export_subtype, $this->db_table, $this->anketa, $this->getUserId(), $loop_id);
+			break;
+			case 9: //SN-imena
+				//return SNImenaLatex::getInstance()->export($spremenljivke, $this->export_format, $this->fillablePdf, $this->texNewLine, $export_subtype, $this->db_table, $this->anketa, $this->getUserId(), $loop_id);
+			break;
+		}
+	}
+	#funkcija, ki pripravi xml za posamezene element vprasalnika glede na tip vprasanja  - konec #######################################################
+
+	
+	function writeXmlAttr4Element($xml=null, $attribute=null, $element=null, $writeAttribute=0){
+		$this->xml = $xml;		
+		if($writeAttribute){
+			xmlwriter_write_attribute($this->xml, $attribute, $element);
+		}else{
+			xmlwriter_start_attribute($this->xml,  $attribute);
+		}
+		xmlwriter_text($this->xml, $element);
+		xmlwriter_end_attribute($this->xml);
+	}
+	
+	function writeXmlElement($xml=null, $text=null, $element=null){
+		$this->xml = $xml;
+		xmlwriter_start_element($this->xml,  $element);
+		xmlwriter_text($this->xml, $text);
+		xmlwriter_end_element($this->xml);
+	}
+	
+	/**
+	 * prevod za srv_spremenljivka
+	 */
+	 function srv_language_spremenljivka ($spremenljivka=null) {
+		 
+		 if ($this->language != -1) {
+			$sqll = sisplet_query("SELECT * FROM srv_language_spremenljivka WHERE ank_id='".$this->anketa."' AND spr_id='".$spremenljivka['id']."' AND lang_id='".$this->language."'");
+			$rowl = mysqli_fetch_array($sqll);
+			
+			return $rowl;
+		 }
+		
+		return false;
+	 }
+	 	
+	 /**
+	 * vrne prevod za srv_vrednost
+	 * 
+	 * @param mixed $vrednost
+	 */
+	 function srv_language_vrednost ($vrednost=null) {
+
+		 if ($this->language != -1) {	
+			$sqll = sisplet_query("SELECT * FROM srv_language_vrednost WHERE ank_id='".$this->anketa['id']."' AND vre_id='".$vrednost."' AND lang_id='".$this->language."'");
+			$rowl = mysqli_fetch_array($sqll);
+			
+			if ($rowl['naslov'] != '') return $rowl['naslov'];
+		 }
+		 
+		 return false;	 
+	 }
+	 
+	 /**
+	 * vrne prevod za srv_grid
+	 * 
+	 * @param mixed $vrednost
+	 */
+	 function srv_language_grid ($spremenljivka=null, $grid=null) {
+	 	 
+		 if ($this->language != -1) {
+			$sqll = sisplet_query("SELECT * FROM srv_language_grid WHERE ank_id='".$this->anketa['id']."' AND spr_id='".$spremenljivka."' AND grd_id='".$grid."' AND lang_id='".$this->language."'");
+			$rowl = mysqli_fetch_array($sqll);
+			
+			if ($rowl['naslov'] != '') return $rowl['naslov'];	
+		 }
+		 
+		 return false;		 
+	 }
+	 
+	#funkcija, ki skrbi za filanje obstojecega polja z odgovori z missing odgovori #############################################################
+	function AddMissingsToAnswers($vodoravniOdgovori=null, $missingOdgovori=null){		
+		for($m=0;$m<count($missingOdgovori);$m++){
+			array_push($vodoravniOdgovori,$missingOdgovori[$m]);
+		}
+		return $vodoravniOdgovori;
+	}	
+	#funkcija, ki skrbi za filanje obstojecega polja z odgovori z missing odgovori - konec #####################################################
+
+		
+	function getUserId() {return ($this->usr_id)?$this->usr_id:false;}
+	
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja, ki niso grid ali kombinirana tabela
+	function GetUsersData($db_table=null, $spremenljivkeId=null, $spremenljivkeTip=null, $usr_id=null, $loop_id_raw=null){
+		$userDataPresent = 0;	//belezi, ali je odgovor respondenta prisoten in je indeks za določena polja, ki shranjujejo podatke o odgovorih respondenta
+		$loop_id = $loop_id_raw == null ? " IS NULL" : " = '".$loop_id_raw."'";
+		//echo "loop_id v GetUsersData: ".$loop_id."</br>";
+		
+		// če imamo vnose, pogledamo kaj je odgovoril uporabnik
+		if( in_array($spremenljivkeTip, array(21, 7, 8, 18)) ){	//ce je tip besedilo ali stevilo ali datum ali vsota
+			//$sqlUserAnswerString ="SELECT text FROM srv_data_text".$db_table." WHERE spr_id='".$spremenljivkeId."' AND usr_id='".$usr_id."' ";		
+			$sqlUserAnswerString ="SELECT text FROM srv_data_text".$db_table." WHERE spr_id='".$spremenljivkeId."' AND usr_id='".$usr_id."' AND loop_id $loop_id ";
+		}elseif($spremenljivkeTip==17){		//ce je razvrscanje
+			//$sqlUserAnswer = sisplet_query("SELECT vrstni_red FROM srv_data_rating WHERE spr_id=".$spremenljivke['id']." AND usr_id='".$this->getUserId()."' AND vre_id='".$rowVrednost['id']."' AND loop_id $loop_id");
+			//$sqlUserAnswerString = "SELECT vrstni_red FROM srv_data_rating WHERE spr_id='".$spremenljivkeId."' AND usr_id='".$usr_id."' ";
+			$sqlUserAnswerString = "SELECT vrstni_red FROM srv_data_rating WHERE spr_id='".$spremenljivkeId."' AND usr_id='$usr_id' AND loop_id $loop_id ";
+			//echo $sqlUserAnswerString."</br>";
+		}elseif($spremenljivkeTip==26){		//ce je lokacija
+			//$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_map WHERE spr_id='".$spremenljivkeId."' AND usr_id='".$usr_id."' ";
+			$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_map WHERE spr_id='".$spremenljivkeId."' AND usr_id='$usr_id' AND loop_id $loop_id ";
+			//echo $sqlUserAnswerString."</br>";
+		}elseif($spremenljivkeTip==27){		//ce je heatmap
+			//$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_heatmap WHERE spr_id='".$spremenljivkeId."' AND usr_id='".$usr_id."' ";
+			$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_heatmap WHERE spr_id='".$spremenljivkeId."' AND usr_id='$usr_id' AND loop_id $loop_id ";
+			//echo $sqlUserAnswerString."</br>";
+		}else{	
+			//$sqlUserAnswerString =  "SELECT vre_id FROM srv_data_vrednost".$db_table." WHERE spr_id='$spremenljivkeId' AND usr_id=$usr_id";
+			$sqlUserAnswerString =  "SELECT vre_id FROM srv_data_vrednost".$db_table." WHERE spr_id='$spremenljivkeId' AND usr_id='$usr_id' AND loop_id $loop_id";
+			//echo $sqlUserAnswerString."</br>";
+		}
+		
+		$sqlUserAnswer = sisplet_query($sqlUserAnswerString);
+		
+		if( in_array($spremenljivkeTip, array(21, 7, 8, 18, 17)) ){//ce je tip besedilo ali stevilo ali datum ali vsota ali razvrscanje
+			$rowAnswers = mysqli_fetch_assoc($sqlUserAnswer);
+			if($rowAnswers){	//ce je kaj v bazi
+				//echo "Nekaj je v bazi za spremenljivko".$spremenljivkeId." in usr".$usr_id."</br>";
+				$userDataPresent++;
+			}
+		}else{
+			if($sqlUserAnswer){	//ce je kaj v bazi
+				while ($rowAnswers = mysqli_fetch_assoc($sqlUserAnswer)){
+					if($spremenljivkeTip==26||$spremenljivkeTip==27){
+						//$this->userAnswer = $rowAnswers;
+						$this->userAnswer[$userDataPresent] = $rowAnswers;
+						//echo "rowAnswers: ".$this->userAnswer['address'].' za odgovore tip '.$spremenljivkeTip.' id '.$spremenljivkeId.' usr '.$usr_id.'</br>';	
+						$userDataPresent++;
+					}else{
+						$this->userAnswer[$rowAnswers['vre_id']] = $rowAnswers['vre_id'];
+						//echo "rowAnswers: ".$rowAnswers['vre_id'].' za odgovore tip '.$spremenljivkeTip.' id '.$spremenljivkeId.' usr '.$usr_id.'</br>';
+						if($rowAnswers['vre_id']>0){
+							$userDataPresent++;
+						}
+					}				
+				}		
+			}
+		}
+		//echo "userDataPresent za tip ".$spremenljivkeTip." id".$spremenljivkeId." usr ".$usr_id." je:".$userDataPresent."</br>";
+		return $userDataPresent;
+	}
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja, ki niso grid ali kombinirana tabela - konec
+	
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja z grid	
+	function GetUsersDataGrid($spremenljivke=null, $db_table=null, $rowVrednost=null, $rowVsehVrednosti=null, $usr_id=null, $subtip=null, $loop_id_raw=null){
+		$loop_id = $loop_id_raw == null ? " IS NULL" : " = '".$loop_id_raw."'";
+		
+		// poiščemo kaj je odgovoril uporabnik: PREVERITI, CE JE POTREBEN STAVEK Z LOOP IN KDAJ JE TO AKTUALNO
+		if(($spremenljivke['tip']==16)||($spremenljivke['tip']==6&&$spremenljivke['enota']==3)){	//ce je grid checkbox ali dvojna tabela
+			//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = '".$rowVsehVrednosti['id']."' AND loop_id $loop_id");
+			//$sqlString = "SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+			
+			//$sqlString = "SELECT grd_id, vre_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+			$sqlString = "SELECT grd_id, vre_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']." AND loop_id $loop_id";
+			
+			//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']);
+			$sqlUserAnswer = sisplet_query($sqlString);
+		//}elseif($spremenljivke['tip']==6){	//ce je grid radio
+		}elseif($spremenljivke['tip']==6){	//ce je grid radio
+			//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_grid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND loop_id $loop_id");
+
+			//$sqlString ="SELECT grd_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+			
+			//$sqlString ="SELECT grd_id, vre_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+			$sqlString ="SELECT grd_id, vre_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']." AND loop_id $loop_id";
+			//echo $sqlString."</br>";
+			$sqlUserAnswer = sisplet_query($sqlString);
+			
+			//echo $sqlString."</br>";
+		}elseif($spremenljivke['tip']==19||$spremenljivke['tip']==20){	//ce je grid besedila ali stevil
+			$sqlString = "SELECT grd_id, text FROM srv_data_textgrid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+			//$sqlUserAnswer = sisplet_query("SELECT grd_id, text FROM srv_data_textgrid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']);
+			$sqlUserAnswer = sisplet_query($sqlString);
+		}elseif($spremenljivke['tip']==24){	//ce je kombo
+			//echo "Subtip kombo vprasanja: ".$subtip."</br>";
+			if($subtip==6){	//ce je grid radio
+				//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_grid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND loop_id $loop_id");
+				//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_grid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = ".$rowVrednost['id']);
+				//$sqlString ="SELECT grd_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = ".$rowVrednost['id'];
+				//$sqlString ="SELECT grd_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+				$sqlString ="SELECT grd_id FROM srv_data_grid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']." AND loop_id $loop_id";
+				//echo $sqlString."</br>";
+				$sqlUserAnswer = sisplet_query($sqlString);
+				
+				//echo $sqlString."</br>";
+			}elseif($subtip==16){	//ce je grid checkbox ali dvojna tabela
+				//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = '".$rowVsehVrednosti['id']."' AND loop_id $loop_id");
+				
+				//$sqlString = "SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+				$sqlString = "SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']." AND loop_id $loop_id";
+				//$sqlUserAnswer = sisplet_query("SELECT grd_id FROM srv_data_checkgrid".$db_table." WHERE spr_id = '".$rowVrednost['spr_id']."' AND usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id']);
+				$sqlUserAnswer = sisplet_query($sqlString);				
+			}elseif($subtip==19||$subtip==20){	//ce je grid besedila ali stevil
+				$sqlString = "SELECT grd_id, text FROM srv_data_textgrid".$db_table." where spr_id = '".$rowVrednost['spr_id']."' and usr_id = '".$usr_id."' AND vre_id = '".$rowVrednost['id']."' AND grd_id = ".$rowVsehVrednosti['id'];
+
+				$sqlUserAnswer = sisplet_query($sqlString);
+				
+				//$this->userAnswer = mysqli_fetch_assoc($sqlUserAnswer);
+				//echo "userAnswer v funkciji: ".$this->userAnswer['text'].'</br>';
+			}
+		}
+		
+		//echo $sqlString."</br>";
+		//$this->userAnswer = mysqli_fetch_assoc($sqlUserAnswer);
+		//$userAnswer = mysqli_fetch_assoc($sqlUserAnswer);
+		//echo "userAnswer v funkciji: ".$this->userAnswer['grd_id'].'</br>';
+		//echo "userAnswer v funkciji: ".$userAnswer['text'].'</br>';
+		//echo "userAnswer v funkciji: ".$userAnswer['grd_id'].'</br>';
+		
+		return $sqlUserAnswer;
+
+	}
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja z grid - konec
+	
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja s kombinirano tabelo
+	function GetUsersDataKombinirana($spremenljivke=null, $db_table=null, $usr_id=null, $questionText=null, $loop_id_raw=null){
+		$userDataPresent = 0;	//belezi, ali je odgovor respondenta prisoten in je indeks za določena polja, ki shranjujejo podatke o odgovorih respondenta
+		$userAnswerSprIds = array();
+		$userAnswerSprTip = array();
+		$userAnswerSprIdsIndex = 0;
+		$orStavek = '';
+		//$loop_id = $loop_id_raw == null ? " IS NULL" : " = '".$loop_id_raw."'";
+		$loop_id = $loop_id_raw;
+		
+		#za pridobitev stevila vrstic
+		$sqlVrednostiKombo = sisplet_query("SELECT id, naslov, naslov2, variable, other FROM srv_vrednost WHERE spr_id='".$spremenljivke['id']."' ORDER BY vrstni_red");
+		$numRowsSql = mysqli_num_rows($sqlVrednostiKombo);
+		//echo $numRowsSql."</br>";
+		#za pridobitev stevila vrstic - konec
+		
+		#za pridobitev stevila stolpcev
+		$sqlStVrednostiKombo = sisplet_query("SELECT count(*) FROM srv_grid g, srv_grid_multiple m WHERE m.spr_id=g.spr_id AND m.parent='".$spremenljivke['id']."'");
+		$rowStVrednost = mysqli_fetch_array($sqlStVrednostiKombo);	//stevilo stolpcev		
+		$numColSql = $rowStVrednost['count(*)'];	//stevilo vseh stolpcev
+		//echo "stevilo stolpcev: ".$numColSql."</br>";
+		#za pridobitev stevila stolpcev - konec
+		
+		$sqlSubGrid = sisplet_query("SELECT m.spr_id, s.tip FROM srv_grid_multiple m, srv_spremenljivka s WHERE m.parent='".$spremenljivke['id']."' AND m.spr_id=s.id ORDER BY m.vrstni_red");	//pridobimo spr_id in tip podvprasanj, ki sestavljajo kombinirano tabelo
+		//echo "SELECT m.spr_id, s.tip FROM srv_grid_multiple m, srv_spremenljivka s WHERE m.parent='".$spremenljivke['id']."' AND m.spr_id=s.id ORDER BY m.vrstni_red"."</br>";
+		
+		while($rowSubGrid = mysqli_fetch_array($sqlSubGrid)){
+			array_push($userAnswerSprIds, $rowSubGrid['spr_id'] );	//filanje polja s spr_id podvprasanj
+			array_push($userAnswerSprTip, $rowSubGrid['tip'] );	//filanje polja s tip podvprasanj
+			if($userAnswerSprIdsIndex){
+				$orStavek .= ' OR ';
+			}
+			//$orStavek .= "spr_id='".$rowSubGrid['spr_id']."' ";
+			$orStavek .= "v.spr_id='".$rowSubGrid['spr_id']."' ";
+			$userAnswerSprIdsIndex++;
+		}
+		
+		//echo $orStavek."</br>";
+		//echo count($userAnswerSprTip)."</br>";
+		
+		for($i=1;$i<=$numRowsSql;$i++){
+			//$sqlVrednostiString = "SELECT id, naslov, spr_id FROM srv_vrednost WHERE (".$orStavek.") AND vrstni_red=".($i).";";
+			$sqlVrednostiString = "SELECT v.spr_id, v.naslov, s.tip, v.id FROM srv_vrednost v, srv_spremenljivka s WHERE v.spr_id=s.id AND (".$orStavek.") AND v.vrstni_red=".($i).";";
+			//echo $sqlVrednostiString."</br>";
+			$sqlVrednosti = sisplet_query($sqlVrednostiString);
+			while($rowVrednosti = mysqli_fetch_assoc($sqlVrednosti)){
+				$sqlVsehVrednostiString = "SELECT id, naslov FROM srv_grid WHERE spr_id='".$rowVrednosti['spr_id']."' ORDER BY 'vrstni_red'";
+				//echo $sqlVsehVrednostiString."</br>";
+				//echo $rowVrednosti['tip']."</br>";
+				//echo "Vrednost: ".$rowVrednosti['spr_id']."</br>";
+				$sqlVsehVrednosti = sisplet_query($sqlVsehVrednostiString);
+				while ($rowVsehVrednosti = mysqli_fetch_assoc($sqlVsehVrednosti)){
+					//$sqlUserAnswer = $this->GetUsersDataGrid($spremenljivke, $db_table, $rowVrednosti, $rowVsehVrednosti, $usr_id, $rowVrednosti['tip']);
+					$sqlUserAnswer = $this->GetUsersDataGrid($spremenljivke, $db_table, $rowVrednosti, $rowVsehVrednosti, $usr_id, $rowVrednosti['tip'], $loop_id);
+					$userAnswer = mysqli_fetch_assoc($sqlUserAnswer);
+					//if($userAnswer){	//ce je kaj v bazi
+						if($rowVrednosti['tip']==19||$rowVrednosti['tip']==20){
+							//$this->userAnswer[$userDataPresent] = $userAnswer['text'];	
+							$userAnswers[$userDataPresent] = $userAnswer['text'];	
+						}else{
+							//$this->userAnswer[$userDataPresent] = $userAnswer['grd_id'];								
+							$userAnswers[$userDataPresent] = $userAnswer['grd_id'];								
+						}
+						//echo $this->userAnswer[$userDataPresent]."</br>";
+						//echo $userAnswer[$userDataPresent]."</br>";
+						$userDataPresent++;
+					//}
+				}
+			}
+			
+		}
+		//if($questionText){
+			//return $userDataPresent;			
+		//}else{
+			//return $this->userAnswer;
+			return $userAnswers;
+		//}		
+	}
+	#funkcija, ki skrbi za preverjanje obstoja podatkov za vprasanja s kombinirano tabelo - konec
+	
+	#funkcija, ki skrbi za pridobitev operatorja iz stevilskega podatka ###########################################################
+	function GetOperator($operatorNum=null){
+		if ($operatorNum == 0){
+			$operator = $this->encodeText('+');
+		}elseif ($operatorNum == 1){
+			$operator = $this->encodeText('-');
+		}elseif ($operatorNum == 2){
+			$operator = $this->encodeText('*');
+		}elseif ($operatorNum == 3){
+			$operator = $this->encodeText('/');
+		}
+		return $operator;
+	}
+	#funkcija, ki skrbi za pridobitev operatorja iz stevilskega podatka - konec ###################################################
+	
+}
\ No newline at end of file
-- 
cgit v1.2.3