GetCreateOrderModelByWMSOrderHeadersTest.php 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
  1. <?php
  2. namespace Tests\Services\OrderService\GetCreateOrderModelByWMSOrderHeadersTest;
  3. use App\Commodity;
  4. use App\Logistic;
  5. use App\OracleActAllocationDetails;
  6. use App\OracleBasCode;
  7. use App\OracleBasSKU;
  8. use App\OracleDOCOrderDetail;
  9. use App\OracleDOCOrderHeader;
  10. use App\Order;
  11. use App\Owner;
  12. use App\Services\common\DataHandlerService;
  13. use App\Services\LogisticService;
  14. use App\Services\OracleBasSkuService;
  15. use App\Services\OracleDOCOrderHeaderService;
  16. use App\Services\OrderService;
  17. use App\Services\OwnerService;
  18. use App\Services\ShopService;
  19. use App\Services\WarehouseService;
  20. use App\Shop;
  21. use App\Warehouse;
  22. use Carbon\Carbon;
  23. use Illuminate\Foundation\Testing\RefreshDatabase;
  24. use Illuminate\Foundation\Testing\WithFaker;
  25. use Illuminate\Support\Facades\DB;
  26. use Tests\TestCase;
  27. class GetCreateOrderModelByWMSOrderHeadersTest extends TestCase
  28. {
  29. // use RefreshDatabase;
  30. /**
  31. * @var OrderService $service
  32. * @var OracleDOCOrderHeaderService $orderHeaderService
  33. * @var DataHandlerService $dataHandlerService
  34. * @var OwnerService $ownerService
  35. * @var LogisticService $logisticService
  36. * @var ShopService $shopService
  37. * @var WarehouseService $warehouseService
  38. */
  39. public $service;
  40. public $orderHeaderService;
  41. public $dataHandlerService;
  42. public $ownerService;
  43. public $logisticService;
  44. public $shopService;
  45. public $warehouseService;
  46. private $data = [];
  47. public function setUp(): void
  48. {
  49. parent::setUp();
  50. $this->service = app('OrderService');
  51. $this->orderHeaderService = app('OracleDocOrderHeaderService');
  52. $this->dataHandlerService=app('DataHandlerService');
  53. $this->ownerService=app('OwnerService');
  54. $this->logisticService=app('LogisticService');
  55. $this->shopService=app('ShopService');
  56. $this->warehouseService=app('WarehouseService');
  57. $this->data['owner'] = factory(Owner::class)->create(['name'=>'测试货主']);
  58. $wmsOrderHeader = factory(OracleDOCOrderHeader::class)->make([
  59. 'customerid'=>$this->data['owner']['code'],'sostatus'=>99,'userdefine1'=>'TEST_CA','warehouseid'=>'WH_TEST'
  60. ]);
  61. // $this->data['warehouse'] = factory(Warehouse::class)->create(['code'=>'WH_TEST']);
  62. $res = DB::insert('insert ignore into logistics (code,name) values(?, ?)',['TEST_CA', '测试承运商']);
  63. $this->data['logistic'] = Logistic::query()->where('code','TEST_CA')->where('name','测试承运商')->first();
  64. $this->data['shop'] = factory(Shop::class)->create(['owner_id'=>$this->data['owner']['id']]);
  65. $code_BasCode = factory(OracleBasCode::class)->make(['codeid'=>'OW','code'=>'99','descr_c'=>'订单完成']);
  66. $orderType = factory(OracleBasCode::class)->make(['code'=>'sysy', 'codeid'=>'SO_TYP', 'codename_c'=>'测试状态']);
  67. $wmsOrderHeader->setRelation('orderType',$orderType);
  68. $wmsOrderHeader->setRelation('oracleBASCode',$code_BasCode);
  69. $this->data['orderHeader'] = $wmsOrderHeader;
  70. }
  71. /**
  72. * @test
  73. */
  74. public function getCreateOrderModelByWMSOrderHeaders()
  75. {
  76. $orderHeaders = collect([$this->data['orderHeader']]);
  77. $warehouses = $this->getWareHouses($orderHeaders);
  78. $owners = $this->getOwners($orderHeaders);
  79. $logistics = $this->getLogistics($orderHeaders);
  80. $shops = $this->getShops($orderHeaders);
  81. $batches = [];
  82. $orders = $this->service->getByWmsOrders($orderHeaders);
  83. $crate_orders = $this->service->getCreateOrderModelsByWMSOrderHeaders($orderHeaders, $orders, $warehouses, $owners, $logistics, $shops, $batches);
  84. if($orders->count() == $orderHeaders->count() ){
  85. $this->assertEquals($orders->count(),$orderHeaders->count());
  86. }
  87. $crate_orders = collect($crate_orders);
  88. foreach ($orderHeaders as $orderHeader) {
  89. $order = $crate_orders->where('code',$orderHeader->orderno)->first();
  90. $order = new Order($order);
  91. $exist_order = $orders->where('code',$orderHeader->orderno)->first();
  92. if(isset($exist_order))continue;
  93. $this->assertNotNull($order);
  94. $warehouse = Warehouse::query()->where('code',$orderHeader->warehouseid)->first();
  95. if($orderHeader->warehouseid ?? false)
  96. $this->assertEquals($warehouse->id ?? '',$order->warehouse_id ?? '');
  97. $owner = Owner::query()->where('code',$orderHeader->customerid)->first();
  98. if($orderHeader->customerid ?? false)
  99. $this->assertEquals($order->owner_id ?? '',$owner->id??'');
  100. $logistic = Logistic::query()->where('code',$orderHeader->userdefine1??'')->first();
  101. if($orderHeader->userdefine1 ?? false)
  102. $this->assertEquals($logistic->id ?? '',$logistic->id ?? '');
  103. $shop = Shop::query()->where('name',$orderHeader->issuepartyname)->where('owner_id',$owner->id)->first();
  104. if($orderHeader->issuepartyname ?? false)
  105. $this->assertEquals($shop->name,$orderHeader->issuepartyname);
  106. $this->assertEquals($order->consignee_name ,$orderHeader->c_contact);
  107. $this->assertEquals($order->consignee_phone ,empty($orderHeader->c_tel2)?$orderHeader->c_tel1:$orderHeader->c_tel2);
  108. $this->assertEquals($order->province ,$orderHeader->c_province);
  109. $this->assertEquals($order->city ,$orderHeader->c_city);
  110. $this->assertEquals($order->district ,$orderHeader->c_district);
  111. $this->assertEquals($order->client_code ,$orderHeader->soreference1);
  112. $this->assertEquals($order->wms_edittime ,(string)$orderHeader->edittime);
  113. $this->assertEquals($order->wms_status ,$orderHeader->oracleBASCode_codename_c);
  114. }
  115. }
  116. public function getWareHouses($orderHeaders)
  117. {
  118. return $this->warehouseService->getByWmsOrders($orderHeaders);
  119. }
  120. public function getOwners($orderHeaders)
  121. {
  122. return $this->ownerService->getByWmsOrders($orderHeaders);
  123. }
  124. public function getLogistics($orderHeaders)
  125. {
  126. return $this->logisticService->getByWmsOrders($orderHeaders);
  127. }
  128. public function getShops($orderHeaders)
  129. {
  130. return $this->shopService->getByWmsOrders($orderHeaders);
  131. }
  132. public function tearDown(): void
  133. {
  134. cache()->forget("getLogisticByCode_{$this->data['logistic']}");
  135. cache()->forget("getOwnerByCode_{$this->data['owner']}");
  136. cache()->forget("getShopByCodeMap_{$this->data['shop']}");
  137. // cache()->forget("WareHouse_{$this->data['warehouse']}");
  138. Shop::query()->where('owner_id',$this->data['owner']['id'])->delete();
  139. Logistic::query()->where('code','TEST_CA')->where('name','测试承运商')->forceDelete();
  140. Owner::query()->where('name','测试货主')->delete();
  141. Warehouse::query()->where('code','WH_TEST')->delete();
  142. parent::tearDown(); // TODO: Change the autogenerated stub
  143. }
  144. }