vendor/uvdesk/core-framework/Services/UserService.php line 78

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Services;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Twig\Environment as TwigEnvironment;
  7. use Doctrine\Common\Collections\Criteria;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\RequestStack;
  10. use Symfony\Component\Filesystem\Filesystem as Fileservice;
  11. use Symfony\Component\DependencyInjection\ContainerInterface;
  12. use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
  13. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportRole;
  14. use Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance;
  15. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket;
  16. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportPrivilege;
  17. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup;
  18. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam;
  19. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SavedReplies;
  20. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Website;
  21. use Webkul\UVDesk\CoreFrameworkBundle\Workflow\Events as CoreWorkflowEvents;
  22. use Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite;
  24. class UserService
  25. {
  26.     protected $container;
  27.     protected $requestStack;
  28.     protected $entityManager;
  29.     protected $twig;
  31.     public function __construct(ContainerInterface $container, RequestStack $requestStack, EntityManagerInterface $entityManager, TwigEnvironment $twig)
  32.     {
  33.         $this->container = $container;
  34.         $this->requestStack = $requestStack;
  35.         $this->entityManager = $entityManager;
  36.         $this->twig = $twig;
  37.     }
  39.     public function getCustomFieldTemplateCustomer()
  40.     {
  41.         $request = $this->requestStack->getCurrentRequest();
  42.         $ticket = $this->entityManager->getRepository(Ticket::class)->findOneById($request->attributes->get('id'));
  44.         try {
  45.             if ($this->isFileExists('apps/uvdesk/custom-fields')) {
  46.                 $customFieldsService = $this->container->get('uvdesk_package_custom_fields.service');
  47.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_custom_fields';
  48.             } else if ($this->isFileExists('apps/uvdesk/form-component')) {
  49.                 $customFieldsService = $this->container->get('uvdesk_package_form_component.service');
  50.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_form_component';
  51.             }
  52.         } catch (\Exception $e) {
  53.             // @TODO: Log execption message
  54.         }
  56.         $customerCustomFieldSnippet = !empty($customFieldsService) ? $customFieldsService->getCustomerCustomFieldSnippet($ticket) : [];
  58.         if (!empty($registeredBaseTwigPath) && sizeof($customerCustomFieldSnippet["customFieldCollection"]) > 0) {
  59.             return $this->twig->render('@' . $registeredBaseTwigPath . '/widgets/CustomFields/customFieldSnippetCustomer.html.twig', $customerCustomFieldSnippet);
  60.         }
  62.         return;
  63.     }
  65.     public function isGranted($role)
  66.     {
  67.         $securityContext = $this->container->get('security.token_storage');
  69.         try {
  70.             return (bool) ($role == $securityContext->getToken()->getRoles()[0]->getRole());
  71.         } catch (AuthenticationCredentialsNotFoundException $e) {
  72.             // @TODO: Handle Authentication Failure
  73.         }
  75.         return false;
  76.     }
  78.     public function getSessionUser()
  79.     {
  80.         $user = $this->container->get('security.token_storage')->getToken()?->getUser();
  82.         return $user instanceof User ? $user : null;
  83.     }
  85.     public function getCurrentUser()
  86.     {
  87.         if ($this->container->get('security.token_storage')->getToken()) {
  88.             return $this->container->get('security.token_storage')->getToken()?->getUser();
  89.         } else {
  90.             return false;
  91.         }
  92.     }
  94.     public function getCountries()
  95.     {
  96.         return $this->helpdeskCountries = \Symfony\Component\Intl\Countries::getNames();
  97.     }
  99.     public function isAccessAuthorized($scope, User $user = null)
  100.     {
  101.         // Return false if no user is provided
  102.         if (empty($user) && !($user = $this->getSessionUser())) {
  103.             return false;
  104.         }
  106.         try {
  107.             $userRole = $user?->getCurrentInstance()?->getSupportRole()->getCode();
  108.         } catch (\Exception $error) {
  109.             $userRole = '';
  110.         }
  112.         switch ($userRole) {
  113.             case 'ROLE_SUPER_ADMIN':
  114.             case 'ROLE_ADMIN':
  115.                 return true;
  116.             case 'ROLE_AGENT':
  117.                 $agentPrivileges = $this->getUserPrivileges($this->getCurrentUser()?->getId());
  118.                 $agentPrivileges = array_merge($agentPrivileges, ['saved_filters_action', 'saved_replies']);
  120.                 return in_array($scope, $agentPrivileges) ? true : false;
  121.             case 'ROLE_CUSTOMER':
  122.             default:
  123.                 break;
  124.         }
  126.         return true;
  127.     }
  129.     public function getUserPrivileges($userId)
  130.     {
  131.         static $agentPrivilege = [];
  133.         if (isset($agentPrivilege[$userId])) {
  134.             return $agentPrivilege[$userId];
  135.         }
  137.         $userPrivileges = array();
  138.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  139.         $privileges = $user->getAgentInstance()->getSupportPrivileges();
  141.         if ($privileges) {
  142.             foreach ($privileges as $privilege) {
  143.                 $userPrivileges = array_merge($userPrivileges, $privilege->getPrivileges());
  144.             }
  145.         }
  147.         $agentPrivilege[$userId] = $this->agentPrivilege[$userId] = $userPrivileges;
  149.         return $userPrivileges;
  150.     }
  152.     public function getSupportPrivileges()
  153.     {
  154.         $qb = $this->entityManager->createQueryBuilder();
  155.         $qb->select("supportPrivilege")->from(SupportPrivilege::class, 'supportPrivilege');
  157.         return $qb->getQuery()->getArrayResult();
  158.     }
  160.     public function getSupportGroups(Request $request = null)
  161.     {
  162.         static $results;
  163.         if (null !== $results)
  164.             return $results;
  165.         $qb = $this->entityManager->createQueryBuilder();
  166.         $qb->select('supportGroup.id, supportGroup.name')->from(SupportGroup::class, 'supportGroup')
  167.             ->andWhere('supportGroup.isActive = 1');
  168.         if ($request) {
  169.             $qb->andWhere("supportGroup.name LIKE :groupName");
  170.             $qb->setParameter('groupName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  171.             $qb->andWhere("supportGroup.id NOT IN (:ids)");
  172.             $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  173.         }
  175.         return $results = $qb->getQuery()->getArrayResult();
  176.     }
  178.     public function getSupportTeams(Request $request = null)
  179.     {
  180.         static $results;
  181.         if (null !== $results)
  182.             return $results;
  184.         $queryBuilder = $this->entityManager->createQueryBuilder()
  185.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) as name, userInstance.profileImagePath as smallThumbnail")
  186.             ->from(User::class, 'user')
  187.             ->leftJoin('user.userInstance', 'userInstance')
  188.             ->leftJoin('userInstance.supportRole', 'supportRole')
  189.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  190.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  191.             ->orderBy('name', Criteria::ASC);
  193.         if ($request && null != $request->query->get('query')) {
  194.             $queryBuilder
  195.                 ->andWhere("CONCAT(dt.firstName,' ', dt.lastName) LIKE :customerName")
  196.                 ->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  197.         }
  199.         $qb = $this->entityManager->createQueryBuilder();
  200.         $qb->select('supportTeam.id, supportTeam.name')
  201.             ->from(SupportTeam::class, 'supportTeam');
  202.         $qb->andWhere('supportTeam.isActive = 1');
  204.         if ($request) {
  205.             $qb->andWhere("supportTeam.name LIKE :subGroupName");
  206.             $qb->setParameter('subGroupName', '%' . urldecode($request->query->get('query')) . '%');
  207.             $qb->andWhere("supportTeam.id NOT IN (:ids)");
  208.             $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  209.         }
  211.         return $results = $qb->getQuery()->getResult();
  212.     }
  214.     public function createUserInstance($email, $name, SupportRole $role, array $extras = [])
  215.     {
  216.         $user = $this->entityManager->getRepository(User::class)->findOneByEmail($email) ?: new User();
  218.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  219.         $timeZone = $website->getTimezone();
  220.         $timeFormat = $website->getTimeformat();
  222.         if (null == $user->getId()) {
  223.             $name = explode(' ', trim($name));
  225.             $user->setEmail($email);
  226.             $user->setFirstName(isset($extras['firstName']) ? $extras['firstName'] : array_shift($name));
  227.             $user->setLastName(trim(implode(' ', $name)));
  228.             $user->setIsEnabled($extras['active']);
  229.             $user->setTimeZone($timeZone);
  230.             $user->setTimeFormat($timeFormat);
  232.             $this->entityManager->persist($user);
  233.             $this->entityManager->flush();
  234.         }
  236.         $userInstance = 'ROLE_CUSTOMER' == $role->getCode() ? $user->getCustomerInstance() : $user->getAgentInstance();
  238.         if (empty($userInstance)) {
  239.             $userInstance = new UserInstance();
  241.             $userInstance->setUser($user);
  242.             $userInstance->setSupportRole($role);
  243.             $userInstance->setContactNumber(!empty($extras['contact']) ? $extras['contact'] : null);
  244.             $userInstance->setSkypeId(!empty($extras['skype']) ? $extras['skype'] : null);
  245.             $userInstance->setDesignation(!empty($extras['designation']) ? $extras['designation'] : null);
  246.             $userInstance->setSignature(!empty($extras['signature']) ? $extras['signature'] : null);
  248.             $userInstance->setSource(!empty($extras['source']) ? $extras['source'] : 'website');
  249.             $userInstance->setIsActive(!empty($extras['active']) ? (bool) $extras['active'] : false);
  250.             $userInstance->setIsVerified(!empty($extras['verified']) ? (bool) $extras['verified'] : false);
  251.             $userInstance->setIsStarred(!empty($extras['starred']) ? (bool) $extras['starred'] : false);
  253.             if (!empty($extras['image'])) {
  254.                 $assetDetails = $this->container->get('uvdesk.core.file_system.service')->getUploadManager()->uploadFile($extras['image'], 'profile');
  256.                 if (!empty($assetDetails)) {
  257.                     $userInstance->setProfileImagePath($assetDetails['path']);
  258.                 }
  259.             }
  261.             $this->entityManager->persist($userInstance);
  262.             $this->entityManager->flush();
  264.             $user->addUserInstance($userInstance);
  266.             // Trigger user created event
  267.             $event = $role->getCode() == 'ROLE_CUSTOMER' ? new CoreWorkflowEvents\Customer\Create() : new CoreWorkflowEvents\Agent\Create();
  268.             $event
  269.                 ->setUser($user);
  271.             $this->container->get('event_dispatcher')->dispatch($event, 'uvdesk.automation.workflow.execute');
  272.         }
  274.         return $user;
  275.     }
  277.     public function getAgentPartialDataCollection(Request $request = null)
  278.     {
  279.         $queryBuilder = $this->entityManager->createQueryBuilder()
  280.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', COALESCE(user.lastName, '')) as name, userInstance.profileImagePath as smallThumbnail, userInstance.isOnline")
  281.             ->from(User::class, 'user')
  282.             ->leftJoin('user.userInstance', 'userInstance')
  283.             ->leftJoin('userInstance.supportRole', 'supportRole')
  284.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  285.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  286.             ->orderBy('name', Criteria::ASC);
  288.         if ($request && null != $request->query->get('query')) {
  289.             $queryBuilder
  290.                 ->andWhere("CONCAT(user.firstName,' ', user.lastName) LIKE :customerName")
  291.                 ->setParameter('customerName', '%' . urldecode($request->query->get('query')) . '%')
  292.             ;
  293.         }
  295.         if ($request && null != $request->query->get('not')) {
  296.             $queryBuilder
  297.                 ->andWhere("u.id NOT IN (:ids)")
  298.                 ->setParameter('ids', explode(',', urldecode($request->query->get('not'))))
  299.             ;
  300.         }
  302.         return $queryBuilder->getQuery()->getArrayResult();
  303.     }
  305.     public function getAgentsPartialDetails(Request $request = null)
  306.     {
  307.         static $agents;
  309.         if (null !== $agents) {
  310.             return $agents;
  311.         }
  313.         $qb = $this->entityManager->createQueryBuilder();
  314.         $qb
  315.             ->select("u.id, userInstance.id as udId,u.email,CONCAT(u.firstName,' ', u.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  316.             ->from(User::class, 'u')
  317.             ->leftJoin('u.userInstance', 'userInstance')
  318.             ->andWhere('userInstance.supportRole != :roles')
  319.             ->setParameter('roles', 4)
  320.             ->andWhere('userInstance.isActive = 1')
  321.             ->orderBy('name', 'ASC')
  322.         ;
  324.         if ($request) {
  325.             $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  326.             $qb->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  327.             $qb->andWhere("u.id NOT IN (:ids)");
  328.             $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  329.         }
  331.         $data = $agents = $qb->getQuery()->getArrayResult();
  333.         return $data;
  334.     }
  336.     public function getAgentDetailById($agentId)
  337.     {
  338.         if (!$agentId) {
  339.             return;
  340.         }
  342.         $qb = $this->entityManager->createQueryBuilder();
  343.         $qb
  344.             ->select("DISTINCT u.id,u.email,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, u.firstName,u.lastName, u.isEnabled, userInstance.profileImagePath, userInstance.profileImagePath as smallThumbnail,userInstance.isActive, userInstance.isVerified, userInstance.designation, userInstance.contactNumber, userInstance.signature, userInstance.ticketAccessLevel, userInstance.isOnline")
  345.             ->from(User::class, 'u')
  346.             ->leftJoin('u.userInstance', 'userInstance')
  347.             ->andWhere('userInstance.supportRole != :roles')
  348.             ->andWhere('u.id = :agentId')
  349.             ->setParameter('roles', 4)
  350.             ->setParameter('agentId', $agentId)
  351.         ;
  353.         $result = $qb->getQuery()->getResult();
  355.         return isset($result[0]) ? $result[0] : null;
  356.     }
  358.     public function getUsersByGroupId($groupId)
  359.     {
  360.         $qb = $this->entityManager->createQueryBuilder();
  361.         $qb->select("DISTINCT user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) AS name, userInstance.profileImagePath as smallThumbnail")
  362.             ->from(User::class, 'user')
  363.             ->leftJoin('user.userInstance', 'userInstance')
  364.             ->leftJoin('userInstance.supportGroups', 'supportGroup')
  365.             ->andWhere('userInstance.supportRole != :roles')->setParameter('roles', 4)
  366.             ->andWhere('supportGroup.id = :groupId')->setParameter('groupId', $groupId)
  367.             ->andWhere('userInstance.isActive = 1')
  368.         ;
  370.         $data = $qb->getQuery()->getArrayResult();
  372.         return $data;
  373.     }
  375.     public function getUsersBySubGroupId($subGroupId)
  376.     {
  377.         $qb = $this->entityManager->createQueryBuilder();
  378.         $qb->select("DISTINCT user.id, supportTeam.id as udId,user.email,CONCAT(user.firstName,' ', user.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  379.             ->from(User::class, 'user')
  380.             ->leftJoin('user.userInstance', 'userInstance')
  381.             ->leftJoin('userInstance.supportTeams', 'supportTeam')
  382.             ->andWhere('userInstance.supportRole != :roles')
  383.             ->andWhere('supportTeam.id = :subGroupId')
  384.             ->setParameter('roles', 4)
  385.             ->setParameter('subGroupId', $subGroupId)
  386.             ->andWhere('supportTeam.isActive = 1')
  387.             ->andWhere('userInstance.isActive = 1');
  389.         $data = $qb->getQuery()->getArrayResult();
  391.         return $data;
  392.     }
  394.     public function getCustomerDetailsById($customerId)
  395.     {
  396.         $qb = $this->entityManager->createQueryBuilder();
  397.         $qb->select("user.id,user.email,CONCAT(user.firstName,' ', COALESCE(user.lastName,'')) AS name,user.firstName,user.lastName,user.isEnabled,userInstance.contactNumber,userInstance.profileImagePath,userInstance.profileImagePath as smallThumbnail,userInstance.isActive, userInstance.isVerified")->from(User::class, 'user')
  398.             ->leftJoin('user.userInstance', 'userInstance')
  399.             ->andWhere('userInstance.supportRole = :roles')
  400.             ->andWhere('user.id = :customerId')
  401.             ->setParameter('roles', 4)
  402.             ->setParameter('customerId', $customerId);
  404.         $result = $qb->getQuery()->getResult();
  406.         return ($result ? $result[0] : null);
  407.     }
  409.     public function getCustomerPartialDetailById($customerId)
  410.     {
  411.         $qb = $this->entityManager->createQueryBuilder();
  412.         $qb->select("u.id,u.email,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name,u.firstName,u.lastName,userInstance.contactNumber,userInstance.profileImagePath,userInstance.profileImagePath as smallThumbnail")->from(User::class, 'u')
  413.             ->leftJoin('u.userInstance', 'userInstance')
  414.             ->andWhere('userInstance.supportRole = :roles')
  415.             ->andWhere('u.id = :customerId')
  416.             ->setParameter('roles', 4)
  417.             ->setParameter('customerId', $customerId);
  419.         $result = $qb->getQuery()->getResult();
  421.         return $result ? $result[0] : null;
  422.     }
  424.     public function getCustomersPartial(Request $request = null)
  425.     {
  426.         $qb = $this->entityManager->createQueryBuilder();
  427.         $qb->from(User::class, 'u');
  429.         $qb->select("DISTINCT u.id,u.email,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, userInstance.profileImagePath as smallThumbnail ")
  430.             ->leftJoin('u.userInstance', 'userInstance')
  431.             ->andWhere('userInstance.supportRole = :roles')
  432.             ->setParameter('roles', 4)
  433.             ->orderBy('name', 'ASC');
  435.         if ($request) {
  436.             if ($request->query->get('query')) {
  437.                 $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName OR u.email LIKE :customerName");
  438.             } else {
  439.                 $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  440.             }
  442.             $qb->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%')
  443.                 ->andWhere("u.id NOT IN (:ids)")
  444.                 ->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  445.         }
  447.         $query = $qb->getQuery();
  449.         return $query->getScalarResult();
  450.     }
  452.     public function getCustomersCount()
  453.     {
  454.         $qb = $this->entityManager->createQueryBuilder();
  455.         $qb->select($qb->expr()->countDistinct('c.id') . "as customerCount")->from(Ticket::class, 't')
  456.             ->leftJoin('t.customer', 'c');
  458.         $this->entityManager->getRepository(Ticket::class)->addPermissionFilter($qb, $this->container, false);
  460.         return $qb->getQuery()->getSingleScalarResult();
  461.     }
  463.     public function getUserSubGroupIds($userId)
  464.     {
  465.         $qb = $this->entityManager->createQueryBuilder();
  466.         $qb->select('supportTeams.id')->from(User::class, 'user')
  467.             ->leftJoin('user.userInstance', 'userInstance')
  468.             ->leftJoin('userInstance.supportTeams', 'supportTeams')
  469.             ->andWhere('user.id = :userId')
  470.             ->andWhere('userInstance.supportRole != :agentRole')
  471.             ->andWhere('supportTeams.isActive = 1')
  472.             ->setParameter('userId', $userId)
  473.             ->setParameter('agentRole', '4');
  475.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  476.     }
  478.     public function getUserGroupIds($userId)
  479.     {
  480.         $qb = $this->entityManager->createQueryBuilder();
  481.         $qb->select('supportGroup.id')->from(User::class, 'user')
  482.             ->leftJoin('user.userInstance', 'userInstance')
  483.             ->leftJoin('userInstance.supportGroups', 'supportGroup')
  484.             ->andWhere('user.id = :userId')
  485.             ->andWhere('supportGroup.isActive = 1')
  486.             ->setParameter('userId', $userId);
  488.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  489.     }
  491.     public function createUser($data)
  492.     {
  493.         $user = new User();
  494.         $user->setEmail($data['from']);
  495.         $user->setFirstName($data['firstName']);
  496.         $user->setLastName($data['lastName']);
  497.         $user->setIsEnabled($data['isActive']);
  498.         $this->entityManager->persist($user);
  500.         $role = $this->entityManager->getRepository(SupportRole::class)->find($data['role']);
  502.         $userInstance = new UserInstance();
  503.         $userInstance->setSupportRole($role);
  504.         $userInstance->setUser($user);
  505.         $userInstance->setIsActive($data['isActive']);
  506.         $userInstance->setIsVerified(0);
  508.         if (isset($data['source']))
  509.             $userInstance->setSource($data['source']);
  510.         else
  511.             $userInstance->setSource('website');
  513.         if (isset($data['contactNumber'])) {
  514.             $userInstance->setContactNumber($data['contactNumber']);
  515.         }
  517.         if (isset($data['profileImage']) && $data['profileImage']) {
  518.             $userInstance->setProfileImagePath($data['profileImage']);
  519.         }
  521.         $this->entityManager->persist($userInstance);
  522.         $this->entityManager->flush();
  524.         $user->addUserInstance($userInstance);
  526.         $this->entityManager->persist($user);
  527.         $this->entityManager->flush();
  529.         return $user;
  530.     }
  532.     public function getWebsiteConfiguration($code)
  533.     {
  534.         $enabled_bundles = $this->container->getParameter('kernel.bundles');
  536.         if (!in_array('UVDeskSupportCenterBundle', array_keys($enabled_bundles))) {
  537.             return [
  538.                 'id'                        =>  1,
  539.                 'website'                   =>  1,
  540.                 'status'                    =>  1,
  541.                 'brandColor'                => '#0056fc',
  542.                 'pageBackgroundColor'       => '#FFFFFF',
  543.                 'headerBackgroundColor'     => '#FFFFFF',
  544.                 'bannerBackgroundColor'     => '#7085F4',
  545.                 'navTextColor'              =>  '#7085F4',
  546.                 'navActiveColor'            => '#7085F4',
  547.                 'linkColor'                 => '#7085F4',
  548.                 'linkHoverColor'            => '#7085F4',
  549.                 'headerLinks'               => null,
  550.                 'footerLinks'               => null,
  551.                 'articleTextColor'          => '#7085F4',
  552.                 'whiteList'                 => null,
  553.                 'blackList'                 => null,
  554.                 'siteDescritption'          => 'Hi! how can i help you.',
  555.                 'metaDescription'           => null,
  556.                 'metaKeywords'              => null,
  557.                 'homepageContent'           => null,
  558.                 'ticketCreateOption'        =>  1,
  559.                 'createdAt'                 =>  '2024-09-21 16:20:01',
  560.                 'updatedat'                 =>  '2024-09-21 16:20:01',
  561.                 'broadcastMessage'          => null,
  562.                 'removeCustomerLoginButton' => null,
  563.                 'disableCustomerlogin'      =>  0,
  564.                 'removeBrandingContent'     => null,
  565.                 'loginRequiredToCreate'     => null,
  566.                 'script'                    => null,
  567.                 'customCss'                 => null,
  568.                 'isActive'                  => 1,
  569.             ];
  570.         }
  572.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  574.         if ($website) {
  575.             $configuration = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy([
  576.                 'website'  => $website->getId(),
  577.                 'isActive' => 1
  578.             ]);
  579.         }
  581.         return !empty($configuration) ? $configuration : false;
  582.     }
  584.     public function getWebsiteDetails($code)
  585.     {
  586.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  588.         return !empty($website) ? $website : false;
  589.     }
  591.     public function convertToTimezone($date, $format = "d-m-Y H:ia")
  592.     {
  593.         if (!$date) {
  594.             return "N/A";
  595.         }
  597.         $date = date_format($date, $format);
  598.         $dateTime = date('Y-m-d H:i:s', strtotime($date));
  600.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  601.         $scheduleDate
  602.             ->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  604.         return $scheduleDate->format($format);
  605.     }
  607.     public function convertDateTimeToSupportedUserTimeFormat(\DateTime $date, $timezone = "Asia/Kolkata", $timeformat = "d-m-Y H:ia")
  608.     {
  609.         if (empty($date)) {
  610.             return "N/A";
  611.         }
  613.         $currentUser = $this->getCurrentUser();
  615.         if (!empty($currentUser)) {
  616.             if ($currentUser->getTimezone() != null) {
  617.                 $timezone = $currentUser->getTimezone();
  618.             }
  620.             if ($currentUser->getTimeFormat() != null) {
  621.                 $timeformat = $currentUser->getTimeFormat();
  622.             }
  623.         }
  625.         $date
  626.             ->setTimeZone(new \DateTimeZone($timezone));
  628.         return $date->format($timeformat);
  629.     }
  631.     public function convertToDatetimeTimezoneTimestamp($date, $format = "d-m-Y h:ia")
  632.     {
  633.         if (!$date)
  634.             return "N/A";
  635.         $currentUser = $this->getCurrentUser();
  636.         $date = date_format($date, $format);
  637.         $dateTime = date('Y-m-d H:i:s', strtotime($date));
  638.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  639.         $this->domain = $this->container->get('router')->getContext()->getHost();
  641.         $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  643.         return $scheduleDate->getTimestamp();
  644.     }
  646.     public function removeCustomer($customer)
  647.     {
  648.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $customer->getId()));
  650.         $count = count($userData);
  651.         $ticketData = $this->entityManager->getRepository(Ticket::class)->findBy(array('customer' => $customer->getId()));
  653.         $fileService = new Fileservice();
  654.         // Delete all tickets attachments.
  655.         if ($ticketData) {
  656.             foreach ($ticketData as $ticket) {
  657.                 $threads = $ticket->getThreads();
  658.                 if (count($threads) > 0) {
  659.                     foreach ($threads as $thread) {
  660.                         if (!empty($thread)) {
  661.                             $fileService->remove($this->container->getParameter('kernel.project_dir') . '/public/assets/threads/' . $thread->getId());
  662.                         }
  663.                     }
  664.                 }
  665.             }
  666.         }
  668.         // Remove profile.
  669.         foreach ($userData as $user) {
  670.             if ($user->getSupportRole()->getId() == 4 && $user->getProfileImagePath()) {
  671.                 $fileService->remove($this->container->getParameter('kernel.project_dir') . '/public' . $user->getProfileImagePath());
  672.             }
  673.         }
  675.         // getCustomerTickets
  676.         $qb = $this->entityManager->createQueryBuilder();
  677.         $query = $qb->delete(Ticket::class, 't')
  678.             ->andWhere('t.customer = :customerId')
  679.             ->setParameter('customerId', $customer->getId())
  680.             ->getQuery();
  682.         $query->execute();
  684.         $qb = $this->entityManager->createQueryBuilder();
  685.         $query = $qb->delete(UserInstance::class, 'userInstance')
  686.             ->andWhere('userInstance.user = :customerId')
  687.             ->andWhere('userInstance.supportRole = :roleId')
  688.             ->setParameter('customerId', $customer->getId())
  689.             ->setParameter('roleId', 4)
  690.             ->getQuery();
  692.         $query->execute();
  694.         if ($count == 1) {
  695.             $this->entityManager->remove($customer);
  696.             $this->entityManager->flush();
  697.         }
  698.     }
  700.     public function removeAgent($user)
  701.     {
  702.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $user->getId()));
  703.         $count = count($userData);
  705.         $qb = $this->entityManager->createQueryBuilder();
  706.         $query = $qb->delete(UserInstance::class, 'ud')
  707.             ->andWhere('ud.user = :userId')
  708.             ->andWhere('ud.supportRole = :roleId')
  709.             ->setParameter('userId', $user->getId())
  710.             ->setParameter('roleId', 3)
  711.             ->getQuery();
  713.         $query->execute();
  715.         foreach ($user->getAgentInstance()->getSupportGroups() as $group) {
  716.             $user->getAgentInstance()->removeSupportGroup($group);
  717.             $this->entityManager->persist($group);
  718.             $this->entityManager->flush();
  719.         }
  721.         $qb = $this->entityManager->createQueryBuilder();
  722.         $query = $qb->update(Ticket::class, 't')
  723.             ->set('t.agent', ':nullAgent')
  724.             ->andWhere('t.agent = :agentId')
  725.             ->setParameter('agentId', $user->getId())
  726.             ->setParameter('nullAgent', null)
  727.             ->getQuery();
  729.         $query->execute();
  731.         if ($count == 1) {
  732.             $this->entityManager->remove($user);
  733.             $this->entityManager->flush();
  734.         }
  735.     }
  737.     public function getWebsiteView()
  738.     {
  739.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  740.         $layout  = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website' => $website->getId()]);
  742.         $homepageContent = $layout->getHomepageContent();
  744.         return (!empty($homepageContent)) ? $homepageContent . 'View' : 'masonryView';
  745.     }
  747.     public function getUserDetailById($userId)
  748.     {
  749.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  750.         foreach ($user->getUserInstance() as $row) {
  751.             if ($row->getSupportRole()->getId() != 4)
  752.                 return $row;
  753.         }
  755.         return null;
  756.     }
  758.     public function getUserPrivilegeIds($userId)
  759.     {
  760.         $qb = $this->entityManager->createQueryBuilder();
  761.         $qb
  762.             ->select('supportPrivileges.id')
  763.             ->from(User::class, 'user')
  764.             ->leftJoin('user.userInstance', 'userInstance')
  765.             ->leftJoin('userInstance.supportPrivileges', 'supportPrivileges')
  766.             ->andWhere('user.id = :userId')
  767.             ->setParameter('userId', $userId)
  768.         ;
  770.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  771.     }
  773.     public function getWebsiteSpamDetails($websiteSpam)
  774.     {
  775.         $blackList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getBlackList()));
  776.         $whiteList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getWhiteList()));
  778.         return [
  779.             'blackList' => $this->filterBlockSpam($blackList),
  780.             'whiteList' => $this->filterBlockSpam($whiteList),
  781.         ];
  782.     }
  784.     public function filterBlockSpam($str)
  785.     {
  786.         $list = array();
  787.         foreach (explode(',', $str) as $value) {
  788.             if (filter_var($value, FILTER_VALIDATE_EMAIL)) {
  789.                 if (!isset($list['email'])) {
  790.                     $list['email'] = array();
  791.                 }
  793.                 array_push($list['email'], strtolower($value));
  794.             } else if (filter_var($value, FILTER_VALIDATE_IP)) {
  795.                 if (!isset($list['ip'])) {
  796.                     $list['ip'] = array();
  797.                 }
  799.                 array_push($list['ip'], $value);
  800.             } else if (isset($value[0]) && $value[0] == '@') {
  801.                 if (!isset($list['domain'])) {
  802.                     $list['domain'] = array();
  803.                 }
  805.                 array_push($list['domain'], strtolower($value));
  806.             }
  807.         }
  809.         return $list;
  810.     }
  812.     // @TODO: Refactor this - We can instead just use \DateTimeZone::listIdentifiers() wherever need be.
  813.     public function getTimezones()
  814.     {
  815.         return \DateTimeZone::listIdentifiers();
  816.     }
  818.     public function getUserSavedReplyReferenceIds()
  819.     {
  820.         // @TODO: Refactor this function
  821.         $savedReplyIds = [];
  822.         $groupIds = [];
  823.         $teamIds = [];
  824.         $userInstance = $this->getCurrentUser()->getAgentInstance();
  825.         $userId = $userInstance->getId();
  827.         // Get all the saved reply the current user has created.
  828.         $savedReplyRepo = $this->entityManager->getRepository(SavedReplies::class)->findAll();
  830.         if (in_array($userInstance->getSupportRole()->getCode(), ['ROLE_ADMIN', "ROLE_SUPER_ADMIN"])) {
  831.             // If the user is admin or super admin, return all saved replies.
  832.             foreach ($savedReplyRepo as $sr) {
  833.                 array_push($savedReplyIds, (int)$sr->getId());
  834.             }
  836.             return $savedReplyIds;
  837.         }
  839.         foreach ($savedReplyRepo as $sr) {
  840.             if ($userId == $sr->getUser()->getId()) {
  841.                 //Save the ids of the saved reply.
  842.                 array_push($savedReplyIds, (int)$sr->getId());
  843.             }
  844.         }
  846.         // Get the ids of the Group(s) the current user is associated with.
  847.         $query = "select * from uv_user_support_groups where userInstanceId =" . $userId;
  848.         $connection = $this->entityManager->getConnection();
  849.         $stmt = $connection->prepare($query);        
  850.         $result = $stmt->executeQuery()->fetchAllAssociative();
  852.         foreach ($result as $row) {
  853.             array_push($groupIds, $row['supportGroupId']);
  854.         }
  856.         // Get all the saved reply's ids that is associated with the user's group(s).
  857.         $query = "select * from uv_saved_replies_groups";
  858.         $stmt = $connection->prepare($query);
  859.         $result = $stmt->executeQuery()->fetchAllAssociative();
  861.         foreach ($result as $row) {
  862.             if (in_array($row['group_id'], $groupIds)) {
  863.                 array_push($savedReplyIds, (int) $row['savedReply_id']);
  864.             }
  865.         }
  867.         // Get the ids of the Team(s) the current user is associated with.
  868.         $query = "select * from uv_user_support_teams";
  869.         $connection = $this->entityManager->getConnection();
  870.         $stmt = $connection->prepare($query);
  871.         $result = $stmt->executeQuery()->fetchAllAssociative();
  873.         foreach ($result as $row) {
  874.             if ($row['userInstanceId'] == $userId) {
  875.                 array_push($teamIds, $row['supportTeamId']);
  876.             }
  877.         }
  879.         $query = "select * from uv_saved_replies_teams";
  880.         $stmt = $connection->prepare($query);
  881.         $result = $stmt->executeQuery()->fetchAllAssociative();
  883.         foreach ($result as $row) {
  884.             if (in_array($row['subgroup_id'], $teamIds)) {
  885.                 array_push($savedReplyIds, (int)$row['savedReply_id']);
  886.             }
  887.         }
  889.         return $savedReplyIds;
  890.     }
  892.     // Return formatted time on user preference basis
  893.     public function getLocalizedFormattedTime(\DateTime $timestamp, $user = null, $format = 'm-d-y h:i A')
  894.     {
  895.         $activeUserTimeZone = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'Knowledgebase']);
  897.         if (!empty($user) && $user != 'anon.' && $user->getTimezone() != null) {
  898.             $timestamp = clone $timestamp;
  900.             $timestamp->setTimeZone(new \DateTimeZone($user->getTimeZone()));
  901.             $format = $user->getTimeFormat();
  902.         } elseif (!empty($activeUserTimeZone) && $activeUserTimeZone != 'anon.' && $activeUserTimeZone->getTimezone() != null) {
  903.             $timestamp = clone $timestamp;
  905.             $timestamp->setTimeZone(new \DateTimeZone($activeUserTimeZone->getTimeZone()));
  906.             $format = $activeUserTimeZone->getTimeFormat();
  907.         }
  909.         return $timestamp->format($format);
  910.     }
  912.     public function isFileExists($filePath)
  913.     {
  914.         $dir = $this->container->get('kernel')->getProjectDir();
  915.         $file = str_replace("\\", '/', $dir . "/" . $filePath);
  917.         if (is_dir($file)) {
  918.             return true;
  919.         }
  921.         return false;
  922.     }
  924.     public function getCustomersCountForKudos($container)
  925.     {
  926.         $qb = $this->entityManager->createQueryBuilder();
  927.         $qb->select($qb->expr()->countDistinct('c.id') . "as customerCount")->from(Ticket::class, 't')
  928.             ->leftJoin('t.customer', 'c');
  930.         $container->get('report.service')->addPermissionFilter($qb, $this->container, false);
  932.         return $qb->getQuery()->getSingleScalarResult();
  933.     }
  935.     public function getAssignedUserSupportPrivilegeDetails($user, $userInstance)
  936.     {
  937.         $queryBuilder = $this->entityManager->createQueryBuilder();
  938.         $queryBuilder
  939.             ->select('DISTINCT privilege.id, privilege.name, privilege.privileges')
  940.             ->from(SupportPrivilege::class, 'privilege')
  941.             ->leftJoin('privilege.users', 'userInstance')
  942.             ->where('userInstance.id = :userInstanceId')->setParameter('userInstanceId', $userInstance->getId())
  943.         ;
  945.         return $queryBuilder->getQuery()->getResult();
  946.     }
  947. }