📄 index.php
字号:
<?php
include_once( "../auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>今日日程</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n<body>\r\n<font color=blue size=+2><b>今日日程</b></font>\r\n<br><br>\r\n\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from CALENDAR where USER_ID='".$LOGIN_USER_ID."' and to_days(CAL_TIME)=to_days('{$CUR_DATE}') order by CAL_TIME";
$cursor = exequery( $connection, $query );
$CAL_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$CAL_COUNT;
$CAL_ID = $ROW['CAL_ID'];
$CAL_TIME = $ROW['CAL_TIME'];
$END_TIME = $ROW['END_TIME'];
$CAL_TIME = strtok( $CAL_TIME, " " );
$CAL_TIME = strtok( " " );
$CAL_TIME = substr( $CAL_TIME, 0, 5 );
$END_TIME = strtok( $END_TIME, " " );
$END_TIME = strtok( " " );
$END_TIME = substr( $END_TIME, 0, 5 );
$CONTENT = $ROW['CONTENT'];
$CONTENT = str_replace( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $CONTENT );
$CONTENT = stripslashes( $CONTENT );
echo " ";
echo $CAL_TIME;
echo "-";
echo $END_TIME;
echo " ";
echo $CONTENT;
echo "<br>\r\n";
}
$query = "SELECT * from AFFAIR where USER_ID='".$LOGIN_USER_ID."' and BEGIN_TIME<='{$CUR_TIME}' order by REMIND_TIME";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$AFF_ID = $ROW['AFF_ID'];
$USER_ID = $ROW['USER_ID'];
$TYPE = $ROW['TYPE'];
$REMIND_DATE = $ROW['REMIND_DATE'];
$REMIND_TIME = $ROW['REMIND_TIME'];
$CONTENT = $ROW['CONTENT'];
$FLAG = 0;
if ( $TYPE == "2" )
{
$FLAG = 1;
}
else if ( $TYPE == "3" && date( "w", time( ) ) == $REMIND_DATE )
{
$FLAG = 1;
}
else if ( $TYPE == "4" && date( "j", time( ) ) == $REMIND_DATE )
{
$FLAG = 1;
}
else if ( $TYPE == "5" )
{
$REMIND_ARR = explode( "-", $REMIND_DATE );
$REMIND_DATE_MON = $REMIND_ARR[0];
$REMIND_DATE_DAY = $REMIND_ARR[1];
if ( date( "n", time( ) ) == $REMIND_DATE_MON && date( "j", time( ) ) == $REMIND_DATE_DAY )
{
$FLAG = 1;
}
}
if ( $FLAG == 1 )
{
++$CAL_COUNT;
echo " ";
echo substr( $REMIND_TIME, 0, 5 );
echo " ";
echo $CONTENT;
echo "<br>\r\n";
}
}
if ( $CAL_COUNT == 0 )
{
echo "暂无日程安排";
}
echo "\r\n<a href=\"../main.php?P=";
echo $P;
echo "\">返回</a>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -