123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245 |
- <?php
- namespace app\api\model\mj;
- use app\api\model\Goods as GoodsModel;
- use app\api\model\GoodsSku as GoodsSkuModel;
- use app\api\model\ShopGoodsSku;
- use app\common\enum\goods\GoodsType;
- use app\common\enum\order\DeliveryType as DeliveryTypeEnum;
- use app\common\library\helper;
- use app\common\model\mj\MjSendActivity as MjSendActivityModel;
- /**
- * 满件送赠品活动模型
- * @package app\store\model\coupon
- */
- class MjSendActivity extends MjSendActivityModel
- {
- /**
- * 获取列表
- * @param $goodsId
- * @return mixed
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\DbException
- * @throws \think\db\exception\ModelNotFoundException
- */
- public static function validActivity($goodsId)
- {
- // 检索查询条件
- $now = date('Y-m-d H:i:s');
- $filter[] = ['ac.start_time','<',$now];
- $filter[] = ['ac.end_time','>',$now];
- $filter[] = ['ac.audit_status','=',1];
- $filter[] = ['ac.status','=',1];
- $filter[] = ['g.goods_id','=',$goodsId];
- // 执行查询
- $list = self::field('ac.*')
- ->with(['goodsExcept','giftGoods'])
- ->alias('ac')
- ->leftJoin('mj_send_goods g','g.mj_send_activity_id = ac.id')
- ->where($filter)
- ->find();
- // dd(self::getLastSql());
- // dd($list['giftGoods']);
- if (!$list)return null;
- $list = $list->toArray();
- //判断商品还能不能使用活动
- if ($list['goodsExcept']['goods_id']==$goodsId){
- if($list['goodsExcept']['residue_stock']<=0){
- return null;
- }else{
- $mj_props = array_values(array_sort($list['mj_props'], 'value'));
- if($mj_props[0]['value']>$list['goodsExcept']['residue_stock']){
- return null;
- }
- }
- }
- $list['empty_gifts'] = false;//当所有的赠品库存都是0:true
- $giftsGoods = null;
- $count = count($list['giftGoods']);
- foreach ($list['giftGoods'] as $key=>$g){
- if ($g['goods_info']['stock_total'] < 1){
- $count--;
- }else{
- $giftsGoods[] = $g;//库存大于0的才展示这个赠品
- }
- }
- unset($list['giftGoods']);
- if ($count == 0){//
- $list['empty_gifts'] = true;
- }
- $list['gift_goods'] = $giftsGoods;
- $list['remain_secs'] = strtotime($list['end_time']) - time();
- return $list;
- }
- /**
- * 获取确认订单满件送活动赠送商品列表
- * @param $orderGoodList
- * @return mixed
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\DbException
- * @throws \think\db\exception\ModelNotFoundException
- */
- public static function validActivityList(&$orderGoodList,&$order)
- {
- // $order['is_mj_send'] = 0;
- // $order['mj_send_activity_id'] = 0;
- $mjSendGoodList = []; //满件送商品数量列表
- $giveGoodList = [];//满就送+全场满件送+满件送商品数量总和
- // 检索查询条件
- $now = date('Y-m-d H:i:s');
- $filter[] = ['start_time','<',$now];
- $filter[] = ['end_time','>',$now];
- $filter[] = ['status','=',1];
- $filter[] = ['audit_status','=',1];
- // 执行查询
- $lists = self::with(['goodsExcept','giftGoods'])->where($filter)->select();
- if (!$lists) return $mjSendGoodList;
- $lists = $lists->toArray();
- // 整理当前订单所有商品ID集
- $orderGoodsIds = helper::getArrayColumn($orderGoodList, 'goods_id');
- foreach ($orderGoodList as $good){
- $good['is_mj_send'] = 0;
- $good['mj_send_activity_id'] = 0;
- $good['mj_send_num'] = 0;
- $good['mj_send_count'] = 0;
- $good['mj_send_use_count'] = 0;
- $good['mj_send_goods_list'] = [];
- $mjSendGoodList[$good['goods_id']] = 0;
- if($good['goods_type']==GoodsType::GIFT){
- if(isset($giveGoodList[$good['goods_id']])){
- $giveGoodList[$good['goods_id']] += $good['total_num'];
- }else{
- $giveGoodList[$good['goods_id']] = $good['total_num'];
- }
- }
- }
- foreach ($lists as $list){ //循环多个满件送活动
- $exceptGoodsId = $list['goodsExcept']['goods_id'];//每个满件送活动只能选择一个商品
- $goodsIds = array_intersect($orderGoodsIds,[$exceptGoodsId]);
- if(empty($goodsIds)){//如果没有满件送商品,那就终止
- continue;//跳出本次循环
- }
- $is_mj = 0;
- $set_count = 0; //赠送当前几套赠品数量
- $mj_props = array_values(array_sort($list['mj_props'], 'value', true));
- // dd($mj_props);
- // 获取当前商品列表的订单金额
- foreach ($orderGoodList as $good){
- if(in_array($good['goods_id'],$goodsIds)){
- //如果使用了会员折扣又不叠加会员折扣
- if($good['is_user_member']>0 && stripos($list['overlay_type'],'2') !== false){
- continue;
- }
- //如果使用了优惠券又不叠加优惠券
- if($good['coupon_id']>0 && stripos($list['overlay_type'],'1') !== false){
- continue;
- }
- //如果使用了推荐官专属折扣又不叠加专属折扣
- if($good['is_user_distributor']>0 && stripos($list['overlay_type'],'3') !== false){
- continue;
- }
- //使用了N件X折活动并且不能叠加满件送
- if($good['is_activity_discount']==1 && stripos($good['activity_discount_overlay'],'3') === false){
- $is_mj = 1;
- break;//终止循环
- }
- //如果库存没有
- $good_num = $good['total_num'];
- if($list['goodsExcept']['goods_id']==$good['goods_id']){
- if($list['goodsExcept']['residue_stock']<$good['total_num']){
- $good_num = $list['goodsExcept']['residue_stock'];
- }
- }
- if($list['type']==1){
- foreach ($mj_props as $arr){
- if($good_num<$arr['value']){//商品数量小于当前活动满件送的最小数量
- $is_mj = 1;
- break;//终止循环
- }else{
- $set_count = floor($good_num/$arr['value']);
- break;//终止循环
- }
- }
- }else{
- foreach ($mj_props as $arr){
- if($good_num<$arr['value']){//商品数量小于当前活动满件送的最小数量
- continue;
- }else{
- $set_count = $arr['count'];
- break;//终止循环
- }
- }
- }
- $good['is_mj_send'] = 1;
- $good['mj_send_activity_id'] = $list['id'];
- $good['mj_send_num'] = $mj_props[0]['value'];
- $good['mj_send_count'] = $set_count;
- $good['mj_send_use_count'] = $good_num;
- }
- }
- if($is_mj){
- continue;//跳出本次循环
- }
- if(empty($set_count)){//如果没有送的赠品
- continue;//跳出本次循环
- }
- //获取赠送商品ID集
- $giftGoodsIds = helper::getArrayColumn($list['giftGoods'], 'goods_id');
- $model = new GoodsModel;
- $goodsList = $model->getListByIdsFromApi($giftGoodsIds);
- // 隐藏冗余的属性
- $goodsList->hidden(array_merge($model->hidden, ['content', 'goods_images', 'images']));
- // 返回商品处理
- $orderGoodListNew = [];
- foreach ($goodsList as &$item) {
- // 商品sku信息
- $item['skuInfo'] = GoodsSkuModel::detail($item['goods_id'], 0);//赠品都是单规格,sku=0
- // 商品单价
- $item['skuInfo']['goods_price'] = 0.00;
- $item['goods_price'] = $item['skuInfo']['goods_price'];
- $item['goods_type'] = 20;
- // 商品赠送数量
- $item['total_num'] = (int)$set_count;
- // 商品SKU索引
- $item['goods_sku_id'] = $item['skuInfo']['goods_sku_id'];
- // 商品购买总金额
- $item['total_price'] = helper::bcmul($item['goods_price'], 1);
- $item['staffUserId'] = 0;
- $item['shopId'] = 0;
- $item['distributorRadio'] = 0;
- if(isset($giveGoodList[$item['goods_id']])){
- $giveGoodList[$item['goods_id']] += $set_count;
- }else{
- $giveGoodList[$item['goods_id']] = $set_count;
- }
- if($order['delivery'] == DeliveryTypeEnum::SHOPS_DELIVERY){//门店自提
- $ShopGoodsSku = ShopGoodsSku::get(['goods_id'=>$item['goods_id'],'goods_sku_id'=>0,'shop_id'=>$order['shopInfo']['shop_id']]);
- if(!empty($ShopGoodsSku) && $ShopGoodsSku['stock_num'] && $giveGoodList[$item['goods_id']]<=$ShopGoodsSku['stock_num']){//赠品有库存才出现在确认订单,或者赠品库存不足
- $orderGoodListNew[] = $item;
- }
- }else{
- if($item['skuInfo']['stock_num'] && $giveGoodList[$item['goods_id']]<=$item['skuInfo']['stock_num']){//赠品有库存才出现在确认订单
- $orderGoodListNew[] = $item;
- }
- }
- if(in_array($item['goods_id'],$orderGoodsIds)){
- $mjSendGoodList[$item['goods_id']] = $giveGoodList[$item['goods_id']];
- }
- }
- foreach ($orderGoodList as $good){
- if(in_array($good['goods_id'],$goodsIds)){
- $good['mj_send_goods_list'] = $orderGoodListNew;
- }
- }
- }
- return $mjSendGoodList;
- }
- }
|