path: root/admin/survey/classes/class.SurveyPostProcess.php

<?php

/**
* 
* V tem classu so funkcije, ki se ticejo postprocessinga podatkov
* ala compute, recode, code ...
* 
*/

class SurveyPostProcess {
	
	private $anketa;
	private $spremenljivka;
	
	private $db_table = '';
	
	private $SDF = null;
	
	/**
	* post procesiranje podatkov ankete
	* 
	* @param int $anketa ID ankete
	*/
	function __construct ($anketa) {
		
		$this->anketa = $anketa;
		
		SurveyInfo::getInstance()->SurveyInit($this->anketa);
		
		$this->db_table = SurveyInfo::getInstance()->getSurveyArchiveDBString();
		
		#inicializiramo class za datoteke
		$this->SDF = SurveyDataFile::get_instance();
		$this->SDF->init($this->anketa);
	}
	
	/**
	* izris taba za kalkulacijo
	* 
	*/
	function displayTab () {
		global $lang;
		
		echo '<fieldset id="calculations"><legend>'.$lang['srv_compute'].'</legend>';
		echo '<script>__vnosi=1;</script>';
		
		$b = new Branching($this->anketa);
		
		$sql = sisplet_query("SELECT s.id, s.naslov, s.variable FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip='22'");
		$count = 0;
		if (mysqli_num_rows($sql) > 0) {
			
			echo '<p class="bottom16">'.$lang['srv_compute_list'].'</p>';
			
			while ($row = mysqli_fetch_array($sql)) {
				$count +=1;
				echo '<div class="icon_holder">';
				echo '<p>'.$row['naslov'].' '.$count.': '.$b->calculations_display(-$row['id'], 1).'</p>';
				echo '<span class="faicon edit aslink" onclick="calculation_editing(\'-'.$row['id'].'\'); return false;"></span>';
				echo '<span class="faicon trash empty aslink" onclick="brisi_spremenljivko(\''.$row['id'].'\'); return false;"></span>';
				echo '</div>';
			}
		}
		
		echo '<a class="noline" href="#" onClick="spremenljivka_new(0, 0, 1, 0, 22); return false;"><span class="faicon plus_circle link-right"></span>'.$lang['srv_add_compute'].'</a>';
		
		if (mysqli_num_rows($sql) > 0) {
			echo '<div class="button_holder">';
			echo '<button class="medium blue" onclick="postprocess_start_calculation(); return false;">'.$lang['srv_compute_start'].'</button>';				
			echo '</div>';
		}
		
		echo '</legend>';
	}
	
	/**
	* prikaze link za dodat novo kalkulacijo za post process
	* dodamo kar obicno kalkulacijo, pri zapiranju (detektiramo v JS) pa se poklice ajax_calculation_postprocess_save, ki gre cez celo bazo
	* 
	*/
	function displayLink () {
		global $lang;
		
		echo '<div style="float:right; margin-right:10px">';
		echo '<a href="" onclick="spremenljivka_new(0, 0, 1, 0, 22); return false;">'.$lang['srv_add_compute'].'</a>';
		echo '</div>';
		
	}
	
	/**
	* zavihek za avtomatsko rekodiranje
	* 
	*/
	function displayCodingAuto () {
		global $lang;
		
		echo '<fieldset><legend>'.$lang['srv_auto_coding'].'</legend>';
		
		SurveyAnalysis::Init($this->anketa);
		$freq = SurveyAnalysis::getFrequencys();
		
		$ok = false;

		echo '<div id="ok">';

		echo '<div class="setting_holder">';
		echo '<label for="mass_coding_spr_id">'.$lang['srv_mass_coding'].'</label>';

		echo '<select class="dropdown large w400" name="spr_id" id="mass_coding_spr_id">';
		
		foreach (SurveyAnalysis::$_HEADERS AS $key => $h) {
			
			$spr = explode('_', $key);
			
			if ( is_numeric( $spr['0'] ) ) {
				
				foreach ($h['grids'] AS $grids_k => $grids_v) {
					
					foreach ($grids_v['variables'] AS $variables_k => $variables_v) {
						
						if ($variables_v['text'] == '1'/* || $h['tip'] == 19*/) {
							$ok = true;
							echo '<option value="'.$variables_v['sequence'].'-'.$spr[0].'">('.$h['variable'].') '.$h['naslov'].($variables_v['naslov']!=''?' - '.$variables_v['naslov']:'').'</option>';
						}						
					}					
				}
			}
		}
		
		echo '</select>';
                                    
		echo '</div>';

		echo '<div class="setting_holder">';
		
		echo '<label for="coding_type">'.$lang['srv_mass_coding_count'].'</label>';
		echo '<select class="dropdown large w400" name="coding_type" id="coding_type">';
		echo '<option value="1">'.$lang['srv_coding_one'].'</option>';
		echo '<option value="2">'.$lang['srv_coding_multi'].'</option>';
		echo '</select> ';

		echo '</div>';

		echo '<div class="button_holder intext">';
		echo '<button class="medium blue" type="submit" onclick="$(this).prop(\'disabled\', true); mass_coding($(\'#mass_coding_spr_id\').val(), $(\'#coding_type\').val()); return false;">'.$lang['srv_mass_coding_run'].'</button>';              
		echo '</div>';
		echo '</div>';
		
		if (!$ok) {
			?><script> $('#ok').addClass('displayNone'); </script><?
			echo '<p class="bold">'.$lang['srv_mass_coding_no_vars'].'</p>';
		}
		else {
			?><script> $('#ok').removeClass('displayNone'); </script><?
		}
		
		echo '<p class="top16">'.$lang['srv_mass_coding_txt1'].'</p>';
		echo '<p class="top16">'.$lang['srv_mass_coding_txt2'].'</p>';
		echo '<p class="top16">'.$lang['srv_mass_coding_txt3'].'</p>';
		echo '<p class="top16">'.$lang['srv_mass_coding_txt4'].'</p>';
		
		echo '</fieldset>';
	}
	
	/**
	* zavihek za rocno rekodiranje
	* 
	*/
	function displayCoding () {
		global $lang;
		global $global_user_id;
		
		//$this->updateTracking($this->anketa, 4);
		echo '<fieldset><legend>'.$lang['srv_hand_coding'].'</legend>';
		echo '<div id="analiza_data">';
		Timer::StartTimer($lang['srv_collectData']);
		SurveyDataDisplay::Init($this->anketa);
		
		echo '<div id="div_analiza_filtri_right" class="analiza" style="left:auto"><a href="#" onclick="$(\'#filters\').slideToggle(); $(this).find(\'span\').toggleClass(\'plus\').toggleClass(\'minus\'); return false"><span class="faicon plus"></span> '.$lang['srv_advanced'].'</a></div>';
		
		echo '<div id="filters" style="display:none; height:80px; margin-top:10px">';
		SurveyDataDisplay::displayFilters();
		echo '</div>';
		
		SurveyAnalysis::Init($this->anketa);
		$freq = SurveyAnalysis::getFrequencys();
		
		SurveyVariablesProfiles::Init($this->anketa, $global_user_id);
		$variables = SurveyVariablesProfiles::getProfileVariables(-1);
		if (SurveyVariablesProfiles::getCurentProfileId() != -1)
			$variables = array();
		
		echo '<p class="bottom16">'.$lang['srv_hand_coding_text'] . '</p>';

		echo '<div class="setting_holder">';

		echo '<div class="setting_item">';
		echo '<input type="radio" name="filter" '.(count($variables)==0?'checked':'').'>';
		echo '<label id="link_variable_profile_remove" onclick="removeVariableProfile();"> '.$lang['srv_coding_spr_1'].'</label>';
		echo '</div>';
		echo '<div class="setting_item">';
		echo '<input type="radio" name="filter" '.(count($variables)>0?'checked':'').' onclick="return false;">';
		echo '<label onclick="coding_filter($(\'#mass_coding_spr_id\').val());"> '.$lang['srv_coding_spr'].':</label>';
		echo '<select name="spr_id" id="mass_coding_spr_id" class="dropdown medium '.(count($variables)>0?'':'disabled').'" onchange="coding_filter($(\'#mass_coding_spr_id\').val()); return false;">';

		SurveyAnalysis::Init($this->anketa);
		$freq = SurveyAnalysis::getFrequencys();
		
		foreach (SurveyAnalysis::$_HEADERS AS $key => $h) {
			
			$spr = explode('_', $key);
			
			if ( is_numeric( $spr['0'] ) ) {
				
				foreach ($h['grids'] AS $grids_k => $grids_v) {
					
					foreach ($grids_v['variables'] AS $variables_k => $variables_v) {
						
						if ($variables_v['text'] == '1'/* || $h['tip'] == 19*/) {
							
							echo '<option value="'.$variables_v['sequence'].'-'.$spr[0].'" '.(in_array($spr[0].'_0', $variables)?'selected':'').'>('.$h['variable'].') '.$h['naslov'].($variables_v['naslov']!=''?' - '.$variables_v['naslov']:'').'</option>';
						}	
					}			
				}
			}
		}
		
		echo '</select> ';
		echo '</div>';
					
		echo '<div class="setting_item coding-refresh"><p class="top4 bottom4"><a href="index.php?anketa='.$this->anketa.'&a=data&m=coding">'.$lang['src_coding_refresh'].'</a></p></div>';
		
		echo '</div>';
		
		
		SurveyDataDisplay::displayVnosiHTML();
		echo '</div>'; // div_analiza_data
		Timer::GetTimer($lang['srv_collectData']);

		
		// div za popup editiranje
		echo '<div id="coding"></div>';
		echo '</fieldset>';
	}
	
	function ajax() {
		
		$this->anketa = $_REQUEST['anketa'];
		$this->spremenljivka = isset($_REQUEST['spremenljivka']) ? $_REQUEST['spremenljivka'] : null;
		
		if ($_GET['a'] == 'postprocess_start_calculation') {
			$this->ajax_postprocess_start_calculation();
		
		} elseif ($_GET['a'] == 'edit_data_question') {
			$this->ajax_edit_data_question();
			
		} elseif ($_GET['a'] == 'edit_data_question_save') {
			$this->ajax_edit_data_question_save(0);
			
		} elseif ($_GET['a'] == 'edit_data_question_upload_delete') {
			$this->ajax_edit_data_question_upload_delete();
			
		} elseif ($_GET['a'] == 'get_inline_edit') {
			$this->ajax_get_inline_edit();
			
		} elseif ($_GET['a'] == 'get_inline_edit_all') {
			$this->ajax_get_inline_edit_all();
			
		} elseif ($_GET['a'] == 'coding') {
			$this->ajax_coding();
			
		} elseif ($_GET['a'] == 'coding_save') {
			$this->ajax_coding_save();
			
		} elseif ($_GET['a'] == 'vrednost_new') {
			$this->ajax_vrednost_new();
			
		} elseif ($_GET['a'] == 'spremenljivka_new') {
			$this->ajax_spremenljivka_new();
			
		} elseif ($_GET['a'] == 'tip') {
			$this->ajax_tip();
			
		} elseif ($_GET['a'] == 'mass_coding') {
			$this->ajax_mass_coding();
			
		} elseif ($_GET['a'] == 'coding_merge') {
			$this->ajax_coding_merge();
			
		} elseif ($_GET['a'] == 'coding_filter') {
			$this->ajax_coding_filter();	
		}	
	}
	
	/**
	* pozene racunanje kalkulacij na celotni anketi
	* 
	*/
	function ajax_postprocess_start_calculation () {
		Common::updateEditStamp();
		
		$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.tip='22'");
		if (!$sql) echo 'err34234'.mysqli_error($GLOBALS['connect_db']);
		
		$spremenljivk = mysqli_num_rows($sql);
		
		$i = 0;
		while ($row = mysqli_fetch_array($sql)) {
			$this->calculate_spremenljivka($row['id']);
		}
		
		self::forceRefreshData($this->anketa);
				
		// redirect
		echo 'index.php?anketa='.$this->anketa.'&a=data';
	}
	
	/**
	* za spremenljivko (tipa 22 - kalkulacija) gre cez celo bazo (beremo iz tekstovne datoteke) in preracuna vrednosti
	* 
	*/
	function calculate_spremenljivka ($spremenljivka = 0) {
		
		require('definition.php');
		
		if ($spremenljivka != 0)
			$this->spremenljivka = $spremenljivka;
		
		$row = Cache::srv_spremenljivka($this->spremenljivka);
		if ($row['tip'] != 22) return;
				
		$_fileStatus = $this->SDF->getStatus() ;

		# če imamo data datoteko (novo=1 in staro=0)
		if ($_fileStatus == FILE_STATUS_OK || $_fileStatus == FILE_STATUS_OLD) {
			$_dataFileName = $this->SDF->getDataFileName();
			
			$missing = $this->generateCalculationMissing(-$this->spremenljivka);
			$calculation = $this->generateCalculationAWK(-$this->spremenljivka);			
			
			// for(i=1;i<=NF;i++) if ($i < 0) $i=0;	// nastavi vse <0 na 0
			
			if (IS_WINDOWS) {
				$cmd = 'awk -F"|" "{{OFS=\"\"} {ORS=\"\"}} { if ( '.$missing.' ) calc=-1; else calc = '.$calculation.' ; print \"('.$this->spremenljivka.',\",calc,\",\",$1,\"),\"}" '.$_dataFileName;
			} else {
				$cmd = 'awk -F"|" \'{{OFS=""} {ORS=""}} { if ( '.$missing.' ) calc=-1; else calc = '.$calculation.' ; print "('.$this->spremenljivka.',",calc,",",$1,"),"}\' '.$_dataFileName;
			}
			
			$out = shell_exec($cmd);
			
			// rezultat lahko vrne nan - spremenimo na -1
			$out = str_replace('-nan', '-1', $out);
			$out = str_replace('nan', '-1', $out);
			
			// pobrisemo zadnjo vejico
			$values = substr($out, 0, strrpos($out, ",") );
			
			// Zaokrozimo na doloceno stevilo decimalk
			$decimals = $row['decimalna'];
			$calc_val_array = explode(',', $values);
			for($i=1; $i<count($calc_val_array); $i+=3){			
				$calc_val_array[$i] = round(floatval($calc_val_array[$i]), $decimals);
			}
			$values = implode(',', $calc_val_array);
			
			$sql = sisplet_query("DELETE FROM srv_data_text".$this->db_table." WHERE spr_id='".$this->spremenljivka."'");
			if (!$sql) echo 'err3324'.mysqli_error($GLOBALS['connect_db']);
			
			if ($values != '') {
			
				$sql_query = "INSERT INTO srv_data_text".$this->db_table." (spr_id, text, usr_id) VALUES " . $values . "";
	
				$sql = sisplet_query($sql_query);
				if (!$sql) echo 'err766567'.' '.$sql_query.' '.mysqli_error($GLOBALS['connect_db']);
			
			}
			
			$sql = sisplet_query("UPDATE srv_anketa SET edit_time = NOW() WHERE id = '$this->anketa'");
			if (!$sql) echo 'err6563'.sisplet_query($sql);
			
		} else {
			//echo 'filestatus' . $_fileStatus;
		}
				
	}
	
	/**
	* vrne vrstni red stolpca v datoteki s podatki za podano spremenljivko
	* 
	* @param mixed $spr_id
	* @param mixed $vre_id
	* @return mixed
	*/
	function getSequence ($spr_id, $vre_id = null, $grd_id = null) {
		
		$header = $this->SDF->getHeaderVariable($spr_id.'_0');

	 	switch ($header['tip']) {
			case 1 :		// radio
			case 3 :		// dropdown
			case 4 :		// text -??
			case 21:		// beseilo?
			case 22:		// compute
			case 25:		// kvota
			    return $header['grids']['0']['variables']['0']['sequence'];
			break;
			case 7:			// number
				return $header['grids']['0']['variables'][$grd_id]['sequence'];
			case 16:		// multicheckbox
			case 20:		// multinumber
				foreach ($header['grids'] AS $grids) {
					foreach ($grids['variables'] AS $variables) {
						if ($variables['vr_id'] == $vre_id && $variables['gr_id'] == $grd_id)
							return ($variables['sequence']);
						}
				}
			case 17:		// razvrscanje
	        case 18:		// vsota
			default :		// multigrid, checkbox
				foreach ($header['grids'] AS $grids) {
					foreach ($grids['variables'] AS $variables) {
						if ($variables['vr_id'] == $vre_id)
							return ($variables['sequence']);
						}
				}
			    return ;
			break;
	 	}
	 }
	
	/**
    * @desc zgenerira kalkulacijo za vstavitev v awk
    */
    function generateCalculationAWK ($condition) {
		
        $sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$condition' ORDER BY vrstni_red ASC");
        if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
                
        $i = 0;
        $expression = '';
        while ($row = mysqli_fetch_array($sql)) {

        	$row1 = Cache::srv_spremenljivka($row['spr_id']);
        	
            if ($i++ != 0)
                if ($row['operator'] == 0)
                    $expression .= ' + ';
                elseif ($row['operator'] == 1)
                    $expression .= ' - ';
                elseif ($row['operator'] == 2)
                    $expression .= ' * ';
                elseif ($row['operator'] == 3)
                    $expression .= ' / ';

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

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

                $seq = $this->getSequence($row['spr_id'], $row['vre_id'], $row['grd_id']);
                if ($seq > 0)
                	$expression .= ' $'.$seq.' ';
                else
                	$expression .= ' 0 ';

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

                $expression .= $row['number'];

            }

            for ($i=1; $i<=$row['right_bracket']; $i++)
                $expression .= ' ) ';

        }

        return '('.$expression.')';
    }
	
	/**
    * @desc zgenerira pogoj, ki preveri, ce je kateri od odgovorov missing - potem je tudi kalkulacija missing
    */
    function generateCalculationMissing ($condition) {

        $sql = sisplet_query("SELECT * FROM srv_calculation WHERE cnd_id = '$condition' ORDER BY vrstni_red ASC");
        if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
                
        $i = 0;
        $expression = '';
        while ($row = mysqli_fetch_array($sql)) {

        	$row1 = Cache::srv_spremenljivka($row['spr_id']);

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

				$seq = $this->getSequence($row['spr_id'], $row['vre_id'], $row['grd_id']);
                if ($seq > 0) {
                	if ($expression != '') $expression .= ' || ';
                	$expression .= ' $'.$seq.' < 0 ';
				}
            
            }

        }

        if ($expression == '') $expression = 'false';
        return $expression;
    }
	
	function ajax_edit_data_question() {
		global $lang;
		
		/*?>
		  <link rel="stylesheet" href="http://localhost/fdv/cms2/main/survey/skins/Modern.css" type="text/css" media="screen" />
		<?*/
		
		$spr_id = $_POST['spr_id'];
		$usr_id = $_POST['usr_id'];
		
		// preverimo, ce gre za multiple tabelo
		$sql = sisplet_query("SELECT parent FROM srv_grid_multiple WHERE spr_id='$spr_id' AND ank_id='$this->anketa'");
		$row = mysqli_fetch_array($sql);
		if (mysqli_num_rows($sql) > 0)
			$spr_id = $row['parent'];
		
		echo '<div id="preview_spremenljivka">';
		echo '<div id="spremenljivka_preview">';
        
        echo '<div class="popup_close"><a href="#" onClick="edit_data_close(); return false;">✕</a></div>';

		echo '<form name="edit_data" method="post" action="ajax.php?t=postprocess&a=edit_data_question_save&anketa='.$this->anketa.'" onsubmit="edit_data_question_save(); return false;">';
		echo '<input type="submit" id="submit" style="display:none" />'; // workaround, ker se drugace ne poklice onsubmit
		echo '<input type="hidden" name="spr_id" value="'.$spr_id.'" />';
		echo '<input type="hidden" name="usr_id" value="'.$usr_id.'" />';

		include_once('../../main/survey/app/global_function.php');
		new \App\Controllers\SurveyController(true);
		save('anketa', $this->anketa);
		save('forceShowSpremenljivka', true);
		save('question_edit', true);
		\App\Controllers\Vprasanja\VprasanjaController::getInstance()->displaySpremenljivka($spr_id);
		
		echo '<div class="buttons_holder">';

		echo '<button class="medium white-blue" onclick="javascript:edit_data_close();">'.$lang['srv_cancel'].'</button>';
		echo '<button class="medium blue" onClick="javascript:$(\'#submit\').click(); return false;">'.$lang['srv_potrdi'].'</button>';
		
		echo '</div>';
		
		echo '</form>';
		
		/*echo '<div class="clr"></div>';*/
		
		echo '</div>';
		echo '</div>';
		
	}
	
	function ajax_edit_data_question_save ($refresh = 1) {
		Common::updateEditStamp();
		
		// Preverimo ce gre za prvo popravljanje podatkov in avtomatskoustvarimo arhiv podatkov ce je potrebno
		$sas = new SurveyAdminSettings();
		$sas->checkFirstDataChange();
		
		$spr_id = $_POST['spr_id'];
		$usr_id = $_POST['usr_id'];

		include_once('../../main/survey/app/global_function.php');
		new \App\Controllers\SurveyController(true);
		save('anketa', $this->anketa);
		save('forceShowSpremenljivka', true);
		save('usr_id', $usr_id);
		\App\Models\SaveSurvey::getInstance()->posted(0, $spr_id);
		
		/*if ($refresh == 1)
			header("Location: index.php?anketa=".$this->anketa."&a=data&m=edit");*/
	}

    // Pobrisemo upload datoteke v urejanju podatkov
    function ajax_edit_data_question_upload_delete () {
		Common::updateEditStamp();
				
		$spr_id = $_POST['spr_id'];
		$usr_id = $_POST['usr_id'];
		$code = $_POST['code'];

        $s = sisplet_query("DELETE FROM srv_data_upload WHERE ank_id='".$this->anketa."' AND usr_id='".$usr_id."' AND code='".$code."'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);

        $s2 = sisplet_query("DELETE FROM srv_data_text".$this->db_table." WHERE spr_id='".$spr_id."' AND usr_id='".$usr_id."'");
		if (!$s2) echo mysqli_error($GLOBALS['connect_db']);

        $this->ajax_edit_data_question();

        self::forceRefreshData($this->anketa);
	}
	
	function ajax_get_inline_edit () {
		
		$spr_id = $_POST['spr_id'];
		
		echo '<form action="ajax.php?t=postprocess&a=edit_data_question_save&anketa='.$this->anketa.'">';
		echo '<input type="hidden" name="spr_id" value="'.$spr_id.'" />';
		echo '<input type="hidden" name="visible_'.$spr_id.'" value="1" />';

		echo '<select class="fullwidth dropdown" name="vrednost_'.$spr_id.'" onchange="edit_data_inline_edit_save(this.parentNode.getAttribute(\'name\'));">';
		$sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id='$spr_id' ORDER BY vrstni_red ASC");
		while ($row = mysqli_fetch_array($sql)) {
			
			echo '<option value="'.$row['id'].'" variable="'.$row['variable'].'" class="'.$row['variable'].'">'.$row['naslov'].'</option>';
		}
		
		echo '</select>';
		echo '</form>';	
	}
	
	function ajax_get_inline_edit_all () {
		
		$spr = isset($_POST['spr']) ? $_POST['spr'] : array();
		
		$response = array();
		
		foreach ($spr AS $spr_id) {
			
			$output = array();
			
			$output['spr'] = $spr_id;
			$output['html'] = '';
			
			$output['html'] .= '<form action="ajax.php?t=postprocess&a=edit_data_question_save&anketa='.$this->anketa.'">';
			$output['html'] .= '<input type="hidden" name="spr_id" value="'.$spr_id.'" />';
			$output['html'] .= '<input type="hidden" name="visible_'.$spr_id.'" value="1" />';
			
			$output['html'] .= '<select class="fullwidth dropdown" name="vrednost_'.$spr_id.'" onchange="edit_data_inline_edit_save(this.parentNode.getAttribute(\'name\'));">';
						
			$sql = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id='$spr_id' ORDER BY naslov ASC");
			while ($row = mysqli_fetch_array($sql)) {
				
				$output['html'] .= '<option value="'.$row['id'].'" variable="'.$row['variable'].'" class="'.$row['variable'].'">'.$row['naslov'].'</option>';	
			}
			
			$output['html'] .= '</select>';
			$output['html'] .= '</form>';
		
			$response[] = $output;
		}
		
		echo json_encode($response);
	}
	
	function ajax_coding ($editing = false) {
		global $lang;
		
		$usr_id = $_POST['usr_id'];
		$spr_id = $_POST['spr_id'];
		
		$row = Cache::srv_spremenljivka($spr_id);
		if ($row['coding'] > 0) {
			$coding_id = $row['coding']; 
		} else {
			$coding_id = $spr_id;
		}
		echo '<div class="popup_close"><a href="#" onClick="toggle_coding_div(); return false;">✕</a></div>';
		echo '<h2><span class="faicon fa-code-branch blue"></span>'.$lang['srv_hand_coding'].'</h2>';

		echo '<form id="coding_'.$usr_id.'">';
		
		echo '<input type="hidden" value="'.$usr_id.'" name="usr_id">';
		echo '<input type="hidden" value="'.$this->anketa.'" name="anketa">';
		
		$sql = sisplet_query("SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' AND s.coding='$coding_id' ORDER BY g.vrstni_red, s.vrstni_red");
		if (mysqli_num_rows($sql) > 0) {
			
			while ($row = mysqli_fetch_array($sql)) {
				
				echo '<fieldset style="position: relative">';

				//Zgornji sivi del
				echo '<div class="variable_name">';
				
				echo '<div class="osnovno">';
				echo '<p class=semi-bold>'.skrajsaj(strip_tags($row['naslov']), 20).'</p>';
				echo '<span class="faicon edit pointer blue" onclick="$(\'.edit_'.$row['id'].'\').toggle(); return false;" title="'.$lang['edit2'].'"></span>';
				echo '<span class="faicon delete empty blue pointer" onclick="brisi_spremenljivko(\''.$row['id'].'\'); return false;" title="'.$lang['srv_brisispremenljivko'].'"></span>';
				echo '</div>';

				echo '<div class="urejanje edit_'.$row['id'].'" style="display:none;">'.$lang['srv_tip'].': ';
				echo '<select name="tip" class="dropdown small" onchange="if (confirm(\''.$lang['srv_change_q_tip'].'\')) {coding_tip(\''.$row['id'].'\', \''.$usr_id.'\', $(this).val());} return false;"><option value="1" '.($row['tip']==1?'selected':'').'>'.$lang['srv_vprasanje_tip_1'].'</option><option value="2" '.($row['tip']==2?'selected':'').'>'.$lang['srv_vprasanje_tip_2'].'</option><option value="3" '.($row['tip']==3?'selected':'').'>'.$lang['srv_vprasanje_tip_3'].'</option></select>';
				echo '<a class="noline" href="index.php?anketa='.$this->anketa.'&spr_id='.$row['id'].'#branching_'.$row['id'].'">'.$lang['srv_napredno_urejanje'].'</a></div>';

				echo '</div>';

				//Spodnji del
				echo '<div class="variable_content">';
				
				echo '<input id="visible_'.$row['id'].'" type="hidden" value="1" name="visible_'.$row['id'].'">';
				
				if ($row['tip'] == 3) {
					echo '<select name="vrednost_'.$row['id'].'">';
				}
				$sql1 = sisplet_query("SELECT id, naslov FROM srv_vrednost WHERE spr_id='$row[id]' ORDER BY vrstni_red ASC");
				while ($row1 = mysqli_fetch_array($sql1)) {

					echo '<div class="setting_holder horizontal">';
					
					$sql2 = sisplet_query("SELECT * FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$row[id]' AND vre_id='$row1[id]' AND usr_id='$usr_id'");
					if (mysqli_num_rows($sql2) > 0)
						$checked = 'checked="checked"'; else $checked = '';
					
					if ($row['tip'] == 1) {
						echo '<input type="radio" name="vrednost_'.$row['id'].'" id="spremenljivka_'.$row['id'].'_vrednost_'.$row1['id'].'" value="'.$row1['id'].'" '.$checked.' /><label for="spremenljivka_'.$row['id'].'_vrednost_'.$row1['id'].'"> '.$row1['naslov'].'</label>';
					} elseif ($row['tip'] == 2) {
						echo '<input type="checkbox" name="vrednost_'.$row['id'].'[]" id="spremenljivka_'.$row['id'].'_vrednost_'.$row1['id'].'" value="'.$row1['id'].'" '.$checked.' /><label for="spremenljivka_'.$row['id'].'_vrednost_'.$row1['id'].'"> '.$row1['naslov'].'</label>';
					} elseif ($row['tip'] == 3) {
						echo '<option value="'.$row1['id'].'" '.($checked!=''?'selected':'').'>'.$row1['naslov'].'</option>';
					}
					
					if ($row['tip'] == 1 || $row['tip'] == 2) {
						echo '<span style="display:none;" class="edit_'.$row['id'].'"><select class="dropdown small" onchange="coding_merge(\''.$row['id'].'\', \''.$row1['id'].'\', \''.$usr_id.'\', this.value)" style="width:150px">';
						echo '<option value="0">'.$lang['srv_coding_merge'].':</option>';
						
						$sql2 = sisplet_query("SELECT id, naslov FROM srv_vrednost WHERE spr_id='$row[id]' AND id != '$row1[id]' ORDER BY vrstni_red ASC");
						while ($row2 = mysqli_fetch_array($sql2))
							echo '<option value="'.$row2['id'].'">'.$row2['naslov'].'</option>';
						
						echo '</select>';
					}

					echo '</div>';
					
				}
				if ($row['tip'] == 3) {
					echo '</select>';
				}
				echo '<input type="text" class="text small" name="vrednost_new_'.$row['id'].'" value="" placeholder="'.$lang['srv_novavrednost'].'"/> <a href="#" onclick="coding_vrednost_new(\''.$row['id'].'\', \''.$usr_id.'\', $(\'input[name=vrednost_new_'.$row['id'].']\').val()); return false;"><span class="faicon add blue pointer" title="'.$lang['add'].'"></span></a>';

				echo '</div>'; #div.variable_content
				echo '</fieldset>';
			}
		} else {
			echo '<p class="italic bottom16">'.$lang['srv_coding_no_spr'].'</p>';
		}
		

		echo '<div class="button_holder left" id="dodaj_spr">';
		echo '<button class="medium blue" onclick="'.(true?' $(\'#coding_spr_new\').toggle(); $(\'#dodaj_spr\').toggle();':'').' return false;">'.$lang['srv_coding_new'].'</button>';
		echo '</div>';

		echo '<div class="setting_holder horizontal" id="coding_spr_new" '.(true?' style="display:none"':'').'>';
		echo '<p>'.$lang['name'].':</p>';
		echo '<div class="button_holder inline">';
		echo '<input type="text" class="text large" name="spremenljivka_new" value=""/>';
		echo '<button class="medium blue" onclick="coding_spremenljivka_new(\''.$coding_id.'\', \''.$usr_id.'\', $(\'input[name=spremenljivka_new]\').val()); return false;">'.$lang['add'].'</button>';
		echo '<button class="medium white-blue" onclick="$(\'#coding_spr_new\').toggle(); $(\'#dodaj_spr\').toggle(); return false;">'.$lang['edit1338'].'</button>';
		echo '</div>';
		echo '</div>';

		echo '<div class="button_holder left">';
		echo '<button class="medium white-blue" onclick="coding_save(\''.$usr_id.'\'); return false;">'.$lang['save'].'</button>';
		echo '</div>';
		
		echo '</form>';
		
		if ($editing !== false) {
			echo '<script> $(\'.edit_'.$editing.'\').show(); </script>';
		}
		
	}
	
	function ajax_coding_save () {
		Common::updateEditStamp();
		
		$usr_id = $_POST['usr_id'];
		
		foreach ($_POST AS $key => $val) {
			
			if ( substr($key, 0, 8) == 'visible_' ) {
				
				$spr_id = substr($key, 8);

				include_once('../../main/survey/app/global_function.php');
				new \App\Controllers\SurveyController(true);
				save('anketa', $this->anketa);
				save('forceShowSpremenljivka', true);
				save('usr_id', $usr_id);
				\App\Models\SaveSurvey::getInstance()->posted(0, $spr_id);
			
			}
		}
		
		self::forceRefreshData($this->anketa);
		
	}
	
	function ajax_vrednost_new () {
		Common::updateEditStamp();
		
		$usr_id = $_POST['usr_id'];
		
		$v = new Vprasanje($this->anketa);
		$v->spremenljivka = $_POST['spr_id'];
		
		$v->vrednost_new($_POST['naslov']);
		
		$this->ajax_coding();
		
		self::forceRefreshData($this->anketa);
		
	}
	
	function ajax_spremenljivka_new () {
		Common::updateEditStamp();
		global $global_user_id;
		
		$usr_id = $_POST['usr_id'];
		$spr_id = $_POST['spr_id'];
		
		ob_start();
		$ba = new BranchingAjax($this->anketa);
		$ba->ajax_spremenljivka_new($spr_id, 0, 0, 0, 2, 0);
		$spr_new = $ba->spremenljivka;
		ob_clean();
		
		SurveyVariablesProfiles::Init($this->anketa, $global_user_id);
		$variables = SurveyVariablesProfiles::getProfileVariables(0);
		if ( isset($variables['variables']) && count($variables['variables']) > 0 ) {
			SurveyVariablesProfiles::setProfileVariables(0, implode(',', $variables['variables']).','.$spr_new.'_0');
			SurveyVariablesProfiles::setDefaultProfile(0);
		}
		
		// spremenimo ime, coding
		$s = sisplet_query("UPDATE srv_spremenljivka SET variable_custom='1' WHERE id='$spr_id'");
					
		$var = Cache::get_spremenljivka($spr_id, 'variable');
		$i = 1;
		do {
			$variable = $var.'_coding_'.$i++;
			$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE variable='$variable' AND s.gru_id=g.id AND g.ank_id='".$this->anketa."'");
		} while (mysqli_num_rows($sql) > 0);
		
		if ($_POST['naslov'] != '')
			$naslov = $_POST['naslov'];
		else
			$naslov = $variable;
		
		$s = sisplet_query("UPDATE srv_spremenljivka SET coding='$spr_id', visible='0', naslov='".$naslov."', variable='".$variable."', variable_custom='1', size='0' WHERE id='$spr_new'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);
		$s = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id='$spr_new'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);
		
		$s = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id = '$spr_new'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);
		
		$this->ajax_coding();
		
		self::forceRefreshData($this->anketa);
		
	}
	
	
	function ajax_tip () {
		Common::updateEditStamp();
		
		$spr_id = $_POST['spr_id'];
		$tip = $_POST['tip'];
		
		$v = new Vprasanje($this->anketa);
		$v->change_tip($spr_id, $tip);
		
		Common::prestevilci($spr_id);
		
		$this->ajax_coding();
		
		self::forceRefreshData($this->anketa);
		
	}
	
	function ajax_coding_merge () {
		Common::updateEditStamp();
		
		$spr_id = $_POST['spr_id'];
		$vre_id = $_POST['vre_id'];
		$merge = $_POST['merge'];
		
		$s = sisplet_query("UPDATE srv_data_vrednost$this->db_table SET vre_id='$merge' WHERE vre_id='$vre_id' AND spr_id='$spr_id'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);
		
		$s = sisplet_query("DELETE FROM srv_vrednost WHERE id = '$vre_id'");
		if (!$s) echo mysqli_error($GLOBALS['connect_db']);
		
		$this->ajax_coding($spr_id);
		
		self::forceRefreshData($this->anketa);
		
	}
	
	function ajax_mass_coding () {
		global $lang;
				
		$spr_new = $this->mass_coding_auto();
		
		$link = '<a href="index.php?anketa='.$this->anketa.'&a=data&m=coding&highlight_spr='.$spr_new.'&relevance=0">'.$lang['srv_hand_coding'].'</a>';
		
		// enajblamo labele
		session_start();
		$_SESSION['sid_'.$this->anketa]['dataIcons_labels'] = true;
		
		echo '<h2><span class="faicon blue fa-check-circle"></span>'.$lang['srv_auto_coding_end_title'].'</h2>';
		echo '<div class="popup_close"><a href="#" onclick="popupClose();">✕</a></div>';

		echo '<p>';
		
		printf($lang['srv_auto_coding_end'], $this->mass_coding_auto_vars, $link);
		
		echo '</p>';
        
		echo '<div class="button_holder">';
		echo '<button class="medium white-blue" onclick="popupClose(); window.location.reload(); return false;">'.$lang['srv_zapri'].'</button>';
		echo '</div>';
	}
	
	private $mass_coding_auto_vars = 0;
	
	function mass_coding_auto () {
		global $global_user_id;
		Common::updateEditStamp();
		
		global $lang;
		
		$coding_type = $_POST['coding_type'];
		
		$seq = $_POST['seq'];
		$seq = explode('-', $seq);
		
		$spr_id = (int)$seq[1];
		$sequence = (int)$seq[0];

		// frekvence besed poberemo iz analize
		SurveyAnalysis::Init($this->anketa);
		SurveyAnalysis::setUpFilter(1);
		$freq = SurveyAnalysis::getFrequencys();
		
		// imamo sekvenco polja (pozicijo v text fajlu)
		if ($sequence != false) {
			
			$besede = isset($freq[$sequence]['valid']) ? $freq[$sequence]['valid'] : array();
			$koreni = array();
			
			// sestavimo array korenov
			foreach ($besede AS $beseda => $count) {
				
				if (strlen( iconv("UTF-8", "ISO-8859-2", $beseda) ) >= 3) {	// manjsih od  3 znakov ne upostevamo
					
					if ($coding_type == 1) {
					
						$k = iconv("ISO-8859-2", "UTF-8", substr( iconv("UTF-8", "ISO-8859-2", $beseda), 0, round(strlen( iconv("UTF-8", "ISO-8859-2", $beseda) )*0.75) ) );
					
						if ( array_key_exists($k, $koreni) ) {
							$koreni[$k] += $count;
						} else {
							$koreni[$k] = $count;
						}
						
					} elseif ($coding_type == 2) {
						
						$razbita = explode(",", $beseda);
						foreach ($razbita AS $part) {
							$k = iconv("ISO-8859-2", "UTF-8", substr( iconv("UTF-8", "ISO-8859-2", $part), 0, round(strlen( iconv("UTF-8", "ISO-8859-2", $part) )*0.75) ) );
					
							if ( array_key_exists($k, $koreni) ) {
								$koreni[$k] += $count;
							} else {
								$koreni[$k] = $count;
							}
						}
						
					}
				}
			}
			
			// array obrnemo, da imamo vrstni_red => koren
			$i = 1;
			$koren = array();
			foreach ($koreni AS $key => $val) {
				$koren[$i++] = $key;
			}
			
			if (count($koren) > 0) {
				
				// naredimo novo spremenljivko
				ob_start();
				$ba = new BranchingAjax($this->anketa);
				$ba->ajax_spremenljivka_new($spr_id, 0, 0, 0, $coding_type, 0);
				$spr_new = $ba->spremenljivka;
				ob_clean();
				
				if ($spr_new > 0) {
					
					// spremenimo ime, coding
					$s = sisplet_query("UPDATE srv_spremenljivka SET variable_custom='1' WHERE id='$spr_id'");
					
					$var = Cache::get_spremenljivka($spr_id, 'variable');
					$i = 1;
					do {
						$variable = $var.'_coding_'.$i++;
						$sql = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.variable='$variable' AND s.gru_id=g.id AND g.ank_id='".$this->anketa."'");
					} while (mysqli_num_rows($sql) > 0);
					
					$s = sisplet_query("UPDATE srv_spremenljivka SET coding='$spr_id', visible='0', naslov='".$variable."', variable='".$variable."', variable_custom='1', size='".count($koren)."' WHERE id='$spr_new'");
					if (!$s) echo mysqli_error($GLOBALS['connect_db']);
					$s = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id='$spr_new'");
					if (!$s) echo mysqli_error($GLOBALS['connect_db']);
					
					// napolnimo vrednosti spremenljivke s koreni
					$koren_new = array();
					foreach ($koren AS $key => $val) {
						$val = ucfirst(strtolower( $val ));
						$s = sisplet_query("INSERT INTO srv_vrednost (id, spr_id, naslov, variable, vrstni_red) VALUES ('', '$spr_new', '$val', '$key', '$key')");
						if (!$s) echo mysqli_error($GLOBALS['connect_db']);
						
						$koren_new[strtolower($val)] = mysqli_insert_id($GLOBALS['connect_db']);
					}
					
					// gremo cez tekstovne podatke in vnasamo vrednosti
					$sql = sisplet_query("SELECT usr_id, text FROM srv_data_text".$this->db_table." WHERE spr_id='$spr_id'");
					while ($row = mysqli_fetch_array($sql)) {
						
						if ($coding_type == 1) {
							
							$k = iconv("ISO-8859-2", "UTF-8", substr( iconv("UTF-8", "ISO-8859-2", $row['text']), 0, round(strlen( iconv("UTF-8", "ISO-8859-2", $row['text']) )*0.75) ) );
							$k = strtolower($k);
							
							if ( array_key_exists($k, $koren_new) ) {
							
								$s = sisplet_query("DELETE FROM srv_data_vrednost$this->db_table WHERE spr_id='$spr_new' AND usr_id='$row[usr_id]'");	// ker se zafilajo z -4
								$s = sisplet_query("INSERT INTO srv_data_vrednost$this->db_table (spr_id, vre_id, usr_id, loop_id) VALUES('$spr_new', '$koren_new[$k]', '$row[usr_id]', NULL)");
								if (!$s) echo mysqli_error($GLOBALS['connect_db']);
								
								$this->mass_coding_auto_vars++;
							}
						
						} elseif ($coding_type == 2) {
							
							$s = sisplet_query("DELETE FROM srv_data_vrednost$this->db_table WHERE spr_id='$spr_new' AND usr_id='$row[usr_id]'");	// ker se zafilajo z -4
							
							foreach ($koren_new AS $k => $v) {
								if ( strpos($row['text'], $k) !== false ) {
									
									$s = sisplet_query("INSERT INTO srv_data_vrednost$this->db_table (spr_id, vre_id, usr_id, loop_id) VALUES('$spr_new', '$koren_new[$k]', '$row[usr_id]', NULL)");
									if (!$s) echo mysqli_error($GLOBALS['connect_db']);
									
									$this->mass_coding_auto_vars++;
									
								}
									
							}
							
						}
						
					}
					
					$variables = $spr_id.'_0,'.$spr_new.'_0';
					SurveyVariablesProfiles::Init($this->anketa, $global_user_id);
					SurveyVariablesProfiles::setProfileVariables(0, $variables);
					SurveyVariablesProfiles::setDefaultProfile(0);
					
					self::forceRefreshData($this->anketa);
					
					return $spr_new;
					
				}
				
			}
			
		}
		
		return 0;
		
	}
	
	function ajax_coding_filter () {
		global $global_user_id;
		global $lang;
		
		$seq = $_POST['seq'];
		$seq = explode('-', $seq);
		
		$spr_id = (int)$seq[1];
		$sequence = (int)$seq[0];
		$variables = array();
		$variables[] = $spr_id.'_0';
		
		$sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE coding = '$spr_id'");
		while ($row = mysqli_fetch_array($sql)) {
			$variables[] = $row['id'].'_0';
		}
		
		$variables = serialize($variables);
		
		SurveyVariablesProfiles::Init($this->anketa, $global_user_id);
		SurveyVariablesProfiles::setProfileVariables(-1, $variables);
		SurveyVariablesProfiles::setDefaultProfile(-1);
	}
	
	static function forceRefreshData( $anketa ) {
		
		if ( file_exists( dirname(__FILE__) . '/../surveyData/export_dashboard_'.$anketa.'.html' ) )
			unlink( dirname(__FILE__) . '/../surveyData/export_dashboard_'.$anketa.'.html' );
		
		if ( file_exists( dirname(__FILE__) . '/../surveyData/export_data_'.$anketa.'.dat' ) )
			unlink( dirname(__FILE__) . '/../surveyData/export_data_'.$anketa.'.dat' );
		
		if ( file_exists( dirname(__FILE__) . '/../surveyData/export_header_'.$anketa.'.dat' ) )
			unlink( dirname(__FILE__) . '/../surveyData/export_header_'.$anketa.'.dat' );
		
	}
	
}
 
?>