SyncOrderByWMSOrderHeaderTest.php 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. <?php
  2. namespace Tests\Services\OrderService\SyncOrderByWMSOrderHeaderTest;
  3. use App\Logistic;
  4. use App\OracleDOCOrderHeader;
  5. use App\Order;
  6. use App\Owner;
  7. use App\Services\common\DataHandlerService;
  8. use App\Services\LogisticService;
  9. use App\Services\OracleDOCOrderHeaderService;
  10. use App\Services\OrderService;
  11. use App\Services\OwnerService;
  12. use App\Services\ShopService;
  13. use App\Services\WarehouseService;
  14. use App\Shop;
  15. use App\Warehouse;
  16. use Carbon\Carbon;
  17. use Illuminate\Foundation\Testing\RefreshDatabase;
  18. use Illuminate\Foundation\Testing\WithFaker;
  19. use Tests\TestCase;
  20. class SyncOrderByWMSOrderHeaderTest extends TestCase
  21. {
  22. use RefreshDatabase;
  23. /**
  24. * @var OrderService $service
  25. * @var OracleDOCOrderHeaderService $orderHeaderService
  26. * @var DataHandlerService $dataHandlerService
  27. * @var OwnerService $ownerService
  28. * @var LogisticService $logisticService
  29. * @var ShopService $shopService
  30. * @var WarehouseService $warehouseService
  31. */
  32. public $service;
  33. public $orderHeaderService;
  34. public $dataHandlerService;
  35. public $ownerService;
  36. public $logisticService;
  37. public $shopService;
  38. public $warehouseService;
  39. public function setUp(): void
  40. {
  41. parent::setUp();
  42. $this->service=app(OrderService::class);
  43. $this->orderHeaderService=app(OracleDOCOrderHeaderService::class);
  44. }
  45. public function testCreateOrUpdateOrderByWMSOrderHeaders()
  46. {
  47. $orderHeader = OracleDOCOrderHeader::query()->where('sostatus',99)->orderByDesc('addtime')->first();
  48. $orderHeaders = OracleDOCOrderHeader::query()
  49. ->where('sostatus',99)
  50. ->where('addtime','>=',$orderHeader->addtime)
  51. ->get();
  52. $this->service->syncOrderByWMSOrderHeaders($orderHeaders);
  53. $orders = Order::query()->whereIn('code',data_get($orderHeaders,'*.orderno'))->get();
  54. foreach ($orderHeaders as $orderHeader) {
  55. $code = $orderHeader->orderno;
  56. $order = $orders->where('code',$code)->first();
  57. $this->assertNotNull($order);
  58. $warehouse = Warehouse::query()->where('code',$orderHeader->warehouseid)->first();
  59. if($orderHeader->warehouseid ?? false)
  60. $this->assertEquals($warehouse->id ?? '',$order->warehouse_id ?? '');
  61. $owner = Owner::query()->where('code',$orderHeader->customerid)->first();
  62. if($orderHeader->customerid ?? false)
  63. $this->assertEquals($order->owner_id ?? '',$owner->id??'');
  64. $logistic = Logistic::query()->where('code',$orderHeader->userdefine1??'')->first();
  65. if($orderHeader->userdefine1 ?? false)
  66. $this->assertEquals($logistic->id ?? '',$logistic->id ?? '');
  67. $shop = Shop::query()->where('name',$orderHeader->issuepartyname)->where('owner_id',$owner->id)->first();
  68. if($orderHeader->issuepartyname ?? false)
  69. $this->assertEquals($shop->name,$orderHeader->issuepartyname);
  70. $this->assertEquals($order->consignee_name ,$orderHeader->c_contact);
  71. $this->assertEquals($order->consignee_phone ,empty($orderHeader->c_tel2)?$orderHeader->c_tel1:$orderHeader->c_tel2);
  72. $this->assertEquals($order->province ,$orderHeader->c_province);
  73. $this->assertEquals($order->city ,$orderHeader->c_city);
  74. $this->assertEquals($order->district ,$orderHeader->c_district);
  75. $this->assertEquals($order->client_code ,$orderHeader->soreference1);
  76. $this->assertEquals($order->wms_edittime ,(string)$orderHeader->edittime);
  77. $this->assertEquals($order->wms_status ,$orderHeader->oracleBASCode_codename_c);
  78. $this->assertEquals((string)$order->created_at ,(string)$orderHeader->addtime);
  79. }
  80. }
  81. }