📄 export_excel.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/check_type.php");
ob_end_clean();
Header("Cache-control: private");
Header("Content-type: application/vnd.ms-excel");
Header("Content-Disposition: attachment; filename= 日程安排.xls");
?>
<html>
<head>
<title>日程安排导出</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="5">
<table border="1" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr style="BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;">
<td nowrap align="center">开始时间</td>
<td nowrap align="center">结束时间</td>
<td nowrap align="center">事务类型</td>
<td nowrap align="center">事务内容</td>
<td nowrap align="center">安排人</td>
<td nowrap align="center">时间状态</td>
<td nowrap align="center">完成状态</td>
</tr>
<?
$CUR_DATE=date("Y-m-d",time());
$CUR_TIME=date("Y-m-d H:i:s",time());
//----------- 合法性校验 ---------
if($SEND_TIME_MIN!="")
{
$TIME_OK=is_date($SEND_TIME_MIN);
if(!$TIME_OK)
{ Message("错误","\"日期\"的格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$SEND_TIME_MIN=$SEND_TIME_MIN." 00:00:00";
}
if($SEND_TIME_MAX!="")
{
$TIME_OK=is_date($SEND_TIME_MAX);
if(!$TIME_OK)
{ Message("错误","\"日期\"的格式不对，应形如 ".$CUR_DATE);
Button_Back();
exit;
}
$SEND_TIME_MAX=$SEND_TIME_MAX." 23:59:59";
}
//------------------------ 生成条件字符串 ------------------
$CONDITION_STR="";
if($CAL_TYPE!="")
$CONDITION_STR.=" and CAL_TYPE=$CAL_TYPE";
if($CONTENT!="")
$CONDITION_STR.=" and CONTENT like '%".$CONTENT."%'";
if($SEND_TIME_MIN!="")
$CONDITION_STR.=" and CAL_TIME>='$SEND_TIME_MIN'";
if($SEND_TIME_MAX!="")
$CONDITION_STR.=" and END_TIME<='$SEND_TIME_MAX'";
$query = "SELECT * from CALENDAR where USER_ID='$LOGIN_USER_ID'".$CONDITION_STR." order by CAL_TIME,END_TIME";
$cursor=exequery($connection,$query);
$CAL_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$CAL_TIME=$ROW["CAL_TIME"];
$END_TIME=$ROW["END_TIME"];
$CAL_TYPE=$ROW["CAL_TYPE"];
$CONTENT=$ROW["CONTENT"];
$MANAGER_ID=$ROW["MANAGER_ID"];
$OVER_STATUS=$ROW["OVER_STATUS"];
$CONTENT=str_replace("<","<",$CONTENT);
$CONTENT=str_replace(">",">",$CONTENT);
$CONTENT=stripslashes($CONTENT);
$MANAGER_NAME="";
if($MANAGER_ID!="")
{
$query1 = "SELECT * from USER where USER_ID='$MANAGER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$MANAGER_NAME="(安排人：".$ROW1["USER_NAME"].")";
}
if($OVER_STATUS=="" || $OVER_STATUS=="1")
$OVER_STATUS1="<font color='#00AA00'><b>已完成</span>";
elseif($OVER_STATUS=="0")
$OVER_STATUS1="<font color='#FF0000'><b>未完成</span>";
switch($CAL_TYPE)
{
case "1":
$CAL_TYPE="工作事务";
break;
case "2":
$CAL_TYPE="个人事务";
break;
}
if(compare_time($CUR_TIME,$END_TIME)>0)
$STATUS="<font color='#FF0000'><b>过期</b></font>";
else if(compare_time($CUR_TIME,$CAL_TIME)<0)
$STATUS="<font color='#0000AA'><b>未至</b></font>";
else
$STATUS="<font color='#00AA00'><b>进行中</b></font>";
?>
<tr style="BACKGROUND: #FFFFFF;">
<td><?=$CAL_TIME?></td>
<td><?=$END_TIME?></td>
<td><?=$CAL_TYPE?></td>
<td><?=$CONTENT?></td>
<td><?=$MANAGER_NAME?></td>
<td><?=$STATUS?></td>
<td><?=$OVER_STATUS1?></td>
</tr>
<?
}
?>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -