?? 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.action=\"../list/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.action=\"excel_data.php\";\r\n document.form1.submit();\r\n}\r\n\r\nfunction export_list_view()\r\n{\r\n if(!get_run_str())\r\n {\r\n alert(\"要導出工作，請至少選擇其中一項。\");\r\n return;\r\n }\r\n\r\n document.form1.action=\"excel_list_view.php\";\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)\r\n{\r\n msg=\"下一步驟尚未接收時可收回至本步驟重新辦理，確認要收回么？\";\r\n if(window.confirm(msg))\r\n {\r\n url=\"../list/call_back.php?FLOW_ID=";
echo $FLOW_ID;
echo "&RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n ";
if ( $MENU_FLAG != "1" )
{
echo "parent.";
}
echo "location=url;\r\n }\r\n}\r\n\r\nfunction restore_run(RUN_ID,FLOW_ID)\r\n{\r\n msg='確認要將該工作恢復到執(zhí)行中么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"restore.php?FLOW_ID=\"+FLOW_ID+\"&RUN_ID=\"+RUN_ID;\r\n location=url;\r\n }\r\n}\r\n\r\nfunction SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n URL=\"/module/save_file?ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME+\"&A=1\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.open(URL,null,\"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+loc_y+\",left=\"+loc_x+\",resizable=yes\");\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 ( $RUN_ID != "" )
{
$query .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
$EXPLODE = explode( "|", $RUN_NAME );
$EXPLODE_COUNT = count( $EXPLODE );
$I = 0;
for ( ; $I < $EXPLODE_COUNT; ++$I )
{
$FIELDVALUE = $EXPLODE[$I];
$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 .= $WHERE_STR;
}
}
if ( $ATTACHMENT_NAME != "" )
{
$EXPLODE = explode( "|", $ATTACHMENT_NAME );
$EXPLODE_COUNT = count( $EXPLODE );
$I = 0;
for ( ; $I < $EXPLODE_COUNT; ++$I )
{
$FIELDVALUE = $EXPLODE[$I];
$WHERE_STR = " and ATTACHMENT_NAME like '%".$FIELDVALUE."%'";
$query .= $WHERE_STR;
}
}
if ( !( $FLOW_QUERY_TYPE == "ALL" ) && $LOGIN_USER_PRIV != 1 || $FLOW_QUERY_TYPE == "2" )
{
$query_my = $query.( " and USER_ID='".$LOGIN_USER_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 (PRCS_TIME>='".$PRCS_DATE1." 00:00:00' or PRCS_TIME IS NULL)";
}
if ( $PRCS_DATE2 != "" )
{
$query .= " and (PRCS_TIME<='".$PRCS_DATE2." 23:59:59' or PRCS_TIME IS NULL)";
}
$query_global = $query;
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" )
{
$TO_ID = $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},%')";
}
$query_run = $query_global." and PRCS_FLAG<>'4'";
$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='0' 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_ID DESC,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."步";
}
$NOT_FOUND = 0;
$I = 1;
for ( ; $I <= $ITEM_ID_MAX; ++$I )
{
$STR = "DATA_".$I;
$FIELDVALUE = $$STR;
if ( !( $FIELDVALUE != "" ) && !( $FIELDVALUE != "SELECT_ALL_VALUE" ) )
{
continue;
}
$STR = "RELATION_".$I;
$RELATION = $$STR;
if ( $FIELDVALUE == "CHECKBOX_ON" )
{
$FIELDVALUE = "on";
}
else if ( $FIELDVALUE == "CHECKBOX_OFF" )
{
$FIELDVALUE = "";
}
$EXPLODE = explode( "|", $FIELDVALUE );
$EXPLODE_COUNT = count( $EXPLODE );
$WHERE_STR1 = "";
$J = 0;
for ( ; $J < $EXPLODE_COUNT; ++$J )
{
$FIELDVALUE1 = $EXPLODE[$J];
$WHERE_STR = " and ITEM_DATA";
switch ( $RELATION )
{
case 1 :
$WHERE_STR .= "='".$FIELDVALUE1."'";
break;
case 2 :
if ( is_numeric( $FIELDVALUE1 ) )
{
$WHERE_STR .= ">".$FIELDVALUE1."";
}
else
{
$WHERE_STR .= ">'".$FIELDVALUE1."'";
}
break;
case 3 :
if ( is_numeric( $FIELDVALUE1 ) )
{
$WHERE_STR .= "<".$FIELDVALUE1."";
}
else
{
$WHERE_STR .= "<'".$FIELDVALUE1."'";
}
break;
case 4 :
if ( is_numeric( $FIELDVALUE1 ) )
{
$WHERE_STR .= ">=".$FIELDVALUE1."";
}
else
{
$WHERE_STR .= ">='".$FIELDVALUE1."'";
}
break;
case 5 :
if ( is_numeric( $FIELDVALUE1 ) )
{
$WHERE_STR .= "<=".$FIELDVALUE1."";
}
else
{
$WHERE_STR .= "<='".$FIELDVALUE1."'";
}
break;
case 6 :
$WHERE_STR .= "!='".$FIELDVALUE1."'";
break;
case 7 :
$WHERE_STR .= " like '".$FIELDVALUE1."%'";
break;
case 8 :
$WHERE_STR .= " like '%".$FIELDVALUE1."%'";
break;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -