how to override index query during runtime and update the table laravel-nova

in my use case, I need more than one text box for searching in more than two fields in the index view at the same time, because there too much data, laravel-nova provide only one out of the box, so if there is a way that I can add search in a card and update the index query in run time it will be great, and if there are any other solutions for this problem I would appreciate it

osama_abdullah's avatar
osama_abdullah's avatar osama_abdu...Nova
0

Help with Query please

I have 2 cruds staff, and staff_categories. I need to query each category and check if published and output them. Staff table: Schema::create('staff', function (Blueprint $table) { $table->increments('id'); $table->date('startdate')->nullable(); $table->string('name')->nullable(); $table->string('job_ti

madsynn's avatar
madsynn's avatar madsynnLaravel
5

My sql query

Hi i have this query but for 100 users i want to get the total users in country and the total order amount of the users but i the issue is when i add COUNT(DISTINCT u.id) it gave me 16 users in USA and when i do it without DISTINCT it gave me 85 users in USA but i don't have any duplication in rows so why this happen please ? SELECT c.*,COUNT (DISTINCT u.id) as total_users, SUM

mostafasadek's avatar
mostafasadek's avatar MichalOrav...General
2

Fix error in Eloquent query

user id name address_id address id photo_id photo id description I need to get all user which has photo description ="nice" whats the correct Eloquent to get the result $user= Users::with('address.photo', function (Builder $query) { $query->where('photo.description', 'like', 'nice'); } )->paginate(5);

Mqandeel's avatar
Mqandeel's avatar MqandeelEloquent
4

SQL - Is it possible to have more than one keyword in a query?

Hi everyone, I'm trying to create my own simple Database Management System with an input for SQL Queries. I've got a question about SQL: Is it possible to have more than one keyword in a query? With keyword I mean one of these: SELECT INSERT UPDATE DELETE DROP CREATE ALTER If the answer is no, I know I can scan a string to know which action to do. Thank you! Jer

jeroenvanrensen's avatar
jeroenvanrensen's avatar JeroenvanR...General
2

Should I use API Resources or Eluquent query for joinin tables

Hi guys I'm new here. I want to ask question. I have 3 tables on database, these are posts, post_views and votes. For every post row on posts table have multiple view and votes row. I split them to another tables because I want to hold voters and viewers ip addresses too. Lastly my votes table has a column which is holding vote type as integer. However, I wrote eloquent ORM que

stealhex's avatar
stealhex's avatar stealhexEloquent
0

Trimming down an expensive query

I have an query that takes almost 3 minutes to give results. It pins one of the CPU cores at 100% the whole time. I'm trying to figure out a way to get the same result without the expensive query. The results are correct, so I have no complaints about that. App\Cladding.php(Model) <?php namespace App; use App\BusinessParameters; use Illuminate\Database\Eloquent\Model; cla

fbc's avatar
fbc's avatar davidifran...Laravel
6

make query in blade view

I have the following tables groups - id - title categories - id - title - parent_id - group_id threads - id - replies_count - title - category_id replies - id - thread_id For each group, i display the title of the group For each category associated with a group, i display the title of the category, the total number of threads and replies associated with that category The

orest's avatar
orest's avatar orestCode Review
1

PDO hangs on executing query on heavy queue system, timeout does not work

Laravel Version: 7.6.2 PHP Version: 7.4.5-fpm-alpine Database Driver & Version: MYSQL 8.0 Queue driver: Redis:alpine3.11 I'm running a heavy queue system that runs about 300k jobs and insert/updating about 20 million rows per day, using docker-compose and scale workers by docker-compose scale command Sometimes, a job gets stuck and does not release even if the timeout has

nhoxtwi's avatar
nhoxtwi's avatar jocoonopa@...Laravel
4

Duplicate session query

On every page i've this duplicate session query, and i dont know where to start looking for the problem. Any suggestions? select * from `sessions` where `id` = 'ZGtPxAAAlFsMcZOC4OXnwRRX8n8gf9uWsqeefjoP' limit 1 update `sessions` set `payload` = `sdffbbblablablverylong` select * from `sessions` where `id` = 'ZGtPxAAAlFsMcZOC4OXnwRRX8n8gf9uWsqeefjoP' limit 1

Troj's avatar
Troj's avatar bugsyshaLaravel
9

Advanced Query Help

Need some help writing the following mysql working query. Works perfectly in as Normal SQL syntax in mysql workbench into Laravel DB syntax. I am banging my head trying to get this to work using Laravel DB. SELECT id, company_name, company_contact_name, (SELECT COUNT(id) FROM riders WHERE company_id = companies.id) as ridercount FROM companies So I query companies table a

laracasts9924's avatar
laracasts9924's avatar PedroCPint...Laravel
4

conditional relationship / query based on table field

I have the following tables categories - id - parent_id threads - id - title - category_id - updated_at The categories table consists of children and parent categories and each thread belongs to a children category. For each category ( either parent or children ) i want to fetch the thread that was most recently updated. Therefore, when i query all categories, i need to have

orest's avatar
orest's avatar guybrush_t...Laravel
9

How to add a backslash in an insert query (ex App\User)

I have a specific requirement to run this query directly without using Eloquent ORM DB::insert("INSERT INTO projects SET subject_type='App\Project', causer_type='App\User', created_at= NOW(), updated_at= NOW() "); It works but it doesn't add the back slash

appyapp's avatar
appyapp's avatar appyappLaravel
1

Challenge with query: local versus server.

good day, i have an issue with an query: Local it works fine staging (forge on digital ocean) it doesn't. Tests i did: (1) this query produces public function getSingle_dp($slug,$type) { $dp = dp::where('dp_name_slug', '=', $slug) ->where('dp_status_id',1) ->with(['services' => function($query) { $query->where('service_s

mbo's avatar
mbo's avatar mboLaravel
5

Optimise Laravel Eloquent Query Result

I have a homework table in Laravel-5.7 where 5000 records in the table also have some Relational records that are coming through HasMany() or HasOne() Relation. I tried many types of Eloquent Queries to get fast results. but Postman result time becomes 10200ms to 10700ms but when i direct display this into postman then i am getting this into 500ms to 1100ms. i want to get it in

pankajWork's avatar
pankajWork's avatar pankajWorkLaravel
0

Laravel modal query

I am trying to get array of related model to my data and it returns null. Code return Product::with(['allBarcodes' => function ($query) { $query->select('serial_number'); }])->get(); result Also I tried pluck like $query->pluck('serial_number'); and result was My real data the data I suppose to receive is like [{ "id":1, "product_id":1,

UsmanBasharmal's avatar
UsmanBasharmal's avatar uhohLaravel
3

How to Add IF ELSE Condition Between Laravel Query

I Want To Add if Else Condtion Between Query. If Distance is Not Equal To 0 Then Execute Query With Having Condition......... Else Remove Having Conition I Want Like This. As Shown Below. But Got Error. Please Suggest Me How Can I do This ? Below Code Is Not Working. $data = DB::table('tbl_jobs') ->select(array("*", DB::r

milanpatel's avatar
milanpatel's avatar tykusEloquent
3

Regex covert string formula to mysql LIKE search query

Regex how to convert string formula into MySQL LIKE search query in PHP? What is the best way to convert this string formula into MySQL LIKE search query in PHP? Example Input: (Business Intelligence) AND ((Business Objects Specialist) OR Cognos Impromptu OR (Crystal Reports) OR (Datawarehousing) OR (PowerBI) OR (SSAS) OR (SSIS) OR (SSRS)) Expected output: (column LIKE '%Busin

zubairmohsin's avatar
zubairmohsin's avatar zubairmohs...Laravel
0

Query builder GROUP BY, HAVING, COUNT in Laravel

how to express this code in query builder. I'm using Laravel 6. SELECT * FROM feedback GROUP BY noTicket having count(`status`) < 2 My Code: $feedback = DB::table('feedback') ->groupBy('noTicket') ->having('count(status)', '<', 2) ->get(); Error Code: SQLSTATE[42000]: Syntax error or access violation: 1055 'sifora.feedback.i

UsmanBasharmal's avatar
UsmanBasharmal's avatar uhohLaravel
2

Eloquent Query for array

I have a table structure as defined below id code name parent_id 1 oj8h4rd Parent Category 1 0 2 hg64g3 Sub Category 1 1 3 hwfhjf47 Parent Category N 0 4 kffh4jhw Parent Category O 0 5 jhs4g3g3 Sub Category 2 3 6 hf373g53 Sub Category 3 3 How do i write an eloquent query do show sub categories of belonging to a particular parent category. e.g Parent categor

ComputerMaverick's avatar
ComputerMaverick's avatar ComputerMa...Eloquent
14

what is "%" in query builder

I am looking at the query builder, I don't understand the character "%" what is it? where('id', 'like', '%' . $_data['q'] . '%')

KharNam's avatar
KharNam's avatar MichalOrav...Laravel
3

same Query is running on every GET request

Hello artisans, I am developing one application with Laravel Nova. and debugging it with Laravel telescope. But all of sudden page load time increased. quick look as telescope reveals that every GET (including styles and scripts ) request is querying 'select * from users where id = 3 limit 1'. here 3 is logged in users. In single page load sql query is running hundreds of time

surajjd's avatar
surajjd's avatar surajjdNova
3

How can I do a filter from multiple dropdown select on the view using one single query

On my view i have 4 dropdown selects where the user can select any of them, a combination of any, or all of them, clicks on a button and it queries the db and returns the result. In trying to implement this, I thought of using different queries for different dropdowns, but I can't seem to get the query that should execute when all is selected. $stat = request('status');

pianistprogrammer's avatar
pianistprogrammer's avatar guybrush_t...Laravel
5

Multiple query is giving empty data

if (true) { $musicDepartment = $departments->where(function($query) { $query->where('type', 'music'); })->with(['students'])->get(); $artDepartment = $departments->where(function($query) { $query->where('type', 'art'); })->with(['students'])->get(); $languageDepa

deepu07's avatar
deepu07's avatar MichalOrav...General
9

How to run raw SQL query - not select, but insert without any parameters?

Here is the withoutColumn() function in the WarehouseProduct model: /** * Get all columns of model * * @return Array */ public static function getTableColumns() { $model = new Product(); return $model->getConnection() ->getSchemaBuilder() ->getColumnListing($model->getTable()); } /** *

netdjw's avatar
netdjw's avatar joefuscoEloquent
1

Updated at didnt change for 1 day - Query

How can I query data that hasn't change for more than 1 day? I'm not talking one day from today but in all time. It could've been not update for 1 day one month ago for example.

Kemped's avatar
Kemped's avatar kalemdziev...Laravel
1

Join query error

Hi sorry for english , i try to change a developer code on a site write in lumen , im new of laravel . This is the code : if (!isset($_SESSION['perpage'])) { $_SESSION['perpage'] = 500; } if ($request->has('limit')) { $_SESSION['perpage'] = $request->get('limit'); } if($_SESSION['user_permissions']==1){ $query = $newsletters = Newsletter::orderBy('id', 'DESC

pippuccio76's avatar
pippuccio76's avatar trungtranq...Lumen
2

Converting RAW query into Eloquent query

i have a table called partner_transaction. On those table their is some column line - id, partner_id, amount, type(Debit, Credit) and balance. We wants to readjust all balance column by type for a specific partner. So we write a raw query - update partner_transactions pt inner join ( select id, (select sum(case type when 'Credit' then amount when 'Debit' then -amount end)

pasha's avatar
pasha's avatar pashaEloquent
0

Persisting query parameter across links on a given website

Hi everybody, I'm trying to find the best solution for the following task - let's say a user accesses my website using a token in the url, something along the lines of http://www.example.com/?token=12345. What I would like to do next is to persist that token query parameter on any links from the website that the user might visit. The entry point can be any link available on the

cosminc's avatar
cosminc's avatar MichalOrav...Laravel
6

Dublicate query when use SESSION_DRIVER=database

Hello, i have a duplicate query when load anypage on my website, select * from `sessions` where `id` = 'ykQz0YS8vSKIJDd1MuYt7tVyGSIRGuo7jncLBbfn' limit 1 update `sessions` set `payload` = 'YToh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', `last_activity` = 1590496081, `user_id` = '', `ip_address` = '127.0.0.1',

yzedayyash's avatar
yzedayyash's avatar yzedayyashLaravel
2

Update query throws "SQLSTATE[HY093]: Invalid parameter number" error. Parameters don't get passed on

I have this rather simple query: Category::whereRaw('hierarchy LIKE ?', [$old_hierarchy . '>%']) ->update([ 'hierarchy' => DB::raw("REPLACE(hierarchy, ?, ?)", [$old_hierarchy, $new_hierarchy]) ]); And it keeps giving me this error: SQLSTATE[HY093]: Invalid parameter number (SQL: update `categories` set `hierarchy` = REPLACE(hierarchy, 2020-05

catalin8's avatar
catalin8's avatar BryanKEloquent
6

Crypt in Eloquent Query

Hello, so I am defining a relationship with a user and the core database where all entries are encrypted. For this I have assigned an encrypted key to each user so that using the eloquent query I can find out which row belongs to which user. $get = Model::firstWhere('key', Crypt::decrypt(Auth::user()->key)); The 'key' is also encrypted in the core db. I am using the encrypta

hiaaryan's avatar
hiaaryan's avatar onbabyworl...Laravel
10

How to do a query search in multiple tables?

For example, i have 20 tables and want to do a query search that perform a search in all tables and return a instance of Query Builder.

JoaoHamerski's avatar
JoaoHamerski's avatar Tray2Laravel
7

using mysql load data query as a raw laravel query

Hi im trying to use this query LOAD DATA INFILE 'c:/tmp/discounts.csv' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; in laravel as raw query but that line terminating character actually takes the query on new line and it does not work . $upload = DB::raw("LOAD DATA INFILE '$file' INTO TABLE '$request->tabl

tallaljamshed's avatar
tallaljamshed's avatar tallaljams...Eloquent
6

Using a lookup table twice in one query

I'm new to laravel and have run into some problems. I need to use the same lookup table twice. This is a simplified example of the issue: Say I have two tables: users and assignments Users structure id username Assignments structure: id description - string user1 - unsigned user2 - unsigned user_id - unsigned (which identifies the person creating the assignment) Users model: c

Max100's avatar
Max100's avatar guybrush_t...Laravel
3

Variable used for joining conditional query scope is getting overwritten

The two dd($resourceSchedule->count() ) results give different values. I need the $resourceSchedule variable to remain unchanged in order to build the conditional query. protected function getResourceItemSchedule($resourceItemId) { $resourceType = Str::singular(request()->segments()[0]); if($resourceType == 'location') $resourceSchedule = Schedule::lo

khanimranm's avatar
khanimranm's avatar khanimranmLaravel
2

Query builder returning null

I am trying to run the query below but I keep getting null return. $result = Order::with(['customers', 'team'])->where('customers_id','=', $custid)->select(sprintf('%s.*', (new Order)->table)); Then I changed it to $result = Order::with(['customers', 'team'])->where(function($query) use ($cust) {$query->where('customers_id', $cust);})->select(sprintf('%s.*', (

gixroq's avatar
gixroq's avatar mkshingrak...Code Review
7

Query with filter on child tables

I have these tables: orders ---------- id (PK) stage_id (FK) stages --------- id (PK) phase I'd like to query the orders which associated stage has a phase='2' Thanks!

raulmercadox's avatar
raulmercadox's avatar piljac1Eloquent
3

Export excel from controller with a query

This is what I have currently Export class class ReportExcel implements FromQuery, withHeadings { use Exportable; public function __construct(int $id) { $this->id = $id; } public function query() { return Form::query()->where('country_id', $this->id); } public function headings(): array { return ["Opci

eggplantSword's avatar
eggplantSword's avatar msslgomezLaravel
1

query table based on multiple values

I have this table: ------------------------------------------------------------------------- | p_id | i_id | o_id | v_id | -------------------------------------------------------------------------- |65 | 1 | 2 | 12 | |65 | 1 | 4 | 9 | |65 | 2 | 2 | 3 | |65 | 2 | 4 | 9 | |65 | 3 | 2 | 4 | |

calin.ionut's avatar
calin.ionut's avatar calin.ionu...Eloquent
8

Query with attributes from related model

I have a Post model that can have multiple categories: The relationship looks like this: public function categories() { return $this->hasMany('App\PostsCategories', 'post_id', 'id'); } PostsCategories table contains IDs of posts and their categories. I'm trying to query posts by multiple criteria (post name, category, etc.) like this: public function search(

mleontenko's avatar
mleontenko's avatar mleontenkoEloquent
3

query limit when using pagination

Hi there, i have a question, came across this issue, looked up on internet and i see many others with the same difficulty and didnt see any solution, maybe you have some advice? i have this app, which works with tables of products lets say, and i can create subsets (segments) of these products, based on some criteria. I can also limit the number of allowed items in a segment. S

frankone's avatar
frankone's avatar frankoneEloquent
4

Number the rows in a subquery using Query Builder (or Eloquent)?

I'm trying to line up two sets of players (users), who have drawn different colors, opposite each other on the same table row of the view. The players who will occupy the same row have no common field value to join them except their row number from their subqueries. I need to number the rows in the subqueries so the first player to draw green appears in the same row as the firs

nategg's avatar
nategg's avatar nateggLaravel
1

Get spatie roles included with the query builder.

I'm trying to create a query build and also include the user roles in spatie but how can I do it? I tried different options from previous forums but none of them fits my needs. DB::table('users') ->select('users.id', 'users.name', 'users.email', 'banned_users.ban_date', 'banned_users.ban_reason') ->join('banned_users', 'banned_users.user_id', '=', 'users.id') ->where([

rcvioleta's avatar
rcvioleta's avatar rcvioletaLaravel
2

Possible to fill related models with a single query?

Say you have models Widget, Lookup1, Lookup2. Lookup1 & Lookup2 are lookup tables where Widget belongsTo Lookup1 and belongsTo Lookup2. If I just Widget::find(1) and in the template I call $widget->lookup1 and $widget->lookup2 I will end up with 3 queries. If I try to Widget::find(1)->with(['Lookup1','Lookup2']) I also end up with 3 queries. If I try ->join('ta

chrisan's avatar
chrisan's avatar chrisanLaravel
4

Eloquent WHEN: Add attributes to the query results depending on column value

I have a following query to select a client with its title ('Dr.' , 'Prof.', etc). I have a title_idcolumn and all the possible titles in an array under config/titles.php Titles.php <?php return [ 'titles' => [ '1' => 'Dr.', '2' => 'Prof.', ] ]; In my query I want to achieve that IF title_id = 1 then add an attribute as title = 'Dr.' If it

RafaelMunoznl's avatar
RafaelMunoznl's avatar SnapeyEloquent
5

Query Builder Placement

Hello, . I am new and learning laravel for now, if I write a 'Query Builder', where is my best place to place it? . What if I place it in the 'Eloquent Model' as a static function? please give your answer about the best placement for this . Thanks all ^ _ ^

andhirto's avatar
andhirto's avatar finhawkmanEloquent
3

How to use my Query to represent 1 as Male and 2 as Female

In my Larave-5.8, I am trying to generate bar chart using: public function report() { $userCompany = Auth::user()->company_id; $userId = Auth::user()->id; $gender_datas = HrEmployee::selectRaw('count(gender_id) as count,gender_id')->where('company_id', $userCompany)->groupBy('gender_id')->get(); $data=array(); foreach ($gender_datas as

noblemfd's avatar
noblemfd's avatar MichalOrav...Laravel
1

query the lowest value for each day in the past 30 days in a table

I am saving prices for a product several times every day in a price table. Now, I would like to collect data for a chart with the lowest prices for each of the past 30 days for one specific product. Is there a way to do this in Eloquent? I have no other idea than creating a query for each day. But I have the feeling this probably can be done a lot better. Any idea?

alev's avatar
alev's avatar alevEloquent
4

Update query to show table in real time

Greetings! I hope I can explain myself properly. I have a table in my view that shows all rows in my db like this: Query used to make this table: $query= DB::connection('pgsql')->table('DATOS_CABECERA_OT')->get(); +-------+---------+----------------+ | form | taller | id_antiguedad | +-------+---------+----------------+ | 1 | A1 | 2020 | | 2 | A

MarcosKlender's avatar
MarcosKlender's avatar drewdanLaravel
7