📄 month.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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>\r\n<head>\r\n<title>日程安排</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/calendar.css\">\r\n</head>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script src=\"/inc/js/calendar.js\"></script>\r\n<script>\r\nfunction set_date(id)\r\n{\r\n var td_cur =\$(\"td_\"+document.form1.YEAR.value+document.form1.MONTH.value+document.form1.DAY.value);\r\n var div_cur=\$(\"div_\"+document.form1.YEAR.value+document.form1.MONTH.value+document.form1.DAY.value);\r\n var td=\$(id);\r\n var div=\$(\"div_\"+id.substr(3));\r\n if(!td || !td_cur || !div || !div_cur) return;\r\n td_cur.className=\"\";\r\n div_cur.className=\"TableContent\";\r\n td.className=\"TableRed\";\r\n div.className=\"TableRed\";\r\n document.form1.YEAR.value=id.substr(3,4);\r\n document.form1.MONTH.value=id.substr(7,2);\r\n document.form1.DAY.value=id.substr(9,2);\r\n}\r\n\r\nfunction init()\r\n{\r\n var tbl = \$(\"cal_table\");\r\n if(!tbl) return;\r\n for(i=0;i<tbl.rows.length;i++)\r\n {\r\n for(j=0;j<tbl.rows[i].cells.length;j++)\r\n {\r\n var td=tbl.rows[i].cells[j];\r\n if(td.id.substr(0,3)==\"td_\")\r\n {\r\n td.onclick =function() {set_date(this.id);};\r\n td.ondblclick =function() {new_cal(this.id.substr(3),'+1 days');};\r\n }\r\n else if(td.id.substr(0,3)==\"tw_\")\r\n {\r\n td.ondblclick =function() {new_cal(this.id.substr(3),'+1 weeks');};\r\n td.title=\"双击建立周事务\";\r\n }\r\n }\r\n }\r\n}\r\n</script>\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"init();\">\r\n<div class=\"small\" style=\"clear:both;\">\r\n <div style=\"float:left;\">\r\n <form name=\"form1\" action=\"";
echo $_SERVER['SCRIPT_NAME'];
echo "\" style=\"margin-bottom:5px;\">\r\n <input type=\"hidden\" value=\"\" name=\"BTN_OP\">\r\n <input type=\"hidden\" value=\"";
echo $_GET['OVER_STATUS'];
echo "\" name=\"OVER_STATUS\">\r\n <input type=\"hidden\" value=\"";
echo $DAY;
echo "\" name=\"DAY\">\r\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 "'\">\r\n<!-------------- 年 ------------>\r\n <a href=\"javascript:set_year(-1);\" class=\"ArrowButtonLL\" title=\"上一年\"></a>\r\n <a href=\"javascript:set_mon(-1);\" class=\"ArrowButtonL\" title=\"上一月\"></a>\r\n <select name=\"YEAR\" class=\"SmallSelect\" onchange=\"My_Submit();\">\r\n";
$I = 2000;
for ( ; $I <= 2030; ++$I )
{
echo " <option value=\"";
echo $I;
echo "\" ";
if ( $I == $YEAR )
{
echo "selected";
}
echo ">";
echo $I;
echo "年</option>\r\n";
}
echo " </select>\r\n<!-------------- 月 ------------>\r\n <select name=\"MONTH\" class=\"SmallSelect\" onchange=\"My_Submit();\">\r\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>\r\n";
}
echo " </select>\r\n <a href=\"javascript:set_mon(1);\" class=\"ArrowButtonR\" title=\"下一月\"></a>\r\n <a href=\"javascript:set_year(1);\" class=\"ArrowButtonRR\" title=\"下一年\"></a> \r\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> \r\n <div id=\"status_menu\" class=\"attach_div\">\r\n <a href=\"javascript:set_status('');\">全部</a>\r\n <a href=\"javascript:set_status(1);\" style=\"color:#0000FF;\">未开始</a>\r\n <a href=\"javascript:set_status(2);\" style=\"color:#0000FF;\">进行中</a>\r\n <a href=\"javascript:set_status(3);\" style=\"color:#FF0000;\">已超时</a>\r\n <a href=\"javascript:set_status(4);\" style=\"color:#00AA00;\">已完成</a>\r\n </div>\r\n </div>\r\n <div style=\"float:right;\">\r\n <a id=\"new\" href=\"javascript:;\" class=\"dropdown\" onclick=\"showMenu(this.id,'1');\" hidefocus=\"true\"><span>新建";
echo menu_arrow( "DOWN" );
echo "</span></a> \r\n <div id=\"new_menu\" class=\"attach_div\">\r\n <a href=\"javascript:new_cal(";
echo $MONTH_BEGIN;
echo ",'+1 months');\" title=\"创建新的事务,以便提醒自己\">月事务</a>\r\n <a href=\"javascript:new_diary();\">工作日志</a>\r\n </div>\r\n <span class=\"\">\r\n <a href=\"javascript:set_view('list');\" title=\"列表视图\"><span><img src=\"/images/cal_list.gif\" align=\"absMiddle\">列表</span></a>\r\n <a href=\"javascript:set_view('day');\" title=\"日视图\"><span><img src=\"/images/cal_day.gif\" align=\"absMiddle\">日</span></a>\r\n <a href=\"javascript:set_view('index');\" title=\"周视图\"><span><img src=\"/images/cal_week.gif\" align=\"absMiddle\">周</span></a>\r\n <a href=\"javascript:set_view('month');\" title=\"月视图\"><span><img src=\"/images/cal_month.gif\" align=\"absMiddle\">月</span></a>\r\n </span>\r\n </form>\r\n </div>\r\n</div>\r\n\r\n";
$CODE_NAME = array( );
$MANAGER = array( );
$query = "SELECT * from CALENDAR where USER_ID='".$LOGIN_USER_ID."'".$CONDITION_STR." 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."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$MANAGER[$MANAGER_ID] = $ROW1['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";
}
$OP_MENU .= "<span id=\"cal_".$CAL_ID."_menu\" class=\"attach_div\">\n";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -