RegroupOrderCommoditiesTest.php 2.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. <?php
  2. namespace Tests\Services\OrderPackageCommoditiesService\RegroupOrderCommoditiesTest;
  3. use App\Order;
  4. use App\OrderPackage;
  5. use App\OrderPackageCommodities;
  6. use App\Services\OracleDOCOrderHeaderService;
  7. use App\Services\OrderPackageCommoditiesService;
  8. use Carbon\Carbon;
  9. use Illuminate\Foundation\Testing\RefreshDatabase;
  10. use Illuminate\Foundation\Testing\WithFaker;
  11. use Tests\TestCase;
  12. class RegroupOrderCommoditiesTest extends TestCase
  13. {
  14. /**
  15. * @var OrderPackageCommoditiesService $service
  16. * @var OracleDOCOrderHeaderService $orderHeaderService
  17. */
  18. public $service;
  19. public $orderHeaderService;
  20. public function setUp(): void
  21. {
  22. parent::setUp();
  23. $this->service = app('OrderPackageCommoditiesService');
  24. $this->orderHeaderService = app('OracleDocOrderHeaderService');
  25. }
  26. public function testRegroupOrderCommodities()
  27. {
  28. /*
  29. * createOrderPackage($orderHeaders,$orders,$packages)
  30. * */
  31. $carbon =Carbon::now()->subHours(10);
  32. $date = '2020-06-18 18:13:50';
  33. $orderHeaders = $this->orderHeaderService->getWMSOrderOnStartDate($date);
  34. if($orderHeaders->count()==0){
  35. return;
  36. }
  37. $order_nos = Order::all()->map(function($order){
  38. return $order->code;
  39. });
  40. $order_nos = data_get($orderHeaders,'*.orderno');
  41. $order_commodities = OrderPackageCommodities::query()->with(['commodity','package.order'])->whereHas('package',function($query)use($order_nos){
  42. $query->whereHas('order',function ($query)use($order_nos){
  43. $query->whereIn('code',$order_nos);
  44. });
  45. })->get();
  46. $orders = Order::query()->whereIn('code',$order_nos)->get();
  47. $order = Order::query()->whereIn('code',$order_nos)->sql();
  48. $params = $this->service->regroupOrderCommodities($order_commodities);
  49. $_params = [];
  50. $orderHeaders->each(function($order_header)use(&$_params){
  51. $order_header->actAllocationDetails->each(function($detail)use(&$_params){
  52. $order_no = $detail->orderno;
  53. $logistic_number = $detail->picktotraceid;
  54. $sku = $detail->sku;
  55. $key = ' orderno='.$order_no.' logsitic_number='.$logistic_number.' sku='.$sku.' ';
  56. if(isset($_params[$key])){
  57. $_params[$key]['amount'] += $detail->qty_each;
  58. }else{
  59. $_params[$key] = [
  60. 'orderno'=>$order_no,
  61. 'logistic_number'=>$logistic_number,
  62. 'sku' => $sku,
  63. 'amount' => $sku,
  64. 'owner_code' => $detail->customerid
  65. ];
  66. }
  67. });
  68. });
  69. foreach ($_params as $key=>$param) {
  70. $this->assertNotEmpty($params[$key]);
  71. }
  72. }
  73. }