input_form.php

来自「极限网络智能办公系统 - Office Automation 2.8 100％ 」· PHP 代码 · 共 519 行 · 第 1/2 页

				{
					break;
				}
				$AUTO_VALUE = $ROW['USER_NAME'];
				break;
			case "SYS_DEPTNAME" :
				$AUTO_VALUE = dept_long_name( $LOGIN_DEPT_ID );
				break;
			case "SYS_FORMNAME" :
				$AUTO_VALUE = $FORM_NAME;
				break;
			case "SYS_RUNNAME" :
				$AUTO_VALUE = $RUN_NAME;
				break;
			case "SYS_RUNDATE" :
				$AUTO_VALUE = $PRCS_DATE;
				break;
			case "SYS_RUNDATETIME" :
				$AUTO_VALUE = $PRCS_DATE_TIME;
				break;
			case "SYS_SQL" :
				$EDATASRC = get_attr( $ELEMENT, "DATASRC" );
				$EDATASRC = str_replace( "`", "'", $EDATASRC );
				$EDATASRC = str_replace( "[SYS_USER_ID]", $LOGIN_USER_ID, $EDATASRC );
				$EDATASRC = str_replace( "[SYS_DEPT_ID]", $LOGIN_DEPT_ID, $EDATASRC );
				$cursor_SYS_SQL = exequery( $connection, $EDATASRC );
				if ( !( $ROW = mysql_fetch_array( $cursor_SYS_SQL ) ) )
				{
					break;
				}
				$AUTO_VALUE = $ROW[0];
			}
			if ( $ITEM_VALUE == "" && !$READ_ONLY )
			{
				$ELEMENT_OUT = str_replace( "value={$EVALUE}", "", $ELEMENT_OUT );
				$ELEMENT_OUT = str_replace( "value=''", "", $ELEMENT_OUT );
				$ELEMENT_OUT = str_replace( "<{$ENAME}", "<{$ENAME} value='{$AUTO_VALUE}'", $ELEMENT_OUT );
			}
		}
		else if ( $ENAME == "SELECT" )
		{
			$AUTO_VALUE = "<option value=\"\"";
			if ( $ITEM_VALUE == "" )
			{
				$AUTO_VALUE .= " selected";
			}
			$AUTO_VALUE .= "></option>\n";
			$ITEM_VALUE_TEXT = "";
			switch ( $EDATAFLD )
			{
			case "SYS_LIST_DEPT" :
				$AUTO_VALUE .= my_dept_tree( 0, $ITEM_VALUE, 0 );
				if ( !( $ITEM_VALUE != "" ) )
				{
					break;
				}
				$query_auto = "SELECT * from DEPARTMENT where DEPT_ID={$ITEM_VALUE}";
				$cursor_auto = exequery( $connection, $query_auto );
				if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
				{
					break;
				}
				$ITEM_VALUE_TEXT = $ROW['DEPT_NAME'];
				break;
			case "SYS_LIST_USER" :
				$query_auto = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
				$cursor_auto = exequery( $connection, $query_auto );
				while ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$USER_ID = $ROW['USER_ID'];
					$USER_NAME = $ROW['USER_NAME'];
					$AUTO_VALUE .= "<option value=\"{$USER_ID}\"";
					if ( $ITEM_VALUE == $USER_ID )
					{
						$AUTO_VALUE .= " selected";
						$ITEM_VALUE_TEXT = $USER_NAME;
					}
					$AUTO_VALUE .= ">{$USER_NAME}</option>\n";
				}
				break;
			case "SYS_LIST_PRIV" :
				$query_auto = "SELECT * from USER_PRIV order by PRIV_NO";
				$cursor_auto = exequery( $connection, $query_auto );
				while ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$USER_PRIV = $ROW['USER_PRIV'];
					$PRIV_NAME = $ROW['PRIV_NAME'];
					$AUTO_VALUE .= "<option value=\"{$USER_PRIV}\"";
					if ( $ITEM_VALUE == $USER_PRIV )
					{
						$AUTO_VALUE .= " selected";
						$ITEM_VALUE_TEXT = $PRIV_NAME;
					}
					$AUTO_VALUE .= ">{$PRIV_NAME}</option>\n";
				}
				break;
			case "SYS_LIST_PRCSUSER1" :
				$query_auto = "select * from FLOW_PROCESS where FLOW_ID={$FLOW_ID} order by PRCS_ID";
				$cursor_auto = exequery( $connection, $query_auto );
				$PRCS_USER = "";
				while ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$PRCS_USER .= $ROW['PRCS_USER'];
				}
				$query_auto = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
				$cursor_auto = exequery( $connection, $query_auto );
				while ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$USER_ID = $ROW['USER_ID'];
					$USER_NAME = $ROW['USER_NAME'];
					if ( find_id( $PRCS_USER, $USER_ID ) )
					{
						$AUTO_VALUE .= "<option value=\"{$USER_ID}\"";
						if ( $ITEM_VALUE == $USER_ID )
						{
							$AUTO_VALUE .= " selected";
							$ITEM_VALUE_TEXT = $USER_NAME;
						}
						$AUTO_VALUE .= ">{$USER_NAME}</option>\n";
					}
				}
				break;
			case "SYS_LIST_PRCSUSER2" :
				$query_auto = "select * from FLOW_PROCESS where FLOW_ID={$FLOW_ID} and PRCS_ID={$FLOW_PRCS}";
				$cursor_auto = exequery( $connection, $query_auto );
				if ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$PRCS_USER = $ROW['PRCS_USER'];
				}
				$query_auto = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
				$cursor_auto = exequery( $connection, $query_auto );
				while ( $ROW = mysql_fetch_array( $cursor_auto ) )
				{
					$USER_ID = $ROW['USER_ID'];
					$USER_NAME = $ROW['USER_NAME'];
					if ( find_id( $PRCS_USER, $USER_ID ) || $ITEM_VALUE == $USER_ID )
					{
						$AUTO_VALUE .= "<option value=\"{$USER_ID}\"";
						if ( $ITEM_VALUE == $USER_ID )
						{
							$AUTO_VALUE .= " selected";
							$ITEM_VALUE_TEXT = $USER_NAME;
						}
						$AUTO_VALUE .= ">{$USER_NAME}</option>\n";
					}
				}
				break;
			case "SYS_LIST_SQL" :
				$EDATASRC = get_attr( $ELEMENT, "DATASRC" );
				$EDATASRC = str_replace( "`", "'", $EDATASRC );
				$EDATASRC = str_replace( "[SYS_USER_ID]", $LOGIN_USER_ID, $EDATASRC );
				$EDATASRC = str_replace( "[SYS_DEPT_ID]", $LOGIN_DEPT_ID, $EDATASRC );
				$cursor_SYS_SQL = exequery( $connection, $EDATASRC );
				while ( $ROW = mysql_fetch_array( $cursor_SYS_SQL ) )
				{
					$AUTO_VALUE_SQL = $ROW[0];
					$AUTO_VALUE .= "<option value=\"{$AUTO_VALUE_SQL}\"";
					if ( $ITEM_VALUE == $AUTO_VALUE_SQL )
					{
						$AUTO_VALUE .= " selected";
						$ITEM_VALUE_TEXT = $AUTO_VALUE_SQL;
					}
					$AUTO_VALUE .= ">{$AUTO_VALUE_SQL}</option>\n";
				}
			}
			$ELEMENT_OUT = str_replace( $EVALUE, $AUTO_VALUE, $ELEMENT_OUT );
		}
	}
	else if ( $ECLASS == "LIST_VIEW" )
	{
		$LV_ID = "DATA_".$ITEM_ID;
		$LV_TB_ID = "LV_".$ITEM_ID;
		$LV_TITLE = get_attr( $ELEMENT, "LV_TITLE" );
		$LV_SIZE = get_attr( $ELEMENT, "LV_SIZE" );
		$ELEMENT_OUT = "<TABLE id='{$LV_TB_ID}' class='LIST_VIEW' style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=2 bordercolor='#000000' FormData='{$LV_SIZE}'><TR class=TableHeader>\n";
		$MY_ARRAY = explode( "`", $LV_TITLE );
		$ARRAY_COUNT = sizeof( $MY_ARRAY );
		if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
		{
			--$ARRAY_COUNT;
		}
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT;	++$I	)
		{
			$ELEMENT_OUT .= "<TD nowrap>".$MY_ARRAY[$I]."</TD>\n";
		}
		$ELEMENT_OUT .= "<TD>操作</TD></TR></TABLE>\n";
		if ( !$READ_ONLY )
		{
			$ELEMENT_OUT .= "<input type=button value=新增 onclick=\"tb_addnew('{$LV_TB_ID}',".$READ_ONLY.",'')\">\n";
		}
		$ELEMENT_OUT .= "<input type=hidden name=".$LV_ID.">\n";
		$ELEMENT_OUT .= "<SCRIPT>\n";
		$ITEM_VALUE = str_replace( "'", "\\'", $ITEM_VALUE );
		$ITEM_VALUE = str_replace( "\"", "\\'", $ITEM_VALUE );
		$MY_ARRAY = explode( "\r\n", $ITEM_VALUE );
		$ARRAY_COUNT = sizeof( $MY_ARRAY );
		if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
		{
			--$ARRAY_COUNT;
		}
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT;	++$I	)
		{
			$ELEMENT_OUT .= "tb_addnew('{$LV_TB_ID}',".$READ_ONLY.",'".$MY_ARRAY[$I]."');\n";
		}
		$ELEMENT_OUT .= "</SCRIPT>";
	}
	if ( $READ_ONLY )
	{
		if ( strstr( $ELEMENT_OUT, "type=checkbox" ) )
		{
			if ( strstr( $ELEMENT_OUT, " CHECKED" ) )
			{
				$ELEMENT_OUT = str_replace( "<{$ENAME}", "<{$ENAME} readonly onclick='this.checked=1;' class=BigStatic1", $ELEMENT_OUT );
			}
			else
			{
				$ELEMENT_OUT = str_replace( "<{$ENAME}", "<{$ENAME} readonly onclick='this.checked=0;' class=BigStatic1", $ELEMENT_OUT );
			}
		}
		else if ( $ECLASS != "LIST_VIEW" )
		{
			$ELEMENT_OUT = "<{$ENAME} readonly class=BigStatic1 ".str_replace( "<{$ENAME}", "", $ELEMENT_OUT );
		}
		if ( $ENAME == "SELECT" )
		{
			$EVALUE = get_attr( $ELEMENT_OUT, "VALUE" );
			if ( $ECLASS != "AUTO" )
			{
				$ELEMENT_OUT = str_replace( $EVALUE, "<OPTION value={$ITEM_VALUE}>{$ITEM_VALUE}</OPTION>", $ELEMENT_OUT );
			}
			else
			{
				$ELEMENT_OUT = str_replace( $EVALUE, "<OPTION value={$ITEM_VALUE}>{$ITEM_VALUE_TEXT}</OPTION>", $ELEMENT_OUT );
			}
		}
	}
	if ( $ECLASS == "AUTO" && $ENAME == "INPUT" && !$READ_ONLY )
	{
		$ELEMENT_OUT .= "<INPUT type=\"button\" title=\"重新获取系统当前值\" value=\"刷新\" border=0 onclick=\"document.form1.DATA_{$ITEM_ID}.value='{$AUTO_VALUE}'\">";
	}
	$POS = strpos( $PRINT_MODEL, $ELEMENT, $POS );
	$PRINT_MODEL = substr( $PRINT_MODEL, 0, $POS ).$ELEMENT_OUT.substr( $PRINT_MODEL, $POS + strlen( $ELEMENT ) );
}
echo $PRINT_MODEL;
echo "\r\n    <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\">\r\n        <input type=\"hidden\"  name=\"SAVE_FLAG\" value=\"1\">\r\n        <input type=\"hidden\"  name=\"RUN_ID\" value=\"";
echo $RUN_ID;
echo "\">\r\n        <input type=\"hidden\"  name=\"FLOW_ID\" value=\"";
echo $FLOW_ID;
echo "\">\r\n        <input type=\"hidden\"  name=\"PRCS_ID\" value=\"";
echo $PRCS_ID;
echo "\">\r\n        <input type=\"hidden\"  name=\"FLOW_PRCS\" value=\"";
echo $FLOW_PRCS;
echo "\">\r\n        <input type=\"hidden\"  name=\"ITEM_ID_MAX\" value=\"";
echo $ITEM_ID;
echo "\">\r\n      </td>\r\n    </tr>\r\n</table>\r\n</form>\r\n<br>\r\n\r\n</body>\r\n</html>\r\n";
?>