?? search.php
字號:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.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<style>\r\na.op, a.delete {\r\n\tborder-bottom: none;\r\n\tdisplay: inline;\r\n\tpadding: 2px;\r\n\ttext-align: center;\r\n}\r\na.op:hover{\r\n\tbackground: #06c;\r\n\tcolor: #fff;\r\n\ttext-decoration:none;\r\n}\r\na.delete:hover {\r\n\tbackground: #c00;\r\n\tcolor: #fff;\r\n\ttext-decoration:none;\r\n}\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:10px}\r\n</style>\r\n<script src=\"/inc/sort_table.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/jquery.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/utility.js\"></script>\r\n<script>\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-800)/2;\r\n mytop=(screen.availWidth-600)/2;\r\n window.open(\"../list/comment.php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=550,height=180,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 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=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 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\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=\"確認要將此工作恢復到執(zhí)行中么？\";\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>執(zhí)行中</font>\");\r\n });\r\n }\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\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\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 document.form1.action=\"excel_data.php\";\r\n document.form1.RUN_ID_STR.value=run_str;\r\n document.form1.submit();\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 document.form1.action=\"export_zip.php\";\r\n document.form1.RUN_ID_STR.value=run_str;\r\n document.form1.submit();\r\n}\r\n\r\n\r\nfunction export_list_view()\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 document.form1.action=\"excel_list_view.php\";\r\n document.form1.RUN_ID_STR.value=run_str;\r\n document.form1.LIST_VIEW_STR.value=LIST_VIEW.value;\r\n document.form1.submit();\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).remove();\r\n }\r\n });\r\n }\r\n}\r\n\r\nfunction restore_run(RUN_ID)\r\n{\r\n msg=\"確認要將此工作恢復到執(zhí)行中么？\";\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>執(zhí)行中</font>\");\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\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</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" style=\"position:realtive;\" topmargin=\"5\" leftmargin=0 onload=\"SortTable('flow_table')\">\r\n<img src=\"/images/menu/infofind.gif\" align=\"absmiddle\"><span class=\"big3\"> 工作查詢結果 ";
echo $FLOW_NAME;
echo "</span>\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;
}
$query = "SELECT * from FLOW_TYPE,FLOW_RUN WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.DEL_FLAG=0";
if ( $FLOW_ID_GLOBAL )
{
$query_add .= " and FLOW_TYPE.FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
$query_add .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
$FIELDVALUE = $RUN_NAME;
$WHERE_STR = " and RUN_NAME";
switch ( $RUN_NAME_RELATION )
{
case 1 :
$WHERE_STR .= "='".$FIELDVALUE."'";
break;
case 2 :
$WHERE_STR .= ">'".$FIELDVALUE."'";
break;
case 3 :
$WHERE_STR .= "<'".$FIELDVALUE."'";
break;
case 4 :
$WHERE_STR .= ">='".$FIELDVALUE."'";
break;
case 5 :
$WHERE_STR .= "<='".$FIELDVALUE."'";
break;
case 6 :
$WHERE_STR .= "!='".$FIELDVALUE."'";
break;
case 7 :
$WHERE_STR .= " like '".$FIELDVALUE."%'";
break;
case 8 :
$WHERE_STR .= " like '%".$FIELDVALUE."%'";
break;
case 9 :
$WHERE_STR .= " like '%".$FIELDVALUE."'";
break;
$WHERE_STR .= " like '%".$FIELDVALUE."%'";
}
$query_add .= $WHERE_STR;
}
if ( $ATTACHMENT_NAME != "" )
{
$query_add .= " and ATTACHMENT_NAME like '%".$ATTACHMENT_NAME."%'";
}
$query .= $query_add;
if ( !( $FLOW_QUERY_TYPE == "ALL" ) && $LOGIN_USER_PRIV != 1 || $FLOW_QUERY_TYPE == "2" )
{
$query_my = "select FLOW_RUN.RUN_ID from FLOW_TYPE,FLOW_RUN,FLOW_RUN_PRCS where FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID AND FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID AND USER_ID='".$LOGIN_USER_ID."' and PRCS_FLAG<>5";
$query_my .= $query_add." GROUP BY FLOW_RUN.RUN_ID";
$cursor = exequery( $connection, $query_my );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$MY_RUN_ID .= $ROW['RUN_ID'].",";
}
if ( $MY_RUN_ID != "" )
{
$MY_RUN_ID = substr( $MY_RUN_ID, 0, -1 );
}
else
{
$MY_RUN_ID = "0";
}
}
if ( $PRCS_DATE1 != "" )
{
$query .= " and BEGIN_TIME>='".$PRCS_DATE1." 00:00:00'";
}
if ( $PRCS_DATE2 != "" )
{
$query .= " and BEGIN_TIME<='".$PRCS_DATE2." 23:59:59'";
}
if ( $FLOW_QUERY_TYPE == "ALL" && $LOGIN_USER_PRIV != 1 )
{
$query .= " and (FLOW_RUN.RUN_ID in (".$MY_RUN_ID.") or MANAGE_USER like '%,{$LOGIN_USER_ID},%' or MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
}
else if ( $FLOW_QUERY_TYPE == "1" )
{
$BEGIN_USER = $LOGIN_USER_ID;
}
else if ( $FLOW_QUERY_TYPE == "2" )
{
$query .= " and FLOW_RUN.RUN_ID in (".$MY_RUN_ID.")";
}
else if ( $FLOW_QUERY_TYPE == "3" && $LOGIN_USER_PRIV != 1 )
{
$query .= " and (MANAGE_USER like '%,".$LOGIN_USER_ID.",%' or MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
}
else if ( $FLOW_QUERY_TYPE == "4" )
{
$query .= " and find_in_set('".$LOGIN_USER_ID."',FOCUS_USER)";
}
else if ( $FLOW_QUERY_TYPE == "5" )
{
if ( $LOGIN_USER_PRIV != 1 )
{
$query .= " and (MANAGE_USER like '%,".$LOGIN_USER_ID.",%' or MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
}
$BEGIN_USER = $TO_ID;
}
else if ( $LOGIN_USER_PRIV != 1 )
{
exit( );
}
if ( $FLOW_STATUS != "ALL" )
{
if ( $FLOW_STATUS == "0" )
{
$query .= " and FLOW_RUN.END_TIME is null";
}
else
{
$query .= " and FLOW_RUN.END_TIME is not null";
}
}
if ( $BEGIN_USER != "" )
{
$query .= " and BEGIN_USER='".$BEGIN_USER."'";
}
$query .= " 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'];
$BEGIN_TIME = $ROW['BEGIN_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'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$COMMENT_PRIV = $ROW['COMMENT_PRIV'];
$FOCUS_USER = $ROW['FOCUS_USER'];
$END_TIME = $ROW['END_TIME'];
$EDIT_PRIV = $ROW['EDIT_PRIV'];
$NOT_FOUND = 0;
$I = 1;
for ( ; $I <= $ITEM_ID_MAX; ++$I )
{
$STR = "DATA_".$I;
$FIELDVALUE = $$STR;
$STR = "RELATION_".$I;
$RELATION = $$STR;
if ( $FIELDVALUE != "" && !( $FIELDVALUE != "SELECT_ALL_VALUE" ) || !( $RELATION == 10 ) )
{
continue;
}
if ( $FIELDVALUE == "CHECKBOX_ON" )
{
$FIELDVALUE = "on";
}
else if ( $FIELDVALUE == "CHECKBOX_OFF" )
{
$FIELDVALUE = "";
}
$WHERE_STR = " where RUN_ID='".$RUN_ID."' and ITEM_ID={$I} and ITEM_DATA";
switch ( $RELATION )
{
case 1 :
$WHERE_STR .= "='".$FIELDVALUE."'";
break;
case 2 :
if ( is_numeric( $FIELDVALUE ) )
{
$WHERE_STR .= ">".$FIELDVALUE."";
}
else
{
$WHERE_STR .= ">'".$FIELDVALUE."'";
}
break;
case 3 :
if ( is_numeric( $FIELDVALUE ) )
{
$WHERE_STR .= "<".$FIELDVALUE."";
}
else
{
$WHERE_STR .= "<'".$FIELDVALUE."'";
}
break;
case 4 :
if ( is_numeric( $FIELDVALUE ) )
{
$WHERE_STR .= ">=".$FIELDVALUE."";
}
else
{
$WHERE_STR .= ">='".$FIELDVALUE."'";
}
break;
case 5 :
if ( is_numeric( $FIELDVALUE ) )
{
$WHERE_STR .= "<=".$FIELDVALUE."";
}
else
{
$WHERE_STR .= "<='".$FIELDVALUE."'";
}
break;
case 6 :
$WHERE_STR .= "!='".$FIELDVALUE."'";
break;
case 7 :
$WHERE_STR .= " like '".$FIELDVALUE."%'";
break;
case 8 :
$WHERE_STR .= " like '%".$FIELDVALUE."%'";
break;
case 9 :
$WHERE_STR .= " like '%".$FIELDVALUE."'";
break;
case 10 :
$WHERE_STR .= "=''";
}
$query1 = "select 1 from FLOW_RUN_DATA".$WHERE_STR." limit 1";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
continue;
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -