false); // za shrambo parametrov in sporocil private $headFileName = null; # pot do header fajla private $dataFileName = null; # pot do data fajla private $dataFileStatus = null; # status data datoteke /** * @desc konstruktor */ function __construct ($anketa = null, $sprID = null){ global $site_path; global $global_user_id; global $output; // preverimo ali imamo stevilko ankete if ( is_numeric($anketa) ){ $this->anketa['id'] = $anketa; $this->spremenljivka = $sprID; SurveyAnalysis::Init($this->anketa['id']); SurveyAnalysis::$setUpJSAnaliza = false; // create new XLS document $this->xls = new xls(); // Poskrbimo za datoteko s podatki $SDF = SurveyDataFile::get_instance(); $SDF->init($this->anketa['id']); $SDF->prepareFiles(); $this->headFileName = $SDF->getHeaderFileName(); $this->dataFileName = $SDF->getDataFileName(); $this->dataFileStatus = $SDF->getStatus(); // Nastavimo da izpisujemo samo prvih 5 spremenljivk $_GET['spr_limit'] = 'all'; // Nastavimo da nikoli ne izpisemo vabila $_GET['email'] = 0; SurveyDataDisplay::Init($this->anketa['id']); } else{ $this->pi['msg'] = "Anketa ni izbrana!"; $this->pi['canCreate'] = false; return false; } if ( SurveyInfo::getInstance()->SurveyInit($this->anketa['id']) && $this->init()){ $this->anketa['uid'] = $global_user_id; SurveyUserSetting::getInstance()->Init($this->anketa['id'], $this->anketa['uid']); } else return false; // ce smo prisli do tu je vse ok $this->pi['canCreate'] = true; return true; } function getAnketa() { return $this->anketa['id']; } function checkCreate() { return $this->pi['canCreate']; } function getFile($fileName) { //Close and output rtf document // $this->rtf->Output($fileName, 'I'); $output = $this->createXls(); $this->xls->display($fileName, $output); } function init() { return true; } function createXls(){ global $site_path; global $lang; global $output; $convertTypes = array('charSet' => "windows-1250", 'delimit' => ";", 'newLine' => "\n", 'BOMchar' => "\xEF\xBB\xBF"); $output = $convertTypes['BOMchar']; $output .= '
'.$lang['export_list'].'
'; $this->displayTable(); return $output; } function displayTable(){ global $site_path; global $lang; global $output; $folder = $site_path . EXPORT_FOLDER.'/'; //polovimo podatke o nastavitvah trenutnega profila (missingi..) SurveyAnalysis::$missingProfileData = SurveyMissingProfiles::getProfile(SurveyAnalysis::$currentMissingProfile); #preberemo HEADERS iz datoteke SurveyAnalysis::$_HEADERS = unserialize(file_get_contents($this->headFileName)); #odstranimo sistemske variable SurveyAnalysis::removeSystemVariables(); SurveyDataDisplay::$_VARS[VAR_DATA] = 1; SurveyDataDisplay::$_VARS[VAR_SPR_LIMIT] = 5; SurveyDataDisplay::$_VARS[VAR_META] = 0; SurveyDataDisplay::$_VARS[VAR_EMAIL] = 0; SurveyDataDisplay::$_VARS[VAR_RELEVANCE] = 0; SurveyDataDisplay::$_VARS[VAR_STATUS] = 0; SurveyDataDisplay::$_VARS[VAR_EDIT] = 0; SurveyDataDisplay::$_VARS[VAR_PRINT] = 0; SurveyDataDisplay::$_VARS[VAR_MONITORING] = 0; if(SurveyDataDisplay::$_VARS['view_date']) SurveyDataDisplay::$_VARS[VAR_SPR_LIMIT]++; # ponastavimo nastavitve- filter SurveyDataDisplay::setUpFilter(); $vars_count = count(SurveyAnalysis::$_FILTRED_VARIABLES); $output .= ''; $output .= ''; $output .= ''; // Vrstica z naslovi spremenljivk if(SurveyDataDisplay::$_VARS['view_date']){ $output .= ''; } $spr_cont = 0; foreach (SurveyAnalysis::$_HEADERS AS $spid => $spremenljivka) { # preverjamo ali je meta if ($spremenljivka['tip'] != 'm' && in_array($spremenljivka['tip'], SurveyAnalysis::$_FILTRED_TYPES)){ # ali imamo sfiltrirano spremenljivko if ($vars_count == 0 || ($vars_count > 0 && isset(SurveyAnalysis::$_FILTRED_VARIABLES[$spid]))) { // prikazemo samo prvih 5 spremenljivk if ($spr_cont < 5) { $output .= ''; } $spr_cont++; } } } $output .= ''; // Vrstica imeni variabel if(SurveyDataDisplay::$_VARS['view_date']){ $output .= ''; } $spr_cont = 0; foreach (SurveyAnalysis::$_HEADERS AS $spid => $spremenljivka) { # preverjamo ali je meta if ($spremenljivka['tip'] != 'm' && in_array($spremenljivka['tip'], SurveyAnalysis::$_FILTRED_TYPES)){ # ali imamo sfiltrirano spremenljivko if ($vars_count == 0 || ($vars_count > 0 && isset(SurveyAnalysis::$_FILTRED_VARIABLES[$spid])) && count($spremenljivka['grids']) > 0) { // prikazemo samo prvih 5 spremenljivk if ($spr_cont < 5) { foreach ($spremenljivka['grids'] AS $gid => $grid) { $output .= ''; } } $spr_cont++; } } } $output .= ''; if(SurveyDataDisplay::$_VARS['view_date']){ $output .= ''; } $spr_cont = 0; foreach (SurveyAnalysis::$_HEADERS AS $spid => $spremenljivka) { # preverjamo ali je meta if ($spremenljivka['tip'] != 'm' && in_array($spremenljivka['tip'], SurveyAnalysis::$_FILTRED_TYPES)){ # ali imamo sfiltrirano spremenljivko if ($vars_count == 0 || ($vars_count > 0 && isset(SurveyAnalysis::$_FILTRED_VARIABLES[$spid])) && count($spremenljivka['grids']) > 0) { // prikazemo samo prvih 5 spremenljivk if($spr_cont < 5) { foreach ($spremenljivka['grids'] AS $gid => $grid) { if (count ($grid['variables']) > 0) { foreach ($grid['variables'] AS $vid => $variable ){ $output .= ''; } } } } $spr_cont++; } } } $output .=''; $output .= ''; // Nastavimo stevilo izpisov - prikazemo vse $_REC_LIMIT = ''; //$_REC_LIMIT = ' NR==1,NR==50'; $_command = ''; #preberemo podatke // polovimo vrstice z statusom 5,6 in jih damo v začasno datoteko if (IS_WINDOWS) { $_command = 'gawk -F"'.STR_DLMT.'" "BEGIN {OFS=\"\x7C\"} '.SurveyDataDisplay::$_CURRENT_STATUS_FILTER.' { print $0 }" '.$this->dataFileName; } else { $_command = 'awk -F"'.STR_DLMT.'" \'BEGIN {OFS="\x7C"} '.SurveyDataDisplay::$_CURRENT_STATUS_FILTER.' { print $0 }\' '.$this->dataFileName; } // paginacija po stolpcih (spremenljivkah) if (IS_WINDOWS) { $_command .= ' | cut -d "|" -f 1,'.SurveyDataDisplay::$_VARIABLE_FILTER; } else { $_command .= ' | cut -d \'|\' -f 1,'.SurveyDataDisplay::$_VARIABLE_FILTER; } if ($_REC_LIMIT != '') { #paginating if (IS_WINDOWS) { $_command .= ' | awk '.$_REC_LIMIT; } else { $_command .= ' | awk '.$_REC_LIMIT; } } else { #$file_sufix = 'filtred_spr_pagination'; } // zamenjamo | z '; if (file_exists($folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT)) { $f = fopen ($folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT, 'r'); while ($line = fgets ($f)) { $output .= ''; $dataArray = array(); $dataArray = explode('|', $line); // Ne upostevamo prve vrednosti (ID) array_shift($dataArray); foreach($dataArray as $key => $val){ $output .= ''; } $output .= ''; } } else { $output .= 'File does not exist (err.No.1)! :'.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT; } $output .= ''; if ($f) { fclose($f); } if (file_exists($folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT)) { unlink($folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT); } $output .= '
'; $output .= $lang['srv_data_date']; $output .= ''; $output .= $spremenljivka['naslov']; $output .= '
'; $output .= $lang['srv_data_date']; $output .= ''; $output .= $grid['naslov']; $output .= '
'; $output .= $lang['srv_data_date']; $output .= ''; $output .= $variable['naslov']; if ($variable['other'] == 1) $output .= ' (text)'; $output .= '
- NI POTREBNO if (IS_WINDOWS) { //$_command .= ' | sed "s*'.STR_DLMT.'*'.STR_LESS_THEN.'/td'.STR_GREATER_THEN.STR_LESS_THEN.'td'.STR_GREATER_THEN.'*g" >> '.$folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT; $_command .= ' >> '.$folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT; } else { //$_command .= ' | sed \'s*'.STR_DLMT.'**g\' >> ' //.$folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT; $_command .= ' >> '.$folder.'tmp_export_'.$this->anketa['id'].'_data'.TMP_EXT; } if (IS_WINDOWS) { # ker so na WINsih težave z sortom, ga damo v bat fajl in izvedemo :D $file_handler = fopen($folder.'cmd_'.$this->anketa['id'].'_to_run.bat',"w"); fwrite($file_handler,$_command); fclose($file_handler); $out_command = shell_exec($folder.'cmd_'.$this->anketa['id'].'_to_run.bat'); unlink($folder.'cmd_'.$this->anketa['id'].'_to_run.bat'); } else { $out_command = shell_exec($_command); } $output .= '
'.$val.'
'; } function encodeText($text) { // popravimo sumnike ce je potrebno $stringIn = array("č","š","đ","ć","ž","Č","Š","Đ","Ć","Ž"," "); $stringOut = array("č","š","đ","ć","ž","Č","Š","Đ","Ć","Ž"," "); //$text = html_entity_decode($text, ENT_NOQUOTES, 'UTF-8'); $text = str_replace($stringIn, $stringOut, $text); return $text; } function enkaEncode($text) { // popravimo sumnike ce je potrebno $text = html_entity_decode($text, ENT_NOQUOTES, 'UTF-8'); return strip_tags($text); } function formatNumber ($value, $digit = 0, $sufix = "") { if ($value <> 0 && $value != null) $result = round($value, $digit); else $result = "0"; //$result = number_format($result, $digit, '.', ',') . $sufix; $result = number_format($result, $digit, ',', '') . $sufix; return $result; } } ?>