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

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\Controller;
  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;
  21. class Website extends Controller
  22. {
  23.     private $visibility = ['public'];
  24.     private $limit = 5;
  25.     private $company;
  27.     private function isKnowledgebaseActive()
  28.     {
  29.         $entityManager = $this->getDoctrine()->getManager();
  30.         $website = $entityManager->getRepository(CoreWebsite::class)->findOneByCode('knowledgebase');
  32.         if (!empty($website)) {
  33.             $knowledgebaseWebsite = $entityManager->getRepository(KnowledgebaseWebsite::class)->findOneBy(['website' => $website->getId(), 'status' => true]);
  35.             if (!empty($knowledgebaseWebsite) && true == $knowledgebaseWebsite->getIsActive()) {
  36.                 return true;
  37.             }
  38.         }
  40.         throw new NotFoundHttpException('Page Not Found');
  41.     }
  43.     public function home(Request $request)
  44.     {
  45.         $this->isKnowledgebaseActive();
  47.         $parameterBag = [
  48.             'visibility' => 'public',
  49.             'sort' => 'id',
  50.             'direction' => 'desc'
  51.         ];
  53.         $articleRepository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article');
  54.         $solutionRepository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Solutions');
  56.         $twigResponse = [
  57.             'searchDisable' => false,
  58.             'popArticles' => $articleRepository->getPopularTranslatedArticles($request->getLocale()),
  59.             'solutions' => $solutionRepository->getAllSolutions(new ParameterBag($parameterBag), $this->container, 'a', [1]),
  60.         ];
  62.         $newResult = [];
  63.        
  64.         foreach ($twigResponse['solutions'] as $key => $result) {
  65.             $newResult[] = [
  66.                 'id' => $result->getId(),
  67.                 'name' => $result->getName(),
  68.                 'description' => $result->getDescription(),
  69.                 'visibility' => $result->getVisibility(),
  70.                 'solutionImage' => ($result->getSolutionImage() == null) ? '' : $result->getSolutionImage(),
  71.                 'categoriesCount' => $solutionRepository->getCategoriesCountBySolution($result->getId()),
  72.                 'categories' => $solutionRepository->getCategoriesWithCountBySolution($result->getId()),
  73.                 'articleCount' => $solutionRepository->getArticlesCountBySolution($result->getId()),
  74.             ];
  75.         }
  77.         $twigResponse['solutions']['results'] = $newResult;
  78.         $twigResponse['solutions']['categories'] = array_map(function($category) use ($articleRepository) {
  79.             $parameterBag = [
  80.                 'categoryId' => $category['id'],
  81.                 'status' => 1,
  82.                 'sort' => 'id',
  83.                 'limit'=>10,
  84.                 'direction' => 'desc'
  85.             ];
  87.             $article =  $articleRepository->getAllArticles(new ParameterBag($parameterBag), $this->container, 'a.id, a.name, a.slug, a.stared');
  88.              
  89.             return [
  90.                 'id' => $category['id'],
  91.                 'name' => $category['name'],
  92.                 'description' => $category['description'],
  93.                 'articles' => $article
  94.             ];
  95.         }, $solutionRepository->getAllCategories(10, 2));
  97.         return $this->render('@UVDeskSupportCenter//Knowledgebase//index.html.twig', $twigResponse);
  98.     }
  100.     public function listCategories(Request $request)
  101.     {
  102.         $this->isKnowledgebaseActive();
  104.         $solutionRepository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Solutions');
  105.         $categoryCollection = $solutionRepository->getAllCategories(10, 4);
  106.         
  107.         return $this->render('@UVDeskSupportCenter/Knowledgebase/categoryListing.html.twig', [
  108.             'categories' => $categoryCollection,
  109.             'categoryCount' => count($categoryCollection),
  110.         ]);
  111.     }
  113.     public function viewFolder(Request $request)
  114.     {
  115.         $this->isKnowledgebaseActive();
  116.         
  117.         if(!$request->attributes->get('solution'))
  118.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  120.         $filterArray = ['id' => $request->attributes->get('solution')];
  122.         $solution = $this->getDoctrine()
  123.                     ->getRepository('UVDeskSupportCenterBundle:Solutions')
  124.                     ->findOneBy($filterArray);
  126.         if(!$solution)
  127.             $this->noResultFound();
  129.         $breadcrumbs = [
  130.             [
  131.                 'label' => $this->get('translator')->trans('Support Center'),
  132.                 'url' => $this->generateUrl('helpdesk_knowledgebase')
  133.             ],
  134.             [
  135.                 'label' => $solution->getName(),
  136.                 'url' => '#'
  137.             ],
  138.         ];
  140.         $testArray = [1, 2, 3, 4];
  141.         foreach ($testArray as $test) {
  142.             $categories[] = [
  143.                 'id' => $test,
  144.                 'name' => $test . " name",
  145.                 'articleCount' => $test . " articleCount",
  146.             ];
  147.         }
  149.         return $this->render('@UVDeskSupportCenter//Knowledgebase//folder.html.twig', [
  150.             'folder' => $solution,
  151.             'categoryCount' => $this->getDoctrine()
  152.                 ->getRepository('UVDeskSupportCenterBundle:Solutions')
  153.                 ->getCategoriesCountBySolution($solution->getId()),
  154.             'categories' => $this->getDoctrine()
  155.                 ->getRepository('UVDeskSupportCenterBundle:Solutions')
  156.                 ->getCategoriesWithCountBySolution($solution->getId()),
  157.             'breadcrumbs' => $breadcrumbs
  158.         ]);
  159.     }
  161.     public function viewFolderArticle(Request $request)
  162.     {
  163.         $this->isKnowledgebaseActive();
  165.         if(!$request->attributes->get('solution'))
  166.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  168.         $filterArray = ['id' => $request->attributes->get('solution')];
  170.         $solution = $this->getDoctrine()
  171.                     ->getRepository('UVDeskSupportCenterBundle:Solutions')
  172.                     ->findOneBy($filterArray);
  174.         if(!$solution)
  175.             $this->noResultFound();
  177.         $breadcrumbs = [
  178.             [
  179.                 'label' => $this->get('translator')->trans('Support Center'),
  180.                 'url' => $this->generateUrl('helpdesk_knowledgebase')
  181.             ],
  182.             [
  183.                 'label' => $solution->getName(),
  184.                 'url' => '#'
  185.             ],
  186.         ];
  188.         $parameterBag = [
  189.             'solutionId' => $solution->getId(),
  190.             'status' => 1,
  191.             'sort' => 'id',
  192.             'direction' => 'desc'
  193.         ];
  194.         $article_data = [
  195.             'folder' => $solution,
  196.             'articlesCount' => $this->getDoctrine()
  197.                 ->getRepository('UVDeskSupportCenterBundle:Solutions')
  198.                 ->getArticlesCountBySolution($solution->getId(), [1]),
  199.             'articles' => $this->getDoctrine()
  200.                 ->getRepository('UVDeskSupportCenterBundle:Article')
  201.                 ->getAllArticles(new ParameterBag($parameterBag), $this->container, 'a.id, a.name, a.slug, a.stared'),
  202.             'breadcrumbs' => $breadcrumbs,
  203.         ];
  205.         return $this->render('@UVDeskSupportCenter/Knowledgebase/folderArticle.html.twig', $article_data);
  206.     }
  208.     public function viewCategory(Request $request)
  209.     {
  210.         $this->isKnowledgebaseActive();
  212.         if(!$request->attributes->get('category'))
  213.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  215.         $filterArray = array(
  216.                             'id' => $request->attributes->get('category'),
  217.                             'status' => 1,
  218.                         );
  219.        
  220.         $category = $this->getDoctrine()
  221.                     ->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
  222.                     ->findOneBy($filterArray);
  223.     
  224.         if(!$category)
  225.             $this->noResultFound();
  227.         $breadcrumbs = [
  228.             [ 'label' => $this->get('translator')->trans('Support Center'),'url' => $this->generateUrl('helpdesk_knowledgebase') ],
  229.             [ 'label' => $category->getName(),'url' => '#' ],
  230.         ];
  231.         
  232.         $parameterBag = [
  233.             'categoryId' => $category->getId(),
  234.             'status' => 1,
  235.             'sort' => 'id',
  236.             'direction' => 'desc'
  237.         ];
  239.         $category_data=  array(
  240.             'category' => $category,
  241.             'articlesCount' => $this->getDoctrine()
  242.                             ->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
  243.                             ->getArticlesCountByCategory($category->getId(), [1]),
  244.             'articles' => $this->getDoctrine()
  245.                         ->getRepository('UVDeskSupportCenterBundle:Article')
  246.                         ->getAllArticles(new ParameterBag($parameterBag), $this->container, 'a.id, a.name, a.slug, a.stared'),
  247.             'breadcrumbs' => $breadcrumbs
  248.         );
  250.         return $this->render('@UVDeskSupportCenter/Knowledgebase/category.html.twig',$category_data);
  251.     }
  252.    
  253.     public function viewArticle(Request $request)
  254.     {
  255.         $this->isKnowledgebaseActive();
  256.        
  257.         if (!$request->attributes->get('article') && !$request->attributes->get('slug')) {
  258.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  259.         }
  261.         $entityManager = $this->getDoctrine()->getManager();
  262.         $user = $this->get('user.service')->getCurrentUser();
  263.         $articleRepository = $entityManager->getRepository('UVDeskSupportCenterBundle:Article');
  265.         if ($request->attributes->get('article')) {
  266.             $article = $articleRepository->findOneBy(['status' => 1, 'id' => $request->attributes->get('article')]);
  267.         } else {
  268.             $article = $articleRepository->findOneBy(['status' => 1,'slug' => $request->attributes->get('slug')]);
  269.         }
  270.        
  271.         if (empty($article)) {
  272.             $this->noResultFound();
  273.         }
  274.         $article->setViewed((int) $article->getViewed() + 1);
  275.         
  276.         // Log article view
  277.         $articleViewLog = new ArticleViewLog();
  278.         $articleViewLog->setUser(($user != null && $user != 'anon.') ? $user : null);
  279.         
  280.         $articleViewLog->setArticle($article);
  281.         $articleViewLog->setViewedAt(new \DateTime('now'));
  283.         $entityManager->persist($article);
  284.         $entityManager->persist($articleViewLog);
  285.         $entityManager->flush();
  286.         
  287.         // Get article feedbacks
  288.         $feedbacks = ['enabled' => false, 'submitted' => false, 'article' => $articleRepository->getArticleFeedbacks($article)];
  290.         if (!empty($user) && $user != 'anon.') {
  291.             $feedbacks['enabled'] = true;
  293.             if (!empty($feedbacks['article']['collection']) && in_array($user->getId(), array_column($feedbacks['article']['collection'], 'user'))) {
  294.                 $feedbacks['submitted'] = true;
  295.             }
  296.         }
  298.         // @TODO: App popular articles
  299.         $article_details = [
  300.             'article' => $article,
  301.             'breadcrumbs' => [
  302.                 ['label' => $this->get('translator')->trans('Support Center'), 'url' => $this->generateUrl('helpdesk_knowledgebase')],
  303.                 ['label' => $article->getName(), 'url' => '#']
  304.             ],
  305.             'dateAdded' => $this->get('user.service')->convertToTimezone($article->getDateAdded()),
  306.             'articleTags' => $articleRepository->getTagsByArticle($article->getId()),
  307.             'articleAuthor' => $articleRepository->getArticleAuthorDetails($article->getId()),
  308.             'relatedArticles' => $articleRepository->getAllRelatedyByArticle(['locale' => $request->getLocale(), 'articleId' => $article->getId()], [1]),
  309.             'popArticles'  => $articleRepository->getPopularTranslatedArticles($request->getLocale())
  310.         ];
  312.         return $this->render('@UVDeskSupportCenter/Knowledgebase/article.html.twig',$article_details);
  313.     }
  315.     public function searchKnowledgebase(Request $request)
  316.     {
  317.         $this->isKnowledgebaseActive();
  319.         $searchQuery = $request->query->get('s');
  320.         if (empty($searchQuery)) {
  321.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  322.         }
  324.         $articleCollection = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article')->getArticleBySearch($request);
  326.         return $this->render('@UVDeskSupportCenter/Knowledgebase/search.html.twig', [
  327.             'search' => $searchQuery,
  328.             'articles' => $articleCollection,
  329.         ]);
  330.     }
  332.     public function viewTaggedResources(Request $request)
  333.     {
  334.         $this->isKnowledgebaseActive();
  336.         $tagQuery = $request->attributes->get('tag');
  337.         if (empty($tagQuery)) {
  338.             return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  339.         }
  341.         $tagLabel = $request->attributes->get('name');
  342.         $articleCollection = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article')->getArticleByTags([$tagLabel]);
  344.         return $this->render('@UVDeskSupportCenter/Knowledgebase/search.html.twig', [
  345.             'articles' => $articleCollection,
  346.             'search' => $tagLabel,
  347.             'breadcrumbs' => [
  348.                 ['label' => $this->get('translator')->trans('Support Center'), 'url' => $this->generateUrl('helpdesk_knowledgebase')],
  349.                 ['label' => $tagLabel, 'url' => '#'],
  350.             ],
  351.         ]);
  352.     }
  354.     public function rateArticle($articleId, Request $request)
  355.     {
  356.         $this->isKnowledgebaseActive();
  358.         // @TODO: Refactor
  359.             
  360.         // if ($request->getMethod() != 'POST') {
  361.         //     return $this->redirect($this->generateUrl('helpdesk_knowledgebase'));
  362.         // }
  364.         // $company = $this->getCompany();
  365.         // $user = $this->container->get('user.service')->getCurrentUser();
  366.         $response = ['code' => 404, 'content' => ['alertClass' => 'danger', 'alertMessage' => 'An unexpected error occurred. Please try again later.']];
  368.         // if (!empty($user) && $user != 'anon.') {
  369.         //     $entityManager = $this->getDoctrine()->getEntityManager();
  370.         //     $article = $entityManager->getRepository('WebkulSupportCenterBundle:Article')->findOneBy(['id' => $articleId, 'companyId' => $company->getId()]);
  372.         //     if (!empty($article)) {
  373.         //         $providedFeedback = $request->request->get('feedback');
  375.         //         if (!empty($providedFeedback) && in_array(strtolower($providedFeedback), ['positive', 'neagtive'])) {
  376.         //             $isArticleHelpful = ('positive' == strtolower($providedFeedback)) ? true : false;
  377.         //             $articleFeedback = $entityManager->getRepository('WebkulSupportCenterBundle:ArticleFeedback')->findOneBy(['article' => $article, 'ratedCustomer' => $user]);
  379.         //             $response = ['code' => 200, 'content' => ['alertClass' => 'success', 'alertMessage' => 'Feedback saved successfully.']];
  381.         //             if (empty($articleFeedback)) {
  382.         //                 $articleFeedback = new \Webkul\SupportCenterBundle\Entity\ArticleFeedback();
  384.         //                 // $articleBadge->setDescription('');
  385.         //                 $articleFeedback->setIsHelpful($isArticleHelpful);
  386.         //                 $articleFeedback->setArticle($article);
  387.         //                 $articleFeedback->setRatedCustomer($user);
  388.         //                 $articleFeedback->setCreatedAt(new \DateTime('now'));
  389.         //             } else {
  390.         //                 $articleFeedback->setIsHelpful($isArticleHelpful);
  391.         //                 $response['content']['alertMessage'] = 'Feedback updated successfully.';
  392.         //             }
  394.         //             $entityManager->persist($articleFeedback);
  395.         //             $entityManager->flush();
  396.         //         } else {
  397.         //             $response['content']['alertMessage'] = 'Invalid feedback provided.';
  398.         //         }
  399.         //     } else {
  400.         //         $response['content']['alertMessage'] = 'Article not found.';
  401.         //     }
  402.         // } else {
  403.         //     $response['content']['alertMessage'] = 'You need to login to your account before can perform this action.';
  404.         // }
  406.         return new Response(json_encode($response['content']), $response['code'], ['Content-Type: application/json']);
  407.     }
  409.     /**
  410.      * If customer is playing with url and no result is found then what will happen
  411.      * @return 
  412.      */
  413.     protected function noResultFound()
  414.     {
  415.         throw new NotFoundHttpException('Not Found!');
  416.     }
  417. }