📄 submit.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
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 class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$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" && $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,DEPT_ID,CPTL_VAL,CPTL_KIND,PRCS_ID";
$VALUE_STR = "'{$CPTL_NO}','{$CPTL_NAME}',{$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: ../" );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -