*** PLEASE READ FULL VERY DETAILED DESCRIPTION BELOW***
The flash application is a series of questions about an item that is added to a database. I imagine Flash interface, PHP, and MySQL.
A simple admin interface and user registration should begin the [url removed, login to view] an admin login will allow the addition of a new user, login, pass, [url removed, login to view], then the user can begin to add items to the database through the questionhierarchy.
I have attached the design composition. As you can see, each time a question is answered the question and answer is moved to the upper right.
There will need to be basic error checking. Also, there will need to be auto-population of fields. For instance, if the user begins to type a model that is already in the database, it should automatically complete the name of the model from the db. The attached .PDF contains all the questions and several other important points about what happens after an item is added. For the quote, all I need is that the item is added to the database with all the fields, and a date/time stamp, and a unique identifier as defined below. Also, the ability to drag/drop the images associated with each item and video files as asked in the question document.
Also, if the user selects that the item needs to be imported to EBAY, it should be outputted in a format reflective of the two documents I have attached that explain the EBAY API. The information is attached and more is available here:
Main eBay Developer site: [url removed, login to view]
PHP Developer content: [url removed, login to view]
I think this is all… it’s a straightforward database population application.
Regarding the unique identifier
When the record is finished being entered, the system assigns the inventory number(s) to the record(s) as part of the “Output.” The Inventory Number consists of 3 Alpha, 5 Numeric, 3 Numeric Extensions.
The extensions are for multiples of the same object, e.g., if we had 70 cable modems, the numbering would be AAA12345-001, AAA12345-002 through AAA12345-070.
If there is only one of the object, it is AAA98765-001
So, the entire number (minus the “-“) is 11 digits long (or 12 digits with the “-“).
The incrementation is would be, for example, AGB99999 to AGC00000, or, FDZ99999 to FEA00000. As of yet, the letters don't mean anything other than giving us 26^3 options in the first three digits instead of 10^3.
***Another reference of all the files is in a zip file at [url removed, login to view]