⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
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 = csubstr( strip_tags( $CONTENT ), 0, 20 );
	if ( $LAST_REMIND == "0000-00-00" )
	{
		$LAST_REMIND = "";
	}
	$AFF_TITLE = "提醒时间：每月".$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>";
	$REMIND_WEEK = date( "w", strtotime( date( "Y-m-", $WEEK_BEGIN ).$REMIND_DATE ) );
	$REMIND_WEEK = $REMIND_WEEK == 0 ? 6 : $REMIND_WEEK - 1;
	$REMIND_HOUR = intval( substr( $REMIND_TIME, 0, strpos( $REMIND_TIME, ":" ) ) );
	if ( $BEGIN_TIME <= date( "Y-m-", $WEEK_BEGIN ).$REMIND_DATE." ".$REMIND_TIME )
	{
		$CAL_ARRAY[$REMIND_WEEK][$REMIND_HOUR] .= $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='5' and (END_TIME='' or END_TIME='0000-00-00 00:00:00' or END_TIME>='".date( "Y-m-d", $DATE )." 23:59:59') and REMIND_DATE>='".date( "n-j", $WEEK_BEGIN )."' and REMIND_DATE<='".date( "n-j", $WEEK_END )."' 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 = csubstr( strip_tags( $CONTENT ), 0, 20 );
	if ( $LAST_REMIND == "0000-00-00" )
	{
		$LAST_REMIND = "";
	}
	$AFF_TITLE = "提醒时间：每年".str_replace( "-", "月", $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>";
	$REMIND_WEEK = date( "w", strtotime( date( "Y-", $WEEK_BEGIN ).$REMIND_DATE ) );
	$REMIND_WEEK = $REMIND_WEEK == 0 ? 6 : $REMIND_WEEK - 1;
	$REMIND_HOUR = intval( substr( $REMIND_TIME, 0, strpos( $REMIND_TIME, ":" ) ) );
	if ( $BEGIN_TIME <= date( "Y-", $WEEK_BEGIN ).$REMIND_DATE." ".$REMIND_TIME )
	{
		$CAL_ARRAY[$REMIND_WEEK][$REMIND_HOUR] .= $CONTENT;
	}
}
echo "\r\n  <table id=\"cal_table\" class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n    <tr id=\"tbl_header\" align=\"center\" class=\"TableHeader\">\r\n      <td width=\"9%\"><a href=\"javascript:display_front();\">0-6点</a></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN );
echo "(星期一)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 86400 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 86400 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 86400 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 86400 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 86400 );
echo "(星期二)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 172800 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 172800 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 172800 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 172800 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 172800 );
echo "(星期三)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 259200 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 259200 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 259200 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 259200 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 259200 );
echo "(星期四)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 345600 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 345600 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 345600 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 345600 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 345600 );
echo "(星期五)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 432000 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 432000 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 432000 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 432000 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 432000 );
echo "(星期六)</a></b></td>\r\n      <td width=\"13%\" id=\"th_";
echo date( "Ymd", $WEEK_BEGIN + 518400 );
echo "\"><b><a href=\"day.php?YEAR=";
echo date( "Y", $WEEK_BEGIN + 518400 );
echo "&MONTH=";
echo date( "m", $WEEK_BEGIN + 518400 );
echo "&DAY=";
echo date( "d", $WEEK_BEGIN + 518400 );
echo "&OVER_STATUS=";
echo $_GET['OVER_STATUS'];
echo "\">";
echo date( "m/d", $WEEK_BEGIN + 518400 );
echo "(星期日)</a></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";
}
echo "    <tbody id=\"front\" style=\"display:none;\">\r\n";
$I = 0;
for ( ;	$I < 7;	++$I	)
{
	echo "    <tr class=\"TableData\" valign=\"top\" height=\"40\">\r\n      <td align=\"center\" class=\"TableContent\" width=\"9%\">";
	if ( $I < 10 )
	{
		echo "0";
	}
	echo $I;
	echo ":00</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[0][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 86400 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 86400 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[1][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 172800 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 172800 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[2][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 259200 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 259200 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[3][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 345600 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 345600 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[4][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 432000 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 432000 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[5][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 518400 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 518400 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[6][$I];
	echo "</td>\r\n    </tr>\r\n";
}
echo "    </tbody>\r\n";
$I = 7;
for ( ;	$I < 24;	++$I	)
{
	echo "    <tr class=\"TableData\" valign=\"top\" height=\"40\">\r\n      <td align=\"center\" class=\"TableContent\" width=\"9%\">";
	if ( $I < 10 )
	{
		echo "0";
	}
	echo $I;
	echo ":00</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[0][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 86400 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 86400 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[1][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 172800 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 172800 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[2][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 259200 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 259200 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[3][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 345600 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 345600 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[4][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 432000 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 432000 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[5][$I];
	echo "</td>\r\n      <td id=\"td_";
	echo $WEEK_BEGIN + 518400 + $I * 3600;
	echo "\" width=\"13%\"";
	if ( $DATE == $WEEK_BEGIN + 518400 )
	{
		echo " class=\"TableRowHover\"";
	}
	echo ">";
	echo $CAL_ARRAY[6][$I];
	echo "</td>\r\n    </tr>\r\n";
}
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</body>\r\n</html>\r\n\r\n";
?>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -