StoreCombinationServices.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2023 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. declare (strict_types=1);
  12. namespace app\services\activity\combination;
  13. use app\Request;
  14. use app\services\BaseServices;
  15. use app\dao\activity\combination\StoreCombinationDao;
  16. use app\services\order\StoreOrderServices;
  17. use app\services\other\QrcodeServices;
  18. use app\services\product\product\StoreCategoryServices;
  19. use app\services\product\product\StoreDescriptionServices;
  20. use app\services\product\product\StoreProductRelationServices;
  21. use app\services\product\product\StoreProductReplyServices;
  22. use app\services\product\product\StoreProductServices;
  23. use app\services\product\sku\StoreProductAttrResultServices;
  24. use app\services\product\sku\StoreProductAttrServices;
  25. use app\services\product\sku\StoreProductAttrValueServices;
  26. use crmeb\exceptions\AdminException;
  27. use app\jobs\ProductLogJob;
  28. use crmeb\exceptions\ApiException;
  29. use crmeb\services\CacheService;
  30. /**
  31. *
  32. * Class StoreCombinationServices
  33. * @package app\services\activity
  34. * @method getPinkIdsArray(array $ids, array $field)
  35. * @method getOne(array $where, ?string $field = '*', array $with = []) 根据条件获取一条数据
  36. * @method get(int $id, array $field) 获取一条数据
  37. */
  38. class StoreCombinationServices extends BaseServices
  39. {
  40. /**
  41. * StoreCombinationServices constructor.
  42. * @param StoreCombinationDao $dao
  43. */
  44. public function __construct(StoreCombinationDao $dao)
  45. {
  46. $this->dao = $dao;
  47. }
  48. /**
  49. * 获取指定条件下的条数
  50. * @param array $where
  51. */
  52. public function getCount(array $where)
  53. {
  54. $this->dao->count($where);
  55. }
  56. /**
  57. * 获取是否有拼团商品
  58. * */
  59. public function validCombination()
  60. {
  61. return $this->dao->count([
  62. 'is_del' => 0,
  63. 'is_show' => 1,
  64. 'pinkIngTime' => true
  65. ]);
  66. }
  67. /**
  68. * 拼团商品添加
  69. * @param int $id
  70. * @param array $data
  71. */
  72. public function saveData(int $id, array $data)
  73. {
  74. $description = $data['description'];
  75. $detail = $data['attrs'];
  76. $items = $data['items'];
  77. $data['start_time'] = strtotime($data['section_time'][0]);
  78. $data['stop_time'] = strtotime($data['section_time'][1]);
  79. if ($data['stop_time'] < strtotime(date('Y-m-d', time()))) throw new AdminException(400096);
  80. $data['image'] = $data['image'];
  81. $data['images'] = json_encode($data['images']);
  82. $data['price'] = min(array_column($detail, 'price'));
  83. $data['quota'] = $data['quota_show'] = array_sum(array_column($detail, 'quota'));
  84. $data['stock'] = array_sum(array_column($detail, 'stock'));
  85. $data['logistics'] = implode(',', $data['logistics']);
  86. unset($data['section_time'], $data['description'], $data['attrs'], $data['items']);
  87. /** @var StoreDescriptionServices $storeDescriptionServices */
  88. $storeDescriptionServices = app()->make(StoreDescriptionServices::class);
  89. /** @var StoreProductAttrServices $storeProductAttrServices */
  90. $storeProductAttrServices = app()->make(StoreProductAttrServices::class);
  91. /** @var StoreProductServices $storeProductServices */
  92. $storeProductServices = app()->make(StoreProductServices::class);
  93. if ($data['quota'] > $storeProductServices->value(['id' => $data['product_id']], 'stock')) {
  94. throw new AdminException(400090);
  95. }
  96. $this->transaction(function () use ($id, $data, $description, $detail, $items, $storeDescriptionServices, $storeProductAttrServices, $storeProductServices) {
  97. if ($id) {
  98. $res = $this->dao->update($id, $data);
  99. $storeDescriptionServices->saveDescription((int)$id, $description, 3);
  100. $skuList = $storeProductServices->validateProductAttr($items, $detail, (int)$id, 3);
  101. $valueGroup = $storeProductAttrServices->saveProductAttr($skuList, (int)$id, 3);
  102. if (!$res) throw new AdminException(100007);
  103. } else {
  104. if (!$storeProductServices->getOne(['is_del' => 0, 'id' => $data['product_id']])) {
  105. throw new AdminException('无法添加回收站商品');
  106. }
  107. $data['add_time'] = time();
  108. $res = $this->dao->save($data);
  109. $storeDescriptionServices->saveDescription((int)$res->id, $description, 3);
  110. $skuList = $storeProductServices->validateProductAttr($items, $detail, (int)$res->id, 3, 1, true);
  111. $valueGroup = $storeProductAttrServices->saveProductAttr($skuList, (int)$res->id, 3);
  112. if (!$res) throw new AdminException(100022);
  113. }
  114. });
  115. }
  116. /**
  117. * 拼团列表
  118. * @param array $where
  119. * @return array
  120. */
  121. public function systemPage(array $where)
  122. {
  123. [$page, $limit] = $this->getPageValue();
  124. $list = $this->dao->getList($where, $page, $limit);
  125. $count = $this->dao->count($where);
  126. /** @var StorePinkServices $storePinkServices */
  127. $storePinkServices = app()->make(StorePinkServices::class);
  128. $countAll = $storePinkServices->getPinkCount([]);
  129. $countTeam = $storePinkServices->getPinkCount(['k_id' => 0, 'status' => 2]);
  130. $countPeople = $storePinkServices->getPinkCount(['k_id' => 0]);
  131. $stopIds = [];
  132. foreach ($list as &$item) {
  133. $item['count_people'] = $countPeople[$item['id']] ?? 0;//拼团数量
  134. $item['count_people_all'] = $countAll[$item['id']] ?? 0;//参与人数
  135. $item['count_people_pink'] = $countTeam[$item['id']] ?? 0;//成团数量
  136. $item['stop_status'] = $item['stop_time'] < time() ? 1 : 0;
  137. if ($item['is_show']) {
  138. if ($item['start_time'] > time()) {
  139. $item['start_name'] = '未开始';
  140. } else if ($item['stop_time'] < time()) {
  141. $item['start_name'] = '已结束';
  142. $item['is_show'] = 0;
  143. $stopIds[] = $item['id'];
  144. } else if ($item['stop_time'] > time() && $item['start_time'] < time()) {
  145. $item['start_name'] = '进行中';
  146. }
  147. } else {
  148. $item['start_name'] = '已结束';
  149. }
  150. $item['start_time'] = $item['start_time'] ? date('Y-m-d H:i:s', $item['start_time']) : '';
  151. $item['stop_time'] = $item['stop_time'] ? date('Y-m-d 23:59:59', $item['stop_time']) : '';
  152. }
  153. if ($stopIds) {
  154. $this->dao->batchUpdate($stopIds, ['is_show' => 0]);
  155. }
  156. return compact('list', 'count');
  157. }
  158. /**
  159. * 获取详情
  160. * @param int $id
  161. * @return array|\think\Model|null
  162. */
  163. public function getInfo(int $id)
  164. {
  165. $info = $this->dao->get($id);
  166. if (!$info) {
  167. throw new ApiException(410294);
  168. }
  169. if ($info->is_del) {
  170. throw new ApiException(410311);
  171. }
  172. if ($info['start_time'])
  173. $start_time = date('Y-m-d H:i:s', $info['start_time']);
  174. if ($info['stop_time'])
  175. $stop_time = date('Y-m-d H:i:s', $info['stop_time']);
  176. if (isset($start_time) && isset($stop_time))
  177. $info['section_time'] = [$start_time, $stop_time];
  178. else
  179. $info['section_time'] = [];
  180. unset($info['start_time'], $info['stop_time']);
  181. $info['price'] = floatval($info['price']);
  182. $info['postage'] = floatval($info['postage']);
  183. $info['weight'] = floatval($info['weight']);
  184. $info['volume'] = floatval($info['volume']);
  185. $info['logistics'] = explode(',', $info['logistics']);
  186. /** @var StoreDescriptionServices $storeDescriptionServices */
  187. $storeDescriptionServices = app()->make(StoreDescriptionServices::class);
  188. $info['description'] = $storeDescriptionServices->getDescription(['product_id' => $id, 'type' => 3]);
  189. $info['attrs'] = $this->attrList($id, $info['product_id']);
  190. return $info;
  191. }
  192. /**
  193. * 获取规格
  194. * @param int $id
  195. * @param int $pid
  196. * @return mixed
  197. */
  198. public function attrList(int $id, int $pid)
  199. {
  200. /** @var StoreProductAttrResultServices $storeProductAttrResultServices */
  201. $storeProductAttrResultServices = app()->make(StoreProductAttrResultServices::class);
  202. $combinationResult = $storeProductAttrResultServices->value(['product_id' => $id, 'type' => 3], 'result');
  203. $items = json_decode($combinationResult, true)['attr'];
  204. $productAttr = $this->getAttr($items, $pid, 0);
  205. $combinationAttr = $this->getAttr($items, $id, 3);
  206. foreach ($productAttr as $pk => $pv) {
  207. foreach ($combinationAttr as &$sv) {
  208. if ($pv['detail'] == $sv['detail']) {
  209. $productAttr[$pk] = $sv;
  210. $productAttr[$pk]['r_price'] = $pv['price'];
  211. }
  212. }
  213. $productAttr[$pk]['detail'] = json_decode($productAttr[$pk]['detail']);
  214. $productAttr[$pk]['r_price'] = $productAttr[$pk]['r_price'] ?? $productAttr[$pk]['price'];
  215. }
  216. $attrs['items'] = $items;
  217. $attrs['value'] = $productAttr;
  218. foreach ($items as $key => $item) {
  219. $header[] = ['title' => $item['value'], 'key' => 'value' . ($key + 1), 'align' => 'center', 'minWidth' => 80];
  220. }
  221. $header[] = ['title' => '图片', 'slot' => 'pic', 'align' => 'center', 'minWidth' => 120];
  222. $header[] = ['title' => '拼团价', 'slot' => 'price', 'align' => 'center', 'minWidth' => 80];
  223. $header[] = ['title' => '成本价', 'key' => 'cost', 'align' => 'center', 'minWidth' => 80];
  224. $header[] = ['title' => '日常售价', 'key' => 'r_price', 'align' => 'center', 'minWidth' => 80];
  225. $header[] = ['title' => '库存', 'key' => 'stock', 'align' => 'center', 'minWidth' => 80];
  226. $header[] = ['title' => '限量', 'slot' => 'quota', 'type' => 1, 'align' => 'center', 'minWidth' => 80];
  227. $header[] = ['title' => '重量(KG)', 'key' => 'weight', 'align' => 'center', 'minWidth' => 80];
  228. $header[] = ['title' => '体积(m³)', 'key' => 'volume', 'align' => 'center', 'minWidth' => 80];
  229. $header[] = ['title' => '商品编码', 'key' => 'bar_code', 'align' => 'center', 'minWidth' => 80];
  230. $header[] = ['title' => '条形码', 'key' => 'bar_code_number', 'align' => 'center', 'minWidth' => 80];
  231. $attrs['header'] = $header;
  232. return $attrs;
  233. }
  234. /**
  235. * 获得规格
  236. * @param $attr
  237. * @param $id
  238. * @param $type
  239. * @return array
  240. */
  241. public function getAttr($attr, $id, $type)
  242. {
  243. /** @var StoreProductAttrValueServices $storeProductAttrValueServices */
  244. $storeProductAttrValueServices = app()->make(StoreProductAttrValueServices::class);
  245. list($value, $head) = attr_format($attr);
  246. $valueNew = [];
  247. $count = 0;
  248. foreach ($value as $suk) {
  249. $detail = explode(',', $suk);
  250. $sukValue = $storeProductAttrValueServices->getColumn(['product_id' => $id, 'type' => $type, 'suk' => $suk], 'bar_code,bar_code_number,cost,price,ot_price,stock,image as pic,weight,volume,brokerage,brokerage_two,quota', 'suk');
  251. if (count($sukValue)) {
  252. foreach ($detail as $k => $v) {
  253. $valueNew[$count]['value' . ($k + 1)] = $v;
  254. }
  255. $valueNew[$count]['detail'] = json_encode(array_combine($head, $detail));
  256. $valueNew[$count]['pic'] = $sukValue[$suk]['pic'] ?? '';
  257. $valueNew[$count]['price'] = $sukValue[$suk]['price'] ? floatval($sukValue[$suk]['price']) : 0;
  258. $valueNew[$count]['cost'] = $sukValue[$suk]['cost'] ? floatval($sukValue[$suk]['cost']) : 0;
  259. $valueNew[$count]['ot_price'] = isset($sukValue[$suk]['ot_price']) ? floatval($sukValue[$suk]['ot_price']) : 0;
  260. $valueNew[$count]['stock'] = $sukValue[$suk]['stock'] ? intval($sukValue[$suk]['stock']) : 0;
  261. $valueNew[$count]['quota'] = $sukValue[$suk]['quota'] ? intval($sukValue[$suk]['quota']) : 0;
  262. $valueNew[$count]['bar_code'] = $sukValue[$suk]['bar_code'] ?? '';
  263. $valueNew[$count]['bar_code_number'] = $sukValue[$suk]['bar_code_number'] ?? '';
  264. $valueNew[$count]['weight'] = $sukValue[$suk]['weight'] ? floatval($sukValue[$suk]['weight']) : 0;
  265. $valueNew[$count]['volume'] = $sukValue[$suk]['volume'] ? floatval($sukValue[$suk]['volume']) : 0;
  266. $valueNew[$count]['brokerage'] = $sukValue[$suk]['brokerage'] ? floatval($sukValue[$suk]['brokerage']) : 0;
  267. $valueNew[$count]['brokerage_two'] = $sukValue[$suk]['brokerage_two'] ? floatval($sukValue[$suk]['brokerage_two']) : 0;
  268. $valueNew[$count]['_checked'] = $type != 0;
  269. $count++;
  270. }
  271. }
  272. return $valueNew;
  273. }
  274. /**
  275. * 根据id获取拼团数据列表
  276. * @param array $ids
  277. * @param string $field
  278. * @return array
  279. * @throws \think\db\exception\DataNotFoundException
  280. * @throws \think\db\exception\DbException
  281. * @throws \think\db\exception\ModelNotFoundException
  282. */
  283. public function getCombinationList()
  284. {
  285. [$page, $limit] = $this->getPageValue();
  286. $list = $this->dao->combinationList(['is_del' => 0, 'is_show' => 1, 'pinkIngTime' => true, 'storeProductId' => true], $page, $limit);
  287. foreach ($list as &$item) {
  288. $item['image'] = set_file_url($item['image']);
  289. $item['price'] = floatval($item['price']);
  290. $item['product_price'] = floatval($item['product_price']);
  291. }
  292. return $list;
  293. }
  294. /**
  295. *首页获取拼团数据
  296. * @param $where
  297. * @return array
  298. * @throws \think\db\exception\DataNotFoundException
  299. * @throws \think\db\exception\DbException
  300. * @throws \think\db\exception\ModelNotFoundException
  301. */
  302. public function getHomeList($where)
  303. {
  304. [$page, $limit] = $this->getPageValue();
  305. $where['is_del'] = 0;
  306. $where['is_show'] = 1;
  307. $where['pinkIngTime'] = true;
  308. $where['storeProductId'] = true;
  309. $data = [];
  310. $list = $this->dao->getHomeList($where, $page, $limit);
  311. foreach ($list as &$item) {
  312. $item['image'] = set_file_url($item['image']);
  313. $item['price'] = floatval($item['price']);
  314. $item['product_price'] = floatval($item['product_price']);
  315. }
  316. $data['list'] = $list;
  317. return $data;
  318. }
  319. /**
  320. * 后台页面设计获取拼团列表
  321. * @param $where
  322. */
  323. public function getDiyCombinationList($where)
  324. {
  325. $where['pinkIngTime'] = true;
  326. $where['storeProductId'] = true;
  327. [$page, $limit] = $this->getPageValue();
  328. $list = $this->dao->diyCombinationList($where, $page, $limit);
  329. $count = $this->dao->getCount($where);
  330. $cateIds = implode(',', array_column($list, 'cate_id'));
  331. /** @var StoreCategoryServices $storeCategoryServices */
  332. $storeCategoryServices = app()->make(StoreCategoryServices::class);
  333. $cateList = $storeCategoryServices->getCateArray($cateIds);
  334. foreach ($list as &$item) {
  335. $cateName = array_filter($cateList, function ($val) use ($item) {
  336. if (in_array($val['id'], explode(',', $item['cate_id']))) {
  337. return $val;
  338. }
  339. });
  340. $item['cate_name'] = implode(',', array_column($cateName, 'cate_name'));
  341. $item['store_name'] = $item['title'];
  342. $item['price'] = floatval($item['price']);
  343. $item['is_product_type'] = 2;
  344. }
  345. return compact('count', 'list');
  346. }
  347. /**
  348. * 拼团商品详情
  349. * @param Request $request
  350. * @param int $id
  351. * @return mixed
  352. * @throws \think\db\exception\DataNotFoundException
  353. * @throws \think\db\exception\DbException
  354. * @throws \think\db\exception\ModelNotFoundException
  355. */
  356. public function combinationDetail(Request $request, int $id)
  357. {
  358. $uid = (int)$request->uid();
  359. $storeInfo = $this->dao->getOne(['id' => $id], '*', ['description', 'total']);
  360. if (!$storeInfo) {
  361. throw new ApiException(410311);
  362. } else {
  363. $storeInfo = $storeInfo->toArray();
  364. }
  365. $siteUrl = sys_config('site_url');
  366. $storeInfo['image'] = set_file_url($storeInfo['image'], $siteUrl);
  367. $storeInfo['image_base'] = set_file_url($storeInfo['image'], $siteUrl);
  368. $storeInfo['sale_stock'] = 0;
  369. if ($storeInfo['stock'] > 0) $storeInfo['sale_stock'] = 1;
  370. /** @var StoreProductRelationServices $storeProductRelationServices */
  371. $storeProductRelationServices = app()->make(StoreProductRelationServices::class);
  372. $storeInfo['userCollect'] = $storeProductRelationServices->isProductRelation(['uid' => $uid, 'product_id' => $id, 'type' => 'collect', 'category' => 'product']);
  373. $storeInfo['userLike'] = false;
  374. $storeInfo['store_name'] = $storeInfo['title'];
  375. $storeInfo['product_is_show'] = app()->make(StoreProductServices::class)->value($storeInfo['product_id'], 'is_show');
  376. if (sys_config('share_qrcode', 0) && request()->isWechat()) {
  377. /** @var QrcodeServices $qrcodeService */
  378. $qrcodeService = app()->make(QrcodeServices::class);
  379. $storeInfo['wechat_code'] = $qrcodeService->getTemporaryQrcode('combination-' . $id, $uid)->url;
  380. } else {
  381. $storeInfo['wechat_code'] = '';
  382. }
  383. $data['storeInfo'] = get_thumb_water($storeInfo, 'big', ['image', 'images']);
  384. $storeInfoNew = get_thumb_water($storeInfo, 'small');
  385. $data['storeInfo']['small_image'] = $storeInfoNew['image'];
  386. /** @var StorePinkServices $pinkService */
  387. $pinkService = app()->make(StorePinkServices::class);
  388. list($pink, $pinkAll) = $pinkService->getPinkList($id, true);//拼团列表
  389. $data['pink_ok_list'] = $pinkService->getPinkOkList($uid);
  390. $data['pink_ok_sum'] = $pinkService->getPinkOkSumTotalNum();
  391. $data['pink'] = $pink;
  392. $data['pinkAll'] = $pinkAll;
  393. /** @var StoreOrderServices $storeOrderServices */
  394. $storeOrderServices = app()->make(StoreOrderServices::class);
  395. $data['buy_num'] = $storeOrderServices->getBuyCount($uid, 'combination_id', $id);
  396. /** @var StoreProductReplyServices $storeProductReplyService */
  397. $storeProductReplyService = app()->make(StoreProductReplyServices::class);
  398. $data['reply'] = get_thumb_water($storeProductReplyService->getRecProductReply($storeInfo['product_id']), 'small', ['pics']);
  399. [$replyCount, $goodReply, $replyChance] = $storeProductReplyService->getProductReplyData((int)$storeInfo['product_id']);
  400. $data['replyChance'] = $replyChance;
  401. $data['replyCount'] = $replyCount;
  402. /** @var StoreProductAttrServices $storeProductAttrServices */
  403. $storeProductAttrServices = app()->make(StoreProductAttrServices::class);
  404. list($productAttr, $productValue) = $storeProductAttrServices->getProductAttrDetail($id, $uid, 0, 3, $storeInfo['product_id']);
  405. $data['productAttr'] = $productAttr;
  406. $data['productValue'] = $productValue;
  407. $data['routine_contact_type'] = sys_config('routine_contact_type', 0);
  408. //用户访问事件
  409. event('UserVisitListener', [$uid, $id, 'combination', $storeInfo['product_id'], 'view']);
  410. //浏览记录
  411. ProductLogJob::dispatch(['visit', ['uid' => $uid, 'product_id' => $storeInfo['product_id']]]);
  412. return $data;
  413. }
  414. /**
  415. * 修改销量和库存
  416. * @param $num
  417. * @param $CombinationId
  418. * @return bool
  419. */
  420. public function decCombinationStock(int $num, int $CombinationId, string $unique)
  421. {
  422. $product_id = $this->dao->value(['id' => $CombinationId], 'product_id');
  423. if ($unique) {
  424. /** @var StoreProductAttrValueServices $skuValueServices */
  425. $skuValueServices = app()->make(StoreProductAttrValueServices::class);
  426. //减去拼团商品的sku库存增加销量
  427. $res = false !== $skuValueServices->decProductAttrStock($CombinationId, $unique, $num, 3);
  428. //减去拼团库存
  429. $res = $res && $this->dao->decStockIncSales(['id' => $CombinationId, 'type' => 3], $num);
  430. //获取拼团的sku
  431. $sku = $skuValueServices->value(['product_id' => $CombinationId, 'unique' => $unique, 'type' => 3], 'suk');
  432. //减去当前普通商品sku的库存增加销量
  433. $res = $res && $skuValueServices->decStockIncSales(['product_id' => $product_id, 'suk' => $sku, 'type' => 0], $num);
  434. } else {
  435. $res = false !== $this->dao->decStockIncSales(['id' => $CombinationId, 'type' => 3], $num);
  436. }
  437. /** @var StoreProductServices $services */
  438. $services = app()->make(StoreProductServices::class);
  439. //减去普通商品库存
  440. $res = $res && $services->decProductStock($num, $product_id);
  441. return $res;
  442. }
  443. /**
  444. * 加库存减销量
  445. * @param int $num
  446. * @param int $CombinationId
  447. * @param string $unique
  448. * @return bool
  449. */
  450. public function incCombinationStock(int $num, int $CombinationId, string $unique)
  451. {
  452. $product_id = $this->dao->value(['id' => $CombinationId], 'product_id');
  453. if ($unique) {
  454. /** @var StoreProductAttrValueServices $skuValueServices */
  455. $skuValueServices = app()->make(StoreProductAttrValueServices::class);
  456. //增加拼团商品的sku库存,减去销量
  457. $res = false !== $skuValueServices->incProductAttrStock($CombinationId, $unique, $num, 3);
  458. //增加拼团库存
  459. $res = $res && $this->dao->incStockDecSales(['id' => $CombinationId, 'type' => 3], $num);
  460. //增加当前普通商品sku的库存,减去销量
  461. $suk = $skuValueServices->value(['unique' => $unique, 'product_id' => $CombinationId], 'suk');
  462. $productUnique = $skuValueServices->value(['suk' => $suk, 'product_id' => $product_id], 'unique');
  463. if ($productUnique) {
  464. $res = $res && $skuValueServices->incProductAttrStock($product_id, $productUnique, $num);
  465. }
  466. } else {
  467. $res = false !== $this->dao->incStockDecSales(['id' => $CombinationId, 'type' => 3], $num);
  468. }
  469. /** @var StoreProductServices $services */
  470. $services = app()->make(StoreProductServices::class);
  471. //增加普通商品库存
  472. $res = $res && $services->incProductStock($num, $product_id);
  473. return $res;
  474. }
  475. /**
  476. * 获取一条拼团数据
  477. * @param $id
  478. * @param $field
  479. * @return mixed
  480. */
  481. public function getCombinationOne($id, $field = '*')
  482. {
  483. return $this->dao->validProduct($id, $field);
  484. }
  485. /**
  486. * 获取拼团详情
  487. * @param Request $request
  488. * @param int $id
  489. * @return mixed
  490. * @throws \think\db\exception\DataNotFoundException
  491. * @throws \think\db\exception\DbException
  492. * @throws \think\db\exception\ModelNotFoundException
  493. */
  494. public function getPinkInfo(Request $request, int $id)
  495. {
  496. /** @var StorePinkServices $pinkService */
  497. $pinkService = app()->make(StorePinkServices::class);
  498. $is_ok = 0;//判断拼团是否完成
  499. $userBool = 0;//判断当前用户是否在团内 0未在 1在
  500. $pinkBool = 0;//判断拼团是否成功 0未在 1在
  501. $user = $request->user();
  502. if (!$id) throw new ApiException(100100);
  503. $pink = $pinkService->getPinkUserOne($id);
  504. if (!$pink) throw new ApiException(100100);
  505. $pink = $pink->toArray();
  506. if (isset($pink['is_refund']) && $pink['is_refund']) {
  507. if ($pink['is_refund'] != $pink['id']) {
  508. $id = $pink['is_refund'];
  509. return $this->getPinkInfo($request, $id);
  510. } else {
  511. throw new ApiException(410226);
  512. }
  513. }
  514. list($pinkAll, $pinkT, $count, $idAll, $uidAll) = $pinkService->getPinkMemberAndPinkK($pink);
  515. if ($pinkT['status'] == 2) {
  516. $pinkBool = 1;
  517. $is_ok = 1;
  518. } else if ($pinkT['status'] == 3) {
  519. $pinkBool = -1;
  520. $is_ok = 0;
  521. } else {
  522. if ($count < 1) {//组团完成
  523. $is_ok = 1;
  524. $pinkBool = $pinkService->pinkComplete($uidAll, $idAll, $user['uid'], $pinkT);
  525. } else {
  526. $pinkBool = $pinkService->pinkFail($pinkAll, $pinkT, $pinkBool);
  527. }
  528. $pinkT = $pinkService->getPinkUserOne($pinkT['id']);
  529. }
  530. if (!empty($pinkAll)) {
  531. foreach ($pinkAll as $v) {
  532. if ($v['uid'] == $user['uid']) $userBool = 1;
  533. }
  534. }
  535. if ($pinkT['uid'] == $user['uid']) $userBool = 1;
  536. $combinationOne = $this->getCombinationOne($pink['cid']);
  537. if (!$combinationOne) {
  538. throw new ApiException(410312);
  539. }
  540. $data['userInfo']['uid'] = $user['uid'];
  541. $data['userInfo']['nickname'] = $user['nickname'];
  542. $data['userInfo']['avatar'] = $user['avatar'];
  543. $data['is_ok'] = $is_ok;
  544. $data['userBool'] = $userBool;
  545. $data['pinkBool'] = $pinkBool;
  546. $data['store_combination'] = $combinationOne->hidden(['mer_id', 'images', 'attr', 'info', 'sort', 'sales', 'stock', 'add_time', 'is_host', 'is_show', 'is_del', 'combination', 'mer_use', 'is_postage', 'postage', 'start_time', 'stop_time', 'cost', 'browse', 'product_price'])->toArray();
  547. $data['pinkT'] = $pinkT;
  548. $data['pinkAll'] = $pinkAll;
  549. $data['count'] = $count <= 0 ? 0 : $count;
  550. $data['store_combination_host'] = $this->dao->getCombinationHost();
  551. $data['current_pink_order'] = $pinkService->getCurrentPink($id, $user['uid']);
  552. /** @var StoreProductAttrServices $storeProductAttrServices */
  553. $storeProductAttrServices = app()->make(StoreProductAttrServices::class);
  554. /** @var StoreProductAttrValueServices $storeProductAttrValueServices */
  555. $storeProductAttrValueServices = app()->make(StoreProductAttrValueServices::class);
  556. list($productAttr, $productValue) = $storeProductAttrServices->getProductAttrDetail($combinationOne['id'], $user['uid'], 0, 3, $combinationOne['product_id']);
  557. foreach ($productValue as $k => $v) {
  558. $productValue[$k]['product_stock'] = $storeProductAttrValueServices->value(['product_id' => $combinationOne['product_id'], 'suk' => $v['suk'], 'type' => 0], 'stock');
  559. }
  560. $data['store_combination']['productAttr'] = $productAttr;
  561. $data['store_combination']['productValue'] = $productValue;
  562. /** @var StoreOrderServices $orderServices */
  563. $orderServices = app()->make(StoreOrderServices::class);
  564. $data['order_pid'] = $orderServices->value(['order_id' => $data['current_pink_order']], 'pid');
  565. return $data;
  566. }
  567. /**
  568. * 验证拼团下单库存限量
  569. * @param int $uid
  570. * @param int $combinationId
  571. * @param int $cartNum
  572. * @param string $unique
  573. * @return array
  574. * @throws \think\db\exception\DataNotFoundException
  575. * @throws \think\db\exception\DbException
  576. * @throws \think\db\exception\ModelNotFoundException
  577. */
  578. public function checkCombinationStock(int $uid, int $combinationId, int $cartNum = 1, string $unique = '')
  579. {
  580. /** @var StoreProductAttrValueServices $attrValueServices */
  581. $attrValueServices = app()->make(StoreProductAttrValueServices::class);
  582. if ($unique == '') {
  583. $unique = $attrValueServices->value(['product_id' => $combinationId, 'type' => 3], 'unique');
  584. }
  585. $attrInfo = $attrValueServices->getOne(['product_id' => $combinationId, 'unique' => $unique, 'type' => 3]);
  586. if (!$attrInfo || $attrInfo['product_id'] != $combinationId) {
  587. throw new ApiException(410305);
  588. }
  589. $StoreCombinationInfo = $productInfo = $this->getCombinationOne($combinationId, '*,title as store_name');
  590. if (!$StoreCombinationInfo) {
  591. throw new ApiException(410295);
  592. }
  593. /** @var StoreOrderServices $orderServices */
  594. $orderServices = app()->make(StoreOrderServices::class);
  595. $userBuyCount = $orderServices->getBuyCount($uid, 'combination_id', $combinationId);
  596. if ($StoreCombinationInfo['once_num'] < $cartNum) {
  597. throw new ApiException(410313, ['num' => $StoreCombinationInfo['once_num']]);
  598. }
  599. if ($StoreCombinationInfo['num'] < ($userBuyCount + $cartNum)) {
  600. throw new ApiException(410298, ['num' => $StoreCombinationInfo['num']]);
  601. }
  602. if ($cartNum > $attrInfo['quota']) {
  603. throw new ApiException(410296);
  604. }
  605. return [$attrInfo, $unique, $productInfo];
  606. }
  607. /**
  608. * 拼团统计
  609. * @param $id
  610. * @return array
  611. */
  612. public function combinationStatistics($id)
  613. {
  614. /** @var StorePinkServices $pinkServices */
  615. $pinkServices = app()->make(StorePinkServices::class);
  616. /** @var StoreOrderServices $orderServices */
  617. $orderServices = app()->make(StoreOrderServices::class);
  618. $people_count = $pinkServices->getDistinctCount([['cid', '=', $id]], 'uid', false);
  619. $spread_count = $pinkServices->getDistinctCount([['cid', '=', $id], ['k_id', '>', 0]], 'uid', false);
  620. $start_count = $pinkServices->count(['cid' => $id, 'k_id' => 0]);
  621. $success_count = $pinkServices->count(['cid' => $id, 'k_id' => 0, 'status' => 2]);
  622. $pay_price = $orderServices->sum([['combination_id', '=', $id], ['paid', '=', 1], ['pid', '<>', -1], ['refund_type', 'in', [0, 3]], ['is_del', '=', 0]], 'pay_price', false);
  623. $pay_count = $orderServices->getDistinctCount([['combination_id', '=', $id], ['paid', '=', 1], ['refund_type', 'in', [0, 3]], ['is_del', '=', 0]], 'uid', false);
  624. return compact('people_count', 'spread_count', 'start_count', 'success_count', 'pay_price', 'pay_count');
  625. }
  626. /**
  627. * 拼团订单
  628. * @param $id
  629. * @param array $where
  630. * @return array
  631. */
  632. public function combinationStatisticsOrder($id, $where = [])
  633. {
  634. /** @var StoreOrderServices $orderServices */
  635. $orderServices = app()->make(StoreOrderServices::class);
  636. [$page, $limit] = $this->getPageValue();
  637. $where = $where + ['paid' => 1, 'refund_status' => 0, 'is_del' => 0];
  638. $list = $orderServices->combinationStatisticsOrder($id, $where, $page, $limit);
  639. $count = $orderServices->combinationStatisticsCount($id, $where);
  640. foreach ($list as &$item) {
  641. if ($item['status'] == 0) {
  642. if ($item['paid'] == 0) {
  643. $item['status'] = '未支付';
  644. } else {
  645. $item['status'] = '未发货';
  646. }
  647. } elseif ($item['status'] == 1) {
  648. $item['status'] = '待收货';
  649. } elseif ($item['status'] == 2) {
  650. $item['status'] = '待评价';
  651. } elseif ($item['status'] == 3) {
  652. $item['status'] = '已完成';
  653. } elseif ($item['status'] == -2) {
  654. $item['status'] = '已退款';
  655. } else {
  656. $item['status'] = '未知';
  657. }
  658. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  659. $item['pay_time'] = $item['pay_time'] ? date('Y-m-d H:i:s', $item['pay_time']) : '';
  660. }
  661. return compact('list', 'count');
  662. }
  663. }