?? search.php
字號:
case 9 :
$WHERE_STR .= " like '%".$FIELDVALUE1."'";
}
$WHERE_STR1 .= $WHERE_STR;
}
$query1 = "select * from FLOW_RUN_DATA where RUN_ID='".$RUN_ID."' and ITEM_ID={$I} ".$WHERE_STR1;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
continue;
}
$NOT_FOUND = 1;
break;
}
if ( $NOT_FOUND == 1 )
{
continue;
}
$NOT_FOUND = 0;
$I = 1;
for ( ; $I <= $ITEM_ID_MAX; ++$I )
{
$STR = "DATA_".$I."_2";
$FIELDVALUE = $$STR;
if ( !( $FIELDVALUE != "" ) && !( $FIELDVALUE != "SELECT_ALL_VALUE" ) )
{
continue;
}
$STR = "RELATION_".$I."_2";
$RELATION = $$STR;
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 :
$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."'";
}
$query1 = "select * from FLOW_RUN_DATA".$WHERE_STR;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
continue;
}
$NOT_FOUND = 1;
break;
}
if ( $NOT_FOUND == 1 )
{
continue;
}
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 )
{
if ( $FLOW_ID_GLOBAL )
{
echo " <input type=\"button\" class=\"SmallButton\" value=\"生成Excel報表\" onclick=\"excel_data()\"> \r\n <input type=\"button\" class=\"SmallButton\" value=\"返回\" onclick=\"history.back()\">\r\n";
}
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";
if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
{
echo " \t<td nowrap align=\"center\">選擇</td>\r\n";
}
echo " <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";
if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
{
echo " \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";
}
echo " <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";
if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
{
echo " <a href=\"../list/input_form?MENU_FLAG=";
echo $MENU_FLAG;
echo "&RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "&FLOW_PRCS=";
echo $FLOW_PRCS;
echo "\" ";
if ( $MENU_FLAG != "1" )
{
echo "target=_parent";
}
echo ">辦理</a> \r\n <a href=\"../list/others/";
if ( $FLOW_TYPE == "1" )
{
echo "others";
}
else
{
echo "others_free";
}
echo ".php?MENU_FLAG=";
echo $MENU_FLAG;
echo "&RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "&OP_FLAG=";
echo $OP_FLAG;
echo "\" ";
if ( $MENU_FLAG != "1" )
{
echo "target=_parent";
}
echo ">委托</a> \r\n";
}
else if ( $PRCS_FLAG == "3" && $OP_FLAG == "1" )
{
echo " <a href=\"javascript:call_back(";
echo $RUN_ID;
echo ",";
echo $PRCS_ID;
echo ");\">收回</a>\r\n";
}
if ( $LOGIN_USER_PRIV == "1" && $PRCS_OVER )
{
echo " <a href=\"javascript:restore_run(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ");\">恢復執行</a> \r\n <a href=\"javascript:edit_run(";
echo $RUN_ID;
echo ",";
echo $FLOW_ID;
echo ");\">編輯</a> \r\n";
}
echo "\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";
if ( $FLOW_ID_GLOBAL )
{
echo " <input type=\"button\" value=\"導出Excel\" class=\"SmallButton\" onClick=\"export_run_sel();\" title=\"導出所選工作到Excel\"> \r\n";
}
if ( $LOGIN_USER_PRIV == "1" )
{
echo " <input type=\"button\" value=\"管理員刪除\" class=\"SmallButton\" onClick=\"delete_run_sel();\" title=\"刪除所選工作\"> \r\n";
}
if ( $LIST_VIEW != "" && $FLOW_ID_GLOBAL )
{
echo " <select name=\"LIST_VIEW\" class=\"SmallSelect\">\r\n";
$MY_ARRAY = explode( "^", $LIST_VIEW );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$ITEM_NAME = strtok( $MY_ARRAY[$I], "~" );
echo " \t <option value=\"";
echo urlencode( $MY_ARRAY[$I] );
echo "\">";
echo $ITEM_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n <input type=\"button\" value=\"列表項導出\" class=\"SmallButton\" onClick=\"export_list_view();\" title=\"導出所選工作中的列表項到Excel\"> \r\n";
}
echo " </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='blank.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 <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 + -