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

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