src/Controller/ActionController.php line 408

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Action;
  6. use App\Entity\Actioncategory;
  7. use App\Entity\Settings;
  8. use App\Entity\Appointments;
  9. use App\Entity\Appointmentscategory;
  10. use App\Entity\User;
  11. use App\Entity\Actionlog;
  12. use App\Entity\Orderstatus;
  14. use App\Form\ActionType;
  15. use App\Repository\ActionRepository;
  16. use App\Repository\AppointmentsRepository;
  17. use App\Repository\OrderRepository;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\HttpFoundation\Response;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  24. use Symfony\Component\Form\Extension\Core\Type\TextType;
  25. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  26. use Symfony\Component\Form\Extension\Core\Type\DateTimeType;
  27. use Symfony\Component\Form\Extension\Core\Type\DateType;
  28. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  29. use Symfony\Component\Form\Extension\Core\Type\SearchType;
  30. use Symfony\Component\Form\FormBuilderInterface;
  31. use Symfony\Component\Form\FormEvent;
  32. use Symfony\Component\Form\FormEvents;
  34. use Doctrine\ORM\EntityRepository;
  35. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  36. use Symfony\Component\Form\Extension\Core\Type\FileType;
  37. use Symfony\Component\Validator\Constraints\File;
  39. use App\Service\FileUploader;
  40. use App\Service\ActionReminder;
  41. use App\Service\ActionService;
  43. use Doctrine\DataTables;
  45. /**
  46.  * @Route("/action")
  47.  */
  48. class ActionController extends AbstractController
  49. {
  50.     /**
  51.      * @Route("/", name="action_index", methods={"GET"})
  52.      */
  53.     public function index(): Response
  54.     {
  55.         return $this->render('action/index.html.twig');
  56.     }
  57.     
  59.     /**
  60.      * @Route("/ssp", name="action_ssp", methods={"GET"})
  61.      */
  62.     public function ssp(): Response
  63.     {
  64.         $em = $this->getDoctrine()->getManager();
  65.         
  66.         $datatables = (new DataTables\Builder())
  67.             ->withColumnAliases([
  68.                 'a_duedate' => 'a.duedate',
  69.                 'u_username' => 'u.username',
  70.                 'a_title' => 'a.title',
  71.                 'o_ordernumber' => 'o.ordernumber',
  72.                 'c_name' => 'c.name',
  73.                 'c_city' => 'c.city',
  74.                 'a_completedate' => 'a.completedate',
  75.             ]) 
  76.             ->withIndexColumn('a.id')
  77.             ->withQueryBuilder(
  78.                 $em->createQueryBuilder()
  79.                     ->select('a','o','c','u')
  80.                     ->from(Action::class, 'a')
  81.                     ->leftjoin('a.actionholder','u')
  82.                     ->leftjoin('a.orderid','o')
  83.                     ->leftjoin('o.customer','c')
  84.                     ->where('a.status = 1')
  85.                     ->andWhere('a.isfinished = false')
  86.             )
  87.             ->withRequestParams($_GET);
  88.         
  89.         #echo "<pre>";
  90.         #echo json_encode($datatables->getResponse(), JSON_PRETTY_PRINT);
  91.         #exit();
  92.         
  93.         return new Response(json_encode($datatables->getResponse()));
  95.     }    
  96.     
  97.      /**
  98.      * @Route("/personalview", name="action_index_personal", methods={"GET"})
  99.      */
  100.     public function personalview(): Response
  101.     {
  102.         return $this->render('action/indexpersonal.html.twig');
  103.     }
  104.     
  105.      /**
  106.      * @Route("/personalhiddenview", name="action_index_personalhidden", methods={"GET"})
  107.      */
  108.     public function personalhiddenview(): Response
  109.     {
  110.         return $this->render('action/indexpersonalhidden.html.twig');
  111.     }    
  112.     
  113.     /**
  114.      * @Route("/personalssp", name="action_personal_ssp", methods={"GET"})
  115.      */
  116.     public function personalssp(): Response
  117.     {
  118.         $em = $this->getDoctrine()->getManager();
  119.         
  120.         $datatables = (new DataTables\Builder())
  121.             ->withColumnAliases([
  122.                 'a_duedate' => 'a.duedate',
  123.                 'u_username' => 'u.username',
  124.                 'a_title' => 'a.title',
  125.                 'o_ordernumber' => 'o.ordernumber',
  126.                 'c_name' => 'c.name',
  127.                 'c_city' => 'c.city',
  128.                 'a_completedate' => 'a.completedate',
  129.             ]) 
  130.             ->withIndexColumn('a.id')
  131.             ->withQueryBuilder(
  132.                 $em->createQueryBuilder()
  133.                     ->select('a','o','c','u','k')
  134.                     ->from(Action::class, 'a')
  135.                     ->leftjoin('a.actionholder','u')
  136.                     ->leftjoin('a.orderid','o')
  137.                     ->leftjoin('o.customer','c')
  138.                     ->leftjoin('a.category','k')
  139.                     ->where('a.status = 1')
  140.                     ->andWhere(':userId NOT MEMBER OF k.hiddenbyusers')
  141.                     ->andWhere('a.actionholder = ' . $this->getUser()->getId())
  142.                     ->andWhere('a.isfinished = false')
  143.                     ->setParameter("userId", $this->getUser()->getId())
  144.             )
  145.             ->withRequestParams($_GET);
  146.         
  147.         return new Response(json_encode($datatables->getResponse()));
  149.     }        
  151.     /**
  152.      * @Route("/personalhiddenssp", name="action_personalhidden_ssp", methods={"GET"})
  153.      */
  154.     public function personalhiddenssp(): Response
  155.     {
  156.         $em = $this->getDoctrine()->getManager();
  157.         
  158.         $datatables = (new DataTables\Builder())
  159.             ->withColumnAliases([
  160.                 'a_duedate' => 'a.duedate',
  161.                 'u_username' => 'u.username',
  162.                 'a_title' => 'a.title',
  163.                 'o_ordernumber' => 'o.ordernumber',
  164.                 'c_name' => 'c.name',
  165.                 'c_city' => 'c.city',
  166.                 'a_completedate' => 'a.completedate',
  167.             ]) 
  168.             ->withIndexColumn('a.id')
  169.             ->withQueryBuilder(
  170.                 $em->createQueryBuilder()
  171.                     ->select('a','o','c','u','k')
  172.                     ->from(Action::class, 'a')
  173.                     ->leftjoin('a.actionholder','u')
  174.                     ->leftjoin('a.orderid','o')
  175.                     ->leftjoin('o.customer','c')
  176.                     ->leftjoin('a.category','k')
  177.                     ->where('a.status = 1')
  178.                     ->andWhere(':userId MEMBER OF k.hiddenbyusers')
  179.                     ->andWhere('a.actionholder = ' . $this->getUser()->getId())
  180.                     ->andWhere('a.isfinished = false')
  181.                     ->setParameter("userId", $this->getUser()->getId())
  182.             )
  183.             ->withRequestParams($_GET);
  184.         
  185.         return new Response(json_encode($datatables->getResponse()));
  187.     }    
  188.     
  189.     /**
  190.      * @Route("/filteredview", name="action_index_filtered", methods={"GET","POST"})
  191.      */
  192.     public function filteredview(Request $request, ActionRepository $actionRepository): Response
  193.     {
  194.         $form = $this->createFormBuilder()
  195.             ->add('category', EntityType::class, [
  196.                 'label_attr' => array('class' => ''),
  197.                 'attr' => array('class' => 'form-control selectpicker','data-live-search' => 'true'),
  198.                 'required' => false,
  199.                 'query_builder' => function (EntityRepository $er) {
  200.                     return $er->createQueryBuilder('u')
  201.                         ->where('u.status = 1')
  202.                         ->orderBy('u.priority', 'DESC');
  203.                     },
  204.                 'class' => Actioncategory::class,
  205.                 'choice_label' => 'name',
  206.                 'placeholder' => 'Alle categoriën',
  207.                 'label' => 'Filter op actiecategorie(ën)',
  208.                 'multiple' => true,
  209.                 ])
  210.             ->add('user', EntityType::class, [
  211.                 'label_attr' => array('class' => ''),
  212.                 'attr' => array('class' => 'form-control selectpicker','data-live-search' => 'true'),
  213.                 'required' => false,
  214.                 'query_builder' => function (EntityRepository $er) {
  215.                     return $er->createQueryBuilder('u')
  216.                         ->where('u.status = 1');
  217.                     },
  218.                 'class' => User::class,
  219.                 'choice_label' => 'username',
  220.                 'placeholder' => 'Alle gebruikers',
  221.                 'label' => 'Filter op actiehouder',
  222.                 ])                
  223.             ->add('finished', ChoiceType::class, [
  224.                 'label' => 'Filter op lopend of afgerond',
  225.                 'attr' => array('class' => 'form-control selectpicker'),
  226.                 'placeholder' => 'Alles tonen',
  227.                 'required' => false,
  228.                 'choices'  => [
  229.                     'Lopend' => 1,
  230.                     'Lopend (over tijd)' => 2,
  231.                     'Afgerond' => 3,
  232.                 ]])
  233.             ->add('showdeleted', ChoiceType::class, [
  234.                 'label' => 'Verwijderde acties tonen',
  235.                 'attr' => array('class' => 'form-control selectpicker'),
  236.                 'placeholder' => 'Alles tonen',
  237.                 'required' => false,
  238.                 'data' => 2,
  239.                 'choices'  => [
  240.                     'Alleen bestaande' => 2,
  241.                     'Uitsluitend verwijderde' => 1,
  242.                 ]])
  243.             ->add('startdate', DateType::class, array(
  244.                 'widget'=> 'single_text', 
  245.                 'label' => 'Streefdatum na',
  246.                 'attr' => array('class' => 'form-control'),
  247.                 'required' => false,
  248.                 ))        
  249.             ->add('enddate', DateType::class, array(
  250.                 'widget'=> 'single_text', 
  251.                 'label' => 'Streefdatum voor',
  252.                 'attr' => array('class' => 'form-control'),
  253.                 'required' => false,
  254.                 ))
  255.             ->add('createstartdate', DateType::class, array(
  256.                 'widget'=> 'single_text', 
  257.                 'label' => 'Actie aangemaakt na',
  258.                 'attr' => array('class' => 'form-control'),
  259.                 'required' => false,
  260.                 ))        
  261.             ->add('createenddate', DateType::class, array(
  262.                 'widget'=> 'single_text', 
  263.                 'label' => 'Actie aangemaakt voor',
  264.                 'attr' => array('class' => 'form-control'),
  265.                 'required' => false,
  266.                 ))                    
  267.             ->getForm();
  268.         $form->handleRequest($request);
  269.         
  270.         if ($form->isSubmitted() && $form->isValid()) {
  271.             
  272.             $category = $form['category']->getData(); 
  273.             $user = $form['user']->getData();
  274.             $isfinished = $form['finished']->getData();
  275.             $showdeleted = $form['showdeleted']->getData();
  276.             $startdate = $form['startdate']->getData();
  277.             $enddate = $form['enddate']->getData();
  278.             $createstartdate = $form['createstartdate']->getData();
  279.             $createenddate = $form['createenddate']->getData();            
  280.             
  281.             $query = $actionRepository->createQueryBuilder('a');
  283.             if (!$category->isEmpty()) {
  284.                 $query->andWhere('a.category IN (:category)')
  285.                       ->setParameter('category', $category);
  286.             }            
  287.             
  288.             if ($user) {
  289.                 $query->andWhere('a.actionholder = :user')->setParameter('user', $user);
  290.             }
  291.             
  292.             if ($startdate) {
  293.                 $query->andWhere('a.duedate >= :startdate')->setParameter('startdate', $startdate);
  294.             }
  295.             
  296.             if ($enddate) {
  297.                 $query->andWhere('a.duedate <= :enddate')->setParameter('enddate', $enddate);
  298.             }
  300.             if ($createstartdate) {
  301.                 $query->andWhere('a.createdate >= :createstartdate')->setParameter('createstartdate', $createstartdate);
  302.             }
  303.             
  304.             if ($createenddate) {
  305.                 $query->andWhere('a.createdate <= :createenddate')->setParameter('createenddate', $createenddate);
  306.             }
  307.             
  308.             $today = new \DateTime();
  309.             
  310.             if ($isfinished == 1) {
  311.                 $query->andWhere('a.isfinished = false');
  312.             } elseif ($isfinished == 2) {
  313.                 $query->andWhere('a.isfinished = false');
  314.                 $query->andWhere('a.duedate < :today')->setParameter('today', $today);
  315.             } elseif ($isfinished == 3) {
  316.                 $query->andWhere('a.isfinished = true');
  317.             }
  318.             
  319.             if ($showdeleted == 2) {
  320.                 $query->andWhere('a.status = 1');
  321.             } elseif ($showdeleted == 1) {
  322.                 $query->andWhere('a.status = 0');
  323.             }
  324.             
  325.             
  326.             // limit the result to ensure speed
  327.             $query->setMaxResults(250);
  328.             
  329.             $result = $query->getQuery()->execute();
  332.             return $this->render('action/indexfiltered.html.twig', [
  333.                 'filteredview' => true,
  334.                 'actions' => $result,
  335.                 'form' => $form->createView(),
  336.             ]);
  337.         
  338.         }
  340.         return $this->render('action/indexfiltered.html.twig', [
  341.             'filteredview' => false,
  342.             'form' => $form->createView(),
  343.         ]);
  344.     }
  346.     /**
  347.      * @Route("/new", name="action_new", methods={"GET","POST"})
  348.      */
  349.     public function new(Request $request, OrderRepository $orderRepository, ActionReminder $actionReminder, ActionService $actionService): Response
  350.     {
  351.         $action = new Action();
  352.         
  353.         # get max upload size to be indicated to the user
  354.         $maxfilesize = ini_get("upload_max_filesize");
  355.         
  356.         $form = $this->createForm(ActionType::class, $action);
  357.         $form = $form->add('reminder', EntityType::class, [
  358.                 'label_attr' => array('class' => ''),
  359.                 'attr' => array('class' => 'form-control'),
  360.                 'required' => false,
  361.                 'query_builder' => function (EntityRepository $er) {
  362.                     return $er->createQueryBuilder('u')
  363.                         ->where('u.status = 1')
  364.                         ->andWhere('u.microsoft IS NOT NULL');
  365.                     },
  366.                 'class' => User::class,
  367.                 'placeholder' => 'Kies een agenda',
  368.                 'label' => 'Agenda reminder op streefdatum toevoegen (optioneel)',
  369.                 'mapped' => false,
  370.                 ]);
  371.         $form = $form->add('orderid', SearchType::class, [
  372.                 'label_attr' => array('class' => ''),
  373.                 'attr' => array('class' => 'form-control','autocomplete'=>'off'),
  374.                 'required' => true,
  375.                 'label' => 'Gerelateerde order *',
  376.                 'mapped' => false,
  377.                 ]);
  378.         $form = $form->add('uploads', FileType::class, [
  379.                     'attr' => array('class' => 'custom-file'),
  380.                     'label' => 'Bestanden uploaden (max ' . $maxfilesize . 'B)',
  381.                     'mapped' => false,
  382.                     'multiple' => true,
  383.                     'required' => false,
  384.                 ]);
  385.         
  386.         $form->handleRequest($request);
  388.         if ($form->isSubmitted() && $form->isValid()) {
  389.             
  390.             $selectedid = $request->request->get('selectedid');
  391.             $order = $orderRepository->find($selectedid);
  392.             
  393.             $action = $actionService->saveAction($form,$order);
  395.             return $this->redirectToRoute('action_show',array('id'=>$action->getId()));
  396.         }
  398.         return $this->render('action/new.html.twig', [
  399.             'action' => $action,
  400.             'form' => $form->createView(),
  401.         ]);
  402.     }
  403.     
  404.     
  405.     /**
  406.      * @Route("/triggered/{id}", name="action_new_triggered", methods={"GET","POST"})
  407.      */
  408.     public function newtriggered(Request $request, AppointmentsRepository $appointmentsRepository, ActionRepository $actionRepository, $id=null, ActionService $actionService): Response
  409.     {
  410.         $previousaction = $actionRepository->findOneBy(['id' => $id ]);
  411.         $previousactioncategory = $previousaction->getCategory();
  412.         
  413.         # get the entity manager $em
  414.         $em = $this->getDoctrine()->getManager();
  415.         
  416.         # get repository for all actioncategories
  417.         $repoActioncategory = $em->getRepository(Actioncategory::class);
  418.         
  419.         $triggercategory = $repoActioncategory->findOneBy([
  420.             'id' => $previousactioncategory->getTriggercategory(),
  421.         ]);
  422.         
  423.         $order = $previousaction->getOrderid();
  424.         
  425.         # get upcoming appointments for this action to show upcoming appointments for the user
  426.         $today = new \DateTime("today midnight");
  427.         
  428.         # build query and execute, get list with appointment
  429.         $queryAppointments= $appointmentsRepository->createQueryBuilder('a')
  430.             ->where('a.status = 1')
  431.             ->andWhere('a.startdate >= :now')
  432.             ->andWhere('a.orderid = ' . $order->getId())
  433.             ->setParameter('now',$today->format('Y-m-d'))
  434.             ->orderBy('a.startdate','ASC');
  435.         $appointments = $queryAppointments->getQuery()->execute();
  436.             
  437.         
  438.         $action = new Action();
  440.         if ($triggercategory) {
  441.             $action->setActionholder($triggercategory->getDefaultuser());
  442.             $action->setCategory($triggercategory);
  443.             $action->setTitle($triggercategory->getName());
  444.             
  445.             # get due date and more    
  446.             $returnarray =  $actionService->getDuedate($triggercategory, $order);    
  447.             $duedate = $returnarray['duedate'];    
  448.             $determinedby = $returnarray['determinedby'];    
  449.             $appointmentscategory = $returnarray['appointmentscategory'];    
  450.             
  451.             if ($determinedby == 'appointment') {
  452.                 $appointmentscategorybool = true;
  453.             } else {
  454.                 $appointmentscategorybool = false;
  455.             }
  456.             
  457.             # check if it is duplicate action
  458.             $duplicate = $actionService->checkDuplicate($triggercategory, $order);    
  459.         
  460.             
  461.             $action->setDuedate(new \DateTime($duedate));
  462.         } else {
  463.             
  464.             # set bools to false 
  465.             $appointmentscategorybool = false;
  466.             $duplicate = false;
  467.         }
  468.         
  469.         # get max upload size to be indicated to the user
  470.         $maxfilesize = ini_get("upload_max_filesize");
  471.         
  472.         $form = $this->createFormBuilder($action)
  473.             ->add('title', TextType::class, array(
  474.                 'attr' => array('class' => 'form-control'),
  475.                 'label' => 'Titel *',
  476.                 'required' => true,
  477.                 ))
  478.             ->add('category', EntityType::class, [
  479.                 'label_attr' => array('class' => ''),
  480.                 'attr' => array('class' => 'form-control'),
  481.                 'required' => true,
  482.                 'query_builder' => function (EntityRepository $er) {
  483.                     return $er->createQueryBuilder('u')
  484.                         ->where('u.status = 1')
  485.                         ->orderBy('u.priority', 'DESC');
  486.                     },
  487.                 'class' => Actioncategory::class,
  488.                 'choice_label' => 'name',
  489.                 'placeholder' => 'Kies een actiecategorie',
  490.                 'label' => 'Actiecategorie *',
  491.                 ])
  492.             ->add('description', TextareaType::class, array(
  493.                 'attr' => array('class' => 'form-control'),
  494.                 'label' => 'Opmerkingen',
  495.                 'required' => false,
  496.                 ))
  497.             ->add('duedate', DateType::class, array(
  498.                 'widget'=> 'single_text', 
  499.                 'attr' => array('class' => 'form-control'),
  500.                 'input' => 'datetime',
  501.                 'label' => 'Streefdatum *',
  502.                 'required' => true,
  503.                 ))
  504.             ->add('actionholder', EntityType::class, [
  505.                     'label_attr' => array('class' => ''),
  506.                     'attr' => array('class' => 'form-control'),
  507.                     'required' => true,
  508.                     'query_builder' => function (EntityRepository $er) {
  509.                         return $er->createQueryBuilder('u')
  510.                             ->where('u.status = 1');
  511.                         },
  512.                     'class' => User::class,
  513.                     'choice_label' => 'username',
  514.                     'placeholder' => 'Selecteer actiehouder',
  515.                     'label' => 'Actie bij *',
  516.                 ])
  517.             ->add('uploads', FileType::class, [
  518.                 'attr' => array('class' => 'custom-file'),
  519.                 'label' => 'Bestanden uploaden (max ' . $maxfilesize . 'B)',
  520.                 'mapped' => false,
  521.                 'multiple' => true,
  522.                 'required' => false,
  523.             ])
  524.             ->add('reminder', EntityType::class, [
  525.                 'label_attr' => array('class' => ''),
  526.                 'attr' => array('class' => 'form-control'),
  527.                 'required' => false,
  528.                 'query_builder' => function (EntityRepository $er) {
  529.                     return $er->createQueryBuilder('u')
  530.                         ->where('u.status = 1')
  531.                         ->andWhere('u.microsoft IS NOT NULL');
  532.                     },
  533.                 'class' => User::class,
  534.                 'placeholder' => 'Kies een agenda',
  535.                 'label' => 'Agenda reminder op streefdatum toevoegen (optioneel)',
  536.                 'mapped' => false,
  537.             ])
  538.             ->getForm();
  539.         $form->handleRequest($request);
  541.         if ($form->isSubmitted() && $form->isValid()) {
  542.             
  543.             $action = $actionService->saveAction($form,$order);
  545.             return $this->redirectToRoute('action_show',array('id'=>$action->getId()));
  546.         }
  548.         return $this->render('order/subpages/triggered.html.twig', [
  549.             'appointmentscategorybool' => $appointmentscategorybool,
  550.             'duplicate' => $duplicate,
  551.             'order' => $order,
  552.             'form' => $form->createView(),
  553.             'appointments' => $appointments,
  554.             'action' => $previousaction,
  555.         ]);
  556.     }
  558.     /**
  559.      * @Route("/{id}", name="action_show", methods={"GET","POST"})
  560.      */
  561.     public function show(Action $action, Request $request, FileUploader $fileUploader, ActionReminder $actionReminder, AppointmentsRepository $appointmentsRepository): Response
  562.     {
  563.         $order = $action->getOrderid();
  564.         
  565.         $relatedappointment = $action->getAppointment();
  566.         
  567.         if ($relatedappointment) {
  568.             $appointmenthost = $relatedappointment->getHost();
  569.         } else {
  570.             $appointmenthost = null;
  571.         }
  573.         # get max upload size to be indicated to the user
  574.         $maxfilesize = ini_get("upload_max_filesize");
  575.         
  576.         # get upcoming appointments for this action
  577.         $today = new \DateTime("today midnight");
  578.         
  579.         # build query and execute, get list with appointment
  580.         $queryAppointments= $appointmentsRepository->createQueryBuilder('a')
  581.             ->where('a.status = 1')
  582.             ->andWhere('a.startdate >= :now')
  583.             ->andWhere('a.orderid = ' . $order->getId())
  584.             ->setParameter('now',$today->format('Y-m-d'))
  585.             ->orderBy('a.startdate','ASC');
  586.         $appointments = $queryAppointments->getQuery()->execute();
  587.         
  588.         $form = $this->createFormBuilder()
  589.             ->add('title', TextType::class, array(
  590.                 'attr' => array('class' => 'form-control'),
  591.                 'label' => 'Titel *',
  592.                 'data' => $action->getTitle(),
  593.                 'required' => true,
  594.                 ))        
  595.             ->add('description', TextareaType::class, array(
  596.                 'attr' => array('class' => 'form-control'),
  597.                 'data' => '',
  598.                 'label' => 'Beschrijving',
  599.                 'required' => false,
  600.                 ))
  601.             ->add('duedate', DateType::class, array(
  602.                 'widget'=> 'single_text', 
  603.                 'label' => 'Streefdatum',
  604.                 'attr' => array('class' => 'form-control'),
  605.                 'data' => $action->getDuedate(),
  606.                 'required' => true,
  607.                 ))
  608.             ->add('actionholder', EntityType::class, [
  609.                 'label_attr' => array('class' => ''),
  610.                 'attr' => array('class' => 'form-control'),
  611.                 'required' => true,
  612.                 'query_builder' => function (EntityRepository $er) {
  613.                     return $er->createQueryBuilder('u')
  614.                         ->where('u.status = 1');
  615.                     },
  616.                 'class' => User::class,
  617.                 'data' => $action->getActionholder(),
  618.                 'choice_label' => 'username',
  619.                 'placeholder' => 'Kies een actiehouder',
  620.                 'label' => 'Actie bij *',
  621.                 ])    
  622.             ->add('orderstatus', EntityType::class, [
  623.                 'label_attr' => array('class' => ''),
  624.                 'attr' => array('class' => 'form-control'),
  625.                 'required' => true,
  626.                 'query_builder' => function (EntityRepository $er) {
  627.                     return $er->createQueryBuilder('u')
  628.                         ->where('u.status = 1');
  629.                     },
  630.                 'class' => Orderstatus::class,
  631.                 'choice_label' => 'name',
  632.                 'placeholder' => 'Kies een orderstatus',
  633.                 'label' => 'Status van de order aanpassen',
  634.                 'data' => $order->getOrderstatus(),
  635.                 ])                
  636.             ->add('isfinished', CheckboxType::class, [
  637.                 'required' => false,
  638.                 'label_attr' => array('class' => 'mr-3'),
  639.                 'attr' => array('class' => 'mt-3'),
  640.                 'data' => $action->getIsfinished(),
  641.                 'label' => 'Actie afgerond',
  642.                 ])
  643.             ->add('reminder', EntityType::class, [
  644.                 'label_attr' => array('class' => ''),
  645.                 'attr' => array('class' => 'form-control'),
  646.                 'required' => false,
  647.                 'query_builder' => function (EntityRepository $er) {
  648.                     return $er->createQueryBuilder('u')
  649.                         ->where('u.status = 1')
  650.                         ->andWhere('u.microsoft IS NOT NULL');
  651.                     },
  652.                 'class' => User::class,
  653.                 'placeholder' => 'Kies een agenda',
  654.                 'data' => $appointmenthost,
  655.                 'label' => 'Agenda reminder op streefdatum toevoegen (optioneel)',
  656.                 'mapped' => false,
  657.                 ])                            
  658.             ->add('uploads', FileType::class, [
  659.                     'attr' => array('class' => 'custom-file'),
  660.                     'label' => 'Bestanden uploaden (max ' . $maxfilesize . 'B)',
  661.                     'mapped' => false,
  662.                     'multiple' => true,
  663.                     'required' => false,
  664.                 ])
  665.             ->getForm();
  666.         $form->handleRequest($request);
  667.         
  668.         if ($form->isSubmitted() && $form->isValid()) {
  669.             
  670.             $action->setDescription(nl2br($form['description']->getData()));
  671.             $action->setDuedate($form['duedate']->getData()->setTime(23, 59));
  672.             $action->setActionholder($form['actionholder']->getData());
  673.             $action->setTitle($form['title']->getData());
  674.             
  675.             $agenda = $form['reminder']->getData();
  676.                 
  677.             if ($agenda) {
  678.                 $appointment = $actionReminder->add($action, $agenda);
  679.                 $action->setAppointment($appointment);
  680.             } else {
  681.                 $action->setAppointment(null);
  682.                 # Eigenlijk moet de afspraak ook weggegooid worden.. To be done one day!
  683.             }
  684.             
  685.             $actionlog = new Actionlog();
  686.                         
  687.             if ($form['isfinished']->getData()) {
  688.                 $action->setCompletedate(new \DateTime());
  689.                 $action->setIsfinished(true);
  690.                 $actionlog->setCompletedate(new \DateTime());
  691.                 $actionlog->setIsfinished(true);
  692.             }
  693.             else {
  694.                 $action->setCompletedate(null);
  695.                 $actionlog->setCompletedate(null);
  696.                 $action->setIsfinished(false);
  697.                 $actionlog->setIsfinished(false);
  698.             }
  699.             
  700.             $entityManager = $this->getDoctrine()->getManager();
  701.             $entityManager->persist($action);
  702.             $entityManager->flush();
  703.             
  704.             $uploads = $form['uploads']->getData();
  705.         
  706.             if ($uploads) {
  707.                 
  708.                 foreach ($uploads as $upload) {
  709.                 
  710.                     $uploadFileName = $fileUploader->upload($upload);
  711.                     $uploads_array[]= $uploadFileName;
  712.                 }
  713.                 
  714.                 # setUpload is not used anymore since multi upload is required
  715.                 $actionlog->setUploads($uploads_array);
  716.             }
  717.             
  718.             $actionlog->setActionid($action);
  719.             $actionlog->setTitle($form['title']->getData());
  720.             $actionlog->setDescription(nl2br($form['description']->getData()));
  721.             $actionlog->setActionholder($form['actionholder']->getData());
  722.             $actionlog->setDuedate($form['duedate']->getData());
  723.             $actionlog->setCreatedbyuser($this->getUser());
  724.             $actionlog->setCreatedate(new \DateTime());
  725.             $actionlog->setStatus(1);
  726.             
  727.             $entityManager = $this->getDoctrine()->getManager();
  728.             $entityManager->persist($actionlog);
  729.             $entityManager->flush();
  730.             
  731.             $order->setOrderstatus($form['orderstatus']->getData());
  732.             $entityManager->persist($order);
  733.             $entityManager->flush();
  734.             
  735.             if ($action->getIsfinished()){
  736.                 return $this->redirectToRoute('action_new_triggered',array('id'=>$action->getId()));
  737.             }
  738.             else {
  739.                 return $this->redirectToRoute('action_show',array('id'=>$action->getId()));
  740.             }
  741.         } else if ($form->isSubmitted()) {
  742.             
  743.             // form submit not valid, most likely to do with upload size!
  744.             echo '<script>alert("Kan niet opslaan. Controleer of de bestanden die je upload niet te groot zijn")</script>';
  745.             
  746.             return $this->render('action/showinorder.html.twig', [
  747.                 'appointments' => $appointments,
  748.                 'action' => $action,
  749.                 'order' => $order,
  750.                 'form' => $form->createView(),
  751.             ]);
  752.         }
  753.         
  754.         return $this->render('action/showinorder.html.twig', [
  755.             'appointments' => $appointments,
  756.             'action' => $action,
  757.             'order' => $order,
  758.             'form' => $form->createView(),
  759.         ]);
  760.     }
  761.     
  762.     /**
  763.      * @Route("/{id}/edit", name="action_edit", methods={"GET","POST"})
  764.      */
  765.     public function edit(Request $request, Action $action): Response
  766.     {
  767.         $form = $this->createForm(ActionType::class, $action);
  768.         $form->handleRequest($request);
  770.         if ($form->isSubmitted() && $form->isValid()) {
  771.             $this->getDoctrine()->getManager()->flush();
  773.             return $this->redirectToRoute('action_show',array('id'=>$action->getId()));
  774.         }
  776.         return $this->render('action/edit.html.twig', [
  777.             'action' => $action,
  778.             'form' => $form->createView(),
  779.         ]);
  780.     }
  782.     /**
  783.      * @Route("/{id}", name="action_delete", methods={"DELETE"})
  784.      */
  785.     public function delete(Request $request, Action $action): Response
  786.     {
  787.         $orderid = $action->getOrderid()->getId();
  788.         
  789.         if ($this->isCsrfTokenValid('delete'.$action->getId(), $request->request->get('_token'))) {
  790.             $entityManager = $this->getDoctrine()->getManager();
  791.             #$action->setCompletedate(new \DateTime());
  792.             #$action->setIsfinished(true);        
  793.             $action->setStatus(0);
  794.             $entityManager->flush();
  795.         }
  797.         return $this->redirectToRoute('order_show_acties',['id' => $orderid] );
  798.     }
  800. }