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:
csr (which rep took the call)
type of customer
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)