Laravel 5.6 Create multiple relationships

Hi I have a complex question. I have been working with Laravel for only a week. And I try to build price lists for customers.

I have 5 tables:

price_lists:
  id
  title

---------------------------
price_lists_products:
  id
  product_id
  price_lists_id
  price
  percent

---------------------------
price_lists_users:
  id
  user_id
  price_lists_id

---------------------------
products:
  id
  title
  price
---------------------------
users:
  id
  name

And I have to put them together like this:

There are a few price lists

Each price list is associated with products + price

Each user can associate up to 5 price lists

In product view and in the list, I need to show the user the product with the cheapest price that is set for him in the price lists

For example:

I have a book that belongs to 5 different price lists and each price list, a different price.

And there is a user associated with 3 price lists.

I want the user to get the cheapest price in the price lists to which he belongs

I hope this is understandable, I have no idea how to approach it, I would be happy if you can help me with it, thanks!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2PEjERc
via IFTTT