📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
 

include_once( "inc/auth.php" );
if ( $FLOW_ID != "" )
{
	$MENU_FLAG = 1;
}
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 Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',600000);\r\n</script>\r\n\r\n<script>\r\nfunction view_graph(FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  window.open(\"../list/view_graph?FLOW_ID=\"+FLOW_ID,\"flow_view\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=500,left=\"+myleft+\",top=50\");\r\n}\r\n\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,location=no,scrollbars=yes,width=800,height=600,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 user_view(USER_ID)\r\n{\r\n  myleft=(screen.availWidth-500)/2;\r\n  window.open(\"/general/ipanel/user_info.php?WINDOW=1&USER_ID=\"+USER_ID,\"user_view\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=500,height=500,left=\"+myleft+\",top=100\");\r\n}\r\n\r\nfunction delete_run(RUN_ID)\r\n{\r\n  msg='确认要删除该工作流程么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"../list/delete.php?FLOW_ID=";
echo $FLOW_ID;
echo "&OP=MANAGE&RUN_ID=\"+RUN_ID;\r\n    location=url;\r\n  }\r\n}\r\n\r\nfunction stop_run(RUN_ID,FLOW_ID,PRCS_ID)\r\n{\r\n  msg='确认要结束该工作流程么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"../list/stop.php?FLOW_ID=";
echo $FLOW_ID;
echo "&OP=MANAGE&RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID+\"&PRCS_ID=\"+PRCS_ID;\r\n    location=url;\r\n  }\r\n}\r\n\r\nfunction select_flow()\r\n{\r\n   location=\"index.php?FLOW_ID=\"+FLOW_ID_LIST.value;;\r\n}\r\n\r\nfunction query_run()\r\n{\r\n   location=\"index.php?FLOW_ID=";
echo $FLOW_ID;
echo "&RUN_ID=\"+RUN_ID.value;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"small\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"><span class=\"big3\"> 请选择要监控的流程</span>\r\n\r\n    <select name=\"FLOW_ID_LIST\" class=\"SmallSelect\" style=\"width:150px\" onchange=\"select_flow()\">\r\n    \t<option value=\"\">选择流程类型</option>\r\n    \t<option value=\"ALL\" ";
if ( $FLOW_ID == "ALL" )
{
	echo "selected";
}
echo ">所有流程类型</option>\r\n";
$query1 = "SELECT FLOW_ID,FLOW_NAME from FLOW_TYPE,FLOW_SORT where FLOW_TYPE.FLOW_SORT=FLOW_SORT.SORT_ID and (MANAGE_USER like '%,".$LOGIN_USER_ID.",%' or MANAGE_USER like '{$LOGIN_USER_ID},%') order by SORT_NO,FLOW_NO";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FLOW_ID1 = $ROW['FLOW_ID'];
	$FLOW_NAME1 = $ROW['FLOW_NAME'];
	echo "      <option value=\"";
	echo $FLOW_ID1;
	echo "\" ";
	if ( $FLOW_ID1 == $FLOW_ID )
	{
		echo "selected";
	}
	echo ">";
	echo $FLOW_NAME1;
	echo "</option>\r\n";
}
echo "    </select>\r\n    &nbsp;&nbsp;<span class=small1>可以点击标题进行排序</span>\r\n    </td>\r\n";
if ( $FLOW_ID != "" )
{
	echo "    <td align=right class=small1>\r\n    \t流水号 <input type=\"text\" name=\"RUN_ID\" class=\"SmallInput\" size=\"5\" value=\"";
	echo $RUN_ID;
	echo "\">\r\n    \t<input type=\"button\" class=\"SmallButton\" value=\"查询\" onclick=\"query_run()\">\r\n    \t<input type=\"button\" class=\"SmallButton\" value=\"催办超时流程\" onclick=\"sms_time_out()\">\r\n    </td>\r\n";
}
echo "  </tr>\r\n</table>\r\n\r\n";
if ( $FLOW_ID == "" )
{
	message( "提示", "请选择要监控的流程" );
	exit( );
}
$query = "SELECT FLOW_RUN_PRCS.RUN_ID,PRCS_ID,USER_ID,PRCS_FLAG,PRCS_TIME,FLOW_PRCS from FLOW_RUN_PRCS,FLOW_RUN WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and PRCS_FLAG in('1','2')and OP_FLAG=1 and DELETE_FLAG='0'";
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 ";
if ( $ORDER_FIELD == "" )
{
	$ORDER_FIELD = "PRCS_TIME";
	$ORDER_TYPE = "DESC";
}
$query .= " order by ".$ORDER_FIELD." ".$ORDER_TYPE;
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$RUN_ID = $ROW['RUN_ID'];
	$PRCS_ID = $ROW['PRCS_ID'];
	$USER_ID = $ROW['USER_ID'];
	$PRCS_FLAG = $ROW['PRCS_FLAG'];
	$PRCS_TIME = $ROW['PRCS_TIME'];
	$FLOW_PRCS = $ROW['FLOW_PRCS'];
	$query = "SELECT FLOW_TYPE.FLOW_ID,RUN_NAME,FLOW_NAME,FLOW_TYPE,MANAGE_USER,MANAGE_FLAG,DO_USER,DELETE_USER,TURN_USER,FLOW_SORT from FLOW_TYPE,FLOW_RUN WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and RUN_ID='".$RUN_ID."' limit 1";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FLOW_ID1 = $ROW['FLOW_ID'];
		$RUN_NAME = $ROW['RUN_NAME'];
		$FLOW_NAME = $ROW['FLOW_NAME'];
		$FLOW_TYPE = $ROW['FLOW_TYPE'];
		$MANAGE_USER = $ROW['MANAGE_USER'];
		$MANAGE_FLAG = $ROW['MANAGE_FLAG'];
		$DO_USER = $ROW['DO_USER'];
		$DELETE_USER = $ROW['DELETE_USER'];
		$TURN_USER = $ROW['TURN_USER'];
		$FLOW_SORT = $ROW['FLOW_SORT'];
		if ( $FLOW_TYPE == "1" )
		{
			$FLOW_TYPE_DESC = "固定流程";
		}
		else
		{
			$FLOW_TYPE_DESC = "自由流程";
		}
		if ( find_id( $MANAGE_USER, $LOGIN_USER_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 ( $MANAGE_FLAG == 1 && $LOGIN_DEPT_ID != $DEPT_ID )
			{
			}
		}
	}
	$STR = "RUN_ID_MAX_".$RUN_ID;
	if ( $$STR != "" )
	{
		if ( $PRCS_ID != $$STR )
		{
			break;
		}
	}
	else
	{
		$query = "SELECT MAX(PRCS_ID) from FLOW_RUN_PRCS WHERE RUN_ID=".$RUN_ID;
		$cursor1 = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$PRCS_ID_MAX = $ROW[0];
			$$STR = $PRCS_ID_MAX;
			if ( !( $PRCS_ID != $PRCS_ID_MAX ) )
			{
			}
		}
	}
	++$FLOW_COUNT;
	$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_ID1." 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 ( $PRCS_FLAG == "1" )
	{
		$STATUS = "<img src='/images/email_close.gif' alt='未接收'>";
	}
	else if ( $PRCS_FLAG == "2" )
	{
		$STATUS = "<img src='/images/email_open.gif' alt='已接收'>";
	}
	else
	{
		$STATUS = "<img src='/images/flow_next.gif' alt='已办结'>";
	}
	if ( $FLOW_COUNT == 1 )
	{
		echo "  <table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n    <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\">\r\n       <a href=\"index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "&ORDER_FIELD=PRCS_FLAG&ORDER_TYPE=";
		if ( $ORDER_FIELD == "PRCS_FLAG" && $ORDER_TYPE == "ASC" )
		{
			echo "DESC";
		}
		else
		{
			echo "ASC";
		}
		echo "\">\r\n       状态";
		if ( $ORDER_TYPE == "ASC" && $ORDER_FIELD == "PRCS_FLAG" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		else if ( $ORDER_TYPE == "DESC" && $ORDER_FIELD == "PRCS_FLAG" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a>\r\n      </td>\r\n      <td nowrap align=\"center\">\r\n       <a href=\"index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "&ORDER_FIELD=RUN_ID&ORDER_TYPE=";
		if ( $ORDER_FIELD == "RUN_ID" && $ORDER_TYPE == "ASC" )
		{
			echo "DESC";
		}
		else
		{
			echo "ASC";
		}
		echo "\">\r\n       流水号";
		if ( $ORDER_TYPE == "ASC" && $ORDER_FIELD == "RUN_ID" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		else if ( $ORDER_TYPE == "DESC" && $ORDER_FIELD == "RUN_ID" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a>\r\n      </td>\r\n      <td nowrap align=\"center\">\r\n       <a href=\"index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "&ORDER_FIELD=FLOW_ID&ORDER_TYPE=";
		if ( $ORDER_FIELD == "FLOW_ID" && $ORDER_TYPE == "ASC" )
		{
			echo "DESC";
		}
		else
		{
			echo "ASC";
		}
		echo "\">\r\n       流程名称";
		if ( $ORDER_TYPE == "ASC" && $ORDER_FIELD == "FLOW_ID" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		else if ( $ORDER_TYPE == "DESC" && $ORDER_FIELD == "FLOW_ID" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a>\r\n      </td>\r\n      <td nowrap align=\"center\">\r\n       <a href=\"index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "&ORDER_FIELD=RUN_NAME&ORDER_TYPE=";
		if ( $ORDER_FIELD == "RUN_NAME" && $ORDER_TYPE == "ASC" )
		{
			echo "DESC";
		}
		else
		{
			echo "ASC";
		}
		echo "\">\r\n       工作名称/文号";
		if ( $ORDER_TYPE == "ASC" && $ORDER_FIELD == "RUN_NAME" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		else if ( $ORDER_TYPE == "DESC" && $ORDER_FIELD == "RUN_NAME" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a>\r\n      </td>\r\n      <td nowrap align=\"center\">\r\n      \t<a href=\"index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "&ORDER_FIELD=PRCS_ID&ORDER_TYPE=";
		if ( $ORDER_FIELD == "PRCS_ID" && $ORDER_TYPE == "ASC" )
		{
			echo "DESC";
		}
		else
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -