dept_sum.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

function dept_sum_list( $DEPT_ID, $WHERE_STR )
{
	global $TOTAL_SUM;
	global $connection;
	$query = "SELECT b.USER_NAME as BORROWER, d.PRO_ID as PRO_ID,d.PRO_NAME as PRO_NAME,d.PRO_UNIT as PRO_UNIT ,SUM(c.TRANS_QTY) AS QTY, c.TRANS_DATE as TRANS_DATE ,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            AND (c.TRANS_STATE='' or c.TRANS_STATE='1') GROUP BY b.DEPT_ID,BORROWER,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'];
		$TRANS_DATE = $ROW['TRANS_DATE'];
		$BORROWER = $ROW['BORROWER'];
		$TOTAL_SUM += $TOTAL_PRICE;
		$SUM_TEXT .= "\r\n  <tr class=TableData>\r\n    <td>".$BORROWER."</td>\r\n    <td>".$PRO_ID."</td>\r\n    <td>".$PRO_NAME."</td>\r\n    <td>".$QTY.$UNIT."</td>\r\n    <td>".$TRANS_DATE."</td>\r\n    <td>".$Price."</td>\r\n    <td>".$TOTAL_PRICE."</td>\r\n   ";
	}
	return $SUM_TEXT;
}

function dept_tree_list( $DEPT_ID, $PRIV_OP, $WHERE_STR )
{
	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 = 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 nowrap valign=\"bottom\">\r\n           <table style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=2 bordercolor='#000000' class=small cellpadding=3 align=left>\r\n           <tr bgcolor='#D3E5FA'>\r\n              <td nowrap align=center><b>领用人</b></td>\r\n  \t          <td nowrap align=center><b>办公用品ID</b></td>\r\n              <td nowrap align=center><b>办公用品名称</b></td>\r\n              <td nowrap align=center><b>领用总量</b></td>\r\n              <td nowrap align=center><b>领用日期</b></td>\r\n              <td nowrap align=center><b>单价</b></td>\r\n              <td nowrap align=center><b>总价</b></td>\r\n            </tr>".dept_sum_list( $DEPT_ID, $WHERE_STR )."\r\n           </table>合计：".$TOTAL_SUM."\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_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<style>\r\n.menulines{}\r\n</style>\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/notify_open.gif\" align=\"absmiddle\"><span class=\"big5\">&nbsp;&nbsp;部门领用汇总</span><br>\r\n    </td>\r\n    <td align=\"right\">\r\n     <input type=\"button\" class=\"SmallButton\" value=\"关闭\" onClick=\"window.close();\">&nbsp;&nbsp;<input type=\"button\" class=\"SmallButton\" value=\"打印\" onClick=\"window.print();\">\r\n   </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
$TOTAL_SUM = 0;
if ( $FROM_DATE != "" )
{
	$WHERE_STR .= " and c.TRANS_DATE>='".$FROM_DATE."'";
}
if ( $TO_DATE != "" )
{
	$WHERE_STR .= " and c.TRANS_DATE<='".$TO_DATE."'";
}
if ( $PRO_ID != "" )
{
	$WHERE_STR .= " and c.PRO_ID='".$PRO_ID."'";
}
if ( $OFFICE_PROTYPE != "" )
{
	$WHERE_STR .= " and d.OFFICE_PROTYPE='".$OFFICE_PROTYPE."'";
}
if ( $DEPT_ID == "" )
{
	$DEPT_ID = 0;
}
$OPTION_TEXT = dept_tree_list( $DEPT_ID, 1, $WHERE_STR );
if ( $OPTION_TEXT == "" )
{
	message( "提示", "未定义或无可管理部门" );
	echo "   <div align=\"center\"><input type=\"button\" class=\"BigButton\" value=\"关闭\" onClick=\"javascript:window.close();\"></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 "</body>\r\n</html>\r\n";
?>