What I would like to do is run a script (you create) on the 5th of the month via cron. The script would search a MySql DB and pull out data from the previous month and create a report that is emailed to a email address (address can be put right in the script).
I would like a detailed report using all data. ASCII graphs/charts showing monthly totals (at a minimum, total inbound and outbound messages, total inbound and outbound data ammounts, and the number of fail messages, if in the dataset).
I would also like a verson of the script that could do the same thing daily or if easier pass a param to the script like 1 - previous day, 2 - monthly, 3 - yearly.
See attached file for table layout and sample data.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
Lunix system. Perfered work done in PHP or PERL.