Hello,
Our company currently processes a few hundred form submissions through
our site. Up till now, the contents of the form has been sent to our
customer support staff in real-time. Each submission goes to a general
e-mail box where it's printed through our mail client. A copy of the
form is also stored in a MySQL db, although it's not used that often.
I have been asked to figure out a way to stop delivering the form
submissions in real-time and migrate to the following:
Each morning, provide an Excel spreadsheet and word document (or PDF)
with a certain number of form submissions to each customer support
rep. For example, say 200 form submissions were processed the day
before. This morning, I should split those 200 among the 5 support
reps and provide each of them a certain amount (which can change
daily). Assuming each person gets 40 form submissions, each person
would need to be given an excel file and .doc document that contains
their 40 form submissions.
One of the most important things is that the .doc file needs to have
each form submission separated by a page break, so that when they
print the document each form submission is printed on a separate page.
Finally, not all of the fields from the form submission should be
given to the support rep. Maybe date and time is left off.
Any suggestions on where to begin looking? I'm a intermediate level
hack that programs in a few diff't languages, but I am not sure where
to start with this one using PHP & MySQL. Any guidance would be
GREATLY appreciated.
Thanks in advance,
Eric.