I have a model Facility that has rates (tariffs). The Rate model has a relationship to a RateType. The RateType has a column weight. I want to sort the Facility's rates based on those weights. I would like to always…
I'm trying to select a specific column from a relationship. F.x User::with(array('phone' => function($q) { $q->where('ext', "!=" 42); }))->select('id', 'number'); Here i ONLY want to select the user ID, and the number for the phone. How can i do that?…
I'm using laravel with query builder. Is there a way to transform a query builder result into json respecting the child elements and not creating a parse manually ? I mean, transform this: id customer product_id product 1 Will 1…
I am working on an application that has genders as a standardized entity and the gender ids are used in the user entity. So user1 has gender_id = 1. How do i specify that if the gender id is used…
As it is right now ->join() is a query builder so it wouldn't using Model that has SoftDelete, there is too many codes that used join in my project so I don't want to manually replace it all with eager…
I need to make an advanced query in Laravel hopefully using Eloquent to make that a collection but a query builder or raw normal SQL query is acceptable. I have users table with User model having relation: public function roles()…
I want to display the sum total of all credit activities in a user account as his main account balance. I have three different wallet, bonus, referral and deposit and will like to sum up all of them together. This…
I have made a category and a posts table. On post table I'm storing the category id's in the JSON format on posts table. Now, I would like to get total count of posts for each category where categories are…
I'm trying to implement an efficient search on street names. A street has multiple residences (houses). The search I'm trying to build is street names LIKE %example% within the given city_id. The result must include the LIKE list of matching…
I have the following query params in string format $query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])'; How do i pass it to the eloquent? Am trying to achieve something like this InboundMessage::query()->{$query}; Am getting the error below Property [->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'),…