| 搜索 |
<?php
$selectsqlpage="select fsname,spbh as gwbh,zhuti,fssj,reachtime,leixing from shenpd where zbbz='在办' and fenfbz<>1 and sptype<>10 and sylc<>'审批不规范已被退回' and nowname='$_SESSION[username]' order by spbh desc limit 3";
//echo $selectsqlpage;
$selectsqlpage1="select fsname,gwbh,zhuti,fssj,reachtime,leixing from gongwen where zbbz='在办' and (gwtype=1 or gwtype=8) and nowname='$_SESSION[username]' order by gwbh desc limit 3";
// echo $selectsqlpage1;
$selectsqlpage2="select fsname,gwbh,zhuti,fssj,reachtime,leixing from yibangw where zbbz='在办' and fhbz=1 and gwtype<>10 and nowname='$_SESSION[username]' order by gwbh desc limit 3";
// echo $selectsqlpage2;
$rs1 = mysql_query($selectsqlpage);
$rs2 = mysql_query($selectsqlpage1);
$rs3 = mysql_query($selectsqlpage2);
if (@mysql_num_rows($rs1) > 0) {
while($r1 = mysql_fetch_array($rs1)) {
$data[]=$r1;
// echo "<li class=\"link_none\"><a href=\"/$r1[leixing]/du$r1[leixing].php?rd=".rand()."&bh=$r1[gwbh] \">$r1[zhuti]</a><span>[15:36](已到达".date("d",(time()- strtotime($r1['reachtime'])))."天3小时)</span></li>
// <li class=\"link_time\">经办人:$r1[fsname] $r1[fssj] | 已审用时:2天15小时</li>";
}
}
if (@mysql_num_rows($rs2) > 0) {
while($r2 = mysql_fetch_array($rs2)) {
$data[]=$r2;
}
}
if (@mysql_num_rows($rs3) > 0) {
while($r3 = mysql_fetch_array($rs3)) {
$data[]=$r3;
}
}
$newArr=array();
for($j=0;$j<count(@$data);$j++){
$newArr[]=$data[$j]['reachtime'];
}
@array_multisort($newArr,SORT_DESC,$data);
// print_r($data);
// var_dump($data);
if(!is_array($data)){
echo "<img src='/images/xiuxi.png' alt='没有待办，休息一会！' />";
}else{
foreach ($data as $key => $shuju) {
if ($key>4) {
break;
}
$shijianc1=strtotime($shuju['reachtime']);//进行比较的时间戳
$jt=strtotime(''.date("Y-m-d",time()).' 00:00:00');//今天零点时间戳
$zt=($jt-86400);//昨天零点时间戳
$qt=($zt-86400);//前天零点时间戳
$fssjex=explode(" ",$shuju['fssj']);
$sjc=(time()-strtotime($shuju['reachtime']));//停留时间
$sjcsj=(strtotime($shuju['reachtime'])-strtotime($shuju['fssj']));//已审批用时
if($shijianc1>$jt){
$myday="今天";
$mytime=date("H:i",strtotime($shuju['reachtime']));
}
elseif($shijianc1<$jt && $shijianc1>$zt){
$myday="昨天";
$mytime=date("H:i",strtotime($shuju['reachtime']));
}
elseif($shijianc1<$zt && $shijianc1>$qt){
$myday="前天";
$mytime=date("H:i",strtotime($shuju['reachtime']));
}
else{
$myday=date("m-d",strtotime($shuju['reachtime']));
$mytime=date("H:i",strtotime($shuju['reachtime']));
}
if($shuju['leixing']=="yibangongwu"){
$erji="gw";
}
else{
$erji=$shuju['leixing'];
}
// echo $shuju['zhuti'];
if ($_SESSION['username']=='文件中心') {
echo "<li class=\"link_none\"><a href=\"/$shuju[leixing]/du".$erji."wjzx.php?rd=".rand()."&bh=$shuju[gwbh]\">$shuju[zhuti]</a><span>$myday</span></li>
<li class=\"link_time\">经办人:$shuju[fsname] $fssjex[0] | 已审用时:".floor($sjcsj/3600)."小时 | 已停留".floor($sjc/3600)."小时<span>$mytime</span></li>";
}else{
echo "<li class=\"link_none\"><a href=\"/$shuju[leixing]/du".$erji.".php?rd=".rand()."&bh=$shuju[gwbh]\">$shuju[zhuti]</a><span>$myday</span></li>
<li class=\"link_time\">经办人:$shuju[fsname] $fssjex[0] | 已审用时:".floor($sjcsj/3600)."小时 | 已停留".floor($sjc/3600)."小时<span>$mytime</span></li>";
}
}
}
?>