日期:2014-05-16 浏览次数:20578 次
<div title="待处理工作事项" iconCls="icon-search" closable="true" style="height:150px;padding:10px;">
<?php
include($_SERVER['DOCUMENT_ROOT']."/auth.php");//调用数据库连接文件
$query3 = "select count(*) from (select * from (select * from bydms_dutyapp where dutyapp_approverid='$MY_SYSNUMBER' order by dutyapp_datetime desc ) as bydms_tempa left join bydms_project on dutyapp_projectid=project_id ) as bydms_tempb where dutyapp_result='审批中' ";
$result3 = mysql_query($query3);
while ($row = mysql_fetch_array($result3)) { //输出所有的查询结果
echo "您当前有".$row."条待审批流程!";
}
?>
</div>
$query3 = "select count(*) from (select * from (select * from bydms_dutyapp where dutyapp_approverid='$MY_SYSNUMBER' order by dutyapp_datetime desc ) as bydms_tempa left join bydms_project on dutyapp_projectid=project_id ) as bydms_tempb where dutyapp_result='审批中' ";