<?
include "./db_conn.php";
include "./include/jsonRPCClient.php";
header('Content-Type: application/json;charset=UTF-8');

$startDate = $_GET["startDate"] ;
$endDate = $_GET["endDate"] ;
//$callback = $_REQUEST['callback'];

if ($startDate == $endDate)
{
	$count_sql = "select count(*) from T_MAIL where (STATUS = '0' or STATUS = '1' or STATUS = '2' or STATUS = '3' or STATUS = '4' or STATUS = '5') and MAIL_DATE LIKE '%$startDate%'"; 
	error_log ("sql0:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $receive_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where SENT_STATUS = '0' and MAIL_DATE LIKE '%$startDate%'"; 
	error_log ("sql1:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $wait_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where SENT_STATUS = '2' and MAIL_DATE  LIKE '%$startDate%'"; 
	error_log ("sql2:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $sent_ok_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where STATUS = '2' and MAIL_DATE  LIKE '%$startDate%'"; 
	error_log ("sql3:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $sign_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where (STATUS = '1' or STATUS = '3') and MAIL_DATE  LIKE '%$startDate%'"; 
	error_log ("sql4:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $deny_count = $data[0];
	} 
} else
{
	$count_sql = "select count(*) from T_MAIL where (STATUS = '0' or STATUS = '1' or STATUS = '2' or STATUS = '3' or STATUS = '4') and MAIL_DATE between '$startDate' and '$endDate'"; 
	error_log ("sql0:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $receive_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where SENT_STATUS = '0' and MAIL_DATE between '$startDate' and '$endDate'"; 
	error_log ("sql1:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $wait_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where SENT_STATUS = '2' and MAIL_DATE between '$startDate' and '$endDate'"; 
	error_log ("sql2:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $sent_ok_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where STATUS = '2' and MAIL_DATE between '$startDate' and '$endDate'"; 
	error_log ("sql3:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $sign_count = $data[0];
	} 
	$count_sql = "select count(*) from T_MAIL where (STATUS = '1' or STATUS = '3') and MAIL_DATE between '$startDate' and '$endDate'"; 
	error_log ("sql4:" . $count_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
	if ($data=mysql_fetch_array($count_result)) {
	    $deny_count = $data[0];
	} 
}

error_log ("receive_count:" . $receive_count, 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("wait_count:" . $wait_count, 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("sent_ok_count:" . $sent_ok_count, 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("sign_count:" . $sign_count, 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("deny_count:" . $deny_count, 3, "/usr/local/imagefilter30/var/logs/php.log");
error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");

/*
$json_val = "{\"list\":[{\"mailReceiveSum\":,\"mailWaitSum\":,\"mailSentOkSum\":,\"mailSignSum\":,\"mailDenySum\":}]}"
echo $callback."(".$json_val.")";
*/
?>
{"list":[
{"mailReceiveSum":,"mailWaitSum":,"mailSentOkSum":,"mailSignSum":,"mailDenySum":}
]}
<?
if($connect) mysql_close($connect);
?>