UpdateStoreTest.php 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. <?php
  2. namespace Tests\Services\StoreService;
  3. use App\OracleBasCode;
  4. use App\OracleDOCASNDetail;
  5. use App\OracleDOCASNHeader;
  6. use App\Owner;
  7. use App\Services\CommodityService;
  8. use App\Services\StoreService;
  9. use App\Warehouse;
  10. use Illuminate\Support\Facades\DB;
  11. use Tests\TestCase;
  12. class UpdateStoreTest extends TestCase
  13. {
  14. /** @var StoreService $service */
  15. public $service;
  16. public $asnHeaders;
  17. public $stores;
  18. private $data=[];
  19. public function setUp(): void
  20. {
  21. parent::setUp(); // TODO: Change the autogenerated stub
  22. $this->service=app(StoreService::class);
  23. $this->data['warehouse'] = factory(Warehouse::class)->create(['code'=>'test_wh']);
  24. $this->data['owner'] = factory(Owner::class)->create(['code'=>'test_owner','name'=>'测试货主']);
  25. $wmsAsnHeader = factory(OracleDOCASNHeader::class)->make([
  26. 'customerid'=>'test_owner','warehouseid'=>'test_wh','asntype'=>'CSRK','asnstatus'=>'11',
  27. ]);
  28. $asnType = factory(OracleBasCode::class)->make(['codeid'=>'ASN_TYP','code'=>'CSRK','descr_c'=>'测试入库']);
  29. $asnStatus = factory(OracleBasCode::class)->make(['code'=>'11', 'codeid'=>'ASN_STS', 'codename_c'=>'测试状态']);
  30. $wmsAsnHeader->setRelation('asnType',$asnType);
  31. $wmsAsnHeader->setRelation('asnStatus',$asnStatus);
  32. $this->asnHeaders=collect();
  33. $this->asnHeaders->add($wmsAsnHeader);
  34. }
  35. public function testUpdateStore(){
  36. if (!$this->asnHeaders) {
  37. $this->assertNull($this->asnHeaders);
  38. }else{
  39. $this->service->updateStore($this->asnHeaders);
  40. $this->stores=$this->service->getByWms($this->asnHeaders);
  41. $this->assertNotNull($this->stores);
  42. }
  43. }
  44. public function tearDown(): void
  45. {
  46. $this->data['warehouse']->delete();
  47. $this->data['owner']->delete();
  48. $storeIds=[];
  49. foreach ($this->stores as $store){
  50. array_push($storeIds,$store->id);
  51. }
  52. $asnDetails=OracleDOCASNDetail::query()->whereIn('asnno',data_get($this->asnHeaders,'*.asnno'))->get();
  53. $maps = [];
  54. foreach ($asnDetails as $asnDetail) {
  55. $value = [
  56. 'owner_code' => $asnDetail->customerid,
  57. 'sku' => $asnDetail->sku,
  58. ];
  59. $maps[json_encode($value)] = $value;
  60. }
  61. /** CommodityService $commodityService */
  62. $commodityService=app(CommodityService::class);
  63. $commodities=$commodityService->getCommoditiesByMaps($maps);
  64. $commodity_ids=[];
  65. foreach ($commodities as $commodity){
  66. array_push($commodity_ids,$commodity->id);
  67. }
  68. DB::table('stores')->whereIn('asn_code',data_get($this->asnHeaders,'*.asnno'))->delete();
  69. DB::table('commodities')->whereIn('id',$commodity_ids)->delete();
  70. DB::table('store_items')->whereIn('store_id',$storeIds)->delete();
  71. parent::tearDown(); // TODO: Change the autogenerated stub
  72. }
  73. }