📄 month.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
include_once( "check_priv.php" );
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
if ( $BTN_OP != "" )
{
$DATE = strtotime( $BTN_OP, strtotime( $YEAR."-".$MONTH."-".$DAY ) );
$YEAR = date( "Y", $DATE );
$MONTH = date( "m", $DATE );
$DAY = date( "d", $DATE );
}
if ( !$YEAR )
{
$YEAR = $CUR_YEAR;
}
if ( !$MONTH )
{
$MONTH = $CUR_MON;
}
if ( !$DAY )
{
$DAY = $CUR_DAY;
}
if ( !checkdate( $MONTH, $DAY, $YEAR ) )
{
message( "错误", "日期不正确" );
exit( );
}
$DATE = strtotime( $YEAR."-".$MONTH."-".$DAY );
$MONTH_BEGIN = strtotime( $YEAR."-".$MONTH."-01" );
$MONTH_END = strtotime( $YEAR."-".$MONTH."-".date( "t", $DATE ) );
$WEEKS = date( "W", $MONTH_BEGIN );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$CONDITION_STR = "";
if ( $_GET['OVER_STATUS'] == "1" )
{
$CONDITION_STR .= " and OVER_STATUS='0' and CAL_TIME>'".$CUR_TIME."'";
$STATUS_DESC = "<font color='#0000FF'>未开始</font>";
}
else if ( $_GET['OVER_STATUS'] == "2" )
{
$CONDITION_STR .= " and OVER_STATUS='0' and CAL_TIME<='".$CUR_TIME."' and END_TIME>='{$CUR_TIME}'";
$STATUS_DESC = "<font color='#0000FF'>进行中</font>";
}
else if ( $_GET['OVER_STATUS'] == "3" )
{
$CONDITION_STR .= " and OVER_STATUS='0' and END_TIME<'".$CUR_TIME."'";
$STATUS_DESC = "<font color='#FF0000'>已超时</font>";
}
else if ( $_GET['OVER_STATUS'] == "4" )
{
$CONDITION_STR .= " and OVER_STATUS='1'";
$STATUS_DESC = "<font color='#00AA00'>已完成</font>";
}
else
{
$STATUS_DESC = "全部";
}
echo "<html>\n<head>\n<title>日程安排查询</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/calendar.css\">\n</head>\n<script src=\"/inc/js/attach.js\"></script>\n<script src=\"/inc/js/calendar.js\"></script>\n<script>\nfunction init()\n{\n var tbl = \$(\"cal_table\");\n if(!tbl) return;\n for(i=0;i<tbl.rows.length;i++)\n {\n for(j=0;j<tbl.rows[i].cells.length;j++)\n {\n var td=tbl.rows[i].cells[j];\n if(td.id.substr(0,3)==\"td_\")\n {\n td.ondblclick =function() {new_arrange('";
echo $USER_ID;
echo "',this.id.substr(3),'+1 days');};\n }\n else if(td.id.substr(0,3)==\"tw_\")\n {\n td.ondblclick =function() {new_arrange('";
echo $USER_ID;
echo "',this.id.substr(3),'+1 weeks');};\n td.title=\"双击建立周事务\";\n }\n }\n }\n}\n</script>\n</head>\n\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"init();\">\n<div class=\"small\" style=\"clear:both;\">\n <div style=\"float:left;\">\n <form name=\"form1\" action=\"";
echo $_SERVER['SCRIPT_NAME'];
echo "\" style=\"margin-bottom:5px;\">\n <input type=\"hidden\" value=\"\" name=\"BTN_OP\">\n <input type=\"hidden\" value=\"";
echo $_GET['OVER_STATUS'];
echo "\" name=\"OVER_STATUS\">\n <input type=\"hidden\" value=\"";
echo $DAY;
echo "\" name=\"DAY\">\n <input type=\"button\" value=\"今天\" class=\"SmallButton\" title=\"今天\" onclick=\"location='";
echo $_SERVER['SCRIPT_NAME'];
echo "?YEAR=";
echo $CUR_YEAR;
echo "&MONTH=";
echo $CUR_MON;
echo "&DAY=";
echo $CUR_DAY;
echo "'\">\n<!-------------- 年 ------------>\n <a href=\"javascript:set_year(-1);\" class=\"ArrowButtonLL\" title=\"上一年\"></a>\n <a href=\"javascript:set_mon(-1);\" class=\"ArrowButtonL\" title=\"上一月\"></a>\n <select name=\"YEAR\" class=\"SmallSelect\" onchange=\"My_Submit();\">\n";
$I = 2000;
for ( ; $I <= 2030; ++$I )
{
echo " <option value=\"";
echo $I;
echo "\" ";
if ( $I == $YEAR )
{
echo "selected";
}
echo ">";
echo $I;
echo "年</option>\n";
}
echo " </select>\n<!-------------- 月 ------------>\n <select name=\"MONTH\" class=\"SmallSelect\" onchange=\"My_Submit();\">\n";
$I = 1;
for ( ; $I <= 12; ++$I )
{
if ( $I < 10 )
{
$I = "0".$I;
}
echo " <option value=\"";
echo $I;
echo "\" ";
if ( $I == $MONTH )
{
echo "selected";
}
echo ">";
echo $I;
echo "月</option>\n";
}
echo " </select>\n <a href=\"javascript:set_mon(1);\" class=\"ArrowButtonR\" title=\"下一月\"></a>\n <a href=\"javascript:set_year(1);\" class=\"ArrowButtonRR\" title=\"下一年\"></a> \n <a id=\"status\" href=\"javascript:;\" class=\"dropdown\" onclick=\"showMenu(this.id,'1');\" hidefocus=\"true\"><span>";
echo $STATUS_DESC;
echo menu_arrow( "DOWN" );
echo "</span></a>\n <div id=\"status_menu\" class=\"attach_div\">\n <a href=\"javascript:set_status('');\">全部</a>\n <a href=\"javascript:set_status(1);\" style=\"color:#0000FF;\">未开始</a>\n <a href=\"javascript:set_status(2);\" style=\"color:#0000FF;\">进行中</a>\n <a href=\"javascript:set_status(3);\" style=\"color:#FF0000;\">已超时</a>\n <a href=\"javascript:set_status(4);\" style=\"color:#00AA00;\">已完成</a>\n </div>\n </div>\n <div style=\"float:right;\">\n <input type=\"button\" value=\"查询\" class=\"SmallButton\" title=\"查询\" onclick=\"location='query.php'\">\n";
if ( $DEPT_PRIV != "3" )
{
echo " <select name=\"DEPT_ID\" class=\"SmallSelect\" onchange=\"My_Submit();\">\n";
echo my_dept_tree( 0, $DEPT_ID, array(
"DEPT_PRIV" => $DEPT_PRIV,
"DEPT_ID_STR" => $DEPT_ID_STR
) );
echo " </select>\n";
}
echo " <select name=\"USER_ID\" class=\"SmallSelect\" onchange=\"My_Submit();\">\n";
$COUNT = 0;
$query = "SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!='1'".$WHERE_STR." order by PRIV_NO,USER_NO,USER_NAME";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$COUNT;
$USER_ID1 = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo " <option value=\"";
echo $USER_ID1;
echo "\"";
if ( $USER_ID1 == $USER_ID )
{
echo "selected";
}
echo ">";
echo $USER_NAME;
echo "</option>\n";
if ( !$USER_ID )
{
if ( $COUNT == 1 )
{
$USER_ID = $USER_ID1;
}
}
}
echo " </select>\n <span class=\"\">\n <a href=\"javascript:set_view('day','cal_info_view');\" title=\"日视图\"><span><img src=\"/images/cal_day.gif\" align=\"absMiddle\">日</span></a>\n <a href=\"javascript:set_view('index','cal_info_view');\" title=\"周视图\"><span><img src=\"/images/cal_week.gif\" align=\"absMiddle\">周</span></a>\n <a href=\"javascript:set_view('month','cal_info_view');\" title=\"月视图\"><span><img src=\"/images/cal_month.gif\" align=\"absMiddle\">月</span></a>\n </span>\n </form>\n </div>\n</div>\n\n";
if ( !$USER_ID )
{
message( "", "请选择用户" );
exit( );
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$CODE_NAME = array( );
$MANAGER = array( );
$query = "SELECT * from CALENDAR where USER_ID='".$USER_ID."'".$CONDITION_STR." and CAL_TYPE!='2' and (CAL_TIME>='".date( "Y-m-d", $MONTH_BEGIN )." 00:00:00' and CAL_TIME<='".date( "Y-m-d", $MONTH_END )." 23:59:59' || END_TIME>='".date( "Y-m-d", $MONTH_BEGIN )." 00:00:00' and END_TIME<='".date( "Y-m-d", $MONTH_END )." 23:59:59' || CAL_TIME<='".date( "Y-m-d", $MONTH_BEGIN )." 00:00:00' and END_TIME>='".date( "Y-m-d", $MONTH_END )." 23:59:59') 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'];
$CAL_LEVEL = $ROW['CAL_LEVEL'];
$CONTENT = $ROW['CONTENT'];
$MANAGER_ID = $ROW['MANAGER_ID'];
$OVER_STATUS = $ROW['OVER_STATUS'];
if ( !array_key_exists( $CAL_TYPE, $CODE_NAME ) )
{
$CODE_NAME[$CAL_TYPE] = get_code_name( $CAL_TYPE, "CAL_TYPE" );
}
$CAL_TITLE = "类型：".$CODE_NAME[$CAL_TYPE]."\n";
if ( $OVER_STATUS == "0" )
{
if ( 0 < compare_time( $CUR_TIME, $END_TIME ) )
{
$STATUS_COLOR = "#FF0000";
$CAL_TITLE .= "状态：已超时";
}
else if ( compare_time( $CUR_TIME, $CAL_TIME ) < 0 )
{
$STATUS_COLOR = "#0000FF";
$CAL_TITLE .= "状态：未开始";
}
else
{
$STATUS_COLOR = "#0000FF";
$CAL_TITLE .= "状态：进行中";
}
}
else
{
$STATUS_COLOR = "#00AA00";
$CAL_TITLE .= "状态：已完成";
}
if ( $MANAGER_ID != "" )
{
if ( !array_key_exists( $MANAGER_ID, $MANAGER ) )
{
$query = "SELECT USER_NAME from USER where USER_ID='".$MANAGER_ID."'";
$cursor2 = exequery( $connection, $query );
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$MANAGER[$MANAGER_ID] = $ROW2['USER_NAME'];
}
}
$CAL_TITLE .= "\n安排人：".$MANAGER[$MANAGER_ID];
}
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 50 );
if ( substr( $CAL_TIME, 0, 10 ) != substr( $END_TIME, 0, 10 ) )
{
$ALL_DAY = "<div title='".$CAL_TITLE."'>";
if ( substr( $CAL_TIME, 0, 10 ) < date( "Y-m-d", $MONTH_BEGIN ) )
{
$ALL_DAY .= "<a href=\"javascript:set_mon(-1);\" title=\"上一月\">".menu_arrow( "LEFT" )."</a> ";
}
$ALL_DAY .= "<span class=\"CalLevel".$CAL_LEVEL."\" title=\"".cal_level_desc( $CAL_LEVEL )."\">".substr( $CAL_TIME, 0, 16 )." - ".substr( $END_TIME, 0, 16 )."</span> <a id=\"cal_".$CAL_ID.( "\" href='javascript:my_note(".$CAL_ID.");' onmouseover=\"showMenu(this.id);\" style='color:" ).$STATUS_COLOR.";'>".$CONTENT."</a> ";
if ( date( "Y-m-d", $MONTH_END ) < substr( $END_TIME, 0, 10 ) )
{
$ALL_DAY .= "<a href=\"javascript:set_mon(1);\" title=\"下一月\">".menu_arrow( "RIGHT" )."</a>";
}
$ALL_DAY .= "</div>\n";
$CAL_ALL_DAY[] = $ALL_DAY;
}
else
{
$CAL_ARRAY[date( "j", strtotime( $CAL_TIME ) )] .= "<div title='".$CAL_TITLE."'><span class=\"CalLevel".$CAL_LEVEL."\" title=\"".cal_level_desc( $CAL_LEVEL )."\">".substr( $CAL_TIME, 11, 5 )."-".substr( $END_TIME, 11, 5 )."</span><br><a id=\"cal_".$CAL_ID.( "\" href='javascript:my_note(".$CAL_ID.");' onmouseover=\"showMenu(this.id);\" style='color:" ).$STATUS_COLOR.";'>".$CONTENT."</a></div>\n";
}
if ( $MANAGER_ID == $LOGIN_USER_ID )
{
$OP_MENU .= "<span id=\"cal_".$CAL_ID."_menu\" class=\"attach_div\">\n";
$OP_MENU .= "<a href='javascript:my_note(".$CAL_ID.");'> 查看</a>\n";
$OP_MENU .= "<a href=\"modify.php?CAL_ID=".$CAL_ID."&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 修改</a>\n";
$OP_MENU .= "<a href=\"javascript:del_cal(".$CAL_ID.");\"> 删除</a>\n";
$OP_MENU .= "</span>\n";
}
}
echo " <table id=\"cal_table\" class=\"TableBlock\" width=\"100%\" align=\"center\">\n <tr align=\"center\" class=\"TableHeader\" height=\"20\">\n <td width=\"5%\"><b>周数</b></td>\n <td width=\"14%\"><b>星期一</b></td>\n <td width=\"14%\"><b>星期二</b></td>\n <td width=\"14%\"><b>星期三</b></td>\n <td width=\"14%\"><b>星期四</b></td>\n <td width=\"13%\"><b>星期五</b></td>\n <td width=\"13%\"><b>星期六</b></td>\n <td width=\"13%\"><b>星期日</b></td>\n </tr>\n";
if ( 0 < count( $CAL_ALL_DAY ) )
{
echo " <tr class=\"TableData\">\n <td class=\"TableContent\" align=\"center\">跨天</td>\n <td colspan=\"7\">\n";
foreach ( $CAL_ALL_DAY as $ALL_DAY )
{
echo $ALL_DAY;
}
echo " </td>\n </tr>\n";
}
$I = 1;
for ( ; $I <= date( "t", $DATE ); ++$I )
{
$WEEK = date( "w", strtotime( $YEAR."-".$MONTH."-".$I ) );
$WEEK = $WEEK == 0 ? 6 : $WEEK - 1;
if ( $WEEK == 0 || $I == 1 )
{
$WEEK_BEGIN = date( "Ymd", strtotime( "-".$WEEK."days", strtotime( $YEAR."-".$MONTH."-".$I ) ) );
echo " <tr height=\"80\" class=\"TableData\">\n";
echo " <td id=\"tw_".$WEEK_BEGIN."\" class=\"TableContent\" align=\"center\">第".$WEEKS++."周</td>\n";
}
$J = 0;
for ( ; $J < $WEEK && $I == 1; ++$J )
{
echo " <td class=\"TableData\" valign=\"top\"> </td>\n";
}
echo " <td id=\"td_";
echo strtotime( $YEAR."-".$MONTH."-".$I );
echo "\" class=\"";
if ( $I == $DAY )
{
echo "TableRed";
}
echo "\" valign=\"top\">\n <div align=\"right\" class=\"";
echo $I == $DAY ? "TableRed" : "TableContent";
echo "\" title=\"转到该日查看\" style=\"cursor:hand;width: 100%;\" onclick='location=\"day.php?YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&DAY=";
echo $I;
echo "\"'>\n <font color=\"blue\"><b>";
echo $I;
echo "</b></font>\n </div>\n <div>\n ";
echo $CAL_ARRAY[$I];
echo " </div>\n </td>\n";
if ( $WEEK == 6 )
{
echo "</tr>";
}
}
if ( $WEEK != 6 )
{
$I = $WEEK;
for ( ; $I < 6; ++$I )
{
echo " <td class=\"TableData\"> </td>\n";
}
echo " </tr>\n";
}
$CUR_MONTH = $MONTH;
$query = "SELECT USER_NAME,BIRTHDAY from USER where NOT_LOGIN!='1' order by SUBSTRING(BIRTHDAY,6,5),USER_NAME ASC";
$cursor = exequery( $connection, $query );
$PERSON_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_NAME = $ROW['USER_NAME'];
$BIRTHDAY = $ROW['BIRTHDAY'];
$MON = substr( $BIRTHDAY, 5, 2 );
$DATA = substr( $BIRTHDAY, 5, 5 );
if ( !( $MON != $CUR_MONTH ) || !( $BIRTHDAY == "1900-01-01 00:00:00" ) )
{
if ( $BIRTHDAY == "0000-00-00 00:00:00" )
{
break;
}
}
else
{
continue;
}
$PERSON_STR .= $USER_NAME."(".$DATA.")    ";
++$PERSON_COUNT;
}
if ( 0 < $PERSON_COUNT )
{
echo "\n <tr class=\"TableData\">\n <td style=\"color:#46A718\" align=\"center\"><b>本月生日：</b></td>\n <td colspan=\"20\">\n ";
echo $PERSON_STR;
echo " </td>\n </tr>\n";
}
echo " </table>\n";
echo $OP_MENU;
echo "<br>\n<div align=right>\n";
echo iask( "calendar_info" );
echo "</div>\n</body>\n</html>\n\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -