📄 update.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

💻 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 ( $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}',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 .= ",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: query.php" );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -