Tag: collections

Laravel check if belongstomany contains belongstomany

in my system: a lead belongstomany salespeople a manager belongstomany salespeople i am trying to check if a lead has a manager through the salespeople. this is for a policy so i can make sure a manager can see the leads of their salespeople. something like this: is there a collection method that will allow m…

Eloquent Sort By depend on the field

collections eloquent laravel php

I have a query like this: I want to sort the result but i have problem. if the result of withMin if null i want to sort it by another field (lets say ‘product.sale_price’). Or how can i make a new field, lets say ‘final_price’, if promotion_price is null use sale_price. What i already …

How to display pagination links in a blade on Laravel 8?

collections laravel pagination php

I need to add pagination, but it seems complicated in my case, because I get data from database with paginate, but then I modify this data and when I call links() method on the blade, I get the following exception Method IlluminateSupportCollection::links does not exist. My code in the Controller method: Yes,…

How to add array inside array based on PHP condition?

collections laravel php

I have a laravel collection below from: $unitinventory = DB::select(‘call wh_inventory_list(?)’, array(‘Units’)); And another collection: $modifification = collect(DB::table(‘pd_jo_bodymodification’)->get()); I want to find out if a $unitinventory->chassis_no has a mo…

Transform nested collection in laravel

collections laravel laravel-5 laravel-collection php

I have a nested collection that I want to transform, pulling some keys “up a level” and discarding some other keys. Every item in the collection has an allergens property. I need to make each items allergens property, look like I’ve tried the following: But it doesn’t overwrite the all…

Is there any way to optimize the query while working with 2mil+ rows database table

collections laravel mariadb php sql

I am working on Laravel query that shall count the latest month data and also group by week, for the last 3 months. I have tried to fix that in a few ways but still it’s exceeds my memory limit and load very slow. Bellow is the current code that I am using to get the final results – but

Detect if array contains another array

arrays collections laravel php

I’m using external API for my website. When user select city and town, API returns neighborhoods. But the problem is, if there is only one neighborhood array contains name and neighborhood id. But if there is more than one, it contains multiple array for each neighborhood. Single example ; Multiple Exam…

Laravel collection multi level groupBy insert new items without checking each level’s key

collections grouping laravel php

Laravel collections now have a great multi-level groupBy function built in, but I am struggling with a sensible way to insert new items. For example: Very nice, easy to set up and access. For this example, I will assume each key is a number If there are already items in the nested positions [1], [2], and [3] …

Laravel get most recent array item for each day in array

collections greatest-n-per-group laravel php sorting

I’m trying to figure out the best way (whether I do this using the query builder or raw PHP) to get the most recent array item based on it’s created_at timestamp for a given day, in an array …

Grouped collection to associative array

arrays collections laravel php

I need to achive array in format showed at the end, I’m using laravel collections $query->get()->groupBy(‘COLOR’)->toArray(); array:2 [ “GREEN” => array:123 [ 0 => array:…