📄 index.php
字号:
<?php
if ( $_COOKIE['cal_info_view'] == "day" || $_COOKIE['cal_info_view'] == "month" )
{
header( "location:".$_COOKIE['cal_info_view'].".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 );
$WEEK = date( "W", $DATE );
$WEEK_BEGIN = strtotime( "-".( date( "w", $DATE ) == 0 ? 6 : date( "w", $DATE ) - 1 )."days", $DATE );
$WEEK_END = strtotime( "+6 days", $WEEK_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\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.ondblclick =function() {new_arrange(user_id_array[this.id.substr(3,this.id.lastIndexOf(\"_\")-3)], this.id.substr(this.id.lastIndexOf(\"_\")+1), \"+1 days\");};\r\n td.title=\"双击建立日事务\";\r\n }\r\n else if(td.id.substr(0,3)==\"th_\")\r\n {\r\n //td.onclick =function() {set_data(this.id);};\r\n td.ondblclick =function() {new_arrange(user_id_array, this.id.substr(3), '+1 days');};\r\n td.title=\"双击为下边所有人员建立日事务\";\r\n }\r\n else if(td.id.substr(0,3)==\"tr_\")\r\n {\r\n td.ondblclick =function() {new_arrange(user_id_array[this.id.substr(3)],'";
echo $WEEK_BEGIN;
echo "' , '+1 weeks');};\r\n td.title=\"双击建立周事务\";\r\n }\r\n }\r\n }\r\n \r\n var th = \$(\"tbl_header\"),week_width=0;\r\n if(!th) return;\r\n \r\n for(j=1;j<th.cells.length;j++)\r\n week_width+=th.cells[j].offsetWidth;\r\n \r\n for(i=0;i<cal_div_array.length;i++)\r\n {\r\n var left=width=0;\r\n for(j=1;j<cal_div_array[i][1];j++)\r\n left+=th.cells[j].offsetWidth;\r\n for(j=cal_div_array[i][1];j<=cal_div_array[i][2];j++)\r\n width+=th.cells[j].clientWidth;\r\n \r\n if(left+width > week_width-6)\r\n width=week_width-left-6;\r\n \r\n \$(\"div_\"+cal_div_array[i][0]).style.left=left+\"px\";\r\n \$(\"div_\"+cal_div_array[i][0]).style.width=width+\"px\";\r\n }\r\n}\r\n</script>\r\n</head>\r\n\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 $MONTH;
echo "\" name=\"MONTH\">\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_week(-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=\"WEEK\" class=\"SmallSelect\" onchange=\"set_week(this.value-";
echo $WEEK;
echo ");\">\r\n";
$I = 1;
for ( ; $I <= 52; ++$I )
{
echo " <option value=\"";
echo $I;
echo "\" ";
if ( $I == $WEEK )
{
echo "selected";
}
echo ">第";
echo $I;
echo "周</option>\r\n";
}
echo " </select>\r\n <a href=\"javascript:set_week(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 <input type=\"button\" value=\"查询\" class=\"SmallButton\" title=\"查询\" onclick=\"location='query.php'\">\r\n";
if ( $DEPT_PRIV != "3" )
{
echo " <select name=\"DEPT_ID\" class=\"SmallSelect\" onchange=\"My_Submit();\">\r\n";
echo my_dept_tree( 0, $DEPT_ID, array(
"DEPT_PRIV" => $DEPT_PRIV,
"DEPT_ID_STR" => $DEPT_ID_STR
) );
echo " </select>\r\n";
}
echo " <span class=\"\">\r\n <a href=\"javascript:set_view('day','cal_info_view');\" title=\"日视图\"><span><img src=\"/images/cal_day.gif\" align=\"absMiddle\">日</span></a>\r\n <a href=\"javascript:set_view('index','cal_info_view');\" title=\"周视图\"><span><img src=\"/images/cal_week.gif\" align=\"absMiddle\">周</span></a>\r\n <a href=\"javascript:set_view('month','cal_info_view');\" 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";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$CODE_NAME = $MANAGER = $USERS = array( );
$USER_ID_STR = "";
$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 ) )
{
$USERS[$ROW['USER_ID']]['NAME'] = $ROW['USER_NAME'];
$USER_ID_STR .= $ROW['USER_ID'].",";
}
$query = "SELECT * from CALENDAR where find_in_set(USER_ID,'".$USER_ID_STR."')".$CONDITION_STR." and CAL_TYPE!='2' and (CAL_TIME>='".date( "Y-m-d", $WEEK_BEGIN )." 00:00:00' and CAL_TIME<='".date( "Y-m-d", $WEEK_END )." 23:59:59' || END_TIME>='".date( "Y-m-d", $WEEK_BEGIN )." 00:00:00' and END_TIME<='".date( "Y-m-d", $WEEK_END )." 23:59:59' || CAL_TIME<='".date( "Y-m-d", $WEEK_BEGIN )." 00:00:00' and END_TIME>='".date( "Y-m-d", $WEEK_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'];
$USER_ID = $ROW['USER_ID'];
$CONTENT = $ROW['CONTENT'];
$MANAGER_ID = $ROW['MANAGER_ID'];
$OVER_STATUS = $ROW['OVER_STATUS'];
$MANAGER_NAME = "";
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'];
}
}
$MANAGER_NAME = "安排人:".$MANAGER[$MANAGER_ID]."<br>";
}
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 .= "状态：已完成";
}
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 20 );
if ( substr( $CAL_TIME, 0, 10 ) != substr( $END_TIME, 0, 10 ) )
{
$ALL_DAY = "<div id=\"div_".$CAL_ID."\" title='".$CAL_TITLE."' class=\"CalAllDay\">";
if ( substr( $CAL_TIME, 0, 10 ) < date( "Y-m-d", $WEEK_BEGIN ) )
{
$ALL_DAY .= "<a href=\"javascript:set_week(-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( "Y-m-d", $WEEK_END ) < substr( $END_TIME, 0, 10 ) )
{
$ALL_DAY .= "<a href=\"javascript:set_week(1);\" title=\"下一周\">".menu_arrow( "RIGHT" )."</a>";
}
$ALL_DAY .= "</div>\n";
$USERS[$USER_ID]['ALL_DAY'] .= $ALL_DAY;
$COL_BEGIN = floor( ( strtotime( substr( $CAL_TIME, 0, 10 ) ) - $WEEK_BEGIN ) / 86400 ) + 1;
$COL_BEGIN = $COL_BEGIN <= 0 ? 1 : $COL_BEGIN;
$COL_END = floor( ( strtotime( substr( $END_TIME, 0, 10 ) ) - $WEEK_BEGIN ) / 86400 ) + 1;
$COL_END = 7 < $COL_END ? 7 : $COL_END;
$CAL_DIV_ARRAY .= "Array(".$CAL_ID.", {$COL_BEGIN}, {$COL_END}), ";
}
else
{
$USERS[$USER_ID]['WEEK'][date( "w", strtotime( $CAL_TIME ) ) == 0 ? 6 : date( "w", strtotime( $CAL_TIME ) ) - 1] .= "<div id=\"div_".$CAL_ID."\" 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>";
}
if ( $MANAGER_ID == $LOGIN_USER_ID )
{
$OP_MENU .= "<span id=\"cal_".$CAL_ID."_menu\" class=\"attach_div\" style=\"width:80px\">\n";
$OP_MENU .= "<a href='javascript:my_note(".$CAL_ID.");'> 查看</a>\n";
$OP_MENU .= "<a href=\"javascript:;\" onclick=\"window.open('new.php?CAL_ID=".$CAL_ID."','oa_sub_window','height=300,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes');\">修改</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\">\r\n <tr id=\"tbl_header\" align=\"center\" class=\"TableHeader\">\r\n <td width=\"80\" class=\"Small\">姓名</td>\r\n";
$WEEK_DATE = $WEEK_BEGIN;
for ( ; $WEEK_DATE <= $WEEK_END; $WEEK_DATE = strtotime( "+1 day", $WEEK_DATE ) )
{
echo " <td id=\"th_";
echo $WEEK_DATE;
echo "\" ";
if ( $WEEK == 0 )
{
echo "bgcolor=#FFCCFF";
}
else if ( $WEEK == 6 )
{
echo "bgcolor=#CCFFCC";
}
echo " class=\"Small\">\r\n <a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_DATE );
echo "&MONTH=";
echo date( "m", $WEEK_DATE );
echo "&DAY=";
echo date( "d", $WEEK_DATE );
echo "&DEPT_ID=";
echo $DEPT_ID;
echo "\">";
echo date( "m/d", $WEEK_DATE );
echo "(星期";
echo get_week( date( "Y-m-d", $WEEK_DATE ) );
echo ")</a>\r\n </td>\r\n";
}
echo " </tr>\r\n";
$I = 0;
foreach ( $USERS as $USER_ID => $USER )
{
if ( $USER['ALL_DAY'] != "" )
{
echo " <tr class=\"TableData\">\r\n <td id=\"tr_";
echo $I;
echo "\" width=\"80\" align=\"center\" rowspan=\"2\">";
echo $USER['NAME'];
echo "</td>\r\n <td colspan=\"7\">";
echo $USER['ALL_DAY'];
echo "</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableData\" height=\"30\">\r\n";
if ( $USER['ALL_DAY'] == "" )
{
echo " <td id=\"tr_";
echo $I;
echo "\" width=\"80\" align=\"center\">";
echo $USER['NAME'];
echo "</td>\r\n";
}
$WEEK_DATE = $WEEK_BEGIN;
for ( ; $WEEK_DATE <= $WEEK_END; $WEEK_DATE = strtotime( "+1 day", $WEEK_DATE ) )
{
$WEEK_YEAR = date( "Y", $WEEK_DATE );
$WEEK_MON = date( "m", $WEEK_DATE );
$WEEK_DAY = date( "d", $WEEK_DATE );
if ( $WEEK_DAY == $DAY && $YEAR == $WEEK_YEAR && $MONTH == $WEEK_MON )
{
$DAY_COLOR = "TableContent";
}
else
{
$DAY_COLOR = "TableData";
}
echo " <td id=\"td_";
echo $I;
echo "_";
echo $WEEK_DATE;
echo "\" class=\"";
echo $DAY_COLOR;
echo "\">\r\n ";
echo $USER['WEEK'][date( "w", $WEEK_DATE ) == 0 ? 6 : date( "w", $WEEK_DATE ) - 1];
echo " </td>\r\n";
}
echo " </tr>\r\n";
$USER_ARRAY_STR .= "'".$USER_ID."',";
++$I;
}
echo " </table>\r\n";
echo $OP_MENU;
echo "<script>var cal_div_array = new Array(";
echo trim( trim( $CAL_DIV_ARRAY ), "," );
echo ");</script>\r\n<script>var user_id_array = new Array(";
echo trim( trim( $USER_ARRAY_STR ), "," );
echo ");</script>\r\n<br>\r\n<div align=right>\r\n";
echo iask( "calendar_info" );
echo "</div>\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -