📄 index.php
字号:
<?
include_once("../auth.php");
?>
<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);
?>
<?=$CAL_TIME?>-<?=$END_TIME?> <?=$CONTENT?><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;
elseif($TYPE=="3" && date("w",time())==$REMIND_DATE)
$FLAG=1;
elseif($TYPE=="4" && date("j",time())==$REMIND_DATE)
$FLAG=1;
elseif($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++;
?>
<?=substr($REMIND_TIME,0,5)?> <?=$CONTENT?><br>
<?
}
}
if($CAL_COUNT==0)
{
echo "暂无日程安排";
}
?>
<a href="../main.php?P=<?=$P?>">返回</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -