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

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Services;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Twig\Environment as TwigEnvironment;
  7. use Doctrine\Common\Collections\Criteria;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\RequestStack;
  10. use Symfony\Component\Filesystem\Filesystem as Fileservice;
  11. use Symfony\Component\DependencyInjection\ContainerInterface;
  12. use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
  13. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportRole;
  14. use Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance;
  15. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket;
  16. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportPrivilege;
  17. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup;
  18. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam;
  19. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SavedReplies;
  20. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Website;
  21. use Webkul\UVDesk\CoreFrameworkBundle\Workflow\Events as CoreWorkflowEvents;
  22. use Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite;
  24. class UserService
  25. {
  26. protected $container;
  27. protected $requestStack;
  28. protected $entityManager;
  29. protected $twig;
  31. public function __construct(ContainerInterface $container, RequestStack $requestStack, EntityManagerInterface $entityManager, TwigEnvironment $twig)
  32. {
  33. $this->container = $container;
  34. $this->requestStack = $requestStack;
  35. $this->entityManager = $entityManager;
  36. $this->twig = $twig;
  37. }
  39. public function getCustomFieldTemplateCustomer()
  40. {
  41. $request = $this->requestStack->getCurrentRequest();
  42. $ticket = $this->entityManager->getRepository(Ticket::class)->findOneById($request->attributes->get('id'));
  44. try {
  45. if ($this->isFileExists('apps/uvdesk/custom-fields')) {
  46. $customFieldsService = $this->container->get('uvdesk_package_custom_fields.service');
  47. $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_custom_fields';
  48. } else if ($this->isFileExists('apps/uvdesk/form-component')) {
  49. $customFieldsService = $this->container->get('uvdesk_package_form_component.service');
  50. $registeredBaseTwigPath = '_uvdesk_extension_uvdesk_form_component';
  51. }
  52. } catch (\Exception $e) {
  53. // @TODO: Log execption message
  54. }
  56. $customerCustomFieldSnippet = !empty($customFieldsService) ? $customFieldsService->getCustomerCustomFieldSnippet($ticket) : [];
  58. if (!empty($registeredBaseTwigPath) && sizeof($customerCustomFieldSnippet["customFieldCollection"]) > 0) {
  59. return $this->twig->render('@' . $registeredBaseTwigPath . '/widgets/CustomFields/customFieldSnippetCustomer.html.twig', $customerCustomFieldSnippet);
  60. }
  62. return;
  63. }
  65. public function isGranted($role)
  66. {
  67. $securityContext = $this->container->get('security.token_storage');
  69. try {
  70. return (bool) ($role == $securityContext->getToken()->getRoles()[0]->getRole());
  71. } catch (AuthenticationCredentialsNotFoundException $e) {
  72. // @TODO: Handle Authentication Failure
  73. }
  75. return false;
  76. }
  78. public function getSessionUser()
  79. {
  80. $user = $this->container->get('security.token_storage')->getToken()?->getUser();
  82. return $user instanceof User ? $user : null;
  83. }
  85. public function getCurrentUser()
  86. {
  87. if ($this->container->get('security.token_storage')->getToken()) {
  88. return $this->container->get('security.token_storage')->getToken()?->getUser();
  89. } else {
  90. return false;
  91. }
  92. }
  94. public function getCountries()
  95. {
  96. return $this->helpdeskCountries = \Symfony\Component\Intl\Countries::getNames();
  97. }
  99. public function isAccessAuthorized($scope, User $user = null)
  100. {
  101. // Return false if no user is provided
  102. if (empty($user) && !($user = $this->getSessionUser())) {
  103. return false;
  104. }
  106. try {
  107. $userRole = $user?->getCurrentInstance()?->getSupportRole()->getCode();
  108. } catch (\Exception $error) {
  109. $userRole = '';
  110. }
  112. switch ($userRole) {
  113. case 'ROLE_SUPER_ADMIN':
  114. case 'ROLE_ADMIN':
  115. return true;
  116. case 'ROLE_AGENT':
  117. $agentPrivileges = $this->getUserPrivileges($this->getCurrentUser()?->getId());
  118. $agentPrivileges = array_merge($agentPrivileges, ['saved_filters_action', 'saved_replies']);
  120. return in_array($scope, $agentPrivileges) ? true : false;
  121. case 'ROLE_CUSTOMER':
  122. default:
  123. break;
  124. }
  126. return true;
  127. }
  129. public function getUserPrivileges($userId)
  130. {
  131. static $agentPrivilege = [];
  133. if (isset($agentPrivilege[$userId])) {
  134. return $agentPrivilege[$userId];
  135. }
  137. $userPrivileges = array();
  138. $user = $this->entityManager->getRepository(User::class)->find($userId);
  139. $privileges = $user->getAgentInstance()->getSupportPrivileges();
  141. if ($privileges) {
  142. foreach ($privileges as $privilege) {
  143. $userPrivileges = array_merge($userPrivileges, $privilege->getPrivileges());
  144. }
  145. }
  147. $agentPrivilege[$userId] = $this->agentPrivilege[$userId] = $userPrivileges;
  149. return $userPrivileges;
  150. }
  152. public function getSupportPrivileges()
  153. {
  154. $qb = $this->entityManager->createQueryBuilder();
  155. $qb->select("supportPrivilege")->from(SupportPrivilege::class, 'supportPrivilege');
  157. return $qb->getQuery()->getArrayResult();
  158. }
  160. public function getSupportGroups(Request $request = null)
  161. {
  162. static $results;
  163. if (null !== $results)
  164. return $results;
  165. $qb = $this->entityManager->createQueryBuilder();
  166. $qb->select('supportGroup.id, supportGroup.name')->from(SupportGroup::class, 'supportGroup')
  167. ->andWhere('supportGroup.isActive = 1');
  168. if ($request) {
  169. $qb->andWhere("supportGroup.name LIKE :groupName");
  170. $qb->setParameter('groupName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  171. $qb->andWhere("supportGroup.id NOT IN (:ids)");
  172. $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  173. }
  175. return $results = $qb->getQuery()->getArrayResult();
  176. }
  178. public function getSupportTeams(Request $request = null)
  179. {
  180. static $results;
  181. if (null !== $results)
  182. return $results;
  184. $queryBuilder = $this->entityManager->createQueryBuilder()
  185. ->select("user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) as name, userInstance.profileImagePath as smallThumbnail")
  186. ->from(User::class, 'user')
  187. ->leftJoin('user.userInstance', 'userInstance')
  188. ->leftJoin('userInstance.supportRole', 'supportRole')
  189. ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  190. ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  191. ->orderBy('name', Criteria::ASC);
  193. if ($request && null != $request->query->get('query')) {
  194. $queryBuilder
  195. ->andWhere("CONCAT(dt.firstName,' ', dt.lastName) LIKE :customerName")
  196. ->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  197. }
  199. $qb = $this->entityManager->createQueryBuilder();
  200. $qb->select('supportTeam.id, supportTeam.name')
  201. ->from(SupportTeam::class, 'supportTeam');
  202. $qb->andWhere('supportTeam.isActive = 1');
  204. if ($request) {
  205. $qb->andWhere("supportTeam.name LIKE :subGroupName");
  206. $qb->setParameter('subGroupName', '%' . urldecode($request->query->get('query')) . '%');
  207. $qb->andWhere("supportTeam.id NOT IN (:ids)");
  208. $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  209. }
  211. return $results = $qb->getQuery()->getResult();
  212. }
  214. public function createUserInstance($email, $name, SupportRole $role, array $extras = [])
  215. {
  216. $user = $this->entityManager->getRepository(User::class)->findOneByEmail($email) ?: new User();
  218. $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  219. $timeZone = $website->getTimezone();
  220. $timeFormat = $website->getTimeformat();
  222. if (null == $user->getId()) {
  223. $name = explode(' ', trim($name));
  225. $user->setEmail($email);
  226. $user->setFirstName(isset($extras['firstName']) ? $extras['firstName'] : array_shift($name));
  227. $user->setLastName(trim(implode(' ', $name)));
  228. $user->setIsEnabled($extras['active']);
  229. $user->setTimeZone($timeZone);
  230. $user->setTimeFormat($timeFormat);
  232. $this->entityManager->persist($user);
  233. $this->entityManager->flush();
  234. }
  236. $userInstance = 'ROLE_CUSTOMER' == $role->getCode() ? $user->getCustomerInstance() : $user->getAgentInstance();
  238. if (empty($userInstance)) {
  239. $userInstance = new UserInstance();
  241. $userInstance->setUser($user);
  242. $userInstance->setSupportRole($role);
  243. $userInstance->setContactNumber(!empty($extras['contact']) ? $extras['contact'] : null);
  244. $userInstance->setSkypeId(!empty($extras['skype']) ? $extras['skype'] : null);
  245. $userInstance->setDesignation(!empty($extras['designation']) ? $extras['designation'] : null);
  246. $userInstance->setSignature(!empty($extras['signature']) ? $extras['signature'] : null);
  248. $userInstance->setSource(!empty($extras['source']) ? $extras['source'] : 'website');
  249. $userInstance->setIsActive(!empty($extras['active']) ? (bool) $extras['active'] : false);
  250. $userInstance->setIsVerified(!empty($extras['verified']) ? (bool) $extras['verified'] : false);
  251. $userInstance->setIsStarred(!empty($extras['starred']) ? (bool) $extras['starred'] : false);
  253. if (!empty($extras['image'])) {
  254. $assetDetails = $this->container->get('uvdesk.core.file_system.service')->getUploadManager()->uploadFile($extras['image'], 'profile');
  256. if (!empty($assetDetails)) {
  257. $userInstance->setProfileImagePath($assetDetails['path']);
  258. }
  259. }
  261. $this->entityManager->persist($userInstance);
  262. $this->entityManager->flush();
  264. $user->addUserInstance($userInstance);
  266. // Trigger user created event
  267. $event = $role->getCode() == 'ROLE_CUSTOMER' ? new CoreWorkflowEvents\Customer\Create() : new CoreWorkflowEvents\Agent\Create();
  268. $event
  269. ->setUser($user);
  271. $this->container->get('event_dispatcher')->dispatch($event, 'uvdesk.automation.workflow.execute');
  272. }
  274. return $user;
  275. }
  277. public function getAgentPartialDataCollection(Request $request = null)
  278. {
  279. $queryBuilder = $this->entityManager->createQueryBuilder()
  280. ->select("user.id, user.email, CONCAT(user.firstName, ' ', COALESCE(user.lastName, '')) as name, userInstance.profileImagePath as smallThumbnail, userInstance.isOnline")
  281. ->from(User::class, 'user')
  282. ->leftJoin('user.userInstance', 'userInstance')
  283. ->leftJoin('userInstance.supportRole', 'supportRole')
  284. ->where('supportRole.code != :customerRole')->setParameter('customerRole', 'ROLE_CUSTOMER')
  285. ->andWhere('userInstance.isActive = :isUserActive')->setParameter('isUserActive', true)
  286. ->orderBy('name', Criteria::ASC);
  288. if ($request && null != $request->query->get('query')) {
  289. $queryBuilder
  290. ->andWhere("CONCAT(user.firstName,' ', user.lastName) LIKE :customerName")
  291. ->setParameter('customerName', '%' . urldecode($request->query->get('query')) . '%')
  292. ;
  293. }
  295. if ($request && null != $request->query->get('not')) {
  296. $queryBuilder
  297. ->andWhere("u.id NOT IN (:ids)")
  298. ->setParameter('ids', explode(',', urldecode($request->query->get('not'))))
  299. ;
  300. }
  302. return $queryBuilder->getQuery()->getArrayResult();
  303. }
  305. public function getAgentsPartialDetails(Request $request = null)
  306. {
  307. static $agents;
  309. if (null !== $agents) {
  310. return $agents;
  311. }
  313. $qb = $this->entityManager->createQueryBuilder();
  314. $qb
  315. ->select("u.id, userInstance.id as udId,u.email,CONCAT(u.firstName,' ', u.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  316. ->from(User::class, 'u')
  317. ->leftJoin('u.userInstance', 'userInstance')
  318. ->andWhere('userInstance.supportRole != :roles')
  319. ->setParameter('roles', 4)
  320. ->andWhere('userInstance.isActive = 1')
  321. ->orderBy('name', 'ASC')
  322. ;
  324. if ($request) {
  325. $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  326. $qb->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%');
  327. $qb->andWhere("u.id NOT IN (:ids)");
  328. $qb->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  329. }
  331. $data = $agents = $qb->getQuery()->getArrayResult();
  333. return $data;
  334. }
  336. public function getAgentDetailById($agentId)
  337. {
  338. if (!$agentId) {
  339. return;
  340. }
  342. $qb = $this->entityManager->createQueryBuilder();
  343. $qb
  344. ->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, userInstance.isOnline")
  345. ->from(User::class, 'u')
  346. ->leftJoin('u.userInstance', 'userInstance')
  347. ->andWhere('userInstance.supportRole != :roles')
  348. ->andWhere('u.id = :agentId')
  349. ->setParameter('roles', 4)
  350. ->setParameter('agentId', $agentId)
  351. ;
  353. $result = $qb->getQuery()->getResult();
  355. return isset($result[0]) ? $result[0] : null;
  356. }
  358. public function getUsersByGroupId($groupId)
  359. {
  360. $qb = $this->entityManager->createQueryBuilder();
  361. $qb->select("DISTINCT user.id, user.email, CONCAT(user.firstName, ' ', user.lastName) AS name, userInstance.profileImagePath as smallThumbnail")
  362. ->from(User::class, 'user')
  363. ->leftJoin('user.userInstance', 'userInstance')
  364. ->leftJoin('userInstance.supportGroups', 'supportGroup')
  365. ->andWhere('userInstance.supportRole != :roles')->setParameter('roles', 4)
  366. ->andWhere('supportGroup.id = :groupId')->setParameter('groupId', $groupId)
  367. ->andWhere('userInstance.isActive = 1')
  368. ;
  370. $data = $qb->getQuery()->getArrayResult();
  372. return $data;
  373. }
  375. public function getUsersBySubGroupId($subGroupId)
  376. {
  377. $qb = $this->entityManager->createQueryBuilder();
  378. $qb->select("DISTINCT user.id, supportTeam.id as udId,user.email,CONCAT(user.firstName,' ', user.lastName) AS name,userInstance.profileImagePath as smallThumbnail")
  379. ->from(User::class, 'user')
  380. ->leftJoin('user.userInstance', 'userInstance')
  381. ->leftJoin('userInstance.supportTeams', 'supportTeam')
  382. ->andWhere('userInstance.supportRole != :roles')
  383. ->andWhere('supportTeam.id = :subGroupId')
  384. ->setParameter('roles', 4)
  385. ->setParameter('subGroupId', $subGroupId)
  386. ->andWhere('supportTeam.isActive = 1')
  387. ->andWhere('userInstance.isActive = 1');
  389. $data = $qb->getQuery()->getArrayResult();
  391. return $data;
  392. }
  394. public function getCustomerDetailsById($customerId)
  395. {
  396. $qb = $this->entityManager->createQueryBuilder();
  397. $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')
  398. ->leftJoin('user.userInstance', 'userInstance')
  399. ->andWhere('userInstance.supportRole = :roles')
  400. ->andWhere('user.id = :customerId')
  401. ->setParameter('roles', 4)
  402. ->setParameter('customerId', $customerId);
  404. $result = $qb->getQuery()->getResult();
  406. return ($result ? $result[0] : null);
  407. }
  409. public function getCustomerPartialDetailById($customerId)
  410. {
  411. $qb = $this->entityManager->createQueryBuilder();
  412. $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')
  413. ->leftJoin('u.userInstance', 'userInstance')
  414. ->andWhere('userInstance.supportRole = :roles')
  415. ->andWhere('u.id = :customerId')
  416. ->setParameter('roles', 4)
  417. ->setParameter('customerId', $customerId);
  419. $result = $qb->getQuery()->getResult();
  421. return $result ? $result[0] : null;
  422. }
  424. public function getCustomersPartial(Request $request = null)
  425. {
  426. $qb = $this->entityManager->createQueryBuilder();
  427. $qb->from(User::class, 'u');
  429. $qb->select("DISTINCT u.id,u.email,CONCAT(u.firstName,' ', COALESCE(u.lastName,'')) AS name, userInstance.profileImagePath as smallThumbnail ")
  430. ->leftJoin('u.userInstance', 'userInstance')
  431. ->andWhere('userInstance.supportRole = :roles')
  432. ->setParameter('roles', 4)
  433. ->orderBy('name', 'ASC');
  435. if ($request) {
  436. if ($request->query->get('query')) {
  437. $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName OR u.email LIKE :customerName");
  438. } else {
  439. $qb->andWhere("CONCAT(u.firstName,' ', u.lastName) LIKE :customerName");
  440. }
  442. $qb->setParameter('customerName', '%' . urldecode(trim($request->query->get('query'))) . '%')
  443. ->andWhere("u.id NOT IN (:ids)")
  444. ->setParameter('ids', explode(',', urldecode($request->query->get('not'))));
  445. }
  447. $query = $qb->getQuery();
  449. return $query->getScalarResult();
  450. }
  452. public function getCustomersCount()
  453. {
  454. $qb = $this->entityManager->createQueryBuilder();
  455. $qb->select($qb->expr()->countDistinct('c.id') . "as customerCount")->from(Ticket::class, 't')
  456. ->leftJoin('t.customer', 'c');
  458. $this->entityManager->getRepository(Ticket::class)->addPermissionFilter($qb, $this->container, false);
  460. return $qb->getQuery()->getSingleScalarResult();
  461. }
  463. public function getUserSubGroupIds($userId)
  464. {
  465. $qb = $this->entityManager->createQueryBuilder();
  466. $qb->select('supportTeams.id')->from(User::class, 'user')
  467. ->leftJoin('user.userInstance', 'userInstance')
  468. ->leftJoin('userInstance.supportTeams', 'supportTeams')
  469. ->andWhere('user.id = :userId')
  470. ->andWhere('userInstance.supportRole != :agentRole')
  471. ->andWhere('supportTeams.isActive = 1')
  472. ->setParameter('userId', $userId)
  473. ->setParameter('agentRole', '4');
  475. return array_column($qb->getQuery()->getArrayResult(), 'id');
  476. }
  478. public function getUserGroupIds($userId)
  479. {
  480. $qb = $this->entityManager->createQueryBuilder();
  481. $qb->select('supportGroup.id')->from(User::class, 'user')
  482. ->leftJoin('user.userInstance', 'userInstance')
  483. ->leftJoin('userInstance.supportGroups', 'supportGroup')
  484. ->andWhere('user.id = :userId')
  485. ->andWhere('supportGroup.isActive = 1')
  486. ->setParameter('userId', $userId);
  488. return array_column($qb->getQuery()->getArrayResult(), 'id');
  489. }
  491. public function createUser($data)
  492. {
  493. $user = new User();
  494. $user->setEmail($data['from']);
  495. $user->setFirstName($data['firstName']);
  496. $user->setLastName($data['lastName']);
  497. $user->setIsEnabled($data['isActive']);
  498. $this->entityManager->persist($user);
  500. $role = $this->entityManager->getRepository(SupportRole::class)->find($data['role']);
  502. $userInstance = new UserInstance();
  503. $userInstance->setSupportRole($role);
  504. $userInstance->setUser($user);
  505. $userInstance->setIsActive($data['isActive']);
  506. $userInstance->setIsVerified(0);
  508. if (isset($data['source']))
  509. $userInstance->setSource($data['source']);
  510. else
  511. $userInstance->setSource('website');
  513. if (isset($data['contactNumber'])) {
  514. $userInstance->setContactNumber($data['contactNumber']);
  515. }
  517. if (isset($data['profileImage']) && $data['profileImage']) {
  518. $userInstance->setProfileImagePath($data['profileImage']);
  519. }
  521. $this->entityManager->persist($userInstance);
  522. $this->entityManager->flush();
  524. $user->addUserInstance($userInstance);
  526. $this->entityManager->persist($user);
  527. $this->entityManager->flush();
  529. return $user;
  530. }
  532. public function getWebsiteConfiguration($code)
  533. {
  534. $enabled_bundles = $this->container->getParameter('kernel.bundles');
  536. if (!in_array('UVDeskSupportCenterBundle', array_keys($enabled_bundles))) {
  537. return [
  538. 'id' => 1,
  539. 'website' => 1,
  540. 'status' => 1,
  541. 'brandColor' => '#0056fc',
  542. 'pageBackgroundColor' => '#FFFFFF',
  543. 'headerBackgroundColor' => '#FFFFFF',
  544. 'bannerBackgroundColor' => '#7085F4',
  545. 'navTextColor' => '#7085F4',
  546. 'navActiveColor' => '#7085F4',
  547. 'linkColor' => '#7085F4',
  548. 'linkHoverColor' => '#7085F4',
  549. 'headerLinks' => null,
  550. 'footerLinks' => null,
  551. 'articleTextColor' => '#7085F4',
  552. 'whiteList' => null,
  553. 'blackList' => null,
  554. 'siteDescritption' => 'Hi! how can i help you.',
  555. 'metaDescription' => null,
  556. 'metaKeywords' => null,
  557. 'homepageContent' => null,
  558. 'ticketCreateOption' => 1,
  559. 'createdAt' => '2024-09-21 16:20:01',
  560. 'updatedat' => '2024-09-21 16:20:01',
  561. 'broadcastMessage' => null,
  562. 'removeCustomerLoginButton' => null,
  563. 'disableCustomerlogin' => 0,
  564. 'removeBrandingContent' => null,
  565. 'loginRequiredToCreate' => null,
  566. 'script' => null,
  567. 'customCss' => null,
  568. 'isActive' => 1,
  569. ];
  570. }
  572. $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  574. if ($website) {
  575. $configuration = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy([
  576. 'website' => $website->getId(),
  577. 'isActive' => 1
  578. ]);
  579. }
  581. return !empty($configuration) ? $configuration : false;
  582. }
  584. public function getWebsiteDetails($code)
  585. {
  586. $website = $this->entityManager->getRepository(Website::class)->findOneByCode($code);
  588. return !empty($website) ? $website : false;
  589. }
  591. public function convertToTimezone($date, $format = "d-m-Y H:ia")
  592. {
  593. if (!$date) {
  594. return "N/A";
  595. }
  597. $date = date_format($date, $format);
  598. $dateTime = date('Y-m-d H:i:s', strtotime($date));
  600. $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  601. $scheduleDate
  602. ->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  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));
  628. return $date->format($timeformat);
  629. }
  631. public function convertToDatetimeTimezoneTimestamp($date, $format = "d-m-Y h:ia")
  632. {
  633. if (!$date)
  634. return "N/A";
  635. $currentUser = $this->getCurrentUser();
  636. $date = date_format($date, $format);
  637. $dateTime = date('Y-m-d H:i:s', strtotime($date));
  638. $scheduleDate = new \DateTime($dateTime, new \DateTimeZone(date_default_timezone_get()));
  639. $this->domain = $this->container->get('router')->getContext()->getHost();
  641. $scheduleDate->setTimeZone(new \DateTimeZone('Asia/Kolkata'));
  643. return $scheduleDate->getTimestamp();
  644. }
  646. public function removeCustomer($customer)
  647. {
  648. $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $customer->getId()));
  650. $count = count($userData);
  651. $ticketData = $this->entityManager->getRepository(Ticket::class)->findBy(array('customer' => $customer->getId()));
  653. $fileService = new Fileservice();
  654. // Delete all tickets attachments.
  655. if ($ticketData) {
  656. foreach ($ticketData as $ticket) {
  657. $threads = $ticket->getThreads();
  658. if (count($threads) > 0) {
  659. foreach ($threads as $thread) {
  660. if (!empty($thread)) {
  661. $fileService->remove($this->container->getParameter('kernel.project_dir') . '/public/assets/threads/' . $thread->getId());
  662. }
  663. }
  664. }
  665. }
  666. }
  668. // Remove profile.
  669. foreach ($userData as $user) {
  670. if ($user->getSupportRole()->getId() == 4 && $user->getProfileImagePath()) {
  671. $fileService->remove($this->container->getParameter('kernel.project_dir') . '/public' . $user->getProfileImagePath());
  672. }
  673. }
  675. // getCustomerTickets
  676. $qb = $this->entityManager->createQueryBuilder();
  677. $query = $qb->delete(Ticket::class, 't')
  678. ->andWhere('t.customer = :customerId')
  679. ->setParameter('customerId', $customer->getId())
  680. ->getQuery();
  682. $query->execute();
  684. $qb = $this->entityManager->createQueryBuilder();
  685. $query = $qb->delete(UserInstance::class, 'userInstance')
  686. ->andWhere('userInstance.user = :customerId')
  687. ->andWhere('userInstance.supportRole = :roleId')
  688. ->setParameter('customerId', $customer->getId())
  689. ->setParameter('roleId', 4)
  690. ->getQuery();
  692. $query->execute();
  694. if ($count == 1) {
  695. $this->entityManager->remove($customer);
  696. $this->entityManager->flush();
  697. }
  698. }
  700. public function removeAgent($user)
  701. {
  702. $userData = $this->entityManager->getRepository(UserInstance::class)->findBy(array('user' => $user->getId()));
  703. $count = count($userData);
  705. $qb = $this->entityManager->createQueryBuilder();
  706. $query = $qb->delete(UserInstance::class, 'ud')
  707. ->andWhere('ud.user = :userId')
  708. ->andWhere('ud.supportRole = :roleId')
  709. ->setParameter('userId', $user->getId())
  710. ->setParameter('roleId', 3)
  711. ->getQuery();
  713. $query->execute();
  715. foreach ($user->getAgentInstance()->getSupportGroups() as $group) {
  716. $user->getAgentInstance()->removeSupportGroup($group);
  717. $this->entityManager->persist($group);
  718. $this->entityManager->flush();
  719. }
  721. $qb = $this->entityManager->createQueryBuilder();
  722. $query = $qb->update(Ticket::class, 't')
  723. ->set('t.agent', ':nullAgent')
  724. ->andWhere('t.agent = :agentId')
  725. ->setParameter('agentId', $user->getId())
  726. ->setParameter('nullAgent', null)
  727. ->getQuery();
  729. $query->execute();
  731. if ($count == 1) {
  732. $this->entityManager->remove($user);
  733. $this->entityManager->flush();
  734. }
  735. }
  737. public function getWebsiteView()
  738. {
  739. $website = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'knowledgebase']);
  740. $layout = $this->entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website' => $website->getId()]);
  742. $homepageContent = $layout->getHomepageContent();
  744. return (!empty($homepageContent)) ? $homepageContent . 'View' : 'masonryView';
  745. }
  747. public function getUserDetailById($userId)
  748. {
  749. $user = $this->entityManager->getRepository(User::class)->find($userId);
  750. foreach ($user->getUserInstance() as $row) {
  751. if ($row->getSupportRole()->getId() != 4)
  752. return $row;
  753. }
  755. return null;
  756. }
  758. public function getUserPrivilegeIds($userId)
  759. {
  760. $qb = $this->entityManager->createQueryBuilder();
  761. $qb
  762. ->select('supportPrivileges.id')
  763. ->from(User::class, 'user')
  764. ->leftJoin('user.userInstance', 'userInstance')
  765. ->leftJoin('userInstance.supportPrivileges', 'supportPrivileges')
  766. ->andWhere('user.id = :userId')
  767. ->setParameter('userId', $userId)
  768. ;
  770. return array_column($qb->getQuery()->getArrayResult(), 'id');
  771. }
  773. public function getWebsiteSpamDetails($websiteSpam)
  774. {
  775. $blackList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getBlackList()));
  776. $whiteList = str_replace("\n", ',', str_replace("\r\n", ',', $websiteSpam->getWhiteList()));
  778. return [
  779. 'blackList' => $this->filterBlockSpam($blackList),
  780. 'whiteList' => $this->filterBlockSpam($whiteList),
  781. ];
  782. }
  784. public function filterBlockSpam($str)
  785. {
  786. $list = array();
  787. foreach (explode(',', $str) as $value) {
  788. if (filter_var($value, FILTER_VALIDATE_EMAIL)) {
  789. if (!isset($list['email'])) {
  790. $list['email'] = array();
  791. }
  793. array_push($list['email'], strtolower($value));
  794. } else if (filter_var($value, FILTER_VALIDATE_IP)) {
  795. if (!isset($list['ip'])) {
  796. $list['ip'] = array();
  797. }
  799. array_push($list['ip'], $value);
  800. } else if (isset($value[0]) && $value[0] == '@') {
  801. if (!isset($list['domain'])) {
  802. $list['domain'] = array();
  803. }
  805. array_push($list['domain'], strtolower($value));
  806. }
  807. }
  809. return $list;
  810. }
  812. // @TODO: Refactor this - We can instead just use \DateTimeZone::listIdentifiers() wherever need be.
  813. public function getTimezones()
  814. {
  815. return \DateTimeZone::listIdentifiers();
  816. }
  818. public function getUserSavedReplyReferenceIds()
  819. {
  820. // @TODO: Refactor this function
  821. $savedReplyIds = [];
  822. $groupIds = [];
  823. $teamIds = [];
  824. $userInstance = $this->getCurrentUser()->getAgentInstance();
  825. $userId = $userInstance->getId();
  827. // Get all the saved reply the current user has created.
  828. $savedReplyRepo = $this->entityManager->getRepository(SavedReplies::class)->findAll();
  830. if (in_array($userInstance->getSupportRole()->getCode(), ['ROLE_ADMIN', "ROLE_SUPER_ADMIN"])) {
  831. // If the user is admin or super admin, return all saved replies.
  832. foreach ($savedReplyRepo as $sr) {
  833. array_push($savedReplyIds, (int)$sr->getId());
  834. }
  836. return $savedReplyIds;
  837. }
  839. foreach ($savedReplyRepo as $sr) {
  840. if ($userId == $sr->getUser()->getId()) {
  841. //Save the ids of the saved reply.
  842. array_push($savedReplyIds, (int)$sr->getId());
  843. }
  844. }
  846. // Get the ids of the Group(s) the current user is associated with.
  847. $query = "select * from uv_user_support_groups where userInstanceId =" . $userId;
  848. $connection = $this->entityManager->getConnection();
  849. $stmt = $connection->prepare($query);
  850. $result = $stmt->executeQuery()->fetchAllAssociative();
  852. foreach ($result as $row) {
  853. array_push($groupIds, $row['supportGroupId']);
  854. }
  856. // Get all the saved reply's ids that is associated with the user's group(s).
  857. $query = "select * from uv_saved_replies_groups";
  858. $stmt = $connection->prepare($query);
  859. $result = $stmt->executeQuery()->fetchAllAssociative();
  861. foreach ($result as $row) {
  862. if (in_array($row['group_id'], $groupIds)) {
  863. array_push($savedReplyIds, (int) $row['savedReply_id']);
  864. }
  865. }
  867. // Get the ids of the Team(s) the current user is associated with.
  868. $query = "select * from uv_user_support_teams";
  869. $connection = $this->entityManager->getConnection();
  870. $stmt = $connection->prepare($query);
  871. $result = $stmt->executeQuery()->fetchAllAssociative();
  873. foreach ($result as $row) {
  874. if ($row['userInstanceId'] == $userId) {
  875. array_push($teamIds, $row['supportTeamId']);
  876. }
  877. }
  879. $query = "select * from uv_saved_replies_teams";
  880. $stmt = $connection->prepare($query);
  881. $result = $stmt->executeQuery()->fetchAllAssociative();
  883. foreach ($result as $row) {
  884. if (in_array($row['subgroup_id'], $teamIds)) {
  885. array_push($savedReplyIds, (int)$row['savedReply_id']);
  886. }
  887. }
  889. return $savedReplyIds;
  890. }
  892. // Return formatted time on user preference basis
  893. public function getLocalizedFormattedTime(\DateTime $timestamp, $user = null, $format = 'm-d-y h:i A')
  894. {
  895. $activeUserTimeZone = $this->entityManager->getRepository(Website::class)->findOneBy(['code' => 'Knowledgebase']);
  897. if (!empty($user) && $user != 'anon.' && $user->getTimezone() != null) {
  898. $timestamp = clone $timestamp;
  900. $timestamp->setTimeZone(new \DateTimeZone($user->getTimeZone()));
  901. $format = $user->getTimeFormat();
  902. } elseif (!empty($activeUserTimeZone) && $activeUserTimeZone != 'anon.' && $activeUserTimeZone->getTimezone() != null) {
  903. $timestamp = clone $timestamp;
  905. $timestamp->setTimeZone(new \DateTimeZone($activeUserTimeZone->getTimeZone()));
  906. $format = $activeUserTimeZone->getTimeFormat();
  907. }
  909. return $timestamp->format($format);
  910. }
  912. public function isFileExists($filePath)
  913. {
  914. $dir = $this->container->get('kernel')->getProjectDir();
  915. $file = str_replace("\\", '/', $dir . "/" . $filePath);
  917. if (is_dir($file)) {
  918. return true;
  919. }
  921. return false;
  922. }
  924. public function getCustomersCountForKudos($container)
  925. {
  926. $qb = $this->entityManager->createQueryBuilder();
  927. $qb->select($qb->expr()->countDistinct('c.id') . "as customerCount")->from(Ticket::class, 't')
  928. ->leftJoin('t.customer', 'c');
  930. $container->get('report.service')->addPermissionFilter($qb, $this->container, false);
  932. return $qb->getQuery()->getSingleScalarResult();
  933. }
  935. public function getAssignedUserSupportPrivilegeDetails($user, $userInstance)
  936. {
  937. $queryBuilder = $this->entityManager->createQueryBuilder();
  938. $queryBuilder
  939. ->select('DISTINCT privilege.id, privilege.name, privilege.privileges')
  940. ->from(SupportPrivilege::class, 'privilege')
  941. ->leftJoin('privilege.users', 'userInstance')
  942. ->where('userInstance.id = :userInstanceId')->setParameter('userInstanceId', $userInstance->getId())
  943. ;
  945. return $queryBuilder->getQuery()->getResult();
  946. }
  947. }