export_excel.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 151 行
PHP
151 行
<?
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');
echo '
<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>
<t';
echo 'd 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 == '') OR ($OVER_STATUS == '1')))
{
$OVER_STATUS1 = '<font color=\'#00AA00\'><b>已完成</span>';
}
else
{
if (($OVER_STATUS == '0'))
{
$OVER_STATUS1 = '<font color=\'#FF0000\'><b>未完成</span>';
}
}
$CAL_TYPE = get_code_name ($CAL_TYPE, 'CAL_TYPE');
if ((0 < compare_time ($CUR_TIME, $END_TIME)))
{
$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>';
}
}
echo '
<tr style="BACKGROUND: #FFFFFF;">
<td>';
echo substr ($CAL_TIME, 0, -3);
echo '</td>
<td>';
echo substr ($END_TIME, 0, -3);
echo '</td>
<td>';
echo $CAL_TYPE;
echo '</td>
<td>';
echo $CONTENT;
echo '</td>
<td>';
echo $MANAGER_NAME;
echo '</td>
<td>';
echo $STATUS;
echo '</td>
<td>';
echo $OVER_STATUS1;
echo '</td>
</tr>
';
}
echo ' </table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?