I’m searching to load a relation inside a pivot table with "->with()". Table structure: Are 5 tables and Laravel Eloquent models user (id) team (id) role (id) team_user (id, team_id, user_id) team_user_role (id, team_user_id, role_id) class User extends Model { function teams(){ return $this->belongsToMany(Team::class) ->using(TeamUser::class); } } class Team extends Model { function users(){ return ..
Category : relationship
I’m searching to load a relation inside a pivot table with "->with()". Table structure: Are 5 tables and Laravel Eloquent models user (id) team (id) role (id) team_user (id, team_id, user_id) team_user_role (id, team_user_id, role_id) class User extends Model { function teams(){ return $this->belongsToMany(Team::class) ->using(TeamUser::class); } } class Team extends Model { function users(){ return ..
public function show($id) { $post = Post::find($id); $comments = $post->comments()->orderBy(‘created_at’, ‘desc’)->get()->transform(function ($item, $key) { $item->registered = $item->created_at->diffForHumans(); return $item; }); return view(‘blog_views.post’)->with([‘post’ => $post, ‘comments’ => $comments]); } I want to add paginate(5) on $comments before return it to view and keep this values accessible in the view. {{ $comment->user->name }} relationship returning the creator ..
i have to table with one to many relation First table is status: | id | product_id | status | created_at | |—-|————|——–|———————| | 1 | 1 | 0 | 2018-01-01 00:00:00 | | 2 | 1 | 1 | 2018-02-01 00:00:00 | | 3 | 2 | 1 | 2018-01-01 00:00:00 | | 4 ..
I just wondering is there any proper way to fetch multiple data from multiple tables to the view without any relationships or joins, I have this code bellow that gonna fetch data1 and data2 to the view, yeah I might use Join or Eloquent Relationships but what if the data is totally different each other ..
I have a question regarding the extract of a schema you see below: As you see there are tasks that are connected with files through a pivot table task_files. The pivot table has an enum column io with possible values input and output. I would like to create an eager-loadable Laravel Eloquent relation that returns ..
I have a model with a one to many relationship and I want to see all records for the model grouped by the relationship. For example, I want to output something like this: One [1] Many [1] Many [2] Many [3] One [2] Many [4] Many [5] Many [6] so far with the code given ..
Hello to the community! I have a question regarding the extract of a schema you see below: As you see there are tasks that are connected with files through a pivot table. The pivot table task_files has an enum column io with possible values input and output. I would like to create a laravel relation ..
According to Laravel documentation OneToOne, OneToMany and ManyToMany relationships are available. https://laravel.com/docs/8.x/eloquent-relationships#many-to-many users id – integer name – string roles id – integer name – string role_user user_id – integer role_id – integer class User extends Model { public function roles() { return $this->belongsToMany(‘AppModelsRole’); } } Is it possible to change above many to many ..
I have the following table structure categories id product_category (others related categories) product_id category_id product id category_id (main category) manufacturer_id manufacturer id How can i get all categories(from the product_category) related to one manufacturer? Thanks a lot!. Sourc..
I have tables like this products – id, name, description, category_id, brand_id, color_id, material_id, price extras – id, product_id, size_id, stock images – id, product_id, name, path size – id, name Model product : public function meta() { return $this->hasMany(‘AppMeta’, ‘product_id’, ‘id’); } public function image() { return $this->hasMany(‘AppImage’, ‘product_id’, ‘id’); } Model extra : ..
My question is how to get the data from an eloquent model with its relation? Imagine 3 tables: users: | id | name | email | |—-|——|—————–| | 1 | name | [email protected] | companies: | id | name | user_id | address_id | |—-|——|———|————| | 1 | name | 1 | 1 | addresses: ..
I have an OneToMany relation between EVENT and MAJOR model as following’s schema : EVENT belongs to Major and Major HasMany Events Here is my tables in MySQl EVENTS Table : id name major_id 1 liga 1st 1 2 liga 2nd 2 Majors Table : id symbol name 1 MTB xxxxxxxxxxxxxxxxxxxxxxxx 2 ROAD yyyyyyyyyyyyyyyyyyyyyyyy 3 ..
I have a table of Lessons. I want some Lessons to be prerequisites to other lessons. I call these lessons Goal and Prerequisite. I have made a Prerequisite model and Prerequisites table as below. I can retrieve Lesson->prerequisite using oneToMany in the Lesson model. I want to make the Prerequisite->Lesson relationship but can’t work out ..
i have two tables ( Factories , Products ) Factories table has two columns ( id , factory_name ) and Products table has three columns ( id , factory_id , product_name ) i want to display factory_name column in Factories table in blade.php based on factory_id in Products table the code in Factory Model : ..
I have a State, County, salesTeam, and user models. SalesTeam.php public function state(){ return $this->belongsTo(State::class); } public function manager(){ return $this->belongsTo(User::class,’manager_id’); } County.php public function counties(){ return $this->hasMany(‘AppCounty’)->orderBy(‘county’); } What I am trying to achieve is that there might be some cases where there is a submanager assigned to a salesTeam but only to a ..
I want to add to this call more results from usercontract table. public function showRelated() { return UserContract::with([‘topics’, ‘contracttax’, ‘contractproperty’, ‘persons’])->get(); } In my user model I have this relationship that gives me usercontracts in which a given user by email as been invited to. So I want to add the result from this relationship ..
I have a Usercontract table and model… and I can call the usercontracts with it’s relationships like this return UserContract ::with([‘contracttax’, ‘contractproperty’, ‘persons’, ‘contractwarranty’, ‘users’, ‘contracts’, ‘tags’]) ->orderBy(‘created_at’, ‘desc’)->get(); Then I have another user model with this method. public function nonAcceptedContracts() { return $this->belongsToMany(UserContract::class, ‘invite’, ’email’, ‘usercontract’, ’email’)->where(‘status’, ‘pending’); } Is there a way to ..
I have 2 tables subscribers & subscriber_packages. I need to fetch the count of currently active packages for the selected subscriber via given subscriber_package / id. Tables: # | subscriber_id | package_id | status ————————————— 1 | 1 | 1 | true 2 | 1 | 2 | true 3 | 1 | 3 | ..
I want to recieve all users from a group. The problem is in this group their are student users (with a pivot table) and normal users. So i have to merge them together, but i still want to maintain all possibilities from eloquent. I came to this: dd($this->belongsToMany(User::class)->union($this->hasManyThrough(User::class,Student::class,’class_id’,’id’,’id’,’user_id’))->get()); But as result i get: My database ..
I’m trying to get users of entity using the relationship $users = $entity->users()->paginate(20); but now I want to run multiple where conditions depending on parameters sent to the API so if I do this $users = $entity->users(); //$users->where($where_array) $users->paginate(20); I get out of memory error. It’s getting all users first then tries to paginate (commented ..
Models Product and Category. Product model has this custom attribute: getCategoryIdAttribute(). because the way to get category id is a bit complex. With that attribute I can define the relationship (Product -> Category): public function category() { return $this->belongsTo(Category::class, ‘category_id’, ‘id’); } This relationship works fine! But now on the Category model: public function products() ..
I need some help designing my database relationships. I have these tables: documents, companies, individuals and users. A document can be internal or external. If it is external, it can be signed by a company or an individual. If it is internal it has to be signed by a user. In any case, the document ..
I am getting this error Method IlluminateDatabaseEloquentCollection::belongsToMany does not exist. And I have imported belongsToMany into User Model use IlluminateDatabaseEloquentRelationsBelongsToMany; Am using laravel version 7.2.28 Where am I getting wrong? class User extends Eloquent { /** * @return IlluminateDatabaseEloquentRelationsBelongsToMany */ public function roles() { return $this->account->belongsToMany(‘NaviculaEntitiesRole’); } } Sourc..
I have navbar table. Navbar_id represents dropdowns. When I’m creating in CRUD system navbar sections, I can choose if this menu will be drop down, or not. If yes, I give it a parent id, if not – set to 0. When I create navbar row, a blank row is inserted in table called dizainas1. ..