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