📄 submit.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(!settype($CPTL_VAL,"float"))
$MSG_ST.="\"资产原值\",";
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;
}
$FIELD_STR="CPTL_NO,CPTL_NAME,TYPE_ID,DEPT_ID,CPTL_VAL,CPTL_KIND,PRCS_ID";
$VALUE_STR="'$CPTL_NO','$CPTL_NAME',$TYPE_ID,$DEPT_ID,$CPTL_VAL,'$CPTL_KIND',$PRCS_ID";
if($CPTL_BAL!="")
{
$FIELD_STR.=",CPTL_BAL";
$VALUE_STR.=",".$CPTL_BAL;
}
if($DPCT_YY!="")
{
$FIELD_STR.=",DPCT_YY";
$VALUE_STR.=",".$DPCT_YY;
}
if($SUM_DPCT!="")
{
$FIELD_STR.=",SUM_DPCT";
$VALUE_STR.=",".$SUM_DPCT;
}
if($MON_DPCT!="")
{
$FIELD_STR.=",MON_DPCT";
$VALUE_STR.=",".$MON_DPCT;
}
if($FINISH_FLAG!="")
{
$FIELD_STR.=",FINISH_FLAG";
$VALUE_STR.=",'".$FINISH_FLAG."'";
}
$FIELD_STR.=",CREATE_DATE,FROM_YYMM,KEEPER,REMARK";
$VALUE_STR.=",'$CUR_DATE','$FROM_YYMM','$KEEPER','$REMARK'";
//------------------- 增加固定资产 -----------------------
$query="insert into CP_CPTL_INFO (".$FIELD_STR.") values(".$VALUE_STR.");";
exequery($connection,$query);
header("location: ../");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -