OrderPackageReceivedSyncService.php 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. <?php
  2. namespace App\Services;
  3. use App\OrderPackage;
  4. use Carbon\Carbon;
  5. use Exception;
  6. use Illuminate\Database\Eloquent\Collection;
  7. class OrderPackageReceivedSyncService
  8. {
  9. protected $logisticSFService;
  10. protected $logisticZopService;
  11. /**
  12. * 同步快递信息
  13. * 1 如果当前时间大于初始化时间 每日执行一次,更新order_packages中创建时间大于初始化时间,没有异常,用户未收货的全部订单的快递路由状态
  14. * 2 如果当前时间小于等于初始化时间,执行初始化脚本,将数据库中全部小于等于初始化时间的数据更新
  15. * @throws Exception
  16. */
  17. public function syncLogisticRoute()
  18. {
  19. $this->update($this->getLogisticRoutes($this->getLogisticNumbers()));
  20. }
  21. /**
  22. * 根据传递的承运商与快递单号更新快递信息
  23. * @param array $logisticNumbers 快递单号
  24. * example: ['SF' => ['SF1038651915891', 'SF1038651413847', 'SF1038611050071'],'ZT'=>['75424148714142','548464120822', '75424147834290']....]
  25. * @throws Exception 快递接口调用或者返回的信息有误,无法更新指定的快递路由信息
  26. */
  27. public function syncLogisticRouteApi(array $logisticNumbers)
  28. {
  29. $this->update($this->getLogisticRoutes($logisticNumbers));
  30. }
  31. /**
  32. * 获取快件揽收信息
  33. * @param array $request [
  34. * 'SF' => ['SF1038651915891', 'SF1038651413847', 'SF1038611050071'],
  35. * 'ZT'=>['75424148714142','548464120822', '75424147834290']
  36. * ]
  37. * @return array
  38. * @throws Exception
  39. */
  40. public function getLogisticRoutes(array $request): array
  41. {
  42. $this->logisticSFService = new LogisticSFService();
  43. $this->logisticZopService = new LogisticZopService();
  44. $resultSF = [];
  45. $resultZT = [];
  46. $resultYD = [];
  47. $resultYT = [];
  48. $resultOther = [];
  49. foreach ($request as $key => $logisticNums) {
  50. switch ($key) {
  51. case "SF":
  52. $resultSF = $this->logisticSFService->get($logisticNums);
  53. break;
  54. case "ZTO":
  55. // $resultZT = $this->logisticZopService->get($logisticNums);
  56. $resultZT = [];
  57. break;
  58. case "YD":
  59. $resultYD = [];
  60. break;
  61. case "YT":
  62. $resultYT = [];
  63. break;
  64. default:
  65. $resultOther = [];
  66. break;
  67. }
  68. }
  69. return array_merge($resultSF, $resultYD, $resultYT, $resultZT, $resultOther);
  70. }
  71. public function update(array $orderPackages)
  72. {
  73. foreach ($orderPackages as $data) {
  74. $orderPackage = OrderPackage::query()->where('logistic_number', $data['logistic_number'])->first();
  75. if (isset($data['status'])) $orderPackage->status = $data['status'];
  76. if (isset($data['received_at'])) $orderPackage->received_at = $data['received_at'];
  77. if (isset($data['exception'])) $orderPackage->exception = $data['exception'];
  78. if (isset($data['transfer_status'])) $orderPackage->transfer_status = $data['transfer_status'];
  79. $orderPackage->save();
  80. }
  81. }
  82. /**
  83. * 查询当前日期前的快递单号并按照承运商分类
  84. */
  85. public function getLogisticNumbers(): array
  86. {
  87. //初始化时间 2020-12-31 23:59:59
  88. $initDate = Carbon::parse(config('api_logistic.init_date'));
  89. $data = [];
  90. $query = OrderPackage::query()
  91. ->with(['order' => function ($query) {
  92. return $query->with('logistic');
  93. }]);
  94. if (Carbon::now()->lte($initDate)) {//当前时间小于等于初始化时间
  95. //初始化查询一个月的数据,exception为否
  96. $query = $query->where('created_at', '>=', $initDate->subDays((int)config('api_logistic.days'))->toDateTimeString())
  97. ->where('exception', '否');
  98. } else {//当前时间大于初始化时间,exception为否且未收货
  99. $query = $query->where('created_at', '>=', $initDate->toDateTimeString())
  100. ->where('exception', '否')
  101. ->whereNull('received_at');
  102. }
  103. return $this->buildData($query->get(), $data);
  104. }
  105. /**
  106. * 将orderPackage集合分类并摘取指定数据
  107. * @param Collection $orderPackages
  108. * @param array $data
  109. * @return array
  110. */
  111. private function buildData(Collection $orderPackages, array $data): array
  112. {
  113. foreach ($orderPackages as $orderPackage) {
  114. try {
  115. $logisticCode = $orderPackage->order->logistic->code;
  116. } catch (Exception $e) {
  117. continue;
  118. }
  119. $key = config('api_logistic.logistic.' . $logisticCode);
  120. if (!isset($data[$key])) {
  121. $data[$key] = [];
  122. }
  123. $data[$key][] = $orderPackage->logistic_number;
  124. }
  125. return $data;
  126. }
  127. }