本周日程.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

echo "<!-------------------- 本周日程 ----------------------->\r\n<div id=\"module_";
echo $MODULE_ID;
echo "\" class=\"module listColor\">\r\n  <div class=\"head\">\r\n  <h4 id=\"module_";
echo $MODULE_ID;
echo "_head\" class=\"moduleHeader\">\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_title\" class=\"title\" style=\"cursor:move;\"> 本周日程</span>\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_op\" class=\"close\">\r\n      <a href=\"javascript:_show('";
echo $MODULE_ID;
echo "');\" alt=\"设置显示条数\"><img border=\"0\" src=\"/images/edit.gif\" alt=\"设置显示条数\"></a>&nbsp;\r\n    \t<a href=\"/general/calendar/\">全部</a>&nbsp;\r\n    \t<a href=\"javascript:_edit();\">设置</a>&nbsp;";
if ( $VIEW_TYPE != "2" )
{
	echo "<a href=\"javascript:_del(";
	echo $MODULE_ID;
	echo ");\"><img src=\"/images/close.png\" /></a>";
}
echo "</span>\r\n  </h4>\r\n  </div>\r\n  <div id=\"module_";
echo $MODULE_ID;
echo "_edit\" style=\"font-size: 9pt;display:none;\">\r\n      <div id=\"module_";
echo $MODULE_ID;
echo "_info\" style=\"float:left;\"></div>\r\n     <input type=\"checkbox\" id=\"MODULE_SCROLL_";
echo $MODULE_ID;
echo "\" ";
if ( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_scroll"] == "true" )
{
	echo " checked";
}
echo "><label for=\"MODULE_SCROLL_";
echo $MODULE_ID;
echo "\">上下滚动显示</label>&nbsp;\r\n     显示条数：<input type=\"input\" size=\"3\" class=\"SmallInput\" value=\"";
echo $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"];
echo "\" name=\"MODULE_NUM_";
echo $MODULE_ID;
echo "\">&nbsp;\r\n     <a href=\"javascript:SetNumsMo('";
echo $MODULE_ID;
echo "');\" title=\"保存设置\">设置</a>\r\n     <a href=\"javascript:_show('";
echo $MODULE_ID;
echo "');\" title=\"关闭\">关闭</a>\r\n  </div>\r\n  <div id=\"module_";
echo $MODULE_ID;
echo "_body\" class=\"module_body\">\r\n    <div id=\"module_";
echo $MODULE_ID;
echo "_ul\" class=\"module_div\" style=\"height:px;\">\r\n";
unset( $CAL_ARRAY );
$MAX_COUNT = intval( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"] );
if ( $MAX_COUNT <= 0 || 1000 <= $MAX_COUNT )
{
	$MAX_COUNT = 10;
}
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
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_BEGIN = strtotime( "-".date( "w", $DATE )."days", $DATE );
$WEEK_END = strtotime( "+6 days", $WEEK_BEGIN );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from CALENDAR where USER_ID='".$LOGIN_USER_ID."' and CAL_TIME>='".date( "Y-m-d", $WEEK_BEGIN )." 00:00:00' and CAL_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'];
	$CONTENT = $ROW['CONTENT'];
	$MANAGER_ID = $ROW['MANAGER_ID'];
	$OVER_STATUS = $ROW['OVER_STATUS'];
	$CAL_TITLE = "类型：".get_code_name( $CAL_TYPE, "CAL_TYPE" )."\n";
	if ( $OVER_STATUS == "0" )
	{
		if ( 0 < compare_time( $CUR_TIME, $END_TIME ) )
		{
			$STATUS = "<font color='#FF0000'>过期</font>";
		}
		else if ( compare_time( $CUR_TIME, $CAL_TIME ) < 0 )
		{
			$STATUS = "<font color='#0000AA'>未至</font>";
		}
		else
		{
			$STATUS = "<font color='#00AA00'>进行中</font>";
		}
	}
	else
	{
		$STATUS = "<font color='#00AA00'>已完成</font>";
	}
	if ( $OVER_STATUS == "0" )
	{
		$CAL_TITLE .= "状态：未完成";
	}
	else
	{
		$CAL_TITLE .= "状态：已完成";
	}
	if ( $MANAGER_ID != "" )
	{
		$query = "SELECT * from USER where USER_ID='".$MANAGER_ID."'";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$CAL_TITLE .= "\n安排人：".$ROW1['USER_NAME'];
		}
	}
	$CONTENT = htmlspecialchars( $CONTENT );
	$CONTENT = "<div id=\"cal_".$CAL_ID."\" title='".$CAL_TITLE."'>".substr( $CAL_TIME, 11, 5 )."-".substr( $END_TIME, 11, 5 ).( " <a href='javascript:my_note(".$CAL_ID.");'>" ).$CONTENT."</a>(".$STATUS.")";
	$CONTENT .= "<span id=\"cal_".$CAL_ID."_op\" style=\"display:none;\">";
	if ( $OVER_STATUS == "0" )
	{
		$CONTENT .= "<a href=\"/general/calendar/arrange/status.php?CAL_ID=".$CAL_ID."&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> &nbsp;完成</a>";
	}
	else if ( $OVER_STATUS == "" || $OVER_STATUS == "1" )
	{
		$CONTENT .= "<a href=\"/general/calendar/arrange/status.php?CAL_ID=".$CAL_ID."&OVER_STATUS=0&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 未完成</a>";
	}
	if ( $MANAGER_ID == "" || $MANAGER_ID == $LOGIN_USER_ID )
	{
		$CONTENT .= "<a href=\"/general/calendar/arrange/modify.php?CAL_ID=".$CAL_ID."&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 修改</a>";
		$CONTENT .= "<a href=\"/general/calendar/arrange/delete.php?CAL_ID=".$CAL_ID."&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 删除</a>";
	}
	$CONTENT .= "</span></div>";
	$REMIND_WEEK = date( "w", strtotime( $CAL_TIME ) );
	$COUNT_STR = "COUNT_".$REMIND_WEEK;
	++$$COUNT_STR;
	if ( !( $MAX_COUNT < $$COUNT_STR ) )
	{
		$CAL_ARRAY[$REMIND_WEEK] .= $CONTENT;
	}
}
$query = "SELECT * from AFFAIR where USER_ID='".$LOGIN_USER_ID."' and BEGIN_TIME<='".date( "Y-m-d", $WEEK_END )." 23:59:59' and TYPE='2' 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'];
	$LAST_REMIND = $ROW['LAST_REMIND'];
	$CONTENT = htmlspecialchars( $CONTENT );
	if ( $LAST_REMIND == "0000-00-00" )
	{
		$LAST_REMIND = "";
	}
	$AFF_TITLE = "提醒时间：每日 ".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_WEEK = date( "w", strtotime( date( "Y-m-", $WEEK_BEGIN ).$REMIND_DATE ) );
	$REMIND_HOUR = intval( substr( $REMIND_TIME, 0, strpos( $REMIND_TIME, ":" ) ) );
	$I = 0;
	for ( ;	$I < 7;	++$I	)
	{
		if ( $BEGIN_TIME <= date( "Y-m-d", $WEEK_BEGIN + $I * 86400 )." ".$REMIND_TIME )
		{
			$REMIND_WEEK = date( "w", strtotime( date( "Y-m-d", $WEEK_BEGIN + $I * 86400 )." ".$REMIND_TIME ) );
			$COUNT_STR = "COUNT_".$REMIND_WEEK;
			++$$COUNT_STR;
			if ( !( $MAX_COUNT < $$COUNT_STR ) )
			{
				$CAL_ARRAY[$REMIND_WEEK] .= $CONTENT;
			}
		}
	}
}
$query = "SELECT * from AFFAIR where USER_ID='".$LOGIN_USER_ID."' and BEGIN_TIME<='".date( "Y-m-d", $WEEK_END )." 23:59:59' and TYPE='3' 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'];
	$LAST_REMIND = $ROW['LAST_REMIND'];
	$CONTENT = htmlspecialchars( $CONTENT );
	if ( $LAST_REMIND == "0000-00-00" )
	{
		$LAST_REMIND = "";
	}
	if ( $REMIND_DATE == 0 )
	{
		$REMIND_DATE_DESC = "日";
	}
	else if ( $REMIND_DATE == 1 )