Symfony Profiler

<?php
namespace Webkul\UVDesk\CoreFrameworkBundle\Controller;
use Webkul\UVDesk\CoreFrameworkBundle\Entity;
use Webkul\UVDesk\CoreFrameworkBundle\Form;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Webkul\UVDesk\CoreFrameworkBundle\Services\UserService;
use Webkul\UVDesk\CoreFrameworkBundle\Services\UVDeskService;
use Webkul\UVDesk\CoreFrameworkBundle\Services\ReportService;
use Symfony\Contracts\Translation\TranslatorInterface;
use Knp\Component\Pager\PaginatorInterface;
use Doctrine\ORM\Query;
use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketRating;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
class Report extends AbstractController
{
private $userService;
private $reportService;
private $uvdeskService;
private $paginator;
private $translator;
public function __construct(UserService $userService, UVDeskService $uvdeskService,ReportService $reportService, PaginatorInterface $paginator, TranslatorInterface $translator)
{
$this->userService = $userService;
$this->reportService = $reportService;
$this->uvdeskService = $uvdeskService;
$this->paginator = $paginator;
$this->translator = $translator;
}
public function listAgentActivity(Request $request)
{
if (!$this->userService->isAccessAuthorized('ROLE_AGENT_MANAGE_AGENT_ACTIVITY')){
return $this->redirect($this->generateUrl('helpdesk_member_dashboard'));
}
return $this->render('@UVDeskCoreFramework/Reports/listAgentActivities.html.twig', [
'agents' => $this->userService->getAgentsPartialDetails(),
]);
}
public function agentActivityXHR(Request $request)
{
$json = [];
if ($request->isXmlHttpRequest()) {
$json = $this->agentActivityData($request);
}
return new Response(json_encode($json), 200, ['Content-Type' => 'application/json']);
}
public function agentActivityData(Request $request)
{
if (!$this->userService->isAccessAuthorized('ROLE_AGENT_MANAGE_AGENT_ACTIVITY')){
throw new \Exception('Access Denied', 403);
}
$data = [];
$reportService = $this->reportService;
$reportService->parameters = $request->query->all();
$startDate = $reportService->parameters['after'];
$endDate = $reportService->parameters['before'];
$agentIds = [];
if(isset($reportService->parameters['agent']))
$agentIds = explode(',', $reportService->parameters['agent']);
$userService = $this->userService;
$from = $startDate." 00:00:01";
$to = $endDate." 23:59:59";
$reportService->parameters = $request->query->all();
$qb = $reportService->getAgentActivity($agentIds, $from, $to);
$paginator = $this->paginator;
$newQb = clone $qb;
$results = $paginator->paginate(
$qb->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY)->setHint('knp_paginator.count', count($newQb->getQuery()->getResult())),
$request->query->get('page') ?: 1,
20,
array('distinct' => true)
);
$paginationData = $results->getPaginationData();
$queryParameters = $results->getParams();
$queryParameters['page'] = "replacePage";
$paginationData['url'] = '#'.$this->uvdeskService->buildPaginationQuery($queryParameters);
$data = array();
$ticketIds = [];
$agentActivity = [];
$agentIds = [];
foreach ($results as $key => $activity) {
$ticket = $this->getDoctrine()->getManager()->getRepository(Ticket::class)->findOneById($activity['ticketId']);
$currentDateTime = new \DateTime('now');
$activityDateTime = $activity['createdAt'];
$difference = $currentDateTime->getTimeStamp() - $activityDateTime->getTimeStamp();
$lastReply = $reportService->time2string($difference);
$ticketViewURL = $this->get('router')->generate('helpdesk_member_ticket', ['ticketId' => $activity['ticketId']], UrlGeneratorInterface::ABSOLUTE_URL);
$data[] = [
'id' => $activity['id'],
'ticketURL' => $ticketViewURL,
'ticketId' => $activity['ticketId'],
// 'typeId' => $activity['typeId'],
'code' => $activity['code'],
// 'subject' => $activity['subject'],
// 'color' => $activity['colorCode'],
// 'customerName'=> $activity['customerName'],
// 'threadType' => $activity['threadType'],
// 'lastReply' => $lastReply,
// 'agentName' => $activity['agentName']
'fullName' => $activity['fullName'],
'customerName' => $activity['customerName'],
'timeSpent' => $activity['timeSpent'],
'createdAt' => $activity['createdAt'] instanceof \DateTimeInterface
? $activity['createdAt']->format('Y-m-d H:i:s')
: $activity['createdAt'],
];
array_push($ticketIds, $activity['ticketId']);
// array_push($agentIds, $activity['agentId']);
}
// Separate logic to fetch all pagination data without interfering
$allPaginatedData = []; // Variable to store data from all pages
$totalPages = $paginationData['pageCount']; // Total number of pages
for ($currentPage = 1; $currentPage <= $totalPages; $currentPage++) {
$paginatedResults = $paginator->paginate(
$qb->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY),
$currentPage,
20,
['distinct' => true]
);
foreach ($paginatedResults as $activity) { $ticketViewURL = $this->get('router')->generate(
'helpdesk_member_ticket',
['ticketId' => $activity['ticketId']],
UrlGeneratorInterface::ABSOLUTE_URL
);
$allPaginatedData[] = [
'id' => $activity['id'],
'ticketURL' => $ticketViewURL,
'ticketId' => $activity['ticketId'],
// 'typeId' => $activity['typeId'],
// 'ticketTypeCode' => $activity['ticketTypeCode'],
// 'subject' => $activity['subject'],
// 'color' => $activity['colorCode'],
// 'customerName'=> $activity['customerName'],
// 'threadType' => $activity['threadType'],
// 'lastReply' => $lastReply,
// 'agentName' => $activity['agentName']
'code' => $activity['code'],
'fullName' => $activity['fullName'],
'customerName' => $activity['customerName'],
'timeSpent' => $activity['timeSpent'],
'createdAt' => $activity['createdAt'] instanceof \DateTimeInterface
? $activity['createdAt']->format('Y-m-d H:i:s')
: $activity['createdAt'],
];
}
}
$threadDetails = $reportService->getTotalReplies(array_unique($ticketIds), $agentIds, $from, $to);
foreach ($data as $index => $ticketDetail) {
foreach ($threadDetails as $detail) {
if ($detail['ticketId'] == $ticketDetail['ticketId']) {
$data[$index]['totalReply'] = $detail['ticketCount'];
}
}
}
$agentActivity = [];
//$request->getSession()->set('agentActivity', $agentActivity); // Store in session
$agentActivity['data'] = $data;
$agentActivity['allPaginatedData'] = $allPaginatedData;
$agentActivity['pagination_data'] = $paginationData;
$request->getSession()->set('agentActivity', $agentActivity);
return $agentActivity;
}
public function exportAgentActivity(Request $request): Response
{
ob_start(); // Start output buffering
// Retrieve agent activity data from the session
$agentActivity = $request->getSession()->get('agentActivity', []);
// Check if data is empty
if (empty($agentActivity) || empty($agentActivity['allPaginatedData'])) {
return new Response('No data available to export', 404);
}
// Extract the data array from session data
$data = $agentActivity['allPaginatedData'];
// Create a new Spreadsheet object
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
// Extract headers dynamically from the first data row
$headers = array_keys(reset($data));
// Set the header row
$col = 'A';
foreach ($headers as $header) {
$sheet->setCellValue($col . '1', $header);
$col++;
}
// Fill the data rows
$row = 2;
foreach ($data as $rowData) {
$col = 'A';
foreach ($headers as $header) {
$value = $rowData[$header] ?? ''; // Use empty string if value is not set
$sheet->setCellValue($col . $row, $value);
$col++;
}
$row++;
}
// Generate and return the Excel file
$writer = new Xlsx($spreadsheet);
$filename = 'agentActivity.xlsx';
$response = new Response();
$response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
$response->headers->set('Content-Disposition', 'attachment; filename="' . $filename . '"');
$response->headers->set('Cache-Control', 'max-age=0');
$writer->save('php://output');
return $response;
}
public function achievementInsightsAction()
{
$this->userService->forceFormat = true;
$startDate = $this->userService->convertToTimezone(new \DateTime("-7 days"), 'Y-m-d');
$endDate = $this->userService->convertToTimezone(new \DateTime("now"), 'Y-m-d');
$this->userService->forceFormat = false;
return $this->render('@UVDeskCoreFramework/Reports/kudos-insights.html.twig',array(
'startDate' => $startDate,
'endDate' => $endDate
)
);
}
public function getAchievementsXhr(Request $request, ContainerInterface $container)
{
$json = array();
if( $request->isXmlHttpRequest()) {
$repository = $this->getDoctrine()->getRepository(TicketRating::class);
$json = $repository->getRatedTicketList($request->query, $container);
$json['data'] = $this->getAchievementsData($request, $container);
}
$response = new Response(json_encode($json));
$response->headers->set('Content-Type', 'application/json');
return $response;
}
public function getAchievementsData($request, $container)
{
$data = array();
$reportService = $this->reportService;
$reportService->parameters = $request->query->all();
$startDate = $reportService->parameters['start'];
$endDate = $reportService->parameters['end'];
$reportService->startDate = $this->userService->convertToTimezone(new \DateTime($startDate),'Y-m-d H:i:s');
$reportService->endDate = $this->userService->convertToTimezone(new \DateTime($endDate),'Y-m-d H:i:s');
$repository = $this->getDoctrine()->getRepository(TicketRating::class);
$data = $repository->getRatingData($request->query, $container);
for ($i = 1; $i <= 5; $i++) {
$data['ratings'][$i] = $repository->getRatingByStarCount($request->query, $i, $container);
}
return $data;
}
}

vendor/uvdesk/core-framework/Controller/Report.php line 44