anketa['id'] = $anketa; // create new XLS document $this->xls = new xls(); } else { return false; } $_GET['a'] = A_ANALYSIS; // preberemo nastavitve iz baze (prej v sessionu) SurveyUserSession::Init($this->anketa['id']); $this->sessionData = SurveyUserSession::getData('break'); // ustvarimo break objekt $this->breakClass = new SurveyBreak($anketa); $this->spr = $this->sessionData['spr']; # poiščemo sekvenco $this->seq = $this->sessionData['seq']; $this->break_percent = (isset($this->sessionData['break_percent']) && $this->sessionData['break_percent'] == false) ? false : true; 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; } // 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_break'].' - '.SurveyInfo::getSurveyTitle().'
'; $output .= '
'; if ($this->spr != 0){ # poiščemo pripadajoče variable $_spr_data = $this->breakClass->_HEADERS[$this->spr]; # poiščemo opcije $options = $_spr_data['options']; # za vsako opcijo posebej izračunamo povprečja za vse spremenljivke $frequencys = null; if (count($options) > 0) { foreach ($options as $okey => $option) { # zloopamo skozi variable $okeyfrequencys = $this->breakClass->getAllFrequencys($okey, $this->seq, $this->spr); if ($okeyfrequencys != null) { if ($frequencys == null) { $frequencys = array(); } $frequencys[$okey] = $okeyfrequencys; } } } $this->displayBreak($this->spr,$frequencys); } else { $output .= '
'.$lang['srv_break_error_note_1'].'
'; } return $output; } function displayBreak($forSpr, $frequencys) { # č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(); # če rekodiranje //$SR = new SurveyRecoding($this->anketa); //$SR -> getProfileString(); # filtriranje po spremenljivkah $_FILTRED_VARIABLES = SurveyVariablesProfiles::getProfileVariables(SurveyVariablesProfiles::checkDefaultProfile(), true); foreach ($this->breakClass->_HEADERS AS $skey => $spremenljivka) { $spremenljivka['id'] = $skey; $tip = $spremenljivka['tip']; 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); } } } function displayBreakSpremenljivka($forSpr,$frequencys,$spremenljivka) { $tip = $spremenljivka['tip']; $skala = $spremenljivka['skala']; if ($forSpr != $spremenljivka['id']) { switch ($tip) { # radio, dropdown case 1: case 3: $this->displayCrosstabs($forSpr,$frequencys,$spremenljivka); break; #multigrid case 6: if ($spremenljivka['skala'] == 0) { $this->displayBreakTableMgrid($forSpr,$frequencys,$spremenljivka); } else { $this->displayCrosstabs($forSpr,$frequencys,$spremenljivka); } break; # checkbox case 2: $this->displayCrosstabs($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->displayCrosstabs($forSpr,$frequencys,$spremenljivka); break; case 4: case 21: $this->displayCrosstabs($forSpr,$frequencys,$spremenljivka); break; default: $this->displayCrosstabs($forSpr,$frequencys,$spremenljivka); break; } } } function displayBreakTableMgrid($forSpr,$frequencys,$spremenljivka) { global $lang; global $output; $keysCount = count($frequencys); $sequences = explode('_',$spremenljivka['sequences']); $forSpremenljivka = $this->breakClass->_HEADERS[$forSpr]; $tip = $spremenljivka['tip']; # izračunamo povprečja za posamezne sekvence $means = array(); $totalMeans = array(); $totalFreq = array(); foreach ($frequencys AS $fkey => $fkeyFrequency) { foreach ($sequences AS $sequence) { $means[$fkey][$sequence] = $this->breakClass->getMeansFromKey($fkeyFrequency[$sequence]); } } $rowspan = 'rowspan="3"'; $colspan = 'colspan="'.count($sequences).'"'; # če ni multicheck in multi grid $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } } $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } } $output .= ''; foreach ($frequencys AS $fkey => $fkeyFrequency) { $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; if ($variable['other'] != 1) { #povprečja $output .= ''; $totalMeans[$sequence] += ($this->breakClass->getMeansFromKey($fkeyFrequency[$sequence])*(int)$frequencys[$fkey][$sequence]['validCnt']); $totalFreq[$sequence]+= (int)$frequencys[$fkey][$sequence]['validCnt']; } } } $output .= ''; } #dodamo še skupno sumo in povprečje $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; if ($variable['other'] != 1) { #povprečja $output .= ''; } } } $output .= ''; $output .= '
'; $output .= ''.$forSpremenljivka['naslov']; $output .= '('.$forSpremenljivka['variable'].')'; $output .= ''; $output .= ''.$spremenljivka['naslov']; $output .= '('.$spremenljivka['variable'].')'; $output .= '
'; $output .= $variable['naslov']; $output .= '('.$variable['variable'].')'; $output .= '
Povprečje'; $output .= '
'; $output .= $forSpremenljivka['options'][$fkey]; $output .= ''; $output .= self::formatNumber($means[$fkey][$sequence],SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= 'Skupaj'; $output .= ''; $totalMean = $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0; $output .= self::formatNumber($totalMean ,SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= '
'; } function displayBreakTableNumber($forSpr,$frequencys,$spremenljivka) { global $lang; global $output; $keysCount = count($frequencys); $sequences = explode('_',$spremenljivka['sequences']); $forSpremenljivka = $this->breakClass->_HEADERS[$forSpr]; $tip = $spremenljivka['tip']; # izračunamo povprečja za posamezne sekvence $means = array(); $totalMeans = array(); $totalFreq = array(); foreach ($frequencys AS $fkey => $fkeyFrequency) { foreach ($sequences AS $sequence) { $means[$fkey][$sequence] = $this->breakClass->getMeansFromKey($fkeyFrequency[$sequence]); } } # za multi number naredimo po skupinah if ($tip != 20 ) { $rowspan = ' rowspan="3"'; $colspan = ' colspan="'.(count($sequences)).'"'; # če ni multicheck in multi grid $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } } $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } } $output .= ''; foreach ($frequencys AS $fkey => $fkeyFrequency) { $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; if ($variable['other'] != 1) { #povprečja $output .= ''; $totalMeans[$sequence] += ($this->breakClass->getMeansFromKey($fkeyFrequency[$sequence])*(int)$frequencys[$fkey][$sequence]['validCnt']); $totalFreq[$sequence]+= (int)$frequencys[$fkey][$sequence]['validCnt']; } } } $output .= ''; } #dodamo še skupno sumo in povprečje $output .= ''; $output .= ''; foreach ($spremenljivka['grids'] AS $gkey => $grid) { foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; if ($variable['other'] != 1) { #povprečja $output .= ''; } } } $output .= ''; $output .= '
'; $output .= ''.$forSpremenljivka['naslov']; $output .= '('.$forSpremenljivka['variable'].')'; $output .= ''; $output .= ''.$spremenljivka['naslov']; $output .= '('.$spremenljivka['variable'].')'; $output .= '
'; $output .= $variable['naslov']; $output .= '('.$variable['variable'].')'; $output .= '
Povprečje'; $output .= '
'; $output .= $forSpremenljivka['options'][$fkey]; $output .= ''; $output .= self::formatNumber($means[$fkey][$sequence],SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= 'Skupaj'; $output .= ''; $totalMean = $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0; $output .= self::formatNumber($totalMean ,SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= '
'; } else if ($tip == 20){ # za multi number razdelimo na grupe - skupine $rowspan = ' rowspan="3"'; $colspan = ' colspan="'.(count($spremenljivka['grids'][0]['variables'])).'"'; foreach ($spremenljivka['grids'] AS $gkey => $grid) { $text = '
Tabela za: '.$spremenljivka['naslov'].' ('.$spremenljivka['variable'].') = '.$grid['naslov'].' ('.$grid['variable'].')'; $text .= '
'; $output.= $text; $output .= ''; #labele $output .= ''; $output .= ''; $output .= ''; $output .=''; #labele $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } $output .= ''; $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } $output .= ''; foreach ($forSpremenljivka['options'] AS $okey => $option) { $output .= ''; $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; #povprečje $output .= ''; $totalMeans[$sequence] += ($means[$okey][$sequence]*(int)$frequencys[$okey][$sequence]['validCnt']); $totalFreq[$sequence]+= (int)$frequencys[$okey][$sequence]['validCnt']; } $output .= ''; } #dodamo še skupno sumo in povprečje $output .= ''; $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; if ($variable['other'] != 1) { #povprečja $output .= ''; } } $output .= ''; $output .= '
'; $output .= ''.$forSpremenljivka['naslov']; $output .= '('.$forSpremenljivka['variable'].')'; $output .= ''; $output .= ''.$spremenljivka['naslov']. ' - '; $output .= $grid['naslov']; $output .= '('.$grid['variable'].')'; $output .= '
'; $output .= $variable['naslov']; $output .= '('.$variable['variable'].')'; $output .= '
Povprečje'; $output .= '
'; $output .= $option; $output .= ''; $output .= self::formatNumber($means[$okey][$sequence],SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= 'Skupaj'; $output .= ''; $totalMean = $totalFreq[$sequence] > 0 ? $totalMeans[$sequence] / $totalFreq[$sequence] : 0; $output .= self::formatNumber($totalMean ,SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_AVERAGE'),''); $output .= '
'; $output .= '
'; } } } function displayBreakTableText($forSpr,$frequencys,$spremenljivka) { global $lang; global $output; $keysCount = count($frequencys); $sequences = explode('_',$spremenljivka['sequences']); $forSpremenljivka = $this->breakClass->_HEADERS[$forSpr]; $tip = $spremenljivka['tip']; # izračunamo povprečja za posamezne sekvence $texts = array(); $totalMeans = array(); $totalFreq = array(); foreach ($frequencys AS $fkey => $fkeyFrequency) { foreach ($sequences AS $sequence) { $texts[$fkey][$sequence] = $this->breakClass->getTextFromKey($fkeyFrequency[$sequence]); } } # za multi text razdelimo na grupe - skupine $rowspan = ' rowspan="2"'; $colspan = ' colspan="'.(count($spremenljivka['grids'][0]['variables'])).'"'; foreach ($spremenljivka['grids'] AS $gkey => $grid) { $text = '
Tabela za: '.$spremenljivka['naslov'].' ('.$spremenljivka['variable'].') = '.$grid['naslov'].' ('.$grid['variable'].')'; $text .= '
'; $output.= $text; $output .= ''; #labele $output .= ''; $output .= ''; $output .= ''; $output .=''; #labele $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $output .= ''; } $output .= ''; foreach ($forSpremenljivka['options'] AS $okey => $option) { $output .= ''; $output .= ''; foreach ($grid['variables'] AS $vkey => $variable) { $sequence = $variable['sequence']; #povprečje $output .= ''; } $output .= ''; } $output .= '
'; $output .= ''.$forSpremenljivka['naslov']; $output .= '('.$forSpremenljivka['variable'].')'; $output .= ''; $output .= ''.$spremenljivka['naslov']. ' - '; $output .= $grid['naslov']; $output .= '('.$grid['variable'].')'; $output .= '
'; $output .= $variable['naslov']; $output .= '('.$variable['variable'].')'; $output .= '
'; $output .= $option; $output .= ''; if (count($texts[$okey][$sequence]) > 0) { $text = ''; foreach ($texts[$okey][$sequence] AS $ky => $units) { $text .= $units['text'].', '; } $text = substr($text,0,-2); $output .= $units['text']; } $output .= '
'; $output .= '
'; } } function displayCrosstabs($forSpr,$frequencys,$spremenljivka) { global $lang; global $output; //ustvarimo crosstab objekt $this->crosstabClass = new SurveyCrosstabs(); $this->crosstabClass->Init($this->anketa['id']); $spr1 = $this->spr; $seq1 = $this->seq; $grd1 = 'undefined'; foreach ($this->breakClass->_HEADERS[$spr1]['grids'] AS $gid => $grid) { foreach ($grid['variables'] AS $vkey => $vrednost) { if ($vrednost['sequence'] == $seq1) { $grd1 = $gid; } } } $spr2 = $spremenljivka['id']; foreach ($spremenljivka['grids'] AS $gid => $grid) { if ($spremenljivka['tip'] == 16 || $spremenljivka['tip'] == 6) { $text = '
Tabela za: '.$spremenljivka['naslov'].' ('.$spremenljivka['variable'].') = '.$grid['naslov']; if ($spremenljivka['tip'] != 6) { $text .= ' ('.$grid['variable'].')'; } $text .= '
'; $output.= $text; } $seq2 = $grid['variables'][0]['sequence']; $grd2 = $gid; $this->crosstabClass->setVariables($seq2,$spr2,$grd2,$seq1,$spr1,$grd1); $this->displayCrosstabsTable(); } } function displayCrosstabsTable() { global $lang; global $output; if ($this->crosstabClass->getSelectedVariables(1) !== null && $this->crosstabClass->getSelectedVariables(2) !== null) { $variables1 = $this->crosstabClass->getSelectedVariables(1); $variables2 = $this->crosstabClass->getSelectedVariables(2); foreach ($variables1 AS $v_first) { foreach ($variables2 AS $v_second) { $crosstabs = null; $crosstabs_value = null; $crosstabs = $this->crosstabClass->createCrostabulation($v_first, $v_second); $crosstabs_value = $crosstabs['crosstab']; # podatki spremenljivk $spr1 = $this->crosstabClass->_HEADERS[$v_first['spr']]; $spr2 = $this->crosstabClass->_HEADERS[$v_second['spr']]; $grid1 = $spr1['grids'][$v_first['grd']]; $grid2 = $spr2['grids'][$v_second['grd']]; #število vratic in število kolon $cols = count($crosstabs['options1']); $rows = count($crosstabs['options2']); # ali prikazujemo vrednosti variable pri spremenljivkah $show_variables_values = $this->crosstabClass->doValues; # nastavitve oblike if (($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) && ($this->crosstabClass->crossChkEC || $this->crosstabClass->crossChkRE || $this->crosstabClass->crossChkSR || $this->crosstabClass->crossChkAR)) { # dodamo procente in residuale $rowSpan = 3; $numColumnPercent = $this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3; $numColumnResidual = $this->crosstabClass->crossChkEC + $this->crosstabClass->crossChkRE + $this->crosstabClass->crossChkSR + $this->crosstabClass->crossChkAR; $tblColumn = max($numColumnPercent,$numColumnResidual); } else if ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) { # imamo samo procente $rowSpan = 2; $numColumnPercent = $this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3; $numColumnResidual = 0; $tblColumn = $numColumnPercent; } else if ($this->crosstabClass->crossChkEC || $this->crosstabClass->crossChkRE || $this->crosstabClass->crossChkSR || $this->crosstabClass->crossChkAR) { # imamo samo residuale $rowSpan = 2; $numColumnPercent = 0; $numColumnResidual = $this->crosstabClass->crossChkEC + $this->crosstabClass->crossChkRE + $this->crosstabClass->crossChkSR + $this->crosstabClass->crossChkAR; $tblColumn = $numColumnResidual; } else { #prikazujemo samo podatke $rowSpan = 1; $numColumnPercent = 0; $numColumnResidual = 0; $tblColumn = 1; } //izracun sirine ene celice $singleWidth = round( 170 / $cols ); //izracun visine ene celice if($rowSpan == 1) $height = 8; elseif($rowSpan == 2) $height = 10; else $height = 15; # izrišemo tabelo # najprej izrišemo naslovne vrstice # za multicheckboxe popravimo naslov, na podtip $sub_q1 = null; if ($spr1['tip'] == '6' || $spr1['tip'] == '16' || $spr1['tip'] == '17' || $spr1['tip'] == '19' || $spr1['tip'] == '20') { foreach ($spr1['grids'] AS $grid) { foreach ($grid['variables'] AS $variable) { if ($variable['sequence'] == $v_first['seq']) { $sub_q1 = strip_tags($spr1['naslov']); if ($show_variables_values == true ) { $sub_q1 .= ' ('.strip_tags($spr1['variable']).')'; } if ($spr1['tip'] == '16') { $sub_q1 .= ', ' . strip_tags($grid1['naslov']) . ($show_variables_values == true ? ' (' . strip_tags($grid1['variable']) . ')' : ''); } else { $sub_q1 .= ', ' . strip_tags($variable['naslov']) . ($show_variables_values == true ? ' (' . strip_tags($variable['variable']) . ')' : ''); } } } } } if ($sub_q1 == null) { $sub_q1 .= strip_tags($spr1['naslov']); $sub_q1 .= ($show_variables_values == true ? ' ('.strip_tags($spr1['variable']).')' : ''); } $sub_q2 = null; if ($spr2['tip'] == '6' || $spr2['tip'] == '16' || $spr2['tip'] == '17' || $spr2['tip'] == '19' || $spr2['tip'] == '20') { foreach ($spr2['grids'] AS $grid) { foreach ($grid['variables'] AS $variable) { if ($variable['sequence'] == $v_second['seq']) { $sub_q2 = strip_tags($spr2['naslov']); if ($show_variables_values == true) { $sub_q2 .= ' ('.strip_tags($spr2['variable']).')'; } if ($spr2['tip'] == '16') { $sub_q2.= ',
' . strip_tags($grid2['naslov']) . ($show_variables_values == true ? ' (' . strip_tags($grid2['variable']) . ')' : ''); } else { $sub_q2.= ',
' . strip_tags($variable['naslov']) . ($show_variables_values == true ? ' (' . strip_tags($variable['variable']) . ')' : ''); } } } } } if ($sub_q2 == null) { $sub_q2 .= strip_tags($spr2['naslov']); $sub_q2 .= ($show_variables_values == true ? ' ('.strip_tags($spr2['variable']).')' : ''); } # izrišemo tabelo # najprej izrišemo naslovne vrstice $output .= ''; /*$output .= ''; $output .= ''; $output .= ''; if (count($crosstabs['options1']) > 0 ) { $_width_percent = round(100 / count($crosstabs['options1'],2)); foreach ($crosstabs['options1'] as $ckey1 =>$crossVariabla) { $output .= ''; } } $output .= ''; $output .= '';*/ $output .= ''; /*$output .= '';*/ $output .= ''; $output .= ''; $output .= ''; $output .= ''; $col_cnt=0; if (count($crosstabs['options1']) > 0 ) { foreach ($crosstabs['options1'] as $ckey1 =>$crossVariabla) { $col_cnt++; #ime variable $output .= ''; } } $col_cnt++; $output .= ''; $output .= ''; $cntY = 0; if (count($crosstabs['options2']) > 0) { foreach ($crosstabs['options2'] as $ckey2 =>$crossVariabla2) { $cntY++; $output .= ''; if ($cntY == 1) { # ime variable $output .= ''; } //$css_backY = 'rsdl_bck_variable'.($cntY & 1); $css_backY = ' rsdl_bck_variable1'; $output .= ''; foreach ($crosstabs['options1'] as $ckey1 => $crossVariabla1) { $output .= ''; } // vedno rišemo zadnji stolpec. $output .= ''; $output .= ''; } } $cntY++; $output .= ''; $output .= ''; // skupni sestevki po stolpcih if (count($crosstabs['options1']) > 0) foreach ($crosstabs['options1'] as $ckey1 => $crossVariabla1) { $output .= ''; } # zadnja celica z skupno sumo $output .= ''; $output .= ''; $output .= '
Χ2 = '; $output .= $this->formatNumber($crosstabs['hi2'], 3, ''); $output .= ''; $output .= ''.$sub_q1.''; $output .= ' 
'; $output .= $crossVariabla['naslov']; # če ni tekstovni odgovor dodamo key if ($crossVariabla['type'] != 't' && $show_variables_values == true) { if ($crossVariabla['vr_id'] == null ) { $output .= '
( '.$ckey1.' )'; } else { $output .= '
( '.$crossVariabla['vr_id'].' )'; } } $output .= '
' . $lang['srv_analiza_crosstab_skupaj'] . '
'; $output .= ''.$sub_q2.''; $output .= ''; $output .= $crossVariabla2['naslov']; # če ni tekstovni odgovor dodamo key if ($crossVariabla2['type'] !== 't' && $show_variables_values == true ) { if ($crossVariabla2['vr_id'] == null) { $output .= '
( '.$ckey2.' )'; } else { $output .= '
( '.$crossVariabla2['vr_id'].' )'; } } $output .= '
'; # celica z vebino { # prikazujemo eno ali več od: frekvenc, odstotkov, residualov $output .= ''; if ($this->crosstabClass->crossChk0) { # izpišemo frekvence crostabov $output .= ''; $output .= ''; $output .= ''; } if ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) { # sirina celice v % if ( ($this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3) == 3 ) $css_width = ' ctb_w33p'; elseif (($this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3) == 2 ) $css_width = ' ctb_w50p'; else $css_width = ''; $css_bt = ( $this->crosstabClass->crossChk0 ) ? 'anl_dash_bt' : ''; # izpisemo procente $output .= ''; $output .= ''; $output .= ''; } # izpisemo residuale if ($this->crosstabClass->crossChkEC || $this->crosstabClass->crossChkRE || $this->crosstabClass->crossChkSR || $this->crosstabClass->crossChkAR) { # sirina celice v % if ( ($this->crosstabClass->crossChkEC + $this->crosstabClass->crossChkRE + $this->crosstabClass->crossChkSR + $this->crosstabClass->crossChkAR) == 4 ) $css_width = ' ctb_w25p'; elseif ( ($this->crosstabClass->crossChkEC + $this->crosstabClass->crossChkRE + $this->crosstabClass->crossChkSR + $this->crosstabClass->crossChkAR) == 3 ) $css_width = ' ctb_w33p'; elseif ( ($this->crosstabClass->crossChkEC + $this->crosstabClass->crossChkRE + $this->crosstabClass->crossChkSR + $this->crosstabClass->crossChkAR) == 2 ) $css_width = ' ctb_w50p'; else $css_width = ''; $css_bt = ( $this->crosstabClass->crossChk0 || ($this->crosstabClass->crossChk1 && $this->crosstabClass->crossChk2 && $this->crosstabClass->crossChk3)) ? 'anl_dash_bt' : ''; $output .= ''; $output .= ''; $output .= ''; } $output .= '
'; $output .= ((int)$crosstabs_value[$ckey1][$ckey2] > 0) ? $crosstabs_value[$ckey1][$ckey2] : 0; # .$crossTab[$crossVariabla1[cell_id]][$ckey2] # $output .= '
'; $output .= ''; $output .= ''; $col=0; if ($this->crosstabClass->crossChk1) { #procent vrstica $col++; $css_color = ($this->crosstabClass->doColor == 'true') ? 'ctbChck_sp1' : ''; $css_br = $numColumnPercent > $col ? ' anl_dash_br' : ''; $output .= ''; } if ($this->crosstabClass->crossChk2) { #procent stolpec $col++; $css_br = $numColumnPercent > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'ctbChck_sp2' : ''; $output .= ''; } if ($this->crosstabClass->crossChk3) { #procent skupni $col++; $css_br = $numColumnPercent > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'ctbChck_sp3' : ''; $output .= ''; } $output .= ''; $output .= '
'; $output .= $this->formatNumber($this->crosstabClass->getCrossTabPercentage($crosstabs['sumaVrstica'][$ckey2], $crosstabs_value[$ckey1][$ckey2]), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber($this->crosstabClass->getCrossTabPercentage($crosstabs['sumaStolpec'][$ckey1], $crosstabs_value[$ckey1][$ckey2]), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber($this->crosstabClass->getCrossTabPercentage($crosstabs['sumaSkupna'], $crosstabs_value[$ckey1][$ckey2]), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= '
'; $output .= '
'; $output .= ''; $output .= ''; $col=0; if ($this->crosstabClass->crossChkEC) { $col++; $css_br = $numColumnResidual > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'crossCheck_EC' : ''; $output .= ''; } if ($this->crosstabClass->crossChkRE) { $col++; $css_br = $numColumnResidual > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'crossCheck_RE' : ''; $output .= ''; } if ($this->crosstabClass->crossChkSR) { $col++; $css_br = $numColumnResidual > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'crossCheck_SR' : ''; $output .= ''; } if ($this->crosstabClass->crossChkAR) { $col++; $css_br = $numColumnResidual > $col ? ' anl_dash_br' : ''; $css_color = ($this->crosstabClass->doColor == 'true') ? 'crossCheck_AR' : ''; $output .= ''; } $output .= ''; $output .= '
'; $output .= $this->formatNumber($crosstabs['exC'][$ckey1][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'), ''); $output .= ''; $output .= $this->formatNumber($crosstabs['res'][$ckey1][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'), ''); $output .= ''; $output .= $this->formatNumber($crosstabs['stR'][$ckey1][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'), ''); $output .= ''; $output .= $this->formatNumber($crosstabs['adR'][$ckey1][$ckey2], SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_RESIDUAL'), ''); $output .= '
'; $output .= '
'; } # konec celice z vsebino $output .= '
'; $output .= ''; if ($this->crosstabClass->crossChk0) { $output .= ''; $output .= ''; $output .= ''; } if ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) { if (($this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3) == 3) { $css_width = ' ctb_w33p'; } else if (($this->crosstabClass->crossChk1 + $this->crosstabClass->crossChk2 + $this->crosstabClass->crossChk3) == 2) { $css_width = ' ctb_w50p'; } else { $css_width = ''; } $css_bt = ( $this->crosstabClass->crossChk0 ) ? ' anl_dash_bt' : ''; # suma po vrsticah v procentih $output .= ''; if ($this->crosstabClass->crossChk1) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp1' : ''; $output .= ''; } if ($this->crosstabClass->crossChk2) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp2' : ''; $css_border = ($this->crosstabClass->crossChk1 ? ' anl_dash_bl ' : ''); $output .= ''; } if ($this->crosstabClass->crossChk3) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp3' : ''; $css_border = ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 ? ' anl_dash_bl ' : ''); $output .= ''; } $output .= ''; } $output .= '
'; # suma po vrsticah $output .= (int)$crosstabs['sumaVrstica'][$ckey2]; $output .= '
'; $output .= $this->formatNumber(100, SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber( ($crosstabs['sumaSkupna'] > 0 ? (100 * $crosstabs['sumaVrstica'][$ckey2] / $crosstabs['sumaSkupna']) : 0), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber( ($crosstabs['sumaSkupna'] > 0 ? (100 * $crosstabs['sumaVrstica'][$ckey2] / $crosstabs['sumaSkupna']) : 0), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= '
'; $output .= '
 '; //$css_backY = 'rsdl_bck_variable'.($cntY & 1); $css_backY = ' rsdl_bck_variable1'; $output .= '' . $lang['srv_analiza_crosstab_skupaj'] . ''; { # prikazujemo eno od treh možnosti $output .= ''; if ($this->crosstabClass->crossChk0) { $output .= ''; $output .= ''; $output .= ''; } if ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) { # suma po stolpcih v procentih $css_bt = ($this->crosstabClass->crossChk0) ? ' anl_dash_bt' : ''; $output .= ''; if ($this->crosstabClass->crossChk1) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp1' : ''; $output .= ''; } if ($this->crosstabClass->crossChk2) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp2' : ''; $output .= ''; } if ($this->crosstabClass->crossChk3) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp3' : ''; $output .= ''; } $output .= ''; } $output .= '
'; # suma po stolpcih $output .= (int)$crosstabs['sumaStolpec'][$ckey1]; $output .= '
'; $output .= $this->formatNumber( ($crosstabs['sumaSkupna'] > 0 ? (100 * $crosstabs['sumaStolpec'][$ckey1] / $crosstabs['sumaSkupna']) : 0), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber(100, SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber( ($crosstabs['sumaSkupna'] > 0 ? (100 * $crosstabs['sumaStolpec'][$ckey1] / $crosstabs['sumaSkupna']) : 0), SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= '
'; } $output .= '
'; { $output .= ''; if ($this->crosstabClass->crossChk0) { $output .= ''; $output .= ''; $output .= ''; } if ($this->crosstabClass->crossChk1 || $this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) { # suma po stolpcih v procentih $css_bt = ($this->crosstabClass->crossChk0) ? ' anl_dash_bt' : ''; $output .= ''; if ($this->crosstabClass->crossChk1) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp1' : ''; $css_border = ($this->crosstabClass->crossChk2 || $this->crosstabClass->crossChk3) ? ' anl_dash_br' : ''; $output .= ''; } if ($this->crosstabClass->crossChk2) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp2' : ''; $css_border = ($this->crosstabClass->crossChk3) ? ' anl_dash_br' : ''; $output .= ''; } if ($this->crosstabClass->crossChk3) { $css_color = ($this->crosstabClass->doColor == 'true') ? ' ctbChck_sp3' : ''; $output .= ''; } $output .= ''; } $output .= '
'; # skupna suma $output .= (int)$crosstabs['sumaSkupna']; $output .= '
'; $output .= $this->formatNumber(100, SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber(100, SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= ''; $output .= $this->formatNumber(100, SurveyDataSettingProfiles :: getSetting('NUM_DIGIT_PERCENT'), '%'); $output .= '
'; } $output .= '
'; $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; } } ?>