form.inc.php

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

<?php

function sys_manager( $TMP_DEPT_ID )
{
	global $connection;
	global $LOGIN_USER_ID;
	$query = "SELECT MANAGER FROM DEPARTMENT WHERE DEPT_ID='".$TMP_DEPT_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$MANAGER = $ROW['MANAGER'];
	}
	if ( $MANAGER != "" )
	{
		$MANAGER_ARRAY = explode( ",", $MANAGER );
		$query = "SELECT USER_NAME FROM USER WHERE USER_ID='".$MANAGER_ARRAY['0']."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$AUTO_VALUE = $ROW['USER_NAME'];
			return $AUTO_VALUE;
		}
	}
	else
	{
		$query = "SELECT USER_ID,USER_NAME,USER_PRIV.USER_PRIV from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID='".$TMP_DEPT_ID."' and USER_ID!='{$LOGIN_USER_ID}' order by PRIV_NO,USER_NO,USER_NAME LIMIT 1";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$AUTO_VALUE = $ROW['USER_NAME'];
		}
	}
	return $AUTO_VALUE;
}

function sys_list_manager( $TMP_DEPT_ID )
{
	global $connection;
	global $LOGIN_USER_ID;
	$AUTO_VALUE = "";
	$query = "SELECT MANAGER FROM DEPARTMENT WHERE DEPT_ID='".$TMP_DEPT_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$MANAGER = $ROW['MANAGER'];
	}
	if ( $MANAGER != "" )
	{
		$MANAGER = substr( $MANAGER, 0, -1 );
		$query = "SELECT USER_ID,USER_NAME FROM USER WHERE find_in_set(USER_ID,'".$MANAGER."')";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$AUTO_VALUE .= "<option value=\"".$ROW['USER_ID']."\">".$ROW['USER_NAME']."</option>\n";
		}
	}
	else
	{
		$query = "SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID='".$TMP_DEPT_ID."' and USER_ID!='{$LOGIN_USER_ID}' order by PRIV_NO,USER_NO, USER_NAME";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$AUTO_VALUE .= "<option value=\"".$ROW['USER_ID']."\">".$ROW['USER_NAME']."</option>\n";
		}
	}
	return $AUTO_VALUE;
}

function getSignInfo( $RUN_ID, $FLOW_ID, $PRINT_MODEL )
{
	global $connection;
	$query = "SELECT PRCS_ID,FLOW_PRCS from FLOW_RUN_PRCS WHERE RUN_ID=".$RUN_ID;
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRCS_ID1 = $ROW['PRCS_ID'];
		$FLOW_PRCS1 = $ROW['FLOW_PRCS'];
		$query = "SELECT PRCS_NAME from FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID." AND PRCS_ID={$FLOW_PRCS1}";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$PRCS_NAME = $ROW['PRCS_NAME'];
		}
		if ( $PRCS_ID_ARRAY[$PRCS_ID1] == "" )
		{
			$PRCS_ID_ARRAY[$PRCS_ID1] = $PRCS_NAME;
		}
		else if ( $PRCS_ID_ARRAY[$PRCS_ID1] != $PRCS_NAME )
		{
			$PRCS_ID_ARRAY[$PRCS_ID1] .= ",".$PRCS_NAME;
		}
	}
	$TEMP_POS = 0;
	$SIGN_MACRO = array( );
	while ( $TEMP_POS = strpos( $PRINT_MODEL, "#[会签意见", $TEMP_POS ) )
	{
		$END_POS = strpos( $PRINT_MODEL, "]", $TEMP_POS );
		$SIGN_MACRO_NAME = substr( $PRINT_MODEL, $TEMP_POS, $END_POS - $TEMP_POS + 1 );
		$SIGN_MACRO_NUM = substr( $SIGN_MACRO_NAME, strpos( $SIGN_MACRO_NAME, "见", 0 ) + 2, -1 );
		$SIGN_MACRO[] = array(
			$SIGN_MACRO_NAME,
			$SIGN_MACRO_NUM
		);
		$TEMP_POS = $END_POS + 1;
	}
	foreach ( $SIGN_MACRO as $V )
	{
		$query = "SELECT * from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
		if ( $V[1] != "" )
		{
			$query .= " and PRCS_ID='".$V['1']."'";
		}
		$query .= " order by PRCS_ID,EDIT_TIME";
		$cursor = exequery( $connection, $query );
		$SIGN_CONTENT = "";
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$USER_ID = $ROW['USER_ID'];
			$PRCS_ID1 = $ROW['PRCS_ID'];
			$CONTENT = $ROW['CONTENT'];
			$EDIT_TIME = $ROW['EDIT_TIME'];
			$CONTENT = str_replace( "<", "&lt", $CONTENT );
			$CONTENT = str_replace( ">", "&gt", $CONTENT );
			$CONTENT = stripslashes( $CONTENT );
			$CONTENT = str_replace( "\n", "<br>", $CONTENT );
			$query1 = "SELECT USER_NAME,DEPT_ID from USER where USER_ID='".$USER_ID."'";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$USER_NAME = $ROW['USER_NAME'];
				$DEPT_ID = $ROW['DEPT_ID'];
				$DEPT_NAME = dept_long_name( $DEPT_ID );
			}
			if ( $PRCS_ID1 != 0 )
			{
				$SIGN_CONTENT .= "第".$PRCS_ID1."步 ".$PRCS_ID_ARRAY[$PRCS_ID1];
			}
			$SIGN_CONTENT .= " ".$USER_NAME."({$DEPT_NAME}):{$CONTENT} {$EDIT_TIME} <br>";
		}
		$PRINT_MODEL = str_replace( $V[0], $SIGN_CONTENT, $PRINT_MODEL );
	}
	return $PRINT_MODEL;
}

function getAttach( $RUN_ID, $ATTACHMENT_ID, $ATTACHMENT_NAME, $PRINT_MODEL )
{
	global $connection;
	$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
	$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
	$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
	$TEMP_POS = 0;
	$ATTACH_MACRO = array( );
	while ( $TEMP_POS = strpos( $PRINT_MODEL, "#[附件", $TEMP_POS ) )
	{
		$END_POS = strpos( $PRINT_MODEL, "]", $TEMP_POS );
		$ATTACH_MACRO_NAME = substr( $PRINT_MODEL, $TEMP_POS, $END_POS - $TEMP_POS + 1 );
		$ATTACH_MACRO_NUM = substr( $ATTACH_MACRO_NAME, strpos( $ATTACH_MACRO_NAME, "件", 0 ) + 2, -1 );
		$ATTACH_MACRO[] = array(
			$ATTACH_MACRO_NAME,
			$ATTACH_MACRO_NUM
		);
		$TEMP_POS = $END_POS + 1;
	}
	foreach ( $ATTACH_MACRO as $V )
	{
		if ( $V[1] != "" )
		{
			$ATTACH_INFO = attach_macro( $ATTACHMENT_ID_ARRAY[$V[1] - 1], $ATTACHMENT_NAME_ARRAY[$V[1] - 1] );
			$PRINT_MODEL = str_replace( $V[0], $ATTACH_INFO, $PRINT_MODEL );
			$ATTACH_ALL .= $ATTACH_INFO;
		}
	}
	if ( strstr( $PRINT_MODEL, "#[附件]" ) )
	{
		$PRINT_MODEL = str_replace( "#[附件]", $ATTACH_ALL, $PRINT_MODEL );
	}
	return $PRINT_MODEL;
}

?>