📄 export.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_field.php" );
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename= 固定资产.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 class=\"TableList\" width=\"95%\">\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 \r\n </tr>\r\n";
$CONDITION_STR = "";
if ( $CPTL_NO != "" )
{
$CONDITION_STR .= " and CPTL_NO like '%".$CPTL_NO."%'";
}
if ( $CPTL_NAME != "" )
{
$CONDITION_STR .= " and CPTL_NAME like '%".$CPTL_NAME."%'";
}
if ( $TYPE_ID != "" )
{
$CONDITION_STR .= " and TYPE_ID=".$TYPE_ID;
}
if ( $DEPT_ID != "" )
{
$CONDITION_STR .= " and CP_CPTL_INFO.DEPT_ID=".$DEPT_ID;
}
if ( $CPTL_KIND != "" )
{
$CONDITION_STR .= " and CPTL_KIND=".$CPTL_KIND;
}
if ( $PRCS_ID != "" )
{
$CONDITION_STR .= " and PRCS_ID=".$PRCS_ID;
}
if ( $DCR_PRCS_ID != "" )
{
$CONDITION_STR .= " and DCR_PRCS_ID=".$DCR_PRCS_ID;
}
if ( $FINISH_FLAG != "" )
{
$CONDITION_STR .= " and FINISH_FLAG=".$FINISH_FLAG;
}
if ( $CPTL_VAL_MIN != "" )
{
$CONDITION_STR .= " and CPTL_VAL>=".$CPTL_VAL_MIN;
}
if ( $CPTL_VAL_MAX != "" )
{
$CONDITION_STR .= " and CPTL_VAL<=".$CPTL_VAL_MAX;
}
if ( $CPTL_BAL_MIN != "" )
{
$CONDITION_STR .= " and CPTL_BAL>=".$CPTL_BAL_MIN;
}
if ( $CPTL_BAL_MAX != "" )
{
$CONDITION_STR .= " and CPTL_BAL<=".$CPTL_BAL_MAX;
}
if ( $CREATE_DATE_MIN != "" )
{
$CONDITION_STR .= " and CREATE_DATE>='".$CREATE_DATE_MIN."'";
}
if ( $CREATE_DATE_MAX != "" )
{
$CONDITION_STR .= " and CREATE_DATE<='".$CREATE_DATE_MAX."'";
}
if ( $DCR_DATE_MIN != "" )
{
$CONDITION_STR .= " and DCR_DATE>='".$DCR_DATE_MIN."'";
}
if ( $DCR_DATE_MAX != "" )
{
$CONDITION_STR .= " and DCR_DATE<='".$DCR_DATE_MAX."'";
}
if ( $FROM_YYMM_MIN != "" )
{
$CONDITION_STR .= " and FROM_YYMM>='".$FROM_YYMM_MIN."'";
}
if ( $FROM_YYMM_MAX != "" )
{
$CONDITION_STR .= " and FROM_YYMM<='".$FROM_YYMM_MAX."'";
}
if ( $KEEPER != "" )
{
$CONDITION_STR .= " and KEEPER like '%".$KEEPER."%'";
}
if ( $REMARK != "" )
{
$CONDITION_STR .= " and REMARK like '%".$REMARK."%'";
}
$query = "select * from CP_CPTL_INFO where 1=1 ".$CONDITION_STR." order by DEPT_ID,CREATE_DATE,CPTL_NO";
$cursor = exequery( $connection, $query );
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'];
$DEF_FIELD_ARRAY = get_field_text( "CP_CPTL_INFO", $CPTL_ID );
$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 + -