RegroupOrderCommoditiesTest.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  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. var_dump('查询数据为空');
  36. return;
  37. }
  38. $order_nos = Order::all()->map(function($order){
  39. return $order->code;
  40. });
  41. dd(Order::all()->map(function($order){
  42. return $order->created_at;
  43. }));
  44. $order_nos = data_get($orderHeaders,'*.orderno');
  45. $order_commodities = OrderPackageCommodities::query()->with(['commodity','package.order'])->whereHas('package',function($query)use($order_nos){
  46. $query->whereHas('order',function ($query)use($order_nos){
  47. $query->whereIn('code',$order_nos);
  48. });
  49. })->get();
  50. $orders = Order::query()->whereIn('code',$order_nos)->get();
  51. $order = Order::query()->whereIn('code',$order_nos)->sql();
  52. $params = $this->service->regroupOrderCommodities($order_commodities);
  53. $_params = [];
  54. $orderHeaders->each(function($order_header)use(&$_params){
  55. $order_header->actAllocationDetails->each(function($detail)use(&$_params){
  56. $order_no = $detail->orderno;
  57. $logistic_number = $detail->picktotraceid;
  58. $sku = $detail->sku;
  59. $key = ' orderno='.$order_no.' logsitic_number='.$logistic_number.' sku='.$sku.' ';
  60. if(isset($_params[$key])){
  61. $_params[$key]['amount'] += $detail->qty_each;
  62. }else{
  63. $_params[$key] = [
  64. 'orderno'=>$order_no,
  65. 'logistic_number'=>$logistic_number,
  66. 'sku' => $sku,
  67. 'amount' => $sku,
  68. 'owner_code' => $detail->customerid
  69. ];
  70. }
  71. });
  72. });
  73. foreach ($_params as $key=>$param) {
  74. $this->assertNotEmpty($params[$key]);
  75. }
  76. }
  77. }