<?php
include ('../forbidden/db_ro_details.php');

// Standard Source view option check
function check_sourceview () {
    global $SITE;
    if (isset($_GET['view']) && $_GET['view'] == 'sce') {
        $filenameReal = __FILE__;
        $download_size = filesize($filenameReal);
        header('Pragma: public');
        header('Cache-Control: private');
        header('Cache-Control: no-cache, must-revalidate');
        header('Content-type: text/plain');
        header('Accept-Ranges: bytes');
        header("Content-Length: $download_size");
        header('Connection: close');
        readfile($filenameReal);
        exit;
    }
}

// Just list the PHP source?
check_sourceview();

// get the input parameters
if (isset($_GET["mm"])) {
    $month = intval($_GET["mm"]);
} else {
    die("No 'mm' parameter supplied");
}

if ($month == "") {
    die("Invalid 'mm' parameter supplied");
}

// get the input parameters
if (isset($_GET["yy"])) {
    $year = intval($_GET["yy"]);
} else {
    die("No 'yy' parameter supplied");
}

if ($year == "") {
    die("Invalid 'yy' parameter supplied");
}

// Connect to the database
$con=@mysql_connect($dbhost,$dbuser,$dbpassword);
if (!$con) { echo "failed to connect to the database server"; exit(); }

if (!mysql_select_db($database,$con)) { echo "Failed to connect to the database on the server"; exit(); }

#
# The db querys
#

/*$CreateQuery = "CREATE TABLE $param_table (LogDate date NOT NULL ,HighWindGust decimal(4,1) NOT NULL,HWindGBear varchar(3) NOT NULL,THWindG varchar(5) NOT NULL,MinTemp decimal(5,1) NOT NULL,TMinTemp varchar(5) NOT NULL,MaxTemp decimal(5,1) NOT NULL,TMaxTemp varchar(5) NOT NULL," .
					"MinPress decimal(6,2) NOT NULL,TMinPress varchar(5) NOT NULL,MaxPress decimal(6,2) NOT NULL,TMaxPress varchar(5) NOT NULL,MaxRainRate decimal(4,1) NOT NULL,TMaxRR varchar(5) NOT NULL,TotRainFall decimal(6,2) NOT NULL,AvgTemp decimal(4,2) NOT NULL,TotWindRun decimal(5,1) NOT NULL," .
					"HighAvgWSpeed decimal(3,1),THAvgWSpeed varchar(5),LowHum varchar(3),TLowHum varchar(5),HighHum varchar(3),THighHum varchar(5),TotalEvap decimal(5,2),HoursSun decimal(2,1),HighHeatInd decimal(4,1),THighHeatInd varchar(5),HighAppTemp decimal(4,1),THighAppTemp varchar(5),LowAppTemp decimal(4,1)," .
					"TLowAppTemp varchar(5),HighHourRain decimal(4,1),THighHourRain varchar(5),LowWindChill decimal(4,1),TLowWindChill varchar(5),HighDewPoint decimal(4,1),THighDewPoint varchar(5),LowDewPoint decimal(4,1),TLowDewPoint varchar(5),DomWindDir varchar(3),HeatDegDays decimal(4,1),CoolDegDays decimal(4,1)," .
					"HighSolarRad varchar(5),THighSolarRad varchar(5),HighUV varchar(2),THighUV varchar(5),HWindGBearSym varchar(3),DomWindDirSym varchar(3),PRIMARY KEY(LogDate) ) COMMENT = \"Dayfile from Cumulus\"";
	*/

$result = mysql_query("SET time_zone='+1:00';");
if (!$result) { printf ("ERROR - TZ Statement"); exit; }

$query = "SELECT MAX(MaxTemp), MIN(MinTemp), AVG(AvgTemp), MAX(HighHum), MIN(LowHum), SUM(TotRainFall), MAX(HighWindGust), SUM(TotWindRun), MIN(MinPress), MAX(MaxPress), SUM(CoolDegDays), SUM(HeatDegDays), AVG(DomWindDir), MAX(MaxRainRate), MAX(HighSolarRad) FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month."";

$result = mysql_query($query);
if (!$result) { printf ("ERROR - Bad Select Statement"); exit; }

while($row = mysql_fetch_row($result)) {
	$TMaxM = (float)$row[0];
	$TMinM = (float)$row[1];
	$TAvgM = number_format((float)$row[2],1);
	$HMaxM = (float)$row[3];
	$HMinM = (float)$row[4];
	$PTotM = (float)$row[5];
	$VMaxM = (float)$row[6];
	$VTotM = (float)$row[7];
	$PMaxM = (float)$row[8];
	$PMinM = (float)$row[9];
	$CDjuM = (float)$row[10];
	$HDjuM = (float)$row[11];
	$VDirM = (float)$row[12];	
	$PDebM = (float)$row[13];
	$SRadM = (float)$row[14];	
}

 $query = "SELECT DATE_FORMAT(LogDate, '%d') AS LogDate, MaxTemp, MinTemp, AvgTemp, HighHum, LowHum, TotRainFall, HighWindGust, TotWindRun, MinPress, MaxPress, CoolDegDays, HeatDegDays, DomWindDir, MaxRainRate, HighSolarRad FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month." ORDER BY LogDate ASC";


$result = mysql_query($query);
if (!$result) { printf ("ERROR - Bad Select Statement"); exit; }

// import the rows and put the data into arrays
while($row = mysql_fetch_row($result)) {
	$title[] = $row[0];
	$TMax[] = (float)$row[1];
	$TMin[] = (float)$row[2];
	$TAvg[] = (float)$row[3];
	$HMax[] = (float)$row[4];
	$HMin[] = (float)$row[5];
	$PTot[] = (float)$row[6];
	$VMax[] = (float)$row[7];
	$VTot[] = (float)$row[8];
	$PMax[] = (float)$row[9];
	$PMin[] = (float)$row[10];
	$CDju[] = (float)$row[11];
	$HDju[] = (float)$row[12];
	$VDir[] = (float)$row[13];
	$PDeb[] = (float)$row[14];
	$SRad[] = (float)$row[15];
}

$query = " SELECT DATE_FORMAT(LogDate, '%d') AS LogDate, HighHourRain FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month." and HighHourRain = (SELECT MAX(HighHourRain) FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month.")";
//print_r($query);
$result = mysql_query($query);
if (!$result) { printf ("ERROR - Bad Select Statement"); exit; }
while($row = mysql_fetch_row($result)) {
	$HRainM[0] = $row[1];
	$HRainM[1] = $row[0];
}

// put into a single array
// Have to add an offset of 10 minutes to the start-date for some reason?!

$rows =array('jour' => $title, 'tmin' => $TMin, 'tmax' => $TMax, 'tavg' => $TAvg, 'cdd' => $CDju, 'hdd' => $HDju, 'hmin' => $HMin, 'hmax' => $HMax, 'pluie' => $PTot, 'averse' => $PDeb, 'ventr' => $VMax, 'ventt' => $VTot, 'vdir' => $VDir, 'pmin' => $PMin, 'pmax' => $PMax, 'srad' => $SRad,
			'tminM' => $TMinM, 'tmaxM' =>$TMaxM, 'tavgM' =>$TAvgM, 'cddM' => $CDjuM, 'hddM' => $HDjuM, 'hmaxM' =>$HMaxM, 'hminM' =>$HMinM, 'pluieM' =>$PTotM, 'averseM' => $PDebM, 'ventrM' => $VMaxM, 'venttM' => $VTotM, 'vdirM' => $VDirM, 'pminM' => $PMinM, 'pmaxM' => $PMaxM, 'sradM' => $SRadM,
			'pluie1HM' => $HRainM);

header("Content-type: text/json");
echo json_encode($rows);
//print_r($rows);
?>