MySQL based data collection site, user logins, 3 combo boxes, records time, project

Overview Create webpage that stores values in mysql tables for tracking employee work and processes. Ability for employee to switch orders and processes must be extremely quick. All time must be accounted for. Design of form (see attached, concept only formatting/colors not important) Text box "Hello [UserName]" Dropdown List OrderID Dropdown list ProcessID Button Our current website uses magento and has a mqsql database, we would like to stick with this database. This extension can be written as magento extension or as standalone code. Winning bidder will provide all code and directions for uploading to our site. An additional database has been created by myself and can be changed as you suggest. I will provide information on this or you can specify structure. We can give you access to this database. Table Structure: Table "MPTblOrders" OrderID (Unique number, that I will populate, shows in dropdown list) SortOrder (Number) Table "MPProcessName" ProcessID (Unique Number, that I will populate) SortOrder (Number) ProcessName (Text Field, limit to 25 characters, I will populate manually, this is the value that will show dropdown list) Table "MPProcessTime" ProcessTimeID (AutoID) CurrentUserName (Store value here) OrderIDLink (Store value here) ProcessIDLink (Store value here) StartTime (Via your code will store date in format of (4/30/2014 4:14:41 PM or as mysql standards)) EndTime (Via your code will store date in format of (4/30/2014 4:14:41 PM or as mysql standards)) Dropdowns explained OrderID-From Table MPTblOrders, show OrderID where SortOrder is > 0 arrange least to greatest based on SortOrder ProcessID-From Table "MPProcessName", List "ProcessName", where Sort Order is > 0 arrange least to greatest based on SortOrder Button A Displays caption based on code, default value "Select above" How a user interacts User goes to website, logs in, timeout must be long >10 hrs, ideally no timeout. Creating this process is part of this project. Run Query when page loaded If user has a MPProcessTime with no EndTime, ProcessID dropdown show ProcessIDLink value from record with no endtime for user OrderId dropdown show OrderIDLink dropdown for record with no endtime for user Button A caption "Finish for day/lunch" Else ProcessID dropdown shows null OrderId dropdown shows null Button A caption "Not currently working" Events on Form When OrderID is changed If OrderID dropdown is null, not selected -do nothing Else If OrderID not null Clear ProcessID box, Button A Caption "Select Process ID" When ProcessID is changed If OrderID dropdown is null, not selected - Button A Caption "Select Order" Else Button A caption "Finish for day/lunch/" If user has a MPProcessTime with no EndTime, insert current time as endtime Insert new record to "MPProcessTime" CurrentUserName (from user) OrderIDLink (from OrderId dropdown) ProcessIDLink (from ProcessID dropdown, store ProcessID not process name) StartTime (Via your code will store date in format of (4/30/2014 4:14:41 PM or as mysql standards)) Else Insert new record to "MPProcessTime" CurrentUserName (from user) OrderIDLink (from OrderId dropdown) ProcessIDLink (from ProcessID dropdown, store ProcessID not process name) StartTime (Via your code will store date in format of (4/30/2014 4:14:41 PM or as mysql standards)) When Button A is clicked If record in MPProcessTime exists for user with no endtime, insert current time as endtime Clear OrderID dropdown Clear ProcessID dropdown Button A caption "Select above" Else Nothing