diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyParaAnalysis.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyParaAnalysis.php | 1550 |
1 files changed, 1550 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyParaAnalysis.php b/admin/survey/classes/class.SurveyParaAnalysis.php new file mode 100644 index 0000000..f5813cf --- /dev/null +++ b/admin/survey/classes/class.SurveyParaAnalysis.php @@ -0,0 +1,1550 @@ +<?php
+
+class SurveyParaAnalysis{
+
+ private $anketa; # id ankete
+ private $db_table; # katere tabele uporabljamo
+ public $_HEADERS = array(); # shranimo podatke vseh variabel
+
+ private $headFileName = null; # pot do header fajla
+ private $dataFileName = null; # pot do data 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 (zakeširamo)
+
+ public $_CURRENT_STATUS_FILTER = ''; # filter po statusih, privzeto izvažamo 6 in 5
+ public $_PROFILE_ID_VARIABLE = ''; # filter po statusih, privzeto izvažamo 6 in 5
+
+ public $_HAS_TEST_DATA = false; # ali anketa vsebuje testne podatke
+
+ private $sessionData; # podatki ki so bili prej v sessionu - za nastavitve, ki se prenasajo v izvoze...
+
+
+ private $decimal_point = ',';
+ private $thousands = '.';
+ private $num_digit_average = NUM_DIGIT_AVERAGE;
+ private $num_digit_percent = NUM_DIGIT_PERCENT;
+ private $_missings = array();
+ private $_unsets = array();
+
+ private $cols_with_value = array(); # kateri stolpci imajo vrednosti
+ private $show_with_zero = false; # Ali prikazujemo stolpce z vrednostmi 0
+ private $show_with_other = true; # Ali prikazujemo vrstice "Drugo"
+
+
+ private $show_question_basic = true; # Ali prikazujemo vprašanja v osnovnem načinu
+ private $show_graph_basic = true; # Ali prikazujemo graf v osnovnem načinu
+ private $show_question_breaks = true; # Ali prikazujemo vprašanja v prekinitvak
+ private $show_graph_breaks = true; # Ali prikazujemo graf v prekinitvah
+ private $show_question_advanced = false; # Ali prikazujemo vprašanja v naprednem načinu
+ private $show_graph_advanced = false; # Ali prikazujemo graf v naprednem načinu
+ private $show_graph_breaks_type = 0; # Kareri graf prikazujemo 0=>SP, 1=>SP bruto, 2=>SP neto
+
+ private $show_categories = true; # Ali prikazujemo kategorične spremenljivke
+ private $show_numbers = true; # Ali prikazujemo numeričnespremenljivke
+ private $show_text = true; # Ali prikazujemo textovne spremenljivke
+
+ private $spr_type;
+
+ function __construct($anketa)
+ {
+ if ((int)$anketa > 0)
+ {
+ $this->anketa = $anketa;
+
+ SurveyAnalysisHelper::getInstance()->Init($this->anketa);
+
+ # polovimo vrsto tabel (aktivne / neaktivne)
+ SurveyInfo :: getInstance()->SurveyInit($this->anketa);
+ if (SurveyInfo::getInstance()->getSurveyColumn('db_table') == 1) {
+ $this->db_table = '_active';
+ }
+ $this->_CURRENT_STATUS_FILTER = STATUS_FIELD.' ~ /6|5/';
+
+ Common::deletePreviewData($this->anketa);
+
+
+ // Poskrbimo za datoteko s podatki
+ $this->SDF = SurveyDataFile::get_instance();
+ $this->SDF->init($this->anketa);
+ $this->SDF->prepareFiles();
+
+ $this->headFileName = $this->SDF->getHeaderFileName();
+ $this->dataFileName = $this->SDF->getDataFileName();
+ $this->dataFileStatus = $this->SDF->getStatus();
+
+
+ # Inicializiramo in polovimo nastavitve missing profila
+ SurveyStatusProfiles::Init($this->anketa);
+ SurveyUserSetting::getInstance()->Init($this->anketa, $global_user_id);
+ SurveyConditionProfiles :: Init($this->anketa, $global_user_id);
+ SurveyTimeProfiles :: Init($this->anketa, $global_user_id);
+ SurveyVariablesProfiles :: Init($this->anketa, $global_user_id);
+ SurveyDataSettingProfiles :: Init($this->anketa);
+ # 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');
+
+ $this->spr_type = SurveyDataSettingProfiles::$spr_type;
+
+ // preberemo nastavitve iz baze (prej v sessionu)
+ SurveyUserSession::Init($this->anketa);
+ $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));
+ }
+
+ # nastavimo vse filtre
+ $this->setUpFilter();
+
+ # nastavimo filtre uporabnika
+ $this->setUserFilters();
+
+ }
+ else
+ {
+ echo 'Invalid Survey ID!';
+ exit();
+ }
+ }
+
+ /** 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;
+ }
+
+ # 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;
+ }
+ }
+
+ $smv = new SurveyMissingValues($this->anketa);
+ $smv -> Init();
+
+ $smv_array = $smv->GetSurveyMissingValues($this->anketa);
+ if (!empty($smv_array[1])){
+ foreach ($smv_array[1] AS $_survey_missings)
+ {
+ $this->_missings[$_survey_missings['value']] = $_survey_missings['text'];
+
+ }
+ }
+ if (!empty($smv_array[2])){
+ foreach ($smv_array[2] AS $_survey_unsets)
+ {
+ $this->_unsets[$_survey_unsets['value']] = $_survey_unsets['text'];
+ }
+ }
+ }
+
+ private function setUserFilters()
+ {
+ # Nastavimo filtre variabel
+ $dvp = SurveyUserSetting :: getInstance()->getSettings('default_variable_profile');
+ $_currentVariableProfile = SurveyVariablesProfiles :: checkDefaultProfile($dvp);
+ if ($dvp != $_currentVariableProfile) {
+ SurveyUserSetting :: getInstance()->saveSettings('default_variable_profile', $_currentVariableProfile);
+ }
+ $this->_PROFILE_ID_VARIABLE = $_currentVariableProfile;
+
+ # ali prikazujemo tudi stolpce z 0 vrednostmi
+ if (isset($this->sessionData['para_analysis']['show_with_zero'])) {
+ $this->show_with_zero = $this->sessionData['para_analysis']['show_with_zero'];
+ }
+
+ # ali prikazujemo vrstice "Drugo"
+ if (isset($this->sessionData['para_analysis']['show_with_other'])) {
+ $this->show_with_other = $this->sessionData['para_analysis']['show_with_other'];
+ }
+/*
+ # ali prikazujemo vrstice tipa "besedilo"
+ if (isset($this->sessionData['para_analysis']['show_with_text'])) {
+ $this->show_with_text = $this->sessionData['para_analysis']['show_with_text'];
+ }
+*/
+
+ # Ali prikazujemo vprašanja v osnovnem nacinu
+ if (isset($this->sessionData['para_analysis']['show_question_basic'])) {
+ $this->show_question_basic = $this->sessionData['para_analysis']['show_question_basic'];
+ }
+ # Ali prikazujemo vprašanja v preinitvah
+ if (isset($this->sessionData['para_analysis']['show_question_breaks'])) {
+ $this->show_question_breaks = $this->sessionData['para_analysis']['show_question_breaks'];
+ }
+ # Ali prikazujemo vprašanja v naprednem nacinu
+ if (isset($this->sessionData['para_analysis']['show_question_advanced'])) {
+ $this->show_question_advanced = $this->sessionData['para_analysis']['show_question_advanced'];
+ }
+ # Ali prikazujemo graf v osnovnem nacinu
+ if (isset($this->sessionData['para_analysis']['show_graph_basic'])) {
+ $this->show_graph_basic = $this->sessionData['para_analysis']['show_graph_basic'];
+ }
+ # Ali prikazujemo graf v prekinitvah
+ if (isset($this->sessionData['para_analysis']['show_graph_breaks'])) {
+ $this->show_graph_breaks = $this->sessionData['para_analysis']['show_graph_breaks'];
+ }
+ # Ali prikazujemo graf v naprednem nacinu
+ if (isset($this->sessionData['para_analysis']['show_graph_advanced'])) {
+ $this->show_graph_advanced = $this->sessionData['para_analysis']['show_graph_advanced'];
+ }
+ # Kateri tip grafa prikazujemo v prekinitvah
+ if (isset($this->sessionData['para_analysis']['show_graph_breaks_type']) && in_array((int)$this->sessionData['para_analysis']['show_graph_breaks_type'], array(0,1,2))) {
+ $this->show_graph_breaks_type = $this->sessionData['para_analysis']['show_graph_breaks_type'];
+ }
+
+ # Ali prikazujemo kategorije, numerične, besedila
+ if (isset($this->sessionData['para_analysis']['show_categories'])) {
+ $this->show_categories = $this->sessionData['para_analysis']['show_categories'];
+ }
+ if (isset($this->sessionData['para_analysis']['show_numbers'])) {
+ $this->show_numbers = $this->sessionData['para_analysis']['show_numbers'];
+ }
+ if (isset($this->sessionData['para_analysis']['show_text'])) {
+ $this->show_text = $this->sessionData['para_analysis']['show_text'];
+ }
+
+ }
+
+ function Display() {
+ global $lang;
+
+
+ # ali imamo testne podatke
+ if ($this->_HAS_TEST_DATA){
+ # izrišemo bar za testne podatke
+ $SSH = new SurveyStaticHtml($this->anketa);
+ $SSH -> displayTestDataBar(true);
+ }
+
+ //$this->DisplayLinks();
+
+ echo '<div id="displayFilterNotes">';
+ # če imamo filter zoom ga izpišemo
+ SurveyZoom::getConditionString();
+ # če imamo filter ifov ga izpišemo
+ SurveyConditionProfiles:: getConditionString();
+ # če ne uporabljamo privzetega časovnega profila izpišemo opozorilo
+ SurveyTimeProfiles :: printIsDefaultProfile();
+ # če imamo filter spremenljivk ga izpišemo
+ SurveyVariablesProfiles:: getProfileString();
+
+ SurveyDataSettingProfiles :: getVariableTypeNote($doNewLine );
+ echo '</div>';
+
+ echo '<div class="clr"> </div>';
+
+
+ $this->displayData();
+ }
+
+
+ function DisplayGraph()
+ {
+ global $lang;
+ $paraType = 'basic';
+
+ if (isset($_GET['m']) && $_GET['m'] == 'advanced') {
+ $paraType = 'advanced';
+ }
+ if (isset($_GET['m']) && $_GET['m'] == 'breaks') {
+ $paraType = 'breaks';
+ }
+
+ $showSettings = false;
+ if (isset($_SESSION['sid_'.$this->anketa]['paraAnalysisGraph_settings']) && $_SESSION['sid_'.$this->anketa]['paraAnalysisGraph_settings'] == true) {
+
+ $showSettings = true;
+ }
+
+ echo '<div id="dataSettingsCheckboxes" class="paraAnalysisGraph" '.($showSettings ? '' : ' style="display:none;"').'>';
+ echo '<div id="toggleDataCheckboxes2" onClick="toggleDataCheckboxes(\'paraAnalysisGraph\');"><span class="faicon close icon-orange" style="padding-bottom:2px;"></span> '.$lang['srv_para_close_settings'].'</div>';
+
+ echo '<table id="para_settings"><tr><th>Spremenljivke</th><th rowspan="2" class="anl_bl spacer"></th><th>Prekinitve</th><th rowspan="2" class="anl_bl spacer"></th><th>Podrobno</th></tr>';
+ echo '<tr><td>';
+ # spremenljivke
+ echo '<div class="floatLeft">';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_question_basic" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_basic == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_para_show_question_basic'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_graph_basic" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_basic == true ? ' checked="checked"' : '').' autocomplete="off" >';
+ echo $lang['srv_para_show_show_graph_basic'];
+ echo '</label>';
+ echo '</div>';
+ # end:spremenljivke
+ echo '</td><td>';
+ # prekinitve
+ echo '<div class="floatLeft">';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_question_breaks" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_breaks == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_para_show_question_breaks'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_graph_breaks" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_breaks == true ? ' checked="checked"' : '').' autocomplete="off" >';
+ echo $lang['srv_para_show_show_graph_breaks'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>'.$lang['srv_para_graph_type'].':';
+ echo '<select id="show_graph_breaks_type" onchange="changeParaAnalysisSelect(this);" autocomplete="off">';
+ echo '<option value="0"'.((int)$this->show_graph_breaks_type == 0 ? ' selected="selected"' : '').'>'.$lang['srv_para_graph_type0'].'</option>';
+ echo '<option value="1"'.((int)$this->show_graph_breaks_type == 1 ? ' selected="selected"' : '').'>'.$lang['srv_para_graph_type1'].'</option>';
+ echo '<option value="2"'.((int)$this->show_graph_breaks_type == 2 ? ' selected="selected"' : '').'>'.$lang['srv_para_graph_type2'].'</option>';
+ echo '</select>';
+ echo '</label>';
+ echo '</div>';
+
+ # end: prekinitve
+ echo '</td><td>';
+ # podrobno
+ echo '<div class="floatLeft">';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_with_zero" onclick="changeParaAnalysisCbx(this,true);" '.($this->show_with_zero == false ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_para_only_valid'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_with_other" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_with_other == true ? ' checked="checked"' : '').' autocomplete="off" >';
+ echo $lang['srv_para_show_rows_other'];
+ echo '</label>';
+ echo '</div>';
+ echo '<div class="floatLeft spaceLeftBig anl_bl">';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_categories" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_categories == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_analiza_kategorialneSpremenljivke'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_numbers" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_numbers == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_analiza_numericneSpremenljivke'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_text" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_text == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_analiza_textovneSpremenljivke'];
+ echo '</label>';
+ echo '</div>';
+
+ echo '<div class="floatLeft spaceLeftBig">';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_question_advanced" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_advanced == true ? ' checked="checked"' : '').' autocomplete="off">';
+ echo $lang['srv_para_show_question_advanced'];
+ echo '</label>';
+ echo '<br/>';
+ echo '<label>';
+ echo '<input type="checkbox" id="show_graph_advanced" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_advanced == true ? ' checked="checked"' : '').' autocomplete="off" >';
+ echo $lang['srv_para_show_show_graph_advanced'];
+ echo '</label>';
+ echo '</div>';
+
+ # end:podrobno
+ echo '</td></tr></table>';
+
+ if ($paraType == 'basic') {
+ }
+ if ($paraType == 'advanced') {
+ }
+
+ echo '<div class="clr"></div>';
+
+ echo '</div>'; // konec diva zapiranje nastavitev
+
+
+ echo '<div id="div_para_data">';
+
+ echo '<div id="displayFilterNotes">';
+ # če imamo filter ifov ga izpišemo
+ SurveyConditionProfiles:: getConditionString();
+ # če imamo filter spremenljivk ga izpišemo
+ SurveyVariablesProfiles:: getProfileString();
+ echo '</div>';
+
+
+ if ($paraType == 'basic') {
+ $this->displayGraphDataBasic();
+ }
+ if ($paraType == 'advanced') {
+ $this->displayGraphDataAdvanced();
+ }
+ if ($paraType == 'breaks') {
+ $this->displayGraphDataBreaks();
+ }
+ echo '</div>'; #id="div_pra_data"
+
+ }
+
+
+ function DisplayLinks()
+ {
+ # izrišemo navigacijo za analize
+ $SSH = new SurveyStaticHtml($this->anketa);
+ $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;
+ }
+ </script>';
+ }
+
+ # izrišemo navigacijo za analize
+ $SSH = new SurveyStaticHtml($this->anketa);
+ # izrišemo desne linke do posameznih nastavitev
+ $SSH -> displayAnalizaRightOptions(M_ANALYSIS_PARA);
+
+ }
+
+ function displayGraphDataBreaks() {
+ global $lang;
+ $pageUrl = "index.php?anketa=" . $this->anketa . "&a=nonresponse_graph&m=breaks";
+ $showGraph = $this->show_graph_breaks;
+ $showQuestion = $this->show_question_breaks;
+ $showGraphType = $this->show_graph_breaks_type;
+
+ // prestejemo vprasanja, če jih je več kot 1 ne moreš na glasovanja
+ $sqlQ = sisplet_query("SELECT g.id as g_id, g.naslov, s.id as spr_id FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' ORDER BY g.vrstni_red, s.vrstni_red");
+
+
+ $pages = array();
+ $sprPage = array();
+ while ($row = mysqli_fetch_assoc($sqlQ)) {
+ $sprPage[$row['spr_id']] = $row['g_id'];
+ if (!isset($pages[$row['g_id']])) {
+ $pages[$row['g_id']] = $row['naslov'];
+ }
+ }
+ $headerVariablesId = $this->getVariables();
+
+ list($data, $show_delta) = $this->collectData();
+
+ $cnt_missing = 0;
+ $cnt_undefined = 0;
+ $valid = SurveyStatusProfiles::getAllValidCount();
+ $all = SurveyStatusProfiles::getAllUserCount();
+
+ $percent_all = SurveyStatusProfiles::getActiveProfileUserCount();
+ $sspid = SurveyStatusProfiles::getCurentProfileId();
+ $isNotStandardProfile = ($sspid != 1 && $sspid != 2);
+ $added_colspan = 5+1*$isNotStandardProfile;
+ $showPercent = true;
+
+ // sort bo treba dodelat.. glede na to da se ns, ns_neto, ns_bruto izmenično prikazujejo v grafu
+/*
+ $sort_type = SORT_ASC;
+ if (isset($_REQUEST['sort_type'])
+ && ((int)$_REQUEST['sort_type'] == SORT_DESC || (int)$_REQUEST['sort_type'] == SORT_ASC)) {
+ $sort_type = (int)$_REQUEST['sort_type'];
+ }
+ if ($sort_type != SORT_DESC) {
+ $sort_type = SORT_ASC;
+ }
+ $sort_type_sprite = $sort_type == SORT_ASC ? 'sort_ascending' : 'sort_descending';
+
+ $sort_field = 'variable';
+ if (isset($_REQUEST['sort'])) {
+ $sort_field = $_REQUEST['sort'];
+ }
+
+ if ($sort_field != 'ns') {
+ $sort_field = 'variable';
+ }
+
+ // če ni po spremenljivki
+ if ($sort_field != 'variable') {
+ #do sort
+ #sort_seq=10&sort_type=sort_asc
+ $sort = array();
+ foreach ($rows as $key => $row) {
+ if ($sort_field == 'ns') {
+ $sort[$key] = $row['ns'];
+ } else {
+ $sort[$key] = $row['variable'];
+ }
+ }
+
+ array_multisort($sort, $sort_type, $rows);
+ } else {
+
+ if ($sort_type != SORT_ASC ) {
+ $rows = array_reverse($rows);
+ }
+
+ }
+
+ // če imamo privzeto sortiranje izrisujemo še strani
+ $showPages = false;
+ if (count($pages) > 1 && $sort_field == 'variable') {
+ if ($sort_type == SORT_ASC) {
+
+ } else {
+ $sprPage = array_reverse($sprPage, true);
+ }
+ $showPages = true;
+ }
+*/
+ // ko bo rešen sort odstrani še tole spodaj
+ $showPages = true;
+
+ $this->displayFormula();
+
+ $rows = $data;
+
+ $baseColspan = 6;
+
+ echo '<table id="tbl_para_analitics" class="graph'.($showGraph ? ' showGraph' : '').'">';
+ echo '<tr class="persist-header">';
+ echo '<th class="anl_w50 pointer" ';
+ if ($sort_field == 'variable') {
+ if ($sort_type == SORT_DESC) {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=v&sort_type=" . SORT_ASC . "')\"";
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=v&sort_type=" . SORT_DESC . "')\"";
+ }
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=v&sort_type=" . SORT_ASC . "')\"";
+ }
+ echo '>';
+ echo '<span class="floatLeft pointer">' . $lang['srv_para_variable'] . '</span>';
+ if ($sort_field == 'variable') {
+ echo '<span class="floatRight faicon '.$sort_type_sprite.'"> </span>';
+ }
+ echo'</th>';
+ if ($showQuestion) {
+ echo '<th class="anl_w200" >'.$lang['srv_para_question'].'</th>';
+ }
+ echo '<th class="anl_w50" title="'.$lang['srv_para_breaks'].'">'.$lang['srv_para_breaks_short'].'</th>';
+ if ($show_delta) {
+ echo '<th class="anl_w50" title="'.$lang['srv_para_breaks_delta'].'">'.$lang['srv_para_breaks_delta_short'].'</th>';
+ }
+
+/*
+ * echo '<th class="anl_w70" title="'.$lang['srv_para_breaks_value'].'"';
+ if ($sort_field == 'ns') {
+ if ($sort_type == SORT_DESC) {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_ASC . "')\"";
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_DESC . "')\"";
+ }
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_ASC . "')\"";
+ }
+
+ echo '>';
+ echo '<span>' . $lang['srv_para_breaks_short']. Help :: display('srv_item_nonresponse') . '</span>';
+ if ($sort_field == 'ns') {
+ echo '<span class="floatRight faicon '.$sort_type_sprite.'"> </span>';
+ }
+*/
+ echo '<th class="anl_w50" title="'.$lang['srv_para_breaks_value'].'">';
+ echo '<span>' . $lang['srv_para_breaks_value_short']. '</span>';
+ echo '</th>';
+ echo '<th class="anl_w50" title="'.$lang['srv_para_breaks_value_bruto'].'">';
+ echo '<span>' . $lang['srv_para_breaks_value_bruto_short'].'</span>';
+ echo '</th>';
+ echo '<th class="anl_w50" title="'.$lang['srv_para_breaks_value_neto'].'">';
+ echo '<span>' . $lang['srv_para_breaks_value_neto_short'].'</span>';
+ echo '</th>';
+# echo '<th class="anl_w70 pointer" title="'.$lang['srv_para_breaks_value_bruto'].'">';
+# echo '<span>' . $lang['srv_para_breaks_value_bruto_short']. '</span>';
+# echo '</th>';
+# echo '<th class="anl_w75 pointer" title="'.$lang['srv_para_breaks_value_neto'].'">';
+# echo '<span>' . $lang['srv_para_breaks_value_neto_short']. '</span>';
+# echo '</th>';
+ if ($showGraph) {
+ echo '<th class="anl_bb" title="' . $lang['srv_para_breaks_graph_title'] . '">' . $lang['srv_para_breaks_graph_title'] . '</th>';
+ }
+ echo '</tr>';
+
+ if ($showPages) {
+ $oldPage = reset($sprPage);
+ $newPage = $oldPage;
+ echo '<tr>';
+ echo '<td colspan="' . ($baseColspan + (int)$showQuestion + (int)$showGraph). '" class=" para_page_break">
+ <span>' . $pages[$newPage] . '</span></td>';
+ //echo '<td class="empty_cell"></td>';
+ echo '</tr>';
+
+ }
+ foreach ($rows AS $row) {
+ if ($showPages) {
+ $newPage = $sprPage[$row['sid']];
+ if ($newPage != $oldPage) {
+ $oldPage = $newPage;
+ echo '<tr>';
+ echo '<td colspan="' . ($baseColspan + (int)$showQuestion + (int)$showGraph). '" class=" para_page_break">
+ <span>' . $pages[$newPage] . '</span></td>';
+ //echo '<td class="empty_cell"></td>';
+ echo '</tr>';
+ }
+ }
+
+ echo '<tr class="'.$css_sublcass.'">';
+ echo '<td >';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $row['spid'] . '\'); return false;" href="#">' . $row['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ if ($showQuestion) {
+ echo '<td>';
+ echo (strlen($row['naslov']) > 40 ? substr($row['naslov'],0,40)."..." : $row['naslov']);
+ echo '</td>';
+ }
+ $val = 0;
+ if (isset($row['values'][-3])) {
+ $val = $row['values'][-3];
+ }
+ echo '<td>'.$val.'</td>';
+ if ($show_delta) {
+ echo '<td>'.$row['delta'].'</td>';
+ }
+ echo '<td>'.common::formatNumber($row['sp']*100,1).'</td>';
+ echo '<td>'.common::formatNumber($row['sp_bruto']*100,1).'</td>';
+ echo '<td>'.common::formatNumber($row['sp_neto']*100,1).'</td>';
+
+ #echo '<td>'.common::formatNumber($value,2).'</td>';
+ if ($showGraph) {
+ $width = $row['sp'];
+ if ((int)$showGraphType == 1) {
+ $width = $row['sp_bruto'];
+ } elseif ((int)$showGraphType == 2) {
+ $width = $row['sp_neto'];
+ }
+
+ echo '<td class="empty_cell">';
+ if ($row['sp'] > 0) {
+ echo '<div class="para_analitics_bar" style="'.'width:'.($width*100).'%; text-align:right; padding-right:5px; color:green;"></div>';
+ } else {
+ echo '<div class="para_analitics_bar null_value" style="'.'width:1px"></div>';
+ }
+ echo '</td>';
+ }
+ echo '</tr>';
+
+ }
+ echo '</table>';
+ #SurveyAnalysisHelper::getInstance()->displayMissingLegend();
+
+ $this->displayLink();
+ echo '<br class="clr" />';
+ }
+
+
+ function displayGraphDataBasic() {
+ global $lang;
+
+ $pageUrl = "index.php?anketa=" . $this->anketa . "&a=nonresponse_graph";
+
+ $showGraph = $this->show_graph_basic;
+ $showQuestion = $this->show_question_basic;
+
+
+ $headerVariablesId = $this->getVariables();
+
+ list($data, $show_delta) = $this->collectData();
+ // delta naj se ne prikazuje pri Spremenljivke
+ $show_delta = false;
+
+ $cnt_missing = 0;
+ $cnt_undefined = 0;
+ $valid = SurveyStatusProfiles::getAllValidCount();
+ $all = SurveyStatusProfiles::getAllUserCount();
+
+ $percent_all = SurveyStatusProfiles::getActiveProfileUserCount();
+ $sspid = SurveyStatusProfiles::getCurentProfileId();
+ $isNotStandardProfile = ($sspid != 1 && $sspid != 2);
+ $added_colspan = 5+1*$isNotStandardProfile;
+ $showPercent = true;
+
+ $rows = $data;
+
+ /*
+ # pripravimo podatke
+ $rows = array();
+ foreach ($headerVariablesId AS $headerVariableId) {
+ $spr = $this->_HEADERS[$headerVariableId];
+ if (empty($spr['grids'])) {
+ continue;
+ }
+ $grids = $spr['grids'];
+ foreach ($grids AS $gid => $grid) {
+
+ $variables = $grid['variables'];
+ if (empty($variables)) {
+ continue;
+ }
+ foreach ($variables AS $vid => $variable) {
+ $data_seq = array();
+ $tip = $spr['tip'];
+ $seq = $variable['sequence'];
+
+ if (!isset($data[$seq])) {
+ continue;
+ }
+
+ $data_seq = $data[$seq];
+ $_value = 0;
+ $exposed = 0;
+
+ if (isset($data_seq[-1]) && (int)$data_seq[-1] > 0) {
+ $valid = isset($data_seq['valid']) ? (int)$data_seq['valid'] : 0;
+ // vsi nevsebinski -99, 98,97,96,95…
+ $non_conceptual_sum = 0;
+ foreach(array_keys($this->_unsets) AS $non_conceptual) {
+ if (isset($data_seq[$non_conceptual])) {
+ $non_conceptual_sum += $data_seq[$non_conceptual];
+ }
+ }
+ $exposed = ($data_seq[-1] + $valid + $non_conceptual_sum);
+ if ($exposed > 0 && $data_seq[-1] > 0) {
+ $_value = $data_seq[-1] / $exposed ;
+ }
+ }
+
+ $_variable = $variable['variable'];
+ $_naslov = $variable['naslov'];
+ if (count($variables) > 1 && in_array($tip, array(2,18,17))) {
+ $_variable = $spr['variable'];
+ $_naslov = $spr['naslov'];
+ }
+ if ($tip == 16 ) {
+ $_variable = $grid['variable'];
+ $_naslov = $grid['naslov'];
+
+ }
+
+ $row_data = array(
+ 't'=>$spr['tip'],
+ 'v'=>$_variable,
+ 'n'=>$_naslov,
+ 'w'=>$_value,
+ 'h'=>$headerVariableId,
+ 'e' => $exposed,
+ 'd'=>$data_seq['delta']
+ );
+ $rows[] = $row_data;
+ if (in_array($tip, array(2,18,17)) || $tip == 16) {
+ break;
+ }
+ }
+ }
+ }
+ */
+ $sort_type = SORT_ASC;
+ if (isset($_REQUEST['sort_type'])
+ && ((int)$_REQUEST['sort_type'] == SORT_DESC || (int)$_REQUEST['sort_type'] == SORT_ASC)) {
+ $sort_type = (int)$_REQUEST['sort_type'];
+ }
+ if ($sort_type != SORT_DESC) {
+ $sort_type = SORT_ASC;
+ }
+ $sort_type_sprite = $sort_type == SORT_ASC ? 'sort_ascending' : 'sort_descending';
+
+ $sort_field = 'variable';
+ if (isset($_REQUEST['sort'])) {
+ $sort_field = $_REQUEST['sort'];
+ }
+
+ if ($sort_field != 'ns') {
+ $sort_field = 'variable';
+ }
+
+ // če ni po spremenljivki
+ if ($sort_field != 'variable') {
+ #do sort
+ #sort_seq=10&sort_type=sort_asc
+ $sort = array();
+ foreach ($rows as $key => $row) {
+ if ($sort_field == 'ns') {
+ $sort[$key] = $row['ns'];
+ } else {
+ $sort[$key] = $row['variable'];
+ }
+ }
+
+ array_multisort($sort, $sort_type, $rows);
+ } else {
+
+ if ($sort_type != SORT_ASC ) {
+ $rows = array_reverse($rows);
+ }
+
+ }
+
+ $this->displayFormula();
+
+ echo '<table id="tbl_para_analitics" class="graph'.($showGraph ? ' showGraph' : '').'">';
+ echo '<tr class="persist-header">';
+ echo '<th class="pointer" ';
+ if ($sort_field == 'variable') {
+ if ($sort_type == SORT_DESC) {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=variable&sort_type=" . SORT_ASC . "')\"";
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=variable&sort_type=" . SORT_DESC . "')\"";
+ }
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=variable&sort_type=" . SORT_ASC . "')\"";
+ }
+ echo '>';
+ echo '<span class="floatLeft pointer">' . $lang['srv_para_variable'] . '</span>';
+ if ($sort_field == 'variable') {
+ echo '<span class="floatRight sprites '.$sort_type_sprite.'"> </span>';
+ }
+ echo'</th>';
+ if ($showQuestion) {
+ echo '<th>'.$lang['srv_para_question'].'</th>';
+ }
+ if ($show_delta) {
+ echo '<th class="anl_w50" title="'.$lang[''].'">delta</th>';
+ }
+ echo '<th class="anl_w50 pointer" title="'.$lang['srv_para_unaswered'].'"';
+ if ($sort_field == 'ns') {
+ if ($sort_type == SORT_DESC) {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_ASC . "')\"";
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_DESC . "')\"";
+ }
+ } else {
+ echo " onclick=\"window.location.assign('" . $pageUrl . "&sort=ns&sort_type=" . SORT_ASC . "')\"";
+ }
+ echo '>';
+ echo '<span>' . $lang['srv_para_unaswered_short'] . ' %</span>'; // . Help :: display('srv_item_nonresponse')
+ if ($sort_field == 'ns') {
+ echo '<span class="floatRight sprites '.$sort_type_sprite.'"> </span>';
+ }
+ echo '</th>';
+ if ($showGraph) {
+ echo '<th class="anl_bb" title="' . $lang['srv_para_unaswered_graph_title'] . '">' . $lang['srv_para_unaswered_graph_title'] . '</th>';
+ }
+ echo '</tr>';
+
+ foreach ($rows AS $row) {
+ echo '<tr class="'.$css_sublcass.'">';
+ echo '<td >';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $row['spid'] . '\'); return false;" href="#">' . $row['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ if ($showQuestion) {
+ echo '<td>';
+ echo (strlen($row['naslov']) > 40 ? substr($row['naslov'],0,40)."..." : $row['naslov']);
+ echo '</td>';
+ }
+ if ($show_delta) {
+ echo '<td>'.$row['delta'].'</td>';
+ }
+ echo '<td>'.common::formatNumber($row['ns']*100,1).'</td>';
+ #echo '<td>'.common::formatNumber($value,2).'</td>';
+ if ($showGraph) {
+ echo '<td class="empty_cell">';
+ if ($row['ns'] > 0) {
+ echo '<div class="para_analitics_bar" style="'.'width:'.($row['ns']*100).'%; text-align:right; padding-right:5px; color:green;"></div>';
+ } else {
+ echo '<div class="para_analitics_bar null_value" style="'.'width:1px"></div>';
+ }
+ echo '</td>';
+ }
+ echo '</tr>';
+
+ }
+ echo '</table>';
+ #SurveyAnalysisHelper::getInstance()->displayMissingLegend();
+
+ $this->displayLink();
+ echo '<br class="clr" />';
+ }
+
+ function displayGraphDataAdvanced( ) {
+ global $lang;
+ global $admin_type;
+
+ $showGraph = $this->show_graph_advanced;
+ $showQuestion = $this->show_question_advanced;
+
+ $headerVariablesId = $this->getVariables();
+
+ list($data, $show_delta) = $this->collectData();
+ # ali odstranimo stolpce kateri imajo same 0
+ if ($this->show_with_zero == false) {
+ # odstranimo missinge brez vrednosti
+ foreach ($this->_missings AS $_key => $_missing) {
+ if (!isset($this->cols_with_value[$_key]) || $this->cols_with_value[$_key] == false) {
+ unset($this->_missings[$_key]);
+ }
+ }
+ # odstranimo neveljavne brez vrednosti
+ foreach ($this->_unsets AS $_key => $_unset) {
+ if (!isset($this->cols_with_value[$_key]) || $this->cols_with_value[$_key] == false) {
+ unset($this->_unsets[$_key]);
+ }
+ }
+ }
+
+ $cnt_missing = 0;
+ $cnt_undefined = 0;
+
+ $valid = SurveyStatusProfiles::getAllValidCount();
+ $all = SurveyStatusProfiles::getAllUserCount();
+
+ $percent_all = SurveyStatusProfiles::getActiveProfileUserCount();
+ $sspid = SurveyStatusProfiles::getCurentProfileId();
+ $isNotStandardProfile = ($sspid != 1 && $sspid != 2);
+ $added_colspan = 5+1+$show_delta+1*$isNotStandardProfile;
+ $showPercent = true;
+
+
+ $this->displayFormula();
+
+
+ echo '<table id="tbl_para_analitics" class="persist-area">';
+ echo '<tr class="persist-header">';
+
+ // Dodatna stolpca zaradi izvoza za Katjo Lozar
+ if($admin_type == '0'){
+ echo '<th style="width:30px;">ID VPRASANJA</th>';
+ echo '<th style="width:30px;">ID VARIABLE</th>';
+ }
+
+ echo '<th>'.$lang['srv_para_variable'].'</th>';
+ if ($showQuestion) {
+ echo '<th>'.$lang['srv_para_question'].'</th>';
+ }
+ echo '<th >'.$lang['srv_para_valid'].'</th>';
+ foreach ($this->_missings AS $value => $text) {
+ $cnt_miss++;
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_mv_'.$text]."\" >{$value}<br/>(".$lang['srv_mv_'.$text].")</th>";
+ }
+ foreach ($this->_unsets AS $value => $text)
+ {
+ $cnt_undefined++;
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_mv_'.$text]."\">{$value}<br/>(".$lang['srv_mv_'.$text].")</th>";
+ }
+ if ($show_delta) {
+ echo "<th class=\"anl_w50\" title=\"".$lang['']."delta\">".$lang['']."Δ</th>";
+ }
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_para_nonconceptual']."\">".$lang['srv_para_nonconceptual']."</th>";
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_para_approp']."\">".$lang['srv_para_approp']."</th>";
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_para_all_units']."\">".$lang['srv_para_all_units']."</th>";
+ if ($isNotStandardProfile)
+ {
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_para_status']."\">".$lang['srv_para_status']."</th>";
+ }
+ echo "<th class=\"anl_w50\" title=\"".$lang['srv_para_unaswered']."\">".$lang['srv_para_unaswered_short']. Help :: display('srv_item_nonresponse')."</th>";
+ if ($showGraph) {
+ echo '<th class="anl_bb">' . $lang['srv_para_unaswered_graph_title'] . '</th>';
+ }
+
+ echo '</tr>';
+ foreach ($headerVariablesId AS $key => $headerVariableId)
+ {
+ $spr = $this->_HEADERS[$headerVariableId];
+ # ali preskočimo kategorije, numerične, besedilo
+ if (($this->show_categories == false && in_array($spr['tip'], $this->spr_type['showCategories']))
+ || ($this->show_numbers == false && in_array($spr['tip'], $this->spr_type['showNumbers']))
+ || ($this->show_text == false && in_array($spr['tip'], $this->spr_type['showText']))) {
+ # if ($this->show_with_text == false && in_array($spr['tip'], array(5, 4, 19, 21))) {
+ continue;
+ }
+
+ if (!empty($spr['grids'])) {
+ $grids = $spr['grids'];
+ if (count($grids) > 1) {
+ # če imamo več grup dodamo header vrstico
+ echo '<tr class="multiGroupHeader">';
+
+ if($admin_type == '0'){
+ echo '<td>'.$spr['spr_id'].'</td>';
+ echo '<td></td>';
+ }
+
+ if ($showQuestion) {
+ echo '<td class="showQuestion">';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan).'">';
+ echo $spr['naslov'];
+ echo '</td>';
+ } else {
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan).'">';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ }
+ if ($showGraph) {
+ echo '<td class="empty_cell30"></td>';
+ }
+ echo '</tr>';
+ }
+ else {
+ $css_GridSublcass = '';
+ }
+
+ foreach ($grids AS $gid => $grid)
+ {
+ $variables = $grid['variables'];
+
+ if (!empty($variables)) {
+ if (count($variables) > 1 ) {
+
+ # če imamo več variabel dodamo header vrstico, vrstice variabel pa obarvamo svetleje
+ $css_sublcass = 'subVar';
+ if (in_array($spr['tip'], array(2,18,17))) {
+ #razvššanje nima zapisa v grupi ampak preberemo iz spremenljivke
+
+ echo '<tr class="multiGroupHeader">';
+
+ if($admin_type == '0'){
+ echo '<td>'.$spr['spr_id'].'</td>';
+ echo '<td></td>';
+ }
+
+ if ($showQuestion) {
+ echo '<td class="showQuestion">';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan ).'">';
+ echo $spr['naslov'];
+ echo '</td>';
+ } else {
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan ).'">';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ }
+ if ($showGraph) {
+ echo '<td class="empty_cell30"></td>';
+ }
+ echo '</tr>';
+
+ }
+ else
+ { #dodamo header za grupo
+ echo '<tr class="multiVariablesHeader">';
+
+ if($admin_type == '0'){
+ echo '<td>'.$spr['spr_id'].'</td>';
+ echo '<td></td>';
+ }
+
+ if ($showQuestion) {
+ echo '<td class="showQuestion">';
+ if (count($grids) > 1) {
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $grid['variable'] . '</a>';
+ echo '</span>';
+ } else {
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ }
+ echo '</td>';
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan).'">';
+ echo $grid['naslov'];
+ echo '</td>';
+ } else {
+ echo '<td colspan="'.(count($this->_missings)+count($this->_unsets)+$added_colspan).'">';
+ if (count($grids) > 1) {
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $grid['variable'] . '</a>';
+ echo '</span>';
+ } else {
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
+ echo '</span>';
+ }
+ echo '</td>';
+ }
+ if ($showGraph) {
+ echo '<td class="empty_cell30"></td>';
+ }
+ echo '</tr>';
+ }
+ }
+ else {
+ $css_sublcass = '';
+ }
+ foreach ($variables AS $vid => $variable)
+ {
+ // če ne prikazuemo polji "Drugo"
+ if ($this->show_with_other == false && $variable['other']) {
+ continue;
+ }
+
+ $seq = $variable['sequence'];
+ $data_seq = $data[$seq];
+/*
+ $valid = isset($data_seq['valid']) ? (int)$data_seq['valid'] : 0;
+ $nonresponse = 0;
+ $exposed = 0;
+ $non_conceptual_sum = 0;
+ if (isset($data_seq[-1]) && (int)$data_seq[-1] > 0) {
+ // vsi nevsebinski -99, 98,97,96,95…
+ $non_conceptual_sum = 0;
+ foreach(array_keys($this->_unsets) AS $non_conceptual) {
+ if (isset($data_seq[$non_conceptual])) {
+ $non_conceptual_sum += $data_seq[$non_conceptual];
+ }
+ }
+ $exposed = ($data_seq[-1] + $valid + $non_conceptual_sum);
+ if ($data_seq[-1] > 0 && $exposed > 0 ) {
+ $nonresponse = $data_seq[-1] / $exposed;
+ }
+ }
+ $delta = $data_seq['delta'];
+*/
+ echo '<tr class="'.$css_sublcass.'">';
+
+ if($admin_type == '0'){
+ echo '<td rowspan="'.($showPercent*2).'">'.$spr['spr_id'].'</td>';
+ echo '<td rowspan="'.($showPercent*2).'">'.$variable['vr_id'].'</td>';
+ }
+
+ //echo '<td style="border-top:0px none !important;border-bottom:0px none !important;"> </td>';
+
+ echo '<td rowspan="'.($showPercent*2).'">';
+ echo '<span class="anl_variabla">';
+ echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $variable['variable'] . '</a>';
+ echo '</span>';
+ echo '</td>';
+ if ($showQuestion) {
+ echo '<td class="showQuestion" rowspan="'.($showPercent*2).'">';
+ echo $variable['naslov'];
+ echo '</td>';
+ }
+ echo '<td>';
+ echo (int)$data_seq['veljavni'];
+ echo '</td>';
+ foreach ($this->_missings AS $value => $text) {
+ $missing = 0;
+ if (isset($data_seq['values'][$value])) {
+ $missing = $data_seq['values'][$value];
+ }
+ echo '<td>'.(int)$missing.'</td>';
+ }
+ foreach ($this->_unsets AS $value => $text) {
+ $unset = 0;
+ if (isset($data_seq['values'][$value])) {
+ $unset = $data_seq['values'][$value];
+ }
+ echo '<td>'.(int)$unset.'</td>';
+ }
+ if ($show_delta) {
+ echo "<td rowspan=\"".($showPercent*2)."\">{$data_seq['delta']}</td>";
+ }
+ echo "<td rowspan=\"".($showPercent*2)."\">{$data_seq['prikazani']}</td>";
+ echo "<td rowspan=\"".($showPercent*2)."\">{$data_seq['veljavni']}</td>";
+ echo "<td rowspan=\"".($showPercent*2)."\">{$all}</td>";
+ if ($isNotStandardProfile)
+ {
+ echo "<td rowspan=\"".($showPercent*2)."\">{$percent_all}</td>";
+ }
+ echo "<td rowspan=\"".($showPercent*2)."\">" . common::formatNumber($data_seq['ns'],2) . "</td>";
+ if ($showGraph) {
+ echo "<td rowspan=\"".($showPercent*2)."\" class=\"empty_cell30\">";
+ if ($data_seq['ns'] > 0) {
+ echo '<div class="para_analitics_bar" style="'.'width:'.($data_seq['ns']*100).'%; text-align:right; padding-right:5px; color:green;"></div>';
+ } else {
+ echo '<div class="para_analitics_bar null_value" style="'.'width:1px"></div>';
+ }
+ echo '</td>';
+ }
+ echo '</tr>';
+
+ if ($showPercent)
+ {
+ echo '<tr class="'.$css_sublcass.' percent">';
+ echo '<td>';
+ $val = 0;
+ if ($percent_all > 0) {
+ $val = $data[$seq]['veljavni'] / $percent_all * 100;
+ }
+ echo common::formatNumber($val,0,null,'%') ;
+ echo '</td>';
+ foreach ($this->_missings AS $value => $text) {
+ $val = 0;
+ if ($percent_all > 0 && isset($data[$seq]['values'][$value])) {
+ $val = ($data[$seq]['values'][$value] / $percent_all * 100);
+ }
+ echo '<td>'.common::formatNumber($val,0,null,'%').'</td>';
+ }
+ foreach ($this->_unsets AS $value => $text)
+ {
+ $val = 0;
+ if ($percent_all > 0 && isset($data[$seq]['values'][$value])) {
+ $val = ($data[$seq]['values'][$value] / $percent_all * 100);
+ }
+ echo '<td>'.common::formatNumber($val,0,null,'%').'</td>';
+ }
+ echo '</tr>';
+ }
+ }
+ }
+ }
+ }
+ }
+ echo '</table>';
+ SurveyAnalysisHelper::getInstance()->displayMissingLegend();
+
+ echo '<br class="clr" />';
+
+ }
+
+ function getVariables()
+ {
+ $_currentVariableProfile = SurveyVariablesProfiles :: checkDefaultProfile($dvp);
+ $tmp_svp_pv = SurveyVariablesProfiles :: getProfileVariables($this->_PROFILE_ID_VARIABLE );
+
+ # če je $svp_pv = null potem prikazujemo vse variable
+ # oziroma če je sistemski dodamo tudi vse, ker drugače lahko filter skrije telefon in email
+ if (empty($tmp_svp_pv))
+ {
+ $_sv = $this->SDF->getSurveyVariables();
+ if (count($_sv) > 0)
+ {
+ foreach ( $_sv as $vid => $variable)
+ {
+ $tmp_svp_pv[$vid] = $vid;
+ }
+ }
+ }
+ $svp_pv = array();
+ if (!empty($tmp_svp_pv))
+ {
+ foreach ($tmp_svp_pv AS $_svp_pv)
+ {
+ $svp_pv[$_svp_pv] = $_svp_pv;
+ }
+ }
+ return $svp_pv;
+ }
+
+ public function collectData() {
+ # polovimo 2 skupini podatkov 1. ustrezni (ko niso misisingi) 2. missinge)
+ global $site_path;
+ $folder = $site_path . EXPORT_FOLDER.'/';
+
+ #array za imeni tmp fajlov, ki jih nato izbrišemo
+ $tmp_file = $folder.'tmp_export_'.$this->anketa.'_para_data.php';
+
+ # pobrišemo sfiltrirane podatke, ker jih več ne rabimo
+ if (file_exists($tmp_file)) {
+ unlink($tmp_file);
+ }
+
+ $status_filter = $this->_CURRENT_STATUS_FILTER;
+
+ # s katero sekvenco se začnejo podatki, da ne delamo po nepotrebnem za ostala polja
+ $start_sequence = $this->_HEADERS['_settings']['dataSequence'];
+ # s katero sekvenco se končajo podatki da ne delamo po nepotrebnem za ostala polja
+ $end_sequence = $this->_HEADERS['_settings']['metaSequence']-1;
+
+ # naredimo datoteko z frekvencami
+ # za windows sisteme in za linux sisteme
+ if (IS_WINDOWS ) {
+ # TEST z LINUX načinom
+ # združimo v eno vrstico da bo strežnik bol srečen
+ $command = 'awk -F"|" "BEGIN {{OFS=\"\x7C\"} {ORS=\"\n\"} {FS=\"\x7C\"} {SUBSEP=\"\x7C\"}} '.$status_filter.' {for (i='.$start_sequence.';i<='.$end_sequence.';i++) { arr[i,$i]++}} END {{for (n in arr) { print n,arr[n]}}}" '.$this->dataFileName;
+ $command .= ' | sed "s*\x27*`*g" ';
+ $command .= ' | awk -F"|" "BEGIN {{OFS=\"\"} {ORS=\"\n\"}} { print \"$frequency[\",$1,\"]\",\"[\x27\",$2,\"\x27]\",\"=\",$3,\";\"}" >> '.$tmp_file;
+ } else {
+ # združimo v eno vrstico da bo strežnik bol srečen
+ $command = 'awk -F"|" \'BEGIN {{OFS="|"} {ORS="\n"} {FS="|"} {SUBSEP="|"}} '.$status_filter.' {for (i='.$start_sequence.';i<='.$end_sequence.';i++) { arr[i,$i]++}} END {{for (n in arr) { print n,arr[n]}}}\' '.$this->dataFileName;
+ $command .= ' | sed \'s*\x27*`*g\' ';
+ $command .= ' | awk -F"|" \'BEGIN {{OFS=""} {ORS="\n"}} { print "$frequency[",$1,"]","[\x27",$2,"\x27]","=\x27",$3,"\x27;"}\' >> '.$tmp_file;
+ }
+
+ $file_handler = fopen($tmp_file,"w");
+ fwrite($file_handler,"<?php\n");
+ fclose($file_handler);
+
+ $out = shell_exec($command);
+
+ $file_handler = fopen($tmp_file,"a");
+ fwrite($file_handler,'?>');
+ fclose($file_handler);
+ include($tmp_file);
+
+ # pobrišemo sfiltrirane podatke, ker jih več ne rabimo
+ if (file_exists($tmp_file)) {
+ unlink($tmp_file);
+ }
+
+ # zloopamo po frekvencah in polovimo pravilne
+ $result = array();
+ $hasDelta = false;
+
+ $neodgovor_spremenljivke = array();
+ $this->cols_with_value = array();
+ if (empty($frequency)) {
+ return array('data'=>$result, 'hasDelta'=>$hasDelta);
+ }
+
+ $old_break = 0;
+ //loop skozi header variable da imamo sort po seq vprašanj
+ $headerVariablesId = $this->getVariables();
+ $delta = 0;
+
+ foreach ($headerVariablesId AS $headerVariableId) {
+ $spr = $this->_HEADERS[$headerVariableId];
+ if (empty($spr['grids'])) {
+ continue;
+ }
+ $grids = $spr['grids'];
+ foreach ($grids AS $gid => $grid) {
+ $variables = $grid['variables'];
+ if (empty($variables)) {
+ continue;
+ }
+ foreach ($variables AS $vid => $variable) {
+ $seq = $variable['sequence'];
+ if (!isset($frequency[$seq]) || empty($frequency[$seq])) {
+ continue;
+ }
+ // loop skozi odgovore spremenljivke
+ $freqData = $frequency[$seq];
+
+ $vseEnote = 0;
+ $veljavni = 0;
+ $prikazani = 0;
+ $nevsebinski = 0;
+ $neodgovori = 0;
+ $ustrezni = 0;
+ $neustrezni = 0;
+ $neodgovorSpremenljivke = 0;
+ $stopnjaPrekinitve = 0;
+ $stopnjaPrekinitveNeto = 0;
+ $stopnjaPrekinitveBruto = 0;
+ $delta = 0;
+ $values = array();
+ foreach ($freqData AS $key => $cnt) {
+
+ $vseEnote += $cnt;
+ if (is_numeric($key) && (isset($this->_missings[(int)$key]) || isset($this->_unsets[(int)$key]))) {
+ // shranimo vrednosti -1 ... -99 za prikaz v tabeli podrobno
+ $values[(int)$key] += $cnt;
+
+ $this->cols_with_value[(int)$key] += $cnt;
+ if (isset($this->_unsets[$key])) {
+
+ $nevsebinski += $cnt;
+ } elseif (isset($this->_missings[(int)$key])) {
+
+ $neodgovori += $cnt;
+ # -1 je bil prikazan pa ni bil odgovorjen
+ if ($key == -1) {
+ $prikazani += $cnt;
+ }
+ if ($key == -3) {
+ $hasDelta = true;
+ $delta = (int)$cnt - (int)$old_break;
+ $old_break = $cnt;
+ }
+ if ($key == -5) {
+ $neustrezni += $cnt;
+ }
+ }
+
+ } else {
+
+ $this->cols_with_value['valid'] += $cnt;
+ $veljavni += $cnt;
+ }
+ }
+
+ $prikazani += $nevsebinski + $veljavni;
+
+ #neodgovorSpremenljivke so: -1 / PRIKAZANO (veljavne + (-1) -99.....-90)
+ $ns = 0;
+ if (isset($values[-1]) && $values[-1] > 0) {
+ $ns = $values[-1] / ($prikazani); // -1 je v prikazanih
+ }
+ # prekinitve
+ $ustrezni = $vseEnote;
+ if (isset($values[-5])) {
+ $ustrezni = $ustrezni - $values[-5];
+ }
+
+ $prekinitve = 0;
+ if (isset($values[-3])) {
+ $prekinitve = $values[-3];
+ }
+
+ #prekinitve so: -3 /(-3) + PRIKAZANO (veljavne + (-1) -99.....-90)
+ $sp = 0;
+ if (($prikazani + $prekinitve) > 0) {
+ $sp = $prekinitve / ($prikazani + $prekinitve);
+ }
+
+ #neto so DELTA/(-3+PRIKAZANO)
+ $neto_sp = 0;
+ if (($prikazani + $prekinitve) > 0) {
+ $neto_sp = $delta / ($prikazani + $prekinitve);
+ }
+
+ #bruto pa so (-3)/vse ustrezne enote (torej -3, -2, -1, -4, veljavni, -90...) vse razen empty
+ $bruto_sp = 0;
+ if ($ustrezni > 0) {
+ $bruto_sp = $prekinitve / $ustrezni;
+ }
+
+ $_variable = $variable['variable'];
+ $_naslov = $variable['naslov'];
+ if (count($variables) > 1 && in_array($tip, array(2,18,17))) {
+ $_variable = $spr['variable'];
+ $_naslov = $spr['naslov'];
+ }
+ if ($tip == 16 ) {
+ $_variable = $grid['variable'];
+ $_naslov = $grid['naslov'];
+ }
+
+ $result[$seq]['spid'] = $headerVariableId;
+ $result[$seq]['sid'] = $spr['spr_id'];
+ $result[$seq]['variable'] = $_variable;
+ $result[$seq]['naslov'] = $_naslov;
+
+ $result[$seq]['vse_enote'] = $vseEnote;
+ $result[$seq]['veljavni'] = $veljavni;
+ $result[$seq]['prikazani'] = $prikazani;
+ $result[$seq]['ustrezni'] = $ustrezni;
+ #$result[$seq]['nevsebinski'] = $nevsebinski;
+ #$result[$seq]['neodgovori'] = $neodgovori;
+ $result[$seq]['delta'] = $delta;
+ $result[$seq]['values'] = $values;
+
+ $result[$seq]['ns'] = $ns ;
+ $result[$seq]['sp'] = $sp ;
+ $result[$seq]['sp_neto'] = $neto_sp ;
+ $result[$seq]['sp_bruto'] = $bruto_sp ;
+
+ }
+ }
+ }
+
+ return array($result, $hasDelta);
+ }
+
+ function ajax()
+ {
+ $action = $_GET['a'];
+ switch ($action)
+ {
+ case 'setCbx' :
+ $this->setCbx();
+ break;
+ case 'setValue' :
+ $this->setValue();
+ break;
+ }
+ }
+ function setCbx() {
+ $value = $_REQUEST['value'];
+ if ($value == 'false') {
+ $value = false;
+ }
+ if ($value == 'true') {
+ $value = true;
+ }
+
+ $what = $_POST['what'];
+
+ $this->sessionData['para_analysis'][$what] = $value;
+ // Shranimo spremenjene nastavitve v bazo
+ SurveyUserSession::saveData($this->sessionData);
+
+ }
+ function setValue() {
+ $value = $_REQUEST['value'];
+ $what = $_POST['what'];
+ $this->sessionData['para_analysis'][$what] = $value;
+ // Shranimo spremenjene nastavitve v bazo
+ SurveyUserSession::saveData($this->sessionData);
+ }
+
+ function displayLink() {
+# global $lang;
+# echo '<a href="index.php?anketa=' . $this->anketa .'&a=analysis&m=para">' . $lang['srv_napredno'] . '</a>';
+ }
+ function displayFormula() {
+ return false;
+ global $lang;
+ echo '<table><tr><td rowspan="2">' . $lang['srv_para_unaswered'] . ' (' . $lang['srv_para_unaswered_short'] . ')' . ' = </td><td class="anl_bb anl_ac">(-1)</td></tr><tr><td class="anl_ac">(' . $lang['srv_para_valid'] . ') + (-1) + (-97) + (-98) + (-99)</td></tr><table>';
+ }
+}
\ No newline at end of file |