OrderService.php 41 KB

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