📄 dept_sum.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>部门领用汇总</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
.menulines{}
</style>
</head>
<body topmargin="1" leftmargin="0" class="bodycolor">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 部门领用汇总</span><br>
</td>
<td align="right">
<input type="button" class="SmallButton" value="关闭" onclick="window.close();">
</td>
</tr>
</table>
<br>
<?
//---------合成SQL--------
if($PRO_ID!=" " and $PRO_ID!="")
$WHERE_STR.=" and c.PRO_ID='$PRO_ID '";
if($PRO_NAME!=" " and $PRO_NAME!="")
$WHERE_STR.=" and d.PRO_NAME like '%".$PRO_NAME."%'";
if($FROM_DATE!=" " and $FROM_DATE!="")
$WHERE_STR.=" and c.TRANS_DATE>='$FROM_DATE'";
if($TO_DATE!=" " and $TO_DATE!="")
$WHERE_STR.=" and c.TRANS_DATE<='$TO_DATE'";
if($BORROWER!=" " and $BORROWER!="")
$WHERE_STR.=" and c.BORROWER='$BORROWER'";
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,BORROWER
FROM `DEPARTMENT` a
LEFT OUTER JOIN `USER` b ON a.DEPT_ID = b.DEPT_ID
LEFT OUTER JOIN OFFICE_TRANSHISTORY c ON `BORROWER`= b.USER_ID
LEFT OUTER JOIN OFFICE_PRODUCTS d ON d.PRO_ID = c.PRO_ID
where b.DEPT_ID='$DEPT_ID' AND c.TRANS_FLAG='1'".$WHERE_STR."
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"];
$BORROWER=$ROW["BORROWER"];
$TOTAL_SUM=$TOTAL_SUM+$TOTAL_PRICE;
$SUM_TEXT.="
<tr class=TableData>
<td>".$BORROWER."</td>
<td>".$PRO_ID."</td>
<td>".$PRO_NAME."</td>
<td>".$QTY.$UNIT."</td>
<td>".$Price."</td>
<td>".$TOTAL_PRICE."</td>
";
}//while
$SUM_TEXT.="
</tr>
<tr class=TableData>
<td colspan=6 align=right>总计：".$TOTAL_SUM." </td>
</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("<","<",$DEPT_NAME);
$DEPT_NAME=str_replace(">",">",$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)
FROM `DEPARTMENT` a
LEFT OUTER JOIN `USER` b ON a.DEPT_ID = b.DEPT_ID
LEFT OUTER JOIN OFFICE_TRANSHISTORY c ON `BORROWER`= b.USER_ID
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.="
<tr class=TableData>
<td>".$DEEP_COUNT1."├".$DEPT_NAME."</a></td>
<td>
<table style='border-collapse:collapse' bordercolor=#000000 border=1 width=60% cellspacing=0 class=small cellpadding=3 align=left>
<tr class=TableHeader>
<td nowrap align=center>领用人</td>
<td nowrap align=center>办公用品ID</td>
<td nowrap align=center>办公用品名称</td>
<td nowrap align=center>领用总量</td>
<td nowrap align=center>单价</td>
<td nowrap align=center>总价</td>
</tr>".dept_sum_list($DEPT_ID,$WHERE_STR)."
</table>
</td>
</tr>";
}
else
{
$OPTION_TEXT.="
<tr class=TableData>
<td>".$DEEP_COUNT1."├".$DEPT_NAME."</a></td>
<td>
</td>
</tr>";
}
if($OPTION_TEXT_CHILD!="")
$OPTION_TEXT.=$OPTION_TEXT_CHILD;
}//while
$DEEP_COUNT=$DEEP_COUNT1;
return $OPTION_TEXT;
}
if($DEPT_ID=="")
$DEPT_ID=0;
$OPTION_TEXT=dept_tree_list($DEPT_ID,$PRIV_OP,$WHERE_STR);
if($OPTION_TEXT=="")
{
Message("提示","未定义或无可管理部门");
?>
<div align="center"><input type="button" class="BigButton" value="返回" onclick="javascript:location='dept_list.php?PRIV_OP=<?=$PRIV_OP?>';"></div>
<?
}
else
{
?>
<table style='border-collapse:collapse' border=1 bordercolor=#000000 cellspacing="0" width="95%" class="small" cellpadding="3" align="center">
<?
echo $OPTION_TEXT;
?>
</table>
<?
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -