📄 add.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.

💻 PHP

字号:

<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>

<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");
?>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -