asum.php

电子派单系统

<?php
session_start();
include("resp.inc");
resp_db_connect_i();
$pnum=mysql_query("select goin, count(*) as dnumber ,sum(time_to_sec(timediff(comptm,arrtm))/60) as ptime from flow where sn=any(select sn from deliver where tflag='1') group by goin order by dnumber  desc"); 

$private=mysql_query("select coman,count(distinct  sn) as dnum,count(sn) as pnum from flow where sn=any(select sn from deliver where tflag='1') group by coman order by dnum,pnum desc");

$height=(mysql_num_rows($pnum)>mysql_num_rows($private)?mysql_num_rows($pnum):mysql_num_rows($private))*30+100;
echo "<iframe style='position:relative;left:0px; top:0px;width=100%;height=$height' frameBorder='0'  scrolling='no' src='sumdata.php'></iframe>";
echo "<iframe style='position:relative;left:0px; top:0px;width=50%;height=240;'  frameBorder='0' scrolling='no' src='sum.php'></iframe>";
echo "<iframe style='position:relative;left:0px; top:0px;width=50%;height=240;'  frameBorder='0' scrolling='no' src='area.php'></iframe>";
?>