show_return.php

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

PHP

103 行

<?
  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">
</head>
<body  topmargin="5">
 <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/hrms.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big5">&nbsp;归还查看</span><br>
    </tr>
 </table>
 <br>
 <div align="center">
    <table border="0" cellspacing="1" width="60%" class="small" bgcolor="#000000" cellpadding="3">
           <tr class="TableHeader">
  	          <td nowrap align="center">办公用品ID</td>
              <td nowrap align="center">办公用品名称</td>
              <td nowrap align="center">归还数量</td>
           ';
  echo '   <td nowrap align="center">归还人</td>
              <td nowrap align="center">归还部门</td>
              <td nowrap align="center">操作员</td>
              <td nowrap align="center">归还日期</td>
           </tr>
';
  $query1 = (((((((''.'SELECT a.PRO_ID, b.PRO_NAME ,a.TRANS_QTY ,b.PRO_UNIT,a.TRANS_DATE,a.OPERATOR,a.BORROWER  FROM `OFFICE_TRANSHISTORY` a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID LEFT OUTER JOIN USER c ON `BORROWER`= c.USER_ID LEFT OUTER JOIN DEPARTMENT d ON d.DEPT_ID = c.DEPT_ID where a.PRO_ID=\'').$PRO_ID).'\' and  a.TRANS_FLAG= \'3\' and TRANS_DATE>=\'').$DATE).'\' and c.DEPT_ID=\'').$DEP_ID).'\'');
  $cursor1 = exequery ($connection, $query1);
  $DETAIL_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$DETAIL_COUNT;
    $DETAIL_PROID = $ROW['PRO_ID'];
    $DETAIL_PRONAME = $ROW['PRO_NAME'];
    $DETAIL_TRANSQTY = $ROW['TRANS_QTY'];
    $DETAIL_PROUNIT = $ROW['PRO_UNIT'];
    $DETAIL_PRICE = $ROW['PRICE'];
    $DETAIL_USER = $ROW['OPERATOR'];
    $DETAIL_BORROWER = $ROW['BORROWER'];
    $DETAIL_DATE = $ROW['TRANS_DATE'];
    $TOK = strtok ($DETAIL_USER, ',');
    $query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
    $cursor2 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor2))
    {
      $DETAIL_USERNAME = $ROW['USER_NAME'];
    }
    $TOK = strtok ($DETAIL_BORROWER, ',');
    $query1 = (((''.'SELECT `USER_ID` , `USER_NAME` , PRIV_NAME, DEPT_NAME,a.DEPT_ID as DEPT_ID FROM `USER` a LEFT OUTER JOIN DEPARTMENT b ON a.DEPT_ID = b.DEPT_ID LEFT OUTER JOIN USER_PRIV c ON a.USER_PRIV = c.USER_PRIV where a.USER_ID=\'').$TOK).'\'');
    $cursor2 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor2))
    {
      $DETAIL_BORROWERNAME = $ROW['USER_NAME'];
      $DETAIL_BORROWERDEPT = $ROW['DEPT_NAME'];
      $DETAIL_BORROWERDEPTID = $ROW['DEPT_ID'];
    }
    if ((($DETAIL_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '           <tr class="TableData">
           <td nowrap align="center">';
    echo $DETAIL_PROID;
    echo '</td>
           <td align="center">';
    echo $DETAIL_PRONAME;
    echo '</td>
           <td nowrap align="center">';
    echo $DETAIL_TRANSQTY;
    echo $DETAIL_PROUNIT;
    echo '</td>
           <td nowrap align="center">';
    echo $DETAIL_BORROWERNAME;
    echo '</td>
           <td nowrap align="center">';
    echo $DETAIL_BORROWERDEPT;
    echo '</td>
           <td nowrap align="center">';
    echo $DETAIL_USERNAME;
    echo '</td>
           <td nowrap align="center">';
    echo $DETAIL_DATE;
    echo '</td>
           </tr>
';
  }
  echo '       </table>
   <br>
   <input type="button" class="BigButton" value="关闭" onclick="window.close();">
</div>
</body>
</html>';
?>

show_return.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 show_return.php 源码文件，采用 PHP 编程语言编写，共 103 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?