📄 update.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";
$TIME_OK = is_number( $TRANS_QTY );
if ( ( !$TIME_OK && $TRANS_QTY <= 0 ) && $TYPE == "PRO" )
{
	message( "错误", "数量错误" );
	echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='edit.php?HISTORY_ID=";
	echo $HISTORY_ID;
	echo "&";
	echo $QUERY_LIST;
	echo "'\">\r\n</div>\r\n\r\n";
	exit( );
}
if ( $TYPE == "PRO" )
{
	$TOTAL_PRICE = $PRICE * $TRANS_QTY;
}
$query = "update SALE_HISTORY set CUSTOMER_ID='".$CUSTOMER_ID."',PRODUCT_ID='{$PRO_ID}',SERVICE_ID='{$SER_ID}',TYPE='{$TYPE}',DATE='{$CREATE_DATE}',AMT='{$TRANS_QTY}',PRICE='{$PRICE}',TOTAL_PRICE='{$TOTAL_PRICE}',SALESMAN='{$SELLER}',MEMO='{$MEMO}' where HISTORY_ID='{$HISTORY_ID}'";
exequery( $connection, $query );
if ( $TYPE == "PRO" )
{
	$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 );
}
header( "location: index.php?".$QUERY_LIST );
echo "</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -