src/Trinity/FormsBundle/Controller/FormsController.php line 726

Open in your IDE?
  1. <?php
  2. namespace App\Trinity\FormsBundle\Controller;
  4. use App\CmsBundle\Classes\Hummessenger as MailerTool;
  5. use App\CmsBundle\Controller\StorageController;
  6. use App\CmsBundle\Entity\Media;
  7. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  10. use Symfony\Component\HttpFoundation\Request;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\HttpFoundation\JsonResponse;
  13. use Symfony\Component\HttpFoundation\RedirectResponse;
  14. use Symfony\Component\HttpFoundation\File\UploadedFile;
  16. use Symfony\Component\Form\Extension\Core\Type\TextType;
  17. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  18. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  20. class FormsController extends StorageController
  21. {
  23.     /**
  24.      * @Route("/admin/forms/answers/filter/{formid}/{page}", name="admin_mod_forms_answers_filter", requirements={"formid": "\d+", "page": "\d+"})
  25.      * @Template()
  26.      */
  27.     public function filterAction(Request $request, $formid, $page = 1)
  28.     {
  29.         parent::init($request);
  33.         $filter = $request->get('filter');
  34.         if(!empty($filter['q'])){
  35.             $filter['q'] = explode(' ', $filter['q']);
  36.         }
  37.         $offset = 0;
  38.         $limit  = (int)(!empty($_GET['pp']) ? $_GET['pp'] : 20);
  40.         $count = $this->getDoctrine()->getRepository('TrinityFormsBundle:Answer')->filter($formid, true, $offset, $limit, $filter);
  42.         $pages = ceil($count / $limit);
  43.         if($pages == 0) $pages = 1;
  44.         if($page > $pages){ $page = $pages; }
  45.         if($pages < 1){ $pages = 1; }
  46.         $offset = (($page * $limit) - $limit);
  48.         $results = [];
  49.         $dql_results = $this->getDoctrine()->getRepository('TrinityFormsBundle:Answer')->filter($formid, false, $offset, $limit, $filter);
  51.         foreach($dql_results as $Entry){
  54.             $a = [
  55.                 'name' => [],
  56.                 'email' => '',
  57.                 'phone' => '',
  58.                 'nieuwsbrief' => '',
  59.             ];
  61.             if(!is_array($Entry->getAnswer())){
  62.                 $ans = json_decode($Entry->getAnswer(), true);
  63.                 foreach($ans as $k => $v){
  64.                     $k = strtolower($k);
  65.                     // echo '<pre>' . print_r($k, 1) . '</pre>';
  66.                     if(preg_match('/naam/', $k)){
  67.                         $a['name'][] = $v;
  68.                     }
  69.                     if(preg_match('/mail/', $k)){
  70.                         $a['email'] = $v;
  71.                     }
  72.                     if(preg_match('/nieuwsbrief/', $k)){
  73.                         $a['nieuwsbrief'] = '<i class="material-icons">check_circle</i>';
  74.                     }
  75.                     if(preg_match('/foon/', $k)){
  76.                         $a['phone'] = $v;
  77.                     }
  78.                 }
  80.                 $a['name'] = implode(' ', $a['name']);
  82.                 // $answers[$i]->setAnswer($a);
  83.             }
  87.             $results[] = [
  88.                 'id'      => $Entry->getId(),
  89.                 'ip'      => (!empty($Entry->getIp()) ? $Entry->getIp() : '----'),
  90.                 'date' => (!empty($Entry->getSession()) ? $Entry->getSession()->getDateEnd()->format('d-m-Y H:i:s') : ''),
  91.                 'name' => $a['name'],
  92.                 'email' => $a['email'],
  93.                 'phone' => $a['phone'],
  94.                 'nieuwsbrief' => $a['nieuwsbrief'],
  95.             ];
  96.         }
  98.         return new JsonResponse([
  99.             'count'   => (int)$count,
  100.             'page'    => $page,
  101.             'pages'   => $pages,
  102.             'offset'  => $offset,
  103.             'limit'   => $limit,
  104.             'results' => $results,
  105.         ]);
  106.     }
  108.     /**
  109.      * @Route("/admin/forms", name="admin_mod_forms")
  110.      * @Template()
  111.      */
  112.     public function indexAction( Request $request, $id = null)
  113.     {
  115.         parent::init($request);
  117.         $this->breadcrumbs->addRouteItem($this->trans("Formulieren", 'cms'), "admin_mod_forms");
  119.         $forms = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->findBy([
  120.             'language' => $this->language,
  121.             'settings' => $this->Settings
  122.         ]);
  124.         $forms_used = [];
  125.         $blocks = $this->getDoctrine()->getRepository('CmsBundle:PageBlock')->findByData('TrinityFormsBundle');
  127.         foreach($blocks as $Block){
  128.             $p = $Block->getWrapper()->getPage();
  129.             if($p->getLanguage() == $this->language){
  130.                 $data = $Block->getBundleData(true);
  131.                 if (isset($data['id'])) {
  132.                     $forms_used[] = $data['id'];
  133.                 }
  134.             }
  135.         }
  137.         return $this->attributes(array(
  138.             'forms_used' => $forms_used,
  139.             'forms' => $forms
  140.         ));
  141.     }
  143.     /**
  144.      * @Route("/admin/forms/answers/delete/{id}", name="admin_mod_forms_answers_delete")
  145.      */
  146.     public function deleteAmswerAction( Request $request, $id = null)
  147.     {
  148.         parent::init($request);
  150.         $Answer = $this->getDoctrine()->getRepository('TrinityFormsBundle:Answer')->find($id);
  151.         $form_id = $Answer->getForm()->getId();
  153.         $em = $this->getDoctrine()->getManager();
  154.         $em->remove($Answer);
  155.         $em->flush();
  157.         return $this->redirectToRoute('admin_mod_forms_answers', ['id' => $form_id]);
  158.     }
  160.     /**
  161.      * @Route("/admin/forms/answers/{id}/export", name="admin_mod_forms_answers_export")
  162.      * @Template()
  163.      */
  164.     public function export( Request $request, $id = null)
  165.     {
  166.         parent::init($request);
  167.         
  168.         header('Content-Type: text/csv; charset=utf-8');
  169.         header('Content-Disposition: attachment; filename=form_answers.csv');
  170.         $output = fopen('php://output', 'w');
  172.         $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->find($id);
  174.         fputcsv($output, ['Veld',  'Invoer']);
  175.         fputcsv($output, ['']);
  177.         $answers = $Form->getAnswers();
  178.         foreach($answers as $i => $answer){
  180.             if(!is_array($answer->getAnswer())){
  181.                 $ans = json_decode($answer->getAnswer(), true);
  182.                 $keys = [];
  183.                 $values = [];
  184.                 foreach($ans as $k => $v){
  185.                     if(is_array($v)){
  186.                         $v = implode(', ', $v);
  187.                     }
  189.                     fputcsv($output, [$k,  $v]);
  190.                 }
  192.                 fputcsv($output, ['']);
  194.                 /* if(empty($csv[0])){
  195.                     $csv[0] = $keys;
  196.                 } */
  197.             }
  198.         }
  200.         exit;
  201.     }
  203.     /**
  204.      * @Route("/admin/forms/answers/{id}/{answerid}", name="admin_mod_forms_answers")
  205.      * @Template()
  206.      */
  207.     public function answersAction( Request $request, $id = null, $answerid = null)
  208.     {
  209.         parent::init($request);
  211.         $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->find($id);
  213.         $this->breadcrumbs->addRouteItem($this->trans("Formulieren", 'cms'), "admin_mod_forms");
  214.         $this->breadcrumbs->addRouteItem($Form->getLabel(), "admin_mod_forms");
  215.         $this->breadcrumbs->addRouteItem($this->trans("Reacties", 'cms'), "admin_mod_forms_answers", array('id' => $id, 'answerid' => null));
  217.         $Answer = null;
  218.         if(!is_null($answerid)){
  219.             $Answer = $this->getDoctrine()->getRepository('TrinityFormsBundle:Answer')->find($answerid);
  220.             $this->breadcrumbs->addRouteItem($this->trans("Reactie", 'cms'), "admin_mod_forms_answers", array('id' => $id, 'answerid' => $answerid));
  221.             $Answer->setAnswer(json_decode($Answer->getAnswer(), true));
  223.             if($request->isXmlHttpRequest()) {
  224.                 return $this->render('@TrinityForms/form/answers_ajax.html.twig', ['Answer' => $Answer]);
  225.             }
  226.         }
  228.         $answers = $Form->getAnswers();
  229.         foreach($answers as $i => $answer){
  230.             $a = [
  231.                 'name' => [],
  232.                 'email' => '',
  233.                 'phone' => '',
  234.             ];
  236.             if(!is_array($answer->getAnswer())){
  237.                 $ans = json_decode($answer->getAnswer(), true);
  238.                 foreach($ans as $k => $v){
  239.                     $k = strtolower($k);
  240.                     // echo '<pre>' . print_r($k, 1) . '</pre>';
  241.                     if(preg_match('/naam/', $k)){
  242.                         $a['name'][] = $v;
  243.                     }
  244.                     if(preg_match('/mail/', $k)){
  245.                         $a['email'] = $v;
  246.                     }
  247.                     if(preg_match('/foon/', $k)){
  248.                         $a['phone'] = $v;
  249.                     }
  250.                 }
  252.                 $a['name'] = implode(' ', $a['name']);
  254.                 $answers[$i]->setAnswer($a);
  255.             }
  256.         }
  258.         $hasNewsletter = false;
  259.         if(in_array('NewsletterBundle', $this->installed)){
  260.             $hasNewsletter = true;
  261.         }
  263.         return $this->attributes(array(
  264.             'Form' => $Form,
  265.             'Answer' => $Answer,
  266.             'hasNewsletter' => $hasNewsletter,
  267.             'answers' => $answers
  268.         ));
  269.     }
  271.     /**
  272.      * @Route("/admin/forms/edit/addelement/{id}/{type}", name="admin_mod_forms_addrow")
  273.      */
  274.     public function addelementAction(Request $request, $id = null, $type = null){
  275.         parent::init($request);
  277.         $tpl = '';
  278.         $tplDir = $this->containerInterface->get('kernel')->locateResource('@TrinityFormsBundle/Resources/views/elements/');
  280.         // Check for newsletter presence
  281.         $emaillists = null;
  282.         if(in_array('NewsletterBundle', $this->installed)){
  283.             $emaillists = $this->getDoctrine()->getRepository('TrinityFormsBundle:Emaillist')->findAll();
  284.         }
  286.         if(file_exists($tplDir . $type . '.html.twig')){
  287.             $Question = new \App\Trinity\FormsBundle\Entity\Question();
  288.             $Question->setType($type);
  290.             /*if($Question->getTitle() == 'Titel'){
  291.                 $Question->setTitle($this->trans('Title', 'cms'));
  292.             }*/
  294.             /*if($Question->getSubTitle() == 'Toelichting'){
  295.                 $Question->setSubTitle($this->trans('Explanation', 'cms'));
  296.             }*/
  298.             // Default values
  299.             if($type == 'newsletter'){
  300.                 $Question->setTitle($this->trans('Ik wil me aanmelden voor de nieuwsbrief', 'cms'));
  301.             }
  304.             $random = time();
  306.             // Get Form
  307.             $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->findOneById($id);
  309.             return $this->render('@TrinityForms/elements/' . $type . '.html.twig', array('edit' => true, 'emaillists' => $emaillists, 'Form' => $Form, 'Question' => $Question, 'random' => $random));
  310.         }
  311.         return $this->render('@TrinityForms/elements/invalid.html.twig', array('edit' => true, 'emaillists' => $emaillists));
  312.     }
  314.     /**
  315.      * @Route("/admin/forms/edit/{id}", name="admin_mod_forms_edit")
  316.      * @Template()
  317.      */
  318.     public function editAction( Request $request, $id = null)
  319.     {
  321.         parent::init($request);
  323.         $hasNewsletter = false;
  324.         if(in_array('NewsletterBundle', $this->installed)){
  325.             $hasNewsletter = true;
  326.         }
  328.         $this->breadcrumbs->addRouteItem($this->trans("Formulieren", 'cms'), "admin_mod_forms");
  330.         $new = false;
  331.         if( (int)$id > 0 ){
  332.             // Edit
  333.             $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->find($id);
  336.             if($this->language != $Form->getLanguage() || $this->Settings != $Form->getSettings()){
  337.                 return $this->redirect($this->generateUrl('admin_mod_forms'));
  338.             }
  340.             $this->breadcrumbs->addRouteItem($this->trans("Wijzigen:", 'cms'). " " . $Form->getLabel(), "admin_mod_forms_edit");
  342.         }else{
  343.             $new = true;
  344.             // Add
  345.             $Form = new \App\Trinity\FormsBundle\Entity\Form();
  346.             $Form->setLanguage($this->language);
  347.             $Form->setSettings($this->Settings);
  348.             $this->breadcrumbs->addRouteItem($this->trans("Toevoegen", 'cms'), "admin_mod_forms_edit");
  349.         }
  350.         $saved = false;
  351.         if($this->get('security.authorization_checker')->isGranted('ROLE_SUPER_ADMIN')) {
  352.             $editform = $this->createFormBuilder($Form)
  353.                 ->add('label', TextType::class, array('label' => $this->trans('Formulier titel', [], 'cms')))
  354.                 ->add('hide_clear_button', CheckBoxType::class, ['label' => $this->trans('Verberg de leegmaken knop', 'cms'), 'required' => false, 'row_attr' => ['class' => 'page-chk']])
  355.                 ->add('mail_reply_to', CheckboxType::class, array('label' => $this->trans('E-mail als reply-to adres', 'cms'), 'row_attr' => ['class' => 'page-chk']))
  356.                 ->add('floating_labels', CheckboxType::class, array('label' => 'Floating labels', 'required' => false))
  357.                 ->add('active_campaign', CheckboxType::class, array('label' => 'ActiveCampaign', 'required' => false, 'row_attr' => ['class' => 'page-chk']))
  358.                 ->add('active_campaign_url', TextType::class, array('label' => 'ActiveCampaign Url', 'required' => false))
  359.                 ->add('active_campaign_key', TextType::class, array('label' => 'ActiveCampaign Key', 'required' => false))
  360.                 ->add('active_campaign_listid', TextType::class, array('label' => 'ActiveCampaign List ID', 'required' => false))
  361.                 ->add('active_lef_api', CheckboxType::class, array('label' => 'LEF api', 'required' => false))
  362.                 ->setMethod('post')
  363.                 ->getForm();
  364.             if($Form->getSettings()->isHummessengerApiEnabled()){
  365.             $editform->add('mailer_listid', TextType::class, array('label' => 'Hummessenger List ID', 'required' => false));
  366.             }
  367.         } else {
  368.             $editform = $this->createFormBuilder($Form)
  369.                 ->add('label', TextType::class, array('label' => $this->trans('Formulier titel', [], 'cms')))
  370.                 ->add('hide_clear_button', CheckBoxType::class, ['label' => $this->trans('Verberg de leegmaken knop', 'cms'), 'required' => false, 'row_attr' => ['class' => 'page-chk']])
  371.                 ->add('mail_reply_to', CheckboxType::class, array('label' => $this->trans('E-mail als reply-to adres', 'cms'), 'row_attr' => ['class' => 'page-chk']))
  372.                 ->setMethod('post')
  373.                 ->getForm();
  374.         }
  376.         $em = $this->getDoctrine()->getManager();
  378.         $editform->handleRequest($request);
  379.         if ($editform->isSubmitted() && $editform->isValid()) {
  381.             if(!isset($_POST['id'])){
  382.                 // No fields found, clean up
  383.                 $rm_questions = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findByForm($Form);
  384.                 foreach($rm_questions as $RmQuestion){
  385.                     $em->remove($RmQuestion);
  386.                 }
  387.             }
  389.             if(!empty($_POST['id'])){
  390.                 $ids = [];
  391.                 $q = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findByForm($Form);
  392.                 foreach($q as $Q){ $ids[] = $Q->getId(); }
  393.                 foreach(array_diff($ids, $_POST['id']) as $id){
  394.                     $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->find($id);
  395.                     $em->remove($Question);
  396.                 }
  398.                 $positions = [];
  399.                 if(!empty($_POST['pos'])){
  400.                     $positions = array_values($_POST['pos']);
  401.                 }
  403.                 $width = [];
  404.                 if(!empty($_POST['width'])){
  405.                     $width = array_values($_POST['width']);
  406.                 }
  408.                 foreach($_POST['id'] as $i => $id){
  409.                     $pos = (isset($positions[$i]) ? (int)$positions[$i] : 0);
  410.                     $w = (isset($width[$i]) ? (int)$width[$i] : 12);
  412.                     $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->find($id);
  413.                     if(empty($Question)){
  414.                         // New
  415.                         $Question = new \App\Trinity\FormsBundle\Entity\Question();
  416.                         $Question->setForm($Form);
  417.                         $Question->setType($_POST['type'][$i]);
  418.                         $Form->addQuestion($Question);
  419.                     }
  421.                     $Question->setPosition($pos); // Set position
  422.                     $Question->setWidth($w); // Set position
  424.                     if(isset($_POST['values'][$id])){
  425.                         if(is_array($_POST['values'][$id])){
  426.                             foreach($_POST['values'][$id] as $k => $v){
  427.                                 $_POST['values'][$id][$k] = str_replace(',', '&comma;', $v);
  428.                             }
  429.                         }
  431.                         $Question->setValues($_POST['values'][$id]);
  432.                     }
  434.                     if(isset($_POST['disabled'][$id])){
  435.                         $Question->setDisabled($_POST['disabled'][$id]);
  436.                     }else{
  437.                         $Question->setDisabled([]);
  438.                     }
  440.                     if(isset($_POST['config'][$id])){
  441.                         $Question->setConfig($_POST['config'][$id]);
  442.                     }else{
  443.                         $Question->setConfig([]);
  444.                     }
  446.                     if(isset($_POST['default'][$id])){
  447.                         $Question->setDefault($_POST['default'][$id]);
  448.                     }else{
  449.                         $Question->setDefault([]);
  450.                     }
  452.                     if(isset($_POST['email'][$id])){
  453.                         $Question->setEmail($_POST['email'][$id]);
  454.                     }else{
  455.                         $Question->setEmail([]);
  456.                     }
  458.                     if(isset($_POST['heading'][$i])){
  459.                         $Question->setTitle(strip_tags($_POST['heading'][$i]));
  460.                     }else{
  461.                         $Question->setTitle("");
  462.                     }
  463.                     
  464.                     
  465.                     if(!empty($_POST['title'][$i])){
  466.                         $Question->setTitle(strip_tags($_POST['title'][$i]));
  467.                     }else{
  468.                         $Question->setTitle("");
  469.                     }
  471.                     if(!empty($_POST['required'])){
  472.                         $Question->setRequired(in_array($id, $_POST['required']));
  473.                     }else{
  474.                         $Question->setRequired(false);
  475.                     }
  477.                     if(!empty($_POST['hidden'])){
  478.                         $Question->setHidden(in_array($id, $_POST['hidden']));
  479.                     }else{
  480.                         $Question->setHidden(false);
  481.                     }
  483.                     if(!empty($_POST['hidden_label'][$id])){
  484.                         $Question->setHiddenLabel(in_array($id, $_POST['hidden_label']));
  485.                     }else{
  486.                         $Question->setHiddenLabel(false);
  487.                     }
  489.                     if(!empty($_POST['placeholder'][$i])){
  490.                         $Question->setPlaceholder($_POST['placeholder'][$i]);
  491.                     } else if (empty($_POST['placeholder'][$i]) && !empty($Question->getPlaceHolder())) {
  492.                         $Question->setPlaceholder(null);
  493.                     }
  495.                     // Set new sort order
  496.                     $Question->setSort($i);
  498.                     $em->persist($Question);
  499.                 }
  500.             }
  502.             $Form->setMails($_POST['mail']);
  504.             if(!empty($_POST['delete'])){
  505.                 foreach(explode(',', $_POST['delete']) as $id){
  506.                     if(!empty($id)){
  507.                         $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->find($id);
  508.                         $em->remove($Question);
  509.                     }
  510.                 }
  511.             }
  513.             // Store in database
  514.             $em->persist($Form);
  515.             $em->flush();
  517.             // Clone question to more sites
  518.             if(!empty($_POST['clone'])){
  519.                 foreach($_POST['clone'] as $id){
  520.                     $LinkedSettings = $this->getDoctrine()->getRepository('CmsBundle:Settings')->find($id);
  522.                     $NewForm = clone $Form;
  523.                     $NewForm->setSettings($LinkedSettings);
  524.                     $NewForm->setLanguage($LinkedSettings->getLanguage());
  525.                     $em->persist($NewForm);
  527.                     // Clone questions
  528.                     foreach($Form->getQuestions() as $Question){
  529.                         $newQuestion = clone $Question;
  530.                         $newQuestion->setForm($NewForm);
  531.                         $em->persist($newQuestion);
  532.                     }
  533.                 }
  534.                 $em->flush();
  535.             }
  537.             // Store metadata/metatags
  538.             if(!empty($_POST['metadata'])){
  539.                 foreach($_POST['metadata'] as $metatagid => $value){
  540.                     $Metatag = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->findOneById($metatagid);
  542.                     $FormMetatag = $this->getDoctrine()->getRepository('TrinityFormsBundle:Metatag')->findOneBy(['metatag' => $Metatag, 'form' => $Form]);
  543.                     if(empty($FormMetatag)){
  544.                         $FormMetatag = new \App\Trinity\FormsBundle\Entity\Metatag();
  545.                         $FormMetatag->setMetatag($Metatag);
  546.                         $FormMetatag->setForm($Form);
  547.                     }
  548.                     $FormMetatag->setValue($value);
  550.                     $em->persist($FormMetatag);
  551.                 }
  552.             $em->flush();
  553.             }
  555.             $this->resetPageCacheThatContainedBundle('TrinityFormsBundle', $this->Settings);
  557.             if(empty($_POST['inline_save'])){
  558.                 return $this->redirect($this->generateUrl('admin_mod_forms'));
  559.             }else{
  560.                 return $this->redirect($this->generateUrl('admin_mod_forms_edit', ['id' => $Form->getId()]));
  561.             }
  562.         }
  564.         $templates = scandir('../templates/emails');
  565.         foreach($templates as $k => $v){
  566.             if(substr($v, 0, 1) == '.'){
  567.                 unset($templates[$k]);
  568.             }
  569.         }
  571.         $questions = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findBy(array('form'=> $Form), array('sort' => 'ASC'));
  573.         // Check for newsletter presence
  574.         $emaillists = null;
  575.         if(in_array('NewsletterBundle', $this->installed)){
  576.             $emaillists = $this->getDoctrine()->getRepository('TrinityFormsBundle:Emaillist')->findAll();
  577.         }
  579.         $formMetatags = [];
  580.         $ignoreTags    = ['description', 'keywords'];
  581.         $metatags      = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->findBy(['system' => false]);
  582.         foreach($metatags as $index => $Metatag){
  583.             if(!in_array($Metatag->getKey(), $ignoreTags)){
  584.                 $FormMetatag = $this->getDoctrine()->getRepository('TrinityFormsBundle:Metatag')->findOneBy(['metatag' => $Metatag, 'form' => $Form]);
  585.                 if(empty($FormMetatag)){
  586.                     $FormMetatag = new \App\Trinity\FormsBundle\Entity\Metatag();
  587.                     $FormMetatag->setMetatag($Metatag);
  588.                 }
  589.                 $formMetatags[] = $FormMetatag;
  590.             }
  591.         }
  593.         return $this->attributes(array(
  594.             'form'          => $editform->createView(),
  595.             'Form'          => $Form,
  596.             'mails'         => $Form->getMails(),
  597.             'questions'     => $questions,
  598.             'templates'     => $templates,
  599.             'hasNewsletter' => $hasNewsletter,
  600.             'id'            => $id,
  601.             'new'           => $new,
  602.             'Settings'      => $this->Settings,
  603.             'edit'          => true,
  604.             'saved'         => (bool)$saved,
  605.             'emaillists'    => $emaillists,
  606.             'metatags'      => $formMetatags,
  607.         ));
  608.     }
  610.     /**
  611.      * @Route("/admin/forms/config/{id}", name="admin_mod_forms_config")
  612.      * @Template()
  613.      */
  614.     public function configAction( Request $request, $id)
  615.     {
  617.         parent::init($request);
  619.         $this->breadcrumbs->addRouteItem($this->trans("Formulieren", 'cms'), "admin_mod_forms");
  620.         $this->breadcrumbs->addRouteItem($this->trans("Configureren", 'cms'), "admin_mod_forms_config", ['id' => $id]);
  622.         $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->find($id);
  624.         $saved = false;
  625.         $editform = $this->createFormBuilder($Form)
  626.             ->add('label', TextType::class, array('label' => $this->trans('Formulier titel', 'cms')))
  627.             ->add('auto_response', CheckboxType::class, array('label' => $this->trans('Automatisch antwoord', 'cms')))
  628.             ->add('auto_response_subject', TextType::class, array('label' => $this->trans('Onderwerp', 'cms')))
  629.             ->add('auto_response_text', TextareaType::class, array('label' => $this->trans('E-mail inhoud', 'cms')))
  630.             ->setMethod('post')
  631.             ->getForm();
  633.         $em = $this->getDoctrine()->getManager();
  635.         $editform->handleRequest($request);
  636.         if ($editform->isSubmitted() && $editform->isValid()) {
  638.             // Store in database
  639.             $em->persist($Form);
  640.             $em->flush();
  641.             return $this->redirect($this->generateUrl('admin_mod_forms'));
  642.         }
  644.         return $this->attributes(array(
  645.             'form'      => $editform->createView(),
  646.             'Form'      => $Form,
  647.         ));
  648.     }
  650.     /**
  651.      * @Route("/admin/forms/delete/{id}", name="admin_mod_forms_delete")
  652.      * @Template()
  653.      */
  654.     public function deleteAction(Request $request, $id = null)
  655.     {
  657.         parent::init($request);
  659.         $em = $this->getDoctrine()->getManager();
  660.         $Form = $em->getRepository('TrinityFormsBundle:Form')->find($id);
  662.         if(!is_null($Form)){
  663.             $em = $this->getDoctrine()->getManager();
  665.             $sessions = $em->getRepository('TrinityFormsBundle:Session')->findByForm($Form);
  666.             foreach($sessions as $a){
  667.                 $a->setForm(null);
  668.                 $a->setAnswer(null);
  669.                 $em->flush();
  670.             }
  671.             foreach($sessions as $a){
  672.                 $em->remove($a);
  673.                 $em->flush();
  674.             }
  676.             foreach($Form->getAnswers() as $a){
  677.                 $em->remove($a);
  678.                 $em->flush();
  679.             }
  681.             $em->remove($Form);
  682.             $em->flush();
  684.             $this->resetPageCacheThatContainedBundle('TrinityFormsBundle', $this->Settings);
  685.         }
  687.         return $this->redirect($this->generateUrl('admin_mod_forms'));
  688.     }
  690.     /**
  691.      * @Route("/forms/ajax/{id}", name="mod_forms_ajax")
  692.      * @Template()
  693.      */
  694.     public function ajaxShowAction(Request $request,$id = null){
  695.         parent::init($request);
  696.         
  697.         $config['id'] = $id;
  698.         return $this->showAction($config,array('isAjax' => true),$request);
  699.     }
  701.     /**
  702.      * Show bundle content to front
  703.      *
  704.      * @param  array  $config Array with configuration options
  705.      * @param  array  $params Additional parameters
  706.      *
  707.      * @return string         HTML
  708.      */
  709.     public function showAction($config, $params, $request)
  710.     {
  711.         parent::init($request);
  713.         $Form = $this->getDoctrine()->getRepository('TrinityFormsBundle:Form')->findOneById($config['id']);
  714.         if($Form){
  715.             $hash = $this->get('session')->get('formhash');
  716.             if(is_null($hash) || substr($hash, 0, strlen($Form->getId()) + 1) != $Form->getId() . '_'){
  717.                 $hash = $Form->getId() . '_' . md5(rand(1000,9999) . '' . time());
  718.             }
  719.             
  720.             if(in_array('WebshopBundle',$this->installed)){
  721.                 if($this->Settings->getIsCatalog() && !empty($params[0])){
  722.                     $product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($params[0]);
  723.                 }
  724.             }
  726.             $this->get('session')->set('formhash', $hash);
  728.             $saved = false;
  729.             $error = false;
  730.             $inline_error = false;
  732.             $files = array();
  733.             $canvas = [];
  735.             // Add attachement
  736.             $uploadDir = str_replace('/src/Trinity/FormsBundle/Controller' , '/public/uploads/', __DIR__);
  738.             if(!is_writable($uploadDir)){
  739.                 die($this->trans('Upload dir for forms is not writable!', 'cms'));
  740.             }
  742.             $ctx = $this->container->get('router')->getContext();
  743.             $webUrl = $ctx->getScheme() . '://' . $ctx->getHost();
  744.             if(isset($_FILES['form']['tmp_name'][$config['id']]) && is_array($_FILES['form']['tmp_name'][$config['id']])){
  745.                 foreach($_FILES['form']['tmp_name'][$config['id']] as $index => $tmpfile){
  746.                     if(!empty($tmpfile)){
  747.                         $filename = $_FILES['form']['name'][$config['id']][$index];
  748.                         $size = $_FILES['form']['size'][$config['id']][$index];
  750.                         if ($size > 10485760) { // 10 MB
  751.                             $error = $this->trans('Het bestand dat u probeert te uploaden is te groot:', 'cms') . ' <strong>' . $filename . '</strong> (' . round($size/1024/1024, 2) . ' MB)';
  752.                         }else{
  753.                             // Validation
  754.                             $finfo = new \finfo(FILEINFO_MIME_TYPE);
  755.                             if (false === $ext = array_search(
  756.                                 $finfo->file($tmpfile),
  757.                                 [
  758.                                     'doc'     => 'application/doc',
  759.                                     'xls'     => 'application/excel',
  760.                                     'pdf'     => 'application/pdf',
  761.                                     'ppt'     => 'application/powerpoint',
  762.                                     'rtf'     => 'application/rtf',
  763.                                     'keynote' => 'application/vnd.apple.keynote',
  764.                                     'numbers' => 'application/vnd.apple.numbers',
  765.                                     'pages'   => 'application/vnd.apple.pages',
  766.                                     'xlsx'    => 'application/vnd.ms-excel',
  767.                                     'pptx'    => 'application/vnd.ms-powerpoint',
  768.                                     'rar'     => 'application/x-rar-compressed',
  769.                                     'zip'     => 'application/zip',
  770.                                     'ogg'     => 'audio/ogg',
  771.                                     'wav'     => 'audio/wav',
  772.                                     'midi'    => 'audio/x-midi',
  773.                                     'csv'     => 'text/csv',
  774.                                     'avi'     => 'video/avi',
  775.                                     'mp4'     => 'video/mp4',
  776.                                     'mpg'     => 'video/mpeg',
  777.                                     'mpeg'    => 'video/mpeg',
  778.                                     'mov'     => 'video/quicktime',
  779.                                     'bmp'     => 'image/bmp',
  780.                                     'gif'     => 'image/gif',
  781.                                     'jpeg'    => 'image/jpeg',
  782.                                     'jpg'     => 'image/jpeg',
  783.                                     'png'     => 'image/png',
  784.                                     'svg'     => 'image/svg+xml',
  785.                                 ],
  786.                                 true
  787.                             )) {
  788.                                 $error = $this->trans('U heeft geen geldig bestandstype geupload:', 'cms') . ' <strong>' . $filename . '</strong><br/><br/>' . $this->trans('De volgende bestanden zijn toegestaan:', 'cms') . '<br/>.doc, .xls, .pdf, .ppt, .rtf, .keynote, .numbers, .pages, .xlsx, .pptx, .rar, .zip, .ogg, .wav, .midi, .csv, .avi, .mp4, .mpg, .mpeg, .mov, .bmp, .gif, .jpeg, .jpg, .png, .svg.';
  789.                             }
  790.                         }
  792.                         if(!$error){
  793.                             $tmpUploadDir = $uploadDir . '';
  795.                             $tmpUploadDir = $tmpUploadDir . 'forms/';
  796.                             if(!file_exists($tmpUploadDir)) mkdir($tmpUploadDir);
  798.                             $tmpUploadDir = $tmpUploadDir . $config['id'] . '/';
  799.                             if(!file_exists($tmpUploadDir)) mkdir($tmpUploadDir);
  801.                             $tmpUploadDir = $tmpUploadDir . date('YmdH') . '/';
  802.                             if(!file_exists($tmpUploadDir)) mkdir($tmpUploadDir);
  804.                             $dest = $tmpUploadDir . $filename;
  805.                             if(move_uploaded_file($tmpfile, $dest)){
  806.                                 $files[$filename] = $webUrl . '/uploads/forms/' . $config['id'] . '/' . date('YmdH') . '/' . $filename;
  807.                             }
  808.                         }
  809.                     }
  810.                 }
  811.             }
  813.             // Store in database
  814.             if(!empty($_POST['form']) && !$error && !empty($_POST['form-bundle-submit']) && $_POST['form-bundle-submit'] == $Form->getId()){
  816.                 // $Session = $this->getDoctrine()->getRepository('TrinityFormsBundle:Session')->findOneByHash($hash);
  817.                 $validCaptcha = $this->Settings->validateGoogleRecaptcha($request->request->get('g-recaptcha-response'));
  818.             
  819.                 if(($validCaptcha) && empty($_POST['form-check'])){
  821.                     if(empty($Session)){
  822.                         // Generate new session in case the current sesion got lost.
  823.                         $hash = $Form->getId() . '_' . md5(rand(1000,9999) . '' . time());
  824.                         $this->get('session')->set('formhash', $hash);
  826.                         // if(is_null($Session)){
  827.                         $Session = new \App\Trinity\FormsBundle\Entity\Session();
  828.                         $Session->setForm($Form);
  829.                         $Session->setHash($hash);
  830.                         $Session->setIpaddress($_SERVER['REMOTE_ADDR']);
  831.                         $Session->setDateStart(new \Datetime("now"));
  832.                     }
  834.                     $receiverFromAnswer = null;
  836.                 $Answer = $this->getDoctrine()->getRepository('TrinityFormsBundle:Answer')->findOneBySession($Session);
  837.                 if(!empty($Answer)){
  838.                     $saved = false;
  839.                     $error = $this->trans('Uw heeft het formulier al verzonden.', 'cms');
  840.                 }else{
  841.                     $Answer = new \App\Trinity\FormsBundle\Entity\Answer();
  842.                     $Answer->setForm($Form);
  843.                     $results = array();
  844.                     $email = null;
  845.                     $firstname = '';
  846.                     $lastname = '';
  847.                     $emaillist = null;
  849.                     foreach($_POST['form'][$Form->getId()] as $questionid => $answer){
  850.                         $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findOneById($questionid);
  852.                         if($Question->getType() == 'email'){
  853.                             $email = $answer;
  854.                         }
  855.                         if($Question->getType() == 'newsletter'){
  856.                             $this->addmemberActivecampaign($Answer->getForm(), [], $email);
  857.                         }
  858.                         if($Question->getType() == 'mailer'){
  859.                             if($email !== null) {
  860.                                 $mailerTool = new MailerTool(
  861.                                         $this->Settings->getHummessengerApiUrl(),
  862.                                         $this->Settings->getHummessengerApiKey(),
  863.                                         $Answer->getForm()->getMailerListid()
  864.                                 );
  865.                                 $mailerTool->setEmail($email);
  866.                                 if ($firstname != '') {
  867.                                     $mailerTool->setName($firstname);
  868.                                 }
  869.                                 if ($lastname != '') {
  870.                                     $mailerTool->setSurname($lastname);
  871.                                 }
  872.                                 $mailerTool->EditToList();
  873.                             }
  874.                         }
  875.                         if($Question->getType() == 'canvas'){
  876.                                 $random = bin2hex(openssl_random_pseudo_bytes(5));
  877.                                 $filename = 'canvas-' . $random . '.png';
  879.                                 $encoded_image = explode(",", $answer)[1];
  880.                                 $decoded_image = base64_decode($encoded_image);
  882.                                 $uploadDir = str_replace('/src/Trinity/FormsBundle/Controller' , '/public/uploads/', __DIR__);
  884.                                 $uploadDir = $uploadDir . 'canvas/';
  885.                                 if(!file_exists($uploadDir)) {
  886.                                     mkdir($uploadDir);
  887.                                 }
  889.                                 $uploadDir = $uploadDir . date('Ymd') . '/';
  890.                                 if(!file_exists($uploadDir)) {
  891.                                     mkdir($uploadDir);
  892.                                 }
  894.                                 $dest = $uploadDir . $filename;
  896.                                 $webDest = preg_replace('/^.*?\/public/', '', $dest);
  897.                                 if(file_put_contents($dest, $decoded_image) === false)
  898.                                 {
  899.                                     // return code was false
  900.                                 }else {
  901.                                     $canvas[$Question->getTitle()] = $webUrl . $webDest;
  902.                                 }
  903.                             }
  904.                             if(preg_match('/voornaam/', strtolower($Question->getTitle()))){
  905.                                 $firstname = $answer;
  906.                             }
  907.                             if(preg_match('/achternaam/', strtolower($Question->getTitle()))){
  908.                                 $lastname = $answer;
  909.                             }
  911.                             if($Question->getType() == 'select'){
  912.                                 foreach($Question->getValues() as $i => $v){
  913.                                     if($v == $answer){
  914.                                         if(!empty($Question->getEmail()[$i])){
  915.                                             // Can send mail?
  916.                                             $receiverFromAnswer = $v;
  917.                                         }
  918.                                     }
  919.                                 }
  920.                             }
  922.                             $results[$Question->getTitle()] = $answer;
  923.                         }
  925.                         $imagesUrls = [];
  927.                         $hosturl = $this->generateUrl('homepage', [], \Symfony\Component\Routing\Generator\UrlGeneratorInterface::ABSOLUTE_URL);
  929.                         if(isset($_POST['imageslist'])) {
  930.                             $imageQuestionId = 0;
  932.                             foreach($_POST['imageslist'] as $questionid => $answer) {
  934.                                 $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findOneById($questionid);
  935.                                 $imageQuestionId = $Question->getId();
  937.                                 if ($Question->getType() == 'dropzone') {
  938.                                     $images = explode(',', $answer);
  940.                                     foreach($images as $imageId) {
  941.                                         /** @var Media $Media */
  942.                                         $Media = $this->getDoctrine()->getRepository('CmsBundle:Media')->find($imageId);
  944.                                         if ($Media) {
  945.                                             $extentions = explode('.', $Media->getWebPath());
  946.                                             switch (end($extentions)){
  947.                                                 case 'doc':
  948.                                                 case 'docx':
  949.                                                     $path = 'bundles/cms/images/filetypes/' . $Media->getFileImage();
  950.                                                     break;
  951.                                                 case 'xlsx':
  952.                                                     $path = 'bundles/cms/images/filetypes/excel.png';
  953.                                                     break;
  954.                                                 case 'pptx':
  955.                                                     $path = 'bundles/cms/images/filetypes/powerpoint.png';
  956.                                                     break;
  957.                                                 default:
  958.                                                     if($Media->getFileImage() !== 'png.png' || $Media->getFileImage() !== 'jpg.png'){
  959.                                                         $path = 'bundles/cms/images/filetypes/' . $Media->getFileImage();
  960.                                                     } else {
  961.                                                         $path = $Media->getWebPath();
  962.                                                     }
  963.                                             }
  964.                                             $imagesUrls[] = '<a class="d-flex justify-content-center" target="_blank" href="' . $hosturl . $Media->getWebPath() . '"><img src="' . $hosturl . $path . '" width="70" height="70"/><br/> klik hier om ' . $Media->getLabel() . ' te downloaden </a>';
  965.                                         }
  966.                                     }
  967.                                 }
  968.                             }
  969.                             $results[$imageQuestionId] = $imagesUrls;
  970.                         }
  972.                         $Answer->setIp($_SERVER['REMOTE_ADDR']);
  973.                         $Answer->setAnswer(json_encode($results, JSON_FORCE_OBJECT));
  974.                         $Answer->setSession($Session);
  976.                         $Session->setDateEnd(new \Datetime("now"));
  977.                         $Session->setAnswer($Answer);
  978.                         $Session->setDone(1);
  979.                         $Session->setDuration($Session->getDateEnd()->getTimestamp() - $Session->getDateStart()->getTimestamp());
  981.                         if($this->Settings->getLefApiActive() && $Form->getLefApiActive()){
  982.                             if($this->Settings->getLefFormsRequest()){
  983.                                 $origin = $_SERVER['HTTP_REFERER'];
  984.                                 $hostUrl = "https://".$this->Settings->getHost();
  985.                                 $lef = new \App\CmsBundle\Classes\Lef();
  987.                                 $apiRequest = $lef->setSettings($this->Settings)
  988.                                     ->setId()
  989.                                     ->setType()
  990.                                     ->setKindOf()
  991.                                     ->setInitType()
  992.                                     ->setDescription($Form->getLabel())
  993.                                     ->setOrigin($hostUrl)
  994.                                     ->setEntityManager($this->getDoctrine())
  995.                                     ->setByForm($_POST['form'][$Form->getId()])
  996.                                     ->addAddress();
  999.                                 if(!empty($origin)){
  1000.                                     $apiRequest->addPair("Url",$origin);
  1001.                                     $apiRequest->addGroup("Volledige URL");
  1002.                                 }
  1003.                                 $result = $apiRequest->send();
  1004.                                 if(!empty($result)){
  1005.                                     $questions = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findBy(array('form'=> $Form), array('sort' => 'ASC'));
  1006.                                     $error = $result;
  1007.                                     $saved = false;
  1008.                                     $maxFileSize = 10;
  1009.                                     return $this->renderView('@TrinityForms/default/form.html.twig', array(
  1010.                                         'config'           => $config,
  1011.                                         'Form'             => $Form,
  1012.                                         'questions'        => $questions,
  1013.                                         'saved'            => $saved,
  1014.                                         'hide_send'        => !empty($config['hide_send']),
  1015.                                         'error'            => $error,
  1016.                                         'inline_error'     => $inline_error,
  1017.                                         'settings'         => $this->Settings,
  1018.                                         'maxMediaFileSize' => $this->Settings->getMaxMediaSizeInKB(),
  1019.                                         'maxFileSize'      => $maxFileSize,
  1020.                                     ));
  1021.                                 }
  1022.                             }
  1023.                         }
  1025.                         /*
  1026.                             AUTO RESPONSE
  1027.                         */
  1028.                         /*if($Form->getAutoResponse() && $email){
  1029.                             $Settings = $this->getDoctrine()->getRepository('CmsBundle:Settings')->findOneById(1);
  1031.                             $body = $this->renderView(
  1032.                                     ':emails:notify.html.twig',
  1033.                                     array(
  1034.                                         'label' => $Form->getAutoResponseSubject(),
  1035.                                         'message' => $Form->getAutoResponseText()
  1036.                                     )
  1037.                                 );
  1039.                             $message = \Swift_Message::newInstance()
  1040.                             ->setSubject($Form->getAutoResponseSubject())
  1041.                             ->setFrom(array($Settings->getSystemEmail() => $Settings->getSystemEmailFrom()))
  1042.                             ->setTo($email)
  1043.                             ->setBody($body, 'text/html')
  1044.                             ->addPart($Form->getAutoResponseText(), 'text/plain');
  1046.                             $this->get('mailer')->send($message);
  1047.                         }*/
  1049.                         /*
  1050.                             SEND COPY
  1051.                         */
  1052.                         if(!empty($_POST['form'][$Form->getId()])){
  1053.                             ob_start();
  1054.                             $this->trans('Het onderstaande formulier is ingevuld via de website:', 'cms')
  1055.                             ?>
  1056.                             <table style="margin-top: 20px;width: 100%;">
  1057.                                 <?php
  1058.                                 foreach($_POST['form'][$Form->getId()] as $questionid => $value){
  1059.                                     $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findOneById($questionid);
  1061.                                     // we don't want the raw canvas data in the mails, canvas data will get added as a Bijlage
  1062.                                     if($Question->getType() == "canvas")
  1063.                                     {
  1064.                                         continue;
  1065.                                     }
  1067.                                     $valueLabels = $Question->getValues();
  1069.                                     if ($Question->getType() == 'checkbox') {
  1070.                                         if(is_array($value)){
  1071.                                             $value = '<ul><li>' . implode('</li><li>', $value) . '</li></ul>';
  1072.                                         }
  1073.                                     }
  1075.                                     // I don't know why this code is here, probably for checkbox. But so leave it here and fix checkbox above.
  1076.                                     if(is_array($value)){
  1077.                                         $values = [];
  1078.                                         foreach($value as $k => $v){
  1079.                                             $values[] = $valueLabels[$k];
  1080.                                         }
  1081.                                         $value = '<ul><li>' . implode('</li><li>', $values) . '</li></ul>';
  1082.                                     }
  1083.                                     if(preg_match('/\s?\|\s?/', $value)){
  1084.                                         $value = preg_replace('/^(.*?)\s?\|.*?$/', '$1', $value);
  1085.                                     }
  1087.                                     $value = str_replace('&comma;', ',', $value);
  1088.                                     ?>
  1089.                                     <tr>
  1090.                                         <td style="padding: 10px 0;width: 40%;vertical-align: top;font-weight: bold;text-align: right;padding-right: 20px;"><?php echo $Question->getTitle(); ?></td>
  1091.                                         <td style="padding: 10px 0;width: 60%;vertical-align: top;"><?php echo nl2br($value); ?></td>
  1092.                                     </tr>
  1093.                                     <?php
  1094.                                 }
  1096.                             if(!empty($files) || !empty($canvas) || !empty($imagesUrls)){
  1097.                                 if ($Question->getType() == 'newsletter') {
  1098.                                     if(is_array($value)){
  1099.                                         $value = '<ul><li>' . implode('</li><li>', $value) . '</li></ul>';
  1100.                                     }
  1101.                                 }
  1102.                                 ?>
  1103.                                 <tr>
  1104.                                     <td style="padding: 10px 0;width: 40%;vertical-align: top;font-weight: bold;text-align: right;padding-right: 20px;"><?php $this->trans('Bijlage(n)', 'cms')?></td>
  1105.                                     <td style="padding: 10px 0;width: 60%;vertical-align: top;">
  1106.                                         <?php
  1107.                                         foreach($files as $filename => $path){
  1108.                                             ?>
  1109.                                             <a href="<?php echo $path; ?>"><?php echo $filename; ?></a><br />
  1110.                                             <?php   
  1111.                                         }
  1113.                                             foreach($canvas as $title => $path){
  1114.                                                 echo $title;
  1115.                                                 ?>
  1116.                                                 <br />
  1117.                                                 <img src="<?php echo $path; ?>" style="width: 400px; height: 200px;"><br/>
  1118.                                                 <?php
  1119.                                             }
  1121.                                             foreach($imagesUrls as $i) {
  1122.                                                 ?>
  1123.                                                 <?php echo $i; ?><br/><br/>
  1124.                                                 <?php
  1125.                                             }
  1126.                                             ?>
  1127.                                         </td>
  1128.                                     </tr>
  1129.                                     <?php
  1130.                                 }
  1131.                                 ?>
  1132.                             </table>
  1133.                             <?php
  1134.                             $message = ob_get_contents();
  1135.                             ob_end_clean();
  1137.                             /*if($this->container->getParameter('kernel.environment') == 'dev'){
  1138.                                 dump($message);die();
  1139.                             }*/
  1143.                                 //$Settings = $this->getDoctrine()->getRepository('CmsBundle:Settings')->findOneById(1);
  1144.                             $mails = $Form->getMails();
  1145.                             foreach($mails as $key => $mail){
  1147.                                 if(!isset($mail['receiver'])){
  1148.                                     // Try to find local mailaddress
  1149.                                     $mail['receiver'] = $email;
  1150.                                 }
  1152.                                 // Remove spaces
  1153.                                 $mail['receiver'] = str_replace(' ', '', $mail['receiver']);
  1154.                                 $mail['receiver'] = explode(';', $mail['receiver']);
  1156.                                 $vals = $_POST['form'][$Form->getId()];
  1158.                                 foreach($mail['receiver'] as $index => $receiver){
  1159.                                     if(empty($receiver)){
  1160.                                         unset($mail['receiver'][$index]);
  1161.                                     }
  1162.                                 }
  1165.                                 $tags = preg_match_all('/\[(\d+)\#.*?\]/', $mail['subject'], $m);
  1166.                                 if($tags){
  1167.                                     foreach($m[1] as $index => $field_id){
  1168.                                         $value = $vals[$field_id];
  1169.                                         if(preg_match('/\s?\|\s?/', $value)){
  1170.                                             $value = preg_replace('/^(.*?)\s?\|.*?$/', '$1', $value);
  1171.                                         }
  1172.                                         $mail['subject'] = str_replace($m[0][$index], $value, $mail['subject']);
  1173.                                     }
  1174.                                 }
  1176.                                 if (isset($mail['sendername'])) {
  1177.                                     $tags = preg_match_all('/\[(\d+)\#.*?\]/', $mail['sendername'], $m);
  1178.                                     if($tags){
  1179.                                         foreach($m[1] as $index => $field_id){
  1180.                                             $value = $vals[$field_id];
  1181.                                             if(preg_match('/\s?\|\s?/', $value)){
  1182.                                                 $value = preg_replace('/^(.*?)\s?\|.*?$/', '$1', $value);
  1183.                                             }
  1184.                                             $mail['sendername'] = str_replace($m[0][$index], $value, $mail['sendername']);
  1185.                                         }
  1186.                                     }
  1187.                                 }
  1189.                                 if(!empty($mail['receiver'])){
  1192.                                         if(is_array($mail['receiver'])){
  1193.                                             foreach($mail['receiver'] as $i => $receiver){
  1194.                                                 $tags = preg_match_all('/\[(\d+)\#.*?\]/', $receiver, $m);
  1195.                                                 if($tags){
  1196.                                                     foreach($m[1] as $index => $field_id){
  1198.                                                         $receiver = str_replace($m[0][$index], $vals[$field_id], $receiver);
  1200.                                                         if(preg_match('/\s?\|\s?/', $receiver)){
  1201.                                                             $receiver = preg_replace('/^.*?\s?\|\s?(.*?)$/', '$1', $receiver);
  1202.                                                         }
  1203.                                                     }
  1204.                                                 }
  1206.                                                 $mail['receiver'][$i] = $receiver;
  1207.                                             }
  1208.                                         }
  1210.                                     $tags = preg_match_all('/\[(\d+)\#.*?\]/', $mail['content'], $m);
  1211.                                     if($tags){
  1212.                                         foreach($m[1] as $index => $field_id){
  1214.                                                 $value = $vals[$field_id];
  1215.                                                 if(preg_match('/\s?\|\s?/', $value)){
  1216.                                                     $value = preg_replace('/^(.*?)\s?\|.*?$/', '$1', $value);
  1217.                                                 }
  1218.                                                 $mail['content'] = str_replace($m[0][$index], $value, $mail['content']);
  1219.                                         }
  1220.                                     }
  1222.                                     $mail['content'] = str_replace('[FORM_RESULTS]', $message, $mail['content']);
  1223.                                     
  1224.                                     if(in_array('WebshopBundle',$this->installed)){
  1225.                                         if($this->Settings->getIsCatalog() && !empty($_POST["form"]["productid"])){
  1226.                                             $product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_POST["form"]["productid"]);
  1227.                                             if(!empty($product)){
  1228.                                                 $productInfo = $product->getLabel();
  1229.                                                 $mail['content'] = str_replace('[productinfo]', $productInfo,$mail['content']);
  1230.                                             }
  1231.                                         }
  1232.                                     }
  1234.                                     // $mail['receiver'] = 'jelle@beyonit.nl';
  1236.                                     $mailer = clone $this->mailer;
  1237.                                     $mailer->init();
  1239.                                     // Add optional reply-to
  1240.                                     if ($key == 'internal') {
  1241.                                         if (isset($mail['sendername']) && !empty($mail['sendername'])) {
  1242.                                             if($this->Settings->getTest()){
  1243.                                                 $mailer->setFrom(explode(';', $this->Settings->getAdminEmail())[0], $mail['sendername']);
  1244.                                             }else{
  1245.                                                 $mailer->setFrom($this->Settings->getSystemEmail(), $mail['sendername']);
  1246.                                             }
  1247.                                         }
  1249.                                         if ($Form->getMailReplyTo() && !empty($email) && !empty($mail['sendername'])) {
  1250.                                             $mailer->setReplyTo([$email => $mail['sendername']]);
  1251.                                         } elseif ($Form->getMailReplyTo() && !empty($email)) {
  1252.                                             $mailer->setReplyTo([$email]);
  1253.                                         }
  1254.                                     }
  1256.                                     $mailer->setSubject($mail['subject'])
  1257.                                             ->setTo($mail['receiver'])
  1258.                                             ->setTwigBody('/emails/' . $mail['template'], [
  1259.                                                 // 'label' => $mail['label'],
  1260.                                                 'message' => $mail['content']
  1261.                                             ])
  1262.                                             ->setPlainBody($mail['content']);
  1264.                                         if(!empty($mail['from_email']) && !empty($mail['from_name'])){
  1265.                                             $mailer->setFrom($mail['from_email'], $mail['from_name']);
  1266.                                         }
  1268.                                     $send = $mailer->execute_forced();
  1269.                                 }
  1270.                             }
  1272.                         }
  1274.                         /**
  1275.                          * LEF call
  1276.                          */
  1277.                         if (isset($config['extension_lef']))
  1278.                         {
  1279.                             $extensionObject = new \App\Trinity\ExtensionsBundle\Classes\Extensions($this->container, $this->Settings, 'lef');
  1281.                             $formLabel = $Form->getLabel();
  1282.                             $extensionObject->setDescriptionSuffix($formLabel);
  1284.                             // Aftersales formulieren
  1285.                             $aftersales = [];
  1286.                             if (preg_match('/renses-online.nl/', $request->server->get('HTTP_HOST')))
  1287.                             {
  1288.                                 $aftersales[] = 'werkplaats';
  1289.                                 $aftersales[] = 'ruitschade';
  1290.                                 $aftersales[] = 'autoschade';
  1291.                             }
  1293.                             if (preg_match('/kreijne.nl/', $request->server->get('HTTP_HOST')))
  1294.                             {
  1295.                                 $aftersales[] = 'Auto verzekering';
  1296.                                 $aftersales[] = 'werkplaatsafspraak';
  1297.                             }
  1299.                             foreach ($aftersales as $as)
  1300.                             {
  1301.                                 if (strpos(strtolower($formLabel), $as) !== FALSE)
  1302.                                 {
  1303.                                     $extensionObject->setLeadType('AfterSales');
  1304.                                 }
  1305.                             }
  1307.                             // FIXME HARDCODED, hoe willen we particulier / zakelijk keuze aanbidden?
  1308.                             $extensionObject->setRelationType($extensionObject->getRelationType()[0]);
  1310.                             $foundAccount = false;
  1311.                             $extrainfo = [];
  1312.                             foreach($_POST['form'][$Form->getId()] as $questionid => $answer)
  1313.                             {
  1314.                                 $Question = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findOneById($questionid);
  1316.                                 switch($Question->getTitle())
  1317.                                 {
  1318.                                     case "Vestiging":
  1319.                                 case "Selecteer vestiging":
  1320.                                         $accounts = $extensionObject->getAccounts();
  1321.                                         foreach($accounts as $account)
  1322.                                         {
  1323.                                         $expoded = explode(' ', $answer);
  1325.                                         foreach ($expoded as $item)
  1326.                                         {
  1327.                                             if (strpos($account['label'], $item) !== false)
  1328.                                             {
  1329.                                                 $foundAccount = true;
  1330.                                                 $extensionObject->setAccount($account['id']);
  1331.                                                 $extrainfo['vestiging'] = $answer;
  1332.                                                 continue 2;
  1333.                                             }
  1334.                                         }
  1335.                                     }
  1337.                                     if (preg_match('/kreijne.nl/', $request->server->get('HTTP_HOST')))
  1338.                                     {
  1339.                                         $aftersalesquestions = 'werkplaats';
  1341.                                         if (strpos(strtolower($answer), $aftersalesquestions) !== FALSE)
  1342.                                         {
  1343.                                             $extensionObject->setLeadType('AfterSales');
  1344.                                             }
  1345.                                         }
  1346.                                         break;
  1347.                                     case "Aanhef":
  1348.                                         $extensionObject->setNamePrefix($answer);
  1349.                                         break;
  1350.                                     case "Voornaam":
  1351.                                         $extensionObject->setFirstName($answer);
  1352.                                         break;
  1353.                                     case "Voorletters":
  1354.                                         $extensionObject->setNameInitials($answer);
  1355.                                         break;
  1356.                                     case "tussenvoegsel":
  1357.                                         $extensionObject->setMiddleName($answer);
  1358.                                         break;
  1359.                                     case "Naam":
  1360.                                     case "Uw naam":
  1361.                                     case "Achternaam":
  1362.                                     case "Voornaam + Achternaam":
  1363.                                         $extensionObject->setLastName($answer);
  1364.                                         break;
  1365.                                     case "Straat":
  1366.                                     case "Straatnaam + huisnummer":
  1367.                                         $extensionObject->setStreetName($answer);
  1368.                                         break;
  1369.                                     case "Huisnummer":
  1370.                                     case "huisnummer":
  1371.                                         $extensionObject->setHouseNumber($answer);
  1372.                                         break;
  1373.                                 case "Huisnummertoevoeging":
  1374.                                     case "huisnummertoevoeging":
  1375.                                         $extensionObject->setHouseNumberSuffix($answer);
  1376.                                         break;
  1377.                                     case "Postcode":
  1378.                                     case "postcode":
  1379.                                         $extensionObject->setPostcode($answer);
  1380.                                         break;
  1381.                                     case "Plaats":
  1382.                                     case "Stad":
  1383.                                         $extensionObject->setCity($answer);
  1384.                                         break;
  1385.                                     case "Land":
  1386.                                         $extensionObject->setCountry($answer);
  1387.                                         break;
  1388.                                     case "GeboorteDatum":
  1389.                                     case "Geboortedatum":
  1390.                                         $extensionObject->setBirthday($answer);
  1391.                                         break;
  1392.                                     case "Gender":
  1393.                                     case "Sex":
  1394.                                         $extensionObject->setGender($answer);
  1395.                                         break;
  1396.                                     case "Telefoonnummer":
  1397.                                         $extensionObject->addTelephoneNumber($answer);
  1398.                                         break;
  1399.                                     case "Bedrijfsnaam":
  1400.                                         $extensionObject->setCompanyName($answer);
  1401.                                         break;
  1402.                                     case "Bedrijfsnummer":
  1403.                                     case "CompanyNumber":
  1404.                                     case "KvKnummer":
  1405.                                         $extensionObject->setCompanyNumber($answer);
  1406.                                         break;
  1407.                                     case "E-mailadres":
  1408.                                     case "Uw e-mailadres":
  1409.                                     case "E-mail":
  1410.                                         $extensionObject->setEmailAddress($answer);
  1411.                                         break;
  1412.                                     default:
  1413.                                         // Add unknown forms to extrainfo.
  1414.                                         $title = $Question->getTitle();
  1415.                                         $newtitle = $title;
  1417.                                         // Make sure we don't overwrite another key, value pair
  1418.                                         for($i = 0; ; $i++)
  1419.                                         {
  1420.                                             if (array_key_exists($newtitle, $extrainfo))
  1421.                                             {
  1422.                                                 $newtitle = $title . ' ' . ($i + 1);
  1423.                                         } else {
  1424.                                                 break;
  1425.                                         }
  1426.                                     }
  1428.                                         // Support checkbox questions
  1429.                                         if (is_array($answer))
  1430.                                         {
  1431.                                             $question_value_list = $Question->getValues();
  1432.                                             $temp = 'Opties: ';
  1433.                                             foreach($answer as $key => $a)
  1434.                                             {
  1435.                                                 if ($temp != 'Opties: ')
  1436.                                             {
  1437.                                                     $temp .= '; ';
  1438.                                             }
  1440.                                                 $temp .= '\'' . $question_value_list[$key] . '\'';
  1441.                                             }
  1442.                                             $answer = $temp . ' geselecteerd';
  1443.                                         }
  1445.                                         $extrainfo[$newtitle] = $answer;
  1446.                                         break;
  1447.                                 }
  1448.                             } // end foreach()
  1450.                             if (!$foundAccount)
  1451.                             {
  1452.                                 $accounts = $extensionObject->getAccounts();
  1453.                                 if(count($accounts) >= 1)
  1454.                                 {
  1455.                                     $extensionObject->setAccount($accounts[0]['id']);
  1456.                                 }
  1457.                             }
  1459.                             $extensionObject->setAdditionInfoGroup('Overige informatie', $extrainfo);
  1461.                             $extensionObject->sendContent();
  1462.                         } // end LEF
  1464.                         //Active Campaign
  1465.                         if ($Form->getActiveCampaign() && !empty($Form->getActiveCampaignKey()) && !empty($Form->getActiveCampaignListid())) {
  1466.                             $this->addmemberActivecampaign($Form, $results, $email);
  1467.                         }
  1469.                     $em = $this->getDoctrine()->getManager();
  1470.                     $em->persist($Answer);
  1471.                     $em->persist($Session);
  1473.                     if($emaillist && $email && in_array('NewsletterBundle', $this->installed)){
  1474.                         $List = $this->getDoctrine()->getRepository('TrinityNewsletterBundle:Emaillist')->find($emaillist);
  1475.                         $Recipient = new \App\Trinity\NewsletterBundle\Entity\Recipient();
  1476.                         $Recipient->setEmaillist($List);
  1477.                         $Recipient->setEmail($email);
  1478.                         $Recipient->setName(implode(' ', [$firstname, $lastname]));
  1480.                         $em->persist($Recipient);
  1481.                     }
  1483.                     $em->flush();
  1485.                     $saved = true;
  1487.                         if(isset($config['redirect']) && !empty($config['redirect'])){
  1488.                             header('Location: ' . $config['redirect']);
  1489.                             exit;
  1490.                         }
  1491.                     }
  1492.                 }
  1493.                 else
  1494.                 {
  1495.                     $saved = false;
  1496.                     $inline_error = $this->trans('Ongeldige reCAPTCHA.', 'cms');
  1497.                 }
  1498.             }else{
  1499.                 $hash = $Form->getId() . '_' . md5(rand(1000,9999) . '' . time());
  1500.                 $this->get('session')->set('formhash', $hash);
  1502.                 // if(is_null($Session)){
  1503.                 $Session = new \App\Trinity\FormsBundle\Entity\Session();
  1504.                 $Session->setForm($Form);
  1505.                 $Session->setHash($hash);
  1506.                 $Session->setIpaddress($_SERVER['REMOTE_ADDR']);
  1507.                 $Session->setDateStart(new \Datetime("now"));
  1509.                 $em = $this->getDoctrine()->getManager();
  1510.                 $em->persist($Session);
  1511.                 $em->flush();
  1512.                 // }
  1513.             }
  1515.             $questions = $this->getDoctrine()->getRepository('TrinityFormsBundle:Question')->findBy(array('form'=> $Form), array('sort' => 'ASC'));
  1517.             $maxFileSize = 10;
  1518.             try{
  1519.                 //$maxFileSize = (int)ini_get('upload_max_filesize');
  1520.             }catch(\Exception $e){
  1521.                 // Nothing going on here
  1522.             }
  1523.             
  1524.             $parameters = array(
  1525.                     'config'           => $config,
  1526.                     'Form'             => $Form,
  1527.                     'questions'        => $questions,
  1528.                     'saved'            => $saved,
  1529.                     'hide_send'        => !empty($config['hide_send']),
  1530.                     'error'            => $error,
  1531.                     'inline_error'     => $inline_error,
  1532.                     'settings'         => $this->Settings,
  1533.                     'maxMediaFileSize' => $this->Settings->getMaxMediaSizeInKB(),
  1534.                     'maxFileSize'      => $maxFileSize,
  1535.                     'product'               => (!empty($product) ? $product : null)
  1536.                 );
  1537.             
  1538.             if(!empty($params["isAjax"]) && $params["isAjax"]){
  1539.                 return $this->render('@TrinityForms/default/form.html.twig',$parameters);                
  1540.             }
  1541.             return $this->renderView('@TrinityForms/default/form.html.twig',$parameters);
  1542.         }
  1543.         return $this->renderView('@TrinityForms/default/not-found.html.twig');
  1544.     }
  1546.     public function addmemberActivecampaign($Form, $results, $email)
  1547.     {
  1549.         $ApiKey = $Form->getActiveCampaignKey();
  1550.         $ListId = $Form->getActiveCampaignListid();
  1551.         $ApiUrl = $Form->getActiveCampaignUrl();
  1554.         if (isset($results['Naam'])) {
  1555.             $name = $results['Naam'];
  1556.         } else {
  1557.             $name = explode("@", $email)[0];
  1558.         }
  1560.         // $Mail = $_POST['email'];
  1561.         $curl = curl_init();
  1562.         $data = array(
  1563.             'contact' => array(
  1564.                 'email' => $email,
  1565.                 // 'lastname' => $firstName,
  1566.                 'firstName' => $name,
  1567.                 // 'phone' => $_POST['phone']
  1568.             )
  1569.         );
  1570.         curl_setopt_array($curl, array(
  1571.             CURLOPT_URL => $ApiUrl . "/api/3/contacts",
  1572.             CURLOPT_RETURNTRANSFER => true,
  1573.             CURLOPT_ENCODING => "",
  1574.             CURLOPT_SSL_VERIFYPEER => false,
  1575.             CURLOPT_MAXREDIRS => 10,
  1576.             CURLOPT_TIMEOUT => 30,
  1577.             CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1578.             CURLOPT_CUSTOMREQUEST => "POST",
  1579.             CURLOPT_POSTFIELDS => json_encode($data),
  1580.             CURLOPT_HTTPHEADER => array(
  1581.                 "Api-Token: $ApiKey",
  1582.                 "Content-Type: application/json",
  1583.                 "Postman-Token: 41fb5406-d0b7-40e3-b168-2645967314b0",
  1584.                 "cache-control: no-cache"
  1585.             )
  1586.         ));
  1589.         $response = curl_exec($curl);
  1590.         $err = curl_error($curl);
  1593.         curl_close($curl);
  1596.         $curl = curl_init();
  1598.         curl_setopt_array($curl, array(
  1599.             CURLOPT_URL => $ApiUrl . "/api/3/contacts?search=" . $email,
  1600.             CURLOPT_RETURNTRANSFER => true,
  1601.             CURLOPT_ENCODING => "",
  1602.             CURLOPT_SSL_VERIFYPEER => false,
  1603.             CURLOPT_MAXREDIRS => 10,
  1604.             CURLOPT_TIMEOUT => 30,
  1605.             CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1606.             CURLOPT_CUSTOMREQUEST => "GET",
  1607.             CURLOPT_HTTPHEADER => array(
  1608.                 "Api-Token: $ApiKey",
  1609.                 "Content-Type: application/json",
  1610.                 "Postman-Token: 41fb5406-d0b7-40e3-b168-2645967314b0",
  1611.                 "cache-control: no-cache"
  1612.             )
  1613.         ));
  1615.         $response1 = curl_exec($curl);
  1616.         $err = curl_error($curl);
  1617.         $dataID = json_decode($response1, true);
  1618.         $ID = $dataID['contacts'][0]["id"];
  1621.         curl_close($curl);
  1623.         $curl = curl_init();
  1624.         $dataList = array(
  1625.             'contactList' => array(
  1626.                 'list' => $ListId,
  1627.                 'contact' => $ID,
  1628.                 'status' => 1,
  1629.             )
  1630.         );
  1632.         curl_setopt_array($curl, array(
  1633.             CURLOPT_URL => $ApiUrl . "/api/3/contactLists",
  1634.             CURLOPT_RETURNTRANSFER => true,
  1635.             CURLOPT_ENCODING => "",
  1636.             CURLOPT_SSL_VERIFYPEER => false,
  1637.             CURLOPT_MAXREDIRS => 10,
  1638.             CURLOPT_TIMEOUT => 30,
  1639.             CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1640.             CURLOPT_CUSTOMREQUEST => "POST",
  1641.             CURLOPT_POSTFIELDS => json_encode($dataList),
  1642.             CURLOPT_HTTPHEADER => array(
  1643.                 "Api-Token: $ApiKey",
  1644.                 "Content-Type: application/json",
  1645.                 "Postman-Token: 41fb5406-d0b7-40e3-b168-2645967314b0",
  1646.                 "cache-control: no-cache"
  1647.             )
  1648.         ));
  1651.         $response = curl_exec($curl);
  1652.         $err = curl_error($curl);
  1653.         curl_close($curl);
  1654.     }
  1656.     /**
  1657.      * Return link data when required within the link form
  1658.      *
  1659.      * @param  object  Doctrine object
  1660.      *
  1661.      * @return array   Array with config options
  1662.      */
  1663.     public function getLinkData($em, $language, $container, $settings){
  1664.         $questions = [];
  1665.         $forms = $em->getRepository('TrinityFormsBundle:Form')->findBy([ 'language' => $language, 'settings' => $settings ]);
  1666.         foreach($forms as $Form){
  1667.             $q = $em->getRepository('TrinityFormsBundle:Question')->findBy([ 'form' => $Form ], ['sort' => 'asc']);
  1668.             foreach($q as $Question){
  1669.                 $questions[$Form->getId()][$Question->getId()] = [
  1670.                     'id' => $Question->getId(),
  1671.                     'title' => $Question->getTitle(),
  1672.                     'type' => $Question->getType(),
  1673.                     'values' => $Question->getValues(),
  1674.                 ];
  1675.             }
  1676.         }
  1677.         return array(
  1678.             'forms' => $forms,
  1679.             'questions' => $questions,
  1680.         );
  1681.     }
  1683.     /**
  1684.      * Show dashboard blocks
  1685.      *
  1686.      * @return array List of blocks
  1687.      */
  1688.     public function dashboardBlocks(){
  1689.         $sessions = $this->getDoctrine()->getRepository('TrinityFormsBundle:Session')->findBy(array(
  1690.             'done' => 1
  1691.         ), array(
  1692.             'dateStart' => 'desc'
  1693.         ), 10);
  1695.         $responses = '';
  1696.         foreach($sessions as $Session){
  1697.             $responses .= '<tr>
  1698.                 <td style="text-align:left;">' . $Session->getForm()->getLabel() . '</td>
  1699.                 <td style="text-align:center;"><a href="' . $this->generateUrl('admin_mod_forms_answers', array('id' => $Session->getForm()->getId(), 'answerid' => $Session->getAnswer()->getId())) . '">' . $this->time2str($Session->getDateStart()) . '</a></td>
  1700.             </tr>';
  1701.         }
  1703.         return array(
  1704.             array(
  1705.                 'title' => $this->trans('Laatst ingevulde formulieren', 'cms'),
  1706.                 'class' => '',
  1707.                 'content' => '<table><tr><th style="text-align:left;">'.$this->trans('Formulier', 'cms').'</th><th style="text-align:center;">'.$this->trans('Datum', 'cms').'</th></tr>' . $responses . '</table>'
  1708.             ),
  1709.         );
  1710.     }
  1712.     /**
  1713.      * Generate relative date
  1714.      *
  1715.      * @param  mixed $ts Timestamp or \DateTime object
  1716.      *
  1717.      * @return string    Relative date
  1718.      */
  1719.     private function time2str($ts) {
  1720.         if($ts instanceof \DateTime){
  1721.             $ts = $ts->getTimestamp();
  1722.         }
  1723.         if(!ctype_digit($ts)) {
  1724.             $ts = strtotime($ts);
  1725.         }
  1726.         $diff = time() - $ts;
  1727.         if($diff == 0) {
  1728.             return 'Nu';
  1729.         } elseif($diff > 0) {
  1730.             $day_diff = floor($diff / 86400);
  1731.             if($day_diff == 0) {
  1732.                 if($diff < 60) { return $this->trans('Zojuist', 'cms'); }
  1733.                 if($diff < 120) { return $this->trans('1 minuut geleden', 'cms'); }
  1734.                 if($diff < 3600) { return floor($diff / 60) . ' ' . $this->trans('minuten geleden', 'cms'); }
  1735.                 if($diff < 7200) { return $this->trans('1 uur geleden', 'cms'); }
  1736.                 if($diff < 86400) { return floor($diff / 3600) . ' ' . $this->trans('uren geleden', 'cms'); }
  1737.             }
  1738.             if($day_diff == 1) { return $this->trans('Gisteren', 'cms'); }
  1739.             if($day_diff < 7) { return $day_diff . ' ' . $this->trans('dagen geleden', 'cms'); }
  1740.             if($day_diff < 31) { return ceil($day_diff / 7) . ' '. $this->trans('weken geleden', 'cms'); }
  1741.             if($day_diff < 60) { return $this->trans('afgelopen maand', 'cms'); }
  1742.             return date('F Y', $ts);
  1743.         } else {
  1744.             $diff = abs($diff);
  1745.             $day_diff = floor($diff / 86400);
  1746.             if($day_diff == 0) {
  1747.                 if($diff < 120) { return $this->trans('Binnen een minuut', 'cms'); }
  1748.                 if($diff < 3600) { return $this->trans('Binnen %time% minuten', 'cms', ['%time%' => floor($diff / 60)]); }
  1749.                 if($diff < 7200) { return $this->trans('Binnen een uur', 'cms'); }
  1750.                 if($diff < 86400) { return $this->trans('Binnen %time% uren', 'cms', ['%time%' => floor($diff / 3600)]); }
  1751.             }
  1752.             if($day_diff == 1) { return $this->trans('Morgen', 'cms'); }
  1753.             if($day_diff < 4) { return date('l', $ts); }
  1754.             if($day_diff < 7 + (7 - date('w'))) { return $this->trans('Volgende week', 'cms'); }
  1755.             if(ceil($day_diff / 7) < 4) { return $this->trans('Binnen %time% weken', 'cms', ['%time%' => ceil($day_diff / 7)]); }
  1756.             if(date('n', $ts) == date('n') + 1) { return $this->trans('Volgende week', 'cms'); }
  1757.             return date('F Y', $ts);
  1758.         }
  1759.     }
  1761.     /**
  1762.      * Handle uploaded files
  1763.      *
  1764.      * @Route("/trinity/forms/upload", name="trinity_mod_forms_upload")
  1765.      */
  1766.     public function uploadAction(Request $request){
  1767.         parent::init($request);
  1769.         /*if(count($_FILES) != 1 || !is_array($_FILES) || !isset($_FILES['images-' . $id]) || !is_array($_FILES['images-' . $id])) {
  1770.             $response = new JsonResponse(['error' => 'File parameter count is not 1, or the parameter is empty', 'json' => $_FILES]);
  1771.             $response->setStatusCode(\Symfony\Component\HttpFoundation\Response::HTTP_BAD_REQUEST);
  1772.             return $response;
  1773.         }*/
  1774.         if(!empty($_FILES['file'])){
  1776.             $file = $_FILES['file'];
  1778.             $uploadedfile = new UploadedFile( $file['tmp_name'], $file['name'], $file['type'], (int)$file['error'] );
  1780.             $em = $this->getDoctrine()->getManager();
  1781.             $mediadir = $this->getDoctrine()->getRepository('CmsBundle:Mediadir')->findPathByName($em, (!empty($this->Settings->getHost()) ? $this->Settings->getHost() . '/' : '') .  $this->trans('Forms', [], 'forms') . '/' . date('Ymd'), $this->language);
  1783.             $mediafile = new \App\CmsBundle\Entity\Media();
  1784.             $mediafile->setParent($mediadir);
  1785.             $mediafile->setLabel($file['name']);
  1786.             $mediafile->setDateAdd();
  1787.             $mediafile->setFile($uploadedfile);
  1788.             $mediafile->preUpload();
  1789.             $mediafile->upload();
  1790.             $em->persist($mediafile);
  1791.             $em->flush($mediafile);
  1793.             return new JsonResponse([
  1794.                 'status' => true,
  1795.                 'mediaid' => $mediafile->getId(),
  1796.                 'webpath' => $mediafile->getWebpath(),
  1797.             ]);
  1798.         }
  1800.         return new JsonResponse([
  1801.             'status' => false,
  1802.             '_FILES' => (!empty($_FILES) ? $_FILES : []),
  1803.             '_POST' => (!empty($_POST) ? $_POST : []),
  1804.             'error' => 'No file given',
  1805.         ]);
  1807.     }
  1809.     public static function resourcesHandler($Settings, array $bundledata, string $projectDir) : ?string
  1810.     {
  1811.         $resources = null;
  1812.         $layoutKey = !empty($Settings->getOverrideKey()) ? trim($Settings->getOverrideKey()) . '/' : '';
  1814.         // check if file exists or build array in code and return that.
  1815.         $file = __DIR__ . "/../Resources/views/default/resources.json";
  1816.         $override = $projectDir . '/public/custom/' . $layoutKey . 'blog/resources.json';
  1818.         if (file_exists($override)) {
  1819.             $resources = $override;
  1820.         } else if (file_exists($file)) {
  1821.             $resources = $file;
  1822.         }
  1824.         return $resources;
  1825.     }
  1827. }