?? index.php
字號(hào):
<?
include_once '../auth.php';
echo '
<html>
<head>
<title>今日日程</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<font color=blue size=+2><b>今日日程</b></font>
<br><br>
';
$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>
';
}
$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' AND date ('w', time ()) == $REMIND_DATE))
{
$FLAG = 1;
}
else
{
if (($TYPE == '4' AND 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 AND 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>
';
continue;
}
}
if ($CAL_COUNT == 0)
{
echo '暫無(wú)日程安排';
}
echo '
<a href="../main.php?P=';
echo $P;
echo '">返回</a>
</body>
</html>
';
?>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -