📄 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 <table class=\"TableList\" 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\r\n";
}
echo " </tr>\r\n\r\n";
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
$query = "SELECT * from USER where USER_ID='".$USER_ID."' and NOT_LOGIN!='1'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo "\r\n<tr class=\"TableData\">\r\n<td 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 CAL_TYPE!='2' 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'];
$MANAGER_ID = $ROW['MANAGER_ID'];
$OVER_STATUS = $ROW['OVER_STATUS'];
$MANAGER_NAME = "";
if ( $MANAGER_ID != "" )
{
$query = "SELECT * from USER where USER_ID='".$MANAGER_ID."'";
$cursor2 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor2 ) )
{
$MANAGER_NAME = "安排人：".$ROW1['USER_NAME']."<br>";
}
}
if ( $OVER_STATUS == "" || $OVER_STATUS == "1" )
{
$OVER_STATUS1 = "<font color='#00AA00'><b>已结束</b></font>";
}
else if ( $OVER_STATUS == "0" )
{
$OVER_STATUS1 = "";
}
$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 );
echo " ";
echo $CAL_TIME;
echo "-";
echo $END_TIME;
echo "<br>\r\n";
if ( $MANAGER_ID == $LOGIN_USER_ID )
{
echo " <a href=\"javascript:;\" onClick=\"window.open('new.php?CAL_ID=";
echo $CAL_ID;
echo "','oa_sub_window','height=300,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes');\">";
echo $CONTENT;
echo "</a> ";
echo $OVER_STATUS1;
echo " <a href=\"delete.php?CAL_ID=";
echo $CAL_ID;
echo "&YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&BEGIN_DAY=";
echo $BEGIN_DAY;
echo "&END_DAY=";
echo $END_DAY;
echo "&USER_ID=";
echo $USER_ID;
echo "\">删除</a>\r\n";
}
else
{
echo " ";
echo $CONTENT;
echo " ";
echo $OVER_STATUS1;
}
echo " <br>";
echo $MANAGER_NAME;
}
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 + -