📄 work_list3.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/function_page_01.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\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</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 <tr class=\"tablehead2\">\r\n <td><a href=\"work_list.php\"> <img src=\"/images/button/return.gif\" bor";
echo "der=\"0\" accesskey=\"B\" title=\"返回\"></a> </td>\r\n </tr> \r\n \r\n</table>\r\n<table border=\"0\" width=\"100%\">\r\n<tr height=\"5\"><td></td></tr>\r\n</table>\r\n <table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\">\r\n <tr>\r\n <td height=\"30\" colspan=\"6\"><img src='/images/littlegif/icon_promise.gif'> <b>办理中的工作</b></td>\r\n </tr>\r\n <tr class=\"TableHeader\">\r\n <td><b>文号</b></td>\r\n <td><b>说明</b";
echo "></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\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'].",";
}
$run_id_str = substr( $run_id_str, 0, strlen( $run_id_str ) - 1 );
$run_id_str = $run_id_str ? $run_id_str : 0;
$sqlfrunthis = "SELECT FLOW_ID,RUN_ID FROM flow_run WHERE RUN_ID IN (".$run_id_str.") AND FLOW_ID='".$_REQUEST['flow_id_r']."'";
$rsfrunthis = exequery( $connection, $sqlfrunthis );
while ( $rowfrunthis = mysql_fetch_array( $rsfrunthis ) )
{
$run_id_str_this .= $rowfrunthis['RUN_ID'].",";
}
$run_id_str_this = substr( $run_id_str_this, 0, strlen( $run_id_str_this ) - 1 );
$run_id_str_this = $run_id_str_this ? $run_id_str_this : 0;
$query = "\r\nSELECT * 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 AND RUN_ID IN (".$run_id_str_this.")\r\n\t\t\t\t ORDER BY RUN_ID DESC\r\n \r\n ";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
$FLOW_COUNT_R = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
if ( $FLOW_COUNT_R == 1 )
{
$FLOW_COUNT_R = 99;
}
$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."步";
}
echo "\r\n\r\n\r\n\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";
}
echo "\r\n</table>\r\n\r\n<table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n <tr>\r\n <td align=\"right\">";
disp( "flow_id_r=".$_REQUEST['flow_id_r'] );
echo "</td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -