SyncWMSOrderTask.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  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. $is_enabled= config('sync.order_sync.cache_prefix.enabled');
  36. if($is_enabled=='false')return;
  37. $this->syncCreatedOrder();
  38. $this->syncUpdatedOrder();
  39. }
  40. public function syncCreatedOrder()
  41. {
  42. /**
  43. * @var OracleDOCOrderHeaderService $oracleDOCOrderHeaderService
  44. * @var OrderService $orderService
  45. */
  46. $newest = config('sync.order_sync.cache_prefix.created_at');
  47. $newest_list = config('sync.order_sync.cache_prefix.newest_list');
  48. $hasKey = config('sync.order_sync.cache_prefix.newest_has');
  49. $prefixKey = config('sync.order_sync.cache_prefix.newest');
  50. ini_set('memory_limit', '512M');
  51. $orderService = app('OrderService');
  52. $oracleDOCOrderHeaderService = app('OracleDocOrderHeaderService');
  53. $last_date = $orderService->getOrderSyncAt($newest,'newest'); // 获取时间点
  54. $orderHeaders = $oracleDOCOrderHeaderService->getWMSOrderOnStartDate($last_date); // WMS订单
  55. if($orderHeaders->count()==0)return;
  56. $last_order = $orderHeaders->first(); // 时间点靠后的
  57. $newest_orders = $orderHeaders->where('addtime',$last_order->addtime);
  58. $orderHeaders = $orderService->filterOrderByCache($orderHeaders,$newest_list); // 对比缓存
  59. if(count($newest_orders)>0 && count($orderHeaders) >0){
  60. $orderService->syncOrder($orderHeaders); // 同步订单
  61. $orderService->cancelOrderCache($newest_list,$prefixKey); // 清除缓存
  62. $orderService->pushOrderCache($newest_orders,$prefixKey,$hasKey,$newest_list); // 添加缓存
  63. $orderService->setOrderSyncAt($newest,$last_order->addtime,count($orderHeaders)>0); // 更新时间
  64. }
  65. }
  66. public function syncUpdatedOrder()
  67. {
  68. /**
  69. * @var OracleDOCOrderHeaderService $oracleDOCOrderHeaderService
  70. * @var OrderService $orderService
  71. */
  72. $renewal = config('sync.order_sync.cache_prefix.updated_at');
  73. $renewal_list = config('sync.order_sync.cache_prefix.renewal_list');
  74. $hasKey = config('sync.order_sync.cache_prefix.renewal_has');
  75. $prefixKey = config('sync.order_sync.cache_prefix.renewal');
  76. ini_set('memory_limit', '512M');
  77. $orderService = app('OrderService');
  78. $oracleDOCOrderHeaderService = app('OracleDocOrderHeaderService');
  79. $last_date = $orderService->getOrderSyncAt($renewal,'renewal'); // 获取时间点
  80. $orderHeaders = $oracleDOCOrderHeaderService->getWMSOrderOnEditDate($last_date); // WMS订单
  81. if($orderHeaders->count()==0)return;
  82. $renewal_order = $orderHeaders->first(); // 时间点靠后的
  83. $renewal_orders = $orderHeaders->where('edittime',$renewal_order->edittime);
  84. $orderHeaders = $orderService->filterOrderByCache($orderHeaders,$renewal_list); // 对比缓存
  85. if(count($renewal_orders)>0 && count($orderHeaders)>0){
  86. $orderService->syncOrder($orderHeaders); // 同步订单
  87. $orderService->cancelOrderCache($renewal_list,$prefixKey); // 清除缓存
  88. $orderService->pushOrderCache($renewal_orders,$prefixKey,$hasKey,$renewal_list); // 添加缓存
  89. $orderService->setOrderSyncAt($renewal,$renewal_order->edittime,count($orderHeaders)>0); // 更新时间
  90. }
  91. }
  92. }