SyncWMSOrderTask.php 2.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  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. /**
  36. * @var OracleDOCOrderHeaderService $oracleDOCOrderHeaderService
  37. * @var OrderService $orderService
  38. */
  39. $oracleDOCOrderHeaderService = app('OracleDOCOrderHeaderService');
  40. $orderService = app('OrderService');
  41. $this->syncCreatedOrder($orderService,$oracleDOCOrderHeaderService);
  42. $this->syncUpdateOrder($orderService,$oracleDOCOrderHeaderService);
  43. }
  44. public function syncCreatedOrder(OrderService $orderService,OracleDOCOrderHeaderService $oracleDOCOrderHeaderService)
  45. {
  46. $key = 'order_last_created_sync_at';
  47. $last_date = $orderService->getOrderSyncAt($key);
  48. // 这段时间段内的新增
  49. $orderHeaders = $oracleDOCOrderHeaderService->getWmsOrderOnStartDateEdit($last_date); // 根据时间获取OrderHeader
  50. $last_order = $orderHeaders->first();
  51. $last_created_order = $orderHeaders->where('addTime',$last_order->addtime); // 最后时间插入的数据
  52. // 创建
  53. $orderService->syncOrder($orderHeaders);
  54. $orderService->pushOrderCreatedCache($last_created_order); //
  55. }
  56. public function syncUpdateOrder(OrderService $orderService,OracleDOCOrderHeaderService $oracleDOCOrderHeaderService)
  57. {
  58. $key = 'order_last_updated_sync_at';
  59. $last_date = $orderService->getOrderSyncAt($key);
  60. $orderHeaders = $oracleDOCOrderHeaderService->getWMSOrderOnStartDate($last_date);
  61. $last_order = $orderHeaders->first();
  62. $last_updated_order = $orderHeaders->where('addTime',$last_order->addtime);
  63. // 更新
  64. $orderService->syncOrder($orderHeaders);
  65. $orderService->pushOrderUpdatedCache($last_updated_order);
  66. }
  67. }