<?php
/** Class ki skrbi za T-test
 *  December 2011
 *
 *
 * Enter description here ...
 * @author Gorazd_Veselic
 *
 */

if(!defined("EXPORT_FOLDER"))define("EXPORT_FOLDER", "admin/survey/SurveyData");
if(!defined("BREAK_OPTION_LIMIT"))define("BREAK_OPTION_LIMIT", 15);

class SurveyBreak
{
	private $sid;										# id ankete
	private $db_table;									# katere tabele uporabljamo
	public $_HEADERS = array();							# shranimo podatke vseh variabel
	
	private $headFileName = null;						# pot do header fajla
	private $dataFileStatus = null;						# status data datoteke
	private $SDF = null;								# class za inkrementalno dodajanje fajlov

	public $variablesList = null; 					 	# Seznam vseh variabel nad katerimi lahko izvajamo break(zakeširamo)

	public $_CURRENT_STATUS_FILTER = ''; 				# filter po statusih, privzeto izvažamo 6 in 5

	public $_HAS_TEST_DATA = false;						# ali anketa vsebuje testne podatke
	
	public $break_percent = false;						# ali prikazujemo procente
	public $break_charts = 0;							# ali prikazujemo 0->tabele ali 1->grafe
	
	private $sessionData;							# podatki ki so bili prej v sessionu - za nastavitve, ki se prenasajo v izvoze...

	private $SurveyAnaliza;							# klas analiza
	private $SurveyCrosstab;						# klas Crosstab
	

	private $decimal_point = ',';
	private $thousands = '.';
	private $num_digit_average = NUM_DIGIT_AVERAGE;
	private $num_digit_percent = NUM_DIGIT_PERCENT;
	
	function __construct($sid) {
		global $global_user_id;

		if ((int)$sid > 0) {

			$this->sid = $sid;

			SurveyAnalysisHelper::getInstance()->Init($this->sid);
				
			# polovimo vrsto tabel (aktivne / neaktivne)
			SurveyInfo :: getInstance()->SurveyInit($this->sid);
			$this->db_table = SurveyInfo::getInstance()->getSurveyArchiveDBString();

			$this->_CURRENT_STATUS_FILTER = STATUS_FIELD.' ~ /6|5/';

            // Pri glasovanju tega ne pustimo
            if(SurveyInfo::getInstance()->getSurveyColumn("survey_type") == 0){
                die();
            }
				
			#inicializiramo class za datoteke
			$this->SDF = SurveyDataFile::get_instance();
			$this->SDF->init($this->sid);
			$this->headFileName = $this->SDF->getHeaderFileName();
			$this->dataFileStatus = $this->SDF->getStatus();
			
			# Inicializiramo in polovimo nastavitve missing profila
			SurveyStatusProfiles::Init($this->sid);
			SurveyUserSetting::getInstance()->Init($this->sid, $global_user_id);
				
			SurveyStatusProfiles::Init($this->sid);
			SurveyMissingProfiles :: Init($this->sid,$global_user_id);
			SurveyConditionProfiles :: Init($this->sid, $global_user_id);
			SurveyZankaProfiles :: Init($this->sid, $global_user_id);
			SurveyTimeProfiles :: Init($this->sid, $global_user_id);
			SurveyVariablesProfiles :: Init($this->sid, $global_user_id);
			
			SurveyDataSettingProfiles :: Init($this->sid);
			# polovimo decimalna mesta in vejice za tisočice
			$this->decimal_point = SurveyDataSettingProfiles :: getSetting('decimal_point');
			$this->thousands = SurveyDataSettingProfiles :: getSetting('thousands');
			$this->num_digit_average = SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE');
			$this->num_digit_percent = SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT');
				
			
			// preberemo nastavitve iz baze (prej v sessionu) 
			SurveyUserSession::Init($this->sid);
			$this->sessionData = SurveyUserSession::getData();

			
			if ($this->dataFileStatus == FILE_STATUS_NO_DATA || $this->dataFileStatus == FILE_STATUS_NO_FILE || $this->dataFileStatus == FILE_STATUS_SRV_DELETED){
				Common::noDataAlert();
				exit();
			}

			if ($this->headFileName !== null && $this->headFileName != '') {
				$this->_HEADERS = unserialize(file_get_contents($this->headFileName));
			}

			$this->SurveyAnaliza = new SurveyAnalysis();
			$this->SurveyAnaliza->Init($this->sid);
			
			$this->SurveyCrosstab = new SurveyCrosstabs();
			$this->SurveyCrosstab->Init($this->sid);
				
			# nastavimo vse filtre
			$this->setUpFilter();

		} else {
			echo 'Invalid Survey ID!';
			exit();
		}
	}

	function ajax() {
		
		# spremenljivko in sekvenco shranimo v session
		if (isset($_POST['spr'])) {
			$this->sessionData['break']['spr'] = $_POST['spr'];
			if (isset($_POST['seq'])) {
				$this->sessionData['break']['seq'] = $_POST['seq'];
			}
		}
		
		// Shranimo spremenjene nastavitve v bazo
		SurveyUserSession::saveData($this->sessionData);

		# izvedemo akcijo
		switch ($_GET['a']) {
			case 'spremenljivkaChange':
				$this->doBreakForSpremenljivka();
			break;
			case 'change_break_percent':
				$this->setSessionPercent();
				break;
			break;
			case 'change_break_charts':
				$this->setSessionCharts();
				break;
			break;
			default:
				print_r("<pre>");
				print_r($_GET);
				print_r($_POST);
				print_r("</pre>");
				break;
		}
	}


	/** Funkcija ki nastavi vse filtre
	 *
	 */
	private function setUpFilter() {
		if ($this->dataFileStatus == FILE_STATUS_NO_DATA
		|| $this->dataFileStatus == FILE_STATUS_NO_FILE
		|| $this->dataFileStatus == FILE_STATUS_SRV_DELETED){
			return false;
		}

		# ali prikazujemo procente
		$this->break_percent = (isset($this->sessionData['break']['break_percent']) && (int)$this->sessionData['break']['break_percent'] == 1) ? true : false;
		
		# poiščemo kater profil uporablja uporabnik
		$_currentMissingProfile = SurveyUserSetting :: getInstance()->getSettings('default_missing_profile');
		$this->currentMissingProfile = (isset($_currentMissingProfile) ? $_currentMissingProfile : 1);

		# filtriranje po statusih
		$this->_CURRENT_STATUS_FILTER = SurveyStatusProfiles :: getStatusAsAWKString();

		# filtriranje po časih
		$_time_profile_awk = SurveyTimeProfiles :: getFilterForAWK($this->_HEADERS['unx_ins_date']['grids']['0']['variables']['0']['sequence']);

		# dodamo še ife

		SurveyConditionProfiles :: setHeader($this->_HEADERS);
		$_condition_profile_AWK = SurveyConditionProfiles:: getAwkConditionString();

		if (($_condition_profile_AWK != "" && $_condition_profile_AWK != null ) || ($_time_profile_awk != "" && $_time_profile_awk != null)) {
			$this->_CURRENT_STATUS_FILTER  = '('.$this->_CURRENT_STATUS_FILTER;
			if ($_condition_profile_AWK != "" && $_condition_profile_AWK != null ) {
				$this->_CURRENT_STATUS_FILTER .= ' && '.$_condition_profile_AWK;
			}
			if ($_time_profile_awk != "" && $_time_profile_awk != null) {
				$this->_CURRENT_STATUS_FILTER .= ' && '.$_time_profile_awk;
			}
			$this->_CURRENT_STATUS_FILTER .= ')';
		}

		$status_filter = $this->_CURRENT_STATUS_FILTER;

		if ($this->dataFileStatus == FILE_STATUS_OK || $this->dataFileStatus == FILE_STATUS_OLD) {

			if (isset($this->_HEADERS['testdata'])) {
				$this->_HAS_TEST_DATA = true;
			}
		}
		
	}

	function Display() {
		global $lang;
	
		# ali imamo testne podatke
		if ($this->_HAS_TEST_DATA) {
            # izrišemo bar za testne podatke	
            $SSH = new SurveyStaticHtml($this->sid);
			$SSH -> displayTestDataBar(true);
		}	
		
		# ali prikazujemo tabele ali grafe
		$this->break_charts = (isset($this->sessionData['break']['break_show_charts']) && (int)$this->sessionData['break']['break_show_charts'] == 1) ? 1 : 0;
		
		echo '<div id="div_break_data">';
		$this->displayData();
		echo '</div>'; #id="div_break_data"
		
	}


	function DisplayLinks() {
		# izrišemo navigacijo za analize
		$SSH = new SurveyStaticHtml($this->sid);
		$SSH -> displayAnalizaSubNavigation();
	}

		
	/** Prikazuje filtre
	 *
	*/
	function DisplayFilters() {
		global $lang;
		
		if ($this->dataFileStatus == FILE_STATUS_SRV_DELETED || $this->dataFileStatus == FILE_STATUS_NO_DATA){
			return false;
		}
		

		if ($this->setUpJSAnaliza == true) {
			echo '<script>
			        window.onload = function() {
		            __analiza = 1;
		            __tabele = 1;
		        }
		        </script>';
		}

		# izrišemo navigacijo za analize
		$SSH = new SurveyStaticHtml($this->sid);
		# izrišemo desne linke do posameznih nastavitev
		$SSH -> displayAnalizaRightOptions(M_ANALYSIS_BREAK);
	}
	
	function displayData() {
		global $lang;

		$variables = $this->getVariableList(2);

		echo '<div id="break_variables">';
        
        // Dropdown
		echo '<div id="breakSpremenljivkaSpan" class="breakDropdownHolder">';

		echo '<span class="title">'.$lang['srv_break_label1'].':</span>';

		echo '<select id="breakSpremenljivka" name="breakSpremenljivka" class="dropdown large" onchange="breakSpremenljivkaChange();" autocomplete="off">';
		echo '<option value="0" selected="selected" >'. $lang['srv_break_select1_option'] . '</option>';
		if (count($variables)) {
			foreach ($variables as $variable) {
				echo '<option value="'.(isset($variable['spr_id'])?$variable['spr_id']:'').'"'
				. ( isset($variable['sequence']) ? ' seq="'.(isset($variable['spr_id'])?$variable['sequence']:'').'" ' : '')
				. (( (int)$variable['canChoose'] == 1) ? '' : ' disabled="disabled" ')
				.(isset($this->sessionData['break']['seq'])&&isset($variable['sequence'])&&isset($variable['canChoose'])&&$this->sessionData['break']['seq'] == $variable['sequence'] && (int)$variable['canChoose'] == 1 ? ' selected="selected"':'')
				. '> '
				. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? '&nbsp;&nbsp;' : '&nbsp;&nbsp;&nbsp;&nbsp;' ))
				. $variable['variableNaslov'] . '</option>';
			}
		}
		echo '</select>';

		echo '</div>';

        // Dodatne nastavitve
		echo '<div id="div_crossCheck" class="breakSubSetting">' ;

        echo '<span class="title">'.$lang['settings'].':</span>';

        echo '<span class="setting_line">';
		$this->displayLinePercent();
        echo '</span>';
        
        echo '<span class="setting_line">';
		$this->displayLineCharts();
        echo '</span>';

		echo '</div>';
		
		echo '</div>';


        echo '<div id="breakResults">';
		if (isset($this->sessionData['break']['spr']) && (int)$this->sessionData['break']['spr'] > 0 
				&& isset($this->sessionData['break']['seq']) && (int)$this->sessionData['break']['seq'] > 0) {
		
			$this->doBreakForSpremenljivka();
		}
        echo '</div>'; # id="breakResults"
	}
	
	/** funkcija vrne seznam primern variabel za crostabe
	 *
	 */
	function getVariableList($witch) {
		# pobrišemo array()
		$this->variablesList = array();
		# zloopamo skozi header in dodamo variable (potrebujemo posamezne sekvence)
		foreach ($this->_HEADERS AS $skey => $spremenljivka) {
		
			$tip = isset($spremenljivka['tip'])?$spremenljivka['tip']:null;
			{
				#drugi dropdown
				# tekstovnih in numeričnih tipov ne dodajamo
				$_dropdown_condition = is_numeric($tip) 
					#&& $tip != 2# checkbox - 21.11.2012 baje mormo checkboxe p
													&& $tip != 4	#text
													&& $tip != 5	#label
													&& $tip != 7	#number
													&& $tip != 8	#datum
													&& $tip != 9	#SN-imena
													&& $tip != 16	#multicheck
													&& $tip != 18	#vsota
													&& $tip != 19	#multitext
													&& $tip != 20	#multinumber
													&& $tip != 21	#besedilo*
													&& $tip != 22	#compute
													&& $tip != 25	#kvota
											? true : false;
			} 
			
			if ($_dropdown_condition) {
				$cnt_all = (int)$spremenljivka['cnt_all'];
				# radio in select in checkbox
				if ($cnt_all == '1' || $tip == 1 || $tip == 3 || $tip == 2) {
					# pri tipu radio ali select dodamo tisto variablo ki ni polje "drugo"
					if ($tip == 1 || $tip == 3 ) {
						if (count($spremenljivka['grids']) == 1 ) {
							# če imamo samo en grid ( lahko je več variabel zaradi polja drugo.
							$grid = $spremenljivka['grids'][0];
							if (count ($grid['variables']) > 0) {
								foreach ($grid['variables'] AS $vid => $variable ){
									if ($variable['other'] != 1) {
										# imampo samo eno sekvenco grids[0]variables[0]
										$this->variablesList[] = array(
											'tip'=>$tip,
											'spr_id'=>$skey,
											'sequence'=>$spremenljivka['grids'][0]['variables'][$vid]['sequence'],
											'variableNaslov'=>'('.$spremenljivka['variable'].')&nbsp;'.strip_tags($spremenljivka['naslov']),
											'canChoose'=>true,
											'sub'=>0);
											
									}
								}
							}
						}
					} else if ($tip == 2){
						if ($witch == 1) {
							#pri checkboxu ponudimo vsako podvariablo posebej
							$this->variablesList[] = array(
								'tip'=>$tip,
								'variableNaslov'=>'('.$spremenljivka['variable'].')&nbsp;'.strip_tags($spremenljivka['naslov']),
								'canChoose'=>false,
								'sub'=>0);
							# imampo samo eno sekvenco grids[0]
							if (count ($spremenljivka['grids'][0]['variables']) > 0) {
							
								foreach ($spremenljivka['grids'][0]['variables'] AS $vid => $variable ){
									if ($variable['other'] != 1) {
										$this->variablesList[] = array(
											'tip'=>$tip,
											'spr_id'=>$skey,
											'vr_id'=>$vid,
											'sequence'=>$variable['sequence'],
											'variableNaslov'=>'('.$variable['variable'].')&nbsp;'.strip_tags($variable['naslov']),
											'canChoose'=>true,
											'sub'=>1);
									}
								}
							}		
				
						} else {
							# imampo samo eno sekvenco grids[0]variables[0]
							$this->variablesList[] = array(
								'tip'=>$tip,
								'spr_id'=>$skey,
								'sequence'=>$spremenljivka['grids'][0]['variables'][0]['sequence'],
								'variableNaslov'=>'('.$spremenljivka['variable'].')&nbsp;'.strip_tags($spremenljivka['naslov']),
								'canChoose'=>true,
								'sub'=>0);
						}
						
					} else {
						# imampo samo eno sekvenco grids[0]variables[0]
						$this->variablesList[] = array(
							'tip'=>$tip,
							'spr_id'=>$skey,
							'sequence'=>$spremenljivka['grids'][0]['variables'][0]['sequence'],
							'variableNaslov'=>'('.$spremenljivka['variable'].')&nbsp;'.strip_tags($spremenljivka['naslov']),
							'canChoose'=>true,
							'sub'=>0);
					}

				} else if ($cnt_all > 1){
					# imamo več skupin ali podskupin, zato zlopamo skozi gride in variable
					if (count($spremenljivka['grids']) > 0 ) {
						$this->variablesList[] = array(
							'tip'=>$tip,
							
							'variableNaslov'=>'('.$spremenljivka['variable'].')&nbsp;'.strip_tags($spremenljivka['naslov']),
							'canChoose'=>false,
							'sub'=>0);
						# ali imamo en grid, ali več (tabele
						if (count($spremenljivka['grids']) == 1 ) {
							# če imamo samo en grid ( lahko je več variabel zaradi polja drugo.
							$grid = $spremenljivka['grids'][0];
							if (isset($grid['variables'])&&count ($grid['variables']) > 0) {
								foreach ($grid['variables'] AS $vid => $variable ){
									if ($variable['other'] != 1) {
										$this->variablesList[] = array(
											'tip'=>$tip,
											'spr_id'=>$skey,
											'sequence'=>$variable['sequence'],
											'variableNaslov'=>'('.$variable['variable'].')&nbsp;'.strip_tags($variable['naslov']),
											'canChoose'=>true,
											'sub'=>1);
									}
								}
							}

						} else if($tip == 16||$tip == 18) {
							# imamo multicheckbox
							foreach($spremenljivka['grids'] AS $gid => $grid) {
								$sub = 0;
								if (isset($grid['variable'])&&$grid['variable'] != '') {
									$sub++;
									$this->variablesList[] = array(
										'tip'=>$tip,
										'spr_id'=>$skey,
										'grd_id'=>$gid,
										'sequence'=>$grid['variables'][0]['sequence'],
										'variableNaslov'=>'('.$grid['variable'].')&nbsp;'.strip_tags($grid['naslov']),
										'canChoose'=>true,
										'sub'=>1);
								}
							}
						} else {
							# imamo več gridov - tabele
							foreach($spremenljivka['grids'] AS $gid => $grid) {
								$sub = 0;
								if (isset($grid['variable'])&&$grid['variable'] != '') {
									$sub++;
									$this->variablesList[] = array(
										'tip'=>$tip,
										'variableNaslov'=>'('.$grid['variable'].')&nbsp;'.strip_tags($grid['naslov']),
										'canChoose'=>false,
										'sub'=>$sub);
								}
								if (count ($grid['variables']) > 0) {
									$sub++;
									foreach ($grid['variables'] AS $vid => $variable ){
										if ($variable['other'] != 1) {
											$this->variablesList[] = array(
												'tip'=>$tip,
												'spr_id'=>$skey,
												'sequence'=>$variable['sequence'],
												'variableNaslov'=>'('.$variable['variable'].')&nbsp;'.strip_tags($variable['naslov']),
												'canChoose'=>true,
												'sub'=>$sub);
										}
									}
								}
							}
						}

					}
				}
			}
		}

		return $this->variablesList;
	}

	function doBreakForSpremenljivka() {
		global $lang;
		
		# ali prikazujemo procente		
		$this->break_percent = isset($this->sessionData['break']['break_percent']) && (int)$this->sessionData['break']['break_percent'] == 1 ? true : false;
		$this->break_charts = isset($this->sessionData['break']['break_show_charts']) && (int)$this->sessionData['break']['break_show_charts'] == 1 ? 1 : 0;
		
		if (isset($this->sessionData['break']['spr']) && $this->sessionData['break']['spr'] != 0){
			$_spr = explode('_',$this->sessionData['break']['spr']);
			$spr = $this->sessionData['break']['spr'];
			# poiščemo pripadajoče variable
			$_spr_data = $this->_HEADERS[$this->sessionData['break']['spr']];
			
			# poiščemo sekvenco
			$sekvenca = $this->sessionData['break']['seq'];
			
			# poiščemo opcije
			$opcije = $_spr_data['options'];
			
			# izrisemo ikone za izvoz pdf/rtf
			$this->displayExport($spr, $sekvenca);
				
			if ((int)$_spr_data['tip'] != 2) {
				$seqences[] = $sekvenca;
				$options = $opcije;
			} else {
				# za checkboxe imamo več sekvenc
				$seqences = explode('_',$_spr_data['sequences']);
				$options[1] = $opcije[1];
			}
			
			
			# za vsako opcijo posebej izračunamo povprečja za vse spremenljivke
			$frequencys = array();
			if (count($seqences) > 0) {
				foreach ($seqences as $seq) {
					
					if (count($options) > 0) {
						foreach ($options as $oKey => $option) {
							# zloopamo skozi variable
							$oKeyfrequencys = $this->getAllFrequencys($oKey, $seq, $spr);
							if ($oKeyfrequencys != null) {
								$frequencys[$seq][$oKey] = $oKeyfrequencys;
							} 
						}
					}
				}
			}

			$this->displayBreak($spr,$frequencys);
		} 
        else {
			echo '<p class="red strong">'.$lang['srv_break_error_note_1'].'</p>';
		}
	}
	
	/** za posamezno opcijo izračunamo frekvence za vse spremenljivke
	 * 
	 * @param unknown_type $oKey
	 * @param unknown_type $seq
	 */
	function getAllFrequencys($oKey, $seq, $spr) {
		$result = null;
		# sestavimo dodaten awk filter
		$awk_filter = $this->getAwkFilter($oKey, $seq, $spr);
		if ($awk_filter != null) {
			# pridobimo frekvence
			$this->SurveyAnaliza->setUpFilter();
			$this->SurveyAnaliza->frequencyAddInvalid(false);
			$result = $this->SurveyAnaliza->getFrequencys($awk_filter);
		}
		return $result;
	}

	function getAwkFilter($oKey, $seq, $spr) {
		$result = null;
		$_spr_data = $this->_HEADERS[$spr];
		$tip = $_spr_data['tip'];
		
		$result = '$'.$seq.'=='.$oKey;
		return $result;
		
	}
	
	function formatNumber ($value, $digit = 0, $sufix = "") {
		if ($value <> 0 && $value != null)
			$result = round($value, $digit);
		else
			$result = "0";
			
			
		$result = number_format($result, $digit, $this->decimal_point, $this->thousands) . $sufix;
	
		return $result;
	}
	
	function displayBreak($forSpr, $frequencys) {
			
		ob_start(); // outer buffer
		
		# če ne uporabljamo privzetega časovnega profila izpišemo opozorilo
		SurveyTimeProfiles :: printIsDefaultProfile(false);
		
		# če imamo filter ifov ga izpišemo
		SurveyConditionProfiles:: getConditionString();
		
		# če imamo filter spremenljivk ga izpišemo
		SurveyVariablesProfiles:: getProfileString(true);
		SurveyDataSettingProfiles :: getVariableTypeNote();
		
		# filtriranje po spremenljivkah
		$_FILTRED_VARIABLES = SurveyVariablesProfiles::getProfileVariables(SurveyVariablesProfiles::checkDefaultProfile(), true);


		foreach ($this->_HEADERS AS $skey => $spremenljivka) {
				
			if (isset($spremenljivka['hide_system'])&&(int)$spremenljivka['hide_system'] == 1 && in_array($spremenljivka['variable'],array('email','ime','priimek','telefon','naziv','drugo'))) {
				continue;
			}

			$spremenljivka['id'] = $skey;
			$tip = isset($spremenljivka['tip'])?$spremenljivka['tip']:null;
			if ( is_numeric($tip) 
						&& $tip != 4	#text
						&& $tip != 5	#label
						&& $tip != 8	#datum
						&& $tip != 9	#SN-imena
						&& $tip != 19	#multitext
						&& $tip != 21	#besedilo*
			&& ( count($_FILTRED_VARIABLES) == 0 || (count($_FILTRED_VARIABLES) > 0 && isset($_FILTRED_VARIABLES[$skey]) ))
						) {
				
				$this->displayBreakSpremenljivka($forSpr,$frequencys,$spremenljivka);
			} 
            else if ( is_numeric($tip) 
						&& (
								$tip == 4	#text
								|| $tip == 19	#multitext
								|| $tip == 21	#besedilo*
								|| $tip == 20	#multi numer*
						) && ( count($_FILTRED_VARIABLES) == 0 || (count($_FILTRED_VARIABLES) > 0 && isset($_FILTRED_VARIABLES[$skey]) ) )
						) {
                            
				$this->displayBreakSpremenljivka($forSpr,$frequencys,$spremenljivka);
			}
				
			ob_end_flush();
		}
		
		// Izpisemo nastavitve na dnu (izvozi, arhiv, vabila...)
		$this->displayBottomSettings();
	}
	
	function displayBreakSpremenljivka($forSpr,$frequencys,$spremenljivka) {
		
		$tip = $spremenljivka['tip'];
		
		if ($forSpr != $spremenljivka['id']) {
			
			switch ($tip) {
				# radio, dropdown
				case 1:
				case 3:
					$this->displayCrosstabTable($forSpr,$frequencys,$spremenljivka);
					break;
				
				#multigrid
				case 6:
					$skala = Common::getSpremenljivkaSkala($spremenljivka['id']);
					if ($skala == 0) {
						$this->displayBreakTableMgrid($forSpr,$frequencys,$spremenljivka);
					} 
					else {
						$this->displayCrosstabTable($forSpr,$frequencys,$spremenljivka);
					}
					break;
				
				# checkbox
				case 2:
                    $this->displayCrosstabTable($forSpr,$frequencys,$spremenljivka);
                    break;
				
                #number
				case 7:
				#ranking
				case 17:
				#vsota
				case 18:
				#multinumber
				case 20:
					$this->displayBreakTableNumber($forSpr,$frequencys,$spremenljivka);
				break ;
			
				case 19:
					$this->displayBreakTableText($forSpr,$frequencys,$spremenljivka);
				break ;

				#multicheck
				case 16:
					$this->displayCrosstabTable($forSpr,$frequencys,$spremenljivka);
				break;
				
				case 4:	
				case 21:
					# po novem besedilo izpisujemo v klasični tabeli
					$this->displayBreakTableText($forSpr,$frequencys,$spremenljivka);
				break;
				
				default:
					$this->displayCrosstabTable($forSpr,$frequencys,$spremenljivka);
				break;
			}
		}
	}
	
	function displayBreakTableMgrid($forSpr,$frequencys,$spremenljivka){
		#mgrid - 16:
		
		// Ce izrisujemo graf
		if($this->break_charts == 1){
			$tableChart = new SurveyTableChart($this->sid, $this, 'break');
			$tableChart->setBreakVariables($forSpr,$frequencys,$spremenljivka);
			$tableChart->display();
		}
		
		// Ce izrisujemo tabelo
		else{
			
			$keysCount = count($frequencys);
			$sequences = explode('_',$spremenljivka['sequences']);
			$forSpremenljivka = $this->_HEADERS[$forSpr];
			$tip = $spremenljivka['tip'];
			
			# izračunamo povprečja za posamezne sekvence
			$means = array();
			$totalMeans = array();
			$totalFreq = array();
			foreach ($frequencys AS $fkey => $options) {
				foreach ($options AS $oKey => $option) {
					foreach ($sequences AS $sequence) {
						$txt = $this->getMeansFromKey($option[$sequence]);
						if ($txt) {
							$cnt[$fkey]++;
							$means[$fkey][$oKey][$sequence] = $txt;
						}
					}
				}
			}
						
			# ce imamo vec kot 20 kategorij,izpisujemo samo tiste ki imajo vrednosti
			$displayAll = (count($options) > 20) ? false : true;
				
            if (isset($spremenljivka['double']) && $spremenljivka['double'] > 1) {
				$doubleGridParts = $spremenljivka['double'];
				$multiply = 1;
				$isDoubleGrid = true;
			} 
            else {
				$doubleGridParts[1]['subtitle'] = '';
				$multiply = 2;
				$isDoubleGrid = false;
			}
	
			# če imamo dvojno tabelo
			$rowspan = ' rowspan="3"';
			$colspan = ' colspan="'.($multiply*count($sequences)).'"';


			foreach ($doubleGridParts AS $part => $doubleGridTitle) {

                echo '<div id="'.$spremenljivka['id'].'" class="table_holder">';


                // Zvezdica za vkljucitev v porocilo
                echo '<div class="top_line">';

                $spr1 = $this->sessionData['break']['seq'].'-'. $this->sessionData['break']['spr'].'-undefined';
                $spr2 = $spremenljivka['grids'][0]['variables'][0]['sequence'].'-'.$spremenljivka['id'].'-undefined';
                SurveyAnalysisHelper::getInstance()->addCustomReportElement($type=9, $sub_type=0, $spr1, $spr2);

                echo '</div>';


				# če ni multicheck in multi grid
				echo '<table class="table_break">';


				echo '<tr class="row1">';

				echo '<td class="cell_question" '.$rowspan.'>';
				echo '<span class="anl_variabla">';
				echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $forSpr . '\'); return false;">';
				echo $forSpremenljivka['naslov'];
				echo '('.$forSpremenljivka['variable'].')';
				echo '</a>';
				echo '</span>';
				echo '</td>';

				echo '<td class="cell_question" '.$colspan.'>';
				echo '<span class="anl_variabla">';
				echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $spremenljivka['id'] . '\'); return false;">';
				echo $spremenljivka['naslov'];
				echo '('.$spremenljivka['variable'].')';
				echo '</a>';
				if (isset ($doubleGridTitle['subtitle'])) {
					echo ' - '.$doubleGridTitle['subtitle'];
				}
				echo '</span>';
				echo '</td>';

				echo '</tr>';
					

				echo '<tr class="row2">';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					if ($isDoubleGrid == false || ($isDoubleGrid == true && $grid['part'] == $part)) {
						foreach ($grid['variables'] AS $vkey => $variable) {
	
							echo '<td class="cell_grid" colspan="2">';
							echo $variable['naslov'];
							echo '('.$variable['variable'].')';
							echo '</td>';
						}
					}
				}

				echo '</tr>';


				echo '<tr class="row3">';
				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					if ($isDoubleGrid == false || ($isDoubleGrid == true && $grid['part'] == $part)) {
						foreach ($grid['variables'] AS $vkey => $variable) {
							echo '<td class="cell_value">Povprečje</td>';
							echo '<td class="cell_value">Št. enot</td>';
						}
					}
				}
				echo '</tr>';

                
				$cnt=0;
				foreach ($frequencys AS $fkey => $fkeyFrequency) {
					$cbxLabel = $forSpremenljivka['grids'][0]['variables'][$cnt]['naslov'];
					$cnt++;
					foreach ($options AS $oKey => $option) {
						if ($means[$fkey][$oKey] != null || $displayAll) {
							
                            echo '<tr>';
							
                            echo '<td class="cell_value">';
							if ($forSpremenljivka['tip'] == 2) {
								echo $cbxLabel;
							} 
                            else {
								echo $forSpremenljivka['options'][$oKey];
							}
							echo '</td>';

							foreach ($spremenljivka['grids'] AS $gkey => $grid) {
								if ($isDoubleGrid == false || ($isDoubleGrid == true && $grid['part'] == $part)) {
									foreach ($grid['variables'] AS $vkey => $variable) {
										$sequence = $variable['sequence'];
										if ($variable['other'] != 1) {
                                            
											#povprečja
											echo '<td class="cell_value">';
											echo $this->formatNumber($means[$fkey][$oKey][$sequence],$this->num_digit_average,'');
											echo '</td>';

											# enote
											echo '<td class="cell_value">';
											echo (int)$frequencys[$fkey][$oKey][$sequence]['validCnt'];
											echo '</td>';
											$totalMeans[$sequence] += ($means[$fkey][$oKey][$sequence]*(int)$frequencys[$fkey][$oKey][$sequence]['validCnt']);
											$totalFreq[$sequence]+= (int)$frequencys[$fkey][$oKey][$sequence]['validCnt'];
										}
							
									}
								}
							}

							echo '</tr>';
						}
					}
				}


				#dodamo še skupno sumo in povprečje
				echo '<tr>';

				echo '<td class="cell_value">';
				echo 'Skupaj';
				echo '</td>';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					if ($isDoubleGrid == false || ($isDoubleGrid == true && $grid['part'] == $part)) {
						foreach ($grid['variables'] AS $vkey => $variable) {
								
							$sequence = $variable['sequence'];
							if ($variable['other'] != 1) {

								#povprečja
								echo '<td class="cell_value">';
								$totalMean =  $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0;
								echo $this->formatNumber($totalMean ,$this->num_digit_average,'');
								echo '</td>';

								# enote
								echo '<td class="cell_value">';
								echo (int)$totalFreq[$sequence];
								echo '</td>';
							}
						}
					}
				}

				echo '</tr>';

				echo '</table>';	
                
                echo '</div>';
			}
		}
	}
	
	function displayBreakTableNumber($forSpr,$frequencys,$spremenljivka){
		#number - 7:
		#ranking - 17:
		#vsota - 18:
		#multinumber - 20:
		global $lang;

		$keysCount = count($frequencys);
		$sequences = explode('_',$spremenljivka['sequences']);
		$forSpremenljivka = $this->_HEADERS[$forSpr];
		$tip = $spremenljivka['tip'];
		
		# izračunamo povprečja za posamezne sekvence
		$means = array();
		$totalMeans = array();
		$totalFreq = array();
		foreach ($frequencys AS $fkey => $options) {
			foreach ($options AS $oKey => $option) {
				foreach ($sequences AS $sequence) {
					$txt = $this->getMeansFromKey($option[$sequence]);
					if ($txt) {
						$means[$fkey][$oKey][$sequence] = $txt;
					}
				}
			}
		}
		# ce imamo vec kot 20 kategorij,izpisujemo samo tiste ki imajo vrednosti
		$displayAll = (count($options) > 20) ? false : true;
	
		// Ce izrisujemo graf
		if($this->break_charts == 1){
		
			// Number, vsota, ranking graf
			if($tip != 20 ){
				$tableChart = new SurveyTableChart($this->sid, $this, 'break');
				$tableChart->setBreakVariables($forSpr,$frequencys,$spremenljivka);
				$tableChart->display();
			}
			
			// Multinumber graf
			else{
				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
				
					// Izrisujemo samo 1 graf v creportu
					if($_GET['m'] == 'analysis_creport'){
						
						if($spremenljivka['break_sub_table']['key'] == $gkey){
							$tableChart = new SurveyTableChart($this->sid, $this, 'break');
							$tableChart->setBreakVariables($forSpr,$frequencys,$spremenljivka);
							$tableChart->display();
						}
					}
					
					// Izrisujemo vse zaporedne grafe
					else{
						$spremenljivka['break_sub_table']['key'] = $gkey;
						$spremenljivka['break_sub_table']['sequence'] = $grid['variables'][0]['sequence'];
					
						$tableChart = new SurveyTableChart($this->sid, $this, 'break');
						$tableChart->setBreakVariables($forSpr,$frequencys,$spremenljivka);
						$tableChart->display();
					}
				}
			}

		}
		// Ce izrisujemo tabelo
		else{

			# za multi number naredimo po skupinah
			if ($tip != 20 ) {

				$rowspan = ' rowspan="3"';
				$colspan = ' colspan="'.(2*count($sequences)).'"';

				# ali prikazujemo procente
				if ((int)$this->break_percent > 0) {
					$break_percentRowSpan = ' rowspan="2"'; 
				}

                echo '<div id="'.$spremenljivka['id'].'" class="table_holder">';


                // Zvezdica za vkljucitev v porocilo
                echo '<div class="top_line">';

				$spr1 = $this->sessionData['break']['seq'].'-'. $this->sessionData['break']['spr'].'-undefined';
				$spr2 = $spremenljivka['grids'][0]['variables'][0]['sequence'].'-'.$spremenljivka['id'].'-undefined';
				SurveyAnalysisHelper::getInstance()->addCustomReportElement($type=9, $sub_type=0, $spr1, $spr2);

                echo '</div>';


				# če ni multicheck in multi grid
				echo '<table class="table_break">';


				echo '<tr class="row1">';

				echo '<td class="cell_question" '.$rowspan.'>';
				echo '<span class="anl_variabla">';
				echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $forSpr . '\'); return false;">';
				echo $forSpremenljivka['naslov'];
				echo '('.$forSpremenljivka['variable'].')';
				echo '</a>';
				echo '</span>';
				echo '</td>';

				echo '<td  class="cell_question" '.$colspan.'>';
				echo '<span class="anl_variabla">';
				echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $spremenljivka['id'] . '\'); return false;">';
				echo $spremenljivka['naslov'];
				echo '('.$spremenljivka['variable'].')';
				echo '</a>';
				echo '</span>';
				echo '</td>';

				echo '</tr>';

				
				echo '<tr class="row2">';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					foreach ($grid['variables'] AS $vkey => $variable) {
						echo '<td  class="cell_grid" colspan="2">';
						echo $variable['naslov'];
						echo '('.$variable['variable'].')';
						echo '</td>';
					}
				}

				echo '</tr>';


				echo '<tr class="row3">';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					foreach ($grid['variables'] AS $vkey => $variable) {
						echo '<td class="cell_value">Povprečje</td>';
						echo '<td class="cell_value">Št. enot</td>';
					}
				}

				echo '</tr>';
				

				foreach ($frequencys AS $fkey => $fkeyFrequency) {
 
					foreach ($options AS $oKey => $option) {
						if ($displayAll || $means[$fkey][$oKey] != null) {

							echo '<tr>';

							echo '<td class="cell_var">';
							echo $forSpremenljivka['options'][$oKey];
							echo '</td>';

							foreach ($spremenljivka['grids'] AS $gkey => $grid) {
								foreach ($grid['variables'] AS $vkey => $variable) {
									$sequence = $variable['sequence'];
									if ($variable['other'] != 1) {

										$means1 = isset($means[$fkey][$oKey][$sequence])?$means[$fkey][$oKey][$sequence]:0;
										$validCnt1 = isset($frequencys[$fkey][$oKey][$sequence]['validCnt'])?$frequencys[$fkey][$oKey][$sequence]['validCnt']:0;

										#povprečja
										echo '<td class="cell_value">';
										echo $this->formatNumber($means1,$this->num_digit_average,'');
										echo '</td>';

										# enote
										echo '<td class="cell_value">';
										echo (int)$validCnt1;
										echo '</td>';

                                        $totalMeans[$sequence] = (isset($totalMeans[$sequence])? 
											$totalMeans[$sequence] += ($means1*(int)$validCnt1): $means1*(int)$validCnt1);
										$totalFreq[$sequence] = (isset($totalFreq[$sequence])? 
											$totalFreq[$sequence] += ((int)$validCnt1): (int)$validCnt1);
									}
									
								}
								
							}

							echo '</tr>';


							if ((int)$this->break_percent) {

								echo '<tr>';

								foreach ($spremenljivka['grids'] AS $gkey => $grid) {
									foreach ($grid['variables'] AS $vkey => $variable) {
										if ($variable['other'] != 1) {

											$sequence = $variable['sequence'];

											echo '<td class="cell_value">';
											$percent = 0;
											if ($frequencys[$fkey][$sequence]['validCnt'] > 0 ) {
												$percent = 100;
											}
											echo $this->formatNumber($percent,$this->num_digit_percent,'%');
											echo '</td>';
										}
									}
										
								}

								echo '</tr>';
							}
						}	
					}
				}


				#dodamo še skupno sumo in povprečje
				echo '<tr>';

				echo '<td class="cell_value">';
				echo 'Skupaj';
				echo '</td>';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					foreach ($grid['variables'] AS $vkey => $variable) {
						
						$sequence = $variable['sequence'];
						if ($variable['other'] != 1) {

							#povprečja
							echo '<td class="cell_value">';
							$totalMean =  $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0;
							echo $this->formatNumber($totalMean ,$this->num_digit_average,'');
							echo '</td>';

							# enote
							echo '<td class="cell_value">';
							echo (int)$totalFreq[$sequence];
							echo '</td>';
						}
						
					}
				}

				echo '</tr>';

				echo '</table>';
				
                echo '</div>';
			} 
            else if ($tip == 20){

				# za multi number razdelimo na grupe - skupine
				$rowspan = ' rowspan="3"';
				$colspan = ' colspan="'.(2*count($spremenljivka['grids'][0]['variables'])).'"';

				foreach ($spremenljivka['grids'] AS $gkey => $grid) {
					
					// Ce smo v porocilu po meri in ni prava tabela jo preskocimo
					if(isset($spremenljivka['break_sub_table']['key']) && $spremenljivka['break_sub_table']['key'] != $gkey){
						continue;
					}

                    echo '<div id="'.$spremenljivka['id'].'" class="table_holder">';
					

                    echo '<div class="top_line">';

					// Ce smo v porocilu po meri in je prava tabelo jo izpisemo brez naslova
					if(!isset($spremenljivka['break_sub_table']['sequence'])){
                        echo '<div class="table_title">';
                        
                        echo $lang['srv_break_table_for'];
						echo $spremenljivka['naslov'].' (';
						echo $spremenljivka['variable'].') = ';
						echo $grid['naslov'];
						echo ' ('.$grid['variable'].')';
						
                        echo '</div>';
					}

                    // Zvezdica za vkljucitev v porocilo
					$spr1 = $this->sessionData['break']['seq'].'-'. $this->sessionData['break']['spr'].'-undefined';
					$spr2 = $grid['variables'][0]['sequence'].'-'.$spremenljivka['id'].'-undefined';
					SurveyAnalysisHelper::getInstance()->addCustomReportElement($type=9, $sub_type=0, $spr1, $spr2);

                    echo '</div>';

					
					echo '<table class="table_break">';


					#labele
					echo '<tr class="row1">';

					echo '<td class="cell_question" '.$rowspan.'>';
					echo '<span class="anl_variabla">';
					echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $forSpr . '\'); return false;">';
					echo $forSpremenljivka['naslov'];
					echo '('.$forSpremenljivka['variable'].')';
					echo '</a>';
					echo '</span>';
					echo '</td>';
					
					echo '<td class="cell_question" '.$colspan.'>';
					echo '<span class="anl_variabla">';
					echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $spremenljivka['id'] . '\'); return false;">';
					echo $spremenljivka['naslov']. ' - ';
					echo $grid['naslov'];
					echo '('.$grid['variable'].')';
					echo '</a>';
					echo '</span>';
					echo '</td>';

					echo'</tr>';


					#labele
					echo '<tr class="row2">';

					foreach ($grid['variables'] AS $vkey => $variable) {
						echo '<td class="cell_grid" colspan="2">';
						echo $variable['naslov'];
						echo '('.$variable['variable'].')';
						echo '</td>';
					}
					echo '</tr>';


					echo '<tr class="row3">';

					foreach ($grid['variables'] AS $vkey => $variable) {
						echo '<td class="cell_value">Povprečje</td>';
						echo '<td class="cell_value">Št. enot</td>';
					}

					echo '</tr>';


					$cnt=0;
					foreach ($frequencys AS $fkey => $fkeyFrequency) {
						$cbxLabel = $forSpremenljivka['grids'][0]['variables'][$cnt]['naslov'];
						$cnt++;

						foreach ($forSpremenljivka['options'] AS $oKey => $option) {
							if ($displayAll || $means[$fkey][$oKey] != null) {

								# če je osnova checkbox vzamemo samo tam ko je 1
								if(($forSpremenljivka['tip'] == 2 && $option == 1) || $forSpremenljivka['tip'] != 2 ) { 
									
                                    echo '<tr>';

									echo '<td class="cell_value">';
									if ($forSpremenljivka['tip'] == 2) {
										echo $cbxLabel;
									} 
                                    else {
										echo $forSpremenljivka['options'][$oKey];
									}
									
									echo '</td>';

									foreach ($grid['variables'] AS $vkey => $variable) {
										$sequence = $variable['sequence'];

										#povprečje
										echo '<td class="cell_value">';
										echo $this->formatNumber($means[$fkey][$oKey][$sequence],$this->num_digit_average,'');
										echo '</td>';

										# enote
										echo '<td class="cell_value">';
										echo (int)$frequencys[$fkey][$oKey][$sequence]['validCnt'];
										echo '</td>';

										$totalMeans[$sequence] += ($means[$fkey][$oKey][$sequence]*(int)$frequencys[$fkey][$oKey][$sequence]['validCnt']);
										$totalFreq[$sequence]+= (int)$frequencys[$fkey][$oKey][$sequence]['validCnt'];
										
									}
									echo '</tr>';
								}
							}
						}
					}


					#dodamo še skupno sumo in povprečje
					echo '<tr>';

					echo '<td class="cell_value">';
					echo 'Skupaj';
					echo '</td>';

					foreach ($grid['variables'] AS $vkey => $variable) {
						$sequence = $variable['sequence'];
						if ($variable['other'] != 1) {

							#povprečja
							echo '<td class="cell_value">';
							$totalMean =  $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0;
							echo $this->formatNumber($totalMean ,$this->num_digit_average,'');
							echo '</td>';

							# enote
							echo '<td class="cell_value">';
							echo (int)$totalFreq[$sequence];
							echo '</td>';
						}
					}

					echo '</tr>';

					echo '</table>';
								
					echo '</div>';
				}
			}	
		}	
	}
	
    #text - 21:
	#multi text - 19:
	function displayBreakTableText($forSpr,$frequencys,$spremenljivka){
		global $lang;
		$keysCount = count($frequencys);
		$sequences = explode('_',$spremenljivka['sequences']);
		$forSpremenljivka = $this->_HEADERS[$forSpr];
		
		$tip = $spremenljivka['tip'];
		# izračunamo povprečja za posamezne sekvence
		$texts = array();
		$totalMeans = array();
		$totalFreq = array();
		$forSequences = array();
		$cnt = array();

		foreach ($frequencys AS $fkey => $fkeyFrequency) {
			$forSequences[] = $fkey;
			foreach ($forSpremenljivka['options'] AS $oKey => $option) {
				foreach ($sequences AS $sequence) {
					$txt = isset($fkeyFrequency[$oKey][$sequence])?$this->getTextFromKey($fkeyFrequency[$oKey][$sequence]):array();
					if ($txt) {
						$cnt[$fkey]++;
						$texts[$fkey][$oKey][$sequence] = $txt;
					}
				}
			}
		}

		# če imamo več kot 20 kategorij,izpisujemo samo tiste ki imajo vrednosti
		$displayAll = (count($forSpremenljivka['options']) > 20) ? false : true;		

        # za multi text razdelimo na grupe - skupine
        $rowspan = ' rowspan="2"';
        $colspan = ' colspan="'.(count($spremenljivka['grids'][0]['variables'])).'"';


        foreach ($spremenljivka['grids'] AS $gkey => $grid) {
                            
            // Ce smo v porocilu po meri in ni prava tabela jo preskocimo
            if(isset($spremenljivka['break_sub_table']['sequence']) && $spremenljivka['break_sub_table']['key'] != $gkey){
                continue;
            }

            echo '<div id="'.$spremenljivka['id'].'" class="table_holder">';
            

            echo '<div class="top_line">';

            // Ce smo v porocilu po meri in je prava tabelo jo izpisemo brez naslova
            if(!isset($spremenljivka['break_sub_table']['sequence'])){					
			
                if($tip != '21'){
                    echo '<div class="table_title">';

                    echo $lang['srv_break_table_for'];
                    echo $spremenljivka['naslov'].' (';
                    echo $spremenljivka['variable'].') = ';
                    echo $grid['naslov'];
                    echo ' ('.$grid['variable'].')';

                    echo '</div>';
                }
            }

            // Zvezdica za vkljucitev v porocilo
            $spr1 = $this->sessionData['break']['seq'].'-'. $this->sessionData['break']['spr'].'-undefined';
            $spr2 = $grid['variables'][0]['sequence'].'-'.$spremenljivka['id'].'-undefined';
            SurveyAnalysisHelper::getInstance()->addCustomReportElement($type=9, $sub_type=0, $spr1, $spr2);

            echo '</div>';

            
            echo '<table class="table_break">';


            #labele
            echo '<tr class="row1">';

            echo '<td class="cell_question" '.$rowspan.'>';
            echo '<span class="anl_variabla">';
            echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $forSpr . '\'); return false;">';
            echo $forSpremenljivka['naslov'];
            echo '('.$forSpremenljivka['variable'].')';
            echo '</a>';
            echo '</span>';
            echo '</td>';
            
            echo '<td class="cell_question" '.$colspan.'>';
            echo '<span class="anl_variabla">';
            echo '<a href="#" title="' . $lang['srv_predogled_spremenljivka'] . '" onclick="showspremenljivkaSingleVarPopup(\'' . $spremenljivka['id'] . '\'); return false;">';
            echo $spremenljivka['naslov']. ' - ';
            echo $grid['naslov'];
            echo isset($grid['variable'])?'('.$grid['variable'].')':'';
            echo '</a>';
            echo '</span>';
            echo '</td>';

            echo'</tr>';


            #labele
            echo '<tr class="row2">';

            foreach ($grid['variables'] AS $vkey => $variable) {
                echo '<td class="cell_grid">';
                echo $variable['naslov'];
                echo '('.$variable['variable'].')';
                echo '('.$variable['sequence'].')';
                echo '</td>';
            }

            echo '</tr>';


            $cntCbx= 0;
            foreach ($forSequences AS $fKey => $forSequence) {
                $cbxLabel = $forSpremenljivka['grids'][0]['variables'][$cntCbx]['naslov'];
                $cntCbx++;

                foreach ($forSpremenljivka['options'] AS $oKey => $option) {
                    if ($displayAll || $texts[$forSequence][$oKey] != null) { 
                        if(($forSpremenljivka['tip'] == 2 && $option == 1) || $forSpremenljivka['tip'] != 2 ) {

                            echo '<tr>';

                            echo '<td class="cell_value">';
                            if ($forSpremenljivka['tip'] == 2) {
                                echo $cbxLabel;
                            } 
                            else {
                                echo $forSpremenljivka['options'][$oKey];
                            }
                            echo '</td>';

                            foreach ($grid['variables'] AS $vkey => $variable) {
                                $sequence = $variable['sequence'];
                                #povprečje
                                echo '<td class="cell_value">';
                                if (isset($texts[$forSequence][$oKey][$sequence])&&count($texts[$forSequence][$oKey][$sequence]) > 0) {
                                    $cnt=1;
                                    $count = count($texts[$forSequence][$oKey][$sequence]);
                                    foreach ($texts[$forSequence][$oKey][$sequence] AS $ky => $units) {
                                        echo '<div class="'.($cnt<=$count && $cnt>1?'anl_bt_dot ':'').('').'"style="line-height: 150%; padding:3px;">';
                                        echo $units['text'];
                                        echo '</div>';
                                        $cnt++;
                                    }
                                }
                                
                                echo '</td>';      
                            }

                            echo '</tr>';
                        }
                    }
                }
            }

            echo '</table>';

            echo '</div>';
        }
	}

	function displayCrosstabTable($forSpr,$frequencys,$spremenljivka){
		global $lang;
		#polovimo sekvence in spremenljivke
		// Ce smo v creportu imamo nastavljeno prvo spremenljivko posebej (ne v sessionu)
		if(isset($spremenljivka['break_sub_table']['sequence'])){
			$spr1 = $spremenljivka['creport_first_spr']['spr'];
			$seq1 = $spremenljivka['creport_first_spr']['seq'];
		}
		else{
			$spr1 = $this->sessionData['break']['spr'];
			$seq1 = $this->sessionData['break']['seq'];
		}
		$grd1 = 'undefined';
		foreach ($this->_HEADERS[$spr1]['grids'] AS $gid => $grid) {
			foreach ($grid['variables'] AS $vkey => $vrednost) {
				if ($vrednost['sequence'] == $seq1) {
					$grd1 = $gid;
				}
			}
		}
		
		$this->SurveyCrosstab->displayHi2 = false;
		$this->SurveyCrosstab->fromBreak = true;
		$this->SurveyCrosstab->showAverage = $this->break_percent;
		if ($spremenljivka['tip'] == 2 
				|| $spremenljivka['tip'] == 16
				|| $spremenljivka['tip'] == 4 
				|| $spremenljivka['tip'] == 19 
				|| $spremenljivka['tip'] == 21 
				|| ($spremenljivka['tip'] == 6 && $spremenljivka['skala'] != 0)
				|| ($spremenljivka['tip'] == 1 && $spremenljivka['skala'] != 0)){
			$this->SurveyCrosstab->showAverage = false;
		}
		$spr2 = $spremenljivka['id'];
		foreach ($spremenljivka['grids'] AS $gid => $grid) {
						
			// Ce smo v porocilu po meri in ni prava tabela jo preskocimo
			if(isset($spremenljivka['break_sub_table']['sequence']) && $spremenljivka['break_sub_table']['key'] != $gid){
				continue;
			}
			
			// Ce smo v porocilu po meri in je prava tabelo jo izpisemo brez naslova
			if(!isset($spremenljivka['break_sub_table']['sequence']) && ($spremenljivka['tip'] == 16 || $spremenljivka['tip'] == 6) && $this->break_charts != 1){	
				
                echo '<div class="table_title">';

                echo $lang['srv_break_table_for'];
				echo $spremenljivka['naslov'].' (';
				echo $spremenljivka['variable'].') = ';
				echo $grid['naslov'];
				if ($spremenljivka['tip'] != 6) {
					echo ' ('.$grid['variable'].')';
				}

				echo '</div>';
			}
			
			$seq2 = $grid['variables'][0]['sequence'];
			$grd2 = $gid;
			$this->SurveyCrosstab->setColor(false);
			# ali rišemo povprečje po stolpcih v zadnji vrstici
			if ($spremenljivka['tip'] == 1 && $spremenljivka['skala'] == 0 ) {
				$this->SurveyCrosstab->showBottomAverage (true);
			}
					
			if($this->break_charts == 1){
				$this->SurveyCrosstab->setVariables($seq1,$spr1,'undefined'/*$grd1*/,$seq2,$spr2,$grd2);
				$this->SurveyCrosstab->fromBreak = false;
				$tableChart = new SurveyTableChart($this->sid, $this->SurveyCrosstab, 'break');
				$tableChart->break_crosstab = 1;
				$tableChart->display();
			}
			else{
				$this->SurveyCrosstab->setVariables($seq1,$spr1,$grd1,$seq2,$spr2,$grd2);
				$this->SurveyCrosstab->displayCrosstabsTable();
			}
		}
	}

	function getMeansFromKey($frequencys) {
		$sum = 0;
		if (isset($frequencys['valid'])&&count($frequencys['valid']) > 0) {
			foreach ($frequencys['valid'] AS $fkey => $tmp) {
			
				$sum += (int)$fkey * (int)$tmp['cnt'];
			}
		}
		$mean = isset($frequencys['validCnt'])&&(int)$frequencys['validCnt'] > 0 ? (int)$sum / (int)$frequencys['validCnt'] : 0;
		return $mean;
	}
	
	function getTextFromKey($frequencys) {
		$texts = array();
		if (isset($frequencys['valid'])&&count($frequencys['valid']) > 0) {
			foreach ($frequencys['valid'] AS $fkey => $tmp) {
					$texts[] = $tmp;
			}
		}
		return $texts;
	}
	
	function DisplayLink($hideAdvanced = true) {
		global $lang;
		if ($_GET['m'] == M_ANALYSIS_BREAK) {
			$css = ' black';
		} else {
			$css = ' gray';
		} 
		
		if ($hideAdvanced == false) {
			echo '<li>';
			echo '<span class="as_link'.$css.'" title="' . $lang['srv_break'] . '"><a class="gray" href="index.php?anketa='.$this->sid.'&a=analysis&m=break">' . $lang['srv_break'] . '</a></span>'."\n";
			echo '</li>';
			echo '<li class="space">&nbsp;</li>';
		}
	}

	
	// Izvoz pdf in rtf
	function displayExport ($spr, $seq) {

		if ((int)$spr > 0 && (int)$seq > 0) {
			$href_pdf = makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis&anketa='.$this->sid);
			$href_rtf = makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis_rtf&anketa='.$this->sid);
			$href_xls = makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis_xls&anketa='.$this->sid);
			echo '<script>';
			# nastavimopravilne linke
			echo '$("#secondNavigation_links a#breakDoPdf").attr("href", "'.$href_pdf.'");';
			echo '$("#secondNavigation_links a#breakDoRtf").attr("href", "'.$href_rtf.'");';
			echo '$("#secondNavigation_links a#breakDoXls").attr("href", "'.$href_xls.'");';
			# prikažemo linke
			echo '$("#hover_export_icon").removeClass("hidden");';
			echo '$("#secondNavigation_links a").removeClass("hidden");';
			echo '</script>';
		}
	}

	// Nastavitve na dnu
	function displayBottomSettings(){
		global $site_path;
		global $lang;
		global $global_user_id;
        
        // Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
        $userAccess = UserAccess::getInstance($global_user_id);   

		$lan_print = ' title="'.$lang['PRN_Izpis'].'"';
		$lan_pdf = ' title="'.$lang['PDF_Izpis'].'"';
		$lan_rtf = ' title="'.$lang['RTF_Izpis'].'"';
		$lan_xls = ' title="'.$lang['XLS_Izpis'].'"';
		
		echo '<div class="analysis_bottom_settings printHide">';
		
        echo '<div class="comment_holder">';
		echo '  <a href="#" class="comment" onClick="addCustomReportAllElementsAlert(9);" title="'.$lang['srv_custom_report_comments_add_hover'].'" class="'.(!$userAccess->checkUserAccess('analysis_analysis_creport') ? 'user_access_locked' : '').'" user-access="analysis_analysis_creport"><span class="faicon comments" ></span><span>'.$lang['srv_custom_report_comments_add'].'</span></a>';
        echo '</div>';

		echo '<a href="'.makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis_xls&anketa=' . $this->sid) . '" target="_blank"'.$lan_xls.' class="srv_ico '.(!$userAccess->checkUserAccess('analysis_export') ? 'user_access_locked' : '').'" user-access="analysis_export"><span class="faicon xls"></span></a>';								
		//echo '<a href="'.makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis_rtf&anketa=' . $this->sid) . '" target="_blank"'.$lan_rtf.' class="srv_ico '.(!$userAccess->checkUserAccess('analysis_export') ? 'user_access_locked' : '').'" user-access="analysis_export"><span class="faicon rtf"></span></a>';
		//echo '<a href="'.makeEncodedIzvozUrlString('izvoz.php?b=export&m=break_izpis&anketa=' . $this->sid) . '" target="_blank"'.$lan_pdf.' class="srv_ico '.(!$userAccess->checkUserAccess('analysis_export') ? 'user_access_locked' : '').'" user-access="analysis_export"><span class="faicon pdf"></span></a>';
		
		echo '<a href="#" onclick="doArchiveBreak();" title="'.$lang['srv_analiza_arhiviraj_ttl'].'" class="'.(!$userAccess->checkUserAccess('archive') ? 'user_access_locked' : '').'" user-access="archive"><span class="faicon arhiv black very_large"></span></a>';
		echo '<a href="#" onclick="createArchiveBreakBeforeEmail();" title="'.$lang['srv_analiza_arhiviraj_email_ttl'] . '" class="'.(!$userAccess->checkUserAccess('archive') ? 'user_access_locked' : '').'" user-access="archive"><span class="faicon arhiv_mail"></span></a>';			

        echo '</div>';
        
        // Javascript s katerim povozimo urlje za izvoze, ki niso na voljo v paketu
        if(AppSettings::getInstance()->getSetting('app_settings-commercial_packages') === true){
            echo '<script> userAccessExport(); </script>';
        }
	}
	
	function setSessionPercent() {

		if (isset($_POST['break_percent'])) {
			$this->sessionData['break']['break_percent'] = ($_POST['break_percent'] == 'true') ? true : false;
			$this->break_percent = $this->sessionData['break']['break_percent']; 
		}

		// Shranimo spremenjene nastavitve v bazo
		SurveyUserSession::saveData($this->sessionData);
		
		$this->break_percent = isset($this->sessionData['break']['break_percent']) && (int)$this->sessionData['break']['break_percent'] == 1 ? true : false;
	}
	
	function setSessionCharts() {

		if (isset($_POST['break_charts'])) {
			$this->sessionData['break']['break_show_charts'] = ($_POST['break_charts'] == 1) ? 1 : 0;
			$this->break_charts = $this->sessionData['break']['break_show_charts']; 
		}
		
		// Shranimo spremenjene nastavitve v bazo
		SurveyUserSession::saveData($this->sessionData);
		
		$this->break_charts = isset($this->sessionData['break']['break_show_charts']) && (int)$this->sessionData['break']['break_show_charts'] == 1 ? 1 : 0;
	}
	
	function displayLinePercent() {
		global $lang;

		echo '<input id="break_percent" name="break_percent" onchange="change_break_percent();" type="checkbox" ' . ((int)$this->break_percent == 1 ? ' checked="checked" ' : '') . ' autocomplete="off"/>';
		echo '<label for="break_percent">'.$lang['srv_analiza_crosstab_odstotek_vrstice_short'].'</label>';
	}
	
	function displayLineCharts() {
		global $lang;
		
		echo '<input type="radio" value="0" name="break_charts" id="break_charts_0" '.((int)$this->break_charts == 0 ? ' checked="checked" ' : '').' onClick="change_break_charts(this.value)" />';
        echo '<label for="break_charts_0">'.$lang['srv_tables'].'</label>';

		echo '<input type="radio" value="1" name="break_charts" id="break_charts_1" '.((int)$this->break_charts == 1 ? ' checked="checked" ' : '').' onClick="change_break_charts(this.value)" />';
        echo '<label for="break_charts_1">'.$lang['srv_charts'].'</label>';
	}

}