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

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\EventDispatcher\GenericEvent;
  20. use Symfony\Component\DependencyInjection\ContainerInterface;
  21. use Webkul\UVDesk\CoreFrameworkBundle\Workflow\Events as CoreWorkflowEvents;
  22. use Symfony\Component\Translation\Translator;
  23. use Symfony\Component\Translation\Loader\YamlFileLoader;
  24. use Twig\Environment as TwigEnvironment;
  25. use Symfony\Component\Filesystem\Filesystem as Fileservice;
  26. use Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite;
  28. class UserService
  29. {
  30.     protected $container;
  31.     protected $requestStack;
  32.     protected $entityManager;
  33.     protected $twig;
  35.     public function __construct(ContainerInterface $container, RequestStack $requestStack, EntityManagerInterface $entityManager, TwigEnvironment $twig)
  36.     {
  37.         $this->container = $container;
  38.         $this->requestStack = $requestStack;
  39.         $this->entityManager = $entityManager;
  40.         $this->twig = $twig;
  41.     }
  43.     public function getCustomFieldTemplateCustomer()
  44.     {
  45.         $request = $this->requestStack->getCurrentRequest();
  46.         //get the ticket
  47.         $ticket = $this->entityManager->getRepository(Ticket::class)->findOneById($request->attributes->get('id'));
  48.         $getCustomerCustomFieldSnippet = $this->container->get('custom.field.service')->getCustomerCustomFieldSnippet($ticket);
  50.         if (sizeof($getCustomerCustomFieldSnippet["customFieldCollection"]) > 0 ) {
  51.             return $this->twig->render('@_uvdesk_extension_uvdesk_form_component/widgets/CustomFields/customFieldSnippetCustomer.html.twig', 
  52.                 $getCustomerCustomFieldSnippet);
  53.         }
  55.         return ;
  56.     }
  58.     public function isGranted($role) {
  59.         $securityContext = $this->container->get('security.token_storage');
  60.        
  61.         try {
  62.             return (bool) ($role == $securityContext->getToken()->getRoles()[0]->getRole());
  63.         } catch (AuthenticationCredentialsNotFoundException $e) {
  64.             // @TODO: Handle Authentication Failure
  65.         }
  67.         return false;
  68.     }
  69.     
  70.     public function getSessionUser()
  71.     {
  72.         $user = $this->container->get('security.token_storage')->getToken()->getUser();
  74.         return $user instanceof User ? $user : null;
  75.     }
  77.     public function getCurrentUser()
  78.     {
  79.         if ($this->container->get('security.token_storage')->getToken()) {
  80.             return $this->container->get('security.token_storage')->getToken()->getUser();
  81.         } else {
  82.             return false;
  83.         }
  84.     }
  85.     
  86.     public function isAccessAuthorized($scope, User $user = null)
  87.     {
  88.         // Return false if no user is provided
  89.         if (empty($user) && !($user = $this->getSessionUser())) {
  90.             return false;
  91.         }
  93.         try {
  94.             $userRole = $user->getCurrentInstance()->getSupportRole()->getCode();
  95.         } catch (\Exception $error) {
  96.             $userRole = '';
  97.         }
  99.         switch ($userRole) {
  100.             case 'ROLE_SUPER_ADMIN':
  101.             case 'ROLE_ADMIN':
  102.                 return true;
  103.             case 'ROLE_AGENT':
  104.                 $agentPrivileges = $this->getUserPrivileges($this->getCurrentUser()->getId());
  105.                 $agentPrivileges = array_merge($agentPrivileges, ['saved_filters_action', 'saved_replies']);
  106.                 
  107.                 return in_array($scope, $agentPrivileges) ? true : false;
  108.             case 'ROLE_CUSTOMER':
  109.             default:
  110.                 break;
  111.         }
  113.         return true;
  114.     }
  116.     public function getUserPrivileges($userId)
  117.     {
  118.         static $agentPrivilege = [];
  119.         
  120.         if (isset($agentPrivilege[$userId])) {
  121.             return $agentPrivilege[$userId];
  122.         }
  123.         
  124.         $userPrivileges = array();
  125.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  126.         $privileges = $user->getAgentInstance()->getSupportPrivileges();  
  127.       
  128.         if ($privileges) {
  129.             foreach ($privileges as $privilege) {
  130.                 $userPrivileges = array_merge($userPrivileges, $privilege->getPrivileges());
  131.             }
  132.         }
  133.         
  134.         $agentPrivilege[$userId] = $this->agentPrivilege[$userId] = $userPrivileges;  
  136.         return $userPrivileges;
  137.     }
  139.     public function getSupportPrivileges()
  140.     {
  141.         $qb = $this->entityManager->createQueryBuilder();
  142.         $qb->select("supportPrivilege")->from(SupportPrivilege::class, 'supportPrivilege');
  143.         
  144.         return $qb->getQuery()->getArrayResult();
  145.     }
  147.     public function getSupportGroups(Request $request = null)
  148.     {
  149.         static $results;
  150.         if(null !== $results)
  151.             return $results;
  152.         $qb = $this->entityManager->createQueryBuilder();
  153.         $qb->select('supportGroup.id, supportGroup.name')->from(SupportGroup::class, 'supportGroup')
  154.                 ->andwhere('supportGroup.isActive = 1');
  155.         if($request) {
  156.             $qb->andwhere("supportGroup.name LIKE :groupName");
  157.             $qb->setParameter('groupName', '%'.urldecode($request->query->get('query')).'%');
  158.             $qb->andwhere("supportGroup.id NOT IN (:ids)");
  159.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  160.         }
  161.         return $results = $qb->getQuery()->getArrayResult();
  162.     }
  164.     public function getSupportTeams(Request $request = null)
  165.     {
  166.         static $results;
  167.         if(null !== $results)
  168.             return $results;
  169.         $queryBuilder = $this->entityManager->createQueryBuilder()
  170.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) as name, userInstance.profileImagePath as smallThumbnail")
  171.             ->from(User::class, 'user')
  172.             ->leftJoin('user.userInstance', 'userInstance')
  173.             ->leftJoin('userInstance.supportRole', 'supportRole')
  174.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  175.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  176.             ->orderBy('name', Criteria::ASC);
  178.         if ($request && null != $request->query->get('query')) {
  179.             $queryBuilder
  180.                 ->andWhere("CONCAT(dt.firstName,' ', dt.lastName) LIKE :customerName")
  181.                 ->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%');
  182.         }
  184.         $qb = $this->entityManager->createQueryBuilder();
  185.         $qb->select('supportTeam.id, supportTeam.name')
  186.            ->from(SupportTeam::class, 'supportTeam');
  187.         $qb->andwhere('supportTeam.isActive = 1');
  188.         
  189.         if($request) {
  190.             $qb->andwhere("supportTeam.name LIKE :subGroupName");
  191.             $qb->setParameter('subGroupName', '%'.urldecode($request->query->get('query')).'%');
  192.             $qb->andwhere("supportTeam.id NOT IN (:ids)");
  193.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  194.         }
  196.         return $results = $qb->getQuery()->getResult();
  197.     }
  199.     public function createUserInstance($email, $name, SupportRole $role, array $extras = [])
  200.     {
  201.         $user = $this->entityManager->getRepository(User::class)->findOneByEmail($email) ?: new User();
  202.         
  203.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  204.         $timeZone = $website->getTimezone();
  205.         $timeFormat = $website->getTimeformat();
  207.         if (null == $user->getId()) {
  208.             $name = explode(' ', trim($name));
  209.             
  210.             $user->setEmail($email);
  211.             $user->setFirstName(isset($extras['firstName']) ? $extras['firstName'] : array_shift($name));
  212.             $user->setLastName(trim(implode(' ', $name)));
  213.             $user->setIsEnabled($extras['active']);
  214.             $user->setTimeZone($timeZone);
  215.             $user->setTimeFormat($timeFormat);
  217.             $this->entityManager->persist($user);
  218.             $this->entityManager->flush();
  219.         }
  220.         
  221.         $userInstance = 'ROLE_CUSTOMER' == $role->getCode() ? $user->getCustomerInstance() : $user->getAgentInstance();
  222.         
  223.         if (empty($userInstance)) {
  224.             $userInstance = new UserInstance();
  225.                 
  226.             $userInstance->setUser($user);
  227.             $userInstance->setSupportRole($role);
  228.             $userInstance->setContactNumber(!empty($extras['contact']) ? $extras['contact'] : null);
  229.             $userInstance->setSkypeId(!empty($extras['skype']) ? $extras['skype'] : null);
  230.             $userInstance->setDesignation(!empty($extras['designation']) ? $extras['designation'] : null);
  231.             $userInstance->setSignature(!empty($extras['signature']) ? $extras['signature'] : null);
  233.             $userInstance->setSource(!empty($extras['source']) ? $extras['source'] : 'website');
  234.             $userInstance->setIsActive(!empty($extras['active']) ? (bool) $extras['active'] : false);
  235.             $userInstance->setIsVerified(!empty($extras['verified']) ? (bool) $extras['verified'] : false);
  236.             $userInstance->setIsStarred(!empty($extras['starred']) ? (bool) $extras['starred'] : false);
  238.             if (!empty($extras['image'])) {
  239.                 $assetDetails = $this->container->get('uvdesk.core.file_system.service')->getUploadManager()->uploadFile($extras['image'], 'profile');
  241.                 if (!empty($assetDetails)) {
  242.                     $userInstance->setProfileImagePath($assetDetails['path']);
  243.                 }
  244.             }
  246.             $this->entityManager->persist($userInstance);
  247.             $this->entityManager->flush();
  249.             $user->addUserInstance($userInstance);
  251.             // Trigger user created event
  252.             $eventId = 'ROLE_CUSTOMER' == $role->getCode() ? CoreWorkflowEvents\Customer\Create::getId() : CoreWorkflowEvents\Agent\Create::getId();
  253.             $event = new GenericEvent($eventId, ['entity' => $user]);
  255.             $this->container->get('event_dispatcher')->dispatch($event, 'uvdesk.automation.workflow.execute');
  256.         }
  258.         return $user;
  259.     }
  261.     public function getAgentPartialDataCollection(Request $request = null)
  262.     {
  263.         $queryBuilder = $this->entityManager->createQueryBuilder()
  264.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', COALESCE(user.lastName, '')) as name, userInstance.profileImagePath as smallThumbnail")
  265.             ->from(User::class, 'user')
  266.             ->leftJoin('user.userInstance', 'userInstance')
  267.             ->leftJoin('userInstance.supportRole', 'supportRole')
  268.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  269.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  270.             ->orderBy('name', Criteria::ASC);
  272.         if ($request && null != $request->query->get('query')) {
  273.             $queryBuilder
  274.                 ->andWhere("CONCAT(user.firstName,' ', user.lastName) LIKE :customerName")
  275.                 ->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%');
  276.         }
  278.         if ($request && null != $request->query->get('not')) {
  279.             $queryBuilder
  280.                 ->andwhere("u.id NOT IN (:ids)")
  281.                 ->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  282.         }
  284.         return $queryBuilder->getQuery()->getArrayResult();
  285.     }
  287.     public function getAgentsPartialDetails(Request $request = null) {
  288.         static $agents;
  289.         if (null !== $agents)
  290.             return $agents;
  292.         $qb = $this->entityManager->createQueryBuilder();
  293.         $qb->select("u.id, userInstance.id as udId,u.email,CONCAT(u.firstName,' ', u.lastName) AS name,userInstance.profileImagePath as smallThumbnail")->from(User::class, 'u')
  294.                 ->leftJoin('u.userInstance', 'userInstance')
  295.                 ->andwhere('userInstance.supportRole != :roles')
  296.                 ->setParameter('roles', 4)
  297.                 ->andwhere('userInstance.isActive = 1')
  298.                 ->orderBy('name','ASC');
  300.         if($request) {
  301.             $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  302.             $qb->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%');
  303.             $qb->andwhere("u.id NOT IN (:ids)");
  304.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  305.         }
  307.         $data = $agents = $qb->getQuery()->getArrayResult();
  308.         return $data;
  309.     }
  311.     public function getAgentDetailById($agentId) {
  312.         if(!$agentId) return;
  313.         $qb = $this->entityManager->createQueryBuilder();
  314.         $qb->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")
  315.             ->from(User::class, 'u')
  316.             ->leftJoin('u.userInstance', 'userInstance')
  317.             ->andwhere('userInstance.supportRole != :roles')
  318.             ->andwhere('u.id = :agentId')
  319.             ->setParameter('roles', 4)
  320.             ->setParameter('agentId', $agentId);
  322.         $result = $qb->getQuery()->getResult();
  324.         return isset($result[0]) ? $result[0] : null;
  325.     }
  327.     public function getUsersByGroupId($groupId)
  328.     {
  329.         $qb = $this->entityManager->createQueryBuilder();
  330.         $qb->select("DISTINCT user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) AS name, userInstance.profileImagePath as smallThumbnail")
  331.             ->from(User::class, 'user')
  332.             ->leftJoin('user.userInstance', 'userInstance')
  333.                 ->leftJoin('userInstance.supportGroups', 'supportGroup')
  334.                 ->andWhere('userInstance.supportRole != :roles')->setParameter('roles', 4)
  335.                 ->andwhere('supportGroup.id = :groupId')->setParameter('groupId', $groupId)
  336.                 ->andwhere('userInstance.isActive = 1');
  338.         $data = $qb->getQuery()->getArrayResult();
  339.         return $data;
  340.     }
  342.     public function getUsersBySubGroupId($subGroupId)
  343.     {
  344.         $qb = $this->entityManager->createQueryBuilder();
  345.         $qb->select("DISTINCT user.id, supportTeam.id as udId,user.email,CONCAT(user.firstName,' ', user.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  346.                 ->from(User::class, 'user')
  347.                 ->leftJoin('user.userInstance', 'userInstance')
  348.                 ->leftJoin('userInstance.supportTeams', 'supportTeam')
  349.                 ->andwhere('userInstance.supportRole != :roles')
  350.                 ->andwhere('supportTeam.id = :subGroupId')
  351.                 ->setParameter('roles', 4)
  352.                 ->setParameter('subGroupId', $subGroupId)
  353.                 ->andwhere('supportTeam.isActive = 1')
  354.                 ->andwhere('userInstance.isActive = 1');
  356.         $data = $qb->getQuery()->getArrayResult();
  357.         return $data;
  358.     }
  360.     public function getCustomerDetailsById($customerId)
  361.     {
  362.         $qb = $this->entityManager->createQueryBuilder();
  363.         $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')
  364.                 ->leftJoin('user.userInstance', 'userInstance')
  365.                 ->andwhere('userInstance.supportRole = :roles')
  366.                 ->andwhere('user.id = :customerId')
  367.                 ->setParameter('roles', 4)
  368.                 ->setParameter('customerId', $customerId);
  370.         $result = $qb->getQuery()->getResult();
  371.         return ($result ? $result[0] : null);
  372.     }
  374.     public function getCustomerPartialDetailById($customerId)
  375.     {
  376.         $qb = $this->entityManager->createQueryBuilder();
  377.         $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')
  378.             ->leftJoin('u.userInstance', 'userInstance')
  379.             ->andwhere('userInstance.supportRole = :roles')
  380.             ->andwhere('u.id = :customerId')
  381.             ->setParameter('roles', 4)
  382.             ->setParameter('customerId', $customerId);
  384.         $result = $qb->getQuery()->getResult();
  386.         return $result ? $result[0] : null;
  387.     }
  389.     public function getCustomersPartial(Request $request = null)
  390.     {
  391.         $qb = $this->entityManager->createQueryBuilder();
  392.         $qb->from(User::class, 'u');
  394.         $qb->select("DISTINCT u.id,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, userInstance.profileImagePath as smallThumbnail ")
  395.             ->leftJoin('u.userInstance', 'userInstance')
  396.             ->andwhere('userInstance.supportRole = :roles')
  397.             ->setParameter('roles', 4)
  398.             ->orderBy('name','ASC');
  399.         
  400.         if ($request) {
  401.             if ($request->query->get('query')) {
  402.                 $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName OR u.email LIKE :customerName");
  403.             } else {
  404.                 $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  405.             }
  406.             
  407.             $qb->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%')
  408.                 ->andwhere("u.id NOT IN (:ids)")
  409.                 ->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  410.         }
  412.         $query = $qb->getQuery();
  413.         // $query->useResultCache(true, 3600, 'customer_list_'.$this->getCompany()->getId());
  415.         return $query->getScalarResult();
  416.     }
  418.     public function getCustomersCount()
  419.     {
  420.         $qb = $this->entityManager->createQueryBuilder();
  421.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  422.                 ->leftJoin('t.customer', 'c');
  424.         $this->entityManager->getRepository(Ticket::class)->addPermissionFilter($qb, $this->container, false);
  426.         return $qb->getQuery()->getSingleScalarResult();
  427.     }
  429.     public function getUserSubGroupIds($userId) {
  430.         $qb = $this->entityManager->createQueryBuilder();
  431.         $qb->select('supportTeams.id')->from(User::class, 'user')
  432.                 ->leftJoin('user.userInstance','userInstance')
  433.                 ->leftJoin('userInstance.supportTeams','supportTeams')
  434.                 ->andwhere('user.id = :userId')
  435.                 ->andwhere('userInstance.supportRole != :agentRole')
  436.                 ->andwhere('supportTeams.isActive = 1')
  437.                 ->setParameter('userId', $userId)
  438.                 ->setParameter('agentRole', '4'); 
  440.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  441.     }
  443.     public function getUserGroupIds($userId) {
  444.         $qb = $this->entityManager->createQueryBuilder();
  445.         $qb->select('supportGroup.id')->from(User::class, 'user')
  446.                 ->leftJoin('user.userInstance','userInstance')
  447.                 ->leftJoin('userInstance.supportGroups','supportGroup')
  448.                 ->andwhere('user.id = :userId')
  449.                 ->andwhere('supportGroup.isActive = 1')
  450.                 ->setParameter('userId', $userId);
  452.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  453.     }
  455.     public function createUser($data)
  456.     {
  457.         $user = new User();
  458.         $user->setEmail($data['from']);
  459.         $user->setFirstName($data['firstName']);
  460.         $user->setLastName($data['lastName']);
  461.         $user->setIsEnabled($data['isActive']);
  462.         $this->entityManager->persist($user);
  463.         // $this->entityManager->flush();
  464.         $role = $this->entityManager->getRepository(SupportRole::class)->find($data['role']);
  465.     
  466.         $userInstance = new UserInstance();
  467.         $userInstance->setSupportRole($role);
  468.         $userInstance->setUser($user);
  469.         $userInstance->setIsActive($data['isActive']);
  470.         $userInstance->setIsVerified(0);
  471.         if(isset($data['source']))
  472.             $userInstance->setSource($data['source']);
  473.         else
  474.             $userInstance->setSource('website');
  475.         if(isset($data['contactNumber'])) {
  476.             $userInstance->setContactNumber($data['contactNumber']);
  477.         }
  478.         if(isset($data['profileImage']) && $data['profileImage']) {
  479.                 $userInstance->setProfileImagePath($data['profileImage']);
  480.         }
  481.         $this->entityManager->persist($userInstance);
  482.         $this->entityManager->flush();
  484.         $user->addUserInstance($userInstance);
  485.         $this->entityManager->persist($user);
  486.         $this->entityManager->flush();
  488.         //$user->setUserName($userInstance->getName());
  489.         return $user;
  490.     }
  492.     public function getWebsiteConfiguration($code)
  493.     {
  494.         $enabled_bundles = $this->container->getParameter('kernel.bundles');
  495.         
  496.         if (!in_array('UVDeskSupportCenterBundle', array_keys($enabled_bundles))) {
  497.             return [
  498.                 'id' =>  1,
  499.                 'website' =>  1,
  500.                 'status' =>  1,
  501.                 'brandColor' => '#7E91F0',
  502.                 'pageBackgroundColor' => '#FFFFFF',
  503.                 'headerBackgroundColor' => '#FFFFFF',
  504.                 'bannerBackgroundColor' => '#7085F4',
  505.                 'navTextColor' =>  '#7085F4',
  506.                 'navActiveColor' => '#7085F4',
  507.                 'linkColor' => '#7085F4',
  508.                 'linkHoverColor' => '#7085F4',
  509.                 'headerLinks' => null,
  510.                 'footerLinks' => null,
  511.                 'articleTextColor' => '#7085F4',
  512.                 'whiteList' => null,
  513.                 'blackList' => null,
  514.                 'siteDescritption' => 'Hi! how can i help you.',
  515.                 'metaDescription' => null,
  516.                 'metaKeywords' => null,
  517.                 'homepageContent' => null,
  518.                 'ticketCreateOption' =>  1,
  519.                 'createdAt' =>  '2018-09-21 16:20:01',
  520.                 'updatedat' =>  '2018-09-21 16:20:01',
  521.                 'broadcastMessage' => null,
  522.                 'removeCustomerLoginButton' => null,
  523.                 'disableCustomerlogin' =>  0,
  524.                 'removeBrandingContent' => null,
  525.                 'loginRequiredToCreate' => null,
  526.                 'script' => null,
  527.                 'customCss' => null,
  528.                 'isActive' => 1,
  529.             ];
  530.         }
  531.         
  532.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  534.         if ($website) {
  535.             $configuration = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy([
  536.                 'website' => $website->getId(), 
  537.                 'isActive' => 1
  538.             ]);
  539.         }
  541.         return !empty($configuration) ? $configuration : false;
  542.     }
  544.     public function getWebsiteDetails($code)
  545.     {
  546.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  548.         return !empty($website) ? $website : false;
  549.     }
  551.     public function convertToTimezone($date, $format = "d-m-Y H:ia")
  552.     {
  553.         if(!$date)
  554.             return "N/A";
  555.         $currentUser = $this->getCurrentUser();
  556.         $date = date_format($date,$format);
  557.         $dateTime = date('Y-m-d H:i:s',strtotime($date));
  558.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  559.         $this->domain = $this->container->get('router')->getContext()->getHost();
  561.         $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  563.         return $scheduleDate->format($format);
  564.     }
  566.     public function convertToDatetimeTimezoneTimestamp($date, $format = "d-m-Y h:ia")
  567.     {
  568.         if(!$date)
  569.             return "N/A";
  570.         $currentUser = $this->getCurrentUser();
  571.         $date = date_format($date, $format);
  572.         $dateTime = date('Y-m-d H:i:s',strtotime($date));
  573.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  574.         $this->domain = $this->container->get('router')->getContext()->getHost();
  576.         $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  578.         return $scheduleDate->getTimestamp();
  579.     }
  581.     public function removeCustomer($customer)
  582.     {
  583.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $customer->getId()));
  585.         $count = count($userData);
  586.         $ticketData = $this->entityManager->getRepository(Ticket::class)->findBy(array('customer' => $customer->getId()));
  588.         $fileService = new Fileservice();
  589.         // Delete all tickets attachments.
  590.         if($ticketData) {
  591.             foreach($ticketData as $ticket) {
  592.                 $threads = $ticket->getThreads();
  593.                 if (count($threads) > 0) {
  594.                     foreach($threads as $thread) {
  595.                         if (!empty($thread)) {
  596.                             $fileService->remove($this->container->getParameter('kernel.project_dir').'/public/assets/threads/'.$thread->getId());
  598.                         }
  599.                     }
  600.                 }
  601.             }
  602.         }
  604.         // Remove profile.
  605.         foreach($userData as $user) {
  606.             if($user->getSupportRole()->getId() == 4 && $user->getProfileImagePath()) {
  607.                 $fileService->remove($this->container->getParameter('kernel.project_dir').'/public'.$user->getProfileImagePath());
  608.             }
  609.         }
  611.         // getCustomerTickets
  612.         $qb = $this->entityManager->createQueryBuilder();
  613.         $query = $qb->delete(Ticket::class, 't')
  614.                     ->andwhere('t.customer = :customerId')
  615.                     ->setParameter('customerId', $customer->getId())
  616.                     ->getQuery();
  618.         $query->execute();
  620.         $qb = $this->entityManager->createQueryBuilder();
  621.         $query = $qb->delete(UserInstance::class, 'userInstance')
  622.                     ->andwhere('userInstance.user = :customerId')
  623.                     ->andwhere('userInstance.supportRole = :roleId')
  624.                     ->setParameter('customerId', $customer->getId())
  625.                     ->setParameter('roleId', 4)
  626.                     ->getQuery();
  628.         $query->execute();
  630.         if($count == 1) {
  631.             $this->entityManager->remove($customer);
  632.             $this->entityManager->flush();
  633.         }
  634.     }
  635.     
  636.     public function removeAgent($user)
  637.     {
  638.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $user->getId()));
  639.         $count = count($userData);
  641.         $qb = $this->entityManager->createQueryBuilder();
  642.         $query = $qb->delete(UserInstance::class, 'ud')
  643.                     ->andwhere('ud.user = :userId')
  644.                     ->andwhere('ud.supportRole = :roleId')
  645.                     ->setParameter('userId', $user->getId())
  646.                     ->setParameter('roleId', 3)
  647.                     ->getQuery();
  649.         $query->execute();
  650.         
  651.         foreach ($user->getAgentInstance()->getSupportGroups() as $group) {
  652.                 $user->getAgentInstance()->removeSupportGroup($group);
  653.                 $this->entityManager->persist($group);
  654.                 $this->entityManager->flush();
  655.             
  656.         }
  658.         $qb = $this->entityManager->createQueryBuilder();
  659.         $query = $qb->update(Ticket::class, 't')
  660.                     ->set('t.agent', ':nullAgent')
  661.                     ->andwhere('t.agent = :agentId')
  662.                     ->setParameter('agentId', $user->getId())
  663.                     ->setParameter('nullAgent', null)
  664.                     ->getQuery();
  666.         $query->execute();
  668.        
  669.         if($count == 1) {
  670.             $this->entityManager->remove($user);
  671.             $this->entityManager->flush();
  672.         }
  673.     }
  675.     public function getWebsiteView()
  676.     {
  677.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code'=>'knowledgebase']);
  678.         $layout  = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website'=>$website->getId()]);
  679.       
  680.         $homepageContent = $layout->getHomepageContent();
  681.         return (!empty($homepageContent)) ? $homepageContent . 'View' : 'masonryView';
  682.     }
  684.     public function getUserDetailById($userId) {
  685.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  686.         foreach ($user->getUserInstance() as $row) {
  687.             if($row->getSupportRole()->getId() != 4)
  688.                 return $row;
  689.         }
  690.         return null;
  691.     }
  693.     public function getUserPrivilegeIds($userId) 
  694.     {
  695.         $qb = $this->entityManager->createQueryBuilder();
  696.         $qb->select('supportPrivileges.id')->from(User::class, 'user')
  697.                 ->leftJoin('user.userInstance','userInstance')
  698.                 ->leftJoin('userInstance.supportPrivileges','supportPrivileges')
  699.                 ->andwhere('user.id = :userId')
  700.                 ->setParameter('userId', $userId);
  702.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  703.     }
  705.     public function getWebsiteSpamDetails($websiteSpam) 
  706.     {
  707.         $blackList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getBlackList()));
  708.         $whiteList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getWhiteList()));
  710.         return [
  711.             'blackList' => $this->filterBlockSpam($blackList),
  712.             'whiteList' => $this->filterBlockSpam($whiteList),
  713.         ];
  714.     }
  716.     public function filterBlockSpam($str) 
  717.     {
  718.         $list = array();
  719.         foreach (explode(',', $str) as $value) {
  720.             if (filter_var($value, FILTER_VALIDATE_EMAIL)) {
  721.                 if (!isset($list['email'])) {
  722.                     $list['email'] = array();
  723.                 }
  725.                 array_push($list['email'], strtolower($value));
  726.             } else if (filter_var($value, FILTER_VALIDATE_IP)) {
  727.                 if (!isset($list['ip'])) {
  728.                     $list['ip'] = array();
  729.                 }
  730.                 
  731.                 array_push($list['ip'], $value);
  732.             } else if (isset($value[0]) && $value[0] == '@') {
  733.                 if (!isset($list['domain'])) {
  734.                     $list['domain'] = array();
  735.                 }
  737.                 array_push($list['domain'], strtolower($value));
  738.             }
  739.         }
  740.         
  741.         return $list;
  742.     }
  744.     // @TODO: Refactor this - We can instead just use \DateTimeZone::listIdentifiers() wherever need be.
  745.     public function getTimezones()
  746.     {
  747.         return \DateTimeZone::listIdentifiers();
  748.     }
  750.     public function getUserSavedReplyReferenceIds()
  751.     {
  752.         // @TODO: Refactor this function
  753.         $savedReplyIds = [];
  754.         $groupIds = [];
  755.         $teamIds = []; 
  756.         $userId = $this->getCurrentUser()->getAgentInstance()->getId();
  758.         // Get all the saved reply the current user has created.
  759.         $savedReplyRepo = $this->entityManager->getRepository(SavedReplies::class)->findAll();
  761.         foreach ($savedReplyRepo as $sr) {
  762.             if ($userId == $sr->getUser()->getId()) {
  763.                 //Save the ids of the saved reply.
  764.                 array_push($savedReplyIds, (int)$sr->getId());
  765.             }
  766.         }
  768.         // Get the ids of the Group(s) the current user is associated with.
  769.         $query = "select * from uv_user_support_groups where userInstanceId =".$userId;
  770.         $connection = $this->entityManager->getConnection();
  771.         $stmt = $connection->prepare($query);
  772.         $stmt->execute();
  773.         $result = $stmt->fetchAll();
  775.         foreach ($result as $row) {
  776.             array_push($groupIds, $row['supportGroupId']);
  777.         }
  779.         // Get all the saved reply's ids that is associated with the user's group(s).
  780.         $query = "select * from uv_saved_replies_groups";
  781.         $stmt = $connection->prepare($query);
  782.         $stmt->execute();
  783.         $result = $stmt->fetchAll();
  785.         foreach ($result as $row) {
  786.             if (in_array($row['group_id'], $groupIds)) {
  787.                 array_push($savedReplyIds, (int) $row['savedReply_id']);
  788.             }
  789.         }
  791.         // Get the ids of the Team(s) the current user is associated with.
  792.         $query = "select * from uv_user_support_teams";
  793.         $connection = $this->entityManager->getConnection();
  794.         $stmt = $connection->prepare($query);
  795.         $stmt->execute();
  796.         $result = $stmt->fetchAll();
  798.         foreach($result as $row) {
  799.             if ($row['userInstanceId'] == $userId) {
  800.                 array_push($teamIds, $row['supportTeamId']);
  801.             }
  802.         }
  804.         $query = "select * from uv_saved_replies_teams";
  805.         $stmt = $connection->prepare($query);
  806.         $stmt->execute();
  807.         $result = $stmt->fetchAll();
  809.         foreach ($result as $row) {
  810.             if (in_array($row['subgroup_id'], $teamIds)) {
  811.                 array_push($savedReplyIds, (int)$row['savedReply_id']);
  812.             }
  813.         }
  815.         return $savedReplyIds;
  816.     }
  817.     
  818.     // Return formatted time on user preference basis
  819.     public function getLocalizedFormattedTime(\DateTime $timestamp, $user = null, $format = 'm-d-y h:i A')
  820.     {
  821.         $activeUserTimeZone = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'Knowledgebase']);
  822.         if (!empty($user) && $user != 'anon.' && $user->getTimezone() != null) {
  823.             $timestamp = clone $timestamp;
  824.             
  825.             $timestamp->setTimeZone(new \DateTimeZone($user->getTimeZone()));
  826.             $format = $user->getTimeFormat();
  827.         }elseif (!empty($activeUserTimeZone) && $activeUserTimeZone != 'anon.' && $activeUserTimeZone->getTimezone() != null) {
  828.             $timestamp = clone $timestamp;
  829.             
  830.             $timestamp->setTimeZone(new \DateTimeZone($activeUserTimeZone->getTimeZone()));
  831.             $format = $activeUserTimeZone->getTimeFormat();
  832.         }
  833.         
  834.         return $timestamp->format($format);
  835.     }
  837.     public function isfileExists($filePath)
  838.     {
  839.         $dir = $this->container->get('kernel')->getProjectDir();
  840.         // $dirSplit = explode('vendor', $dir);
  841.         $file = str_replace("\\",'/', $dir."/".$filePath);
  843.         if (is_dir($file)) { 
  844.             return true;
  845.         }
  846.         
  847.         return false;
  848.     }
  850.     public function getCustomersCountForKudos($container)
  851.     {
  852.         $qb = $this->entityManager->createQueryBuilder();
  853.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  854.                 ->leftJoin('t.customer', 'c');
  856.         $container->get('report.service')->addPermissionFilter($qb, $this->container, false);
  858.         return $qb->getQuery()->getSingleScalarResult();
  859.     }
  860. }