I want to pick questions randomly but category dependent. For example, if the test is given with 10 questions and the total category is 5, the test flow should take 2 questions randomly from each category. Is there a way…
I want to show data from 'personas' (parent table) that has at least one 'residente' (child table), its a one to many relationship, and i want to show data of that residente too. I was trying to do it using…
I have a pivot table with two foreign keys and I want to list items according to one foreign key. id | tool_id | user_id ______________________ 1 2 12 2 5 12 3 3 12 4 4 7 I have…
Hello I have these columns 'name', 'email', 'username' and 'ip' how would I check or highlight table row in blade if records has same ip? This is my controller $promo = Promo::with(['participants' => function ($q) { $q->orderBy('winner', 'desc')->orderBy('created_at', 'desc'); }])->find($id);…
I'm trying to get the right data from the database, I'm retriving a model with a media relation via eloquent, but I want to return a photo that contains the 'main' tag stored in JSON, if this tag is missing,…
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…