auti_boofly_mush_api/app/models/store/StoreCart.php

<?php
/**
 *
 * @author: xaboy<365615158@qq.com>
 * @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');
    }

}