Development of one-form Google Web Toolkit based app

We need to have developed a Google Web Toolkit based application which consists of the single form (mock-up provided) with specific database connectivity. 1.1. Database: MySQL 1.2. Programming languages: PHP, Java, JavaScript, HTML&CSS, SQL 1.3. Size of the application: one form 1.4. Server Hosting Environment: Linux (Fedora Core 13), Apache 2.2.6, MySQL 5.0.45, PHP 5.2.4 1.5. Physical installation: Worker must demonstrate working application on Worker’s own server, after which we will install the application on our server. ## Deliverables 1. General Considerations 1.1. Third party components: The deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.); 1.2. Program type: An internet web-site 1.3. Target workers for this job: software developers confident with Google Web Toolkit, PHP and MySQL 1.4. Questions are welcome: If you consider the project feasible, but you need extra clarifications, please don't hesitate to ask. We encourage you asking, as this would help us to select the right coder for this job. 1.5. No partial payment: This project will not, under any circumstances, be accepted as partially done, i.e. we will not escrow a percentage of the funds if the worker ends up delivering only a part of the features/functionalities requested (before the deadline), unless we explicitly agree to do so as the project develops. 1.6. Deliver BEFORE the deadline: 1.6.1. Buyer should be provided with URL to a working installation of the application at worker's server 24 hours BEFORE the project deadline arrives. 1.6.2. All deliverables (source code, IDE project, plus SQL dump of worker's testing database) must be uploaded 12 hours BEFORE the project deadline arrives. 1.7. Testing: By bidding on this project, the winning worker agrees explicitly that it is their obligation to test the deliverables for conformity with buyer's requirements BEFORE the official deadline arrived, and that Buyer is only obliged to conduct one time final acceptance test 2. Internet web-site info 2.1. Database: MySQL 2.2. Programming languages: PHP, Java, JavaScript, HTML&CSS, SQL 2.3. Size of the application: one form 2.4. Server Hosting Environment: Linux (Fedora Core 13), Apache 2.2.6, MySQL 5.0.45, PHP 5.2.4 2.5. Physical installation: Worker must demonstrate working application on Worker’s own server, after which we will install the application on our server. 3. Deliverables 3.1. Requirements specification 3.1.1. Develop a Google Web Toolkit based application which consists of the single form depicted on the mockup screenshot below. 3.1.2. This form should have the following functionalities: 3.1.2.1. When user opens the form (i.e. loads ULR in the browser), default input focus must be in the Operator ID widget. 3.1.2.2. User types in Operator ID alphanumeric sequence (no spaces) and presses Enter. The application checks (via AJAX and PHP script) whether this sequence exists as OperatorID value in a row of MySql table "operators" which has the following design: 3.1.2.3. If the sequence is not found in the table, the application shows JavaScript modal dialog window saying "Operator unknown" with OK button only. After user presses the OK button and dialog is closed, the application clears Operator ID widget and keeps the input focus there. 3.1.2.4. If the sequence is found, the application silently moves the input focus to the Box ID widget. User types in Box ID alphanumeric sequence (no spaces) and presses Enter. The application checks (via AJAX and PHP script) whether this sequence exists as BoxID value in a row of MySql table "boxes" with the following design: 3.1.2.5. If the sequence is not found in the table "boxes", the application shows JavaScript modal dialog window saying "Box unknown" with OK button only. After user presses the OK button and dialog is closed, the application clears Box ID widget and keeps the input focus there. 3.1.2.6. If the sequence is found, the application silently moves the input focus in the top left cell of the datagrid. User types in alphanumeric sequence, presses Enter, and the application moves the input focus to the next left hand cell. 3.1.2.7. At any time when user types in the keyboard sequence "save" and presses Enter, the application saves the whole datagrid (via AJAX and PHP) to MySQL table "samples" with the following structure. BoxID field is a foreign key which contains the value of the ID field of a row in table "boxes" which corresponds to the BoxID typed in the form according to p. 4 and 5. Requirement 2.1.2. 7 is applicable if the input focus is in the datagrid. 3.2. Requirement Delivery 3.2.1. This project will not, under any circumstances, be accepted as “partially done??, i.e. we will not escrow a percentage of the funds if the worker ends up delivering only part of the features/functionalities we are requesting, unless we explicitly agree to this as the project progresses. 3.2.2. Buyer must be provided with the URL to a working installation of the application at worker's server 24 hours BEFORE the official [login to view URL] deadline for this project. 3.2.3. All deliverables (source code, IDE project, plus SQL dump of worker's testing database) must be uploaded before the project deadline. 3.2.4. Worker agrees explicitly that it is their obligation to test the deliverables for conformity with buyer's requirements BEFORE the official deadline, and that buyer is only obliged to conduct one time final acceptance test. 4. Coder/Worker must provide: 4.1. Bid 4.2. Deadline (for delivery of final, tested deliverables) 4.3. Explicitly stated: that coder/worker understands that partial work will NOT receive partial payment