Hi all,

 

I need a logic how to implement a scenario.

 

Scenario: There are multiple products with product id and image.

 

There is a project section where i use products in it. When i click on add product button, i get to see all the list of products that are unassigned. Suppose, a product, A, has been assigned in a project, X, for a period between 10/2/2013 to 15/2/2013.

Since this product is busy for this period, now when i will create a new project for 16/2/2012 to 20/2/2013. Then, this product needs to be shown to add product in this project.

 

So, can you help me how to implement this scenario. It's urgent.

 

Thanks in advance.

do you have both a products and a products_assignment table?  If so, a search in the products assignment table for the product and the date range will return nothing, indicating that the product is available.

Thanks for the reply.

 

I dont have product assignment table. if i have to create so, what would be stored in that table?

 

Thanks.

the product id, start and end date of the assignment (plus the usual: who created the assignment, when,..)

 

A table like this will allow you:

- check when something is assigned

- but also see the history of a product's assignments