StoreOrderController.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715
  1. <?php
  2. namespace app\api\controller\order;
  3. use Qiniu\Auth;
  4. use app\admin\model\system\{
  5. SystemAttachment, ShippingTemplates
  6. };
  7. use app\admin\model\user\User;
  8. use app\models\routine\RoutineFormId;
  9. use crmeb\repositories\OrderRepository;
  10. use app\models\store\{StoreBargainUser,
  11. StoreCart,
  12. StoreCoupon,
  13. StoreCouponIssue,
  14. StoreCouponUser,
  15. StoreOrder,
  16. StoreOrderCartInfo,
  17. StoreOrderStatus,
  18. StorePink,
  19. StoreProduct,
  20. StoreProductReply};
  21. use app\models\system\SystemStore;
  22. use app\models\user\UserAddress;
  23. use app\models\user\UserLevel;
  24. use app\models\user\User as User2;
  25. use app\Request;
  26. use crmeb\services\{
  27. CacheService,
  28. ExpressService,
  29. SystemConfigService,
  30. UtilService
  31. };
  32. /**
  33. * 订单类
  34. * Class StoreOrderController
  35. * @package app\api\controller\order
  36. */
  37. class StoreOrderController
  38. {
  39. /**
  40. * 订单确认
  41. * @param Request $request
  42. * @return mixed
  43. */
  44. public function confirm(Request $request)
  45. {
  46. $temp = ShippingTemplates::get(1);
  47. if (!$temp) return app('json')->fail('默认模板未配置,无法下单');
  48. list($cartId) = UtilService::postMore(['cartId'], $request, true);
  49. if (!is_string($cartId) || !$cartId) return app('json')->fail('请提交购买的商品');
  50. $uid = $request->uid();
  51. $cartGroup = StoreCart::getUserProductCartList($uid, $cartId, 1);
  52. if (count($cartGroup['invalid'])) return app('json')->fail($cartGroup['invalid'][0]['productInfo']['store_name'] . '已失效!');
  53. if (!$cartGroup['valid']) return app('json')->fail('请提交购买的商品');
  54. $cartInfo = $cartGroup['valid'];
  55. $addr = UserAddress::where('uid', $uid)->where('is_default', 1)->find();
  56. $priceGroup = StoreOrder::getOrderPriceGroup($cartInfo, $addr);
  57. if ($priceGroup === false) {
  58. return app('json')->fail(StoreOrder::getErrorInfo('运费模板不存在'));
  59. }
  60. $other = [
  61. 'offlinePostage' => sys_config('offline_postage'),
  62. 'integralRatio' => sys_config('integral_ratio')
  63. ];
  64. $usableCoupons = StoreCouponUser::getUsableCouponList($uid, $cartGroup, $priceGroup['totalPrice']);
  65. $usableCoupon = isset($usableCoupons[0]) ? $usableCoupons[0] : null;
  66. $cartIdA = explode(',', $cartId);
  67. $seckill_id = 0;
  68. $combination_id = 0;
  69. $bargain_id = 0;
  70. if (count($cartIdA) == 1) {
  71. $seckill_id = StoreCart::where('id', $cartId)->value('seckill_id');
  72. $combination_id = StoreCart::where('id', $cartId)->value('combination_id');
  73. $bargain_id = StoreCart::where('id', $cartId)->value('bargain_id');
  74. }
  75. $data['deduction'] = $seckill_id || $combination_id || $bargain_id;
  76. $data['usableCoupon'] = $usableCoupon;
  77. $data['addressInfo'] = UserAddress::getUserDefaultAddress($uid);
  78. $data['seckill_id'] = $seckill_id;
  79. $data['combination_id'] = $combination_id;
  80. $data['bargain_id'] = $bargain_id;
  81. $data['cartInfo'] = $cartInfo;
  82. $data['priceGroup'] = $priceGroup;
  83. $data['orderKey'] = StoreOrder::cacheOrderInfo($uid, $cartInfo, $priceGroup, $other);
  84. $data['offlinePostage'] = $other['offlinePostage'];
  85. $vipId = UserLevel::getUserLevel($uid);
  86. $user = $request->user();
  87. if (isset($user['pwd'])) unset($user['pwd']);
  88. $user['vip'] = $vipId !== false ? true : false;
  89. if ($user['vip']) {
  90. $user['vip_id'] = $vipId;
  91. $user['discount'] = UserLevel::getUserLevelInfo($vipId, 'discount');
  92. }
  93. $data['userInfo'] = $user;
  94. $data['integralRatio'] = $other['integralRatio'];
  95. $data['offline_pay_status'] = (int)sys_config('offline_pay_status') ?? (int)2;
  96. $data['store_self_mention'] = (int)sys_config('store_self_mention') ?? 0;//门店自提是否开启
  97. $data['system_store'] = ($res = SystemStore::getStoreDispose()) ? $res : [];//门店信息
  98. return app('json')->successful($data);
  99. }
  100. /**
  101. * 计算订单金额
  102. * @param Request $request
  103. * @param $key
  104. * @return mixed
  105. * @throws \think\Exception
  106. * @throws \think\db\exception\DataNotFoundException
  107. * @throws \think\db\exception\ModelNotFoundException
  108. * @throws \think\exception\DbException
  109. */
  110. public function computedOrder(Request $request, $key)
  111. {
  112. // $priceGroup = StoreOrder::getOrderPriceGroup($cartInfo);
  113. if (!$key) return app('json')->fail('参数错误!');
  114. $uid = $request->uid();
  115. if (StoreOrder::be(['order_id|unique' => $key, 'uid' => $uid, 'is_del' => 0]))
  116. return app('json')->status('extend_order', '订单已生成', ['orderId' => $key, 'key' => $key]);
  117. list($addressId, $couponId, $payType, $useIntegral, $mark, $combinationId, $pinkId, $seckill_id, $formId, $bargainId, $shipping_type) = UtilService::postMore([
  118. 'addressId', 'couponId', ['payType', 'yue'], ['useIntegral', 0], 'mark', ['combinationId', 0], ['pinkId', 0], ['seckill_id', 0], ['formId', ''], ['bargainId', ''],
  119. ['shipping_type', 1],
  120. ], $request, true);
  121. $payType = strtolower($payType);
  122. if ($bargainId) {
  123. $bargainUserTableId = StoreBargainUser::getBargainUserTableId($bargainId, $uid);//TODO 获取用户参与砍价表编号
  124. if (!$bargainUserTableId)
  125. return app('json')->fail('砍价失败');
  126. $status = StoreBargainUser::getBargainUserStatusEnd($bargainUserTableId);
  127. if ($status == 3)
  128. return app('json')->fail('砍价已支付');
  129. StoreBargainUser::setBargainUserStatus($bargainId, $uid); //修改砍价状态
  130. }
  131. if ($pinkId) {
  132. if (StorePink::getIsPinkUid($pinkId, $request->uid()))
  133. return app('json')->status('ORDER_EXIST', '订单生成失败,你已经在该团内不能再参加了', ['orderId' => StoreOrder::getStoreIdPink($pinkId, $request->uid())]);
  134. if (StoreOrder::getIsOrderPink($pinkId, $request->uid()))
  135. return app('json')->status('ORDER_EXIST', '订单生成失败,你已经参加该团了,请先支付订单', ['orderId' => StoreOrder::getStoreIdPink($pinkId, $request->uid())]);
  136. }
  137. $priceGroup = StoreOrder::cacheKeyCreateOrder($request->uid(), $key, $addressId, $payType, (int)$useIntegral, $couponId, $mark, $combinationId, $pinkId, $seckill_id, $bargainId, true, 0, $shipping_type);
  138. if ($priceGroup)
  139. return app('json')->status('NONE', 'ok', $priceGroup);
  140. else
  141. return app('json')->fail(StoreOrder::getErrorInfo('计算失败'));
  142. }
  143. /**
  144. * 订单创建
  145. * @param Request $request
  146. * @param $key
  147. * @return mixed
  148. * @throws \think\Exception
  149. * @throws \think\db\exception\DataNotFoundException
  150. * @throws \think\db\exception\ModelNotFoundException
  151. * @throws \think\exception\DbException
  152. */
  153. public function create(Request $request, $key)
  154. {
  155. if (!$key) return app('json')->fail('参数错误!');
  156. $uid = $request->uid();
  157. if (StoreOrder::be(['order_id|unique' => $key, 'uid' => $uid, 'is_del' => 0]))
  158. return app('json')->status('extend_order', '订单已生成', ['orderId' => $key, 'key' => $key]);
  159. list($addressId, $couponId, $payType, $useIntegral, $mark, $combinationId, $pinkId, $seckill_id, $formId, $bargainId, $from, $shipping_type, $real_name, $phone, $storeId) = UtilService::postMore([
  160. 'addressId', 'couponId', 'payType', ['useIntegral', 0], 'mark', ['combinationId', 0], ['pinkId', 0], ['seckill_id', 0], ['formId', ''], ['bargainId', ''], ['from', 'weixin'],
  161. ['shipping_type', 1], ['real_name', ''], ['phone', ''], ['store_id', 0]
  162. ], $request, true);
  163. $payType = strtolower($payType);
  164. if ($bargainId) {
  165. $bargainUserTableId = StoreBargainUser::getBargainUserTableId($bargainId, $uid);//TODO 获取用户参与砍价表编号
  166. if (!$bargainUserTableId)
  167. return app('json')->fail('砍价失败');
  168. $status = StoreBargainUser::getBargainUserStatusEnd($bargainUserTableId);
  169. if ($status == 3)
  170. return app('json')->fail('砍价已支付');
  171. StoreBargainUser::setBargainUserStatus($bargainId, $uid); //修改砍价状态
  172. }
  173. if ($pinkId) {
  174. if (StorePink::getIsPinkUid($pinkId, $request->uid()))
  175. return app('json')->status('ORDER_EXIST', '订单生成失败,你已经在该团内不能再参加了', ['orderId' => StoreOrder::getStoreIdPink($pinkId, $request->uid())]);
  176. if (StoreOrder::getIsOrderPink($pinkId, $request->uid()))
  177. return app('json')->status('ORDER_EXIST', '订单生成失败,你已经参加该团了,请先支付订单', ['orderId' => StoreOrder::getStoreIdPink($pinkId, $request->uid())]);
  178. }
  179. $isChannel = 1;
  180. if ($from == 'weixin')
  181. $isChannel = 0;
  182. elseif ($from == 'weixinh5')
  183. $isChannel = 2;
  184. $order = StoreOrder::cacheKeyCreateOrder($request->uid(), $key, $addressId, $payType, (int)$useIntegral, $couponId, $mark, $combinationId, $pinkId, $seckill_id, $bargainId, false, $isChannel, $shipping_type, $real_name, $phone, $storeId);
  185. if ($order === false) return app('json')->fail(StoreOrder::getErrorInfo('订单生成失败'));
  186. $orderId = $order['order_id'];
  187. $info = compact('orderId', 'key');
  188. if ($orderId) {
  189. event('OrderCreated', [$order]); //订单创建成功事件
  190. event('ShortMssageSend', [$orderId, 'AdminPlaceAnOrder']);//发送管理员通知
  191. switch ($payType) {
  192. case "weixin":
  193. $orderInfo = StoreOrder::where('order_id', $orderId)->find();
  194. if (!$orderInfo || !isset($orderInfo['paid'])) return app('json')->fail('支付订单不存在!');
  195. $orderInfo = $orderInfo->toArray();
  196. if ($orderInfo['paid']) return app('json')->fail('支付已支付!');
  197. //支付金额为0
  198. if (bcsub((float)$orderInfo['pay_price'], 0, 2) <= 0) {
  199. //创建订单jspay支付
  200. $payPriceStatus = StoreOrder::jsPayPrice($orderId, $uid, $formId);
  201. if ($payPriceStatus)//0元支付成功
  202. return app('json')->status('success', '微信支付成功', $info);
  203. else
  204. return app('json')->status('pay_error', StoreOrder::getErrorInfo());
  205. } else {
  206. try {
  207. if ($from == 'routine') {
  208. $jsConfig = OrderRepository::jsPay($orderId); //创建订单jspay
  209. } else if ($from == 'weixinh5') {
  210. $jsConfig = OrderRepository::h5Pay($orderId);
  211. } else {
  212. $jsConfig = OrderRepository::wxPay($orderId);
  213. }
  214. } catch (\Exception $e) {
  215. return app('json')->status('pay_error', $e->getMessage(), $info);
  216. }
  217. $info['jsConfig'] = $jsConfig;
  218. if ($from == 'weixinh5') {
  219. return app('json')->status('wechat_h5_pay', '订单创建成功', $info);
  220. } else {
  221. return app('json')->status('wechat_pay', '订单创建成功', $info);
  222. }
  223. }
  224. break;
  225. case 'yue':
  226. if (StoreOrder::yuePay($orderId, $request->uid(), $formId))
  227. return app('json')->status('success', '余额支付成功', $info);
  228. else {
  229. $errorinfo = StoreOrder::getErrorInfo();
  230. if (is_array($errorinfo))
  231. return app('json')->status($errorinfo['status'], $errorinfo['msg'], $info);
  232. else
  233. return app('json')->status('pay_error', $errorinfo);
  234. }
  235. break;
  236. case 'offline':
  237. return app('json')->status('success', '订单创建成功', $info);
  238. break;
  239. }
  240. } else return app('json')->fail(StoreOrder::getErrorInfo('订单生成失败!'));
  241. }
  242. /**
  243. * 订单 再次下单
  244. * @param Request $request
  245. * @return mixed
  246. */
  247. public function again(Request $request)
  248. {
  249. list($uni) = UtilService::postMore([
  250. ['uni', ''],
  251. ], $request, true);
  252. if (!$uni) return app('json')->fail('参数错误!');
  253. $order = StoreOrder::getUserOrderDetail($request->uid(), $uni);
  254. if (!$order) return app('json')->fail('订单不存在!');
  255. $order = StoreOrder::tidyOrder($order, true);
  256. $res = [];
  257. foreach ($order['cartInfo'] as $v) {
  258. if ($v['combination_id']) return app('json')->fail('拼团产品不能再来一单,请在拼团产品内自行下单!');
  259. else if ($v['bargain_id']) return app('json')->fail('砍价产品不能再来一单,请在砍价产品内自行下单!');
  260. else if ($v['seckill_id']) return app('json')->ail('秒杀产品不能再来一单,请在秒杀产品内自行下单!');
  261. else $res[] = StoreCart::setCart($request->uid(), $v['product_id'], $v['cart_num'], isset($v['productInfo']['attrInfo']['unique']) ? $v['productInfo']['attrInfo']['unique'] : '', 'product', 0, 0);
  262. }
  263. $cateId = [];
  264. foreach ($res as $v) {
  265. if (!$v) return app('json')->fail('再来一单失败,请重新下单!');
  266. $cateId[] = $v['id'];
  267. }
  268. event('OrderCreateAgain', implode(',', $cateId));
  269. return app('json')->successful('ok', ['cateId' => implode(',', $cateId)]);
  270. }
  271. /**
  272. * 订单支付
  273. * @param Request $request
  274. * @return mixed
  275. */
  276. public function pay(Request $request)
  277. {
  278. // 获取请求参数
  279. list($uni, $paytype, $from) = UtilService::postMore([
  280. ['uni', ''],
  281. ['paytype', 'weixin'],
  282. ['from', 'weixin']
  283. ], $request, true);
  284. // 根据订单号和用户ID获取订单信息
  285. $order = StoreOrder::getUserOrderDetail($request->uid(), $uni);
  286. // 检查订单是否存在
  287. if (!$order) return app('json')->fail('订单不存在!');
  288. // 检查订单是否已支付
  289. if ($order['paid']) return app('json')->fail('该订单已支付!');
  290. // 检查订单是否失效
  291. if ($order['pink_id'] && StorePink::isPinkStatus($order['pink_id'])) return app('json')->fail('该订单已失效!');
  292. // 根据支付来源调整订单ID
  293. if ($from == 'weixin' && in_array($order->is_channel, [1, 2])) {
  294. $order['order_id'] = mt_rand(100, 999) . '_' . $order['order_id'];
  295. } elseif ($from == 'weixinh5' && in_array($order->is_channel, [0, 1])) {
  296. $order['order_id'] = mt_rand(100, 999) . '_' . $order['order_id'];
  297. } elseif ($from == 'routine' && in_array($order->is_channel, [0, 2])) {
  298. $order['order_id'] = mt_rand(100, 999) . '_' . $order['order_id'];
  299. }
  300. // 重新设置支付方式
  301. $order['pay_type'] = $paytype;
  302. // 根据支付方式进行处理
  303. switch ($order['pay_type']) {
  304. case 'weixin':
  305. try {
  306. $jsConfig = OrderRepository::jsPay($order);
  307. } catch (\Exception $e) {
  308. return app('json')->fail($e->getMessage());
  309. }
  310. if ($from == 'weixinh5') {
  311. return app('json')->status('wechat_h5_pay', ['jsConfig' => $jsConfig, 'order_id' => $order['order_id']]);
  312. } else {
  313. $this->set_parent($request->uid());
  314. return app('json')->status('wechat_pay', ['jsConfig' => $jsConfig, 'order_id' => $order['order_id']]);
  315. }
  316. break;
  317. case 'yue':
  318. if (StoreOrder::yuePay($order['order_id'], $request->uid())) {
  319. $this->set_parent($request->uid());
  320. return app('json')->status('success', '余额支付成功');
  321. } else {
  322. $error = StoreOrder::getErrorInfo();
  323. return app('json')->fail(is_array($error) && isset($error['msg']) ? $error['msg'] : $error);
  324. }
  325. break;
  326. case 'offline':
  327. StoreOrder::createOrderTemplate($order);
  328. if (StoreOrder::setOrderTypePayOffline($order['order_id'])) {
  329. return app('json')->status('success', '订单创建成功');
  330. } else {
  331. return app('json')->status('success', '支付失败');
  332. }
  333. break;
  334. }
  335. return app('json')->fail('支付方式错误');
  336. }
  337. public function set_parent($uid)
  338. {
  339. // 获取用户信息
  340. $user = User2::getUserInfo($uid);
  341. var_dump('1111111111111111111111');
  342. var_dump($user);
  343. if ($user['parent']) {
  344. return app('json')->fail('该用户已设置接点');
  345. }
  346. if (!StoreOrder::where('uid', $uid)->where('store_order', 1)->where('paid', 1)->find()) {
  347. return app('json')->fail('该用户尚未完成报单');
  348. }
  349. $product = StoreProduct::where('is_best', 1)->find();
  350. if (!$product) {
  351. return app('json')->fail('没有找到满足条件的商品');
  352. }
  353. $spreadUid = $user['spread_uid'];
  354. if ($spreadUid) {
  355. $spreadUser = User2::where('uid', $spreadUid)->find();
  356. if ($spreadUser) {
  357. if ($spreadUser['C_count'] == 0) {
  358. User2::where('uid', $spreadUid)->update(['C_count' => 1]);
  359. User2::where('uid', $uid)->update(['parent' => $spreadUid]);
  360. return app('json')->success('设置成功');
  361. } else {
  362. return app('json')->fail('目标C区已有下级');
  363. }
  364. }
  365. }
  366. return app('json')->fail('找不到满足条件的用户');
  367. }
  368. /**
  369. * 订单列表
  370. * @param Request $request
  371. * @return mixed
  372. */
  373. public function lst(Request $request)
  374. {
  375. list($type, $page, $limit, $search) = UtilService::getMore([
  376. ['type', ''],
  377. ['page', 0],
  378. ['limit', ''],
  379. ['search', ''],
  380. ], $request, true);
  381. return app('json')->successful(StoreOrder::getUserOrderSearchList($request->uid(), $type, $page, $limit, $search));
  382. }
  383. /**
  384. * 订单详情
  385. * @param Request $request
  386. * @param $uni
  387. * @return mixed
  388. */
  389. public function detail(Request $request, $uni)
  390. {
  391. if (!strlen(trim($uni))) return app('json')->fail('参数错误');
  392. $order = StoreOrder::getUserOrderDetail($request->uid(), $uni);
  393. if (!$order) return app('json')->fail('订单不存在');
  394. $order = $order->toArray();
  395. //是否开启门店自提
  396. $store_self_mention = sys_config('store_self_mention');
  397. //关闭门店自提后 订单隐藏门店信息
  398. if ($store_self_mention == 0) $order['shipping_type'] = 1;
  399. if ($order['verify_code']) {
  400. $verify_code = $order['verify_code'];
  401. $verify[] = substr($verify_code, 0, 4);
  402. $verify[] = substr($verify_code, 4, 4);
  403. $verify[] = substr($verify_code, 8);
  404. $order['_verify_code'] = implode(' ', $verify);
  405. }
  406. $order['add_time_y'] = date('Y-m-d', $order['add_time']);
  407. $order['add_time_h'] = date('H:i:s', $order['add_time']);
  408. $order['system_store'] = SystemStore::getStoreDispose($order['store_id']);
  409. if ($order['shipping_type'] === 2 && $order['verify_code']) {
  410. $name = $order['verify_code'] . '.jpg';
  411. $imageInfo = SystemAttachment::getInfo($name, 'name');
  412. $siteUrl = sys_config('site_url');
  413. if (!$imageInfo) {
  414. $imageInfo = UtilService::getQRCodePath($order['verify_code'], $name);
  415. if (is_array($imageInfo)) {
  416. SystemAttachment::attachmentAdd($imageInfo['name'], $imageInfo['size'], $imageInfo['type'], $imageInfo['dir'], $imageInfo['thumb_path'], 1, $imageInfo['image_type'], $imageInfo['time'], 2);
  417. $url = $imageInfo['dir'];
  418. } else
  419. $url = '';
  420. } else $url = $imageInfo['att_dir'];
  421. if (isset($imageInfo['image_type']) && $imageInfo['image_type'] == 1) $url = $siteUrl . $url;
  422. $order['code'] = $url;
  423. }
  424. $order['mapKey'] = sys_config('tengxun_map_key');
  425. return app('json')->successful('ok', StoreOrder::tidyOrder($order, true, true));
  426. }
  427. /**
  428. * 订单删除
  429. * @param Request $request
  430. * @return mixed
  431. */
  432. public function del(Request $request)
  433. {
  434. list($uni) = UtilService::postMore([
  435. ['uni', ''],
  436. ], $request, true);
  437. if (!$uni) return app('json')->fail('参数错误!');
  438. $res = StoreOrder::removeOrder($uni, $request->uid());
  439. if ($res)
  440. return app('json')->successful();
  441. else
  442. return app('json')->fail(StoreOrder::getErrorInfo());
  443. }
  444. /**
  445. * 订单收货
  446. * @param Request $request
  447. * @return mixed
  448. */
  449. public function take(Request $request)
  450. {
  451. list($uni) = UtilService::postMore([
  452. ['uni', ''],
  453. ], $request, true);
  454. if (!$uni) return app('json')->fail('参数错误!');
  455. $res = StoreOrder::takeOrder($uni, $request->uid());
  456. if ($res) {
  457. $order_info = StoreOrder::where('order_id', $uni)->find();
  458. $gain_integral = intval($order_info['gain_integral']);
  459. $gain_coupon = StoreCouponIssue::alias('a')
  460. ->join('store_coupon b', 'a.cid = b.id')
  461. ->where('a.status', 1)
  462. ->where('a.is_full_give', 1)
  463. ->where('a.is_del', 0)
  464. ->where('a.full_reduction', '<=', $order_info['total_price'])
  465. ->sum('b.coupon_price');
  466. return app('json')->successful(['gain_integral' => $gain_integral, 'gain_coupon' => $gain_coupon]);
  467. } else
  468. return app('json')->fail(StoreOrder::getErrorInfo());
  469. }
  470. /**
  471. * 订单 查看物流
  472. * @param Request $request
  473. * @param $uni
  474. * @return mixed
  475. */
  476. public function express(Request $request, $uni)
  477. {
  478. if (!$uni || !($order = StoreOrder::getUserOrderDetail($request->uid(), $uni))) return app('json')->fail('查询订单不存在!');
  479. if ($order['delivery_type'] != 'express' || !$order['delivery_id']) return app('json')->fail('该订单不存在快递单号!');
  480. $cacheName = $uni . $order['delivery_id'];
  481. $result = CacheService::get($cacheName, null);
  482. if ($result === NULL) {
  483. $result = ExpressService::query($order['delivery_id']);
  484. if (is_array($result) &&
  485. isset($result['result']) &&
  486. isset($result['result']['deliverystatus']) &&
  487. $result['result']['deliverystatus'] >= 3)
  488. $cacheTime = 0;
  489. else
  490. $cacheTime = 1800;
  491. CacheService::set($cacheName, $result, $cacheTime);
  492. }
  493. $orderInfo = [];
  494. $cartInfo = StoreOrderCartInfo::where('oid', $order['id'])->column('cart_info', 'unique') ?? [];
  495. $info = [];
  496. $cartNew = [];
  497. foreach ($cartInfo as $k => $cart) {
  498. $cart = json_decode($cart, true);
  499. $cartNew['cart_num'] = $cart['cart_num'];
  500. $cartNew['truePrice'] = $cart['truePrice'];
  501. $cartNew['productInfo']['image'] = $cart['productInfo']['image'];
  502. $cartNew['productInfo']['store_name'] = $cart['productInfo']['store_name'];
  503. $cartNew['productInfo']['unit_name'] = $cart['productInfo']['unit_name'] ?? '';
  504. array_push($info, $cartNew);
  505. unset($cart);
  506. }
  507. $orderInfo['delivery_id'] = $order['delivery_id'];
  508. $orderInfo['delivery_name'] = $order['delivery_name'];
  509. $orderInfo['delivery_type'] = $order['delivery_type'];
  510. $orderInfo['cartInfo'] = $info;
  511. return app('json')->successful(['order' => $orderInfo, 'express' => $result ? $result : []]);
  512. }
  513. /**
  514. * 订单评价
  515. * @param Request $request
  516. * @return mixed
  517. * @throws \think\db\exception\DataNotFoundException
  518. * @throws \think\db\exception\ModelNotFoundException
  519. * @throws \think\exception\DbException
  520. */
  521. public function comment(Request $request)
  522. {
  523. $group = UtilService::postMore([
  524. ['unique', ''], ['comment', ''], ['pics', ''], ['product_score', 5], ['service_score', 5]
  525. ], $request);
  526. $unique = $group['unique'];
  527. unset($group['unique']);
  528. if (!$unique) return app('json')->fail('参数错误!');
  529. $cartInfo = StoreOrderCartInfo::where('unique', $unique)->find();
  530. $uid = $request->uid();
  531. $user_info = User::get($uid);
  532. $group['nickname'] = $user_info['nickname'];
  533. $group['avatar'] = $user_info['avatar'];
  534. if (!$cartInfo) return app('json')->fail('评价产品不存在!');
  535. $orderUid = StoreOrder::getOrderInfo($cartInfo['oid'], 'uid')['uid'];
  536. if ($uid != $orderUid) return app('json')->fail('评价产品不存在!');
  537. if (StoreProductReply::be(['oid' => $cartInfo['oid'], 'unique' => $unique]))
  538. return app('json')->fail('该产品已评价!');
  539. $group['comment'] = htmlspecialchars(trim($group['comment']));
  540. if ($group['product_score'] < 1) return app('json')->fail('请为产品评分');
  541. else if ($group['service_score'] < 1) return app('json')->fail('请为商家服务评分');
  542. if ($cartInfo['cart_info']['combination_id']) $productId = $cartInfo['cart_info']['product_id'];
  543. else if ($cartInfo['cart_info']['seckill_id']) $productId = $cartInfo['cart_info']['product_id'];
  544. else if ($cartInfo['cart_info']['bargain_id']) $productId = $cartInfo['cart_info']['product_id'];
  545. else $productId = $cartInfo['product_id'];
  546. if ($group['pics']) $group['pics'] = json_encode(is_array($group['pics']) ? $group['pics'] : explode(',', $group['pics']));
  547. $group = array_merge($group, [
  548. 'uid' => $uid,
  549. 'oid' => $cartInfo['oid'],
  550. 'unique' => $unique,
  551. 'product_id' => $productId,
  552. 'add_time' => time(),
  553. 'reply_type' => 'product'
  554. ]);
  555. StoreProductReply::beginTrans();
  556. $res = StoreProductReply::reply($group, 'product');
  557. if (!$res) {
  558. StoreProductReply::rollbackTrans();
  559. return app('json')->fail('评价失败!');
  560. }
  561. try {
  562. StoreOrder::checkOrderOver($cartInfo['oid']);
  563. } catch (\Exception $e) {
  564. StoreProductReply::rollbackTrans();
  565. return app('json')->fail($e->getMessage());
  566. }
  567. StoreProductReply::commitTrans();
  568. event('UserCommented', $res);
  569. event('AdminNewPush');
  570. return app('json')->successful();
  571. }
  572. /**
  573. * 订单统计数据
  574. * @param Request $request
  575. * @return mixed
  576. */
  577. public function data(Request $request)
  578. {
  579. return app('json')->successful(StoreOrder::getOrderData($request->uid()));
  580. }
  581. /**
  582. * 订单退款理由
  583. * @return mixed
  584. */
  585. public function refund_reason()
  586. {
  587. $reason = sys_config('stor_reason') ?: [];//退款理由
  588. $reason = str_replace("\r\n", "\n", $reason);//防止不兼容
  589. $reason = explode("\n", $reason);
  590. return app('json')->successful($reason);
  591. }
  592. /**
  593. * 订单退款审核
  594. * @param Request $request
  595. * @return mixed
  596. */
  597. public function refund_verify(Request $request)
  598. {
  599. $data = UtilService::postMore([
  600. ['text', ''],
  601. ['refund_reason_wap_img', ''],
  602. ['refund_reason_wap_explain', ''],
  603. ['uni', '']
  604. ], $request);
  605. $uni = $data['uni'];
  606. unset($data['uni']);
  607. if ($data['refund_reason_wap_img']) $data['refund_reason_wap_img'] = explode(',', $data['refund_reason_wap_img']);
  608. if (!$uni || $data['text'] == '') return app('json')->fail('参数错误!');
  609. $res = StoreOrder::orderApplyRefund($uni, $request->uid(), $data['text'], $data['refund_reason_wap_explain'], $data['refund_reason_wap_img']);
  610. if ($res)
  611. return app('json')->successful('提交申请成功');
  612. else
  613. return app('json')->fail(StoreOrder::getErrorInfo());
  614. }
  615. /**
  616. * 订单取消 未支付的订单回退积分,回退优惠券,回退库存
  617. * @param Request $request
  618. * @return mixed
  619. * @throws \think\db\exception\DataNotFoundException
  620. * @throws \think\db\exception\ModelNotFoundException
  621. * @throws \think\exception\DbException
  622. */
  623. public function cancel(Request $request)
  624. {
  625. list($id) = UtilService::postMore([['id', 0]], $request, true);
  626. if (!$id) return app('json')->fail('参数错误');
  627. if (StoreOrder::cancelOrder($id, $request->uid()))
  628. return app('json')->successful('取消订单成功');
  629. return app('json')->fail(StoreOrder::getErrorInfo('取消订单失败'));
  630. }
  631. /**
  632. * 订单产品信息
  633. * @param Request $request
  634. * @return mixed
  635. * @throws \think\db\exception\DataNotFoundException
  636. * @throws \think\db\exception\ModelNotFoundException
  637. * @throws \think\exception\DbException
  638. */
  639. public function product(Request $request)
  640. {
  641. list($unique) = UtilService::postMore([['unique', '']], $request, true);
  642. if (!$unique || !StoreOrderCartInfo::be(['unique' => $unique]) || !($cartInfo = StoreOrderCartInfo::where('unique', $unique)->find())) return app('json')->fail('评价产品不存在!');
  643. $cartInfo = $cartInfo->toArray();
  644. $cartProduct = [];
  645. $cartProduct['cart_num'] = $cartInfo['cart_info']['cart_num'];
  646. $cartProduct['productInfo']['image'] = isset($cartInfo['cart_info']['productInfo']['image']) ? $cartInfo['cart_info']['productInfo']['image'] : '';
  647. $cartProduct['productInfo']['price'] = isset($cartInfo['cart_info']['productInfo']['price']) ? $cartInfo['cart_info']['productInfo']['price'] : 0;
  648. $cartProduct['productInfo']['store_name'] = isset($cartInfo['cart_info']['productInfo']['store_name']) ? $cartInfo['cart_info']['productInfo']['store_name'] : '';
  649. if (isset($cartInfo['cart_info']['productInfo']['attrInfo'])) {
  650. $cartProduct['productInfo']['attrInfo']['product_id'] = isset($cartInfo['cart_info']['productInfo']['attrInfo']['product_id']) ? $cartInfo['cart_info']['productInfo']['attrInfo']['product_id'] : '';
  651. $cartProduct['productInfo']['attrInfo']['suk'] = isset($cartInfo['cart_info']['productInfo']['attrInfo']['suk']) ? $cartInfo['cart_info']['productInfo']['attrInfo']['suk'] : '';
  652. $cartProduct['productInfo']['attrInfo']['price'] = isset($cartInfo['cart_info']['productInfo']['attrInfo']['price']) ? $cartInfo['cart_info']['productInfo']['attrInfo']['price'] : '';
  653. $cartProduct['productInfo']['attrInfo']['image'] = isset($cartInfo['cart_info']['productInfo']['attrInfo']['image']) ? $cartInfo['cart_info']['productInfo']['attrInfo']['image'] : '';
  654. }
  655. $cartProduct['product_id'] = isset($cartInfo['cart_info']['product_id']) ? $cartInfo['cart_info']['product_id'] : 0;
  656. $cartProduct['combination_id'] = isset($cartInfo['cart_info']['combination_id']) ? $cartInfo['cart_info']['combination_id'] : 0;
  657. $cartProduct['seckill_id'] = isset($cartInfo['cart_info']['seckill_id']) ? $cartInfo['cart_info']['seckill_id'] : 0;
  658. $cartProduct['bargain_id'] = isset($cartInfo['cart_info']['bargain_id']) ? $cartInfo['cart_info']['bargain_id'] : 0;
  659. $cartProduct['order_id'] = StoreOrder::where('id', $cartInfo['oid'])->value('order_id');
  660. return app('json')->successful($cartProduct);
  661. }
  662. /**
  663. * 首页获取未支付订单
  664. */
  665. public function get_noPay(Request $request)
  666. {
  667. return app('json')->successful(StoreOrder::getUserOrderSearchList($request->uid(), 0, 0, 0, ''));
  668. }
  669. }