📄 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">
<?
$CUR_TIME=date("Y-m-d H:i:s",time());
$PRO_CONTENT_ARRAY=explode("\n",$PRO_CONTENT);
$ARRAY_COUNT=sizeof($PRO_CONTENT_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
	if($PRO_CONTENT_ARRAY[$I]=="")
		break;
	$PRO_CONTENT_ITEM_ARRAY=explode("`",$PRO_CONTENT_ARRAY[$I]);
	$TOTAL_PRICE=$PRO_CONTENT_ITEM_ARRAY[2]*$PRO_CONTENT_ITEM_ARRAY[3];
	$PRICE=$PRO_CONTENT_ITEM_ARRAY[2];
	$TRANS_QTY=$PRO_CONTENT_ITEM_ARRAY[3];
	$PRO_ID=$PRO_CONTENT_ITEM_ARRAY[1];
	//----------------------------------------------------------
	$query="INSERT into SALE_HISTORY(`CUSTOMER_ID`,`PRODUCT_ID`,`SERVICE_ID`,`TYPE`,`DATE`,`AMT`,`PRICE`,`TOTAL_PRICE`,`SALESMAN`,`DISCOUNT`,`CONTRACT_ID`,`LINE_ID`,`MEMO`,`MEMO1`)values
									('$CUSTOMER_ID', '$PRO_ID','$SER_ID','PRO','$CREATE_DATE','$TRANS_QTY','$PRICE','$TOTAL_PRICE','$SELLER','$DISCOUNT','$CONTRACT_ID','$LINE_ID','$MEMO','$MEMO1')";
	exequery($connection,$query);

	$HISTORY_ID=mysql_insert_id();
	$query="insert into STOCK(PRODUCT_ID,AMT,PRICE,ADD_TIME,HISTORY_ID) values ('$PRO_ID','-$TRANS_QTY','$PRICE','$CUR_TIME','$HISTORY_ID')";
	exequery($connection,$query);
}


$SER_CONTENT_ARRAY=explode("\n",$SER_CONTENT);

$ARRAY_COUNT=sizeof($SER_CONTENT_ARRAY);
$PRICE='';
$TRANS_QTY=0;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
	if($SER_CONTENT_ARRAY[$I]=="")
		break;
	$SER_CONTENT_ITEM_ARRAY=explode("`",$SER_CONTENT_ARRAY[$I]);
	$TOTAL_PRICE=$SER_CONTENT_ITEM_ARRAY[2];
	$SER_ID=$SER_CONTENT_ITEM_ARRAY[1];
	//----------------------------------------------------------
	$query="INSERT into SALE_HISTORY(`CUSTOMER_ID`,`PRODUCT_ID`,`SERVICE_ID`,`TYPE`,`DATE`,`AMT`,`PRICE`,`TOTAL_PRICE`,`SALESMAN`,`DISCOUNT`,`CONTRACT_ID`,`LINE_ID`,`MEMO`,`MEMO1`)values
									('$CUSTOMER_ID', '$PRO_ID','$SER_ID','SER','$CREATE_DATE','$TRANS_QTY','$PRICE','$TOTAL_PRICE','$SELLER','$DISCOUNT','$CONTRACT_ID','$LINE_ID','$MEMO','$MEMO1')";
	exequery($connection,$query);
}

header("location: index.php");
?>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -