hemall.terabimsoft.com.cn/app/common/models/Coupon.php

<?php

namespace app\common\models;

use app\framework\Database\Eloquent\Builder;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * Class Coupon
 * @package app\common\models
 * @property int coupon_method
 * @property int use_type
 * @property int status
 * @property int get_type
 * @property int time_limit
 * @property string name
 * @property string suppliernames
 * @property array supplierids
 * @property int getsupplier
 * @property string storenames
 * @property array storeids
 * @property int getstore
 * @property string category_ids
 * @property int is_complex
 * @property array goods_ids
 * @property int id
 * @property int plugin_id
 * @property int total
 * @property int time_days
 * @property float discount
 * @property float enough
 * @property float deduct
 * @property int get_max
 * @property int level_limit
 * @property Carbon time_start
 * @property Carbon time_end
 * @method  Builder memberLevel($memberLevel)
 * @method Builder unexpired($time)
 */
class  Coupon extends BaseModel
{
    use SoftDeletes;

    protected $dates = ['deleted_at', 'time_start', 'time_end'];

    const COUPON_SHOP_USE = 0; //适用范围 - 商城通用
    const COUPON_CATEGORY_USE = 1; //适用范围 - 指定分类
    const COUPON_GOODS_USE = 2; //适用范围 - 指定商品
    const COUPON_SUPPLIER_USE = 3; //适用范围 - 指定供应商single
    const COUPON_STORE_USE = 4; //适用范围 - 指定门店
    const COUPON_SINGLE_STORE_USE = 5; //适用范围 - 指定单个门店
    const COUPON_ONE_HOTEL_USE = 6; //适用范围 - 单个酒店
    const COUPON_MORE_HOTEL_USE = 7; //适用范围 - 多个酒店
    const COUPON_EXCHANGE_USE = 8; //兑换券
    const COUPON_GOODS_AND_STORE_USE = 9; //指定商品+指定门店

    const COUPON_MONEY_OFF = 1; //优惠方式- 立减
    const COUPON_DISCOUNT = 2; //优惠方式- 折扣
    const COUPON_EXCHANGE = 3; //优惠方式- 兑换

    const COUPON_DATE_TIME_RANGE = 1;//有效期 - 时间范围
    const COUPON_SINCE_RECEIVE = 0;//有效期 - 领取后n天

    const NO_LIMIT = -1; //不限


    public $table = 'yz_coupon';

    protected $guarded = [];

    protected $casts = [
        'goods_ids' => 'json',
        'category_ids' => 'json',
        'goods_names' => 'json',
        'categorynames' => 'json',
        'supplierids' => 'json',
        'storeids' => 'json',
        'storenames' => 'json',
        'member_tags_ids' => 'json',
        'member_tags_names' => 'json',
    ];

    /**
     * @var array
     */
    protected $appends = ['coupon_type_name'];

    public function getCouponTypeNameAttribute()
    {
        switch ($this->attributes['use_type']) {
            case Coupon::COUPON_SHOP_USE:
                $name = '平台商品';
                break;
            case Coupon::COUPON_STORE_USE:
                $name = '门店商品';
                break;
            case Coupon::COUPON_SINGLE_STORE_USE:
                $name = '门店商品';
                break;
            case Coupon::COUPON_ONE_HOTEL_USE:
                $name = '酒店商品';
                break;
            case Coupon::COUPON_MORE_HOTEL_USE:
                $name = '酒店商品';
                break;
            case Coupon::COUPON_GOODS_USE:
                $name = '指定商品';
                break;
            case Coupon::COUPON_CATEGORY_USE:
                $name = '分类商品';
                break;
            case Coupon::COUPON_EXCHANGE_USE:
                $name = '兑换券';
                break;
            case Coupon::COUPON_GOODS_AND_STORE_USE:
                $name = '商品和门店';
                break;
            default:
                $name = '未知类型';
        }
        return $name;
    }
//    protected $hidden = ['storeids'];
//    protected $hidden = ['uniacid', 'cat_id', 'get_type', 'level_limit', 'use_type', 'return_type', 'coupon_type'
//        , 'coupon_method','back_type','supplier_uid','cashiersids','cashiersnames','category_ids','goods_ids',
//    'storeids','supplierids','is_complex','getcashier','getstore','getsupplier','back_money','back_credit',
//        'back_redpack','back_when','descnoset','deleted_at'];

    public function hasManyMemberCoupon()
    {
        return $this->hasMany('app\common\models\MemberCoupon','coupon_id','id');
    }

    public static function getValidCoupon($MemberModel)
    {
        return MemberCoupon::getMemberCoupon($MemberModel);
    }

    public static function getUsageCount($couponId)
    {
        return static::uniacid()
            ->select(['id'])
            ->where('id', '=', $couponId)
            ->withCount(['hasManyMemberCoupon' => function ($query) {
                return $query->where('used', '=', 0);
            }]);
    }

    public static function getCouponById($couponId)
    {
        return static::uniacid()
            ->where('id', '=', $couponId)
           // ->with(['hasManyMemberCoupon'])（这个查询导致数据量太大崩了）
            ->first();
    }

    //获取优惠券优惠方式
    public static function getPromotionMethod($couponId)
    {
        $useType = static::uniacid()->where('id', '=', $couponId)->value('coupon_method');
        switch ($useType) {
            case self::COUPON_MONEY_OFF:
                return [
                    'type' => self::COUPON_MONEY_OFF,
                    'mode' => static::uniacid()->where('id', '=', $couponId)->value('deduct'),
                ];
                break;
            case self::COUPON_DISCOUNT:
                return [
                    'type' => self::COUPON_DISCOUNT,
                    'mode' => static::uniacid()->where('id', '=', $couponId)->value('discount'),
                ];
                break;
            default:
                return [
                    'type' => self::COUPON_SHOP_USE,
                ];
                break;
        }
    }

    //获取优惠券适用期限
    public static function getTimeLimit($couponId)
    {
        $time_limit = static::uniacid()->where('id', '=', $couponId)->value('time_limit');
        switch ($time_limit) {
            case self::COUPON_SINCE_RECEIVE:
                return [
                    'type' => self::COUPON_SINCE_RECEIVE,
                    'time_end' => static::uniacid()->where('id', '=', $couponId)->value('time_days'),
                ];
                break;
            case self::COUPON_DATE_TIME_RANGE:
                return [
                    'type' => self::COUPON_DATE_TIME_RANGE,
                    'time_end' => static::uniacid()->where('id', '=', $couponId)->value('time_end'),
                ];
                break;
            default:
                return [
                    'type' => self::COUPON_SHOP_USE,
                ];
                break;
        }
    }

    //获取优惠券的适用范围
    public static function getApplicableScope($couponId)
    {
        $useType = static::uniacid()
            ->where('id', '=', $couponId)
            ->value('use_type');
        switch ($useType) {
            case 8:
                $goodIds = self::getApplicalbeGoodIds($couponId);
                return [
                    'type' => self::COUPON_GOODS_USE,
                    'scope' => $goodIds,
                ];
                break;
            case self::COUPON_GOODS_USE:
                $goodIds = self::getApplicalbeGoodIds($couponId);
                return [
                    'type' => self::COUPON_GOODS_USE,
                    'scope' => $goodIds,
                ];
                break;
            case self::COUPON_CATEGORY_USE:
                $categoryIds = self::getApplicalbeCategoryIds($couponId);
                return [
                    'type' => self::COUPON_CATEGORY_USE,
                    'scope' => $categoryIds,
                ];
                break;
            case self::COUPON_STORE_USE:
                $categoryIds = self::getApplicalbeCategoryIds($couponId);
                return [
                    'type' => self::COUPON_STORE_USE,
                    'scope' => $categoryIds,
                ];
                break;
            case self::COUPON_SINGLE_STORE_USE:
                $categoryIds = self::getApplicalbeCategoryIds($couponId);
                return [
                    'type' => self::COUPON_SINGLE_STORE_USE,
                    'scope' => $categoryIds,
                ];
                break;
            case self::COUPON_GOODS_AND_STORE_USE:
                return [
                    'type' => self::COUPON_GOODS_AND_STORE_USE,
                ];
                break;
            default:
                return [
                    'type' => self::COUPON_SHOP_USE,
                ];
                break;
        }
    }

    //获取优惠券的适用商品ID
    public static function getApplicalbeGoodIds($couponId)
    {
        return static::uniacid()
            ->where('id', '=', $couponId)
            ->value('goods_ids');
    }

    //获取优惠券的适用商品分类ID
    public static function getApplicalbeCategoryIds($couponId)
    {
        return static::uniacid()
            ->where('id', '=', $couponId)
            ->value('category_ids');
    }

    /**
     * 筛选某会员等级可领
     * @param Builder $query
     * @param $memberLevel
     * @return Builder
     */
    public function scopeMemberLevel(Builder $query, $memberLevel)
    {
        return $query->where(function ($query) use ($memberLevel) {
            $query->where('level_limit', '<=', $memberLevel)
                ->orWhere(function ($query) {
                    $query->where('level_limit', -1);
                });
        });
    }

    /**
     * 筛选未过期
     * @param Builder $query
     * @param null $time
     * @return Builder
     */
    public function scopeUnexpired(Builder $query, $time = null)
    {
        if (!isset($time)) {
            $time = time();
        }
        return $query->where(function ($query) use ($time) {
            // 不限时间
            $query->where('time_limit', 1)->where('time_end', '>', $time-86400)
                ->orWhere(function ($query) {
                // 未结束的优惠券
                $query->where('time_limit', 0);
            });

        });
    }

    /**
     * todo 为什么会出现负数
     * 可领取张数
     * @param $receivedCount
     * @return int
     */
    public function availableCount($receivedCount)
    {
        if ($this->get_max == self::NO_LIMIT) {
            return 999;
        }
        return max($this->get_max - $receivedCount,0);
    }

    /**
     * todo 应在优惠券表添加这个字段
     * 获取已领取数量
     * @return int
     */
    public function getReceiveCount()
    {
        return $this->hasManyMemberCoupon()->count();
    }

    /**
     * 是否可领取
     * @return bool
     */
    public function available($special_type = 0)
    {
        $res = $this->status == 1 && ($this->total == -1 || $this->total > 0);
        if ($special_type != 1){
            $res = $res && $this->get_type == 1;
        }
        return $res;
//        return $this->status == 1 && $this->get_type == 1 && ($this->total == -1 || $this->total > 0);
    }
}