month.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

	$OP_MENU .= "<a href='javascript:my_note(".$CAL_ID.");'> 查看</a>\n";
	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";
}
$I = 1;
for ( ;	$I <= date( "t", $DATE );	++$I	)
{
	$DAY_I = strtotime( $YEAR."-".$MONTH."-".$I );
	$query = "SELECT * from AFFAIR where USER_ID='".$LOGIN_USER_ID."' and BEGIN_TIME<='".date( "Y-m-d", $DAY_I )." 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", $DAY_I )."' or TYPE='4' and REMIND_DATE='".date( "j", $DAY_I )."' or TYPE='5' and REMIND_DATE='".date( "n-j", $DAY_I )."') 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, 20 );
		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 ).( "<br><a href='javascript:my_affair(".$AFF_ID.");' title='" ).$AFF_TITLE."'>".$CONTENT."</a><br>";
		if ( $BEGIN_TIME <= date( "Y-m-d", $DAY_I )." ".$REMIND_TIME )
		{
			$CAL_ARRAY[$I] .= $CONTENT;
		}
	}
}
echo "<table id=\"cal_table\" class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n  <tr align=\"center\" class=\"TableHeader\">\r\n    <td width=\"6%\"><b>周数</b></td>\r\n    <td width=\"14%\"><b>星期一</b></td>\r\n    <td width=\"14%\"><b>星期二</b></td>\r\n    <td width=\"14%\"><b>星期三</b></td>\r\n    <td width=\"14%\"><b>星期四</b></td>\r\n    <td width=\"14%\"><b>星期五</b></td>\r\n    <td width=\"12%\"><b>星期六</b></td>\r\n    <td width=\"12%\"><b>星期日</b></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 colspan=\"7\">\r\n";
	foreach ( $CAL_ALL_DAY as $ALL_DAY )
	{
		echo $ALL_DAY;
	}
	echo "      </td>\r\n    </tr>\r\n";
}
$I = 1;
for ( ;	$I <= date( "t", $DATE );	++$I	)
{
	$WEEK = date( "w", strtotime( $YEAR."-".$MONTH."-".$I ) );
	$WEEK = $WEEK == 0 ? 6 : $WEEK - 1;
	if ( $WEEK == 0 || $I == 1 )
	{
		$WEEK_BEGIN = date( "Ymd", strtotime( "-".$WEEK."days", strtotime( $YEAR."-".$MONTH."-".$I ) ) );
		echo "  <tr height=\"80\" class=\"TableData\">\n";
		echo "    <td id=\"tw_".$WEEK_BEGIN."\" class=\"TableContent\" align=\"center\">第".$WEEKS++."周</td>\n";
	}
	$J = 0;
	for ( ;	$J < $WEEK && $I == 1;	++$J	)
	{
		echo "    <td class=\"TableData\" valign=\"top\">&nbsp</td>\r\n";
	}
	echo "    <td id=\"td_";
	echo $YEAR.$MONTH.( $I < 10 ? "0".$I : $I );
	echo "\" class=\"";
	if ( $I == $DAY )
	{
		echo "TableRed";
	}
	echo "\" valign=\"top\">\r\n      <div id=\"div_";
	echo $YEAR.$MONTH.( $I < 10 ? "0".$I : $I );
	echo "\" align=\"right\" class=\"";
	echo $I == $DAY ? "TableRed" : "TableContent";
	echo "\" title=\"转到该日查看\" style=\"cursor:hand;width: 100%;\" onclick='location=\"day.php?YEAR=";
	echo $YEAR;
	echo "&MONTH=";
	echo $MONTH;
	echo "&DAY=";
	echo $I;
	echo "&OVER_STATUS=";
	echo $_GET['OVER_STATUS'];
	echo "\"'>\r\n        <font color=\"blue\"><b>";
	echo $I;
	echo "</b></font>\r\n      </div>\r\n      <div>\r\n        ";
	echo $CAL_ARRAY[$I];
	echo "      </div>\r\n    </td>\r\n";
	if ( $WEEK == 6 )
	{
		echo "  </tr>\n";
	}
}
if ( $WEEK != 6 )
{
	$I = $WEEK;
	for ( ;	$I < 6;	++$I	)
	{
		echo "    <td class=\"TableData\">&nbsp</td>\r\n";
	}
	echo "  </tr>\r\n";
}
$CUR_MONTH = $MONTH;
$query = "SELECT USER_NAME,BIRTHDAY from USER where NOT_LOGIN!='1' and DEPT_ID!=0 order by SUBSTRING(BIRTHDAY,6,5),USER_NAME ASC";
$cursor = exequery( $connection, $query );
$PERSON_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_NAME = $ROW['USER_NAME'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$MON = substr( $BIRTHDAY, 5, 2 );
	$DATA = substr( $BIRTHDAY, 5, 5 );
	if ( !( $MON != $CUR_MONTH ) || !( $BIRTHDAY == "1900-01-01 00:00:00" ) )
	{
		if ( $BIRTHDAY == "0000-00-00 00:00:00" )
		{
			break;
		}
	}
	else
	{
		continue;
	}
	$PERSON_STR .= $USER_NAME."(".$DATA.")&nbsp&nbsp&nbsp&nbsp";
	++$PERSON_COUNT;
}
if ( 0 < $PERSON_COUNT )
{
	echo "\r\n  <tr class=\"TableData\">\r\n    <td style=\"color:#46A718\" align=\"center\"><b>生日：</b></td>\r\n    <td colspan=\"20\">";
	echo $PERSON_STR;
	echo "</td>\r\n  </tr>\r\n";
}
echo "</table>\r\n";
echo $OP_MENU;
echo "</body>\r\n</html>\r\n\r\n";
?>