📄 export.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
ob_end_clean ();
header ('Cache-control: private');
header ('Content-type: application/vnd.ms-excel');
header ((((''.'Content-Disposition: attachment; filename= ').$LOGIN_USER_ID).'.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>
<td nowrap align="center">月折旧额</td>
<td nowrap align="center">累计折旧</td>
<td nowrap align="center">资产性质</td>
<td nowrap align="center">';
echo '折旧提足</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>
<td nowrap align="center">保管人</td>
<td nowrap align="center">备注</td>
</tr>
';
$cursor = exequery ($connection, $QUERY_ASSET);
while ($ROW = mysql_fetch_array ($cursor))
{
$CPTL_ID = $ROW['CPTL_ID'];
$CPTL_NO = $ROW['CPTL_NO'];
$CPTL_NAME = $ROW['CPTL_NAME'];
$TYPE_ID = $ROW['TYPE_ID'];
$DEPT_ID = $ROW['DEPT_ID'];
$CPTL_VAL = $ROW['CPTL_VAL'];
$CPTL_BAL = $ROW['CPTL_BAL'];
$DPCT_YY = $ROW['DPCT_YY'];
$MON_DPCT = $ROW['MON_DPCT'];
$SUM_DPCT = $ROW['SUM_DPCT'];
$CPTL_KIND = $ROW['CPTL_KIND'];
$PRCS_ID = $ROW['PRCS_ID'];
$FINISH_FLAG = $ROW['FINISH_FLAG'];
$CREATE_DATE = $ROW['CREATE_DATE'];
$DCR_DATE = $ROW['DCR_DATE'];
$DCR_PRCS_ID = $ROW['DCR_PRCS_ID'];
$FROM_YYMM = $ROW['FROM_YYMM'];
$KEEPER = $ROW['KEEPER'];
$REMARK = $ROW['REMARK'];
$query = ((''.'SELECT * from CP_ASSET_TYPE where TYPE_ID=').$TYPE_ID);
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$TYPE_NAME = $ROW1['TYPE_NAME'];
}
if (($CPTL_KIND == '01'))
{
$CPTL_KIND_DESC = '资产';
}
else
{
if (($CPTL_KIND == '02'))
{
$CPTL_KIND_DESC = '费用';
}
}
$query1 = ((''.'select * from CP_PRCS_PROP where PRCS_ID=').$PRCS_ID);
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$PRCS_LONG_DESC = $ROW1['PRCS_LONG_DESC'];
}
$query1 = ((''.'select * from CP_PRCS_PROP where PRCS_ID=').$DCR_PRCS_ID);
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DCR_PRCS_LONG_DESC = $ROW1['PRCS_LONG_DESC'];
}
$query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DEPT_NAME = $ROW1['DEPT_NAME'];
}
$query1 = (((''.'select * from CP_DPCT_SUB where CPTL_ID=').$CPTL_ID).' order by PEPRE_DATE asc');
$cursor1 = exequery ($connection, $query1);
$CONTENT_COMENT = '';
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$PEPRE_DATE = $ROW1['PEPRE_DATE'];
$FROM_YYMM = $ROW1['FROM_YYMM'];
$TO_YYMM = $ROW1['TO_YYMM'];
$DEPRE_AMT = $ROW1['DEPRE_AMT'];
($CONTENT_COMENT .= ((((((('<br>'.$PEPRE_DATE).' ').$FROM_YYMM).' ').$TO_YYMM).' ').$DEPRE_AMT));
}
$CONTENT_COMENT = ('发生时间 起始时间 结束时间 折旧金额'.$CONTENT_COMENT);
if (($FINISH_FLAG == '1'))
{
$FINISH_FLAG_DESC = '提足';
}
else
{
if (($FINISH_FLAG == '0'))
{
$FINISH_FLAG_DESC = '未提足';
}
}
$query1 = 'SELECT * from CP_ASSETCFG';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$BAL_SORT = $ROW['BAL_SORT'];
}
if (($BAL_SORT == '01'))
{
$BAL_DESC = '残值';
$PERCENTAGE = '';
}
else
{
if (($BAL_SORT == '02'))
{
$BAL_DESC = '残值率';
$PERCENTAGE = '%';
}
}
echo ' <tr style="BACKGROUND: #FFFFFF;">
<td>';
echo $CPTL_NO;
echo '</td>
<td>';
echo $CPTL_NAME;
echo '</td>
<td>';
echo $TYPE_NAME;
echo '</td>
<td>';
echo $DEPT_NAME;
echo '</td>
<td>';
echo $CPTL_VAL;
echo '</td>
<td>';
echo ($CPTL_BAL.$PERCENTAGE);
echo '</td>
<td>';
echo $DPCT_YY;
echo '</td>
<td>';
echo $MON_DPCT;
echo '</td>
<td>';
echo $SUM_DPCT;
echo '</td>
<td>';
echo $CPTL_KIND_DESC;
echo '</td>
<td>';
echo $FINISH_FLAG_DESC;
echo '</td>
<td>';
echo $CREATE_DATE;
echo '</td>
<td>';
echo $PRCS_LONG_DESC;
echo '</td>
<td>';
if (($FROM_YYMM == '0000-00-00'))
{
echo '未启用';
}
else
{
echo $FROM_YYMM;
}
echo '</td>
<td>';
if (($DCR_DATE != '0000-00-00'))
{
echo $DCR_DATE;
}
echo '</td>
<td>';
echo $DCR_PRCS_LONG_DESC;
echo '</td>
<td>';
echo $CONTENT_COMENT;
echo '</td>
<td>';
echo $KEEPER;
echo '</td>
<td>';
echo $REMARK;
echo '</td>
</tr>
';
}
echo ' </table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -