Find Jobs
Hire Freelancers

Database Driven Website Application

$500-1500 USD

Completed
Posted almost 18 years ago

$500-1500 USD

Paid on delivery
**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.
Project ID: 3502928

About the project

28 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$1,020 USD in 18 days
5.0 (3 reviews)
5.0
5.0
28 freelancers are bidding on average $936 USD for this job
User Avatar
See private message.
$1,275 USD in 18 days
4.9 (886 reviews)
8.8
8.8
User Avatar
See private message.
$637.50 USD in 18 days
5.0 (384 reviews)
8.6
8.6
User Avatar
See private message.
$1,232.50 USD in 18 days
4.9 (342 reviews)
8.2
8.2
User Avatar
See private message.
$850 USD in 18 days
4.8 (64 reviews)
7.0
7.0
User Avatar
See private message.
$1,100.75 USD in 18 days
4.7 (70 reviews)
6.7
6.7
User Avatar
See private message.
$1,062.50 USD in 18 days
4.6 (18 reviews)
6.4
6.4
User Avatar
See private message.
$637.50 USD in 18 days
4.9 (59 reviews)
5.9
5.9
User Avatar
See private message.
$850 USD in 18 days
3.5 (26 reviews)
6.1
6.1
User Avatar
See private message.
$1,062.50 USD in 18 days
5.0 (53 reviews)
5.5
5.5
User Avatar
See private message.
$1,190 USD in 18 days
2.4 (7 reviews)
5.6
5.6
User Avatar
See private message.
$1,275 USD in 18 days
5.0 (2 reviews)
4.9
4.9
User Avatar
See private message.
$1,062.50 USD in 18 days
4.6 (10 reviews)
3.1
3.1
User Avatar
See private message.
$510 USD in 18 days
4.4 (5 reviews)
1.9
1.9
User Avatar
See private message.
$595 USD in 18 days
5.0 (1 review)
1.1
1.1
User Avatar
See private message.
$425 USD in 18 days
5.0 (13 reviews)
1.0
1.0
User Avatar
See private message.
$849.15 USD in 18 days
5.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$637.50 USD in 18 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$1,275 USD in 18 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$595 USD in 18 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$680 USD in 18 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
19
Member since Apr 10, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.