src/CompanyGroupBundle/Controller/TicketController.php line 117

Open in your IDE?
  1. <?php
  3. namespace CompanyGroupBundle\Controller;
  5. use ApplicationBundle\Controller\GenericController;
  6. use CompanyGroupBundle\Entity\EntityTicket;
  7. use CompanyGroupBundle\Entity\EntityTicketReport;
  8. use Symfony\Component\HttpFoundation\JsonResponse;
  9. use Symfony\Component\HttpFoundation\Request;
  11. /**
  12.  * TicketController
  13.  *
  14.  * Handles the full ticket lifecycle:
  15.  *   - Manual ticket list / create / edit / view
  16.  *   - Status transitions: resolve / close / assign
  17.  *   - System reporter endpoint with 1-hour problemHash deduplication
  18.  *
  19.  * Entity manager: company_group
  20.  * Views: CompanyGroupBundle:pages/tickets:*.html.twig
  21.  */
  22. class TicketController extends GenericController
  23. {
  24.     // =========================================================================
  25.     // CONSTANTS
  26.     // =========================================================================
  28.     const STATUS_OPEN        = 1;
  29.     const STATUS_IN_PROGRESS = 2;
  30.     const STATUS_RESOLVED    = 3;
  31.     const STATUS_CLOSED      = 4;
  33.     const SOURCE_MANUAL = 1;
  34.     const SOURCE_SYSTEM = 2;
  35.     const SOURCE_API    = 3;
  37.     const DEDUP_WINDOW_SECONDS = 3600; // 1 hour
  39.     const TICKETS_PER_PAGE = 20;
  41.     // =========================================================================
  42.     // LIST
  43.     // =========================================================================
  45.     /**
  46.      * GET /tickets
  47.      * Paginated, filterable list of all tickets.
  48.      */
  49.     public function TicketListAction(Request $request)
  50.     {
  51.         $em = $this->getDoctrine()->getManager('company_group');
  53.         // ── Filters ──────────────────────────────────────────────────────────
  54.         $filters = [
  55.             'status'   => $request->query->get('status',   null),
  56.             'priority' => $request->query->get('priority', null),
  57.             'source'   => $request->query->get('source',   null),
  58.             'q'        => trim($request->query->get('q',   '')),
  59.         ];
  60.         $page        = max(1, (int) $request->query->get('page', 1));
  61.         $offset      = ($page - 1) * self::TICKETS_PER_PAGE;
  63.         // ── Build DQL ────────────────────────────────────────────────────────
  64.         $qb = $em->createQueryBuilder()
  65.             ->select('t')
  66.             ->from('CompanyGroupBundle\Entity\EntityTicket', 't')
  67.             ->orderBy('t.createdAt', 'DESC');
  69.         if ($filters['status'] !== null && $filters['status'] !== '') {
  70.             $qb->andWhere('t.status = :status')->setParameter('status', (int) $filters['status']);
  71.         }
  72.         if ($filters['priority'] !== null && $filters['priority'] !== '') {
  73.             $qb->andWhere('t.urgency = :priority')->setParameter('priority', (int) $filters['priority']);
  74.         }
  75.         if ($filters['source'] !== null && $filters['source'] !== '') {
  76.             $qb->andWhere('t.source = :source')->setParameter('source', (int) $filters['source']);
  77.         }
  78.         if ($filters['q'] !== '') {
  79.             $qb->andWhere(
  80.                 $qb->expr()->orX(
  81.                     $qb->expr()->like('t.title',        ':q'),
  82.                     $qb->expr()->like('t.ticketNumber', ':q'),
  83.                     $qb->expr()->like('t.ticketBody',   ':q')
  84.                 )
  85.             )->setParameter('q', '%' . $filters['q'] . '%');
  86.         }
  88.         // ── Count for pagination ──────────────────────────────────────────────
  89.         $countQb = clone $qb;
  90.         $total   = (int) $countQb->select('COUNT(t.id)')->getQuery()->getSingleScalarResult();
  92.         $tickets    = $qb->setFirstResult($offset)->setMaxResults(self::TICKETS_PER_PAGE)->getQuery()->getResult();
  93.         $totalPages = (int) ceil($total / self::TICKETS_PER_PAGE);
  95.         // ── Summary counts ────────────────────────────────────────────────────
  96.         $summary = $this->_getStatusSummary($em);
  98.         return $this->render('@CompanyGroup/pages/tickets/list_tickets.html.twig', [
  99.             'tickets'     => $tickets,
  100.             'filters'     => $filters,
  101.             'currentPage' => $page,
  102.             'totalPages'  => $totalPages,
  103.             'total'       => $total,
  104.             'summary'     => $summary,
  105.         ]);
  106.     }
  108.     // =========================================================================
  109.     // VIEW
  110.     // =========================================================================
  112.     /**
  113.      * GET /ticket/{id}
  114.      */
  115.     public function ViewTicketAction(Request $request, $id)
  116.     {
  117.         $em = $this->getDoctrine()->getManager('company_group');
  119.         $ticket = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  121.         if (!$ticket) {
  122.             throw $this->createNotFoundException('Ticket #' . $id . ' not found.');
  123.         }
  125.         // Load occurrence log (EntityTicketReport rows for this ticket)
  126.         $reports = $em->createQueryBuilder()
  127.             ->select('r')
  128.             ->from('CompanyGroupBundle\Entity\EntityTicketReport', 'r')
  129.             ->where('r.ticketId = :tid')
  130.             ->setParameter('tid', $id)
  131.             ->orderBy('r.reportedAt', 'DESC')
  132.             ->setMaxResults(100)
  133.             ->getQuery()
  134.             ->getResult();
  136.         return $this->render('@CompanyGroup/pages/tickets/view_ticket.html.twig', [
  137.             'ticket'  => $ticket,
  138.             'reports' => $reports,
  139.         ]);
  140.     }
  142.     // =========================================================================
  143.     // CREATE
  144.     // =========================================================================
  146.     /**
  147.      * GET /ticket/create  — show blank form
  148.      */
  149.     public function CreateTicketAction(Request $request)
  150.     {
  151.         return $this->render('@CompanyGroup/pages/tickets/create_ticket.html.twig', [
  152.             'formData' => $this->_emptyFormData(),
  153.         ]);
  154.     }
  156.     /**
  157.      * POST /ticket/create/submit  — persist new ticket
  158.      */
  159.     public function CreateTicketSubmitAction(Request $request)
  160.     {
  161.         $session = $request->getSession();
  162.         $em      = $this->getDoctrine()->getManager('company_group');
  163.         $post    = $request->request;
  165.         $ticket = new EntityTicket();
  166.         $ticket->setTitle(trim($post->get('title', '')));
  167.         $ticket->setTicketBody(trim($post->get('description', '')));
  168.         $ticket->setNote(trim($post->get('note', '')));
  169.         $ticket->setType((int) $post->get('ticketType', 0) ?: null);
  170.         $ticket->setStatus(self::STATUS_OPEN);
  171.         $ticket->setUrgency((int) $post->get('priority', 3));
  172.         $ticket->setSource((int) $post->get('source', self::SOURCE_MANUAL));
  173.         $ticket->setSystemCreated(false);
  174.         $ticket->setUserId($this->loggedUserId($request));
  176.         // Ownership
  177.         if ($post->get('assignedToUserId')) {
  178.             $ticket->setAssignedToUserId((int) $post->get('assignedToUserId'));
  179.             $ticket->setAssignedByUserId($this->loggedUserId($request));
  180.             $ticket->setTicketAssignedDate(new \DateTime());
  181.         }
  182.         if ($post->get('taggedUserIds')) {
  183.             $ticket->setTaggedUserIds($post->get('taggedUserIds'));
  184.         }
  185.         if ($post->get('companyId')) {
  186.             $ticket->setCompanyId((int) $post->get('companyId'));
  187.         }
  188.         if ($post->get('appId')) {
  189.             $ticket->setAppId((int) $post->get('appId'));
  190.         }
  191.         if ($post->get('branchId')) {
  192.             $ticket->setBranchId((int) $post->get('branchId'));
  193.         }
  195.         // Reporter contact
  196.         $ticket->setName(trim($post->get('name', '')));
  197.         $ticket->setEmail(trim($post->get('email', '')));
  198.         $ticket->setPhone(trim($post->get('phone', '')));
  199.         if ($post->get('preferredContactMethod')) {
  200.             $ticket->setPreferredContactMethod((int) $post->get('preferredContactMethod'));
  201.         }
  203.         // Deadline
  204.         if ($post->get('deadlineDate')) {
  205.             try {
  206.                 $ticket->setDeadlineDate(new \DateTime($post->get('deadlineDate')));
  207.             } catch (\Exception $e) {
  208.                 // ignore bad date format
  209.             }
  210.         }
  212.         // Feedback
  213.         if ($post->get('feedback')) {
  214.             $ticket->setFeedback(trim($post->get('feedback')));
  215.         }
  217.         // System tracking fields (advanced section)
  218.         if ($post->get('problemHash')) {
  219.             $ticket->setProblemHash(trim($post->get('problemHash')));
  220.         }
  221.         if ($post->get('serverIdentifier')) {
  222.             $ticket->setServerIdentifier(trim($post->get('serverIdentifier')));
  223.         }
  224.         if ($post->get('lastPayloadJson')) {
  225.             $ticket->setLastPayloadJson(trim($post->get('lastPayloadJson')));
  226.         }
  228.         $em->persist($ticket);
  229.         $em->flush();
  231.         $this->addFlash('success', 'Ticket ' . $ticket->getTicketNumber() . ' created successfully.');
  233.         return $this->redirectToRoute('ticket_view', ['id' => $ticket->getId()]);
  234.     }
  236.     // =========================================================================
  237.     // EDIT
  238.     // =========================================================================
  240.     /**
  241.      * GET /ticket/edit/{id}  — show pre-filled form
  242.      */
  243.     public function EditTicketAction(Request $request, $id)
  244.     {
  245.         $em = $this->getDoctrine()->getManager('company_group');
  247.         $ticket = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  248.         if (!$ticket) {
  249.             throw $this->createNotFoundException('Ticket #' . $id . ' not found.');
  250.         }
  252.         // Map entity back to form data array for the view
  253.         $formData = [
  254.             'title'                  => $ticket->getTitle(),
  255.             'description'            => $ticket->getTicketBody(),
  256.             'note'                   => $ticket->getNote(),
  257.             'ticketType'             => $ticket->getType(),
  258.             'priority'               => $ticket->getUrgency(),
  259.             'source'                 => $ticket->getSource(),
  260.             'assignedToUserId'       => $ticket->getAssignedToUserId(),
  261.             'taggedUserIds'          => $ticket->getTaggedUserIds(),
  262.             'companyId'              => $ticket->getCompanyId(),
  263.             'appId'                  => $ticket->getAppId(),
  264.             'branchId'               => $ticket->getBranchId(),
  265.             'name'                   => $ticket->getName(),
  266.             'email'                  => $ticket->getEmail(),
  267.             'phone'                  => $ticket->getPhone(),
  268.             'preferredContactMethod' => $ticket->getPreferredContactMethod(),
  269.             'deadlineDate'           => $ticket->getDeadlineDate() ? $ticket->getDeadlineDate()->format('Y-m-d') : '',
  270.             'problemHash'            => $ticket->getProblemHash(),
  271.             'serverIdentifier'       => $ticket->getServerIdentifier(),
  272.             'lastPayloadJson'        => $ticket->getLastPayloadJson(),
  273.             'feedback'               => $ticket->getFeedback(),
  274.         ];
  276.         return $this->render('@CompanyGroup/pages/tickets/create_ticket.html.twig', [
  277.             'ticket'   => $ticket,
  278.             'formData' => $formData,
  279.             'editMode' => true,
  280.         ]);
  281.     }
  283.     /**
  284.      * POST /ticket/edit/{id}/submit
  285.      */
  286.     public function EditTicketSubmitAction(Request $request, $id)
  287.     {
  288.         $em     = $this->getDoctrine()->getManager('company_group');
  289.         $post   = $request->request;
  291.         $ticket = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  292.         if (!$ticket) {
  293.             throw $this->createNotFoundException('Ticket #' . $id . ' not found.');
  294.         }
  296.         $ticket->setTitle(trim($post->get('title', '')));
  297.         $ticket->setTicketBody(trim($post->get('description', '')));
  298.         $ticket->setNote(trim($post->get('note', '')));
  299.         $ticket->setType((int) $post->get('ticketType', 0) ?: null);
  300.         $ticket->setUrgency((int) $post->get('priority', 3));
  301.         $ticket->setSource((int) $post->get('source', self::SOURCE_MANUAL));
  302.         $ticket->setName(trim($post->get('name', '')));
  303.         $ticket->setEmail(trim($post->get('email', '')));
  304.         $ticket->setPhone(trim($post->get('phone', '')));
  306.         if ($post->get('preferredContactMethod')) {
  307.             $ticket->setPreferredContactMethod((int) $post->get('preferredContactMethod'));
  308.         }
  309.         if ($post->get('assignedToUserId')) {
  310.             if (!$ticket->getAssignedToUserId()) {
  311.                 $ticket->setTicketAssignedDate(new \DateTime());
  312.                 $ticket->setAssignedByUserId($this->loggedUserId($request));
  313.             }
  314.             $ticket->setAssignedToUserId((int) $post->get('assignedToUserId'));
  315.         }
  316.         if ($post->get('taggedUserIds')) {
  317.             $ticket->setTaggedUserIds($post->get('taggedUserIds'));
  318.         }
  319.         if ($post->get('companyId')) {
  320.             $ticket->setCompanyId((int) $post->get('companyId'));
  321.         }
  322.         if ($post->get('appId')) {
  323.             $ticket->setAppId((int) $post->get('appId'));
  324.         }
  325.         if ($post->get('branchId')) {
  326.             $ticket->setBranchId((int) $post->get('branchId'));
  327.         }
  328.         if ($post->get('deadlineDate')) {
  329.             try {
  330.                 $ticket->setDeadlineDate(new \DateTime($post->get('deadlineDate')));
  331.             } catch (\Exception $e) {}
  332.         }
  333.         if ($post->get('problemHash')) {
  334.             $ticket->setProblemHash(trim($post->get('problemHash')));
  335.         }
  336.         if ($post->get('serverIdentifier')) {
  337.             $ticket->setServerIdentifier(trim($post->get('serverIdentifier')));
  338.         }
  339.         if ($post->get('lastPayloadJson')) {
  340.             $ticket->setLastPayloadJson(trim($post->get('lastPayloadJson')));
  341.         }
  342.         if ($post->get('feedback')) {
  343.             $ticket->setFeedback(trim($post->get('feedback')));
  344.         }
  346.         $em->flush();
  348.         $this->addFlash('success', 'Ticket ' . $ticket->getTicketNumber() . ' updated.');
  350.         return $this->redirectToRoute('ticket_view', ['id' => $ticket->getId()]);
  351.     }
  353.     // =========================================================================
  354.     // STATUS TRANSITIONS
  355.     // =========================================================================
  357.     /**
  358.      * GET /ticket/resolve/{id}
  359.      */
  360.     public function ResolveTicketAction(Request $request, $id)
  361.     {
  362.         $em     = $this->getDoctrine()->getManager('company_group');
  363.         $ticket = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  365.         if (!$ticket) {
  366.             throw $this->createNotFoundException('Ticket #' . $id . ' not found.');
  367.         }
  369.         $ticket->setStatus(self::STATUS_RESOLVED);
  370.         $ticket->setResolvedAt(new \DateTime());
  371.         $em->flush();
  373.         $this->addFlash('success', 'Ticket ' . $ticket->getTicketNumber() . ' marked as resolved.');
  375.         return $this->redirectToRoute('ticket_view', ['id' => $id]);
  376.     }
  378.     /**
  379.      * GET /ticket/close/{id}
  380.      */
  381.     public function CloseTicketAction(Request $request, $id)
  382.     {
  383.         $em     = $this->getDoctrine()->getManager('company_group');
  384.         $ticket = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  386.         if (!$ticket) {
  387.             throw $this->createNotFoundException('Ticket #' . $id . ' not found.');
  388.         }
  390.         $ticket->setStatus(self::STATUS_CLOSED);
  391.         $ticket->setClosedAt(new \DateTime());
  392.         $em->flush();
  394.         $this->addFlash('success', 'Ticket ' . $ticket->getTicketNumber() . ' closed.');
  396.         return $this->redirectToRoute('ticket_view', ['id' => $id]);
  397.     }
  399.     /**
  400.      * POST /ticket/assign/{id}
  401.      * Body params: assignedToUserId
  402.      */
  403.     public function AssignTicketAction(Request $request, $id)
  404.     {
  405.         $em      = $this->getDoctrine()->getManager('company_group');
  406.         $ticket  = $em->getRepository('CompanyGroupBundle\Entity\EntityTicket')->find($id);
  408.         if (!$ticket) {
  409.             return new JsonResponse(['success' => false, 'message' => 'Ticket not found'], 404);
  410.         }
  412.         $assignTo = (int) $request->request->get('assignedToUserId', 0);
  413.         if (!$assignTo) {
  414.             return new JsonResponse(['success' => false, 'message' => 'assignedToUserId required'], 400);
  415.         }
  417.         $ticket->setAssignedToUserId($assignTo);
  418.         $ticket->setAssignedByUserId($this->loggedUserId($request));
  419.         $ticket->setTicketAssignedDate(new \DateTime());
  421.         if ($ticket->getStatus() === self::STATUS_OPEN) {
  422.             $ticket->setStatus(self::STATUS_IN_PROGRESS);
  423.         }
  425.         $em->flush();
  427.         return new JsonResponse([
  428.             'success'      => true,
  429.             'ticketNumber' => $ticket->getTicketNumber(),
  430.             'assignedTo'   => $assignTo,
  431.         ]);
  432.     }
  434.     // =========================================================================
  435.     // SYSTEM REPORTER  (called by cron / error handlers, no browser session)
  436.     // =========================================================================
  438.     /**
  439.      * POST /ticket/system/report
  440.      *
  441.      * Expected JSON body:
  442.      * {
  443.      *   "errorCode":       "DB_CONN_FAIL",
  444.      *   "message":         "Could not connect to database",
  445.      *   "exceptionClass":  "Doctrine\\DBAL\\Exception",
  446.      *   "fileLocation":    "src/Bundle/Service/ReportService.php:142",
  447.      *   "serverIdentifier":"app-server-01",
  448.      *   "appId":           3,
  449.      *   "payloadJson":     "{...full raw error payload...}"
  450.      * }
  451.      *
  452.      * Returns JSON: { success, ticketId, ticketNumber, action: "created"|"merged" }
  453.      */
  454.     public function SystemReportAction(Request $request)
  455.     {
  456.         // ── Parse input ───────────────────────────────────────────────────────
  457.         $body = json_decode($request->getContent(), true);
  458.         if (!$body) {
  459.             $body = $request->request->all();
  460.         }
  462.         $errorCode       = $body['errorCode']       ?? '';
  463.         $message         = $body['message']          ?? '';
  464.         $exceptionClass  = $body['exceptionClass']   ?? '';
  465.         $fileLocation    = $body['fileLocation']     ?? '';
  466.         $serverIdentifier= $body['serverIdentifier'] ?? gethostname();
  467.         $appId           = isset($body['appId']) ? (int) $body['appId'] : null;
  468.         $payloadJson     = isset($body['payloadJson'])
  469.             ? (is_string($body['payloadJson']) ? $body['payloadJson'] : json_encode($body['payloadJson']))
  470.             : json_encode($body);
  472.         // ── Compute problemHash (stable attributes only, NO timestamps/userIds) ──
  473.         $hashInput   = implode('|', [$errorCode, $exceptionClass, $fileLocation, (string) $appId]);
  474.         $problemHash = hash('sha256', $hashInput);
  476.         $em  = $this->getDoctrine()->getManager('company_group');
  477.         $now = new \DateTime();
  479.         // ── Deduplication: look for open ticket with same hash within 1 hour ──
  480.         $windowStart = (clone $now)->modify('-' . self::DEDUP_WINDOW_SECONDS . ' seconds');
  482.         $existing = $em->createQueryBuilder()
  483.             ->select('t')
  484.             ->from('CompanyGroupBundle\Entity\EntityTicket', 't')
  485.             ->where('t.problemHash = :hash')
  486.             ->andWhere('t.lastReportedAt >= :window')
  487.             ->andWhere('t.status != :closed')
  488.             ->setParameter('hash',   $problemHash)
  489.             ->setParameter('window', $windowStart)
  490.             ->setParameter('closed', self::STATUS_CLOSED)
  491.             ->setMaxResults(1)
  492.             ->getQuery()
  493.             ->getOneOrNullResult();
  495.         if ($existing) {
  496.             // ── MERGE: increment counter, refresh last payload ─────────────
  497.             $existing->setReportCount($existing->getReportCount() + 1);
  498.             $existing->setLastReportedAt($now);
  499.             $existing->setLastPayloadJson($payloadJson);
  500.             if ($serverIdentifier) {
  501.                 $existing->setServerIdentifier($serverIdentifier);
  502.             }
  504.             $ticket = $existing;
  505.             $action = 'merged';
  507.         } else {
  508.             // ── CREATE: new ticket (new incident window) ───────────────────
  509.             $ticket = new EntityTicket();
  510.             $ticket->setTitle('[' . $errorCode . '] ' . mb_substr($message, 0, 200));
  511.             $ticket->setTicketBody($message);
  512.             $ticket->setStatus(self::STATUS_OPEN);
  513.             $ticket->setUrgency(1); // emergency by default for system errors
  514.             $ticket->setSource(self::SOURCE_SYSTEM);
  515.             $ticket->setSystemCreated(true);
  516.             $ticket->setProblemHash($problemHash);
  517.             $ticket->setReportCount(1);
  518.             $ticket->setFirstReportedAt($now);
  519.             $ticket->setLastReportedAt($now);
  520.             $ticket->setLastPayloadJson($payloadJson);
  521.             $ticket->setServerIdentifier($serverIdentifier);
  522.             if ($appId) {
  523.                 $ticket->setAppId($appId);
  524.             }
  526.             $em->persist($ticket);
  527.             $action = 'created';
  528.         }
  530.         // ── Always log one EntityTicketReport row per occurrence ──────────────
  531.         $em->flush(); // flush ticket first so we have its ID if just created
  533.         $report = new EntityTicketReport();
  534.         $report->setTicketId($ticket->getId());
  535.         $report->setMessage($message);
  536.         $report->setErrorCode($errorCode);
  537.         $report->setServerIdentifier($serverIdentifier);
  538.         $report->setPayloadJson($payloadJson);
  539.         $report->setReportedAt($now);
  541.         $em->persist($report);
  542.         $em->flush();
  544.         return new JsonResponse([
  545.             'success'      => true,
  546.             'action'       => $action,
  547.             'ticketId'     => $ticket->getId(),
  548.             'ticketNumber' => $ticket->getTicketNumber(),
  549.             'reportCount'  => $ticket->getReportCount(),
  550.         ]);
  551.     }
  553.     // =========================================================================
  554.     // PRIVATE HELPERS
  555.     // =========================================================================
  557.     /**
  558.      * Returns a fully-keyed formData array with safe defaults.
  559.      * Prevents Twig strict-access errors when the form is blank (create mode).
  560.      */
  561.     private function _emptyFormData()
  562.     {
  563.         return [
  564.             'title'                  => '',
  565.             'description'            => '',
  566.             'note'                   => '',
  567.             'ticketType'             => null,
  568.             'priority'               => 3,
  569.             'source'                 => 1,
  570.             'assignedToUserId'       => null,
  571.             'taggedUserIds'          => '',
  572.             'companyId'              => null,
  573.             'appId'                  => null,
  574.             'branchId'               => null,
  575.             'name'                   => '',
  576.             'email'                  => '',
  577.             'phone'                  => '',
  578.             'preferredContactMethod' => null,
  579.             'deadlineDate'           => '',
  580.             'problemHash'            => '',
  581.             'serverIdentifier'       => '',
  582.             'lastPayloadJson'        => '',
  583.             'errorCode'              => '',
  584.             'feedback'               => '',
  585.         ];
  586.     }
  588.     /**
  589.      * Returns ticket counts grouped by status.
  590.      */
  591.     private function _getStatusSummary($em)
  592.     {
  593.         $rows = $em->createQueryBuilder()
  594.             ->select('t.status, COUNT(t.id) as cnt')
  595.             ->from('CompanyGroupBundle\Entity\EntityTicket', 't')
  596.             ->groupBy('t.status')
  597.             ->getQuery()
  598.             ->getArrayResult();
  600.         $map = ['open' => 0, 'inProgress' => 0, 'resolved' => 0, 'closed' => 0];
  601.         foreach ($rows as $row) {
  602.             switch ((int) $row['status']) {
  603.                 case self::STATUS_OPEN:        $map['open']       = (int) $row['cnt']; break;
  604.                 case self::STATUS_IN_PROGRESS: $map['inProgress'] = (int) $row['cnt']; break;
  605.                 case self::STATUS_RESOLVED:    $map['resolved']   = (int) $row['cnt']; break;
  606.                 case self::STATUS_CLOSED:      $map['closed']     = (int) $row['cnt']; break;
  607.             }
  608.         }
  609.         return $map;
  610.     }
  611. }