📄 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");
?>
<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>
<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>
<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="%";
}
?>
<tr style="BACKGROUND: #FFFFFF;">
<td><?=$CPTL_NO?></td>
<td><?=$CPTL_NAME?></td>
<td><?=$TYPE_NAME?></td>
<td><?=$DEPT_NAME?></td>
<td><?=$CPTL_VAL?></td>
<td><?=$CPTL_BAL.$PERCENTAGE?></td>
<td><?=$DPCT_YY?></td>
<td><?=$MON_DPCT?></td>
<td><?=$SUM_DPCT?></td>
<td><?=$CPTL_KIND_DESC?></td>
<td><?=$FINISH_FLAG_DESC?></td>
<td><?=$CREATE_DATE?></td>
<td><?=$PRCS_LONG_DESC?></td>
<td><?if($FROM_YYMM=="0000-00-00") echo "未启用"; else echo $FROM_YYMM;?></td>
<td><?if($DCR_DATE!="0000-00-00") echo $DCR_DATE;?></td>
<td><?=$DCR_PRCS_LONG_DESC?></td>
<td><?=$CONTENT_COMENT?></td>
<td><?=$KEEPER?></td>
<td><?=$REMARK?></td>
</tr>
<?
}
?>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -