index_function.php

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

<?php

function getindexpara( $block_id )
{
	global $connection;
	$query = "\r\n\t\tSELECT * FROM `index_block` WHERE BLOCK_ID={$block_id}\r\n\t\t";
	$rc = exequery( $connection, $query );
	$row = mysql_fetch_array( $rc );
	$index_array = array(
		"block_row" => $row['BLOCK_ROW'],
		"subject_length" => $row['SUBJECT_LENGTH'],
		"common_id" => $row['COMMON_ID'],
		"is_show_date" => $row['IS_SHOW_DATE'],
		"is_show_creator" => $row['IS_SHOW_CREATOR'],
		"block_effect" => $row['BLOCK_EFFECT'],
		"common_str" => $row['COMMON_STR']
	);
	return $index_array;
}

function getusername( $user_id )
{
	global $connection;
	$user_spit = substr( $user_id, 0, -1 );
	$array_id = explode( ",", $user_spit );
	if ( count( $array_id ) == 1 )
	{
		$query = "\r\n\t\t\tSELECT USER_NAME FROM `user`  WHERE USER_ID = '".$user_id."' \r\n\t\t\t";
		$rc = exequery( $connection, $query );
		$row = mysql_fetch_array( $rc );
		$user_name = $row[0];
		return $user_name;
	}
	if ( 1 < count( $array_id ) )
	{
		$i = 0;
		for ( ;	$i < count( $array_id );	++$i	)
		{
			$query = "\r\n\t\t\t\tSELECT USER_NAME FROM `user`  WHERE USER_ID = '".$array_id[$i]."' \r\n\t\t\t\t";
			$rc = exequery( $connection, $query );
			$row = mysql_fetch_array( $rc );
			$user_name .= "&nbsp;";
			$user_name .= $row['USER_NAME'];
		}
		return $user_name;
	}
}

function getpersonfoldersortid( &$sort_num, $file_sort )
{
	$connection = openconnection( );
	if ( $file_sort == "" )
	{
		$sql = "\r\n\t\t\t\t  SELECT SORT_ID,SORT_PARENT,SORT_NAME,SORT_TYPE,USER_ID FROM file_sort\r\n\t\t\t\t\t  WHERE SORT_TYPE=4\r\n\t\t\t\t\t\t AND USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t\t     AND SORT_PARENT=0 \r\n\t\t\t\t\t       ORDER BY CREATE_TIME DESC\r\n\t\t\t   ";
	}
	else
	{
		$sql = "\r\n\t\t\t\t  SELECT SORT_ID,SORT_PARENT,SORT_NAME,SORT_TYPE,USER_ID FROM file_sort\r\n\t\t\t\t\t  WHERE SORT_PARENT=".$file_sort." \r\n\t\t\t\t\t  ORDER BY CREATE_TIME DESC\r\n\t\t\t   ";
	}
	$res = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $res ) )
	{
		$sort_num .= $row['SORT_ID'];
		$sort_num .= ",";
		getpersonfoldersortid( &$sort_num, $row['SORT_ID'] );
	}
	return $sort_num;
}

function getpublicfoldersortid( &$sort_num, $file_sort )
{
	$connection = openconnection( );
	$LOGIN_DEPT_ID = $_SESSION['LOGIN_DEPT_ID'];
	$LOGIN_USER_ID = $_SESSION['LOGIN_USER_ID'];
	if ( $file_sort == "" )
	{
		$sql = "\r\n\t\t\t\t SELECT * from FILE_SORT where (SORT_TYPE='1' or (SORT_TYPE='2' and INStr(DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(DEPT_ID,'{$LOGIN_DEPT_ID},')=1) or (SORT_TYPE='3' and (InStr(USER_ID,'{$LOGIN_USER_ID},')>0))) order by CREATE_TIME DESC\r\n\t\t\t   ";
	}
	else
	{
		$sql = "\r\n\t\t\t\t  SELECT SORT_ID,SORT_PARENT,SORT_NAME,SORT_TYPE,USER_ID FROM file_sort\r\n\t\t\t\t\t  WHERE SORT_PARENT=".$file_sort." \r\n\t\t\t\t\t  ORDER BY CREATE_TIME DESC\r\n\t\t\t   ";
	}
	$res = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $res ) )
	{
		$sort_num .= $row['SORT_ID'];
		$sort_num .= ",";
		getpublicfoldersortid( &$sort_num, $row['SORT_ID'] );
	}
	return $sort_num;
}

include_once( "inc/auth.php" );
?>