I am trying to store a simple form into my database. My model is that I have jobs which where each job can contain several task. Therefore my Models look like this: User public function jobs() { return $this->hasMany(Job::class); }…
The below function allows me to retrieve related entries of a given model type that have, for instance, overlapping tags associated with them. <?php public function getRelated($entity, $fields = [], $relations = []) { $related = new EloquentCollection(); // get…
I fill a SQL Table from a Request with Laravel Excel. After this I do an Eloquent Statement to fill the values markt and period manually. public function importall(Request $request) { $periode = $request->periode; $markt = $request->markt; Excel::import(new periodenImport(), $request->file);…
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,…