GetCreateOrderModelByWMSOrderHeadersTest.php 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  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. DB::insert('insert ignore into owners (code,name) values(?,?)',['TEST_OW','测试货主']);
  59. $this->data['owner'] = Owner::query()->where('code','TEST_OW')->where('name','测试货主')->first();
  60. $wmsOrderHeader = factory(OracleDOCOrderHeader::class)->make([
  61. 'customerid'=>$this->data['owner']['code'],'sostatus'=>99,'userdefine1'=>'TEST_CA','warehouseid'=>'WH_TEST'
  62. ]);
  63. // $this->data['warehouse'] = factory(Warehouse::class)->create(['code'=>'WH_TEST']);
  64. $res = DB::insert('insert ignore into logistics (code,name) values(?, ?)',['TEST_CA', '测试承运商']);
  65. $this->data['logistic'] = Logistic::query()->where('code','TEST_CA')->where('name','测试承运商')->first();
  66. $this->data['shop'] = factory(Shop::class)->create(['owner_id'=>$this->data['owner']['id']]);
  67. $code_BasCode = factory(OracleBasCode::class)->make(['codeid'=>'OW','code'=>'99','descr_c'=>'订单完成']);
  68. $orderType = factory(OracleBasCode::class)->make(['code'=>'sysy', 'codeid'=>'SO_TYP', 'codename_c'=>'测试状态']);
  69. $wmsOrderHeader->setRelation('orderType',$orderType);
  70. $wmsOrderHeader->setRelation('oracleBASCode',$code_BasCode);
  71. $this->data['orderHeader'] = $wmsOrderHeader;
  72. }
  73. /**
  74. * @test
  75. */
  76. public function getCreateOrderModelByWMSOrderHeaders()
  77. {
  78. $orderHeaders = collect([$this->data['orderHeader']]);
  79. $warehouses = $this->getWareHouses($orderHeaders);
  80. $owners = $this->getOwners($orderHeaders);
  81. $logistics = $this->getLogistics($orderHeaders);
  82. $shops = $this->getShops($orderHeaders);
  83. $batches = [];
  84. $orders = $this->service->getByWmsOrders($orderHeaders);
  85. $crate_orders = $this->service->getCreateOrderModelsByWMSOrderHeaders($orderHeaders, $orders, $warehouses, $owners, $logistics, $shops, $batches);
  86. if($orders->count() == $orderHeaders->count() ){
  87. $this->assertEquals($orders->count(),$orderHeaders->count());
  88. }
  89. $crate_orders = collect($crate_orders);
  90. foreach ($orderHeaders as $orderHeader) {
  91. $order = $crate_orders->where('code',$orderHeader->orderno)->first();
  92. $order = new Order($order);
  93. $exist_order = $orders->where('code',$orderHeader->orderno)->first();
  94. if(isset($exist_order))continue;
  95. $this->assertNotNull($order);
  96. $warehouse = Warehouse::query()->where('code',$orderHeader->warehouseid)->first();
  97. if($orderHeader->warehouseid ?? false)
  98. $this->assertEquals($warehouse->id ?? '',$order->warehouse_id ?? '');
  99. $owner = Owner::query()->where('code',$orderHeader->customerid)->first();
  100. if($orderHeader->customerid ?? false)
  101. $this->assertEquals($order->owner_id ?? '',$owner->id??'');
  102. $logistic = Logistic::query()->where('code',$orderHeader->userdefine1??'')->first();
  103. if($orderHeader->userdefine1 ?? false)
  104. $this->assertEquals($logistic->id ?? '',$logistic->id ?? '');
  105. $shop = Shop::query()->where('name',$orderHeader->issuepartyname)->where('owner_id',$owner->id)->first();
  106. if($orderHeader->issuepartyname ?? false)
  107. $this->assertEquals($shop->name,$orderHeader->issuepartyname);
  108. $this->assertEquals($order->consignee_name ,$orderHeader->c_contact);
  109. $this->assertEquals($order->consignee_phone ,empty($orderHeader->c_tel2)?$orderHeader->c_tel1:$orderHeader->c_tel2);
  110. $this->assertEquals($order->province ,$orderHeader->c_province);
  111. $this->assertEquals($order->city ,$orderHeader->c_city);
  112. $this->assertEquals($order->district ,$orderHeader->c_district);
  113. $this->assertEquals($order->client_code ,$orderHeader->soreference1);
  114. $this->assertEquals($order->wms_edittime ,(string)$orderHeader->edittime);
  115. $this->assertEquals($order->wms_status ,$orderHeader->oracleBASCode_codename_c);
  116. }
  117. }
  118. public function getWareHouses($orderHeaders)
  119. {
  120. return $this->warehouseService->getByWmsOrders($orderHeaders);
  121. }
  122. public function getOwners($orderHeaders)
  123. {
  124. return $this->ownerService->getByWmsOrders($orderHeaders);
  125. }
  126. public function getLogistics($orderHeaders)
  127. {
  128. return $this->logisticService->getByWmsOrders($orderHeaders);
  129. }
  130. public function getShops($orderHeaders)
  131. {
  132. return $this->shopService->getByWmsOrders($orderHeaders);
  133. }
  134. public function tearDown(): void
  135. {
  136. cache()->forget("getLogisticByCode_{$this->data['logistic']}");
  137. cache()->forget("getOwnerByCode_{$this->data['owner']}");
  138. cache()->forget("getShopByCodeMap_{$this->data['shop']}");
  139. // cache()->forget("WareHouse_{$this->data['warehouse']}");
  140. Shop::query()->where('owner_id',$this->data['owner']['id'])->delete();
  141. Logistic::query()->where('code','TEST_CA')->where('name','测试承运商')->forceDelete();
  142. Owner::query()->where('name','测试货主')->delete();
  143. Warehouse::query()->where('code','WH_TEST')->delete();
  144. parent::tearDown(); // TODO: Change the autogenerated stub
  145. }
  146. }