Dynamic value doesn't seem like a valid parameter for a relatable query

Hello ! Here I come again with a strange behavior. I'm trying to use the relatable query Nova feature to restrict the colors (from my Color model) shown in my BelongsTo dropdown, but I struck a huge... bug ? First of all, here's a code snippet pulled from Nova's documentation of what I'm trying to accomplish : public static function relatableTags(NovaRequest $request, $query) {

piljac1's avatar
piljac1's avatar piljac1Nova
3

eloquent query relations

I have a Job table that hasMany JobData i want to query Job::where('is_active', true)->JobData('title', 'LIKE', $query) (this is just pseudo code) this is the code I wrote, but the problem is that it gets also Job items that don't satisfy the condition $jobs = Job::where('is_active', 1) ->whereHas(['data' => function($query) use($keyword) { $query->where

Imadev's avatar
Imadev's avatar ImadevLaravel
7

How to write search query with multiple conditions but where records under the same user

I have a database with inventory products. Also, I have many users where products belonged to different users. So I need to write a query with multiple conditions, where search needs to be in different table columns, so it will be a couple of ->orWhere() statements. But the search needs to find all the products that belonged to the same user. But if I have many ->orWhere(

bobby_by's avatar
bobby_by's avatar dostogirEloquent
3

Where query using and md5 value - lavavel 5.3

I'm trying to query the database to get the record that matches the unique id for a user. User::whereRaw(('md5(unique_id)'), $mdid)->first(); This returns the first id in the database, not the intended user User::whereRaw(('md5(unique_id)'), $mdid)->get(); This returns every user in the database Any suggestions, thank you!

justl00king's avatar
justl00king's avatar JayteeLaravel
13

Eloquent query | Search in multiple tables

Hello guys, I have question about multiple search query I have in my Controller function: public function search(Request $request) { $search = $request->get('search'); $results = DB::table('pages')->where('description', 'like', '%'.$search.'%')->where('visible',1)->paginate(6); return view('pages.search', ['results' => $results]);

ziben69's avatar
ziben69's avatar goldtasteEloquent
2

Eloquent or Query Builder Select all from multiple tables

I want to form a query where I can select from multiple tables with aliases; Likes so; select all from 'configurations' as 'configs', 'shoes as shoes', 'categories as cats'. Can anyone help me achieve this? Thank you.

nanadjei2's avatar
nanadjei2's avatar tykusEloquent
12

Media Query for component config settings

Is there a way to change the config settings of a component in a media query? I want to change my calendar from being inlined to an input field on mobile devices. So in this following code block, i'de want the inline field to be set to false in my media query. I'm using this as my date picker: https://flatpickr.js.org/options/ DatePicker Component <template> <div>

lara121081's avatar
lara121081's avatar lara121081Vue
0

laravel query

This is the laravel query. $tempUserData = TempCustomerBookTrip::select('temp_ggt_user_book_trip.order_date','temp_ggt_user_book_trip.order_time','temp_ggt_user_book_trip.intermediate_address','temp_ggt_user_book_trip.id','temp_ggt_user_book_trip.user_id','temp_ggt_user_book_trip.user_search_id','temp_ggt_user_book_trip.start_address_line_1','temp_ggt_user_book_trip.start_addre

lav's avatar
lav's avatar lavLaravel
6

how to query database for each day in an array of days laravel

i have an array of days that i want to query my model for each date that i have in that array , that could be possible with a for loop and index but as thumbs rules i dont want to query inside a loop so is there any other possibility to check the date in my model so my tried with for loop is like below : $period = CarbonPeriod::create($from_date, $to_date); $dates

farshadf's avatar
farshadf's avatar Tray2Laravel
2

Query with whereHas

Hi, I need a query where I can insert the table-name in a flexible way and query should return all products that are connected with exporter (many to many). I was wondering why this is not working $products = DB::table('products')->whereHas('exporters', function (Builder $query) use($exporterId) { $query->where('exporter_id', '=', 1); })->ge

stefan7's avatar
stefan7's avatar stefan7Laravel
2

Query returning unexpected results

In my application I have a Spotlight model. I run this query: Spotlight::newerThan(1)->published()->inRandomOrder()->take(2)->get(); Here are the query scopes. /** * Scope an article by whether or not it's published * */ public function scopePublished($query) { return $query->where('status', 'published'); } /** * Only retrieve Spotlights newer than

jesse_orange_newable's avatar
jesse_orange_newable's avatar SinnbeckEloquent
6

Help with sql query postgres!!

I am making a form that should tell me the people who did not go to work in a given date range ... Ejm from 2019-09-01 to 2019-09-30, the question I ask is how can I make a query to see who does not they went to work in that range since I have several ideas but I do not function ... If I use the function between everything, it gives me true since when getting that person was at

jpmg's avatar
jpmg's avatar jpmgGeneral
3

add custom field to query

Hello, I want to create a simple API and for categories I want to return a json with custom data: ex: $categories = $categories->select('CategoryID', 'MenuOrder', 'IsActive', 'Name', 'Slug' )->where($filterCondition)->orderBy($orderBy, $orderType)->paginate($paginate)->appends($queries); I need 1 more field "Url" - which is not in the DB - I have to ge

calin.ionut's avatar
calin.ionut's avatar johnbaronEloquent
1

SQL To Query Builder

Help Me To Convert SQL To Query Builder SELECT r.id FROM requisitions r JOIN users u JOIN user_can_approve uca ON u.id = uca.user_id AND r.type = uca.requisition_type AND r.level = uca.requisition_level WHERE uca.user_id=$currentUsersID

ibrahimks's avatar
ibrahimks's avatar henriquesa...Laravel
8

laravel query run twice

i am using laravel spatie package for query builder and when i run my query it shows in telescop that it runs twice the only difference between them is this line : select count(*) as aggregate from `accommodations` where . . .rest of my query and the other one is like this : select * from `accommodations` where . . . limit 10 offset 0 any idea what is wrong here bec

farshadf's avatar
farshadf's avatar farshadfLaravel
8

Error in with method in a query to a model

Hello everyone, I am getting this error after doing this query, I migrated from Laravel 5.6 to 5.7 and this query started to fail query $asesores = Asesor::with(['usuario' => function ($q) { $q->orderBy('NombreCompleto') ->select('NombreCompleto AS id','NombreCompleto AS text', 'Id'); }]) ->get() ->pluck('usuario')

chechogrom's avatar
chechogrom's avatar chechogromEloquent
5

how to chunk a join query in laravel

Somewhere in my Laravel application, the following query is likely to return a very large results set: $data = $query->join('accommodation_rooms', 'accommodations.id', '=', 'accommodation_rooms.accommodation_id') ->join('discounts', 'accommodation_rooms.id', '=', 'discounts.accommodation_room_id') ->select('accommodation_rooms.id') ->orderBy('discounts.a

farshadf's avatar
farshadf's avatar jlrdwLaravel
10

No query results for model App/Models/Country delete_all

I am working on project useing laravel and vuejs the problem is that I am trying to select multi rows and delete them the error is No query results for model [App\Models\Country] delete_all my route link Route::delete('/delete_all','CountriesController@deleteAll'); delete function in the country controller public function deleteAll(Request $request){ $ids = $request->ids; DB

monaabdo88's avatar
monaabdo88's avatar monaabdo88Laravel
3

How to Query using properties from a Resource

Hey guys! Noob question here. Would just like to know if it is possible to use the query builder to search for a certain property from its own Resource. For Example: Blood Component (Resource) return [ 'id' => $this->id, 'component' => $this->component, 'amount' => $this->amount, 'status' => $this->status,

ignisrzeus's avatar
ignisrzeus's avatar SinnbeckLaravel
1

scout + elastic search query always return null

i have indexed my data and can see them by the link below : http://localhost:9200/accommodation_write/_search?pretty=true&q=*:* when i hit the above link i can see all my data active and indexed on my elastic search but when i try to search them like below : public function search(Request $request){ $orders = Accommodation::search('*') ->where('id

farshadf's avatar
farshadf's avatar hondnlLaravel
3

Passing value '0' is aborting DB query

Hi, I am facing a strange issue. In blade, I have a form carrying a variable 'gender', which has values 0 for female and 1 for male. When I select MALE and trigger the search, it works fine. But when I select FEMALE and trigger the search, the controller does not include the gender-related part in the search query. I tried a lot of troubleshooting, but unable to figure out the

saadaan's avatar
saadaan's avatar SnapeyLaravel
4

Running WHEN condition for query

Hi, I am trying to run a WHEN condition in some code in blade. It works fine in blade when the variable is coming via REQUEST object. However, it's not working in blade when I try to replace the request variable with a custom variable. The documentation says if the first condition is true, it should work. However, it's not working, and the query is being executed without the WH

saadaan's avatar
saadaan's avatar saadaanLaravel
3

Laravel DB query turning array instead of object

I have this query in laravel am trying to use but it's returning an array is there a method to have it an object instead? $x = DB::table('user_profiles') ->where('id',$holidays[0] ->profile_id) ->select('first_name')->get();

bassemshoukry's avatar
bassemshoukry's avatar ketansaval...Laravel
5

How to remove a query string from an url?

I have the following url: request()->fullUrlWithQuery(['status'=>'published', 'category'=>'sport']) // '/users/1/articles?status=published&category=sport' and would like to remove 'category' to get: request()->fullUrlWithQuery(['status'=>'published']) // /'users/1/articles?status=published' Whatever solution I try, the fullUrlWithQuery() appears to remember

minjon's avatar
minjon's avatar JLevyRequests
8

Better solution for SQL query

I have these two queries $na = DB::select('select n.*,u.name from nalog2019s n,users u where n.user_id=u.id order by n.id desc'); $voo = DB::select('select * from vrsta_otvora2019s'); and in view in table @foreach($voo as $vo) @if($na->id == $vo->nalog_id) <li>{{ $vo->naziv }} : <strong>{{$vo->kolicina}}</strong></li>

adnan483's avatar
adnan483's avatar adnan483General
4

one query to get list of data and total count and total sum?

hello I have following table: products id name price sold_count how can I paginate through products and to get list of data along with total sold_count of all products and also total number of products, all in one query? Product::withSum('sold_count')->withCount()->paginate(); thank you in advance

danimohamadnejad's avatar
danimohamadnejad's avatar SinnbeckEloquent
1

Advance Query Builder Where clause with given parameter

Hi All, I am having the problem on how to create an equivalent Laravel Query with the intention of having the data generated by below: SELECT EmpID, CASE WHEN LastVacDate IS NULL THEN DATEADD(dd, tblRotation.DayOn, tblEmployee.StartDate) ELSE DATEADD(dd, tblRotation.DayOn, tblEmployee.LastVacDate) END AS ForeseenVacation FROM tblEmployee INNER JOIN tblRotation ON tblEmploye

aisalen's avatar
aisalen's avatar aisalenLaravel
2

get url query string value with javascript

Hi everybody, I have a laravel-vue app where after a vue component is mounted I want to chek if the url has the a given query string parameter and its value, for example given this url: /?show-login-form=1 On compoennt mounted I want to check if url is login-form == true, how would you approach this situation?

Gabotronix's avatar
Gabotronix's avatar SinnbeckGeneral
1

Using relationship column in a query

I have my category list coming from this relationship public $belongsToMany = [ 'catbuy' => [ 'Corymillz\Adverts\Models\Cat', 'table' => 'corymillz_adverts_buyrequest_cat', 'order' => 'cat_title', 'key' => 'buy_id', 'otherKey' => 'cat_id' ] ]; I created a simple filter using ajax to filter by up to

KingsleyO's avatar
KingsleyO's avatar KingsleyOLaravel
8

Query eloquent belongsTo and hasMany (laravel-datatables)

Well, I'm having trouble showing data about my relationship with datatables. The information I want to visualize is related in the following way: I have the table customers, orders and details: a customer can have 1 to N orders. An order belongs to a customer. An order can have 1 to N details. A detail belongs to an order. Here my relationships in the requested model: class Or

rjruiz's avatar
rjruiz's avatar SnapeyLaravel
7

Rewrite SQL query

Hello. I'm trying to update some old code we have. I need to rewrite the following query: SELECT DISTINCT tblclients.id,tblclients.firstname,tblclients.lastname FROM tblclients, tblhosting WHERE tblclients.status="Active" AND tblclients.id=userid AND tblhosting.domainstatus="Active" AND tblhosting.server=1 I'm a newb at MySQL, so this is a difficult problem

DennisHermannsen's avatar
DennisHermannsen's avatar jlrdwEloquent
4

Query filter by relation

I am creating an application where a building has facilities and I want to make a query to get a building where its facility can be, for example; ["stand-by-generator", "wifi", "swimming-pool"]. The code below returns buildings where facilities are one of these ["stand-by-generator", "wifi", "swimming-pool"] instead of

nanadjei2's avatar
nanadjei2's avatar SinnbeckEloquent
3

Query scopes or new model for self-reference?

I have a User that has a trainer_id, that is the id of another user. I'd like to be able to get all the Trainers. Does one normally create a Trainer model that uses the users table and make some query methods (all, etc) that return the correct data? Or do I make some query scopes or something on the User model (isTrainer, or whatever)? Thanks in advance for your help.

edalzell's avatar
edalzell's avatar clickEloquent
1

Query gets extremely slow

private function getArticles() { $query = Article::orderBy($this->sort, $this->sortOrder); if ($this->searchTerm != '') { $query->where('blog_url', 'LIKE', '%' . $this->searchTerm . '%'); } // $query->whereHas('categories', function($query) { // $query->whereIn('category_id', [8]); // }

dylanryan's avatar
dylanryan's avatar Tray2Eloquent
10

Laravel | Pagination - relationship table query

Hello guys, how can I use pagination, where my eloquent query looks: PageController - method show: $page = Page::where('slug', $slug)->with(['subpages'=>function($q) { $q->where('visible', 1)->orderBy('order', 'asc')->paginate(9); }])->first(); I would like to paginate subpages on page's View blade (Page one to many Subpage relationship) Here

ziben69's avatar
ziben69's avatar selvavigne...Laravel
1

Shorter version of this query

$query->whereNotIn('id', Animal::where([category' => 'animal', 'type' => 'dog']) ->orWhere(['category' => 'animal', 'type'=>'bear'])->pluck('animal_id')->all() )->orWhereIn('id', Animal::where( ['category' => 'animal', 'type' => 'cat'] )->pluck('animal_id')->all()) ->get(); Say i have House and Animal model and having

untymage's avatar
untymage's avatar SnapeyLaravel
9

Why my caching is slower that regular sql query? (file driver)

fetching 150 thread, Regular sql query : with file driver caching : Why cached version is slower than normal query ? Souldnt it faster than normal query ?

untymage's avatar
untymage's avatar untymageLaravel
3

total count and recent data in one query?

Hello. how can I get recent models and also total number of rows using same query? is that possible? thank you in advance

danimohamadnejad's avatar
danimohamadnejad's avatar jlrdwEloquent
5

should I query to database for all different data on same request?

hello. I want to show types of data in statistics page of website. for instance I want to show a list of latest orders, summary or all orders including total sales, groups sales based on monthes, new users, best selling products and maybe event some other sort of information. my quistion is that is it okay to query them all in my controller method and sent them to view? becaus

danimohamadnejad's avatar
danimohamadnejad's avatar danimohama...General
4

Simplify query

Is there any way i can simplify this query, Avoiding query in a loop and get all the data in single query! foreach ($Subjects as $sub) { foreach ($ExamSubHeads as $esh) { $IsExist = DB::table('tbl_marks_distributions') ->select('marks_distribution_id', 'full_marks', 'allowed_input_date_time_from', 'allowed_input_date_time_to', 'is_

rassem's avatar
rassem's avatar rassemLaravel
2

Improve ->whereHas() query performance

I have a scope for querying the models that have a relationship with the passed category id. This scope returns all the models that have that category or subcategory relation. public function scopeCategory($query, $category) { return $query->whereHas('categories', function ($q) use ($category) { $q->where('categories.id', $category)

bufferoverflow's avatar
bufferoverflow's avatar bufferover...Eloquent
5

how to update all rows using one query?

Hello. please consider following data: $data=[ ['id'=>'1','stock'=>'12'], ['id'=>'2','stock'=>'13'] ]; how can I update all stocks using IDs using one query?

danimohamadnejad's avatar
danimohamadnejad's avatar SinnbeckLaravel
5

Simple SQL query vs Eloquent

To me, sometimes it is easier to write a simple sql query versus creating an eloquent call for the same result. For example if I need to return just a company name and id form Company table, but the results will filtered where the condition is met ~3 joints deep. Are there certain benefits using eloquent, is it safer, faster or because of some other benefits..? I think eloquent

GuntarV's avatar
GuntarV's avatar jlrdwEloquent
7

Vue-router query params

hello, I have a route defined so: { path: '/newModule/:id', component: () => import(/* webpackChunkName: "newModule" */ './NewModule/NewModuleId.vue').then((m: any) => m.default), }, Say I wanted to add "?user=john to the url? The docs say: this.$router.push({ path: '/newModule/:id', query: { user: 'john' }}) The result I get is http://l

ludo1960's avatar
ludo1960's avatar ludo1960Vue
0

Where condition on aggregated query doesnt work, but orderBy works...

I have the following query where i'm sorting products by price (asc and desc) and i also want to filter them between a price range but also taking into account if there's any discount for them. The sorting part works, but when i throw in the price range condition it blows up. Any thoughts? $q ->selectRaw( 'products.*, CASE WHEN pd.price IS NULL THEN p

geowrgetudor's avatar
geowrgetudor's avatar geowrgeEloquent
2

Query by lastest relationship value

Hi all! I need help! I cant solve this issue, looks simple but I have failed in all my attempts... I'm trying to create a query scope that can filter Post models by latest relationship value. Post model hasMany() Statuses, each status has a date. Simple. So, a Post can has multiple Status childs, where the only one that Im interested is the last one, specifically its date. So m

Zalo's avatar
Zalo's avatar ZaloEloquent
2

Query builder missing value quotes

When i run the following code I get an sql error \DB::connection('utskrift')->table('utskrift')->insert( ['varenummer' => 123, 'navn' => 'test navn', 'leverandor' => 22, 'leverandor_varenummer' => 'test 123', 'antall' => 1, 'printer' => 'printer 1'] ); After inspecting the error the returned query is insert into [utskrift] ([varenummer], [

23andreas's avatar
23andreas's avatar jlrdwCode Review
1

how to make laravel local scope just query the current model and relation not all of it

i am using spatie query builder and i am using the scopes query now this is my local scope i added : public function scopeFilterPrice(Builder $query,$start_price) : Builder { $data = $query->whereHas('accommodationRoomsLimited.roomPricingHistorySearch', function(Builder $query) use ($start_price){ $query->where('sales_price','<',$start_price);

farshadf's avatar
farshadf's avatar farshadfLaravel
0

how to limit the number of data in where has query laravel

I have a query like so $data = City::with('hotel')->orwherehas('hotel', function ($query) use ($user_input) { //here i want to limit this result to 5 $query->where('name', 'LIKE', '%' . $user_input . '%')->take(5); // $query->take(5); i have tried this too })->orWhere('name', 'LIKE', '%' . $user_input . '%')->get(); inside the wher

farshadf's avatar
farshadf's avatar farshadfLaravel
2

Eloquent Query to get Counts at every level of nesting in a Polymorphic one-to-many relationship

Quick Side Note: I have more than open question I am trying to solve based on this same code. Also see this. I have the following schema and code in my Laravel application for one-to-many polymorphic relations Users create Posts Post HasMany Comments Post HasMany Reactions Here, Comment is polymorphic on Post or Comment (commentable_id and commentable_type tell you if the co

connecteev's avatar
connecteev's avatar mansoorkha...Eloquent
2