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;
    }

    public static function actualQuantityByRedis($sku_id){
        //计算实际库存 -还未到卖家云的量
        $sku_quantity = GoodsSkus::where('id', $sku_id)->pluck('quantity');
        $redisKey = config('SKU_QUANTITY_TABLE');
        $w_num = RedisModel::hGet($redisKey, $sku_id);
        if(!$w_num) $w_num = 0;
        $quantity = $sku_quantity - $w_num;
        return $quantity;
    }
   
}