📄 work_list.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>待办工作</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\nfunction highlight(o){\r\n\tvar trs = o.getElementsByTagName(\"tr\");\r\n\tfor(var i=0;i<trs.length;i++){\r\n\t\t//trs[i].className = (i%2)==0 ? 'highlight':'nohighlight';\r\n\t\ttrs[i].onmouseover = function(){this.style.backgroundColor='#d6d6d6';return false;}\r\n\t\ttrs[i].onmouseout = function(){this.style.backgroundColor='';return false;}\r\n\t}\r\n}\r\n</script>\r\n";
echo "<s";
echo "cript Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',180000);\r\n</script>\r\n\r\n";
echo "<s";
echo "cript>\r\nfunction delete_run(RUN_ID)\r\n{\r\n msg='确认要删除该工作流程么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"delete.php?RUN_ID=\"+RUN_ID;\r\n location=url;\r\n }\r\n}\r\n\r\nfunction flow_view(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-600)/2;\r\n window.open(\"flow_view.php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"flow_view\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,";
echo "width=600,height=400,left=\"+myleft+\",top=100\");\r\n}\r\n\r\nfunction stop_run(RUN_ID,PRCS_ID)\r\n{\r\n msg='确认要终止该工作流程么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"stop.php?RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n location=url;\r\n }\r\n}\r\n\r\nfunction call_back(RUN_ID,PRCS_ID)\r\n{\r\n msg='下一步骤尚未接收办理，确认要收回至本步骤重新办理么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"call_back.php";
echo "?RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n location=url;\r\n }\r\n}\r\n</script>\r\n";
echo "<s";
echo "tyle>\r\nul li{\r\n\tpadding:2px;\r\n\r\n}\r\n</style>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/workflow.gif\" align=\"absmiddle\">待办事宜\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$sqlfrprcs = " \r\n\t\t\t SELECT RUN_ID,PRCS_FLAG FROM flow_run_prcs \r\n\t\t\t WHERE USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t AND ( \r\n\t\t\t\t\t ( (\r\n\t\t\t\t\t\t (PRCS_FLAG='2' AND SAVEFORM_TIME IS NULL AND OP_FLAG=0)\r\n\t\t\t\t\t\t OR\r\n\t\t\t\t\t\t (PRCS_FLAG='2' AND OP_FLAG=1)\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t\t OR PRCS_FLAG='1')\r\n\t\t\t\t\t )\r\n\t\t\t ";
$rsfrprcs = exequery( $connection, $sqlfrprcs );
while ( $rowfrprcs = mysql_fetch_array( $rsfrprcs ) )
{
$run_id_str .= $rowfrprcs['RUN_ID'].",";
$arrayflowrun[$rowfrprcs['RUN_ID']]['PRCS_FLAG'] = $rowfrprcs[$rowfrprcs['PRCS_FLAG']];
}
$run_id_str = substr( $run_id_str, 0, strlen( $run_id_str ) - 1 );
$run_id_str = $run_id_str ? $run_id_str : 0;
$sqlfrunall = "SELECT FLOW_ID,RUN_ID FROM flow_run WHERE RUN_ID IN (".$run_id_str.")";
$rsfrunall = exequery( $connection, $sqlfrunall );
while ( $rowfrunall = mysql_fetch_array( $rsfrunall ) )
{
$arrayflowrun[$rowfrunall['RUN_ID']]['FLOW_ID'] = $rowfrunall['FLOW_ID'];
}
if ( is_array( $arrayflowrun ) )
{
while ( list( $key, $var ) = each( $arrayflowrun ) )
{
$newcount = $var['PRCS_FLAG'] == 1 ? 1 : 0;
$arrayflowid[$var['FLOW_ID']]['newcount'] += $newcount;
}
reset( $arrayflowrun );
}
$sqlfrun = "SELECT FLOW_ID,COUNT(RUN_ID) AS cnt FROM flow_run WHERE RUN_ID IN (".$run_id_str.") GROUP BY FLOW_ID";
$rsfrun = exequery( $connection, $sqlfrun );
while ( $rowfrun = mysql_fetch_array( $rsfrun ) )
{
$flow_id_str .= $rowfrun['FLOW_ID'].",";
$arrayflowid[$rowfrun['FLOW_ID']]['count'] = $rowfrun['cnt'];
}
$flow_id_str = substr( $flow_id_str, 0, strlen( $flow_id_str ) - 1 );
$flow_id_str = $flow_id_str ? $flow_id_str : 0;
$sqlfl = "SELECT FLOW_SORT,FLOW_NAME,FLOW_ID,FLOW_TYPE FROM flow_type WHERE FLOW_ID IN (".$flow_id_str.")";
$rsfl = exequery( $connection, $sqlfl );
while ( $rowfl = mysql_fetch_array( $rsfl ) )
{
$flow_sort_str .= $rowfl['FLOW_SORT'].",";
$arrayflowid[$rowfl['FLOW_ID']]['flowsort'] = $rowfl['FLOW_SORT'];
$arrayflowid[$rowfl['FLOW_ID']]['flowname'] = $rowfl['FLOW_NAME'];
$arrayflowid[$rowfl['FLOW_ID']]['flowtype'] = $rowfl['FLOW_TYPE'];
}
$flow_sort_str = substr( $flow_sort_str, 0, strlen( $flow_sort_str ) - 1 );
$flow_sort_str = $flow_sort_str ? $flow_sort_str : 0;
$sql = "SELECT ID,NOORDER,TITLE FROM flow_sort WHERE ID IN (".$flow_sort_str.") ORDER BY NOORDER ASC";
$rs = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $rs ) )
{
$arrayflowsort[$row['ID']] = $row['TITLE'];
}
$totalflowrun = count( $arrayflowrun );
$totalflowid = count( $arrayflowid );
$totalflowsort = count( $arrayflowsort );
if ( is_array( $arrayflowid ) )
{
while ( list( $key, $var ) = each( $arrayflowid ) )
{
$arrayuse[$var['flowsort']]['sortname'] = $arrayflowsort[$var['flowsort']];
$arrayuse[$var['flowsort']]['flowid'][$key]['flowname'] = $var['flowname'];
$arrayuse[$var['flowsort']]['flowid'][$key]['count'] = $var['count'];
$arrayuse[$var['flowsort']]['flowid'][$key]['newcount'] = $var['newcount'];
$arrayuse[$var['flowsort']]['flowid'][$key]['flowtype'] = $var['flowtype'];
}
reset( $arrayflowid );
}
$htmlstr = " <tr>\n <td valign='top'>\n";
$cols = 3;
$colsbyrows = ceil( $totalflowid / $cols );
if ( $colsbyrows < 12 )
{
$colsbyrows = 12;
}
$nowcount = 0;
if ( is_array( $arrayuse ) )
{
while ( list( $key, $var ) = each( $arrayflowid ) )
{
$htmlstr .= " <ul><li><b>".$arraysort['sortname']."</b>\n";
while ( list( $sortid, $arraysort ) = each( $arrayuse ) )
{
++$nowcount;
if ( 0 < $arrayflow['newcount'] )
{
$edHref = "work_list3.php?flow_id_r=".$flowid;
$htmlTrStrNew = " <a style='color:red' href='".$edHref."' title='".$arrayflow['newcount']."条新到事宜'>".$arrayflow['newcount']."</a> <img src='/images/newred.gif' align=absbottom> / ";
}
$edHref = "work_list3.php?flow_id_r=".$flowid;
$htmlstr .= " <ul><li><a href='".$edHref."'>".$arrayflow['flowname']."</a> ( ".$htmlTrStrNew."<a href='".$edHref."'>".$arrayflow['count']."</a> )"." </li></ul>\n";
unset( $htmlTrStrNew );
if ( $nowcount % $colsbyrows == 0 )
{
$htmlstr .= " </li></ul>\n </td>\n <td valign='top'>\n <ul><li>";
}
}
$htmlstr .= " </li></ul>\n";
}
reset( $arrayuse );
}
$htmlstr .= " </td>\n </tr>\n";
$htmlstr = str_replace( "<ul><li> </li></ul>", "", $htmlstr );
$htmlTrHead = " <a href='work_list2.php'>您共有 ( ";
if ( $totalflowrun == 0 )
{
$htmlTrHead .= $totalflowrun;
}
else
{
$htmlTrHead .= "<b>";
$htmlTrHead .= $totalflowrun;
$htmlTrHead .= "</b>";
}
$htmlTrHead .= " ) 待办事宜</a>";
echo "\r\n<br>";
if ( $totalflowrun < 5 )
{
$noteNum = $totalflowrun;
}
else
{
$noteNum = 5;
}
$noteStr = " <img src='/images/green_arrow.gif'> 最近 ( <b>{$noteNum}</b> ) 条待办事宜".$htmlTrHead;
echo $noteStr;
echo "\r\n";
$query = " \r\n SELECT * FROM flow_run_prcs \r\n\t\t WHERE USER_ID='{$LOGIN_USER_ID}' \r\n\t\t\t AND ( (prcs_flag='2' AND SAVEFORM_TIME IS NULL AND OP_FLAG=0) \r\n\t\t\t OR (prcs_flag='2' AND OP_FLAG=1) \r\n\t\t\t\t\tOR prcs_flag='1' \r\n\t\t\t\t ) \r\n\t\t\t ORDER BY RUN_ID DESC LIMIT 0,5";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
$FLOW_COUNT1 = 0;
$FLOW_COUNT2 = 0;
$FLOW_COUNT3 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$FLOW_COUNT;
$RUN_ID = $ROW['RUN_ID'];
$PRCS_ID = $ROW['PRCS_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$OP_FLAG = $ROW['OP_FLAG'];
$query = "SELECT * from FLOW_RUN WHERE RUN_ID={$RUN_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_ID = $ROW['FLOW_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
$RUN_SEQ = $ROW['RUN_SEQ'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_ID != "" )
{
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$FLOW_DOC = "<img src='/general/netdisk/images/defaut.gif' alt='附件：\n";
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
{
$FLOW_DOC .= $ATTACHMENT_NAME_ARRAY[$I]."\n";
}
}
$FLOW_DOC .= "'>";
}
}
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
if ( $FLOW_TYPE == "1" )
{
$FLOW_TYPE_DESC = "固定";
}
else
{
$FLOW_TYPE_DESC = "<b>自由</b>";
}
}
if ( $FLOW_TYPE == "1" )
{
$query = "SELECT * from FLOW_PROCESS WHERE FLOW_ID={$FLOW_ID} AND PRCS_ID={$FLOW_PRCS}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_NAME = "第".$PRCS_ID."步：".$ROW['PRCS_NAME'];
}
}
else
{
$PRCS_NAME = "第".$PRCS_ID."步";
}
if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
{
if ( $totalpr < 5 )
{
$noteNum = $totalpr;
}
else
{
$noteNum = 5;
}
$STATUS = "<b>办理中的工作</b>";
++$FLOW_COUNT2;
}
else
{
$STATUS = "已办结的工作";
++$FLOW_COUNT3;
}
if ( $FLOW_COUNT == 1 )
{
echo " <table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\">\r\n";
}
if ( ( $PRCS_FLAG == "2" || $PRCS_FLAG == "1" ) && $FLOW_COUNT2 == 1 || $PRCS_FLAG == "3" && $FLOW_COUNT3 == 1 )
{
if ( $FLOW_COUNT3 == 1 )
{
echo "<tr>\r\n <td height=\"10\" colspan=\"9\"> </td>\r\n </tr>";
}
echo "\r\n";
if ( $FLOW_COUNT == 1 || $FLOW_COUNT3 == 1 )
{
echo " <tr class=\"TableHeader\">\r\n <td><b>文号</b></td>\r\n <td><b>说明</b></td>\r\n\t <td><b>流程名称</b></td>\r\n <td nowrap><b>步骤</b></td>\r\n <td nowrap><b>办理</b></td>\r\n <td nowrap><b>查看</b></td>\r\n </tr>\r\n";
}
}
if ( $FLOW_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n\t <td>";
echo $RUN_SEQ;
echo "</td>\r\n <td>";
echo $RUN_NAME;
echo " ";
if ( $PRCS_FLAG == 1 )
{
echo "<img src='/images/newred.gif' align=absbottom>";
}
echo "</td>\r\n <td>";
echo $FLOW_NAME;
echo "</td>\r\n <td>";
echo $PRCS_NAME;
echo "</td>\r\n <td nowrap> \r\n";
if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
{
echo " <a href=\"input_form/?RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "&FLOW_PRCS=";
echo $FLOW_PRCS;
echo "&FLOW_TYPE=";
echo $FLOW_TYPE;
echo "\">办理</a> \r\n <a href=\"others/";
if ( $FLOW_TYPE == "1" )
{
echo "others";
}
else
{
echo "others_free";
}
echo ".php?RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "\">委托</a> \r\n";
}
else
{
echo " <a href=\"javascript:call_back(";
echo $RUN_ID;
echo ",";
echo $PRCS_ID;
echo ");\">收回</a> \r\n";
}
echo " </td>\r\n <td nowrap> \r\n\r\n <a href=\"#\" onClick=\"javascript:window.open('print?RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "','FLOW_PRINT','status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes');\">表单</a> \r\n <a href=\"#\" onClick=\"flow_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ")\">流程图</a> \r\n\r\n";
if ( $PRCS_ID == 1 || $LOGIN_USER_ID == "admin" )
{
echo " <a href=\"javascript:delete_run(";
echo $RUN_ID;
echo ");\">";
if ( $PRCS_ID != 1 )
{
echo "admin";
}
echo "删除</a>\r\n";
}
echo " ";
if ( $FLOW_TYPE == "2" )
{
echo " <a href=\"javascript:stop_run(";
echo $RUN_ID;
echo ",";
echo $PRCS_ID;
echo ");\">终止</a> \r\n";
}
echo " </td>\r\n </tr>\r\n";
}
if ( 0 < $FLOW_COUNT )
{
echo " </table>\r\n";
}
else
{
message( "提示", "暂无待办工作" );
}
echo "\r\n\r\n\r\n<br>\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" class=\"tableline1\" >\r\n\r\n";
echo $htmlstr;
echo "</table>\r\n\r\n\r\n\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -