Design and implement a PHP/MySQL system to present and store daily/weekly/monthly staff performance data based on data pulled from existing logs from a MySQL database from the WHMCS application. This will involve data like number of calls answered, emails replied, log-in/log-out times, etc. The system will also need to be able to generate specific reports, like average number of support tickets responded to per day, per technician.
You will be provided with an existing PHP script that currently does similar tasks (except instead of storing the data in a DB it only sends it out in an email) to base your work on.
The data will be stored in a separate MySQL database to which you will be given access to, and must be viewable via a PHP page.
Reports will also be sent out via a cron job daily, by email, as per the specs that will be provided.
Eventually this system will be enhanced with additional features so more work can be expected if chosen candidate does a good job.
Chosen candidate must be willing to sign an NDA.
12 freelancers are bidding on average $573 for this job
Dear Customer, We have highly skilled staff in MySQL, PHP with an experience of 6 years.We are interested in taking up your application project. Kindly check your personal mail box for further details