src/Controller/EquipmentGenericController.php line 1458

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Psr\Log\LoggerInterface;
  6. use App\Entity\EquipmentGeneric;
  7. use App\Entity\EquipmentSpecific;
  8. use App\Entity\InterfaceGeneric;
  9. use App\Entity\InterfaceSpecific;
  10. use App\Entity\Port;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  15. use Pagerfanta\Pagerfanta;
  16. // use Pagerfanta\Adapter\DoctrineORMAdapter;
  17. use Symfony\Contracts\Translation\TranslatorInterface;
  18. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  21. class EquipmentGenericController  extends AbstractController
  22. {
  25.     /**
  26.      * @Route("/equipment/generic/create", name="equipment_generic_create")
  27.      */
  28.     public function createAction(Request $request, TranslatorInterface $translator)
  29.     {
  31.         $user = $this->getUser();
  33.         // process form
  34.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  36.             $em = $this->getDoctrine()->getManager();
  38.             $eq = new EquipmentGeneric();
  40.             $eq->setTitle($request->request->get('title'));
  41.             $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  42.             $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  43.             $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  45.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  47.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  49.                 // NEW FRONT IMAGE
  50.                 $uploadedImage = $_FILES['frontImage'];
  51.                 $file = $uploadedImage['tmp_name'];
  52.                 $path_parts = pathinfo($uploadedImage['name']);
  53.                 $extension = $path_parts['extension'];
  54.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  56.                 $fullPathImage = $upload_dir . $fileNameImg;
  58.                 move_uploaded_file($file, $fullPathImage);
  60.                 $eq->setFrontImage($fileNameImg);
  61.             }
  64.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  66.                 // NEW REAR IMAGE
  67.                 $uploadedImage = $_FILES['rearImage'];
  68.                 $file = $uploadedImage['tmp_name'];
  69.                 $path_parts = pathinfo($uploadedImage['name']);
  70.                 $extension = $path_parts['extension'];
  71.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  73.                 $fullPathImage = $upload_dir . $fileNameImg;
  75.                 move_uploaded_file($file, $fullPathImage);
  77.                 $eq->setRearImage($fileNameImg);
  78.             }
  81.             $em->persist($eq);
  82.             $em->flush();
  85.             // store interfaces
  86.             $inter_num = $eq->getNumberOfInterfaces();
  87.             for ($i = 0; $i < $inter_num; $i++) {
  89.                 $if = new InterfaceGeneric();
  91.                 $if->setEquipmentGeneric($eq);
  92.                 $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  93.                 $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  94.                 $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  95.                 if ($_POST['typeConnector'][$i]) {
  96.                     $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  97.                 }
  98.                 $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  100.                 $if->setAlias($this->buildAlias($i));
  101.                 $em->persist($if);
  102.                 $em->flush();
  103.             }
  105.             return $this->redirectToRoute('equipment_generic_list');
  107.             // show form
  108.         } else {
  110.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  111.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  112.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  113.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  114.             return $this->render('equipment/generic_create.html.twig', [
  115.                 'action' => 'insert',
  116.                 'page_title' => $translator->trans('Generic Equipment'),
  117.                 'box_title' => '<i class="fa fa-plus-circle fa-fw"></i>' . $translator->trans('Add new'),
  118.                 'typeLink' => $typeLink,
  119.                 'typeConnector' => $typeConnector,
  120.                 'typeEquipments' => $typeEquipments,
  121.                 'typeInterconnection' => $typeInterconnection
  122.             ]);
  123.         }
  124.     }
  125.     private function buildAlias(int $i):?string{
  126.         $alias = [];
  127.         $result = null;
  128.         if (isset($_POST["port"][$i + 1])) {
  129.             for ($j = 1; $j <= count($_POST["port"][$i + 1]); $j++) {
  130.                 if (isset($_POST["port"][$i + 1][$j - 1])) {
  131.                     $alias[$j] = $_POST["port"][$i + 1][$j - 1];
  132.                 } else {
  133.                     $alias[$j] = "";
  134.                 }
  135.             }
  136.         }
  137.         if (!empty($alias)) {
  138.             $result = json_encode($alias);
  139.         } else {
  140.             if ($_POST['typeLink'][$i] == "3") {
  141.                 for ($j = 1; $j <= $_POST['numberOfPorts'][$i]; $j++) {                                
  142.                     $alias[$j] = "";
  143.                 }
  144.                 $result = json_encode($alias);
  145.             }  
  146.         }
  147.         return $result;
  148.     }
  150.     /**
  151.      * @Route("/equipment/generic/list", name="equipment_generic_list")
  152.      */
  153.     public function listAction(Request $request, TranslatorInterface $translator)
  154.     {
  155.         //modified to exclude chassis module
  156.         $list = $this->getDoctrine()->getRepository(EquipmentGeneric::class)->findBy(["isModule" => false, "isModulaire" => false, "isChassisModule"=> false]);
  157.         // $em = $this->getDoctrine()->getManager();
  158.         // $queryBuilder = $em->createQueryBuilder()
  159.         // ->select('eqg')
  160.         // ->from('App\Entity\EquipmentGeneric', 'eqg')
  161.         // ->where("eqg.isModule = :isModule")
  162.         // ->andWhere("eqg.isModulaire = :isModulaire")
  163.         // ->setParameter("isModule", false)
  164.         // ->setParameter("isModulaire", false)
  165.         // ->orderBy("eqg.title", "ASC");
  166.         // $adapter = new DoctrineORMAdapter($queryBuilder);
  167.         // $pagerfanta = new Pagerfanta($adapter);
  168.         // $pageLength = $request->query->get("pageLength", $this->getParameter("eqg.maxPerPage"));
  169.         // if ($pageLength == "Tout") {
  170.         //   $qb = $em->createQueryBuilder()
  171.         //   ->select('COUNT(eqg.id)')
  172.         //   ->from('App\Entity\EquipmentGeneric', 'eqg')
  173.         //   ->where("eqg.isModule = :isModule")
  174.         //   ->andWhere("eqg.isModulaire = :isModulaire")
  175.         //   ->setParameter("isModule", false)
  176.         //   ->setParameter("isModulaire", false)
  177.         //   ->orderBy("eqg.title", "ASC");
  178.         //
  179.         //   $count = $qb->getQuery()->getSingleScalarResult();
  180.         //   $pagerfanta->setMaxPerPage($count); // 10 by default
  181.         // }
  182.         // else {
  183.         //   $pagerfanta->setMaxPerPage($pageLength); // 10 by default
  184.         // }
  185.         // $page = $request->query->get("page", 1);
  186.         // $pagerfanta->setCurrentPage($page);
  187.         return $this->render('equipment/generic_list.html.twig', [
  188.             'action' => 'list',
  189.             'page_title' => $translator->trans('Generic Equipment'),
  190.             'path_default' => 'equipment_generic_create',
  191.             'path_update' => 'equipment_generic_update',
  192.             'path_delete' => 'equipment_generic_delete',
  193.             'list' => $list,
  194.             // 'my_pager' => $pagerfanta,
  195.             // 'pageLength' => $pageLength,
  196.         ]);
  197.     }
  200.     /**
  201.      * @Route("/equipment/generic/edit/{id}", name="equipment_generic_update")
  202.      */
  203.     public function updateAction(Request $request, $id, TranslatorInterface $translator)
  204.     {
  206.         $user = $this->getUser();
  208.         $em = $this->getDoctrine()->getManager();
  209.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  210.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  212.         if ($specific) {
  213.             $inUse = 1;
  214.         } else {
  215.             $inUse = 0;
  216.         }
  218.         $current_no_interfaces = $eq->getNumberOfInterfaces();
  219.         $new_no_interfaces = $request->request->get('numberOfInterfaces');
  222.         // process form
  223.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  225.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  228.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  230.                 // DELETE OLD FRONT IMAGE
  231.                 $currentFrontImg = $eq->getFrontImage();
  232.                 if ($currentFrontImg) {
  233.                     unlink($upload_dir . $currentFrontImg);
  234.                 }
  236.                 // NEW FRONT IMAGE
  237.                 $uploadedImage = $_FILES['frontImage'];
  238.                 $file = $uploadedImage['tmp_name'];
  239.                 $path_parts = pathinfo($uploadedImage['name']);
  240.                 $extension = $path_parts['extension'];
  241.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  243.                 $fullPathImage = $upload_dir . $fileNameImg;
  245.                 move_uploaded_file($file, $fullPathImage);
  247.                 $eq->setFrontImage($fileNameImg);
  248.             }
  251.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  253.                 // DELETE OLD FRONT IMAGE
  254.                 $currentRearImg = $eq->getRearImage();
  255.                 if ($currentRearImg) {
  256.                     unlink($upload_dir . $currentRearImg);
  257.                 }
  259.                 // NEW REAR IMAGE
  260.                 $uploadedImage = $_FILES['rearImage'];
  261.                 $file = $uploadedImage['tmp_name'];
  262.                 $path_parts = pathinfo($uploadedImage['name']);
  263.                 $extension = $path_parts['extension'];
  264.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  266.                 $fullPathImage = $upload_dir . $fileNameImg;
  268.                 move_uploaded_file($file, $fullPathImage);
  270.                 $eq->setRearImage($fileNameImg);
  271.             }
  274.             $redirect = $request->request->get('redirect');
  276.             if ($specific) {
  278.                 $eq->setTitle($request->request->get('title'));
  279.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  281.                 if ($new_no_interfaces >= $current_no_interfaces) {
  283.                     $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  284.                 }
  286.                 $em->persist($eq);
  287.                 $em->flush();
  288.                 // $error = array('error' => 'title');
  290.                 if ($redirect == 0) {
  291.                     return $this->redirectToRoute('equipment_generic_list');
  292.                     // return $this->redirectToRoute('equipment_generic_list', $error);
  293.                 } else {
  294.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId()));
  295.                 }
  296.             } else {
  298.                 $eq->setTitle($request->request->get('title'));
  299.                 $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  300.                 $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  301.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  303.                 // delete generic interfaces
  304.                 if ($new_no_interfaces < $current_no_interfaces) {
  306.                     $i = 1;
  308.                     $interfaces = $eq->getInterfaceGeneric();
  310.                     foreach ($interfaces as $interface) {
  312.                         if ($i > $new_no_interfaces) {
  313.                             $em->remove($interface);
  314.                             $em->flush();
  315.                         }
  316.                         $i++;
  317.                     }
  318.                 }
  320.                 $em->persist($eq);
  321.                 $em->flush();
  323.                 if ($redirect == 0) {
  324.                     return $this->redirectToRoute('equipment_generic_list');
  325.                 } else {
  326.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId()));
  327.                 }
  328.             }
  329.         } else {
  331.             $em = $this->getDoctrine()->getManager();
  332.             $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  334.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  335.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  336.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  337.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  339.             return $this->render('equipment/generic_edit.html.twig', [
  340.                 'action' => 'process',
  341.                 'page_title' => $translator->trans('Generic Equipment'),
  342.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  343.                 'path_process' => 'equipment_generic_update_process',
  344.                 'typeLink' => $typeLink,
  345.                 'typeConnector' => $typeConnector,
  346.                 'typeEquipments' => $typeEquipments,
  347.                 'typeInterconnection' => $typeInterconnection,
  348.                 'eq' => $eq,
  349.                 'inUse' => $inUse
  350.             ]);
  351.         }
  352.     }
  355.     /**
  356.      * @Route("/equipment/generic/interfaces/edit/{id}", name="equipment_generic_interfaces_update")
  357.      */
  358.     public function updateInterfacesAction(Request $request, LoggerInterface $logger, $id, TranslatorInterface $translator)
  359.     {
  361.         $user = $this->getUser();
  363.         $em = $this->getDoctrine()->getManager();
  364.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  365.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  366.         $inUse = 0;
  367.         if ($specific) {
  368.             $inUse = 1;
  369.         } else {
  370.             $inUse = 0;
  371.         }
  373.         // process form
  374.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  376.             $em = $this->getDoctrine()->getManager();
  377.             $eq = $em->getRepository(EquipmentGeneric::class)->find($request->request->get('id'));
  379.             // find specific in usage
  380.             // $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  382.             // if ($specific){
  383.             //
  384.             //     $interfaces = $this->getDoctrine()->getRepository('App\Entity\InterfaceGeneric')->findByEquipmentGeneric($eq);
  385.             //     $nbIntTemp = count($interfaces);
  386.             //     //$current_interface_no = count($interfaces);
  387.             //     if (isset($_POST['interfaceNumber'])) {
  388.             //       $new_interface_no = count($_POST['interfaceNumber']);
  389.             //
  390.             //
  391.             //       if ($new_interface_no > 0){ // 1
  392.             //
  393.             //           for ($i = 0; $i < $new_interface_no; $i++){
  394.             //
  395.             //
  396.             //               $if = new InterfaceGeneric();
  397.             //
  398.             //               $if->setEquipmentGeneric($eq);
  399.             //               $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  400.             //               $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  401.             //               $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  402.             //               if (isset($_POST['typeConnector']) && isset($_POST['typeConnector'][$i])) {
  403.             //                 $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  404.             //               }
  405.             //               $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  406.             //
  407.             //               // if ($_POST['typeLink'][$i] == "3") {
  408.             //                 $alias = [];
  409.             //                 if (isset($_POST["port"][$nbIntTemp+1])) {
  410.             //                   for ($j = 1; $j<=count($_POST["port"][$nbIntTemp+1]); $j++){
  411.             //                     if (isset($_POST["port"][$nbIntTemp+1][$j-1])) {
  412.             //                       $alias[$j] = $_POST["port"][$nbIntTemp+1][$j-1];
  413.             //                     }
  414.             //                   }
  415.             //                 }
  416.             //
  417.             //
  418.             //                 if (!empty($alias)) {
  419.             //                     $alias = json_encode($alias);
  420.             //                     $alias = (string)$alias;
  421.             //                 } else {
  422.             //                     $alias = null;
  423.             //                 }
  424.             //
  425.             //                 $if->setAlias($alias);
  426.             //               // }
  427.             //               $em->persist($if);
  428.             //               $em->flush();
  429.             //
  430.             //               foreach ($specific as $eq_specific){
  431.             //
  432.             //                   $interfaceSpecific = new InterfaceSpecific();
  433.             //                   $interfaceSpecific->setEquipmentSpecific($eq_specific);
  434.             //                   $interfaceSpecific->setInterfaceGeneric($if);
  435.             //                   $alias = json_decode($if->getAlias(), true);
  436.             //                   $em->persist($interfaceSpecific);
  437.             //                   $em->flush();
  438.             //
  439.             //                   // create ports
  440.             //                   $numberOfPorts = $if->getNumberOfPorts();
  441.             //                   for ($k=1; $k<=$numberOfPorts; $k++){
  442.             //
  443.             //                       $port = new Port();
  444.             //                       $port->setInterfaceSpecific($interfaceSpecific);
  445.             //                       $port->setOrderNo($k);
  446.             //                       if ($alias) {
  447.             //                         $port->setAlias($alias[$k]);
  448.             //                       }
  449.             //                       $em->persist($port);
  450.             //                       $em->flush();
  451.             //
  452.             //                   }
  453.             //
  454.             //               }
  455.             //
  456.             //           }
  457.             //
  458.             //
  459.             //       }
  460.             //       else {
  461.             //         $error = array('error' => 'title');
  462.             //       }
  463.             //     }
  464.             //     if (strpos($request->query->get('ref'), "module") === 0 ) {
  465.             //
  466.             //       return $this->redirectToRoute('equipment_generic_module_list', $error);
  467.             //     }
  468.             //     else {
  469.             //       return $this->redirectToRoute('equipment_generic_list', $error);
  470.             //     }
  471.             //   }
  472.             //MODIFIED on 11 mars 2019
  473.             // $interfaceTemp = $this->getDoctrine()->getRepository('App\Entity\InterfaceGeneric')->findByEquipmentGeneric($eq);
  474.             // $nbIntTemp = count($interfaceTemp);
  475.             for ($i = 0; $i < count($_POST['interfaceNumber']); $i++) {
  476.                 // var_dump($_POST['interfaceId']);
  477.                 // $logger->info($_POST['interfaceId'][$i]);
  478.                 if (isset($_POST['interfaceId']) && $_POST['interfaceId'][$i]) {
  479.                     $if = $this->getDoctrine()->getRepository('App\Entity\InterfaceGeneric')->find($_POST['interfaceId'][$i]);
  480.                     // var_dump($if->getId());
  481.                     // $if->setEquipmentGeneric($eq);
  482.                     $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  483.                     $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  484.                     $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  485.                     if (isset($_POST['typeConnector']) && isset($_POST['typeConnector'][$i])) {
  486.                         $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  487.                     }
  488.                     $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  490.                     $if->setAlias($this->buildAlias($i));
  491.                     $em->persist($if);
  492.                     $em->flush();
  494.                     foreach ($specific as $eq_specific) {
  495.                         foreach ($eq_specific->getInterfaceSpecific() as $value) {
  496.                             if ($value->getInterfaceGeneric()->getId() == $if->getId()) {
  497.                                 $alias = json_decode($if->getAlias(), true);
  498.                                 $k = 1;
  499.                                 //ADDED on 11 avril 2019
  500.                                 $portsSpecific = $value->getPort();
  501.                                 $nbPortsGeneric = $value->getInterfaceGeneric()->getNumberOfPorts();
  502.                                 $nbPortsToAdd = $nbPortsGeneric - count($portsSpecific);
  503.                                 $portOrderNoInit = count($portsSpecific) + 1;
  504.                                 for ($m = 0; $m < $nbPortsToAdd; $m++) {
  505.                                     $port = new Port();
  506.                                     $port->setInterfaceSpecific($value);
  507.                                     $port->setOrderNo($portOrderNoInit);
  508.                                     $port->setAlias($alias[$portOrderNoInit++]);
  509.                                     $em->persist($port);
  510.                                     $em->flush();
  511.                                 }
  512.                                 //END ADDED on 11 avril 2019
  513.                                 foreach ($value->getPort() as $p) {
  515.                                     $p->setAlias($alias[$k]);
  516.                                     $k++;
  517.                                     $em->persist($p);
  518.                                     $em->flush();
  519.                                 }
  520.                             }
  521.                         }
  522.                     }
  523.                 } else {
  524.                     $if = new InterfaceGeneric();
  526.                     $if->setEquipmentGeneric($eq);
  527.                     $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  528.                     $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  529.                     $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  530.                     if (isset($_POST['typeConnector']) && isset($_POST['typeConnector'][$i])) {
  531.                         $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  532.                     }
  533.                     $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  534.                     $if->setAlias($this->buildAlias($i));
  535.                     $em->persist($if);
  536.                     $em->flush();
  537.                     foreach ($specific as $eq_specific) {
  538.                         $interfaceSpecific = new InterfaceSpecific();
  539.                         $interfaceSpecific->setEquipmentSpecific($eq_specific);
  540.                         $interfaceSpecific->setInterfaceGeneric($if);
  541.                         $alias = json_decode($if->getAlias(), true);
  542.                         $em->persist($interfaceSpecific);
  543.                         $em->flush();
  545.                         // create ports
  546.                         $numberOfPorts = $if->getNumberOfPorts();
  547.                         for ($k = 1; $k <= $numberOfPorts; $k++) {
  549.                             $port = new Port();
  550.                             $port->setInterfaceSpecific($interfaceSpecific);
  551.                             $port->setOrderNo($k);
  552.                             if ($alias) {
  553.                                 $port->setAlias($alias[$k]);
  554.                             }
  555.                             $em->persist($port);
  556.                             $em->flush();
  557.                         }
  558.                     }
  559.                 }
  560.             }
  561.             if (strpos($request->query->get('ref'), "module") === 0) {
  562.                 if (strpos($request->query->get('ref'), "moduleChassis") === 0) {
  563.                     return $this->redirectToRoute('equipment_generic_modulaire_update', array('id' => $eq->getChassisParent()->getId()));
  564.                 } else {
  565.                     return $this->redirectToRoute('equipment_generic_module_list');
  566.                 }
  567.             } else {
  568.                 return $this->redirectToRoute('equipment_generic_list');
  569.             }
  570.             // if (!$specific){
  571.             //
  572.             //     // remove existing interfaces
  573.             //     $interfaces = $this->getDoctrine()->getRepository('App\Entity\InterfaceGeneric')->findByEquipmentGeneric($eq);
  574.             //
  575.             //     foreach ($interfaces as $interface){
  576.             //
  577.             //         $em->remove($interface);
  578.             //         $em->flush();
  579.             //
  580.             //     }
  581.             //
  582.             //     // store interfaces
  583.             //     $inter_num = $eq->getNumberOfInterfaces();
  584.             //     for ($i = 0; $i < $inter_num; $i++){
  585.             //
  586.             //         $if = new InterfaceGeneric();
  587.             //
  588.             //         $if->setEquipmentGeneric($eq);
  589.             //         $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  590.             //         $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  591.             //         $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  592.             //         if (isset($_POST['typeConnector']) && isset($_POST['typeConnector'][$i])) {
  593.             //           $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  594.             //         }
  595.             //         $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  596.             //         // if ($_POST['typeLink'][$i] == "3") {
  597.             //           $alias = [];
  598.             //
  599.             //           for ($j = 1; $j<=count($_POST["port"][$i+1]); $j++){
  600.             //               $alias[$j] = $_POST["port"][$i+1][$j-1] ? $_POST["port"][$i+1][$j-1] : "";
  601.             //           }
  602.             //           //var_dump($alias);
  603.             //           if (!empty($alias)) {
  604.             //               $alias = json_encode($alias);
  605.             //               $alias = (string)$alias;
  606.             //           } else {
  607.             //               $alias = null;
  608.             //           }
  609.             //
  610.             //           $if->setAlias($alias);
  611.             //         // }
  612.             //         $em->persist($if);
  613.             //         $em->flush();
  614.             //
  615.             //     }
  616.             //     if (strpos($request->query->get('ref'), "module") === 0 ) {
  617.             //
  618.             //       return $this->redirectToRoute('equipment_generic_module_list');
  619.             //     }
  620.             //     else {
  621.             //       return $this->redirectToRoute('equipment_generic_list');
  622.             //     }
  623.             //
  624.             // }
  626.         } else {
  628.             // $em = $this->getDoctrine()->getManager();
  629.             // $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  631.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  632.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  633.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  635.             return $this->render('equipment/generic_edit_interfaces.html.twig', [
  636.                 'action' => 'process',
  637.                 'page_title' => $translator->trans('Generic Equipment Interfaces'),
  638.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  639.                 'path_process' => 'equipment_generic_update_process',
  640.                 'typeLink' => $typeLink,
  641.                 'typeConnector' => $typeConnector,
  642.                 'typeInterconnection' => $typeInterconnection,
  643.                 'eq' => $eq,
  644.                 'inUse' => $inUse,
  645.                 'ref' => $request->query->get('ref')
  646.             ]);
  647.         }
  648.     }
  651.     /**
  652.      * @Route("/equipment/generic/interfaces/setNports/{id}", name="equipment_generic_interfaces_setNports")
  653.      */
  654.     public function updateInterfacesSetNportsAction(Request $request, $id, TranslatorInterface $translator)
  655.     {
  657.         $user = $this->getUser();
  659.         $em = $this->getDoctrine()->getManager();
  660.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  661.         $interfaces = $this->getDoctrine()->getRepository('App\Entity\InterfaceGeneric')->findByEquipmentGeneric($eq);
  663.         // process form
  664.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  666.             foreach ($interfaces as $interface) {
  668.                 $intId = $interface->getId();
  669.                 $noOfPorts = $interface->getNumberOfPorts();
  670.                 $nPorts = [];
  672.                 for ($i = 1; $i <= $noOfPorts; $i++) {
  673.                     if (isset($_POST[$intId . '_' . $i])) {
  674.                         $nPorts[] = $i;
  675.                     }
  676.                 }
  678.                 if (!empty($nPorts)) {
  679.                     $nPorts = json_encode($nPorts);
  680.                     $nPorts = (string)$nPorts;
  681.                 } else {
  682.                     $nPorts = null;
  683.                 }
  685.                 $interface->setNPorts($nPorts);
  687.                 $em->persist($interface);
  688.                 $em->flush();
  689.             }
  691.             $error = [];
  693.             if (strpos($request->query->get('ref'), "module") === 0) {
  694.                 if (strpos($request->query->get('ref'), "moduleChassis") === 0) {
  695.                     return $this->redirectToRoute('equipment_generic_modulaire_update', array('id' => $eq->getChassisParent()->getId()));
  696.                 } else {
  697.                     return $this->redirectToRoute('equipment_generic_module_list', $error);
  698.                 }
  699.             } else {
  700.                 return $this->redirectToRoute('equipment_generic_list', $error);
  701.             }
  702.         } else {
  704.             foreach ($interfaces as $interface) {
  706.                 $nPorts = $interface->getNPorts();
  708.                 if ($nPorts) {
  709.                     $nPorts = json_decode($interface->getNPorts());
  710.                 } else {
  711.                     $nPorts = null;
  712.                 }
  714.                 $interface->setNPorts($nPorts);
  715.             }
  717.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  718.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  719.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  721.             return $this->render('equipment/generic_edit_interfaces_setNports.html.twig', [
  722.                 'action' => 'process',
  723.                 'page_title' => $translator->trans('Generic Equipment Interfaces'),
  724.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  725.                 'path_process' => 'equipment_generic_update_process',
  726.                 'typeLink' => $typeLink,
  727.                 'typeConnector' => $typeConnector,
  728.                 'typeInterconnection' => $typeInterconnection,
  729.                 'eq' => $eq,
  730.                 'interfaces' => $interfaces,
  731.                 'ref' => $request->query->get('ref')
  732.             ]);
  733.         }
  734.     }
  738.     /**
  739.      * @Route("/equipment/generic/interfaces/delete/{id}", name="equipment_generic_interfaces_delete")
  740.      */
  741.     public function deleteInterfacesAction(Request $request, LoggerInterface $logger, $id, TranslatorInterface $translator)
  742.     {
  744.         //return $this->json('processing...');
  745.         $user = $this->getUser();
  747.         $em = $this->getDoctrine()->getManager();
  748.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  750.         // process form
  751.         if ($request->request->has('action') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  753.             $em = $this->getDoctrine()->getManager();
  754.             $eq = $em->getRepository(EquipmentGeneric::class)->find($request->request->get('id'));
  756.             $numberOfInterfaces = $eq->getNumberOfInterfaces();
  758.             $interfacesGeneric = $eq->getInterfaceGeneric();
  760.             foreach ($interfacesGeneric as $interfaceGeneric) {
  762.                 $id = $interfaceGeneric->getId();
  764.                 if (isset($_POST['interface_' . $id])) {
  765.                     $eq->removeInterfaceGeneric($interfaceGeneric);
  766.                     $numberOfInterfaces--;
  767.                 }
  768.             }
  770.             $eq->setNumberOfInterfaces($numberOfInterfaces);
  771.             $em->persist($eq);
  772.             $em->flush();
  774.             if (strpos($request->query->get('ref'), "module") === 0) {
  776.                 return $this->redirectToRoute('equipment_generic_module_list');
  777.             } else {
  778.                 return $this->redirectToRoute('equipment_generic_list');
  779.             }
  780.         } else {
  781.             $em = $this->getDoctrine()->getManager();
  782.             $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  783.             if($eq != null) {
  784.                 $interfacesGeneric = $eq->getInterfaceGeneric();
  786.                 foreach ($interfacesGeneric as $interfaceGeneric) {
  787.     
  788.                     $interfaceGeneric->inUse = 0;
  789.     
  790.                     $interfacesSpecific = $interfaceGeneric->getInterfaceSpecific();
  791.                     foreach ($interfacesSpecific as $interfaceSpecific) {
  792.                         if ($interfaceGeneric->inUse == 1) {
  793.                             break;
  794.                         }
  795.                         $ports = $interfaceSpecific->getPort();
  796.     
  797.                         foreach ($ports as $port) {
  798.                             $logger->info($port->getId());
  799.                             $inUse = $this->isPortInUse($port);
  800.                             if ($inUse) {
  801.                                 $logger->info("inuse=1");
  802.                                 $interfaceGeneric->inUse = 1;
  803.                                 break;
  804.                             }
  805.                             //port externe
  806.                             else {
  807.                                 if ($port->getInterfaceSpecificPortExterne() != null) {
  808.                                     $ports = $port->getInterfaceSpecificPortExterne()->getPort();
  809.     
  810.                                     foreach ($ports as $port) {
  811.                                         $logger->info("Port externe :");
  812.                                         $logger->info($port->getId());
  813.                                         $inUse = $this->isPortInUse($port);
  814.                                         if ($inUse) {
  815.                                             $logger->info("inuse=1");
  816.                                             $interfaceGeneric->inUse = 1;
  817.                                             break;
  818.                                         }
  819.                                     }
  820.                                 }
  821.                                 if ($port->getPortMpo() != null && $port->getPortMpo()->getInterfaceSpecificPortExterne() != null) {
  822.                                     $ports = $port->getPortMpo()->getInterfaceSpecificPortExterne()->getPort();
  823.     
  824.                                     foreach ($ports as $port) {
  825.                                         $logger->info("Port MPO :");
  826.                                         $logger->info($port->getId());
  827.                                         $inUse = $this->isPortInUse($port);
  828.                                         if ($inUse) {
  829.                                             $logger->info("inuse=1");
  830.                                             $interfaceGeneric->inUse = 1;
  831.                                             break;
  832.                                         }
  833.                                     }
  834.                                 }
  835.                             }
  836.                         }
  837.                     }
  838.                 }
  839.             }
  840.             
  842.             // foreach ($interfacesGeneric as $interfaceGeneric){
  844.             //     $interfaceGeneric->inUse = 0;
  846.             //     $interfacesSpecific = $interfaceGeneric->getInterfaceSpecific();
  848.             //     foreach ($interfacesSpecific as $interfaceSpecific) {
  850.             //         $ports = $interfaceSpecific->getPort();
  852.             //         foreach ($ports as $port){
  854.             //             $usedAtrunk = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortA($port);
  855.             //             $usedBtrunk = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortB($port);
  856.             //             $usedExt = $this->getDoctrine()->getRepository('App\Entity\TrunkExtension')->findOneByPortB($port);
  857.             //             $usedALink = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByPortA($port);
  858.             //             $usedBLink = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByPortB($port);
  860.             //             if ($usedAtrunk || $usedBtrunk || $usedExt || $usedALink || $usedBLink){
  861.             //                 $interfaceGeneric->inUse = 1;
  862.             //             }
  864.             //         }
  866.             //     }
  868.             // }
  871.             return $this->render('equipment/generic_delete_interfaces.html.twig', [
  872.                 'page_title' => $translator->trans('Generic Equipment Interfaces'),
  873.                 'box_title' => '<i class="fa fa-trash fa-fw"></i> Delete',
  874.                 'eq' => $eq,
  875.                 'ref' => $request->query->get('ref')
  876.             ]);
  877.         }
  878.     }
  880.     private function isPortInUse($port)
  881.     {
  882.         $usedAtrunk = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortA($port);
  883.         $usedBtrunk = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortB($port);
  884.         $usedExt = $this->getDoctrine()->getRepository('App\Entity\TrunkExtension')->findOneByPortB($port);
  885.         $usedInLink = $this->getDoctrine()->getRepository('App\Entity\ExtensionOrder')->findOneByPort($port);
  886.         // $usedALink = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByPortA($port);
  887.         // if ($usedALink) {
  888.         //     $logger->info("usedALink :" . $usedALink->getId());
  889.         // }
  890.         // $usedBLink = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByPortB($port);
  891.         // if ($usedBLink) {
  892.         //     $logger->info("usedBLink :" . $usedBLink->getId());
  893.         // }
  894.         if ($usedAtrunk || $usedBtrunk || $usedExt || $usedInLink) {
  895.             return true;
  896.         }
  897.         return false;
  898.     }
  901.     /**
  902.      * @IsGranted("ROLE_CRUD")
  903.      * @Route("/equipment/generic/delete/{id}", name="equipment_generic_delete")
  904.      */
  905.     public function deleteAction(Request $request, $id, TranslatorInterface $translator)
  906.     {
  907.         $em = $this->getDoctrine()->getManager();
  908.         $equipmentGen = $em->getRepository(EquipmentGeneric::class)->find($id);
  910.         // find in usage
  911.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($equipmentGen);
  912.         if (!$specific) {
  913.             $conn = $em->getConnection();
  915.             $sql = "update equipment_generic set chassis_module_id=null where id = " . $equipmentGen->getId();
  916.             // $extIds = [$temp[0]->getExtremityA()->getId(), $temp[0]->getExtremityB()->getId()];
  917.             $stmt = $conn->prepare($sql);
  918.             $stmt->execute();
  920.             $sql = "delete from equipment_modulaire where module_id=" . $equipmentGen->getId() . " or parent_id=" . $equipmentGen->getId();
  921.             $stmt = $conn->prepare($sql);
  922.             $stmt->execute();
  923.             $em->remove($equipmentGen);
  924.             $em->flush();
  925.             $error = [];
  926.         } else {
  927.             $error = array('error' => 'usage');
  928.         }
  929.         if (strpos($request->headers->get('referer'), "module") == true) {
  931.             return $this->redirectToRoute('equipment_generic_module_list', $error);
  932.         } elseif (strpos($request->headers->get('referer'), "modulaire") == true) {
  933.             return $this->redirectToRoute('equipment_generic_modulaire_list', $error);
  934.         } else {
  935.             return $this->redirectToRoute('equipment_generic_list', $error);
  936.         }
  937.     }
  940.     /**
  941.      * @Route("/equipment/generic/module/create", name="equipment_generic_module_create")
  942.      */
  943.     public function createModuleAction(Request $request, TranslatorInterface $translator)
  944.     {
  946.         $user = $this->getUser();
  948.         // process form
  949.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  950.             // var_dump($request->request->all());
  951.             $em = $this->getDoctrine()->getManager();
  953.             $eq = new EquipmentGeneric();
  955.             $eq->setTitle($request->request->get('title'));
  956.             $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  957.             $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  958.             $eq->setIsModule(true);
  959.             $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  961.             foreach ($request->request->get('parent') as $key => $value) {
  962.                 // var_dump($value);
  963.                 $eq->addParent($this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->find($value));
  964.             }
  965.             // var_dump($request->request->get('parent'));
  967.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  969.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  971.                 // NEW FRONT IMAGE
  972.                 $uploadedImage = $_FILES['frontImage'];
  973.                 $file = $uploadedImage['tmp_name'];
  974.                 $path_parts = pathinfo($uploadedImage['name']);
  975.                 $extension = $path_parts['extension'];
  976.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  978.                 $fullPathImage = $upload_dir . $fileNameImg;
  980.                 move_uploaded_file($file, $fullPathImage);
  982.                 $eq->setFrontImage($fileNameImg);
  983.             }
  986.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  988.                 // NEW REAR IMAGE
  989.                 $uploadedImage = $_FILES['rearImage'];
  990.                 $file = $uploadedImage['tmp_name'];
  991.                 $path_parts = pathinfo($uploadedImage['name']);
  992.                 $extension = $path_parts['extension'];
  993.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  995.                 $fullPathImage = $upload_dir . $fileNameImg;
  997.                 move_uploaded_file($file, $fullPathImage);
  999.                 $eq->setRearImage($fileNameImg);
  1000.             }
  1003.             $em->persist($eq);
  1004.             $em->flush();
  1007.             // store interfaces
  1008.             $inter_num = $eq->getNumberOfInterfaces();
  1009.             for ($i = 0; $i < $inter_num; $i++) {
  1011.                 $if = new InterfaceGeneric();
  1013.                 $if->setEquipmentGeneric($eq);
  1014.                 $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  1015.                 $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  1016.                 $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  1017.                 // $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  1018.                 // $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  1019.                 if ($_POST['typeConnector'][$i]) {
  1020.                     $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  1021.                 }
  1022.                 if ($_POST['typeInterconnection'][$i]) {
  1023.                     $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  1024.                 } else {
  1025.                     $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById(1));
  1026.                 }
  1027.                 $if->setAlias($this->buildAlias($i));
  1028.                 $em->persist($if);
  1029.                 $em->flush();
  1030.             }
  1032.             return $this->redirectToRoute('equipment_generic_module_list');
  1034.             // show form
  1035.         } else {
  1037.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  1038.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  1039.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  1040.             $eqGenericModulaire = $this->getDoctrine()->getRepository(EquipmentGeneric::class)->findBy(["isModulaire" => true], ['title' => 'ASC']);
  1041.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  1043.             return $this->render('equipment/module_create.html.twig', [
  1044.                 'action' => 'insert',
  1045.                 'page_title' => $translator->trans('Generic Equipment'),
  1046.                 'box_title' => '<i class="fa fa-plus-circle fa-fw"></i>' . $translator->trans('Add new'),
  1047.                 'typeLink' => $typeLink,
  1048.                 'typeConnector' => $typeConnector,
  1049.                 'typeEquipments' => $typeEquipments,
  1050.                 'typeInterconnection' => $typeInterconnection,
  1051.                 'eqGenericModulaireList' => $eqGenericModulaire
  1052.             ]);
  1053.         }
  1054.     }
  1056.     /**
  1057.      * @Route("/equipment/generic/module/list", name="equipment_generic_module_list")
  1058.      */
  1059.     public function listModuleAction(Request $request, TranslatorInterface $translator)
  1060.     {
  1062.         $list = $this->getDoctrine()->getRepository(EquipmentGeneric::class)->findBy(["isModule" => true]);
  1063.         // $em = $this->getDoctrine()->getManager();
  1064.         // $queryBuilder = $em->createQueryBuilder()
  1065.         // ->select('eqg')
  1066.         // ->from('App\Entity\EquipmentGeneric', 'eqg')
  1067.         // ->where("eqg.isModule = :isModule")
  1068.         // ->setParameter("isModule", true)
  1069.         // ->orderBy("eqg.title", "ASC");
  1070.         // $adapter = new DoctrineORMAdapter($queryBuilder);
  1071.         // $pagerfanta = new Pagerfanta($adapter);
  1072.         // $pageLength = $request->query->get("pageLength", $this->getParameter("eqg.maxPerPage"));
  1073.         // if ($pageLength == "Tout") {
  1074.         //   $qb = $em->createQueryBuilder()
  1075.         //   ->select('COUNT(eqg.id)')
  1076.         //   ->from('App\Entity\EquipmentGeneric', 'eqg')
  1077.         //   ->where("eqg.isModule = :isModule")
  1078.         //   ->setParameter("isModule", true)
  1079.         //   ->orderBy("eqg.title", "ASC");
  1080.         //
  1081.         //   $count = $qb->getQuery()->getSingleScalarResult();
  1082.         //   $pagerfanta->setMaxPerPage($count); // 10 by default
  1083.         // }
  1084.         // else {
  1085.         //   $pagerfanta->setMaxPerPage($pageLength); // 10 by default
  1086.         // }
  1087.         // $page = $request->query->get("page", 1);
  1088.         // $pagerfanta->setCurrentPage($page);
  1089.         return $this->render('equipment/module_list.html.twig', [
  1090.             'action' => 'list',
  1091.             'page_title' => $translator->trans('Equipement Générique Module'),
  1092.             'path_default' => 'equipment_generic_module_create',
  1093.             'path_show_equipement' => 'module_show_equipement_specifique',
  1094.             'path_update' => 'equipment_generic_module_update',
  1095.             'path_delete' => 'equipment_generic_delete',
  1096.             'list' => $list,
  1097.             // 'my_pager' => $pagerfanta,
  1098.             // 'pageLength' => $pageLength,
  1099.         ]);
  1100.     }
  1101.     /**
  1102.      * @Route("/equipment/generic/module/list/equipement/{id}", name="module_show_equipement_specifique")
  1103.      */
  1104.     public function listEquipementModuleAction(Request $request, $id, TranslatorInterface $translator)
  1105.     {
  1106.         $eqGenerics = $this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->findBy(["isModule" => false, "isModulaire" => false]);
  1107.         $tempRack = $this->getDoctrine()->getRepository('App\Entity\Rack')->findOneByTitle("Temp");
  1108.         $eqModulaires = $this->getDoctrine()->getRepository('App\Entity\EquipmentSpecific')->findBy(["rack" => $tempRack, "isModulaire" => true]);
  1109.         $racks = $this->getDoctrine()->getRepository('App\Entity\Rack')->findAll();
  1110.         $rackFaces = $this->getDoctrine()->getRepository('App\Entity\RackFace')->findAll();
  1112.         // $list = $this->getDoctrine()->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($id);
  1113.         $list = $this->getDoctrine()->getRepository(EquipmentSpecific::class)->findEquipmentsModulaireByEquipmentGeneric($id);
  1114.         $listEqs = array();
  1115.         foreach ($list as $eq) {
  1116.             $listEqs[] = $this->getDoctrine()->getRepository('App\Entity\EquipmentSpecific')->find($eq['id']);
  1117.         }
  1118.         return $this->render('equipment/specific_modulaire_list.html.twig', [
  1119.             'action' => 'list',
  1120.             'page_title' => $translator->trans('Liste des équipements spécifique'),
  1121.             'path_show_equipement' => 'module_show_equipement_specifique',
  1122.             'path_default' => 'equipment_specific_create',
  1123.             'path_update' => 'equipment_specific_update',
  1124.             'path_delete' => 'equipment_specific_delete',
  1125.             'eqGenerics' => $eqGenerics,
  1126.             'eqModulaires' => $eqModulaires,
  1127.             'list' => $listEqs,
  1128.             'racks'=> $racks,
  1129.             'rackFaces'=> $rackFaces
  1130.         ]);
  1131.     }
  1133.     /**
  1134.      * @Route("/equipment/generic/module/edit/{id}", name="equipment_generic_module_update")
  1135.      */
  1136.     public function updateModuleAction(Request $request, $id, TranslatorInterface $translator)
  1137.     {
  1139.         $user = $this->getUser();
  1140.         $error = array();
  1142.         $em = $this->getDoctrine()->getManager();
  1143.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1144.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  1146.         if ($specific) {
  1147.             $inUse = 1;
  1148.         } else {
  1149.             $inUse = 0;
  1150.         }
  1152.         $current_no_interfaces = $eq->getNumberOfInterfaces();
  1153.         $new_no_interfaces = $request->request->get('numberOfInterfaces');
  1156.         // process form
  1157.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  1159.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  1162.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  1164.                 // DELETE OLD FRONT IMAGE
  1165.                 $currentFrontImg = $eq->getFrontImage();
  1166.                 if ($currentFrontImg) {
  1167.                     unlink($upload_dir . $currentFrontImg);
  1168.                 }
  1170.                 // NEW FRONT IMAGE
  1171.                 $uploadedImage = $_FILES['frontImage'];
  1172.                 $file = $uploadedImage['tmp_name'];
  1173.                 $path_parts = pathinfo($uploadedImage['name']);
  1174.                 $extension = $path_parts['extension'];
  1175.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1177.                 $fullPathImage = $upload_dir . $fileNameImg;
  1179.                 move_uploaded_file($file, $fullPathImage);
  1181.                 $eq->setFrontImage($fileNameImg);
  1182.             }
  1185.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  1187.                 // DELETE OLD FRONT IMAGE
  1188.                 $currentRearImg = $eq->getRearImage();
  1189.                 if ($currentRearImg) {
  1190.                     unlink($upload_dir . $currentRearImg);
  1191.                 }
  1193.                 // NEW REAR IMAGE
  1194.                 $uploadedImage = $_FILES['rearImage'];
  1195.                 $file = $uploadedImage['tmp_name'];
  1196.                 $path_parts = pathinfo($uploadedImage['name']);
  1197.                 $extension = $path_parts['extension'];
  1198.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1200.                 $fullPathImage = $upload_dir . $fileNameImg;
  1202.                 move_uploaded_file($file, $fullPathImage);
  1204.                 $eq->setRearImage($fileNameImg);
  1205.             }
  1208.             $redirect = $request->request->get('redirect');
  1210.             if ($specific) {
  1212.                 $eq->setTitle($request->request->get('title'));
  1213.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  1215.                 if ($new_no_interfaces >= $current_no_interfaces) {
  1217.                     $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  1218.                 }
  1219.                 $parIds = array();
  1220.                 foreach ($eq->getParents() as $parent) {
  1221.                     $parIds[] = $parent->getId();
  1222.                 }
  1223.                 $newParIds = array();
  1224.                 foreach ($request->request->get('parent') as $key => $value) {
  1225.                     // var_dump($value);
  1226.                     $newParIds[] = $value;
  1227.                     $eq->addParent($this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->find($value));
  1228.                 }
  1229.                 $parToDelete = array_diff($parIds, $newParIds);
  1230.                 foreach ($parToDelete as $par) {
  1231.                     $tmpError = array();
  1232.                     $tempSpe = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($par);
  1233.                     foreach ($tempSpe as $tmp) {
  1234.                         foreach ($tmp->getModules() as $tmpMod) {
  1235.                             if ($tmpMod->getEquipmentGeneric()->getId() == $id) {
  1236.                                 $tmpError = array('error' => 'title');
  1237.                                 break;
  1238.                             }
  1239.                         }
  1240.                         if (count($tmpError) > 0) {
  1241.                             break;
  1242.                         }
  1243.                     }
  1244.                     if (count($tmpError) == 0) {
  1245.                         $conn = $em->getConnection();
  1246.                         $sql = "delete from equipment_modulaire where parent_id=" . $par . " and module_id=" . $id;
  1247.                         $stmt = $conn->prepare($sql);
  1248.                         $stmt->execute();
  1249.                     } else {
  1250.                         $error = array('error' => 'title');
  1251.                     }
  1252.                 }
  1253.                 $em->persist($eq);
  1254.                 $em->flush();
  1255.                 // $error = array('error' => 'title');
  1257.                 if ($redirect == 0) {
  1258.                     return $this->redirectToRoute('equipment_generic_module_list', $error);
  1259.                 } else {
  1260.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId(), 'ref' => 'module'));
  1261.                 }
  1262.             } else {
  1264.                 $eq->setTitle($request->request->get('title'));
  1265.                 $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  1266.                 $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  1267.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  1269.                 //delete all the Parents
  1270.                 $conn = $em->getConnection();
  1271.                 $sql = "delete from equipment_modulaire where module_id=" . $id;
  1272.                 $stmt = $conn->prepare($sql);
  1273.                 $stmt->execute();
  1274.                 foreach ($request->request->get('parent') as $key => $value) {
  1275.                     // var_dump($value);
  1276.                     $eq->addParent($this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->find($value));
  1277.                 }
  1278.                 // delete generic interfaces
  1279.                 if ($new_no_interfaces < $current_no_interfaces) {
  1281.                     $i = 1;
  1283.                     $interfaces = $eq->getInterfaceGeneric();
  1285.                     foreach ($interfaces as $interface) {
  1287.                         if ($i > $new_no_interfaces) {
  1288.                             $em->remove($interface);
  1289.                             $em->flush();
  1290.                         }
  1291.                         $i++;
  1292.                     }
  1293.                 }
  1295.                 $em->persist($eq);
  1296.                 $em->flush();
  1298.                 if ($redirect == 0) {
  1299.                     return $this->redirectToRoute('equipment_generic_module_list');
  1300.                 } else {
  1301.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId(), 'ref' => 'module'));
  1302.                 }
  1303.             }
  1304.         } else {
  1306.             $em = $this->getDoctrine()->getManager();
  1307.             $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1309.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  1310.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  1311.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  1312.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  1313.             $eqCurrentParents = $eq->getParents();
  1314.             $eqGenericModulaireTemp = $this->getDoctrine()->getRepository(EquipmentGeneric::class)->findBy(["isModulaire" => true], ['title' => 'ASC']);
  1315.             $eqGenericModulaire = array_filter($eqGenericModulaireTemp, function ($eq) use ($eqCurrentParents) {
  1316.                 foreach ($eqCurrentParents as $parent) {
  1317.                     if ($eq->getId() == $parent->getId()) {
  1318.                         return false;
  1319.                     }
  1320.                 }
  1321.                 return true;
  1322.             });
  1323.             return $this->render('equipment/generic_module_edit.html.twig', [
  1324.                 'action' => 'process',
  1325.                 'page_title' => $translator->trans('Generic Equipment'),
  1326.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  1327.                 'path_process' => 'equipment_generic_module_update',
  1328.                 'typeLink' => $typeLink,
  1329.                 'typeConnector' => $typeConnector,
  1330.                 'typeEquipments' => $typeEquipments,
  1331.                 'typeInterconnection' => $typeInterconnection,
  1332.                 'eq' => $eq,
  1333.                 'inUse' => $inUse,
  1334.                 'eqGenericModulaireList' => $eqGenericModulaire,
  1335.                 "eqCurrentParents" => $eqCurrentParents
  1336.             ]);
  1337.         }
  1338.     }
  1340.     /**
  1341.      * @Route("/equipment/generic/modulaire/create", name="equipment_generic_modulaire_create")
  1342.      */
  1343.     public function createModulaireAction(Request $request, TranslatorInterface $translator)
  1344.     {
  1346.         $user = $this->getUser();
  1348.         // process form
  1349.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  1351.             $em = $this->getDoctrine()->getManager();
  1353.             $eq = new EquipmentGeneric();
  1355.             $eq->setTitle($request->request->get('title'));
  1356.             $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  1357.             $eq->setNumberOfSlots($request->request->get('numberOfSlots'));
  1358.             $eq->setIsModulaire(true);
  1359.             $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  1361.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  1363.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  1365.                 // NEW FRONT IMAGE
  1366.                 $uploadedImage = $_FILES['frontImage'];
  1367.                 $file = $uploadedImage['tmp_name'];
  1368.                 $path_parts = pathinfo($uploadedImage['name']);
  1369.                 $extension = $path_parts['extension'];
  1370.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1372.                 $fullPathImage = $upload_dir . $fileNameImg;
  1374.                 move_uploaded_file($file, $fullPathImage);
  1376.                 $eq->setFrontImage($fileNameImg);
  1377.             }
  1380.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  1382.                 // NEW REAR IMAGE
  1383.                 $uploadedImage = $_FILES['rearImage'];
  1384.                 $file = $uploadedImage['tmp_name'];
  1385.                 $path_parts = pathinfo($uploadedImage['name']);
  1386.                 $extension = $path_parts['extension'];
  1387.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1389.                 $fullPathImage = $upload_dir . $fileNameImg;
  1391.                 move_uploaded_file($file, $fullPathImage);
  1393.                 $eq->setRearImage($fileNameImg);
  1394.             }
  1395.             if ($request->request->get('moduleChassis')) {
  1396.                 $chassisModule = new EquipmentGeneric();
  1398.                 $chassisModule->setTitle($request->request->get('moduleTitle'));
  1399.                 $chassisModule->setNumberOfUnits(1);
  1400.                 $chassisModule->setNumberOfInterfaces($request->request->get('moduleNumberOfInterfaces'));
  1401.                 $chassisModule->setIsChassisModule(true);
  1402.                 $eq->setChassisModule($chassisModule);
  1403.                 $em->persist($eq);
  1404.                 // store interfaces
  1405.                 $inter_num = $chassisModule->getNumberOfInterfaces();
  1406.                 for ($i = 0; $i < $inter_num; $i++) {
  1408.                     $if = new InterfaceGeneric();
  1410.                     $if->setEquipmentGeneric($chassisModule);
  1411.                     $if->setInterfaceNumber($_POST['interfaceNumber'][$i]);
  1412.                     $if->setNumberOfPorts($_POST['numberOfPorts'][$i]);
  1413.                     $if->setTypeLink($this->getDoctrine()->getRepository('App\Entity\TypeLink')->findOneById($_POST['typeLink'][$i]));
  1414.                     // $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  1415.                     // $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  1416.                     if ($_POST['typeConnector'][$i]) {
  1417.                         $if->setTypeConnector($this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findOneById($_POST['typeConnector'][$i]));
  1418.                     }
  1419.                     if ($_POST['typeInterconnection'][$i]) {
  1420.                         $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById($_POST['typeInterconnection'][$i]));
  1421.                     } else {
  1422.                         $if->setTypeInterconnection($this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findOneById(1));
  1423.                     }
  1424.                     $if->setAlias($this->buildAlias($i));
  1425.                     $em->persist($if);
  1426.                     $em->flush();
  1427.                 }
  1428.             }
  1429.             else{
  1430.                 $em->persist($eq);
  1431.             }
  1432.             $em->flush();
  1434.             return $this->redirectToRoute('equipment_generic_modulaire_list');
  1436.             // show form
  1437.         } else {
  1438.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  1439.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  1440.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  1441.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  1443.             return $this->render('equipment/modulaire_create.html.twig', [
  1444.                 'action' => 'insert',
  1445.                 'page_title' => $translator->trans('Equipement Générique Modulaire'),
  1446.                 'box_title' => '<i class="fa fa-plus-circle fa-fw"></i>' . $translator->trans('Add new'),
  1447.                 'typeLink' => $typeLink,
  1448.                 'typeConnector' => $typeConnector,
  1449.                 'typeEquipments' => $typeEquipments,
  1450.                 'typeInterconnection' => $typeInterconnection,
  1451.             ]);
  1452.         }
  1453.     }
  1455.     /**
  1456.      * @Route("/equipment/generic/modulaire/list", name="equipment_generic_modulaire_list")
  1457.      */
  1458.     public function listModulaireAction(Request $request, TranslatorInterface $translator)
  1459.     {
  1460.         $list = $this->getDoctrine()->getRepository(EquipmentGeneric::class)->findBy(["isModulaire" => true]);
  1461.         // $em = $this->getDoctrine()->getManager();
  1462.         // $queryBuilder = $em->createQueryBuilder()
  1463.         // ->select('eqg')
  1464.         // ->from('App\Entity\EquipmentGeneric', 'eqg')
  1465.         // ->where("eqg.isModulaire = :isModulaire")
  1466.         // ->setParameter("isModulaire", true)
  1467.         // ->orderBy("eqg.title", "ASC");
  1468.         // $adapter = new DoctrineORMAdapter($queryBuilder);
  1469.         // $pagerfanta = new Pagerfanta($adapter);
  1470.         // $pageLength = $request->query->get("pageLength", $this->getParameter("eqg.maxPerPage"));
  1471.         // if ($pageLength == "Tout") {
  1472.         //   $qb = $em->createQueryBuilder()
  1473.         //   ->select('COUNT(eqg.id)')
  1474.         //   ->from('App\Entity\EquipmentGeneric', 'eqg')
  1475.         //   ->where("eqg.isModulaire = :isModulaire")
  1476.         //   ->setParameter("isModulaire", true)
  1477.         //   ->orderBy("eqg.title", "ASC");
  1478.         //
  1479.         //   $count = $qb->getQuery()->getSingleScalarResult();
  1480.         //   $pagerfanta->setMaxPerPage($count); // 10 by default
  1481.         // }
  1482.         // else {
  1483.         //   $pagerfanta->setMaxPerPage($pageLength); // 10 by default
  1484.         // }
  1485.         // $page = $request->query->get("page", 1);
  1486.         // $pagerfanta->setCurrentPage($page);
  1487.         return $this->render('equipment/modulaire_list.html.twig', [
  1488.             'action' => 'list',
  1489.             'page_title' => $translator->trans('Equipement Générique Modulaire'),
  1490.             'path_default' => 'equipment_generic_modulaire_create',
  1491.             'path_update' => 'equipment_generic_modulaire_update',
  1492.             'path_delete' => 'equipment_generic_delete',
  1493.             'list' => $list,
  1494.             // 'my_pager' => $pagerfanta,
  1495.             // 'pageLength' => $pageLength,
  1496.         ]);
  1497.     }
  1499.     /**
  1500.      * @Route("/equipment/generic/modulaire/edit/{id}", name="equipment_generic_modulaire_update")
  1501.      */
  1502.     public function updateModulaireAction(Request $request, $id, TranslatorInterface $translator)
  1503.     {
  1505.         $user = $this->getUser();
  1507.         $em = $this->getDoctrine()->getManager();
  1508.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1509.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  1511.         if ($specific) {
  1512.             $inUse = 1;
  1513.         } else {
  1514.             $inUse = 0;
  1515.         }
  1517.         $current_no_slots = $eq->getNumberOfSlots();
  1518.         $new_no_slots = $request->request->get('numberOfSlots');
  1521.         // process form
  1522.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  1524.             $upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/';
  1527.             if (is_uploaded_file($_FILES['frontImage']['tmp_name'])) {
  1529.                 // DELETE OLD FRONT IMAGE
  1530.                 $currentFrontImg = $eq->getFrontImage();
  1531.                 if ($currentFrontImg) {
  1532.                     unlink($upload_dir . $currentFrontImg);
  1533.                 }
  1535.                 // NEW FRONT IMAGE
  1536.                 $uploadedImage = $_FILES['frontImage'];
  1537.                 $file = $uploadedImage['tmp_name'];
  1538.                 $path_parts = pathinfo($uploadedImage['name']);
  1539.                 $extension = $path_parts['extension'];
  1540.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1542.                 $fullPathImage = $upload_dir . $fileNameImg;
  1544.                 move_uploaded_file($file, $fullPathImage);
  1546.                 $eq->setFrontImage($fileNameImg);
  1547.             }
  1550.             if (is_uploaded_file($_FILES['rearImage']['tmp_name'])) {
  1552.                 // DELETE OLD FRONT IMAGE
  1553.                 $currentRearImg = $eq->getRearImage();
  1554.                 if ($currentRearImg) {
  1555.                     unlink($upload_dir . $currentRearImg);
  1556.                 }
  1558.                 // NEW REAR IMAGE
  1559.                 $uploadedImage = $_FILES['rearImage'];
  1560.                 $file = $uploadedImage['tmp_name'];
  1561.                 $path_parts = pathinfo($uploadedImage['name']);
  1562.                 $extension = $path_parts['extension'];
  1563.                 $fileNameImg = md5(uniqid()) . '.' . $extension;
  1565.                 $fullPathImage = $upload_dir . $fileNameImg;
  1567.                 move_uploaded_file($file, $fullPathImage);
  1569.                 $eq->setRearImage($fileNameImg);
  1570.             }
  1573.             $redirect = $request->request->get('redirect');
  1575.             if ($specific) {
  1577.                 $eq->setTitle($request->request->get('title'));
  1578.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  1581.                 if ($new_no_slots >= $current_no_slots) {
  1583.                     $eq->setNumberOfSlots($request->request->get('numberOfSlots'));
  1584.                 }
  1586.                 $em->persist($eq);
  1587.                 $em->flush();
  1588.                 $error = array('error' => 'title');
  1589.                 if ($redirect == 0) {
  1590.                     return $this->redirectToRoute('equipment_generic_modulaire_list', $error);
  1591.                 }
  1592.                 // return $this->redirectToRoute('equipment_generic_modulaire_list');
  1594.             } else {
  1596.                 $eq->setTitle($request->request->get('title'));
  1597.                 $eq->setNumberOfUnits($request->request->get('numberOfUnits'));
  1598.                 $eq->setNumberOfSlots($request->request->get('numberOfSlots'));
  1599.                 $eq->setType($this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findOneById($request->request->get('typeEquipment')));
  1601.                 $em->persist($eq);
  1602.                 $em->flush();
  1604.                 if ($redirect == 0) {
  1605.                     return $this->redirectToRoute('equipment_generic_modulaire_list');
  1606.                 }
  1607.             }
  1608.         } else {
  1610.             $em = $this->getDoctrine()->getManager();
  1611.             $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1612.             $typeEquipments = $this->getDoctrine()->getRepository('App\Entity\TypeEquipment')->findAll();
  1613.             return $this->render('equipment/generic_modulaire_edit.html.twig', [
  1614.                 'action' => 'process',
  1615.                 'page_title' => $translator->trans('Equipement générique modulaire'),
  1616.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  1617.                 'path_process' => 'equipment_generic_modulaire_update',
  1618.                 'path_update_chassis_module' => 'chassis_module_update',
  1619.                 'path_delete_chassis_module' => 'chassis_module_delete',
  1620.                 'eq' => $eq,
  1621.                 'typeEquipments' => $typeEquipments,
  1622.                 'inUse' => $inUse
  1623.             ]);
  1624.         }
  1625.     }
  1627.     /**
  1628.      * @Route("/equipment/generic/chassis/module/edit/{id}", name="chassis_module_update")
  1629.      */
  1630.     public function updateChassisModuleAction(Request $request, $id, TranslatorInterface $translator)
  1631.     {
  1633.         $user = $this->getUser();
  1634.         $error = array();
  1636.         $em = $this->getDoctrine()->getManager();
  1637.         $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1638.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($eq);
  1640.         if ($specific) {
  1641.             $inUse = 1;
  1642.         } else {
  1643.             $inUse = 0;
  1644.         }
  1646.         $current_no_interfaces = $eq->getNumberOfInterfaces();
  1647.         $new_no_interfaces = $request->request->get('numberOfInterfaces');
  1650.         // process form
  1651.         if ($request->request->has('title') && ($user->hasRole("ROLE_SUPER_ADMIN") || $user->hasRole("ROLE_ADMIN"))) {
  1653.             $redirect = $request->request->get('redirect');
  1655.             if ($specific) {
  1657.                 $eq->setTitle($request->request->get('title'));
  1659.                 if ($new_no_interfaces >= $current_no_interfaces) {
  1661.                     $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  1662.                 }
  1663.                 $em->persist($eq);
  1664.                 $em->flush();
  1665.                 // $error = array('error' => 'title');
  1667.                 if ($redirect == 0) {
  1668.                     return $this->redirectToRoute('equipment_generic_modulaire_update', array('id' => $eq->getChassisParent()->getId()));
  1669.                 } else {
  1670.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId(), 'ref' => 'moduleChassis'));
  1671.                 }
  1672.             } else {
  1674.                 $eq->setTitle($request->request->get('title'));
  1675.                 $eq->setNumberOfInterfaces($request->request->get('numberOfInterfaces'));
  1677.                 // delete generic interfaces
  1678.                 if ($new_no_interfaces < $current_no_interfaces) {
  1680.                     $i = 1;
  1682.                     $interfaces = $eq->getInterfaceGeneric();
  1684.                     foreach ($interfaces as $interface) {
  1686.                         if ($i > $new_no_interfaces) {
  1687.                             $em->remove($interface);
  1688.                             $em->flush();
  1689.                         }
  1690.                         $i++;
  1691.                     }
  1692.                 }
  1694.                 $em->persist($eq);
  1695.                 $em->flush();
  1697.                 if ($redirect == 0) {
  1698.                     return $this->redirectToRoute('equipment_generic_modulaire_update', array('id' => $eq->getChassisParent()->getId()));
  1699.                 } else {
  1700.                     return $this->redirectToRoute('equipment_generic_interfaces_update', array('id' => $eq->getId(), 'ref' => 'moduleChassis'));
  1701.                 }
  1702.             }
  1703.         } else {
  1705.             $em = $this->getDoctrine()->getManager();
  1706.             $eq = $em->getRepository(EquipmentGeneric::class)->find($id);
  1708.             $typeLink = $this->getDoctrine()->getRepository('App\Entity\TypeLink')->findAll();
  1709.             $typeConnector = $this->getDoctrine()->getRepository('App\Entity\TypeConnector')->findAll();
  1710.             $typeInterconnection = $this->getDoctrine()->getRepository('App\Entity\TypeInterconnection')->findAll();
  1712.             return $this->render('equipment/chassis_module_edit.html.twig', [
  1713.                 'action' => 'process',
  1714.                 'page_title' => $translator->trans('Chassis Module'),
  1715.                 'box_title' => '<i class="fa fa-edit fa-fw"></i> ' . $translator->trans('Edit'),
  1716.                 'path_process' => 'chassis_module_update',
  1717.                 'typeLink' => $typeLink,
  1718.                 'typeConnector' => $typeConnector,
  1719.                 'typeInterconnection' => $typeInterconnection,
  1720.                 'eq' => $eq,
  1721.                 'inUse' => $inUse
  1722.             ]);
  1723.         }
  1724.     }
  1726.     /**
  1727.      * @IsGranted("ROLE_CRUD")
  1728.      * @Route("/equipment/generic/chassis/module/delete/{id}", name="chassis_module_delete")
  1729.      */
  1730.     public function deleteChassisModuleAction(Request $request, $id, TranslatorInterface $translator)
  1731.     {
  1732.         $em = $this->getDoctrine()->getManager();
  1733.         $equipmentGen = $em->getRepository(EquipmentGeneric::class)->find($id);
  1734.         $chassisId = $equipmentGen->getChassisParent()->getId();
  1735.         // find in usage
  1736.         $error = ['id' => $chassisId];
  1737.         $specific = $em->getRepository(EquipmentSpecific::class)->findByEquipmentGeneric($equipmentGen);
  1738.         if (!$specific) {
  1739.             $em->remove($equipmentGen);
  1740.             $em->flush();
  1741.         } else {
  1742.             $error = array('id' => $chassisId, 'error' => 'usage');
  1743.         }
  1744.         return $this->redirectToRoute('equipment_generic_modulaire_update', $error);
  1745.     }
  1747.     /**
  1748.      * @Route("/equipment/generic/findTitleDuplicate", name="ajax_find_generic_title")
  1749.      */
  1750.     public function findTitleDuplicate()
  1751.     {
  1752.         $eq = $this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->findOneByTitle($_POST['title']);
  1753.         if ($eq) {
  1754.             $response = 1;
  1755.         } else {
  1756.             $response = 0;
  1757.         }
  1758.         return $this->json($response);
  1759.     }
  1761.     /**
  1762.      * @Route("/equipment/generic/findTitleDuplicateOther", name="ajax_find_generic_title_other")
  1763.      */
  1764.     public function findTitleDuplicateOther()
  1765.     {
  1766.         $response = $this->getDoctrine()->getRepository('App\Entity\EquipmentGeneric')->findTitleDuplicateOther($_POST['title'], $_POST['id']);
  1767.         return $this->json($response);
  1768.     }
  1769. }