📄 add.php

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

💻 PHP

字号:

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
echo "\r\n<html>\r\n<head>\r\n<title>增加退货明细</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\">\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$PRICE *= $AMT;
if ( $OP == "ADD" )
{
	$query = "INSERT into SALE_CANCEL_ITEM (CANCEL_ID,PRODUCT_ID,AMT,PRICE) values('".$CANCEL_ID."','{$PRODUCT_ID}','{$AMT}','{$PRICE}')";
}
else
{
	$query = "update SALE_CANCEL_ITEM set PRODUCT_ID='".$PRODUCT_ID."',AMT='{$AMT}',PRICE='{$PRICE}' where ITEM_ID='{$STOCK_ID}'";
}
exequery( $connection, $query );
if ( $OP == "ADD" )
{
	$STOCK_ID = mysql_insert_id( );
}
$query = "select sum(AMT),sum(PRICE) from SALE_CANCEL_ITEM where CANCEL_ID='".$CANCEL_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TOTAL_AMT = $ROW[0];
	$TOTAL_PRICE = $ROW[1];
}
$query = "update SALE_CANCEL set TOTAL_NUM='".$TOTAL_AMT."',TOTAL_PRICE='{$TOTAL_PRICE}' where CANCEL_ID='{$CANCEL_ID}'";
exequery( $connection, $query );
$query = "select STOCK_ID from STOCK where HISTORY_ID='".$CANCEL_ID."' and ITEM_ID='{$STOCK_ID}' and AMT>0";
$cursor = exequery( $connection, $query );
if ( !mysql_fetch_array( $cursor ) )
{
	$query = "insert into STOCK(PRODUCT_ID,AMT,PRICE,ADD_TIME,HISTORY_ID,ITEM_ID,STATUS) values ('".$PRODUCT_ID."','{$AMT}','{$PRICE}','{$CUR_TIME}','{$CANCEL_ID}','{$STOCK_ID}','1')";
}
else
{
	$query = "update STOCK set AMT='".$AMT."' where HISTORY_ID='{$CANCEL_ID}' and ITEM_ID='{$STOCK_ID}'";
}
exequery( $connection, $query );
echo "</body>\r\n</html>\r\n<script>\r\nlocation=\"index.php?CANCEL_ID=";
echo $CANCEL_ID;
echo "&WH_ID=";
echo $WH_ID;
echo "&";
echo $QUERY_LIST;
echo "\";\r\n</script>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -