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

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