📄 update.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>
<html>
<head>
<title>修改固定资产</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$CUR_DATE=date("Y-m-d",time());
$connection=OpenConnection();
if($CPTL_NAME=="")
$MSG_ST.="\"资产名称\",";
if($DEPT_ID=="")
$MSG_ST.="\"所属部门\",";
if($CPTL_KIND=="")
$MSG_ST.="\"资产性质\",";
if($PRCS_ID=="")
$MSG_ST.="\"增加类型\",";
if($KEEPER=="")
$MSG_ST.="\"保管人\",";
if($CPTL_KIND=="01")
{
if($FINISH_FLAG=="")
$MSG_ST.="\"折旧\",";
}
if($MSG_STR!="")
{
$MSG_STR=substr($MSG_STR,0,-1)."不能为空";
Message("",$MSG_STR);
}
$MSG_STR="";
if($CPTL_KIND=="01")
{
if(!settype($CPTL_BAL,"float"))
$MSG_STR.="\"折旧(率)\",";
if(!settype($DPCT_YY,"float"))
$MSG_STR.="\"折旧年限\",";
if(!settype($SUM_DPCT,"float"))
$MSG_STR.="\"累计折旧\",";
if(!settype($MON_DPCT,"float"))
$MSG_STR.="\"月折旧额\",";
}
else
{
if($CPTL_BAL!=""&&!settype($CPTL_BAL,"float"))
$MSG_STR.="\"折旧(率)\",";
if($DPCT_YY!=""&&!settype($DPCT_YY,"float"))
$MSG_STR.="\"折旧年限\",";
if($SUM_DPCT!=""&&!settype($SUM_DPCT,"float"))
$MSG_STR.="\"累计折旧\",";
if($MON_DPCT!=""&&!settype($MON_DPCT,"float"))
$MSG_STR.="\"月折旧额\",";
}
if($MSG_STR!="")
{
$MSG_STR=substr($MSG_STR,0,-1)."必须为数字";
Message("",$MSG_STR);
Button_Back();
exit;
}
if($FROM_YYMM!=""&&!is_date($FROM_YYMM))
{
Message("","\"启用日期\"应为日期型");
Button_Back();
exit;
}
$UPDATE_STR="CPTL_NO='$CPTL_NO',CPTL_NAME='$CPTL_NAME',TYPE_ID=$TYPE_ID,DEPT_ID=$DEPT_ID,CPTL_VAL=$CPTL_VAL,CPTL_KIND='$CPTL_KIND',PRCS_ID=$PRCS_ID";
if($CPTL_BAL!="")
$UPDATE_STR.=",CPTL_BAL=$CPTL_BAL";
else
$UPDATE_STR.=",CPTL_BAL=0";
if($DPCT_YY!="")
$UPDATE_STR.=",DPCT_YY=$DPCT_YY";
else
$UPDATE_STR.=",DPCT_YY=0";
if($SUM_DPCT!="")
$UPDATE_STR.=",SUM_DPCT=$SUM_DPCT";
else
$UPDATE_STR.=",SUM_DPCT=0";
if($MON_DPCT!="")
$UPDATE_STR.=",MON_DPCT=$MON_DPCT";
else
$UPDATE_STR.=",MON_DPCT=0";
if($FINISH_FLAG!="")
$UPDATE_STR.=",FINISH_FLAG='$FINISH_FLAG'";
$UPDATE_STR.=",CREATE_DATE='$CUR_DATE',FROM_YYMM='$FROM_YYMM',KEEPER='$KEEPER',REMARK='$REMARK'";
//------------------- 增加固定资产 -----------------------
$query="update CP_CPTL_INFO set $UPDATE_STR where CPTL_ID=$CPTL_ID";
exequery($connection,$query);
header("location: index.php");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -