Peruttu

PHP / AJAX Multi-Dimension Form and report

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

Taidot: AJAX, Javascript, PHP, XML

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) East Bangor, United States

Projektin tunnus: #486166

15 freelancers are bidding on average $349 for this job

SoftEngineer

Hi, pleas check [url removed, login to view]

250 $ USD 3 päivässä
(255 arvostelua)
8.1
A2Design

We'd like to help you with this. Check our experience at: [url removed, login to view]

730 $ USD 18 päivässä
(34 arvostelua)
7.9
VALUEONWEB

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

350 $ USD 3 päivässä
(213 arvostelua)
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 Lisää

250 $ USD 7 päivässä
(51 arvostelua)
6.9
dinhtoan

please see PMB more details.

300 $ USD 2 päivässä
(67 arvostelua)
6.3
ashwin86

check pmb for further details

250 $ USD 2 päivässä
(51 arvostelua)
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 5 päivässä
(85 arvostelua)
5.6
Thewebweavers

Hi, Please check Your PM.

250 $ USD 2 päivässä
(14 arvostelua)
4.0
gvyshnya

Please see more details in PM.

250 $ USD 2 päivässä
(3 arvostelua)
3.8
gafhus

Ready to start.

600 $ USD 3 päivässä
(10 arvostelua)
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 20 päivässä
(2 arvostelua)
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 2 päivässä
(1 arvostelu)
2.0
ghdany

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

500 $ USD 10 päivässä
(0 arvostelua)
0.0
bdconsulting

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

250 $ USD 21 päivässä
(0 arvostelua)
0.0
superjmt974

hi please see your pm

400 $ USD 5 päivässä
(0 arvostelua)
0.0