📄 export.php
字号:
<?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 "\r\n<html>\r\n<head>\r\n<title>固定资产查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body topmargin=\"5\">\r\n <table border=\"1\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n <td nowrap align=\"center\">资产编号</td>\r\n <td nowrap align=\"center\">资产名称</td>\r\n <td nowrap align=\"center\">资产类别</td>\r\n <td nowrap align=\"center\">所属部门</td>\r\n <td nowrap align=\"center\">资产原值</td>\r\n <td nowrap align=\"center\">残值(率)</td>\r\n <td nowrap align=\"center\">折旧年限</td>\r\n <td nowrap align=\"center\">月折旧额</td>\r\n <td nowrap align=\"center\">累计折旧</td>\r\n <td nowrap align=\"center\">资产性质</td>\r\n <td nowrap align=\"center\">折旧提足</td>\r\n <td nowrap align=\"center\">增加日期</td>\r\n <td nowrap align=\"center\">增加类型</td>\r\n <td nowrap align=\"center\">启用日期</td>\r\n <td nowrap align=\"center\">减少日期</td>\r\n <td nowrap align=\"center\">减少类型</td>\r\n <td nowrap align=\"center\">折旧记录</td>\r\n <td nowrap align=\"center\">保管人</td>\r\n <td nowrap align=\"center\">备注</td>\r\n </tr>\r\n";
$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;\">\r\n <td>";
echo $CPTL_NO;
echo "</td>\r\n <td>";
echo $CPTL_NAME;
echo "</td>\r\n <td>";
echo $TYPE_NAME;
echo "</td>\r\n <td>";
echo $DEPT_NAME;
echo "</td>\r\n <td>";
echo $CPTL_VAL;
echo "</td>\r\n <td>";
echo $CPTL_BAL.$PERCENTAGE;
echo "</td>\r\n <td>";
echo $DPCT_YY;
echo "</td>\r\n <td>";
echo $MON_DPCT;
echo "</td>\r\n <td>";
echo $SUM_DPCT;
echo "</td>\r\n <td>";
echo $CPTL_KIND_DESC;
echo "</td>\r\n <td>";
echo $FINISH_FLAG_DESC;
echo "</td>\r\n <td>";
echo $CREATE_DATE;
echo "</td>\r\n <td>";
echo $PRCS_LONG_DESC;
echo "</td>\r\n <td>";
if ( $FROM_YYMM == "0000-00-00" )
{
echo "未启用";
}
else
{
echo $FROM_YYMM;
}
echo "</td>\r\n <td>";
if ( $DCR_DATE != "0000-00-00" )
{
echo $DCR_DATE;
}
echo "</td>\r\n <td>";
echo $DCR_PRCS_LONG_DESC;
echo "</td>\r\n <td>";
echo $CONTENT_COMENT;
echo "</td> \r\n <td>";
echo $KEEPER;
echo "</td>\r\n <td>";
echo $REMARK;
echo "</td>\r\n </tr>\r\n";
}
echo " </table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -