* @day: 2017/12/18 */ namespace app\models\store; use app\models\system\SystemGroupDataMerchant; use app\models\system\SystemProductStore; use crmeb\basic\BaseModel; use crmeb\traits\ModelTrait; use think\db\exception\DataNotFoundException; use think\db\exception\DbException; use think\db\exception\ModelNotFoundException; /** * TODO 购物车Model * Class StoreCart * @package app\models\store */ class StoreCart extends BaseModel { /** * 数据表主键 * @var string */ protected $pk = 'id'; /** * 模型名称 * @var string */ protected $name = 'store_cart'; use ModelTrait; protected $insert = ['add_time']; protected function setAddTimeAttr() { return time(); } public static function setCart($uid, $product_id, $cart_num = 1, $product_attr_unique = '', $type = 'product', $is_new = 0, $assistance_id = 0, $combination_id = 0, $seckill_id = 0, $bargain_id = 0, $mer_id = false) { if ($cart_num < 1) $cart_num = 1; if ($seckill_id) { if (!StoreSeckill::isSeckillEnd($seckill_id, $mer_id)) return self::setErrorInfo('活动已结束'); $StoreSeckillinfo = StoreSeckill::getValidProduct($seckill_id, $mer_id); if (!$StoreSeckillinfo) return self::setErrorInfo('该商品已下架或删除'); $userbuycount = StoreOrder::merSet($mer_id)->where('uid', $uid)->where('paid', 1)->where('seckill_id', $seckill_id)->count(); if ($StoreSeckillinfo['num'] <= $userbuycount || $StoreSeckillinfo['num'] < $cart_num) return self::setErrorInfo('每人限购' . $StoreSeckillinfo['num'] . '件'); $res = StoreProductAttrValue::where('product_id', $seckill_id)->where('unique', $product_attr_unique)->where('type', 1)->field('suk,quota')->find(); if ($cart_num > $res['quota']) return self::setErrorInfo('该商品库存不足' . $cart_num); $product_stock = StoreProductAttrValue::where('product_id', $StoreSeckillinfo['product_id'])->where('suk', $res['suk'])->where('type', 0)->value('stock'); if ($product_stock < $cart_num) return self::setErrorInfo('该商品库存不足' . $cart_num); } elseif ($bargain_id) { if (!StoreBargain::validBargain($bargain_id)) return self::setErrorInfo('该商品已下架或删除'); $StoreBargainInfo = StoreBargain::getBargain($bargain_id); $res = StoreProductAttrValue::where('product_id', $bargain_id)->where('type', 2)->field('suk,quota')->find(); if ($cart_num > $res['quota']) return self::setErrorInfo('该商品库存不足' . $cart_num); $product_stock = StoreProductAttrValue::where('product_id', $StoreBargainInfo['product_id'])->where('suk', $res['suk'])->where('type', 0)->value('stock'); if ($product_stock < $cart_num) return self::setErrorInfo('该商品库存不足' . $cart_num); } elseif ($combination_id) {//拼团 $StoreCombinationInfo = StoreCombination::getCombinationOne($combination_id); if (!$StoreCombinationInfo) return self::setErrorInfo('该商品已下架或删除'); $userbuycount = StoreOrder::merSet($mer_id)->where('uid', $uid)->where('paid', 1)->where('combination_id', $combination_id)->count(); // if ($StoreCombinationInfo['num'] <= $userbuycount || $StoreCombinationInfo['num'] < $cart_num) // return self::setErrorInfo('每人限购' . $StoreCombinationInfo['num'] . '件'); $res = StoreProductAttrValue::where('product_id', $combination_id)->where('unique', $product_attr_unique)->where('type', 3)->field('suk,quota')->find(); if ($cart_num > $res['quota']) return self::setErrorInfo('该商品库存不足' . $cart_num); $product_stock = StoreProductAttrValue::where('product_id', $StoreCombinationInfo['product_id'])->where('suk', $res['suk'])->where('type', 0)->value('stock'); if ($product_stock < $cart_num) return self::setErrorInfo('该商品库存不足' . $cart_num); } elseif (isset($assistance_id) && $assistance_id) {//助力 $StoreAssistanceInfo = StoreAssistance::getAssistanceOne($assistance_id); if (!$StoreAssistanceInfo) return self::setErrorInfo('该商品已下架或删除'); $res = StoreProductAttrValue::where('product_id', $assistance_id)->where('unique', $product_attr_unique)->where('type', 4)->field('suk,quota')->find(); if ($cart_num > $res['quota']) return self::setErrorInfo('该商品库存不足' . $cart_num); $product_stock = StoreProductAttrValue::where('product_id', $StoreAssistanceInfo['product_id'])->where('suk', $res['suk'])->where('type', 0)->value('stock'); if ($product_stock < $cart_num) return self::setErrorInfo('该商品库存不足' . $cart_num); } else { if (StoreProduct::isValidOneProduct($product_id, $mer_id)){ $userbuycount = StoreOrder::getOrderProductCount($uid, $product_id, $mer_id); if ($userbuycount >= 1 || $cart_num > 1) return self::setErrorInfo('此商品限购1件'); }else if (!StoreProduct::isValidProduct($product_id, $mer_id)) return self::setErrorInfo('该商品已下架或删除'); if (!StoreProductAttr::issetProductUnique($product_id, $product_attr_unique)) return self::setErrorInfo('请选择有效的商品属性'); if (StoreProduct::getProductStock($product_id, $product_attr_unique) < $cart_num) return self::setErrorInfo('该商品库存不足' . $cart_num); } if ($cart = self::where('type', $type)->where('uid', $uid)->where('product_id', $product_id)->where('product_attr_unique', $product_attr_unique)->where('is_new', $is_new)->where('is_pay', 0)->where('is_del', 0)->where('assistance_id', $assistance_id)->where('combination_id', $combination_id)->where('bargain_id', $bargain_id)->where('seckill_id', $seckill_id)->find()) { if ($is_new) $cart->cart_num = $cart_num; else $cart->cart_num = bcadd($cart_num, $cart->cart_num, 0); $cart->add_time = time(); $cart->save(); return $cart; } else { $add_time = time(); return self::create(compact('uid', 'product_id', 'cart_num', 'product_attr_unique', 'is_new', 'type', 'assistance_id', 'combination_id', 'add_time', 'bargain_id', 'seckill_id')); } } public static function removeUserCart($uid, $ids) { return self::where('uid', $uid)->where('id', 'IN', implode(',', $ids))->update(['is_del' => 1]); } public static function getUserCartNum($uid, $type, $numType) { if ($numType) { return self::where('uid', $uid)->where('type', $type)->where('is_pay', 0)->where('is_del', 0)->where('is_new', 0)->count(); } else { return self::where('uid', $uid)->where('type', $type)->where('is_pay', 0)->where('is_del', 0)->where('is_new', 0)->sum('cart_num'); } } /** * TODO 修改购物车库存 * @param $cartId * @param $cartNum * @param $uid * @param bool $mer_id * @return StoreCart|bool * @throws DataNotFoundException * @throws DbException * @throws ModelNotFoundException */ public static function changeUserCartNum($cartId, $cartNum, $uid, $mer_id = false) { $count = self::where('uid', $uid)->where('id', $cartId)->count(); if (!$count) return self::setErrorInfo('参数错误'); $cartInfo = self::where('uid', $uid)->where('id', $cartId)->field('product_id,combination_id,seckill_id,bargain_id,product_attr_unique,cart_num')->find()->toArray(); $stock = 0; if ($cartInfo['bargain_id']) { //TODO 获取砍价商品的库存 $stock = 0; } else if ($cartInfo['seckill_id']) { //TODO 获取秒杀商品的库存 $stock = 0; } else if ($cartInfo['combination_id']) { //TODO 获取拼团商品的库存 $stock = 0; } else if ($cartInfo['product_id']) { //TODO 获取普通商品的库存 $stock = StoreProduct::getProductStock($cartInfo['product_id'], $cartInfo['product_attr_unique'], $mer_id); } if (!$stock) return self::setErrorInfo('暂无库存'); if (!$cartNum) return self::setErrorInfo('库存错误'); if ($stock < $cartNum) return self::setErrorInfo('库存不足' . $cartNum); if ($cartInfo['cart_num'] == $cartNum) return true; return self::where('uid', $uid)->where('id', $cartId)->update(['cart_num' => $cartNum]); } /** * 优化新方法 * @param $uid * @param string $cartIds * @param int $status * @param bool $mer_id * @return mixed * @throws DataNotFoundException * @throws DbException * @throws ModelNotFoundException */ public static function getUserProductCartListV1($uid, $cartIds = '', $status = 0, $mer_id = false) { $productInfoField = 'id,image,price,ot_price,vip_price,postage,give_integral,sales,stock,store_name,unit_name,is_show,is_del,is_postage,cost,is_sub,temp_id,is_ban,is_alone,delivery'; $seckillInfoField = 'id,image,price,ot_price,postage,give_integral,sales,stock,title as store_name,unit_name,is_show,is_del,is_postage,cost,temp_id,weight,volume,start_time,stop_time,time_id'; $bargainInfoField = 'id,image,min_price as price,price as ot_price,postage,give_integral,sales,stock,title as store_name,unit_name,status as is_show,is_del,is_postage,cost,temp_id,weight,volume'; $combinationInfoField = 'id,image,price,postage,sales,stock,title as store_name,is_show,is_del,is_postage,cost,temp_id,weight,volume'; $assistanceInfoField = 'id,image,price,postage,sales,stock,title as store_name,is_show,is_del,is_postage,cost,temp_id,weight,volume'; $model = new self(); $valid = $invalid = []; $model = $model->where('uid', $uid)->where('type', 'product')->where('is_pay', 0) ->where('is_del', 0); if (!$status) $model = $model->where('is_new', 0); if ($cartIds) $model = $model->where('id', 'IN', $cartIds); $model = $model->order('add_time DESC'); $list = $model->select()->toArray(); if (!count($list)) return compact('valid', 'invalid'); $now = time(); $seckillProduct = []; $bargainProduct = []; $combinationProduct = []; $product_all = []; $systemGroupDataMerchant = []; $seckill_ids = array_unique(array_column($list, 'seckill_id')); if (!empty($seckill_ids)) { $seckillProduct = StoreSeckill::merSet($mer_id)->field($seckillInfoField)->where('id', 'in', $seckill_ids)->select()->toArray(); if (!empty($seckillProduct)) { $time_ids = array_unique(array_column($seckillProduct, 'time_id')); $seckillProduct = array_combine(array_column($seckillProduct, 'id'), $seckillProduct); if (!empty($time_ids)) { $systemGroupDataMerchant = SystemGroupDataMerchant::where('id', 'in', $time_ids)->select()->toArray(); if (!empty($systemGroupDataMerchant)) $systemGroupDataMerchant = array_combine(array_column($systemGroupDataMerchant, 'id'), $systemGroupDataMerchant); } } } $bargain_ids = array_unique(array_column($list, 'bargain_id')); if (!empty($bargain_ids)) { $bargainProduct = StoreBargain::merSet($mer_id)->field($bargainInfoField)->where('id', 'in', $bargain_ids)->select()->toArray(); if (!empty($bargainProduct)) $bargainProduct = array_combine(array_column($bargainProduct, 'id'), $bargainProduct); } $combination_ids = array_unique(array_column($list, 'combination_id')); if (!empty($combination_ids)) { $combinationProduct = StoreCombination::merSet($mer_id)->field($combinationInfoField)->where('id', 'in', $combination_ids)->select()->toArray(); if (!empty($combinationProduct)) $combinationProduct = array_combine(array_column($combinationProduct, 'id'), $combinationProduct); } $assistance_ids = array_unique(array_column($list, 'assistance_id')); if (!empty($assistance_ids)) { $assistanceProduct = StoreAssistance::merSet($mer_id)->field($assistanceInfoField)->where('id', 'in', $assistance_ids)->select()->toArray(); if (!empty($assistanceProduct)) $assistanceProduct = array_combine(array_column($assistanceProduct, 'id'), $assistanceProduct); } $product_ids = array_unique(array_column($list, 'product_id')); if (!empty($product_ids)) { $product_all = StoreProduct::merSet($mer_id)->field($productInfoField)->where('id', 'in', $product_ids)->select()->toArray(); if (!empty($product_all)) $product_all = array_combine(array_column($product_all, 'id'), $product_all); } $deduction = ['seckill_id' => $seckill_ids, 'bargain_id' => $bargain_ids, 'combination_id' => $combination_ids, 'assistance_id' => $assistance_ids]; //商品属性 $product_attr_all = []; $attr_unique_s = array_unique(array_column($list, 'product_attr_unique')); if (!empty($attr_unique_s)) { $product_attr_all = StoreProductAttr::uniqueByAttrInfoMore($attr_unique_s); if (!empty($product_attr_all)) $product_attr_all = array_combine(array_column($product_attr_all, 'unique'), $product_attr_all); } //需要删除id集合 $del_array = []; foreach ($list as $k => $cart) { if ($cart['seckill_id']) { $product = isset($seckillProduct[$cart['seckill_id']]) && !empty($seckillProduct[$cart['seckill_id']]) ? $seckillProduct[$cart['seckill_id']] : []; } elseif ($cart['bargain_id']) { $product = isset($bargainProduct[$cart['bargain_id']]) && !empty($bargainProduct[$cart['bargain_id']]) ? $bargainProduct[$cart['bargain_id']] : []; } elseif ($cart['combination_id']) { $product = isset($combinationProduct[$cart['combination_id']]) && !empty($combinationProduct[$cart['combination_id']]) ? $combinationProduct[$cart['combination_id']] : []; } elseif ($cart['assistance_id']) { $product = isset($assistanceProduct[$cart['assistance_id']]) && !empty($assistanceProduct[$cart['assistance_id']]) ? $assistanceProduct[$cart['assistance_id']] : []; } else { $product = isset($product_all[$cart['product_id']]) && !empty($product_all[$cart['product_id']]) ? $product_all[$cart['product_id']] : []; } $product['image'] = set_file_url($product['image']); $cart['productInfo'] = $product; //商品不存在 if (!$product) { $del_array[] = $cart['id']; //商品删除或无库存 } else if (!$product['is_show'] || $product['is_del'] || !$product['stock']) { $invalid[] = $cart; //秒杀商品未开启或者已结束 } else if ($cart['seckill_id'] && ($product['start_time'] > $now || $product['stop_time'] < $now - 86400)) { $invalid[] = $product; //商品属性不对应 } else if (!StoreProductAttr::issetProductUnique($cart['product_id'], $cart['product_attr_unique']) && !$cart['assistance_id'] && !$cart['combination_id'] && !$cart['seckill_id'] && !$cart['bargain_id']) { $invalid[] = $cart; //正常商品 } else { if ($cart['seckill_id']) { $config = isset($systemGroupDataMerchant[$product['time_id']]) && !empty($systemGroupDataMerchant[$product['time_id']]) ? $systemGroupDataMerchant[$product['time_id']] : []; if ($config) { $arr = json_decode($config['value'], true); $now_hour = date('H', time()); $start_hour = $arr['time']['value']; $continued = $arr['continued']['value']; $end_hour = $start_hour + $continued; if ($start_hour > $now_hour) { //'活动未开启'; $invalid[] = $cart; continue; } elseif ($end_hour < $now_hour) { //'活动已结束'; $invalid[] = $cart; continue; } } } if(isset($product['is_alone'])) $cart['is_alone'] = $product['is_alone']; if(isset($product['delivery'])) $cart['delivery'] = $product['delivery']; $cart['store_id'] = SystemProductStore::alias('a')->where('a.product_id', $product['id'])->join('system_store s', 'a.store_id = s.id')->column('store_id'); $cart['tip'] = 0; if ($cart['product_attr_unique']) { $attrInfo = isset($product_attr_all[$cart['product_attr_unique']]) && !empty($product_attr_all[$cart['product_attr_unique']]) ? $product_attr_all[$cart['product_attr_unique']] : []; //商品没有对应的属性 if (!$attrInfo || !$attrInfo['stock']) $invalid[] = $cart; else { $cart['productInfo']['attrInfo'] = $attrInfo; if ($cart['assistance_id'] || $cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id']) { $cart['truePrice'] = $attrInfo['price']; $cart['vip_truePrice'] = 0; } else { $cart['truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid, true, $mer_id); $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid, false, $mer_id); } $cart['trueStock'] = $attrInfo['stock']; $cart['costPrice'] = $attrInfo['cost']; $cart['productInfo']['image'] = empty($attrInfo['image']) ? $cart['productInfo']['image'] : $attrInfo['image']; $valid[] = $cart; } } else { if ($cart['assistance_id'] || $cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id']) { $cart['truePrice'] = $cart['productInfo']['price']; $cart['vip_truePrice'] = 0; if ($cart['bargain_id']) { $cart['productInfo']['attrInfo'] = StoreProductAttrValue::where('product_id', $cart['bargain_id'])->where('type', 2)->find(); } $cart['productInfo']['attrInfo']['weight'] = $product['weight']; $cart['productInfo']['attrInfo']['volume'] = $product['volume']; } else { $cart['truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid, true, $mer_id); $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid, false, $mer_id); } $cart['trueStock'] = $cart['productInfo']['stock']; $cart['costPrice'] = $cart['productInfo']['cost']; $valid[] = $cart; } } } //统一删除 if ($del_array) { $model->where('id', 'in', $del_array)->update(['is_del' => 1]); } $delivery = (int)sys_config('store_self_mention', '', $mer_id) ?? 0; foreach ($valid as $k => $cart) { if ($cart['trueStock'] < $cart['cart_num']) { $cart['cart_num'] = $cart['trueStock']; $model->where('id', $cart['id'])->update(['cart_num' => $cart['cart_num']]); $valid[$k] = $cart; } unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']); if (isset($valid[$k]['productInfo'])) { unset($valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_show']); } if(isset($cart['is_alone']) && $cart['is_alone'] === 0){ $valid[$k]['delivery'] = $delivery; } } $type = count($valid) && isset($valid[0]['delivery']) ? $valid[0]['delivery'] : ''; $bool = true; foreach ($valid as $k => $cart) { if(isset($cart['delivery']) && $cart['delivery'] !== $type){ $bool = false; } } foreach ($invalid as $k => $cart) { unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']); if (isset($invalid[$k]['productInfo'])) { unset($invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_show']); } } return compact('valid', 'invalid', 'deduction', 'bool', 'type'); } /** * @param $uid * @param string $cartIds * @param int $status * @return array * @throws DataNotFoundException * @throws DbException * @throws ModelNotFoundException */ public static function getUserProductCartList($uid, $cartIds = '', $status = 0, $mer_id = false) { $productInfoField = 'id,image,price,ot_price,vip_price,postage,give_integral,sales,stock,store_name,unit_name,is_show,is_del,is_postage,cost,is_sub,temp_id,is_ban,is_alone,delivery'; $seckillInfoField = 'id,image,price,ot_price,postage,give_integral,sales,stock,title as store_name,unit_name,is_show,is_del,is_postage,cost,temp_id,weight,volume,start_time,stop_time,time_id'; $bargainInfoField = 'id,image,min_price as price,price as ot_price,postage,give_integral,sales,stock,title as store_name,unit_name,status as is_show,is_del,is_postage,cost,temp_id,weight,volume'; $combinationInfoField = 'id,image,price,postage,sales,stock,title as store_name,is_show,is_del,is_postage,cost,temp_id,weight,volume'; $assistanceInfoField = 'id,image,price,postage,sales,stock,title as store_name,is_show,is_del,is_postage,cost,temp_id,weight,volume'; $model = new self(); $valid = $invalid = []; $model = $model->where('uid', $uid)->where('type', 'product')->where('is_pay', 0) ->where('is_del', 0); if (!$status) $model = $model->where('is_new', 0); if ($cartIds) $model = $model->where('id', 'IN', $cartIds); $model = $model->order('add_time DESC'); $list = $model->select()->toArray(); if (!count($list)) return compact('valid', 'invalid'); $now = time(); foreach ($list as $k => $cart) { if ($cart['seckill_id']) { $product = StoreSeckill::merSet($mer_id)->field($seckillInfoField) ->find($cart['seckill_id'])->toArray(); } elseif ($cart['bargain_id']) { $product = StoreBargain::merSet($mer_id)->field($bargainInfoField) ->find($cart['bargain_id'])->toArray(); } elseif ($cart['combination_id']) { $product = StoreCombination::merSet($mer_id)->field($combinationInfoField) ->find($cart['combination_id'])->toArray(); } elseif ($cart['assistance_id']) { $product = StoreAssistance::merSet($mer_id)->field($assistanceInfoField) ->find($cart['assistance_id'])->toArray(); } else { $product = StoreProduct::merSet($mer_id)->field($productInfoField) ->find($cart['product_id'])->toArray(); } $product['image'] = set_file_url($product['image']); $cart['productInfo'] = $product; //商品不存在 if (!$product) { $model->where('id', $cart['id'])->update(['is_del' => 1]); //商品删除或无库存 } else if (!$product['is_show'] || $product['is_del'] || !$product['stock']) { $invalid[] = $cart; //秒杀商品未开启或者已结束 } else if ($cart['seckill_id'] && ($product['start_time'] > $now || $product['stop_time'] < $now - 86400)) { $invalid[] = $product; //商品属性不对应 } else if (!StoreProductAttr::issetProductUnique($cart['product_id'], $cart['product_attr_unique']) && !$cart['combination_id'] && !$cart['seckill_id'] && !$cart['bargain_id']) { $invalid[] = $cart; //正常商品 } else { if ($cart['seckill_id']) { $config = SystemGroupDataMerchant::get($product['time_id']); if ($config) { $arr = json_decode($config->value, true); $now_hour = date('H', time()); $start_hour = $arr['time']['value']; $continued = $arr['continued']['value']; $end_hour = $start_hour + $continued; if ($start_hour > $now_hour) { //'活动未开启'; $invalid[] = $cart; continue; } elseif ($end_hour < $now_hour) { //'活动已结束'; $invalid[] = $cart; continue; } } } if(isset($product['is_alone'])) $cart['is_alone'] = $product['is_alone']; if(isset($product['delivery'])) $cart['delivery'] = $product['delivery']; if ($cart['product_attr_unique']) { $attrInfo = StoreProductAttr::uniqueByAttrInfo($cart['product_attr_unique']); //商品没有对应的属性 if (!$attrInfo || !$attrInfo['stock']) $invalid[] = $cart; else { $cart['productInfo']['attrInfo'] = $attrInfo; if ($cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id']) { $cart['truePrice'] = $attrInfo['price']; $cart['vip_truePrice'] = 0; } else { $cart['truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid, true, $mer_id); $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid, false, $mer_id); } $cart['trueStock'] = $attrInfo['stock']; $cart['costPrice'] = $attrInfo['cost']; $cart['productInfo']['image'] = empty($attrInfo['image']) ? $cart['productInfo']['image'] : $attrInfo['image']; $valid[] = $cart; } } else { if ($cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id']) { $cart['truePrice'] = $cart['productInfo']['price']; $cart['vip_truePrice'] = 0; if ($cart['bargain_id']) { $cart['productInfo']['attrInfo'] = StoreProductAttrValue::where('product_id', $cart['bargain_id'])->where('type', 2)->find(); } $cart['productInfo']['attrInfo']['weight'] = $product['weight']; $cart['productInfo']['attrInfo']['volume'] = $product['volume']; } else { $cart['truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid, true, $mer_id); $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid, false, $mer_id); } $cart['trueStock'] = $cart['productInfo']['stock']; $cart['costPrice'] = $cart['productInfo']['cost']; $valid[] = $cart; } } } foreach ($valid as $k => $cart) { if ($cart['trueStock'] < $cart['cart_num']) { $cart['cart_num'] = $cart['trueStock']; $model->where('id', $cart['id'])->update(['cart_num' => $cart['cart_num']]); $valid[$k] = $cart; } unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']); if (isset($valid[$k]['productInfo'])) { unset($valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_show']); } } foreach ($invalid as $k => $cart) { unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']); if (isset($invalid[$k]['productInfo'])) { unset($invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_show']); } } $delivery = (int)sys_config('store_self_mention', '', $mer_id) ?? 0; return compact('valid', 'invalid', 'delivery'); } /** * 拼团 * @param $uid * @param string $cartIds * @return array * @throws DataNotFoundException * @throws DbException * @throws ModelNotFoundException */ public static function getUserCombinationProductCartList($uid, $cartIds = '') { $productInfoField = 'id,image,slider_image,price,cost,ot_price,vip_price,postage,mer_id,give_integral,cate_id,sales,stock,store_name,unit_name,is_show,is_del,is_postage'; $model = new self(); $valid = $invalid = []; $model = $model->where('uid', $uid)->where('type', 'product')->where('is_pay', 0) ->where('is_del', 0); if ($cartIds) $model->where('id', 'IN', $cartIds); $list = $model->select()->toArray(); if (!count($list)) return compact('valid', 'invalid'); foreach ($list as $k => $cart) { $product = StoreProduct::field($productInfoField) ->find($cart['product_id'])->toArray(); $cart['productInfo'] = $product; //商品不存在 if (!$product) { $model->where('id', $cart['id'])->update(['is_del' => 1]); //商品删除或无库存 } else if (!$product['is_show'] || $product['is_del'] || !$product['stock']) { $invalid[] = $cart; //商品属性不对应 // }else if(!StoreProductAttr::issetProductUnique($cart['product_id'],$cart['product_attr_unique'])){ // $invalid[] = $cart; //正常商品 } else { $cart['truePrice'] = (float)StoreCombination::where('id', $cart['combination_id'])->value('price'); $cart['costPrice'] = (float)StoreCombination::where('id', $cart['combination_id'])->value('cost'); $cart['trueStock'] = StoreCombination::where('id', $cart['combination_id'])->value('stock'); $valid[] = $cart; } } foreach ($valid as $k => $cart) { if ($cart['trueStock'] < $cart['cart_num']) { $cart['cart_num'] = $cart['trueStock']; $model->where('id', $cart['id'])->update(['cart_num' => $cart['cart_num']]); $valid[$k] = $cart; } } return compact('valid', 'invalid'); } /** * 商品编号 * @param array $ids * @return array */ public static function getCartIdsProduct(array $ids) { return self::whereIn('id', $ids)->column('product_id', 'id'); } /** * 获取购物车内最新一张商品图 */ public static function getProductImage(array $cart_id) { return self::whereIn('a.id', $cart_id)->alias('a')->order('a.id desc') ->join('store_product p', 'p.id = a.product_id')->value('p.image'); } }