diff options
Diffstat (limited to 'admin/survey/modules/mod_advanced_timestamps/class.SurveyAdvancedTimestamps.php')
| -rw-r--r-- | admin/survey/modules/mod_advanced_timestamps/class.SurveyAdvancedTimestamps.php | 238 |
1 files changed, 238 insertions, 0 deletions
diff --git a/admin/survey/modules/mod_advanced_timestamps/class.SurveyAdvancedTimestamps.php b/admin/survey/modules/mod_advanced_timestamps/class.SurveyAdvancedTimestamps.php new file mode 100644 index 0000000..a6cc56c --- /dev/null +++ b/admin/survey/modules/mod_advanced_timestamps/class.SurveyAdvancedTimestamps.php @@ -0,0 +1,238 @@ +<?php
+
+/*
+ * Modul za pregledovanje in urejanje nastavitev naprednih časov po straneh
+ *
+ */
+
+
+use PhpOffice\PhpSpreadsheet\Spreadsheet;
+use PhpOffice\PhpSpreadsheet\IOFactory;
+use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
+
+
+class SurveyAdvancedTimestamps {
+
+ var $anketa; # id ankete
+
+
+ function __construct($anketa){
+
+ // Ce imamo anketo
+ if ((int)$anketa > 0){
+ $this->anketa = $anketa;
+ }
+ }
+
+
+ public function displaySettings(){
+ global $lang;
+
+
+ echo '<fieldset><legend>'.$lang['srv_results'].'</legend>';
+
+ $href_csv = 'izvoz.php?m=advanced_timestamps_xls&anketa='.$this->anketa;
+ echo ' <span><a href="'.$href_csv.'">Excel izvoz parapodatkov</a></span>';
+
+ echo '</fieldset>';
+ }
+
+ // Izvozimo tabelo s parapodatki v xls
+ public function exportTable(){
+ global $site_path;
+
+ ini_set('memory_limit', '4048M');
+
+
+ // Pridobimo podatke za vse tabele
+ $timestamp_data = $this->getTimestampData();
+ $page_data = $this->getPageData();
+ $question_data = $this->getQuestionData();
+ $variable_data = $this->getVariableData();
+
+
+ $spreadsheet = new Spreadsheet();
+
+
+ // Zavihek strani
+ $sheet = $spreadsheet->getActiveSheet();
+
+ $sheet->setTitle("Strani");
+ $sheet->fromArray(
+ $page_data, // The data to set
+ NULL, // Array values with this value will not be set
+ 'A1' // Top left coordinate of the worksheet range where
+ );
+
+ $spreadsheet->createSheet();
+
+
+ // Zavihek vprasanja
+ $sheet = $spreadsheet->getSheet(1);
+
+ $sheet->setTitle("Vprašanja");
+ $sheet->fromArray(
+ $question_data, // The data to set
+ NULL, // Array values with this value will not be set
+ 'A1' // Top left coordinate of the worksheet range where
+ );
+
+ $spreadsheet->createSheet();
+
+
+ // Zavihek itemi
+ $sheet = $spreadsheet->getSheet(2);
+
+ $sheet->setTitle("Itemi");
+ $sheet->fromArray(
+ $variable_data, // The data to set
+ NULL, // Array values with this value will not be set
+ 'A1' // Top left coordinate of the worksheet range where
+ );
+
+ $spreadsheet->createSheet();
+
+
+ // Zavihek casi po straneh
+ $sheet = $spreadsheet->getSheet(3);
+
+ $sheet->setTitle("Časi po straneh");
+ $sheet->fromArray(
+ $timestamp_data, // The data to set
+ NULL, // Array values with this value will not be set
+ 'A1' // Top left coordinate of the worksheet range where
+ );
+
+
+ $writer = new Xlsx($spreadsheet);
+
+ // ob_clean();
+ // ob_start();
+ $filename = 'advanced_timestamps_'.$this->anketa.'.xlsx';
+
+ header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ header("Content-Disposition: attachment;filename=".$filename);
+ header("Cache-Control: max-age=0");
+ header("Last-Modified: ".date("D, d M Y H:i:s"));
+ header("Cache-Control: cache, must-revalidate");
+ header("Pragma: public");
+
+ $writer->save("php://output");
+ // ob_end_flush();
+
+ die();
+ }
+
+
+
+ // Pridobimo parapodatke casov po straneh
+ private function getTimestampData(){
+
+ $data = array(0 => array('Stran ID', 'Respondent ID', 'Čas'));
+
+ // Najprej dobimo case na uvodih (gru_id=0)
+ $sql = sisplet_query("SELECT at.gru_id, at.usr_id, at.time_edit
+ FROM srv_advanced_timestamps at, srv_user u
+ WHERE u.ank_id='".$this->anketa."' AND at.usr_id=u.id AND gru_id<1
+ ORDER BY at.usr_id ASC, at.id ASC
+ ");
+ while($row = mysqli_fetch_assoc($sql)){
+ $data[] = $row;
+ }
+
+ // Dobimo se ostale case
+ $sql = sisplet_query("SELECT at.gru_id, at.usr_id, at.time_edit
+ FROM srv_advanced_timestamps at, srv_grupa g
+ WHERE g.ank_id='".$this->anketa."' AND at.gru_id=g.id
+ ORDER BY at.usr_id ASC, at.id ASC
+ ");
+ while($row = mysqli_fetch_assoc($sql)){
+ $data[] = $row;
+ }
+
+ return $data;
+ }
+
+ // Pridobimo podatke strani v anketi
+ private function getPageData(){
+
+ $data = array(0 => array('Stran ID', 'Naslov', 'Vrstni red'));
+
+ $sql = sisplet_query("SELECT id, naslov, vrstni_red
+ FROM srv_grupa
+ WHERE ank_id='".$this->anketa."'
+ ORDER BY vrstni_red ASC
+ ");
+ while($row = mysqli_fetch_assoc($sql)){
+ $data[] = $row;
+ }
+
+ return $data;
+ }
+
+ // Pridobimo podatke vprasanj v anketi
+ private function getQuestionData(){
+
+ $question_types = array(
+ '1' => 'radio',
+ '2' => 'checkbox',
+ '3' => 'select',
+ '4' => 'text',
+ '21' => 'besedilo*',
+ '5' => 'label',
+ '6' => 'multigrid',
+ '16' => 'multicheckbox',
+ '19' => 'multitext',
+ '20' => 'multinumber',
+ '7' => 'number',
+ '22' => 'compute ',
+ '25' => 'quota',
+ '8' => 'datum ',
+ '17' => 'ranking ',
+ '18' => 'vsota',
+ '24' => 'grid - multiple',
+ '23' => 'iz knjiznice',
+ '9' => 'SN-imena',
+ '26' => 'Lokacija',
+ '27' => 'HeatMap ',
+ );
+
+ $data = array(0 => array('Vprašanje ID', 'Stran ID', 'Naslov', 'Variabla', 'Tip'));
+
+ $sql = sisplet_query("SELECT s.id, s.gru_id, s.naslov, s.variable, s.tip
+ FROM srv_spremenljivka s, srv_grupa g
+ WHERE g.ank_id='".$this->anketa."' AND s.gru_id=g.id
+ ORDER BY g.vrstni_red ASC, s.id ASC
+ ");
+ while($row = mysqli_fetch_assoc($sql)){
+
+ $row['tip'] = $question_types[$row['tip']];
+ $row['naslov'] = strip_tags($row['naslov']);
+
+ $data[] = $row;
+ }
+
+ return $data;
+ }
+
+ // Pridobimo podatke posameznih itemov v vprasanjih
+ private function getVariableData(){
+
+ $data = array(0 => array('Vrednost ID', 'Vprašanje ID, ', 'Naslov', 'Variabla', 'Vrstni red'));
+
+ $sql = sisplet_query("SELECT v.id, v.spr_id, v.naslov, v.variable, v.vrstni_red
+ FROM srv_vrednost v, srv_spremenljivka s, srv_grupa g
+ WHERE g.ank_id='".$this->anketa."' AND s.gru_id=g.id AND v.spr_id=s.id
+ ORDER BY g.vrstni_red ASC, s.id ASC, v.id ASC
+ ");
+ while($row = mysqli_fetch_assoc($sql)){
+
+ $row['naslov'] = strip_tags($row['naslov']);
+
+ $data[] = $row;
+ }
+
+ return $data;
+ }
+
+}
\ No newline at end of file |