Eloquent query not giving correct result

I have this query: $companyId = Auth::user()->company_id; $userId = Auth::user()->id; $employeeId = Auth::user()->employee_id; $employeeCode = Auth::user()->employee_code; $identities = DB::table('appraisal_identity')->select('id')->where('com

noblemfd's avatar
noblemfd's avatar noblemfdLaravel
6

Query to find x days from date with X in column

I am not sure if this is even possible but I have a table like this below. Estimates: created_at updated_at service_date-> Date Service was completed nextServiceDays -> total days before next service email is sent. nextServiceEmail -> Date Email sent status I am trying to write a query that returns all estimates with a status of 4 and nextServiceEmail is null that is g

joshblevins's avatar
joshblevins's avatar joshblevin...Eloquent
2

Query with where + where or + where in not working

I am having some trouble getting this to respond correctly: $teams = Team::where('options->stage', 'Subscribed')->get()->pluck('id')->toArray(); $str = implode(", ", $teams); $documents = Document::where('stage', '!=', 10)->orWhere('error', '!=', '')->whereIn('team_id', [$str])->get(); The query output is this: select * from `documents` where

Utchin's avatar
Utchin's avatar tykusEloquent
7

Laravel8 - Eloquent query builder: how add a raw query?

Hi to all, I cannot write a Query Builder with a raw query inside. I need to use the Query Builder 'cause I'm paginating and sorting the results via scoped query. Is it possible to inject that raw query that at the moment is commented out? Taken alone, it works and return right recordset ;) return $this //->select(DB::raw("SELECT * FROM users WHERE id IN (SE

robdevel's avatar
robdevel's avatar a4ashrafEloquent
3

Frontend query string for Spatie query builder

How to make on frontend query string for Spatie query builder? @foreach(\App\Product::get()->pluck("name") as $value => $name) <a href="{{ route('products.index', ['filter[name]'=>$name ]) }}" >{{$name}}</a> @endforeach Result is this: http://test.test/products?filter%5Bname%5D=armani wanted : http://test.test/products?filter[name]=a

Ajvanho's avatar
Ajvanho's avatar IvanRadoje...Laravel
4

Include events with “touching” start/end times in query

I am running a Laravel 6 app using MongoDB through Jenssegers MongoDB plugin. So far I have not had to write a raw mongo query and I hope I won't have to for this one too, I mean, I have no idea how to achieve what I want through Eloquent even with SQL, so not sure if possible. I have three models: User - standard user details Availability - Event type model with start_date, en

fidanym's avatar
fidanym's avatar fidanymEloquent
2

query on created_at with carbon

I have this query Community::where('created_at', Carbon::now()->subDays(3)->toDateString()) and in db i have this raw "created_at" : ISODate("2020-10-14T16:26:20.762Z") but each time i made query data return empty

Hala's avatar
Hala's avatar SnapeyEloquent
8

Query Eloquent sum and groupBy

hello, I have this SQL query that I would like to pass in Eloquent but I can't, can you help me? SELECT SUM(number) as sum, types_id FROM coches where membres_id = 40 group by types_id;

cherson's avatar
cherson's avatar chersonRequests
5

What is the way of adding executable eloquent query scope

In Laravel Eloquent, we can do something like: User::active()->where('reference', $request->ref)->first() Here active() is a scope and we can add scope for ref too: User::active()->reference($request->ref)->first() Here, reference is a scope defined that return builder. But in my use case I want to execute on the scope call instead of calling first(); Like: Us

al_imran_ahmed's avatar
al_imran_ahmed's avatar al_imran_a...Eloquent
4

Query in nova relation

i have post resource and comment when i show up post detail page i want to list comments order_by field not by id , how could i add that when i added the query into relation it works but i want to effect only on nova not all project

Hala's avatar
Hala's avatar bugsyshaNova
3

Column not found but it's not in query....

I'm getting this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accounts_id' in 'NEW' (SQL: update users_act set stopped = 1, users_act.updated_at = 2020-10-15 14:06:48 where id = 3184); THE PROBLEM: Column 'accounts_id' is not in query and the updated_at value is not quoted This happens when I try to save an ORM. Trace: #0 C:\localhost\vendor\doctrine\dbal\lib\

ramonnogueira's avatar
ramonnogueira's avatar ramonnogue...Lumen
6

Trying to group my query into alphabetic chunks

Any help would be awesome. my query so far but not sure how to connect each set of letters. $partners = Directory::where('name', 'like', 'A%')->orderBy('name', 'asc')->get(); returns all with start letter A just fine but i want to group them into [A,B,C,D] and keeps them in that order. I can do a query for each one but not practical so i want to output them as grouped

madsynn's avatar
madsynn's avatar madsynnEloquent
28

How to add if statement to query builder

I have this query build I used to generate leave balance: $leaveBalance = DB::table('hr_leave_types AS lt') ->leftJoin('hr_leave_type_details AS ltd', function($join) use ($userCompany) { $join->on('ltd.leave_type_id', '=', 'lt.id') ->where('ltd.company_id', '=', $userCompany);

noblemfd's avatar
noblemfd's avatar noblemfdLaravel
4

executing this kind of query possible?

I am trying to make this kind of query, but I am lost on how to do this in laravel. i know about the DB facade, but not how to structure this in there. any casts or posts that show it - please point me in their direction!!! basically there are two pivot tables, the similar key therein is a stream id. once this runs, I will filter the array but I need to get it to run before

AlexSteele's avatar
AlexSteele's avatar AlexSteeleCode Review
4

Can't get DB::raw query to work within the select method of another query

Background I have a project that manages the finances of certain clients, in the app, I have a Loan, Account, and LoanStatus models in relationship such that Account hasMany loans and a LoanStatus belongsTo a Loan Account Schema Schema::create('accounts', function (Blueprint $table) { $table->bigIncrements('id'); $table->unsignedBigInteger('user_i

seewhy's avatar
seewhy's avatar seewhyEloquent
4

Query Strings aand Parameters - Blowing my mind!

Hi community, Running into a brick wall here with Query String/Parameter building, I have a feeling it shouldn't be this complicated but wanted to get best practice advice. I am currently building a community platform that allows/requires users to tag their content. The content is tagged via two query string parameters. Please note all relationships, tagging logic for posts inc

Adam_Commit's avatar
Adam_Commit's avatar automicaGeneral
8

Convert RAW query to Laravel Eloquent

Hi guys, i'm new to laravel and would need some help in converting the following raw query to laravel eloquent. SELECT "id","available_rooms","hotel_id" FROM "public"."room_types" a WHERE is_enabled IS TRUE AND available_rooms > ( SELECT

rollcasual's avatar
rollcasual's avatar jlrdwEloquent
1

Is there anyway to perform update / increment values of multiple rows with different values in laravel in a single query

Let's say i have a collection of user model, $users = [ [ 'id' => 1, 'email' => '[email protected]', 'total_reward_received' => 1000 ], [ 'id' => 2, 'email' => '[email protected]', 'total_reward_received' => 1500 ] [ 'id' => 3, 'email' => '[email protected]', 'total_reward_receiv

rahul95's avatar
rahul95's avatar rahul95Laravel
6

No query results for model Livewire

I have this code which is working but i have to set default value for $region_id and $distrcit_id which is nt what i want. my intention is anyone can search project by one or more of these fields if you know better way please help thanks. and this is using livewire with laravel public $state_id; public $type_id; public $region_id=1; public $district_id=1; i would like

fadahye's avatar
fadahye's avatar fadahyeLivewire
3

eloquent query scopes question

I was wondering what difference does it make to return the query, i've been working with scopes for a some time and yet to find a difference. public function scopePublished($query) { return $query->where('published', true); } vs public function scopePublished($query) { $query->where('published', true); } both seems to work quite the same even with chaining multiple sc

michaelhany's avatar
michaelhany's avatar jlrdwEloquent
1

My query returning unexpected result

I’m using this eloquent query in a table in my database with an array of values, Sumalr::where(‘type’, 1) ->where(function ($q) use ($query) { $q->whereIn('nwlo', $query); $q->orWhereIn('walo', $query); }) ->whereNull('wedr_id') ->orderBy('id', 'asc') ->get(); query variable is an array of 2 values ['WEE', 'EGGT'] in my Sumalr table I have 1 row tha

Austinbryan's avatar
Austinbryan's avatar Austinbrya...Laravel
2

Optional search parameter breaks query

I have the following query with some optional parameters that works fine: $query = ObrazacProcjeneVrste::where('znanstveno_ime', 'LIKE', "%{$znanstvenoIme}%"); if($skupina != 0) { $query = $query->whereHas('skupine', function($q) use($skupina) { $q->where('skupina_id', $skupina); }); } if($datumDo !

mleontenko's avatar
mleontenko's avatar MichalOrav...General
15

Query 2 rows conditions in one result

Hello Everyone! I need help to make a query to get the ids where the values for a specific month are between the start and end dates. The table format is (I can't change, this is not mine): id | attribute_id | value 1 | 24 | '2016-03-01' 1 | 25 | '2020-03-01' ... 24 = start 25 = end I try this: Model::select('id') ->whereIn('id', $Ids) // Condition A (Sinc

RafaelGrube's avatar
RafaelGrube's avatar automicaEloquent
3

Get data by belongsToMany relation in 'where' query

I am literally confused about how to proceed with the query. I have two models: Product Tag Product - Tag are related by many-to-many relationship. So: // Product.php public function tags() { return $this->belongsToMany(Tag::class); } // in Tag.php public function products() { return $this->belongsToMany(Product::class); }

dgvai's avatar
dgvai's avatar shami003Laravel
15

How to query by Eloquent ORM value?

Let's make it quick, I have two models: User UserBalance with a one-to-one relationship. I can perform such relationship actions like: UserBalance::find(1)->user->name; // returns name Now I want to perform a query, but now I am confused! What I want to do: UserBalance::with(['user'])->where( ... ) // here I am confused /** * What I wanna do: where()->u

dgvai's avatar
dgvai's avatar MichalOrav...Laravel
2

Doesn't exist query

Hello, I have a problem with a query. in posts table, i have posts.id, then, in reviews table, i have posts_id(foreign key -> posts.id), reviews.id. i want to query those posts_id which doesn't exist in reviews table(post_id). i am trying like -> $r = DB::table('reviews') ->select(DB::raw('count(id) as rev_count, posts_id')) ->groupBy('posts_

dipcb05's avatar
dipcb05's avatar dipcb05General
2

Eloquent query not returning the expected result

I'm trying to use this eloquent query to query a table in my database with an array of values, FlightRequest::where('public', 1) ->where(function ($q) use ($query) { $q->whereIn('departure', $query); $q->orWhereIn('arrival', $query); }) ->whereNull('acceptee_id') ->orderBy('id', 'asc') ->get(); My query variable is an array of 2 values ['EGLL', 'EGKK'

hcphoon01's avatar
hcphoon01's avatar automicaEloquent
1

Query data from through pivot table based on slug

Hi Everyone, I have a route setup that uses /books/category/{slug} to get books based off a slug but I'm having an issue getting the data to return quickly. Tables /** * Books */ UUID Name ISBN .... /** * Categories */ UUID Name Slug ... /** * Book_Category */ UUID Book_id (foreign) Category_id (foreign) ... I'm using the following in my controller to get the data

twg_'s avatar
twg_'s avatar alanholmesEloquent
2

Raw SQL query to array

I'm using a raw SQL query that selects some ids from database. It looks like this: $query = DB::select('SELECT pr.id_obrasca_prethodne FROM public."prethodneNacionalneProcjene" AS pr JOIN public."obrasciProcjeneVrste" AS ob ON pr.id_obrasca = ob.id WHERE ob.status LIKE \'Prihvaćen\''); If I output the $query variable now, I get: [{"id

mleontenko's avatar
mleontenko's avatar mleontenkoGeneral
5

How to hide all results of algolia instantVue js search if query empty ?

How to hide all results of algolia instantVue js search if query empty when page start loading ..

mahmoudtrageh's avatar
mahmoudtrageh's avatar mahmoudtra...Laravel
0

query order text

I have a $ table-> text ('status') field that can take cat, dog, rabbit, t-rex (it's just these 4) I would like to query that orders for rabbit, dog, t-rex, cat?

Antonella's avatar
Antonella's avatar gianmarxLaravel
5

How to build query for google bar chart in laravel?

My Database looks like this id | country_name | population | created_at 1 | USA | 2000000000 | 2020-02-04 2 | China | 2200000000 | 2020-02-04 3 | Russia | 12000000 | 2020-04-02 My Query look like this. I am just trying to build query but not getting result.Maybe there are some mistake. public function barChart(){ $countries=Country::get

saurav77's avatar
saurav77's avatar saurav77Eloquent
3

"message": "No query results for model [App\\Venue] stats",

When I run my URL using GET: moveme.test/venues/1152522/tagin/stats in postman, I get the following message: "message": "No query results for model [App\Venue] stats", Here is my method, nothing gets output to the screen public function venueTaginstats($id) { $tagins = Tagin::findOrFail($id); dd($tagins); // return view('venues.tagins

boyjarv's avatar
boyjarv's avatar SinnbeckLaravel
12

Why first() is not using LIMIT in it's query?

Why method first() is not using LIMIT in it's query while it always returns one result?

timurlan156's avatar
timurlan156's avatar timurlan15...Laravel
5

Help using orderBy on nested relationship query

I have a Livewire component that generates an HTML table where you can click a table header and sort the data. It also has a text input that you can type in to filter the results by name. I'm having issues getting the "sorting" part of it to work. Relevant Users model with two Application model relations: Get all applications for the user public function applicati

schwartzmj's avatar
schwartzmj's avatar bobbybouwm...Code Review
1

How to count product with respect to categories using query builder?

This is my Category Database Table id | category_name | created_at 1 | Mobile |2020/09/20 2 | Laptop |2020/09/20 This is my brand database table id|category_id | brand_name | created_at 1| 1 | Samsung | 2020/09/20 2 | 2 | DELL | 2020/09/20 3 | 2 | Lenova |2020/09/20 4 | 1 | Nok

saurav77's avatar
saurav77's avatar saurav77Eloquent
6

Query won't search for resulsts

Hi, I have the below query which is not working for me. When I search for a string I sometimes get results back. I'm 100% sure by columns exist and the data si there. It seems that only results where the alias matches is working correctly for me. public function index() { $query = request('q'); $itemsQuery = Item::query() if ($query !== null) { $monitorsQ

podu-file-plus's avatar
podu-file-plus's avatar bobbybouwm...General
3

Help building a query or using Eloquent

I'm having some issues creating a query and structuring my data for a view. I have a User model with role family that hasMany Applications The view I'm displaying to the user is a table with the following table headings: Name, Email, and Year 2020 Application Status Originally I was looping over every family and querying the database for every single row of the table in the vie

schwartzmj's avatar
schwartzmj's avatar schwartzmjCode Review
7

Laravel Eloquent - How can I filter a query and re-use it for different variables.

I previously wrote some code but now that I'm looking at it about a year I feel like there has to be a more optimized way of getting the same result. I have a Model for Items, the Items have a 'type' attribute. This is how I am currently getting the Items by type, using Item::where('type','foo')->get(); In total this is running the same query 5 times. $meats = Item::where('t

iamxquisite's avatar
iamxquisite's avatar extjacLaravel
8

How to use multiple filters in Spatie Query Builder

Hello, I have a problem with multiple filters when using Spatie Query Builder. When both filters have $query->with(...) then the last one overrides previous. Any ideas how to merge then or fix it? Allowed filters: $this->allowedFilters([ AllowedFilter::custom('date', new FiltersEventDate), AllowedFilter::custom('theaters', new FiltersMovieTheater),

PaulJasiul's avatar
PaulJasiul's avatar PaulJasiulEloquent
5

How to write product filter query in Laravel

Can someone please guide me on how I can write this below query in laravel by using eloquent ORM and with QUERY Builder as well? The below code is in custom PHP, but I want to use it in laravel. I am trying to develop product filters with ajax request, filters are appearing in the sidebar when someone clicks on any filter then the system will fetch data from a database that is

imranshabbir's avatar
imranshabbir's avatar frankieleeLaravel
1

Is this Eloquent query right?

I found this query in one project I am facing right now but I am not sure what it actually does. It seems like a duplicate or redundant query. $attributes = Attribute::with(['values.variants' => function ($query) use ($product) { $query->where('product_id', $product->id); }])->whereHas('values.variants', function($query) use ($product){ $query-&g

Čamo's avatar
Čamo's avatar ČamoGeneral
5

How to do a query prior to user logging out (but triggered by logout)

I need to do a DB query prior to the user logging out in order to determine what page to send them to upon logout. I thought putting the following in the LoginController would work but by the time this function overrides AuthenticatesUsers@loggedOut() the user session is already terminated so auth()->user() is not available. Is there a risk in putting code in the Authenticat

scottsuhy's avatar
scottsuhy's avatar scottsuhyLaravel
5

How to make query for fetching specific id in eloquent many to many?

I'm trying to access a specific club id and displaying all the members under the same club id. This function is for admin page. Below is the code that I have tried but it fetching all the user including the non members. How can I fix this query? club member club_member id | name | |id | name | | id| id_club | id_member

mimiloca's avatar
mimiloca's avatar mimilocaEloquent
2

Array inside IN () raw Query

I'm working on a project, which has a gigantic raw query with a concatenated query like this: column in(".$filters.")) I need maintain the raw query, but use bind parameters to pass an array. Does anyone how to pass array in this situation?

inovador's avatar
inovador's avatar clickEloquent
1

Positive query result but no database update

I want to update the column tool_order in a pivot table tool_user for certain records (the ones where order has changed). The Laravel dump server and query result tell me that everything is fine and some records were updated but there are no changes in the table. There are no erros on console, dump server or log. My code: public function setOrders(Request $request) {

Loomix's avatar
Loomix's avatar LoomixLaravel
7

How to optimize my SQL query

Hey, I got this query, where I basically need to check how many IDs haven't been assigned for a certain strategy: ->where('strategy', (string) $strategy) ->whereNotNull('assigned_at') ->count(); raw SQL: select count(*) as aggregate from `external_ids` where `strategy` = 'very long string' and `assigned_at` is not null; And the issue is, the q

reinisk22's avatar
reinisk22's avatar newbie360General
9

Eloquent query for morphToMany - problem with generated SQL code

I have problem with Eloquent morphToMany public function categories() { return $this->morphToMany(Category::class, 'categoryable')->withTimestamps(); } # part of query return $this->builder->whereHas('categories', function ($query) use ($val) { $query->whereIn('categories.id', $val); }); this part of query produce MySQL code (deleted not required here p

vertoo's avatar
vertoo's avatar vertooEloquent
1

Pivot table query

So, I have an existing table of emotions that a logged-in user is asked to rate 1,2, or 3 from a form. Many users can have many emotions rated, so I was thinking about an emotion_user pivot table. My query is how to write this? If I were to just write to a normal table called emotion_user using its own controller, would this act as a pivot table or would I have to write a speci

MattB's avatar
MattB's avatar laracoftLaravel
3

laravel query builder

hi I tried to use spatie laravel query builder to create filters(brand,category,size and color) in my project so it works just for brand and not for category so how to change code in productcontroller to make it work thank you and this is an image to explain https://i.imgur.com/qsFluwP.png and how to add code in productcontroller and products.blade.php to filtering size and

nacha's avatar
nacha's avatar nachaLaravel
13