1], [['limit',], 'default', 'value' => 1000], ]; } public function search() { $query = BusinessCart::find()->where(['saas_id' => $this->saas_id, 'is_delete' => 0]); if($this->store_id > 0){ $query->andWhere(['store_id' => $this->store_id]); } $count = $query->count(); $pagination = new Pagination(['totalCount' => $count, 'page' => $this->page - 1, 'pageSize' => 10000,]); /* @var Cart[] $list */ $list = $query->orderBy('store_id DESC')->limit($pagination->limit)->offset($pagination->offset)->all(); $new_list = []; $mch_list = [];//入驻商的商品 $goods_id_list = []; // 平台购物车商品ids foreach ($list as $item) { $goods = Goods::findOne([ 'id' => $item->goods_id, 'is_delete' => 0, 'status' => 1, ]); if (!$goods) { continue; } $goods_id_list[] = $item->goods_id; $attr_list = Attr::find()->alias('a') ->select('ag.attr_group_name,a.attr_name,') ->leftJoin(['ag' => AttrGroup::tableName()], 'a.attr_group_id=ag.id') ->where(['a.id' => json_decode($item->attr, true)]) ->asArray()->all(); // 门店逻辑 $attr = $goods->attr; $price = $goods->price; $status = $goods->status; $goodsData = [ 'attr' => $attr, 'price' => $price, 'is_level' => $goods->is_level, 'use_attr' => $goods->use_attr, ]; $goods_attr_info = CommonGoods::currentGoodsAttr($goodsData, (array) json_decode($item->attr, true)); $attr_num = intval(empty($goods_attr_info['num']) ? 0 : $goods_attr_info['num']); $goods_pic = isset($goods_attr_info['pic']) && !empty($goods_attr_info['pic']) ? $goods->getGoodsPic(0)->pic_url : $goods->cover_pic; $storeInfo = Store::find()->where(['id'=>$item->store_id,'is_delete'=>0])->asArray()->one(); $price = $goods_attr_info['level_price']; //新人专享活动 $activityAt = ActivityNewUser::activityAt($goods->store_id); $open = false; if ($activityAt) { $goods_ext = ActivityNewUserGoods::findOne(['activity_id' => $activityAt->id, 'goods_id' => $goods->id, 'is_delete' => 0]); if ($goods_ext) { $ext_attrs = json_decode($goods_ext->attr, true); $attr_list_ = json_decode($item->attr, true); foreach($ext_attrs as $ext_attr){ $ext_attr_id = array_column($ext_attr['attr_list'], 'attr_id'); sort($ext_attr_id); sort($attr_list_); //与购物车添加的规格id数组比较 // array_splice($this->attr_list, 0, 1); if (empty(array_diff($ext_attr_id, $attr_list_))) { $ext_price = $ext_attr['price']; $open = true; } } $buy_limit = $activityAt->buy_limit; if ($open) { if ($buy_limit && $buy_limit > 0) { //部分享受优惠 $saas_user = SaasUser::findOne(get_saas_user_id()); if ($saas_user) { $user = User::findOne(['binding' => $saas_user->mobile, 'store_id' => $goods->store_id, 'is_delete' => 0]); if ($user) { $goodsNum = intval(Goods::getBuyNum($user, $goods->id)); $diff_num = $buy_limit - $goodsNum; // 1 只有$diff_num件享受新人价格 if ($diff_num > 0) { $buy_num = $item->num - $diff_num;//1 - 5 if ($buy_num > 0) { $price = ($diff_num * $ext_price) + ($buy_num * $price); } else { $price = $item->num * $ext_price; } } } else { $open = false; } } }else{ //全部享受优惠 $price = $ext_price * $item->num; } // $price = sprintf('%.2f', $price / $item->num); } } } if (!$open) { $price = ($price * $item->num) ?: doubleval(empty($goods_attr_info['price']) ? $goods->price : $goods_attr_info['price']) * $item->num; } $new_item = (object)[ 'cart_id' => $item->id, 'store_id'=> $item->store_id, 'store_name' => (isset($storeInfo['name'])) ? $storeInfo['name'] : '', 'store_logo' => (isset($storeInfo['logo'])) ? $storeInfo['logo'] : '', 'store_business_model' => (isset($storeInfo['business_model'])) ? $storeInfo['business_model'] : '', 'goods_id' => $goods->id, 'goods_name' => $goods->name, 'goods_pic' => $goods_pic, 'num' => $item->num, 'attr_list' => $attr_list, 'price' => (float)$price, 'unitPrice' => doubleval($goods_attr_info['price']), 'max_num' => $attr_num, 'disabled' => ($item->num > $attr_num) ? true : false, 'status' => $status ]; if ($goods->mch_id != 0) { if (!is_array($mch_list['mch_id_' . $goods->mch_id])) { $mch_list['mch_id_' . $goods->mch_id] = []; } $new_item->mch_id = $goods->mch_id; $mch_list['mch_id_' . $goods->mch_id][] = $new_item; } else { $new_list[] = $new_item; } } $new_mch_list = []; foreach ($mch_list as $i => $item) { $mch = Mch::findOne([ 'id' => $item[0]->mch_id, 'is_delete' => 0, 'is_open' => 1, 'is_lock' => 0, ]); if ($mch) { $new_mch_list[] = [ 'id' => $mch->id, 'name' => $mch->name, 'list' => $item, ]; } } // 获取平台可用优惠券 $coupon_list = Coupon::getAllianceList(0, 0, $goods_id_list); // foreach ($new_mch_list as &$value) { // $mch_goods_id_list = []; // foreach ($value['list'] as $v) { // $mch_goods_id_list[] = $v->goods_id; // } // $value['coupon_list'] = Coupon::getList($value['id'], 0, 0, $mch_goods_id_list); // } return [ 'code' => 0, 'msg' => 'success', 'data' => [ 'row_count' => $count, 'page_count' => $pagination->pageCount, 'list' => $new_list, 'mch_list' => $new_mch_list, 'coupon_list' => $coupon_list['list'], ], ]; } public function save() { if ($this->list) { $cart_list = json_decode($this->list, true); foreach ($cart_list as $v) { $form = BusinessCart::find()->where(['store_id' => $this->store_id, 'is_delete' => 0])->where('id=:id', [':id' => $v['cart_id']])->one(); $form->num = $v['num']; $form->save(); } }; if ($this->mch_list) { $mch_list = json_decode($this->mch_list, true); if (is_array($mch_list)) { foreach ($mch_list as $i => $mch) { if (is_array($mch['list'])) { foreach ($mch['list'] as $j => $item) { $cart = BusinessCart::findOne([ 'id' => $item['cart_id'], 'saas_id' => $this->saas_id, ]); if (!$cart) { continue; } $cart->num = intval($item['num']); $cart->save(); } } } } } return [ 'code' => 0, 'msg' => 'success', ]; } }