path: root/admin/survey/export/latexclasses/class.LatexSurvey.php

<?php

/**
 *
 *	Class ki skrbi za izris vprasalnika v latex
 *
 *
 */
//namespace Export\Latexclasses;

include('../../vendor/autoload.php');

if (!defined('RADIO_BTN_SIZE')) define("RADIO_BTN_SIZE", 0.13);
if (!defined('PIC_SIZE_ANS')) define("PIC_SIZE_ANS", "\includegraphics[width=3cm]"); 	//slika dolocene sirine
 
class LatexSurvey{
	
	var $anketa; // ID ankete
	var $tex;	//shrani tex kodo
	var $texNewLine = '\\\\ ';
	var $texPageBreak = "\\newpage";
	var $export_format;
	var $export_data_show_recnum;
	var $exportDataPageBreak=0; //vsak respondent na svoji strani
	
	var $commentType = 1;	// tip izpisa komentarjev
	
	var $loop_id = null;	// id trenutnega loopa ce jih imamo	
	
	var $db_table = '';
	var $path2Images = '';
	
	protected $showIntro = 0;
	protected $showGDPRIntro = 0;
	protected $GDPRIntro = '';
	protected $type = 0;			// tip izpisa - 0->navaden, 1->iz prve strani, 2->s komentarji
	
	protected $showIf = 0;		// izpis if-ov
	
	var $skipEmpty = 0; 	// izpusti vprasanja brez odgovora
	var $skipEmptySub = 0; 	// izpusti podvprasanja brez odgovora
	
	protected $recnum = 0;
	protected $usr_id = 0;
	protected $texBigSkip = '\bigskip';

	protected $grupa = 0;
	protected $currentHeight = 0;
	protected $variableName = '';

	protected $admin_type;

	protected $path2UploadedImages;
	
	protected $language = -1;		// Katero verzijo prevoda izvazamo	

	public static $spremenljivka;
	
	function __construct($anketa=null, $export_format='', $export_show_intro=null, $export_show_if=null, $export_data_skip_empty=null, $export_data_skip_empty_sub=null){
		global $site_path, $global_user_id, $admin_type, $lang;
	
		$this->anketa = $anketa;
		$this->export_format = $export_format;

		$this->admin_type = $admin_type;
		
		$this->usr_id = isset($_GET['usr_id']) ? $_GET['usr_id'] : '';
		
		$this->showIntro = $export_show_intro;
		$this->showIf = $export_show_if;
		
		$this->skipEmpty = $export_data_skip_empty;
		
		$this->skipEmptySub = $export_data_skip_empty_sub;

		$this->path2Images = $site_path.'admin/survey/export/latexclasses/textemp/images/';

					
		//Prikazi GDPR v uvodu			
		$gdpr = new GDPR();
		$this->showGDPRIntro = $gdpr->isGDPRSurveyTemplate($this->anketa);
		if($this->showGDPRIntro){
			$this->GDPRIntro = $gdpr->getSurveyIntro($this->anketa);
		}
		if ($this->usr_id  != '') {
			$sqlR = sisplet_query("SELECT recnum FROM srv_user WHERE id = '$this->usr_id '");
			$rowR = mysqli_fetch_array($sqlR);
			$this->recnum = $rowR['recnum'];
		}
		
		//pridobitev nastavitev izvoza
		SurveySetting::getInstance()->Init($this->anketa);
		$this->export_data_show_recnum = SurveySetting::getInstance()->getSurveyMiscSetting('export_data_show_recnum');	//ali je potrebno pokazati recnum ob vsakem respondentu
		$this->exportDataPageBreak = (int)SurveySetting::getInstance()->getSurveyMiscSetting('export_data_PB');	//ali mora vsak izpis odgovorov respondenta zaceti na svoji strani

		SurveyStatusProfiles::Init($this->anketa);
		
		//if ( SurveyInfo::getInstance()->SurveyInit($this->anketa['id']) && $this->init())
		if ( SurveyInfo::getInstance()->SurveyInit($this->anketa) )
		{		
			$this->db_table = SurveyInfo::getInstance()->getSurveyArchiveDBString();
		}
		else{
			return false;
		}		
	}
	
	#funkcija, ki skrbi za izpis praznega vprasalnika in vprasalnika z odgovori enega respondenta
	public function displaySurvey($export_subtype='', $export_data_type='', $language=null){
		global $lang, $site_url;

		$this->language = $language;
		if($this->language!=-1){
			// Naložimo jezikovno datoteko
			$file = '../../lang/'.$this->language.'.php';
			include($file);
			$_SESSION['langX'] = $site_url .'lang/'.$this->language.'.php';
		}		
		
		$surveyExpanded = SurveyInfo::getInstance()->getSurveyColumn('expanded');
		
		// filtriramo spremenljivke glede na profil	
		SurveyVariablesProfiles :: Init($this->anketa);
		
		$dvp = SurveyUserSetting :: getInstance()->getSettings('default_variable_profile');
		$_currentVariableProfile = SurveyVariablesProfiles :: checkDefaultProfile($dvp);
		
		$tmp_svp_pv = SurveyVariablesProfiles :: getProfileVariables($_currentVariableProfile);
		
		foreach ( $tmp_svp_pv as $vid => $variable) {
			$tmp_svp_pv[$vid] = substr($vid, 0, strpos($vid, '_'));			
		}

		$tex = '';
		
		if($export_subtype=='q_data'){	//ce je vprasalnik za enega respondenta
			//pridobitev podatkov trenutnega respondenta za izpis Recnum
			$izbranStatusProfile = SurveyStatusProfiles :: getStatusAsQueryString();
			$sqluString = "SELECT id, last_status, lurker, recnum FROM srv_user WHERE ank_id = '".$this->anketa."' ".$izbranStatusProfile." AND deleted='0' AND preview='0' AND id='".$this->usr_id."' ORDER BY recnum";
			
			$sqlu = sisplet_query($sqluString);		
			$rowu = mysqli_fetch_array($sqlu);
			$recnum = $rowu['recnum'];
			if($recnum && $this->export_data_show_recnum){
				$recnumBesedilo = "(Recnum $recnum)";
			}else{
				$recnumBesedilo = "";
			}
			//pridobitev podatkov trenutnega respondenta za izpis Recnum - konec
					
			$tex .= '\MakeUppercase{\huge \textbf{'./* $lang['srv_respondent_answer']. */' '.$recnumBesedilo.'}}';	//izpisi "Odgovori respondenta"
			$tex .= $this->texNewLine;
			$tex .= $this->texNewLine;
		}
		//ce je potrebno izpisati GDPR besedilo v intro
		if($this->showGDPRIntro == 1){	
			$GDPRintro = strip_tags($this->GDPRIntro, '<a><img><ul><li><ol><br><p>');
			
			//$GDPRintro = $this->encodeTextHere($GDPRintro);			
			$GDPRintro = LatexDocument::encodeText($GDPRintro, 0, 0, 0, 'gdpr');

			$tex .= ' \textbf{'.$GDPRintro.'} ';

			//radio buttona
			if($export_subtype=='q_empty'){	//ce je prazen vprasalnik
				$radioButtonTex = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}");
				$tex .= '\\\\'.$radioButtonTex.' '.$lang['srv_gdpr_intro_no'];
				$tex .= '\\\\'.$radioButtonTex.' '.$lang['srv_gdpr_intro_yes'];
			}else{
				//pridobitev ID grupe
				$sqlGrupeStringGDPR = "SELECT id FROM srv_grupa WHERE ank_id='".$this->anketa."' ORDER BY vrstni_red";		
				$sqlGrupeGDPR = sisplet_query($sqlGrupeStringGDPR);
				$rowGrupeGDPR = mysqli_fetch_array( $sqlGrupeGDPR );
				$grupa = $rowGrupeGDPR['id'];
				//pridobitev ID grupe - konec
				
				//pridobitev informacije obiska strani oz. ankete				
				$sqlStringStran = "SELECT time_edit FROM srv_user_grupa".$this->db_table." WHERE usr_id='".$this->usr_id."' AND gru_id='".$grupa."'";
				
				$sqlStran = sisplet_query($sqlStringStran);
				$rowStran = mysqli_fetch_array( $sqlStran );
				$stran = $rowStran['time_edit'];
				
				//pridobitev informacije obiska strani oz. ankete - konec

				if($stran){
					$radioButtonTexNo = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}");
					$radioButtonTexYes = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio2}");
				}else{
					$radioButtonTexNo = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio2}");
					$radioButtonTexYes = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}");
				}

				$tex .= '\\\\'.$radioButtonTexNo.' '.$lang['srv_gdpr_intro_no'];
				$tex .= '\\\\'.$radioButtonTexYes.' '.$lang['srv_gdpr_intro_yes'];
				
			}
			
			
			//radio buttona - konec

			$tex .= $this->texNewLine;				
			$tex .= $this->texNewLine;
		}
		
		// ce obstaja intro izpisemo intro - pri izpisu vprasalnika brez odgovorov (ce smo na prvi strani moramo biti v razsirjenem nacinu)
		if( ($surveyExpanded != 0 || $this->type != 1) && $this->showIntro == 1 ){
			if ( SurveyInfo::getInstance()->getSurveyShowIntro() )
			{ 		
				//preverjanje, ali je prevod
				if(isset($_GET['language'])){
					//$this->language = $_GET['language'];
					$this->language = isset($_GET['language'])?$_GET['language']:null;
					$prevod = 1;
				}else{
					$prevod = 0;
				}
				//preverjanje, ali je prevod - konec

				if($prevod){ //ce je prevod ankete
					$spr_id_uvod = -1;
					$sqll = sisplet_query("SELECT naslov, info FROM srv_language_spremenljivka WHERE ank_id='".$this->anketa."' AND spr_id='".$spr_id_uvod."' AND lang_id='".$this->language."'");
					$rowl = mysqli_fetch_array($sqll);	//pridobi prevod uvoda v ustreznem jeziku
					$intro = $rowl['naslov'];	//prevod uvoda v ustreznem jeziku
				}else{
					$sqlIntroString = "SELECT introduction FROM srv_anketa WHERE id=".$this->anketa." ";
					$sqlIntro = sisplet_query($sqlIntroString);
					$rowl = mysqli_fetch_array($sqlIntro);	//pridobi besedilu uvoda
					$intro = $rowl['introduction'];	//prevod uvoda v ustreznem jeziku
				}			
				$tex .=  LatexDocument::encodeText($intro, 0, 0, 0, 'intro');
				if($intro){
					$tex .= "\r\n";
					$tex .= $this->texNewLine;
					$tex .= $this->texNewLine;
				}
			}
		}
		
		$sqlGrupeString = "SELECT id FROM srv_grupa WHERE ank_id='".$this->anketa."' ORDER BY vrstni_red";		
		$sqlGrupe = sisplet_query($sqlGrupeString);

		//echo "__________________________________</br>";
		//echo "Funkcija displaySurvey user: $this->usr_id</br>";
		if($this->export_format == 'rtf'){
			$tex .= $this->texNewLine;
		}

		$question = new LatexSurveyElement($this->anketa, $this->export_format, 0, $this->usr_id, $export_subtype, $language);
		########
		while ( $rowGrupe = mysqli_fetch_assoc( $sqlGrupe ) )
		{ // sprehodmo se skozi grupe ankete
			$this->grupa = $rowGrupe['id'];
			// Pogledamo prvo spremenljivko v grupi ce je v loopu
			$sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC");			
			$row = mysqli_fetch_array($sql);
			
			// ce je ima loop za parenta
			$if_id = isset(($row['id']))?$this->find_parent_loop($row['id']):null;

			if ($if_id > 0 && ($export_subtype=='q_data'||$export_subtype=='q_data_all')){	//ce je loop in (je izpis odgovorov respondentov)
				$texLoop = '';
				$sql1 = sisplet_query("SELECT if_id FROM srv_loop WHERE if_id = '$if_id'");
				$row1 = mysqli_fetch_array($sql1);
				
				$this->loop_id = $this->findNextLoopId($row1['if_id']);
				//echo "Loop id: ".$this->loop_id."</br>";
				//echo " id: ".$row['id']."</br>";
				$if = Cache::srv_if($if_id);
				//echo "If label: ".$if['label']."</br>";
				//echo "If : ".print_r($if)."</br>";
				$loop_title = $if['label'];
				
				// gremo cez vse spremenljivke v trenutnem loopu
				while($this->loop_id != null){
					//echo "Loop id: ".$this->loop_id."</br>";
					
					// Izrisemo naslov loopa
					$tex .= $this->dataPiping($loop_title);
					$zaporedna = 0;
					//TODO: TUdi tu se celotna spremenljivka prenaša naprej
					$sqlSpremenljivke = sisplet_query("SELECT id, tip, visible, sistem, variable, naslov, info, orientation, dostop, grids, ranking_k, enota, grid_subtitle1, grid_subtitle2, text_kosov, text_orientation, signature, upload, size, design, vsota FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC");
					
					while ($rowSpremenljivke = mysqli_fetch_assoc($sqlSpremenljivke))
					{ // sprehodimo se skozi spremenljivke grupe					
						
						$spremenljivka = $rowSpremenljivke['id'];
						
						if ($rowSpremenljivke['visible'] == 0 || !( ($this->admin_type <= $rowSpremenljivke['dostop'] && $this->admin_type>=0) || ($this->admin_type==-1 && $rowSpremenljivke['dostop']==4) ) ) {
							//echo "ni admin za sprem: ".$rowSpremenljivke['id']."</br>";
							continue;						
						}
						
						if($export_subtype=='q_data'||$export_subtype=='q_data_all'){	//ce je vprasalnik s podatki za enega ali vse respondente
							$preveriSpremenljivko = $this->checkSpremenljivkaData($spremenljivka, $this->loop_id);
						}else{	//ce je prazen vprasalnik ali vprasalnik s komentarji
							$preveriSpremenljivko = $this->checkSpremenljivka($spremenljivka);
						}
						
						//if ( $this->checkSpremenljivka ($spremenljivka) /*|| $this->showIf == 1*/ )
						if ($preveriSpremenljivko)	
						{ // lahko izrišemo spremenljivke

							// po potrebi obarvamo vprašanja
							//$this->pdf->SetTextColor(0);
							if ($rowSpremenljivke['visible'] == 0)
							{
								if ($rowSpremenljivke['sistem'] == 1)
								{ 		// če je oboje = vijolčno
									//$this->pdf->SetTextColor(128,0,128);
								}
								else
								{		// Če je skrito = rdeče
									//$this->pdf->SetTextColor(255,0,0);
								}
							}
							else if ($rowSpremenljivke['sistem'] == 1)
							{
							  //$this->pdf->SetTextColor(0,0,255);
							}

							// če imamo številčenje Type = 1 potem številčimo V1
							if (SurveyInfo::getInstance()->getSurveyCountType())
							$zaporedna++;
							$stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ?
							( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $rowSpremenljivke['variable'].") " : $zaporedna.") " ) : null;
										
							// Izpis vprasalnika z rezultati
							
							// Ce imamo kombinirano tabelo pogledamo ce prikazujemo katero od podtabel
							if($rowSpremenljivke['tip'] == 24){
								
								$subGrids = array();
								$showGridMultiple = false;
								
								// Loop po podskupinah gridov					
								$sqlSubGrid = sisplet_query("SELECT m.spr_id, s.tip, s.enota FROM srv_grid_multiple m, srv_spremenljivka s WHERE m.parent='".$spremenljivka."' AND m.spr_id=s.id");
								while($rowSubGrid = mysqli_fetch_array($sqlSubGrid)){					
									if(in_array($rowSubGrid['spr_id'],$tmp_svp_pv) || count($tmp_svp_pv) == 0){
										$showGridMultiple = true;
										break;
									}
								}
							}
							// ce je nastavljen profil s filtriranimi spremenljivkami
							if(in_array($spremenljivka,$tmp_svp_pv) || count($tmp_svp_pv) == 0 || ($rowSpremenljivke['tip'] == 24 && $showGridMultiple) || $rowSpremenljivke['tip'] == 5){
								
								$this->currentHeight = 0;
								
								//izpisi tekst vprasanja
								$tex .= $question->displayQuestionText($rowSpremenljivke, $stevilcenje, $export_subtype, $preveriSpremenljivko, $this->loop_id, $export_data_type);	//izpisi tekst vprasanja
								
								//izpisi odgovore								
								$tex  .= $question->displayAnswers($rowSpremenljivke, $export_subtype, $preveriSpremenljivko, $export_data_type, $this->loop_id);	//izpisi odgovore
							}											
						}
					}								
					$this->loop_id = $this->findNextLoopId();
					
					//ce je prazen vprasalnik, ustavi
					if($export_subtype=='q_empty'){
						break;
					}
				}
			}			
			// Navadne spremenljivke ki niso v loopu
			else{
				//echo "Ni v loop-u </br>";
				$loop_id = 'IS NULL';
				$zaporedna = 0;
				//TODO: Omenjen query je potrebno optimizirati in da se naprej samo prenaša ID, ki se potem v podfunkcijah kliče ustrezen query
                // trenutno se potrebuje:  id, tip, visible, sistem, variable, params				
				$sqlSpremenljivke = sisplet_query("SELECT id, tip, visible, sistem, variable, params, dostop, naslov, orientation, info, grids, ranking_k, enota, grid_subtitle1, grid_subtitle2, text_kosov, text_orientation, signature, upload, size, design, vsota FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC");
				while ($rowSpremenljivke = mysqli_fetch_assoc($sqlSpremenljivke)){ // sprehodimo se skozi spremenljivke grupe
					$spremenljivka = $rowSpremenljivke['id'];
					
					if ($rowSpremenljivke['visible'] == 0 || !( ($this->admin_type <= $rowSpremenljivke['dostop'] && $this->admin_type>=0) || ($this->admin_type==-1 && $rowSpremenljivke['dostop']==4) ) ) {
						//echo "ni admin za sprem: ".$rowSpremenljivke['id']."</br>";
						continue;						
					}

					//echo "Ni v loop-u:".$rowSpremenljivke['tip']."  </br>";
					if($export_subtype=='q_data'||$export_subtype=='q_data_all'){	//ce je vprasalnik s podatki za enega ali vse respondente
						$preveriSpremenljivko = $this->checkSpremenljivkaData($spremenljivka, $loop_id);
					}else{	//ce je prazen vprasalnik ali vprasalnik s komentarji
						$preveriSpremenljivko = $this->checkSpremenljivka($spremenljivka);
					}
					
					if ($preveriSpremenljivko)
					{ // lahko izrišemo spremenljivke

						// po potrebi obarvamo vprašanja
						//$this->pdf->SetTextColor(0);
						if ($rowSpremenljivke['visible'] == 0)
						{
							if ($rowSpremenljivke['sistem'] == 1)
							{ 		// če je oboje = vijolčno
								//$this->pdf->SetTextColor(128,0,128);
							}
							else
							{		// Če je skrito = rdeče
								//$this->pdf->SetTextColor(255,0,0);
							}
						}
						else if ($rowSpremenljivke['sistem'] == 1)
						  //$this->pdf->SetTextColor(0,0,255);


						// če imamo številčenje Type = 1 potem številčimo V1
						if (SurveyInfo::getInstance()->getSurveyCountType())
							$zaporedna++;
						$stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ?
						( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $rowSpremenljivke['variable'].") " : $zaporedna.") " ) : null;

						$this->currentHeight = 0;
						
						// izpis skrcenega vprasalnika (samo pri izpisu iz urejanja)
						if($surveyExpanded == 0 && $this->type == 1){
							//$this->outputVprasanjeCollapsed($rowSpremenljivke, $stevilcenje);
						}
						
						// izpis navadnega vprasalnika
						else{
							//echo "while stavek za".$rowSpremenljivke['id']." </br>";							
							$tex .= $question->displayQuestionText($rowSpremenljivke, $stevilcenje, $export_subtype, $preveriSpremenljivko, $this->loop_id, $export_data_type);	//izpisi tekst vprasanja							
							$tex .= $question->displayAnswers($rowSpremenljivke, $export_subtype, $preveriSpremenljivko, $export_data_type, $this->loop_id);	//izpisi odgovore
						}
						//$this->pdf->Ln(LINE_BREAK);
					}
				}
				//echo "Končni tex brez loopa: ".$tex."</br>";
			}
			//$tex .= $this->texBigSkip;
			if($this->export_format == 'rtf'){
				$tex .= $this->texBigSkip;
			}
			//$tex .= $texLoop;
			//echo "Končni tex: ".$tex."</br>";
		}
		//echo "Končni tex: ".$tex."</br>";
		// če izpisujemo grupo, ne izpisujemo zakljucka
		if ( !$this->getGrupa() ){
			if ( SurveyInfo::getInstance()->getSurveyShowConcl() && SurveyInfo::getInstance()->getSurveyConcl() )
			{		// ce obstaja footer izpisemo footer

			}
		}


        // Izpis grafa in tabele za NIJZ na koncu dokumenta
        global $site_domain;
        if( ($site_domain == 'test.1ka.si' && $this->anketa == '8892') || ($site_domain == 'anketa.nijz.si' && $this->anketa == '126738') ){	

            // Page break
            $tex .= '\cleardoublepage';

            // Naslov "Ocena bivalnega okolja"
            $tex .= '\begin{center} \textbf{Ocena bivalnega okolja} \end{center}';

            $nijz = new SurveyNIJZ($this->anketa, $this->usr_id);
            
            // Latex nijz slika grafa
            $tex .= $nijz->displayRadarLatex();

            // Latex nijz tabela
            $tex .= $nijz->displayTableLatex();
        }
		
		return $tex;
	}
	#funkcija, ki skrbi za izpis praznega vprasalnika in vprasalnika z odgovori enega respondenta - konec
	
	
	#funkcija, ki skrbi za izpis vseh odgovorov (vsi respondenti -> max 300)	//po outputAllResults() iz class.pdfIzvozResults.php
	public function displayAllSurveys($export_subtype='', $export_format='', $export_data_type=''){
		global $lang, $site_url;
		$tex = '';
		$izbranStatusProfile = SurveyStatusProfiles :: getStatusAsQueryString();
		
		$sqluString = "SELECT id, last_status, lurker, recnum FROM srv_user WHERE ank_id = '".$this->anketa."' ".$izbranStatusProfile." AND deleted='0' AND preview='0' ORDER BY recnum";
		//echo $sqluString;
		$sqlu = sisplet_query($sqluString);
		
		$numOfUsers = mysqli_num_rows($sqlu);	//stevilo respondentov
		
		if($numOfUsers > 300){
			$tex .= $lang['srv_export_all_respondent_data_error'].' ('.$numOfUsers.').';
		}		
		else{								
			//za vsak user oz respondent
			while($rowu = mysqli_fetch_array($sqlu)){								
				//belezenje statusa
				switch($rowu['last_status']){
					case '0':
						$status = $lang['srv_userstatus_0'];
						break;
					case '1':
						$status = $lang['srv_userstatus_1'];
						break;
					case '2':
						$status = $lang['srv_userstatus_2'];
						break;
					case '3':
						$status = $lang['srv_userstatus_3'];
						break;
					case '4':
						$status = $lang['srv_userstatus_4'];
						break;
					case '5':
						$status = $lang['srv_userstatus_5'];
						break;
					case '6':
						$status = $lang['srv_userstatus_6'];
						$status .= ($rowu['lurker'] == '1') ? ' - lurker' : '';
						break;
				}
				
				#prenos odgovorov vsakega respondenta na novo stran, če je to potrebno
				//if($this->exportDataPageBreak == 1){	//ce mora vsak respondent imeti svoje odgovore na svoji strani
				if($this->exportDataPageBreak == 1 && $export_format == 'pdf'){	//ce mora vsak respondent imeti svoje odgovore na svoji strani in je pdf izvoz, saj za rtf pagebreak ne deluje
					$tex .= $this->texPageBreak;
				}
				#prenos odgovorov vsakega respondenta na novo stran, če je to potrebno - konec
				
				//$this->export_data_show_recnum = 1;
				#izpis statusa respondenta in anketiranja
				if($this->export_data_show_recnum == 1){	//ce je potrebno pokazati stevilko respondenta					
					$tex .= '{\\Large Status '.$rowu['last_status'].' - '.$status.' (Recnum '.$rowu['recnum'].')} '.$this->texNewLine.' \\par ';					
				}else{
					$tex .= '{\\Large Status '.$rowu['last_status'].' - '.$status.$this->texNewLine.' \\par}';					
				}
				#izpis statusa respondenta in anketiranja - konec
				
				
				#izpis odgovorov posameznega userja
				$this->usr_id = $rowu['id'];
				
				#za pridobitev jezika respondenta
				if ($this->usr_id  != '') {					
					$sqlL = sisplet_query("SELECT language FROM srv_user WHERE id = '$this->usr_id ' ");
					$rowL = mysqli_fetch_array($sqlL);
					$language = $rowL['language'];					
				}
				#za pridobitev jezika respondenta - konec

				$tex .= $this->displaySurvey($export_subtype, $export_data_type, $language);
				#izpis odgovorov posameznega userja - konec
				
			}
		}
		return $tex;
	}
	#funkcija, ki skrbi za izpis vseh odgovorov (vsi respondenti -> max 300) - konec
	
	
	#funkcija, ki skrbi za izpis praznega vprasalnika s komentarji	//po outputCommentaries() iz class.pdfIzvoz.php
	public function displaySurveyCommentaries($export_subtype='', $export_data_type=''){	
		
		global $lang;
		global $site_url;
		global $admin_type;
		global $global_user_id;
		$texBigSkip = '\bigskip';
		$tex = '';
		
		$this->commentType = (isset($_GET['only_unresolved'])) ? $_GET['only_unresolved'] : 1;

		$f = new Forum;
		$c = 0;
		
		$b = new Branching($this->anketa);
		
		$rowi = SurveyInfo::getInstance()->getSurveyRow();

		SurveySetting::getInstance()->Init($this->anketa);
		$question_resp_comment_viewadminonly = SurveySetting::getInstance()->getSurveyMiscSetting('question_resp_comment_viewadminonly');
		$question_comment_viewadminonly = SurveySetting::getInstance()->getSurveyMiscSetting('question_comment_viewadminonly');
		$question_comment_viewauthor = SurveySetting::getInstance()->getSurveyMiscSetting('question_comment_viewauthor');
		$sortpostorder = SurveySetting::getInstance()->getSurveyMiscSetting('sortpostorder');
		$question_note_view = SurveySetting::getInstance()->getSurveyMiscSetting('question_note_view');
		$addfieldposition = SurveySetting::getInstance()->getSurveyMiscSetting('addfieldposition');
		$commentmarks = SurveySetting::getInstance()->getSurveyMiscSetting('commentmarks');
		$commentmarks_who = SurveySetting::getInstance()->getSurveyMiscSetting('commentmarks_who');
			
		$sqlString = "SELECT s.* 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";
		$sql = sisplet_query($sqlString);

		$question = new LatexSurveyElement($this->anketa, $this->export_format, 0, 0, 0);


 		if ( mysqli_num_rows($sql) > 0 && ( (int)$question_resp_comment_viewadminonly + (int)$question_comment_viewadminonly ) > 0 ) {
			$zaporedna = 0;
			while ($row = mysqli_fetch_array($sql)) {
				
				$sql1 = sisplet_query("SELECT thread, note FROM srv_spremenljivka WHERE id = '$row[id]'");
				$row1 = mysqli_fetch_array($sql1);
				
 				$orderby = $sortpostorder == 1 ? 'DESC' : 'ASC' ;
				$tid = $row1['thread'];	
				
				$only_unresolved = " ";
				$only_unresolved2 = " ";
				
				if ($this->commentType == 1) $only_unresolved = " AND ocena <= 1 "; 
				if ($this->commentType == 1) $only_unresolved2 = " AND text2 <= 1 "; 
				
				if ($this->commentType == 2) $only_unresolved = " AND ocena = 0 "; 
				if ($this->commentType == 2) $only_unresolved2 = " AND text2 = 0 "; 
				
				if ($this->commentType == 3) $only_unresolved = " AND ocena = 1 "; 
				if ($this->commentType == 3) $only_unresolved2 = " AND text2 = 1 "; 
				
				if ($this->commentType == 4) $only_unresolved = " AND ocena = 2 "; 
				if ($this->commentType == 4) $only_unresolved2 = " AND text2 = 2 "; 
				
				if ($this->commentType == 5) $only_unresolved = " AND ocena = 3 "; 
				if ($this->commentType == 5) $only_unresolved2 = " AND text2 = 3 "; 

				// če imamo številčenje Type = 1 potem številčimo V1
				if (SurveyInfo::getInstance()->getSurveyCountType())
				$zaporedna++;
				$stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ?
				( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $row['variable'].") " : $zaporedna.") " ) : null;
				
				
				$tema_vsebuje = substr($lang['srv_forum_intro'],0,10);		// da ne prikazujemo 1. default sporocila
				
				if ($admin_type <= $question_comment_viewadminonly) {	// vidi vse komentarje
					$sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE vsebina NOT LIKE '%{$tema_vsebuje}%' AND tid='$tid' $only_unresolved ORDER BY time $orderby, id $orderby");

				} elseif ($question_comment_viewauthor==1) {	// vidi samo svoje komentarje
					$sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE vsebina NOT LIKE '%{$tema_vsebuje}%' AND tid='$tid' $only_unresolved AND uid='$global_user_id' ORDER BY time $orderby, id $orderby");

				} else {												// ne vidi nobenih komentarjev
				    $sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE 1=0");
				}		
				
				$sql2 = sisplet_query("SELECT COUNT(*) AS count FROM srv_data_text".$this->db_table." WHERE spr_id='0' AND vre_id='$row[id]' $only_unresolved2");
				$row2 = mysqli_fetch_array($sql2);

				if ( mysqli_num_rows($sqlt) > 0 || $row2['count'] > 0 || $row1['note'] != '') {
					$c++;
					$preveriSpremenljivko = 0; //ni potrebno
					$tex .= $question->displayQuestionText($row, $stevilcenje, $export_subtype, $preveriSpremenljivko, null, $export_data_type);	//izpisi tekst vprasanja
					$tex .= $question->displayAnswers($row, $export_subtype, $preveriSpremenljivko, $export_data_type, null);	//izpisi odgovore
					
 					if ($admin_type <= $question_note_view || $question_note_view == '') {
						
						if ($row1['note'] != '') {

							//$tex .= $texNewLine;
							$tex .= $this->texNewLine;
							$tex .= LatexDocument::encodeText($lang['hour_comment']);

							//$tex .= $texNewLine;
							$tex .= $this->texNewLine;
							$tex .= LatexDocument::encodeText($row1['note']);
						}
					}
									
					// komentarji na vprasanje
					if ($row1['thread'] > 0) {
						
						if (mysqli_num_rows($sqlt) > 0) {							
							//$tex .= $texNewLine;
							$tex .= $this->texNewLine;
							$tex .= '\textcolor{komentar}{\textbf{'.LatexDocument::encodeText($lang['srv_admin_comment']).'}}';	//izpis naslova komentarjev
							$tex .= '\\\\';

							$i = 0;
							while ($rowt = mysqli_fetch_array($sqlt)) {

								$tex .= '\textbf{'.LatexDocument::encodeText($f->user($rowt['uid'])).'}';	//izpis imena trenutnega urednika
								
								$tex .= LatexDocument::encodeText(' ('.$f->datetime1($rowt['time']).'):');	//izpis datuma komentarja
								
								$tex .= '\\\\';

								// Popravimo vsebino ce imamo replike							
								$vsebina = $rowt['vsebina'];
								$odgovori = explode("<blockquote style=\"margin-left:20px\">", $vsebina);
								
								$tex .= LatexDocument::encodeText($odgovori[0]);	//izpis komentarja
								
								unset($odgovori[0]);
								foreach($odgovori as $odgovor){	//izpis replik
									$odgovor = explode('<br />', $odgovor);
									$avtor = explode('</b> ', $odgovor[0]);
									
									$tex .= '\\\\';
									$tex .= '\forceindent';	//da je indented
									$tex .= '\textbf{'.LatexDocument::encodeText($avtor[0]).'} ';	//avtor replike
									$tex .= LatexDocument::encodeText($avtor[1]); //izpis datuma replike
									
									$tex .= '\\\\';
									$tex .= '\forceindent ';	//da je indented
									$tex .= LatexDocument::encodeText($odgovor[1]); //izpis replike
								}
								
								// Crta
								$tex .= '\\\\';
								$tex .= '\noindent\rule{0.9\textwidth}{0.5pt} ';								
								$tex .= '\\\\';
							}			
						}
					}

					// komentarji respondentov
					if ($row2['count'] > 0) {
						
						if ($admin_type <= $question_resp_comment_viewadminonly) {
							$tex .= $this->texNewLine;
							$tex .= '\textcolor{komentar}{\textbf{'.LatexDocument::encodeText($lang['srv_repondent_comment']).'}}';	//izpisa naslova komentarjev
							$tex .= '\\\\';
							
							//$this->pdf->Ln(3);
							
							if ($this->commentType == 1) $only_unresolved = " AND d.text2 <= 1 "; else $only_unresolved = " ";
							
							$sqlt = sisplet_query("SELECT d.text AS text, u.time_edit AS time_edit FROM srv_data_text".$this->db_table." d, srv_user u WHERE d.spr_id='0' AND d.vre_id='$row[id]' AND u.id=d.usr_id $only_unresolved2 ORDER BY d.id ASC");
							if (!$sqlt) echo mysqli_error($GLOBALS['connect_db']);
							while ($rowt = mysqli_fetch_array($sqlt)) {
																
								$tex .= LatexDocument::encodeText($f->datetime1($rowt['time_edit']).':');	//izpis datuma komentarja
								
								$tex .= '\\\\';
								
								$tex .= LatexDocument::encodeText($rowt['text']);	//izpis komentarja respondenta
								
								$tex .= '\\\\';
								
								// Crta
								$tex .= '\noindent\rule{0.9\textwidth}{0.5pt} ';								
								$tex .= '\\\\';
								

							}
						}
					}
					
					//$this->pdf->Ln(LINE_BREAK);
					$tex .= $texBigSkip;
					$tex .= $texBigSkip;
				}
			}
	
			
		}
		
	
		return $tex;	
	}
	
	function getGrupa() {return $this->grupa;}
	
	
	/**
    * @desc preveri ali je spremenljivka vidna (zaradi branchinga)
    */
    function checkSpremenljivka ($spremenljivka=null) {

        $row = sisplet_query("SELECT visible FROM srv_spremenljivka WHERE id = '".$spremenljivka."'", "obj");
        if ($row->visible == 0) {
            return false;
        }

        //TODO: Omenjen del kode je nepotreben, ker vedno vrne true
        //$sql1 = sisplet_query("SELECT parent FROM srv_branching WHERE element_spr = '".$spremenljivka."'");
        //if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
        //$row1 = mysqli_fetch_array($sql1);

        /*if (!$this->checkIf($row1['parent']))
            return false;*/

        return true;
    }
	
    /**
    * @desc preveri ali je spremenljivka vidna (zaradi branchinga), ko je q_data ali q_data_all
    */
    //function checkSpremenljivkaData ($spremenljivka, $gridMultiple=false) {
    function checkSpremenljivkaData ($spremenljivka=null, $loop_id_raw=null, $gridMultiple=false) {
		
		$loop_id = $loop_id_raw == 'IS NULL' ? " IS NULL" : " = '".$loop_id_raw."'";
		
		//$row = sisplet_query("SELECT id, visible, dostop, tip, enota FROM srv_spremenljivka WHERE id = '".$spremenljivka."'", "array");
		$sql = sisplet_query("SELECT id, visible, dostop, tip, enota FROM srv_spremenljivka WHERE id = '".$spremenljivka."'");
        if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
		$row = mysqli_fetch_array($sql);
		
		// Ce vprasanje ni vidno ali ce uporabnik nima dostopa do vprasanja
        if ($row['visible'] == 0 || !( ($this->admin_type <= $row['dostop'] && $this->admin_type>=0) || ($this->admin_type==-1 && $row['dostop']==4) ) ) {
            return false;
        }
			
		// Kalklulacije in kvote ne prikazujemo
       	if($row['tip'] == 22 || $row['tip'] == 25) {
            return false;
        }
			
		// Preverjamo ce je vprasanje prazno in ce preskakujemo prazne
		if($this->skipEmpty==1 && !$gridMultiple){
			
			$isEmpty = true;
			//echo "isEmpty: ".$isEmpty."</br>";
			switch ( $row['tip'] ){
				case 1: //radio
				case 2: //check
				case 3: //select -> radio
					//$sqlUserAnswer = sisplet_query("SELECT * FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$row[id]' AND usr_id='".$this->usr_id."' AND vre_id!='-2'");
					$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$row[id]' AND usr_id='".$this->usr_id."' AND vre_id>'0' AND loop_id $loop_id ";
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					if($sqlUserAnswer->st > 0){
						$isEmpty = false;
					}						
				break;

				case 6: //multigrid
				case 16:// multicheckbox
				case 19:// multitext
				case 20:// multinumber											
					if($row['tip'] == 6 && $row['enota'] != 3){
						$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_grid".$this->db_table." WHERE spr_id = '".$row['id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
					}
					elseif($row['tip'] == 16 || ($row['tip'] == 6 && $row['enota'] == 3)){
						//$sqlUserAnswer = sisplet_query("SELECT * FROM srv_data_checkgrid".$this->db_table." WHERE spr_id = '".$row['id']."' AND usr_id = '".$this->usr_id."'");
						$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_checkgrid".$this->db_table." WHERE spr_id = '".$row['id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
					}
					else{
						//$sqlUserAnswer = sisplet_query("SELECT * FROM srv_data_textgrid".$this->db_table." WHERE spr_id = '".$row['id']."' AND usr_id = '".$this->usr_id."'");
						$sqlUserAnswerString ="SELECT COUNT(*) AS st FROM srv_data_textgrid".$this->db_table." WHERE spr_id = '".$row['id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
					}
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					//echo "stevilo podatkov: ".mysqli_num_rows($sqlUserAnswer)."</br>";
					if($sqlUserAnswer->st > 0){
						$isEmpty = false;	
					}
				break;
				
				case 7: //number
				case 8: //datum	
				case 18: //vsota
				case 21: //besedilo*
					$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_text".$this->db_table." WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' AND loop_id $loop_id";
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					if($sqlUserAnswer->st > 0)
						$isEmpty = false;				
				break;

				case 4: //besedilo*
					$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_text".$this->db_table." WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' AND loop_id $loop_id";
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					if($sqlUserAnswer->st > 0)
						$isEmpty = false;				
				break;
				
				case 17: //ranking					
					$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_rating WHERE spr_id=".$row['id']." AND usr_id='".$this->usr_id."' AND loop_id $loop_id";
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					if($sqlUserAnswer->st > 0)
						$isEmpty = false;
				break;
				
				case 24: //mesan multigrid	
					// loop po podskupinah gridov
					$sqlSubGrid = sisplet_query("SELECT m.spr_id AS spr_id, s.tip AS tip, s.enota FROM srv_grid_multiple AS m LEFT JOIN srv_spremenljivka AS s ON m.spr_id=s.id WHERE m.parent='".$spremenljivka."'");
					while($rowSubGrid = mysqli_fetch_array($sqlSubGrid)){
						if($rowSubGrid['tip'] == 6){
							$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_grid".$this->db_table." WHERE spr_id = '".$rowSubGrid['spr_id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
						}
						elseif($rowSubGrid['tip'] == 16){
							$sqlUserAnswerString ="SELECT COUNT(*) AS st FROM srv_data_checkgrid".$this->db_table." WHERE spr_id = '".$rowSubGrid['spr_id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
						}
						else{
							$sqlUserAnswerString = "SELECT COUNT(*) AS st FROM srv_data_textgrid".$this->db_table." WHERE spr_id = '".$rowSubGrid['spr_id']."' AND usr_id = '".$this->usr_id."' AND loop_id $loop_id";
						}

						$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
						if($sqlUserAnswer->st > 0){
							$isEmpty = false;	
							break;
						}
					}	
				break;
				
				case 5: //nagovor	
					// Ce je nagovor v loopu, ga prikazemo
					if($this->loop_id != null)
						$isEmpty = false;
				break;
				
				case 26: //lokacija
                                        //za podtip izberi lokacijo je treba preverjat posebej, ker se vrstica pri userju vedno kreira ampak brez odgovora
                                        if($row['enota'] == 3){
                                            $qu = "SELECT count(*) as cnt FROM srv_data_map WHERE spr_id='".$row['id']."' AND usr_id='$this->usr_id' AND loop_id $loop_id AND (text NOT REGEXP '^[+\-]?[0-9]+$' OR text>=0);";
                                            $sql = sisplet_query($qu, 'obj');
                                            if($sql->cnt > 0)
						$isEmpty = false;
                                        }
                                        else{
                                            //$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_map WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' ";
                                            $sqlUserAnswerString ="SELECT COUNT(*) AS st FROM srv_data_map WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' AND loop_id $loop_id";
                                            $sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
                                            if($sqlUserAnswer->st > 0)
                                                    $isEmpty = false;
                                        }
				break;
				
				case 27: //heatmap
					//$sqlUserAnswerString ="SELECT lat, lng, address, text FROM srv_data_heatmap WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' ";
					$sqlUserAnswerString ="SELECT COUNT(*) AS st FROM srv_data_heatmap WHERE spr_id='".$row['id']."' AND usr_id='".$this->usr_id."' AND loop_id $loop_id";
					$sqlUserAnswer = sisplet_query($sqlUserAnswerString, "obj");
					if($sqlUserAnswer->st > 0)
						$isEmpty = false;
				break;
				
				default:
					$isEmpty = false;
					//$isEmpty = true;
				break;
			}
			//echo "isEmpty na koncu: ".$isEmpty."</br>";
			if($isEmpty == true){
				return false;
			}
		}
        return true;
    }
	
	
	function displayIf($if=null){
		global $lang;
		//echo "</br> displayIf funkcija </br> ";
		$sql_if_string = "SELECT tip, number FROM srv_if WHERE id = '$if'";
		//echo "sql_if_string: ".$sql_if_string." </br>";
    	//$sql_if = sisplet_query("SELECT * FROM srv_if WHERE id = '$if'");
    	$sql_if = sisplet_query($sql_if_string);
    	$row_if = mysqli_fetch_array($sql_if);
		//echo "tip: ".$row_if['tip']." </br>";

        // Blok
		if($row_if['tip'] == 1)
			$output = strtoupper($lang['srv_block']).' ';
		// Loop
		elseif($row_if['tip'] == 2)
			$output = strtoupper($lang['srv_loop']).' ';
		// IF
		else
			$output = 'IF ';

		$output .= '('.$row_if['number'].') ';

        $sql = Cache::srv_condition($if);
        
        $bracket = 0;
        $i = 0;
         while ($row = mysqli_fetch_array($sql)) {

            if ($i++ != 0)
                if ($row['conjunction'] == 0)
                    $output .= ' and ';
                else
                    $output .= ' or ';

            if ($row['negation'] == 1)
                $output .= ' NOT ';

            for ($i=1; $i<=$row['left_bracket']; $i++)
				$output .=  ' ( ';

            // obicajne spremenljivke
            if ($row['spr_id'] > 0) {

				$row2 = Cache::srv_spremenljivka($row['spr_id']);
				
                // obicne spremenljivke
                if ($row['vre_id'] == 0) {
                    $row1 = Cache::srv_spremenljivka($row['spr_id']);
                // multigrid
                } elseif ($row['vre_id'] > 0) {
                    $sql1 = sisplet_query("SELECT variable FROM srv_vrednost WHERE id = '$row[vre_id]'");
                    $row1 = mysqli_fetch_array($sql1);
                } else
                    $row1 = null;

                $output .= $row1['variable'];

                // radio, checkbox, dropdown in multigrid
                if (($row2['tip'] <= 3 || $row2['tip'] == 6) && ($row['spr_id'] || $row['vre_id'])) {

                    if ($row['operator'] == 0)
                        $output .= ' = ';
                    else
                        $output .= ' != ';

                    $output .= '[';

                    // obicne spremenljivke
                    if ($row['vre_id'] == 0) {
                        $sql2 = sisplet_query("SELECT v.variable AS variable FROM srv_condition_vre c, srv_vrednost v WHERE cond_id='$row[id]' AND c.vre_id=v.id");

                        $j = 0;
                        while ($row2 = mysqli_fetch_array($sql2)) {
                            if ($j++ != 0) $output .= ', ';
                            $output .= $row2['variable'];
                        }
                    // multigrid
                    } elseif ($row['vre_id'] > 0) {
                        $sql2 = sisplet_query("SELECT g.variable AS variable FROM srv_condition_grid c, srv_grid g WHERE c.cond_id='$row[id]' AND c.grd_id=g.id AND g.spr_id='$row[spr_id]'");

                        $j = 0;
                        while ($row2 = mysqli_fetch_array($sql2)) {
                            if ($j++ != 0) $output .= ', ';
                            $output .= $row2['variable'];
                        }
                    }

                    $output .= ']';

                // textbox in nubmer mata drugacne pogoje in opcije
                } elseif ($row2['tip'] == 4 ||$row2['tip'] == 21 || $row2['tip'] == 7 || $row2['tip'] == 22) {

                    if ($row['operator'] == 0)
                        $output .= ' = ';
                    elseif ($row['operator'] == 1)
                        $output .= ' <> ';
                    elseif ($row['operator'] == 2)
                        $output .= ' < ';
                    elseif ($row['operator'] == 3)
                        $output .= ' <= ';
                    elseif ($row['operator'] == 4)
                        $output .= ' > ';
                    elseif ($row['operator'] == 5)
                        $output .= ' >= ';

                    $output .= '\''.$row['text'].'\'';

                }

            // recnum
            } elseif ($row['spr_id'] == -1) {

                $output .= 'mod(recnum, '.$row['modul'].') = '.$row['ostanek'];

			} 

            for ($i=1; $i<=$row['right_bracket']; $i++)
				$output .= ' ) ';
        }
        
        if ($row_if['label'] != '') {
	        $output .= ' (';
	        $output .= ' '.$row_if['label'].' ';
	        $output .= ') ';      		
        }

		return $output;
	}

	/* poisce, ce ima podani element parenta, ki je loop
	* 
	*/
	function find_parent_loop ($element_spr=null, $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['id']."'");
		$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);

		$row_parent = isset($row['parent'])?$row['parent']:null;
		
		if ($row_parent == 0) return 0;

		$count = sisplet_query("SELECT COUNT(*) AS st FROM srv_if WHERE id = '$row[parent]' AND tip = '2'", "obj");
		if ($count->st > 0) {
            return $row_parent;
        }else {
            return $this->find_parent_loop(0, $row_parent);
        }
	}	
	
		 /**
    * poisce naslednjo vre_id v loopu
    * 
    */
    function findNextLoopId ($if_id=0) {
		if ($if_id == 0) {
			$sql = sisplet_query("SELECT if_id FROM srv_loop_data WHERE id='$this->loop_id'");
			$row = mysqli_fetch_array($sql);
			$if_id = $row['if_id'];
			$loop_id = $this->loop_id;
		} else{
			$loop_id = 0;
		}

		$sql = sisplet_query("SELECT spr_id, max FROM srv_loop WHERE if_id = '$if_id'");
		$row = mysqli_fetch_array($sql);
		$spr_id = $row['spr_id'];
		$max = $row['max'];
		
		$spr = Cache::srv_spremenljivka($spr_id);
		//echo "spr tip: ".$spr['tip']."</br>";


		if ($spr['tip'] == 2 || $spr['tip'] == 3 || $spr['tip'] == 9) {
			$data_vrednost = array();
			if($spr['tip'] == 9){
				if($this->usr_id){
					$sql1String = "SELECT vre_id FROM srv_data_text".$this->db_table." WHERE spr_id='$spr_id' AND usr_id='".$this->usr_id."' ";
				}else{
					$sql1String = "SELECT vre_id FROM srv_data_text".$this->db_table." WHERE spr_id='$spr_id' ";
				}
			}
			else{
 				if($this->usr_id){
					$sql1String = "SELECT vre_id FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$spr_id' AND usr_id='".$this->usr_id."'";
				}else{
					$sql1String = "SELECT vre_id FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$spr_id' ";
				}				
			}
			//echo "sql1String: ".$sql1String."</br>";
			$sql1 = sisplet_query($sql1String);
			while ($row1 = mysqli_fetch_array($sql1)) {
				$data_vrednost[$row1['vre_id']] = 1;
			}
			
			$vre_id = '';
			$i = 1;
			//$sql = sisplet_query("SELECT * FROM srv_loop_vre WHERE if_id='$if_id'");

			$sql = sisplet_query("SELECT lv.vre_id AS vre_id, lv.tip AS tip FROM srv_loop_vre lv, srv_vrednost v WHERE lv.if_id='$if_id' AND lv.vre_id=v.id ORDER BY v.vrstni_red ASC");
			while ($row = mysqli_fetch_array($sql)) {
				
				if ($row['tip'] == 0) {			// izbran
					if ( isset($data_vrednost[$row['vre_id']]) ) {
						$vre_id .= ', '.$row['vre_id'];
						$i++;
					}
				} elseif ($row['tip'] == 1) {	// ni izbran
					if ( !isset($data_vrednost[$row['vre_id']]) ) {
						$vre_id .= ', '.$row['vre_id'];
						$i++;
					}
				} elseif ($row['tip'] == 2) {	// vedno
					$vre_id .= ', '.$row['vre_id'];
					$i++;
				}								// nikoli nimamo sploh v bazi, zato ni potrebno nic, ker se nikoli ne prikaze
				
				if ($i > $max && $max>0) break;
			}
			
			$vre_id = substr($vre_id, 2);
			
			if ($vre_id == '') return null;

			//Stari query srv_vrednost se ni nikjer uporabljal
			//$sql = sisplet_query("SELECT l.* FROM srv_loop_data l, srv_vrednost v WHERE l.if_id='$if_id' AND l.id > '$loop_id' AND l.vre_id IN ($vre_id) AND l.vre_id=v.id ORDER BY l.id ASC");
			//Problematicni sql, ker ocitno tale zadeva z obj ne dela najbolje
			//$sql = sisplet_query("SELECT id FROM srv_loop_data WHERE if_id='$if_id' AND id > '$loop_id' AND vre_id IN ($vre_id) ORDER BY id ASC", "obj");	
						
			$sqlTestString = "SELECT id FROM srv_loop_data WHERE if_id='$if_id' AND id > '$loop_id' AND vre_id IN ($vre_id) ORDER BY id ASC";
			//echo "sqlString: ".$sqlTestString."</br>";
			$sqlTest = sisplet_query($sqlTestString);
			$rowTest = mysqli_fetch_array($sqlTest);
			
			if (count($sql) > 0)
				return $rowTest['id'];
				//return $sql->id;
			else
				return null;
				
		// number
		} elseif ($spr['tip'] == 7) {
			
			//$sql1 = sisplet_query("SELECT text FROM srv_data_text".$this->db_table." WHERE spr_id='$spr_id' AND usr_id='".$this->getUserId()."'");
			$sql1String = "SELECT text FROM srv_data_text".$this->db_table." WHERE spr_id='$spr_id' AND usr_id='".$this->usr_id."'";
			//echo "sql1String: ".$sql1String."</br>";
			$sql1 = sisplet_query($sql1String);
			$row1 = mysqli_fetch_array($sql1);
			
			$num = (int)$row1['text'];

			//$countLoopManjsi = sisplet_query("SELECT COUNT(*) AS st FROM srv_loop_data WHERE if_id='$if_id' AND id <= '$loop_id'", "obj");
			$countLoopManjsiString = "SELECT COUNT(*) AS st FROM srv_loop_data WHERE if_id='$if_id' AND id <= '$loop_id'";
			$countLoopManjsi = sisplet_query($countLoopManjsiString);
			$rowcountLoopManjsi = mysqli_fetch_array($countLoopManjsi);
			//echo "countLoopManjsiString: ".$countLoopManjsiString."</br>";
			//if ($countLoopManjsi->st >= $num || ($countLoopManjsi->st >= $max && $max>0)) {
			if ($rowcountLoopManjsi['st'] >= $num || ($rowcountLoopManjsi['st'] >= $max && $max>0)) {
                return null;
            }

			//$loopVecji = sisplet_query("SELECT id FROM srv_loop_data WHERE if_id='$if_id' AND id > '$loop_id'", "obj");
			$loopVecjiString = "SELECT id FROM srv_loop_data WHERE if_id='$if_id' AND id > '$loop_id'";
			//echo "loopVecjiString: ".$loopVecjiString."</br>";
			$loopVecji = sisplet_query($loopVecjiString);
			$rowcountLoopVecji = mysqli_fetch_array($loopVecji);
			//if (count($loopVecji) > 0) {
			if (mysqli_num_rows($loopVecji) > 0) {
				//return $loopVecji->id;				
				return $rowcountLoopVecji['id'];
            }else {
                return null;
            }
			
		}
    }
	
		/**
    * @desc V podanem stringu poisce spremenljivke in jih spajpa z vrednostmi
    */
    function dataPiping ($text='') {
    	Common::getInstance()->Init($this->anketa);
        return Common::getInstance()->dataPiping($text, $this->usr_id, $this->loop_id);
	}
	
	#funkcija ki skrbi za encode dolocenih spornih delov besedila v latex-u prijazno
	function encodeTextHere($text='', $vre_id=0, $naslovStolpca = 0, $img_id=0){
		global $site_path, $lang;
		//$text = str_replace(' ','X',$text);	//nadomesti presledke
		//echo "Encoding ".$text."</br>";
		//echo "vre_id: ".$vre_id."</br>";
		//echo "ime spremenljivke ".$this->variableName."</br>";
				
		$text = ($text!=null && $text='' ? htmlspecialchars_decode($text) : '');		//vse html special chars kot je &amp; spremeni v ustrezne simbole (npr. &amp;=>&) 
		
		//resevanje razbirajanja predolgih neprekinjenih besed in URL - spremenljivke za kasnejsi prilagojen izpis
		//$numOfWords = str_word_count($text, 0);
		$numOfSpacesPrej = substr_count($text, ' '); //stevilo presledkov v besedilu
		$stringLength = strlen($text);

		$findSpace = ' ';
		$posSpace1 = strpos($text, $findSpace);	//najdi pozicijo prvega presledka v besedilu
		$posSpace2 = strripos($text, $findSpace);	//najdi pozicijo zadnjega presledka v besedilu
		
		
		$findHttp = 'http://';
		$findHttps = 'https://';
		$posHttp = strpos($text, $findHttp);
		$posHttps = strpos($text, $findHttps);
		$isURL = 0;
		/* if($posHttp !== false || $posHttps !== false) {	//imamo URL naslov			
			$isURL = 1;
		} */
		//resevanje razbirajanja predolgih neprekinjenih besed in URL - konec
		
		$this->path2UploadedImages = $site_path.'uploadi/editor/';
		if($text == ''){	//ce ni teksta, vrni se
			return;			
		}
		$textOrig = $text;
		$findme = '<br />';
		$findmeLength = strlen($findme);
		$findImg = '<img';		
		$findImgLength = strlen($findImg);
		$findUl = '<ul';
		$findUlLength = strlen($findUl);
		$findOl = '<ol';		
		$findLi = '<li';
		
		$findPar = '<p>';
		
		$pos = strpos($text, $findme);
		$posImg = strpos($text, $findImg);
		$posUl = strpos($text, $findUl);
		$posOl = strpos($text, $findOl);
		$posLi = strpos($text, $findLi);
		$posPar = strpos($text, $findPar);

		//echo "pozicija paragrafa: $posPar </br>";

		//ureditev izrisa slike
		if($posImg !== false){
			$numOfImgs = substr_count($text, $findImg);	//stevilo '<img	' v tekstu
			$posImg = strpos($text, $findImg);
			$textPrej = '';
			$textPotem = '';			
			for($i=0; $i<$numOfImgs; $i++){				
				$posImg = strpos($text, $findImg);
				$textPrej = substr($text, 0, $posImg);	//tekst do img
				$textPotem = substr($text, $posImg);	//tekst po img, z vkljuceno hmlt kodo z img
				$posImgEnd = strpos($textPotem, '/>');	//pozicija, kjer se konca html koda za img
				$textPotem = substr($textPotem, $posImgEnd+strlen('/>'));	//tekst od konca html kode za img dalje
				
				$imageName = $this->path2UploadedImages."".$this->getImageName($text, 0, '<img', $vre_id, $img_id);				
				$imageNameTest = $imageName.'.png';	//za preveriti, ali obstaja slikovna datoteka na strezniku
				//echo $imageName."</br>";
				//error_log("iz survey element: ".$imageNameTest);
				//echo("iz survey element imageNameTest: ".$imageNameTest."</br>");
				//echo "Obstaja ? ".file_exists($imageNameTest)."</br>";
				//echo("iz survey element imageName: ".$imageName."</br>");
				//echo "velikost: ".filesize($imageNameTest)."</br>";
/* 				if(filesize($imageNameTest) > 0){
					$text = $textPrej.' '.PIC_SIZE_ANS."{".$imageName."}".' '.$textPotem;
				}else{
					$image = $lang['srv_pc_unavailable'];
					$text = $textPrej.' '.$image.' '.$textPotem;
				} */
				$text = '';
				//$text = $textPrej.' ';
				
				//if(filesize($imageNameTest) > 0){
				if(file_exists($imageNameTest)){
					$text .= $textPrej.' '.PIC_SIZE_ANS."{".$imageName."}";
				}else{
					$image = $lang['srv_pc_unavailable'];
					$text .= $image;					
				}
				$text .= ' '.$textPotem;
			}
			
			//pred ureditvijo posebnih karakterjev, odstrani del teksta s kodo za sliko, da se ne pojavijo tezave zaradi imena datoteke od slike
			$findImgCode = '\includegraphics';
			$posOfImgCode = strpos($text, $findImgCode);
			//echo $posOfImgCode."</br>";
			$textToImgCode = substr($text, 0, $posOfImgCode);	//tekst do $findImgCode
			//echo $textToImgCode."</br>";
			$textFromImgCode = substr($text, $posOfImgCode);	//tekst po $findImgCode
			//echo $textFromImgCode."</br>";
			$findImgCodeEnd = '}';
			//$posOfImgCodeEnd = strpos($text,  $findImgCodeEnd);
			$posOfImgCodeEnd = strpos($textFromImgCode, $findImgCodeEnd);
			//echo $posOfImgCodeEnd."</br>";
			$textAfterImgCode = substr($textFromImgCode, $posOfImgCodeEnd+1);	//tekst po $findImgCodeEnd
			//echo $textAfterImgCode."</br>";
			$textOfImgCode = substr($text, $posOfImgCode, $posOfImgCodeEnd+1);
			//echo $textOfImgCode."</br>";
			
			$text = $textToImgCode.$textAfterImgCode;
			
			//pred ureditvijo posebnih karakterjev, odstrani del teksta s kodo za sliko, da se ne pojavijo tezave zaradi imena datoteke od slike - konec
		}
		//ureditev izrisa slike - konec

		//ureditev posebnih karakterjev za Latex	http://www.cespedes.org/blog/85/how-to-escape-latex-special-characters, https://en.wikibooks.org/wiki/LaTeX/Special_Characters#Other_symbols
		$text = str_replace('\\','\textbackslash{} ',$text);
		//$text = str_replace('{','\{',$text);		
		//$text = str_replace('}','\}',$text);	
		$text = str_replace('$','\$ ',$text);
		
		if(substr_count($text, '#')){	//ce je stevilo # vecje od 1
			$text = str_replace('#','\#',$text);
		}else{
			$text = str_replace('#','\# ',$text);
		}				
		$text = str_replace('%','\% ',$text);		
		$text = str_replace('€','\euro',$text);		
		$text = str_replace('^','\textasciicircum{} ',$text);		
		$text = str_replace('_','\_ ',$text);	
		$text = str_replace('~','\textasciitilde{} ',$text);		
		if(strpos($text, '&amp;')){	//ce je prisotno v besedilu &amp;'
			$text = str_replace('&amp;','\& ',$text);	
		}else{
			$text = str_replace('&','\& ',$text);				
		}
		$text = str_replace('&nbsp;','~',$text);
		//$text = str_replace('&lt;','\textless ',$text);
		$text = str_replace('&lt;',' \textless ',$text);
		//$text = str_replace('&gt;','\textgreater ',$text);
		$text = str_replace('&gt;',' \textgreater ',$text);
		//ureditev posebnih karakterjev za Latex - konec
		
		//ureditev grskih crk
		/* $text = str_replace('α','\textalpha ',$text); //ά
		$text = str_replace('ά','\textalpha ',$text);
		$text = str_replace('β','\textbeta ',$text);
		$text = str_replace('γ','\textgamma ',$text);
		$text = str_replace('δ','\textdelta ',$text);
		$text = str_replace('ε','\textepsilon ',$text);
		$text = str_replace('ζ','\textzeta ',$text);
		$text = str_replace('η','\texteta ',$text);
		$text = str_replace('θ','\texttheta ',$text);
		$text = str_replace('ι','\textiota ',$text);
		$text = str_replace('κ','\textkappa ',$text);
		$text = str_replace('λ','\textlambda ',$text);
		$text = str_replace('μ','\textmugreek ',$text);
		$text = str_replace('ν','\textnu ',$text);
		$text = str_replace('ξ','\textxi ',$text); */
		//$text = str_replace('ο','o',$text); // \textomicron ne dela
		//$text = str_replace('ο','\textgreek{ο}',$text);
		//$text = str_replace('ς','\textvarsigma ',$text);
		/* $text = str_replace('ς','\textgreek{ς}',$text);
		$text = str_replace('π','\textpi ',$text);
		$text = str_replace('ρ','\textrho ',$text);
		$text = str_replace('σ','\textsigma ',$text);
		$text = str_replace('τ','\texttau ',$text);
		$text = str_replace('υ','\textupsilon ',$text);
		$text = str_replace('φ','\textphi ',$text);
		$text = str_replace('χ','\textchi ',$text);
		$text = str_replace('ψ','\textpsi ',$text);
		$text = str_replace('ω','\textomega ',$text);
		$text = str_replace('ύ','\textgreek{ύ}',$text); */
		//ureditev grskih crk - konec

		//ureditev ostalih posebnih crk
		$text = str_replace('ə','\textschwa ',$text);		
		//ureditev ostalih posebnih crk - konec


		//ureditev preureditve html kode ul in li v latex itemize
 		if($posUl !== false){			
			//echo "text prej: ".$text."</br>";
			$numOfUl = substr_count($text, $findUl);	//stevilo '<ul' v tekstu
			//echo "numOfUl ".$numOfUl."</br>";			
			######################
			//if($numOfUl!=0){
			if($numOfUl!=0 && $posLi !== false){	//ce imamo ul in li				
				$text = str_replace('<ul>','\begin{itemize} ', $text);
				$text = str_replace('<ul','\begin{itemize} ', $text);
/* 				$text = str_replace('<li>','\item ', $text);
				$text = str_replace('<li','\item ', $text); */
				$text = str_replace('<li>','\item \ ', $text);
				$text = str_replace('<li','\item \ ', $text);
				$text = str_replace('</ul>','\end{itemize} \ ', $text);					
			}
			//echo "prazno v html: ".strpos($text, '\r')."</br>";
			//echo "text potem: ".$text."</br>";
			######################
		}
		//ureditev preureditve html kode ul in li v latex itemize - konec

		//ureditev preureditve html kode ol in li v latex enumerate, ki je ostevilcen
		if($posOl !== false){			
			//echo "text prej: ".$text."</br>";
			$numOfOl = substr_count($text, $findOl);	//stevilo '<ol' v tekstu
			//echo "numOfUl ".$numOfUl."</br>";			
			######################
			//if($numOfUl!=0){
			if($numOfOl!=0 && $posLi !== false){	//ce imamo ol in li				
				$text = str_replace('<ol>','\begin{enumerate} ', $text);
/* 				$text = str_replace('<li>','\item ', $text);
				$text = str_replace('<li','\item ', $text); */
				$text = str_replace('<li>','\item \ ', $text);
				$text = str_replace('<li','\item \ ', $text);
				$text = str_replace('</ol>','\end{enumerate} \ ', $text);					
			}
			//echo "prazno v html: ".strpos($text, '\r')."</br>";
			//echo "text potem: ".$text."</br>";
			######################
		}
		//ureditev preureditve html kode ol in li v latex enumerate, ki je ostevilcen - konec
		
		//po ureditvi posebnih karakterjev, dodati del teksta s kodo za sliko, ce je slika prisotna
		if($posImg !== false){
			$text = substr_replace($text, $textOfImgCode, $posOfImgCode, 0);
		}
		//po ureditvi posebnih karakterjev, dodati del teksta s kodo za sliko, ce je slika prisotna	
		
		if($posPar !== false){	//ce je kaksen html tag <p>, dodaj prazno vrstico oz. break			
			if($this->variableName=='gdpr'){
				if($numOfUl!=0 && $posLi !== false){	//ce imamo ul in li	
					$divider = ' ';
				}else{
					$divider = ' \\ \\\\ ';
				}
				$text = str_replace('<p>',$divider, $text);
			}else{				
				$text = str_replace('<p>',' ', $text);
			}			
		}

		
		//priprava izpisa zelo dolgega besedila brez presledkov (URL, email, ...)
		//if($numOfSpacesPrej == 0 && ($stringLength >= MAX_STRING_LENGTH)){	//ce v besedilu ni presledkov in je besedilo daljse od max dovoljene dolzine
		if( ($numOfSpacesPrej == 0 && ($stringLength >= MAX_STRING_LENGTH)) || ($numOfSpacesPrej == 1 && $posSpace1 == $posSpace2 && $stringLength >= MAX_STRING_LENGTH)){	//ce v besedilu ni presledkov in je besedilo daljse od max dovoljene dolzine
			//$text = "\seqsplit{".$text."}"; //ni v redu seqsplit, ker ne dela, če so posebni znaki			
			$text = substr_replace($text, $this->texNewLine, MAX_STRING_LENGTH, 0);	//dodaj na ustrezni dolzini besedila prehod v novo vrstico
		}
		//priprava izpisa zelo dolgega besedila brez presledkov - konec
		
		//echo "text potem: ".$text."</br>";
		
		//detekcija prisotnosti e-naslova v besedilu in primerna preureditev, da pride do pravilnega izpisa
		$findAt = '@1'; //IZKLOPIL DETEKCIJO, KER DELA TUDI BREZ TEGA
		$numOfAt = substr_count($text, $findAt);	//stevilo '@' v besedilu
		$findNewline = 'br';
		
		$text = preg_replace("/<\/?a( [^>]*)?>/i", "", $text); //remove anchor tag from string <a href= ... </a>, to se je uredilo za rešiti <a href= mailto: ...
		
		$posAt = strpos($text, $findAt);
		if($posAt && $posSpace1){	//ce je prisotna afna in je prisoten presledek v besedilu
						
			$posSpace1Mail = strpos(substr($text, $posAt), $findSpace);	//najdi pozicijo prvega presledka v besedilu po e-naslovu
			$posSpace1Mail = $posSpace1Mail+$posAt;	//koncna pozicija, ce se gleda celotno besedilo
			//echo "pozicija prvega presledka v besedilu po e-naslovu: ".$posSpace1Mail."</br>";
			
			//najdi prvi presledek pred afno			
			$posSpace2Mail = strripos(substr($text, 0, $posAt), $findSpace);	//najdi pozicijo zadnjega presledka v besedilu pred e-naslovom
			//echo "pozicijo zadnjega presledka v besedilu pred e-naslovom: ".$posSpace2Mail."</br>";

			

			//najdi prvi simbol za v novo vrstico "br" po afni
			//echo substr($text, $posAt) ."</br>";			
			$posNewLineMail = strpos(substr($text, $posAt), $findNewline);	//najdi pozicijo prvega simbola za v novo vrstico v besedilu po e-naslovu
			$posNewLineMail = $posNewLineMail+$posAt-1;	//koncna pozicija, ce se gleda celotno besedilo
			
			if($posSpace1Mail<$posNewLineMail){	//ce se po e-naslovu pojavi prej presledek
				$posKonec = $posSpace1Mail; //se zakljuci pri presledku, ker je ta lokacija za zakljucek url
			}else{
				$posKonec = $posNewLineMail;	//se zakljuci pred simbolom za novo vrstico, ker je ta lokacija za zakljucek url
			}
			//echo "posKonec: ".$posKonec."</br>";

			//dodaj po e-naslovu potrebno latex kodo za zakljucek url
			//$text = substr_replace($text, '}', $posSpace1Mail, 0);
			$text = substr_replace($text, '}', $posKonec, 0);
			
			//dodaj pred e-naslovom potrebno latex kodo za url			
			//substr_replace(string_name, replacement_string, start_pos, length)
			$text = substr_replace($text, ' \url{', $posSpace2Mail, 0);
			//echo $text."</br>";

		}
		//detekcija prisotnosti e-naslova v besedilu  in primerna preureditev, da pride do pravilnega izpisa - konec


		//RESEVANJE BESEDILA V CIRILICI
		$contains_cyrillic = (bool) preg_match('/[\p{Cyrillic}]/u', $text);	//ali je v besedilu cirilica?		
		if($contains_cyrillic){	// ce je cirilica v besedilu
			$text = '\foreignlanguage{russian}{'.$text.'}';
		}
		//RESEVANJE BESEDILA V CIRILICI - konec

		

		//RESEVANJE odstranitve dodatnih style tag-ov po ul, ipd. #######################################################
		$findStyleTagFull = '<style="';
		$findStyleTagIn = 'style="';		
		$findStyleTagEnd = '">';
		$numOfStyleTagsFull = substr_count($text, $findStyleTagFull);	//stevilo '<style=" ' v tekstu
		$numOfStyleTagsIn = substr_count($text, $findStyleTagIn);	//stevilo 'style=" ' v tekstu
		if($numOfStyleTagsFull){
			$numOfStyleTags = $numOfStyleTagsFull;
			$findStyleTag = $findStyleTagFull;
			$offset = 2;
		}else{
			$numOfStyleTags = $numOfStyleTagsIn;
			$findStyleTag = $findStyleTagIn;
			$offset = 1;
		}
		for($s=0; $s<$numOfStyleTags; $s++){	//za vsako najdeno 'style=" ' besedilo, uredi njeno odstranitev			
			$posStyleTag = strpos($text, $findStyleTag);			
			$posStyleTagEnd = strpos($text, $findStyleTagEnd, $posStyleTag);	//strpos(string,find,start) najdi $findStyleTagEnd v $text, isci od $posStyleTag dalje
			$dolzinaOff = $posStyleTagEnd - $posStyleTag + $offset;
			$text = substr_replace($text, "", $posStyleTag, $dolzinaOff); //substr_replace(string,replacement,start,length)		
		}
		//RESEVANJE odstranitve dodatnih style tag-ov po ul, ipd. - konec #################################################

		//echo 	"po style: ".$text."</br>";

 		if($pos === false && $posImg === false) {	//v tekstu ni br in img 		
			
			$text = preg_replace("/(\R){2,}/", "$1", $text);
			return strip_tags($text);
		}else {	//v tekstu sta prisotna br ali img		
			$text2Return = '';	//tekst ki bo vrnjen
										
			//ureditev preureditev html kode za novo vrstico v latex, ureditev prenosa v novo vrstico
			if($naslovStolpca==0){	// ce besedilo ni naslov stolpca tabele
				if($pos !== false){
					$pos = strpos($text, $findme);
					$numOfBr = substr_count($text, $findme);	//stevilo '<br />' v tekstu
					for($i=0; $i<$numOfBr; $i++){
						if($i == 0){	//ce je prvi najdeni '<br />'
							$textPrej = substr($text, 0, $pos);
							$textPotem = substr($text, $pos+$findmeLength);
							if($i == $numOfBr-1){							
								//$text2Return .= $textPrej.' \break '.$textPotem;
								$text2Return .= $textPrej.' \\\\ '.$textPotem;
							}else{
								//$text2Return .= $textPrej.' \break ';
								$text2Return .= $textPrej.' \\\\ ';
							}
						}else{	//drugace
							$pos = strpos($textPotem, $findme);
							$textPrej = substr($textPotem, 0, $pos);
							$textPotem = substr($textPotem, $pos+$findmeLength);
							if($i == $numOfBr-1){
								//$text2Return .= $textPrej.' \break '.$textPotem;
								$text2Return .= $textPrej.' \\\\ '.$textPotem;
							}else{
								//$text2Return .= $textPrej.' \break ';
								$text2Return .= $textPrej.' \\\\ ';
							}
						}
					}
					$text = $text2Return;
				}
			}
			//ureditev preureditev html kode za novo vrstico v latex, ureditev prenosa v novo vrstico - konec
			//echo "text potem: ".$text."</br>";
			$text = preg_replace("/(\R){2,}/", "$1", $text);
			return strip_tags($text);	//vrni tekst brez html tag-ov
		}
	}
	#funkcija ki skrbi za encode dolocenih spornih delov besedila v latex-u prijazno - konec

	#funkcija, ki skrbi za pridobitev imena slike, ki jo je potrebno izrisati ######################################
	function getImageName($text='', $sprId=null, $findme='', $vre_id=0, $img_id=0){
		global $site_path, $site_url;
		$imageName = '';
		//echo "id slike $img_id </br>";
		if($text == 'hotspot' && $findme == 'hotspot_image='){
			$sqlParametrov = sisplet_query("SELECT params FROM srv_spremenljivka WHERE id='".$sprId."'");
			$rowParametrov = mysqli_fetch_row($sqlParametrov);
			$text = $rowParametrov[0];
		}

		$pos = strpos($text, $findme);	//najdi pozicijo teksta v $findme
		//echo "text za echo: ".$text."</br>";
		//if($pos!=''){	//ce je slika v bazi
		if($pos!=''||$pos==0){	//ce je slika v bazi
			$imageName = substr($text,$pos);	//pokazi le del text od besedila $findme dalje (vkljucno z besedilom)
			//echo "imageName prej: ".$imageName."</br>";
			
			//$findme = $site_path.'uploadi/editor/';
			$findme = $site_url.'uploadi/editor/';
			//$findme = 'uploadi/editor/';
			//$findme = 'editor/';
			//echo "findme: ".$findme."</br>";
			$pos = strpos($imageName, $findme);	//najdi pozicijo teksta v $findme
			//echo "najdi tole: ".$findme."</br>";
			//echo "najdi tukaj: ".$imageName."</br>";
			//echo "pozicija tega: ".$pos."</br>";
			if($pos){	//ce je slika na strezniku
				$slikaNaStrezniku = 1;
			}else{//ce slike ni na strezniku
				$slikaNaStrezniku = 0;
			}
			//echo "ali je slika na strežniku: ".$slikaNaStrezniku."</br>";
			if($slikaNaStrezniku==1){	//ce je slika na strezniku
				$findEditor = 'editor/';				
				$posEditor = strpos($imageName, $findEditor);	//najdi pozicijo teksta v $findEditor
				$imageName = substr($imageName,$posEditor+7);	//pokazi le del params od besedila 'editor/' dalje, brez besedila 'editor/'				
				//echo "imagename : ".$imageName."</br>";
				$pos = $this->getEndPosition($imageName);	//najdi pozicijo konca URL slike	
				$imageExtension = substr($imageName, $pos-3, 3);	//pridobi koncnico slike (za gif je potrebno sliko pretvoriti v png, saj latex ne podpira gif)
				$imageName = substr($imageName, 0, $pos);	//pokazi le del params od zacetka besedila do '"' oz. konca URL slike
				
				$path = $site_path.'uploadi/editor/'.$imageName;
				//$path = $site_url.'uploadi/editor/'.$imageName;
							
				if($imageExtension == 'gif'){	//ce je slika gif, jo je potrebno pretvoriti v png					
					$this->convertGifToPng($path, $slikaNaStrezniku);
				}

				if($imageExtension == 'jpg' || $imageExtension == 'peg'){	//ce je slika jpg ali jpeg, jo je potrebno pretvoriti v png					
					$this->convertJpgToPng($path, $slikaNaStrezniku, $imageExtension);
				}
			}elseif($slikaNaStrezniku==0){	//ce slike ni na strezniku
				//echo "vre_id: $vre_id </br>";
				$imageName = $this->getOnlineImageName($imageName, $slikaNaStrezniku, $vre_id, $img_id);	//pridobi njen URL
			}

			$imageName = substr($imageName, 0, strrpos($imageName, '.'));
		
		}
		
		//echo "imagename pred return: ".$imageName."</br>";
		return $imageName;
	}
	#funkcija, ki skrbi za pridobitev imena slike, ki jo je potrebno izrisati - konec ###############################
	
	function getEndPosition($imageName=''){
		$findme = '"';
		$pos = strpos($imageName, $findme);	//najdi pozicijo teksta '"'
		return $pos;
	}

	function convertGifToPng($path='', $slikaNaStrezniku=null){
		//echo "path: ".$path."</br>";
		$image = imagecreatefromgif($path);	//pripravi sliko iz gif za pretvorbo
		$imageName = substr($path, 0, -3);	//ime slike brez extension-a
		//echo $imageName."</br>";
		$imageNamePNG = $imageName.'png';	//ime slike z ustreznim extension		
		imagepng($image, $imageNamePNG);	//pretvori pripravljeno gif sliko v png
		
		if($slikaNaStrezniku==0){	//ce slika je iz URL in ni na strezniku, GIF izbrisi
			unlink($imageName.'gif');	//izbrisi gif sliko
		}		
	}	

	function convertJpgToPng($path='', $slikaNaStrezniku=null, $imageExtension=''){
		$image = imagecreatefromjpeg($path);	//pripravi sliko iz jpg za pretvorbo
		$imageName = substr($path, 0, strrpos($path, '.')); //ime slike brez extension-a
		//echo $imageName."</br>";
		$imageNamePNG = $imageName.'.png';	//ime slike z ustreznim extension
		imagepng($image, $imageNamePNG);	//pretvori pripravljeno jpg sliko v png
		//echo "pretvorba v png: ".$imageNamePNG."</br>";
		//echo "xtens: ".$imageExtension."</br>";
		//$origExtension = strrchr($path, '.');
		//echo "ali je slika na strežniku: ".$slikaNaStrezniku."</br>";
		if($slikaNaStrezniku==0){	//ce slika je iz URL in ni na strezniku, izbrisi jo
			//echo "tukaj </br>";
			if($imageExtension == 'jpg'){
				unlink($imageName.'.'.$imageExtension);	//izbrisi sliko
			}elseif($imageExtension == 'peg'){
				unlink($imageName.'.j'.$imageExtension);	//izbrisi sliko
			}
		}			
	}
	#funkcija, ki skrbi za pridobitev slike, ki se nahaja nekje online in jo je potrebno izrisati, in vrne lokalno ime slike ######################################
	function getOnlineImageName($imageName='', $slikaNaStrezniku=null, $vre_id=null, $img_id=0){
		global $site_path;	
		//echo "imageName v getOnlineImageName nekje vmes 1: ".$imageName."</br>";
		$row = Cache::srv_spremenljivka(self::$spremenljivka);
		//echo "sprem: ".self::$spremenljivka."</br>";
		$spremenljivkaParams = new enkaParameters($row['params']);
		//echo "params: ".$spremenljivkaParams->get('hotspot_image')."</br>";		
		$imageNameTmp = $spremenljivkaParams->get('hotspot_image');
		//if($imageNameTmp!=''){	//ce je hotspot
		if($imageNameTmp!=''&&$vre_id==0){	//ce je hotspot
			$imageName = $imageNameTmp;
		}
		
		$findHttp = 'http';
		$posHttp = strpos($imageName, $findHttp);		
		$imageName = substr($imageName,$posHttp);	//besedilo do zacetka http		
		
		$pos = $this->getEndPosition($imageName);	//najdi pozicijo konca URL slike
		$imageName = substr($imageName, 0, $pos);	//pokazi le del params od zacetka besedila do '"' oz. konca URL slike
		//echo "imageName v getOnlineImageName nekje vmes 2: ".$imageName."</br>";
		$imageExtension = substr($imageName, $pos-3, 3);	//pridobi koncnico slike
		//echo "imageExtension: ".$imageExtension."</br>";
		
		//if($imageExtension!='jpg'&&$imageExtension!='png'&&$imageExtension!='gif'&&$imageExtension!='jpeg'){	//ce ni veljavnen extension, spremeni ga v png
		if($imageExtension=='jpg'||$imageExtension=='gif'||$imageExtension=='jpeg'){	//ce ni veljavnen extension, spremeni ga v png
			//echo "spremeni extension </br>";
			$imageExtension='png';
		}
		
		if($vre_id){	//ce se pridobiva imena tmp slik iz vrednosti vprasanja
			//$imgFilename = self::$spremenljivka.'_'.$vre_id.'_tmpImage.'.$imageExtension;	//tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
			$imgFilename = self::$spremenljivka.'_'.$vre_id.'_tmpImage_'.$img_id.'.'.$imageExtension;	//tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
		}else{
			//$imgFilename = self::$spremenljivka.'_tmpImage.'.$imageExtension;	//tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
			$imgFilename = self::$spremenljivka.'_tmpImage_'.$img_id.'.'.$imageExtension;	//tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
		}
		
		$pathDir = $site_path.'uploadi/editor/';	//pot za novo mapo, kjer se bodo shranjevale slike za trenutno anketo	
		$path = $pathDir.$imgFilename;	//pot do datoteke z imenom datoteke
		
		# ukaz za pretakanje slike
		if(IS_WINDOWS){
			//za windows sisteme	//powershell -command "& { iwr URL -OutFile 'PATH' }"			
			$command = 'powershell -command "& { iwr \''.$imageName.'\' -OutFile \''.$path.'\' }"';
			//$command = 'wget -O \''.$imageName.'\' -O '.$path.'  ';
		}elseif(IS_LINUX){
			//za linux sisteme //exec('wget URL -P PATH ');
			//$command = 'wget \''.$imageName.'\' -P '.$path.' ';
			$command = 'wget -O '.$path.' \''.$imageName.'\' ';
			//echo "ukaz za pobiranje: $command </br>";
		}		
		
		//echo "command: ".$command."</br>";
		exec($command); //pretoci sliko
		
		//$path = $pathDir.$imgFilename;	//pot do datoteke z imenom datoteke
		
/* 		if($imageExtension == 'gif'){	//ce je slika gif, jo je potrebno pretvoriti v png,  saj latex ne podpira gif
			$this->convertGifToPng($path, $slikaNaStrezniku);
		} */
		//echo "imgfilename na koncu: ".$imgFilename."</br>";
		if($imageExtension != 'png'){ //ce slika ni png, jo pretvori
			if($imageExtension == 'gif'){	//ce je slika gif, jo je potrebno pretvoriti v png,  saj latex ne podpira gif
				$this->convertGifToPng($path, $slikaNaStrezniku);				
			}else{
				$this->convertJpgToPng($path, $slikaNaStrezniku, $imageExtension);				
			}
		}
		
		//echo "imgfilename na koncu: ".$imgFilename."</br>";
		return $imgFilename;
	}	
	#funkcija, ki skrbi za pridobitev slike, ki se nahaja nekje online in jo je potrebno izrisati, in vrne lokalno ime slike - konec ###############################

}