OrderService.php 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128
  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\MemberCouponModel;
  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 => '待评价',5=>'已完成'];
  80. foreach ($list['data'] as &$item) {
  81. $item['create_time'] = $item['create_time'] ? datetime(strtotime($item['create_time']), 'Y-m-d H:i') : '';
  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. $couponId = isset($params['coupon_id']) && $params['coupon_id'] ? $params['coupon_id'] : 0;
  177. $payType = isset($params['pay_type']) && $params['pay_type'] ? $params['pay_type'] : 10;
  178. $submitType = isset($params['submit_type']) && $params['submit_type'] ? $params['submit_type'] : 0;
  179. $remark = isset($params['remark']) && $params['remark'] ? $params['remark'] : '';
  180. $goods = isset($params['goods']) && $params['goods'] ? $params['goods'] : [];
  181. $ids = $goods ? array_column($goods, 'id') : [];
  182. // 参数验证
  183. if (empty($goods) || empty($ids)) {
  184. $this->error = '商品参数不为空';
  185. return false;
  186. }
  187. if ($addressId <= 0) {
  188. $this->error = '请选择收货地址';
  189. return false;
  190. }
  191. // 缓存锁
  192. $cacheLockKey = "caches:orders:submit_lock:{$userId}";
  193. if (RedisService::get($cacheLockKey)) {
  194. $this->error = '订单处理中~';
  195. return false;
  196. }
  197. // 用户信息
  198. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  199. $userInfo = MemberModel::with(['levelData'])->where(['id' => $userId, 'mark' => 1])
  200. ->select(['id', 'openid','vip_expired', 'member_level', 'status'])
  201. ->first();
  202. $userInfo = $userInfo?$userInfo->toArray() : [];
  203. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  204. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : 0;
  205. $vipExpired = isset($userInfo['vip_expired']) ? $userInfo['vip_expired'] : 0;
  206. $levelData = isset($userInfo['level_data']) ? $userInfo['level_data'] : [];
  207. if (empty($userInfo) || $status != 1) {
  208. $this->error = 1045;
  209. return false;
  210. }
  211. if (empty($openid)) {
  212. $this->error = 1042;
  213. return false;
  214. }
  215. // 有效会员和折扣
  216. $discountPoint = 0;
  217. if($vipExpired != 0){
  218. $discountPoint = isset($levelData['discount']) ? $levelData['discount'] : 0; // 会员折扣
  219. }
  220. // 商品数据
  221. $orderNo = get_order_num('JK');
  222. $result = GoodsService::make()->getOrderGoods($ids, $goods, $userId, $orderNo, $discountPoint, $couponId);
  223. if (empty($result)) {
  224. RedisService::clear($cacheLockKey);
  225. $this->error = GoodsService::make()->getError();
  226. return false;
  227. }
  228. $orderGoods = isset($result['goods']) ? $result['goods'] : [];
  229. $goodsTotal = isset($result['goods_total']) ? $result['goods_total'] : 0; // 商品总价
  230. $orderTotal = isset($result['order_total']) ? $result['order_total'] : 0; // 订单结算金额(折后)
  231. $discountTotal = isset($result['discount_total']) ? $result['discount_total'] : 0; // 会员折扣金额
  232. $couponTotal = isset($result['coupon_total']) ? $result['coupon_total'] : 0; // 优惠金额
  233. $orderCount = isset($result['count']) ? $result['count'] : 0;
  234. $deliveryFee = isset($result['delivery_fee']) ? $result['delivery_fee'] : 0; // 运费
  235. $storeId = isset($result['store_id']) ? $result['store_id'] : 0; // 企业/商家
  236. if (empty($orderGoods)) {
  237. RedisService::clear($cacheLockKey);
  238. $this->error = '获取订单商品错误~';
  239. return false;
  240. }
  241. if ($orderTotal <= 0) {
  242. RedisService::clear($cacheLockKey);
  243. $this->error = '订单金额错误~';
  244. return false;
  245. }
  246. if ($orderCount <= 0) {
  247. RedisService::clear($cacheLockKey);
  248. $this->error = '订单商品数量错误~';
  249. return false;
  250. }
  251. // 收货地址信息
  252. $addressInfo = MemberAddressService::make()->getBindInfo($userId, $addressId);
  253. $realname = isset($addressInfo['realname']) ? $addressInfo['realname'] : '';
  254. $mobile = isset($addressInfo['mobile']) ? $addressInfo['mobile'] : '';
  255. $area = isset($addressInfo['area']) ? $addressInfo['area'] : '';
  256. $address = isset($addressInfo['address']) ? $addressInfo['address'] : '';
  257. if (empty($addressInfo) || empty($realname) || empty($mobile) || empty($area) || empty($address)) {
  258. RedisService::clear($cacheLockKey);
  259. $this->error = '收货地址信息错误,请核对后重试~';
  260. return false;
  261. }
  262. // 是否开启分账功能
  263. $payTotal = moneyFormat($orderTotal + $deliveryFee, 2); // 含运费支付金额
  264. $revenueOpen = ConfigService::make()->getConfigByCode('order_revenue_open', 0);
  265. $revenueRate = ConfigService::make()->getConfigByCode('order_revenue_rate', 30);
  266. $revenueRate = $revenueRate>0 && $revenueRate<100? $revenueRate: 30;
  267. $revenueAmount = moneyFormat($payTotal * $revenueRate/100,2);
  268. if (env('PAY_DEBUG')) {
  269. $revenueAmount = 0.01;
  270. $payTotal = 0.01;
  271. }
  272. // 订单数据
  273. $order = [
  274. 'order_no' => $orderNo,
  275. 'user_id' => $userId,
  276. 'store_id' => $storeId,
  277. 'total' => $goodsTotal, // 商品总价
  278. 'num' => $orderCount,
  279. 'pay_type' => $payType, // 支付方式
  280. 'pay_total' => $orderTotal, // 折扣后商品总价(不含运费)
  281. 'discount_point' => $discountPoint, //会员折扣
  282. 'discount_total' => $discountTotal, // 会员折扣金额
  283. 'coupon_id' => $couponId, // 优惠券
  284. 'coupon_total' => $couponTotal, // 优惠金额
  285. 'delivery_fee' => $deliveryFee, // 运费
  286. 'receiver_name' => $realname,
  287. 'receiver_mobile' => $mobile,
  288. 'receiver_area' => $area,
  289. 'receiver_address' => $address,
  290. 'is_revenue' => $revenueOpen==1?1: 2,
  291. 'revenue_no' => $revenueOpen==1?(str_replace('JK','RE',$orderNo)):'',
  292. 'revenue_amount' => $revenueOpen==1?$revenueAmount:0,
  293. 'remark' => $remark,
  294. 'create_time' => time(),
  295. 'update_time' => time(),
  296. 'status' => 1,
  297. 'mark' => 1,
  298. ];
  299. // 订单处理
  300. DB::beginTransaction();
  301. if (!$orderId = $this->model->insertGetId($order)) {
  302. DB::rollBack();
  303. $this->error = '创建订单失败';
  304. RedisService::clear($cacheLockKey);
  305. return false;
  306. }
  307. // 订单商品
  308. if ($orderGoods && !OrderGoodsModel::insert($orderGoods)) {
  309. DB::rollBack();
  310. $this->error = '处理订单商品错误';
  311. RedisService::clear($cacheLockKey);
  312. return false;
  313. }
  314. // 商家佣金和收益计算
  315. $order['id'] = $orderId;
  316. if(!$commission = SettleService::make()->commissionCount($order, $orderGoods, $userInfo)){
  317. Db::rollBack();
  318. $this->error = '订单处理失败';
  319. return false;
  320. }
  321. // 获取支付参数
  322. /* TODO 支付处理 */
  323. $payOrder = [
  324. 'type' => 1,
  325. 'order_no' => $orderNo,
  326. 'is_revenue' => $order['is_revenue'],
  327. 'pay_money' => $payTotal,
  328. 'body' => '订单付款',
  329. 'openid' => $openid
  330. ];
  331. // 调起支付
  332. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  333. if (empty($payment)) {
  334. RedisService::clear($cacheLockKey);
  335. $this->error = PaymentService::make()->getError();
  336. return false;
  337. }
  338. // 商品库存扣除
  339. if ($orderGoods) {
  340. foreach ($orderGoods as $goods) {
  341. $id = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
  342. $num = isset($goods['num']) ? $goods['num'] : 0;
  343. $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
  344. if ($id && !GoodsModel::where(['id' => $id])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
  345. DB::rollBack();
  346. RedisService::clear($cacheLockKey);
  347. $this->error = '商品库存处理失败';
  348. return false;
  349. }
  350. if ($skuId && !GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
  351. DB::rollBack();
  352. RedisService::clear($cacheLockKey);
  353. $this->error = '商品库存处理失败';
  354. return false;
  355. }
  356. }
  357. // 清空购物车结算商品
  358. if($submitType == 'cart'){
  359. $skuIds = $goods ? array_column($goods, 'sku_id') : [];
  360. CartModel::whereIn('goods_id',$ids)->whereIn('sku_id',$skuIds)->where(['user_id'=>$userId,'mark'=>1])->update(['mark'=>0,'num'=>0,'update_time'=>time()]);
  361. RedisService::clear("caches:goods:cartCount:{$userId}");
  362. }
  363. // 优惠券已使用
  364. if($couponId){
  365. MemberCouponModel::where(['coupon_id'=>$couponId,'user_id'=>$userId])->update(['status'=>2,'update_time'=>time()]);
  366. }
  367. }
  368. // 用户操作记录
  369. DB::commit();
  370. $this->error = '订单创建成功,请前往支付~';
  371. RedisService::clear($cacheLockKey);
  372. return [
  373. 'order_id' => $orderId,
  374. 'payment' => $payment,
  375. 'total' => $payOrder['pay_money'],
  376. 'pay_type' => 10,
  377. ];
  378. }
  379. /**
  380. * 订单支付
  381. * @param $userId
  382. * @param $id
  383. * @return array|false
  384. */
  385. public function pay($userId, $id, $payType=10)
  386. {
  387. if ($id <= 0) {
  388. $this->error = '请选择支付订单';
  389. return false;
  390. }
  391. // 缓存锁
  392. $cacheLockKey = "caches:orders:pay_lock:{$userId}_{$id}_{$payType}";
  393. if (RedisService::get($cacheLockKey)) {
  394. $this->error = '订单处理中~';
  395. return false;
  396. }
  397. // 商品数据
  398. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  399. // 用户信息
  400. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  401. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  402. ->first();
  403. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  404. $openid = isset($userInfo['openid']) ? $userInfo['openid'] : '';
  405. if (empty($userInfo) || $status != 1) {
  406. $this->error = 1045;
  407. RedisService::clear($cacheLockKey);
  408. return false;
  409. }
  410. if (empty($openid)) {
  411. $this->error = '用户微信未授权,请重新授权登录';
  412. RedisService::clear($cacheLockKey);
  413. return false;
  414. }
  415. // 订单信息
  416. $info = $this->model->where(['id' => $id, 'mark' => 1])
  417. ->select(['id', 'order_no', 'pay_total', 'delivery_fee', 'status'])
  418. ->first();
  419. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  420. $deliveryFee = isset($info['delivery_fee']) ? $info['delivery_fee'] : 0;
  421. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  422. $status = isset($info['status']) ? $info['status'] : 0;
  423. if (empty($info) || empty($orderNo)) {
  424. $this->error = '订单信息不存在';
  425. RedisService::clear($cacheLockKey);
  426. return false;
  427. }
  428. if ($status != 1) {
  429. $this->error = '订单已支付';
  430. RedisService::clear($cacheLockKey);
  431. return false;
  432. }
  433. if (env('PAY_DEBUG')) {
  434. $orderTotal = 0.01;
  435. }
  436. DB::beginTransaction();
  437. // 获取支付参数
  438. /* TODO 支付处理 */
  439. $payOrder = [
  440. 'type' => 1,
  441. 'order_no' => $orderNo,
  442. 'pay_money' => moneyFormat($orderTotal + $deliveryFee),
  443. 'body' => '购物消费',
  444. 'openid' => $openid
  445. ];
  446. // 调起支付
  447. $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
  448. if (empty($payment)) {
  449. DB::rollBack();
  450. RedisService::clear($cacheLockKey);
  451. $this->error = PaymentService::make()->getError();
  452. return false;
  453. }
  454. // 更新支付方式
  455. $info->pay_type = $payType;
  456. $info->update_time = time();
  457. $info->save();
  458. // 用户操作记录
  459. DB::commit();
  460. $this->error = '支付请求成功,请前往支付~';
  461. RedisService::clear($cacheLockKey);
  462. return [
  463. 'order_id' => $id,
  464. 'payment' => $payment,
  465. 'total' => $payOrder['pay_money'],
  466. 'pay_type' => $payType,
  467. ];
  468. }
  469. /**
  470. * 订单取消
  471. * @param $userId
  472. * @param $orderId
  473. * @return array|false
  474. */
  475. public function cancel($userId, $orderId)
  476. {
  477. if ($orderId <= 0) {
  478. $this->error = '请选择订单';
  479. return false;
  480. }
  481. // 缓存锁
  482. $cacheLockKey = "caches:orders:cancel_lock:{$userId}_{$orderId}";
  483. if (RedisService::get($cacheLockKey)) {
  484. $this->error = '订单处理中~';
  485. return false;
  486. }
  487. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  488. // 用户信息
  489. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  490. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  491. ->first();
  492. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  493. if (empty($userInfo) || $status != 1) {
  494. $this->error = 1045;
  495. RedisService::clear($cacheLockKey);
  496. return false;
  497. }
  498. // 订单信息
  499. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  500. ->select(['id', 'order_no','coupon_id', 'pay_total', 'status'])
  501. ->first();
  502. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  503. $couponId = isset($info['coupon_id']) ? $info['coupon_id'] : 0;
  504. $status = isset($info['status']) ? $info['status'] : 0;
  505. if (empty($info) || empty($orderNo)) {
  506. $this->error = '订单信息不存在';
  507. RedisService::clear($cacheLockKey);
  508. return false;
  509. }
  510. if ($status != 1) {
  511. $this->error = '订单已支付';
  512. RedisService::clear($cacheLockKey);
  513. return false;
  514. }
  515. $orderGoods = OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 1])
  516. ->select(['goods_id', 'num', 'sku_id'])
  517. ->get();
  518. DB::beginTransaction();
  519. // 商品库存
  520. if ($orderGoods) {
  521. foreach ($orderGoods as $goods) {
  522. $goodsId = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
  523. $num = isset($goods['num']) ? $goods['num'] : 0;
  524. $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
  525. if ($goodsId) {
  526. GoodsModel::where(['id' => $goodsId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()]);
  527. }
  528. if ($skuId) {
  529. GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()]);
  530. }
  531. }
  532. }
  533. $this->error = '取消订单成功';
  534. $this->model->where(['user_id' => $userId, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  535. OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
  536. $this->model->where(['id' => $orderId])->update(['mark' => 0, 'update_time' => time()]);
  537. OrderGoodsModel::where(['order_no' => $orderNo])->update(['mark' => 0, 'update_time' => time()]);
  538. // 优惠券返还
  539. if($couponId){
  540. MemberCouponModel::where(['coupon_id'=>$couponId,'user_id'=>$userId])->update(['status'=>1,'remark'=>'取消订单返还','update_time'=>time()]);
  541. }
  542. DB::commit();
  543. return ['id' => $orderId];
  544. }
  545. /**
  546. * 订单删除隐藏
  547. * @param $userId
  548. * @param $orderId
  549. * @return array|false
  550. */
  551. public function hide($userId, $orderId)
  552. {
  553. if ($orderId <= 0) {
  554. $this->error = '请选择订单';
  555. return false;
  556. }
  557. // 缓存锁
  558. $cacheLockKey = "caches:orders:hide_lock:{$userId}_{$orderId}";
  559. if (RedisService::get($cacheLockKey)) {
  560. $this->error = '订单删除中~';
  561. return false;
  562. }
  563. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  564. // 用户信息
  565. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  566. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  567. ->first();
  568. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  569. if (empty($userInfo) || $status != 1) {
  570. $this->error = 1045;
  571. RedisService::clear($cacheLockKey);
  572. return false;
  573. }
  574. // 订单信息
  575. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  576. ->select(['id', 'order_no', 'pay_total', 'status'])
  577. ->first();
  578. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  579. $status = isset($info['status']) ? $info['status'] : 0;
  580. if (empty($info) || empty($orderNo)) {
  581. $this->error = '订单信息不存在';
  582. RedisService::clear($cacheLockKey);
  583. return false;
  584. }
  585. if ($status != 4) {
  586. $this->error = '订单未完成';
  587. RedisService::clear($cacheLockKey);
  588. return false;
  589. }
  590. $this->error = '删除订单成功';
  591. $this->model->where(['id' => $orderId])->update(['is_hide' => 1, 'update_time' => time()]);
  592. return ['id' => $orderId];
  593. }
  594. /**
  595. * 订单提醒发货
  596. * @param $userId
  597. * @param $orderId
  598. * @return array|false
  599. */
  600. public function tips($userId, $orderId)
  601. {
  602. if ($orderId <= 0) {
  603. $this->error = '请选择订单';
  604. return false;
  605. }
  606. // 缓存锁
  607. $cacheLockKey = "caches:orders:tips_lock:{$userId}_{$orderId}";
  608. if (RedisService::get($cacheLockKey)) {
  609. $this->error = '请不要频繁操作~';
  610. return false;
  611. }
  612. RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
  613. // 用户信息
  614. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  615. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  616. ->first();
  617. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  618. $nickname = isset($userInfo['nickname']) ? $userInfo['nickname'] : '';
  619. if (empty($userInfo) || $status != 1) {
  620. $this->error = 1045;
  621. RedisService::clear($cacheLockKey);
  622. return false;
  623. }
  624. // 订单信息
  625. $info = $this->model->where(['id' => $orderId, 'mark' => 1])
  626. ->select(['id', 'order_no','store_id', 'pay_total','tips_status', 'status'])
  627. ->first();
  628. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  629. $status = isset($info['status']) ? $info['status'] : 0;
  630. $tipsStatus = isset($info['tips_status']) ? $info['tips_status'] : 0;
  631. if (empty($info) || empty($orderNo)) {
  632. $this->error = '订单信息不存在';
  633. RedisService::clear($cacheLockKey);
  634. return false;
  635. }
  636. if($tipsStatus ==1){
  637. $this->error = '已经提醒过';
  638. RedisService::clear($cacheLockKey);
  639. return false;
  640. }
  641. if ($status != 2) {
  642. $this->error = '订单状态不可操作';
  643. RedisService::clear($cacheLockKey);
  644. return false;
  645. }
  646. $this->error = '订单提醒发货成功';
  647. $this->model->where(['id' => $orderId])->update(['tips_status' => 1, 'update_time' => time()]);
  648. $msgData = [
  649. 'from_uid'=> $userId,
  650. 'type'=> 4,
  651. 'title'=>'互动消息',
  652. 'description'=> "用户{$nickname}提醒了您,希望您尽快发货",
  653. 'content'=> json_encode(['source_id'=>$orderId,'page'=>'/pagesSub/pages/order/detail?no='.$orderNo]),
  654. 'msg_type'=>4,
  655. ];
  656. // 互动消息
  657. MessageService::make()->pushMessage(1, $msgData);
  658. return ['id' => $orderId];
  659. }
  660. /**
  661. * 订单完成
  662. * @param $userId 订单用户ID
  663. * @param $id 订单ID
  664. * @return array|false
  665. */
  666. public function complete($userId, $id, $check = true)
  667. {
  668. if ($id <= 0) {
  669. $this->error = '请选择订单';
  670. return false;
  671. }
  672. // 缓存锁
  673. $cacheLockKey = "caches:orders:complete_lock:{$userId}_{$id}";
  674. if (RedisService::get($cacheLockKey)) {
  675. $this->error = '订单处理中~';
  676. return false;
  677. }
  678. // 商品数据
  679. RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
  680. // 用户信息
  681. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  682. ->select(['id', 'openid', 'mobile', 'parent_id', 'nickname', 'realname', 'balance', 'status'])
  683. ->first();
  684. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  685. $parentId = isset($userInfo['parent_id']) ? $userInfo['parent_id'] : 0;
  686. if ($check && (empty($userInfo) || $status != 1)) {
  687. $this->error = 1045;
  688. RedisService::clear($cacheLockKey);
  689. return false;
  690. }
  691. // 订单信息
  692. $info = $this->model->with(['orderGoods'])->where(['id' => $id, 'mark' => 1])
  693. ->select(['id', 'order_no','user_id', 'store_id', 'pay_total', 'delivery_no', 'delivery_company', 'delivery_code', 'status'])
  694. ->first();
  695. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  696. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  697. $deliverCompany = isset($info['delivery_company']) ? $info['delivery_company'] : '';
  698. $orderUserId = isset($info['user_id']) ? $info['user_id'] : 0;
  699. $storeId = isset($info['store_id']) ? $info['store_id'] : 0;
  700. $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
  701. $status = isset($info['status']) ? $info['status'] : 0;
  702. $orderGoods = isset($info['order_goods']) ? $info['order_goods'] : [];
  703. if (empty($info) || empty($orderNo)) {
  704. $this->error = '订单信息不存在';
  705. RedisService::clear($cacheLockKey);
  706. return false;
  707. }
  708. if ($status != 3) {
  709. $this->error = '订单未发货';
  710. RedisService::clear($cacheLockKey);
  711. return false;
  712. }
  713. if (empty($deliveryNo) || empty($deliverCompany)) {
  714. $this->error = '订单发货信息错误,请联系客服';
  715. $this->model->where(['id' => $id])->update(['is_complete' => 1, 'complete_remark' => $this->error]);
  716. RedisService::clear("caches:orders:completeList");
  717. RedisService::clear($cacheLockKey);
  718. return false;
  719. }
  720. DB::beginTransaction();
  721. $updateData = ['status' => 4, 'complete_at' => date('Y-m-d H:i:s'), 'update_time' => time()];
  722. if (!$check) {
  723. $updateData['is_complete'] = 1;
  724. $updateData['complete_remark'] = '自动收货';
  725. }
  726. $this->model->where(['id' => $id])->update($updateData);
  727. // 商品销量数据
  728. if ($orderGoods) {
  729. $counts = [];
  730. foreach ($orderGoods as $item) {
  731. $counts[$item['goods_id']] = isset($counts[$item['goods_id']]) ? $counts[$item['goods_id']] : 0;
  732. $counts[$item['goods_id']] += $item['num'];
  733. }
  734. if ($counts) {
  735. foreach ($counts as $id => $v) {
  736. GoodsModel::where(['id' => $id])->update(['sales' => DB::raw("sales + {$v}"), 'update_time' => time()]);
  737. }
  738. }
  739. }
  740. // 订单结算
  741. SettleService::make()->commissionSettle($id);
  742. DB::commit();
  743. $this->error = '确认收货成功';
  744. RedisService::clear("caches:orders:completeList");
  745. RedisService::clear("caches:orders:revenueList");
  746. return ['id' => $id, 'msg' => $this->error];
  747. }
  748. /**
  749. * 售后或退款
  750. * @param $userId
  751. * @param $params
  752. * @return array|false
  753. */
  754. public function after($userId, $params)
  755. {
  756. $id = isset($params['id']) ? $params['id'] : 0;
  757. $afterType = isset($params['after_type']) ? $params['after_type'] : 1;
  758. if ($id <= 0) {
  759. $this->error = '请选择订单';
  760. return false;
  761. }
  762. // 缓存锁
  763. $cacheLockKey = "caches:orders:after_lock:{$userId}_{$id}";
  764. if (RedisService::get($cacheLockKey)) {
  765. $this->error = '订单处理中~';
  766. return false;
  767. }
  768. // 商品数据
  769. RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
  770. // 用户信息
  771. $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
  772. ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
  773. ->first();
  774. $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
  775. if (empty($userInfo) || $status != 1) {
  776. $this->error = 1045;
  777. RedisService::clear($cacheLockKey);
  778. return false;
  779. }
  780. // 订单信息
  781. $info = $this->model->where(['id' => $id, 'mark' => 1])
  782. ->select(['id', 'order_no', 'after_type', 'refund_status', 'pay_total', 'status'])
  783. ->first();
  784. $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
  785. $status = isset($info['status']) ? $info['status'] : 0;
  786. $refundStatus = isset($info['refund_status']) ? $info['refund_status'] : 0;
  787. if (empty($info) || empty($orderNo)) {
  788. $this->error = '订单信息不存在';
  789. RedisService::clear($cacheLockKey);
  790. return false;
  791. }
  792. if ($status == 1) {
  793. $this->error = '订单未支付';
  794. RedisService::clear($cacheLockKey);
  795. return false;
  796. }
  797. if ($status == 4 && $afterType == 2) {
  798. $this->error = '订单已完成';
  799. RedisService::clear($cacheLockKey);
  800. return false;
  801. }
  802. if ($refundStatus > 0 && $refundStatus != 4) {
  803. $this->error = '订单售后处理中';
  804. RedisService::clear($cacheLockKey);
  805. return false;
  806. }
  807. $afterRealname = isset($params['after_realname']) ? $params['after_realname'] : '';
  808. $afterPhone = isset($params['after_phone']) ? $params['after_phone'] : '';
  809. $afterRemark = isset($params['after_remark']) ? $params['after_remark'] : '';
  810. if ($afterType == 1) {
  811. if (empty($afterRealname) || empty($afterPhone) || empty($afterRemark)) {
  812. $this->error = '请填写售后信息';
  813. RedisService::clear($cacheLockKey);
  814. return false;
  815. }
  816. }
  817. $data = [
  818. 'after_type' => $afterType,
  819. 'after_realname' => $afterRealname,
  820. 'after_phone' => $afterPhone,
  821. 'after_remark' => $afterRemark,
  822. 'refund_remark' => isset($params['refund_remark']) ? $params['refund_remark'] : '',
  823. 'refund_status' => 3,
  824. 'update_time' => time()
  825. ];
  826. $this->model->where(['id' => $id])->update($data);
  827. $this->error = '订单申请售后成功';
  828. return ['id' => $id];
  829. }
  830. /**
  831. * 物流查询
  832. * @param $id
  833. * @return array|false|mixed
  834. */
  835. public function getDelivery($id)
  836. {
  837. $info = $this->model->where(['id' => $id, 'mark' => 1])->first();
  838. $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
  839. $deliveryCode = isset($info['delivery_code']) ? $info['delivery_code'] : '';
  840. $mobile = isset($info['receiver_mobile']) ? $info['receiver_mobile'] : '';
  841. $receiverArea = isset($info['receiver_area']) && $info['receiver_area'] ? $info['receiver_area'] : '';
  842. if (empty($info)) {
  843. $this->error = '请选择订单';
  844. return false;
  845. }
  846. $cacheKey = "caches:kd100:order_{$id}";
  847. $data = RedisService::get($cacheKey);
  848. if ($data) {
  849. return $data;
  850. }
  851. $result = Kd100Service::make()->query($deliveryNo, $mobile, $deliveryCode, $receiverArea);
  852. RedisService::set($cacheKey . '_result', $result, 300);
  853. $status = isset($result['status']) ? $result['status'] : 0;
  854. $data = isset($result['data']) ? $result['data'] : [];
  855. $courierInfo = isset($result['courierInfo']) ? $result['courierInfo'] : [];
  856. $arrivalTime = isset($result['arrivalTime']) ? $result['arrivalTime'] : '';
  857. $predictedRoute = isset($result['predictedRoute']) ? $result['predictedRoute'] : [];
  858. $predictedData = $predictedRoute ? end($predictedRoute) : [];
  859. $arrivalData = [];
  860. if ($arrivalTime) {
  861. $arrivalData['arrivalTime'] = dayFormat(strtotime($arrivalTime . ':00:00'));
  862. $arrivalData['predictedData'] = $predictedData;
  863. }
  864. if ($courierInfo && $courierInfo['deliveryManPhone']) {
  865. $courierInfo['deliveryManPhone'] = explode(',', $courierInfo['deliveryManPhone']);
  866. $courierInfo['deliveryPhone'] = $courierInfo['deliveryManPhone'][1] ? $courierInfo['deliveryManPhone'][1] : $courierInfo['deliveryManPhone'][0];
  867. }
  868. if ($data && $status == 200) {
  869. RedisService::set($cacheKey, ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data], 1200);
  870. }
  871. return $data ? ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data] : [];
  872. }
  873. /**
  874. * 已发货待完成订单
  875. * @return array|mixed
  876. */
  877. public function getCompleteOrders()
  878. {
  879. $cacheKey = "caches:orders:completeList";
  880. $datas = RedisService::get($cacheKey);
  881. if ($datas) {
  882. return $datas;
  883. }
  884. $completeDay = ConfigService::make()->getConfigByCode('order_complete_day', 7);
  885. $limitNum = ConfigService::make()->getConfigByCode('order_complete_batch_num', 300);
  886. $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
  887. $completeDay = $completeDay >= 1 && $completeDay < 30 ? $completeDay : 7;
  888. $datas = $this->model->where(['status' => 3, 'is_complete' => 2, 'mark' => 1])
  889. ->whereNotNull('delivery_no')
  890. ->select(['id', 'user_id', 'order_no', 'status'])
  891. ->where('pay_at', '<=', date('Y-m-d H:i:s', time() - $completeDay * 86400))
  892. ->limit($limitNum)
  893. ->get();
  894. $datas = $datas ? $datas->toArray() : [];
  895. if ($datas) {
  896. RedisService::set($cacheKey, $datas, rand(300, 600));
  897. }
  898. return $datas;
  899. }
  900. /**
  901. * 已完成,待分账订单
  902. * @return array|mixed
  903. */
  904. public function getRevenueOrderList()
  905. {
  906. $cacheKey = "caches:orders:revenueList";
  907. $datas = RedisService::get($cacheKey);
  908. if ($datas) {
  909. return $datas;
  910. }
  911. $limitNum = ConfigService::make()->getConfigByCode('order_revenue_batch_num', 300);
  912. $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
  913. $datas = $this->model->where(['status' => 4, 'is_revenue' => 1, 'revenue_status' => 2, 'mark' => 1])
  914. ->select(['id', 'user_id','pay_total', 'order_no','revenue_no','transaction_id', 'status'])
  915. ->limit($limitNum)
  916. ->get();
  917. $datas = $datas ? $datas->toArray() : [];
  918. if ($datas) {
  919. RedisService::set($cacheKey, $datas, rand(300, 600));
  920. }
  921. return $datas;
  922. }
  923. /**
  924. * 订单分账处理
  925. * @param $id
  926. * @return false
  927. * @throws \Yansongda\Pay\Exception\ContainerException
  928. * @throws \Yansongda\Pay\Exception\InvalidParamsException
  929. */
  930. public function revenue($id)
  931. {
  932. if ($id <= 0) {
  933. $this->error = '订单参数错误';
  934. return false;
  935. }
  936. // 缓存锁
  937. $cacheLockKey = "caches:orders:revenue_lock:{$id}";
  938. if (RedisService::get($cacheLockKey)) {
  939. $this->error = '订单分账处理中~';
  940. return false;
  941. }
  942. // 是否设置分账账户
  943. $revenueOpenid = ConfigService::make()->getConfigByCode('order_revenue_openid', '');
  944. if(empty($revenueOpenid)){
  945. $this->error = '订单分账账户未配置';
  946. return false;
  947. }
  948. // 订单信息
  949. RedisService::set($cacheLockKey, ['id'=>$id,'date'=>date('Y-m-d H:i:s')], 20);
  950. $info = $this->model->where(['id' => $id, 'mark' => 1])
  951. ->select(['id', 'order_no','revenue_no','user_id','transaction_id', 'pay_total','is_revenue','revenue_status','revenue_amount', 'status'])
  952. ->first();
  953. $revenueOrderNo = isset($info['revenue_no']) ? $info['revenue_no'] : '';
  954. $revenueAmount = isset($info['revenue_amount']) ? $info['revenue_amount'] : 0;
  955. $status = isset($info['status']) ? $info['status'] : 0;
  956. $isRevenue = isset($info['is_revenue']) ? $info['is_revenue'] : 0;
  957. $revenueStatus = isset($info['revenue_status']) ? $info['revenue_status'] : 0;
  958. if($status != 4){
  959. RedisService::clear($cacheLockKey);
  960. $this->error = '订单状态错误,未完成收货的订单无法分账';
  961. return false;
  962. }
  963. if($isRevenue != 1){
  964. RedisService::clear($cacheLockKey);
  965. $this->error = '该订单不是分账订单';
  966. return false;
  967. }
  968. if($revenueStatus != 2){
  969. RedisService::clear($cacheLockKey);
  970. $this->error = '该订单分账已处理完成';
  971. return false;
  972. }
  973. if($revenueAmount<=0){
  974. RedisService::clear($cacheLockKey);
  975. $this->error = '订单分账金额不足';
  976. return false;
  977. }
  978. $order = [
  979. 'transaction_id'=> $info['transaction_id'],
  980. 'out_order_no'=> $revenueOrderNo,
  981. 'body'=> '订单分账',
  982. 'amount'=> $revenueAmount,
  983. 'unsplit'=> true, // 只分一次
  984. ];
  985. $result = PaymentService::make()->profitsharing($revenueOpenid, $order);
  986. $state = isset($result->state)? $result->state : 0;
  987. $message = isset($result->message)? $result->message : '分账失败';
  988. $orderId = isset($result->order_id)? $result->order_id : '';
  989. if($state == 'FINISHED'){
  990. $this->model->where(['id'=>$id])->update(['revenue_status'=>1,'revenue_order_id'=>$orderId,'update_time'=>time()]);
  991. RedisService::clear($cacheLockKey);
  992. RedisService::clear("caches:orders:revenueList");
  993. $this->error = '分账处理成功';
  994. return true;
  995. }else{
  996. RedisService::clear($cacheLockKey);
  997. $this->error = $message;
  998. return false;
  999. }
  1000. }
  1001. }