";
$DEBUG=0;
if(!isset($sel_date))
$sel_date=0;
if($DEBUG)
echo "sel_date=$sel_date
";
$fieldNameAttr=array("Incoming email attempt",
"Incoming email success",
"Outgoing email attempt",
"Outgoing email success",
"Incoming sms attempt",
"Incoming sms success",
"Outgoing sms attempt",
"Outgoing sms success",
"Total message length",
"Reserved data1",
"Reserved data2");
//get data from database
$db="CSTA_DB";
$table_name="smegDetail";
$temp=date("d",mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y")));
$table_name=$table_name."_".$temp;
if($DEBUG)echo "table_name:$table_name
";
$from_time=date("Y-m-d H:i:s",mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y")));
$to_time=date("Y-m-d H:i:s",mktime(0,0,0,date("m"),date("d")-$sel_date+1,date("Y")));
if($DEBUG)echo "from:$from_time--to:$to_time
";
$select="select key_sys_id,sum(in_email_att) as in_email_att,sum(in_email_suc) as in_email_suc,sum(out_email_att) as out_email_att,sum(out_email_suc) as out_email_suc,sum(in_sms_att) as in_sms_att,sum(in_sms_suc) as in_sms_suc,sum(out_sms_att) as out_sms_att,sum(out_sms_suc) as out_sms_suc ";
$from="from $table_name ";
$where="where csta_datetime >='$from_time' and csta_datetime <'$to_time' ";
$group="group by key_sys_id ";
$sql=$select.$from.$where.$group;
if($DEBUG)echo "$sql
";
$result=@mysqli_query($pubConn,$sql);
$rows=@mysqli_fetch_array($result);
//init
$in_email_att_sum=0;
$in_email_suc_sum=0;
$out_email_att_sum=0;
$out_email_suc_sum=0;
$in_sms_att_sum=0;
$in_sms_suc_sum=0;
$out_sms_att_sum=0;
$out_sms_suca_sum=0;
if($rows)
{
do{
$key_sys_id=$rows[key_sys_id];
$in_email_att_sum=$rows[in_email_att];
$in_email_suc_sum=$rows[in_email_suc];
$out_email_att_sum=$rows[out_email_att];
$out_email_suc_sum=$rows[out_email_suc];
$in_sms_att_sum=$rows[in_sms_att];
$in_sms_suc_sum=$rows[in_sms_suc];
$out_sms_att_sum=$rows[out_sms_att];
$out_sms_suca_sum=$rows[out_sms_suc];
}while($rows=mysqli_fetch_array($result));
}
//table title
echo "";
$sel_date_title=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y")));
echo "$strSMSEG Statistic Date: $sel_date_title
";
echo "";
//show the data
echo "";
echo "";
echo "
| ";
echo "Type | ";
echo "Value | ";
echo "
";
echo "";
echo "| Incoming email | ";
echo "Attempt | ";
//Incoming email attempt
echo "$in_email_att_sum |
";
echo "| Success | ";
//Incoming email success
echo "$in_email_suc_sum |
";
echo "";
echo "";
echo "| Outgoing email | ";
echo "Attempt | ";
//Outgoing email attempt
echo "$out_email_att_sum |
";
echo "| Success | ";
//Outgoing email success
echo "$out_email_suc_sum |
";
echo "";
echo "";
echo "| Incoming sms | ";
echo "Attempt | ";
//Incoming sms attempt
echo "$in_sms_att_sum |
";
echo "| Success | ";
//Incoming sms success
echo "$in_sms_suc_sum |
";
echo "";
echo "";
echo "| Outgoing sms | ";
echo "Attempt | ";
//Outgoing sms attempt
echo "$out_sms_att_sum |
";
echo "| Success | ";
//Outgoing sms success
echo "$out_sms_suca_sum |
";
echo "| Total message length | ";
//Total message length
echo "0 |
";
echo "";
echo "
";
adjust_content_tail("down");
?>