PHP daily, weekly and monthly report page with MySQL
$10-30 USD
Concluído
Publicado há mais de 9 anos
$10-30 USD
Pago na entrega
I need you to create a report that will query a mysql DB (Asterisk). I will give you the DB name, table name and fields. You will develop the MySQL query to create a php file that will be emailed in the body of an email with a dynamic subject. If you want you can send the email with an excel attachment instead. I will attach a sample report. All fields are on the same table. As for the queries there are 3 COUNT, 3 SUM and 3 AVERAGE. I will set this up as a Cronjob to run daily, monthly and weekly. The Weekly and Monthly report must have comparisons from the previous weeks and previous month respectively If you can get this all done in one report/PHP file, the better. Please let me know if you have any questions. Winning bidder must be able to get this done within a half a day or less.
Hello,
All that you mentioned make perfect sense for me except that phrase
" The Weekly and Monthly report must have comparisons from the previous weeks and previous month respectively "
So, please explain :)
I checked the XLS and it's ok
Ready to Start.
Thank you
Hi
I have understand the requirement. Please provide me the database, table name and field name. I am ready to start it when you need.
Please inform me what would be the format for the monthly and weekly report?
Regards
Shihan
Hello,
We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required.
Scope of work includes -
- Working on the cron job script to send daily, weekly. Monthly report to defined email.
Let's take it to the next step and start on this ASAP.
Thanks,
Techmart Team
This can be done and completed within a day including testing
if the server has a working postfix installation.
If you provide email address, I can forward you an email from one of our reseller servers that runs daily a cron for average minutes per customer per day, cost for the day and also time/cost/ per customer for the month
Regards
Etienne