?? findflow.php
字號:
<?php
include_once( "inc/auth.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>\r\nfunction delete_run(RUN_ID)\r\n{\r\n msg='確認要刪除該工作么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"../delete.php?FLOW_ID=76&RUN_ID=\"+RUN_ID;\r\n location=url;\r\n }\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(\"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\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "SELECT flow_run.RUN_ID,flow_id,run_name,prcs_time,attachment_id,\r\n\tattachment_name from flow_run,flow_run_data,flow_run_prcs WHERE\r\n\tflow_run.RUN_ID=flow_run_data.RUN_ID and flow_run.RUN_ID=\r\n\tflow_run_prcs.RUN_ID and prcs_time>='".$TABLE_TIME."' and prcs_time<='{$END_TIME}' \r\n\tand flow_run.flow_id={$FLOW_ID} \r\n\tand ITEM_DATA='{$DEPT_NAME}' order by prcs_time desc";
$cursor = exequery( $connection, $query );
$cn = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$cn;
if ( $cn == 1 )
{
echo "\t\t\r\n \t<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n \t<tr class=\"TableHeader\">\r\n \t<td nowrap align=\"center\">文號</td>\r\n \t<td nowrap align=\"center\">開始時間</td>\r\n \t<td nowrap align=\"center\">公共附件</td>\r\n<!-- \t<td nowrap align=\"center\">狀態</td> -->\r\n \t<td nowrap align=\"center\">查看</td>\r\n \t</tr>\r\n";
}
echo " <tr class=\"TableLine1\">\r\n <td align=\"center\">";
echo $ROW[run_name];
echo "</td>\r\n <td align=\"center\">";
echo $ROW[prcs_time];
echo "</td>\r\n <td>\r\n \t";
$arrattid = explode( ",", $ROW[attachment_id] );
$arrattname = explode( "*", $ROW[attachment_name] );
$i = 0;
for ( ; $i < count( $arrattid ); ++$i )
{
echo " \t\t\t\r\n\t<a href=\"/inc/attach.php?ATTACHMENT_ID=";
echo $arrattid[$i] * 3 + 2;
echo "&ATTACHMENT_NAME=";
echo $arrattname[$i];
echo "\" target=\"_blank\">";
echo $arrattname[$i];
echo "</a>\r\n\t<br> \r\n\t";
}
echo " </td>\r\n \r\n<!-- <td align=\"center\" nowrap>";
echo $ROW[RUN_ID];
echo "</td> -->\r\n <td>\r\n <a href=\"#\" onclick=\"javascript:window.open('print?RUN_ID=";
echo $ROW[RUN_ID];
echo "&FLOW_ID=";
echo $ROW[flow_id];
echo "','FLOW_PRINT','status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes');\">表單</a> \r\n <a href=\"#\" onclick=\"javascript:window.open('personal_sign.php?RUN_ID=";
echo $ROW[RUN_ID];
echo "&FLOW_ID=";
echo $ROW[flow_id];
echo "','FLOW_SIGN','status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes');\">簽辦</a> \r\n <a href=\"#\" onclick=\"flow_view(";
echo $ROW[RUN_ID];
echo ",";
echo $ROW[flow_id];
echo ")\">流程圖</a> \r\n </td>\r\n </tr>\r\n\r\n";
}
if ( $cn == 0 )
{
message( "", "沒有找到符合條件的數據" );
}
else
{
message( "", "共".$cn."條記錄" );
}
echo "</body>\r\n</html>";
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -