📄 workflow.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility.php" );
$query = "select FLOW_ID_STR,RUN_ID_STR FROM PROJ_TASK WHERE TASK_ID='".$TASK_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FLOW_ID_STR = $ROW['FLOW_ID_STR'];
	$RUN_ID_STR = $ROW['RUN_ID_STR'];
}
$FLOW_ID_ARR = explode( ",", $FLOW_ID_STR );
$RUN_ID_ARR = explode( ",", $RUN_ID_STR );
$ARR1 = array( );
$ARR2 = array( );
$ARR3 = array( );
$query = "select RUN_ID,FLOW_ID,END_TIME FROM FLOW_RUN WHERE FIND_IN_SET(RUN_ID,'".$RUN_ID_STR."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$RUN_ID = $ROW['RUN_ID'];
	$FLOW_ID = $ROW['FLOW_ID'];
	$END_TIME = $ROW['END_TIME'];
	if ( find_id( $FLOW_ID_STR, $FLOW_ID ) )
	{
		if ( $END_TIME == "" )
		{
			$ARR2[] = $RUN_ID;
		}
		else
		{
			$ARR3[] = $RUN_ID;
		}
	}
	$FLOW_ING_STR .= $FLOW_ID.",";
}
foreach ( $FLOW_ID_ARR as $k => $v )
{
	if ( !( $v != "" ) && find_id( $FLOW_ING_STR, $v ) )
	{
		$ARR1[] = $v;
	}
}
echo "<html>\r\n<head>\r\n<title>项目流程</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script>\r\nfunction view_graph(FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  window.open(\"/general/workflow/list/view_graph?FLOW_ID=\"+FLOW_ID,\"\",\"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  window.open(\"/general/workflow/list/print?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=\"+(screen.availWidth-12)+\",height=\"+(screen.availHeight-38)+\",location=no,scrollbars=yes,resizable=yes,left=0,top=0\");\r\n}\r\n\r\nfunction flow_view(RUN_ID,FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  window.open(\"/general/workflow/list/flow_view?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,RUN_ID,\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=400,left=\"+myleft+\",top=100\");\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n  <td class=\"Big\"><img src=\"/images/menu/project.gif\" align=\"absmiddle\"><span class=\"big3\"> 项目流程-待办</span>\r\n  </td>\r\n </tr>\r\n</table>\r\n";
if ( 0 < count( $ARR1 ) )
{
	foreach ( $ARR1 as $k => $v )
	{
		if ( $k == 0 )
		{
			echo "<table class=\"TableList\" width=\"100%\">\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\" width=\"100\">流程类型</td>\r\n    <td nowrap align=\"center\">流程名称</td>\r\n    <td nowrap align=\"center\">操作</td>\r\n  </tr>\r\n";
		}
		$query = "select FLOW_NAME,FLOW_TYPE FROM FLOW_TYPE WHERE FLOW_ID='".$v."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$FLOW_NAME = $ROW['FLOW_NAME'];
			$FLOW_TYPE = $ROW['FLOW_TYPE'];
			if ( $FLOW_TYPE == 1 )
			{
				$TYPE_DESC = "固定流程";
			}
			else
			{
				$TYPE_DESC = "自由流程";
			}
		}
		if ( $v % 2 == 0 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "  <tr class=\"";
		echo $TableLine;
		echo "\">\r\n    <td nowrap align=\"center\" width=\"100\">";
		echo $TYPE_DESC;
		echo "</td>\r\n    <td nowrap align=\"center\"><a href=\"javascript:view_graph(";
		echo $v;
		echo ")\">";
		echo $FLOW_NAME;
		echo "</a></td>\r\n    <td nowrap align=\"center\"><a href=\"insert.php?FLOW_ID=";
		echo $v;
		echo "&PROJ_ID=";
		echo $PROJ_ID;
		echo "&TASK_ID=";
		echo $TASK_ID;
		echo "\">新建工作</a></td>\r\n  </tr>\r\n";
	}
	echo "</table>";
}
else
{
	message( "", "无待办项目流程!" );
}
echo "<br> \r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n  <td class=\"Big\"><img src=\"/images/menu/project.gif\" align=\"absmiddle\"><span class=\"big3\"> 项目流程-进行中</span>\r\n  </td>\r\n </tr>\r\n</table>\r\n";
if ( 0 < count( $ARR2 ) )
{
	foreach ( $ARR2 as $k => $v )
	{
		if ( $k == 0 )
		{
			echo "<table class=\"TableList\" width=\"100%\">\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\">流水号</td>\r\n    <td nowrap align=\"center\">工作名称/文号</td>\r\n    <td nowrap align=\"center\">操作</td>\r\n  </tr>\r\n";
		}
		$query = "select FLOW_ID,RUN_NAME FROM FLOW_RUN WHERE RUN_ID='".$v."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$FLOW_ID = $ROW['FLOW_ID'];
			$RUN_NAME = $ROW['RUN_NAME'];
			if ( $FLOW_TYPE == 1 )
			{
				$TYPE_DESC = "固定流程";
			}
			else
			{
				$TYPE_DESC = "自由流程";
			}
		}
		if ( $k % 2 == 0 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "  <tr class=\"";
		echo $TableLine;
		echo "\">\r\n    <td nowrap align=\"center\" width=100>";
		echo $v;
		echo "</td>\r\n    <td><a href=\"javascript:form_view(";
		echo $v;
		echo ",";
		echo $FLOW_ID;
		echo ");\">";
		echo $RUN_NAME;
		echo "</a></td>\r\n";
		$query = "select 1 FROM FLOW_RUN_PRCS WHERE RUN_ID='".$v."' and USER_ID='{$LOGIN_USER_ID}' AND PRCS_FLAG IN (1,2)";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			echo "    <td nowrap align=\"center\"><a href=\"/general/workflow/list/input_form?FLOW_ID=";
			echo $FLOW_ID;
			echo "&RUN_ID=";
			echo $v;
			echo "&PRCS_ID=1&FLOW_PRCS=1\">办理</a></td>\r\n";
		}
		else
		{
			echo "<td nowrap align=\"center\"><font color=green>进行中</font></td>";
		}
		echo "  </tr>\r\n";
	}
	echo "</table>";
}
else
{
	message( "", "无进行中项目流程!" );
}
echo "<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n  <td class=\"Big\"><img src=\"/images/menu/project.gif\" align=\"absmiddle\"><span class=\"big3\"> 项目流程-已结束</span>\r\n  </td>\r\n </tr>\r\n</table>\r\n";
if ( 0 < count( $ARR3 ) )
{
	foreach ( $ARR3 as $k => $v )
	{
		if ( $k == 0 )
		{
			echo "<table class=\"TableList\" width=\"100%\">\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\">流水号</td>\r\n    <td nowrap align=\"center\">工作名称/文号</td>\r\n  </tr>\r\n";
		}
		$query = "select FLOW_ID,RUN_NAME FROM FLOW_RUN WHERE RUN_ID='".$v."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$FLOW_ID = $ROW['FLOW_ID'];
			$RUN_NAME = $ROW['RUN_NAME'];
			if ( $FLOW_TYPE == 1 )
			{
				$TYPE_DESC = "固定流程";
			}
			else
			{
				$TYPE_DESC = "自由流程";
			}
		}
		if ( $k % 2 == 0 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "  <tr class=\"";
		echo $TableLine;
		echo "\">\r\n    <td nowrap align=\"center\" width=100>";
		echo $v;
		echo "</td>\r\n    <td><a href=\"javascript:form_view(";
		echo $v;
		echo ",";
		echo $FLOW_ID;
		echo ");\">";
		echo $RUN_NAME;
		echo "</a></td>\r\n  </tr>\r\n";
	}
	echo "</table>";
}
else
{
	message( "", "无已结束的项目流程!" );
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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