<?php
session_start();
include("resp.inc");
resp_db_connect_i();
$tmp=mysql_query("select sn,ftype,ttime-stime as dtime from deliver where tflag='1' and datediff(now(),stime)='1' order by dtime desc");
if (mysql_num_rows($tmp)<1) {echo "<center><font size=+3>目前暫無銷帳清單</font></center>";}else{
echo "<center><caption><font size=+3><B>前日銷帳清單</B></font></caption></center>";
echo "<table align=center border=1px width=96%>";
echo "<tr><th>序號<th>故障原因<th>流程數<th>處理時長</tr>";
for ($i=1;$i<=mysql_num_rows($tmp);$i++){
$maxsn=mysql_fetch_array(mysql_query("select max(snord) from flow where sn=$opt[sn]"));
$opt=mysql_fetch_array($tmp);
echo "<tr><td><a href=\"dp.php?sn=$opt[sn]\">$opt[sn]</a></td>
	 <td>$opt[ftype]</td>

	 <td>$maxsn[0]</td>
	<td>$opt[dtime]</td></tr>";
}
echo "</table>";
}
?>