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

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