OrderService.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Api;
  12. use App\Models\CartModel;
  13. use App\Models\GoodsModel;
  14. use App\Models\GoodsSkuModel;
  15. use App\Models\MemberModel;
  16. use App\Models\OrderGoodsModel;
  17. use App\Models\OrderModel;
  18. use App\Models\StoreModel;
  19. use App\Services\BaseService;
  20. use App\Services\ConfigService;
  21. use App\Services\Kd100Service;
  22. use App\Services\PaymentService;
  23. use App\Services\RedisService;
  24. use Illuminate\Support\Facades\DB;
  25. /**
  26. * 订单-服务类
  27. * @author laravel开发员
  28. * @since 2020/11/11
  29. * @package App\Services\Api
  30. */
  31. class OrderService extends BaseService
  32. {
  33. // 静态对象
  34. protected static $instance = null;
  35. /**
  36. * 构造函数
  37. * @author laravel开发员
  38. * @since 2020/11/11
  39. */
  40. public function __construct()
  41. {
  42. $this->model = new OrderModel();
  43. }
  44. /**
  45. * 静态入口
  46. */
  47. public static function make()
  48. {
  49. if (!self::$instance) {
  50. self::$instance = new static();
  51. }
  52. return self::$instance;
  53. }
  54. /**
  55. * 订单列表
  56. * @param $params
  57. * @param int $pageSize
  58. * @return array
  59. */
  60. public function getDataList($params, $pageSize = 15)
  61. {
  62. $model = $this->getQuery($params);
  63. // 数据
  64. $list = $model->where(function ($query) use ($params) {
  65. $status = isset($params['status']) ? $params['status'] : 0;
  66. // 进行中
  67. if ($status == 9) {
  68. $query->where('a.refund_status', '>', 0);
  69. } elseif ($status > 0 && is_array($status)) {
  70. $query->whereIn('a.status', $status)->where('a.refund_status', 0);
  71. } else if ($status == 4) {
  72. $query->where('a.status', $status)->where('a.refund_status', 0);
  73. } else if ($status > 0) {
  74. $query->where('a.status', $status)->where('a.refund_status', 0);
  75. }
  76. })->select(['a.*'])
  77. // ->orderBy('a.status', 'asc')
  78. ->orderBy('a.id', 'desc')
  79. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  80. $list = $list ? $list->toArray() : [];
  81. if ($list) {
  82. $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '确认收货'];
  83. foreach ($list['data'] as &$item) {
  84. $item['create_time'] = $item['create_time'] ? dateFormat(strtotime($item['create_time']), 'Y-m-d') : '';
  85. $status = isset($item['status']) ? $item['status'] : 0;
  86. $item['status_text'] = '待支付';
  87. if ($status) {
  88. $item['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
  89. }
  90. if ($item['refund_status'] > 0) {
  91. $item['status_text'] = '退款/售后';
  92. }
  93. $item['goods'] = isset($item['goods']) && $item['goods'] ? $item['goods'] : [];
  94. }
  95. unset($item);
  96. }
  97. return [
  98. 'pageSize' => $pageSize,
  99. 'total' => isset($list['total']) ? $list['total'] : 0,
  100. 'list' => isset($list['data']) ? $list['data'] : []
  101. ];
  102. }
  103. /**
  104. * 查询条件
  105. * @param $params
  106. * @return mixed
  107. */
  108. public function getQuery($params)
  109. {
  110. $where = ['a.mark' => 1];
  111. return $this->model->from('orders as a')->with(['orderGoods', 'store'])
  112. ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
  113. ->where($where)
  114. ->where(function ($query) use ($params) {
  115. $userId = isset($params['user_id']) ? intval($params['user_id']) : 0;
  116. if ($userId > 0) {
  117. $query->where('a.user_id', $userId);
  118. }
  119. })
  120. ->where(function ($query) use ($params) {
  121. $keyword = isset($params['keyword']) ? $params['keyword'] : '';
  122. if ($keyword) {
  123. $query->where('a.order_no', 'like', "%{$keyword}%")
  124. ->orWhere('b.mobile', 'like', "%{$keyword}%");
  125. }
  126. });
  127. }
  128. /**
  129. * 订单详情
  130. * @param $id
  131. */
  132. public function getOrderInfo($id, $no='')
  133. {
  134. $where = ['a.order_no'=>$no,'a.id' => $id, 'a.mark' => 1];
  135. if($no){
  136. unset($where['a.id']);
  137. }else{
  138. unset($where['a.order_no']);
  139. }
  140. $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '已完成'];
  141. $info = $this->model->from('orders as a')
  142. ->with(['orderGoods','store'])
  143. ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
  144. ->where($where)
  145. ->select(['a.*'])
  146. ->first();
  147. if ($info) {
  148. $info = $info->toArray();
  149. $info['create_time'] = $info['create_time'] ? datetime($info['create_time'], 'Y-m-d H:i:s') : '';
  150. $info['pay_at'] = $info['pay_at'] ? datetime(strtotime($info['pay_at']), 'Y-m-d H:i:s') : '';
  151. $info['receiver_mobile_text'] = $info['receiver_mobile']? format_mobile($info['receiver_mobile']):'';
  152. $status = isset($info['status']) ? $info['status'] : 0;
  153. $info['status_text'] = '待支付';
  154. if ($status) {
  155. $info['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
  156. }
  157. }
  158. return $info;
  159. }
  160. /**
  161. * 创建订单
  162. * @param $userId 用户
  163. * @param $params 参数
  164. * @return array|false
  165. */
  166. public function createOrder($userId, $params)
  167. {
  168. try {
  169. $submitType = isset($params['type']) && $params['type'] ? $params['type'] : '';
  170. $addressId = isset($params['address_id']) && $params['address_id'] ? $params['address_id'] : 0;
  171. $goods = isset($params['goods']) && $params['goods'] ? $params['goods'] : [];
  172. $ids = $goods ? array_column($goods, 'id') : [];
  173. $skuIds = $goods ? array_column($goods, 'sku_id') : [];
  174. // 参数验证
  175. if (empty($goods) || empty($ids)) {
  176. $this->error = '商品参数不为空';
  177. return false;
  178. }
  179. if ($addressId <= 0) {
  180. $this->error = '请选择收货地址';
  181. return false;
  182. }
  183. // 缓存锁
  184. $cacheLockKey = "caches:orders:submit_lock:{$userId}";
  185. if (RedisService::get($cacheLockKey)) {
  186. $this->error = '订单处理中~';
  187. return false;
  188. }
  189. // 商品数据
  190. $orderNo = get_order_num('GX');
  191. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  192. $result = GoodsService::make()->getOrderGoods($ids, $goods, $orderNo, $userId);
  193. if (empty($result)) {
  194. RedisService::clear($cacheLockKey);
  195. $this->error = GoodsService::make()->getError();
  196. return false;
  197. }
  198. $orderGoods = isset($result['goods']) ? $result['goods'] : [];
  199. $orderTotal = isset($result['total']) ? $result['total'] : 0;
  200. $orderCount = isset($result['count']) ? $result['count'] : 0;
  201. $deliveryFee = isset($result['delivery_fee']) ? $result['delivery_fee'] : 0; // 运费
  202. $storeId = isset($result['store_id']) ? $result['store_id'] : 0; // 企业/商家
  203. if (empty($orderGoods)) {
  204. RedisService::clear($cacheLockKey);
  205. $this->error = '获取订单商品错误~';
  206. return false;
  207. }
  208. if ($orderTotal <= 0) {
  209. RedisService::clear($cacheLockKey);
  210. $this->error = '订单金额错误~';
  211. return false;
  212. }
  213. if ($orderCount <= 0) {
  214. RedisService::clear($cacheLockKey);
  215. $this->error = '订单商品数量错误~';
  216. return false;
  217. }
  218. // 用户信息
  219. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  220. ->select(['id', 'openid', 'mobile', 'nickname','discount_point', 'realname', 'balance', 'status'])
  221. ->first();
  222. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  223. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : '';
  224. $discountPoint = isset($userInfo['discount_point']) ? $userInfo['discount_point'] : 0; // 折扣
  225. if (empty($userInfo) || $status != 1) {
  226. $this->error = 1045;
  227. RedisService::clear($cacheLockKey);
  228. return false;
  229. }
  230. if (empty($openid)) {
  231. $this->error = '用户微信未授权,请重新授权登录';
  232. RedisService::clear($cacheLockKey);
  233. return false;
  234. }
  235. // 收货地址信息
  236. $addressInfo = MemberAddressService::make()->getBindInfo($userId, $addressId);
  237. $realname = isset($addressInfo['realname']) ? $addressInfo['realname'] : '';
  238. $mobile = isset($addressInfo['mobile']) ? $addressInfo['mobile'] : '';
  239. $area = isset($addressInfo['area']) ? $addressInfo['area'] : '';
  240. $address = isset($addressInfo['address']) ? $addressInfo['address'] : '';
  241. if (empty($addressInfo) || empty($realname) || empty($mobile) || empty($area) || empty($address)) {
  242. RedisService::clear($cacheLockKey);
  243. $this->error = '收货地址信息错误,请核对后重试~';
  244. return false;
  245. }
  246. // 商家佣金
  247. $storeInfo = StoreModel::where(['id' => $storeId])->first();
  248. $bonusRate = isset($storeInfo['bonus_rate']) ? floatval($storeInfo['bonus_rate']) : 0;
  249. $storeBonusRate = ConfigService::make()->getConfigByCode('store_bonus_rate', 0);
  250. $storeBonusRate = $storeBonusRate > 0 && $storeBonusRate <= 100 ? $storeBonusRate : 0;
  251. $bonusRate = $bonusRate > 0 && $bonusRate <= 100 ? $bonusRate : $storeBonusRate;
  252. $bonus = moneyFormat($orderTotal * $bonusRate / 100, 2);
  253. // 折扣
  254. $discountTotal = 0;
  255. $total = $orderTotal;
  256. if($discountPoint>0 && $discountPoint<1){
  257. $orderTotal = moneyFormat((1-$discountPoint) * $discountPoint,2);
  258. $discountTotal = moneyFormat($total - $orderTotal,2);
  259. }
  260. // 邮费
  261. $total = moneyFormat($total + $deliveryFee,2);
  262. if (env('PAY_DEBUG')) {
  263. $orderTotal = 0.1;
  264. }
  265. // 订单数据
  266. $order = [
  267. 'order_no' => $orderNo,
  268. 'user_id' => $userId,
  269. 'store_id' => $storeId,
  270. 'total' => $total,
  271. 'num' => $orderCount,
  272. 'pay_total' => $orderTotal,
  273. 'discount_point' => $discountPoint,
  274. 'discount_total' => $discountTotal,
  275. 'delivery_fee' => $deliveryFee,
  276. 'receiver_name' => $realname,
  277. 'receiver_mobile' => $mobile,
  278. 'receiver_area' => $area,
  279. 'receiver_address' => $address,
  280. 'bonus' => $bonus,
  281. 'create_time' => time(),
  282. 'update_time' => time(),
  283. 'status' => 1,
  284. 'mark' => 1,
  285. ];
  286. // 订单处理
  287. DB::beginTransaction();
  288. if (!$orderId = $this->model->insertGetId($order)) {
  289. DB::rollBack();
  290. $this->error = '创建订单失败';
  291. RedisService::clear($cacheLockKey);
  292. return false;
  293. }
  294. // 订单商品
  295. if ($orderGoods && !OrderGoodsModel::insert($orderGoods)) {
  296. DB::rollBack();
  297. $this->error = '处理订单商品错误';
  298. RedisService::clear($cacheLockKey);
  299. return false;
  300. }
  301. // 获取支付参数
  302. /* TODO 支付处理 */
  303. $payOrder = [
  304. 'type' => 1,
  305. 'order_no' => $orderNo,
  306. 'pay_money' => moneyFormat($orderTotal + $deliveryFee,2),
  307. 'body' => '购物消费',
  308. 'openid' => $openid
  309. ];
  310. // 调起支付
  311. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  312. if (empty($payment)) {
  313. // DB::rollBack();
  314. RedisService::clear($cacheLockKey);
  315. $this->error = PaymentService::make()->getError();
  316. return false;
  317. }
  318. // 商品库存扣除
  319. if($orderGoods){
  320. foreach($orderGoods as $goods){
  321. $id = isset($goods['goods_id'])?$goods['goods_id']:0;
  322. $num = isset($goods['num'])?$goods['num']:0;
  323. $skuId = isset($goods['sku_id'])?$goods['sku_id']:0;
  324. if($id && !GoodsModel::where(['id'=>$id])->update(['stock'=>DB::raw("stock - {$num}"),'update_time'=>time()])){
  325. DB::rollBack();
  326. RedisService::clear($cacheLockKey);
  327. $this->error = '商品库存处理失败';
  328. return false;
  329. }
  330. if($skuId && !GoodsSkuModel::where(['id'=>$skuId])->update(['stock'=>DB::raw("stock - {$num}"),'update_time'=>time()])){
  331. DB::rollBack();
  332. RedisService::clear($cacheLockKey);
  333. $this->error = '商品库存处理失败';
  334. return false;
  335. }
  336. }
  337. }
  338. // 用户操作记录
  339. DB::commit();
  340. $this->error = '订单创建成功,请前往支付~';
  341. RedisService::clear($cacheLockKey);
  342. return [
  343. 'order_id' => $orderId,
  344. 'payment' => $payment,
  345. 'total' => $payOrder['pay_money'],
  346. 'pay_type' => 10,
  347. ];
  348. } catch (\Exception $exception){
  349. $this->error = '创建订单失败:'.$exception->getMessage();
  350. return false;
  351. }
  352. }
  353. /**
  354. * 订单支付
  355. * @param $userId
  356. * @param $id
  357. * @return array|false
  358. */
  359. public function pay($userId, $id)
  360. {
  361. if ($id <= 0) {
  362. $this->error = '请选择支付订单';
  363. return false;
  364. }
  365. // 缓存锁
  366. $cacheLockKey = "caches:orders:pay_lock:{$userId}_{$id}";
  367. if (RedisService::get($cacheLockKey)) {
  368. $this->error = '订单处理中~';
  369. return false;
  370. }
  371. // 商品数据
  372. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  373. // 用户信息
  374. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  375. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  376. ->first();
  377. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  378. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : '';
  379. if (empty($userInfo) || $status != 1) {
  380. $this->error = 1045;
  381. RedisService::clear($cacheLockKey);
  382. return false;
  383. }
  384. if (empty($openid)) {
  385. $this->error = '用户微信未授权,请重新授权登录';
  386. RedisService::clear($cacheLockKey);
  387. return false;
  388. }
  389. // 订单信息
  390. $info = $this->model->where(['id' => $id, 'mark' => 1])
  391. ->select(['id', 'order_no', 'pay_total', 'status'])
  392. ->first();
  393. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  394. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  395. $status = isset($info['status']) ? $info['status'] : 0;
  396. if (empty($info) || empty($orderNo)) {
  397. $this->error = '订单信息不存在';
  398. RedisService::clear($cacheLockKey);
  399. return false;
  400. }
  401. if ($status != 1) {
  402. $this->error = '订单已支付';
  403. RedisService::clear($cacheLockKey);
  404. return false;
  405. }
  406. // 获取支付参数
  407. /* TODO 支付处理 */
  408. $payOrder = [
  409. 'type' => 1,
  410. 'order_no' => $orderNo,
  411. 'pay_money' => $orderTotal,
  412. 'body' => '购物消费',
  413. 'openid' => $openid
  414. ];
  415. // 调起支付
  416. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  417. if (empty($payment)) {
  418. DB::rollBack();
  419. RedisService::clear($cacheLockKey);
  420. $this->error = PaymentService::make()->getError();
  421. return false;
  422. }
  423. // 用户操作记录
  424. DB::commit();
  425. $this->error = '支付请求成功,请前往支付~';
  426. RedisService::clear($cacheLockKey);
  427. return [
  428. 'order_id' => $id,
  429. 'payment' => $payment,
  430. 'total' => $payOrder['pay_money'],
  431. 'pay_type' => 10,
  432. ];
  433. }
  434. /**
  435. * 订单取消
  436. * @param $userId
  437. * @param $orderId
  438. * @return array|false
  439. */
  440. public function cancel($userId, $orderId)
  441. {
  442. if ($orderId <= 0) {
  443. $this->error = '请选择订单';
  444. return false;
  445. }
  446. // 缓存锁
  447. $cacheLockKey = "caches:orders:cancel_lock:{$userId}_{$orderId}";
  448. if (RedisService::get($cacheLockKey)) {
  449. $this->error = '订单处理中~';
  450. return false;
  451. }
  452. // 商品数据
  453. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  454. // 用户信息
  455. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  456. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  457. ->first();
  458. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  459. if (empty($userInfo) || $status != 1) {
  460. $this->error = 1045;
  461. RedisService::clear($cacheLockKey);
  462. return false;
  463. }
  464. // 订单信息
  465. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  466. ->select(['id', 'order_no', 'pay_total', 'status'])
  467. ->first();
  468. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  469. $status = isset($info['status']) ? $info['status'] : 0;
  470. if (empty($info) || empty($orderNo)) {
  471. $this->error = '订单信息不存在';
  472. RedisService::clear($cacheLockKey);
  473. return false;
  474. }
  475. if ($status != 1) {
  476. $this->error = '订单已支付';
  477. RedisService::clear($cacheLockKey);
  478. return false;
  479. }
  480. $orderGoods = OrderGoodsModel::where(['order_no'=> $orderNo,'mark'=>1])
  481. ->select(['goods_id','num','sku_id'])
  482. ->get();
  483. DB::beginTransaction();
  484. if($orderGoods){
  485. foreach($orderGoods as $goods){
  486. $goodsId = isset($goods['goods_id'])?$goods['goods_id']:0;
  487. $num = isset($goods['num'])?$goods['num']:0;
  488. $skuId = isset($goods['sku_id'])?$goods['sku_id']:0;
  489. if($goodsId && !GoodsModel::where(['id'=>$goodsId])->update(['stock'=>DB::raw("stock + {$num}"),'update_time'=>time()])){
  490. DB::rollBack();
  491. RedisService::clear($cacheLockKey);
  492. $this->error = '商品库存处理失败';
  493. return false;
  494. }
  495. if($skuId && !GoodsSkuModel::where(['id'=>$skuId])->update(['stock'=>DB::raw("stock + {$num}"),'update_time'=>time()])){
  496. DB::rollBack();
  497. RedisService::clear($cacheLockKey);
  498. $this->error = '商品库存处理失败';
  499. return false;
  500. }
  501. }
  502. }
  503. $this->error = '取消订单成功';
  504. $this->model->where(['user_id' => $userId, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  505. OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  506. $this->model->where(['id' => $orderId])->update(['mark' => 0, 'update_time' => time()]);
  507. OrderGoodsModel::where(['order_no' => $orderNo])->update(['mark' => 0, 'update_time' => time()]);
  508. DB::commit();
  509. return ['id' => $orderId];
  510. }
  511. /**
  512. * 订单完成
  513. * @param $userId 订单用户ID
  514. * @param $id 订单ID
  515. * @return array|false
  516. */
  517. public function complete($userId, $id, $check= true)
  518. {
  519. if ($id <= 0) {
  520. $this->error = '请选择订单';
  521. return false;
  522. }
  523. // 缓存锁
  524. $cacheLockKey = "caches:orders:complete_lock:{$userId}_{$id}";
  525. if (RedisService::get($cacheLockKey)) {
  526. $this->error = '订单处理中~';
  527. return false;
  528. }
  529. // 商品数据
  530. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  531. // 用户信息
  532. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  533. ->select(['id', 'openid', 'mobile', 'parent_id', 'nickname', 'realname', 'balance', 'status'])
  534. ->first();
  535. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  536. $parentId = isset($userInfo['parent_id']) ? $userInfo['parent_id'] : 0;
  537. if ($check && (empty($userInfo) || $status != 1)) {
  538. $this->error = 1045;
  539. RedisService::clear($cacheLockKey);
  540. return false;
  541. }
  542. // 订单信息
  543. $info = $this->model->with(['orderGoods'])->where(['id' => $id, 'mark' => 1])
  544. ->select(['id', 'order_no', 'store_id', 'pay_total', 'bonus', 'delivery_no', 'delivery_company', 'delivery_code', 'status'])
  545. ->first();
  546. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  547. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  548. $deliverCompany = isset($info['delivery_company']) ? $info['delivery_company'] : '';
  549. $storeId = isset($info['store_id']) ? $info['store_id'] : 0;
  550. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  551. $bonus = isset($info['bonus']) ? $info['bonus'] : 0;
  552. $status = isset($info['status']) ? $info['status'] : 0;
  553. $orderGoods = isset($info['order_goods']) ? $info['order_goods'] : [];
  554. if (empty($info) || empty($orderNo)) {
  555. $this->error = '订单信息不存在';
  556. RedisService::clear($cacheLockKey);
  557. return false;
  558. }
  559. if ($status != 3) {
  560. $this->error = '订单未发货';
  561. RedisService::clear($cacheLockKey);
  562. return false;
  563. }
  564. if (empty($deliveryNo) || empty($deliverCompany)) {
  565. $this->error = '订单发货信息错误,请联系客服';
  566. $this->model->where(['id'=>$id])->update(['is_complete'=>1,'complete_remark'=>$this->error]);
  567. RedisService::clear("caches:orders:completeList");
  568. RedisService::clear($cacheLockKey);
  569. return false;
  570. }
  571. DB::beginTransaction();
  572. $updateData = ['status' => 4, 'update_time' => time()];
  573. if(!$check){
  574. $updateData['is_complete'] = 1;
  575. $updateData['complete_remark'] = '自动收货';
  576. }
  577. $this->model->where(['id' => $id])->update($updateData);
  578. // 商家订单数据统计
  579. $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
  580. StoreModel::where(['id' => $storeId])->update($updateData);
  581. // 商品销量数据
  582. if ($orderGoods) {
  583. $counts = [];
  584. foreach ($orderGoods as $item) {
  585. $counts[$item['goods_id']] = isset($counts[$item['goods_id']]) ? $counts[$item['goods_id']] : 0;
  586. $counts[$item['goods_id']] += $item['num'];
  587. }
  588. if ($counts) {
  589. foreach ($counts as $id => $v) {
  590. GoodsModel::where(['id' => $id])->update(['sales' => DB::raw("sales + {$v}"), 'update_time' => time()]);
  591. }
  592. }
  593. }
  594. // 结算商家收益
  595. if (SettleService::make()->storeBonus($storeId, $bonus, $info) < 0) {
  596. DB::rollBack();
  597. $this->error = SettleService::make()->getError();
  598. RedisService::clear($cacheLockKey);
  599. return false;
  600. }
  601. // 代理佣金结算
  602. if (SettleService::make()->agentBonus($userId, $orderTotal, $info, $parentId) < 0) {
  603. DB::rollBack();
  604. $this->error = SettleService::make()->getError();
  605. RedisService::clear($cacheLockKey);
  606. return false;
  607. }
  608. DB::commit();
  609. $this->error = '确认收货成功';
  610. RedisService::clear("caches:orders:completeList");
  611. return ['id' => $id,'msg'=>$this->error];
  612. }
  613. /**
  614. * 售后或退款
  615. * @param $userId
  616. * @param $params
  617. * @return array|false
  618. */
  619. public function after($userId, $params)
  620. {
  621. $id = isset($params['id']) ? $params['id'] : 0;
  622. $afterType = isset($params['after_type']) ? $params['after_type'] : 1;
  623. if ($id <= 0) {
  624. $this->error = '请选择订单';
  625. return false;
  626. }
  627. // 缓存锁
  628. $cacheLockKey = "caches:orders:after_lock:{$userId}_{$id}";
  629. if (RedisService::get($cacheLockKey)) {
  630. $this->error = '订单处理中~';
  631. return false;
  632. }
  633. // 商品数据
  634. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  635. // 用户信息
  636. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  637. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  638. ->first();
  639. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  640. if (empty($userInfo) || $status != 1) {
  641. $this->error = 1045;
  642. RedisService::clear($cacheLockKey);
  643. return false;
  644. }
  645. // 订单信息
  646. $info = $this->model->where(['id' => $id, 'mark' => 1])
  647. ->select(['id', 'order_no', 'after_type', 'refund_status', 'pay_total', 'status'])
  648. ->first();
  649. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  650. $status = isset($info['status']) ? $info['status'] : 0;
  651. $refundStatus = isset($info['refund_status']) ? $info['refund_status'] : 0;
  652. if (empty($info) || empty($orderNo)) {
  653. $this->error = '订单信息不存在';
  654. RedisService::clear($cacheLockKey);
  655. return false;
  656. }
  657. if ($status == 1) {
  658. $this->error = '订单未支付';
  659. RedisService::clear($cacheLockKey);
  660. return false;
  661. }
  662. if ($status == 4 && $afterType==2) {
  663. $this->error = '订单已完成';
  664. RedisService::clear($cacheLockKey);
  665. return false;
  666. }
  667. if ($refundStatus > 0 && $refundStatus != 4) {
  668. $this->error = '订单售后处理中';
  669. RedisService::clear($cacheLockKey);
  670. return false;
  671. }
  672. $afterRealname = isset($params['after_realname']) ? $params['after_realname'] : '';
  673. $afterPhone = isset($params['after_phone']) ? $params['after_phone'] : '';
  674. $afterRemark = isset($params['after_remark']) ? $params['after_remark'] : '';
  675. if ($afterType == 1) {
  676. if (empty($afterRealname) || empty($afterPhone) || empty($afterRemark)) {
  677. $this->error = '请填写售后信息';
  678. RedisService::clear($cacheLockKey);
  679. return false;
  680. }
  681. }
  682. $data = [
  683. 'after_type' => $afterType,
  684. 'after_realname' => $afterRealname,
  685. 'after_phone' => $afterPhone,
  686. 'after_remark' => $afterRemark,
  687. 'refund_remark' => isset($params['refund_remark']) ? $params['refund_remark'] : '',
  688. 'refund_status' => 3,
  689. 'update_time' => time()
  690. ];
  691. $this->model->where(['id' => $id])->update($data);
  692. $this->error = '订单申请售后成功';
  693. return ['id' => $id];
  694. }
  695. /**
  696. * 物流查询
  697. * @param $id
  698. * @return array|false|mixed
  699. */
  700. public function getDelivery($id)
  701. {
  702. $info = $this->model->where(['id' => $id, 'mark' => 1])->first();
  703. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  704. $deliveryCode = isset($info['delivery_code']) ? $info['delivery_code'] : '';
  705. $mobile = isset($info['receiver_mobile']) ? $info['receiver_mobile'] : '';
  706. $receiverArea = isset($info['receiver_area']) && $info['receiver_area']? $info['receiver_area'] : '';
  707. if (empty($info)) {
  708. $this->error = '请选择订单';
  709. return false;
  710. }
  711. $cacheKey = "caches:kd100:order_{$id}";
  712. $data = RedisService::get($cacheKey);
  713. if ($data) {
  714. return $data;
  715. }
  716. $result = Kd100Service::make()->query($deliveryNo, $mobile, $deliveryCode,$receiverArea);
  717. RedisService::set($cacheKey.'_result', $result, 300);
  718. $status = isset($result['status'])?$result['status']:0;
  719. $data = isset($result['data'])?$result['data']:[];
  720. $courierInfo = isset($result['courierInfo'])?$result['courierInfo']:[];
  721. $arrivalTime = isset($result['arrivalTime'])?$result['arrivalTime']:'';
  722. $predictedRoute = isset($result['predictedRoute'])?$result['predictedRoute']:[];
  723. $predictedData = $predictedRoute?end($predictedRoute):[];
  724. $arrivalData = [];
  725. if($arrivalTime){
  726. $arrivalData['arrivalTime'] = dayFormat(strtotime($arrivalTime.':00:00'));
  727. $arrivalData['predictedData'] = $predictedData;
  728. }
  729. if($courierInfo && $courierInfo['deliveryManPhone']){
  730. $courierInfo['deliveryManPhone'] = explode(',', $courierInfo['deliveryManPhone']);
  731. $courierInfo['deliveryPhone'] = $courierInfo['deliveryManPhone'][1]?$courierInfo['deliveryManPhone'][1]:$courierInfo['deliveryManPhone'][0];
  732. }
  733. if ($data && $status==200) {
  734. RedisService::set($cacheKey, ['info'=>$courierInfo,'arrivalData'=>$arrivalData,'list'=>$data], 1200);
  735. }
  736. return $data?['info'=>$courierInfo,'arrivalData'=>$arrivalData,'list'=>$data]:[];
  737. }
  738. /**
  739. * 已发货待完成订单
  740. * @return array|mixed
  741. */
  742. public function getCompleteOrders()
  743. {
  744. $cacheKey = "caches:orders:completeList";
  745. $datas = RedisService::get($cacheKey);
  746. if($datas){
  747. return $datas;
  748. }
  749. $completeDay = ConfigService::make()->getConfigByCode('order_complete_day',7);
  750. $limitNum = ConfigService::make()->getConfigByCode('order_complete_batch_num',300);
  751. $limitNum = $limitNum>10 && $limitNum<2000? $limitNum : 300;
  752. $completeDay = $completeDay>=1 && $completeDay<30? $completeDay : 7;
  753. $datas = $this->model->where(['status'=>3,'is_complete'=>2,'mark'=>1])
  754. ->whereNotNull('delivery_no')
  755. ->select(['id','user_id','order_no','status'])
  756. ->where('pay_at','<=', date('Y-m-d H:i:s', time() - $completeDay * 86400))
  757. ->limit($limitNum)
  758. ->get();
  759. $datas = $datas?$datas->toArray() : [];
  760. if($datas){
  761. RedisService::set($cacheKey, $datas, rand(300, 600));
  762. }
  763. return $datas;
  764. }
  765. }