📄 delete.php

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

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\" topmargin=\"5\">\r\n\r\n";
$query = "select TRANS_QTY,PRO_ID from OFFICE_TRANSHISTORY where TRANS_ID='{$TRANS_ID}'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$MOD_STOCK = $ROW['TRANS_QTY'] * -1;
	$PRO_ID = $ROW['PRO_ID'];
}
$query = "select PRO_STOCK from OFFICE_PRODUCTS where PRO_ID='{$PRO_ID}'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$PRO_STOCK = $ROW['PRO_STOCK'];
}
$PRO_STOCK = $PRO_STOCK + $TRANS_QTY + $MOD_STOCK;
$query = "update OFFICE_PRODUCTS set PRO_STOCK='{$PRO_STOCK}' where PRO_ID='{$PRO_ID}'";
exequery( $connection, $query );
$query = "delete from OFFICE_TRANSHISTORY where TRANS_ID='{$TRANS_ID}'";
exequery( $connection, $query );
header( "location:record.php" );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -