php拾遗
//计算库存 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']; //库存金额以进价为准 //重新计算销售金额 $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); }
页:
[1]