<?php

namespace app\api\model\plus\coupon;

use app\common\model\plus\coupon\Coupon as CouponModel;
use app\api\model\product\Category as CategoryModel;
use app\api\model\product\Product as ProductModel; // by lyzflash
use app\common\library\helper; // by lyzflash

/**
 * 优惠券模型
 */
class Coupon extends CouponModel
{
    /**
     * 隐藏字段
     */
    protected $hidden = [
        'is_delete',
        'create_time',
        'update_time',
    ];

    /**
     * 获取用户优惠券总数量(可用)
     */
    public function getCount($user_id)
    {
        return $this->where('user_id', '=', $user_id)
            ->where('is_use', '=', 0)
            ->where('is_expire', '=', 0)
            ->count();
    }

    /**
     * 获取用户优惠券ID集
     */
    public function getUserCouponIds($user_id)
    {
        return $this->where('user_id', '=', $user_id)->column('coupon_id');
    }

    /**
     * 领取优惠券
     */
    public function receive($user, $coupon_id)
    {
        // 获取优惠券信息
        $coupon = Coupon::detail($coupon_id);
        // 验证优惠券是否可领取
        if (!$this->checkReceive($user, $coupon)) {
            return false;
        }
        // 添加领取记录
        return $this->add($user, $coupon);
    }

    /**
     * 添加领取记录
     */
    private function add($user, $coupon)
    {
        // 计算有效期
        if ($coupon['expire_type'] == 10) {
            $start_time = time();
            $end_time = $start_time + ($coupon['expire_day'] * 86400);
        } else {
            $start_time = $coupon['start_time']['value'];
            $end_time = $coupon['end_time']['value'];
        }
        // 整理领取记录
        $data = [
            'coupon_id' => $coupon['coupon_id'],
            'name' => $coupon['name'],
            'color' => $coupon['color']['value'],
            'coupon_type' => $coupon['coupon_type']['value'],
            'reduce_price' => $coupon['reduce_price'],
            'discount' => $coupon->getData('discount'),
            'min_price' => $coupon['min_price'],
            'expire_type' => $coupon['expire_type'],
            'expire_day' => $coupon['expire_day'],
            'start_time' => $start_time,
            'end_time' => $end_time,
            'apply_range' => $coupon['apply_range'],
            'user_id' => $user['user_id'],
            'app_id' => self::$app_id,
            // 返还金额
            'back_money' => $coupon['back_money'],
            // 兑换券价值金额
            'product_price' => $coupon['product_price'],
            // 兑换券使用次数 by lyzflash
            'total_use_num' => $coupon['coupon_type']['value'] == 30 ? $coupon['total_use_num'] : 0,
            'limit_use_num' => $coupon['coupon_type']['value'] == 30 ? $coupon['total_use_num'] : 0,
            // 兑换券优惠项目
            'coupon_project' => $coupon['coupon_project'],
            // 使用规则
            'coupon_rule' => $coupon['coupon_rule'],
            // 每天核销上限
            'verify_num' => $coupon['verify_num'],
            // 优惠项目可用数量
            'project_limit_num' => $coupon['project_limit_num'],
            // 适用范围
            'use_scope' => $coupon['use_scope'],

        ];
        return $this->transaction(function () use ($data, $coupon) {
            // 添加领取记录
            $status = $this->save($data);
            if ($status) {
                // 更新优惠券领取数量
                $coupon->setIncReceiveNum();
            }
            return $status;
        });
    }

    /**
     * 获取优惠券列表
     */
    public function getList($user = false, $limit = null, $only_receive = false, $shop_supplier_id = 0)
    {
        $model = $this;
        // 构造查询条件
        $model = $model->with(['supplier'])->where('is_delete', '=', 0);
        // 只显示可领取(未过期,未发完)的优惠券
        if ($only_receive) {
            $model = $model->where('	IF ( `total_num` > - 1, `receive_num` < `total_num`, 1 = 1 )')
                ->where('IF ( `expire_type` = 20, (`end_time` + 86400) >= ' . time() . ', 1 = 1 )');
        }
        //显示平台、店铺优惠券
        $model = $model->where('shop_supplier_id', '=', $shop_supplier_id);
        if($limit != null){
            $model = $model->limit($limit);
        }
        // 优惠券列表
        $couponList = $model->order(['sort' => 'asc', 'create_time' => 'desc'])->select();
        foreach ($couponList as $key => $item) {
            $couponList[$key]['is_receive'] = false;
            $item['category_list'] = [];
            if ($item['apply_range'] == 30) {
                $category_ids = json_decode($item['category_ids'], true);
                $first = (new CategoryModel())->getListByIds($category_ids['first']);
                $first = $first ? $first->toArray() : [];
                $second = (new CategoryModel())->getListByIds($category_ids['second']);
                $second = $second ? $second->toArray() : [];
                $item['category_list'] = array_merge($first, $second);
            }
        }
        // 获取用户已领取的优惠券
        if ($user !== false) {
            $CouponModel = new UserCoupon();
            $userCouponIds = $CouponModel->getUserCouponIds($user['user_id']);
            foreach ($couponList as $key => $item) {
                $couponList[$key]['is_receive'] = in_array($item['coupon_id'], $userCouponIds);

            }
        }
        return $couponList;
    }

    /**
     * 待领取优惠券
     */
    public function getWaitList($data, $user = false, $type = 1, $status = 0, $is_page = false)
    {
        $params = array_merge([
            'list_rows' => 15,       // 每页数量
        ], $data);
        $model = $this->alias('uc')->with(['supplier.logo']);
        $field = "*";
        // 构造查询条件
        if ($type) {
            $model = $model->where('shop_supplier_id', $data['shop_supplier_id']);
        } else {
            $CouponModel = new UserCoupon();
            $userCouponIds = $CouponModel->getUserCouponIds($user['user_id']);
            $model = $model->where('coupon_id', 'not in', implode(',', $userCouponIds));
        }
        if ($status) {//显示平台优惠券
            $model = $model->where('shop_supplier_id', '=', 0);
        }
        $model = $model->where('is_delete', '=', 0);
        $model = $model->where('	IF ( `total_num` > - 1, `receive_num` <= `total_num`, 1 = 1 )')
            ->where('IF ( `expire_type` = 20, `end_time` >= ' . time() . ', 1 = 1 )');
        // 是否显示在领券中心
        $model = $model->where('show_center', '=', 1);

        // 用户可领取优惠券列表
        $model = $model->field("$field")->order(['sort' => 'asc', 'create_time' => 'desc']);
        // 是否分页 by lyzflash
        if ($is_page) {
            $couponList = $model->paginate($params);
        } else {
            $couponList = $model->select();
        }
        foreach ($couponList as $item) {
            $item['reduce_price'] = floatval($item['reduce_price']);
            $item['min_price'] = floatval($item['min_price']);
            $item['price_text'] = $item['min_price'] > 0 ? '满' . $item['min_price'] . '可用' : '无使用门槛';
            $item['product_price'] = floatval($item['product_price']); // 商品价值，兑换券使用 by lyzflash
            // 获取商品
            $product_list = [];
            if ($item['apply_range'] == 20) {
                $product_ids = explode(',', $item['product_ids']);
                $product_list = (new ProductModel())->getListByIdsFromApi($product_ids, $user)->toArray();
            }
            if ($item['apply_range'] == 30) {
                $category_ids = json_decode($item['category_ids'], true);
                $product_list = (new ProductModel())->getListByCatIdsFromApi($category_ids, $user)->toArray();
            }
            if ($product_list) {
                $product_list = array_slice($product_list, 0, 3);
                $item['product'] = helper::getArrayColumns($product_list, ['product_id', 'product_name', 'product_price', 'product_image']);
            }
        }
        // 获取用户已领取的优惠券
        if ($user !== false) {
            $CouponModel = new UserCoupon();
            $userCouponIds = $CouponModel->getUserCouponIds($user['user_id']);
            foreach ($couponList as $item) {
                $item['is_get'] = in_array($item['coupon_id'], $userCouponIds);
            }
        } else {
            foreach ($couponList as $item) {
                $item['is_get'] = 0;
            }
        }
        return $couponList;
    }

    /**
     * 验证优惠券是否可领取
     */
    public function checkReceive()
    {
        if ($this['total_num'] > -1 && $this['receive_num'] >= $this['total_num']) {
            $this->error = '优惠券已发完';
            return false;
        }
        if ($this['expire_type'] == 20 && ($this->getData('end_time') + 86400) < time()) {
            $this->error = '优惠券已过期';
            return false;
        }
        return true;
    }

    /**
     * 累计已领取数量
     */
    public function setIncReceiveNum()
    {
        return $this->where('coupon_id', '=', $this['coupon_id'])->inc('receive_num')->update();
    }

    public function getWhereData($coupon_arr)
    {
        return $this->where('coupon_id', 'in', $coupon_arr)->select();
    }

    /**
     * 查询指定优惠券
     */
    public function getCoupon($value)
    {
        return $this->where('coupon_id', 'in', $value)->select();
    }
}