📄 day.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_STR = $YEAR."-".$MONTH."-".$DAY;
$DATE = strtotime( $DATE_STR );
$WEEK = date( "W", $DATE );
$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 init()\r\n{\r\n var elementI=document.getElementsByTagName(\"TR\");\r\n for(i=0;i<elementI.length;i++)\r\n {\r\n if(elementI[i].id.substr(0,3)!=\"tr_\")\r\n continue;\r\n\r\n elementI[i].ondblclick =function() {new_cal(this.id.substr(3));};\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=\"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=\"ArrowButtonL\" title=\"上一年\"></a><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><a href=\"javascript:set_year(1);\" class=\"ArrowButtonR\" title=\"下一年\"></a>\r\n\r\n<!-------------- 月 ------------>\r\n <a href=\"javascript:set_mon(-1);\" class=\"ArrowButtonL\" title=\"上一月\"></a><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><a href=\"javascript:set_mon(1);\" class=\"ArrowButtonR\" title=\"下一月\"></a>\r\n<!-------------- 日 ------------>\r\n <a href=\"javascript:set_day(-1);\" class=\"ArrowButtonL\" title=\"上一天\"></a><select name=\"DAY\" class=\"SmallSelect\" onchange=\"My_Submit();\">\r\n";
$I = 1;
for ( ; $I <= date( "t", $DATE ); ++$I )
{
if ( $I < 10 )
{
$I = "0".$I;
}
echo " <option value=\"";
echo $I;
echo "\" ";
if ( $I == $DAY )
{
echo "selected";
}
echo ">";
echo $I;
echo "日</option>\r\n";
}
echo " </select><a href=\"javascript:set_day(1);\" class=\"ArrowButtonR\" 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 $DATE;
echo ",'+1 days');\" 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( );
$CAL_ALL_DAY = array( );
$query = "SELECT * from CALENDAR where USER_ID='".$LOGIN_USER_ID."'".$CONDITION_STR.( " and to_days(CAL_TIME)<=to_days('".$YEAR."-{$MONTH}-{$DAY}') and to_days(END_TIME)>=to_days('{$YEAR}-{$MONTH}-{$DAY}') order by CAL_TIME" );
$cursor = exequery( $connection, $query );
$CAL_COUNT = 0;
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_TYPE_DESC = $CODE_NAME[$CAL_TYPE]."：";
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 = "状态：已完成";
}
$MANAGER_NAME = "";
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'];
}
}
$MANAGER_NAME = "(安排人:".$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_STR )
{
$ALL_DAY .= "<a href=\"javascript:set_day(-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> ".$CAL_TYPE_DESC."<a id=\"cal_".$CAL_ID.( "\" href='javascript:my_note(".$CAL_ID.");' onmouseover=\"showMenu(this.id);\" style='color:" ).$STATUS_COLOR.";'>".$CONTENT."</a> ".$MANAGER_NAME;
if ( $DATE_STR < substr( $END_TIME, 0, 10 ) )
{
$ALL_DAY .= "<a href=\"javascript:set_day(1);\" title=\"下一天\">".menu_arrow( "RIGHT" )."</a>";
}
$ALL_DAY .= "</div>\n";
$CAL_ALL_DAY[] = $ALL_DAY;
}
else
{
$CAL_ARRAY[date( "G", 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> ".$CAL_TYPE_DESC."<a id=\"cal_".$CAL_ID.( "\" href='javascript:my_note(".$CAL_ID.");' onmouseover=\"showMenu(this.id);\" style='color:" ).$STATUS_COLOR.";'>".$CONTENT."</a> ".$MANAGER_NAME."</div>\n";
}
$OP_MENU .= "<span id=\"cal_".$CAL_ID."_menu\" class=\"attach_div\" style=\"width:60px;\">\n";
$OP_MENU .= "<a href='javascript:my_note(".$CAL_ID.");'> 查看</a>";
if ( $OVER_STATUS == "0" )
{
$OP_MENU .= "<a href=\"status.php?CAL_ID=".$CAL_ID."&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\">完成</a>\n";
}
else if ( $OVER_STATUS == "" || $OVER_STATUS == "1" )
{
$OP_MENU .= "<a href=\"status.php?CAL_ID=".$CAL_ID."&OVER_STATUS=0&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\">未完成</a>\n";
}
if ( $MANAGER_ID == "" || $MANAGER_ID == $LOGIN_USER_ID )
{
$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";
}
$query = "SELECT * from AFFAIR where USER_ID='".$LOGIN_USER_ID."' and BEGIN_TIME<='".date( "Y-m-d", $DATE )." 23:59:59' and (END_TIME='' or END_TIME='0000-00-00 00:00:00' or END_TIME>='".date( "Y-m-d", $DATE )." 23:59:59') and (TYPE='2' or TYPE='3' and REMIND_DATE='".date( "w", $DATE )."' or TYPE='4' and REMIND_DATE='".date( "j", $DATE )."' or TYPE='5' and REMIND_DATE='".date( "n-j", $DATE )."') order by BEGIN_TIME desc";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$AFF_ID = $ROW['AFF_ID'];
$BEGIN_TIME = $ROW['BEGIN_TIME'];
$REMIND_DATE = $ROW['REMIND_DATE'];
$REMIND_TIME = $ROW['REMIND_TIME'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$LAST_REMIND = $ROW['LAST_REMIND'];
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 50 );
if ( $LAST_REMIND == "0000-00-00" )
{
$LAST_REMIND = "";
}
switch ( $TYPE )
{
case "2" :
$TYPE_DESC = "每日";
break;
case "3" :
$TYPE_DESC = "每周";
if ( $REMIND_DATE == "1" )
{
$REMIND_DATE = "一";
}
else if ( $REMIND_DATE == "2" )
{
$REMIND_DATE = "二";
}
else if ( $REMIND_DATE == "3" )
{
$REMIND_DATE = "三";
}
else if ( $REMIND_DATE == "4" )
{
$REMIND_DATE = "四";
}
else if ( $REMIND_DATE == "5" )
{
$REMIND_DATE = "五";
}
else
{
if ( $REMIND_DATE == "6" )
{
$REMIND_DATE = "六";
}
else
{
if ( !( $REMIND_DATE == "0" ) )
{
break;
}
$REMIND_DATE = "日";
}
}
break;
case "4" :
$TYPE_DESC = "每月";
$REMIND_DATE .= "日";
break;
case "5" :
$TYPE_DESC = "每年";
$REMIND_DATE = str_replace( "-", "月", $REMIND_DATE )."日";
}
$AFF_TITLE = "提醒时间：".$TYPE_DESC.$REMIND_DATE." ".substr( $REMIND_TIME, 0, -3 )."\n上次提醒：".$LAST_REMIND."\n起始时间：".$BEGIN_TIME;
$CONTENT = substr( $REMIND_TIME, 0, -3 ).( " <a href='javascript:my_affair(".$AFF_ID.");' title='" ).$AFF_TITLE."'>".$CONTENT."</a><br>";
$REMIND_HOUR = intval( substr( $REMIND_TIME, 0, strpos( $REMIND_TIME, ":" ) ) );
if ( $BEGIN_TIME <= date( "Y-m-d", $DATE )." ".$REMIND_TIME )
{
$CAL_ARRAY[$REMIND_HOUR] .= $CONTENT;
}
}
echo "\r\n <table class=\"TableList\" width=\"100%\" align=\"center\">\r\n <tr align=\"center\" class=\"TableHeader\">\r\n <td width=\"9%\"><a href=\"javascript:display_front();\">0-6点</a></td>\r\n <td ondblclick=\"new_cal(";
echo $DATE;
echo ",'+1 days');\" title=\"双击建立日事务\">";
echo date( "Y年m月d日", $DATE );
echo "(星期";
echo get_week( date( "Y-m-d", $DATE ) );
echo ")</td>\r\n </tr>\r\n";
if ( 0 < count( $CAL_ALL_DAY ) )
{
echo " <tr class=\"TableData\">\r\n <td class=\"TableContent\" align=\"center\">跨天</td>\r\n <td>\r\n";
foreach ( $CAL_ALL_DAY as $ALL_DAY )
{
echo $ALL_DAY;
}
echo " </td>\r\n </tr>\r\n";
}
echo " <tbody id=\"front\" style=\"display:none;\">\r\n";
$I = 0;
for ( ; $I < 7; ++$I )
{
echo " <tr id=\"tr_";
echo $DATE + $I * 3600;
echo "\" class=\"TableData\" height=\"30\">\r\n <td class=\"TableContent\" align=\"center\" width=\"9%\">";
if ( $I < 10 )
{
echo "0";
}
echo $I;
echo ":00</td>\r\n <td>";
echo $CAL_ARRAY[$I];
echo "</td>\r\n </tr>\r\n";
}
echo " </tbody>\r\n";
$I = 7;
for ( ; $I < 24; ++$I )
{
echo " <tr id=\"tr_";
echo $DATE + $I * 3600;
echo "\" class=\"TableData\" height=\"30\">\r\n <td class=\"TableContent\" align=\"center\" width=\"9%\">";
if ( $I < 10 )
{
echo "0";
}
echo $I;
echo ":00</td>\r\n <td>";
echo $CAL_ARRAY[$I];
echo "</td>\r\n </tr>\r\n";
}
echo " </table>\r\n";
echo $OP_MENU;
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -