PHP / AJAX Multi-Dimension Form and report

Cancelled

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

Skills: AJAX, Javascript, PHP, XML

See more: what is a data entry form in a database, thanks you notes, table checker, php style, php data entry form example, php create table, php contract job, page break graphics, multi dimension database, multi dimension, layout and graphics, job php contract, job contract format, javascript date checker, foreman job, dimension data, data entry staff needed, data entry form php mysql, create your own php style, create table php, create mysql database using php, contract data entry form, check hours worked, 30 radio script, add item text box javascript ajax php

About the Employer:
( 1 review ) East Bangor, United States

Project ID: #486166

15 freelancers are bidding on average $349 for this job

SoftEngineer

Hi, pleas check PM.Thanks

$250 USD in 3 days
(255 Reviews)
8.1
A2Design

We'd like to help you with this. Check our experience at: http://www.a2design.biz/portfolio_

$730 USD in 18 days
(34 Reviews)
7.9
VALUEONWEB

I have check the details, i am ready to design PHP / AJAX Multi-Dimension Form and report for you

$350 USD in 3 days
(213 Reviews)
7.9
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$250 USD in 7 days
(51 Reviews)
6.9
dinhtoan

please see PMB more details.

$300 USD in 2 days
(67 Reviews)
6.3
ashwin86

check pmb for further details

$250 USD in 2 days
(51 Reviews)
5.9
erwindraft

Hi, I have read your req, and i understand it.. I'm experienced with retrieving db using ajax.. Please contact me if you have other detail...

$350 USD in 5 days
(85 Reviews)
5.6
Thewebweavers

Hi, Please check Your PM.

$250 USD in 2 days
(14 Reviews)
4.0
gvyshnya

Please see more details in PM.

$250 USD in 2 days
(3 Reviews)
3.8
gafhus

Ready to start.

$600 USD in 3 days
(10 Reviews)
3.7
piampri

Hi there, I'm a comp. engineer from Canada specializing in software development. Would really love to get an opportunity to work on this project for you.

$250 USD in 20 days
(2 Reviews)
2.5
JonnyAxehandle

I work part-time for a web marketing corporation and I do work similar to this on a daily basis. I can deliver a professional-quality script for you in a very speedy time. I look forward to working with you!

$250 USD in 2 days
(1 Review)
2.0
ghdany

We like forms... like everything else. I'm not gold member yet but satisfaction is guaranteed.

$500 USD in 10 days
(0 Reviews)
0.0
bdconsulting

We would love to do your job and we are very confident that our work will exceed your expectation.

$250 USD in 21 days
(0 Reviews)
0.0
superjmt974

hi please see your pm

$400 USD in 5 days
(0 Reviews)
0.0