📄 index.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</head>\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<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" >";
echo "\r\n  <tr class=\"tablehead1\">\r\n  <td valign=\"bottom\"><img src=\"/images/manage/asset.gif\" align=\"absmiddle\">固定资产折旧\r\n  </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n  <td><a href=\"dpct.php\"><img src=\"/images/button/depreciation.gif\" border=\"0\" title=\"开始折旧\"></a>\r\n  </td>\r\n  </tr>\r\n</table>\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 );
echo "<br>\r\n<table width=\"100%\"  border=\"0\" cellpadding=\"5\" cellspacing=\"1\">\r\n  <tr>\r\n    <td colspan=\"7\" style=\"font:bold;\">折旧资产</td>\r\n  </tr>\r\n  <tr class=\"TableHeader\">\r\n    <td width=\"10%\"> 资产编号 </td>\r\n    <td width=\"20%\"> 资产名称 </td>\r\n    <td width=\"10%\"> 资产原值 </td>\r\n    <td width=\"10%\"> 资产残值</td>\r\n    <td width=\"15%\">增加日期</td>\r\n    <td width=\"10%\">累计折旧</td>\r\n    <td>&nbsp;</td>\r\n  </tr>\r\n  ";
$total_depreciation = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	if ( $total_depreciation % 2 == 1 )
	{
		$tdCss = "TableLine1";
	}
	else
	{
		$tdCss = "TableLine2";
	}
	$CPTL_ID = $ROW['CPTL_ID'];
	$PEPRE_DATE = $ROW['PEPRE_DATE'];
	$MON_NUM = check_depre_date( $PEPRE_DATE );
	if ( $MON_NUM <= 1 )
	{
	}
	else
	{
		$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
			{
				++$total_depreciation;
				$sql = "SELECT CPTL_ID,CPTL_NO,CPTL_NAME,CPTL_VAL,CPTL_BAL,SUM_DPCT,CREATE_DATE FROM cp_cptl_info WHERE CPTL_ID=".$CPTL_ID;
				$rs = exequery( $connection, $sql );
				$rsrow = mysql_fetch_array( $rs );
				echo "  \r\n  <tr class='";
				echo $tdCss;
				echo "'>\r\n    <td>";
				echo $rsrow['CPTL_NO'];
				echo "</td>\r\n    <td><a href=\"javascript:cptl_detail('";
				echo $CPTL_ID;
				echo "');\">";
				echo $rsrow['CPTL_NAME'];
				echo "</a></td>\r\n    <td>";
				echo $rsrow['CPTL_VAL'];
				echo "</td>\r\n    <td>";
				echo $rsrow['CPTL_BAL'];
				echo "</td>\r\n    <td>";
				echo $rsrow['CREATE_DATE'];
				echo "</td>\r\n    <td>";
				echo $rsrow['SUM_DPCT'];
				echo "</td>\r\n    <td>上次折旧时间";
				echo $PEPRE_DATE;
				echo "</td>\r\n  </tr>\r\n ";
			}
		}
	}
}
$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
		{
			++$total_depreciation;
			if ( $tdCss == "TableLine1" )
			{
				$tdCss = "TableLine2";
			}
			else
			{
				$tdCss = "TableLine1";
			}
			echo " \r\n  \r\n  <tr class='";
			echo $tdCss;
			echo "'>\r\n    <td>";
			echo $ROW['CPTL_NO'];
			echo "</td>\r\n    <td><a href=\"javascript:cptl_detail('";
			echo $CPTL_ID;
			echo "');\">";
			echo $ROW['CPTL_NAME'];
			echo "</a></td>\r\n    <td>";
			echo $ROW['CPTL_VAL'];
			echo "</td>\r\n    <td>";
			echo $ROW['CPTL_BAL'];
			echo "</td>\r\n    <td>";
			echo $ROW['CREATE_DATE'];
			echo "</td>\r\n    <td>";
			echo $ROW['SUM_DPCT'];
			echo "</td>\r\n    <td>从未折旧</td>\r\n ";
		}
	}
}
echo " \r\n \r\n  </tr>\r\n  <tr bgcolor=\"#FFFFFF\" >\r\n    <td colspan=\"7\" align=\"right\">折旧资产总计:";
echo $total_depreciation;
echo "    </td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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