trans_return.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "SELECT PRO_ID,FACT_QTY from OFFICE_TRANSHISTORY where TRANS_ID='".$TRANS_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRO_ID = $ROW['PRO_ID'];
	$FACT_QTY = $ROW['FACT_QTY'];
}
$query = "SELECT PRO_STOCK from OFFICE_PRODUCTS where PRO_ID='".$PRO_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRO_STOCK = $ROW['PRO_STOCK'];
}
$NEW_PRO_STOCK = $PRO_STOCK + $FACT_QTY;
$query = "update OFFICE_PRODUCTS set PRO_STOCK='".$NEW_PRO_STOCK."' where PRO_ID='{$PRO_ID}'";
exequery( $connection, $query );
$query = "update OFFICE_TRANSHISTORY set TRANS_STATE='3' where TRANS_ID='".$TRANS_ID."'";
exequery( $connection, $query );
header( "location:trans_info.php" );
?>