-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Not an issue
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Announcements
-
Labels:None
-
ToDo:
-
Asterisk Version:asterisk 11.21.0
-
Distro Version:elastix 2.5.0 freePBX 2.11.0 24
-
Distro:FreePBX Distro
HI team I'm facing issue wrong timing of Break Agent report.
Call Center Add-on Agent Break report
==
Table -Agent Break ---Break1-Hodl Break2-Documnetions like on .
==
But Documentation Break ..when filter apply
*I have found on date : 27-Jun-2016 documentation time 1515:28:37 for extension 8XX2.
8XX2 AGENTNAME PROCESSNAME CSR 00:00:00 24:33:22 23:23:38 101:11:46 15:50:46 27:10:12 1552:53:51 00:23:12 1745:26:47*
But in single day how this much time ....happened,
Database : Call Center
Table : Agent Break and Audit
Query :
SELECT agent.id AS id_agente, agent.number, agent.name AS nombre_agente, audit.id_break,
break.name AS nombre_break,
SUM(UNIX_TIMESTAMP(IFNULL(audit.datetime_end, NOW())) - UNIX_TIMESTAMP(audit.datetime_init)) AS duracion
FROM agent
LEFT JOIN (audit, break)
ON (agent.id = audit.id_agent AND break.id = audit.id_break
AND audit.datetime_init >= '2016-01-01 00:00:00' AND audit.datetime_init <= '2016-08-31 23:59:59')
WHERE agent.estatus = "A"
GROUP BY agent.id, audit.id_break
*Issue : I why is show huge wrong time for Documentation Break ...
Please do Your suggestions and feedback ???
If is BUG or Error ??? What to to do ???*