📄 report.php
字号:
<?php
function dept_tree_list( $DEPT_ID )
{
global $DEEP_COUNT;
global $TOTAL_SUM;
global $connection;
$query = "SELECT * from DEPARTMENT where DEPT_PARENT=".$DEPT_ID;
$cursor = exequery( $connection, $query );
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$DEPT_PARENT = $ROW['DEPT_PARENT'];
if ( !( is_dept_priv( $DEPT_ID ) != "1" ) )
{
$DEPT_NAME = htmlspecialchars( $DEPT_NAME );
$DEPT_NAME = stripslashes( $DEPT_NAME );
$OPTION_TEXT_CHILD = dept_tree_list( $DEPT_ID );
$query1 = "SELECT CPTL_VAL,SUM_DPCT\r\n FROM `DEPARTMENT` a\r\n LEFT OUTER JOIN `CP_CPTL_INFO` b ON a.DEPT_ID = b.DEPT_ID\r\n WHERE a.DEPT_ID ='".$DEPT_ID."'";
$cursor1 = exequery( $connection, $query1 );
$TOTAL_CPTL_VAL = 0;
$TOTAL_SUM_DPCT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SUM_DPCT = $ROW['SUM_DPCT'];
$CPTL_VAL = $ROW['CPTL_VAL'];
$TOTAL_SUM_DPCT += $SUM_DPCT;
$TOTAL_CPTL_VAL += $CPTL_VAL;
}
$OPTION_TEXT .= "\r\n <tr class=TableData>\r\n <td>".$DEEP_COUNT1."├".$DEPT_NAME."</a></td>\r\n <td nowrap valign=\"bottom\">".$TOTAL_CPTL_VAL."</td>\r\n <td nowrap valign=\"bottom\">".$TOTAL_SUM_DPCT."</td>\r\n </tr>";
if ( $OPTION_TEXT_CHILD != "" )
{
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_org.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\r\n</head>\r\n\r\n<body topmargin=\"1\" leftmargin=\"0\">\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/asset.gif\" align=\"absmiddle\"><span class=\"big5\"> 资产报表</span><br>\r\n </td>\r\n <td align=\"right\">\r\n <input type=\"button\" class=\"SmallButton\" value=\"关闭\" onclick=\"window.close();\"> <input type=\"button\" class=\"SmallButton\" value=\"打印\" onclick=\"window.print();\">\r\n </td>\r\n </tr>\r\n</table>\r\n<table class=\"TableList\" width=\"95%\" align=\"center\">\r\n <tr class=TableHeader align=center>\r\n <td width=\"30%\">部门</td>\r\n <td nowrap valign=\"bottom\">总资产原值</td>\r\n <td nowrap valign=\"bottom\">总累计折旧</td>\r\n </tr>\r\n";
if ( $DEPT_ID == "" )
{
$DEPT_ID = 0;
}
echo $OPTION_TEXT = dept_tree_list( $DEPT_ID );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -