📄 add.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码

💻 PHP

字号:

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

<html>
<head>
<title>增加合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor">
<?
  $TIME_OK=is_number($TRANS_QTY);

  if(!$TIME_OK || $TRANS_QTY<=0)
  { Message("错误","数量错误");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='edit.php?HISTORY_ID=<?=$HISTORY_ID?>&<?=$QUERY_LIST?>'">
</div>

<?
    exit;
  }
$CUR_TIME=date("Y-m-d H:i:s",time());
if($TYPE=="PRO")$TOTAL_PRICE=$PRICE*$TRANS_QTY;
if($LINE_ID=="")
 {
 	$query="INSERT into HISTORY_LINE (HISTORY_ID,PRODUCT_ID,SERVICE_ID,TRANS_PRICE,TRANS_QTY,TOTAL_PRICE,PAYMENT,MEMO,TYPE)
        values('$HISTORY_ID','$PRO_ID','$SER_ID','$PRICE','$TRANS_QTY','$TOTAL_PRICE','$PAYMENT','$MEMO','$TYPE')";
  }
else
{
	if($LINE_ID=="-1")
		$query="update SALE_HISTORY set PRODUCT_ID='$PRO_ID',SERVICE_ID='$SER_ID',PRICE='$PRICE',AMT='$TRANS_QTY',TOTAL_PRICE='$TOTAL_PRICE',MEMO='$MEMO',TYPE='$TYPE' where HISTORY_ID='$HISTORY_ID'";
	else
		$query="update HISTORY_LINE set PRODUCT_ID='$PRO_ID',SERVICE_ID='$SER_ID',TRANS_PRICE='$PRICE',TRANS_QTY='$TRANS_QTY',TOTAL_PRICE='$TOTAL_PRICE',MEMO='$MEMO',TYPE='$TYPE' where LINE_ID='$LINE_ID'";
}

exequery($connection,$query);

if($TYPE=="PRO")
{
	if($LINE_ID=="")
		$query="insert into STOCK(PRODUCT_ID,AMT,PRICE,ADD_TIME,HISTORY_ID) values ('$PRO_ID','-$TRANS_QTY','$PRICE','$CUR_TIME','$HISTORY_ID')";
	 else
		$query="update STOCK set PRODUCT_ID='$PRO_ID',AMT='-$TRANS_QTY',PRICE='$PRICE' where HISTORY_ID='$HISTORY_ID' and WH_ID=0";
		exequery($connection,$query);
 }
?>
</body>
</html>
<?
if($FLAGSOURCE=="ad_query")
{
?>
<script>
location="index.php?HISTORY_ID=<?=$HISTORY_ID?>&querstr=<?=$querstr?>&<?=$QUERY_LIST?>";
</script>
<?
}
else
{
?>
<script>
location="index.php?HISTORY_ID=<?=$HISTORY_ID?>&<?=$QUERY_LIST?>";
</script>
<?
}
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -