Hello All,
We have a call center where users use Aastra 53i. Right now, we have Aastra 53i setup wit endpoint xml to be able to log in any phone. We also have static agents in the Queue. However, this is not desired anymore. We will setup dynamic agents for Queue and want payroll system. Eveytime an agent logs into a Queue, their extension # and time (EPOCH) will be saved in MySql database. Everytime agent logs out, the same thing happens. Finally, all this data is sorted and displayed on a password protected page where the Admin can browse and see how productive the users were. The following fields are important:
a- Who worked for the day.
b- How many minutes or hours they were logged in out of 8 hour shift.
c- Most productive to least productive users are sorted out in a list.
Please note that the data out of this system will be used for payroll purposes so the site will allow for report printing and entering SICK, and PBD (personal business day off), or VACATION time.
Also, a SALARY/HOUR field is neccessary for this project to add up the payment that should be made to the employee.
Please bid if you have previous experience with Asterisk. We are currently using Elastix 1.3 for this project.
hi, we are astercc develop team, i think we can do this for u, we capture the agent login/logout time from AMI and save to database using a linux daemon, so it would not affect your current system
mysql> select * from agentlogin_history;
+-------+-------------------+---------------------+---------------------+-----------------+--------+
| agent | channel | agentlogin | agentlogout | uniqueid | online |
+-------+-------------------+---------------------+---------------------+-----------------+--------+
| 1000 | SIP/8000-014c09e0 | 2009-02-16 04:27:05 | 0000-00-00 00:00:00 | 1234754818.12 | 0 |
| 1000 | SIP/8000-014c09e0 | 2009-02-16 04:29:55 | 0000-00-00 00:00:00 | 1234754988.13 | 0 |
| 1000 | SIP/8000-014c09e0 | 2009-02-16 04:31:20 | 2009-02-16 04:31:22 | 1234755073.14 | 2 |
+-------+-------------------+---------------------+---------------------+-----------------+--------+
Hi, we are the team you are looking for. You are in need of some providers or programmers, but we need you to make a long term relationship with you through our quality service. So let's start. PM...