<?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){
global $global_user_id;
if ((int)$anketa > 0){
$this->anketa = $anketa;
SurveyAnalysisHelper::getInstance()->Init($this->anketa);
# polovimo vrsto tabel (aktivne / neaktivne)
SurveyInfo :: getInstance()->SurveyInit($this->anketa);
$this->db_table = SurveyInfo::getInstance()->getSurveyArchiveDBString();
$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 class="wrap1360 page_'.$_GET['a'].' subpage_'.$_GET['m'].'">';
//Spremenljivke
echo '<div class="section" id="one">';
echo '<div class="setting_holder">';
echo '<span class="setting_title">'.$lang['srv_para_label_variables'].'</span>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_question_basic" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_basic == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_question_basic">'.$lang['srv_para_show_question_basic'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_graph_basic" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_basic == true ? ' checked="checked"' : '').' autocomplete="off" >';
echo '<label for="show_graph_basic">'.$lang['srv_para_show_show_graph_basic'].'</label>';
echo '</div>';
echo '</div>';
echo '</div>';
//Prekinitve
echo '<div class="section" id="two">';
echo '<div class="setting_holder">';
echo '<span class="setting_title">'.$lang['srv_para_label_breaks'].'</span>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_question_breaks" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_breaks == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_question_breaks">'.$lang['srv_para_show_question_breaks'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_graph_breaks" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_breaks == true ? ' checked="checked"' : '').' autocomplete="off" >';
echo '<label for="show_graph_breaks">'.$lang['srv_para_show_show_graph_breaks'].'</label>';
echo '</div>';
echo '</div>';
/*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>';
// Podrobno
echo '<div class="section" id="three">';
echo '<span class="setting_title">'.$lang['srv_para_label_details'].'</span>';
echo '<div class="subsection">';
echo '<div class="setting_holder">';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_with_zero" onclick="changeParaAnalysisCbx(this,true);" '.($this->show_with_zero == false ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_with_zero">'.$lang['srv_para_only_valid'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_with_other" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_with_other == true ? ' checked="checked"' : '').' autocomplete="off" >';
echo '<label for="show_with_other">'.$lang['srv_para_show_rows_other'].'</label>';
echo '</div>';
echo '</div>';
echo '<div class="setting_holder">';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_categories" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_categories == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_categories">'.$lang['srv_analiza_kategorialneSpremenljivke'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_numbers" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_numbers == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_numbers">'.$lang['srv_analiza_numericneSpremenljivke'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_text" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_text == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_text">'.$lang['srv_analiza_textovneSpremenljivke'].'</label>';
echo '</div>';
echo '</div>';
echo '<div class="setting_holder">';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_question_advanced" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_question_advanced == true ? ' checked="checked"' : '').' autocomplete="off">';
echo '<label for="show_question_advanced">'.$lang['srv_para_show_question_advanced'].'</label>';
echo '</div>';
echo '<div class="setting_item">';
echo '<input type="checkbox" id="show_graph_advanced" onclick="changeParaAnalysisCbx(this,false);" '.($this->show_graph_advanced == true ? ' checked="checked"' : '').' autocomplete="off" >';
echo '<label for="show_graph_advanced">'.$lang['srv_para_show_show_graph_advanced'].'</label>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>'; // konec diva zapiranje nastavitev
if ($showSettings) {
echo '<script type="text/javascript">
toggle_drop_settings_margin();
</script>';
}
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 '<h2>'.$lang['srv_para_label_breaks'].'</h2>';
echo '<table id="tbl_para_analitics" class="graph'.($showGraph ? ' showGraph' : '').'">';
echo '<tr>';
echo '<th>' . $lang['srv_para_variable'] . '</th>';
if ($showQuestion) {
echo '<th>'.$lang['srv_para_question'].'</th>';
}
echo '<th title="'.$lang['srv_para_breaks'].'">'.$lang['srv_para_breaks_short'].'</th>';
if ($show_delta) {
echo '<th title="'.$lang['srv_para_breaks_delta'].'">'.$lang['srv_para_breaks_delta_short'].'</th>';
}
echo '<th title="'.$lang['srv_para_breaks_value'].'">' . $lang['srv_para_breaks_value_short'] . '</th>';
echo '<th title="'.$lang['srv_para_breaks_value_bruto'].'">' . $lang['srv_para_breaks_value_bruto_short'] . '</th>';
echo '<th title="'.$lang['srv_para_breaks_value_neto'].'">' . $lang['srv_para_breaks_value_neto_short'] . '</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 '</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 '</tr>';
}
}
echo '<tr>';
echo '<td><a onclick="showspremenljivkaSingleVarPopup(\'' . $row['spid'] . '\'); return false;" href="#">' . $row['variable'] . '</a></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>';
if ($showGraph) {
$width = $row['sp'];
if ((int)$showGraphType == 1) {
$width = $row['sp_bruto'];
} elseif ((int)$showGraphType == 2) {
$width = $row['sp_neto'];
}
echo '<td class="graph_cell">';
if ($row['sp'] > 0) {
echo '<div class="graph_full" style="'.'width:'.($width*100).'%;"></div>';
} else {
echo '/';
}
echo '</td>';
}
echo '</tr>';
}
echo '</table>';
#SurveyAnalysisHelper::getInstance()->displayMissingLegend();
$this->displayLink();
}
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;
}
}
}
}
*/
/*SORTIRANJE
$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 '<h2>'.$lang['srv_para_label_variables'].'</h2>';
echo '<table id="tbl_para_analitics" class="graph'.($showGraph ? ' showGraph' : '').'">';
echo '<tr>';
echo '<th>' . $lang['srv_para_variable'] . '</th>';
if ($showQuestion) {
echo '<th>'.$lang['srv_para_question'].'</th>';
}
if ($show_delta) {
echo '<th title="'.$lang[''].'">delta</th>';
}
echo '<th>' . $lang['srv_para_unaswered_short'] . ' %</th>';
if ($showGraph) {
echo '<th title="' . $lang['srv_para_unaswered_graph_title'] . '">' . $lang['srv_para_unaswered_graph_title'] . '</th>';
}
echo '</tr>';
foreach ($rows AS $row) {
echo '<tr>';
echo '<td>';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $row['spid'] . '\'); return false;" href="#">' . $row['variable'] . '</a>';
echo '</td>';
if ($showQuestion) {
echo '<td>';
echo (strlen($row['naslov']) > 80 ? substr($row['naslov'],0,80)."..." : $row['naslov']);
echo '</td>';
}
if ($show_delta) {
echo '<td>'.$row['delta'].'</td>';
}
echo '<td>'.common::formatNumber($row['ns']*100,1).'</td>';
if ($showGraph) {
echo '<td class="graph_cell">';
if ($row['ns'] > 0) {
echo '<div class="graph_full" style="'.'width:'.($row['ns']*100).'%;"></div>';
} else {
echo '/';
}
echo '</td>';
}
echo '</tr>';
}
echo '</table>';
#SurveyAnalysisHelper::getInstance()->displayMissingLegend();
$this->displayLink();
}
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 '<div id="scroll1">';
echo '<div id="scroll2">';
echo '<script>
check_para_wrap();
</script>';
echo '<table id="tbl_para_analitics" class="podrobno">';
echo '<tr>';
// Dodatna stolpca zaradi izvoza za Katjo Lozar
if($admin_type == '0'){
echo '<th class="center">ID VPRAŠANJA</th>';
echo '<th class="center">ID VARIABLE</th>';
}
echo '<th class="left">'.$lang['srv_para_variable'].'</th>';
if ($showQuestion) {
echo '<th class="left">'.$lang['srv_para_question'].'</th>';
}
//echo '<th >'.$lang['srv_para_valid'].'</th>';
foreach ($this->_missings AS $value => $text) {
$cnt_miss++;
echo "<th class=\"left\" title=\"".$lang['srv_mv_'.$text]."\" >{$value}<br>(".$lang['srv_mv_'.$text].")</th>";
}
foreach ($this->_unsets AS $value => $text)
{
$cnt_undefined++;
echo "<th class=\"left\" title=\"".$lang['srv_mv_'.$text]."\">{$value} (".$lang['srv_mv_'.$text].")</th>";
}
if ($show_delta) {
echo "<th title=\"".$lang['']."delta\">".$lang['']."Δ</th>";
}
echo "<th title=\"".$lang['srv_para_nonconceptual']."\">".$lang['srv_para_nonconceptual']."</th>";
echo "<th title=\"".$lang['srv_para_approp']."\">".$lang['srv_para_approp']."</th>";
echo "<th title=\"".$lang['srv_para_all_units']."\">".$lang['srv_para_all_units']."</th>";
if ($isNotStandardProfile)
{
echo "<th title=\"".$lang['srv_para_status']."\">".$lang['srv_para_status']."</th>";
}
echo "<th title=\"".$lang['srv_para_unaswered']."\">".$lang['srv_para_unaswered_short']. Help :: display('srv_item_nonresponse')."</th>";
if ($showGraph) {
echo '<th class="left">' . $lang['srv_para_unaswered_graph_title_br'] . '</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 class="center">'.$spr['spr_id'].'</td>';
echo '<td class="center"></td>';
}
$count_missing = count($this->_missings);
if ($showQuestion) {
echo '<td class="left semi-bold">';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
echo '</td>';
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan).'">';
echo $spr['naslov'];
echo '</td>';
} else {
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan).'">';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
echo '</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 class="center">'.$spr['spr_id'].'</td>';
echo '<td class="center"></td>';
}
if ($showQuestion) {
echo '<td class="left semi-bold">';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
echo '</td>';
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan+4).'">';
echo $spr['naslov'];
echo '</td>';
} else {
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan+3).'">';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
echo '</td>';
}
echo '</tr>';
}
else
{ #dodamo header za grupo
echo '<tr class="multiVariablesHeader">';
if($admin_type == '0'){
echo '<td class="center">'.$spr['spr_id'].'</td>';
echo '<td class="center"></td>';
}
if ($showQuestion) {
echo '<td class="left semi-bold">';
if (count($grids) > 1) {
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $grid['variable'] . '</a>';
} else {
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
}
echo '</td>';
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan+4).'">';
echo (strlen($grid['naslov']) > 30 ? substr($grid['naslov'],0,30)."..." : $grid['naslov']);
echo '</td>';
} else {
echo '<td class="left semi-bold" colspan="'.($count_missing+count($this->_unsets)+$added_colspan+3).'">';
if (count($grids) > 1) {
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $grid['variable'] . '</a>';
} else {
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $spr['variable'] . '</a>';
}
echo '</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>';
if($admin_type == '0'){
echo '<td class="center" rowspan="'.($showPercent*2).'">'.$spr['spr_id'].'</td>';
echo '<td class="center" rowspan="'.($showPercent*2).'">'.$variable['vr_id'].'</td>';
}
//echo '<td style="border-top:0px none !important;border-bottom:0px none !important;"> </td>';
echo '<td class="left" rowspan="'.($showPercent*2).'">';
echo '<a onclick="showspremenljivkaSingleVarPopup(\'' . $key . '\'); return false;" href="#">' . $variable['variable'] . '</a>';
echo '</td>';
if ($showQuestion) {
echo '<td class="left" rowspan="'.($showPercent*2).'">';
echo (strlen($variable['naslov']) > 30 ? substr($variable['naslov'],0,30)."..." : $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=\"graph_cell left\">";
if ($data_seq['ns'] > 0) {
echo '<div class="graph_full" style="'.'width:'.($data_seq['ns']*100).'%;"></div>';
} else {
echo '/';
}
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 class="dashed">'.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 class="dashed">'.common::formatNumber($val,0,null,'%').'</td>';
}
echo '</tr>';
}
}
}
}
}
}
echo '</table>';
echo '</div>';
echo '</div>';
SurveyAnalysisHelper::getInstance()->displayMissingLegend();
}
function getVariables() {
$dvp = SurveyUserSetting :: getInstance()->getSettings('default_variable_profile');
$_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
if(isset($values[(int)$key]))
$values[(int)$key] += $cnt;
else
$values[(int)$key] = $cnt;
if(isset($this->cols_with_value[(int)$key]))
$this->cols_with_value[(int)$key] += $cnt;
else
$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 {
if(isset($this->cols_with_value['valid']))
$this->cols_with_value['valid'] += $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'];
$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>';
}
}