Query nested 2 layers deep collections in laravel

Can you try formatting your code with ``` on the line before and after. Also please show the code you have so far for the query

Hi I did format. Can you help me solve this?

Hmm it seems it is three levels deep. Can you show how you create this collection?

HI it gives error as {message: "Call to a member function where() on array",…}

    {

 
      $solutionSet[] = array(
        'ip_address'       => $ip_address
       );
   
    foreach($fareresponse->flight->legs->fareresponseleg->connections->fareresponseconnection as $connection)
      {

        $availstring   = (string)$connection->availstring;

        $outboundFlights[]    = array(
          "id"                   => $id,
          'availstring'          => $availstring
                
        );

      foreach($connection->segments->fareresponsesegment as $fareresponsesegment)
        {
        
          $outboundairsegments[] = array(
             "id"                 => $id,
             "availstring"        => $availstring,
             "flightType"         => "outbound"
           

          );
        }
      }
      
    }

     $outbound  = array();
        $outboundFlights = $outboundFlights->map(function($item) use ($outboundairsegments){
        foreach($outboundairsegments as $outboundairsegment)
        {
          if(preg_replace('/[^A-Za-z0-9\-]/', '',$outboundairsegment['availstring']) == preg_replace('/[^A-Za-z0-9\-]/', '',$item['availstring']))
          {
            $outbound[]   = $outboundairsegment;   
            }
           }
          return collect($item)->put('outboundairsegments', $outbound);     
        });


       $data  = array();
        $solutionSet = $solutionSet->map(function($item) use ($outboundFlights){
        foreach($outboundFlights as $outboundFlight)
        {
          if(preg_replace('/[^A-Za-z0-9\-]/', '',$outboundFlight['id']) == preg_replace('/[^A-Za-z0-9\-]/', '',$item['id']))
          {
            $data[]   = $outboundFlight;   
            }
           }
          return collect($item)->put('outboundFlights', $data);     
        }); 
             
    $price = array();
     $solutionSet = $solutionSet->map(function($item) use ($priceDetails){
      foreach($priceDetails as $priceDetail)
      {
        if(preg_replace('/[^A-Za-z0-9\-]/', '',$priceDetail['id'])  == preg_replace('/[^A-Za-z0-9\-]/', '',$item['id']))
        {
          $price[]  = $priceDetail;
          }
        }
        return collect($item)->put('priceDetails', $price);
     });

  } ```

Sorry but that code is almost unreadable unless I can actually debug it. I don't see you set flights anywhere in that code? Work on getting flights to point to a collection, not a an array with a collection inside

Edit :seems my first response was overwritten somehow.

sorry "flights" = "outboundFlights",

$solutionSet = $solutionSet->map(function($item) use ($numOfStops) {
                $item   = collect($item['outboundFlights'])->whereIn('outNumStops', $numOfStops);
                return $item;
            });

If i put collect(), then it works, there is no error on where() on array

Yes it would, but is the result correct?

No, There is an issue of not filtering properly.

As expected. Like I said, it is three levels deep not two :)

Collection > array > collection

Yeah. Thats true. Is creating collection into 3 level depth fine? Is it the good practise?

Try changing this line (remove [])

$data   = $outboundFlight;

And then you can filter like this if I understand you correctly

$data = $data->filter(function($item) use ($id) {
    return !! $item->outboundFlight->firstWhere('id', $id);
});

Hi thanks, I am sorry I didn't get you.

The Below code works

$solutionSet = $solutionSet->map(function($item) use ($numOfStops) {
                $item['outboundFlights']   = collect($item['outboundFlights'])->whereIn('outNumStops', $numOfStops);
                return $item;
            });

It filters fine, But how can i come out to root(1st level collection) and display the sorted collections as a whole.

Hi I tried the above one which you have given, But it gives error.

Well without knowing the error I have a hard time giving advise