📄 dept_sum.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码
💻 PHP
字号:
<?php

function dept_sum_list( $DEPT_ID, $WHERE_STR )
{
	$connection = openconnection( );
	$query = "SELECT  d.PRO_ID as PRO_ID,d.PRO_NAME as PRO_NAME,d.PRO_UNIT as PRO_UNIT ,SUM(c.TRANS_QTY) AS QTY, d.PRO_PRICE as Price,SUM(c.TRANS_QTY*d.PRO_PRICE*(-1)) AS TOTAL_PRICE\r\n            FROM `DEPARTMENT` a\r\n            LEFT OUTER JOIN `USER` b ON a.DEPT_ID = b.DEPT_ID\r\n            LEFT OUTER JOIN OFFICE_TRANSHISTORY c ON `BORROWER`= b.USER_ID\r\n            LEFT OUTER JOIN OFFICE_PRODUCTS d ON d.PRO_ID = c.PRO_ID\r\n            where b.DEPT_ID='{$DEPT_ID}' AND c.TRANS_FLAG='1'".$WHERE_STR."\r\n            GROUP BY b.DEPT_ID, c.PRO_ID";
	$cursor = exequery( $connection, $query );
	$SUM_TEXT = "";
	$TOTAL_SUM = 0;
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRO_ID = $ROW['PRO_ID'];
		$PRO_NAME = $ROW['PRO_NAME'];
		$QTY = $ROW['QTY'] * -1;
		$Price = $ROW['Price'];
		$TOTAL_PRICE = $ROW['TOTAL_PRICE'];
		$UNIT = $ROW['PRO_UNIT'];
		$TOTAL_SUM = $TOTAL_SUM + $TOTAL_PRICE;
		$SUM_TEXT .= "\r\n  <tr class=TableData>\r\n    <td>".$PRO_ID."</td>\r\n    <td>".$PRO_NAME."</td>\r\n    <td>".$QTY.$UNIT."</td>\r\n    <td>".$Price."</td>\r\n    <td>".$TOTAL_PRICE."</td>\r\n   ";
	}
	$SUM_TEXT .= "\r\n  </tr>\r\n    <tr class=TableData>\r\n    <td  colspan=5 align=right>总计：".$TOTAL_SUM."&nbsp;&nbsp;</td>\r\n  </tr>";
	return $SUM_TEXT;
}

function dept_tree_list( $DEPT_ID, $PRIV_OP, $WHERE_STR )
{
	global $DEEP_COUNT;
	$connection = openconnection( );
	$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'];
		$DEPT_NAME = str_replace( "<", "&lt", $DEPT_NAME );
		$DEPT_NAME = str_replace( ">", "&gt", $DEPT_NAME );
		$DEPT_NAME = stripslashes( $DEPT_NAME );
		$OPTION_TEXT_CHILD = dept_tree_list( $DEPT_ID, $PRIV_OP, $WHERE_STR );
		$query1 = "SELECT count(distinct c.PRO_ID)\r\n                 FROM `DEPARTMENT` a\r\n                 LEFT OUTER JOIN `USER` b ON a.DEPT_ID = b.DEPT_ID\r\n                 LEFT OUTER JOIN OFFICE_TRANSHISTORY c ON `BORROWER`= b.USER_ID\r\n                 LEFT OUTER JOIN OFFICE_PRODUCTS d ON d.PRO_ID = c.PRO_ID  WHERE a.DEPT_ID ='{$DEPT_ID}' and c.TRANS_FLAG='1'".$WHERE_STR;
		$cursor1 = exequery( $connection, $query1 );
		$VOTE_COUNT = 0;
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$VOTE_COUNT = $ROW[0];
		}
		if ( $VOTE_COUNT != 0 )
		{
			$OPTION_TEXT .= "\r\n       <tr class=TableData>\r\n         <td>".$DEEP_COUNT1."├".$DEPT_NAME."</a></td>\r\n         <td>\r\n           <table style='border-collapse:collapse' bordercolor=#000000 border=1 width=60%  cellspacing=0 class=small cellpadding=3 align=left>\r\n           <tr class=TableHeader>\r\n  \t          <td nowrap align=center>办公用品ID</td>\r\n              <td nowrap align=center>办公用品名称</td>\r\n              <td nowrap align=center>领用总量</td>\r\n              <td nowrap align=center>单价</td>\r\n              <td nowrap align=center>总价</td>\r\n            </tr>".dept_sum_list( $DEPT_ID, $WHERE_STR )."\r\n           </table>\r\n         </td>\r\n      </tr>";
		}
		else
		{
			$OPTION_TEXT .= "\r\n       <tr class=TableData>\r\n         <td>".$DEEP_COUNT1."├".$DEPT_NAME."</a></td>\r\n         <td>\r\n         </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_all.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";
echo "<s";
echo "tyle>\r\n.menulines{}\r\n</style>\r\n\r\n</head>\r\n\r\n<body topmargin=\"1\" leftmargin=\"0\" class=\"bodycolor\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/notify_open.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\">&nbsp;&nbsp;部门领用汇总</span><br>\r\n    </td>\r\n    <td align=\"right\">\r\n\r\n     <input type=\"button\" class=\"SmallButton\" value=\"关闭\" onclick=\"window.close();\">\r\n\r\n   </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
if ( $PRO_ID != " " && $PRO_ID != "" )
{
	$WHERE_STR .= " and c.PRO_ID='{$PRO_ID} '";
}
if ( $PRO_NAME != " " && $PRO_NAME != "" )
{
	$WHERE_STR .= " and d.PRO_NAME like '%".$PRO_NAME."%'";
}
if ( $FROM_DATE != " " && $FROM_DATE != "" )
{
	$WHERE_STR .= " and c.TRANS_DATE>='{$FROM_DATE}'";
}
if ( $TO_DATE != " " && $TO_DATE != "" )
{
	$WHERE_STR .= " and c.TRANS_DATE<='{$TO_DATE}'";
}
if ( $DEPT_ID == "" )
{
	$DEPT_ID = 0;
}
$OPTION_TEXT = dept_tree_list( $DEPT_ID, $PRIV_OP, $WHERE_STR );
if ( $OPTION_TEXT == "" )
{
	message( "提示", "未定义或无可管理部门" );
	echo "   <div align=\"center\"><input type=\"button\" class=\"BigButton\" value=\"返回\" onclick=\"javascript:location='dept_list.php?PRIV_OP=";
	echo $PRIV_OP;
	echo "';\"></div>\r\n";
}
else
{
	echo " <table style='border-collapse:collapse' border=1  bordercolor=#000000 cellspacing=\"0\" width=\"95%\" class=\"small\" cellpadding=\"3\"  align=\"center\">\r\n  ";
	echo $OPTION_TEXT;
	echo "\r\n</table>\r\n";
}
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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