<?php

//#ob_start("ob_gzhandler");

require_once('controller.php');
require_once("./js/gdatasource/vistable.php");

$tqx = isset($_GET['tqx']) ? $_GET['tqx'] : "";
$tq = isset($_GET['tq']) ? $_GET['tq'] : "";
$tqrt = isset($_GET['tqrt']) ? $_GET['tqrt'] : "";
$tz = isset($_GET['tz']) ? $_GET['tz'] : "PDT";
$locale = isset($_SERVER["HTTP_ACCEPT_LANGUAGE"]) ? $_SERVER["HTTP_ACCEPT_LANGUAGE"] : "en_US";

if (isset($_GET['locale'])) {
    $locale = $_GET['locale'];
}

$extra = array();
if (isset($_GET['debug']) && $_GET['debug']) {
    header('Content-type: text/plain; charset="UTF-8"');
    $extra['debug'] = 1;
}

$controller = new Controller(false);
$persistent="true";

if(isset($_GET['com'])) {
	//analoga me to command kalei tin katallili synanrtisi
	if($_GET['com'] == "query") {
		$selectedData = json_decode($_GET['data'],true);

if(!isset($_GET['persistent']))
{ $persistent="true";
}else{$persistent="false";}


		$resp = $controller->makeQuery('table',$persistent);
		$resp = json_decode($resp,true);
		//make the header row
		$header = array();
		if($selectedData['xaxistitle'] && $selectedData['xaxistitle'] !='')
			$header[] = $selectedData['xaxistitle'];
		else{
			$temp = explode("-",$selectedData['xaxis']['name']);
			$header[] = $temp[count($temp)-1];
		}

		for($i=0;$i<count($selectedData['fields']);$i++){
			if(isset($selectedData['fieldsheaders']) && isset($selectedData['fieldsheaders'][$i]) && $selectedData['fieldsheaders'][$i]!=''){
				$header[] = $selectedData['fieldsheaders'][$i];
			}
			else{
				$temp = explode("-",$selectedData['fields'][$i]['fld']);
				if($selectedData['fields'][$i]['agg'] != '')
					$header[] = $selectedData['fields'][$i]['agg']." of ".$temp[count($temp)-1];
				else
					$header[] = $temp[count($temp)-1];
			}
		}
		if($selectedData['group']!='' && $selectedData['group'] !='no'){
			$temp = explode("-",$selectedData['group']);
			$header[] = $temp[count($temp)-1];
		}

		for($i=0;$i<count($header);$i++){
			//print_r($resp['data'][0][$i]);
			if(is_numeric($resp['data'][0][$i]))
				$header[$i] .= " as number";
		}

		$tempdata = array();
		$tempdata[] = implode(",",$header);
		for($l=1;$l<count($resp['data']);$l++){
			$tempdata[] = implode(",",$resp['data'][$l]);
		}
		$data = implode("\n",$tempdata);
		//echo $data;
		/*$file = '../data/data.csv';
		$data = file_get_contents($file);
		if ($file === FALSE) {
			die("Couldnt read `$file'");
		}*/


		$vt = new csv_vistable($tqx, $tq, $tqrt,$tz,$locale,$extra);

		$vt->setup_table($data);

		$result = $vt->execute();

		echo $result;
	}
	else{
		die("unknown command code");
	}
}
else {
	//oops error
	die("no command given");
}
//#ob_end_flush();
?>