src/Controller/FrontendBundle/Ideas/TeacherIdeasController.php line 36

Open in your IDE?
  1. <?php
  3. namespace App\Controller\FrontendBundle\Ideas;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use App\BackendBundle\Helper\UserHelper;
  10. use App\BackendBundle\Helper\EventHelper;
  11. use App\BackendBundle\Helper\SiteTitleHelper;
  12. use App\BackendBundle\Helper\InfoSectionHelper;
  13. use App\BackendBundle\Helper\BoPartnerHelper;
  14. use App\Entity\InfoSectionCategory;
  16. class TeacherIdeasController extends AbstractController {
  17.     
  18.     private $siteTitleHelper;
  19.     private $infoSectionHelper;
  20.     private $userHelper;
  21.     private $eventHelper;
  22.     
  23.     public function __construct(InfoSectionHelper $infosectionhelper, SiteTitleHelper $sitetitlehelper, UserHelper $userhelper, EventHelper $eventhelper, BoPartnerHelper $bopartnerhelper)
  24.            {
  25.         $this->infoSectionHelper = $infosectionhelper;
  26.         $this->siteTitleHelper = $sitetitlehelper;
  27.         $this->userHelper = $userhelper;
  28.         $this->eventHelper = $eventhelper;
  29.         $this->boPartnerHelper = $bopartnerhelper;
  30.         }
  32.     /**
  33.     * @return \Symfony\Component\HttpFoundation\Response
  34.     * @Route("/ideen-lehrer", name="teacher_ideas_list", defaults={"title": "Informationsbereich für Lehrpersonen", "description": "Sie sind eine Lehrperson in der Berufsorientierung und möchten wissen, wie man mit berufsreise.at den Unterricht gestalten kann? Hier finden Sie hilfreiche Informationen und Materialien für Ihren Berufsorientierungsunterricht."}) 
  35.     */
  36.     public function listIdeasAction(Request $request) {
  38.         $this->siteTitleHelper->setTitleDescription($request);          
  39.         
  40.         $em = $this->getDoctrine()->getManager();
  41.         $entities = $em->getRepository(InfoSectionCategory::class)->findBy(array('sectionType' => 2), array('position' => 'ASC'));
  43.         return $this->render('@frontend/public/ideas/ideas_teacher.html.twig', array(
  44.                     'heading' => 'Ideen für Lehrpersonen',
  45.                     'categoryRoute' => 'teacher_ideas_category',
  46.                     'entities' => $entities
  47.         ));
  48.     }
  50.     /**
  51.     * @return \Symfony\Component\HttpFoundation\Response
  52.     * @Route("/ideen-lehrer/{category}", name="teacher_ideas_category", defaults={"title": "Informationsbereich für Lehrpersonen", "description": "Sie sind eine Lehrperson in der Berufsorientierung und möchten wissen, wie man mit berufsreise.at den Unterricht gestalten kann? Hier finden Sie hilfreiche Informationen und Materialien für Ihren Berufsorientierungsunterricht."}) 
  53.     */
  54.     public function categoryAction(Request $request, $category) {
  56.         $infoSectionCategory = $this->infoSectionHelper->getInfoSectionCategoryByUrlText($category);
  57.         if (empty($category)) {
  58.             throw new NotFoundHttpException("Category $category wurde nicht gefunden");
  59.         }
  62.         $this->siteTitleHelper->setInfoSectionCategoryTitle($request, $infoSectionCategory);        
  63.         
  64.         $entities = $this->infoSectionHelper->getInfoSectionSubCategoriesByCategory($infoSectionCategory);
  66.         return $this->render('@frontend/public/ideas/ideas_category.html.twig', array(
  67.                     'category' => $infoSectionCategory,
  68.                     'entities' => $entities
  69.         ));
  70.     }
  71.     
  72.     /**
  73.     * @return \Symfony\Component\HttpFoundation\Response
  74.     * @Route("/ideen-lehrer/fortbildungen/bildungsconsulting", name="teacher_ideas_bildungsconsulting") 
  75.     */
  76.     public function bildungsconsultingAction(Request $request) {
  77.         
  78.         $uuid = "7f2ab9fa-441d-4c90-8000-0c78909233b7";
  79.         
  80.         /* @var $boProfile BoPartnerProfile */
  81.         $boProfile = $this->boPartnerHelper->getBoPartnerProfileByUUID($uuid);
  82.         if ($boProfile == null) {
  83.             throw new NotFoundHttpException();
  84.         }
  85.         
  86.         $user = $this->userHelper->getUserByEmail("bildungsconsulting@wktirol.at");
  87.         
  88.         $eventJuniorCompany = $this->eventHelper->getEventById(755);
  89.         
  90.         $events = $this->getBildungsconsultingTeacherEvents($boProfile->getId(), $boProfile->getProfileTypeID());
  91.         array_push($events, $eventJuniorCompany);
  92.         $eventsData = $this->eventHelper->getEventDataItems($user, $events);
  94.         return $this->render('@frontend/public/ideas/ideas_bildungsconsulting.html.twig', array(
  95.                     'eventsData' => $eventsData,
  96.         ));
  97.     }
  98.     
  99.     private function getBildungsconsultingTeacherEvents($profileID, $profileTypeID) {
  100.         
  101.         $sqlText = 'SELECT event FROM App\Entity\Event event
  102.                         JOIN event.eventState eventState
  103.                         JOIN event.profileType pt
  104.                         JOIN App\Entity\Appointment appointment
  105.                         JOIN event.tagMappings tags
  106.                         JOIN tags.eventTag tag
  107.                         JOIN tag.eventTagCategory tagCategory
  108.                         WHERE eventState.name=:evtStateName
  109.                         AND event.profileID = :profileID
  110.                         AND pt.id=:profileTypeID
  111.                         AND tagCategory.id = 4
  112.                         AND appointment.event = event
  113.                         AND ((appointment.bookableUntil is NULL AND appointment.endDate >= :today) OR appointment.bookableUntil >= :today)';
  114.         $query = $this->getDoctrine()->getManager()->createQuery($sqlText);
  115.         $query->setParameter('evtStateName', 'active');
  116.         $query->setParameter('profileID', $profileID);
  117.         $query->setParameter('profileTypeID', $profileTypeID);
  118.         $query->setParameter('today', new \DateTime());
  119.         $events = $query->getResult();
  121.         if (isset($events) && count($events) > 0) {
  122.             return $events;
  123.         } else {
  124.             return null;
  125.         }
  126.     }
  127. }