Database Driven Website Application

**Overview:**This is a project to develop a database driven application. The application will work similarly to [[login to view URL]][1]. Development will require at least 72 database fields. The application will use user input, database data and calculations to calculate a price and generate a contract. A few project attributes include: database generated pages (at least 2), drop down list dependencies (at least 2), one database data lookup; 1 dynamically generated “help pop-up?? with 1 of 50 possible GIF images; 4 simple calculations; need for an auto generated # emailed to user and then verified online; auto generation of a template PDF to present user inputs in template contract; user log-in administration; coder confidentiality. Please note: 1. Page design will be delivered to coder by buyer in an excel format, including look and feel of each page and intended performance. Site will have 19 pages, including 13 user input pages, a log-in page, 2 static information pages, 1 database view page, and a user/password admin and email text admin page. Most of the pages can be static, however 2 “pages?? (the information and selections on the page) need to be generated based on previous user selections. 2. Load on server will be limited with no more than a handful of simultaneous users at any time. 3. There are two data uploads??"1 is a data dump, the other is a dynamic link to 1 of 50 US state GIFs. 4. System will generate a unique number, then email to user. User will enter unique identifier on website to verify. 5. Calculations:There are 4 calculations that are relatively simple. 1 drop down will need to be dynamic based on a user entry to “modify?? final outcome of calculation 6. User administration:ability to add user and change password and role ## Deliverables Below is a summary of intended application functionality. More precise detail (including page by page guide) will be provided in excel format prior to development commencement. Each page will have a CONTINUE and BACK graphic as navigation. I will ask that you sign a simple NDA requiring that you do not share further information regarding this project with others. **1. Password protected log-in page**. Page #1 includes #1.1 username and #1.2 password entry. System will need to authenticate user against database user / password records. If user does not have username and password, system will prompt to enter #1.3 username and #1.4 password, and #1.5 confirm password. **2. (Opening page** with “connecting to secure connection?? graphic applet) **3. Industry information:**3 questions. #3.1 is a drop down with a list of industries as possible selections. #3.2 is a dynamically generated drop down based on #1 selection, #3.3 is user defined “other?? **4. Reimbursement type:** 2 questions: #4.1 is radio button (9 choices), # 4.2 is drop down “calculation type?? that is dynamically generated based on #4.1 **5. Location:**#5.1 is select number of locations and drop down is 1 to 5. Based on number of locations, user will see 1 to 5 location entry fields. #5.2: Location entry includes: 5.2.1 US or International radio button, 5.2.2 State/Country drop down, 5.2.3 location drop down, 5.2.4 ZIP entry. Choices in 5.2.2 are based on radio selection in 5.2.1. Choices in 5.2.3 will be generated based on selection made in 5.2.2. **GIF lookup**: For each state (choice of 50) selection, there is will be a dynamically generated help link entitled: “View state climate divisions?? that is linked to a GIF with a picture of that state. Coder will need to build a lookup table to link state selection with appropriate GIF. (that is, user choice will dictate which picture appears) **6. Dates of program:**#6.1 (date begin) includes 6.1.1 month, 6.1.2 day and 6.1.3 year, #6.2 9date end) is date of program end including 6.2.1 month, 6.2.2 day and 6.2.3 year. Date_end minus Date_begin is number of days of program. #6.3 is a yes/no radio button. **7. Visualize: #**7.1 This is the database lookup. Based on location and dates and reimbursement type, user will be presented with appropriate data from a table. Table has 16 columns and 1171 rows of data currently in excel and ready for upload. 16 columns will feed "lookup". That is, if reimbursement type was “Temperature??, then only temperature data will appear. Similarly only data for locations (#5) and for the program dates (#6) will be presented. 7.2 is selection of a “calculation trigger?? and includes 7.2.1 drop down (greater than/less than/equal to) and 7.2.2 (trigger number) and 7.3.1, a second drop down (and/or) and 7.3.2 (trigger number) **8. Program Information:**this page has 8 elements. #8.1, customer enters intended rebate size, #8.2: volume of customers per day. #8.3 system calculates SIZE of program by multiplying 8.1 and 8.2 then by number of days (date_end-date_begin) #8.4: Total_Cost = SIZE x (0.10), #8.5: Cost_per_Cust= Total_Cost / #8.2 x Number of days; #8.6 Modify calculation has two aspects, 8.6.1 change calculation trigger (ie. from #7.2.1) and a dynamically generated drop down which includes 7.2.2 and the ability to raise or lower increments by 1 (ie. if 7.2.2 was 20 than drop down would be (+2 (22), +1(20), 20, -1 (19), -2(18)). **9. Administration:** 3 elements: #9.1 Yes/No radio button, #9.2 Yes/No radio button, #9.3 enter a unique 9.3.1 username and 9.3.2 password **10. Company Info: #**10.1 name, 10.2 address1, 10.3 address2, 10.4 City, 10.5 state, 10.6 Zip, 10.7 phone number **11. Company Financials:**11.1 Revenues, 11.2 EBITDA, 11.3 radio button, 11.4 TEV, 11.5 credit, 11.6 credit agency (drop down), 11.7 Radio button (3 choices) **12. User Info:** #12.1 Name (12.1.1 First, 12.1.2 Last), 12.2 Title, 12.3 email, 12.3.1 (form validate email confirm), 12.4 phone, 12.5 radio (yes, No, I Don’t know) **13. CFO Contact Info:** #13.1 Name (13.1.1 First, 13.1.2 Last), 13.2 Title, 13.3 email, 13.3.1 (form validate email confirm), 13.4 phone, **14. Authorize by email:**#14.1 submit SENDS an email to contact 1 and contact 2. system will need to auto-generate and then email both users. #14.2.1 and #14.2.2 provides an input field for each one of the users to enter their unique codes. Think of it as a 2 key authentication system. Buyer will need an admin form to administer text on this email. **15. Implement Program:**Bank information #15.1 Field 1, #15.2 Field 2, #15.3 Field 3, #15.4 Field 4, **Admin: 16:**Username and password administration page. This page will add, change, modify users and passwords and change authority. **Admin 17:**Email text: This page will be a form to administer text in #14.1 **Admin 18:**Database review: administrator will need to be able to review all data entered and sort by user. **Static Information pages:** **19.**1 “**About**?? page and **20.**1 “**Solution**?? description page **Other Details** 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows: a)web sites and other server-side deliverables are intended to only exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform I am flexible on platform and would like to know coder's preference in bid response. My preference for front end is AJAX; and mySQL or equivalent is fine. Platform: Windows or Linux I will provide a dedicated server for development/production environment.