Laracasts Forum -

eloquent get result of query (true or false)

Any idea how I can easily query the database using the query below and save the status into a variable? Using something like whereHas() isn't the way to go I think. $product = Product::find(3); //just require a simple true or false $productHasActiveSales = ($this->whereHas('orders', function ($query) { $query->where('orders.created_at', '>=', Carbon::now()->

Nakov4yrs ago Eloquent

Last reply by Nakov 4yrs ago

Getting error in a nested query : Exception Property [individual] does not exist on the Eloquent builder instance.

Getting this error. $listings = Listings::with('project.city','user','project.locality') ->whereHas('project.city', function ($query) {$query->where('status', 1);}) ->where ('status', '1') ->whereIn('listingtype', [$forsale, $buyers, $forrent, $lookingtorentout]) ->when($request->bedrooms, function ($query) use

FounderSta...4yrs ago Laravel

How to Convert QUERY MySQL to Laravel 8

Hi everybody, Can anyone help me please, i want to convert this query to Laravel: $stmt = $con->prepare(' SELECT SUM(rating IN (4.5, 5))/COUNT(*)*100 AS pct_5_star, SUM(rating IN (3.5, 4))/COUNT(*)*100 AS pct_4_star, SUM(rating IN (2.5, 3))/COUNT(*)*100 AS pct_3_star, SUM(rating IN (1.5, 2))/COUNT(*)*100 AS pct_2_star, SUM(rati

nurularifi...4yrs ago Laravel

Last reply by nurularifin 4yrs ago

Query builder get count of one to many relation

i have tables like below, tests test_id, test_name,test_code,date,test_active,test_type test_package_mapping id, test_id, package_id user_tests id, test_id, user_id, marks_scored Now i am displaying all the tests of selected package like below, $package_ids = [1,2]; $alltests = DB::table('test_package_maping')->join('tests', 'test_package_maping.test_id', '=', 'tests.test

Deekshith4yrs ago Laravel

Last reply by Deekshith 4yrs ago

Correct query for multiplier filters ?

I need to show listings of projects with following filters : If locality of a city is selected Type of listings a. for sale b. for purchase c. for rent d. for rent out type of BHk a. 1 bhk b. 2-3 bhk c. 4 bhk onwards posted by a. individual b. broker My present controller query : I am unable to write nested orWhere for the above filters : $listings = Listings::with('use

Tray24yrs ago Laravel

Last reply by Tray2 4yrs ago

What sis the correct query to filter data ?

I am trying to filter projects with active listings only. IN the filter I have a checkbox , if I need to filter projects based on the number of active listings. My controller query is : $projects = projects::with('builder','city','locality') ->where('project_city', $city) ->withCount('reviews

FounderSta...4yrs ago Laravel

Create a Eloquent query in a blade component

Hi everyone. I would like to know if it could be possible to make/create a query (either eloquent/DB) inside a blade component. For example: public $categories = []; public $promosaleid; public function __construct($promosaleid) { $this->promosaleid = $promosaleid; $this->categories = Category::query()->with(array('products' => function($query) use($this-&g

davidebo3yrs ago Laravel

Last reply by davidebo 3yrs ago

Order a query by its relationship

Lets say I have three models - Artbook, Collection, Artwork with relationship as follows Artbook -> hasMany -> Collection -> hasMany -> Artwork Artbook -> hasMany -> Artwork -> through -> Collection ---------------------------------- Artbook is a public model while Collection belongs to a user. So any user can create a Collection for any Artbook. Thus, t

mrkarma4ya4yrs ago Laravel

Last reply by mrkarma4ya 4yrs ago

Laravel relationship eloquent query

Hi Guys, I am using Laravel5.6* and I have a relationship between the products and users. App\Product Model /** * each product belongs to a user * @return [type] [description] */ public function user() { return $this->belongsTo('App\User', 'users_user_id', 'user_phone'); } Now I want to get all the products which have a category id 3 and I also want to get the n

Sinnbeck4yrs ago Eloquent

How do order by sum (query builder/sql)

How do I oder by sum with this query: $votes = DB::table('votes') ->where('website_id', $site->id) ->sum('stars');

Sinnbeck4yrs ago Code Review

Eloquent query on a created_at column

Hi. I'm working on a legacy database where I need to grab rows differently based on the date. I.e. For anything before 2022, i need to grab the 'transaction_type' column where it contains 'DB' and then anything after the start of this year, I need to grab the 'transaction_type' column contains 'CR' Is there a way of doing this? I saw the ->when() function, but seems this isn

skoobi4yrs ago Laravel

Last reply by skoobi 4yrs ago

Problem with query builder

Hello everyone! I have the following query: $reviews = Reviews::query(); if(!empty($request->stars)) { foreach($request->stars as $star) { $reviews->orWhere('review_stars', '=', $star); } } $reviews->orderBy('created_at', 'desc')->paginate(6); compacted and sent to the blade template file

Sinnbeck4yrs ago Laravel

How to optimise query ?

I need following totals and I am using in blade as @php $activelistings = App\Models\Listings::where('project_id',$item->id) ->where('status',1)->latest()->count(); $totalinprogress = App\Models\Listings::where('project_id',$item->id)->where('status',1) ->where('dealstatus','inprogress')->latest()->count(); $totalclosed = App\Models\L

Sinnbeck4yrs ago Laravel

Please HELP ME, the query doesn't work JOIN and WHERE clause on the joined table's column

$filter->where(function ($query) { $query->leftjoin('customers AS c', function($join){ $join->on('booking.customer_id', '=', 'c.id') ->where('c.first_name', 'like', "%{$this->input}%"); })->dump(); }, 'Customer has booking')->placeholder('search by first name Like'

Tray24yrs ago Eloquent

Last reply by Tray2 4yrs ago

Composing Eloquent query with orWhere

I'm using Larastan to eliminate some of the static analysis errors I have going on in my codebase. I have several errors involving the the Eloquent Higher Order Messaging Proxy known as orWhere. I'm using this method as show below. ModelA::query()->scopeOne()->orWhere->scopeTwo()->get(); After looking through the Larastan repository I stumbled upon this issue that

martinbean4yrs ago Eloquent

Last reply by martinbean 4yrs ago

laravel query not working properly while working on sql database

i run this query on phpmyadmin database table working fine: select substring_index( prefix, '.', 3 ) as subip , count(prefix) as count, prefix from prefixes GROUP BY INET_ATON(subip)/256 order by cidr desc when i run raw query in laravel: $selected_prefixes = DB::select("select substring_index( prefix, '.', 3 ) as subip , count(prefix) as count, prefix from prefixes GROUP

jlrdw4yrs ago Eloquent

Last reply by mailresponse 2yrs ago

Building filtering query with where() and whereHasMorph()

I have a users table with a morph relation to a profile. I'm searching for the firstname, middlename, lastname and id on the users table and contact in the student_profiles. $query->when($filters['search'] ?? false, function ($query, $search) { $query->where(function ($query) use ($search) { $query->where('firstname', 'like', '%' . $search .

kramsuiluj4yrs ago Code Review

Last reply by kramsuiluj 4yrs ago

Laravel DB Query is slower than plain PDO implementation. Why?

Can someone explain to me, why the plain PDO implementation with PDO is waaayyy faster than the framework implementation? To be clear, we do not talk about query optimization and adding indexes or not. I just figured out, that the laravel way is slower than the plain way and I wish to know how to solve this. greetings, J P.S.: forget to mention, for reproduction I use a existi

mailrespon...2yrs ago Eloquent

How to use truncate & avg function in laravel query ?

SELECT TRUNCATE(AVG(rating),2) FROM `reviews` WHERE restro_id=9 I want to write above query in laravel, How can I achieve it ?

iamssingh4yrs ago Laravel

Last reply by iamssingh 4yrs ago

Query Scope with Spatie Permission

Hello, I am writing a query scope based on the Permissions the user has using Spatie Permission Package. And this is what I have so far. $query->when($readAllRequests, function ($request) use ($admin) { // do nothing when they can read all requests }); $query->when($readAssignedRequests, function ($request) use ($admin) { $request->where('receiver_id', $admin-&

pickab004yrs ago Laravel

Last reply by pickab00 4yrs ago

Retain old query parameter on form submit of GET.

I have a full URL like below, https://www.example.com/admin/test-offline-conversions/213/T-203?attendancestatus=Present Now i have added another filter and i have a form tag like below, <form action="{{ route('offlineconvertedtests',[$coursedetails->course_code,$testdetail->test_code]) }}" method="GET" role="search">

Deekshith4yrs ago Laravel

Last reply by Deekshith 4yrs ago

Advance where orWhere query, looping over array.

I'm having some trouble building an advance where() orWhere() query, where the orWhere() loops over array of filters. I am using Livewire for the search filter but will just add some sample content here. Sample data: $locations = [ {'id': 1, 'category_id': 1, 'min_value': 10, 'max_value': 20}, {'id': 2, 'category_id': 2, 'min_value': 15, 'max_value': 25}, {'id': 3, 'cate

Sinnbeck4yrs ago Code Review

Last reply by eliekhazzaka 4yrs ago

Laravel trim in query

guys, i have a column name called attachment_files in my query and save it in DB this way 1641210480.Python-Cheat-Sheet.pdf. i need when i make the query to return it this way Python-Cheat-Sheet.pdf how can i do it? $getMerchant = Merchant::leftjoin('ratings', 'ratings.merchant_id', '=', 'merchants.id', 'merchant_qualification', 'merchant_qualification.qualification')

eliekhazza...4yrs ago Laravel

Can Eloquent query AND USE the value of a previous relation within the same query?

Hi all, No idea if my title makes any sense. But I would like to know if this is possible with eloquent please: ModelA::select( 'id', ) ->with('ModelB:id,name') ->with('ModelC:id,name') ->with(['ModelD' => static function ($query){ $query->where('ModelD.id','=', 'Model

User19804yrs ago Eloquent

Last reply by User1980 4yrs ago

Raw Count Group By Query

Hi guys, this query works, as I execute it on phpmyadmin, but it won't via laravel: $query = "SELECT COUNT(*) AS visits, users.id AS userid, users.name, users.slug, user_visits.id, user_visits.id_user, user_

jlrdw4yrs ago Laravel

Query string array format best practice?

In my livewire component I have an certain amount of features to filter on. If i store the features in an array I get an ugly query string like: ?features[0]=firstfeature&features[1]=secondfeature&features[2]=thirdfeature&... I don't like this because it can get very long very fast and also it's not as readable as for example: ?features=firstfeature,secondfeature,th

jlrdw4yrs ago Livewire

Last reply by mabdullahsari 4yrs ago

Query builder not selecting data correctly

My Query builder in not selecting the correct data it selecting all data form table not according to status my code <?php namespace App\Modules\Search\Repositories; use App\Modules\Fleet\Models\Fleet; use App\Modules\Search\Exceptions\SearchVehiclesIndexException; use App\Modules\Search\Interfaces\SearchVehiclesInterface; use App\Modules\Vehicle\Models\Vehicle; use App\Mod

KalimeroMK4yrs ago Laravel

Last reply by KalimeroMK 4yrs ago

Query Collection on nested item

Assume I have the following Eloquent query (Since I will use the returned collection in more than one place, I eager load the related model) : $myModels = MyModel::with(['myRelatedModel'])->where(...) ... ->get(); Now, what if I want to query $myModels to return only the ones where a field of myRelatedModel is xyz ? In a normal Eloquent query I'd use whereHas, but on col

mabdullahs...4yrs ago Laravel

Laravel - how to use model's ID inside belongs to many relationship query?

Models: Products Variants VariantValue // Product.php public function variants() { return $this->belongsToMany(Variant::class, 'product_variant', 'product_id', 'variant_id') ->with([ 'values' => function ($builder) { return $builder->whereHas('products', function ($q) { return $q->where('products.id', $

cecily4yrs ago Laravel

Last reply by cecily 4yrs ago

How to concat MySQL query into MongoDB

Hello Everyone! How to combine first name and last name in Laravel, and I am using Mongo Database in db table i have two field first name and last name... i was using laravel eloquent query for fetching records i was used sql concat but it's not working because of mongoDb Here my Query orWhere(\DB::raw("CONCAT(last_name, ' ', first_name)"), 'LIKE', "%".$sear

Sinnbeck4yrs ago Laravel

No query results for model INSIDE JOB

Hi, i want make a simple task for queue laravel. I have this error in "failed_jobs" Illuminate\Database\Eloquent\ModelNotFoundException: No query results for model....... What did i do wrong? //controller public function addUser(Request $req) { $user = new User; $user->name = $req->name; $user->username = $req->username;

Sinnbeck4yrs ago Laravel

Laravel Query

Hi Developers, can anyone help me to optimize the below code. What I want is to get the same results with forgetting the key instead get it from the query. $mul_users = User::join('role_users', 'role_users.user_id' , '=' , 'users.id') ->join('roles', 'roles.id' , '=' , 'role_users.role_id') ->where('roles.rank', '=', $mu_manager_ran

Sinnbeck4yrs ago Laravel

Stuck on eloquent related model query

I'm working on a registration system for a facility for disabled people. One of the things the team leaders are registering is the meals taken by the residents. I have a gebruikers (= the residents) table. Gebruikers are grouped in a team (many to many relationship). Gebruikers can have a breakfast, diner and supper. They eat together with their team colleagues. Meals are regis

Bervetuna4yrs ago Eloquent

Last reply by Bervetuna 4yrs ago

Laravel Query : find duplicates records based on multi conditions and group the result duplicates

I have a table of Shops and there is some duplicates records and i need to get them out but with some conditions : Get duplicates based on Name and Address OR if they have same Type AND Status i have used this solution but it only get 1 record and i want to get all duplicate records and also group them. Shop::where(function ($query) { $query->whereIn('id', function (

Tray22yrs ago Laravel

Last reply by Tray2 2yrs ago

What is the correct nested relationship query for filter page

I need to show list of builders on a page with selected city in dropdown filter. Builder is related to project project is related to city my controller public function SearchBuildersincity(Request $request){ $city = $request->project_city; $builders = Builders::whereHas('project.city', function ($query) { $query->where('status', 1)

FounderSta...4yrs ago Laravel

Chaining orWhere clauses on a query doesn't produce correct SQL statements

Hi all Today I had a quick script I needed to run to clear out some models from my DB I had some fields about the models but not their IDs, so I wrote quick query to pluck the uuid from. I had 3 bits of info to find the model by - orig, dest and dep_time_local (this is a Flight model) I simply did something like: $flights = Flight::where([ 'orig' => 'BEG', 'dest' =&g

justash6664yrs ago Eloquent

Last reply by justash666 4yrs ago

Query question. Not sure if this is possible.

Hello All, I need to run a query that return a total based on two different columns in a table. I will try and explain it the best way I can. I have a sold_log table, the table can have two salespeople on each entry if they are both associated with the log entry. A salesperson will get credit for 1 full 'Sold Log' if they are the only salesperson on the entry and .5 if there is

bugsysha4yrs ago Eloquent

Last reply by bugsysha 4yrs ago

How to write a better query?

How to write this query better: $employee = DB::table('employees') ->select('employees.id', 'employees.name') ->addSelect(['rank_id' => DB::table('reranks')->select('rank_id') ->whereColumn('reranks.employee_id', 'employees.id') ->orderByDesc('doc_date') ->limit(1) ])->addSelect(['doc_date' =>

bugsysha4yrs ago Guides

Last reply by bugsysha 4yrs ago

Query error

Hi everyone, I have an error in query and I'm not able to see what I did wrong: { return $request->withOrdering($request->withFilters( $query ->select(DB::raw('users.id as 'id', users.name as 'name', sum(products.price) as 'total'')) ->join('orders', 'users.id', '=', 'orders.user_id') ->joi

amjad_ah4yrs ago Laravel

Last reply by amjad_ah 4yrs ago

How to get correct nested eloquent query

I need to show total 'listings' in 'projects' of a 'builder' $totallistings = App\Models\Listings::whereHas('project.builder', function ($query) {$query->where('id','$item->id');})->count(); listings is related to projects project is related to builder Its giving nill count.

FounderSta...4yrs ago Laravel

Eloquent query not working as expected

I'm trying to filter using a query builder but I'm not getting the expected results. This is my code so far: The $request->get('detail') is the user input to search by, on the model being searched the relationships are like this public function activations() { return $this->hasMany(Activation::class, 'dmm_report_id'); } public function portabilities() {

tykus4yrs ago Eloquent

Last reply by tykus 4yrs ago

Error when using Eloquent query

I'm messing arround with Laravel as API backend and Nuxt js as frontend. Authentication on client side works with Laravel Sanctum pretty fine. But when I trying to query the route "/api/trips" I am facing some, in my opinon strange behaviour. Migration: Schema::create('trips', function (Blueprint $table) { $table->string('uuid')->primary();

wikorl4yrs ago Eloquent

Last reply by wikorl 4yrs ago

Mal-formed Query assistance

I am running a query and for some unknown reason the id's are getting edited. I am using UUID, i checked the model and made sure the id in question is not being cast as something query: "select * from `area_profiles` where `area_profiles`.`subscription_id` in (35, 9223372036854775807, 4);" Thats how the query is executed on the correct id's [ '35dd6aa2-5d58-11ec-8571

movepixels4yrs ago Laravel

Last reply by movepixels 4yrs ago

how to paginate query

Original Query $sort = File::latest()->get()->groupBy(function($item) { return $item->date; }); I tried this, and it doesn't work. it only gives one item $sort = File::latest()->paginate(50)->groupBy(function($item) { return $item->date; });

Sinnbeck4yrs ago Code Review

Is it possible to use a wildcard key in a JSON query?

I need to query for a model where any json value matches the given parameter. All entries have the same keys even though some keys might be missing. The data is provided by another package so I cannot transfer the data into a separate table. I currently do it like this but it looks really bad to me: foreach ($keys as $key) { $query->orWhere("{$field}->{$key}"

MarvinX4yrs ago Eloquent

Last reply by MarvinX 4yrs ago

How to optimize this query in laravel

Thanks in advance. I want to optimize below query because when it applies for thousands of data then thousands for models also precessed by using below query. Can anyone suggest solution for below query. @foreach($invoice as $inv) @foreach(App\Models\invoicedescription::where('invoice_id',$inv->id)->get() as $invdes ) { $dat += $invdes->qty*$invdes->rate; }

jlrdw4yrs ago Laravel