398 lines
17 KiB
PHP
Executable File
398 lines
17 KiB
PHP
Executable File
<?php
|
||
/**
|
||
* Niushop商城系统 - 团队十年电商经验汇集巨献!
|
||
* =========================================================
|
||
* Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
|
||
* ----------------------------------------------
|
||
* 官方网址: https://www.niushop.com
|
||
* =========================================================
|
||
*/
|
||
|
||
namespace addon\coupon\api\controller;
|
||
|
||
use addon\coupon\model\CouponType as CouponTypeModel;
|
||
use app\api\controller\BaseApi;
|
||
use addon\coupon\model\Coupon as CouponModel;
|
||
use addon\coupon\model\MemberCoupon;
|
||
use think\facade\Db;
|
||
|
||
/**
|
||
* 优惠券
|
||
*/
|
||
class Coupon extends BaseApi
|
||
{
|
||
|
||
/**
|
||
* 优惠券类型信息
|
||
*/
|
||
public function typeinfo()
|
||
{
|
||
$coupon_type_id = $this->params[ 'coupon_type_id' ] ?? 0;
|
||
if (empty($coupon_type_id)) {
|
||
return $this->response($this->error('', 'REQUEST_COUPON_TYPE_ID'));
|
||
}
|
||
|
||
$app_type = $this->params[ 'app_type' ] ?? 'h5';
|
||
|
||
$coupon_model = new CouponModel();
|
||
$condition = [
|
||
[ 'coupon_type_id', '=', $coupon_type_id ],
|
||
// [ 'is_show', '=', 1 ],
|
||
[ 'site_id', '=', $this->site_id ]
|
||
];
|
||
|
||
$coupon_type_model = new CouponTypeModel();
|
||
$qrcode = $coupon_type_model->qrcode($coupon_type_id, $app_type, $this->site_id)[ 'data' ];
|
||
|
||
$info = $coupon_model->getCouponTypeInfo($condition);
|
||
if (!empty($info[ 'data' ])) {
|
||
$info[ 'data' ] = $coupon_type_model->getCouponSubData($info[ 'data' ]);
|
||
}
|
||
|
||
if (!empty($info[ 'data' ]) && !empty($qrcode)) {
|
||
$info[ 'data' ][ 'qrcode' ] = $qrcode[ 'path' ];
|
||
}
|
||
return $this->response($info);
|
||
}
|
||
|
||
/**
|
||
* 列表信息
|
||
*/
|
||
public function memberpage()
|
||
{
|
||
$token = $this->checkToken();
|
||
if ($token[ 'code' ] < 0) return $this->response($token);
|
||
|
||
$page = $this->params[ 'page' ] ?? 1;
|
||
$page_size = $this->params[ 'page_size' ] ?? PAGE_LIST_ROWS;
|
||
$state = $this->params[ 'state' ] ?? 1;//优惠券状态 1已领用（未使用） 2已使用 3已过期
|
||
|
||
$coupon_model = new CouponModel();
|
||
$condition = [
|
||
[ 'npc.member_id', '=', $token[ 'data' ][ 'member_id' ] ],
|
||
[ 'npc.state', '=', $state ]
|
||
];
|
||
|
||
//按类型筛选
|
||
$type = $this->params[ 'type' ] ?? '';
|
||
$related_id = $this->params[ 'related_id' ] ?? 0;
|
||
switch ($type) {
|
||
case 'reward'://满减
|
||
$condition[] = [ 'npc.type', '=', 'reward' ];
|
||
break;
|
||
case 'discount'://折扣
|
||
$condition[] = [ 'npc.type', '=', 'discount' ];
|
||
break;
|
||
case 'no_threshold'://无门槛
|
||
$condition[] = [ 'npc.at_least', '=', 0 ];
|
||
break;
|
||
}
|
||
if (!empty($related_id)) {
|
||
$condition[] = [ 'related_id', '=', $related_id ];
|
||
}
|
||
|
||
$list = $coupon_model->getMemberCouponPageList($condition, $page, $page_size);
|
||
$coupon_type_model = new CouponTypeModel();
|
||
foreach ($list[ 'data' ][ 'list' ] as &$val) {
|
||
$val = $coupon_type_model->getCouponSubData($val);
|
||
}
|
||
return $this->response($list);
|
||
}
|
||
|
||
/**
|
||
* 优惠券类型列表
|
||
*/
|
||
public function typelists()
|
||
{
|
||
$num = $this->params[ 'num' ] ?? 0;
|
||
$coupon_type_id_arr = $this->params[ 'coupon_type_id_arr' ] ?? '';//coupon_type_id数组
|
||
$can_receive = $this->params[ 'can_receive' ] ?? 0;// 是否只查询可领取的
|
||
|
||
$token = $this->checkToken();
|
||
|
||
$coupon_model = new CouponModel();
|
||
$condition = [
|
||
[ 'status', '=', 1 ],
|
||
[ 'is_show', '=', 1 ],
|
||
[ 'site_id', '=', $this->site_id ]
|
||
];
|
||
|
||
//按类型查询
|
||
$type = $this->params[ 'type' ] ?? '';
|
||
switch ($type) {
|
||
case 'reward'://满减
|
||
$condition[] = [ 'type', '=', 'reward' ];
|
||
break;
|
||
case 'discount'://折扣
|
||
$condition[] = [ 'type', '=', 'discount' ];
|
||
break;
|
||
case 'no_threshold'://无门槛
|
||
$condition[] = [ 'at_least', '=', 0 ];
|
||
break;
|
||
}
|
||
|
||
if (!empty($coupon_type_id_arr)) {
|
||
$condition[] = [ 'coupon_type_id', 'in', $coupon_type_id_arr ];
|
||
}
|
||
$field = 'coupon_type_id,type,site_id,coupon_name,money,discount,max_fetch,at_least,end_time,image,validity_type,fixed_term,status,is_show,goods_type,discount_limit,count,lead_count,IF(count < 0 or count - lead_count > 0, 1, 0) as is_remain,use_channel, use_store';
|
||
if ($can_receive == 1) {
|
||
$condition[] = [ [ 'count', '<>', Db::raw('lead_count') ] ];
|
||
}
|
||
|
||
if ($this->member_id) {
|
||
$prefix = config('database.connections.mysql.prefix');
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ' . $prefix . 'promotion_coupon_type.coupon_type_id and pc.get_type=2 and pc.member_id=' . $this->member_id . ') as member_coupon_num'; //已领取优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ' . $prefix . 'promotion_coupon_type.coupon_type_id and pc.state = 2 and pc.member_id=' . $this->member_id . ') as use_coupon_num';//已使用优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ' . $prefix . 'promotion_coupon_type.coupon_type_id and pc.state = 1 and pc.member_id=' . $this->member_id . ') as wait_coupon_num'; //待使用优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ' . $prefix . 'promotion_coupon_type.coupon_type_id and pc.state > 2 and pc.member_id=' . $this->member_id . ') as lose_coupon_num'; //已失效优惠券数量(过期,关闭)
|
||
}
|
||
|
||
$order = Db::raw('IF(count < 0 or count - lead_count > 0, 1, 0) DESC,sort ASC');
|
||
$coupon_type_model = new CouponTypeModel();
|
||
$list = $coupon_model->getCouponTypeList($condition, $field, $order, $num);
|
||
if (!empty($list[ 'data' ])) {
|
||
if ($this->member_id) {
|
||
foreach ($list[ 'data' ] as &$val) {
|
||
|
||
// 有效期设置为领取之日起时，检测会员领取的优惠券是否全部过期
|
||
if ($this->member_id && $val[ 'validity_type' ] == 1 && !empty($val[ 'member_coupon_num' ]) && $val[ 'member_coupon_num' ] > 0) {
|
||
if (empty($val['wait_coupon_num'])) {
|
||
$val[ 'received_type' ] = 'expire'; // 已过期
|
||
}
|
||
}
|
||
|
||
// 检测是否全部使用
|
||
if($this->member_id && !empty($val[ 'use_coupon_num' ]) && $val[ 'use_coupon_num' ] >= $val[ 'max_fetch' ]){
|
||
$val[ 'received_type' ] = 'use_out'; //已全部使用
|
||
}
|
||
|
||
}
|
||
}
|
||
foreach ($list[ 'data' ] as &$v) {
|
||
$v = $coupon_type_model->getCouponSubData($v);
|
||
}
|
||
}
|
||
|
||
|
||
return $this->response($list);
|
||
}
|
||
|
||
/**
|
||
* 优惠券类型分页列表
|
||
*/
|
||
public function typepagelists()
|
||
{
|
||
$page = $this->params[ 'page' ] ?? 1;
|
||
$page_size = $this->params[ 'page_size' ] ?? PAGE_LIST_ROWS;
|
||
$coupon_type_id_arr = $this->params[ 'coupon_type_id_arr' ] ?? '';//coupon_type_id数组
|
||
$can_receive = $this->params[ 'can_receive' ] ?? 0;// 是否只查询可领取的
|
||
|
||
$token = $this->checkToken();
|
||
|
||
$coupon_model = new CouponModel();
|
||
$condition = [
|
||
[ 'status', '=', 1 ],
|
||
[ 'is_show', '=', 1 ],
|
||
[ 'site_id', '=', $this->site_id ]
|
||
];
|
||
|
||
//按类型查询
|
||
$type = $this->params[ 'type' ] ?? '';
|
||
switch ($type) {
|
||
case 'reward'://满减
|
||
$condition[] = [ 'type', '=', 'reward' ];
|
||
break;
|
||
case 'discount'://折扣
|
||
$condition[] = [ 'type', '=', 'discount' ];
|
||
break;
|
||
case 'no_threshold'://无门槛
|
||
$condition[] = [ 'at_least', '=', 0 ];
|
||
break;
|
||
}
|
||
|
||
if (!empty($coupon_type_id_arr)) {
|
||
$condition[] = [ 'coupon_type_id', 'in', $coupon_type_id_arr ];
|
||
}
|
||
$field = 'coupon_type_id,type,site_id,coupon_name,money,discount,max_fetch,at_least,end_time,image,validity_type,fixed_term,status,is_show,goods_type,discount_limit,count,lead_count,IF(count < 0 or count - lead_count > 0, 1, 0) as is_remain,use_channel, use_store';
|
||
if ($can_receive == 1) {
|
||
$condition[] = [ [ 'count', '<>', Db::raw('lead_count') ] ];
|
||
}
|
||
|
||
if ($this->member_id) {
|
||
$prefix = config('database.connections.mysql.prefix');
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ct.coupon_type_id and pc.get_type=2 and pc.member_id=' . $this->member_id . ') as member_coupon_num'; //已领取优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ct.coupon_type_id and pc.state = 2 and pc.member_id=' . $this->member_id . ') as use_coupon_num';//已使用优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ct.coupon_type_id and pc.state = 1 and pc.member_id=' . $this->member_id . ') as wait_coupon_num'; //待使用优惠券数量
|
||
$field .= ', (select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = ct.coupon_type_id and pc.state > 2 and pc.member_id=' . $this->member_id . ') as lose_coupon_num'; //已失效优惠券数量(过期,关闭)
|
||
}
|
||
|
||
$order = Db::raw('IF(count < 0 or count - lead_count > 0, 1, 0) DESC,create_time desc');
|
||
|
||
$list = $coupon_model->getCouponTypePageList($condition, $page, $page_size, $order, $field, 'ct');
|
||
$coupon_type_model = new CouponTypeModel();
|
||
foreach ($list[ 'data' ][ 'list' ] as &$val) {
|
||
$val = $coupon_type_model->getCouponSubData($val);
|
||
//$val[ 'received_type' ] = '';
|
||
// 有效期设置为领取之日起时，检测会员领取的优惠券是否全部过期
|
||
if ($this->member_id && $val[ 'validity_type' ] == 1 && !empty($val[ 'member_coupon_num' ]) && $val[ 'member_coupon_num' ] > 0) {
|
||
if (empty($val['wait_coupon_num'])) {
|
||
$val[ 'received_type' ] = 'expire'; // 已过期
|
||
}
|
||
}
|
||
|
||
// 检测是否全部使用
|
||
if($this->member_id && !empty($val[ 'use_coupon_num' ]) && $val[ 'use_coupon_num' ] >= $val[ 'max_fetch' ]){
|
||
$val[ 'received_type' ] = 'use_out'; //已全部使用
|
||
}
|
||
}
|
||
return $this->response($list);
|
||
}
|
||
|
||
/**
|
||
* 获取优惠券
|
||
*/
|
||
public function receive()
|
||
{
|
||
$token = $this->checkToken();
|
||
if ($token[ 'code' ] < 0) return $this->response($token);
|
||
|
||
$site_id = $this->site_id;
|
||
$coupon_type_id = $this->params[ 'coupon_type_id' ] ?? 0;
|
||
$get_type = $this->params[ 'get_type' ] ?? 2;//获取方式:1订单2.直接领取3.活动领取
|
||
|
||
if (empty($coupon_type_id)) {
|
||
return $this->response($this->error('', 'REQUEST_COUPON_TYPE_ID'));
|
||
}
|
||
|
||
$coupon_model = new CouponModel();
|
||
$res = $coupon_model->giveCoupon([['coupon_type_id' => $coupon_type_id, 'num' => 1]], $site_id, $this->member_id, CouponModel::GET_TYPE_MEMBER_LEAD);
|
||
|
||
//判断一下用户是否拥有当前优惠券
|
||
$coupon = $coupon_model->getCouponInfo([ [ 'coupon_type_id', '=', $coupon_type_id ], [ 'site_id', '=', $site_id ], [ 'member_id', '=', $this->member_id ] ], 'coupon_id')[ 'data' ];
|
||
$res[ 'data' ] = [];
|
||
$res[ 'data' ][ 'is_exist' ] = empty($coupon) ? 0 : 1;
|
||
return $this->response($res);
|
||
}
|
||
|
||
/**
|
||
* 会员优惠券数量
|
||
* @return string
|
||
*/
|
||
public function num()
|
||
{
|
||
$token = $this->checkToken();
|
||
if ($token[ 'code' ] < 0) return $this->response($token);
|
||
|
||
$state = $this->params[ 'state' ] ?? 1;
|
||
$coupon_model = new MemberCoupon();
|
||
|
||
$count = $coupon_model->getMemberCouponNum($this->member_id, $state);
|
||
return $this->response($count);
|
||
}
|
||
|
||
/**
|
||
* 是否可以领取
|
||
*/
|
||
public function receivedNum()
|
||
{
|
||
$token = $this->checkToken();
|
||
if ($token[ 'code' ] < 0) return $this->response($token);
|
||
|
||
$coupon_type_id = $this->params[ 'coupon_type_id' ] ?? 0;
|
||
|
||
$coupon_model = new MemberCoupon();
|
||
$res = $coupon_model->receivedNum($coupon_type_id, $this->member_id);
|
||
return $this->response($res);
|
||
}
|
||
|
||
/**
|
||
* 查询商品可用的优惠券
|
||
* @param int $id
|
||
* @return false|string
|
||
*/
|
||
public function goodsCoupon($id = 0)
|
||
{
|
||
$this->checkToken();
|
||
$coupon_model = new CouponModel();
|
||
$goods_id = $this->params[ 'goods_id' ] ?? 0;
|
||
if (!empty($id)) {
|
||
$goods_id = $id;
|
||
}
|
||
|
||
// 查询全部商品参与
|
||
$condition = [
|
||
[ 'site_id', '=', $this->site_id ],
|
||
[ 'status', '=', 1 ],
|
||
[ 'is_show', '=', 1 ],
|
||
[ 'goods_type', '=', 1 ]
|
||
];
|
||
|
||
$field = 'count,lead_count,coupon_type_id,coupon_type_id as type_id,type,site_id,coupon_name,money,discount,max_fetch,at_least,end_time,validity_type,fixed_term,goods_type,discount_limit,use_channel, use_store';
|
||
|
||
if ($this->member_id) {
|
||
$prefix = config('database.connections.mysql.prefix');
|
||
$field .= ',(select count(coupon_id) from ' . $prefix . 'promotion_coupon pc where pc.coupon_type_id = type_id and pc.get_type=2 and pc.member_id=' . $this->member_id . ') as member_coupon_num';
|
||
}
|
||
|
||
$list = $coupon_model->getCouponTypeList($condition, $field, 'money desc', null, 'ct');
|
||
|
||
// 查询指定商品参与
|
||
$goods_condition = [
|
||
[ 'site_id', '=', $this->site_id ],
|
||
[ 'status', '=', 1 ],
|
||
[ 'is_show', '=', 1 ],
|
||
[ 'goods_type', '=', 2 ],
|
||
[ 'goods_ids', 'like', "%,$goods_id,%" ]
|
||
];
|
||
|
||
$goods_coupon = $coupon_model->getCouponTypeList($goods_condition, $field, 'money desc', null, 'ct');
|
||
|
||
if (!empty($goods_coupon[ 'data' ])) {
|
||
$list[ 'data' ] = array_merge($list[ 'data' ], $goods_coupon[ 'data' ]);
|
||
}
|
||
|
||
// 查询指定商品不参与
|
||
$not_goods_condition = [
|
||
[ 'site_id', '=', $this->site_id ],
|
||
[ 'status', '=', 1 ],
|
||
[ 'is_show', '=', 1 ],
|
||
[ 'goods_type', '=', 3 ],
|
||
[ 'goods_ids', 'not like', "%,$goods_id,%" ]
|
||
];
|
||
|
||
$not_goods_coupon = $coupon_model->getCouponTypeList($not_goods_condition, $field, 'money desc', null, 'ct');
|
||
if (!empty($not_goods_coupon[ 'data' ])) {
|
||
$list[ 'data' ] = array_merge($list[ 'data' ], $not_goods_coupon[ 'data' ]);
|
||
}
|
||
|
||
if ($list[ 'data' ] && $this->member_id) {
|
||
foreach ($list[ 'data' ] as $k => $v) {
|
||
// 已抢光
|
||
if ($v[ 'count' ] == $v[ 'lead_count' ]) {
|
||
unset($list[ 'data' ][ $k ]);
|
||
} elseif ($v[ 'max_fetch' ] != 0 && $v[ 'member_coupon_num' ] > 0 && $v[ 'member_coupon_num' ] >= $v[ 'max_fetch' ]) {
|
||
// 已领取
|
||
unset($list[ 'data' ][ $k ]);
|
||
}
|
||
}
|
||
$list[ 'data' ] = array_values($list[ 'data' ]);
|
||
}
|
||
return $this->response($list);
|
||
}
|
||
|
||
/**
|
||
* 查询优惠券通过优惠券类型id
|
||
*/
|
||
public function couponById()
|
||
{
|
||
$id = $this->params[ 'id' ] ?? 0;
|
||
$coupon_model = new CouponModel();
|
||
$condition = [
|
||
[ 'site_id', '=', $this->site_id ],
|
||
[ 'status', '=', 1 ],
|
||
[ 'coupon_type_id', 'in', $id ]
|
||
];
|
||
$list = $coupon_model->getCouponTypeList($condition, 'coupon_type_id,type,site_id,coupon_name,money,discount,max_fetch,at_least,end_time,validity_type,fixed_term,goods_type,discount_limit,use_channel, use_store', 'money desc', '');
|
||
return $this->response($list);
|
||
}
|
||
} |