OrderService.php 42 KB

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