anketa['id'] = $anketa; SurveyAnalysis::Init($this->anketa['id']); SurveyAnalysis::$setUpJSAnaliza = false; // create new XLS document $this->xls = new xls(); // Poskrbimo za datoteko s podatki $SDF = SurveyDataFile::get_instance(); $SDF->init($this->anketa['id']); $SDF->prepareFiles(); $this->headFileName = $SDF->getHeaderFileName(); $this->dataFileName = $SDF->getDataFileName(); $this->dataFileStatus = $SDF->getStatus(); $_GET['a'] = A_ANALYSIS; // preberemo nastavitve iz baze (prej v sessionu) SurveyUserSession::Init($this->anketa['id']); $this->sessionData = SurveyUserSession::getData('means'); // ustvarimo means objekt $this->meansClass = new SurveyMeans($anketa); if ( SurveyInfo::getInstance()->SurveyInit($this->anketa['id']) && $this->init()){ $this->anketa['uid'] = $global_user_id; SurveyUserSetting::getInstance()->Init($this->anketa['id'], $this->anketa['uid']); } else return false; return true; } else{ return false; } } // SETTERS && GETTERS function getFile($fileName) { //Close and output rtf document $output = $this->createXls(); $this->xls->display($fileName, $output); } function init() { return true; } function encodeText($text) { // popravimo sumnike ce je potrebno $text = html_entity_decode($text, ENT_NOQUOTES, 'UTF-8'); $text = str_replace(array("š","š","č"),array("š","š","č"),$text); return strip_tags($text); } function createXls() { global $site_path; global $lang; global $output; $convertTypes = array('charSet' => "windows-1250", 'delimit' => ";", 'newLine' => "\n", 'BOMchar' => "\xEF\xBB\xBF"); $output = $convertTypes['BOMchar']; $output .= '

'.$lang['export_analisys_means'].'

'; $means = array(); # če ne uporabljamo privzetega časovnega profila izpišemo opozorilo //$doNewLine = SurveyTimeProfiles :: printIsDefaultProfile(false); # če imamo filter ifov ga izpišemo //$doNewLine = SurveyConditionProfiles:: getConditionString($doNewLine ); # če imamo filter spremenljivk ga izpišemo //$doNewLine = SurveyVariablesProfiles:: getProfileString($doNewLine , true) || $doNewLine; $this->meanData1 = $this->sessionData['means_variables']['variabla1']; $this->meanData2 = $this->sessionData['means_variables']['variabla2']; if ($this->meanData1 !== null && $this->meanData2 !== null) { $variables1 = $this->meanData2; $variables2 = $this->meanData1; $c1=0; $c2=0; if (is_array($variables2) && count($variables2) > 0) { foreach ($variables2 AS $v_second) { if (is_array($variables1) && count($variables1) > 0) { foreach ($variables1 AS $v_first) { $_means = $this->meansClass->createMeans($v_first, $v_second); if ($_means != null) { $means[$c1][$c2] = $_means; } $c2++; } } $c1++; $c2=0; } } if (is_array($means) && count($means) > 0) { foreach ($means AS $mean_sub_grup) { $output .= ''; $this->displayMeansTable($mean_sub_grup); } } } return $output; } public function displayMeansTable($_means) { global $lang; global $output; #število vratic in število kolon $cols = count($_means); # preberemo kr iz prvega loopa $rows = count($_means[0]['options']); # ali prikazujemo vrednosti variable pri spremenljivkah $show_variables_values = $this->meansClass->doValues; # izrišemo tabelo $output .= ''; $output .= ''; $label2 = $this->meansClass->getSpremenljivkaTitle($_means[0]['v2']); $label2 = $this->encodeText($label2); $output .= ''; for ($i = 0; $i < $cols; $i++) { $output .= ''; } $output .= ''; $output .= ''; for ($i = 0; $i < $cols; $i++) { #Povprečje $output .= ''; #odstotki $output .= ''; } $output .= ''; if (count($_means[0]['options']) > 0) { foreach ($_means[0]['options'] as $ckey2 =>$crossVariabla2) { $output .= ''; $output .= ''; # celice z vsebino for ($i = 0; $i < $cols; $i++) { $output .= ''; $output .= ''; } $output .= ''; } } $output .= ''; $output .= ''; for ($i = 0; $i < $cols; $i++) { $output .= ''; $output .= ''; } $output .= ''; $output .= '

'; $output .= ''.$label2.''; $output .= '	'; $label1 = $this->meansClass->getSpremenljivkaTitle($_means[$i]['v1']); $label1 = $this->encodeText($label1); $output .= ''.$label1.''; $output .= '
	'; $output .= $lang['srv_means_label']; $output .= '	'.$lang['srv_means_label4'].'
'; $output .= $crossVariabla2['naslov']; # če ni tekstovni odgovor dodamo key if ($crossVariabla2['type'] !== 't' ) { if ($show_variables_values == true) { if ($crossVariabla2['vr_id'] == null) { $output .= ' ( '.$ckey2.' )'; } else { $output .= ' ( '.$crossVariabla2['vr_id'].' )'; } } } $output .= '	'; $output .= $this->meansClass->formatNumber($_means[$i]['result'][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL')); $output .= '	'; $output .= (int)$_means[$i]['sumaVrstica'][$ckey2]; $output .= '
'.$lang['srv_means_label3'].'	'; $output .= $this->meansClass->formatNumber($_means[$i]['sumaMeans'], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL')); $output .= '	'; $output .= (int)$_means[$i]['sumaSkupna']; $output .= '

'; } /*Skrajsa tekst in doda '...' na koncu*/ function snippet($text,$length=64,$tail="...") { $text = trim($text); $txtl = strlen($text); if($txtl > $length) { for($i=1;$text[$length-$i]!=" ";$i++) { if($i == $length) { return substr($text,0,$length) . $tail; } } $text = substr($text,0,$length-$i+1) . $tail; } return $text; } function setUserId($usrId) {$this->anketa['uid'] = $usrId;} function getUserId() {return ($this->anketa['uid'])?$this->anketa['uid']:false;} function formatNumber($value,$digit=0,$sufix="") { if ( $value <> 0 && $value != null ) $result = round($value,$digit); else $result = "0"; //$result = number_format($result, $digit, ',', '.').$sufix; $result = number_format($result, $digit, ',', '') . $sufix; // Preprecimo da bi se stevilo z decimalko pretvorilo v datum //$result = '="'. $result.'"'; return $result; } } ?>