<?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();
|
}
|
}
|
