📄 user_list.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>员工日程安排查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n  <tr>\r\n    <td >";
echo "<s";
echo "pan style=\"font-weight : bold \">日程安排查询结果</span></td>\r\n  </tr>\r\n</table>\r\n";
if ( $DEPT_ID == "" )
{
	message( "", "<br>未定义部门" );
	exit( );
}
echo "\r\n  <table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" class=\"small\">\r\n    <tr  class=\"TableHeader\">\r\n      <td width=\"80\" ><div align=\"left\">姓名</div></td>\r\n";
$DAY = $BEGIN_DAY;
for ( ;	$DAY <= $END_DAY;	++$DAY	)
{
	$WEEK = date( "w", mktime( 0, 0, 0, $MONTH, $DAY, $YEAR ) );
	switch ( $WEEK )
	{
	case 0 :
		$WEEK_DESC = "日";
		break;
	case 1 :
		$WEEK_DESC = "一";
		break;
	case 2 :
		$WEEK_DESC = "二";
		break;
	case 3 :
		$WEEK_DESC = "三";
		break;
	case 4 :
		$WEEK_DESC = "四";
		break;
	case 5 :
		$WEEK_DESC = "五";
		break;
	case 6 :
		$WEEK_DESC = "六";
	}
	echo "\r\n      <td ";
	if ( $WEEK == 0 )
	{
		echo "bgcolor=#FFCCFF";
	}
	else if ( $WEEK == 6 )
	{
		echo "bgcolor=#CCFFCC";
	}
	echo ">";
	echo "<s";
	echo "pan style=\"font-weight : normal \">周";
	echo $WEEK_DESC;
	echo "      </span>";
	echo "<s";
	echo "pan style=\"color:#666666;font-size:9px;font-weight : normal\">";
	echo date( "y", time( $YEAR ) );
	echo "-";
	echo $MONTH;
	echo "-";
	echo $DAY;
	echo "</span></td>\r\n      ";
}
echo "    </tr>\r\n\r\n";
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
$connection = openconnection( );
$query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID={$DEPT_ID} order by PRIV_NO";
$cursor1 = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$FLOW_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "<tr class=\"";
	echo $TableLine;
	echo "\">\r\n<td width=\"80\">";
	echo $USER_NAME;
	echo "</td>\r\n\r\n";
	$DAY = $BEGIN_DAY;
	for ( ;	$DAY <= $END_DAY;	++$DAY	)
	{
		if ( $DAY == $CUR_DAY && $YEAR == $CUR_YEAR && $MONTH == $CUR_MON )
		{
			$DAY_COLOR = "TableLine1";
		}
		else
		{
			$DAY_COLOR = "TableLine1";
		}
		echo "     <td>\r\n";
		$query = "SELECT * from CALENDAR where USER_ID='{$USER_ID}' and to_days(CAL_TIME)=to_days('{$YEAR}-{$MONTH}-{$DAY}') order by CAL_TIME";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$CAL_ID = $ROW['CAL_ID'];
			$CAL_TIME = $ROW['CAL_TIME'];
			$END_TIME = $ROW['END_TIME'];
			$CAL_TYPE = $ROW['CAL_TYPE'];
			$CONTENT = $ROW['CONTENT'];
			$CONTENT = str_replace( "<", "&lt", $CONTENT );
			$CONTENT = str_replace( ">", "&gt", $CONTENT );
			$CONTENT = stripslashes( $CONTENT );
			$CAL_DAY = strtok( $CAL_TIME, "-" );
			$CAL_DAY = strtok( "-" );
			$CAL_DAY = strtok( " " );
			if ( substr( $CAL_DAY, 0, 1 ) == "0" )
			{
				$CAL_DAY = substr( $CAL_DAY, -1 );
			}
			$CAL_TIME = strtok( $CAL_TIME, " " );
			$CAL_TIME = strtok( " " );
			$CAL_TIME = substr( $CAL_TIME, 0, 5 );
			$END_TIME = strtok( $END_TIME, " " );
			$END_TIME = strtok( " " );
			$END_TIME = substr( $END_TIME, 0, 5 );
			if ( $CAL_TYPE == "1" )
			{
				echo "     <a href='../arrange/note.php?CAL_ID=";
				echo $CAL_ID;
				echo "' target='_blank'>";
				echo $CAL_TIME;
				echo "-";
				echo $END_TIME;
				echo "<br>";
				echo substrgb( $CONTENT, 10, "..." );
				echo "</a>&nbsp;<br>\r\n";
			}
		}
		echo "    </td>\r\n";
	}
	echo "   </tr>\r\n";
}
echo "</table>\r\n\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -