export.php

<?php
include("inc/config.inc.php");
#Übergabe der Verbindungsdaten
$dbconn = pg_connect("host=". $conf["db"]["host"] .
					" port=". $conf["db"]["port"] . 
					" dbname=". $conf["db"]["db"] .
					" user=". $conf["db"]["user"] .
					" password=". $conf["db"]["pass"]);
if(!$dbconn) { die('<p>Die Datenbankverbindung konnte nicht hergestellt werden, bitte versuchen Sie es später noch einmal.</p>'); }

$abfrage = "SELECT cosmid FROM eggs";
$eggs = pg_query($dbconn, $abfrage);

$i = 0;
$res = array();

while ($helper = pg_fetch_assoc($eggs)){
	$res[$i] = $helper;
	$i++;
}

Foreach ($res as $k => $V) {
	$res2 [$k] = $V ['cosmid'];
}

//test if Egg was chosen
if (empty($_POST["CosmID"])){
	print "Bitte w&aumlhlen Sie ein Ei aus, von dem Sie Daten exportieren m&oumlchten.";
	print '</br>Zur&uumlck zum <a href="/eggtracker?action=export_form">Exportformular</a>.';
	die();}

//test if measuring parameter was chosen
if(empty($_POST["Parameter"])){
	print "Bitte w&aumlhlen Sie einen Messparameter aus.";
	print '</br>Zur&uumlck zum <a href="/eggtracker/?action=export_form">Exportformular</a>.';
	die();}
	
//test if datapoints were chosen
if(empty($_POST["Wert"]["id"]) AND empty($_POST["Wert"]["time"]) AND empty($_POST["Wert"]["value"]) AND empty($_POST["Wert"]["validated"]) AND empty($_POST["Wert"]["outlier"])){
	print "Bitte w&aumlhlen Sie mindestens einen der Datenpunkte aus.";
	print '</br>Zur&uumlck zum <a href="/eggtracker/?action=export_form">Exportformular</a>.';
	die();}

//test if startdate was chosen
if($_POST["von"] =="Von (YYYY-MM-TT)"){
	print "Bitte w&aumlhlen Sie einen Anfangszeitpunkt aus.";
	print '</br>Zur&uumlck zum <a href="/eggtracker/?action=export_form">Exportformular</a>.';
	die();}

//test if enddate was chosen	
if($_POST["bis"] =="Bis (YYYY-MM-TT) "){
	print "Bitte w&aumlhlen Sie einen Endzeitpunkt aus.";
	print '</br>Zur&uumlck zum <a href="/eggtracker/?action=export_form">Exportformular</a>.';
	die();}
	
//test if a exportformat was chosen
if(empty($_POST["format"])){
	print "Bitte w&aumlhlen Sie ein Exportformat aus.";
	print '</br>Zur&uumlck zum <a href="/eggtracker/?action=export_form">Exportformular</a>.';
	die();}
	
	
if (in_array ( $_POST["CosmID"], $res2) == true){
	$ei = $_POST["CosmID"];
	
}

$wo = "";
#Abfrage der Radiobuttons aus dem Export-Formular
if($_POST["Parameter"] == 1)
	$wo .= "o3";
if($_POST["Parameter"] == 2)
	$wo .= "no2";
if($_POST["Parameter"] == 3)
	$wo .= "co";
if($_POST["Parameter"] == 4)
	$wo .= "temperature";
if($_POST["Parameter"] == 5)
	$wo .= "humidity";

	

$was = "";
#Abfrage der Checkboxen aus dem Export-Formular
if(isset($_POST["Wert"]["id"]) && $_POST["Wert"]["id"] == 1)
	$was .= "id, ";
if(isset($_POST["Wert"]["time"]) && $_POST["Wert"]["time"] == 1)
	$was .= "time, ";
if(isset($_POST["Wert"]["value"]) && $_POST["Wert"]["value"] == 1)
	$was .= "$wo, ";
if(isset($_POST["Wert"]["validated"]) && $_POST["Wert"]["validated"] == 1)
	$was .= "validated, ";
if(isset($_POST["Wert"]["outlier"]) && $_POST["Wert"]["outlier"] == 1)
	$was .= "outlier, ";
$was = rtrim ($was, ', ');

#Abfrage der Datumsfelder aus dem Export-Formular
$von = "'".$_POST['von']."'";
$bis = "'".$_POST['bis']."'";

$query_params = array($ei, $von, $bis);
$query = "SELECT $was FROM $wo NATURAL INNER JOIN eggs WHERE cosmid = $1 AND time BETWEEN $2 AND $3";
$result = pg_query_params($dbconn, $query, $query_params);

if($_POST["format"] == "xml") {
	$doc = new DomDocument("1.0");
	$doc->formatOutput = true;

	$root = $doc->createElement('data');
	$root = $doc->appendChild($root);

	while($row = pg_fetch_assoc($result)){
		$node = $doc->createElement('collection');
		$node = $root->appendChild($node);

		foreach($row as $fieldname => $fieldvalue){
		   $node->appendChild($doc->createElement($fieldname, $fieldvalue));
		}
	}
	header("Content-type: application/xml");
	header('Content-Disposition: attachment; filename="Egg-Values.xml"');
	echo $doc->saveXML();
} elseif($_POST["format"] == "csv") {
	header("Content-type: text/plain");
	header('Content-Disposition: attachment; filename="Egg-Values.csv"');
	echo $was.PHP_EOL;
	
	while($row = pg_fetch_assoc($result)){
		$keys = array_keys($row);
		$last_key = end($keys);
		foreach($row as $fieldname => $fieldvalue){
		   echo $fieldvalue;
		   if($fieldname != $last_key) echo ", ";
		}
		echo PHP_EOL;
	}
} elseif($_POST["format"] == "json") {
	header("Content-type: text/plain");
	header('Content-Disposition: attachment; filename="Egg-Values.json"');
	$data = array();
	
	while($row = pg_fetch_assoc($result)){
		$data[] = $row;
	}
	echo json_encode($data);
}

?>