seafood/app/GoodsSkus.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/9/29
 * Time: 15:07
 */

namespace App;
use Illuminate\Database\Eloquent\Model;

class GoodsSkus extends Model
{
    public $timestamps = false;
    protected $table = "goods_skus";

    public static function actualQuantity($sku_id){
    	//计算实际库存 -还未到卖家云的量
    	$sku_quantity = GoodsSkus::where('id', $sku_id)->pluck('quantity');
        $w_num = OrderGoodsSkus::where('sku_id', $sku_id)->where('is_del',0)->where('mj_status',0)->sum('num');
        $fx_num = FxOrderGoodsSkus::where('sku_id', $sku_id)->where('is_del',0)->where('mj_status',0)->sum('num');
        $quantity = $sku_quantity - $w_num - $fx_num;
        return $quantity;
    }
   
}