📄 add.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?
include_once("inc/auth.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">
<?
if($OP=="2")
{
	$query="delete ORDER_LINE,SALE_HISTORY from ORDER_LINE a
        LEFT OUTER JOIN SALE_HISTORY b ON a.LINE_ID =b.LINE_ID
        where a.LINE_ID='$LINE_ID'";
  exequery($connection,$query);
?>
<script>
location="index.php?ORDER_ID=<?=$ORDER_ID?>";
</script>
<?
}
if($OP=="1")
{
  if($ORDER_ID=="")
  {
   $query="select * from SUPPLY_ORDER  where ORDER_NO='$ORDER_NO'";
   $cursor= exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
  {
  Message("错误","订单 ".$ORDER_NO." 已存在");
?>
 <br>
 <div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='index.php'">
 </div>
<?
   exit;
  }
   $query="INSERT into SUPPLY_ORDER (ORDER_NO,ORDER_NAME,ORDER_TYPE,ORDER_MEMO,PROVIDER_ID,LINKMAN_ID,CREATOR,RECIVER,CREATE_DATE,BEGIN_DATE,ORDER_PRINT,REMARK) values
                                    ('$ORDER_NO','$ORDER_NAME','$ORDER_TYPE','$ORDER_MEMO','$PROVIDER_ID','$LINKMAN_ID','$CREATOR','$TO_ID','$CREATE_DATE','$BEGIN_DATE','$ORDER_PRINT','$REMARK')";
   exequery($connection,$query);
   $ORDER_ID=mysql_insert_id();
   save_field_data("SUPPLY_ORDER",$ORDER_ID,$_POST);
  }
  else
  {
 	 $query="update SUPPLY_ORDER set ORDER_NO='$ORDER_NO',ORDER_NAME='$ORDER_NAME',ORDER_TYPE='$ORDER_TYPE',ORDER_MEMO='$ORDER_MEMO',PROVIDER_ID='$PROVIDER_ID',LINKMAN_ID='$LINKMAN_ID',CREATOR='$CREATOR',RECIVER='$TO_ID',CREATE_DATE='$CREATE_DATE',BEGIN_DATE='$BEGIN_DATE',ORDER_PRINT='$ORDER_PRINT',REMARK='$REMARK' where ORDER_ID='$ORDER_ID'";
   exequery($connection,$query);
   save_field_data("SUPPLY_ORDER",$ORDER_ID,$_POST);
  }

  if($LINE_ID=="")
  {
 	  $query="INSERT into ORDER_LINE (ORDER_ID,PRODUCT_ID,TRANS_PRICE,TRANS_QTY,MEMO)
            values('$ORDER_ID','$PRO_ID','$PRICE','$TRANS_QTY','$MEMO')";
    exequery($connection,$query);
    //echo  $query;
    $LINE_ID=mysql_insert_id();
    $query="INSERT into SUPPLY_HISTORY (PROVIDER_ID,PRODUCT_ID,DATE,AMT,PRICE,SALESMAN,ORDER_ID,LINE_ID,MEMO)
            values('$PROVIDER_ID','$PRO_ID','$CREATE_DATE','$TRANS_QTY','$PRICE','$LOGIN_USER_ID','$ORDER_ID','$LINE_ID','$MEMO')";
    exequery($connection,$query);
    //---------订单明细保存----------
    $query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='$ORDER_ID' and  LINE_ID!='$LINE_ID'";
    $cursor= exequery($connection,$query);
    while($ROW=mysql_fetch_array($cursor))
   {
  	$LINE_ID=$ROW["LINE_ID"];
    $PRICE=$LINE_ID."PRICE";
  	$TRANS_QTY=$LINE_ID."TRANS_QTY";
  	$MEMO=$LINE_ID."MEMO";
  	$PRICE=$$PRICE;
  	$TRANS_QTY=$$TRANS_QTY;
  	$MEMO=$$MEMO;
  	$query="update ORDER_LINE set TRANS_PRICE='$PRICE',TRANS_QTY='$TRANS_QTY',MEMO='$MEMO' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
    $query="update SUPPLY_HISTORY set DATE='$CREATE_DATE',AMT='$TRANS_QTY',PRICE='$PRICE',SALESMAN='$LOGIN_USER_ID' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
   }

  }
  else
  {
  	//---------订单明细保存----------
    $query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='$ORDER_ID' ";
    $cursor= exequery($connection,$query);
    while($ROW=mysql_fetch_array($cursor))
   {
  	$LINE_ID=$ROW["LINE_ID"];
    $PRICE=$LINE_ID."PRICE";
  	$TRANS_QTY=$LINE_ID."TRANS_QTY";
  	$MEMO=$LINE_ID."MEMO";
  	$PRICE=$$PRICE;
  	$TRANS_QTY=$$TRANS_QTY;
  	$MEMO=$$MEMO;
  	$query="update ORDER_LINE set TRANS_PRICE='$PRICE',TRANS_QTY='$TRANS_QTY',MEMO='$MEMO' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
    $query="update SUPPLY_HISTORY set DATE='$CREATE_DATE',AMT='$TRANS_QTY',PRICE='$PRICE',SALESMAN='$LOGIN_USER_ID' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
    }
  }
?>
<script>
location="index.php?ORDER_ID=<?=$ORDER_ID?>";
</script>
<?
}
else
{
	if($ORDER_ID=="")
  {
   $query="INSERT into SUPPLY_ORDER (ORDER_NO,ORDER_NAME,ORDER_TYPE,ORDER_MEMO,PROVIDER_ID,LINKMAN_ID,CREATOR,RECIVER,CREATE_DATE,BEGIN_DATE,ORDER_PRINT,REMARK) values
                                    ('$ORDER_NO','$ORDER_NAME','$ORDER_TYPE','$ORDER_MEMO','$PROVIDER_ID','$LINKMAN_ID','$CREATOR','$TO_ID','$CREATE_DATE','$BEGIN_DATE','$ORDER_PRINT','$REMARK')";
   exequery($connection,$query);
   $ORDER_ID=mysql_insert_id();
   save_field_data("SUPPLY_ORDER",$ORDER_ID,$_POST);
  }
  else
  {
 	 $query="update SUPPLY_ORDER set ORDER_NO='$ORDER_NO',ORDER_NAME='$ORDER_NAME',ORDER_TYPE='$ORDER_TYPE',ORDER_MEMO='$ORDER_MEMO',PROVIDER_ID='$PROVIDER_ID',LINKMAN_ID='$LINKMAN_ID',CREATOR='$CREATOR',RECIVER='$TO_ID',CREATE_DATE='$CREATE_DATE',BEGIN_DATE='$BEGIN_DATE',ORDER_PRINT='$ORDER_PRINT',REMARK='$REMARK' where ORDER_ID='$ORDER_ID'";
   exequery($connection,$query);
   save_field_data("SUPPLY_ORDER",$ORDER_ID,$_POST);
  }
  //---------订单明细保存----------
  $query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='$ORDER_ID' ";
  $cursor= exequery($connection,$query);
  while($ROW=mysql_fetch_array($cursor))
  {
  	$LINE_ID=$ROW["LINE_ID"];
    $PRICE=$LINE_ID."PRICE";
  	$TRANS_QTY=$LINE_ID."TRANS_QTY";
  	$MEMO=$LINE_ID."MEMO";
  	$PRICE=$$PRICE;
  	$TRANS_QTY=$$TRANS_QTY;
  	$MEMO=$$MEMO;
  	$query="update ORDER_LINE set TRANS_PRICE='$PRICE',TRANS_QTY='$TRANS_QTY',MEMO='$MEMO' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
    $query="update SUPPLY_HISTORY set DATE='$CREATE_DATE',AMT='$TRANS_QTY',PRICE='$PRICE',SALESMAN='$LOGIN_USER_ID' where LINE_ID='$LINE_ID'";
    exequery($connection,$query);
  }
  Message("提示"," ".$ORDER_NAME." 添加成功！！");
}
?>
<br>
<div align="center">
 <input type="button" value="转至订单管理页面" class="BigButton" onClick="location='../manage/index.php'">
</div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -