I want to retrieve all places where parent_place_id = 999 in the attractions table. What relationships would I set up and what would this query look like? I've tried using the "Has Many Through" relationship, but I'm not sure if…
I have a table journals having columns transaction_id, type(receipt or payment), debit and credit columns for amount, account_id relation with accounts table the records can be multiple receipt or payment entries, and an opposite entry to record sum of these…
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…