Date:
   Print  

read()){ //echo "
$file "; //echo filectime($file); if(strstr($file,'.png') && filectime($file) < $delTimestamp){ if($DEBUG) echo "
DELETE : $file"; @unlink($file); } } $mydir->close(); //产生随机熟用于做文件名 mt_srand((double)microtime()*1000000); $randval = mt_rand(); if(!isset($date)){ if($DEBUG) echo "
Default is Today"; $date=date("Y-m-d",mktime(0,0,0,date("m"),date("d"),date("Y"))); } if($DEBUG) echo "
date=$date"; $dateArr = explode('-',$date); //======================================================================== // CDR Daily Report //======================================================================== $db='95DB_CDR'; $tableName = "95dbCdr_{$dateArr[0]}_{$dateArr[1]}_{$dateArr[2]}"; $sumSql = "SELECT operation,count(charge) as conCharge,sum(charge) as sumCharge FROM $tableName GROUP BY operation ORDER BY operation"; if($DEBUG) echo "
sumSql=$sumSql"; $sumResult = @mysqli_query($pubConn,$sumSql); $errorStr = mysqli_error($pubConn); if(strstr($errorStr,"doesn't exist")){ echo "
This day's record doesn't exist"; exit(0); } $sumChargeArr=array(0,0,0); $conChargeArr=array(0,0,0); while($sumRows = @mysqli_fetch_array($sumResult)){ $i=$sumRows[operation]; $sumChargeArr[$i]=$sumRows[sumCharge]; $conChargeArr[$i]=$sumRows[conCharge]; } echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; for($i=0;$i"; echo " "; echo " "; echo " "; echo " "; } echo "
Charge
Operation TypeTotal TimesTotal Charge
$subsOperDefArr[$i] $conChargeArr[$i] $sumChargeArr[$i] 
"; //======================================================================== // CSTA Daily Report //======================================================================== $db='95DB_CSTA'; $tableName = "95dbCsta_{$dateArr[0]}_{$dateArr[1]}_{$dateArr[2]}"; $sumSql = "SELECT sum(active) as sumActive,sum(webVisit) as sumWebVisit, sum(dnRequ) as sumDnRequ, sum(dnSucc) as sumDnSucc, sum(dnFailNoCharge) as sumDnFailNoCharge, sum(dnFailNetFail) as sumDnFailNetFail, sum(dnFailFileExists) as sumDnFailFileExists, sum(dnFailAuthFail) as sumDnFailAuthFail, sum(dnFailOther) as sumDnFailOther, sum(upRequ) as sumUpRequ, sum(upSucc) as sumUpSucc, sum(upFailDataError) as sumUpFailDataError, sum(upFailNetFail) as sumUpFailNetFail, sum(upFailAuthFail) as sumUpFailAuthFail, sum(upFailOther) as sumUpFailOther FROM $tableName "; if($DEBUG) echo "
sumSql=$sumSql"; $sumResult = @mysqli_query($pubConn,$sumSql); $sumRows = @mysqli_fetch_array($sumResult); $errorStr = mysqli_error($pubConn); if(strstr($errorStr,"doesn't exist")){ echo "
This day's record doesn't exist"; exit(0); } //坐标转换函数，将数值转换成坐标 function getNewXY($pointArr) { global $xBgn,$yBgn,$xEnd,$yEnd,$maxYNum,$unitXPix; $DEBUG=0; for($i=0;$ipointArr[$i]={$pointArr[$i]}"; $pointArr[$i+1] = $yEnd - round(($yEnd - $yBgn) * ($pointArr[$i+1] / $maxYNum)) - 1; if($DEBUG) echo "
pointArr[$i+1]={$pointArr[$i+1]}"; } $pointArr[$i] = $pointArr[$i-2]; if($DEBUG) echo "
pointArr[$i]={$pointArr[$i]}"; $pointArr[$i+1] = $yEnd-1; if($DEBUG) echo "
pointArr[$i+1]={$pointArr[$i+1]}"; $pointArr[$i+2] = $pointArr[0] * $unitXPix; $pointArr[$i+3] = $yEnd; return($pointArr); } echo "

"; $sql = "SELECT * FROM $tableName ORDER BY timeNo"; if($DEBUG) echo "
sql=$sql"; //=============================User======================================= $result = @mysqli_query($pubConn,$sql); require("./cstaImgUser.php"); echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "
User
 Total%
Web Visit $sumRows[sumWebVisit] 100%
   
   
   
   
   
   
   
   
"; echo "

"; //=============================Download===================================== $result = @mysqli_query($pubConn,$sql); require("./cstaImgDownload.php"); echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnSucc]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnFailNoCharge]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnFailNetFail]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnFailFileExists]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnFailAuthFail]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumDnRequ],$sumRows[sumDnFailOther]); echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "
Download
 Total%
Request $sumRows[sumDnRequ] 100%
Success $sumRows[sumDnSucc] $tmpPercent%
No Charge $sumRows[sumDnFailNoCharge] $tmpPercent%
Net Failure $sumRows[sumDnFailNetFail] $tmpPercent%
File Exist $sumRows[sumDnFailFileExists] $tmpPercent%
Auth. Failure $sumRows[sumDnFailAuthFail] $tmpPercent%
Other Failure $sumRows[sumDnFailOther] $tmpPercent%
   
   
"; echo "

"; //=============================Upload======================================= $result = @mysqli_query($pubConn,$sql); require("./cstaImgUpload.php"); echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpRequ]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpSucc]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpFailDataError]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpFailNetFail]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpFailAuthFail]); echo " "; echo " "; echo " "; echo " "; echo " "; $tmpPercent = getPercent($sumRows[sumUpRequ],$sumRows[sumUpFailOther]); echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "
Upload
 Total%
Request $sumRows[sumUpRequ] $tmpPercent%
Success $sumRows[sumUpSucc] $tmpPercent%
Data Error $sumRows[sumUpFailDataError] $tmpPercent%
Net Failure $sumRows[sumUpFailNetFail] $tmpPercent%
Auth. Failure $sumRows[sumUpFailAuthFail] $tmpPercent%
Other Failure $sumRows[sumUpFailOther] $tmpPercent%
   
   
   
"; //========================================================================== $dayStr=date("Y-m-d H:i:s",mktime()); echo "
    Print Time: $dayStr "; echo "    Print User: $userInfo[ID]

"; echo ""; ?>