flow_step.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

include_once( "inc/auth.php" );
ob_end_clean( );
include_once( "inc/utility_all.php" );
include_once( "general/workflow/flow_expr_run.php" );
$query = "SELECT MAX(PRCS_ID) from FLOW_PROCESS WHERE FLOW_ID={$FLOW_ID}";
$PRCS_MAX = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRCS_MAX = $ROW[0];
}
$haveTerm = 0;
$sql = "SELECT COUNT(*) AS cnt FROM flow_term WHERE LEFT(PRC_PRC,INSTR(PRC_PRC,'-'))=".$FLOW_PRCS." AND FLOW_ID=".$FLOW_ID;
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
if ( 0 < $row['cnt'] )
{
	$haveTerm = 1;
}
echo "\r\n\r\n   ";
$sql_opfg = " \r\n    SELECT FLOW_PRCS,OP_FLAG FROM flow_run_prcs \r\n\t     WHERE RUN_ID={$RUN_ID} AND USER_ID='".$LOGIN_USER_ID."'\r\n\t          AND PRCS_FLAG<3 \r\n\t\t\t    ORDER BY PRCS_TIME  DESC\r\n\t";
$res_opfg = exequery( $connection, $sql_opfg );
$row_opfg = mysql_fetch_array( $res_opfg );
$is_opflag_here = $row_opfg['OP_FLAG'];
$sql_concourse = "\r\n\t\t\t\tSELECT PRCS_CONCOURSE FROM FLOW_PROCESS \r\n\t\t\t\t\tWHERE FLOW_ID=".$_REQUEST['FLOW_ID']."\r\n\t\t\t\t\t   AND PRCS_ID=".$_REQUEST['FLOW_PRCS']."\r\n\t\t\t\t ";
$res_concourse = exequery( $connection, $sql_concourse );
$row_concourse = mysql_fetch_array( $res_concourse );
$is_concourse = $row_concourse['PRCS_CONCOURSE'];
$sqlmu = "\r\n\t\t  SELECT u.USER_NAME FROM user u,flow_run_prcs frp \r\n\t\t\t   WHERE RUN_ID=".$_REQUEST['RUN_ID']." \r\n\t\t\t\t AND PRCS_ID=".$_REQUEST['PRCS_ID']." \r\n\t\t\t\t AND u.USER_ID=frp.USER_ID \r\n\t\t\t\t AND frp.OP_FLAG<>1 \r\n\t\t\t\t AND (frp.PRCS_FLAG=1 OR (frp.PRCS_FLAG=2\r\n\t\t\t\t\tAND frp.SAVEFORM_TIME IS NULL))\r\n";
$resmu = exequery( $connection, $sqlmu );
$muc = 0;
while ( $rowmu = mysql_fetch_array( $resmu ) )
{
	$lesser_manage_name[] = $rowmu['USER_NAME'];
	++$muc;
}
if ( $OP_FLAG == 1 && ( $is_concourse == 1 && $muc == 0 || $is_concourse != 1 ) )
{
	$fvalue = "turnnext";
}
else
{
	$fvalue = "saveform";
}
echo "\r\n<input type=\"hidden\" name=\"f\" value=\"";
echo $fvalue;
echo "\">\r\n";
if ( $is_opflag_here == 1 )
{
	if ( $is_concourse == 1 && 0 < $muc )
	{
		echo "<table border=\"0\" cellspacing=\"1\"  cellpadding=\"5\" align=\"center\" width=\"100%\">\r\n  <tr class=\"TableLine2\">\r\n    <td colspan=2>";
		echo "<s";
		echo "pan style=\"color:#FF0000 \">无法选择下一步（当前节点需要会签，所有办理人都必须办理）</span></td>   \r\n  </tr>\r\n <tr class=\"TableLine1\">\r\n    <td colspan=2>\r\n\r\n ";
		echo "<s";
		echo "pan style=\"color:#333333 \">当前节点未办理人员：\r\n    ";
		reset( $lesser_manage_name );
		unset( $mucc );
		while ( list( $key, $var ) = each( $lesser_manage_name ) )
		{
			++$mucc;
			$namestr .= $var;
			if ( $mucc < $muc )
			{
				$namestr .= ",";
			}
		}
		echo $namestr;
		echo "    \r\n</span>\t  </td>\r\n  </tr>  \r\n</table>\r\n   \r\n   \r\n   ";
	}
	else
	{
		echo "\r\n\r\n<table border=\"0\" cellspacing=\"1\"  cellpadding=\"5\" align=\"center\" width=\"100%\">";
		if ( 0 < $muc )
		{
			echo "  <tr class=\"TableLine1\">\r\n    <td colspan=2>\r\n\r\n ";
			echo "<s";
			echo "pan style=\"color:#333333 \">当前节点未办理人员：\r\n    ";
			reset( $lesser_manage_name );
			unset( $mucc );
			while ( list( $key, $var ) = each( $lesser_manage_name ) )
			{
				++$mucc;
				$namestr .= $var;
				if ( $mucc < $muc )
				{
					$namestr .= ",";
				}
			}
			echo $namestr;
			echo "    </span>\t  </td>\r\n  </tr>";
		}
		echo "  ";
		if ( $haveTerm == 1 )
		{
			echo "  <tr>\r\n\t<td colspan=2>";
			echo "<s";
			echo "pan style=\"color:#00f;cursor:hand\" onclick=\"deleteDisabledFlowform()\">修改表单数据</span>\r\n\t</td>\r\n  </tr>\r\n  ";
		}
		echo "  <tr class=\"TableData\">\r\n    <td colspan=2>\r\n      ";
		$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_TO = $ROW['PRCS_TO'];
		}
		if ( $FLOW_PRCS == $PRCS_MAX )
		{
			if ( $PRCS_TO_CHOOSE == "" )
			{
				$PRCS_TO_CHOOSE = -1;
			}
			echo "   <label for=\"labelend\"><input type=\"radio\" id=\"labelend\" name=\"FLOW_PRCS\" value=\"\" ";
			if ( $PRCS_TO_CHOOSE == -1 )
			{
				echo "checked";
			}
			echo ">\r\n      结束流程</label>\r\n      ";
		}
		if ( $PRCS_TO == "" && $FLOW_PRCS != $PRCS_MAX )
		{
			$PRCS_TO = $FLOW_PRCS + 1;
		}
		if ( $PRCS_TO != "" )
		{
			$MY_ARRAY = explode( ",", $PRCS_TO );
			$ARRAY_COUNT = sizeof( $MY_ARRAY );
			if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
			{
				--$ARRAY_COUNT;
			}
			if ( $PRCS_TO_CHOOSE == "" )
			{
				$PRCS_TO_CHOOSE = 0;
			}
			$btnType = "button";
			$isHavePass = 0;
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				if ( $FLOW_PRCS < $MY_ARRAY[$I] )
				{
					$query1 = "SELECT * from FLOW_PROCESS where FLOW_ID={$FLOW_ID} and PRCS_ID={$MY_ARRAY[$I]}";
					$cursor1 = exequery( $connection, $query1 );
					if ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$PRCS_ID_TO = $ROW['PRCS_ID'];
						$exprRunPass = 0;
						$PRC_PRC = $FLOW_PRCS."-".$PRCS_ID_TO;
						if ( exprrun( $FLOW_ID, $RUN_ID, $PRC_PRC ) )
						{
							$exprRunPass = 1;
							++$isHavePass;
						}
						$PRCS_NAME = $ROW['PRCS_NAME'];
						if ( $PRCS_TO_CHOOSE == $I )
						{
							$PRCS_USER = $ROW['PRCS_USER'];
							$PRCS_DEPT = $ROW['PRCS_DEPT'];
							$PRCS_PRIV = $ROW['PRCS_PRIV'];
							$PRCS_OPTYPE = $ROW['PRCS_OPTYPE'];
							$PRCS_DEFAULT_USER = $ROW['PRCS_DEFAULT_USER'];
							$PRCS_DEFAULT_TYPE = $ROW['PRCS_DEFAULT_TYPE'];
							$PRCS_DEFAULT_MANAGE = $ROW['PRCS_DEFAULT_MANAGE'];
							$btnDisabled = "";
							$btnType = "button";
							if ( $PRCS_DEFAULT_USER != "" && $exprRunPass == 1 )
							{
								if ( $PRCS_DEFAULT_TYPE != 1 )
								{
									$btnDisabled = "disabled";
									$btnType = "hidden";
								}
								$prcsdfuser_str = substr( $PRCS_DEFAULT_USER, 0, -1 );
								$prcsdfuser_str = "'".str_replace( ",", "','", $prcsdfuser_str )."'";
								$sqlu = "\r\n\t\t\t\t\t\t\tSELECT USER_ID,USER_NAME FROM user WHERE USER_ID IN (".$prcsdfuser_str.")\r\n\t\t\t\t\t\t\t";
								$rsu = exequery( $connection, $sqlu );
								$ci = 0;
								while ( $rowu = mysql_fetch_array( $rsu ) )
								{
									$userInThisFlownode[$ci]['username'] = $rowu['USER_NAME'];
									$userInThisFlownode[$ci]['userid'] = $rowu['USER_ID'];
									$op_flag_int = $rowu['USER_ID'] == $PRCS_DEFAULT_MANAGE ? 1 : 0;
									$userInThisFlownode[$ci]['opflag'] = $op_flag_int;
									++$ci;
								}
							}
						}
					}
					if ( $exprRunPass == 1 )
					{
						echo "\t\t  <input type=\"radio\" id=\"label";
						echo $I;
						echo "\" stepi=\"";
						echo $I;
						echo "\" name=\"FLOW_PRCS\" value=\"";
						echo $PRCS_ID_TO;
						echo "\" ";
						if ( $PRCS_TO_CHOOSE == $I )
						{
							echo "checked";
						}
						echo " onClick=\"SelectFormValue(";