utility_all.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

	global $LOGIN_DEPT_ID;
	global $connection;
	$query = "SELECT * from USER where USER_ID='{$LOGIN_USER_ID}'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$POST_PRIV = $ROW['POST_PRIV'];
		$POST_DEPT = $ROW['POST_DEPT'];
	}
	if ( $POST_PRIV == 0 && $DEPT_ID != $LOGIN_DEPT_ID && !is_dept_parent( $DEPT_ID, $LOGIN_DEPT_ID ) )
	{
		$DEPT_PRIV = 0;
	}
	else if ( $POST_PRIV == 2 )
	{
		$DEPT_PRIV = 0;
		$MY_ARRAY = explode( ",", $POST_DEPT );
		$ARRAY_COUNT = sizeof( $MY_ARRAY );
		if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
		{
			--$ARRAY_COUNT;
		}
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT;	++$I	)
		{
			if ( is_dept_parent( $DEPT_ID, $MY_ARRAY[$I] ) || $MY_ARRAY[$I] == $DEPT_ID )
			{
				$DEPT_PRIV = 1;
			}
		}
	}
	else
	{
		$DEPT_PRIV = 1;
	}
	return $DEPT_PRIV;
}

function my_dept_tree( $DEPT_ID, $DEPT_CHOOSE, $POST_OP, $NO_CHILD_DEPT = 0 )
{
	global $DEEP_COUNT;
	if ( $DEEP_COUNT == "" )
	{
		$DEEP_COUNT = "|";
	}
	global $connection;
	$query = "SELECT * from DEPARTMENT where DEPT_PARENT={$DEPT_ID} order by DEPT_NO";
	$cursor = exequery( $connection, $query );
	$OPTION_TEXT = "";
	$DEEP_COUNT1 = $DEEP_COUNT;
	$DEEP_COUNT .= "　|";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$COUNT;
		$DEPT_ID = $ROW['DEPT_ID'];
		$DEPT_NAME = $ROW['DEPT_NAME'];
		$DEPT_PARENT = $ROW['DEPT_PARENT'];
		$DEPT_NAME = str_replace( "<", "&lt", $DEPT_NAME );
		$DEPT_NAME = str_replace( ">", "&gt", $DEPT_NAME );
		$DEPT_NAME = stripslashes( $DEPT_NAME );
		if ( $POST_OP == 1 )
		{
			$DEPT_PRIV = is_dept_priv( $DEPT_ID );
		}
		else
		{
			$DEPT_PRIV = 1;
		}
		if ( $NO_CHILD_DEPT != $DEPT_ID )
		{
			$OPTION_TEXT_CHILD = my_dept_tree( $DEPT_ID, $DEPT_CHOOSE, $POST_OP, $NO_CHILD_DEPT );
		}
		if ( $DEPT_PRIV == 1 )
		{
			$OPTION_TEXT .= "<option ";
			if ( $DEPT_ID == $DEPT_CHOOSE )
			{
				$OPTION_TEXT .= "selected ";
			}
			$OPTION_TEXT .= "value={$DEPT_ID}>".$DEEP_COUNT1."─".$DEPT_NAME."</option>\n";
		}
		if ( $NO_CHILD_DEPT != $DEPT_ID && $OPTION_TEXT_CHILD != "" )
		{
			$OPTION_TEXT .= $OPTION_TEXT_CHILD;
		}
	}
	$DEEP_COUNT = $DEEP_COUNT1;
	return $OPTION_TEXT;
}

function dept_long_name( $DEPT_ID )
{
	global $connection;
	$query = "SELECT * from DEPARTMENT where DEPT_ID='{$DEPT_ID}'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DEPT_NAME = $ROW['DEPT_NAME'];
		$DEPT_PARENT = $ROW['DEPT_PARENT'];
		if ( $DEPT_PARENT == 0 )
		{
			return $DEPT_NAME;
		}
		else
		{
			return dept_long_name( $DEPT_PARENT )."/".$DEPT_NAME;
		}
	}
}

function image_mimetype( $fichier )
{
	if ( eregi( "\\.mid\$", $fichier ) )
	{
		$image = "mid.gif";
	}
	else if ( eregi( "\\.txt\$", $fichier ) )
	{
		$image = "txt.gif";
	}
	else if ( eregi( "\\.sql\$", $fichier ) )
	{
		$image = "txt.gif";
	}
	else if ( eregi( "\\.js\$", $fichier ) )
	{
		$image = "js.gif";
	}
	else if ( eregi( "\\.gif\$", $fichier ) )
	{
		$image = "gif.gif";
	}
	else if ( eregi( "\\.jpg\$", $fichier ) )
	{
		$image = "jpg.gif";
	}
	else if ( eregi( "\\.html\$", $fichier ) )
	{
		$image = "html.gif";
	}
	else if ( eregi( "\\.htm\$", $fichier ) )
	{
		$image = "html.gif";
	}
	else if ( eregi( "\\.rar\$", $fichier ) )
	{
		$image = "rar.gif";
	}
	else if ( eregi( "\\.gz\$", $fichier ) )
	{
		$image = "zip.gif";
	}
	else if ( eregi( "\\.tgz\$", $fichier ) )
	{
		$image = "zip.gif";
	}
	else if ( eregi( "\\.z\$", $fichier ) )
	{
		$image = "zip.gif";
	}
	else if ( eregi( "\\.ra\$", $fichier ) )
	{
		$image = "ram.gif";
	}
	else if ( eregi( "\\.ram\$", $fichier ) )
	{
		$image = "ram.gif";
	}
	else if ( eregi( "\\.rm\$", $fichier ) )
	{
		$image = "ram.gif";
	}
	else if ( eregi( "\\.pl\$", $fichier ) )
	{
		$image = "pl.gif";
	}
	else if ( eregi( "\\.zip\$", $fichier ) )
	{
		$image = "zip.gif";
	}
	else if ( eregi( "\\.wav\$", $fichier ) )
	{
		$image = "wav.gif";
	}
	else if ( eregi( "\\.php\$", $fichier ) )
	{
		$image = "php.gif";
	}
	else if ( eregi( "\\.phtml\$", $fichier ) )
	{
		$image = "php.gif";
	}
	else if ( eregi( "\\.exe\$", $fichier ) )
	{
		$image = "exe.gif";
	}
	else if ( eregi( "\\.bmp\$", $fichier ) )
	{
		$image = "bmp.gif";
	}
	else if ( eregi( "\\.png\$", $fichier ) )
	{
		$image = "gif.gif";
	}
	else if ( eregi( "\\.css\$", $fichier ) )
	{
		$image = "css.gif";
	}
	else if ( eregi( "\\.mp3\$", $fichier ) )
	{
		$image = "mp3.gif";
	}
	else if ( eregi( "\\.xls\$", $fichier ) )
	{
		$image = "xls.gif";
	}
	else if ( eregi( "\\.doc\$", $fichier ) )
	{
		$image = "doc.gif";
	}
	else if ( eregi( "\\.pdf\$", $fichier ) )
	{
		$image = "pdf.gif";
	}
	else if ( eregi( "\\.mov\$", $fichier ) )
	{
		$image = "mov.gif";
	}
	else if ( eregi( "\\.avi\$", $fichier ) )
	{
		$image = "avi.gif";
	}
	else if ( eregi( "\\.mpg\$", $fichier ) )
	{
		$image = "mpg.gif";
	}
	else if ( eregi( "\\.mpeg\$", $fichier ) )
	{
		$image = "mpeg.gif";
	}
	else if ( eregi( "\\.swf\$", $fichier ) )
	{
		$image = "flash.gif";
	}
	else
	{
		$image = "defaut.gif";
	}
	return $image;
}

function my_sort_tree( $SORT_ID_CHOOSE, $FILE_SORT, $PARENT_ID, $IS_SORT )
{
	global $DEEP_COUNT;
	global $LOGIN_DEPT_ID;
	global $LOGIN_USER_ID;
	if ( $DEEP_COUNT == "" )
	{
		$DEEP_COUNT = "|";
	}
	global $connection;
	if ( $PARENT_ID == 0 )
	{
		if ( $FILE_SORT == 1 )
		{
			$query = "SELECT * from FILE_SORT where (SORT_TYPE='1' or (SORT_TYPE='2' and DEPT_ID={$LOGIN_DEPT_ID}) or (SORT_TYPE='3' and (InStr(USER_ID,',{$LOGIN_USER_ID},')>0 or InStr(USER_ID,'{$LOGIN_USER_ID},')=1))) and SORT_PARENT={$PARENT_ID} order by SORT_NO,SORT_NAME";
		}
		else
		{
			$query = "SELECT * from FILE_SORT where SORT_TYPE='4' and USER_ID='{$LOGIN_USER_ID}' and SORT_PARENT={$PARENT_ID} order by SORT_NO,SORT_NAME";
		}
	}
	else
	{
		$query = "SELECT * from FILE_SORT where SORT_PARENT={$PARENT_ID} order by SORT_NO,SORT_NAME";
	}
	$cursor = exequery( $connection, $query );
	$OPTION_TEXT = "";
	if ( $FILE_SORT == 2 && $PARENT_ID == 0 )
	{
		$OPTION_TEXT = "<option value=0>根目录</option>\n";
	}
	$DEEP_COUNT1 = $DEEP_COUNT;
	$DEEP_COUNT .= "　|";
	$XML_TEXT = "";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_ID = $ROW['SORT_ID'];
		$USER_ID = $ROW['USER_ID'];
		$NEW_USER = $ROW['NEW_USER'];
		$SORT_NAME = $ROW['SORT_NAME'];
		if ( $IS_SORT == 1 && $SORT_ID == $SORT_ID_CHOOSE )
		{
		}
		else
		{
			if ( $FILE_SORT == 1 )
			{
				if ( $USER_ID == "" )
				{
					$USER_ID = access_priv( $SORT_ID );
				}
				if ( $NEW_USER == "" )
				{
					$NEW_USER = sort_priv( $SORT_ID, "NEW_USER" );
				}
				if ( !find_id( $USER_ID, $LOGIN_USER_ID ) )
				{
					continue;
				}
			}
			$SORT_NAME = htmlspecialchars( $SORT_NAME );
			$OPTION_TEXT .= "<option value={$SORT_ID}";
			if ( $FILE_SORT == 1 && !find_id( $NEW_USER, $LOGIN_USER_ID ) )
			{
				$OPTION_TEXT .= " style='color:gray;'";
			}
			if ( $SORT_ID == $SORT_ID_CHOOSE )
			{
				$OPTION_TEXT .= " selected";
			}
			$OPTION_TEXT .= ">".$DEEP_COUNT1."─".$SORT_NAME."</option>\n";
			$OPTION_TEXT_CHILD = my_sort_tree( $SORT_ID_CHOOSE, $FILE_SORT, $SORT_ID, $IS_SORT );
			if ( $OPTION_TEXT_CHILD != "" )
			{
				$OPTION_TEXT .= $OPTION_TEXT_CHILD;
			}
		}
	}
	$DEEP_COUNT = $DEEP_COUNT1;
	return $OPTION_TEXT;
}

function doc2txt( $path )
{
	exec( $_SERVER['DOCUMENT_ROOT']."inc/doc2txt.exe -q -s {$path}", $OUT_ARRAY );
	$count = count( $OUT_ARRAY );
	$i = 0;
	for ( ;	$i < $count;	++$i	)
	{
		$OUT .= $OUT_ARRAY[$i]."\n";
	}
	return $OUT;
}

function affair_sms( )
{
	global $LOGIN_USER_ID;
	$CUR_DATE = date( "Y-m-d", time( ) );
	$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
	global $connection;
	$query = "SELECT * from AFFAIR where USER_ID='{$LOGIN_USER_ID}' and BEGIN_TIME<='{$CUR_TIME}' and (LAST_REMIND<'{$CUR_DATE}' or LAST_REMIND='0000-00-00')";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$AFF_ID = $ROW['AFF_ID'];
		$USER_ID = $ROW['USER_ID'];
		$TYPE = $ROW['TYPE'];
		$REMIND_DATE = $ROW['REMIND_DATE'];
		$REMIND_TIME = $ROW['REMIND_TIME'];
		$CONTENT = $ROW['CONTENT'];
		$SEND_TIME = date( "Y-m-d", time( ) )." ".$REMIND_TIME;
		$SMS_CONTENT = "日常事务提醒：".csubstr( &$CONTENT, 0, 100 );
		$FLAG = 0;
		if ( $TYPE == "2" )
		{
			$FLAG = 1;
		}
		else if ( $TYPE == "3" && date( "w", time( ) ) == $REMIND_DATE )
		{
			$FLAG = 1;
		}
		else if ( $TYPE == "4" && date( "j", time( ) ) == $REMIND_DATE )
		{
			$FLAG = 1;
		}
		else if ( $TYPE == "5" )
		{
			$REMIND_ARR = explode( "-", $REMIND_DATE );
			$REMIND_DATE_MON = $REMIND_ARR[0];
			$REMIND_DATE_DAY = $REMIND_ARR[1];
			if ( date( "n", time( ) ) == $REMIND_DATE_MON && date( "j", time( ) ) == $REMIND_DATE_DAY )
			{
				$FLAG = 1;
			}
		}
		if ( $FLAG == 1 )
		{
			$query = "insert into SMS(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG) values ('{$LOGIN_USER_ID}','{$LOGIN_USER_ID}','5','{$SMS_CONTENT}','{$SEND_TIME}','1')";
			exequery( $connection, $query );
			$query = "update AFFAIR set LAST_REMIND='{$CUR_DATE}' where AFF_ID={$AFF_ID}";
			exequery( $connection, $query );
		}
	}
}

function top_dept( $DEPT_ID )
{
	global $connection;
	$query = "SELECT * from DEPARTMENT where DEPT_ID='{$DEPT_ID}'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DEPT_PARENT = $ROW['DEPT_PARENT'];
		if ( $DEPT_PARENT == 0 )
		{
			return $DEPT_ID;
		}
		else
		{
			return top_dept( $DEPT_PARENT );
		}
	}
}

function access_priv( $SORT_PARENT )
{
	if ( $SORT_PARENT == 0 )
	{
		return;
	}
	global $connection;
	$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_PARENT}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_PARENT = $ROW['SORT_PARENT'];
		$SORT_TYPE = $ROW['SORT_TYPE'];
		$DEPT_ID = $ROW['DEPT_ID'];
		$USER_ID = $ROW['USER_ID'];
	}
	if ( $SORT_PARENT == 0 && $USER_ID == "" )
	{
		if ( $SORT_TYPE == "1" )
		{
			$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
		}
		else if ( $SORT_TYPE == "2" )
		{
			$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.DEPT_ID='{$DEPT_ID}' and USER.USER_PRIV=USER_PRIV.USER_PRIV";
		}
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$USER_ID .= $ROW['USER_ID'].",";
		}
	}
	if ( $USER_ID != "" )
	{
		return $USER_ID;
	}
	else
	{
		return access_priv( $SORT_PARENT );
	}
}

function sort_priv( $SORT_ID, $PRIV_TYPE )
{
	if ( $SORT_ID == 0 )
	{
		return;
	}
	global $connection;
	$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_ID}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_PARENT = $ROW['SORT_PARENT'];
		$SORT_TYPE = $ROW['SORT_TYPE'];
		$DEPT_ID = $ROW['DEPT_ID'];
		$USER_ID = $ROW['USER_ID'];
		$MANAGE_USER = $ROW['MANAGE_USER'];
		$DOWN_USER = $ROW['DOWN_USER'];
		$NEW_USER = $ROW['NEW_USER'];
	}
	if ( $$PRIV_TYPE != "" )
	{
		return $$PRIV_TYPE;
	}
	else
	{
		return sort_priv( $SORT_PARENT, $PRIV_TYPE );
	}
}

function sort_attrib( $SORT_ID, $ATTRIB )
{
	global $connection;
	$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_ID}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_PARENT = $ROW['SORT_PARENT'];
	}
	if ( $SORT_PARENT == 0 )
	{
		return $ROW[$ATTRIB];
	}
	else
	{
		return sort_attrib( $SORT_PARENT, $ATTRIB );
	}
}

function get_code_name( $CODE_NO, $PARENT_NO )
{
	global $connection;
	$query = "SELECT * from SYS_CODE where PARENT_NO='{$PARENT_NO}' and CODE_NO='{$CODE_NO}'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$CODE_NAME = $ROW['CODE_NAME'];
	}
	return $CODE_NAME;
}

function get_code_n0( $CODE, $PARENT, $M_CODE )
{
	global $connection;
	global $TD_MYOA_COMPANY_NAME;
	if ( $PARENT != $TD_MYOA_COMPANY_NAME )
	{
		exit( );