📄 search.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../prcs_role.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\r\n<script src=\"/inc/sort_table.js\"></script>\r\n<script>\r\nfunction form_view(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-800)/2;\r\n window.open(\"../list/print?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=800,height=600,location=no,scrollbars=yes,resizable=yes,left=\"+myleft+\",top=50\");\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(\"../list/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,width=600,height=400,left=\"+myleft+\",top=100\");\r\n}\r\n\r\nfunction edit_run(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-800)/2;\r\n window.open(\"../list/input_form?RUN_ID=\"+RUN_ID+\"&MENU_FLAG=";
echo $MENU_FLAG;
echo "&EDIT_MODE=1&FLOW_ID=\"+FLOW_ID,\"edit_run\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=600,left=\"+myleft+\",top=50\");\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction check_all()\r\n{\r\n if(document.all(\"allbox\").checked)\r\n check_flag=1;\r\n else\r\n check_flag=0;\r\n\r\n for (i=0;i<document.all(\"run_select\").length;i++)\r\n {\r\n if(check_flag)\r\n document.all(\"run_select\").item(i).checked=true;\r\n else\r\n document.all(\"run_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(check_flag)\r\n document.all(\"run_select\").checked=true;\r\n else\r\n document.all(\"run_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction get_run_str()\r\n{\r\n var run_str=\"\";\r\n if(document.all(\"allbox\").checked)\r\n {\r\n document.form1.RUN_ID_STR.value=document.form1.RUN_ID_STR_ALL.value;\r\n return true;\r\n }\r\n\r\n for(i=0;i<document.all(\"run_select\").length;i++)\r\n {\r\n el=document.all(\"run_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n run_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"run_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n run_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(run_str==\"\")\r\n return false;\r\n else\r\n {\r\n document.form1.RUN_ID_STR.value=run_str;\r\n return true;\r\n }\r\n}\r\n\r\nfunction delete_run_sel()\r\n{\r\n msg=\"确认要删除所选工作么？\";\r\n if(window.confirm(msg))\r\n {\r\n \t if(!get_run_str())\r\n {\r\n alert(\"要还原工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n\r\n document.form1.OP.value=2;\r\n document.form1.action=\"delete.php\";\r\n document.form1.submit();\r\n }\r\n}\r\n\r\nfunction export_run_sel()\r\n{\r\n if(!get_run_str())\r\n {\r\n alert(\"要销毁工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n\r\n document.form1.OP.value=1;\r\n document.form1.action=\"delete.php\";\r\n document.form1.submit();\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"SortTable('flow_table')\">\r\n\r\n";
if ( $FLOW_ID != "" )
{
$query = "SELECT FLOW_NAME from FLOW_TYPE WHERE FLOW_ID='".$FLOW_ID."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
}
$FLOW_ID_GLOBAL = 1;
}
if ( !$QUERY_SMALL )
{
echo "<img src=\"/images/menu/infofind.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 工作查询结果 ";
echo $FLOW_NAME;
echo "</span>\r\n";
}
$query = "SELECT FLOW_RUN.RUN_ID,RUN_NAME,PRCS_TIME,FLOW_TYPE.FLOW_ID,FLOW_PRCS,FLOW_NAME,FLOW_TYPE,USER_ID,MANAGE_USER,QUERY_USER,QUERY_FLAG,ATTACHMENT_ID,ATTACHMENT_NAME from FLOW_TYPE,FLOW_RUN,FLOW_RUN_PRCS WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID";
if ( $FLOW_ID_GLOBAL )
{
$query .= " and FLOW_TYPE.FLOW_ID='".$FLOW_ID."'";
}
if ( $BEGIN_RUN_ID != "" )
{
$query .= " and FLOW_RUN.RUN_ID>='".$BEGIN_RUN_ID."'";
}
if ( $END_RUN_ID != "" )
{
$query .= " and FLOW_RUN.RUN_ID<='".$END_RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
$query .= " and RUN_NAME like '%".$RUN_NAME."%'";
}
if ( $BEGIN_DATE != "" )
{
$query .= " and PRCS_TIME>='".$BEGIN_DATE." 00:00:00'";
}
if ( $END_DATE != "" )
{
$query .= " and PRCS_TIME<='".$END_DATE." 23:59:59'";
}
$query_global = $query;
if ( $COPY_TO_ID != "" )
{
$query .= " and find_in_set(USER_ID,'".$COPY_TO_ID."')";
}
$query_run = $query_global;
$cursor = exequery( $connection, $query_run );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$STATUS_RUN .= $ROW['RUN_ID'].",";
}
if ( $STATUS_RUN != "" )
{
$STATUS_RUN = substr( $STATUS_RUN, 0, -1 );
}
else
{
$STATUS_RUN = 0;
}
if ( $FLOW_STATUS != "ALL" )
{
if ( $FLOW_STATUS == 0 )
{
$query .= " and FLOW_RUN.RUN_ID in (".$STATUS_RUN.")";
}
else
{
$query .= " and FLOW_RUN.RUN_ID not in (".$STATUS_RUN.")";
}
}
if ( $TO_ID != "" )
{
$query .= " and USER_ID='".$TO_ID."'";
}
$query .= " and PRCS_ID=1 and DELETE_FLAG='1' order by FLOW_RUN.RUN_ID desc";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW['RUN_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$FLOW_ID = $ROW['FLOW_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$MANAGE_USER = $ROW['MANAGE_USER'];
$QUERY_USER = $ROW['QUERY_USER'];
$QUERY_FLAG = $ROW['QUERY_FLAG'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$USER_ID = $ROW['USER_ID'];
$query = "SELECT USER_ID,FLOW_PRCS,PRCS_ID from FLOW_RUN_PRCS,FLOW_RUN WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and PRCS_FLAG in('1','2','4')and OP_FLAG=1";
if ( $FLOW_ID != "ALL" )
{
$query .= " and FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
$query .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
$query .= " group by FLOW_RUN_PRCS.RUN_ID,PRCS_ID order by PRCS_TIME DESC";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW['USER_ID'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$PRCS_ID = $ROW['PRCS_ID'];
}
$query = "SELECT DEPT_ID FROM USER WHERE USER_ID='".$USER_ID."'";
$cursor2 = exequery( $connection, $query );
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$DEPT_ID = $ROW2['DEPT_ID'];
}
if ( $QUERY_FLAG == 1 && $LOGIN_DEPT_ID != $DEPT_ID )
{
continue;
}
$query = "SELECT USER_NAME from USER WHERE USER_ID='".$USER_ID."' limit 1";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW['USER_NAME'];
}
if ( $FLOW_TYPE == "1" )
{
$query = "SELECT PRCS_NAME,TIME_OUT from FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID." AND PRCS_ID={$FLOW_PRCS} limit 1";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_NAME = "第".$PRCS_ID."步：".$ROW['PRCS_NAME'];
$TIME_OUT = $ROW['TIME_OUT'];
}
}
else
{
$PRCS_NAME = "第".$PRCS_ID."步";
}
if ( $FLOW_STATUS == "ALL" )
{
if ( find_id( $STATUS_RUN, $RUN_ID ) )
{
$STATUS = "<font color=red>执行中</font>";
}
else
{
$STATUS = "已结束";
}
}
else if ( $FLOW_STATUS == "0" )
{
$STATUS = "<font color=red>执行中</font>";
}
else
{
$STATUS = "已结束";
}
if ( $STATUS == "已结束" )
{
$PRCS_OVER = 1;
}
else
{
$PRCS_OVER = 0;
}
$query1 = "SELECT PRCS_ID,PRCS_FLAG,FLOW_PRCS,OP_FLAG from FLOW_RUN_PRCS WHERE RUN_ID='".$RUN_ID."' AND USER_ID='{$LOGIN_USER_ID}' and PRCS_FLAG<>'4' order by PRCS_FLAG limit 1";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRCS_ID = $ROW['PRCS_ID'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$OP_FLAG = $ROW['OP_FLAG'];
}
else
{
$PRCS_FLAG = "";
}
++$FLOW_COUNT;
$RUN_ID_STR .= $RUN_ID.",";
if ( $FLOW_COUNT == 1 )
{
echo " <table id=\"flow_table\" border=\"1\" bordercolor=\"#000000\" style=\"border-collapse:collapse\" cellspacing=\"0\" width=\"100%\" class=\"small\" cellpadding=\"3\" align=\"center\">\r\n <tr class=\"TableHeader\">\r\n \t<td nowrap align=\"center\">选择</td>\r\n <td nowrap align=\"center\"><a href=\"#\">流水号</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">工作名称/文号</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">开始时间</a></td>\r\n <td nowrap align=\"center\"><a href=\"#\">公共附件</a></td>\r\n <td nowrap align=\"center\">当前步骤</td>\r\n <td nowrap align=\"center\">当前主办人</td>\r\n <td nowrap align=\"center\"><a href=\"#\">状态</a></td>\r\n <td nowrap align=\"center\">操作</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 nowrap align=\"center\">\r\n \t\t<input type=\"checkbox\" name=\"run_select\" value=\"";
echo $RUN_ID;
echo "\" onClick=\"check_one(self);\">\r\n \t</td>\r\n <td nowrap align=\"center\" class=\"TableContent\"><b>";
echo $RUN_ID;
echo "</b></td>\r\n <td>\r\n <a href=\"javascript:form_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ");\">";
echo $RUN_NAME;
echo "</a>\r\n </td>\r\n <td align=\"center\">";
echo $PRCS_TIME;
echo "</td>\r\n <td>\r\n";
if ( $ATTACHMENT_ID == "" )
{
echo "无";
}
else
{
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, "" );
}
echo " </td>\r\n <td>";
echo $PRCS_NAME;
echo "</td>\r\n <td align=\"center\" nowrap>";
echo $USER_NAME;
echo "</td>\r\n <td align=\"center\" nowrap>";
echo $STATUS;
echo "</td>\r\n <td nowrap>\r\n <a href=\"javascript:flow_view(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ")\">流程图</a> \r\n </td>\r\n </tr>\r\n";
if ( !( $QUERY_LIMIT != "" ) && !( $QUERY_LIMIT <= $FLOW_COUNT ) )
{
continue;
}
break;
}
if ( 0 < $FLOW_COUNT )
{
echo "</table>";
if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
{
echo " <table border=\"0\" cellspacing=\"0\" width=\"100%\" class=\"small\" cellpadding=\"3\" align=\"center\">\r\n <tr class=\"TableControl\">\r\n <td colspan=\"10\">\r\n \t <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\" style=\"cursor:hand;color:blue\"><u><b>全选</b></u></label> \r\n <input type=\"button\" value=\"销毁\" class=\"SmallButton\" onClick=\"export_run_sel();\" title=\"销毁已删除的工作\"> \r\n <input type=\"button\" value=\"还原\" class=\"SmallButton\" onClick=\"delete_run_sel();\" title=\"还原已删除的工作\"> \r\n </td></tr>\r\n </table>\r\n";
}
message( "", "共 ".$FLOW_COUNT." 条" );
echo "<script>\r\nfunction excel_data()\r\n{\r\n \tdocument.form1.RUN_ID_STR.value=document.form1.RUN_ID_STR_ALL.value;\r\n \tdocument.form1.action=\"excel_data.php\";\r\n document.form1.submit();\r\n}\r\n</script>\r\n\r\n";
}
else
{
message( "", "无符合条件的工作" );
}
if ( !$QUERY_SMALL )
{
button_back( );
}
else
{
echo " <div align=center><input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\"></div>\r\n";
}
echo "\r\n<form action=\"\" method=\"post\" name=\"form1\">\r\n <input type=\"hidden\" value=\"";
echo $FLOW_ID;
echo "\" name=\"FLOW_ID\">\r\n <input type=\"hidden\" value=\"\" name=\"RUN_ID_STR\">\r\n \t<input type=\"hidden\" name=\"OP\" value=1>\r\n <input type=\"hidden\" value=\"";
echo $RUN_ID_STR;
echo "\" name=\"RUN_ID_STR_ALL\">\r\n <input type=\"hidden\" value=\"\" name=\"QUERY_FLAG\">\r\n <input type=\"hidden\" value=\"\" name=\"LIST_VIEW_STR\">\r\n</form>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -