archive cases/products

hi,

my client has asled me to have the facility to archive cases that are no longer in progress and archive their products sold to them?

could someone help explain how i would go about this with mysql/php webassist extensions?

i am not sure exactly how this would work?

has anyone done anything like this before that they could give pointers on i.e. do i need another table to archive clients details out of one table to an archive table?

many thanks for your support

I don't think that I fully understand what you are trying to accomplish as an end result. Please explain a little more about how things are setup and working for you now and how you would like it to work in the end.

Once the requirements for the new web app are known you can use that info as a guide to creating the functionality needed.

thanks eric, i am a new to this requirement so bare with me.

basically at moment there are users who login and add clients, the clients can have multiple products.

what they want to do with the site is have it so they can archive a previously sold product to that client in a page unique to thst client.

so on the clients details page generated by data assist currently it lists products that have been sold. they want to click a button next to that product that says archive and it then moves it from that page to another tab on the clients detalils page that has heading "archive" in there it will list all archived products been sold.

the clients details page is setup with tabs along the top, listing their details in one tab, product 1 sold to them in another and so on.

hope you can help :)

thanks again eric

I think you could do something like this by adding a new column to the table that records details of the products for the clients. If you add a new column for archived you can set it to 1 or 0 to indicate that the product has been archived.

Once you do this you will then add this column to the query on the page and filter it for only products that have not been archived.

Then next part of this where you click on something to archive it will be like a regular update server behavior. Clicking on the button will trigger the update server behavior and you will just update the archived column to be 1.

The other part of this is to make sure that your query that shows the archived items selects the archived column and filters where it is set to 1. Please post back with any questions that you have on any part of this.

thanks eric for your help, your advice is spot on. only one question.

when i am in the clients details page and i add a new product and it has the default value of 1 as active this is fine. i can click a button next to the old products to change it to 0.

However how can i have it where when you add the new product it auto sets the new one as active and the old ones to 0 from the insert button?

might be better to give them the control by doing it manually but just wondering if possible as it maybe an option that will be needed later on in the app.

many thanks

You could do something like this by adding in an update to the page. The update server behavior would need to update any of the records in the table where the active was set to 1 and the id was not for the just inserted record, it will need to update this to be 0 for all of the others.

It can become quite a bit more complex than this depending on exactly how you would like it to work but this is the general idea.