src/Controller/KbController.php line 67

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\ForumTopics;
  6. use App\Entity\KnowledgeBase;
  7. use App\Entity\KnowledgeBaseCategories;
  8. use App\Entity\User;
  9. use App\Service\GlobalFunctions;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\Routing\Annotation\Route;
  13. class KbController extends AbstractController
  14. {
  15.     /**
  16.      * @Route("/kb", name="kb")
  17.      */
  18.     public function index()
  19.     {
  20.         $GetCategory = $this->getDoctrine()->getRepository(KnowledgeBaseCategories::class)->findBy(['Public' => 1]);
  21.         $GetAdminCategory = $this->getDoctrine()->getRepository(KnowledgeBaseCategories::class)->findBy(['Public' => 0]);
  23.         $GetTopics = $this->getDoctrine()->getRepository(ForumTopics::class)->findAll();
  25.         return $this->render('kb/index.html.twig', [
  26.             'categories' => $GetCategory,
  27.             'admincategories' => $GetAdminCategory,
  28.             'forum_topics' => $GetTopics,
  29.         ]);
  30.     }
  32.     public function article($article_slug)
  33.     {
  34.         $GetArticle = $this->getDoctrine()->getRepository(KnowledgeBase::class)->findOneBy(['KBSlug' => $article_slug]);
  35.         $GetCategory = $GetArticle->getCategory();
  36.         $GetCategoryArticles = $GetCategory->getArticles();
  38.         $GetAuthor = $this->getDoctrine()->getRepository(User::class)->find($GetArticle->getAuthorId());
  40.         if (false !== strpos($GetArticle->getOptions(), '[is_query_article]')) {
  41.             @$EntityId = $_GET['id'];
  42.             if (!isset($EntityId)) {
  43.                 $EntityId = 'select';
  44.             }
  45.             $template = 'kb/query.html.twig';
  47.             /*$GlobalFn = new GlobalFunctions();
  48.             $ShowHeaders = explode(",",$GlobalFn->parse_filter_options($GetArticle->getOptions(), "entity_output_cols"));
  49.             $Entity = $GlobalFn->parse_filter_options($GetArticle->getOptions(), "entity_name");
  51.             $EntitySearch = $this->getDoctrine()->getRepository($Entity::class)->findBy(['Slug'=>$category_slug]);*/
  52.         } else {
  53.             $template = 'kb/article.html.twig';
  54.             $entity_id = 0;
  55.             $ShowHeaders = [];
  56.         }
  58.         return $this->render($template, [
  59.             'controller_name' => 'KbController',
  60.             'article_info' => $GetArticle,
  61.             'category_info' => $GetCategory,
  62.             'author_info' => $GetAuthor,
  63.             'other_articles' => $GetCategoryArticles,
  64.         ]);
  65.     }
  67.     public function category($category_slug)
  68.     {
  69.         $GetCategory = $this->getDoctrine()->getRepository(KnowledgeBaseCategories::class)->findOneBy(['Slug' => $category_slug]);
  70.         $GetCategoryArticles = $GetCategory->getArticles();
  72.         return $this->render('kb/category.html.twig', [
  73.             'category_info' => $GetCategory,
  74.             'category_articles' => $GetCategoryArticles,
  75.         ]);
  76.     }
  78.     public function categoryBlank()
  79.     {
  80.         return $this->redirectToRoute('kb');
  81.     }
  83.     public function search()
  84.     {
  85.         if (isset($_GET['search_term'])) {
  86.             $search_term = $_GET['search_term'];
  87.         }
  89.         $conn = $this->getDoctrine()->getManager()->getConnection();
  91.         $sql = "
  92.             SELECT * FROM knowledge_base INNER JOIN knowledge_base_categories ON knowledge_base.category_id=knowledge_base_categories.id WHERE (article_title LIKE '%$search_term%' OR article LIKE '%$search_term%') AND publish_date<now() AND knowledge_base_categories.public='1'";
  93.         $stmt = $conn->prepare($sql);
  94.         $stmt->execute();
  96.         $GetSearch = $stmt->fetchAll();
  98.         return $this->render('kb/search.html.twig', [
  99.             'results' => $GetSearch,
  100.             'search_term' => $search_term,
  101.         ]);
  102.     }
  103. }