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

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