How can I code a method in model that I use it for multiple records like delete or update? User::whereIn('id', [1, 2, 3])->delete(); My method is like this: public function remove() { $this->update([ 'expired_at' => now()->addYear() ]); } But above…
My model structure is as follows: Question hasMany Decision hasMany Impact morphTo Related So I'm trying to get a list of Questions with all of their Related objects deep inside. Example: {'question':1, relateds:[obj, obj, obj]} {'question':2, relateds:[obj, obj, obj]} {'question':3,…
I am using this query. In database structure column_name into Json format like this : [ { "Date": "2022-11-14T10:45:05.424+01:00", "Name": "nilesh1", "Level": "1" }, { "Date": "2022-11-14T10:54:15.776+01:00", "Name": "nilesh2", "Level": "2" } ] I have to use below query with…
How to add extra object in laravel relationship when fatch data. Here is my code: $list = new self; $list = $list->where('uuid', $uuid); $list = $list->where('user_id', $user->id)->orWhere('to_user_id', $user->id); $list = $list->with(['touser' => function($q1) { $q1 = $q1->select('id', 'name', 'email', 'user_image',…
I have 2 models: publictxt and Pulicetxtrecive publictxt model: class Publictxt extends Model { protected $fillable=['sender','reciver','description','useridseen']; public function Publictxtrecives() { return $this->hasMany(Pulicetxtrecive::class,'publictxt_id', 'id'); } } Pulicetxtrecive model: protected $fillable=['publictxt_id','user_id','seen']; public function publictxts() { return $this->belongsTo(Publictxt::class); } I want to get…
I have a many to many relationship between Users & Courses with a pivot table, Users_Courses, containing an isComplete value, but i can't seem to retrieve the isComplete value without looping through every user, getting their courses and then looping…
I have this 3 tables and I want to get the same subjects by given student_id For example I will select Vince (student_id = 1) And Jane (student_id = 3) the return value should be the subjects english and science.
I'm training with many to many relationships and today i'm trying to compare 2 pivot tables. I'm trying a site for a nutritionist. On one hand the nutritionist/admin can create patient's card (my table "User". In this cards he informs…
I have two columns called price and date, so i want to sum the total of price where the month is 01: price | date ------------------- 200 | 01-01-2022 100 | 09-01-2022 400 | 01-03-2022 120 | 01-06-2022 Here my…
I have a complicated query that I would like to translate either in Eloquent ORM or with the Query Builder for a Laravel site, but I can't do it, can someone help me? Here is my SQL query SELECT opp_id,…