dept_sum.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 188 行

<?
  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
            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'];
      $TRANS_DATE = $ROW['TRANS_DATE'];
      $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>').$TRANS_DATE).'</td>  
    <td>').$Price).'</td>  
    <td>').$TOTAL_PRICE).'</td>
   '));
    }
    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'))
      {
        continue;
      }
      else
      {
        $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)
                 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 nowrap valign="bottom">
           <table style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=2 bordercolor=\'#000000\' class=small cellpadding=3 align=left>
           <tr bgcolor=\'#D3E5FA\'>
              <td nowrap align=center><b>领用人</b></td>
  	          <td nowrap align=center><b>办公用品ID</b></td>
              <td nowrap align=center><b>办公用品名称</b></td>
              <td nowrap align=center><b>领用总量</b></td>
              <td nowrap align=center><b>领用日期</b></td>
              <td nowrap align=center><b>单价</b></td>
              <td nowrap align=center><b>总价</b></td>
            </tr>').dept_sum_list ($DEPT_ID, $WHERE_STR)).'
           </table>合计：').$TOTAL_SUM).'
         </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);
          continue;
        }
        continue;
      }
    }
    $DEEP_COUNT = $DEEP_COUNT1;
    return $OPTION_TEXT;
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>部门领用汇总</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'tyle>
.menulines{}
</style>
</head>
<body topmargin="1" leftmargin="0">
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big5">&nbsp;&nbsp;部门领用汇总</span><br>
    </td>
    <td align="right">
     <input type="button" class="SmallButton" value="关闭" onclick="window.close();">&nbsp;&nbsp;<input type="button" class="SmallButton" value="打印" onclick="window.print();">
   </td>
  </tr>
</table>
<br>
';
  $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:location=\'dept_list.php?PRIV_OP=';
    echo $PRIV_OP;
    echo '\';"></div>
';
  }
  else
  {
    echo ' <table style=\'border-collapse:collapse\' border=1  bordercolor=#000000 cellspacing="0" width="95%" class="small" cellpadding="3"  align="center">
  ';
    echo $OPTION_TEXT;
    echo '
</table>
';
  }
  echo '</body>
</html>
';
?>