Closed

PHP / AJAX Multi-Dimension Form and report

This project received 15 bids from talented freelancers with an average bid price of $349 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
15
Project Description

PHP / AJAX Multi-Dimension Form

Object: To create a form that allows the user to enter data which is submitted to a MySQL database using php, AJAX, and JavaScript options.

Details:
Single Page Form with four sections that allow a Foreman to enter who worked on a job and what they did.


Page 1 [The Form]:
- Section 1 [show only one time per form]:
1. Combo box created by querying the database for information.
Data table queried is called “as1_contract” see database list.
To add a new contract not listed in the combo box the user can select an item called “Add New” then a secondary text field becomes visible and the visitor can add an item manually. Alternatively we can make it a check box that shows the hidden New Contract field.

2. Text field for date with Javascript date format checker. mm/dd/yyyy.

3. Contract Type radio buttons – select “Time / Materials” or “Contract”

- Section 2a [Add A Person to the form – Can add more people to the form by using graphic buttons (jpg) with mouse over graphic (jpg) to add another person. And a graphical button with mouseover for removing this person from list.]
1. Comb box created by querying the database for information.
Data table queried is called “as1_staff”.
To add a new staff member not listed in the combo box the user can select an item called “Add New” then two secondary text fields (First Name and Last Name) become visible and the visitor can add a staff member manually. Alternatively we can make it a check box that shows the hidden New Person field.

2. Comb box created by querying the database for information.
Data table queried is called “as1_position”. The visitor has to select one item from the combo box.

3. Time In: Combo box or open text field to record a start time for work.

4. Time Out: Combo box or open text field to record an end time for work.

5. Lunch Break: Check box to signify the person took a lunch break. If so, then 30 minutes is removed from the total time between Time In and Time Out.

- Section 2b [Add A Task to the above person – Can add more than one task per person by using graphic buttons (jpg) with mouse over graphic (jpg) to add another task. And a graphical button with mouseover for removing this task from list.]
1. Comb box created by querying the database for information.
Data table queried is called “as1_task”.
To add a new task not listed in the combo box the user can select an item called “Add New” then a secondary text field (Task Name) become visible and the visitor can add a staff member manually. Alternatively we can make it a check box that shows the hidden New Task field.

2. Text field for quantity (integer only).

3. Comb box created by querying the database for information.
Data table queried is called “as1_equip”.
To add a new piece of equipment not listed in the combo box the user can select an item called “Add New” then a secondary text field (Equipment Name) become visible and the visitor can add a staff member manually. Alternatively we can make it a check box that shows the hidden New Equipment field.

4. Comb box created by querying the database for information.
Data table queried is called “as1_units”.

5. Text field for hours (integer only).


- Section 3 [show only one time per form]:
1. Text Area for general comments about the Job.



Submit / Reset option for form using graphic buttons (jpg) with mouse over graphic (jpg).

Page 1 – Notes about the functionality.
When to form is submitted the hours for each person are calculated based on their time in and time out minus a lunch break if taken. This amount should be compared to the total number of hours

We originally envisioned the people being added to this form as dynamically listed tabs that would allow the person entering the information to toggle between each person if they need to update or edit their listings.

This one page form is designed to allow the foreman of a job to enter all of his needed information about a job, who worked, and what they did all on one page.


Page 2 [The List]
A list should be generated for each Job Number based on Date so a user can click the entry to reopen the above form with all of the applicable data in editable fields. Pagination can be used to allow a long list to be broken into groups of 25.


Page 3 [The Report]
A report should be generated by a date range selected by the user. This report will include the staff member – the job they were assigned – total hours for that job with a summary of total hours worked for the date range selected.

I have screen shots of our first draft and a database scheme started. However, this is not in current use so your layout and database options are flexible as long as we can meet the needs as above.

No login script is needed as we can incorporate that option.

While all buttons are to be graphics with rollover images, these graphics can be provided by us, or we can replace your own graphics. Overall page look, text font, colors, etc will all be handled by us. All you need to do is set cascading style sheet for the page and we’ll make all of the necessary changes.

We started a database example (see attached) however this is not fully functional. Most of the tables are used to support the combo boxes on the form. We will need an updated database file when you are done.

We will be happy to answer any questions or provide any clarification before or during your work as you request.

Thanks,

LVS

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online