Very simple task for experienced PHP coders. shouldnt take more than 2 hours to get everything in place.
we are a startup company with just 4 members, We use OSTicket ([url removed, login to view]) ticketing system at our office, Its a free opensource Ticket tracking application. I want 2 things to be done in here.
1. Need a dashboard (to hang it in the workplace monitor) to be created (google charting API of live data) , it should list the following
* Overall Tickets in Each Departments (PIE Chart)
* Overdue tickets in each department, with different colors along with the time overlapped (Bar Chart)
* How many tickets handled by each individuals of the team (Head lines like Vertical crawling - Example: [url removed, login to view] (15/400 tickets today))
* How many Tickets Handled today, yesterday , Day before and last month collectively for both individuals/Departments
* Star performer details ( Scrolling Data which reads - Example : Most tickets handled for today until now is [url removed, login to view] 53/300 Tickets)
* Area for Important Announcement to be broadcasted to team
1. 40/500 means, 40 Tickets handled out of 500 Tickets
2. All of these to be in a single dashboard and not to have scrollbars or so on as its going to be on the monitor and running always.
Should be Based on AJAX for auto refresh data values.
Budget is 30$