Đang Thực Hiện

128588 php form upgrades

Hello,

We have a form that reps will fill out each time they make a call and the info is entered into our mysql db. The form is half functioning and needs some work. I'll put the info below and feel free to ask any questions.

1 - When submitted it's supposed to enter a datetime into the db and it currently enters 0000-00-00 00:00:00 so we need that to put the correct datetime.

2 - we need a drop down box that pulls info from another table in our db and when we choose a certain name have it enter their id into the new table.

3 - the delete link to starts to work but doesn't delete anything. So we need that fixed.

4 - We need certain fields or dropdown boxes to be required before it lets them submit. I'll let you know which ones when your chosen.

5 - On the inital page we only want the entries for that day to show up and sorted by date. We also need 3 stats at the top of the page. Calls today (all calls that day), Calls this week (all calls totaled last 7 days), calls this month (all calls totaled last 31 days).

6 - last we need a report that lets the rep choose between 2 dates and prints out:

date

csr (which rep took the call)

customer

type of customer

sale

then at the top give the same 3 stats as above and also a stat of total sales (which just totals the amount of sale)

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: stat c, c stat, mysql dropdown, csr, php form mysql page, table month php, time today php, report page mysql php, datetime, php form delete mysql, mysql date days, sorted form, day php date, drop form fill, report page php mysql, date days php, report delete page, mysql show date, form dropdown, fill submit form, php report sales, sale form, form submit link, php form required, customer rep

Về Bên Thuê:
( 95 nhận xét ) Payson, United States

Mã Dự Án: #1874756

Đã trao cho:

toinnisfree

pls chk pmb

$85 USD trong 1 ngày
(723 Đánh Giá)
8.2