⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dpct.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
🔍 
<?php

include_once( "inc/auth.php" );
include_once( "../manage/check_cfg.php" );
check_assetcfg( );
echo "<html>\r\n<head>\r\n<title>固定资产折旧</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction cptl_detail(CPTL_ID)\r\n{\r\n URL=\"../manage/cptl_detail.php?CPTL_ID=\"+CPTL_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_notify\",\"height=470,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n\r\n\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellp";
echo "adding=\"0\" class=\"small\">\r\n  <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/manage/asset.gif\" align=\"absmiddle\">固定资产折旧\r\n    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td ><a href=\"#\" onclick=\"history.back()\"><img src=\"/images/button/return.gif\" border=\"0\"></a>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n";
check_dpct( );
$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'];
}
$DPCT_COUNT = 0;
$query = "SELECT CPTL_ID,MAX(PEPRE_DATE) PEPRE_DATE from CP_DPCT_SUB group by CPTL_ID order by PEPRE_DATE desc";
$cursor = exequery( $connection, $query );
$ii = -1;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CPTL_ID = $ROW['CPTL_ID'];
	$PEPRE_DATE = $ROW['PEPRE_DATE'];
	$MON_NUM = check_depre_date( $PEPRE_DATE );
	if ( $MON_NUM <= 1 )
	{
	}
	else
	{
		++$ii;
		$tmp_array[$ii]['id'] = $CPTL_ID;
		$tmp_array[$ii]['date_s'] = $PEPRE_DATE;
		$query1 = "SELECT * from CP_CPTL_INFO where CPTL_ID=".$CPTL_ID." and CPTL_KIND='01' and DCR_PRCS_ID=0   and FINISH_FLAG='0'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$CPTL_VAL = $ROW1['CPTL_VAL'];
			$CPTL_BAL = $ROW1['CPTL_BAL'];
			$MON_DPCT = $ROW1['MON_DPCT'];
			$SUM_DPCT = $ROW1['SUM_DPCT'];
			if ( $BAL_SORT == "01" )
			{
				$LEFT_VALUE = $CPTL_VAL - $CPTL_BAL - $SUM_DPCT;
			}
			else
			{
				$LEFT_VALUE = $CPTL_VAL - $CPTL_VAL * $CPTL_BAL / 100 - $SUM_DPCT;
			}
			if ( $LEFT_VALUE <= 0 )
			{
			}
			else
			{
				$FROM_ARRAY = explode( "-", $PEPRE_DATE );
				$FROM_YY = $FROM_ARRAY[0];
				$FROM_MM = $FROM_ARRAY[1] + 1;
				if ( 12 <= $FROM_MM )
				{
					$FROM_YY += 1;
					$FROM_MM = $FROM_MM % 12;
				}
				insert_dpct( $DPCT_SORT, $FROM_YY, $FROM_MM, $MON_NUM, $MON_DPCT, $LEFT_VALUE, $SUM_DPCT, $CPTL_ID );
				++$DPCT_COUNT;
				$sql_e = "SELECT SUM_DPCT FROM cp_cptl_info WHERE CPTL_ID={$CPTL_ID}";
				$result_e = exequery( $connection, $sql_e );
				$row_e = mysql_fetch_array( $result_e );
				$sum_dupt_new = $row_e['SUM_DPCT'];
				if ( $CPTL_VAL <= $sum_dupt_new + $CPTL_BAL )
				{
					$query = "update CP_CPTL_INFO set FINISH_FLAG='1' where CPTL_ID={$CPTL_ID}";
					exequery( $connection, $query );
				}
			}
		}
	}
}
$query = "SELECT * from CP_CPTL_INFO where CPTL_KIND='01' and DCR_PRCS_ID=0 and FINISH_FLAG='0' and FROM_YYMM!='0000-00-00'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CPTL_ID = $ROW['CPTL_ID'];
	$query1 = "SELECT * from CP_DPCT_SUB where CPTL_ID={$CPTL_ID}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
	}
	else
	{
		$CPTL_VAL = $ROW['CPTL_VAL'];
		$CPTL_BAL = $ROW['CPTL_BAL'];
		$MON_DPCT = $ROW['MON_DPCT'];
		$SUM_DPCT = $ROW['SUM_DPCT'];
		$FROM_YYMM = $ROW['FROM_YYMM'];
		$MON_NUM = check_depre_date( $FROM_YYMM );
		if ( $MON_NUM <= 0 )
		{
		}
		else
		{
			if ( $BAL_SORT == "01" )
			{
				$LEFT_VALUE = $CPTL_VAL - $CPTL_BAL - $SUM_DPCT;
			}
			else
			{
				$LEFT_VALUE = $CPTL_VAL - $CPTL_VAL * $CPTL_BAL / 100 - $SUM_DPCT;
			}
			$FROM_ARRAY = explode( "-", $FROM_YYMM );
			$FROM_YY = $FROM_ARRAY[0];
			$FROM_MM = $FROM_ARRAY[1];
			++$ii;
			$tmp_array[$ii]['id'] = $CPTL_ID;
			$tmp_array[$ii]['date_s'] = $FROM_YYMM;
			insert_dpct( $DPCT_SORT, $FROM_YY, $FROM_MM, $MON_NUM, $MON_DPCT, $LEFT_VALUE, $SUM_DPCT, $CPTL_ID );
			++$DPCT_COUNT;
			$sql_e = "SELECT SUM_DPCT FROM cp_cptl_info WHERE CPTL_ID={$CPTL_ID}";
			$result_e = exequery( $connection, $sql_e );
			$row_e = mysql_fetch_array( $result_e );
			$sum_dupt_new = $row_e['SUM_DPCT'];
			if ( $CPTL_VAL <= $sum_dupt_new + $CPTL_BAL )
			{
				$query = "update CP_CPTL_INFO set FINISH_FLAG='1' where CPTL_ID={$CPTL_ID}";
				exequery( $connection, $query );
			}
		}
	}
}
if ( 0 < $DPCT_COUNT )
{
	echo "<table width=\"100%\"  border=\"0\" cellpadding=\"2\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\r\n  <tr class=\"tablehead1\">\r\n    <td colspan=\"6\">本次折旧的资产</td>\r\n  </tr>\r\n  <tr bgcolor=\"#F0F0F0\">\r\n    <td width=\"10%\">";
	echo "<s";
	echo "trong> 资产编号 </strong></td>\r\n    <td>";
	echo "<s";
	echo "trong> 资产名称 </strong></td>\r\n    <td width=\"10%\">";
	echo "<s";
	echo "trong> 资产原值 </strong></td>\r\n    <td width=\"10%\">";
	echo "<s";
	echo "trong> 资产残值</strong></td>\r\n    <td width=\"15%\">";
	echo "<s";
	echo "trong>累次折旧</strong></td>\r\n    <td width=\"10%\">";
	echo "<s";
	echo "trong>本次折旧</strong></td>\r\n  </tr>\r\n";
	$key = 0;
	for ( ;	$key < count( $tmp_array );	++$key	)
	{
		$cptlid = $tmp_array[$key]['id'];
		$date_s = $tmp_array[$key]['date_s'];
		$sql = "SELECT * FROM cp_cptl_info WHERE CPTL_ID=".$cptlid;
		$rs = exequery( $connection, $sql );
		$row_cptl_detail = mysql_fetch_array( $rs );
		$sql = " \r\n            SELECT SUM(DEPRE_AMT) AS totalamt FROM cp_dpct_sub \r\n\t\t\t\tWHERE CPTL_ID=".$cptlid." \r\n\t\t\t\t   AND TO_YYMM>'".$date_s."' \r\n\t\t\t  ";
		$rs = exequery( $connection, $sql );
		$row_cptl_sub = mysql_fetch_array( $rs );
		echo "  <tr bgcolor=\"#FFFFFF\">\r\n    <td width=\"10%\">";
		echo $row_cptl_detail['CPTL_NO'];
		echo " </td>\r\n    <td><a href=\"javascript:cptl_detail('";
		echo $cptlid;
		echo "');\">";
		echo $row_cptl_detail['CPTL_NAME'];
		echo "</a> </td>\r\n    <td>";
		echo $row_cptl_detail['CPTL_VAL'];
		echo " </td>\r\n    <td>";
		echo $row_cptl_detail['CPTL_BAL'];
		echo "</td>\r\n    <td>";
		echo $row_cptl_detail['SUM_DPCT'];
		echo " </td>\r\n    <td>";
		echo $row_cptl_sub['totalamt'];
		echo " </td>\r\n  </tr>\r\n";
	}
	echo "</table>   \r\n   \r\n   \r\n   \r\n   ";
	message( "", "折旧完成，总共".$DPCT_COUNT."件资产折旧" );
	button_back( );
}
else
{
	message( "", "无可折旧的资产" );
}
echo "\r\n\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -