📄 check_cfg.php
字号:
<?php
function check_assetcfg( )
{
$connection = openconnection( );
$query = "SELECT * from CP_ASSETCFG";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$BAL_SORT = $ROW['BAL_SORT'];
$DPCT_SORT = $ROW['DPCT_SORT'];
}
else
{
echo "<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<body class=\"bodycolor\" topmargin=\"5\">\r\n";
message( "", "未配置参数，请先到“参数设置”模块中设置参数" );
echo "</body>\r\n</html>\r\n";
exit( );
}
}
function check_dpct( )
{
$connection = openconnection( );
$query = "SELECT * from CP_ASSETCFG";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DPCT_SORT = $ROW['DPCT_SORT'];
}
$CUR_DATE = getdate( );
$CUR_MON = $CUR_DATE['mon'];
if ( $DPCT_SORT == "S" && 0 < $CUR_MON % 3 )
{
message( "", "只能在3、6、9、12月进行折旧" );
exit( );
}
else if ( $DPCT_SORT == "Y" && 0 < $CUR_MON % 12 )
{
message( "", "只能在12月进行折旧" );
exit( );
}
}
function check_depre_date( $DEPRE_DATE )
{
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_DATE_ARRAY = explode( "-", $CUR_DATE );
$DEPRE_DATE_ARRAY = explode( "-", $DEPRE_DATE );
return ( $CUR_DATE_ARRAY[0] - $DEPRE_DATE_ARRAY[0] ) * 12 + ( $CUR_DATE_ARRAY[1] - $DEPRE_DATE_ARRAY[1] ) + 1;
}
function insert_dpct( $DPCT_SORT, $FROM_YY, $FROM_MM, $MON_NUM, $MON_DPCT, $LEFT_VALUE, $SUM_DPCT, $CPTL_ID )
{
$connection = openconnection( );
$PEPRE_DATE = date( "Y-m-d", time( ) );
if ( $DPCT_SORT == "M" )
{
$NUM = 1;
}
else if ( $DPCT_SORT == "S" )
{
$NUM = 3;
}
else if ( $DPCT_SORT == "Y" )
{
$NUM = 12;
}
$DPCT_COUNT = ( $MON_NUM - $MON_NUM % $NUM ) / $NUM;
if ( 0 < $MON_NUM % $NUM )
{
++$DPCT_COUNT;
}
$I = 0;
for ( ; $I < $DPCT_COUNT; ++$I )
{
if ( $LEFT_VALUE <= 0 )
{
}
else
{
$TO_YY = $FROM_YY;
$TO_MM = $FROM_MM + $NUM - 1;
if ( $MON_DPCT * $NUM <= $LEFT_VALUE )
{
$DEPRE_AMT = $MON_DPCT * $NUM;
if ( $I == 0 && 0 < $MON_NUM % $NUM )
{
$DEPRE_AMT = $MON_DPCT * ( $MON_NUM % $NUM );
$TO_MM = $FROM_MM + $MON_NUM % $NUM - 1;
}
if ( $NUM == 1 )
{
$TO_MM = $FROM_MM + $MON_NUM % $NUM;
}
}
else
{
$DEPRE_AMT = $LEFT_VALUE;
if ( $I == 0 && 0 < $MON_NUM % $NUM && $MON_DPCT * ( $MON_NUM % $NUM ) < $LEFT_VALUE )
{
$DEPRE_AMT = $MON_DPCT * ( $MON_NUM % $NUM );
$TO_MM = $FROM_MM + $MON_NUM % $NUM - 1;
}
if ( $NUM == 1 )
{
$TO_MM = $FROM_MM + $MON_NUM % $NUM;
}
}
if ( 12 < $TO_MM )
{
$TO_YY += 1;
$TO_MM = $TO_MM % 12;
}
$LEFT_VALUE = $LEFT_VALUE - $DEPRE_AMT;
if ( strlen( $FROM_MM ) == 1 )
{
$FROM_MM = "0".$FROM_MM;
}
if ( strlen( $TO_MM ) == 1 )
{
$TO_MM = "0".$TO_MM;
}
$FROM_YYMM = $FROM_YY."-".$FROM_MM;
$TO_YYMM = $TO_YY."-".$TO_MM;
$query = "insert into CP_DPCT_SUB (CPTL_ID,PEPRE_DATE,FROM_YYMM,TO_YYMM,DEPRE_AMT) values({$CPTL_ID},'{$PEPRE_DATE}','{$FROM_YYMM}','{$TO_YYMM}',{$DEPRE_AMT})";
exequery( $connection, $query );
$SUM_DPCT += $DEPRE_AMT;
$FROM_YY = $TO_YY;
$FROM_MM = $TO_MM + 1;
if ( 12 < $FROM_MM )
{
$FROM_YY += 1;
$FROM_MM = $FROM_MM % 12;
}
}
}
$query = "update CP_CPTL_INFO set SUM_DPCT={$SUM_DPCT} where CPTL_ID={$CPTL_ID}";
exequery( $connection, $query );
}
include_once( "inc/conn.php" );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -