GetUpdateModelByWmsOrderHeadersTest.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. <?php
  2. namespace Tests\Services\OrderService\GetUpdateOrderModelByWMSOrderHeadersTest;
  3. use App\Logistic;
  4. use App\OracleDOCOrderHeader;
  5. use App\Order;
  6. use App\Owner;
  7. use App\Services\LogisticService;
  8. use App\Services\OracleDOCOrderHeaderService;
  9. use App\Services\OrderService;
  10. use App\Services\OwnerService;
  11. use App\Services\ShopService;
  12. use App\Services\WarehouseService;
  13. use App\Shop;
  14. use App\Warehouse;
  15. use Carbon\Carbon;
  16. use Illuminate\Foundation\Testing\RefreshDatabase;
  17. use Illuminate\Foundation\Testing\WithFaker;
  18. use Illuminate\Support\Str;
  19. use Tests\TestCase;
  20. class GetUpdateModelByWmsOrderHeadersTest extends TestCase
  21. {
  22. use RefreshDatabase;
  23. /**
  24. * @var OrderService $service
  25. * @var OracleDOCOrderHeaderService $orderHeaderService
  26. */
  27. public $service;
  28. public $orderHeaderService;
  29. public function setUp(): void
  30. {
  31. parent::setUp();
  32. $this->service = app('OrderService');
  33. $this->orderHeaderService = app('OracleDocOrderHeaderService');
  34. }
  35. /**
  36. * @test
  37. */
  38. public function getUpdateOrderModelByWMSOrderHeaders()
  39. {
  40. $orderHeader = OracleDOCOrderHeader::query()->where('sostatus',99)->orderByDesc('addtime')->first();
  41. $orderHeaders = OracleDOCOrderHeader::query()
  42. ->where('sostatus',99)
  43. ->where('addtime','>=',$orderHeader->addtime)
  44. ->get();
  45. /**
  46. * @var OwnerService $ownerService
  47. * @var LogisticService $logisticService
  48. * @var ShopService $shopService
  49. * @var WarehouseService $warehouseService
  50. * @var OrderService $orderService
  51. */
  52. $ownerService = app("OwnerService");
  53. $logisticService = app("LogisticService");
  54. $shopService = app('ShopService');
  55. $warehouseService = app('WarehouseService');
  56. $orderService = app('OrderService');
  57. $owners = $ownerService->getByWmsOrders($orderHeaders);
  58. $logistics = $logisticService->getByWmsOrders($orderHeaders);
  59. $shops = $shopService->getByWmsOrders($orderHeaders);
  60. $warehouses = $warehouseService->getByWmsOrders($orderHeaders);
  61. $orderService->syncOrderByWMSOrderHeaders($orderHeaders);
  62. $orders = Order::query()->whereIn('code',data_get($orderHeaders,'*.orderno'))->get();
  63. $orders->each(function(&$item){
  64. $item->warehouse_id = 1;
  65. $item->owner_id = 1;
  66. $item->shop_id = 1;
  67. $item->logistic_id = 1;
  68. $item->consignee_name = Str::random(50);
  69. $item->consignee_phone = Str::random(50);
  70. $item->province = Str::random(50);
  71. $item->city = Str::random(50);
  72. $item->district = Str::random(50);
  73. $item->address = Str::random(50);
  74. $item->client_code = Str::random(52);
  75. $item->wms_edittime = Carbon::now();
  76. $item->wms_status = Str::random(10);
  77. $item->updated_at = Carbon::now();
  78. $item->created_at = Carbon::now();
  79. });
  80. $update_orders = $this->service->getUpdateOrderModelByWMSOrderHeaders($orderHeaders,$orders,$warehouses,$owners,$logistics,$shops);
  81. foreach ($orderHeaders as $orderHeader) {
  82. $order = $update_orders->where('code',$orderHeader->orderno)->first();
  83. $this->assertNotNull($order);
  84. $warehouse = Warehouse::query()->where('code',$orderHeader->warehouseid)->first();
  85. if($orderHeader->warehouseid ?? false)
  86. $this->assertEquals($warehouse->id ?? '',$order->warehouse_id ?? '');
  87. $owner = Owner::query()->where('code',$orderHeader->customerid)->first();
  88. if($orderHeader->customerid ?? false)
  89. $this->assertEquals($order->owner_id ?? '',$owner->id??'');
  90. $logistic = Logistic::query()->where('code',$orderHeader->userdefine1??'')->first();
  91. if($orderHeader->userdefine1 ?? false)
  92. $this->assertEquals($logistic->id ?? '',$logistic->id ?? '');
  93. $shop = Shop::query()->where('name',$orderHeader->issuepartyname)->where('owner_id',$owner->id)->first();
  94. if($orderHeader->issuepartyname ?? false)
  95. $this->assertEquals($shop->name,$orderHeader->issuepartyname);
  96. $this->assertEquals($order->consignee_name ,$orderHeader->c_contact);
  97. $this->assertEquals($order->consignee_phone ,empty($orderHeader->c_tel2)?$orderHeader->c_tel1:$orderHeader->c_tel2);
  98. $this->assertEquals($order->province ,$orderHeader->c_province);
  99. $this->assertEquals($order->city ,$orderHeader->c_city);
  100. $this->assertEquals($order->district ,$orderHeader->c_district);
  101. $this->assertEquals($order->client_code ,$orderHeader->soreference1);
  102. $this->assertEquals($order->wms_edittime ,(string)$orderHeader->edittime);
  103. $this->assertEquals($order->wms_status ,$orderHeader->oracleBASCode_codename_c);
  104. $this->assertEquals((string)$order->created_at ,(string)$orderHeader->addtime);
  105. }
  106. }
  107. }