add.php

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

PHP

68 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>保存办公用品管理记录保存</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  if (($TRANS_ID != ''))
  {
    $query = (((''.'select TRANS_QTY from OFFICE_TRANSHISTORY where TRANS_ID=\'').$TRANS_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $MOD_STOCK = ($ROW['TRANS_QTY'] * -1);
    }
  }
  if (((($TRANS_FLAG == '1') OR ($TRANS_FLAG == '2')) OR ($TRANS_FLAG == '4')))
  {
    $TRANS_QTY = ($TRANS_QTY * -1);
  }
  $TRANS_DATE = date ('Y-m-d', time ());
  if (($TRANS_ID == ''))
  {
    $query = (((((((((((((((((''.'insert into OFFICE_TRANSHISTORY (PRO_ID,BORROWER,TRANS_FLAG,TRANS_QTY,PRICE,REMARK,TRANS_DATE,OPERATOR) values (\'').$PRO_ID).'\',\'').$TO_ID).'\',\'').$TRANS_FLAG).'\',\'').$TRANS_QTY).'\',\'').$PRICE).'\',\'').$REMARK).'\',\'').$TRANS_DATE).'\',\'').$LOGIN_USER_ID).'\')');
  }
  else
  {
    $query = ((((((((((((((((((''.'update OFFICE_TRANSHISTORY set PRO_ID=\'').$PRO_ID).'\',BORROWER=\'').$TO_ID).'\',TRANS_FLAG=\'').$TRANS_FLAG).'\',TRANS_QTY=\'').$TRANS_QTY).'\',PRICE=\'').$PRICE).'\',REMARK=\'').$REMARK).'\',TRANS_DATE=\'').$TRANS_DATE).'\',OPERATOR=\'').$LOGIN_USER_ID).'\' where TRANS_ID=').$TRANS_ID);
  }
  exequery ($connection, $query);
  message ('', '管理记录保存成功！！');
  $query = (((''.'SELECT sum( TRANS_QTY * PRICE ) / sum( TRANS_QTY ) AS PRICE
        FROM `OFFICE_TRANSHISTORY`
        WHERE `TRANS_FLAG` = \'0\'
        AND `PRO_ID` = \'').$PRO_ID).'\'
        GROUP BY PRO_ID');
  $cursor1 = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $PRO_PRICE = round ($ROW['PRICE'], 2);
  }
  $query = (((''.'select PRO_STOCK from OFFICE_PRODUCTS where PRO_ID=\'').$PRO_ID).'\'');
  $cursor1 = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $PRO_STOCK = $ROW['PRO_STOCK'];
  }
  if (($TRANS_ID != ''))
  {
    $PRO_STOCK = (($PRO_STOCK + $TRANS_QTY) + $MOD_STOCK);
  }
  else
  {
    $PRO_STOCK = ($PRO_STOCK + $TRANS_QTY);
  }
  $query = (((((((''.'update OFFICE_PRODUCTS set PRO_STOCK=\'').$PRO_STOCK).'\',PRO_PRICE=\'').$PRO_PRICE).'\' where PRO_ID=\'').$PRO_ID).'\'');
  exequery ($connection, $query);
  header ('location:record.php');
  echo '</body>
</html>
';
?>

add.php - 源码说明

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

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

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?