📄 cptl_detail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>固定资产详情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<?
$CUR_DATE=date("Y-m-d",time());
$query="select * from CP_CPTL_INFO where CPTL_ID=$CPTL_ID";
$cursor=exequery($connection,$query);
if($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"];
if($FINISH_FLAG=="1")
$FINISH_FLAG_DESC="提足";
else if($FINISH_FLAG=="0")
$FINISH_FLAG_DESC="未提足";
?>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/asset.gif" width="24" height="24"><span class="big3"> 固定资产详情 - <?=$CPTL_NAME?></span><br>
</td>
</tr>
</table>
<hr width="100%" height="1" align="left" color="#FFFFFF">
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr>
<td nowrap align="center" class="TableContent" width="80">资产编号</td>
<td align="left" class="TableData"><?=$CPTL_NO?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产名称</td>
<td align="left" class="TableData"><?=$CPTL_NAME?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产类别</td>
<td align="left" class="TableData"><?=$TYPE_NAME?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">所属部门 </td>
<td align="left" class="TableData"><?=$DEPT_NAME?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产原值</td>
<td nowrap align="left" class="TableData"><?=$CPTL_VAL?></td>
</tr>
<?
$query = "SELECT * from CP_ASSETCFG";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$BAL_SORT=$ROW["BAL_SORT"];
if($BAL_SORT=="01")
{
$BAL_DESC="残值";
$PERCENTAGE="";
}
else if($BAL_SORT=="02")
{
$BAL_DESC="残值率";
$PERCENTAGE="%";
}
?>
<tr>
<td nowrap align="center" class="TableContent" width="80"><?=$BAL_DESC?></td>
<td nowrap align="left" class="TableData"><?=$CPTL_BAL.$PERCENTAGE?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">折旧年限</td>
<td nowrap align="left" class="TableData"><?=$DPCT_YY?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">月折旧额</td>
<td align="left" class="TableData"><?=$MON_DPCT?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">累计折旧</td>
<td nowrap align="left" class="TableData"><?=$SUM_DPCT?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产性质</td>
<td nowrap align="left" class="TableData"><?=$CPTL_KIND_DESC?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">折旧提足 </td>
<td nowrap align="left" class="TableData"><?=$FINISH_FLAG_DESC?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">增加日期</td>
<td nowrap align="left" class="TableData"><?=$CREATE_DATE?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">增加类型 </td>
<td nowrap align="left" class="TableData"><?=$PRCS_LONG_DESC?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">启用日期</td>
<td nowrap align="left" class="TableData"><?if($FROM_YYMM=="0000-00-00") echo "未启用"; else echo $FROM_YYMM;?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">减少日期</td>
<td nowrap align="left" class="TableData"><?if($DCR_DATE!="0000-00-00") echo $DCR_DATE;?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">减少类型</td>
<td nowrap align="left" class="TableData"><?=$DCR_PRCS_LONG_DESC?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">保管人</td>
<td nowrap align="left" class="TableData"><?=$KEEPER?></td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">备注</td>
<td nowrap align="left" class="TableData"><?=$REMARK?></td>
</tr>
<tr class="TableControl">
<td colspan="9" align="center">
<input type="button" value="打印" class="BigButton" onclick="document.execCommand('Print');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
<?
}
else
Message("","未找到相应记录！");
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -