//計算庫存 
    foreach($aGoodsLst as $goodsid => $aGoods) 
    { 
        $aGoods['price'] = $aGoods['buy']==0?0:($aGoods['buymoney']/ $aGoods['buy']); 
        $aGoods['stock'] = $aGoods['buy'] - $aGoods['sell'] + $aGoods['return'];   
        $aGoods['stockmoney'] = $aGoods['stock'] * $aGoods['price']; //庫存金額以進價為準(zhǔn)  
         
        //重新計算銷售金額  
        $aGoods['sell'] = $aGoods['sell'] - $aGoods['return'];   
        $aGoods['sellmoney'] = $aGoods['sellmoney'] - $aGoods['returnmoney'];   
         
        //盈余 
        $aGoods['earn'] = $aGoods['sellmoney']-$aGoods['buymoney'];  
         
        extract($aGoods); 
         
        $sSql = "UPDATE goods SET buy='$buy',buymoney='$buymoney',stock='$stock',stockmoney='$stockmoney',sell='$sell',sellmoney='$sellmoney',`return`='$return',returnmoney='$returnmoney',earn='$earn' WHERE id=$goodsid"; 
        $oDb->query($sSql);  
    }