📄 others.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "../prcs_role.php" );
if ( !run_role( $RUN_ID, $PRCS_ID ) )
{
	exit( );
}
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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FORM_ID = $ROW['FORM_ID'];
}
$query = "SELECT * from FLOW_RUN WHERE RUN_ID={$RUN_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$RUN_NAME = $ROW['RUN_NAME'];
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 委托代办人/转交主办权</span><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n<form action=\"others_submit.php\" method=\"post\" name=\"form1\">\r\n<table border=\"0\" cellspacing=\"1\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" width=\"90%\">\r\n    <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\" class=\"Big\" colspan=\"2\"><b>";
echo $FLOW_NAME;
echo "</b></td>\r\n    </tr>\r\n\r\n";
$PRCS_ID_I = 1;
for ( ;	$PRCS_ID_I <= $PRCS_ID;	++$PRCS_ID_I	)
{
	$query = "SELECT * from FLOW_RUN_PRCS where RUN_ID={$RUN_ID} and PRCS_ID={$PRCS_ID_I}";
	$cursor = exequery( $connection, $query );
	$USER_NAME_STR = "";
	$USER_COUNT = 0;
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$USER_COUNT;
		$USER_ID = $ROW['USER_ID'];
		$FLOW_PRCS = $ROW['FLOW_PRCS'];
		$query1 = "SELECT * from USER where USER_ID='{$USER_ID}'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME_STR .= $ROW['USER_NAME'].",";
		}
	}
	$query1 = "SELECT * from FLOW_PROCESS WHERE FLOW_ID={$FLOW_ID} and PRCS_ID={$FLOW_PRCS}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRCS_NAME = $ROW['PRCS_NAME'];
		$PRCS_USER = $ROW['PRCS_USER'];
		$PRCS_DEPT = $ROW['PRCS_DEPT'];
		$PRCS_PRIV = $ROW['PRCS_PRIV'];
	}
	$USER_NAME_STR = substr( $USER_NAME_STR, 0, strlen( $USER_NAME_STR ) - 1 );
	if ( $PRCS_ID_I != $PRCS_ID )
	{
		echo "\r\n       <tr class=\"TableData\">\r\n         <td nowrap width=\"10%\">";
		echo $PRCS_ID_I;
		echo "：";
		echo $PRCS_NAME;
		echo "</td>\r\n         <td>";
		echo $USER_NAME_STR;
		echo "</td>\r\n       </tr>\r\n";
	}
	else
	{
		echo "       <tr class=\"TableData\">\r\n         <td nowrap width=\"10%\">";
		echo $PRCS_ID_I;
		echo "：";
		echo $PRCS_NAME;
		echo " (当前步骤)</td>\r\n         <td nowrap>\r\n";
		if ( 1 < $USER_COUNT && !$OP_FLAG )
		{
			echo "本步骤为会签步骤，不能指定代办人；且您不是主办人，不能转交主办权";
		}
		else
		{
			if ( $USER_COUNT == 1 )
			{
				if ( $PRCS_DEPT != "" )
				{
					$PRCS_DEPT = substr( $PRCS_DEPT, 0, strlen( $PRCS_DEPT ) - 1 );
					$query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID in({$PRCS_DEPT}) order by PRIV_NO,USER_NO,USER_NAME";
					$cursor1 = exequery( $connection, $query1 );
					while ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$USER_ID = $ROW['USER_ID'];
						$PRCS_USER .= $USER_ID.",";
					}
				}
				if ( $PRCS_PRIV != "" )
				{
					$PRCS_PRIV = substr( $PRCS_PRIV, 0, strlen( $PRCS_PRIV ) - 1 );
					$query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and USER.USER_PRIV in({$PRCS_PRIV}) order by PRIV_NO,USER_NO,USER_NAME";
					$cursor1 = exequery( $connection, $query1 );
					while ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$USER_ID = $ROW['USER_ID'];
						$PRCS_USER .= $USER_ID.",";
					}
				}
			}
			else
			{
				$PRCS_USER = "";
				$query = "SELECT * from FLOW_RUN_PRCS where RUN_ID={$RUN_ID} and PRCS_ID={$PRCS_ID_I}";
				$cursor = exequery( $connection, $query );
				while ( $ROW = mysql_fetch_array( $cursor ) )
				{
					$USER_ID = $ROW['USER_ID'];
					$PRCS_USER .= $USER_ID.",";
				}
			}
			$MY_ARRAY = explode( ",", $PRCS_USER );
			$ARRAY_COUNT = sizeof( $MY_ARRAY );
			if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
			{
				--$ARRAY_COUNT;
			}
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				if ( $MY_ARRAY[$I] != $LOGIN_USER_ID )
				{
					$query1 = "SELECT * from USER where USER_ID='{$MY_ARRAY[$I]}'";
					$cursor1 = exequery( $connection, $query1 );
					if ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$USER_NAME = $ROW['USER_NAME'];
					}
					if ( $I == 0 )
					{
						if ( $USER_COUNT == 1 )
						{
							echo "<b>委托代办人：</b><br>";
						}
						else
						{
							echo "<b>转交主办权：</b><br>";
						}
					}
					echo "              <input type=\"radio\" name=\"USER_ID\" value=\"";
					echo $MY_ARRAY[$I];
					echo "\" ";
					if ( $I == 0 )
					{
						echo "checked";
					}
					echo ">";
					echo $USER_NAME;
					echo "<br>\r\n";
				}
			}
			if ( $MY_ARRAY[0] == $LOGIN_USER_ID && $ARRAY_COUNT == 1 )
			{
				$I = 0;
			}
			if ( $I == 0 )
			{
				echo "本步骤无可供选择的代办人";
			}
		}
		echo "         </td>\r\n       </tr>\r\n";
	}
}
if ( $USER_COUNT == 1 || $OP_FLAG )
{
	echo "    <tr class=\"TableHeader\">\r\n      <td colspan=\"2\"><b>短信提醒</b></td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td colspan=\"2\">\r\n        <input type=\"checkbox\" name=\"SMS_REMIND\" id=\"SMS_REMIND\" ";
	if ( $SMS_REMIND == "1" || $SMS_REMIND == "" )
	{
		echo "checked";
	}
	echo "><label for=\"SMS_REMIND\">使用内部短信提醒经办人</label>\r\n";
	$query = "select * from SMS2_PRIV";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$TYPE_PRIV = $ROW['TYPE_PRIV'];
	}
	if ( find_id( $TYPE_PRIV, 7 ) )
	{
		echo "        <input type=\"checkbox\" name=\"SMS2_REMIND\" id=\"SMS2_REMIND\"><label for=\"SMS2_REMIND\">使用手机短信提醒经办人</label>\r\n";
	}
	if ( $USER_COUNT == 1 )
	{
		$SMS_CONTENT = "工作流委托提醒：".$RUN_NAME;
	}
	else
	{
		$SMS_CONTENT = "工作流主办权转交提醒：".$RUN_NAME;
	}
	echo "<br>\r\n短信内容：<input type=\"text\" name=\"SMS_CONTENT\" value=\"";
	echo $SMS_CONTENT;
	echo "\" size=\"62\" maxlength=\"100\" class=\"SmallInput\">\r\n     </td>\r\n    </tr>\r\n";
}
echo "    <tr class=\"TableControl\">\r\n      <td nowrap align=\"center\" colspan=\"2\">\r\n      \t<input type=\"hidden\"  name=\"RUN_ID\" value=\"";
echo $RUN_ID;
echo "\">\r\n        <input type=\"hidden\"  name=\"USER_COUNT\" value=\"";
echo $USER_COUNT;
echo "\">\r\n        <input type=\"hidden\"  name=\"PRCS_ID\" value=\"";
echo $PRCS_ID;
echo "\">\r\n";
if ( $I != 0 )
{
	echo "        <input type=\"submit\"  value=\"确定\" class=\"BigButton\" name=\"submit\">&nbsp;&nbsp;\r\n";
}
echo "        <input type=\"button\"  value=\"返回\" class=\"BigButton\" name=\"back\" onClick=\"history.back();\">\r\n      </td>\r\n    </tr>\r\n</table>\r\n</form>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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