📄 list.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 );
$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 check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\nfunction get_checked()\r\n{\r\n checked_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n return checked_str;\r\n}\r\nfunction delete_mail()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要删除任务，请至少选择其中一条。\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选任务么？';\r\n if(window.confirm(msg))\r\n {\r\n url='delete.php?CAL_ID='+delete_str+'&PAGE_START=";
echo $PAGE_START;
echo "&OVER_STATUS='+document.form1.OVER_STATUS.value+'&YEAR='+document.form1.YEAR.value+'&MONTH='+document.form1.MONTH.value+'&DAY='+document.form1.DAY.value;\r\n location=url;\r\n }\r\n}\r\n</script>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\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 $YEAR;
echo "\" name=\"YEAR\">\r\n <input type=\"hidden\" value=\"";
echo $MONTH;
echo "\" name=\"MONTH\">\r\n <input type=\"hidden\" value=\"";
echo $DAY;
echo "\" name=\"DAY\">\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('";
echo date( "Ymd", $DATE );
echo "');\">今日日志</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";
$CODE_NAME = array( );
$MANAGER = array( );
$PAGE_SIZE = 20;
$PAGE_START = intval( $PAGE_START );
if ( !isset( $TOTAL_ITEMS ) )
{
$query = "SELECT count(*) from CALENDAR where USER_ID='".$LOGIN_USER_ID."'".$CONDITION_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TOTAL_ITEMS = $ROW[0];
}
}
$TOTAL_ITEMS = intval( $TOTAL_ITEMS );
if ( $TOTAL_ITEMS == 0 )
{
message( "", "无符合条件的日程安排" );
exit( );
}
echo "<table class=\"TableList\" width=\"100%\" align=\"center\">\r\n <tr align=\"center\" class=\"TableHeader\">\r\n <td width=\"40\">选择</td>\r\n <td width=\"120\">起始时间</td>\r\n <td width=\"120\">结束时间</td>\r\n <td>内容</td>\r\n <td>类型</td>\r\n <td width=\"120\">操作</td>\r\n </tr>\r\n";
$CAL_COUNT = 0;
$query = "SELECT * from CALENDAR where USER_ID='".$LOGIN_USER_ID."'".$CONDITION_STR.( " order by CAL_TIME desc limit ".$PAGE_START.",{$PAGE_SIZE}" );
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$CAL_COUNT;
$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'];
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 50 );
if ( !array_key_exists( $CAL_TYPE, $MANAGER ) )
{
$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( $CAL_TYPE, $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].")";
}
echo " <tr align=\"center\" class=\"TableLine";
echo 2 - $CAL_COUNT % 2;
echo "\" title=\"";
echo $CAL_TITLE;
echo "\">\r\n <td><input type=\"checkbox\" name=\"email_select\" value=\"";
echo $CAL_ID;
echo "\" onClick=\"check_one(self);\">\r\n <td>";
echo substr( $CAL_TIME, 0, 16 );
echo "</td>\r\n <td>";
echo substr( $END_TIME, 0, 16 );
echo "</td>\r\n <td align=\"left\"><span class=\"CalLevel";
echo $CAL_LEVEL;
echo "\" title=\"";
echo cal_level_desc( $CAL_LEVEL );
echo "\"> </span><a href=\"javascript:my_note(";
echo $CAL_ID;
echo ");\" style=\"color:";
echo $STATUS_COLOR;
echo ";\">";
echo $CONTENT;
echo "</a></td>\r\n <td>";
echo $CAL_TYPE_DESC;
echo "</td>\r\n <td>\r\n";
if ( $OVER_STATUS == "0" )
{
echo "<a href=\"status.php?CAL_ID=";
echo $CAL_ID;
echo "&OVER_STATUS=1&YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&DAY=";
echo $DAY;
echo "\">完成</a>\n";
}
else if ( $OVER_STATUS == "" || $OVER_STATUS == "1" )
{
echo "<a href=\"status.php?CAL_ID=";
echo $CAL_ID;
echo "&OVER_STATUS=0&YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&DAY=";
echo $DAY;
echo "\">未完成</a>\n";
}
if ( $MANAGER_ID == "" || $MANAGER_ID == $LOGIN_USER_ID )
{
echo "<a href=\"modify.php?CAL_ID=";
echo $CAL_ID;
echo "&OVER_STATUS=1&YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&DAY=";
echo $DAY;
echo "\">修改</a>\n<a href=\"javascript:del_cal(";
echo $CAL_ID;
echo ");\"> 删除</a>\n";
}
echo " </td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableControl\">\r\n <td colspan=\"10\"> <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <a href=\"javascript:delete_mail();\" title=\"删除所选邮件\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除</a> \r\n </td>\r\n </tr>\r\n</table>\r\n<div style=\"float:right;\">";
echo page_bar( $PAGE_START, $TOTAL_ITEMS, $PAGE_SIZE, "PAGE_START" );
echo "</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -