OrderService.php 39 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045
  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\GoodsModel;
  13. use App\Models\GoodsSkuModel;
  14. use App\Models\MeetingModel;
  15. use App\Models\MeetingRecordsModel;
  16. use App\Models\MemberModel;
  17. use App\Models\OrderGoodsModel;
  18. use App\Models\OrderModel;
  19. use App\Models\StoreModel;
  20. use App\Services\BaseService;
  21. use App\Services\ConfigService;
  22. use App\Services\Kd100Service;
  23. use App\Services\PaymentService;
  24. use App\Services\RedisService;
  25. use Illuminate\Support\Facades\DB;
  26. /**
  27. * 订单-服务类
  28. * @author laravel开发员
  29. * @since 2020/11/11
  30. * @package App\Services\Api
  31. */
  32. class OrderService extends BaseService
  33. {
  34. // 静态对象
  35. protected static $instance = null;
  36. /**
  37. * 构造函数
  38. * @author laravel开发员
  39. * @since 2020/11/11
  40. */
  41. public function __construct()
  42. {
  43. $this->model = new OrderModel();
  44. }
  45. /**
  46. * 静态入口
  47. */
  48. public static function make()
  49. {
  50. if (!self::$instance) {
  51. self::$instance = new static();
  52. }
  53. return self::$instance;
  54. }
  55. /**
  56. * 订单列表
  57. * @param $params
  58. * @param int $pageSize
  59. * @return array
  60. */
  61. public function getDataList($params, $pageSize = 15)
  62. {
  63. $model = $this->getQuery($params);
  64. // 数据
  65. $list = $model->where(function ($query) use ($params) {
  66. $status = isset($params['status']) ? $params['status'] : 0;
  67. if ($status > 0 && is_array($status)) {
  68. $query->whereIn('a.status', $status)->where('a.refund_status', 0);
  69. } else if ($status == 4) {
  70. $query->where('a.status', $status)->where('a.refund_status', 0);
  71. } else if ($status > 0) {
  72. $query->where('a.status', $status)->where('a.refund_status', 0);
  73. }
  74. })->select(['a.*'])
  75. ->orderBy('a.id', 'desc')
  76. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  77. $list = $list ? $list->toArray() : [];
  78. if ($list) {
  79. $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '确认收货'];
  80. foreach ($list['data'] as &$item) {
  81. $item['create_time'] = $item['create_time'] ? dateFormat(strtotime($item['create_time']), 'Y-m-d') : '';
  82. $status = isset($item['status']) ? $item['status'] : 0;
  83. $item['status_text'] = '待支付';
  84. if ($status) {
  85. $item['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
  86. }
  87. if ($item['refund_status'] > 0) {
  88. $item['status_text'] = '退款/售后';
  89. }
  90. $item['goods'] = isset($item['goods']) && $item['goods'] ? $item['goods'] : [];
  91. $item['real_total'] = $item['pay_total'];
  92. $item['pay_total'] = moneyFormat($item['pay_total'] + $item['delivery_fee'], 2);
  93. }
  94. unset($item);
  95. }
  96. return [
  97. 'pageSize' => $pageSize,
  98. 'total' => isset($list['total']) ? $list['total'] : 0,
  99. 'list' => isset($list['data']) ? $list['data'] : []
  100. ];
  101. }
  102. /**
  103. * 查询条件
  104. * @param $params
  105. * @return mixed
  106. */
  107. public function getQuery($params)
  108. {
  109. $where = ['a.is_hide' => 0, 'a.mark' => 1];
  110. return $this->model->from('orders as a')
  111. ->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. $meetingId = isset($params['meeting_id']) ? intval($params['meeting_id']) : 0;
  121. if ($meetingId > 0) {
  122. $query->where('a.meeting_id', $meetingId);
  123. }
  124. })
  125. ->where(function ($query) use ($params) {
  126. $keyword = isset($params['keyword']) ? $params['keyword'] : '';
  127. if ($keyword) {
  128. $query->where('a.order_no', 'like', "%{$keyword}%")
  129. ->orWhere('b.mobile', 'like', "%{$keyword}%");
  130. }
  131. });
  132. }
  133. /**
  134. * 订单详情
  135. * @param $id
  136. */
  137. public function getOrderInfo($id, $no = '')
  138. {
  139. $where = ['a.order_no' => $no, 'a.id' => $id, 'a.mark' => 1];
  140. if ($no) {
  141. unset($where['a.id']);
  142. } else {
  143. unset($where['a.order_no']);
  144. }
  145. $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '已完成'];
  146. $info = $this->model->from('orders as a')
  147. ->with(['orderGoods', 'store'])
  148. ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
  149. ->where($where)
  150. ->select(['a.*'])
  151. ->first();
  152. if ($info) {
  153. $info = $info->toArray();
  154. $info['create_time'] = $info['create_time'] ? datetime($info['create_time'], 'Y-m-d H:i:s') : '';
  155. $info['pay_at'] = $info['pay_at'] ? datetime(strtotime($info['pay_at']), 'Y-m-d H:i:s') : '';
  156. $info['receiver_mobile_text'] = $info['receiver_mobile'] ? format_mobile($info['receiver_mobile']) : '';
  157. $info['real_total'] = $info['pay_total'];
  158. $info['pay_total'] = moneyFormat($info['pay_total'] + $info['delivery_fee'], 2);
  159. $status = isset($info['status']) ? $info['status'] : 0;
  160. $info['status_text'] = '待支付';
  161. if ($status) {
  162. $info['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
  163. }
  164. }
  165. return $info;
  166. }
  167. /**
  168. * 创建订单
  169. * @param $userId 用户
  170. * @param $params 参数
  171. * @return array|false
  172. */
  173. public function createOrder($userId, $params)
  174. {
  175. $addressId = isset($params['address_id']) && $params['address_id'] ? $params['address_id'] : 0;
  176. $goods = isset($params['goods']) && $params['goods'] ? $params['goods'] : [];
  177. $ids = $goods ? array_column($goods, 'id') : [];
  178. // 参数验证
  179. if (empty($goods) || empty($ids)) {
  180. $this->error = '商品参数不为空';
  181. return false;
  182. }
  183. if ($addressId <= 0) {
  184. $this->error = '请选择收货地址';
  185. return false;
  186. }
  187. // 缓存锁
  188. $cacheLockKey = "caches:orders:submit_lock:{$userId}";
  189. if (RedisService::get($cacheLockKey)) {
  190. $this->error = '订单处理中~';
  191. return false;
  192. }
  193. // 用户信息
  194. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  195. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  196. ->select(['id', 'openid', 'discount_point', 'status'])
  197. ->first();
  198. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  199. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : 0;
  200. $discountPoint = isset($userInfo['discount_point']) ? $userInfo['discount_point'] : 0; // 折扣
  201. if (empty($userInfo) || $status != 1) {
  202. $this->error = 1045;
  203. return false;
  204. }
  205. if (empty($openid)) {
  206. $this->error = 1042;
  207. return false;
  208. }
  209. // 商品数据
  210. $orderNo = get_order_num('JK');
  211. $result = GoodsService::make()->getOrderGoods($ids, $goods, $userId, $orderNo,$discountPoint);
  212. if (empty($result)) {
  213. RedisService::clear($cacheLockKey);
  214. $this->error = GoodsService::make()->getError();
  215. return false;
  216. }
  217. $orderGoods = isset($result['goods']) ? $result['goods'] : [];
  218. $goodsTotal = isset($result['goods_total']) ? $result['goods_total'] : 0; // 商品总价
  219. $orderTotal = isset($result['order_total']) ? $result['order_total'] : 0; // 订单结算金额(折后)
  220. $discountTotal = isset($result['discount_total']) ? $result['discount_total'] : 0; // 折扣金额
  221. $orderCount = isset($result['count']) ? $result['count'] : 0;
  222. $deliveryFee = isset($result['delivery_fee']) ? $result['delivery_fee'] : 0; // 运费
  223. $storeId = isset($result['store_id']) ? $result['store_id'] : 0; // 企业/商家
  224. if (empty($orderGoods)) {
  225. RedisService::clear($cacheLockKey);
  226. $this->error = '获取订单商品错误~';
  227. return false;
  228. }
  229. if ($orderTotal <= 0) {
  230. RedisService::clear($cacheLockKey);
  231. $this->error = '订单金额错误~';
  232. return false;
  233. }
  234. if ($orderCount <= 0) {
  235. RedisService::clear($cacheLockKey);
  236. $this->error = '订单商品数量错误~';
  237. return false;
  238. }
  239. // 收货地址信息
  240. $addressInfo = MemberAddressService::make()->getBindInfo($userId, $addressId);
  241. $realname = isset($addressInfo['realname']) ? $addressInfo['realname'] : '';
  242. $mobile = isset($addressInfo['mobile']) ? $addressInfo['mobile'] : '';
  243. $area = isset($addressInfo['area']) ? $addressInfo['area'] : '';
  244. $address = isset($addressInfo['address']) ? $addressInfo['address'] : '';
  245. if (empty($addressInfo) || empty($realname) || empty($mobile) || empty($area) || empty($address)) {
  246. RedisService::clear($cacheLockKey);
  247. $this->error = '收货地址信息错误,请核对后重试~';
  248. return false;
  249. }
  250. // 商家佣金
  251. $storeInfo = StoreModel::where(['id' => $storeId])->first();
  252. $bonusRate = isset($storeInfo['bonus_rate']) ? floatval($storeInfo['bonus_rate']) : 0;
  253. $storeBonusRate = ConfigService::make()->getConfigByCode('store_bonus_rate', 0);
  254. $storeBonusRate = $storeBonusRate > 0 && $storeBonusRate <= 100 ? $storeBonusRate : 0;
  255. $bonusRate = $bonusRate > 0 && $bonusRate <= 100 ? $bonusRate : $storeBonusRate;
  256. $bonus = moneyFormat($orderTotal * $bonusRate / 100, 2);
  257. if (env('PAY_DEBUG')) {
  258. $orderTotal = 0.1;
  259. }
  260. // 检查是否关联为会议订单,先签到的会议先关联
  261. $record = MeetingRecordsModel::with(['meeting'])->where(['user_id'=>$userId,'mark'=>1])
  262. ->where('expired_at','>=', date('Y-m-d H:i:s'))
  263. ->orderBy('id', 'asc')
  264. ->first();
  265. $recordMeetingId = isset($record['meeting_id'])? $record['meeting_id'] : 0;
  266. $meeting = isset($record['meeting'])?$record['meeting'] : [];
  267. $meetingBonusRate = isset($meeting['bonus_rate'])?$meeting['bonus_rate'] : 0;
  268. $meetingBonusRate = $meetingBonusRate>0 && $meetingBonusRate<100? $meetingBonusRate : 0;
  269. $meetingBonus = moneyFormat($orderTotal * $meetingBonusRate / 100, 2);
  270. // 是否开启分账功能
  271. $revenueOpen = ConfigService::make()->getConfigByCode('order_revenue_open', 0);
  272. // 订单数据
  273. $order = [
  274. 'order_no' => $orderNo,
  275. 'user_id' => $userId,
  276. 'store_id' => $storeId,
  277. 'meeting_id' => $recordMeetingId, // 关联会议
  278. 'total' => $goodsTotal, // 商品总价
  279. 'num' => $orderCount,
  280. 'pay_total' => $orderTotal, // 折扣后商品总价
  281. 'discount_point' => $discountPoint,
  282. 'discount_total' => $discountTotal, // 折扣金额
  283. 'delivery_fee' => $deliveryFee, // 运费
  284. 'receiver_name' => $realname,
  285. 'receiver_mobile' => $mobile,
  286. 'receiver_area' => $area,
  287. 'receiver_address' => $address,
  288. 'bonus' => $bonus,
  289. 'bonus_rate' => $bonusRate,
  290. 'is_revenue' => $revenueOpen==1?1: 2,
  291. 'meeting_bonus_rate' => $meetingBonusRate,
  292. 'meeting_bonus' => $meetingBonus,
  293. 'create_time' => time(),
  294. 'update_time' => time(),
  295. 'status' => 1,
  296. 'mark' => 1,
  297. ];
  298. // 订单处理
  299. DB::beginTransaction();
  300. if (!$orderId = $this->model->insertGetId($order)) {
  301. DB::rollBack();
  302. $this->error = '创建订单失败';
  303. RedisService::clear($cacheLockKey);
  304. return false;
  305. }
  306. // 订单商品
  307. if ($orderGoods && !OrderGoodsModel::insert($orderGoods)) {
  308. DB::rollBack();
  309. $this->error = '处理订单商品错误';
  310. RedisService::clear($cacheLockKey);
  311. return false;
  312. }
  313. // 获取支付参数
  314. /* TODO 支付处理 */
  315. $payOrder = [
  316. 'type' => 1,
  317. 'order_no' => $orderNo,
  318. 'is_revenue' => $order['is_revenue'],
  319. 'pay_money' => moneyFormat($orderTotal + $deliveryFee, 2),
  320. 'body' => '订单付款',
  321. 'openid' => $openid
  322. ];
  323. // 调起支付
  324. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  325. if (empty($payment)) {
  326. // DB::rollBack();
  327. RedisService::clear($cacheLockKey);
  328. $this->error = PaymentService::make()->getError();
  329. return false;
  330. }
  331. // 商品库存扣除
  332. if ($orderGoods) {
  333. foreach ($orderGoods as $goods) {
  334. $id = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
  335. $num = isset($goods['num']) ? $goods['num'] : 0;
  336. $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
  337. if ($id && !GoodsModel::where(['id' => $id])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
  338. DB::rollBack();
  339. RedisService::clear($cacheLockKey);
  340. $this->error = '商品库存处理失败';
  341. return false;
  342. }
  343. if ($skuId && !GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
  344. DB::rollBack();
  345. RedisService::clear($cacheLockKey);
  346. $this->error = '商品库存处理失败';
  347. return false;
  348. }
  349. }
  350. }
  351. // 用户操作记录
  352. DB::commit();
  353. $this->error = '订单创建成功,请前往支付~';
  354. RedisService::clear($cacheLockKey);
  355. return [
  356. 'order_id' => $orderId,
  357. 'payment' => $payment,
  358. 'total' => $payOrder['pay_money'],
  359. 'pay_type' => 10,
  360. ];
  361. }
  362. /**
  363. * 订单支付
  364. * @param $userId
  365. * @param $id
  366. * @return array|false
  367. */
  368. public function pay($userId, $id)
  369. {
  370. if ($id <= 0) {
  371. $this->error = '请选择支付订单';
  372. return false;
  373. }
  374. // 缓存锁
  375. $cacheLockKey = "caches:orders:pay_lock:{$userId}_{$id}";
  376. if (RedisService::get($cacheLockKey)) {
  377. $this->error = '订单处理中~';
  378. return false;
  379. }
  380. // 商品数据
  381. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  382. // 用户信息
  383. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  384. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  385. ->first();
  386. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  387. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : '';
  388. if (empty($userInfo) || $status != 1) {
  389. $this->error = 1045;
  390. RedisService::clear($cacheLockKey);
  391. return false;
  392. }
  393. if (empty($openid)) {
  394. $this->error = '用户微信未授权,请重新授权登录';
  395. RedisService::clear($cacheLockKey);
  396. return false;
  397. }
  398. // 订单信息
  399. $info = $this->model->where(['id' => $id, 'mark' => 1])
  400. ->select(['id', 'order_no', 'pay_total', 'delivery_fee', 'status'])
  401. ->first();
  402. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  403. $deliveryFee = isset($info['delivery_fee']) ? $info['delivery_fee'] : 0;
  404. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  405. $status = isset($info['status']) ? $info['status'] : 0;
  406. if (empty($info) || empty($orderNo)) {
  407. $this->error = '订单信息不存在';
  408. RedisService::clear($cacheLockKey);
  409. return false;
  410. }
  411. if ($status != 1) {
  412. $this->error = '订单已支付';
  413. RedisService::clear($cacheLockKey);
  414. return false;
  415. }
  416. // 获取支付参数
  417. /* TODO 支付处理 */
  418. $payOrder = [
  419. 'type' => 1,
  420. 'order_no' => $orderNo,
  421. 'pay_money' => moneyFormat($orderTotal + $deliveryFee),
  422. 'body' => '购物消费',
  423. 'openid' => $openid
  424. ];
  425. // 调起支付
  426. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  427. if (empty($payment)) {
  428. DB::rollBack();
  429. RedisService::clear($cacheLockKey);
  430. $this->error = PaymentService::make()->getError();
  431. return false;
  432. }
  433. // 用户操作记录
  434. DB::commit();
  435. $this->error = '支付请求成功,请前往支付~';
  436. RedisService::clear($cacheLockKey);
  437. return [
  438. 'order_id' => $id,
  439. 'payment' => $payment,
  440. 'total' => $payOrder['pay_money'],
  441. 'pay_type' => 10,
  442. ];
  443. }
  444. /**
  445. * 订单取消
  446. * @param $userId
  447. * @param $orderId
  448. * @return array|false
  449. */
  450. public function cancel($userId, $orderId)
  451. {
  452. if ($orderId <= 0) {
  453. $this->error = '请选择订单';
  454. return false;
  455. }
  456. // 缓存锁
  457. $cacheLockKey = "caches:orders:cancel_lock:{$userId}_{$orderId}";
  458. if (RedisService::get($cacheLockKey)) {
  459. $this->error = '订单处理中~';
  460. return false;
  461. }
  462. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  463. // 用户信息
  464. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  465. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  466. ->first();
  467. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  468. if (empty($userInfo) || $status != 1) {
  469. $this->error = 1045;
  470. RedisService::clear($cacheLockKey);
  471. return false;
  472. }
  473. // 订单信息
  474. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  475. ->select(['id', 'order_no', 'pay_total', 'status'])
  476. ->first();
  477. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  478. $status = isset($info['status']) ? $info['status'] : 0;
  479. if (empty($info) || empty($orderNo)) {
  480. $this->error = '订单信息不存在';
  481. RedisService::clear($cacheLockKey);
  482. return false;
  483. }
  484. if ($status != 1) {
  485. $this->error = '订单已支付';
  486. RedisService::clear($cacheLockKey);
  487. return false;
  488. }
  489. $orderGoods = OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 1])
  490. ->select(['goods_id', 'num', 'sku_id'])
  491. ->get();
  492. DB::beginTransaction();
  493. if ($orderGoods) {
  494. foreach ($orderGoods as $goods) {
  495. $goodsId = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
  496. $num = isset($goods['num']) ? $goods['num'] : 0;
  497. $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
  498. if ($goodsId && !GoodsModel::where(['id' => $goodsId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()])) {
  499. DB::rollBack();
  500. RedisService::clear($cacheLockKey);
  501. $this->error = '商品库存处理失败';
  502. return false;
  503. }
  504. if ($skuId && !GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()])) {
  505. DB::rollBack();
  506. RedisService::clear($cacheLockKey);
  507. $this->error = '商品库存处理失败';
  508. return false;
  509. }
  510. }
  511. }
  512. $this->error = '取消订单成功';
  513. $this->model->where(['user_id' => $userId, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  514. OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  515. $this->model->where(['id' => $orderId])->update(['mark' => 0, 'update_time' => time()]);
  516. OrderGoodsModel::where(['order_no' => $orderNo])->update(['mark' => 0, 'update_time' => time()]);
  517. DB::commit();
  518. return ['id' => $orderId];
  519. }
  520. /**
  521. * 订单删除隐藏
  522. * @param $userId
  523. * @param $orderId
  524. * @return array|false
  525. */
  526. public function hide($userId, $orderId)
  527. {
  528. if ($orderId <= 0) {
  529. $this->error = '请选择订单';
  530. return false;
  531. }
  532. // 缓存锁
  533. $cacheLockKey = "caches:orders:hide_lock:{$userId}_{$orderId}";
  534. if (RedisService::get($cacheLockKey)) {
  535. $this->error = '订单删除中~';
  536. return false;
  537. }
  538. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  539. // 用户信息
  540. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  541. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  542. ->first();
  543. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  544. if (empty($userInfo) || $status != 1) {
  545. $this->error = 1045;
  546. RedisService::clear($cacheLockKey);
  547. return false;
  548. }
  549. // 订单信息
  550. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  551. ->select(['id', 'order_no', 'pay_total', 'status'])
  552. ->first();
  553. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  554. $status = isset($info['status']) ? $info['status'] : 0;
  555. if (empty($info) || empty($orderNo)) {
  556. $this->error = '订单信息不存在';
  557. RedisService::clear($cacheLockKey);
  558. return false;
  559. }
  560. if ($status != 4) {
  561. $this->error = '订单未完成';
  562. RedisService::clear($cacheLockKey);
  563. return false;
  564. }
  565. $this->error = '删除订单成功';
  566. $this->model->where(['id' => $orderId])->update(['is_hide' => 1, 'update_time' => time()]);
  567. return ['id' => $orderId];
  568. }
  569. /**
  570. * 订单完成
  571. * @param $userId 订单用户ID
  572. * @param $id 订单ID
  573. * @return array|false
  574. */
  575. public function complete($userId, $id, $check = true)
  576. {
  577. if ($id <= 0) {
  578. $this->error = '请选择订单';
  579. return false;
  580. }
  581. // 缓存锁
  582. $cacheLockKey = "caches:orders:complete_lock:{$userId}_{$id}";
  583. if (RedisService::get($cacheLockKey)) {
  584. $this->error = '订单处理中~';
  585. return false;
  586. }
  587. // 商品数据
  588. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  589. // 用户信息
  590. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  591. ->select(['id', 'openid', 'mobile', 'parent_id', 'nickname', 'realname', 'balance', 'status'])
  592. ->first();
  593. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  594. $parentId = isset($userInfo['parent_id']) ? $userInfo['parent_id'] : 0;
  595. if ($check && (empty($userInfo) || $status != 1)) {
  596. $this->error = 1045;
  597. RedisService::clear($cacheLockKey);
  598. return false;
  599. }
  600. // 订单信息
  601. $info = $this->model->with(['orderGoods'])->where(['id' => $id, 'mark' => 1])
  602. ->select(['id', 'order_no','user_id', 'store_id','meeting_id', 'pay_total', 'bonus', 'delivery_no', 'delivery_company', 'delivery_code', 'status'])
  603. ->first();
  604. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  605. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  606. $deliverCompany = isset($info['delivery_company']) ? $info['delivery_company'] : '';
  607. $orderUserId = isset($info['user_id']) ? $info['user_id'] : 0;
  608. $storeId = isset($info['store_id']) ? $info['store_id'] : 0;
  609. $meetingId = isset($info['meeting_id']) ? $info['meeting_id'] : 0;
  610. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  611. $bonus = isset($info['bonus']) ? $info['bonus'] : 0;
  612. $status = isset($info['status']) ? $info['status'] : 0;
  613. $orderGoods = isset($info['order_goods']) ? $info['order_goods'] : [];
  614. if (empty($info) || empty($orderNo)) {
  615. $this->error = '订单信息不存在';
  616. RedisService::clear($cacheLockKey);
  617. return false;
  618. }
  619. if ($status != 3) {
  620. $this->error = '订单未发货';
  621. RedisService::clear($cacheLockKey);
  622. return false;
  623. }
  624. if (empty($deliveryNo) || empty($deliverCompany)) {
  625. $this->error = '订单发货信息错误,请联系客服';
  626. $this->model->where(['id' => $id])->update(['is_complete' => 1, 'complete_remark' => $this->error]);
  627. RedisService::clear("caches:orders:completeList");
  628. RedisService::clear($cacheLockKey);
  629. return false;
  630. }
  631. DB::beginTransaction();
  632. $updateData = ['status' => 4, 'complete_at' => date('Y-m-d H:i:s'), 'update_time' => time()];
  633. if (!$check) {
  634. $updateData['is_complete'] = 1;
  635. $updateData['complete_remark'] = '自动收货';
  636. }
  637. $this->model->where(['id' => $id])->update($updateData);
  638. // 商家订单数据统计
  639. $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
  640. StoreModel::where(['id' => $storeId])->update($updateData);
  641. // 商品销量数据
  642. if ($orderGoods) {
  643. $counts = [];
  644. foreach ($orderGoods as $item) {
  645. $counts[$item['goods_id']] = isset($counts[$item['goods_id']]) ? $counts[$item['goods_id']] : 0;
  646. $counts[$item['goods_id']] += $item['num'];
  647. }
  648. if ($counts) {
  649. foreach ($counts as $id => $v) {
  650. GoodsModel::where(['id' => $id])->update(['sales' => DB::raw("sales + {$v}"), 'update_time' => time()]);
  651. }
  652. }
  653. }
  654. // 结算商家收益
  655. if (SettleService::make()->storeBonus($storeId, $bonus, $info) < 0) {
  656. DB::rollBack();
  657. $this->error = SettleService::make()->getError();
  658. RedisService::clear($cacheLockKey);
  659. return false;
  660. }
  661. // 关联会议统计
  662. if($meetingId){
  663. // 会议成交统计
  664. $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
  665. MeetingModel::where(['id' => $meetingId])->update($updateData);
  666. // 签到用户成交统计
  667. $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
  668. MeetingRecordsModel::where(['meeting_id' => $meetingId,'user_id'=>$orderUserId])->update($updateData);
  669. }
  670. DB::commit();
  671. $this->error = '确认收货成功';
  672. RedisService::clear("caches:orders:completeList");
  673. RedisService::clear("caches:orders:revenueList");
  674. return ['id' => $id, 'msg' => $this->error];
  675. }
  676. /**
  677. * 售后或退款
  678. * @param $userId
  679. * @param $params
  680. * @return array|false
  681. */
  682. public function after($userId, $params)
  683. {
  684. $id = isset($params['id']) ? $params['id'] : 0;
  685. $afterType = isset($params['after_type']) ? $params['after_type'] : 1;
  686. if ($id <= 0) {
  687. $this->error = '请选择订单';
  688. return false;
  689. }
  690. // 缓存锁
  691. $cacheLockKey = "caches:orders:after_lock:{$userId}_{$id}";
  692. if (RedisService::get($cacheLockKey)) {
  693. $this->error = '订单处理中~';
  694. return false;
  695. }
  696. // 商品数据
  697. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  698. // 用户信息
  699. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  700. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  701. ->first();
  702. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  703. if (empty($userInfo) || $status != 1) {
  704. $this->error = 1045;
  705. RedisService::clear($cacheLockKey);
  706. return false;
  707. }
  708. // 订单信息
  709. $info = $this->model->where(['id' => $id, 'mark' => 1])
  710. ->select(['id', 'order_no', 'after_type', 'refund_status', 'pay_total', 'status'])
  711. ->first();
  712. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  713. $status = isset($info['status']) ? $info['status'] : 0;
  714. $refundStatus = isset($info['refund_status']) ? $info['refund_status'] : 0;
  715. if (empty($info) || empty($orderNo)) {
  716. $this->error = '订单信息不存在';
  717. RedisService::clear($cacheLockKey);
  718. return false;
  719. }
  720. if ($status == 1) {
  721. $this->error = '订单未支付';
  722. RedisService::clear($cacheLockKey);
  723. return false;
  724. }
  725. if ($status == 4 && $afterType == 2) {
  726. $this->error = '订单已完成';
  727. RedisService::clear($cacheLockKey);
  728. return false;
  729. }
  730. if ($refundStatus > 0 && $refundStatus != 4) {
  731. $this->error = '订单售后处理中';
  732. RedisService::clear($cacheLockKey);
  733. return false;
  734. }
  735. $afterRealname = isset($params['after_realname']) ? $params['after_realname'] : '';
  736. $afterPhone = isset($params['after_phone']) ? $params['after_phone'] : '';
  737. $afterRemark = isset($params['after_remark']) ? $params['after_remark'] : '';
  738. if ($afterType == 1) {
  739. if (empty($afterRealname) || empty($afterPhone) || empty($afterRemark)) {
  740. $this->error = '请填写售后信息';
  741. RedisService::clear($cacheLockKey);
  742. return false;
  743. }
  744. }
  745. $data = [
  746. 'after_type' => $afterType,
  747. 'after_realname' => $afterRealname,
  748. 'after_phone' => $afterPhone,
  749. 'after_remark' => $afterRemark,
  750. 'refund_remark' => isset($params['refund_remark']) ? $params['refund_remark'] : '',
  751. 'refund_status' => 3,
  752. 'update_time' => time()
  753. ];
  754. $this->model->where(['id' => $id])->update($data);
  755. $this->error = '订单申请售后成功';
  756. return ['id' => $id];
  757. }
  758. /**
  759. * 物流查询
  760. * @param $id
  761. * @return array|false|mixed
  762. */
  763. public function getDelivery($id)
  764. {
  765. $info = $this->model->where(['id' => $id, 'mark' => 1])->first();
  766. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  767. $deliveryCode = isset($info['delivery_code']) ? $info['delivery_code'] : '';
  768. $mobile = isset($info['receiver_mobile']) ? $info['receiver_mobile'] : '';
  769. $receiverArea = isset($info['receiver_area']) && $info['receiver_area'] ? $info['receiver_area'] : '';
  770. if (empty($info)) {
  771. $this->error = '请选择订单';
  772. return false;
  773. }
  774. $cacheKey = "caches:kd100:order_{$id}";
  775. $data = RedisService::get($cacheKey);
  776. if ($data) {
  777. return $data;
  778. }
  779. $result = Kd100Service::make()->query($deliveryNo, $mobile, $deliveryCode, $receiverArea);
  780. RedisService::set($cacheKey . '_result', $result, 300);
  781. $status = isset($result['status']) ? $result['status'] : 0;
  782. $data = isset($result['data']) ? $result['data'] : [];
  783. $courierInfo = isset($result['courierInfo']) ? $result['courierInfo'] : [];
  784. $arrivalTime = isset($result['arrivalTime']) ? $result['arrivalTime'] : '';
  785. $predictedRoute = isset($result['predictedRoute']) ? $result['predictedRoute'] : [];
  786. $predictedData = $predictedRoute ? end($predictedRoute) : [];
  787. $arrivalData = [];
  788. if ($arrivalTime) {
  789. $arrivalData['arrivalTime'] = dayFormat(strtotime($arrivalTime . ':00:00'));
  790. $arrivalData['predictedData'] = $predictedData;
  791. }
  792. if ($courierInfo && $courierInfo['deliveryManPhone']) {
  793. $courierInfo['deliveryManPhone'] = explode(',', $courierInfo['deliveryManPhone']);
  794. $courierInfo['deliveryPhone'] = $courierInfo['deliveryManPhone'][1] ? $courierInfo['deliveryManPhone'][1] : $courierInfo['deliveryManPhone'][0];
  795. }
  796. if ($data && $status == 200) {
  797. RedisService::set($cacheKey, ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data], 1200);
  798. }
  799. return $data ? ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data] : [];
  800. }
  801. /**
  802. * 已发货待完成订单
  803. * @return array|mixed
  804. */
  805. public function getCompleteOrders()
  806. {
  807. $cacheKey = "caches:orders:completeList";
  808. $datas = RedisService::get($cacheKey);
  809. if ($datas) {
  810. return $datas;
  811. }
  812. $completeDay = ConfigService::make()->getConfigByCode('order_complete_day', 7);
  813. $limitNum = ConfigService::make()->getConfigByCode('order_complete_batch_num', 300);
  814. $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
  815. $completeDay = $completeDay >= 1 && $completeDay < 30 ? $completeDay : 7;
  816. $datas = $this->model->where(['status' => 3, 'is_complete' => 2, 'mark' => 1])
  817. ->whereNotNull('delivery_no')
  818. ->select(['id', 'user_id', 'order_no', 'status'])
  819. ->where('pay_at', '<=', date('Y-m-d H:i:s', time() - $completeDay * 86400))
  820. ->limit($limitNum)
  821. ->get();
  822. $datas = $datas ? $datas->toArray() : [];
  823. if ($datas) {
  824. RedisService::set($cacheKey, $datas, rand(300, 600));
  825. }
  826. return $datas;
  827. }
  828. /**
  829. * 已完成,待分账订单
  830. * @return array|mixed
  831. */
  832. public function getRevenueOrderList()
  833. {
  834. $cacheKey = "caches:orders:revenueList";
  835. $datas = RedisService::get($cacheKey);
  836. if ($datas) {
  837. return $datas;
  838. }
  839. $limitNum = ConfigService::make()->getConfigByCode('order_revenue_batch_num', 300);
  840. $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
  841. $datas = $this->model->where(['status' => 4, 'is_revenue' => 2, 'mark' => 1])
  842. ->whereNotNull('delivery_no')
  843. ->select(['id', 'user_id','pay_total', 'order_no','transaction_id', 'status'])
  844. ->limit($limitNum)
  845. ->get();
  846. $datas = $datas ? $datas->toArray() : [];
  847. if ($datas) {
  848. RedisService::set($cacheKey, $datas, rand(300, 600));
  849. }
  850. return $datas;
  851. }
  852. /**
  853. * 订单分账处理
  854. * @param $id
  855. * @return false
  856. * @throws \Yansongda\Pay\Exception\ContainerException
  857. * @throws \Yansongda\Pay\Exception\InvalidParamsException
  858. */
  859. public function revenue($id)
  860. {
  861. if ($id <= 0) {
  862. $this->error = '订单参数错误';
  863. return false;
  864. }
  865. // 缓存锁
  866. $cacheLockKey = "caches:orders:revenue_lock:{$id}";
  867. if (RedisService::get($cacheLockKey)) {
  868. $this->error = '订单分账处理中~';
  869. return false;
  870. }
  871. // 是否设置分账账户
  872. $revenueOpenid = ConfigService::make()->getConfigByCode('order_revenue_openid', '');
  873. $revenueRate = ConfigService::make()->getConfigByCode('order_revenue_rate', 0);
  874. if(empty($revenueOpenid)){
  875. $this->error = '订单分账账户未配置';
  876. return false;
  877. }
  878. $revenueRate = $revenueRate>0 && $revenueRate<100? $revenueRate: 0;
  879. if($revenueRate<=0){
  880. $this->error = '订单分账比例未配置';
  881. return false;
  882. }
  883. // 订单信息
  884. $info = $this->model->where(['id' => $id, 'mark' => 1])
  885. ->select(['id', 'order_no','user_id','transaction_id', 'pay_total', 'status'])
  886. ->first();
  887. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  888. $payTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  889. $status = isset($info['status']) ? $info['status'] : 0;
  890. if($payTotal<=0){
  891. $this->error = '订单支付金额参数错误';
  892. return false;
  893. }
  894. if($status != 4){
  895. $this->error = '订单状态错误,未完成收货的订单无法分账';
  896. return false;
  897. }
  898. $revenueAmount = moneyFormat($payTotal * $revenueRate/100,2);
  899. $revenueAmount = $revenueAmount<=0.01?0.01:$revenueAmount;
  900. if($revenueAmount<=0){
  901. $this->error = '订单分账金额不足';
  902. return false;
  903. }
  904. $outOrderNo = str_replace('RE','JK', $orderNo);
  905. $order = [
  906. 'transaction_id'=> $info['transaction_id'],
  907. 'out_order_no'=> $outOrderNo,
  908. 'body'=> '订单分账',
  909. 'amount'=> $revenueAmount,
  910. 'unsplit'=> true, // 只分一次
  911. ];
  912. if(!$this->model->where(['id'=>$id])->update(['revenue_no'=>$outOrderNo,'revenue_amount'=>$revenueAmount,'update_time'=>time()])){
  913. $this->error = '订单分账数据更新失败';
  914. return false;
  915. }
  916. $result = PaymentService::make()->profitsharing($revenueOpenid, $order);
  917. $code = isset($result->code)? $result->code : 0;
  918. $state = isset($result->state)? $result->state : 0;
  919. $message = isset($result->message)? $result->message : '分账失败';
  920. if($state == 'FINISHED'){
  921. }else{
  922. }
  923. // $code = isset($re)
  924. dump($code);
  925. dump($state);
  926. dump($message);
  927. dump($result);
  928. }
  929. }