record.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 686 行 · 第 1/2 页

  if (((($TRANS_FLAG == '1') OR ($TRANS_FLAG == '2')) OR ($TRANS_FLAG == '3')))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>
      <td nowrap id="t1" class="TableData" style=';
  if (($TRANS_FLAG == '1'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>领用人：</td>
      <td nowrap id="t2" class="TableData" style=';
  if (($TRANS_FLAG == '2'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>借用人：</td>
      <td nowrap id="t3" class="TableData" style=';
  if (($TRANS_FLAG == '3'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>归还人：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID" value="';
  echo $BORROWER;
  echo '">
        <input type="text" name="TO_NAME" size="20" class="BigStatic" maxlength="20"  value="';
  echo $BORROWER_NAME;
  echo '" readonly>
        &nbsp;<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
        &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_dept1()" title="清空" name="button">
      </td>
    </tr>
   <tr id="COST" style=';
  if (($TRANS_FLAG == '0'))
  {
    echo '';
  }
  else
  {
    echo 'display:none';
  }
  echo '>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
';
  if (($PRICE == ''))
  {
    echo '      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
';
  }
  else
  {
    echo '        <input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="';
    echo $PRICE;
    echo '">
';
  }
  echo '      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">办公用品类别：</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="OFFICE_PROTYPE" class="BigSelect" onChange="getProduct()">
           <option value="-1">请选择类别</option>
';
  $query = 'SELECT CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO=\'OFFICE_PROTYPE\' order by CODE_NAME';
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $CODENAME = $ROW['CODE_NAME'];
    $CODENO = $ROW['CODE_NO'];
    echo '               <option value="';
    echo $CODE_NO;
    echo '" ';
    if (($CODENO == $OFFICE_PROTYPE))
    {
      echo 'selected';
    }
    echo '>';
    echo $CODENAME;
    echo '</option>
';
  }
  echo '         </select>
       </td>
      </tr>
  	<tr>
      <td nowrap class="TableData">办公用品：</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="PRO_ID" class="BigSelect">
           <option value="-1">---请选择---</option>
';
  $query = (((((''.'SELECT * from OFFICE_PRODUCTS where PRO_MANAGER=\'').$LOGIN_USER_ID).'\' or PRO_MANAGER=\'\' or PRO_DEPT=\'\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',PRO_DEPT)');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $PROID = $ROW['PRO_ID'];
    $PRONAME = $ROW['PRO_NAME'];
    $PROSTOCK = $ROW['PRO_STOCK'];
    $PROUNIT = $ROW['PRO_UNIT'];
    echo '               <option value="';
    echo $PROID;
    echo '" ';
    if (($PROID == $PRO_ID))
    {
      echo 'selected';
    }
    echo '>';
    echo $PRONAME;
    echo '/库存';
    echo $PROSTOCK;
    echo $PROUNIT;
    echo '</option>
';
  }
  echo '         </select>
       </td>
      </tr>
   <tr>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="';
  echo $TRANS_QTY;
  echo '">
      </td>
    </tr>
     <tr>
      <td nowrap class="TableData">备注：</td>
      <td class="TableData">
        <textarea name="REMARK" cols="45" rows="5" class="BigInput">';
  echo $REMARK;
  echo '</textarea>
      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" name="TRANS_ID" value="';
  echo $TRANS_ID;
  echo '">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
';
  if (($TRANS_ID != ''))
  {
    echo '        <input type="button" value="取消" class="BigButton" onclick="location=\'record.php\'">
';
  }
  echo '      </td>
    </tr>
  </table>
</form>
';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((((''.'SELECT * from OFFICE_TRANSHISTORY where OPERATOR=\'').$LOGIN_USER_ID).'\' and TRANS_DATE=\'').$CUR_DATE).'\' order by TRANS_ID desc');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $TRANS_ID = $ROW['TRANS_ID'];
    $PRO_ID = $ROW['PRO_ID'];
    $BORROWER = $ROW['BORROWER'];
    $TRANS_FLAG = $ROW['TRANS_FLAG'];
    $TRANS_QTY = $ROW['TRANS_QTY'];
    $PRICE = $ROW['PRICE'];
    $TRANS_DATE = $ROW['TRANS_DATE'];
    $OPERATOR = $ROW['OPERATOR'];
    $query1 = (((''.'select PRO_NAME,PRO_STOCK,PRO_PRICE from OFFICE_PRODUCTS where PRO_ID=\'').$PRO_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $PRO_NAME = $ROW['PRO_NAME'];
      $PRO_STOCK = $ROW['PRO_STOCK'];
      $PRO_PRICE = $ROW['PRO_PRICE'];
    }
    $query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $OPERATOR_NAME = $ROW['USER_NAME'];
    }
    if (($TRANS_FLAG == '0'))
    {
      $TRANS_NAME = '采购入库';
      $BORROWER_NAME = '';
    }
    if (($TRANS_FLAG == '1'))
    {
      $TRANS_QTY = ($TRANS_QTY * -1);
      $TRANS_NAME = '领用';
      $TOK = strtok ($BORROWER, ',');
      $query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $BORROWER_NAME = $ROW['USER_NAME'];
      }
      $PRICE = $PRO_PRICE;
    }
    if (($TRANS_FLAG == '2'))
    {
      $TRANS_QTY = ($TRANS_QTY * -1);
      $TRANS_NAME = '借用';
      $TOK = strtok ($BORROWER, ',');
      $query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $BORROWER_NAME = $ROW['USER_NAME'];
      }
      $PRICE = $PRO_PRICE;
    }
    if (($TRANS_FLAG == '3'))
    {
      $TRANS_NAME = '归还';
      $TOK = strtok ($BORROWER, ',');
      $query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $BORROWER_NAME = $ROW['USER_NAME'];
      }
      $PRICE = $PRO_PRICE;
    }
    if (($TRANS_FLAG == '4'))
    {
      $TRANS_QTY = ($TRANS_QTY * -1);
      $TRANS_NAME = '报废';
      $BORROWER_NAME = '';
      $PRICE = $PRO_PRICE;
    }
    if (($VOTE_COUNT == 1))
    {
      echo '     <table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
       <tr>
        <td background="/images/dian1.gif" width="100%"></td>
       </tr>
     </table>
     <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
       <tr>
       <td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
      echo '<s';
      echo 'pan class="big3">&nbsp;今日操作查看</span>
       </td>
      </tr>
     </table>
     <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
       <tr class="TableHeader">
    	  <td nowrap align="center">办公用品名称</td>
        <td nowrap align="center">登记类型</td>
        <td nowrap align="center">领用/借用/归还人</td>
        <td nowrap align="center"';
      echo '>数量</td>
        <td nowrap align="center">当前库存</td>
        <td nowrap align="center">单价</td>
        <td nowrap align="center">操作日期</td>
        <td nowrap align="center">操作员</td>
        <td nowrap align="center">操作</td>
      </tr>
';
    }
    if ((($VOTE_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $PRO_NAME;
    echo '</td>
      <td align="center">';
    echo $TRANS_NAME;
    echo '</td>
      <td align="center">';
    echo $BORROWER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $TRANS_QTY;
    echo '</td>
      <td nowrap align="center">';
    echo $PRO_STOCK;
    echo '</td>
      <td nowrap align="center">';
    echo $PRICE;
    echo '</td>
      <td nowrap align="center">';
    echo $TRANS_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $OPERATOR_NAME;
    echo '</td>
      <td nowrap align="center">&nbsp;
      <a href="record.php?TRANS_ID=';
    echo $TRANS_ID;
    echo '">修改</a>
      &nbsp;
      <a href="javascript:delete_vote(\'';
    echo $TRANS_ID;
    echo '\');"> 放弃操作</a>
      </td>
    </tr>
';
  }
  if ((0 < $VOTE_COUNT))
  {
    echo '</table>
';
  }
  echo '</body>
</html>
';
?>