<?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;
|
use app\common\model\user\CardRecord as CardRecordModel; // by lyzflash
|
use app\common\model\settings\Setting as SettingModel; // by lyzflash
|
|
/**
|
* 用户优惠券模型
|
*/
|
class UserCoupon extends UserCouponModel
|
{
|
/**
|
* 获取用户优惠券详情
|
*/
|
public static function getDetail($user_coupon_id)
|
{
|
// return (new self)->with(['supplier', 'coupon'])->where('user_coupon_id', '=', $user_coupon_id)->find();
|
$detail = (new static())->with(['supplier', 'coupon'])->find($user_coupon_id);
|
return $detail;
|
}
|
|
/**
|
* 获取用户优惠券列表
|
*/
|
public function getList($user_id, $shop_supplier_id = -1, $is_use = false, $is_expire = false, $coupon_type = 'all',$use_permission=0)
|
{
|
$model = $this;
|
if ($shop_supplier_id != -1) {
|
$model = $model->where('shop_supplier_id', 'in', [0,$shop_supplier_id]);
|
}
|
if ($coupon_type == 'duihuan') {
|
$model = $model->where('coupon_type', '=', 30);
|
}
|
if ($coupon_type == 'daijin') {
|
$model = $model->where('coupon_type', '<>', 30);
|
}
|
if ($use_permission > 0 ) {
|
//排除线上使用或线下使用 by yj 2024.1.16
|
$model = $model->where('use_permission', '<>', $use_permission);
|
}
|
return $model->with(['supplier', '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, $coupon_type = 'all')
|
{
|
$model = $this;
|
$model = $model->where('user_id', '=', $user_id)
|
->where('is_use', '=', 0)
|
->where('is_expire', '=', 0);
|
if ($coupon_type == 'duihuan') {
|
$model = $model->where('coupon_type', '=', 30);
|
}
|
if ($coupon_type == 'daijin') {
|
$model = $model->where('coupon_type', '<>', 30);
|
}
|
return $model->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,
|
// 返还金额
|
'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'],
|
// 适用商品ID
|
'product_ids' => isset($coupon['product_ids']) ? $coupon['product_ids'] : '',
|
'product_image' => isset($coupon['product_image']) ? $coupon['product_image'] : '',
|
// 适用分类ID
|
'category_ids' => isset($coupon['category_ids']) ? $coupon['category_ids'] : '',
|
];
|
// 更新优惠券领取数量
|
$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,
|
'shop_supplier_id' => $coupon['shop_supplier_id'],
|
// 返还金额 by lyzflash
|
'back_money' => $coupon['back_money'],
|
// 兑换券价值金额 by lyzflash
|
'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'],
|
// 使用权限
|
'use_permission' => empty($coupon['use_permission']) ? 0 : $coupon['use_permission'],
|
// 适用商品ID
|
'product_ids' => isset($coupon['product_ids']) ? $coupon['product_ids'] : '',
|
'product_image' => isset($coupon['product_image']) ? $coupon['product_image'] : '',
|
// 适用分类ID
|
'category_ids' => isset($coupon['category_ids']) ? $coupon['category_ids'] : '',
|
];
|
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_id)
|
{
|
$model = new CouponModel();
|
$list = $model->where('coupon_id', 'in', $coupon_ids)->select();
|
$data = [];
|
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_id,
|
'app_id' => self::$app_id,
|
'shop_supplier_id' => $coupon['shop_supplier_id'],
|
// 返还金额 by lyzflash
|
'back_money' => $coupon['back_money'],
|
// 兑换券价值金额 by lyzflash
|
'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'],
|
// 适用商品ID
|
'product_ids' => isset($coupon['product_ids']) ? $coupon['product_ids'] : '',
|
'product_image' => isset($coupon['product_image']) ? $coupon['product_image'] : '',
|
// 适用分类ID
|
'category_ids' => isset($coupon['category_ids']) ? $coupon['category_ids'] : '',
|
];
|
}
|
$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;
|
}
|
// 验证是否仅会员卡会员可领取
|
$config = SettingModel::getItem('store');
|
if ($config['coupon_card_user'] && !CardRecordModel::checkExistByUserId($user['user_id'])) {
|
$this->error = '您需要成为会员卡会员才能领取，请先到会员中心领取会员卡';
|
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, $shop_supplier_id)
|
{
|
// 新增筛选条件: 最低消费金额
|
// 获取用户可用的优惠券列表 (排除 线下使用的优惠券 by yj 2024.1.16)
|
$list = (new self)->getList($user_id, $shop_supplier_id, false,false,'daijin',2); // 排除兑换券 by lyzflash
|
$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');
|
$result = [];
|
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,
|
// 返还金额
|
'back_money' => $res[$j]['back_money'],
|
// 兑换券价值金额
|
'product_price' => $res[$j]['product_price'],
|
// 兑换券使用次数 by lyzflash
|
'total_use_num' => $res[$j]['coupon_type']['value'] == 30 ? $res[$j]['total_use_num'] : 0,
|
'limit_use_num' => $res[$j]['coupon_type']['value'] == 30 ? $res[$j]['total_use_num'] : 0,
|
// 兑换券优惠项目
|
'coupon_project' => $res[$j]['coupon_project'],
|
// 使用规则
|
'coupon_rule' => $res[$j]['coupon_rule'],
|
// 每天核销上限
|
'verify_num' => $res[$j]['verify_num'],
|
// 优惠项目可用数量
|
'project_limit_num' => $res[$j]['project_limit_num'],
|
// 适用范围
|
'use_scope' => $res[$j]['use_scope'],
|
// 适用商品ID
|
'product_ids' => isset($coupon['product_ids']) ? $coupon['product_ids'] : '',
|
'product_image' => isset($coupon['product_image']) ? $coupon['product_image'] : '',
|
// 适用分类ID
|
'category_ids' => isset($coupon['category_ids']) ? $coupon['category_ids'] : '',
|
];
|
}
|
}
|
self::saveAll($result);
|
}
|
}
|
return $coupon_num;
|
}
|
|
}
|
