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

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Services;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Doctrine\Common\Collections\Criteria;
  7. use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportRole;
  11. use Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance;
  12. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket;
  13. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportPrivilege;
  14. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup;    
  15. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam;
  16. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SavedReplies;
  17. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Website;
  18. use Symfony\Component\HttpFoundation\RequestStack;
  19. use Symfony\Component\DependencyInjection\ContainerInterface;
  20. use Webkul\UVDesk\CoreFrameworkBundle\Workflow\Events as CoreWorkflowEvents;
  21. use Symfony\Component\Translation\Translator;
  22. use Symfony\Component\Translation\Loader\YamlFileLoader;
  23. use Twig\Environment as TwigEnvironment;
  24. use Symfony\Component\Filesystem\Filesystem as Fileservice;
  25. use Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite;
  27. class UserService
  28. {
  29.     protected $container;
  30.     protected $requestStack;
  31.     protected $entityManager;
  32.     protected $twig;
  34.     public function __construct(ContainerInterface $container, RequestStack $requestStack, EntityManagerInterface $entityManager, TwigEnvironment $twig)
  35.     {
  36.         $this->container = $container;
  37.         $this->requestStack = $requestStack;
  38.         $this->entityManager = $entityManager;
  39.         $this->twig = $twig;
  40.     }
  42.     public function getCustomFieldTemplateCustomer()
  43.     {
  44.         $request = $this->requestStack->getCurrentRequest();
  45.         $ticket = $this->entityManager->getRepository(Ticket::class)->findOneById($request->attributes->get('id'));
  47.         try {
  48.             if ($this->isFileExists('apps/uvdesk/custom-fields')) {
  49.                 $customFieldsService = $this->container->get('uvdesk_package_custom_fields.service');
  50.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_custom_fields';
  51.             } else if ($this->isFileExists('apps/uvdesk/form-component')) {
  52.                 $customFieldsService = $this->container->get('uvdesk_package_form_component.service');
  53.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_form_component';
  54.             }
  55.         } catch (\Exception $e) {
  56.             // @TODO: Log execption message
  57.         }
  59.         $customerCustomFieldSnippet = !empty($customFieldsService) ? $customFieldsService->getCustomerCustomFieldSnippet($ticket) : [];
  61.         if (!empty($registeredBaseTwigPath) && sizeof($customerCustomFieldSnippet["customFieldCollection"]) > 0 ) {
  62.             return $this->twig->render('@' . $registeredBaseTwigPath . '/widgets/CustomFields/customFieldSnippetCustomer.html.twig', $customerCustomFieldSnippet);
  63.         }
  65.         return ;
  66.     }
  68.     public function isGranted($role) {
  69.         $securityContext = $this->container->get('security.token_storage');
  70.        
  71.         try {
  72.             return (bool) ($role == $securityContext->getToken()->getRoles()[0]->getRole());
  73.         } catch (AuthenticationCredentialsNotFoundException $e) {
  74.             // @TODO: Handle Authentication Failure
  75.         }
  77.         return false;
  78.     }
  79.     
  80.     public function getSessionUser()
  81.     {
  82.         $user = $this->container->get('security.token_storage')->getToken()?->getUser();
  84.         return $user instanceof User ? $user : null;
  85.     }
  87.     public function getCurrentUser()
  88.     {
  89.         if ($this->container->get('security.token_storage')->getToken()) {
  90.             return $this->container->get('security.token_storage')->getToken()?->getUser();
  91.         } else {
  92.             return false;
  93.         }
  94.     }
  96.     public function getCountries()
  97.     {    
  98.         return $this->helpdeskCountries = \Symfony\Component\Intl\Countries::getNames();
  99.     }
  101.     public function isAccessAuthorized($scope, User $user = null)
  102.     {
  103.         // Return false if no user is provided
  104.         if (empty($user) && !($user = $this->getSessionUser())) {
  105.             return false;
  106.         }
  108.         try {
  109.             $userRole = $user?->getCurrentInstance()?->getSupportRole()->getCode();
  110.         } catch (\Exception $error) {
  111.             $userRole = '';
  112.         }
  114.         switch ($userRole) {
  115.             case 'ROLE_SUPER_ADMIN':
  116.             case 'ROLE_ADMIN':
  117.                 return true;
  118.             case 'ROLE_AGENT':
  119.                 $agentPrivileges = $this->getUserPrivileges($this->getCurrentUser()?->getId());
  120.                 $agentPrivileges = array_merge($agentPrivileges, ['saved_filters_action', 'saved_replies']);
  121.                 
  122.                 return in_array($scope, $agentPrivileges) ? true : false;
  123.             case 'ROLE_CUSTOMER':
  124.             default:
  125.                 break;
  126.         }
  128.         return true;
  129.     }
  131.     public function getUserPrivileges($userId)
  132.     {
  133.         static $agentPrivilege = [];
  134.         
  135.         if (isset($agentPrivilege[$userId])) {
  136.             return $agentPrivilege[$userId];
  137.         }
  138.         
  139.         $userPrivileges = array();
  140.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  141.         $privileges = $user->getAgentInstance()->getSupportPrivileges();  
  142.       
  143.         if ($privileges) {
  144.             foreach ($privileges as $privilege) {
  145.                 $userPrivileges = array_merge($userPrivileges, $privilege->getPrivileges());
  146.             }
  147.         }
  148.         
  149.         $agentPrivilege[$userId] = $this->agentPrivilege[$userId] = $userPrivileges;  
  151.         return $userPrivileges;
  152.     }
  154.     public function getSupportPrivileges()
  155.     {
  156.         $qb = $this->entityManager->createQueryBuilder();
  157.         $qb->select("supportPrivilege")->from(SupportPrivilege::class, 'supportPrivilege');
  158.         
  159.         return $qb->getQuery()->getArrayResult();
  160.     }
  162.     public function getSupportGroups(Request $request = null)
  163.     {
  164.         static $results;
  165.         if (null !== $results)
  166.             return $results;
  167.         $qb = $this->entityManager->createQueryBuilder();
  168.         $qb->select('supportGroup.id, supportGroup.name')->from(SupportGroup::class, 'supportGroup')
  169.                 ->andWhere('supportGroup.isActive = 1');
  170.         if ($request) {
  171.             $qb->andWhere("supportGroup.name LIKE :groupName");
  172.             $qb->setParameter('groupName', '%'.urldecode(trim($request->query->get('query'))).'%');
  173.             $qb->andWhere("supportGroup.id NOT IN (:ids)");
  174.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  175.         }
  177.         return $results = $qb->getQuery()->getArrayResult();
  178.     }
  180.     public function getSupportTeams(Request $request = null)
  181.     {
  182.         static $results;
  183.         if (null !== $results)
  184.             return $results;
  186.         $queryBuilder = $this->entityManager->createQueryBuilder()
  187.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) as name, userInstance.profileImagePath as smallThumbnail")
  188.             ->from(User::class, 'user')
  189.             ->leftJoin('user.userInstance', 'userInstance')
  190.             ->leftJoin('userInstance.supportRole', 'supportRole')
  191.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  192.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  193.             ->orderBy('name', Criteria::ASC);
  195.         if ($request && null != $request->query->get('query')) {
  196.             $queryBuilder
  197.                 ->andWhere("CONCAT(dt.firstName,' ', dt.lastName) LIKE :customerName")
  198.                 ->setParameter('customerName', '%'.urldecode(trim($request->query->get('query'))).'%');
  199.         }
  201.         $qb = $this->entityManager->createQueryBuilder();
  202.         $qb->select('supportTeam.id, supportTeam.name')
  203.            ->from(SupportTeam::class, 'supportTeam');
  204.         $qb->andWhere('supportTeam.isActive = 1');
  205.         
  206.         if ($request) {
  207.             $qb->andWhere("supportTeam.name LIKE :subGroupName");
  208.             $qb->setParameter('subGroupName', '%'.urldecode($request->query->get('query')).'%');
  209.             $qb->andWhere("supportTeam.id NOT IN (:ids)");
  210.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  211.         }
  213.         return $results = $qb->getQuery()->getResult();
  214.     }
  216.     public function createUserInstance($email, $name, SupportRole $role, array $extras = [])
  217.     {
  218.         $user = $this->entityManager->getRepository(User::class)->findOneByEmail($email) ?: new User();
  219.         
  220.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  221.         $timeZone = $website->getTimezone();
  222.         $timeFormat = $website->getTimeformat();
  224.         if (null == $user->getId()) {
  225.             $name = explode(' ', trim($name));
  226.             
  227.             $user->setEmail($email);
  228.             $user->setFirstName(isset($extras['firstName']) ? $extras['firstName'] : array_shift($name));
  229.             $user->setLastName(trim(implode(' ', $name)));
  230.             $user->setIsEnabled($extras['active']);
  231.             $user->setTimeZone($timeZone);
  232.             $user->setTimeFormat($timeFormat);
  234.             $this->entityManager->persist($user);
  235.             $this->entityManager->flush();
  236.         }
  237.         
  238.         $userInstance = 'ROLE_CUSTOMER' == $role->getCode() ? $user->getCustomerInstance() : $user->getAgentInstance();
  239.         
  240.         if (empty($userInstance)) {
  241.             $userInstance = new UserInstance();
  242.                 
  243.             $userInstance->setUser($user);
  244.             $userInstance->setSupportRole($role);
  245.             $userInstance->setContactNumber(!empty($extras['contact']) ? $extras['contact'] : null);
  246.             $userInstance->setSkypeId(!empty($extras['skype']) ? $extras['skype'] : null);
  247.             $userInstance->setDesignation(!empty($extras['designation']) ? $extras['designation'] : null);
  248.             $userInstance->setSignature(!empty($extras['signature']) ? $extras['signature'] : null);
  250.             $userInstance->setSource(!empty($extras['source']) ? $extras['source'] : 'website');
  251.             $userInstance->setIsActive(!empty($extras['active']) ? (bool) $extras['active'] : false);
  252.             $userInstance->setIsVerified(!empty($extras['verified']) ? (bool) $extras['verified'] : false);
  253.             $userInstance->setIsStarred(!empty($extras['starred']) ? (bool) $extras['starred'] : false);
  255.             if (!empty($extras['image'])) {
  256.                 $assetDetails = $this->container->get('uvdesk.core.file_system.service')->getUploadManager()->uploadFile($extras['image'], 'profile');
  258.                 if (!empty($assetDetails)) {
  259.                     $userInstance->setProfileImagePath($assetDetails['path']);
  260.                 }
  261.             }
  263.             $this->entityManager->persist($userInstance);
  264.             $this->entityManager->flush();
  266.             $user->addUserInstance($userInstance);
  268.             // Trigger user created event
  269.             $event = $role->getCode() == 'ROLE_CUSTOMER' ? new CoreWorkflowEvents\Customer\Create() : new CoreWorkflowEvents\Agent\Create();
  270.             $event
  271.                 ->setUser($user)
  272.             ;
  274.             $this->container->get('event_dispatcher')->dispatch($event, 'uvdesk.automation.workflow.execute');
  275.         }
  277.         return $user;
  278.     }
  280.     public function getAgentPartialDataCollection(Request $request = null)
  281.     {
  282.         $queryBuilder = $this->entityManager->createQueryBuilder()
  283.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', COALESCE(user.lastName, '')) as name, userInstance.profileImagePath as smallThumbnail")
  284.             ->from(User::class, 'user')
  285.             ->leftJoin('user.userInstance', 'userInstance')
  286.             ->leftJoin('userInstance.supportRole', 'supportRole')
  287.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  288.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  289.             ->orderBy('name', Criteria::ASC)
  290.         ;
  292.         if ($request && null != $request->query->get('query')) {
  293.             $queryBuilder
  294.                 ->andWhere("CONCAT(user.firstName,' ', user.lastName) LIKE :customerName")
  295.                 ->setParameter('customerName', '%' . urldecode($request->query->get('query')) . '%')
  296.             ;
  297.         }
  299.         if ($request && null != $request->query->get('not')) {
  300.             $queryBuilder
  301.                 ->andWhere("u.id NOT IN (:ids)")
  302.                 ->setParameter('ids', explode(',', urldecode($request->query->get('not'))))
  303.             ;
  304.         }
  306.         return $queryBuilder->getQuery()->getArrayResult();
  307.     }
  309.     public function getAgentsPartialDetails(Request $request = null)
  310.     {
  311.         static $agents;
  313.         if (null !== $agents) {
  314.             return $agents;
  315.         }
  317.         $qb = $this->entityManager->createQueryBuilder();
  318.         $qb
  319.             ->select("u.id, userInstance.id as udId,u.email,CONCAT(u.firstName,' ', u.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  320.             ->from(User::class, 'u')
  321.             ->leftJoin('u.userInstance', 'userInstance')
  322.             ->andWhere('userInstance.supportRole != :roles')
  323.             ->setParameter('roles', 4)
  324.             ->andWhere('userInstance.isActive = 1')
  325.             ->orderBy('name','ASC')
  326.         ;
  328.         if ($request) {
  329.             $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  330.             $qb->setParameter('customerName', '%'.urldecode(trim($request->query->get('query'))).'%');
  331.             $qb->andWhere("u.id NOT IN (:ids)");
  332.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  333.         }
  335.         $data = $agents = $qb->getQuery()->getArrayResult();
  337.         return $data;
  338.     }
  340.     public function getAgentDetailById($agentId)
  341.     {
  342.         if (!$agentId) {
  343.             return;
  344.         }
  346.         $qb = $this->entityManager->createQueryBuilder();
  347.         $qb
  348.             ->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")
  349.             ->from(User::class, 'u')
  350.             ->leftJoin('u.userInstance', 'userInstance')
  351.             ->andWhere('userInstance.supportRole != :roles')
  352.             ->andWhere('u.id = :agentId')
  353.             ->setParameter('roles', 4)
  354.             ->setParameter('agentId', $agentId)
  355.         ;
  357.         $result = $qb->getQuery()->getResult();
  359.         return isset($result[0]) ? $result[0] : null;
  360.     }
  362.     public function getUsersByGroupId($groupId)
  363.     {
  364.         $qb = $this->entityManager->createQueryBuilder();
  365.         $qb->select("DISTINCT user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) AS name, userInstance.profileImagePath as smallThumbnail")
  366.             ->from(User::class, 'user')
  367.             ->leftJoin('user.userInstance', 'userInstance')
  368.             ->leftJoin('userInstance.supportGroups', 'supportGroup')
  369.             ->andWhere('userInstance.supportRole != :roles')->setParameter('roles', 4)
  370.             ->andWhere('supportGroup.id = :groupId')->setParameter('groupId', $groupId)
  371.             ->andWhere('userInstance.isActive = 1')
  372.         ;
  374.         $data = $qb->getQuery()->getArrayResult();
  375.         
  376.         return $data;
  377.     }
  379.     public function getUsersBySubGroupId($subGroupId)
  380.     {
  381.         $qb = $this->entityManager->createQueryBuilder();
  382.         $qb->select("DISTINCT user.id, supportTeam.id as udId,user.email,CONCAT(user.firstName,' ', user.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  383.                 ->from(User::class, 'user')
  384.                 ->leftJoin('user.userInstance', 'userInstance')
  385.                 ->leftJoin('userInstance.supportTeams', 'supportTeam')
  386.                 ->andWhere('userInstance.supportRole != :roles')
  387.                 ->andWhere('supportTeam.id = :subGroupId')
  388.                 ->setParameter('roles', 4)
  389.                 ->setParameter('subGroupId', $subGroupId)
  390.                 ->andWhere('supportTeam.isActive = 1')
  391.                 ->andWhere('userInstance.isActive = 1');
  393.         $data = $qb->getQuery()->getArrayResult();
  395.         return $data;
  396.     }
  398.     public function getCustomerDetailsById($customerId)
  399.     {
  400.         $qb = $this->entityManager->createQueryBuilder();
  401.         $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')
  402.                 ->leftJoin('user.userInstance', 'userInstance')
  403.                 ->andWhere('userInstance.supportRole = :roles')
  404.                 ->andWhere('user.id = :customerId')
  405.                 ->setParameter('roles', 4)
  406.                 ->setParameter('customerId', $customerId);
  408.         $result = $qb->getQuery()->getResult();
  410.         return ($result ? $result[0] : null);
  411.     }
  413.     public function getCustomerPartialDetailById($customerId)
  414.     {
  415.         $qb = $this->entityManager->createQueryBuilder();
  416.         $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')
  417.             ->leftJoin('u.userInstance', 'userInstance')
  418.             ->andWhere('userInstance.supportRole = :roles')
  419.             ->andWhere('u.id = :customerId')
  420.             ->setParameter('roles', 4)
  421.             ->setParameter('customerId', $customerId);
  423.         $result = $qb->getQuery()->getResult();
  425.         return $result ? $result[0] : null;
  426.     }
  428.     public function getCustomersPartial(Request $request = null)
  429.     {
  430.         $qb = $this->entityManager->createQueryBuilder();
  431.         $qb->from(User::class, 'u');
  433.         $qb->select("DISTINCT u.id,u.email,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, userInstance.profileImagePath as smallThumbnail ")
  434.             ->leftJoin('u.userInstance', 'userInstance')
  435.             ->andWhere('userInstance.supportRole = :roles')
  436.             ->setParameter('roles', 4)
  437.             ->orderBy('name','ASC');
  438.         
  439.         if ($request) {
  440.             if ($request->query->get('query')) {
  441.                 $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName OR u.email LIKE :customerName");
  442.             } else {
  443.                 $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  444.             }
  445.             
  446.             $qb->setParameter('customerName', '%'.urldecode(trim($request->query->get('query'))).'%')
  447.                 ->andWhere("u.id NOT IN (:ids)")
  448.                 ->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  449.         }
  451.         $query = $qb->getQuery();
  452.         // $query->useResultCache(true, 3600, 'customer_list_'.$this->getCompany()->getId());
  454.         return $query->getScalarResult();
  455.     }
  457.     public function getCustomersCount()
  458.     {
  459.         $qb = $this->entityManager->createQueryBuilder();
  460.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  461.                 ->leftJoin('t.customer', 'c');
  463.         $this->entityManager->getRepository(Ticket::class)->addPermissionFilter($qb, $this->container, false);
  465.         return $qb->getQuery()->getSingleScalarResult();
  466.     }
  468.     public function getUserSubGroupIds($userId) {
  469.         $qb = $this->entityManager->createQueryBuilder();
  470.         $qb->select('supportTeams.id')->from(User::class, 'user')
  471.                 ->leftJoin('user.userInstance','userInstance')
  472.                 ->leftJoin('userInstance.supportTeams','supportTeams')
  473.                 ->andWhere('user.id = :userId')
  474.                 ->andWhere('userInstance.supportRole != :agentRole')
  475.                 ->andWhere('supportTeams.isActive = 1')
  476.                 ->setParameter('userId', $userId)
  477.                 ->setParameter('agentRole', '4'); 
  479.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  480.     }
  482.     public function getUserGroupIds($userId) {
  483.         $qb = $this->entityManager->createQueryBuilder();
  484.         $qb->select('supportGroup.id')->from(User::class, 'user')
  485.                 ->leftJoin('user.userInstance','userInstance')
  486.                 ->leftJoin('userInstance.supportGroups','supportGroup')
  487.                 ->andWhere('user.id = :userId')
  488.                 ->andWhere('supportGroup.isActive = 1')
  489.                 ->setParameter('userId', $userId);
  491.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  492.     }
  494.     public function createUser($data)
  495.     {
  496.         $user = new User();
  497.         $user->setEmail($data['from']);
  498.         $user->setFirstName($data['firstName']);
  499.         $user->setLastName($data['lastName']);
  500.         $user->setIsEnabled($data['isActive']);
  501.         $this->entityManager->persist($user);
  502.         // $this->entityManager->flush();
  503.         $role = $this->entityManager->getRepository(SupportRole::class)->find($data['role']);
  504.     
  505.         $userInstance = new UserInstance();
  506.         $userInstance->setSupportRole($role);
  507.         $userInstance->setUser($user);
  508.         $userInstance->setIsActive($data['isActive']);
  509.         $userInstance->setIsVerified(0);
  510.         if (isset($data['source']))
  511.             $userInstance->setSource($data['source']);
  512.         else
  513.             $userInstance->setSource('website');
  514.         if (isset($data['contactNumber'])) {
  515.             $userInstance->setContactNumber($data['contactNumber']);
  516.         }
  517.         if(isset($data['profileImage']) && $data['profileImage']) {
  518.                 $userInstance->setProfileImagePath($data['profileImage']);
  519.         }
  520.         $this->entityManager->persist($userInstance);
  521.         $this->entityManager->flush();
  523.         $user->addUserInstance($userInstance);
  524.         $this->entityManager->persist($user);
  525.         $this->entityManager->flush();
  527.         //$user->setUserName($userInstance->getName());
  528.         return $user;
  529.     }
  531.     public function getWebsiteConfiguration($code)
  532.     {
  533.         $enabled_bundles = $this->container->getParameter('kernel.bundles');
  534.         
  535.         if (!in_array('UVDeskSupportCenterBundle', array_keys($enabled_bundles))) {
  536.             return [
  537.                 'id'                        =>  1,
  538.                 'website'                   =>  1,
  539.                 'status'                    =>  1,
  540.                 'brandColor'                => '#7E91F0',
  541.                 'pageBackgroundColor'       => '#FFFFFF',
  542.                 'headerBackgroundColor'     => '#FFFFFF',
  543.                 'bannerBackgroundColor'     => '#7085F4',
  544.                 'navTextColor'              =>  '#7085F4',
  545.                 'navActiveColor'            => '#7085F4',
  546.                 'linkColor'                 => '#7085F4',
  547.                 'linkHoverColor'            => '#7085F4',
  548.                 'headerLinks'               => null,
  549.                 'footerLinks'               => null,
  550.                 'articleTextColor'          => '#7085F4',
  551.                 'whiteList'                 => null,
  552.                 'blackList'                 => null,
  553.                 'siteDescritption'          => 'Hi! how can i help you.',
  554.                 'metaDescription'           => null,
  555.                 'metaKeywords'              => null,
  556.                 'homepageContent'           => null,
  557.                 'ticketCreateOption'        =>  1,
  558.                 'createdAt'                 =>  '2024-09-21 16:20:01',
  559.                 'updatedat'                 =>  '2024-09-21 16:20:01',
  560.                 'broadcastMessage'          => null,
  561.                 'removeCustomerLoginButton' => null,
  562.                 'disableCustomerlogin'      =>  0,
  563.                 'removeBrandingContent'     => null,
  564.                 'loginRequiredToCreate'     => null,
  565.                 'script'                    => null,
  566.                 'customCss'                 => null,
  567.                 'isActive'                  => 1,
  568.             ];
  569.         }
  570.         
  571.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  573.         if ($website) {
  574.             $configuration = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy([
  575.                 'website'  => $website->getId(), 
  576.                 'isActive' => 1
  577.             ]);
  578.         }
  580.         return !empty($configuration) ? $configuration : false;
  581.     }
  583.     public function getWebsiteDetails($code)
  584.     {
  585.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  587.         return !empty($website) ? $website : false;
  588.     }
  590.     public function convertToTimezone($date, $format = "d-m-Y H:ia")
  591.     {
  592.         if (!$date) {
  593.             return "N/A";
  594.         }
  596.         $date = date_format($date, $format);
  597.         $dateTime = date('Y-m-d H:i:s', strtotime($date));
  598.         
  599.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  600.         $scheduleDate
  601.             ->setTimeZone(new \DateTimeZone('Asia/Kolkata'))
  602.         ;
  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))
  627.         ;
  629.         return $date->format($timeformat);
  630.     }
  632.     public function convertToDatetimeTimezoneTimestamp($date, $format = "d-m-Y h:ia")
  633.     {
  634.         if (!$date)
  635.             return "N/A";
  636.         $currentUser = $this->getCurrentUser();
  637.         $date = date_format($date, $format);
  638.         $dateTime = date('Y-m-d H:i:s',strtotime($date));
  639.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  640.         $this->domain = $this->container->get('router')->getContext()->getHost();
  642.         $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  644.         return $scheduleDate->getTimestamp();
  645.     }
  647.     public function removeCustomer($customer)
  648.     {
  649.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $customer->getId()));
  651.         $count = count($userData);
  652.         $ticketData = $this->entityManager->getRepository(Ticket::class)->findBy(array('customer' => $customer->getId()));
  654.         $fileService = new Fileservice();
  655.         // Delete all tickets attachments.
  656.         if ($ticketData) {
  657.             foreach ($ticketData as $ticket) {
  658.                 $threads = $ticket->getThreads();
  659.                 if (count($threads) > 0) {
  660.                     foreach ($threads as $thread) {
  661.                         if (!empty($thread)) {
  662.                             $fileService->remove($this->container->getParameter('kernel.project_dir').'/public/assets/threads/'.$thread->getId());
  664.                         }
  665.                     }
  666.                 }
  667.             }
  668.         }
  670.         // Remove profile.
  671.         foreach ($userData as $user) {
  672.             if ($user->getSupportRole()->getId() == 4 && $user->getProfileImagePath()) {
  673.                 $fileService->remove($this->container->getParameter('kernel.project_dir').'/public'.$user->getProfileImagePath());
  674.             }
  675.         }
  677.         // getCustomerTickets
  678.         $qb = $this->entityManager->createQueryBuilder();
  679.         $query = $qb->delete(Ticket::class, 't')
  680.                     ->andWhere('t.customer = :customerId')
  681.                     ->setParameter('customerId', $customer->getId())
  682.                     ->getQuery();
  684.         $query->execute();
  686.         $qb = $this->entityManager->createQueryBuilder();
  687.         $query = $qb->delete(UserInstance::class, 'userInstance')
  688.                     ->andWhere('userInstance.user = :customerId')
  689.                     ->andWhere('userInstance.supportRole = :roleId')
  690.                     ->setParameter('customerId', $customer->getId())
  691.                     ->setParameter('roleId', 4)
  692.                     ->getQuery();
  694.         $query->execute();
  696.         if ($count == 1) {
  697.             $this->entityManager->remove($customer);
  698.             $this->entityManager->flush();
  699.         }
  700.     }
  701.     
  702.     public function removeAgent($user)
  703.     {
  704.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $user->getId()));
  705.         $count = count($userData);
  707.         $qb = $this->entityManager->createQueryBuilder();
  708.         $query = $qb->delete(UserInstance::class, 'ud')
  709.                     ->andWhere('ud.user = :userId')
  710.                     ->andWhere('ud.supportRole = :roleId')
  711.                     ->setParameter('userId', $user->getId())
  712.                     ->setParameter('roleId', 3)
  713.                     ->getQuery();
  715.         $query->execute();
  716.         
  717.         foreach ($user->getAgentInstance()->getSupportGroups() as $group) {
  718.                 $user->getAgentInstance()->removeSupportGroup($group);
  719.                 $this->entityManager->persist($group);
  720.                 $this->entityManager->flush();
  721.             
  722.         }
  724.         $qb = $this->entityManager->createQueryBuilder();
  725.         $query = $qb->update(Ticket::class, 't')
  726.                     ->set('t.agent', ':nullAgent')
  727.                     ->andWhere('t.agent = :agentId')
  728.                     ->setParameter('agentId', $user->getId())
  729.                     ->setParameter('nullAgent', null)
  730.                     ->getQuery();
  732.         $query->execute();
  734.         if ($count == 1) {
  735.             $this->entityManager->remove($user);
  736.             $this->entityManager->flush();
  737.         }
  738.     }
  740.     public function getWebsiteView()
  741.     {
  742.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code'=>'knowledgebase']);
  743.         $layout  = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website'=>$website->getId()]);
  744.       
  745.         $homepageContent = $layout->getHomepageContent();
  747.         return (!empty($homepageContent)) ? $homepageContent . 'View' : 'masonryView';
  748.     }
  750.     public function getUserDetailById($userId) {
  751.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  752.         foreach ($user->getUserInstance() as $row) {
  753.             if ($row->getSupportRole()->getId() != 4)
  754.                 return $row;
  755.         }
  757.         return null;
  758.     }
  760.     public function getUserPrivilegeIds($userId) 
  761.     {
  762.         $qb = $this->entityManager->createQueryBuilder();
  763.         $qb
  764.             ->select('supportPrivileges.id')
  765.             ->from(User::class, 'user')
  766.             ->leftJoin('user.userInstance','userInstance')
  767.             ->leftJoin('userInstance.supportPrivileges','supportPrivileges')
  768.             ->andWhere('user.id = :userId')
  769.             ->setParameter('userId', $userId)
  770.         ;
  772.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  773.     }
  775.     public function getWebsiteSpamDetails($websiteSpam) 
  776.     {
  777.         $blackList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getBlackList()));
  778.         $whiteList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getWhiteList()));
  780.         return [
  781.             'blackList' => $this->filterBlockSpam($blackList),
  782.             'whiteList' => $this->filterBlockSpam($whiteList),
  783.         ];
  784.     }
  786.     public function filterBlockSpam($str) 
  787.     {
  788.         $list = array();
  789.         foreach (explode(',', $str) as $value) {
  790.             if (filter_var($value, FILTER_VALIDATE_EMAIL)) {
  791.                 if (!isset($list['email'])) {
  792.                     $list['email'] = array();
  793.                 }
  795.                 array_push($list['email'], strtolower($value));
  796.             } else if (filter_var($value, FILTER_VALIDATE_IP)) {
  797.                 if (!isset($list['ip'])) {
  798.                     $list['ip'] = array();
  799.                 }
  800.                 
  801.                 array_push($list['ip'], $value);
  802.             } else if (isset($value[0]) && $value[0] == '@') {
  803.                 if (!isset($list['domain'])) {
  804.                     $list['domain'] = array();
  805.                 }
  807.                 array_push($list['domain'], strtolower($value));
  808.             }
  809.         }
  810.         
  811.         return $list;
  812.     }
  814.     // @TODO: Refactor this - We can instead just use \DateTimeZone::listIdentifiers() wherever need be.
  815.     public function getTimezones()
  816.     {
  817.         return \DateTimeZone::listIdentifiers();
  818.     }
  820.     public function getUserSavedReplyReferenceIds()
  821.     {
  822.         // @TODO: Refactor this function
  823.         $savedReplyIds = [];
  824.         $groupIds = [];
  825.         $teamIds = []; 
  826.         $userId = $this->getCurrentUser()->getAgentInstance()->getId();
  828.         // Get all the saved reply the current user has created.
  829.         $savedReplyRepo = $this->entityManager->getRepository(SavedReplies::class)->findAll();
  831.         foreach ($savedReplyRepo as $sr) {
  832.             if ($userId == $sr->getUser()->getId()) {
  833.                 //Save the ids of the saved reply.
  834.                 array_push($savedReplyIds, (int)$sr->getId());
  835.             }
  836.         }
  838.         // Get the ids of the Group(s) the current user is associated with.
  839.         $query = "select * from uv_user_support_groups where userInstanceId =".$userId;
  840.         $connection = $this->entityManager->getConnection();
  841.         $stmt = $connection->prepare($query);
  842.         $stmt->execute();
  843.         $result = $stmt->fetchAll();
  845.         foreach ($result as $row) {
  846.             array_push($groupIds, $row['supportGroupId']);
  847.         }
  849.         // Get all the saved reply's ids that is associated with the user's group(s).
  850.         $query = "select * from uv_saved_replies_groups";
  851.         $stmt = $connection->prepare($query);
  852.         $stmt->execute();
  853.         $result = $stmt->fetchAll();
  855.         foreach ($result as $row) {
  856.             if (in_array($row['group_id'], $groupIds)) {
  857.                 array_push($savedReplyIds, (int) $row['savedReply_id']);
  858.             }
  859.         }
  861.         // Get the ids of the Team(s) the current user is associated with.
  862.         $query = "select * from uv_user_support_teams";
  863.         $connection = $this->entityManager->getConnection();
  864.         $stmt = $connection->prepare($query);
  865.         $stmt->execute();
  866.         $result = $stmt->fetchAll();
  868.         foreach ($result as $row) {
  869.             if ($row['userInstanceId'] == $userId) {
  870.                 array_push($teamIds, $row['supportTeamId']);
  871.             }
  872.         }
  874.         $query = "select * from uv_saved_replies_teams";
  875.         $stmt = $connection->prepare($query);
  876.         $stmt->execute();
  877.         $result = $stmt->fetchAll();
  879.         foreach ($result as $row) {
  880.             if (in_array($row['subgroup_id'], $teamIds)) {
  881.                 array_push($savedReplyIds, (int)$row['savedReply_id']);
  882.             }
  883.         }
  885.         return $savedReplyIds;
  886.     }
  887.     
  888.     // Return formatted time on user preference basis
  889.     public function getLocalizedFormattedTime(\DateTime $timestamp, $user = null, $format = 'm-d-y h:i A')
  890.     {
  891.         $activeUserTimeZone = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'Knowledgebase']);
  892.         if (!empty($user) && $user != 'anon.' && $user->getTimezone() != null) {
  893.             $timestamp = clone $timestamp;
  894.             
  895.             $timestamp->setTimeZone(new \DateTimeZone($user->getTimeZone()));
  896.             $format = $user->getTimeFormat();
  897.         } elseif (!empty($activeUserTimeZone) && $activeUserTimeZone != 'anon.' && $activeUserTimeZone->getTimezone() != null) {
  898.             $timestamp = clone $timestamp;
  899.             
  900.             $timestamp->setTimeZone(new \DateTimeZone($activeUserTimeZone->getTimeZone()));
  901.             $format = $activeUserTimeZone->getTimeFormat();
  902.         }
  903.         
  904.         return $timestamp->format($format);
  905.     }
  907.     public function isFileExists($filePath)
  908.     {
  909.         $dir = $this->container->get('kernel')->getProjectDir();
  910.         // $dirSplit = explode('vendor', $dir);
  911.         $file = str_replace("\\",'/', $dir."/".$filePath);
  913.         if (is_dir($file)) { 
  914.             return true;
  915.         }
  916.         
  917.         return false;
  918.     }
  920.     public function getCustomersCountForKudos($container)
  921.     {
  922.         $qb = $this->entityManager->createQueryBuilder();
  923.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  924.                 ->leftJoin('t.customer', 'c');
  926.         $container->get('report.service')->addPermissionFilter($qb, $this->container, false);
  928.         return $qb->getQuery()->getSingleScalarResult();
  929.     }
  931.     public function getAssignedUserSupportPrivilegeDetails($user, $userInstance) 
  932.     {
  933.         $queryBuilder = $this->entityManager->createQueryBuilder(); 
  934.         $queryBuilder
  935.             ->select('DISTINCT privilege.id, privilege.name, privilege.privileges')
  936.             ->from(SupportPrivilege::class, 'privilege')
  937.             ->leftJoin('privilege.users','userInstance')
  938.             ->where('userInstance.id = :userInstanceId')->setParameter('userInstanceId', $userInstance->getId())
  939.         ; 
  940.         return $queryBuilder->getQuery()->getResult();
  941.     }
  942. }