102 lines
2.9 KiB
PHP
Executable File
102 lines
2.9 KiB
PHP
Executable File
<?php
|
||
/*********************************************************
|
||
程序说明：
|
||
功能说明：CDR列表显示
|
||
调用关系：
|
||
变量说明：
|
||
|
||
作者：
|
||
|
||
修改注释：
|
||
NO.1
|
||
姓名：
|
||
时间：
|
||
修改说明：
|
||
*********************************************************/
|
||
require("../inc/include.inc");
|
||
$DEBUG = 0;
|
||
$MAX_NUM_PER_PAGE = 100;
|
||
$db='95DB_CSTA';
|
||
$displayedNum = 0;
|
||
if(!isset($date)){
|
||
$date=date("Y-m-d",mktime(0,0,0,date("m"),date("d"),date("Y")));
|
||
}
|
||
if($DEBUG) echo "<br>date=$date";
|
||
$dateArr = explode('-',$date);
|
||
|
||
$tableName="95dbCsta_{$dateArr[0]}_{$dateArr[1]}_{$dateArr[2]}";
|
||
$sql = "SELECT * FROM $tableName";
|
||
if($DEBUG) echo "<br>sql=$sql";
|
||
$result = @mysqli_query($pubConn,$sql);
|
||
if($DEBUG) echo '<br>'.mysqli_error($pubConn);
|
||
|
||
echo "\n <script language=\"JavaScript\">";
|
||
echo "\n <!--";
|
||
echo "\n function TableMouseOver(Obj){";
|
||
echo "\n Obj.style.backgroundColor='#f2f2f2';";
|
||
echo "\n }";
|
||
echo "\n function TableMouseOut(Obj){";
|
||
echo "\n Obj.style.backgroundColor='';";
|
||
echo "\n }";
|
||
echo "\n -->";
|
||
echo "\n </script>";
|
||
|
||
?>
|
||
<body topmargin="0" leftmargin="5">
|
||
<br>
|
||
<table border="1" width="100%" bordercolordark="#FFFFFF" bordercolor="#808080" cellspacing="0">
|
||
<tr bgcolor="#E6E6E6" align="center">
|
||
<td rowspan="2" width="6%">No.</td>
|
||
<td rowspan="2" width="11%">HB Number</td>
|
||
<td rowspan="2" width="12%">Active User</td>
|
||
<td rowspan="2" width="12%">Page Visit</td>
|
||
<td colspan="2" width="20%">Download</td>
|
||
<td colspan="2" width="20%">Upload</td>
|
||
<td rowspan="2" width="20%">Date</td>
|
||
</tr>
|
||
<tr bgcolor="#E6E6E6" align="center">
|
||
<td>request</td>
|
||
<td>success</td>
|
||
<!-- <td>no_credit</td> -->
|
||
<!-- <td>net_failure</td> -->
|
||
<!-- <td>file_exist</td> -->
|
||
<!-- <td>auth_failure</td> -->
|
||
<!-- <td>other_failure</td> -->
|
||
<td>request</td>
|
||
<td>success</td>
|
||
<!-- <td>data_error</td> -->
|
||
<!-- <td>net_failure</td> -->
|
||
<!-- <td>auth_failure</td> -->
|
||
<!-- <td>other_failure</td> -->
|
||
</tr>
|
||
<?php
|
||
$rowsNo = 0;
|
||
while($rows = @mysqli_fetch_array($result)){
|
||
$rowsNo++;//$rows[timeNo]
|
||
echo "<tr align=\"right\" onmouseover=\"TableMouseOver(this)\" onmouseout=\"TableMouseOut(this)\">";
|
||
echo "<td>$rowsNo </td>";
|
||
echo "<td>$rows[hb_per_min] </td>";
|
||
echo "<td>$rows[active] </td>";
|
||
echo "<td>$rows[webVisit]</td>";
|
||
echo "<td>$rows[dnRequ]</td>";
|
||
echo "<td>$rows[dnSucc]</td>";
|
||
// echo "<td>$rows[dnFailNoCredit]</td>";
|
||
// echo "<td>$rows[dnFailNetfail]</td>";
|
||
// echo "<td>$rows[dnFailFileExists]</td>";
|
||
// echo "<td>$rows[dnFailAuthFail]</td>";
|
||
// echo "<td>$rows[dnFailOther]</td>";
|
||
echo "<td>$rows[upRequ]</td>";
|
||
echo "<td>$rows[upSucc]</td>";
|
||
// echo "<td>$rows[upFailDataError]</td>";
|
||
// echo "<td>$rows[upFailNetFail]</td>";
|
||
// echo "<td>$rows[upFailAuthFail]</td>";
|
||
// echo "<td>$rows[upFailOther]</td>";
|
||
echo "<td align=\"center\">$rows[recordTime] </td>";
|
||
echo "</tr>";
|
||
}
|
||
?>
|
||
</table>
|
||
</body>
|
||
|
||
</html>
|