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

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.         $ticket = $this->entityManager->getRepository(Ticket::class)->findOneById($request->attributes->get('id'));
  48.         try {
  49.             if ($this->isfileExists('apps/uvdesk/custom-fields')) {
  50.                 $customFieldsService = $this->container->get('uvdesk_package_custom_fields.service');
  51.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_custom_fields';
  52.             } else if ($this->isfileExists('apps/uvdesk/form-component')) {
  53.                 $customFieldsService = $this->container->get('uvdesk_package_form_component.service');
  54.                 $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_form_component';
  55.             }
  56.         } catch (\Exception $e) {
  57.             // @TODO: Log execption message
  58.         }
  60.         $customerCustomFieldSnippet = !empty($customFieldsService) ? $customFieldsService->getCustomerCustomFieldSnippet($ticket) : [];
  62.         if (!empty($registeredBaseTwigPath) && sizeof($customerCustomFieldSnippet["customFieldCollection"]) > 0 ) {
  63.             return $this->twig->render('@' . $registeredBaseTwigPath . '/widgets/CustomFields/customFieldSnippetCustomer.html.twig', $customerCustomFieldSnippet);
  64.         }
  66.         return ;
  67.     }
  69.     public function isGranted($role) {
  70.         $securityContext = $this->container->get('security.token_storage');
  71.        
  72.         try {
  73.             return (bool) ($role == $securityContext->getToken()->getRoles()[0]->getRole());
  74.         } catch (AuthenticationCredentialsNotFoundException $e) {
  75.             // @TODO: Handle Authentication Failure
  76.         }
  78.         return false;
  79.     }
  80.     
  81.     public function getSessionUser()
  82.     {
  83.         $user = $this->container->get('security.token_storage')->getToken()->getUser();
  85.         return $user instanceof User ? $user : null;
  86.     }
  88.     public function getCurrentUser()
  89.     {
  90.         if ($this->container->get('security.token_storage')->getToken()) {
  91.             return $this->container->get('security.token_storage')->getToken()->getUser();
  92.         } else {
  93.             return false;
  94.         }
  95.     }
  96.     
  97.     public function isAccessAuthorized($scope, User $user = null)
  98.     {
  99.         // Return false if no user is provided
  100.         if (empty($user) && !($user = $this->getSessionUser())) {
  101.             return false;
  102.         }
  104.         try {
  105.             $userRole = $user->getCurrentInstance()->getSupportRole()->getCode();
  106.         } catch (\Exception $error) {
  107.             $userRole = '';
  108.         }
  110.         switch ($userRole) {
  111.             case 'ROLE_SUPER_ADMIN':
  112.             case 'ROLE_ADMIN':
  113.                 return true;
  114.             case 'ROLE_AGENT':
  115.                 $agentPrivileges = $this->getUserPrivileges($this->getCurrentUser()->getId());
  116.                 $agentPrivileges = array_merge($agentPrivileges, ['saved_filters_action', 'saved_replies']);
  117.                 
  118.                 return in_array($scope, $agentPrivileges) ? true : false;
  119.             case 'ROLE_CUSTOMER':
  120.             default:
  121.                 break;
  122.         }
  124.         return true;
  125.     }
  127.     public function getUserPrivileges($userId)
  128.     {
  129.         static $agentPrivilege = [];
  130.         
  131.         if (isset($agentPrivilege[$userId])) {
  132.             return $agentPrivilege[$userId];
  133.         }
  134.         
  135.         $userPrivileges = array();
  136.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  137.         $privileges = $user->getAgentInstance()->getSupportPrivileges();  
  138.       
  139.         if ($privileges) {
  140.             foreach ($privileges as $privilege) {
  141.                 $userPrivileges = array_merge($userPrivileges, $privilege->getPrivileges());
  142.             }
  143.         }
  144.         
  145.         $agentPrivilege[$userId] = $this->agentPrivilege[$userId] = $userPrivileges;  
  147.         return $userPrivileges;
  148.     }
  150.     public function getSupportPrivileges()
  151.     {
  152.         $qb = $this->entityManager->createQueryBuilder();
  153.         $qb->select("supportPrivilege")->from(SupportPrivilege::class, 'supportPrivilege');
  154.         
  155.         return $qb->getQuery()->getArrayResult();
  156.     }
  158.     public function getSupportGroups(Request $request = null)
  159.     {
  160.         static $results;
  161.         if(null !== $results)
  162.             return $results;
  163.         $qb = $this->entityManager->createQueryBuilder();
  164.         $qb->select('supportGroup.id, supportGroup.name')->from(SupportGroup::class, 'supportGroup')
  165.                 ->andwhere('supportGroup.isActive = 1');
  166.         if($request) {
  167.             $qb->andwhere("supportGroup.name LIKE :groupName");
  168.             $qb->setParameter('groupName', '%'.urldecode($request->query->get('query')).'%');
  169.             $qb->andwhere("supportGroup.id NOT IN (:ids)");
  170.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  171.         }
  172.         return $results = $qb->getQuery()->getArrayResult();
  173.     }
  175.     public function getSupportTeams(Request $request = null)
  176.     {
  177.         static $results;
  178.         if(null !== $results)
  179.             return $results;
  180.         $queryBuilder = $this->entityManager->createQueryBuilder()
  181.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) as name, userInstance.profileImagePath as smallThumbnail")
  182.             ->from(User::class, 'user')
  183.             ->leftJoin('user.userInstance', 'userInstance')
  184.             ->leftJoin('userInstance.supportRole', 'supportRole')
  185.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  186.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  187.             ->orderBy('name', Criteria::ASC);
  189.         if ($request && null != $request->query->get('query')) {
  190.             $queryBuilder
  191.                 ->andWhere("CONCAT(dt.firstName,' ', dt.lastName) LIKE :customerName")
  192.                 ->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%');
  193.         }
  195.         $qb = $this->entityManager->createQueryBuilder();
  196.         $qb->select('supportTeam.id, supportTeam.name')
  197.            ->from(SupportTeam::class, 'supportTeam');
  198.         $qb->andwhere('supportTeam.isActive = 1');
  199.         
  200.         if($request) {
  201.             $qb->andwhere("supportTeam.name LIKE :subGroupName");
  202.             $qb->setParameter('subGroupName', '%'.urldecode($request->query->get('query')).'%');
  203.             $qb->andwhere("supportTeam.id NOT IN (:ids)");
  204.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  205.         }
  207.         return $results = $qb->getQuery()->getResult();
  208.     }
  210.     public function createUserInstance($email, $name, SupportRole $role, array $extras = [])
  211.     {
  212.         $user = $this->entityManager->getRepository(User::class)->findOneByEmail($email) ?: new User();
  213.         
  214.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  215.         $timeZone = $website->getTimezone();
  216.         $timeFormat = $website->getTimeformat();
  218.         if (null == $user->getId()) {
  219.             $name = explode(' ', trim($name));
  220.             
  221.             $user->setEmail($email);
  222.             $user->setFirstName(isset($extras['firstName']) ? $extras['firstName'] : array_shift($name));
  223.             $user->setLastName(trim(implode(' ', $name)));
  224.             $user->setIsEnabled($extras['active']);
  225.             $user->setTimeZone($timeZone);
  226.             $user->setTimeFormat($timeFormat);
  228.             $this->entityManager->persist($user);
  229.             $this->entityManager->flush();
  230.         }
  231.         
  232.         $userInstance = 'ROLE_CUSTOMER' == $role->getCode() ? $user->getCustomerInstance() : $user->getAgentInstance();
  233.         
  234.         if (empty($userInstance)) {
  235.             $userInstance = new UserInstance();
  236.                 
  237.             $userInstance->setUser($user);
  238.             $userInstance->setSupportRole($role);
  239.             $userInstance->setContactNumber(!empty($extras['contact']) ? $extras['contact'] : null);
  240.             $userInstance->setSkypeId(!empty($extras['skype']) ? $extras['skype'] : null);
  241.             $userInstance->setDesignation(!empty($extras['designation']) ? $extras['designation'] : null);
  242.             $userInstance->setSignature(!empty($extras['signature']) ? $extras['signature'] : null);
  244.             $userInstance->setSource(!empty($extras['source']) ? $extras['source'] : 'website');
  245.             $userInstance->setIsActive(!empty($extras['active']) ? (bool) $extras['active'] : false);
  246.             $userInstance->setIsVerified(!empty($extras['verified']) ? (bool) $extras['verified'] : false);
  247.             $userInstance->setIsStarred(!empty($extras['starred']) ? (bool) $extras['starred'] : false);
  249.             if (!empty($extras['image'])) {
  250.                 $assetDetails = $this->container->get('uvdesk.core.file_system.service')->getUploadManager()->uploadFile($extras['image'], 'profile');
  252.                 if (!empty($assetDetails)) {
  253.                     $userInstance->setProfileImagePath($assetDetails['path']);
  254.                 }
  255.             }
  257.             $this->entityManager->persist($userInstance);
  258.             $this->entityManager->flush();
  260.             $user->addUserInstance($userInstance);
  262.             // Trigger user created event
  263.             $event = $role->getCode() == 'ROLE_CUSTOMER' ? new CoreWorkflowEvents\Customer\Create() : new CoreWorkflowEvents\Agent\Create();
  264.             $event
  265.                 ->setUser($user)
  266.             ;
  268.             $this->container->get('event_dispatcher')->dispatch($event, 'uvdesk.automation.workflow.execute');
  269.         }
  271.         return $user;
  272.     }
  274.     public function getAgentPartialDataCollection(Request $request = null)
  275.     {
  276.         $queryBuilder = $this->entityManager->createQueryBuilder()
  277.             ->select("user.id, user.email, CONCAT(user.firstName, ' ', COALESCE(user.lastName, '')) as name, userInstance.profileImagePath as smallThumbnail")
  278.             ->from(User::class, 'user')
  279.             ->leftJoin('user.userInstance', 'userInstance')
  280.             ->leftJoin('userInstance.supportRole', 'supportRole')
  281.             ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  282.             ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  283.             ->orderBy('name', Criteria::ASC)
  284.         ;
  286.         if ($request && null != $request->query->get('query')) {
  287.             $queryBuilder
  288.                 ->andWhere("CONCAT(user.firstName,' ', user.lastName) LIKE :customerName")
  289.                 ->setParameter('customerName', '%' . urldecode($request->query->get('query')) . '%')
  290.             ;
  291.         }
  293.         if ($request && null != $request->query->get('not')) {
  294.             $queryBuilder
  295.                 ->andwhere("u.id NOT IN (:ids)")
  296.                 ->setParameter('ids', explode(',', urldecode($request->query->get('not'))))
  297.             ;
  298.         }
  300.         return $queryBuilder->getQuery()->getArrayResult();
  301.     }
  303.     public function getAgentsPartialDetails(Request $request = null)
  304.     {
  305.         static $agents;
  307.         if (null !== $agents) {
  308.             return $agents;
  309.         }
  311.         $qb = $this->entityManager->createQueryBuilder();
  312.         $qb
  313.             ->select("u.id, userInstance.id as udId,u.email,CONCAT(u.firstName,' ', u.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  314.             ->from(User::class, 'u')
  315.             ->leftJoin('u.userInstance', 'userInstance')
  316.             ->andwhere('userInstance.supportRole != :roles')
  317.             ->setParameter('roles', 4)
  318.             ->andwhere('userInstance.isActive = 1')
  319.             ->orderBy('name','ASC')
  320.         ;
  322.         if ($request) {
  323.             $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  324.             $qb->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%');
  325.             $qb->andwhere("u.id NOT IN (:ids)");
  326.             $qb->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  327.         }
  329.         $data = $agents = $qb->getQuery()->getArrayResult();
  331.         return $data;
  332.     }
  334.     public function getAgentDetailById($agentId)
  335.     {
  336.         if (!$agentId) {
  337.             return;
  338.         }
  340.         $qb = $this->entityManager->createQueryBuilder();
  341.         $qb
  342.             ->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")
  343.             ->from(User::class, 'u')
  344.             ->leftJoin('u.userInstance', 'userInstance')
  345.             ->andwhere('userInstance.supportRole != :roles')
  346.             ->andwhere('u.id = :agentId')
  347.             ->setParameter('roles', 4)
  348.             ->setParameter('agentId', $agentId)
  349.         ;
  351.         $result = $qb->getQuery()->getResult();
  353.         return isset($result[0]) ? $result[0] : null;
  354.     }
  356.     public function getUsersByGroupId($groupId)
  357.     {
  358.         $qb = $this->entityManager->createQueryBuilder();
  359.         $qb->select("DISTINCT user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) AS name, userInstance.profileImagePath as smallThumbnail")
  360.             ->from(User::class, 'user')
  361.             ->leftJoin('user.userInstance', 'userInstance')
  362.             ->leftJoin('userInstance.supportGroups', 'supportGroup')
  363.             ->andWhere('userInstance.supportRole != :roles')->setParameter('roles', 4)
  364.             ->andwhere('supportGroup.id = :groupId')->setParameter('groupId', $groupId)
  365.             ->andwhere('userInstance.isActive = 1')
  366.         ;
  368.         $data = $qb->getQuery()->getArrayResult();
  369.         
  370.         return $data;
  371.     }
  373.     public function getUsersBySubGroupId($subGroupId)
  374.     {
  375.         $qb = $this->entityManager->createQueryBuilder();
  376.         $qb->select("DISTINCT user.id, supportTeam.id as udId,user.email,CONCAT(user.firstName,' ', user.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  377.                 ->from(User::class, 'user')
  378.                 ->leftJoin('user.userInstance', 'userInstance')
  379.                 ->leftJoin('userInstance.supportTeams', 'supportTeam')
  380.                 ->andwhere('userInstance.supportRole != :roles')
  381.                 ->andwhere('supportTeam.id = :subGroupId')
  382.                 ->setParameter('roles', 4)
  383.                 ->setParameter('subGroupId', $subGroupId)
  384.                 ->andwhere('supportTeam.isActive = 1')
  385.                 ->andwhere('userInstance.isActive = 1');
  387.         $data = $qb->getQuery()->getArrayResult();
  388.         return $data;
  389.     }
  391.     public function getCustomerDetailsById($customerId)
  392.     {
  393.         $qb = $this->entityManager->createQueryBuilder();
  394.         $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')
  395.                 ->leftJoin('user.userInstance', 'userInstance')
  396.                 ->andwhere('userInstance.supportRole = :roles')
  397.                 ->andwhere('user.id = :customerId')
  398.                 ->setParameter('roles', 4)
  399.                 ->setParameter('customerId', $customerId);
  401.         $result = $qb->getQuery()->getResult();
  402.         return ($result ? $result[0] : null);
  403.     }
  405.     public function getCustomerPartialDetailById($customerId)
  406.     {
  407.         $qb = $this->entityManager->createQueryBuilder();
  408.         $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')
  409.             ->leftJoin('u.userInstance', 'userInstance')
  410.             ->andwhere('userInstance.supportRole = :roles')
  411.             ->andwhere('u.id = :customerId')
  412.             ->setParameter('roles', 4)
  413.             ->setParameter('customerId', $customerId);
  415.         $result = $qb->getQuery()->getResult();
  417.         return $result ? $result[0] : null;
  418.     }
  420.     public function getCustomersPartial(Request $request = null)
  421.     {
  422.         $qb = $this->entityManager->createQueryBuilder();
  423.         $qb->from(User::class, 'u');
  425.         $qb->select("DISTINCT u.id,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, userInstance.profileImagePath as smallThumbnail ")
  426.             ->leftJoin('u.userInstance', 'userInstance')
  427.             ->andwhere('userInstance.supportRole = :roles')
  428.             ->setParameter('roles', 4)
  429.             ->orderBy('name','ASC');
  430.         
  431.         if ($request) {
  432.             if ($request->query->get('query')) {
  433.                 $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName OR u.email LIKE :customerName");
  434.             } else {
  435.                 $qb->andwhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  436.             }
  437.             
  438.             $qb->setParameter('customerName', '%'.urldecode($request->query->get('query')).'%')
  439.                 ->andwhere("u.id NOT IN (:ids)")
  440.                 ->setParameter('ids', explode(',',urldecode($request->query->get('not'))));
  441.         }
  443.         $query = $qb->getQuery();
  444.         // $query->useResultCache(true, 3600, 'customer_list_'.$this->getCompany()->getId());
  446.         return $query->getScalarResult();
  447.     }
  449.     public function getCustomersCount()
  450.     {
  451.         $qb = $this->entityManager->createQueryBuilder();
  452.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  453.                 ->leftJoin('t.customer', 'c');
  455.         $this->entityManager->getRepository(Ticket::class)->addPermissionFilter($qb, $this->container, false);
  457.         return $qb->getQuery()->getSingleScalarResult();
  458.     }
  460.     public function getUserSubGroupIds($userId) {
  461.         $qb = $this->entityManager->createQueryBuilder();
  462.         $qb->select('supportTeams.id')->from(User::class, 'user')
  463.                 ->leftJoin('user.userInstance','userInstance')
  464.                 ->leftJoin('userInstance.supportTeams','supportTeams')
  465.                 ->andwhere('user.id = :userId')
  466.                 ->andwhere('userInstance.supportRole != :agentRole')
  467.                 ->andwhere('supportTeams.isActive = 1')
  468.                 ->setParameter('userId', $userId)
  469.                 ->setParameter('agentRole', '4'); 
  471.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  472.     }
  474.     public function getUserGroupIds($userId) {
  475.         $qb = $this->entityManager->createQueryBuilder();
  476.         $qb->select('supportGroup.id')->from(User::class, 'user')
  477.                 ->leftJoin('user.userInstance','userInstance')
  478.                 ->leftJoin('userInstance.supportGroups','supportGroup')
  479.                 ->andwhere('user.id = :userId')
  480.                 ->andwhere('supportGroup.isActive = 1')
  481.                 ->setParameter('userId', $userId);
  483.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  484.     }
  486.     public function createUser($data)
  487.     {
  488.         $user = new User();
  489.         $user->setEmail($data['from']);
  490.         $user->setFirstName($data['firstName']);
  491.         $user->setLastName($data['lastName']);
  492.         $user->setIsEnabled($data['isActive']);
  493.         $this->entityManager->persist($user);
  494.         // $this->entityManager->flush();
  495.         $role = $this->entityManager->getRepository(SupportRole::class)->find($data['role']);
  496.     
  497.         $userInstance = new UserInstance();
  498.         $userInstance->setSupportRole($role);
  499.         $userInstance->setUser($user);
  500.         $userInstance->setIsActive($data['isActive']);
  501.         $userInstance->setIsVerified(0);
  502.         if(isset($data['source']))
  503.             $userInstance->setSource($data['source']);
  504.         else
  505.             $userInstance->setSource('website');
  506.         if(isset($data['contactNumber'])) {
  507.             $userInstance->setContactNumber($data['contactNumber']);
  508.         }
  509.         if(isset($data['profileImage']) && $data['profileImage']) {
  510.                 $userInstance->setProfileImagePath($data['profileImage']);
  511.         }
  512.         $this->entityManager->persist($userInstance);
  513.         $this->entityManager->flush();
  515.         $user->addUserInstance($userInstance);
  516.         $this->entityManager->persist($user);
  517.         $this->entityManager->flush();
  519.         //$user->setUserName($userInstance->getName());
  520.         return $user;
  521.     }
  523.     public function getWebsiteConfiguration($code)
  524.     {
  525.         $enabled_bundles = $this->container->getParameter('kernel.bundles');
  526.         
  527.         if (!in_array('UVDeskSupportCenterBundle', array_keys($enabled_bundles))) {
  528.             return [
  529.                 'id' =>  1,
  530.                 'website' =>  1,
  531.                 'status' =>  1,
  532.                 'brandColor' => '#7E91F0',
  533.                 'pageBackgroundColor' => '#FFFFFF',
  534.                 'headerBackgroundColor' => '#FFFFFF',
  535.                 'bannerBackgroundColor' => '#7085F4',
  536.                 'navTextColor' =>  '#7085F4',
  537.                 'navActiveColor' => '#7085F4',
  538.                 'linkColor' => '#7085F4',
  539.                 'linkHoverColor' => '#7085F4',
  540.                 'headerLinks' => null,
  541.                 'footerLinks' => null,
  542.                 'articleTextColor' => '#7085F4',
  543.                 'whiteList' => null,
  544.                 'blackList' => null,
  545.                 'siteDescritption' => 'Hi! how can i help you.',
  546.                 'metaDescription' => null,
  547.                 'metaKeywords' => null,
  548.                 'homepageContent' => null,
  549.                 'ticketCreateOption' =>  1,
  550.                 'createdAt' =>  '2018-09-21 16:20:01',
  551.                 'updatedat' =>  '2018-09-21 16:20:01',
  552.                 'broadcastMessage' => null,
  553.                 'removeCustomerLoginButton' => null,
  554.                 'disableCustomerlogin' =>  0,
  555.                 'removeBrandingContent' => null,
  556.                 'loginRequiredToCreate' => null,
  557.                 'script' => null,
  558.                 'customCss' => null,
  559.                 'isActive' => 1,
  560.             ];
  561.         }
  562.         
  563.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  565.         if ($website) {
  566.             $configuration = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy([
  567.                 'website' => $website->getId(), 
  568.                 'isActive' => 1
  569.             ]);
  570.         }
  572.         return !empty($configuration) ? $configuration : false;
  573.     }
  575.     public function getWebsiteDetails($code)
  576.     {
  577.         $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  579.         return !empty($website) ? $website : false;
  580.     }
  582.     public function convertToTimezone($date, $format = "d-m-Y H:ia")
  583.     {
  584.         if (!$date) {
  585.             return "N/A";
  586.         }
  588.         $date = date_format($date, $format);
  589.         $dateTime = date('Y-m-d H:i:s', strtotime($date));
  590.         
  591.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  592.         $scheduleDate
  593.             ->setTimeZone(new \DateTimeZone('Asia/Kolkata'))
  594.         ;
  596.         return $scheduleDate->format($format);
  597.     }
  599.     public function convertDateTimeToSupportedUserTimeFormat(\DateTime $date, $timezone = "Asia/Kolkata", $timeformat = "d-m-Y H:ia")
  600.     {
  601.         if (empty($date)) {
  602.             return "N/A";
  603.         }
  605.         $currentUser = $this->getCurrentUser();
  607.         if (!empty($currentUser)) {
  608.             if ($currentUser->getTimezone() != null) {
  609.                 $timezone = $currentUser->getTimezone();
  610.             }
  612.             if ($currentUser->getTimeFormat() != null) {
  613.                 $timeformat = $currentUser->getTimeFormat();
  614.             }
  615.         }
  617.         $date
  618.             ->setTimeZone(new \DateTimeZone($timezone))
  619.         ;
  621.         return $date->format($timeformat);
  622.     }
  624.     public function convertToDatetimeTimezoneTimestamp($date, $format = "d-m-Y h:ia")
  625.     {
  626.         if(!$date)
  627.             return "N/A";
  628.         $currentUser = $this->getCurrentUser();
  629.         $date = date_format($date, $format);
  630.         $dateTime = date('Y-m-d H:i:s',strtotime($date));
  631.         $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  632.         $this->domain = $this->container->get('router')->getContext()->getHost();
  634.         $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  636.         return $scheduleDate->getTimestamp();
  637.     }
  639.     public function removeCustomer($customer)
  640.     {
  641.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $customer->getId()));
  643.         $count = count($userData);
  644.         $ticketData = $this->entityManager->getRepository(Ticket::class)->findBy(array('customer' => $customer->getId()));
  646.         $fileService = new Fileservice();
  647.         // Delete all tickets attachments.
  648.         if($ticketData) {
  649.             foreach($ticketData as $ticket) {
  650.                 $threads = $ticket->getThreads();
  651.                 if (count($threads) > 0) {
  652.                     foreach($threads as $thread) {
  653.                         if (!empty($thread)) {
  654.                             $fileService->remove($this->container->getParameter('kernel.project_dir').'/public/assets/threads/'.$thread->getId());
  656.                         }
  657.                     }
  658.                 }
  659.             }
  660.         }
  662.         // Remove profile.
  663.         foreach($userData as $user) {
  664.             if($user->getSupportRole()->getId() == 4 && $user->getProfileImagePath()) {
  665.                 $fileService->remove($this->container->getParameter('kernel.project_dir').'/public'.$user->getProfileImagePath());
  666.             }
  667.         }
  669.         // getCustomerTickets
  670.         $qb = $this->entityManager->createQueryBuilder();
  671.         $query = $qb->delete(Ticket::class, 't')
  672.                     ->andwhere('t.customer = :customerId')
  673.                     ->setParameter('customerId', $customer->getId())
  674.                     ->getQuery();
  676.         $query->execute();
  678.         $qb = $this->entityManager->createQueryBuilder();
  679.         $query = $qb->delete(UserInstance::class, 'userInstance')
  680.                     ->andwhere('userInstance.user = :customerId')
  681.                     ->andwhere('userInstance.supportRole = :roleId')
  682.                     ->setParameter('customerId', $customer->getId())
  683.                     ->setParameter('roleId', 4)
  684.                     ->getQuery();
  686.         $query->execute();
  688.         if($count == 1) {
  689.             $this->entityManager->remove($customer);
  690.             $this->entityManager->flush();
  691.         }
  692.     }
  693.     
  694.     public function removeAgent($user)
  695.     {
  696.         $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $user->getId()));
  697.         $count = count($userData);
  699.         $qb = $this->entityManager->createQueryBuilder();
  700.         $query = $qb->delete(UserInstance::class, 'ud')
  701.                     ->andwhere('ud.user = :userId')
  702.                     ->andwhere('ud.supportRole = :roleId')
  703.                     ->setParameter('userId', $user->getId())
  704.                     ->setParameter('roleId', 3)
  705.                     ->getQuery();
  707.         $query->execute();
  708.         
  709.         foreach ($user->getAgentInstance()->getSupportGroups() as $group) {
  710.                 $user->getAgentInstance()->removeSupportGroup($group);
  711.                 $this->entityManager->persist($group);
  712.                 $this->entityManager->flush();
  713.             
  714.         }
  716.         $qb = $this->entityManager->createQueryBuilder();
  717.         $query = $qb->update(Ticket::class, 't')
  718.                     ->set('t.agent', ':nullAgent')
  719.                     ->andwhere('t.agent = :agentId')
  720.                     ->setParameter('agentId', $user->getId())
  721.                     ->setParameter('nullAgent', null)
  722.                     ->getQuery();
  724.         $query->execute();
  726.        
  727.         if($count == 1) {
  728.             $this->entityManager->remove($user);
  729.             $this->entityManager->flush();
  730.         }
  731.     }
  733.     public function getWebsiteView()
  734.     {
  735.         $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code'=>'knowledgebase']);
  736.         $layout  = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website'=>$website->getId()]);
  737.       
  738.         $homepageContent = $layout->getHomepageContent();
  739.         return (!empty($homepageContent)) ? $homepageContent . 'View' : 'masonryView';
  740.     }
  742.     public function getUserDetailById($userId) {
  743.         $user = $this->entityManager->getRepository(User::class)->find($userId);
  744.         foreach ($user->getUserInstance() as $row) {
  745.             if($row->getSupportRole()->getId() != 4)
  746.                 return $row;
  747.         }
  748.         return null;
  749.     }
  751.     public function getUserPrivilegeIds($userId) 
  752.     {
  753.         $qb = $this->entityManager->createQueryBuilder();
  754.         $qb
  755.             ->select('supportPrivileges.id')
  756.             ->from(User::class, 'user')
  757.             ->leftJoin('user.userInstance','userInstance')
  758.             ->leftJoin('userInstance.supportPrivileges','supportPrivileges')
  759.             ->andwhere('user.id = :userId')
  760.             ->setParameter('userId', $userId)
  761.         ;
  763.         return array_column($qb->getQuery()->getArrayResult(), 'id');
  764.     }
  766.     public function getWebsiteSpamDetails($websiteSpam) 
  767.     {
  768.         $blackList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getBlackList()));
  769.         $whiteList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getWhiteList()));
  771.         return [
  772.             'blackList' => $this->filterBlockSpam($blackList),
  773.             'whiteList' => $this->filterBlockSpam($whiteList),
  774.         ];
  775.     }
  777.     public function filterBlockSpam($str) 
  778.     {
  779.         $list = array();
  780.         foreach (explode(',', $str) as $value) {
  781.             if (filter_var($value, FILTER_VALIDATE_EMAIL)) {
  782.                 if (!isset($list['email'])) {
  783.                     $list['email'] = array();
  784.                 }
  786.                 array_push($list['email'], strtolower($value));
  787.             } else if (filter_var($value, FILTER_VALIDATE_IP)) {
  788.                 if (!isset($list['ip'])) {
  789.                     $list['ip'] = array();
  790.                 }
  791.                 
  792.                 array_push($list['ip'], $value);
  793.             } else if (isset($value[0]) && $value[0] == '@') {
  794.                 if (!isset($list['domain'])) {
  795.                     $list['domain'] = array();
  796.                 }
  798.                 array_push($list['domain'], strtolower($value));
  799.             }
  800.         }
  801.         
  802.         return $list;
  803.     }
  805.     // @TODO: Refactor this - We can instead just use \DateTimeZone::listIdentifiers() wherever need be.
  806.     public function getTimezones()
  807.     {
  808.         return \DateTimeZone::listIdentifiers();
  809.     }
  811.     public function getUserSavedReplyReferenceIds()
  812.     {
  813.         // @TODO: Refactor this function
  814.         $savedReplyIds = [];
  815.         $groupIds = [];
  816.         $teamIds = []; 
  817.         $userId = $this->getCurrentUser()->getAgentInstance()->getId();
  819.         // Get all the saved reply the current user has created.
  820.         $savedReplyRepo = $this->entityManager->getRepository(SavedReplies::class)->findAll();
  822.         foreach ($savedReplyRepo as $sr) {
  823.             if ($userId == $sr->getUser()->getId()) {
  824.                 //Save the ids of the saved reply.
  825.                 array_push($savedReplyIds, (int)$sr->getId());
  826.             }
  827.         }
  829.         // Get the ids of the Group(s) the current user is associated with.
  830.         $query = "select * from uv_user_support_groups where userInstanceId =".$userId;
  831.         $connection = $this->entityManager->getConnection();
  832.         $stmt = $connection->prepare($query);
  833.         $stmt->execute();
  834.         $result = $stmt->fetchAll();
  836.         foreach ($result as $row) {
  837.             array_push($groupIds, $row['supportGroupId']);
  838.         }
  840.         // Get all the saved reply's ids that is associated with the user's group(s).
  841.         $query = "select * from uv_saved_replies_groups";
  842.         $stmt = $connection->prepare($query);
  843.         $stmt->execute();
  844.         $result = $stmt->fetchAll();
  846.         foreach ($result as $row) {
  847.             if (in_array($row['group_id'], $groupIds)) {
  848.                 array_push($savedReplyIds, (int) $row['savedReply_id']);
  849.             }
  850.         }
  852.         // Get the ids of the Team(s) the current user is associated with.
  853.         $query = "select * from uv_user_support_teams";
  854.         $connection = $this->entityManager->getConnection();
  855.         $stmt = $connection->prepare($query);
  856.         $stmt->execute();
  857.         $result = $stmt->fetchAll();
  859.         foreach($result as $row) {
  860.             if ($row['userInstanceId'] == $userId) {
  861.                 array_push($teamIds, $row['supportTeamId']);
  862.             }
  863.         }
  865.         $query = "select * from uv_saved_replies_teams";
  866.         $stmt = $connection->prepare($query);
  867.         $stmt->execute();
  868.         $result = $stmt->fetchAll();
  870.         foreach ($result as $row) {
  871.             if (in_array($row['subgroup_id'], $teamIds)) {
  872.                 array_push($savedReplyIds, (int)$row['savedReply_id']);
  873.             }
  874.         }
  876.         return $savedReplyIds;
  877.     }
  878.     
  879.     // Return formatted time on user preference basis
  880.     public function getLocalizedFormattedTime(\DateTime $timestamp, $user = null, $format = 'm-d-y h:i A')
  881.     {
  882.         $activeUserTimeZone = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'Knowledgebase']);
  883.         if (!empty($user) && $user != 'anon.' && $user->getTimezone() != null) {
  884.             $timestamp = clone $timestamp;
  885.             
  886.             $timestamp->setTimeZone(new \DateTimeZone($user->getTimeZone()));
  887.             $format = $user->getTimeFormat();
  888.         }elseif (!empty($activeUserTimeZone) && $activeUserTimeZone != 'anon.' && $activeUserTimeZone->getTimezone() != null) {
  889.             $timestamp = clone $timestamp;
  890.             
  891.             $timestamp->setTimeZone(new \DateTimeZone($activeUserTimeZone->getTimeZone()));
  892.             $format = $activeUserTimeZone->getTimeFormat();
  893.         }
  894.         
  895.         return $timestamp->format($format);
  896.     }
  898.     public function isfileExists($filePath)
  899.     {
  900.         $dir = $this->container->get('kernel')->getProjectDir();
  901.         // $dirSplit = explode('vendor', $dir);
  902.         $file = str_replace("\\",'/', $dir."/".$filePath);
  904.         if (is_dir($file)) { 
  905.             return true;
  906.         }
  907.         
  908.         return false;
  909.     }
  911.     public function getCustomersCountForKudos($container)
  912.     {
  913.         $qb = $this->entityManager->createQueryBuilder();
  914.         $qb->select($qb->expr()->countDistinct('c.id')."as customerCount")->from(Ticket::class, 't')
  915.                 ->leftJoin('t.customer', 'c');
  917.         $container->get('report.service')->addPermissionFilter($qb, $this->container, false);
  919.         return $qb->getQuery()->getSingleScalarResult();
  920.     }
  921. }