How to search value in collection and merge model in laravel

Level 1

Any help on this please?

Level 51

for the first part I think you want pluck https://laravel.com/docs/9.x/collections#method-pluck

not sure of the exact path but

$productnames = $invoices->pluck('lines.id');

then you want whereIn not where

    $plans = Plan::whereIn('stripe_id', $productnames)->first();

but that first only will give you the first row. so you probably want...

    $plans = Plan::whereIn('stripe_id', $productnames)->get();

Level 51

and another goodie is higher order map.

You can do $invoices->map->lines and get all the lines from the invoices.

 $invoices->map->lines->pluck('id')

1 like

Level 1

@webrobert thank you for the reply, i have a nested array

$database = collect($invoices)->map->lines->map->data;

the data has a price array, when i fetch the price through mapping it shows error

Undefined array key "price"

$database = collect($invoices)->map->lines->map->data->map->price->id;

in case you wanted to look into array i attached screenshot. https://www.dropbox.com/s/u6fgp3ctz0rxqah/error.png?dl=0

Level 51

what do you get when you dd $invoices->map->lines->toArray()?

Level 1

@webrobert i get this https://www.dropbox.com/s/vg89uo28r0pzneg/array.png?dl=0

Level 51

I think you want ...

$invoices->map(fn ($item) => $item->lines->data)->pluck('id');

Level 1

@webrobert it return a null value.

Level 51

and What about this

$invoices->map(fn ($item) => $item->lines->data)->toArray()

@webrobert this https://www.dropbox.com/s/77cyzxgv13pmczl/this.png?dl=0

Level 1

Level 51

@waleedviews, ok what do you want? do you want the ids for ALL those items?

$invoices->flatMap(fn ($item) => $item->lines->data)->pluck('id')

or something else?

Level 1

@webrobert something else, i want to get the price array, so price->id https://www.dropbox.com/s/u6fgp3ctz0rxqah/error.png?dl=0

i select array in screenshot. you are fetching data->id, i want price->id it's nested array, if you check screenshot

Level 51

$invoices->flatMap( fn ($item) => $item->lines->data)->pluck('price.id')

1 like

Level 51

@waleedviews also

...you are fetching data->id

no, the flatMap should return a list of lines. it flattens out the array of arrays. then it should be returning the item id.

$invoices->flatMap(fn ($item) => $item->lines->data)->pluck('id')

any who.

1 like

Level 1

@webrobert this help alot. actually i wanted to fetch the price.id

numaan

Level 2

To get all the ids from the deep nested array, you can use the map method on the data array:

$productnames = $invoices->first()->lines->data->map(function($line) {
    return $line->id;
});

Then you can use the whereIn method to search for all the ids in the modal:

$plans = Plan::whereIn('stripe_id', $productnames)->get();

Regarding the merging of the collections, you're currently merging the entire $plans collection into the $invoicescollection collection. Instead, you can iterate over the $invoices collection and merge the corresponding plan into each invoice. Here's an example of how you could do this:

$invoices = $request->user()->invoices();
$invoices = $invoices->map(function($invoice) {
    $productnames = $invoice->lines->data->map(function($line) {
        return $line->id;
    });
    $plans = Plan::whereIn('stripe_id', $productnames)->get();
    return array_merge($invoice->toArray(), ['plans' => $plans->toArray()]);
});

This will add a new key plans to each invoice array, containing the corresponding plans.

It's also worth noting that you don't need to create a new Collection objects, since $invoices is already a collection, and Laravel collection are immutable, so you can chain the map method in the same way.

1 like

Level 51

thanks @numaan, now that we just did all that work.

@waleedviews did you just want the price->id for the first invoice?

then dont use flatMap

$invoices->first()
   ->map( fn ($item) => $item->lines->data)->pluck('price.id')

1 like

https://www.dropbox.com/s/pgvtvftthdzngq4/plansarray.png?dl=0

Level 1

@numaan thank you so much,

only issue is merging array, i want to merge plans in to each invoice array, however your solution shows as a key and then array which i don't want, i attach screenshot as well.

Level 1

@webrobert i want to fetch all the price->id, your help have resolved alot of my issues, thank you so much for your precious time, the only help i need with merging the arrays now.

Level 51

@waleedviews of course. This is getting the ids you want, yes?

$invoices->flatMap( fn ($item) => $item->lines->data)->pluck('price.id')

1 like

Level 1

@webrobert yes this was helpful, now i want to merge plans into each invoice array, very near to resolve the issue.

Level 51

@waleedviews what are you trying to achieve with the merge?

https://www.dropbox.com/s/pgvtvftthdzngq4/plansarray.png?dl=0

Level 1

@webrobert i want to merge plans in to each invoice, if you read @numaan answer he has merge it but not into each invoice array.

i want to add a key plans to each invoice array.

Level 51

Not sure that I follow. I thought we just got ALL the price.ids from all the invoices. not one... OR are you actually getting all the price.ids within each invoice?

Level 51

$invoices = $request->user()->invoices()
  ->map( function($invoice) {
      $priceIds = collect($invoice->lines->data)->pluck('price.id');

      $invoice['plans'] = Plan::whereIn('stripe_id', $priceIds)->get();

      return $invoice;
  });

Level 1

@webrobert very near, this is giving me an error

Call to undefined method Laravel\Cashier\Invoice::map()

Level 51

@waleedviews I edited my answer

Level 1

@webrobert another error

Cannot use object of type Laravel\Cashier\Invoice as array

this is generating an error

$invoice['plans'] = Plan::whereIn('stripe_id',  $priceIds)->get();

Best Answer

Level 51

@waleedviews wait, what...

$invoices = $request->user()->invoices()
  ->map( function($invoice) {
      $priceIds = collect($invoice->lines->data)->pluck('price.id');

	  dd($priceIds);

      $invoice['plans'] = Plan::whereIn('stripe_id', $priceIds)->get();

      return $invoice;
  });

Level 1

@webrobert same error

Level 51

I think we are off in the weeds a bit. I didn't realize this was cashier. I imagine there is a cleaner way to do what you are after. Unfortunately, I have to disband. Now. I think its close to working. Just back it out. The original code we wrote was to get all the price ids from all the invoices.

this bit...

$invoices->flatMap( fn ($item) => $item->lines->data)->pluck('price.id')

and that works.

but what you actually want is to get the price ids for each invoice and include them with the invoice, correct?

I imagine there is a way to query for this with Cashier.