📄 cptl_detail.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<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 = '未提足';
}
}
echo '<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">';
echo '<s';
echo 'pan class="big3"> 固定资产详情 - ';
echo $CPTL_NAME;
echo '</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">';
echo $CPTL_NO;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产名称</td>
<td align="left" class="TableData">';
echo $CPTL_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产类别</td>
<td align="left" class="TableData">';
echo $TYPE_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">所属部门 </td>
<td align="left" class="TableData">';
echo $DEPT_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产原值</td>
<td nowrap align="left" class="TableData">';
echo $CPTL_VAL;
echo '</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 = '%';
}
}
echo ' <tr>
<td nowrap align="center" class="TableContent" width="80">';
echo $BAL_DESC;
echo '</td>
<td nowrap align="left" class="TableData">';
echo ($CPTL_BAL.$PERCENTAGE);
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">折旧年限</td>
<td nowrap align="left" class="TableData">';
echo $DPCT_YY;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">月折旧额</td>
<td align="left" class="TableData">';
echo $MON_DPCT;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">累计折旧</td>
<td nowrap align="left" class="TableData">';
echo $SUM_DPCT;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">资产性质</td>
<td nowrap align="left" class="TableData">';
echo $CPTL_KIND_DESC;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">折旧提足 </td>
<td nowrap align="left" class="TableData">';
echo $FINISH_FLAG_DESC;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">增加日期</td>
<td nowrap align="left" class="TableData">';
echo $CREATE_DATE;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">增加类型 </td>
<td nowrap align="left" class="TableData">';
echo $PRCS_LONG_DESC;
echo '</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;
}
echo '</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;
}
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">减少类型</td>
<td nowrap align="left" class="TableData">';
echo $DCR_PRCS_LONG_DESC;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">保管人</td>
<td nowrap align="left" class="TableData">';
echo $KEEPER;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">备注</td>
<td align="left" class="TableData">';
echo $REMARK;
echo '</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 ('', '未找到相应记录！');
}
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -