screen/application/common/model/Goods.php

<?php

namespace app\common\model;

use app\common\validate\KillService;
use think\db\Query;
use think\Model;

/**
 * 邮箱验证码
 * @method $this|static|Query filterNormal()
 * @method $this|static|Query filterKill()
 * @method $this|static|Query filterHot()
 */
class Goods Extends Model
{
    protected $type=[
        'logo'=>'json',
    ];
    public static $read=[
        'num_sell'
    ];
    protected $append=[
        'detail_url',
    ];
    // 开启自动写入时间戳字段
    protected $autoWriteTimestamp = true;

    public function sku(){
        return $this->hasMany(GoodsSku::class);
    }
    public function size(){
        return $this->hasMany(GoodsSize::class);
    }
    public function detail(){
        return $this->hasMany(GoodsDetail::class);
    }
    public function service(){
        return $this->hasMany(GoodsService::class);
    }
    public function binds(){
        return $this->hasMany(GoodsBind::class);
    }
    public function installLink(){
        return $this->hasMany(GoodsInstallLink::class);
    }
    public function category(){
        return $this->belongsTo(Category::class);
    }

    const STATUS_NORMAL=1;
    const STATUS_DOWN=2;
    public static $status=[
        self::STATUS_NORMAL=>'正常',
        self::STATUS_DOWN=>'下架',
    ];

    /**
     * @return string[]
     */
    public static function getStatus(): array
    {
        return self::$status;
    }

    public static function show(){
        return self::where('status',self::STATUS_NORMAL);
    }
    public function getAmountAttr($amount,$model){
        if(KillService::open() && $model['is_kill']){
            return $model['amount_kill'];
        }
        return $amount;
    }
    public function setAmount(){
        $sku=$this->sku()->select();
        $amount=$amountKill=0;
        foreach ($sku as $skuModel){
            foreach ($skuModel['amount_ladder'] as $ladder){
                $amount==0 && $amount=$ladder['amount'];
                if($amount>$ladder['amount']){
                    $amount=$ladder['amount'];
                }
            }
            foreach ($skuModel['amount_kill_ladder'] as $ladder){
                $amountKill==0 && $amountKill=$ladder['amount'];
                if($amountKill>$ladder['amount']){
                    $amountKill=$ladder['amount'];
                }
            }
        }
        $this->where('id',$this['id'])->update([
            'amount'=>$amount,
            'amount_kill'=>$amountKill,
        ]);
    }

    #维修费商品
    public static function getFixGoods(){
        static $goods;
        if(!$goods) {
            $goods = self::show()->where('is_fix', 1)->order('id', 'desc')->find();
        }
        return $goods;
    }

    protected static function init()
    {
        self::beforeWrite(function (self $goods){
            if(!empty($goods['is_hot']) && $goods['is_hot']==1){
                $goods['hot_at']=time();
            }
            if(!empty($goods['is_kill']) && $goods['is_kill']==1){
                $goods['kill_at']=time();
            }
        });
        self::afterDelete(function (self $goods){
            $goods->detail()->delete();
            $goods->service()->delete();
            $goods->sku()->delete();
            $goods->size()->delete();
            $goods->binds()->delete();
            GoodsBind::where('bind_goods_id',$goods['id'])->delete();
            GoodsCart::where('goods_id',$goods['id'])->delete();
            UserCouponGoods::where('goods_id',$goods['id'])->delete();
            GoodsInstallLink::where('goods_id',$goods['id'])->delete();
            Favourite::where('fav_id',$goods['id'])->where('fav_type','goods')->delete();
            ProgrammeGoods::where('goods_id',$goods['id'])->delete();
            CouponGoods::where('goods_id',$goods['id'])->delete();
        });

        self::afterUpdate(function (self $goods){
            //$goods->setAmount();
        });

        self::afterInsert(function (self $goods){
            SiteMsg::sendMsg(
                SiteMsg::TYPE_NEW_GOODS,
                0,
                compact('goods')
            );
        });
    }


    public function scopeFilterNormal(Query $query){
        $query->where('is_kill',0)->where('is_hot',0);
    }
    public function scopeFilterKill(Query $query){
        $query->where('is_kill',1);
    }
    public function scopeFilterHot(Query $query){
        $query->where('is_hot',1);
    }


    public function getDetailUrlAttr($_,$model){
        return sprintf('%s/goodsDetail?id=%d',request()->domain(),$model['id']??0);
    }
}