I’m developing a role and permissions based on laravel framework. I have 3 models : This is pivot table Now, a user can have a weblog with permission id 1,2 and another weblog with permission 1,2,3,4 How can I deploy relationships? and how can I check user permissions when managing a weblog. (middleware…
Tag: eloquent
hasManyThrough – Laravel 5.8
I have database table structure like : ClassRoom id (int) PK name (varchar) ClassTeacherCourse id (int) PK id_classroom (int) FK id_teacher (int) FK id_course (int) FK Course id (int) PK course_name (varchar) Teacher id (int) PK teacher_name (varchar) So far I have code just to call ClassRoom table & Clas…
Laravel Many-to-Many Factory with custom id type
I am using Laravel 8 and trying to make database factories/seeders I am having some issues. I have the following database Schema: Now I am trying to create factories and database seeders but I get an error using the following line to seed: This gives me the following error: Which is if I understand it correct…
Laravel relation from a pivot
I have a relation that I cant figure out my current application looks like this Models Tables Now a tournament can have just some of the users participate in the tournament so I’ve created the below To store users that are participating in a tournament from the team. How should this look in terms of elo…
Laravel – Name from foreign key doesn’t show in my blade
I’m making a project where I use the foreign key from a shop in products. The foreign key works but when I want to show it in my blade by using $product->shop_id->shop_name, it gives a blank spot. My foreign key is named ‘shop_id’.Product page without shop name This is my code: Product…
Laravel Model not loaded with data when trying to delete
I have one link as below: transfer_id) }}’> It gets parsed by the following route: …
How to avoid create record in laravel model creating event
I’m currently using Laravel 8 and I want check a field when my model ‘creating’ event fired. If my field isn’t null, I want cancel creating record. my event is like below: protected static …
Get all profiles in lat/long + range (laravel – laravel-mysql-spatial)
I am trying to build a form in my laravel app to get all users’ profiles that are in or x km around one selected city from my cities table. I’m trying to use the laravel-mysql-spatial that makes use of the ST_DISTANCE_SPHERE mysql function but cant really wrap my brain around the eloquent stuff ne…
Laravel Eloquent ORM – Mismatch between generated SQL and querybuilder results when selecting all models where two relationships are both absent
Let’s say I have a model Foobar with relationships named baz and quux. Foobar belongsTo Baz and Baz hasOne Foobar. This means there is a foreign key column in the Foobar table for baz_id. The …
How to join relationships in Eloquent?
I’m stuck in a problem, I have these 3 models: Order, OrderItem and Product, each Order has many Order Items, and each Order Item has one Prduct but a Product can be ordered several times. Product has a supplier ID column (each supplier has many Products). So here are the relationships: Model: Order: Mo…