vendor/uvdesk/support-center-bundle/Controller/Website.php line 47

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\SupportCenterBundle\Controller;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\HttpFoundation\ParameterBag;
  9. use Symfony\Contracts\Translation\TranslatorInterface;
  10. use Symfony\Component\DependencyInjection\ContainerInterface;
  11. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Webkul\UVDesk\CoreFrameworkBundle\Services\UserService;
  14. use Webkul\UVDesk\CoreFrameworkBundle\Entity as CoreEntities;
  15. use Webkul\UVDesk\SupportCenterBundle\Entity as SupportEntities;
  17. class Website extends AbstractController
  18. {
  19. private $userService;
  20. private $translator;
  21. private $constructContainer;
  22. private $em;
  24. public function __construct(UserService $userService, TranslatorInterface $translator, ContainerInterface $constructContainer, EntityManagerInterface $entityManager)
  25. {
  26. $this->userService = $userService;
  27. $this->translator = $translator;
  28. $this->constructContainer = $constructContainer;
  29. $this->em = $entityManager;
  30. }
  32. private function isKnowledgebaseActive()
  33. {
  34. $website = $this->em->getRepository(CoreEntities\Website::class)->findOneByCode('knowledgebase');
  36. if (! empty($website)) {
  37. $knowledgebaseWebsite = $this->em->getRepository(SupportEntities\KnowledgebaseWebsite::class)->findOneBy(['website' => $website->getId(), 'status' => true]);
  39. if (! empty($knowledgebaseWebsite) && true == $knowledgebaseWebsite->getIsActive()) {
  40. return true;
  41. }
  42. }
  44. throw new NotFoundHttpException('Page Not Found');
  45. }
  47. public function home(Request $request)
  48. {
  49. $this->isKnowledgebaseActive();
  51. $parameterBag = [
  52. 'visibility' => 'public',
  53. 'sort' => 'id',
  54. 'direction' => 'desc'
  55. ];
  57. $articleRepository = $this->em->getRepository(SupportEntities\Article::class);
  58. $solutionRepository = $this->em->getRepository(SupportEntities\Solutions::class);
  60. $twigResponse = [
  61. 'searchDisable' => false,
  62. 'popArticles' => $articleRepository->getPopularTranslatedArticles($request->getLocale()),
  63. 'solutions' => $solutionRepository->getAllSolutions(new ParameterBag($parameterBag), $this->constructContainer, 'a', [1]),
  64. ];
  66. $newResult = [];
  68. foreach ($twigResponse['solutions'] as $key => $result) {
  69. $newResult[] = [
  70. 'id' => $result->getId(),
  71. 'name' => $result->getName(),
  72. 'description' => $result->getDescription(),
  73. 'visibility' => $result->getVisibility(),
  74. 'solutionImage' => ($result->getSolutionImage() == null) ? '' : $result->getSolutionImage(),
  75. 'categoriesCount' => $solutionRepository->getCategoriesCountBySolution($result->getId()),
  76. 'categories' => $solutionRepository->getCategoriesWithCountBySolution($result->getId()),
  77. 'articleCount' => $solutionRepository->getArticlesCountBySolution($result->getId()),
  78. ];
  79. }
  81. $twigResponse['solutions']['results'] = $newResult;
  82. $twigResponse['solutions']['categories'] = array_map(function ($category) use ($articleRepository) {
  83. $parameterBag = [
  84. 'categoryId' => $category['id'],
  85. 'status' => 1,
  86. 'sort' => 'id',
  87. 'limit' => 10,
  88. 'direction' => 'desc'
  89. ];
  91. $article = $articleRepository->getAllArticles(new ParameterBag($parameterBag), $this->constructContainer, 'a.id, a.name, a.slug, a.stared');
  93. return [
  94. 'id' => $category['id'],
  95. 'name' => $category['name'],
  96. 'description' => $category['description'],
  97. 'articles' => $article
  98. ];
  99. }, $solutionRepository->getAllCategories(10, 2));
  101. return $this->render('@UVDeskSupportCenter//Knowledgebase//index.html.twig', $twigResponse);
  102. }
  104. public function listCategories(Request $request)
  105. {
  106. $this->isKnowledgebaseActive();
  108. $solutionRepository = $this->em->getRepository(SupportEntities\Solutions::class);
  109. $categoryCollection = $solutionRepository->getAllCategories(10, 4);
  111. return $this->render('@UVDeskSupportCenter/Knowledgebase/categoryListing.html.twig', [
  112. 'categories' => $categoryCollection,
  113. 'categoryCount' => count($categoryCollection),
  114. ]);
  115. }
  117. public function viewFolder(Request $request)
  118. {
  119. $this->isKnowledgebaseActive();
  121. if (!$request->attributes->get('solution'))
  122. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  124. $filterArray = ['id' => $request->attributes->get('solution')];
  126. $solution = $this->em
  127. ->getRepository(SupportEntities\Solutions::class)
  128. ->findOneBy($filterArray);
  130. if (! $solution)
  131. $this->noResultFound();
  133. if ($solution->getVisibility() == 'private')
  134. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  136. $breadcrumbs = [
  137. [
  138. 'label' => $this->translator->trans('Support Center'),
  139. 'url' => $this->generateUrl('helpdesk_knowledgebase')
  140. ],
  141. [
  142. 'label' => $solution->getName(),
  143. 'url' => '#'
  144. ],
  145. ];
  147. $testArray = [1, 2, 3, 4];
  148. foreach ($testArray as $test) {
  149. $categories[] = [
  150. 'id' => $test,
  151. 'name' => $test . " name",
  152. 'articleCount' => $test . " articleCount",
  153. ];
  154. }
  156. return $this->render('@UVDeskSupportCenter//Knowledgebase//folder.html.twig', [
  157. 'folder' => $solution,
  158. 'categoryCount' => $this->em
  159. ->getRepository(SupportEntities\Solutions::class)
  160. ->getCategoriesCountBySolution($solution->getId()),
  161. 'categories' => $this->em
  162. ->getRepository(SupportEntities\Solutions::class)
  163. ->getCategoriesWithCountBySolution($solution->getId()),
  164. 'breadcrumbs' => $breadcrumbs
  165. ]);
  166. }
  168. public function viewFolderArticle(Request $request)
  169. {
  170. $this->isKnowledgebaseActive();
  172. if (! $request->attributes->get('solution'))
  173. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  175. $filterArray = ['id' => $request->attributes->get('solution')];
  177. $solution = $this->em
  178. ->getRepository(SupportEntities\Solutions::class)
  179. ->findOneBy($filterArray);
  181. if (! $solution)
  182. $this->noResultFound();
  184. if ($solution->getVisibility() == 'private')
  185. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  187. $breadcrumbs = [
  188. [
  189. 'label' => $this->translator->trans('Support Center'),
  190. 'url' => $this->generateUrl('helpdesk_knowledgebase')
  191. ],
  192. [
  193. 'label' => $solution->getName(),
  194. 'url' => '#'
  195. ],
  196. ];
  198. $parameterBag = [
  199. 'solutionId' => $solution->getId(),
  200. 'status' => 1,
  201. 'sort' => 'id',
  202. 'direction' => 'desc'
  203. ];
  204. $article_data = [
  205. 'folder' => $solution,
  206. 'articlesCount' => $this->em
  207. ->getRepository(SupportEntities\Solutions::class)
  208. ->getArticlesCountBySolution($solution->getId(), [1]),
  209. 'articles' => $this->em
  210. ->getRepository(SupportEntities\Article::class)
  211. ->getAllArticles(new ParameterBag($parameterBag), $this->constructContainer, 'a.id, a.name, a.slug, a.stared'),
  212. 'breadcrumbs' => $breadcrumbs,
  213. ];
  215. return $this->render('@UVDeskSupportCenter/Knowledgebase/folderArticle.html.twig', $article_data);
  216. }
  218. public function viewCategory(Request $request)
  219. {
  220. $this->isKnowledgebaseActive();
  222. if (!$request->attributes->get('category'))
  223. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  225. $filterArray = array(
  226. 'id' => $request->attributes->get('category'),
  227. 'status' => 1,
  228. );
  230. $category = $this->em
  231. ->getRepository(SupportEntities\SolutionCategory::class)
  232. ->findOneBy($filterArray);
  234. if (! $category)
  235. $this->noResultFound();
  237. $breadcrumbs = [
  238. ['label' => $this->translator->trans('Support Center'), 'url' => $this->generateUrl('helpdesk_knowledgebase')],
  239. ['label' => $category->getName(), 'url' => '#'],
  240. ];
  242. $parameterBag = [
  243. 'categoryId' => $category->getId(),
  244. 'status' => 1,
  245. 'sort' => 'id',
  246. 'direction' => 'desc'
  247. ];
  249. $category_data = array(
  250. 'category' => $category,
  251. 'articlesCount' => $this->em
  252. ->getRepository(SupportEntities\SolutionCategory::class)
  253. ->getArticlesCountByCategory($category->getId(), [1]),
  254. 'articles' => $this->em
  255. ->getRepository(SupportEntities\Article::class)
  256. ->getAllArticles(new ParameterBag($parameterBag), $this->constructContainer, 'a.id, a.name, a.slug, a.stared'),
  257. 'breadcrumbs' => $breadcrumbs
  258. );
  260. return $this->render('@UVDeskSupportCenter/Knowledgebase/category.html.twig', $category_data);
  261. }
  263. public function viewArticle(Request $request)
  264. {
  265. $this->isKnowledgebaseActive();
  267. if (!$request->attributes->get('article') && !$request->attributes->get('slug')) {
  268. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  269. }
  271. $user = $this->userService->getCurrentUser();
  272. $articleRepository = $this->em->getRepository(SupportEntities\Article::class);
  274. if ($request->attributes->get('article')) {
  275. $article = $articleRepository->findOneBy(['status' => 1, 'id' => $request->attributes->get('article')]);
  276. } else {
  277. $article = $articleRepository->findOneBy(['status' => 1, 'slug' => $request->attributes->get('slug')]);
  278. }
  280. if (empty($article)) {
  281. $this->noResultFound();
  282. }
  284. $article->setContent($article->getContent());
  285. $article->setViewed((int) $article->getViewed() + 1);
  287. // Log article view
  288. $articleViewLog = new SupportEntities\ArticleViewLog();
  289. $articleViewLog->setUser(($user != null && $user != 'anon.') ? $user : null);
  291. $articleViewLog->setArticle($article);
  292. $articleViewLog->setViewedAt(new \DateTime('now'));
  294. $this->em->persist($article);
  295. $this->em->persist($articleViewLog);
  296. $this->em->flush();
  298. // Get article feedbacks
  299. $feedbacks = ['enabled' => false, 'submitted' => false, 'article' => $articleRepository->getArticleFeedbacks($article)];
  301. if (! empty($user) && $user != 'anon.') {
  302. $feedbacks['enabled'] = true;
  304. if (! empty($feedbacks['article']['collection']) && in_array($user->getId(), array_column($feedbacks['article']['collection'], 'user'))) {
  305. $feedbacks['submitted'] = true;
  306. }
  307. }
  309. // @TODO: App popular articles
  310. $article_details = [
  311. 'article' => $article,
  312. 'breadcrumbs' => [
  313. ['label' => $this->translator->trans('Support Center'), 'url' => $this->generateUrl('helpdesk_knowledgebase')],
  314. ['label' => $article->getName(), 'url' => '#']
  315. ],
  316. 'dateAdded' => $this->userService->convertToTimezone($article->getDateAdded()),
  317. 'articleTags' => $articleRepository->getTagsByArticle($article->getId()),
  318. 'articleAuthor' => $articleRepository->getArticleAuthorDetails($article->getId()),
  319. 'relatedArticles' => $articleRepository->getAllRelatedByArticle(['locale' => $request->getLocale(), 'articleId' => $article->getId()], [1]),
  320. 'popArticles' => $articleRepository->getPopularTranslatedArticles($request->getLocale())
  321. ];
  323. return $this->render('@UVDeskSupportCenter/Knowledgebase/article.html.twig', $article_details);
  324. }
  326. public function searchKnowledgebase(Request $request)
  327. {
  328. $this->isKnowledgebaseActive();
  330. $searchQuery = $request->query->get('s');
  331. if (empty($searchQuery)) {
  332. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  333. }
  335. $articleCollection = $this->em->getRepository(SupportEntities\Article::class)->getArticleBySearch($request);
  337. return $this->render('@UVDeskSupportCenter/Knowledgebase/search.html.twig', [
  338. 'search' => $searchQuery,
  339. 'articles' => $articleCollection,
  340. ]);
  341. }
  343. public function viewTaggedResources(Request $request)
  344. {
  345. $this->isKnowledgebaseActive();
  347. $tagQuery = $request->attributes->get('tag');
  348. if (empty($tagQuery)) {
  349. return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  350. }
  352. $tagLabel = $request->attributes->get('name');
  353. $articleCollection = $this->em->getRepository(SupportEntities\Article::class)->getArticleByTags([$tagLabel]);
  355. return $this->render('@UVDeskSupportCenter/Knowledgebase/search.html.twig', [
  356. 'articles' => $articleCollection,
  357. 'search' => $tagLabel,
  358. 'breadcrumbs' => [
  359. ['label' => $this->translator->trans('Support Center'), 'url' => $this->generateUrl('helpdesk_knowledgebase')],
  360. ['label' => $tagLabel, 'url' => '#'],
  361. ],
  362. ]);
  363. }
  365. public function rateArticle($articleId, Request $request)
  366. {
  367. $this->isKnowledgebaseActive();
  369. // @TODO: Refactor
  371. // if ($request->getMethod() != 'POST') {
  372. // return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  373. // }
  375. // $company = $this->getCompany();
  376. // $user = $this->userService->getCurrentUser();
  377. $response = ['code' => 404, 'content' => ['alertClass' => 'danger', 'alertMessage' => 'An unexpected error occurred. Please try again later.']];
  379. // if (!empty($user) && $user != 'anon.') {
  380. // $entityManager = $this->getDoctrine()->getEntityManager();
  381. // $article = $entityManager->getRepository('WebkulSupportCenterBundle:Article')->findOneBy(['id' => $articleId, 'companyId' => $company->getId()]);
  383. // if (!empty($article)) {
  384. // $providedFeedback = $request->request->get('feedback');
  386. // if (!empty($providedFeedback) && in_array(strtolower($providedFeedback), ['positive', 'neagtive'])) {
  387. // $isArticleHelpful = ('positive' == strtolower($providedFeedback)) ? true : false;
  388. // $articleFeedback = $entityManager->getRepository('WebkulSupportCenterBundle:ArticleFeedback')->findOneBy(['article' => $article, 'ratedCustomer' => $user]);
  390. // $response = ['code' => 200, 'content' => ['alertClass' => 'success', 'alertMessage' => 'Feedback saved successfully.']];
  392. // if (empty($articleFeedback)) {
  393. // $articleFeedback = new \Webkul\SupportCenterBundle\Entity\ArticleFeedback();
  395. // // $articleBadge->setDescription('');
  396. // $articleFeedback->setIsHelpful($isArticleHelpful);
  397. // $articleFeedback->setArticle($article);
  398. // $articleFeedback->setRatedCustomer($user);
  399. // $articleFeedback->setCreatedAt(new \DateTime('now'));
  400. // } else {
  401. // $articleFeedback->setIsHelpful($isArticleHelpful);
  402. // $response['content']['alertMessage'] = 'Feedback updated successfully.';
  403. // }
  405. // $entityManager->persist($articleFeedback);
  406. // $entityManager->flush();
  407. // } else {
  408. // $response['content']['alertMessage'] = 'Invalid feedback provided.';
  409. // }
  410. // } else {
  411. // $response['content']['alertMessage'] = 'Article not found.';
  412. // }
  413. // } else {
  414. // $response['content']['alertMessage'] = 'You need to login to your account before can perform this action.';
  415. // }
  417. return new Response(json_encode($response['content']), $response['code'], ['Content-Type: application/json']);
  418. }
  420. /**
  421. * If customer is playing with url and no result is found then what will happen
  422. * @return
  423. */
  424. protected function noResultFound()
  425. {
  426. throw new NotFoundHttpException('Not Found!');
  427. }
  428. }