Laravel query builder cache

Hi Great people, I have a serious problem which cannot find a solution for. Is there any way (package) for Laravel 6.x that allows caching queries from the query builder like DB::table('users')->cache(time, 'id_xxx')->get()

hameti's avatar
hameti's avatar hametiLaravel
8

Problem not showing Pagination if you query data based on status in nested component

I have set of data in same table that displayed on blade in different component based on status 0 or 1 but listing of this data for each component is missing how to query pagination in this case ?

MazenUit's avatar
MazenUit's avatar SinnbeckLaravel
1

how to get all query string and implement in eloquent?

i will fetch users by multiple queryString. Think that's exactly what I want. localhost:8000/consultation/gynecologist-infertility?cb_hasFastPhoneCall=true&cb_hasPhoneCall=true&cb_hasVideoCall=true&cb_hasChat=true&justFemaleR=true&justMaleR=true Assuming all this data is in the users table, how can I do this? My question is as follows: 1- How to get all que

johnDoe220's avatar
johnDoe220's avatar vincent150...Laravel
5

Laravel / Mongodb - How to build query where count array of objects equal to total numher of competitor

I have this array (matching_competitors) of objects in the mongodb server: "matching_competitors": [ { "id_competitor": "21", "domain": "", "id_product_competitor": 224731, "url_product_competior": "https://www.librarie.net/p/224731/nia=1693" }, { "id_c

Shibbir's avatar
Shibbir's avatar NiushLaravel
10

query relationships

Hi everyone, I have three tables named: transaction, transactionLog, provience. how can I reach the count of every proviences from transaction table just with eloquent model not with join with one query? my relationships: transaction: -id, -amount transaction_log: -provience_id, -transaction_id provience: -id, -name TransactionLog model public function transaction () { re

sahar_mkr's avatar
sahar_mkr's avatar vincent150...Eloquent
7

Using Form data to build a query in my Controller

Hi, I have a form that collects data from three SELECT inputs, two of which can have multiple options selected. I can get the data in my Controller using Request, $request and data is like this: array:4 [▼ // app/Http/Controllers/FieldProv.php:71 "_token" => "DK7cJuB6iJWTOh5OLqYR5jjxc8wE7X87HJCXxIGG" "site" => "5MT10647" &quo

stanhook's avatar
stanhook's avatar stanhookLaravel
3

Slow query execution time

Alright, i've been searching everywhere for a solution to this, but nothing i seems to improve my situation. I have a simple mysql query like this: $this->session = Session::query()->select([ 'key', 'data', 'last_accessed' ])->where('key', $this->sessionKey)->first(); The table contains about 16 rows There is an index for the "key" column (its the

coalaura's avatar
coalaura's avatar coalauraEloquent
17

Laravel query ->select && ->with

Hello, devs, I usually use ->select method on query with ->with method in order to get only some properties from the model with relation only some properties. But it doesn't work anymore for me. Using Laravel 9.51 Here is my query: Page::query() ->orderBy('updated_at') ->select('title', 'state', 'created_at', 'updated_at') ->ge

hamzaelmaghari's avatar
hamzaelmaghari's avatar SnapeyEloquent
22

How can i get best sellers query in laravel

I have Books table and Orders table order table have book_id, payment_id i want to get best seller in books How can i do query with best performance ? It should give me array of books sorted with best seller Book Model public function orders(){ return $this->hasMany(Order::class); } Order Model public function books(){ return $this->belongsTo

amer22's avatar
amer22's avatar Tray2Laravel
7

How to get list of ids from pagination query of the current page?

Hello, I have 1 pagination query for every: $pagination_query = Table1::...->paginate(100); then I have a second query that needs to use the list of ids from the pagination query: $second_query = Table2::whereIn('id', $list_of_ids_from_pagination_query); How can I get the list of ids only from the paginated page so that I get 100 ids and not thousands of ids which will end

Ligonsker's avatar
Ligonsker's avatar SinnbeckCode Review
3

whereHas filter query issue

hello guys i want result like i have many products and in products have many supplier and one customer so when i search product description than display all product but i want output like product display but match with customer id here is my code $pi = Product::where('customer_id',$customerId) ->whereHas('supplier', function (Builder $query) use($search) {

vandan's avatar
vandan's avatar vandanLaravel
22

How should i change this query?

I have this query SELECT item.name as Produk, outgoing.date as Tanggal, sum(outgoing_item.quantity) as Jumlah FROM outgoing, outgoing_item, outgoing_type, item WHERE item.id = outgoing_item.item_id AND outgoing_item.outgoing_id = outgoing.id AND outgoing_type.id = outgoing.outgoing_type_id AND outgoing_type_id = 1 GROUP BY item.name, MONTH(outgoing.date) ORDER BY item.name, out

Karrura's avatar
Karrura's avatar lbecketLaravel
11

Eloquent question: Is there a way to perform count query for column with the same id?

I'm trying to find a way to execute this query: SELECT carId, COUNT(1) FROM event_dataGROUP BYcarId ORDER BY COUNT(1) DESC but with Models, i didn't find anything in docs so i came here

szalikdev's avatar
szalikdev's avatar SinnbeckEloquent
4

"No query results for model on trying to remove menu

When I try to remove a menu in our application I get { "message": "No query results for model [App\Models\Editor\Project].", "exception": "Symfony\Component\HttpKernel\Exception\NotFoundHttpException", "file": "/Users/user/code/domain.com/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php&

rhand's avatar
rhand's avatar rhandLaravel
4

Query scope "Call to undefined method"

I am trying to build a query scope, but I can't get it to work. I get the following exception "Call to undefined method". The strange thing is the same query directly used on event works. Maybe someone can help me out. $event->eventParticipantUser($participant) public function scopeEventParticipantUser($query, EventParticipant $participant) { retur

lara28580's avatar
lara28580's avatar NakovLaravel
1

Accessing Spatie Permissions Functions Inside GraphQl Query Always Returns NULL Values.

I'm trying to access User's Roles By Using GraphQl query ( With Rebing ) . with the getRolesNames() function from spatie library.. and always the returned date (role_id) is Null .. I Really tried hard and find nothing .. Can anyone Help me ༼ つ ◕_◕ ༽つ

ahmad_aLit_town's avatar
ahmad_aLit_town's avatar ahmad_aLit...Laravel
2

Extra query when lazy-loading relationship

I'm testing a simple example and can't understand why the second select * from data is needed/executed when the data is already returned by the first query. Could anybody offer any insights? Thanks! Route::get('product/{slug}', function ($slug) { $product = Product::where('slug', $slug)->with('Data')->first(); $data = $product->data; return view('product')

DannyCooper's avatar
DannyCooper's avatar SinnbeckEloquent
3

Check table existence before getting query

I have some queries in AppServiceProvider and I want to check if table exists then run them. I tried Schema like this: if(Schema::hasTable('mytable')) { run query } but it didn't work.

Armani's avatar
Armani's avatar SinnbeckGeneral
1

This Eloquent query is not working

Hi, so we have a page where we have to filter a list of students based on filters selected by the user in the front end. Filters in the front end Filter by Subjects (students who have opted for subjects) Filter by location (students who are part of a location) Filter by Gender (self explanatory) Now Location & Gender are part of student table, so it is very easy to use th

hellopeter13's avatar
hellopeter13's avatar psrzEloquent
6

Error in query execution

I have tried to covert the following raw query into Laravel query using Eloquent model and query builder SELECT * FROM ((SELECT 'Meetings Offered' AS Source, 'Meetings Chosen' AS Destination, COUNT(1) AS value, DATE (created_at) AS day FROM "typeform_contacts" WHERE client_signed = 1 GROUP BY DATE (created

ankur_g's avatar
ankur_g's avatar ankur_gLaravel
10

Trying to convert a SQL into Laravel query using Query builder?

SELECT * FROM (SELECT 'Meetings Offered' AS Source, 'Meetings Chosen' AS Destination, COUNT(1) AS value, DATE (created_at) AS DATE FROM typeform_contacts WHERE client_signed = 1 GROUP BY DATE (created_at) UNION SELECT 'Meetings Chosen' AS Source, '4A OR 4B' AS Destination, COUNT(1) AS

ankur_g's avatar
ankur_g's avatar ankur_gLaravel
22

Multiple query on one instance

Hello guys! In my case , I need to return this data from model : 1- list of pagination users 2- count all users 3- count active users 4- count inactive users my query looks like: $userModel = User::query(); return Inertia::render('Home', [ 'users' => $userModel->paginate(), // list of users 'total_users' => $userModel->count(), // 10 'active_users' => $userMo

karrar's avatar
karrar's avatar pkboomLaravel
6

Result from two table in single query in Laravel

#attributes: array:2 [▼ "id" => 1 "name" => "Saint Lucia country" "city" => array:8 [▼ 0 => App\Models\City {#1449 ▶} 1 => App\Models\City {#1436 ▶} 2 => App\Models\City {#1462 ▶} 3 => App\Models\City {#1475 ▶} 4 => App\Models\City {#1494

abdulrehman176617's avatar
abdulrehman176617's avatar James_Bhat...Eloquent
11

Query Optimization

I have an sql query and it need optimization because even after 20 mins no update UPDATE `exam_application_fees`, `exam_applications` INNER JOIN `exam_application_fees` eaf ON eaf.`student_id` = `exam_applications`.`student_id` SET `exam_application_fees`.`total_paper_amount` = ( SELECT DISTINCT SUM(`paper_amount`) FROM `exam_applications` WHERE `student_id`

vidhyaprakash85's avatar
vidhyaprakash85's avatar vidhyaprak...Laravel
2

Need help turning SQL query into Eloquent statement

Here is a sanitized version of the query itself: SELECT [...] FROM ( (SELECT [...] FROM tableA) as a INNER JOIN (SELECT [...] FROM tableB) as b ON a.date = b.date ) LEFT JOIN sites ON a.sites_id = sites.id Here is the closest I've gotten: DB::select('[...]') ->fromSub(function ($query) { $tableA = DB::table('tableA')->select('[...] as a'

RileyGWeb's avatar
RileyGWeb's avatar jlrdwEloquent
4

Eloquent Query with join returning double the sum of the actual values in Laravel

I want to calculate the total sum from whole database but it is returning exactly double value. $total = DB::table('tblpurchase as t') ->join('tblpurchasebill as tb','tb.fldreference','t.fldreference') ->selectRaw("SUM((tb.fldcredit+tb.fldtotaltax+tb.fldtotalvat+tb.cccharge)-tb.fldlastdisc) as total") ->whereDate('tb.fldpurdate', '&

padamghimire75@gmail.com's avatar
padamghimire75@gmail.com's avatar padamghimi...Eloquent
7

can't execute a query from an imports file, before doing the return

Hello everyone, I just built an import file to import excel files and create tuples on the db. but before doing the typical "return", I need to check if one of the parameters I have to insert (used as a foreign key) is present in another table, and if it is not present I have to insert it first in the other table and then use its id as a foreign key. however when I do

gabtass9's avatar
gabtass9's avatar gabtass9Eloquent
2

which package is responsible for viewing query model response time in laravel

which package is responsible for viewing query model response time in laravel?

sajib353's avatar
sajib353's avatar YorkiLaravel
3

Query last element in where clause?

Good day, I want to write an eloquent query that filters a package by the checkpoint it's at, however at the moment it is matching to all packages that have the checkpoint in its relationship, for example, a package could have checkpoint A, B or C in its pivot table, given that A and B could have been past checkpoints. i only need to match the last/latest checkpoint (C) to the

242Studios's avatar
242Studios's avatar cthronebur...Eloquent
2

How to use raw sql query string that is created dynamically?

I get an array of arrays that represent the values I need to use when I construct the sql query string. For example: [ ["a" => "a1", "b" => "b1", "c" => "c1"], ["a" => "a2", "b" => "b2", "c" => "c2", "d" => "d2&q

Ligonsker's avatar
Ligonsker's avatar LigonskerCode Review
6

Order of where conditions in (eloquent) query

I made some sort of logbook for my organization. The admin creates Tags and gives authority to the users to create and read logbook messages with those specific tags. So far so good. There is also a button 'show new messages since my last login'. Works fine, but there is a bug. When a user presses that button, he does get a list of logbook messages that were created since he la

Bervetuna's avatar
Bervetuna's avatar BervetunaEloquent
2

Get Inertia query parameters

Hi, I am having trouble getting the value from my Inertia query parameters. So I have this route: /?filter='units' and I would like to get the value from filter query inside my Vue file. Any ideas how to do that? I have tried to do this.$route.query.filter but I get $route not found

hjortur17's avatar
hjortur17's avatar SinnbeckInertia
2

4 tables sql "with" query

hello i have 4 tables tableOne : ID, CARPLATE, REPAIR_COST tableTwo: ID, CARPLATE, PORTICS_COST tableThree: ID, CARPLATE, FUEL_COST tableFour: ID,CARPLATE, DRIVER_NAME how do i connect the tables by "CARPLATE" on models, and make a query of the sum of the cost fields and group them by the carplate in a show.blade.php ? i have been trying but i'm not being able, i supp

peterpan26's avatar
peterpan26's avatar Tray2Laravel
3

Please Help me to Convert raw SQL query to Laravel Query Builder

Hi , Laracast Community, My friend prepares this SQL query which run perfectly, but now I need this to convert to Laravel query builder but unfortunelyy I did not have a good knowledge of it. so, I need some help for generating a Laravel query from the given raw SQL query. SELECT id, `leave_name`, `total_leave_days`, leave_id, leave_taken_days FROM `leaves` AS t1 INNER JOIN (

jhyaps's avatar
jhyaps's avatar numaanEloquent
13

Relation not joined on Query Builder

Hi, I'm trying to get a query builder that is already joining a relation to eager load them (Unfortunately I need a "Query Builder" to be later used and passed to another package). I'd suspect the following code to already join the two tables, but it doesn't: > Employee::query()->with('company')->toSql(); = "select * from `employees`" The parent mo

inkarnation's avatar
inkarnation's avatar SinnbeckEloquent
2

My eloquent query is getting failed for rows over 5 Million

I am running a background job to export the rows. My query is $chain = []; $loop = 0; Submission::with(['referredBy', 'referredTo']) ->where('project_id', $this->project->id) ->orderBy('position', 'asc') ->chunk(64000, function ($submissions) use (&$loop, &$chain) { // Add a job to the batch for each chunk of submissio

navneet's avatar
navneet's avatar navneetEloquent
7

Laravel Query Builder - Simple Question!

I'm fairly new to Laravel and query builder I'm trying to do something I thought would be pretty easy, but I must be missing something really obvious. To strip it back to it's simplest I have 3 models PaperFormat, morphs to other models (e.g. Topic), and has many papers Paper, belongs to PaperFormat Topic , morphOne to PaperFormat and has a method of papers(), intended to retr

andyjameswhite's avatar
andyjameswhite's avatar andyjamesw...Laravel
5

with->hasmany->belongsto separate query and another table

hello i want to know how can i make a separate subtotal of a field common in 3 tables and connect it to the view (the tables) , i've already connected tableOne to tableTwo with the command with public function tableOne() { return $this->belongsTo(tableOne::class); } and in the controller i guess that is eloquent : tableTwo::with('tableOne')->get() now i n

peterpan26's avatar
peterpan26's avatar peterpan26Laravel
2

Does Query Builder's "chunk" know about database changes?

Consider this query - DB::table('xyz')->whereNull('status')->orderBy('id')->chunk(50, function($posts) { foreach($posts as $post) { if($something) { DB::table('xyz')->where('post_id', '=', $post->id)->update(['status' => 1]); } } }); In this case, does Laravel know that the 'status' of several posts were updated in the first batch of 50; and avoid fetchin

thebigk's avatar
thebigk's avatar Sergiu17Laravel
1

Query on relationships's json column

I'm trying to get users from their foo relationship, and from an id which is stored in a data json column. I tried the syntax below which is wrong : User::with('foos')->where(['foos.data->id' => 123])->get() What is the correct syntax for such query ?

devondahon's avatar
devondahon's avatar devondahonEloquent
5

Laravel get model relations with select raw query

So I have copied a function from the internet to get all companies in your area. Now the function gets all the columns in the table that I need, but my table has relations with other tables and I want it to get the data of the other tables instead of only the id's. This is the code to get all the companies in your area: $companies = DB::table('companies') ->selectRaw(

moemenh_'s avatar
moemenh_'s avatar SilenceBri...Laravel
1

Is it possible to add a global `AND` condition to an Eloquent query?

Hello I have this simple query that I cant change it unfortunately but I can add on it : echo User::orWhereIn('id',[1,2,5]) ->orWhereIn('id',[1,92,5,9,6,96,9]) ->toSql(); SQL result is : select * from "users" where ("id" in (?, ?, ?) or "id" in (?, ?, ?, ?, ?, ?, ?)) and "users"."deleted_at" is

GodziLaravel's avatar
GodziLaravel's avatar tisuchiEloquent
5

How to walk through the following nested array to build the correct query?

I am getting a nested array from the frontend that is selections made by users that I need to then filter results by these selections. The selections are based on company's hierarchy, for example: // dd($selections) [ "group2" => [ "unit11" => [ "department50" => [ 0 => "team10",

Ligonsker's avatar
Ligonsker's avatar tisuchiCode Review
1

How to hide appends attribute in laravel query?

hi I want laravel query that hide appends attribute? my model like below protected $appends = ['name']; public function getNameAttribute(){ return $this->first_name . ' ' . $this->last_name; } $user = user::get(); this above query gets appends name attribute. is that any query to exclude name appends attribute? and Thanks for answering...

laravelstarter's avatar
laravelstarter's avatar laravelsta...Laravel
4

Convert MySQL to Laravel query builder

Hi, i wonder if anyone could helpme to transform this query to laravel. I try but dont have any idea about the from part SELECT out_info.Id_funcionario, out_info.Primer_nombre, out_info.Primer_apellido, out_info.Date, m.Id_Marcacion, h.Hora_inicial , h.Hora_final, cm.Descripcion as Permiso_Descripcion, sr.vacacion, re.permiso from (Select DISTINCT info.Id_funcionario, d.Dat

hcastillo's avatar
hcastillo's avatar Tray2General
4

Avoid repeating same query in all controller functions

Hello All, i have controller where in every function i have a query to check if passing course id is valid or not like below, public function index($id) { $coursedetail = Course::find($id); //if coursedetail is not empty then conitinue to next code logic } public function show($id) { $coursedetail = Course::find($id); //if coursedetail is not empty then continue to next co

Deekshith's avatar
Deekshith's avatar DeekshithLaravel
3

How to manage product eloquent query result based on category expire time?

How to manage product eloquent query results based on category finish time? I'm working feature that requires the list of product displays on a google map with the category but based on some finishing time tables: product id category_id (array: ['1','2','3']) location lat long long category id title is_finish (yes/no) finish_time (in minutes) let's say category "[1].

M@rty's avatar
M@rty's avatar M@rtyLaravel
7

Create table in db with query and then use eloquent

Hello everyone. If someone creates in a database (oracle) the tables through queries. Then it is possible not to do migrations but to insert and update the data of the tables using eloquent? For example, If in the database I create this table: create table "users" ( "id" uuid not null, "prs_id" va

julianov's avatar
julianov's avatar webrobertEloquent
4

Laravel query builder doesn't work with COALESCE

Hi all, This query works perfectly and return values in both subject and body_html columns. SELECT translations.id, COALESCE(locale.subject, fallback.subject) as subject, COALESCE(locale.body_html, fallback.body_html) as body_html FROM translations LEFT JOIN translations AS locale ON locale.translatable_id = translations.translatable_id AND locale.translatable_type = translat

duddy67's avatar
duddy67's avatar Tray2Laravel
1

Laravel / Eloquent / Counting several entries at once in the same query

I was wondering if there was a way to perform count several times inside the same query for multiple rows with different conditions? For example, I'd like to count the number of entries which are larger than the set values for certain IDs. Let's say that I have this array: $data= [ 0 => [ "id" => 1, "points" => 25.33 ], 1

AverageJoe's avatar
AverageJoe's avatar AverageJoeEloquent
4