update.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

session_start( );
header( "Content-Type: text/html; charset=gb2321" );
include_once( "inc/auth.php" );
$connection = openconnection( );
switch ( $_REQUEST['handle'] )
{
case "update" :
	if ( $_REQUEST['join_amount'] == "2" )
	{
		$amount = "-".$_REQUEST['amount'];
	}
	else
	{
		$amount = $_REQUEST['amount'];
	}
	$sql = "select SORT from officeitem_sort as s, officeitem_appellation as a where a.SORT_ID=s.SORT_ID and a.APPELLATION_ID=".$_REQUEST['appellation_id'];
	$cursor = exequery( $connection, $sql );
	if ( $row = mysql_fetch_row( $cursor ) )
	{
		$sort = $row[0];
	}
	$query = "insert into officeitem_joinstoreroom (JOIN_DATE, PROVIDER_ID, BILL, APPELLATION_ID, PRICE, JOIN_AMOUNT, MONEY, STOREROOM_STOCKPILE, OPERATOR, JOIN_APPELLATION, JOIN_APPELLATION_SORT) VALUES ('".$_REQUEST['join_date']."', '".$_REQUEST['PROVIDER_ID']."', '".$_REQUEST['bill']."', ".$_REQUEST['appellation_id'].", '".$_REQUEST['price']."', ".$amount.", '".$_REQUEST['products']."', ".$_REQUEST['storeroom_stockpile'].", '".$_SESSION['LOGIN_USER_ID']."', '".$_REQUEST['appellation']."', '".$sort."')";
	exequery( $connection, $query );
	$query3 = "select STOCKPILE from officeitem_appellation where APPELLATION_ID=".$_REQUEST['appellation_id'];
	$cursor3 = exequery( $connection, $query3 );
	if ( $row3 = mysql_fetch_row( $cursor3 ) )
	{
		$stockpile = $row3[0];
	}
	$sum = $stockpile + $amount;
	$query2 = "update officeitem_appellation set STOCKPILE=".$sum.",IS_JOIN='1' where APPELLATION_ID=".$_REQUEST['appellation_id'];
	exequery( $connection, $query2 );
	header( "location:./" );
	break;
case "delete" :
	$query = "delete from officeitem_joinstoreroom where STOREROOM_ID=".$_REQUEST['storeroom_id'];
	exequery( $connection, $query );
	header( "location:manage.php" );
}
?>