the main thing I'm looking for is a MySQL and php based on-line system that gives user acces to view a certain stock-situation of a specific item.
In other words: users with differten abbilities should see what item is in stock and for what reason.
eg.
a user sees that there's 100 x art.8890 in stock and wants to reserve 20 pcs. He then does so by giving in a reservation for these 20 pcs. maybe together with some other reservations. A second visitor now must only see the 80 pcs. available left.
when we sent out these 20 pcs. they really will be gone.
but!
with every reservation or order or shipment or edit or whatsoever that is being made, there allways must be a reference or ordernumber given that also (if that isn't enough) must display the last 4 or 5 'historical' changes which may not be edited anymore
so in the end the screenview must say
1. art.nr 8890 100 pcs
2. art.nr 8890 80 pcs last ref. 77492877748
3. art.nr 8890 15 pcs last ref. 88098435t56
4. art.nr 8890 120 pcs last ref. 78u9378744
so... you also must be able to add stock.
all of this is needed to show several customers online what a specific stock cotains at that moment.
when stock is tkaen back, or bought back, the it must be very easy to add again.
for that reason it would be great to just say... + 20
or -10
I hope this rather complex idea is clear to everybody and has ideas on what to use, or where to seek...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
the main thing I'm looking for is a MySQL and php based on-line system that gives user acces to view a certain stock-situation of a specific item.
In other words: users with differten abbilities should see what item is in stock and for what reason.
eg.
a user sees that there's 100 x art.8890 in stock and wants to reserve 20 pcs. He then does so by giving in a reservation for these 20 pcs. maybe together with some other reservations. A second visitor now must only see the 80 pcs. available left.
when we sent out these 20 pcs. they really will be gone.
but!
with every reservation or order or shipment or edit or whatsoever that is being made, there allways must be a reference or ordernumber given that also (if that isn't enough) must display the last 4 or 5 'historical' changes which may not be edited anymore
so in the end the screenview must say
1. art.nr 8890 100 pcs
2. art.nr 8890 80 pcs last ref. 77492877748
3. art.nr 8890 15 pcs last ref. 88098435t56
4. art.nr 8890 120 pcs last ref. 78u9378744
so... you also must be able to add stock.
all of this is needed to show several customers online what a specific stock cotains at that moment.
when stock is tkaen back, or bought back, the it must be very easy to add again.
for that reason it would be great to just say... + 20
or -10
I hope this rather complex idea is clear to everybody and has ideas on what to use, or where to seek...