SyncWMSOrderTask.php 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Services\OracleDOCOrderHeaderService;
  4. use App\Services\OrderService;
  5. use Carbon\Carbon;
  6. use Illuminate\Console\Command;
  7. class SyncWMSOrderTask extends Command
  8. {
  9. /**
  10. * The name and signature of the console command.
  11. *
  12. * @var string
  13. */
  14. protected $signature = 'SyncWMSOrderTask';
  15. /**
  16. * The console command description.
  17. *
  18. * @var string
  19. */
  20. protected $description = 'Command description';
  21. /**
  22. * Create a new command instance.
  23. *
  24. * @return void
  25. */
  26. public function __construct()
  27. {
  28. parent::__construct();
  29. }
  30. /**
  31. * Execute the console command.
  32. */
  33. public function handle()
  34. {
  35. $this->syncCreatedOrder();
  36. $this->syncUpdatedOrder();
  37. }
  38. public function syncCreatedOrder()
  39. {
  40. /**
  41. * @var OracleDOCOrderHeaderService $oracleDOCOrderHeaderService
  42. * @var OrderService $orderService
  43. */
  44. $newest = config('sync.order_sync.cache_prefix.created_at');
  45. $newest_list = config('sync.order_sync.cache_prefix.newest_list');
  46. $hasKey = config('sync.order_sync.cache_prefix.newest_has');
  47. $prefixKey = config('sync.order_sync.cache_prefix.newest');
  48. $last_date = $orderService->getOrderSyncAt($newest,'newest'); // 获取时间点
  49. $orderHeaders = $oracleDOCOrderHeaderService->getWmsOrderOnStartDateEdit($last_date); // WMS订单
  50. $last_order = $orderHeaders->first(); // 时间点靠后的
  51. $renewal_orders = $orderHeaders->where('addTime',$last_order->addtime);
  52. $orderHeaders = $orderService->filterOrderByCache($orderHeaders,$newest_list); // 对比缓存
  53. if(count($orderHeaders)>0 && count($orderHeaders) >0){
  54. $orderService->syncOrder($orderHeaders); // 同步订单
  55. $orderService->cancelOrderCache($newest_list); // 清除缓存
  56. $orderService->pushOrderCache($renewal_orders,$prefixKey,$hasKey,$newest_list); // 添加缓存
  57. $orderService->setOrderSyncAt($newest,$last_order->addTime,count($orderHeaders)>0); // 更新时间
  58. }
  59. }
  60. public function syncUpdatedOrder()
  61. {
  62. /**
  63. * @var OracleDOCOrderHeaderService $oracleDOCOrderHeaderService
  64. * @var OrderService $orderService
  65. */
  66. $renewal = config('sync.order_sync.cache_prefix.updated_at');
  67. $renewal_list = config('sync.order_sync.cache_prefix.renewal_list');
  68. $hasKey = config('sync.order_sync.cache_prefix.renewal_has');
  69. $prefixKey = config('sync.order_sync.cache_prefix.renewal');
  70. $last_date = $orderService->getOrderSyncAt($renewal,'renewal'); // 获取时间点
  71. $orderHeaders = $oracleDOCOrderHeaderService->getWMSOrderOnStartDate($last_date); // WMS订单
  72. $renewal_order = $orderHeaders->first(); // 时间点靠后的
  73. $renewal_orders = $orderHeaders->where('addTime',$renewal_order->addtime);
  74. $orderHeaders = $orderService->filterOrderByCache($orderHeaders,$renewal_list); // 对比缓存
  75. if(count($renewal_orders)>0 && count($orderHeaders)>0){
  76. $orderService->syncOrder($orderHeaders); // 同步订单
  77. $orderService->cancelOrderCache($renewal_list); // 清除缓存
  78. $orderService->pushOrderCache($renewal_orders,$prefixKey,$hasKey,$renewal_list); // 添加缓存
  79. $orderService->setOrderSyncAt($renewal,$renewal_order->addTime,count($orderHeaders)>0); // 更新时间
  80. }
  81. }
  82. }