eloquent Questions

How to apply multiple where condition on laravel eloquent having mutliple models

February 24, 2023
Puneet
3 Answers

I have a model with four relations like as below public function custform_formfields() { return $this->hasOne(FormFieldMapping::class,'field_id','field_id'); } public function custform_fieldtype() { return $this->hasOne(FieldType::class, 'fieldtype_id', 'html_field_type'); } public function custform_forms() { return $this->hasOne(CustomForms::class,'form_id', 'form_id'); } public function custform_options() { return $this->hasOne(FormOptions::class,'option_id',…

VIEW QUESTION

My Eloquent doenst select the correct time data, pls help me understand – Laravel

February 24, 2023
Wedman Hutahaean
2 Answers

im currently making this queue web, so i want to select the longest overall queue time. im able to select the longest queue time per category but somehow when i want to retrieve the longest overall queue time, my model…

VIEW QUESTION

Array callback must have exactly two elements – Laravel

form models { //filters search if(isset($filters['search']) ? $filters['search'] : false){ return $query->where('tittle','like','%' . $filters('search') . '%') ->orWhere('body', 'like', '%' .$filters('search') . '%'); } } and from controller "posts" => Post::latest()->filter(request(['search']))->get() and i get Array callback must have exactly two elements…

VIEW QUESTION

How to have two relationships to the same table – Laravel

February 23, 2023
Bill200
2 Answers

How should I define two relationships to the same table? Here's a simple example: Person - id - name Deal - id - seller_person_id - buyer_person_id - date - amount On the Person model I can have these relationships: public…

VIEW QUESTION

Laravel: Select all the records where booked_at left 6 days?

February 22, 2023
Zia
3 Answers

I'm building a booking system in Laravel, look at below image Today is 3, my customers booked in current month 1,6,8,10,12 and 25. I want to send a notification to those who left 6 days from today. I want to…

VIEW QUESTION

Laravel belongsToMany select all specified ids

February 22, 2023
EgoPrimary
2 Answers

Relation public function groups() { return $this->belongsToMany('AppModelsItemGroup','item_to_group','item_id','item_group_id'); } ** How to select all Items that have item_group_id 0 and 9 BOTH?** $zero_and_nine_count = AppModelsItem::with(['groups' => function ($query) { $where[] = ['item_group_id', , 0]; $where[] = ['item_group_id', '=', 9]; $query->where($where); }])->count();…

VIEW QUESTION

Left Join with models and condition in laravel9

February 21, 2023
Sona Rijesh
2 Answers

How can I change this query [email protected]? $query = "select * from nozzle a left join nozzlereading b on a.id = b.nozzle and b.date=" . $date . " where a.meter=" . $meterid; $reading = DB::select($query); My models are Nozzle and…

VIEW QUESTION

How to delete a single record from pivot table – Laravel

February 20, 2023
Pouya
2 Answers

I have made my own Access Control List with Laravel 9 and basically, I made also a Many To Many relationships between User & Role: User Model: public function roles() { return $this->belongsToMany(Role::class); } Role Model: public function users() {…

VIEW QUESTION

How to return images sequentially inside a "for loop"? – Laravel

February 17, 2023
Itamar Campos
2 Answers

My view displays collections from four different tables. $redtable is my longest collection. @for ($i = 0; $counter < $redtable->count(); $i++) <div> {{ $red->slice($i, 1)->first()?->content }} {{ $green->slice($i, 1)->first()?->content }} {{ $blue->slice($i, 1)->first()?->content }} {{ $gray->slice($i, 1)->first()?->content }} <div> @endfor…

VIEW QUESTION

How to retrieve a record from a parent table based on its id on a child table – Laravel

February 17, 2023
Ebuka Eluzai
2 Answers

I have two related models in a job listing application, Company and Listing. The relationship between them is that company may have listing and a listing must have exactly one company. class Company extends Model { use HasFactory; /** *…

VIEW QUESTION