?? search.php

?? 極限網絡智能辦公系統 - Office Automation 2008 官方100％源碼
?? 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.OP.value=2;\r\n     document.form1.action=\"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.OP.value=1;\r\n  document.form1.action=\"delete.php\";\r\n  document.form1.submit();\r\n}\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 ( $BEGIN_RUN_ID != "" )
{
	$query .= " and FLOW_RUN.RUN_ID>='".$BEGIN_RUN_ID."'";
}
if ( $END_RUN_ID != "" )
{
	$query .= " and FLOW_RUN.RUN_ID<='".$END_RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
	$query .= " and RUN_NAME like '%".$RUN_NAME."%'";
}
if ( $BEGIN_DATE != "" )
{
	$query .= " and PRCS_TIME>='".$BEGIN_DATE." 00:00:00'";
}
if ( $END_DATE != "" )
{
	$query .= " and PRCS_TIME<='".$END_DATE." 23:59:59'";
}
$query_global = $query;
if ( $COPY_TO_ID != "" )
{
	$query .= " and find_in_set(USER_ID,'".$COPY_TO_ID."')";
}
$query_run = $query_global;
$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='1' 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_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."步";
	}
	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 )
	{
		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    \t<td nowrap align=\"center\">選擇</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\"><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    \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      <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>&nbsp;\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&nbsp;<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> &nbsp;\r\n    <input type=\"button\"  value=\"銷毀\" class=\"SmallButton\" onClick=\"export_run_sel();\" title=\"銷毀已刪除的工作\"> &nbsp;\r\n    <input type=\"button\"  value=\"還原\" class=\"SmallButton\" onClick=\"delete_run_sel();\" title=\"還原已刪除的工作\"> &nbsp;\r\n  </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='index.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  \t<input type=\"hidden\" name=\"OP\" value=1>\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>";
?>
?? 文件大小 26710 K
?? 上傳用戶 archimedes88
?? 所屬分類 OA系統
??? 相關標簽

#Automation #Office #2008 #100
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? search.php

?? 快捷鍵說明
