<?php

namespace app\models;

use Yii;
use yii\db\Exception;

/**
 * This is the model class for table "{{%coupon}}".
 *
 * @property int $id
 * @property int $mall_id
 * @property string $name 优惠券名称
 * @property int $type 优惠券类型：1=折扣，2=满减
 * @property string $discount 折扣率
 * @property string $discount_limit 优惠上限
 * @property int $pic_url 未用
 * @property string $desc 未用
 * @property string $min_price 最低消费金额
 * @property string $sub_price 优惠金额
 * @property int $total_count 发放总数量
 * @property int $can_receive_count 可领取数量
 * @property int $sort 排序按升序排列
 * @property int $expire_type 到期类型：1=领取后N天过期，2=指定有效期
 * @property int $expire_day 有效天数，expire_type=1时
 * @property string $begin_time 有效期开始时间
 * @property string $end_time 有效期结束时间
 * @property int $appoint_type 类型
 * @property string $rule 使用说明
 * @property int $is_member 是否指定会员等级购买
 * @property int $is_delete 删除
 * @property string $deleted_at
 * @property string $created_at
 * @property string $updated_at
 * @property string $app_share_title
 * @property string $app_share_pic
 * @property GoodsCats[] $cat
 * @property GoodsWarehouse[] $goods
 * @property GoodsWarehouse[] $goodsWarehouse
 * @property $couponCat
 * @property $couponGoods
 * @property string $appointTypeText
 * @property int $use_obtain
 */
class Coupon extends ModelActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%coupon}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'name', 'type', 'min_price', 'sub_price', 'expire_type', 'appoint_type', 'deleted_at', 'created_at', 'updated_at'], 'required'],
            [['mall_id', 'type', 'pic_url', 'total_count', 'sort', 'expire_type', 'expire_day', 'appoint_type',
                'is_member', 'is_delete', 'can_receive_count', 'use_obtain'], 'integer'],
            [['discount', 'discount_limit', 'min_price', 'sub_price'], 'number'],
            [['begin_time', 'end_time', 'deleted_at', 'created_at', 'updated_at'], 'safe'],
            [['name', 'app_share_title', 'app_share_pic'], 'string', 'max' => 255],
            [['desc', 'rule'], 'string', 'max' => 2000],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => 'mall ID',
            'name' => '优惠券名称',
            'type' => '优惠券类型：1=折扣，2=满减',
            'discount' => '折扣率',
            'discount_limit' => '优惠上限',
            'pic_url' => '未用',
            'desc' => '未用',
            'min_price' => '最低消费金额',
            'sub_price' => '优惠金额',
            'total_count' => '发放总数量',
            'can_receive_count' => '可领取数量',
            'sort' => '排序按升序排列',
            'expire_type' => '到期类型',
            'expire_day' => '有效天数',
            'appoint_type' => '指定方式',
            'begin_time' => '有效期开始时间',
            'end_time' => '有效期结束时间',
            'rule' => '使用说明',
            'is_member' => '是否指定会员等级领取',
            'is_delete' => '删除',
            'deleted_at' => 'Deleted At',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'app_share_title' => 'App Share Title',
            'app_share_pic' => 'App Share Pic',
            'use_obtain' =>  '领取后赠送',
        ];
    }

    public function getCat()
    {
        return $this->hasMany(GoodsCats::className(), ['id' => 'cat_id'])->where(['is_delete' => 0])
            ->via('couponCat');
    }

    public function getGoodsWarehouse()
    {
        return $this->hasMany(GoodsWarehouse::className(), ['id' => 'goods_warehouse_id'])
            ->via('couponGoods');
    }

    public function getGoods()
    {
        return $this->hasMany(GoodsWarehouse::className(), ['id' => 'goods_warehouse_id'])
            ->via('couponGoods');
    }

    public function getCouponCat()
    {
        return $this->hasMany(CouponCatRelation::className(), ['coupon_id' => 'id'])->where(['is_delete' => 0]);
    }

    public function getCouponGoods()
    {
        return $this->hasMany(CouponGoodsRelation::className(), ['coupon_id' => 'id'])->where(['is_delete' => 0]);
    }

    public function getCouponMember()
    {
        return $this->hasMany(CouponMemberRelation::className(), ['coupon_id' => 'id']);
    }

    public function getCouponCenter()
    {
        return $this->hasOne(CouponCenter::className(), ['coupon_id' => 'id']);
    }

    public function getBeginTime()
    {
        return date('Y-m-d', strtotime($this->begin_time));
    }

    public function getEndTime()
    {
        return date('Y-m-d', strtotime($this->end_time));
    }

    /**
     * @param $num integer 修改的数量
     * @param $type string 增加add|减少sub
     * @param null|integer $id 优惠券ID
     * @return Coupon|null
     * @throws Exception
     */
    public function updateCount($num, $type, $id = null)
    {
        if ($id) {
            $coupon = self::findOne(['id' => $id, 'is_delete' => 0]);
        } else {
            $coupon = $this;
        }
        if (!$coupon || !$coupon->id) {
            throw new Exception('错误的优惠券信息');
        }
        if ($coupon->total_count == -1) {
            return $coupon;
        }
        if ($type === 'add') {
            $coupon->total_count += $num;
        } elseif ($type === 'sub') {
            if ($coupon->total_count < $num) {
                throw new Exception('优惠券库存不足');
            }
            $coupon->total_count -= $num;
        } else {
            throw new Exception('错误的$type');
        }
        if ($coupon->save()) {
            return $coupon;
        } else {
            throw new Exception($coupon->errors[0]);
        }
    }

    public function getAppointTypeText()
    {
        switch ($this->appoint_type) {
            case 1:
                $text = '指定商品';
                break;
            case 2:
                $text = '指定商品类别';
                break;
            case 3:
                $text = '全场通用';
                break;
            case 4:
                $text = '仅限当面付';
                break;
            default:
                $text = '';
        }
        return $text;
    }
}