src/JuridicusBundle/Controller/PrueferController.php line 568

Open in your IDE?
  1. <?php
  3. namespace JF\JuridicusBundle\Controller;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\HttpFoundation\JsonResponse;
  8. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  9. use Symfony\Component\Process\Process;
  10. use Symfony\Component\Security\Core\Exception\AccessDeniedException;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  13. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  14. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  15. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  16. use JF\JuridicusBundle\Entity\Kunde;
  17. use JF\JuridicusBundle\Entity\KundePruefung;
  18. use JF\JuridicusBundle\Entity\PrueferEmail;
  19. use JF\JuridicusBundle\Entity\Pruefer;
  20. use JF\JuridicusBundle\Entity\PrueferUser;
  21. use JF\JuridicusBundle\Entity\Dienststellung;
  22. use JF\JuridicusBundle\Entity\Titel;
  23. use JF\JuridicusBundle\Entity\User;
  24. use JF\JuridicusBundle\Entity\Pruefung;
  25. use JF\JuridicusBundle\Entity\PdfProtokollmappePruefer;
  26. use JF\JuridicusBundle\Entity\ProtokollInfothekPruefer;
  27. use JF\JuridicusBundle\Entity\PdfProtokollInfothekPruefer;
  28. use JF\JuridicusBundle\Entity\ProtokollInfothekPruefung;
  29. use JF\JuridicusBundle\Entity\Download;
  30. use JF\JuridicusBundle\Entity\Pruefungsamt;
  31. use JF\JuridicusBundle\Entity\Bundesland;
  32. use JF\JuridicusBundle\Form\PrueferType;
  33. use JF\JuridicusBundle\Form\PrueferUserType;
  34. use JF\JuridicusBundle\Form\PruefungsamtPreSelectType;
  35. use Symfony\Component\Form\Extension\Core\Type\DateType;
  36. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  37. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  38. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  39. use Swift_Mailer;
  40. use Swift_Message;
  41. use Doctrine\ORM\EntityManagerInterface;
  42. use JF\JuridicusBundle\Services\Sms;
  43. use JF\JuridicusBundle\Entity\MailTemplate;
  45. /**
  46.  * Pruefer controller.
  47.  */
  48. class PrueferController extends AbstractController
  49. {
  51.     /**
  52.      * Lists all Pruefungsamt entities.
  53.      *
  54.      * @Route("/pruefungsprotokolle-{examNr}-staatsexamen", name="pruefer")
  55.      */
  56.     public function indexAction($examNr = 1)
  57.     {
  58.         $em = $this->getDoctrine()->getManager();
  59.         if ($examNr == 1) {
  60.             $examType = Pruefung::TYP_EXAMEN_1;
  61.         } else {
  62.             $examType = Pruefung::TYP_EXAMEN_2;
  63.         }
  64.         
  65.         $pip_repo = $em->getRepository(ProtokollInfothekPruefer::class);
  66.         $statistik = $pip_repo->filterParagraphsByExamen($examType);
  67.         $bundeslaender = $em->getRepository(Bundesland::class)->findAll();
  68.         
  69.         $entities = $em->getRepository(Pruefung::class)->findNewest(8, $examType);
  70.         $entities_indexed1 = array();
  71.         $entities_indexed2 = array();
  72.         $index = 0;
  73.         foreach ($entities as $entity) {
  74.             $datum = $entity->getDatum()->format('d.m.Y');
  75.             if ($index%2 == 0) {
  76.                 $entities_indexed1[$datum][] = $entity;
  77.             } else {
  78.                 $entities_indexed2[$datum][] = $entity;
  79.             }
  80.             $index++;
  81.         }
  82.         
  83.         $filter_form = $this->createParagraphFilterForm($examNr);
  84.         
  85.         return $this->render('@JFJuridicusBundle/Pruefer/pruefungsamt_index.html.twig', array(
  86.             'statistik'         => $statistik,
  87.             'filter_form'       => $filter_form->createView(),
  88.             'entities_indexed1' => $entities_indexed1,
  89.             'entities_indexed2' => $entities_indexed2,
  90.             'examType'             => $examType,
  91.             'entities' => $bundeslaender,
  92.         ));
  93.     }
  94.     
  95.         /**
  96.      *
  97.      * @param array $data
  98.      * @return \Symfony\Component\Form\Form
  99.      */
  100.     private function createParagraphFilterForm($examNr)
  101.     {
  102.         $data = array('examen'=>$examNr);
  103.         return $this->createFormBuilder($data)
  104.                 ->add('bundesland', EntityType::class, array(
  105.                      'label'       => false,
  106.                     'class' => 'JF\JuridicusBundle\Entity\Bundesland',
  107.                     'placeholder' => 'Bundesland wählen...',
  108.                     'required' => false,
  109.                     
  110.                 ))
  111.                 ->add('fach', ChoiceType::class, array(
  112.                     'label'       => false,
  113.                     'placeholder' => 'Fach auswählen...',
  114.                     'choices' => array(
  115.                         'Strafrecht' => 'Strafrecht',
  116.                         'Öffentliches Recht' => 'Öffentliches Recht',
  117.                         'Zivilrecht' => 'Zivilrecht',
  118.                         'Arbeitsrecht' => 'Arbeitsrecht',
  119.                         'Verwaltungsrecht' => 'Verwaltungsrecht',
  120.                     ),
  121.                     'required' => false,
  122.                     
  123.                 ))
  124.                 ->add('startdatum', DateType::class, array(
  125.                     'label'       => false,
  126.                     'placeholder' => 'Zeitraum von',
  127.                     'widget'      => 'single_text',
  128.                     //'format'      => 'dd.MM.yyyy',
  129.                     'required'    => false,
  130.                     'attr'        => ['class' => 'js-datepicker', 'placeholder' => 'Zeitraum von ...',],
  131.                 ))
  132.                 ->add('endedatum', DateType::class, array(
  133.                     'label'       => false,
  134.                     'placeholder' => 'bis ...',
  135.                     'widget'      => 'single_text',
  136.                     //'format'      => 'dd.MM.yyyy',
  137.                     'placeholder' => '',
  138.                     'required'    => false,
  139.                     'attr'        => ['class' => 'js-datepicker', 'placeholder' => 'bis',],
  140.                 ))
  141.                 ->add('examen', HiddenType::class, array(
  142.                     'label'       => false,
  143.                     
  144.                     'required' => false,
  145.                     
  146.                 ))
  147.                 ->getForm();
  148.     }
  151.     /**
  152.      * Finds and displays Pruefer entities for a given Prüfungsamt
  153.      *
  154.      * @Route("/pruefungsprotokolle-{examen}-staatsexamen/{bslug}", 
  155.      *  name="pruefer_index_pruefungsamt", 
  156.      *  requirements={"examen"="[12]"}
  157.      * )
  158.      */
  159.     public function showPruefungsamtAction($bslug, $examen)
  160.     {
  161.         $em = $this->getDoctrine()->getManager();
  162.         $pruefungsamt = $em->getRepository(Pruefungsamt::class)->findByExamenAndBSlug($examen, $bslug);
  163.         if (!$pruefungsamt) {
  164.             throw $this->createNotFoundException('Prüfungsamt wurde nicht gefunden.');
  165.         }
  167.         $pruefer_liste = $em->getRepository(Pruefer::class)
  168.                 ->findByPruefungsamt($pruefungsamt->getId(), $pruefungsamt->hasVollbestand());
  170.         $statistik = $em->getRepository(ProtokollInfothekPruefer::class)->filterParagraphsByPruefungsamt($pruefungsamt);
  172.         return $this->render('@JFJuridicusBundle/Pruefer/index.html.twig', array(
  173.             'pruefungsamt' => $pruefungsamt,
  174.             'pruefer_liste' => $pruefer_liste,
  175.             'typ_options' => Pruefung::getTypOptions(),
  176.             'statistik' => $statistik,
  177.         ));
  178.     }
  180.     /**
  181.      * Finds and displays a Pruefer entity.
  182.      *
  183.      * @Route("/pruefungsprotokolle-{examen}-staatsexamen/{bslug}/{pslug}_pruefer_protokolle_pruefung_jura",
  184.      *         name="pruefer_show",
  185.      *      requirements={"examen"="[12]"}
  186.      * )
  187.      */
  188.     public function showAction($examen, $bslug, $pslug)
  189.     {
  190.         $em = $this->getDoctrine()->getManager();
  192.         $bundesland = $em->getRepository(Bundesland::class)->findOneBySlug($bslug);
  193.         if (!$bundesland) {
  194.             throw $this->createNotFoundException('Bundesland wurde nicht gefunden.');            
  195.         }
  196.         $pruefungsamt = $em->getRepository(Pruefungsamt::class)->findByExamenAndBSlug($examen, $bslug);
  197.         if (!$pruefungsamt) {
  198.             throw $this->createNotFoundException('Prüfungsamt wurde nicht gefunden.');
  199.         }
  201.         // Bei Vollbestand werden Prüfer ohne Protokolle umgeleitet - eventuell ändern?
  202.         $pruefer = $em->getRepository(Pruefer::class)
  203.             ->findByPruefungsamtAndSlug($pruefungsamt->getId(), $pslug, $pruefungsamt->hasVollbestand());
  205.         if (!$pruefer) {
  206.             return $this->redirect($this->generateUrl('pruefer_index_pruefungsamt', array(
  207.                 'examen' => $examen, 'bslug' => $bslug,
  208.             )));
  209.         }
  211.         $kunde = new Kunde();
  212.         $kunde->setBundesland($bundesland);
  213.         $kunde->setExamen($examen);
  214.         
  215.         $form = $this->createForm(PruefungsamtPreSelectType::class, $kunde);
  216.               
  217.         return $this->render('@JFJuridicusBundle/Pruefer/show.html.twig', array(
  218.             'bundesland' => $bundesland,
  219.             'examen' => $examen,
  220.             'pruefungsamt' => $pruefungsamt,
  221.             'pruefer' => $pruefer,
  222.             'form' => $form->createView(),
  223.             'typ_options' => Pruefung::getTypOptions(),
  224.         ));
  225.     }
  227.     /**
  228.      * Finds and displays a Pruefer and shows download text
  229.      *
  230.      * @Route("/pruefer/download/success", name="pruefer_download_success")
  231.      * @Method({"POST"})
  232.      */
  233.     public function downloadSuccessAction(Request $request)
  234.     {
  235.         $this->denyAccessUnlessGranted('ROLE_KUNDE');
  236.         $em = $this->getDoctrine()->getManager();
  238.         $user = $this->getUser();
  239.         $kunde = $user->getKunde();
  240.         /* @var $kunde \JF\JuridicusBundle\Entity\Kunde */
  242.         $pruefer_id = $request->request->getInt('pruefer_id');
  243.         $pruefung_id = $request->request->getInt('pruefung_id');
  244.         $examen = $request->request->getInt('examen');
  246.         if (!$pruefer_id or !$examen or !$pruefung_id) {
  247.             throw new AccessDeniedException();
  248.         }
  250.         $pruefer = $em->getRepository(Pruefer::class)->find($pruefer_id);
  251.         if (!$pruefer) {
  252.             throw $this->createNotFoundException('Prüfer nicht gefunden');
  253.         }
  254.         if ($pruefer->getAliasFor()) {
  255.             $pruefer = $pruefer->getAliasFor();
  256.         }
  258.         // Berechtigung checken
  259.         $buchung = $em->getRepository(KundePruefung::class)->getDownloadPermission($kunde->getId(), $pruefer->getId());
  260.         /* @var $buchung \JF\JuridicusBundle\Entity\KundePruefung */
  262.         if (!$buchung) {
  263.             // Donwload nicht erlaubt
  264.             throw new AccessDeniedException();
  265.         } else if ($buchung->needsFacebookPost()) {
  266.             // umleiten
  267.             return $this->redirect($this->generateUrl('facebook_write_post', array(
  268.                 'id' => $buchung->getId(),
  269.                 'pruefer_id' => $pruefer_id,
  270.                 'pruefung_id' => $pruefung_id,
  271.                 'examen' => $examen
  272.             )));
  273.         } else if ($buchung->needsKlausurprotokoll()) {
  274.             // umleiten
  275.             return $this->redirect($this->generateUrl('protokoll_klausur_edit', array('id' => $buchung->getId())));
  276.         } else {
  277.             // Download erlaubt
  278.             $pdf = $em->getRepository(PdfProtokollmappePruefer::class)->findOneByPrueferAndExamen($pruefer->getId(), $examen);
  279.             if (!$pdf) {
  280.                 throw $this->createNotFoundException('Protokolldatei nicht gefunden');
  281.             }
  282.         }
  284.         return $this->render("@JFJuridicusBundle/Pruefer/download_success.html.twig", array(
  285.             'pruefer' => $pruefer,
  286.             'examen' => $examen,
  287.             'pdf_id' => $pdf->getId()
  288.         ));
  289.     }
  291.     /**
  292.      * shows download error text
  293.      *
  294.      * @Route("/pruefer/download/error", name="pruefer_download_error")
  295.      */
  296.     public function downloadErrorAction(Request $request)
  297.     {
  298.         $this->denyAccessUnlessGranted('ROLE_KUNDE');
  299.         return $this->render('@JFJuridicusBundle/Pruefer/download_error.html.twig', array());
  300.     }
  302.     /**
  303.      * @Route("/pruefer/download/success/protokollmappe-{id}.pdf", name="pruefer_download")
  304.      */
  305.     public function downloadAction(PdfProtokollmappePruefer $pdf)
  306.     {
  307.         $this->denyAccessUnlessGranted('ROLE_KUNDE');
  308.         $em = $this->getDoctrine()->getManager();
  310.         $user = $this->getUser();
  311.         $kunde = $user->getKunde();
  312.         /* @var $kunde \JF\JuridicusBundle\Entity\Kunde */
  314.         $pruefer = $pdf->getPruefer();
  316.         // Berechtigung checken
  317.         $buchung = $em->getRepository(KundePruefung::class)->getDownloadPermission($kunde->getId(), $pruefer->getId());
  318.         /* @var $buchung \JF\JuridicusBundle\Entity\KundePruefung */
  319.         if (!$buchung || $buchung->needsKlausurprotokoll()) {
  320.             throw new AccessDeniedException();
  321.         }
  323.         // Dateiname für private Kopie
  324.         $dir = $pdf->getDir();
  326.         $stamped_path = tempnam($dir, 'protokoll_stamped_');
  327.         
  328.         //print_r($kunde->getPdfStempel()->getPath());
  329.         //exit();
  331.         // Protokoll stempeln
  332.         $process = new Process([
  333.             'pdftk',
  334.             $pdf->getPath(),
  335.             'stamp',
  336.             $kunde->getPdfStempel()->getPath(),
  337.             'output',
  338.             $stamped_path,
  339.             'owner_pw',
  340.             'stucha5Ac3ep', // später: $bag->get('tcpdf_owner_pw')
  341.             'allow',
  342.             'printing',
  343.         ]);
  346.         $process->run();
  347.         if (!$process->isSuccessful()) {
  348.                 var_dump($process->getErrorOutput());
  349.                 exit();
  350.             return $this->redirect($this->generateUrl('pruefer_download_error'));
  351.         }
  353.         $download = $em->getRepository(Download::class)->findOneBy(array(
  354.             'kunde' => $kunde->getId(), 'pruefer' => $pruefer->getId(), 'examen' => $pdf->getExamen()
  355.         ));
  356.         /* @var $download \JF\JuridicusBundle\Entity\Download */
  357.         if (!$download) {
  358.             $download = new Download();
  359.             $download->setKunde($kunde)->setPruefer($pruefer)->setExamen($pdf->getExamen());
  360.         }
  361.         $download->setBuchung($buchung);
  362.         $download->setAnzahlProtokolle($pdf->getAnzahlProtokolle());
  364.         $em->persist($download);
  365.         $em->flush();
  367.         $filename = sprintf('%s-%d-examen.pdf', $pruefer->getSlug(), $pdf->getExamen());
  369.         $response = new Response();
  370.         $disposition = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $filename);
  371.         $response->headers->set('Content-Disposition', $disposition);
  372.         $response->headers->set('Content-Type', $pdf->getMimeType());
  373.         $response->setContent(@file_get_contents($stamped_path));
  375.         unlink($stamped_path);
  377.         return $response;
  378.     }
  380.     /**
  381.      * Displays a form to create a new Pruefer entity.
  382.      *
  383.      * @Route("/create/pruefer/ajax/new", name="pruefer_ajax_new")
  384.      */
  385.     public function newAjaxAction()
  386.     {
  387.         $this->denyAccessUnlessGranted('ROLE_KUNDE');
  388.         $em = $this->getDoctrine()->getManager();
  390.         $dienststellung_typeaheads = $em->getRepository(Dienststellung::class)->getTypeaheads();
  391.         $titel_typeaheads = $em->getRepository(Titel::class)->getTypeaheads();
  392.         
  393.         $entity = new Pruefer();
  394.         $form = $this->createForm(PrueferType::class, $entity);
  396.         return $this->render("@JFJuridicusBundle/Pruefer/new.html.twig", array(
  397.             'entity' => $entity,
  398.             'form' => $form->createView(),
  399.             'dienststellungNames' => array_keys($dienststellung_typeaheads),
  400.             'titelNames' => array_keys($titel_typeaheads),
  401.         ));
  402.     }
  404.     /**
  405.      * Creates a new Pruefer entity per ajax
  406.      *
  407.      * @Route("/create/pruefer/ajax/create", name="pruefer_ajax_create")
  408.      * @Method({"POST"})
  409.      */
  410.     public function createAjaxAction(Request $request)
  411.     {
  412.         
  413.         $this->denyAccessUnlessGranted('ROLE_KUNDE');
  414.         $em = $this->getDoctrine()->getManager();
  416.         $user = $this->getUser();
  417.         $kunde = $user->getKunde();
  418.         $pruefungsamt = $em->getRepository(Pruefungsamt::class)->findOneByUser($user->getId());
  420.         $entity = new Pruefer();
  421.         $entity->setQuelle('man');
  422.         $entity->setCreator($user);
  424.         $pruefungsamt_candidates = $kunde->getBundesland()->getPruefungsaemter();
  425.         foreach ($pruefungsamt_candidates as $candidate) {
  426.             $entity->addPruefungsaemter($candidate);
  427.         }
  429.         $form = $this->createForm(PrueferType::class, $entity);
  430.         $form->handleRequest($request); //changedFrom bind
  432.         if ($form->isValid()) {
  433.             // Prüfungsämter abgleichen
  434.             $existing_pruefer = $em->getRepository(Pruefer::class)->findExisting($entity, $pruefungsamt);
  436.             if (empty($existing_pruefer)) {
  437.                 $entity->setAliasFor(
  438.                     $em->getRepository(Pruefer::class)->findAlias($entity, null, $pruefungsamt)
  439.                 );
  440.                 if (!$entity->getSlug()) {
  441.                     $entity->setSlug($this->slugify($entity->getVorname().' '.$entity->getNachname()));
  442.                 }
  444.                 $em->persist($entity);
  445.                 $em->flush();
  446.             } else {
  447.                 foreach ($pruefungsamt_candidates as $candidate) {
  448.                     $candidate->removePruefer($entity);
  449.                 }
  451.                 foreach ($existing_pruefer as $p) {
  452.                     /* @var $p \JF\JuridicusBundle\Entity\Pruefer */
  453.                     foreach ($pruefungsamt_candidates as $candidate) {
  454.                         if (!$p->getPruefungsaemter()->contains($candidate)) {
  455.                             $p->addPruefungsaemter($candidate);
  456.                         }
  457.                     }
  458.                     $em->persist($p);
  459.                 }
  460.                 $em->flush();
  461.                 $entity = $existing_pruefer[0];
  462.             }
  464.             return new JsonResponse(array(
  465.                 'success' => true,
  466.                 'objectId' => $entity->getId(),
  467.                 'objectName' => $entity->getFullTextWithOrt()
  468.             ));
  469.         }
  471.         $dienststellung_typeaheads = $em->getRepository(Dienststellung::class)->getTypeaheads();
  472.         $titel_typeaheads = $em->getRepository(Titel::class)->getTypeaheads();
  474.         $html = $this->get('templating')->render("@JFJuridicusBundle/Pruefer/new.html.twig", array(
  475.             'entity' => $entity,
  476.             'form' => $form->createView(),
  477.             'dienststellungNames' => array_keys($dienststellung_typeaheads),
  478.             'titelNames' => array_keys($titel_typeaheads),
  479.         ));
  481.         return new JsonResponse(array(
  482.             'success' => false,
  483.             'html' => $html
  484.         ));
  485.     }
  486.     
  487.         /**
  488.      *
  489.      * @param string $text
  490.      * @param string $style 'lower'|'upper'
  491.      * @return string
  492.      */
  493.     public static function slugify($text, $style = NULL)
  494.     {
  495.         // replace non letter or digits by -
  496.         $text = preg_replace('~[^\\pL\d]+~u', '-', $text);
  498.         // trim
  499.         $text = trim($text, '-');
  501.         // transliterate
  502.         $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
  504.         if ($style == 'lower') {
  505.             // lowercase
  506.             $text = strtolower($text);
  507.         } elseif ($style == 'upper') {
  508.             // uppercase
  509.             $text = strtoupper($text);
  510.         }
  512.         // remove unwanted characters
  513.         $text = preg_replace('~[^-\w]+~', '', $text);
  515.         if (empty($text)) {
  516.             return 'n-a';
  517.         }
  519.         return $text;
  520.     }
  521.     
  522.     /**
  523.      * Lists all Pruefungsamt entities.
  524.      * @Method({"GET"})
  525.      * @Route("/pruefer/protokolle", name="pruefer_protokolle")
  526.      */
  527.     public function prueferBereichAction()
  528.     {
  529.         $this->denyAccessUnlessGranted('ROLE_PRUEFER');
  530.         $em             = $this->getDoctrine()->getManager();
  531.         $user             = $this->getUser();
  532.         $prueferUser     = $em->getRepository(PrueferUser::class)->findOneByUser($user);
  533.         if (!$prueferUser) {
  534.             return $this->render('@JFJuridicusBundle/PrueferBereich/not_yet_verified.html.twig', array(
  535.             
  536.             ));
  537.         }
  538.         $pruefer         = $prueferUser->getPruefer();
  539.         if (!$pruefer) {
  540.             return $this->render('@JFJuridicusBundle/PrueferBereich/not_yet_verified.html.twig', array(
  541.             
  542.             ));
  543.         }
  544.         
  545.         $lastDate = new \DateTime("01-01-2011");
  546.             //$output->writeln("Prüfer: ".$pruefer->getId()." Pruefungen: ".count($pruefer->getPrueferPruefungen())); 
  547.             foreach($pruefer->getPrueferPruefungen() as $prueferPruefung) {
  548.                 if ($lastDate < $prueferPruefung->getPruefung()->getDatum()) {
  549.                         //prüfe ob dazu auch ein Protokoll gibt
  550.                         $infothekPruefung     = $em->getRepository(ProtokollInfothekPruefung::class)->findBy(['pruefung'=>$prueferPruefung->getPruefung()]);
  551.                         if($infothekPruefung) {
  552.                             $lastDate = $prueferPruefung->getPruefung()->getDatum();
  553.                         }
  554.                 }
  555.             }
  556.             foreach($pruefer->getAliases() as $allias) {
  557.                 //$output->writeln("Alias: ".$allias->getId()."  Pruefungen: ".count($allias->getPrueferPruefungen())); 
  558.                 foreach($allias->getPrueferPruefungen() as $prueferPruefung) {
  559.                     if ($lastDate < $prueferPruefung->getPruefung()->getDatum()) {
  560.                         $infothekPruefung     = $em->getRepository(ProtokollInfothekPruefung::class)->findBy(['pruefung'=>$prueferPruefung->getPruefung()]);
  561.                         if($infothekPruefung) {
  562.                             $lastDate = $prueferPruefung->getPruefung()->getDatum();
  563.                         }
  564.                     }
  565.                     
  566.                 }
  567.             }
  568.             
  569.         
  570.         
  571.         //Letztes Protokoll
  572.         //$lastProtocol     = $em->getRepository('JFJuridicusBundle:Pruefer')->findLastProtocol($pruefer);
  573.         $pdf1Exam         = $em->getRepository(PdfProtokollmappePruefer::class)->findOneByPrueferAndExamen($pruefer->getId(), 1);
  574.         $pdf2Exam         = $em->getRepository(PdfProtokollmappePruefer::class)->findOneByPrueferAndExamen($pruefer->getId(), 2);
  575.         
  576.         return $this->render('@JFJuridicusBundle/PrueferBereich/index.html.twig', array(
  577.             "lastProtocol"    =>     $lastDate,
  578.             "pruererUser"     =>    $prueferUser,
  579.             "pruefer"        =>    $pruefer,
  580.             "pdf1Exam"         =>     $pdf1Exam,
  581.             "pdf2Exam"         =>     $pdf2Exam
  582.         ));
  583.     }
  585.     /**
  586.      * @Method({"GET"})
  587.      * @Route("/pruefer/protokolle/download/{exam}", name="pruefer_protokolle_download")
  588.      */
  589.     public function prueferBereichDownloadAction($exam) {
  590.         $this->denyAccessUnlessGranted('ROLE_PRUEFER');
  591.         $em             = $this->getDoctrine()->getManager();
  592.         $user             = $this->getUser();
  593.         $prueferUser     = $em->getRepository(PrueferUser::class)->findOneByUser($user);
  594.         $pruefer         = $prueferUser->getPruefer();
  595.         if (!$pruefer) {
  596.             throw $this->createNotFoundException('Pruefer noch nicht verifiziert');
  597.         }
  598.         
  599.         // Download erlaubt
  600.         $pdf = $em->getRepository(PdfProtokollmappePruefer::class)->findOneByPrueferAndExamen($pruefer->getId(), $exam);
  601.     
  602.         return $pdf->createResponse();
  603.     }
  605.     /**
  606.      * @Method({"GET"})
  607.      * @Route("/pruefer/registration", name="pruefer_registration")
  608.      */
  609.     public function prueferRegistrationAction()
  610.     {
  611.         $form = $this->createForm(PrueferUserType::class, new PrueferUser());
  612.         
  613.         return $this->render('@JFJuridicusBundle/PrueferBereich/registration.html.twig', array( 
  614.             "form" => $form->createView()
  615.         ));
  616.     }
  617.     
  618.     /**
  619.      * @Method({"POST"})
  620.      * @Route("/pruefer/registration/save", name="pruefer_registration_save")
  621.      */
  622.     public function prueferRegistrationSaveAction(Request $request)
  623.     {
  624.         $form = $this->createForm(PrueferUserType::class, new PrueferUser()); //changedFrom
  625.         $form->handleRequest($request); //changedFrom bind
  626.     
  627.         if ($form->isSubmitted() && $form->isValid()) {
  628.             $em = $this->getDoctrine()->getManager();
  629.             $prueferUser = $form->getData();
  630.             //dump($prueferUser);
  631.             //früher fos_user - nicht sicher ob es jetzt user ist Hier [TODO] - wie war unterschied fos_user und prueferUser?
  632.             $user                 = $em->getRepository(User::class)->findOneBy(['email'=>$prueferUser->getEmail()]);
  633.             $prueferUserOld     = $em->getRepository(PrueferUser::class)->findOneByEmail($prueferUser->getEmail());
  634.             
  635.             if ($prueferUserOld) {
  636.                 return $this->render('@JFJuridicusBundle/PrueferBereich/email_in_use.html.twig', array( 
  637.                     
  638.                 ));
  639.                 //throw $this->createNotFoundException('Die von Ihnen genutzte E-Mail-Adresse ist bei juridicus bereits registriert. Bitte nutzen Sie die „Passwort vergessen“- Funktion. Sollte Ihnen wider Erwarten kein neues Passwort zugestellt werden, nehmen Sie bitte über info@juridicus.de Kontakt mit uns auf.');
  640.             }
  641.             // alten User ggfs. umbiegen
  642.             if ($user) {
  643.                 $kunde_old = $user->getKunde();
  644.                 if ($kunde_old) {
  645.                     $kunde_old->setUser(null);
  646.                     $em->persist($kunde_old);
  647.                     $em->flush();
  648.                 } else {
  649.                     $user->addRole("ROLE_PRUEFER");
  650.                 }
  651.             } else {
  652.                 // entsprechenden User neu erstellen
  653.                 $user = new User();
  654.                 $user->addRole("ROLE_PRUEFER");
  655.                 $user->setUsername($prueferUser->getEmail());
  656.                 $user->setEmail($prueferUser->getEmail());
  657.                 $user->setPlainPassword(substr(uniqid(md5(rand())), 8, 8));
  658.             }
  660.             $token = uniqid(md5(rand()));
  661.             $user->setConfirmationToken($token);
  662.             $user->setEnabled(false);
  663.             $em->persist($user);
  664.             
  665.             $prueferUser->setUser($user);
  666.             $em->persist($prueferUser);
  667.             $em->flush();
  668.             
  669.             // finde neuestes Template
  670.             $template = $em->getRepository(MailTemplate::class)->findCurrentByTyp(PrueferEmail::PRUEFER_BEREICH_REGISTRIERUNG);
  671.             
  672.             $link = $this->generateUrl('pruefer_registration_activate', array('token' => $token), UrlGeneratorInterface::ABSOLUTE_URL); //chagngedFrom true
  673.             
  674.             $replacements = array(
  675.                 'vorname' => $prueferUser->getVorname(),
  676.                 'nachname' => $prueferUser->getNachname(),
  677.                 'titel'    => $prueferUser->getTitel(),
  678.                 'email' => $prueferUser->getEmail(),
  679.                // 'handynummer' => $prueferUser->getHandynummer(),
  680.                 'link' => $link
  681.             );
  682.             
  683.             $this->logger->info(sprintf('Link: %s ', $link));
  684.       
  685.             $mailerBcc = $this->getParameter('mailer_bcc');
  686.             $mailUser     = $this->getParameter('mailer_user');
  687.             
  689.             $message = (new Swift_Message($template->getBetreff()))
  690.                     ->setFrom(array($mailUser => 'Juridicus'))
  691.                     ->setReplyTo('info@juridicus.de')
  692.                     ->setTo($prueferUser->getEmail())
  693.                     ->setBcc('info@juridicus.de')
  694.                     ->setBody($template->replace($replacements), 'text/html')
  695.             ;
  697.              if (isset($mailerBcc)) {
  698.                 $message->setBcc(array($mailerBcc));
  699.             }
  701.             if ($this->mailer->send($message)) {
  702.                 // Versand speichern
  703.                 $email = new PrueferEmail();
  704.                 $email
  705.                     ->setTyp(PrueferEmail::PRUEFER_BEREICH_REGISTRIERUNG)
  706.                     ->setPrueferUser($prueferUser)
  707.                 ;
  708.                 $em->persist($email);
  709.                 $em->flush();
  710.                 $this->get('session')->set('registration_email_success', $prueferUser->getEmail());
  712.                 return $this->redirect($this->generateUrl('pruefer_registration_email_success'));
  713.             } else {
  714.                 
  715.                 $this->get('session')->set('registration_email_error', $prueferUser->getEmail());
  717.                 return $this->redirect($this->generateUrl('pruefer_registration_email_error'));
  718.             }
  719.             
  720.         }
  721.         
  722.         return $this->render('@JFJuridicusBundle/PrueferBereich/registration.html.twig', array( 
  723.             "form" => $form->createView()
  724.         ));
  725.     }
  726.     
  727.     
  728.         /**
  729.      * Tell the user to check his email provider
  730.      *
  731.      * @Route("/pruefer/email/success", name="pruefer_registration_email_success")
  732.      */
  733.     public function prueferEmailSuccessAction()
  734.     {
  735.         $user_manager = $this->container->get('fos_user.user_manager');
  736.         $session = $this->container->get('session');
  737.         $email = $session->get('registration_email_success');
  738.         $session->remove('registration_email_success');
  740.         if (empty($email)) {
  741.             // the user does not come from the sendEmail action
  742.             return $this->redirect($this->generateUrl('homepage'));
  743.         }
  745.         return $this->render('@JFJuridicusBundle/PrueferBereich/email_success.html.twig', array(
  746.             'email' => $email
  747.         ));
  748.     }
  750.     /**
  751.      * Tell the prueferUser that email sending failed
  752.      *
  753.      * @Route("/pruefer/email/error", name="pruefer_registration_email_error")
  754.      */
  755.     public function prueferEmailErrorAction()
  756.     {
  757.         $user_manager = $this->container->get('fos_user.user_manager');
  758.         $session = $this->container->get('session');
  759.         $email = $session->get('registration_email_error');
  760.         $session->remove('registration_email_error');
  762.         if (empty($email)) {
  763.             // the user does not come from the sendEmail action
  764.             return $this->redirect($this->generateUrl('homepage'));
  765.         }
  768.         return $this->render('@JFJuridicusBundle/PrueferBereich/email_error.html.twig', array(
  769.             'email' => $email
  770.         ));
  771.     }
  773.     /**
  774.      * Tell the user to check his sms
  775.      *
  776.      * @Route("/pruefer/sms/success", name="pruefer_registration_sms_success")
  777.      */
  778.     public function prueferSmsSuccessAction()
  779.     {
  780.         $user_manager = $this->get('fos_user.user_manager');
  781.         $session = $this->get('session');
  782.         $email = $session->get('registration_email_success');
  783.         $session->remove('registration_email_success');
  784.         $em = $this->getDoctrine()->getManager();
  785.         if (empty($email)) {
  786.             // the user does not come from the sendEmail action
  787.             return $this->redirect($this->generateUrl('homepage'));
  788.         }
  789.         $prueferUser     = $em->getRepository(PrueferUser::class)->findOneByEmail($email);
  790.         return $this->render('@JFJuridicusBundle/PrueferBereich/sms_success.html.twig', array(
  791.             'prueferUser' => $prueferUser
  792.         ));
  793.     }
  795.     /**
  796.      * Tell the user that email is checked
  797.      *
  798.      * @Route("/pruefer/email/check/success", name="pruefer_registration_email_check_success")
  799.      */
  800.     public function prueferEmailCheckSuccessAction()
  801.     {
  802.         $session = $this->container->get('session');
  803.         $email = $session->get('registration_email_success');
  804.         $session->remove('registration_email_success');
  805.         $em = $this->getDoctrine()->getManager();
  806.         if (empty($email)) {
  807.             // the user does not come from the sendSms action
  808.             return $this->redirect($this->generateUrl('homepage'));
  809.         }
  810.         $prueferUser     = $em->getRepository(PrueferUser::class)->findOneByEmail($email);
  811.         
  813.         return $this->render('@JFJuridicusBundle/PrueferBereich/email_checked.html.twig', array(
  814.             'email' => $email
  815.         ));
  816.     }
  818.     /**
  819.      * Tell the user that sms sending failed
  820.      *
  821.      * @Route("/pruefer/sms/error", name="pruefer_registration_sms_error")
  822.      */
  823.     public function prueferSmsErrorAction()
  824.     {
  825.         $user_manager = $this->container->get('fos_user.user_manager');
  826.         $session = $this->container->get('session');
  827.         $email = $session->get('registration_sms_error');
  828.         $code = $session->get('registration_sms_code');
  829.         $message = $session->get('registration_sms_message');
  830.         $session->remove('registration_sms_error');
  831.         $session->remove('registration_sms_code');
  832.         $session->remove('registration_sms_message');
  833.         $em = $this->getDoctrine()->getManager();
  834.         if (empty($email) || empty($code) || empty($message)) {
  835.             // the user does not come from the sendSms action
  836.             return $this->redirect($this->generateUrl('homepage'));
  837.         }
  838.         $prueferUser     = $em->getRepository(PrueferUser::class)->findOneByEmail($email);
  839.         
  841.         return $this->render('@JFJuridicusBundle/PrueferBereich/sms_error.html.twig', array(
  842.             'prueferUser' => $prueferUser,
  843.             'code' => $code,
  844.             'message' => $message,
  845.         ));
  846.     }
  847.     
  848.        /**
  849.      * Receive the confirmation token and send SMS with password
  850.      *
  851.      * @Route("pruefer/activate/{token}", name="pruefer_registration_activate")
  852.      */
  853.     public function prueferActivateAction($token)
  854.     {
  855.         $em = $this->getDoctrine()->getManager();
  857.         $user_manager = $this->container->get('fos_user.user_manager');
  858.         /* @var $user_manager \FOS\UserBundle\Model\UserManager */
  860.         $sms_service = $this->container->get('jf_juridicus.sms');
  861.         /* @var $sms_service \JF\JuridicusBundle\Services\Sms */
  863.         $user = $user_manager->findUserByConfirmationToken($token);
  864.         if (null === $user) {
  865.             throw $this->createNotFoundException('Der Aktivierungscode ist ungültig oder wurde schon verwendet.');
  866.         }
  868.         $prueferUser = $em->getRepository(PrueferUser::class)->findOneByUser($user);
  870.         if (null === $prueferUser) {
  871.             throw $this->createNotFoundException('Der Benutzer zu diesem Aktivierungscode ist nicht mehr vorhanden.');
  872.         }
  874.         /* Hier wurde die E-Mail mit dem Passwort versendet, jetzt wird diese E-Mail erst nach verifizierung versendet */
  875.         
  876.         $password_plain = substr(uniqid(md5(rand())), 8, 8);
  878.         $user->setConfirmationToken(null);
  879.         $user->setPlainPassword($password_plain);
  880.         $user->setEnabled(true);
  881.         $em->persist($user);
  882.         $this->get('logger')->info(sprintf('User: %s PW: %s', $user->getEmail(), $password_plain));
  884.         // Senden des Passwords per SMS
  885.         $template = $em->getRepository(MailTemplate::class)->findCurrentByTyp(PrueferEmail::PRUEFER_BEREICH_REGISTRIERUNG_PASSWORT);
  886.         $replacements = array(
  887.             'titel'            => $prueferUser->getTitel(),
  888.             'vorname'         => $prueferUser->getVorname(),
  889.             'nachname'         => $prueferUser->getNachname(),
  890.             'email'         => $prueferUser->getEmail(),
  891.             'link'             => 'https://juridicus.de/pruefer/login',
  892.             'password'         => $password_plain
  893.         );
  895.         // NEW send E-Mail with PW 
  896.         $mailer_user = $this->container->getParameter('mailer_user');
  897.         $mailer_bcc = $this->container->getParameter('mailer_bcc');
  898.         $mailer = $this->get('mailer');
  900.             $message = \Swift_Message::newInstance()
  901.                     ->setSubject($template->getBetreff())
  902.                     ->setFrom(array($mailer_user => 'Juridicus'))
  903.                     ->setReplyTo('info@juridicus.de')
  904.                     ->setTo($prueferUser->getEmail())
  905.                     ->setBcc('info@juridicus.de')
  906.                     ->setBody($template->replace($replacements), 'text/html')
  907.             ;
  910.             if ($mailer->send($message)) {
  911.                 // Versand speichern
  912.                 $email = new PrueferEmail();
  913.                 $email
  914.                     ->setTyp(PrueferEmail::PRUEFER_BEREICH_REGISTRIERUNG_PASSWORT)
  915.                     ->setPrueferUser($prueferUser)
  916.                 ;
  917.                 $em->persist($email);
  918.                 $em->flush();
  919.                 $this->get('session')->set('registration_email_success', $prueferUser->getEmail());
  921.                 return $this->redirect($this->generateUrl('pruefer_registration_sms_success'));
  922.             } else {
  923.                 
  924.                 $this->get('session')->set('registration_email_error', $prueferUser->getEmail());
  926.                 return $this->redirect($this->generateUrl('pruefer_registration_sms_error'));
  927.             }
  928.         
  929.         /*$this->get('session')->set('registration_email_success', $prueferUser->getEmail());
  930.         return $this->redirect($this->generateUrl('pruefer_registration_email_check_success'));
  931.         */
  932.     }
  934. }