diff options
Diffstat (limited to 'admin/exportclases/class.xlsIzvozAnalizaMean.php')
| -rw-r--r-- | admin/exportclases/class.xlsIzvozAnalizaMean.php | 294 |
1 files changed, 294 insertions, 0 deletions
diff --git a/admin/exportclases/class.xlsIzvozAnalizaMean.php b/admin/exportclases/class.xlsIzvozAnalizaMean.php new file mode 100644 index 0000000..c007754 --- /dev/null +++ b/admin/exportclases/class.xlsIzvozAnalizaMean.php @@ -0,0 +1,294 @@ +<?php
+
+ global $site_path;
+
+ include_once('../../function.php');
+ include_once('../survey/definition.php');
+ include_once('../exportclases/class.xls.php');
+
+
+/** Class za generacijo xls-ja
+ *
+ */
+class XlsIzvozAnalizaMean {
+
+ var $anketa; // trenutna anketa
+
+ private $headFileName = null; // pot do header fajla
+ private $dataFileName = null; // pot do data fajla
+ private $dataFileStatus = null; // status data datoteke
+
+ public $meansClass = null; //means class
+
+ var $meanData1;
+ var $meanData2;
+
+ var $sessionData; // podatki ki so bili prej v sessionu - za nastavitve, ki se prenasajo v izvoze...
+
+
+ /**
+ * @desc konstruktor
+ */
+ function __construct ($anketa = null, $podstran = 'mean'){
+ global $site_path;
+ global $global_user_id;
+ global $output;
+
+ // preverimo ali imamo stevilko ankete
+ if ( is_numeric($anketa) ){
+
+ $this->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 .= '<table border="0"><tr><td colspan="10"><font size="3"><b>'.$lang['export_analisys_means'].'</b></font></td></tr></table>';
+
+
+ $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 .= '<table border="0"><tr><td></td></tr></table>';
+
+ $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 .= '<table border="1">';
+
+ $output .= '<tr>';
+
+ $label2 = $this->meansClass->getSpremenljivkaTitle($_means[0]['v2']);
+ $label2 = $this->encodeText($label2);
+
+ $output .= '<td align="center" rowspan="2">';
+ $output .= '<b>'.$label2.'</b>';
+ $output .= '</td>';
+
+ for ($i = 0; $i < $cols; $i++) {
+ $output .= '<td align="center" colspan="2" >';
+ $label1 = $this->meansClass->getSpremenljivkaTitle($_means[$i]['v1']);
+ $label1 = $this->encodeText($label1);
+ $output .= '<b>'.$label1.'</b>';
+ $output .= '</td>';
+ }
+ $output .= '</tr>';
+ $output .= '<tr>';
+
+ for ($i = 0; $i < $cols; $i++) {
+ #Povprečje
+ $output .= '<td align="center">';
+ $output .= $lang['srv_means_label'];
+ $output .= '</td>';
+ #odstotki
+ $output .= '<td align="center">'.$lang['srv_means_label4'].'</td>';
+ }
+ $output .= '</tr>';
+
+ if (count($_means[0]['options']) > 0) {
+ foreach ($_means[0]['options'] as $ckey2 =>$crossVariabla2) {
+ $output .= '<tr>';
+
+
+ $output .= '<td align="center">';
+ $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 .= '</td>';
+ # celice z vsebino
+ for ($i = 0; $i < $cols; $i++) {
+ $output .= '<td align="center" k1="'.$ckey1.'" k2="'.$ckey2.'" n1="'.$crossVariabla1['naslov'].'" n2="'.$crossVariabla2['naslov'].'" v1="'.$crossVariabla1['vr_id'].'" v2="'.$crossVariabla2['vr_id'].'">';
+ $output .= $this->meansClass->formatNumber($_means[$i]['result'][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'));
+ $output .= '</td>';
+ $output .= '<td align="center">';
+ $output .= (int)$_means[$i]['sumaVrstica'][$ckey2];
+ $output .= '</td>';
+ }
+ $output .= '</tr>';
+ }
+ }
+ $output .= '<tr>';
+ $output .= '<td align="center">'.$lang['srv_means_label3'].'</td>';
+ for ($i = 0; $i < $cols; $i++) {
+ $output .= '<td align="center">';
+
+ $output .= $this->meansClass->formatNumber($_means[$i]['sumaMeans'], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'));
+ $output .= '</td>';
+ $output .= '<td align="center">';
+ $output .= (int)$_means[$i]['sumaSkupna'];
+ $output .= '</td>';
+ }
+ $output .= '</tr>';
+ $output .= '</table>';
+ }
+
+
+ /*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;
+ }
+}
+
+?>
\ No newline at end of file |