StoreCart.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430
  1. <?php
  2. /**
  3. *
  4. * @author: xaboy<365615158@qq.com>
  5. * @day: 2017/12/18
  6. */
  7. namespace app\models\store;
  8. use app\admin\model\store\StoreProductAttrValue;
  9. use app\admin\model\system\SystemGroupData;
  10. use app\models\user\UserLevel;
  11. use crmeb\basic\BaseModel;
  12. use crmeb\services\UtilService;
  13. use crmeb\traits\ModelTrait;
  14. /**
  15. * TODO 购物车Model
  16. * Class StoreCart
  17. * @package app\models\store
  18. */
  19. class StoreCart extends BaseModel
  20. {
  21. /**
  22. * 数据表主键
  23. * @var string
  24. */
  25. protected $pk = 'id';
  26. /**
  27. * 模型名称
  28. * @var string
  29. */
  30. protected $name = 'store_cart';
  31. use ModelTrait;
  32. protected $insert = ['add_time'];
  33. protected function setAddTimeAttr()
  34. {
  35. return date("Y-m-d H:i:s");
  36. }
  37. public static function setCart($uid, $product_id, $cart_num = 1, $product_attr_unique = '', $type = 'product', $is_new = 0, $combination_id = 0, $seckill_id = 0, $bargain_id = 0, $is_consumer = 0, $store_id = 0)
  38. {
  39. if ($cart_num < 0.001) $cart_num = 1;
  40. if (!$product_attr_unique) {
  41. $id = 0;
  42. $activity_type = 0;
  43. if ($seckill_id) {
  44. $id = $seckill_id;
  45. $activity_type = 1;
  46. } elseif ($bargain_id) {
  47. $id = $bargain_id;
  48. $activity_type = 2;
  49. } elseif ($combination_id) {//拼团
  50. $id = $combination_id;
  51. $activity_type = 3;
  52. }
  53. $unique = StoreProduct::getSingleAttrUnique($product_id, $id, $activity_type);
  54. if ($unique) {
  55. $product_attr_unique = $unique;
  56. }
  57. }
  58. @file_put_contents("cart.txt", $cart_num);
  59. if (!StoreOrder::checkProductStock($uid, $product_id, $cart_num, $product_attr_unique, $combination_id, $seckill_id, $bargain_id)) {
  60. return self::setErrorInfo(StoreOrder::getErrorInfo());
  61. }
  62. 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('combination_id', $combination_id)->where('bargain_id', $bargain_id)->where('seckill_id', $seckill_id)->find()) {
  63. if ($is_new)
  64. $cart->cart_num = $cart_num;
  65. else
  66. $cart->cart_num = bcadd($cart_num, $cart->cart_num, 3);
  67. $stock = 0;
  68. if ($cart['bargain_id']) {
  69. //TODO 获取砍价产品的库存
  70. $stock = StoreBargain::getBargainStock($cart['bargain_id']);
  71. } else if ($cart['seckill_id']) {
  72. //TODO 获取秒杀产品的库存
  73. $stock = StoreSeckill::getProductStock($cart['seckill_id']);
  74. } else if ($cart['combination_id']) {
  75. //TODO 获取拼团产品的库存
  76. $stock = StoreCombination::getCombinationStock($cart['combination_id'], $cart->cart_num);
  77. } else if ($cart['product_id']) {
  78. //TODO 获取普通产品的库存
  79. $stock = StoreProduct::getProductStock($cart['product_id'], $cart['product_attr_unique']);
  80. }
  81. if (!$stock) return self::setErrorInfo('暂无库存');
  82. if (!$cart->cart_num) return self::setErrorInfo('库存错误');
  83. if ($stock < $cart->cart_num) return self::setErrorInfo('库存不足' . $cart->cart_num);
  84. $cart->add_time = time();
  85. $cart->save();
  86. return $cart;
  87. } else {
  88. $stock = 0;
  89. if ($bargain_id) {
  90. //TODO 获取砍价产品的库存
  91. $stock = StoreBargain::getBargainStock($bargain_id);
  92. } else if ($seckill_id) {
  93. //TODO 获取秒杀产品的库存
  94. $stock = StoreSeckill::getProductStock($seckill_id);
  95. } else if ($combination_id) {
  96. //TODO 获取拼团产品的库存
  97. $stock = StoreCombination::getCombinationStock($combination_id, $cart_num);
  98. } else if ($product_id) {
  99. //TODO 获取普通产品的库存
  100. $stock = StoreProduct::getProductStock($product_id, $product_attr_unique);
  101. }
  102. if (!$stock) return self::setErrorInfo('暂无库存');
  103. if (!$cart_num) return self::setErrorInfo('库存错误');
  104. if ($stock < $cart_num) return self::setErrorInfo('库存不足' . $cart_num);
  105. $add_time = time();
  106. $id = self::getkeytoid('cart_id');
  107. $is_suit = (!$combination_id && !$seckill_id && !$bargain_id && StoreProduct::where('id', $product_id)->value('is_suit')) ? 1 : 0;
  108. $is_award = (!$combination_id && !$seckill_id && !$bargain_id && StoreProduct::where('id', $product_id)->value('is_award')) ? 1 : 0;
  109. // var_dump(compact('uid', 'is_award', 'product_id', 'cart_num', 'product_attr_unique', 'is_new', 'type', 'combination_id', 'add_time', 'bargain_id', 'seckill_id', 'id', 'is_consumer', 'is_suit', 'store_id'));
  110. $rs = self::create(compact('uid', 'is_award', 'product_id', 'cart_num', 'product_attr_unique', 'is_new', 'type', 'combination_id', 'add_time', 'bargain_id', 'seckill_id', 'id', 'is_consumer', 'is_suit', 'store_id'));
  111. // @file_put_contents("cart.txt", self::getlastsql(), 8);
  112. return $rs;
  113. }
  114. }
  115. public static function removeUserCart($uid, $ids)
  116. {
  117. return self::where('uid', $uid)->where('id', 'IN', implode(',', $ids))->update(['is_del' => 1]);
  118. }
  119. public static function getUserCartNum($uid, $type, $numType)
  120. {
  121. if ($numType) {
  122. return self::where('c.uid', $uid)->alias('c')->join('store_product p', 'p.id = c.product_id')->where('c.type', $type)->where('c.is_pay', 0)->where('c.is_del', 0)->where('c.is_new', 0)->count();
  123. } else {
  124. return self::where('c.uid', $uid)->alias('c')->join('store_product p', 'p.id = c.product_id')->where('c.type', $type)->where('c.is_pay', 0)->where('c.is_del', 0)->where('c.is_new', 0)->sum('c.cart_num');
  125. }
  126. }
  127. /**
  128. * TODO 修改购物车库存
  129. * @param $cartId
  130. * @param $cartNum
  131. * @param $uid
  132. * @return StoreCart|bool
  133. * @throws \think\Exception
  134. * @throws \think\db\exception\DataNotFoundException
  135. * @throws \think\db\exception\ModelNotFoundException
  136. * @throws \think\exception\DbException
  137. */
  138. public static function changeUserCartNum($cartId, $cartNum, $uid)
  139. {
  140. $count = self::where('uid', $uid)->where('id', $cartId)->count();
  141. if (!$count) return self::setErrorInfo('参数错误');
  142. $cartInfo = self::where('uid', $uid)->where('id', $cartId)->field('product_id,combination_id,seckill_id,bargain_id,product_attr_unique,cart_num')->find()->toArray();
  143. $stock = 0;
  144. if ($cartInfo['bargain_id']) {
  145. //TODO 获取砍价产品的库存
  146. $stock = 0;
  147. } else if ($cartInfo['seckill_id']) {
  148. //TODO 获取秒杀产品的库存
  149. $stock = 0;
  150. } else if ($cartInfo['combination_id']) {
  151. //TODO 获取拼团产品的库存
  152. $stock = 0;
  153. } else if ($cartInfo['product_id']) {
  154. //TODO 获取普通产品的库存
  155. $stock = StoreProduct::getProductStock($cartInfo['product_id'], $cartInfo['product_attr_unique']);
  156. }
  157. if (!$stock) return self::setErrorInfo('暂无库存');
  158. if (!$cartNum) return self::setErrorInfo('库存错误');
  159. if ($stock < $cartNum) return self::setErrorInfo('库存不足' . $cartNum);
  160. if ($cartInfo['cart_num'] == $cartNum) return true;
  161. return self::where('uid', $uid)->where('id', $cartId)->update(['cart_num' => $cartNum]);
  162. }
  163. public static function getUserProductCartList($uid, $cartIds = '', $status = 0, $store_id = 0)
  164. {
  165. $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_consumer,is_suit,is_bind,max_use_integral,store_id,store_bag,store_spread,time_area_discount';
  166. $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';
  167. $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';
  168. $combinationInfoField = 'id,image,price,postage,sales,stock,title as store_name,is_show,is_del,is_postage,cost,temp_id,weight,volume';
  169. $model = new self();
  170. $valid = $invalid = [];
  171. $suit = 0;
  172. $store_bag = false;
  173. $store_spread = 0;
  174. $model = $model->alias('c')->field('c.*')->join('store_product p', 'c.product_id = p.id')->where('c.uid', $uid)->where('c.type', 'product')->where('c.is_pay', 0)
  175. ->where('c.is_del', 0);
  176. if (!$status) $model = $model->where('c.is_new', 0);
  177. if ($cartIds) $model = $model->where('c.id', 'IN', $cartIds);
  178. if ($store_id) $model = $model->where('c.store_id', 'IN', $store_id);
  179. $model = $model->order('c.add_time DESC');
  180. $list = $model->select()->toArray();
  181. if (!count($list)) return compact('valid', 'invalid');
  182. $now = time();
  183. foreach ($list as $k => $cart) {
  184. if ($cart['seckill_id']) {
  185. $product = StoreSeckill::field($seckillInfoField)
  186. ->find($cart['seckill_id'])->toArray();
  187. } elseif ($cart['bargain_id']) {
  188. $product = StoreBargain::field($bargainInfoField)
  189. ->find($cart['bargain_id'])->toArray();
  190. } elseif ($cart['combination_id']) {
  191. $product = StoreCombination::field($combinationInfoField)
  192. ->find($cart['combination_id'])->toArray();
  193. } else {
  194. $product = StoreProduct::field($productInfoField)
  195. ->find($cart['product_id'])->toArray();
  196. }
  197. $product['image'] = set_file_url($product['image']);
  198. $cart['productInfo'] = $product;
  199. //商品不存在
  200. if (!$product) {
  201. $model->where('id', $cart['id'])->update(['is_del' => 1]);
  202. //商品删除或无库存
  203. } else if (!$product['is_show'] || $product['is_del'] || !$product['stock']) {
  204. $invalid[] = $cart;
  205. //秒杀产品未开启或者已结束
  206. } else if ($cart['seckill_id'] && ($product['start_time'] > $now || $product['stop_time'] < $now - 86400)) {
  207. $invalid[] = $product;
  208. //商品属性不对应
  209. } else if (!StoreProductAttr::issetProductUnique($cart['product_id'], $cart['product_attr_unique']) && !$cart['combination_id'] && !$cart['seckill_id'] && !$cart['bargain_id']) {
  210. $invalid[] = $cart;
  211. //正常商品
  212. } else {
  213. if ($cart['seckill_id']) {
  214. $config = SystemGroupData::get($product['time_id']);
  215. if ($config) {
  216. $arr = json_decode($config->value, true);
  217. $now_hour = date('H', time());
  218. $start_hour = $arr['time']['value'];
  219. $continued = $arr['continued']['value'];
  220. $end_hour = $start_hour + $continued;
  221. if ($start_hour > $now_hour) {
  222. //'活动未开启';
  223. $invalid[] = $cart;
  224. continue;
  225. } elseif ($end_hour < $now_hour) {
  226. //'活动已结束';
  227. $invalid[] = $cart;
  228. continue;
  229. }
  230. }
  231. }
  232. if ($cart['product_attr_unique']) {
  233. $attrInfo = StoreProductAttr::uniqueByAttrInfo($cart['product_attr_unique']);
  234. //商品没有对应的属性
  235. if (!$attrInfo || !$attrInfo['stock'])
  236. $invalid[] = $cart;
  237. else {
  238. $cart['productInfo']['attrInfo'] = $attrInfo;
  239. if ($cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id'] || $cart['is_consumer'] || $cart['is_suit'] || (($cart['productInfo']['max_use_integral'] ?? 0) > 0)) {
  240. if ($cart['bargain_id']) {
  241. $cart['truePrice'] = $cart['productInfo']['price'];
  242. } else {
  243. $cart['truePrice'] = $attrInfo['price'];
  244. }
  245. $cart['vip_truePrice'] = 0;
  246. $cart['use_integral'] = $cart['productInfo']['max_use_integral'] ?? 0;
  247. } else {
  248. $discounts = json_decode($product['time_area_discount'] ?: '[]', true);
  249. $discount = 0;
  250. if (count($discounts) > 0) {
  251. foreach ($discounts as $kk => $v) {
  252. $times = explode('-', $kk);
  253. if (!(count($times) == 2)) {
  254. break;
  255. }
  256. $start = strtotime(date('Y-m-d') . ' ' . $times[0]);
  257. $end = strtotime(date('Y-m-d') . ' ' . $times[1]);
  258. if (time() > $start && time() <= $end) {
  259. $discount = $v;
  260. }
  261. }
  262. }
  263. if ($discount > 0) {
  264. $attrInfo['price'] = bcmul(bcdiv($discount, 100, 4), $attrInfo['price'], 2);
  265. }
  266. $cart['truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid, true);
  267. $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($attrInfo['price'], $uid);
  268. $cart['use_integral'] = 0;
  269. }
  270. $cart['trueStock'] = $attrInfo['stock'];
  271. $cart['costPrice'] = $attrInfo['cost'];
  272. $cart['productInfo']['image'] = empty($attrInfo['image']) ? $cart['productInfo']['image'] : $attrInfo['image'];
  273. $valid[] = $cart;
  274. }
  275. } else {
  276. if ($cart['combination_id'] || $cart['seckill_id'] || $cart['bargain_id'] || $cart['is_consumer'] || $cart['is_suit'] || (($cart['productInfo']['max_use_integral'] ?? 0) > 0)) {
  277. $cart['truePrice'] = $cart['productInfo']['price'];
  278. $cart['vip_truePrice'] = 0;
  279. $cart['use_integral'] = $cart['productInfo']['max_use_integral'] ?? 0;
  280. if ($cart['bargain_id']) {
  281. $cart['productInfo']['attrInfo'] = StoreProductAttrValue::where('product_id', $cart['bargain_id'])->where('type', 2)->find();
  282. }
  283. $cart['productInfo']['attrInfo']['weight'] = $product['weight'];
  284. $cart['productInfo']['attrInfo']['volume'] = $product['volume'];
  285. } else {
  286. $discounts = json_decode($product['time_area_discount'] ?: '[]', true);
  287. $discount = 0;
  288. if (count($discounts) > 0) {
  289. foreach ($discounts as $kk => $v) {
  290. $times = explode('-', $kk);
  291. if (!(count($times) == 2)) {
  292. break;
  293. }
  294. $start = strtotime(date('Y-m-d') . ' ' . $times[0]);
  295. $end = strtotime(date('Y-m-d') . ' ' . $times[1]);
  296. if (time() > $start && time() <= $end) {
  297. $discount = $v;
  298. }
  299. }
  300. }
  301. if ($discount > 0) {
  302. $cart['productInfo']['price'] = bcmul(bcdiv($discount, 100, 4), $cart['productInfo']['price'], 2);
  303. }
  304. $cart['truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid, true);
  305. $cart['vip_truePrice'] = (float)StoreProduct::setLevelPrice($cart['productInfo']['price'], $uid);
  306. $cart['use_integral'] = 0;
  307. }
  308. $cart['trueStock'] = $cart['productInfo']['stock'];
  309. $cart['costPrice'] = $cart['productInfo']['cost'];
  310. $valid[] = $cart;
  311. }
  312. }
  313. }
  314. $is_bind = 0;
  315. foreach ($valid as $k => $cart) {
  316. if ($cart['trueStock'] < $cart['cart_num']) {
  317. $cart['cart_num'] = $cart['trueStock'];
  318. $model->where('id', $cart['id'])->update(['cart_num' => $cart['cart_num']]);
  319. $valid[$k] = $cart;
  320. }
  321. unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']);
  322. if (isset($valid[$k]['productInfo'])) {
  323. unset($valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_del'], $valid[$k]['productInfo']['is_show']);
  324. }
  325. $suit += ($cart['productInfo']['is_suit'] ?? 0) * $cart['cart_num'];
  326. $is_bind = $cart['productInfo']['is_bind'] ?? 0;
  327. $store_bag = $store_bag || ($cart['productInfo']['store_bag'] ?? 0);
  328. $store_spread += $cart['productInfo']['store_spread'];
  329. }
  330. foreach ($invalid as $k => $cart) {
  331. unset($valid[$k]['uid'], $valid[$k]['is_del'], $valid[$k]['is_new'], $valid[$k]['is_pay'], $valid[$k]['add_time']);
  332. if (isset($invalid[$k]['productInfo'])) {
  333. unset($invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_del'], $invalid[$k]['productInfo']['is_show']);
  334. }
  335. }
  336. return compact('valid', 'invalid', 'suit', 'store_bag', 'is_bind', 'store_spread');
  337. }
  338. /**
  339. * 拼团
  340. * @param $uid
  341. * @param string $cartIds
  342. * @return array
  343. */
  344. public static function getUserCombinationProductCartList($uid, $cartIds = '')
  345. {
  346. $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';
  347. $model = new self();
  348. $valid = $invalid = [];
  349. $model = $model->where('uid', $uid)->where('type', 'product')->where('is_pay', 0)
  350. ->where('is_del', 0);
  351. if ($cartIds) $model->where('id', 'IN', $cartIds);
  352. $list = $model->select()->toArray();
  353. if (!count($list)) return compact('valid', 'invalid');
  354. foreach ($list as $k => $cart) {
  355. $product = StoreProduct::field($productInfoField)
  356. ->find($cart['product_id'])->toArray();
  357. $cart['productInfo'] = $product;
  358. //商品不存在
  359. if (!$product) {
  360. $model->where('id', $cart['id'])->update(['is_del' => 1]);
  361. //商品删除或无库存
  362. } else if (!$product['is_show'] || $product['is_del'] || !$product['stock']) {
  363. $invalid[] = $cart;
  364. //商品属性不对应
  365. // }else if(!StoreProductAttr::issetProductUnique($cart['product_id'],$cart['product_attr_unique'])){
  366. // $invalid[] = $cart;
  367. //正常商品
  368. } else {
  369. $cart['truePrice'] = (float)StoreCombination::where('id', $cart['combination_id'])->value('price');
  370. $cart['costPrice'] = (float)StoreCombination::where('id', $cart['combination_id'])->value('cost');
  371. $cart['trueStock'] = StoreCombination::where('id', $cart['combination_id'])->value('stock');
  372. $valid[] = $cart;
  373. }
  374. }
  375. foreach ($valid as $k => $cart) {
  376. if ($cart['trueStock'] < $cart['cart_num']) {
  377. $cart['cart_num'] = $cart['trueStock'];
  378. $model->where('id', $cart['id'])->update(['cart_num' => $cart['cart_num']]);
  379. $valid[$k] = $cart;
  380. }
  381. }
  382. return compact('valid', 'invalid');
  383. }
  384. /**
  385. * 产品编号
  386. * @param array $ids
  387. * @return array
  388. */
  389. public static function getCartIdsProduct(array $ids)
  390. {
  391. return self::whereIn('id', $ids)->column('product_id', 'id');
  392. }
  393. /**
  394. * 获取购物车内最新一张产品图
  395. */
  396. public static function getProductImage(array $cart_id)
  397. {
  398. return self::whereIn('a.id', $cart_id)->alias('a')->order('a.id desc')
  399. ->join('store_product p', 'p.id = a.product_id')->value('p.image');
  400. }
  401. }