I am developing an application that's used to manage sales business of a company. Their business are multi layer, means a sales person A is managed by another sales person B, and that sales person B is also managed by…
i have this issue on my application. Object of type QuerySet is not JSON serializable In fact, i creating an application in which we have a relationship of the type several Products inone or more Orders. Here is my code…
I have company and user as many to many relationship. A company can have many users and a user can have many companies. I have the following tables: Company (id, name) User (id, name) User_Company (userId, companyId) How do I…
I have 2 models : Application and Contact. I use a polymorphic relation "contactable". A contact can be referenced to many applications (or other modeles), and can be referenced many times to the same application. In this case, the relations…
I have two tables with many to many relationship in Postresql database. The first Topic table consists of three columns. Their names are id, name and parent. Topic table has hierarchial structure: id name parent 1 Mathematics 0 2 Algebra…
I have 2 models Scheme & Sponsor with a many-to-many relationship with pivot SchemeSponsor. The pivot table has a one-to-many relationship with ContributionRate. I want to get all sponsors related to a scheme together with all contributionrates. Scheme id name…
I am using PHP 8.2.0, MySQL 8.2.0, and Laravel 9.48.0. This is my database migrations file pivot table (category_menu): public function up() { Schema::create('category_menu', function (Blueprint $table) { $table->foreignId('category_id')->constrained(); $table->foreignId('menu_id')->constrained(); }); } This is the CategoryController.php: public function destroy(Category $category)…
I have a many:many relation between student and course. Here are my models and my pivot table: <?php namespace AppModels; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateDatabaseEloquentModel; class Student extends Model { use HasFactory; protected $fillable = [ 'name', 'surname', 'age', 'tdah', 'description',…
I'm training with many to many relationships and today i'm trying to compare 2 pivot tables. I'm trying a site for a nutritionist. On one hand the nutritionist/admin can create patient's card (my table "User". In this cards he informs…
I have two entities (Product and Supply) that have a many-to-many relationship. I also have an entity between then that holds the two ID's (SupplyProduct). My entities: public class Product { [Key] public int ProductId { get; set; } [Required]…