<?php
	require_once("DB.php");

	// 現在と気温/湿度と、24時間以内の最低、最高気温/湿度を
	// JSON で返します
	// 2010/02/01 rei@thread.co.jp

	$db = DB::connect("pgsql://postgres@unix()/ondo");

    $file = file_get_contents('/home2/httpd/htdocs_karuizawa/ondo/ondo.txt', true);
    list($state, $ondo, $shitsudo) = preg_split('/\n/', $file);

    $sql = "insert into ondo (kion, shitsudo, hiduke) VALUES (" .  $ondo .  ", " .  $shitsudo .  ", current_timestamp)";
    $res =& $db->query($sql);

	$sql = "SELECT kion, shitsudo FROM ondo ORDER BY hiduke desc LIMIT 1";
	$now = $db->getAll($sql, DB_FETCHMODE_ASSOC);

	$sql = "SELECT kion, shitsudo FROM ondo WHERE current_timestamp  < hiduke + '1 days' ORDER BY kion desc LIMIT 1";
	$high = $db->getAll($sql, DB_FETCHMODE_ASSOC);

	$sql = "SELECT kion, shitsudo FROM ondo WHERE current_timestamp  < hiduke + '1 days' ORDER BY kion LIMIT 1";
	$low = $db->getAll($sql, DB_FETCHMODE_ASSOC);

	$obj = array(
		'now'    => array('ondo'   => $now[0]['kion'],
	    			'shitsudo' => $now[0]['shitsudo']),
		'high24' => array('ondo'   => $high[0]['kion'],
	    			'shitsudo' => $high[0]['shitsudo']),
		'low24'  => array('ondo'   => $low[0]['kion'],
	    			'shitsudo' => $low[0]['shitsudo'])
	);
	if (isset($argc) && ($argc > 1) && ($argv[1] == "csv"))
	{
		print("{$now[0]['kion']},{$now[0]['shitsudo']}\n");
		print("{$high[0]['kion']},{$high[0]['shitsudo']}\n");
		print("{$low[0]['kion']},{$low[0]['shitsudo']}\n");
		exit;
	}

	if (isset($_GET['var']))
	{
		$hensu = $_GET['var'];
		echo "var $hensu = eval(";
	}
	echo json_encode($obj);
	if (isset($_GET['var']))
	{
		echo ");";
	}
?>