📄 day.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_STR = $YEAR."-".$MONTH."-".$DAY;
$DATE = strtotime( $DATE_STR );
$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_arrange(user_id_array[this.id.substr(3)],'";
echo $DATE;
echo "','+1 days');};\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=\"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", strtotime( $YEAR."-".$MONTH."-".$DAY ) ); ++$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 <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 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 );
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].")";
}
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, 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";
$USERS[$USER_ID]['CAL'] .= $ALL_DAY;
}
else
{
$USERS[$USER_ID]['CAL'] .= "<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 )." ".$CAL_TYPE_DESC."</span><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";
}
if ( $MANAGER_ID == $LOGIN_USER_ID )
{
$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>";
$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 class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n <tr align=\"center\" class=\"TableHeader\" title=\"双击为该部门所有用户建立日事务\" ondblclick=\"new_arrange(user_id_array,'";
echo $DATE;
echo "','+1 days');\">\r\n <td width=\"80\">姓名</td>\r\n <td>";
echo date( "Y年m月d日", $DATE );
echo "(星期";
echo get_week( date( "Y-m-d", $DATE ) );
echo ")</td>\r\n </tr>\r\n";
$I = 0;
foreach ( $USERS as $USER_ID => $USER )
{
echo " <tr id=\"tr_";
echo $I;
echo "\" class=\"TableData\" title=\"双击为 ";
echo $USER['NAME'];
echo " 建立日事务\">\r\n <td align=\"center\">";
echo $USER['NAME'];
echo "</td>\r\n <td>\r\n ";
echo $USER['CAL'];
echo " </td>\r\n </tr>\r\n";
$USER_ARRAY_STR .= "'".$USER_ID."',";
++$I;
}
echo "</table>\r\n";
echo $OP_MENU;
echo "<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";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -