📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "../prcs_role.php" );
if ( $FLOW_ID != "" )
{
header( "location: query.php?FLOW_ID=".$FLOW_ID."&MENU_FLAG=1" );
exit( );
}
$perPage = $_COOKIE['flow_query'] ? $_COOKIE['flow_query'] : 10;
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<link rel=\"stylesheet\" type=\"text/css\" href=\"/inc/js/jquery/page/css/page.css\"/>\r\n<style>\r\n.tip {position:absolute;display:none;text-align:center;font-size:9pt;font-weight:bold;z-index:65535;background-color:#DE7293;color:white;padding:5px}\r\n</style>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/jquery.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/page/page.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/utility.js\"></script>\r\n<script src=\"/inc/js/utility.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script src=\"/inc/js/module.js\"></script>\r\n<script src=\"/inc/sort_table.js\"></script>\r\n<script>\r\nfunction my_query()\r\n{\r\n\tvar para={\r\n\t\tFLOW_STATUS: jQuery(\"select[name='FLOW_STATUS']\").val(),\r\n\t\tFLOW_ID: jQuery(\"select[name='FLOW_ID']\").val(),\r\n FLOW_QUERY_TYPE: jQuery(\"select[name='FLOW_QUERY_TYPE']\").val(),\r\n TO_ID: jQuery(\"input[name='TO_ID']\").val()==''?'':jQuery(\"input[name='TO_ID']\").val(),\r\n PRCS_DATE1: jQuery(\"input[name='PRCS_DATE1']\").val()==''?'':jQuery(\"input[name='PRCS_DATE1']\").val(),\r\n PRCS_DATE2: jQuery(\"input[name='PRCS_DATE2']\").val()==''?'':jQuery(\"input[name='PRCS_DATE2']\").val(),\r\n RUN_ID: jQuery(\"input[name='RUN_ID']\").val()==''?'':jQuery(\"input[name='RUN_ID']\").val(),\r\n RUN_NAME: jQuery(\"input[name='RUN_NAME']\").val()==''?'':jQuery(\"input[name='RUN_NAME']\").val()\r\n };\r\n \t\r\n\tjQuery.ajax({\r\n\t\t url: \"getData.php?act=count\",\r\n\t\t type: \"get\",\r\n\t\t data: para,\r\n\t\t beforeSend: function(XMLHttpRequest){\r\n jQuery('<div class=\"tip\" id=\"loading\">数据加载中......</div>')\r\n \t\t\t\t\t\t .after(\"#queryBtn\")\r\n \t\t\t\t\t\t .fadeIn('slow')\r\n \t\t\t\t\t\t .animate({opacity: 1.0}, 3000);\r\n },\t\t\t\t\t \r\n\t success: function(data,textStatus){\r\n\t \t jQuery(\"#blank\").remove();\r\n\t \t jQuery(\"#tip\").remove();\r\n\t \t if(data!=0)\r\n\t \t {\r\n\t \t \t jQuery(\"#sorry\").hide();\r\n\t \t \t jQuery(\"#pagebar\").jpage({dataBody:\"content\",totalRecord:data,perPage:";
echo $perPage;
echo ",ajaxUrl:\"getData.php\",ajaxParam:para,callback:function(){SortTable('flow_table');},cookieName:\"flow_query\"}); \r\n }\r\n else\r\n {\r\n \t jQuery(\"#pagebar\").empty();\r\n \t jQuery(\"#content\").empty();\r\n \t jQuery(\"#sorry\").show();\r\n }\r\n },\r\n complete: function(XMLHttpRequest, textStatus){\r\n\t jQuery(\"#loading\").remove();\r\n }\r\n });\r\n}\r\nfunction CheckSend()\r\n{\r\n if(event.keyCode==13)\r\n my_query();\r\n}\r\nfunction form_view(RUN_ID,FLOW_ID)\r\n{\r\n window.open(\"../list/print?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=\"+(screen.availWidth-12)+\",height=\"+(screen.availHeight-38)+\",location=no,scrollbars=yes,resizable=yes,left=0,top=0\");\r\n}\r\n\r\nfunction comment(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-550)/2;\r\n mytop=(screen.availHeight-200)/2;\r\n window.open(\"../list/comment.php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"comment\",\"status=0,toolbar=no,menubar=no,width=550,height=200,location=no,scrollbars=yes,resizable=no,left=\"+myleft+\",top=\"+mytop);\r\n}\r\n\r\nfunction call_back(RUN_ID,PRCS_ID,FLOW_PRCS)\r\n{\r\n msg=\"下一步骤尚未接收时可收回至本步骤重新办理，确认要收回么？\";\r\n if(window.confirm(msg))\r\n {\r\n var url=\"../list/call_back.php?FLOW_ID=";
echo $FLOW_ID;
echo "&MENU_FLAG=";
echo $MENU_FLAG;
echo "&RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS;\r\n jQuery.get(url,{},function(data){\r\n \tif(data==1)\r\n \t showTip('<div class=\"tip\" id=\"loading\">您没有权限！</div>');\r\n \telse if(data==2)\r\n \t\t showTip('<div class=\"tip\" id=\"loading\">对方已接收，不能收回</div>');\r\n else\r\n {\r\n \t showTip('<div class=\"tip\" id=\"loading\">工作已回收</div>');\r\n \t jQuery(\"#\"+RUN_ID+\"_back\").remove();\r\n }\r\n });\r\n }\r\n}\r\n\r\nfunction others(FLOW_ID,RUN_ID,PRCS_ID,FLOW_PRCS,FLOW_TYPE)\r\n{\r\n\t//popBox({url:\"../list/others/\"+page+\".php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS\",w:700,h:450,callback:})\r\n\tvar page;\r\n\tif(FLOW_TYPE==1)\r\n\t page=\"others\";\r\n\telse\r\n\t\t page=\"others_free\";\t\t \r\n myleft=(screen.availWidth-700)/2;\r\n mytop=(screen.availHeight-450)/2;\r\n window.open(\"../list/others/\"+page+\".php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS,\"others\",\"status=0,toolbar=no,menubar=no,width=700,height=450,location=no,scrollbars=yes,resizable=no,left=\"+myleft+\",top=\"+mytop);\r\n}\r\n\r\nfunction flow_view(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-800)/2;\r\n mytop=(screen.availHeight-600)/2;\r\n window.open(\"../list/flow_view?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,RUN_ID,\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=600,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 jQuery(\"#allbox_for\").attr(\"checked\", false); \r\n}\r\n\r\nfunction check_all()\r\n{\r\n if(jQuery(\"#allbox_for\").attr(\"checked\")==true)\r\n \tjQuery(\"input[@name='run_select']\").each(function(){jQuery(this).attr(\"checked\", true);});\r\n else\r\n jQuery(\"input[@name='run_select']\").each(function(){jQuery(this).attr(\"checked\", false);});\r\n}\r\n\r\nfunction get_run_str()\r\n{\r\n var run_str=\"\";\r\n jQuery(\"input[@name='run_select']\").each(function(){\r\n \tif(jQuery(this).attr(\"checked\")==true)\r\n \t run_str+=jQuery(this).val()+\",\";\r\n \t});\r\n run_str=run_str.substr(0,run_str.length-1);\r\n return run_str;\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 var run_str=get_run_str();\r\n \t if(run_str==\"\")\r\n {\r\n alert(\"要删除工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n jQuery.get(\"../list/delete.php\",{\"RUN_ID_STR\":run_str},function(data)\r\n {\r\n \tif(data==run_str)\r\n \t\t showTip('<div class=\"tip\" id=\"loading\">所选流程已全部删除</div>');\r\n else\r\n showTip('<div class=\"tip\" id=\"loading\">部分未删除</div>');\r\n if(data!='')\r\n {\r\n \tvar tmp=data.split(\",\");\r\n for(var i=0;i<tmp.length;i++)\r\n jQuery(\"#\"+tmp[i]).remove();\r\n }\r\n if(jQuery(\"#flow_table tbody>tr\").length==0)\r\n jQuery(\"#flow_table\").remove();\r\n });\r\n }\r\n}\r\nfunction restore_run(RUN_ID)\r\n{\r\n msg=\"确认要将此工作恢复到执行中么？\";\r\n if(window.confirm(msg))\r\n {\r\n var url=\"restore.php?RUN_ID=\"+RUN_ID;\r\n jQuery.get(url,{},function(data){\r\n \t showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n \t jQuery(\"#\"+RUN_ID+\"_a2\").remove();\r\n \t jQuery(\"#\"+RUN_ID+\"_a3\").remove();\r\n \t jQuery(\"#\"+RUN_ID+\" :nth-child(6)\").html(\"<font color=red>执行中</font>\");\r\n });\r\n }\r\n}\r\n\r\nfunction check_form()\r\n{\r\n if(document.form1.FLOW_QUERY_TYPE.value==5 && document.form1.TO_ID.value==\"\")\r\n {\r\n alert(\"请指定人员！\");\r\n return false;\r\n }\r\n if(document.form1.FLOW_QUERY_TYPE.value!=5)\r\n document.form1.TO_ID.value=\"\";\r\n my_query();\r\n}\r\n\r\nfunction empty_date()\r\n{\r\n\t document.form1.PRCS_DATE1.value=\"\";\r\n\t document.form1.PRCS_DATE2.value=\"\";\r\n}\r\nfunction set_user()\r\n{\r\n if(document.form1.FLOW_QUERY_TYPE.value==5)\r\n SET_USER.style.display=\"inline\";\r\n else\r\n SET_USER.style.display=\"none\";\r\n}\r\nfunction focus_dom(RUN_ID,OP)\r\n{\r\n var obj=document.getElementById(RUN_ID+\"_a1\");\r\n if(OP)\r\n {\r\n obj.innerHTML=\"取消关注\";\r\n obj.href=\"javascript:focus_run(\"+RUN_ID+\",0);\";\r\n }\r\n else\r\n {\r\n obj.innerHTML=\"关注\";\r\n obj.href=\"javascript:focus_run(\"+RUN_ID+\",1);\";\r\n }\r\n}\r\nfunction focus_run(RUN_ID,OP)\r\n{ \r\n\tvar OP_DESC=OP==1?\"关注\":\"取消关注\";\r\n var msg=\"确认要\"+OP_DESC+\"此工作么？\";\r\n if(window.confirm(msg))\r\n {\r\n jQuery.get(\"../list/focus.php\",{\"RUN_ID\":RUN_ID,\"OP\":OP},function(data)\r\n {\r\n \t showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n focus_dom(RUN_ID,OP);\r\n });\r\n }\r\n}\r\nfunction export_run_sel()\r\n{\r\n\tvar run_str=get_run_str();\r\n if(run_str==\"\")\r\n {\r\n alert(\"要导出工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n window.location=\"excel_data.php?FLOW_ID=\"+jQuery(\"select[name='FLOW_ID']\").val()+\"&RUN_ID_STR=\"+run_str;\r\n}\r\nfunction zip_run_sel()\r\n{\r\n\tvar run_str=get_run_str();\r\n\tif(run_str==\"\")\r\n {\r\n alert(\"要导出工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n window.location=\"export_zip.php?RUN_ID_STR=\"+run_str;\r\n}\r\n\r\nfunction end_run()\r\n{\r\n msg=\"确认要强制结束所选工作么？\";\r\n if(window.confirm(msg))\r\n {\r\n\t var run_str=get_run_str();\r\n\t if(run_str==\"\")\r\n\t {\r\n alert(\"要结束工作，请至少选择其中一项。\");\r\n return;\r\n }\r\n jQuery.get(\"end.php\",{\"RUN_ID_STR\":run_str},function(data)\r\n {\r\n \t showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n \t var tmp=run_str.split(\",\");\r\n for(var i=0;i<tmp.length;i++)\r\n \tjQuery(\"#\"+tmp[i]+\" :nth-child(6)\").html(\"已结束\");\r\n \r\n \t });\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"0\" leftmargin=\"0\" onload=\"document.form1.RUN_ID.focus();\">\r\n\r\n<table class=\"TableList\" border=\"0\" width=\"100%\">\r\n<form name=\"form1\">\r\n <tr class=\"TableContent\">\r\n <td colspan=2>\r\n 流程<select name=\"FLOW_ID\" class=\"SmallSelect\" style=\"width:180px\">\r\n \t<option value=0>所有流程类型</option>\r\n";
$query = "SELECT * from FLOW_TYPE,FLOW_SORT where FLOW_TYPE.FLOW_SORT=FLOW_SORT.SORT_ID order by SORT_NO,FLOW_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$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'];
if ( $FLOW_TYPE == "1" && !prcs_role( $FLOW_ID, 0 ) || !( $LOGIN_USER_PRIV != "1" ) || !find_id( $MANAGE_USER, $LOGIN_USER_ID ) || !find_id( $QUERY_USER, $LOGIN_USER_ID ) )
{
}
else
{
echo " <option value=\"";
echo $FLOW_ID;
echo "\">";
echo $FLOW_NAME;
echo "</option>\r\n";
}
}
echo " </select>\r\n 状态<select name=\"FLOW_STATUS\" class=\"SmallSelect\">\r\n <option value=\"ALL\">所有状态</option>\r\n <option value=\"0\">正在执行</option>\r\n <option value=\"1\">已经结束</option>\r\n </select>\r\n 范围<select name=\"FLOW_QUERY_TYPE\" class=\"SmallSelect\" onchange=\"set_user();\">\r\n <option value=\"ALL\">所有范围</option>\r\n <option value=\"1\">我发起的</option>\r\n <option value=\"2\" selected>我经办的</option>\r\n <option value=\"3\" >我管理的</option>\r\n <option value=\"4\" >我关注的</option>\r\n <option value=\"5\" >指定发起人</option>\r\n </select>\r\n <div id=\"SET_USER\" style=\"display:none\">\r\n <input type=\"text\" name=\"TO_NAME\" size=\"10\" class=\"SmallStatic\" style=\"vertical-align: top;\" readonly>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUserSingle('','TO_ID', 'TO_NAME')\">选择</a>\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"\">\r\n </div>\r\n <div style=\"margin-top:3px\">从<input type=\"text\" name=\"PRCS_DATE1\" size=\"10\" class=\"SmallInput\" value=\"";
echo $YEAR_DATE;
echo "\"><img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:pointer;vertical-align:middle;\" onclick=\"td_calendar('form1.PRCS_DATE1');\">至<input type=\"text\" name=\"PRCS_DATE2\" size=\"10\" class=\"SmallInput\"><img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:pointer;vertical-align:middle;\" onclick=\"td_calendar('form1.PRCS_DATE2');\">\r\n <a href=\"javascript:empty_date()\">清空</a>\r\n 流水号<input type=\"text\" name=\"RUN_ID\" size=\"6\" class=\"SmallInput\" onkeypress=\"CheckSend()\"> \r\n 名称/文号<input type=\"text\" name=\"RUN_NAME\" size=\"20\" class=\"SmallInput\"></div>\r\n </td>\r\n <td align=\"right\">\r\n <input id=\"queryBtn\" type=\"button\" onclick=\"check_form();\" class=\"BigButton\" value=\"开始查询\">\r\n <input type=\"button\" class=\"BigButton\" onClick=\"location.href='flow_list.php';\" title=\"工作流高级查询,允许设定复杂查询条件\" value=\"高级查询\"> \r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n<div id=\"pagebar\" style=\"margin-top:5px\"></div>\r\n";
if ( $LOGIN_USER_PRIV == "1" )
{
echo "<div id=\"tip\" class=small1 style=\"position: absolute;left:0;bottom:3px;width:100%;height:18px;border:1px #606275 solid;background:#F0F0F0;\">\r\n<img src=\"/images/attention.gif\" height=\"18\" align=\"absmiddle\"> 管理员提示：经办人可以查询自己经办的工作，监控人和查询人可查询该流程所有工作，系统管理员可以查询所有工作\r\n</div>\r\n";
}
echo "<div id=\"content\">\r\n\t<iframe id=\"blank\" width=\"100%\" src=\"blank.php\" frameborder=0 height=\"80%\"></iframe>\r\n</div>\r\n<div id=\"sorry\" style=\"display:none\" align=\"center\">\r\n";
message( "", "没有检索到数据！" );
echo "</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -