Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-13087

Agent Break Report

    XMLWordPrintable

    Details

    • 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

      Description

      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 ???*

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hardik11 hardik chauhan
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  NextupJiraPlusStatus

                  Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.