ekshopApi/app/api/model/plus/coupon/UserCoupon.php

<?php

namespace app\api\model\plus\coupon;

use app\common\library\helper;
use app\common\model\plus\coupon\UserCoupon as UserCouponModel;
use app\api\model\plus\coupon\Coupon as CouponModel;

/**
 * 用户优惠券模型
 */
class UserCoupon extends UserCouponModel
{
    /**
     * 获取用户优惠券列表
     */
    public function getPageList($user_id, $is_use, $is_expire, $params)
    {
        return $this->with(['coupon'])->where('user_id', '=', $user_id)
            ->where('is_use', '=', $is_use ? 1 : 0)
            ->where('is_expire', '=', $is_expire ? 1 : 0)
            ->paginate($params);
    }

    /**
     * 获取用户优惠券列表
     */
    public function getList($user_id, $is_use = 0, $is_expire = 0)
    {
        return $this->with(['coupon'])->where('user_id', '=', $user_id)
            ->where('is_use', '=', $is_use ? 1 : 0)
            ->where('is_expire', '=', $is_expire ? 1 : 0)
            ->select();
    }

    /**
     * 获取用户优惠券总数量(可用)
     */
    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);
    }

    /**
     * 批量领取优惠券
     */
    public function receiveList($user, $coupon_ids)
    {
        $coupon_arr = json_decode($coupon_ids, true);
        $model = new CouponModel();
        $list = $model->where('coupon_id', 'in', $coupon_arr)->select();
        // 开启事务
        $this->startTrans();
        try {
            $data = [];
            foreach ($list as $coupon) {
                // 验证优惠券是否可领取
                if ($this->checkReceive($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'],
                        'pv' => $coupon['pv'],
                        'app_id' => self::$app_id
                    ];
                    // 更新优惠券领取数量
                    $coupon->setIncReceiveNum();
                }
            }
            $data && $this->saveAll($data);
            $this->commit();
            return true;
        } catch (\Exception $e) {
            $this->error = $e->getMessage();
            $this->rollback();
            return false;
        }
    }

    /**
     * 添加领取记录
     */
    private function add($user, Coupon $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
        ];
        return $this->transaction(function () use ($data, $coupon) {
            // 添加领取记录
            $status = $this->save($data);
            if ($status) {
                // 更新优惠券领取数量
                $coupon->setIncReceiveNum();
            }
            return $status;
        });
    }

    /**
     * 邀请有礼优惠券奖励
     * @param $coupon_ids
     * @param $user_id
     */
    public function addUserCoupon($coupon_ids, $user)
    {
        $model = new CouponModel();
        $list = $model->where('coupon_id', 'in', $coupon_ids)->select();
        foreach ($list as $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' => $user['app_id']
            ];

        }
        $this->saveAll($data);
        return true;
    }

    /**
     * 礼包购礼优惠券奖励
     */
    public function addNewUserCoupon($coupon_ids, $user_id, $app_id = null)
    {
        $model = new CouponModel();
        $coupon = json_decode($coupon_ids, true);
        foreach ($coupon as $key => $value) {
            //查询优惠券信息
            $couponInfo = $model->where('coupon_id', '=', $value['coupon_id'])->find();
            //计算有效期
            if ($couponInfo['expire_type'] == 10) {
                $start_time = time();
                $end_time = $start_time + ($couponInfo['expire_day'] * 86400);
            } else {
                $start_time = $couponInfo['start_time']['value'];
                $end_time = $couponInfo['end_time']['value'];
            }
            for ($i = 0; $i < $value['coupon_num']; $i++) {
                $data[] = [
                    'coupon_id' => $couponInfo['coupon_id'],
                    'name' => $couponInfo['name'],
                    'color' => $couponInfo['color']['value'],
                    'coupon_type' => $couponInfo['coupon_type']['value'],
                    'reduce_price' => $couponInfo['reduce_price'],
                    'discount' => $couponInfo->getData('discount'),
                    'min_price' => $couponInfo['min_price'],
                    'expire_type' => $couponInfo['expire_type'],
                    'expire_day' => $couponInfo['expire_day'],
                    'start_time' => $start_time,
                    'end_time' => $end_time,
                    'apply_range' => $couponInfo['apply_range'],
                    'user_id' => $user_id,
                    'app_id' => $app_id
                ];
            }
        }
        $this->saveAll($data);
        return true;
    }

    /**
     * 验证优惠券是否可领取
     */
    private function checkReceive($user, $coupon)
    {
        if (!$coupon) {
            $this->error = '优惠券不存在';
            return false;
        }
        if (!$coupon->checkReceive()) {
            $this->error = $coupon->getError();
            return false;
        }
        // 验证是否已领取
        $userCouponIds = $this->getUserCouponIds($user['user_id']);
        if (in_array($coupon['coupon_id'], $userCouponIds)) {
            $this->error = '该优惠券已领取';
            return false;
        }
        return true;
    }

    /**
     * 订单结算优惠券列表
     */
    public static function getUserCouponList($user_id, $orderPayPrice)
    {
        //     新增筛选条件: 最低消费金额
        // 获取用户可用的优惠券列表
        $list = (new self)->getList($user_id);
        $data = [];
        foreach ($list as $coupon) {
            // 最低消费金额
            if ($orderPayPrice < $coupon['min_price']) continue;
            // 有效期范围内
            if ($coupon['start_time']['value'] > time()) continue;
            $key = $coupon['user_coupon_id'];
            $data[$key] = [
                'user_coupon_id' => $coupon['user_coupon_id'],
                'name' => $coupon['name'],
                'color' => $coupon['color'],
                'coupon_type' => $coupon['coupon_type'],
                'reduce_price' => $coupon['reduce_price'],
                'discount' => $coupon['discount'],
                'min_price' => $coupon['min_price'],
                'expire_type' => $coupon['expire_type'],
                'start_time' => $coupon['start_time'],
                'end_time' => $coupon['end_time'],
                'expire_day' => $coupon['expire_day'],
                'free_limit' => $coupon['coupon']['free_limit'],
                'apply_range' => $coupon['coupon']['apply_range'],
                'product_ids' => $coupon['coupon']['product_ids'],
                'category_ids' => $coupon['coupon']['category_ids'],
            ];
            // 计算打折金额
            if ($coupon['coupon_type']['value'] == 20) {
                $reducePrice = helper::bcmul($orderPayPrice, $coupon['discount'] / 10);
                $data[$key]['reduced_price'] = bcsub($orderPayPrice, $reducePrice, 2);
            } else
                $data[$key]['reduced_price'] = $coupon['reduce_price'];
        }
        // 根据折扣金额排序并返回
        return array_sort($data, 'reduced_price', true);
    }

    /**
     * @param $user_id int 用户id
     * @param $days int 连续签到天数
     * @param $sign_conf array 签到配置
     * @return int
     */
    public function setCoupon($user_id, $days, $sign_conf)
    {
        $coupon_num = 0;
        $arr = array_column($sign_conf['reward_data'], 'day');
        if (in_array($days, $arr)) {
            $key = array_search($days, $arr);
            if ($sign_conf['reward_data'][$key]['is_coupon'] == 'true') {
                $coupon = $sign_conf['reward_data'][$key]['coupon'];
                $coupon_arr = array_column($coupon, 'coupon_id');
                $coupon_str = implode(',', $coupon_arr);
                $model = new CouponModel();
                $res = $model->getWhereData($coupon_str)->toArray();
                $res_arr = array_column($res, 'coupon_id');
                foreach ($coupon as $key => $val) {
                    $j = array_search($coupon[$key]['coupon_id'], $res_arr);
                    for ($i = 0; $i < $coupon[$key]['num']; $i++) {
                        $coupon_num = $coupon[$key]['num'];
                        $result[] = [
                            'coupon_id' => $res[$j]['coupon_id'],
                            'name' => $res[$j]['name'],
                            'color' => $res[$j]['color']['value'],
                            'coupon_type' => $res[$j]['coupon_type']['value'],
                            'reduce_price' => $res[$j]['reduce_price'],
                            'discount' => $res[$j]['discount'],
                            'min_price' => $res[$j]['min_price'],
                            'expire_type' => $res[$j]['expire_type'],
                            'expire_day' => $res[$j]['expire_day'],
                            'start_time' => $res[$j]['start_time']['value'],
                            'end_time' => $res[$j]['end_time']['value'],
                            'apply_range' => $res[$j]['apply_range'],
                            'user_id' => $user_id,
                            'app_id' => self::$app_id,
                        ];
                    }
                }
                self::saveAll($result);
            }
        }
        return $coupon_num;
    }

}