📄 user_list.php
字号:
<?php
include_once( "inc/auth.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=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/calendar.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 日程安排查询结果</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
if ( $DEPT_ID == "" )
{
message( "", "<br>未定义部门" );
exit( );
}
echo "\r\n <table border=\"0\" cellspacing=\"1\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n <tr align=\"center\" class=\"TableHeader\">\r\n <td width=\"80\">姓名</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 ">\r\n ";
echo $YEAR;
echo "-";
echo $MONTH;
echo "-";
echo $DAY;
echo "<br>\r\n (周";
echo $WEEK_DESC;
echo ")\r\n </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 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo "\r\n<tr>\r\n<td class=\"TableData\" width=\"80\" align=\"center\">";
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 = "TableContent";
}
else
{
$DAY_COLOR = "TableData";
}
echo " <td class=\"";
echo $DAY_COLOR;
echo "\">\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( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $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 " ";
echo $CAL_TIME;
echo "-";
echo $END_TIME;
echo "<br>";
echo $CONTENT;
echo " <br><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 + -