I am trying to create a HasOne relationship out of HasMany relationship but with added conditions. These are my models Document.php class Document extends Model { public function approvals(): HasMany { return $this->hasMany(Approval::class); } public function nextApproval(): HasOne { return…
I'm working on a Laravel application and I need help with filtering titles based on their relationships with practices, quizzes, and contests. Specifically, I want to retrieve titles that have associated practices but do not have any associated quizzes or…
As the title describes I want to have a zero-or-one to zero-or-one relationship. For example, let's say we have two tables Calls and Files. A call might have an attached file on it, and vice versa. But I have a…
I have ProductCollection Model and AttributeValue Model which have a common table product_collection_attributes that has 2 columns: product_collection_id and attribute_value_id that are a foreign key to their respective tables and are both a primary key. In ProductCollection Model relation is:…
Is there any way to create a relationship on a Laravel model using an "OR" condition for the field used to join the table while loading an eloquent model? Example Table: user_connections Name Type id bigInt|primary|auto_increment from_user_id bigInt to_user_id bigInt…
I'm developing a Spring Boot application with a PostgreSQL database. Within this application, I've implemented the functionality to create bots. Here's a glimpse of my Bot entity: @Data @Entity @Table(name = "bots") @NoArgsConstructor @AllArgsConstructor @Builder public class Bot { @Id…
Let's say i have three models User Post and Comment and linked like so: class User extends Model { public function posts(): HasMany { return $this->hasMany(Post::class); } } class Comment extends Model { public function post(): BelongsTo { return $this->belongsTo(Post::class);…
I have a problem that I have publications that are assigned to articles and I need to display other publications that are assigned to given articles on the details of a given publication. Each publication can be assigned to several…
I have 3 models: public class Student { public int StudentId { get; set; } public string StudentName { get; set; } public string Father { get; set; } public string PhoneNumber { get; set; } public string Email {…
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…