Easy for a person who knows php and mysql.
I'm using a shopping cart system, SquirrelCart ([url removed, login to view]) and it works well for what we need it for. But I need a mod for it.
The system has in place an "order status" module but is a bit clunky. This just simply changes an entry in the database from one value to another reflecting the "order status".
I want severel different sections:
1. We will be using a barcode scanner that will read a barcode an translate it into our order number. The barcodes will be read on the fly as they are moving - no human interaction. So i need a script that will automatically change the order status once the bar code is scanned. Maybe just a field and a rule that if there is 5 digits in the field that it automatically updates the database. The status that this changes the database entry to will be static and can be configured in a config file.
2. We need another page like the one above, which will also be static but just a different status.
3. We need a manual one that would have a field for the order number, radio buttons for the different statuses and a "Send" button - to make it manually change by human interaction.
4. We need one like above, but would have a large field where multiple numbers could be scanned in to change mulitple orders at one time. *Note: the large field would need to implement some sort of auto-return that would allow a person to scan multiple numbers in a row without having to hit return on the keyboard each time to go to the next line.
Order numbers will be 5 characters
Needs to be password protected
Needs to have some sort of check and balance system so it wouldn't do crazy things to the database
We'll provide the html files.
I'll provide a test site with the shopping cart installed and passwords to the site and mysql database.
Let me know any questions - would like to get this going this week.