I have a model Product which contains a list of Specification how can I easily update all the specifications in one-to-many relationship in Laravel 10? class Product extends Model { //... public function specifications() { return $this->hasMany(Specification:class); } } class…
I am creating a small news system and these are the tables I have available: News Table id title text 1 News 1 - 2 News 2 - 3 News 3 - 4 News 4 - 5 News 5 -…
I have table structures like this : jobs id name types id name job_type (pivot table) id job_id type_id tasks id description job_type_task (pivot table) id job_type_id task_id Notes : jobs has many types and vice versa job_type has many…
I have two models, User and Community. A user can belong to many communities while a community can have many users. I have implemented many-to-many relationship for this in both models and then created a pivot table communities_users. In Community…
i try make code for search and this is my code: $services = Service::query()->with('plans')->latest(); if ($request->service_name) { $services = $services->whereRaw("CONVERT(JSON_EXTRACT(name, '$.ar') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.en') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.he') using 'utf8') LIKE '%$request->service_name%' ");…
I'm trying to write a query scope in Laravel Eloquent to get records only where the sum of a records relationship values is more than a value stored in a parent column. So for example I have: Table A id…
Knowing the structure below, can I add a function to the Container class to get records directly with Container::with('records')->get() instead of Container::with('boxes.letter.records')->get() ? containers hasMany boxes hasOne letter hasMany records class Container extends Model { public function boxes(): hasMany {…
I have two tables: items id name description created_at update_at images id name item_id created_at updated_at I did build a one-to-one relationship between the Item model and Image model. Item model <?php namespace App/Models; use IlluminateDatabaseEloquentFactoriesHasFactory; use AppModelsImage; class Item…
I'm working with Laravel 8... So I have the following eloquent query, I've eager loaded a bunch of models but I want to do 2 things to the way the models are loaded: Only select certain fields from the cooking_methods…
I have two models named: Subject and Group, Subject has a group_id column with a foreign key setup to point to the groups' table. When I call $subject->group it returns null; it should return the Group model that the Subject…