src/Controller/StatController.php line 40

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  10. use \PhpOffice\PhpSpreadsheet\Spreadsheet;
  11. use \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
  12. use \PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  13. use Symfony\Component\Filesystem\Filesystem;
  14. use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  15. use Symfony\Contracts\Translation\TranslatorInterface;
  16. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  18. class StatController  extends AbstractController
  19. {
  20.     /**
  21.      * @IsGranted("ROLE_CRUD")
  22.      * @Route("/stats/synthese-equipement", name="stats_synthese_equipement")
  23.      */
  24.     public function syntheseEquipmentAction(TranslatorInterface $translator)
  25.   {
  26.         ini_set("memory_limit", "-1");
  27.         set_time_limit(0);
  28.         ini_set('default_socket_timeout', 600);
  29.         // print " ";
  30.         $sites = @$this->getUsedPortCount();
  31.         return $this->render('Stat/synthese_equipment.html.twig', array(
  32.             "sites"=>$sites,
  33.             'page_title' => $translator->trans('Synthèse Equipements'),
  34.         ));
  35.     }
  36.     /**
  37.      * @IsGranted("ROLE_CRUD")
  38.      * @Route("/stats/synthese-armoire", name="stats_synthese_rack")
  39.      */
  40.     public function syntheseRackAction(TranslatorInterface $translator)
  41.   {
  42.         ini_set("memory_limit", "-1");
  43.         set_time_limit(0);
  44.         ini_set('default_socket_timeout', 600);
  46.         // print " ";
  47.         $sites = @$this->getUsedPortCount();
  48.         return $this->render('Stat/synthese_rack.html.twig', array(
  49.             "sites"=>$sites,
  50.             'page_title' => $translator->trans('Synthèse Armoires'),
  51.         ));
  52.     }
  54.     /**
  55.      * @IsGranted("ROLE_CRUD")
  56.      * @Route("/stats/synthese-equipement/excel", name="stats_synthese_equipement_excel")
  57.      */
  58.     public function syntheseEquipmentExcelAction(TranslatorInterface $translator)
  59.   {
  60.         ini_set("memory_limit", "-1");
  61.         set_time_limit(0);
  62.         ini_set('default_socket_timeout', 600);
  64.         // print " ";
  65.         $sites = @$this->getUsedPortCount();
  66.         $spreadsheet = new Spreadsheet();
  68.         $spreadsheet->getProperties()
  69.                       ->setCreator("FiberLink App")
  70.                       ->setLastModifiedBy("FiberLink App")
  71.                       ->setTitle("Synthèse Equipement")
  72.                       ->setSubject("Synthèse Equipement")
  73.                       ->setDescription("Synthèse Equipement")
  74.                       ->setKeywords("Synthèse Equipement")
  75.                       ->setCategory("Synthèse Equipement");
  76.         // Create a new worksheet called "My Data"
  77.         $myWorkSheet = new Worksheet($spreadsheet, 'Synthèse equipement');
  79.         // Attach the "My Data" worksheet as the first worksheet in the Spreadsheet object
  80.         $spreadsheet->addSheet($myWorkSheet, 0);
  81.         $spreadsheet->setActiveSheetIndex(0);
  83.         $spreadsheet->getActiveSheet()
  84.                         ->setCellValue('A1', 'Site');
  85.         $spreadsheet->getActiveSheet()
  86.                         ->setCellValue('B1', 'Salle');
  87.         $spreadsheet->getActiveSheet()
  88.                         ->setCellValue('C1', 'Armoire');
  89.         $spreadsheet->getActiveSheet()
  90.                         ->setCellValue('D1', 'Équipement');
  91.         $spreadsheet->getActiveSheet()
  92.                         ->setCellValue('E1', 'Module');
  93.         $spreadsheet->getActiveSheet()
  94.                         ->setCellValue('F1', 'Slot');
  95.         $spreadsheet->getActiveSheet()
  96.                         ->setCellValue('G1', 'Nombre de port libre');
  97.         $spreadsheet->getActiveSheet()
  98.                         ->setCellValue('H1', 'Capacité');
  100.         $spreadsheet->getActiveSheet()
  101.                         ->setCellValue('G2', 'MAX de nombre de port');
  102.         $spreadsheet->getActiveSheet()
  103.                         ->setCellValue('H2', 'SUM de Capacité');
  104.         $spreadsheet->getActiveSheet()->getStyle('G2:H2')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);
  105.         $spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(50);
  106.         $spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(25);
  107.         $spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(25);
  108.         $spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(25);
  109.         $spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(25);
  110.         $spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(25);
  111.         $spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(25);
  112.         $spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(25);
  113.         $spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(25);
  116.         $styleArray = [
  117.           'font'=>['bold' => true,],
  118.           'alignment' => ['horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
  119.                           'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,],
  120.           'borders' => ['borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,],
  121.           'fill' => ['fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID, 'startColor'=>['argb' => 'FF9999FF',],],];
  123.         $spreadsheet->getActiveSheet()->getStyle('A1:H1')->applyFromArray($styleArray);
  124.         $siteColumnIndex = 3;
  125.         $roomColumnIndex = 3;
  126.         $rackColumnIndex = 3;
  127.         $equipmentColumnIndex = 3;
  128.         $moduleColumnIndex = 3;
  129.         $interfaceColumnIndex = 3;
  130.         $freePortColumnIndex = 3;
  131.         $capacityColumnIndex = 3;
  132.         foreach ($sites["sites"] as $site) {
  133.           $spreadsheet->getActiveSheet()->getStyle('A'.$siteColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  134.           $spreadsheet->getActiveSheet()->getStyle('A'.$siteColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  135.           $spreadsheet->getActiveSheet()
  136.                           ->setCellValue('A'.$siteColumnIndex++, $site["name"]);
  137.           foreach ($site["rooms"]["roomsArray"] as $room) {
  138.             $spreadsheet->getActiveSheet()->getStyle('B'.$roomColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  139.             $spreadsheet->getActiveSheet()->getStyle('B'.$roomColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  140.             $spreadsheet->getActiveSheet()
  141.                             ->setCellValue('B'.$roomColumnIndex++, $room["name"]);
  142.             foreach ($room["racks"]["racksArray"] as $rack) {
  143.               $spreadsheet->getActiveSheet()->getStyle('C'.$rackColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  144.               $spreadsheet->getActiveSheet()->getStyle('C'.$rackColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  145.               $spreadsheet->getActiveSheet()
  146.                               ->setCellValue('C'.$rackColumnIndex++, $rack["name"]);
  147.               foreach ($rack["equipments"]["equipmentsArray"] as $equipment) {
  148.                 $spreadsheet->getActiveSheet()->getStyle('D'.$equipmentColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  149.                 $spreadsheet->getActiveSheet()->getStyle('D'.$equipmentColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  150.                 $spreadsheet->getActiveSheet()
  151.                                 ->setCellValue('D'.$equipmentColumnIndex++, $equipment["name"]);
  152.                 if (count($equipment["modules"]["modulesArray"]) > 0) {
  153.                   foreach ($equipment["modules"]["modulesArray"] as $module) {
  154.                     $spreadsheet->getActiveSheet()->getStyle('E'.$moduleColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  155.                     $spreadsheet->getActiveSheet()->getStyle('E'.$moduleColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  156.                     $spreadsheet->getActiveSheet()
  157.                                     ->setCellValue('E'.$moduleColumnIndex++, $module["name"]);
  158.                     foreach ($module["interfaces"]["interfacesArray"] as $interface) {
  159.                       $spreadsheet->getActiveSheet()->getStyle('F'.$interfaceColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  160.                       $spreadsheet->getActiveSheet()
  161.                                       ->setCellValue('F'.$interfaceColumnIndex++, $interface["name"]);
  163.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  164.                       $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  165.                       $spreadsheet->getActiveSheet()
  166.                                       ->setCellValue('G'.$freePortColumnIndex++, $interface["counterCapacity"] - $interface["counterUsed"]);
  167.                       $spreadsheet->getActiveSheet()
  168.                                       ->setCellValue('H'.$capacityColumnIndex++, $interface["counterCapacity"]);
  169.                     }
  170.                     $spreadsheet->getActiveSheet()
  171.                                     ->setCellValue('E'.$freePortColumnIndex, "     Total pour ". $module["name"]);
  173.                     $spreadsheet->getActiveSheet()->mergeCells('E'. ($moduleColumnIndex-1).':E'. ($freePortColumnIndex-1));
  174.                     $spreadsheet->getActiveSheet()->mergeCells('E'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  176.                     $interfaceColumnIndex++;
  178.                     $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  179.                     $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  181.                     $spreadsheet->getActiveSheet()
  182.                                     ->setCellValue('G'.$freePortColumnIndex++, $module["counterCapacity"] - $module["counterUsed"]);
  183.                     $spreadsheet->getActiveSheet()
  184.                                     ->setCellValue('H'.$capacityColumnIndex++, $module["counterCapacity"]);
  185.                     $moduleColumnIndex = $freePortColumnIndex;
  186.                     // $moduleColumnIndex = $interfaceColumnIndex;
  187.                   }
  188.                 }
  189.                 else {
  190.                   foreach ($equipment["interfaces"]["interfacesArray"] as $interface) {
  191.                     $spreadsheet->getActiveSheet()->getStyle('F'.$interfaceColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  192.                     $spreadsheet->getActiveSheet()
  193.                                     ->setCellValue('F'.$interfaceColumnIndex++, $interface["name"]);
  195.                     $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  196.                     $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  197.                     $spreadsheet->getActiveSheet()
  198.                                     ->setCellValue('G'.$freePortColumnIndex++, $interface["counterCapacity"] - $interface["counterUsed"]);
  199.                     $spreadsheet->getActiveSheet()
  200.                                     ->setCellValue('H'.$capacityColumnIndex++, $interface["counterCapacity"]);
  201.                   }
  203.                 }
  204.                 $spreadsheet->getActiveSheet()
  205.                                 ->setCellValue('D'.$freePortColumnIndex, "     Total pour ". $equipment["name"]);
  207.                 $spreadsheet->getActiveSheet()->mergeCells('D'. ($equipmentColumnIndex-1).':D'. ($freePortColumnIndex-1));
  208.                 $spreadsheet->getActiveSheet()->mergeCells('D'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  210.                 $interfaceColumnIndex++;
  212.                 $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  213.                 $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  214.                 $spreadsheet->getActiveSheet()
  215.                                 ->setCellValue('G'.$freePortColumnIndex++, $equipment["counterCapacity"] - $equipment["counterUsed"]);
  216.                 $spreadsheet->getActiveSheet()
  217.                                 ->setCellValue('H'.$capacityColumnIndex++, $equipment["counterCapacity"]);
  218.                 $equipmentColumnIndex = $freePortColumnIndex;
  219.                 $moduleColumnIndex = $freePortColumnIndex;
  220.               }
  221.               $spreadsheet->getActiveSheet()
  222.                               ->setCellValue('C'.$freePortColumnIndex, "     Total pour ". $rack["name"]);
  224.               $spreadsheet->getActiveSheet()->mergeCells('C'. ($rackColumnIndex-1).':C'. ($freePortColumnIndex-1));
  225.               $spreadsheet->getActiveSheet()->mergeCells('C'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  227.               $interfaceColumnIndex++;
  229.               $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  230.               $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  231.               $spreadsheet->getActiveSheet()
  232.                               ->setCellValue('G'.$freePortColumnIndex++, $rack["counterCapacity"] - $rack["counterUsed"]);
  233.               $spreadsheet->getActiveSheet()
  234.                               ->setCellValue('H'.$capacityColumnIndex++, $rack["counterCapacity"]);
  235.               $rackColumnIndex = $freePortColumnIndex;
  236.               $equipmentColumnIndex = $freePortColumnIndex;
  237.               $moduleColumnIndex = $freePortColumnIndex;
  238.             }
  239.             $spreadsheet->getActiveSheet()
  240.                             ->setCellValue('B'.$freePortColumnIndex, "     Total pour ". $room["name"]);
  242.             $spreadsheet->getActiveSheet()->mergeCells('B'. ($roomColumnIndex-1).':B'. ($freePortColumnIndex-1));
  243.             $spreadsheet->getActiveSheet()->mergeCells('B'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  245.             $interfaceColumnIndex++;
  247.             $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  248.             $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  249.             $spreadsheet->getActiveSheet()
  250.                             ->setCellValue('G'.$freePortColumnIndex++, $room["counterCapacity"] - $room["counterUsed"]);
  251.             $spreadsheet->getActiveSheet()
  252.                             ->setCellValue('H'.$capacityColumnIndex++, $room["counterCapacity"]);
  253.             $roomColumnIndex = $freePortColumnIndex;
  254.             $rackColumnIndex = $freePortColumnIndex;
  255.             $equipmentColumnIndex = $freePortColumnIndex;
  256.             $moduleColumnIndex = $freePortColumnIndex;
  257.           }
  258.           $spreadsheet->getActiveSheet()
  259.                           ->setCellValue('A'.$freePortColumnIndex, "     Total pour ". $site["name"]);
  261.           $spreadsheet->getActiveSheet()->mergeCells('A'. ($siteColumnIndex-1).':A'. ($freePortColumnIndex-1));
  262.           $spreadsheet->getActiveSheet()->mergeCells('A'. ($freePortColumnIndex).':F'. $freePortColumnIndex);
  264.           $interfaceColumnIndex++;
  266.           $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  267.           $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  268.           $spreadsheet->getActiveSheet()
  269.                           ->setCellValue('G'.$freePortColumnIndex++, $site["counterCapacity"] - $site["counterUsed"]);
  270.           $spreadsheet->getActiveSheet()
  271.                           ->setCellValue('H'.$capacityColumnIndex++, $site["counterCapacity"]);
  272.           $siteColumnIndex = $freePortColumnIndex;
  273.           $roomColumnIndex = $freePortColumnIndex;
  274.           $rackColumnIndex = $freePortColumnIndex;
  275.           $equipmentColumnIndex = $freePortColumnIndex;
  276.           $moduleColumnIndex = $freePortColumnIndex;
  277.         }
  278.         $spreadsheet->getActiveSheet()
  279.                         ->setCellValue('A'.$freePortColumnIndex, "     Total Général ");
  281.         $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  282.         $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  283.         $spreadsheet->getActiveSheet()
  284.                         ->setCellValue('G'.$freePortColumnIndex, $sites["counterCapacity"] - $sites["counterUsed"]);
  285.         $spreadsheet->getActiveSheet()
  286.                         ->setCellValue('H'.$capacityColumnIndex, $sites["counterCapacity"]);
  287.         $spreadsheet->getActiveSheet()->mergeCells('A'. ($freePortColumnIndex).':F'. $freePortColumnIndex);
  289.         $writer = new Xlsx($spreadsheet);
  290.         $writer->save("Synthèse_equipement.xlsx");
  291.         // $excelPath = $this->getParameter('dir.downloads').'/synthèse_equipement.xlsx';
  293.         return $this->file("Synthèse_equipement.xlsx", "Synthèse_equipement.xlsx");
  294.         // return new Response("hi");
  295.     }
  296.     /**
  297.      * @IsGranted("ROLE_CRUD")
  298.      * @Route("/stats/synthese-rack/excel", name="stats_synthese_rack_excel")
  299.      */
  300.     public function syntheseRackExcelAction(TranslatorInterface $translator)
  301.   {
  302.         ini_set("memory_limit", "-1");
  303.         set_time_limit(0);
  304.         ini_set('default_socket_timeout', 600);
  305.         // print " ";
  306.         $sites = @$this->getUsedPortCount();
  307.         $spreadsheet = new Spreadsheet();
  309.         $spreadsheet->getProperties()
  310.                       ->setCreator("FiberLink App")
  311.                       ->setLastModifiedBy("FiberLink App")
  312.                       ->setTitle("Synthèse Armoire")
  313.                       ->setSubject("Synthèse Armoire")
  314.                       ->setDescription("Synthèse Armoire")
  315.                       ->setKeywords("Synthèse Armoire")
  316.                       ->setCategory("Synthèse Armoire");
  317.         // Create a new worksheet called "My Data"
  318.         $myWorkSheet = new Worksheet($spreadsheet, 'Synthèse Armoire');
  320.         // Attach the "My Data" worksheet as the first worksheet in the Spreadsheet object
  321.         $spreadsheet->addSheet($myWorkSheet, 0);
  322.         $spreadsheet->setActiveSheetIndex(0);
  324.         $spreadsheet->getActiveSheet()
  325.                         ->setCellValue('A1', 'Site');
  326.         $spreadsheet->getActiveSheet()
  327.                         ->setCellValue('B1', 'Salle');
  328.         $spreadsheet->getActiveSheet()
  329.                         ->setCellValue('C1', 'Armoire');
  330.         $spreadsheet->getActiveSheet()
  331.                         ->setCellValue('D1', 'Équipement');
  332.         $spreadsheet->getActiveSheet()
  333.                         ->setCellValue('E1', 'Module');
  334.         $spreadsheet->getActiveSheet()
  335.                         ->setCellValue('F1', 'Slot');
  336.         $spreadsheet->getActiveSheet()
  337.                         ->setCellValue('G1', 'Taux d\'occupation');
  338.         $spreadsheet->getActiveSheet()
  339.                         ->setCellValue('H1', 'Capacité');
  341.         $spreadsheet->getActiveSheet()
  342.                         ->setCellValue('G2', 'MAX de nombre de port');
  343.         $spreadsheet->getActiveSheet()
  344.                         ->setCellValue('H2', 'SUM de Capacité');
  345.         $spreadsheet->getActiveSheet()->getStyle('G2:H2')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);
  346.         $spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(50);
  347.         $spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(25);
  348.         $spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(25);
  349.         $spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(25);
  350.         $spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(25);
  351.         $spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(25);
  352.         $spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(25);
  353.         $spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(25);
  354.         $spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(25);
  357.         $styleArray = [
  358.           'font'=>['bold' => true,],
  359.           'alignment' => ['horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
  360.                           'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,],
  361.           'borders' => ['borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,],
  362.           'fill' => ['fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID, 'startColor'=>['argb' => 'FF9999FF',],],];
  364.         $spreadsheet->getActiveSheet()->getStyle('A1:H1')->applyFromArray($styleArray);
  365.         $siteColumnIndex = 3;
  366.         $roomColumnIndex = 3;
  367.         $rackColumnIndex = 3;
  368.         $equipmentColumnIndex = 3;
  369.         $moduleColumnIndex = 3;
  370.         $interfaceColumnIndex = 3;
  371.         $freePortColumnIndex = 3;
  372.         $capacityColumnIndex = 3;
  373.         foreach ($sites["sites"] as $site) {
  374.           $spreadsheet->getActiveSheet()->getStyle('A'.$siteColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  375.           $spreadsheet->getActiveSheet()->getStyle('A'.$siteColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  376.           $spreadsheet->getActiveSheet()
  377.                           ->setCellValue('A'.$siteColumnIndex++, $site["name"]);
  378.           foreach ($site["rooms"]["roomsArray"] as $room) {
  379.             $spreadsheet->getActiveSheet()->getStyle('B'.$roomColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  380.             $spreadsheet->getActiveSheet()->getStyle('B'.$roomColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  381.             $spreadsheet->getActiveSheet()
  382.                             ->setCellValue('B'.$roomColumnIndex++, $room["name"]);
  383.             foreach ($room["racks"]["racksArray"] as $rack) {
  384.               $spreadsheet->getActiveSheet()->getStyle('C'.$rackColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  385.               $spreadsheet->getActiveSheet()->getStyle('C'.$rackColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  386.               $spreadsheet->getActiveSheet()
  387.                               ->setCellValue('C'.$rackColumnIndex++, $rack["name"]);
  388.               foreach ($rack["equipments"]["equipmentsArray"] as $equipment) {
  389.                 $spreadsheet->getActiveSheet()->getStyle('D'.$equipmentColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  390.                 $spreadsheet->getActiveSheet()->getStyle('D'.$equipmentColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  391.                 $spreadsheet->getActiveSheet()
  392.                                 ->setCellValue('D'.$equipmentColumnIndex++, $equipment["name"]);
  393.                 if (count($equipment["modules"]["modulesArray"]) > 0) {
  394.                   foreach ($equipment["modules"]["modulesArray"] as $module) {
  395.                     $spreadsheet->getActiveSheet()->getStyle('E'.$moduleColumnIndex)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  396.                     $spreadsheet->getActiveSheet()->getStyle('E'.$moduleColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  397.                     $spreadsheet->getActiveSheet()
  398.                                     ->setCellValue('E'.$moduleColumnIndex++, $module["name"]);
  399.                     foreach ($module["interfaces"]["interfacesArray"] as $interface) {
  400.                       $spreadsheet->getActiveSheet()->getStyle('F'.$interfaceColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  401.                       $iName = isset($interface["name"]) ? $interface["name"]:"";
  402.                       $iCapacity = isset($interface["counterCapacity"]) ? $interface["counterCapacity"] : "";
  403.                       $spreadsheet->getActiveSheet()
  404.                                       ->setCellValue('F'.$interfaceColumnIndex++, $iName);
  406.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  407.                       $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  408.                       
  409.                       $tempOccupation = isset($interface["counterCapacity"]) ? number_format(($interface["counterUsed"]/$interface["counterCapacity"])*100, 2) : 100;
  411.                       $spreadsheet->getActiveSheet()
  412.                                       ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  413.                       if ($tempOccupation == 0) {
  414.                         $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  415.                                       ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  416.                                       ->getStartColor()->setARGB('FF00FF00');
  417.                       }
  418.                       elseif ($tempOccupation < 1) {
  419.                         $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  420.                                       ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  421.                                       ->getStartColor()->setARGB('FFFFA500');
  422.                       }
  423.                       else {
  424.                         $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  425.                                       ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  426.                                       ->getStartColor()->setARGB('FFFF0000');
  427.                       }
  428.                       $spreadsheet->getActiveSheet()
  429.                                       ->setCellValue('H'.$capacityColumnIndex++, $iCapacity);
  430.                     }
  431.                     $spreadsheet->getActiveSheet()
  432.                                     ->setCellValue('E'.$freePortColumnIndex, "     Total pour ". $module["name"]);
  434.                     $spreadsheet->getActiveSheet()->mergeCells('E'. ($moduleColumnIndex-1).':E'. ($freePortColumnIndex-1));
  435.                     $spreadsheet->getActiveSheet()->mergeCells('E'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  437.                     $interfaceColumnIndex++;
  439.                     $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  440.                     $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  441.                     $tempOccupation = number_format(($module["counterUsed"]/$module["counterCapacity"])*100, 2);
  443.                     $spreadsheet->getActiveSheet()
  444.                                     ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  446.                     if ($tempOccupation == 0) {
  447.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  448.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  449.                                     ->getStartColor()->setARGB('FF00FF00');
  450.                     }
  451.                     elseif ($tempOccupation < 1) {
  452.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  453.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  454.                                     ->getStartColor()->setARGB('FFFFA500');
  455.                     }
  456.                     else {
  457.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  458.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  459.                                     ->getStartColor()->setARGB('FFFF0000');
  460.                     }
  462.                     $spreadsheet->getActiveSheet()
  463.                                     ->setCellValue('H'.$capacityColumnIndex++, $module["counterCapacity"]);
  464.                     $moduleColumnIndex = $freePortColumnIndex;
  465.                     // $moduleColumnIndex = $interfaceColumnIndex;
  466.                   }
  467.                 }
  468.                 else {
  469.                   foreach ($equipment["interfaces"]["interfacesArray"] as $interface) {
  470.                     $iName = isset($interface["name"]) ? $interface["name"]:"";
  471.                     $iCapacity = isset($interface["counterCapacity"]) ? $interface["counterCapacity"] : "";
  472.                     $spreadsheet->getActiveSheet()->getStyle('F'.$interfaceColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  473.                     $spreadsheet->getActiveSheet()
  474.                                     ->setCellValue('F'.$interfaceColumnIndex++, $iName);
  476.                     $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  477.                     $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  478.                     $tempOccupation = isset($interface["counterCapacity"]) ? number_format(($interface["counterUsed"]/$interface["counterCapacity"])*100, 2) : 100;
  479.                     // $tempOccupation = number_format(($interface["counterUsed"]/$interface["counterCapacity"])*100, 2);
  481.                     $spreadsheet->getActiveSheet()
  482.                                     ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  484.                     if ($tempOccupation == 0) {
  485.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  486.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  487.                                     ->getStartColor()->setARGB('FF00FF00');
  488.                     }
  489.                     elseif ($tempOccupation < 1) {
  490.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  491.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  492.                                     ->getStartColor()->setARGB('FFFFA500');
  493.                     }
  494.                     else {
  495.                       $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  496.                                     ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  497.                                     ->getStartColor()->setARGB('FFFF0000');
  498.                     }
  499.                     $spreadsheet->getActiveSheet()
  500.                                     ->setCellValue('H'.$capacityColumnIndex++, $iCapacity);
  501.                   }
  503.                 }
  504.                 $spreadsheet->getActiveSheet()
  505.                                 ->setCellValue('D'.$freePortColumnIndex, "     Total pour ". $equipment["name"]);
  507.                 $spreadsheet->getActiveSheet()->mergeCells('D'. ($equipmentColumnIndex-1).':D'. ($freePortColumnIndex-1));
  508.                 $spreadsheet->getActiveSheet()->mergeCells('D'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  510.                 $interfaceColumnIndex++;
  512.                 $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  513.                 $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  514.                 $tempOccupation = number_format(($equipment["counterUsed"]/$equipment["counterCapacity"])*100, 2);
  516.                 $spreadsheet->getActiveSheet()
  517.                                 ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  519.                 if ($tempOccupation == 0) {
  520.                   $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  521.                                 ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  522.                                 ->getStartColor()->setARGB('FF00FF00');
  523.                 }
  524.                 elseif ($tempOccupation < 1) {
  525.                   $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  526.                                 ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  527.                                 ->getStartColor()->setARGB('FFFFA500');
  528.                 }
  529.                 else {
  530.                   $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  531.                                 ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  532.                                 ->getStartColor()->setARGB('FFFF0000');
  533.                 }
  534.                 $spreadsheet->getActiveSheet()
  535.                                 ->setCellValue('H'.$capacityColumnIndex++, $equipment["counterCapacity"]);
  536.                 $equipmentColumnIndex = $freePortColumnIndex;
  537.                 $moduleColumnIndex = $freePortColumnIndex;
  538.               }
  539.               $spreadsheet->getActiveSheet()
  540.                               ->setCellValue('C'.$freePortColumnIndex, "     Total pour ". $rack["name"]);
  542.               $spreadsheet->getActiveSheet()->mergeCells('C'. ($rackColumnIndex-1).':C'. ($freePortColumnIndex-1));
  543.               $spreadsheet->getActiveSheet()->mergeCells('C'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  545.               $interfaceColumnIndex++;
  547.               $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  548.               $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  549.               $tempOccupation = number_format(($rack["counterUsed"]/$rack["counterCapacity"])*100, 2);
  551.               $spreadsheet->getActiveSheet()
  552.                               ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  554.               if ($tempOccupation == 0) {
  555.                 $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  556.                               ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  557.                               ->getStartColor()->setARGB('FF00FF00');
  558.               }
  559.               elseif ($tempOccupation < 1) {
  560.                 $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  561.                               ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  562.                               ->getStartColor()->setARGB('FFFFA500');
  563.               }
  564.               else {
  565.                 $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  566.                               ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  567.                               ->getStartColor()->setARGB('FFFF0000');
  568.               }
  569.               $spreadsheet->getActiveSheet()
  570.                               ->setCellValue('H'.$capacityColumnIndex++, $rack["counterCapacity"]);
  571.               $rackColumnIndex = $freePortColumnIndex;
  572.               $equipmentColumnIndex = $freePortColumnIndex;
  573.               $moduleColumnIndex = $freePortColumnIndex;
  574.             }
  575.             $spreadsheet->getActiveSheet()
  576.                             ->setCellValue('B'.$freePortColumnIndex, "     Total pour ". $room["name"]);
  578.             $spreadsheet->getActiveSheet()->mergeCells('B'. ($roomColumnIndex-1).':B'. ($freePortColumnIndex-1));
  579.             $spreadsheet->getActiveSheet()->mergeCells('B'. $freePortColumnIndex.':F'. $freePortColumnIndex);
  581.             $interfaceColumnIndex++;
  583.             $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  584.             $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  585.             $tempOccupation = number_format(($room["counterUsed"]/$room["counterCapacity"])*100, 2);
  587.             $spreadsheet->getActiveSheet()
  588.                             ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  590.             if ($tempOccupation == 0) {
  591.               $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  592.                             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  593.                             ->getStartColor()->setARGB('FF00FF00');
  594.             }
  595.             elseif ($tempOccupation < 1) {
  596.               $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  597.                             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  598.                             ->getStartColor()->setARGB('FFFFA500');
  599.             }
  600.             else {
  601.               $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  602.                             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  603.                             ->getStartColor()->setARGB('FFFF0000');
  604.             }
  605.             $spreadsheet->getActiveSheet()
  606.                             ->setCellValue('H'.$capacityColumnIndex++, $room["counterCapacity"]);
  607.             $roomColumnIndex = $freePortColumnIndex;
  608.             $rackColumnIndex = $freePortColumnIndex;
  609.             $equipmentColumnIndex = $freePortColumnIndex;
  610.             $moduleColumnIndex = $freePortColumnIndex;
  611.           }
  612.           $spreadsheet->getActiveSheet()
  613.                           ->setCellValue('A'.$freePortColumnIndex, "     Total pour ". $site["name"]);
  615.           $spreadsheet->getActiveSheet()->mergeCells('A'. ($siteColumnIndex-1).':A'. ($freePortColumnIndex-1));
  616.           $spreadsheet->getActiveSheet()->mergeCells('A'. ($freePortColumnIndex).':F'. $freePortColumnIndex);
  618.           $interfaceColumnIndex++;
  620.           $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  621.           $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  622.           $tempOccupation = number_format(($site["counterUsed"]/$site["counterCapacity"])*100,2);
  624.           $spreadsheet->getActiveSheet()
  625.                           ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  627.           if ($tempOccupation == 0) {
  628.             $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  629.                           ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  630.                           ->getStartColor()->setARGB('FF00FF00');
  631.           }
  632.           elseif ($tempOccupation < 1) {
  633.             $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  634.                           ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  635.                           ->getStartColor()->setARGB('FFFFA500');
  636.           }
  637.           else {
  638.             $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  639.                           ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  640.                           ->getStartColor()->setARGB('FFFF0000');
  641.           }
  642.           $spreadsheet->getActiveSheet()
  643.                           ->setCellValue('H'.$capacityColumnIndex++, $site["counterCapacity"]);
  644.           $siteColumnIndex = $freePortColumnIndex;
  645.           $roomColumnIndex = $freePortColumnIndex;
  646.           $rackColumnIndex = $freePortColumnIndex;
  647.           $equipmentColumnIndex = $freePortColumnIndex;
  648.           $moduleColumnIndex = $freePortColumnIndex;
  649.         }
  650.         $spreadsheet->getActiveSheet()
  651.                         ->setCellValue('A'.$freePortColumnIndex, "     Total Général ");
  653.         $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  654.         $spreadsheet->getActiveSheet()->getStyle('H'.$capacityColumnIndex)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  655.         $tempOccupation = number_format(($sites["counterUsed"]/$sites["counterCapacity"])*100, 2);
  657.         $spreadsheet->getActiveSheet()
  658.                         ->setCellValue('G'.$freePortColumnIndex++, $tempOccupation);
  660.         if ($tempOccupation == 0) {
  661.           $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  662.                         ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  663.                         ->getStartColor()->setARGB('FF00FF00');
  664.         }
  665.         elseif ($tempOccupation < 1) {
  666.           $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  667.                         ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  668.                         ->getStartColor()->setARGB('FFFFA500');
  669.         }
  670.         else {
  671.           $spreadsheet->getActiveSheet()->getStyle('G'.$freePortColumnIndex)->getFill()
  672.                         ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  673.                         ->getStartColor()->setARGB('FFFF0000');
  674.         }
  675.         $spreadsheet->getActiveSheet()
  676.                         ->setCellValue('H'.$capacityColumnIndex, $sites["counterCapacity"]);
  677.         $spreadsheet->getActiveSheet()->mergeCells('A'. ($freePortColumnIndex).':F'. $freePortColumnIndex);
  679.         $writer = new Xlsx($spreadsheet);
  680.         $writer->save("Synthèse_armoire.xlsx");
  681.         // $excelPath = $this->getParameter('dir.downloads').'/synthèse_equipement.xlsx';
  683.         return $this->file("Synthèse_armoire.xlsx", "Synthèse_armoire.xlsx");
  684.         // return new Response("hi");
  685.     }
  687.     /**
  688.      * @IsGranted("ROLE_CRUD")
  689.      * @Route("/stats/diagramme/inter-site/trunk", name="stats_diagram_inter_site_trunk")
  690.      */
  691.     public function diagramTrunkInterSiteAction(TranslatorInterface $translator)
  692.   {
  693.         ini_set("memory_limit", "-1");
  694.         set_time_limit(0);
  695.         ini_set('default_socket_timeout', 600);
  696.         // print " ";
  697.         $portsAllTemp = $this->getDoctrine()->getRepository('App\Entity\Port')->findAllUsedPorts();
  698.         $portsAll = array();
  699.         foreach ($portsAllTemp as $tempArray) {
  700.           foreach ($tempArray as $key => $value) {
  701.             $portsAll[] = $value;
  702.           }
  704.         }
  705.         $posXmax = 1500;
  706.         $posYmax = 700;
  707.         $posXinit = 100;
  708.         $posX = 0;
  709.         $posY = 100;
  710.         $increment = 200;
  712.         $elements = array();
  713.         $edges = array();
  714.         $sites = $this->getDoctrine()->getRepository('App\Entity\Site')->findAll();
  715.         $counter = @$this->getUsedPortSiteRoomCount();
  716.         foreach ($sites as $site) {
  717.           $rooms = [];
  719.             $usedSite = 0;
  720.             $usedRoom = 0;
  721.             $capacitySite = 0;
  722.             $capacityRoom = 0;
  723.             if (isset($counter["sites"][$site->getId()])) {
  724.               $usedSite = $counter["sites"][$site->getId()]["counterUsed"];
  725.               $capacitySite = $counter["sites"][$site->getId()]["counterCapacity"];
  726.             }
  727.             $widthToAdd = 0;
  728.             if ($capacitySite < 1000) {
  729.                 $widthToAdd = 5;
  730.             }
  731.             else if ($capacitySite < 2000) {
  732.                 $widthToAdd = 10;
  733.             }
  734.             else if ($capacitySite < 3000) {
  735.                 $widthToAdd = 15;
  736.             }
  737.             else if ($capacitySite < 4000) {
  738.                 $widthToAdd = 20;
  739.             }
  740.             else if ($capacitySite < 5000) {
  741.                 $widthToAdd = 25;
  742.             }
  743.             else if ($capacitySite < 6000) {
  744.                 $widthToAdd = 30;
  745.             }
  746.             else if ($capacitySite < 7000) {
  747.                 $widthToAdd = 35;
  748.             }
  749.             else if ($capacitySite < 8000) {
  750.                 $widthToAdd = 40;
  751.             }
  752.             else if ($capacitySite < 9000) {
  753.                 $widthToAdd = 45;
  754.             }
  755.             else {
  756.                 $widthToAdd = 50;
  757.             }
  758.             if ($posX < $posXmax) {
  759.                 $posX += $increment;
  760.             } else {
  761.                 $posX = $posXinit;
  762.                 $posY += $increment;
  763.             }
  765.             $elements[] = ["id" => $site->getTitle(),
  766.                           "counterUsed" => ($capacitySite-$usedSite),
  767.                           "counterCapacity" => $capacitySite,
  768.                           "width" => 100+ $widthToAdd,
  769.                           "height" => 75+ $widthToAdd,
  770.                           // "width" => 100+ count($site->getRooms())*15,
  771.                           // "height" => 100+ count($site->getRooms())*10,
  772.                           "shape" => "ellipse",
  773.                           "positionX" => $site->getPositionX() ? $site->getPositionX() : $posX,
  774.                           "positionY" => $site->getPositionY() ? $site->getPositionY() : $posY
  775.                   ];
  776.         }
  777.         $trunks = $this->getDoctrine()->getRepository('App\Entity\Trunk')->findAll();
  778.         foreach ($trunks as $trunk) {
  779.           $count = 0;
  780.           $tempArray = array();
  781.           $element = array();
  782.           $tcfs = $trunk->getCableFiber();
  783.           $ext = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByTrunk($trunk);
  785.           foreach ($tcfs as $tcf) {
  786.               $exts = $tcf->getExtensions();
  787.               $countExts = count($exts);
  788.             if ($ext) {
  789.               if (in_array($tcf->getPortA()->getId(), $portsAll)) {
  790.                 $count++;
  791.               }
  792.               elseif (in_array($tcf->getPortB()->getId(), $portsAll)) {
  793.                 $count++;
  794.               }
  795.               else{
  796.                 // $exts = $tcf->getExtensions();
  797.                 // $countExts = count($exts);
  798.                 if ( $countExts > 0) {
  799.                   if (in_array($exts[$countExts-1]->getPortB()->getId(), $portsAll)) {
  800.                     $count++;
  801.                   }
  802.                 }
  803.               }
  804.             }
  806.             //MODIFIED on 13 mars 2019
  807.             // $trunkSiteA = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  808.             // $trunkSiteB = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  809.             $target = "";
  810.             $source = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  811.             $target = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  812.             if($source != $target){
  813.                 $element["id"] = $trunk->getTrunkID();
  814.                 $element["source"] = $source;
  815.                 $element["target"] = $target;
  816.                 $element["color"] = $trunk->getTypeCable()->getColor();
  817.                 $tempArray[$source . "" . $target] = $element;
  818.             }
  819.             foreach ($exts as $ext1) {
  820.                 $extSiteB = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  822.                 $source = $target;
  823.                 $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  824.                 if($source != $target){
  825.                     $element = array();
  826.                     $element["id"] =$trunk->getTrunkID();
  827.                     $element["source"] = $source;
  828.                     $element["target"] = $target;
  829.                     $element["color"] = ($ext1->getTypeCable()) ? $ext1->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  830.                     $tempArray[$source . "" . $target] = $element;
  831.                 }
  832.                 $trunkSiteB = $extSiteB;
  834.             }
  835.             //old
  836.             // $element["id"] =$trunk->getTrunkID();
  837.             // $source = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  838.             // $element["source"] = $source;
  839.             // $target = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  840.             // if ($element["source"] != $target) {
  841.             //   $element["target"] = $target;
  842.             //   $element["color"] = $trunk->getTypeCable()->getColor();
  843.             //   $tempArray[$source . "" . $target] = $element;
  844.             //   $oldSource = $source;
  845.             //   $oldTarget = $target;
  846.             //   $gotIt = false;
  847.             //   foreach ($tcf->getExtensions() as $ext) {
  848.             //     if ($gotIt) {
  849.             //       $source = $tempArray[$source . "" . $target]["target"];
  850.             //       $oldSource = $source;
  851.             //       $oldTarget = $target;
  852.             //       $gotIt = false;
  853.             //     }
  854.             //     else {
  855.             //       $source = $tempArray[$oldSource . "" . $oldSarget]["target"];
  856.             //     }
  857.             //     $target = $ext->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  858.             //     if ($source != $target) {
  859.             //       $element = array();
  860.             //       $element["id"] =$trunk->getTrunkID();
  861.             //       $element["source"] = $source;
  862.             //       $element["target"] = $target;
  863.             //       $element["color"] = ($ext->getTypeCable()) ? $ext->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  864.             //       $tempArray[$source . "" . $target] = $element;
  865.             //       $gotIt = true;
  866.             //     }
  867.             //   }
  868.             // }
  869.             // else {
  870.             //   $added = false;
  871.             //   $oldSource = $element["source"];
  872.             //   foreach ($tcf->getExtensions() as $ext) {
  873.             //     if ($added) {
  874.             //       $source = $tempArray[$source . "" . $target]["target"];
  875.             //     }
  876.             //     else {
  877.             //       $source = $oldSource;
  878.             //     }
  879.             //     $target = $ext->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getTitle();
  880.             //     if ($source != $target) {
  881.             //       $element = array();
  882.             //       $element["id"] =$trunk->getTrunkID();
  883.             //       $element["source"] = $source;
  884.             //       $element["target"] = $target;
  885.             //       $element["color"] = ($ext->getTypeCable()) ? $ext->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  886.             //       $tempArray[$source . "" . $target] = $element;
  887.             //       $added = true;
  888.             //       $oldSource = $target;
  889.             //     }
  890.             //     else {
  891.             //       $added = false;
  892.             //     }
  893.             //   }
  894.             // }
  896.           }
  897.           $edgsArray = array();
  898.           foreach (array_values($tempArray) as $value) {
  899.             $capacity = $trunk->getCapacity();
  900.             $value["id"] = $value["id"] . " (".($capacity-$count) ."/".$capacity.")";
  901.             //check if id exists
  902.             foreach ($edgsArray as $value1) {
  903.                 if($value1["id"] == $value["id"]){
  904.                     $value["id"] .= " ";
  905.                     break;
  906.                 }
  907.             }
  908.             $edgsArray[] = $value;
  909.           }
  910.           $edges = array_merge($edges, $edgsArray);
  912.           // $elements = array_merge($elements, array_values($tempArray));
  913.         }
  914.         // $fileSystem = new Filesystem();
  915.         // $upload_dir = $_SERVER['DOCUMENT_ROOT'].'/assets/js/sigma/data.json';
  916.         // $fileSystem->dumpFile($upload_dir, json_encode($data));
  917.         return $this->render('Stat/diagram_trunk_inter-site.html.twig', array(
  918.             "sites"=>$sites,
  919.             'page_title' => $translator->trans('Diagramme Trunk Inter-site'),
  920.             'elements' => $elements,
  921.             'edges' => $edges
  922.         ));
  923.     }
  924.     /**
  925.      * @IsGranted("ROLE_CRUD")
  926.      * @Route("/stats/diagramme/intra-site/trunk/{id}", name="stats_diagram_intra_site_trunk")
  927.      */
  928.     public function diagramTrunkIntraSiteAction($id, TranslatorInterface $translator)
  929.   {
  930.         ini_set("memory_limit", "-1");
  931.         set_time_limit(0);
  932.         ini_set('default_socket_timeout', 600);
  933.         // print " ";
  934.         $portsAllTemp = $this->getDoctrine()->getRepository('App\Entity\Port')->findAllUsedPorts();
  935.         $portsAll = array();
  936.         foreach ($portsAllTemp as $temp) {
  937.           foreach ($temp as $key => $value) {
  938.             $portsAll[] = $value;
  939.           }
  941.         }
  943.         $posXmax = 1500;
  944.         $posYmax = 700;
  945.         $posXinit = 100;
  946.         $posX = 0;
  947.         $posY = 100;
  948.         $increment = 200;
  950.         $elements = array();
  951.         $edges = array();
  952.         $site = $this->getDoctrine()->getRepository('App\Entity\Site')->findOneById($id);
  953.         $sites = $this->getDoctrine()->getRepository('App\Entity\Site')->findAll();
  954.         $roomsSite = $this->getDoctrine()->getRepository('App\Entity\Room')->findBySite($site);
  955.         $counter = @$this->getUsedPortSiteRoomCount();
  957.         $rooms = [];
  958.         foreach ($site->getRooms() as $room) {
  959.           $usedSite = 0;
  960.           $usedRoom = 0;
  961.           $capacitySite = 0;
  962.           $capacityRoom = 0;
  963.           if (isset($counter["sites"][$site->getId()])) {
  964.             $usedSite = $counter["sites"][$site->getId()]["counterUsed"];
  965.             $capacitySite = $counter["sites"][$site->getId()]["counterCapacity"];
  966.             if (isset($counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()])) {
  967.               $usedRoom = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"];
  968.               $capacityRoom = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"];
  969.             }
  970.           }
  971.           $widthToAdd = 0;
  972.           if ($capacityRoom < 1000) {
  973.               $widthToAdd = 5;
  974.           }
  975.           else if ($capacityRoom < 2000) {
  976.               $widthToAdd = 10;
  977.           }
  978.           else if ($capacityRoom < 3000) {
  979.               $widthToAdd = 15;
  980.           }
  981.           else if ($capacityRoom < 4000) {
  982.               $widthToAdd = 20;
  983.           }
  984.           else if ($capacityRoom < 5000) {
  985.               $widthToAdd = 25;
  986.           }
  987.           else if ($capacityRoom < 6000) {
  988.               $widthToAdd = 30;
  989.           }
  990.           else if ($capacityRoom < 7000) {
  991.               $widthToAdd = 35;
  992.           }
  993.           else if ($capacityRoom < 8000) {
  994.               $widthToAdd = 40;
  995.           }
  996.           else if ($capacityRoom < 9000) {
  997.               $widthToAdd = 45;
  998.           }
  999.           else {
  1000.               $widthToAdd = 50;
  1001.           }
  1003.           if ($posX < $posXmax) {
  1004.               $posX += $increment;
  1005.           } else {
  1006.               $posX = $posXinit;
  1007.               $posY += $increment;
  1008.           }
  1009.           $rooms[] = ["id" => $room->getTitle(),
  1010.                           "parent" => $site->getTitle(),
  1011.                           "counterUsed" => ($capacityRoom-$usedRoom),
  1012.                           "counterCapacity" => $capacityRoom,
  1013.                           "width" => 100+ $widthToAdd,
  1014.                           // "width" => 100+ count($room->getRacks())*40,
  1015.                           "height" => 75+ $widthToAdd,
  1016.                           // "height" => 100+ count($room->getRacks())*30,
  1017.                           "shape" => "bottomroundrectangle",
  1018.                           "positionX" => $room->getPositionX() ? $room->getPositionX() : $posX,
  1019.                           "positionY" => $room->getPositionY() ? $room->getPositionY() : $posY
  1020.                   ];
  1021.         }
  1022.         $elements[] = ["id" => $site->getTitle(),
  1023.                         "counterUsed" => ($capacitySite-$usedSite),
  1024.                         "counterCapacity" => $capacitySite,
  1025.                         "width" => 100+ count($site->getRooms())*10,
  1026.                         "height" => 100+ count($site->getRooms())*8,
  1027.                         "shape" => "roundrectangle",
  1028.                         "rooms" => $rooms
  1029.                 ];
  1030.         $trunks = $this->getDoctrine()->getRepository('App\Entity\Trunk')->findAll();
  1031.         foreach ($trunks as $trunk) {
  1032.           $count = 0;
  1033.           $tempArray = array();
  1034.           $element = array();
  1035.           $tcfs = $trunk->getCableFiber();
  1036.           $ext = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByTrunk($trunk);
  1038.           foreach ($tcfs as $tcf) {
  1039.                 $exts = $tcf->getExtensions();
  1040.                 $countExts = count($exts);
  1041.             if ($ext) {
  1042.               if (in_array($tcf->getPortA()->getId(), $portsAll)) {
  1043.                 $count++;
  1044.               }
  1045.               elseif (in_array($tcf->getPortB()->getId(), $portsAll)) {
  1046.                 $count++;
  1047.               }
  1048.               else{
  1049.                 if ( $countExts > 0) {
  1050.                   if (in_array($exts[$countExts-1]->getPortB()->getId(), $portsAll)) {
  1051.                     $count++;
  1052.                   }
  1053.                 }
  1054.               }
  1055.             }
  1056.             //MODIFIED on 28 fév 2019
  1057.             $trunkSiteA = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  1058.             $trunkSiteB = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  1059.             $target = "";
  1060.             if($trunkSiteA == $id && $trunkSiteB == $id){
  1061.                 $source = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1062.                 $target = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1063.                 if($source != $target){
  1064.                     $element["id"] = $trunk->getTrunkID();
  1065.                     $element["source"] = $source;
  1066.                     $element["target"] = $target;
  1067.                     $element["color"] = $trunk->getTypeCable()->getColor();
  1068.                     $tempArray[$source . "" . $target] = $element;
  1069.                 }
  1071.             }
  1072.             foreach ($exts as $ext1) {
  1073.                 $extSiteB = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getSite()->getId();
  1074.                 if($trunkSiteB == $id && $extSiteB == $id){
  1075.                     $source = $target;
  1076.                     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1077.                     if($source != $target){
  1078.                         $element = array();
  1079.                         $element["id"] =$trunk->getTrunkID();
  1080.                         $element["source"] = $source;
  1081.                         $element["target"] = $target;
  1082.                         $element["color"] = ($ext1->getTypeCable()) ? $ext1->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  1083.                         $tempArray[$source . "" . $target] = $element;
  1084.                     }
  1085.                     $trunkSiteB = $extSiteB;
  1086.                 }
  1087.                 else if($extSiteB == $id){
  1088.                     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1089.                     $trunkSiteB = $extSiteB;
  1090.                 }
  1092.             }
  1093.             // $element["id"] =$trunk->getTrunkID();
  1094.             // $source = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1095.             // $element["source"] = $source;
  1096.             //
  1097.             // $target = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1098.             // if ($element["source"] != $target) {
  1099.             //   $element["target"] = $target;
  1100.             //   $element["color"] = $trunk->getTypeCable()->getColor();
  1101.             //   $tempArray[$source . "" . $target] = $element;
  1102.             //   $oldSource = $source;
  1103.             //   $oldTarget = $target;
  1104.             //   $gotIt = false;
  1105.             //   foreach ($tcf->getExtensions() as $ext1) {
  1106.             //     if ($gotIt) {
  1107.             //       $source = $tempArray[$source . "" . $target]["target"];
  1108.             //       $oldSource = $source;
  1109.             //       $oldTarget = $target;
  1110.             //       $gotIt = false;
  1111.             //     }
  1112.             //     else {
  1113.             //       $source = $tempArray[$oldSource . "" . $oldSarget]["target"];
  1114.             //     }
  1115.             //     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1116.             //     if ($source != $target) {
  1117.             //       $element = array();
  1118.             //       $element["id"] =$trunk->getTrunkID();
  1119.             //       $element["source"] = $source;
  1120.             //       $element["target"] = $target;
  1121.             //       $element["color"] = ($ext1->getTypeCable()) ? $ext1->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  1122.             //       $tempArray[$source . "" . $target] = $element;
  1123.             //       $gotIt = true;
  1124.             //     }
  1125.             //   }
  1126.             // }
  1127.             // else {
  1128.             //   $added = false;
  1129.             //   $oldSource = $element["source"];
  1130.             //   foreach ($tcf->getExtensions() as $ext1) {
  1131.             //     if ($added) {
  1132.             //       $source = $tempArray[$source . "" . $target]["target"];
  1133.             //     }
  1134.             //     else {
  1135.             //       $source = $oldSource;
  1136.             //     }
  1137.             //     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getTitle();
  1138.             //     if ($source != $target) {
  1139.             //       $element = array();
  1140.             //       $element["id"] =$trunk->getTrunkID();
  1141.             //       $element["source"] = $source;
  1142.             //       $element["target"] = $target;
  1143.             //       $element["color"] = ($ext1->getTypeCable()) ? $ext1->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  1144.             //       $tempArray[$source . "" . $target] = $element;
  1145.             //       $added = true;
  1146.             //       $oldSource = $target;
  1147.             //     }
  1148.             //     else {
  1149.             //       $added = false;
  1150.             //     }
  1151.             //   }
  1152.             // }
  1154.           }
  1155.           $edgsArray = array();
  1156.           foreach (array_values($tempArray) as $value) {
  1157.             $capacity = $trunk->getCapacity();
  1158.             $value["id"] = $value["id"] . " (".($capacity-$count) ."/".$capacity.")";
  1159.             foreach ($edgsArray as $value1) {
  1160.                 if($value1["id"] == $value["id"]){
  1161.                     $value["id"] .= " ";
  1162.                     break;
  1163.                 }
  1164.             }
  1165.             $edgsArray[] = $value;
  1166.           }
  1167.           $edges = array_merge($edges, $edgsArray);
  1168.           // $elements = array_merge($elements, array_values($tempArray));
  1169.         }
  1170.         // var_dump($edges);
  1171.         // $fileSystem = new Filesystem();
  1172.         // $upload_dir = $_SERVER['DOCUMENT_ROOT'].'/assets/js/sigma/data.json';
  1173.         // $fileSystem->dumpFile($upload_dir, json_encode($data));
  1174.         $tempCap = $elements[0]['counterCapacity'];
  1175.         $tempLib = $elements[0]['counterCapacity'] - $elements[0]['counterUsed'];
  1176.         return $this->render('Stat/diagram_trunk_intra-site.html.twig', array(
  1177.             "sites"=>$sites,
  1178.             'page_title' => "Diagramme trunk intra-site: ".$site->getTitle()."(".$tempLib. "/". $tempCap .")" ,
  1179.             'elements' => $elements,
  1180.             'edges' => $edges,
  1181.             'rooms' => $roomsSite,
  1182.             "site_id" => $id
  1183.         ));
  1184.     }
  1186.     /**
  1187.      * @IsGranted("ROLE_CRUD")
  1188.      * @Route("/stats/diagramme/intra-room/trunk/{id}", name="stats_diagram_intra_room_trunk")
  1189.      */
  1190.     public function diagramTrunkIntraRoomAction($id, TranslatorInterface $translator)
  1191.   {
  1192.         ini_set("memory_limit", "-1");
  1193.         set_time_limit(0);
  1194.         ini_set('default_socket_timeout', 600);
  1195.         // print " ";
  1196.         $portsAllTemp = $this->getDoctrine()->getRepository('App\Entity\Port')->findAllUsedPorts();
  1197.         $portsAll = array();
  1198.         foreach ($portsAllTemp as $temp) {
  1199.           foreach ($temp as $key => $value) {
  1200.             $portsAll[] = $value;
  1201.           }
  1203.         }
  1205.         $posXmax = 1500;
  1206.         $posYmax = 700;
  1207.         $posXinit = 100;
  1208.         $posX = 0;
  1209.         $posY = 100;
  1210.         $increment = 200;
  1212.         $elements = array();
  1213.         $edges = array();
  1214.         $room = $this->getDoctrine()->getRepository('App\Entity\Room')->findOneById($id);
  1215.         $site = $room->getSite();
  1216.         $rooms = $this->getDoctrine()->getRepository('App\Entity\Room')->findBySite($site);
  1217.         $counter = @$this->getUsedPortSiteRoomCount();
  1219.         $racks = [];
  1220.         foreach ($room->getRacks() as $rack) {
  1221.           $usedSite = 0;
  1222.           $usedRoom = 0;
  1223.           $usedRack = 0;
  1224.           $capacitySite = 0;
  1225.           $capacityRoom = 0;
  1226.           $capacityRack = 0;
  1227.           if (isset($counter["sites"][$site->getId()])) {
  1228.             // $usedSite = $counter["sites"][$site->getId()]["counterUsed"];
  1229.             // $capacitySite = $counter["sites"][$site->getId()]["counterCapacity"];
  1230.             if (isset($counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()])) {
  1231.               $usedRoom = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"];
  1232.               $capacityRoom = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"];
  1233.               if (isset($counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"])) {
  1234.                 try{
  1235.                   $usedRack = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"];
  1236.                   $capacityRack = $counter["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterCapacity"];
  1237.                 }
  1238.                 catch(Exception $ex){}
  1239.                 
  1240.               }
  1241.             }
  1243.           }
  1244.           $widthToAdd = 0;
  1245.           if ($capacityRack < 100) {
  1246.               $widthToAdd = 5;
  1247.           }
  1248.           else if ($capacityRack < 200) {
  1249.               $widthToAdd = 10;
  1250.           }
  1251.           else if ($capacityRack < 300) {
  1252.               $widthToAdd = 15;
  1253.           }
  1254.           else if ($capacityRack < 400) {
  1255.               $widthToAdd = 20;
  1256.           }
  1257.           else if ($capacityRack < 500) {
  1258.               $widthToAdd = 25;
  1259.           }
  1260.           else if ($capacityRack < 600) {
  1261.               $widthToAdd = 30;
  1262.           }
  1263.           else if ($capacityRack < 700) {
  1264.               $widthToAdd = 35;
  1265.           }
  1266.           else if ($capacityRack < 800) {
  1267.               $widthToAdd = 40;
  1268.           }
  1269.           else if ($capacityRack < 900) {
  1270.               $widthToAdd = 45;
  1271.           }
  1272.           else {
  1273.               $widthToAdd = 50;
  1274.           }
  1276.           if ($posX < $posXmax) {
  1277.               $posX += $increment;
  1278.           } else {
  1279.               $posX = $posXinit;
  1280.               $posY += $increment;
  1281.           }
  1282.           $racks[] = ["id" => $rack->getTitle(),
  1283.                           "parent" => $room->getTitle(),
  1284.                           "counterUsed" => ($capacityRack-$usedRack),
  1285.                           "counterCapacity" => $capacityRack ? $capacityRack : 0,
  1286.                           "width" => 50+ $widthToAdd,
  1287.                           // "width" => 100+ count($room->getRacks())*40,
  1288.                           "height" => 100+ $widthToAdd,
  1289.                           // "height" => 100+ count($room->getRacks())*30,
  1290.                           "shape" => "rectangle",
  1291.                           "positionX" => $rack->getPositionX() ? $rack->getPositionX() : $posX,
  1292.                           "positionY" => $rack->getPositionY() ? $rack->getPositionY() : $posY
  1293.                   ];
  1294.         }
  1295.         $elements[] = [
  1296.                         "counterUsed" => ($capacityRoom-$usedRoom),
  1297.                         "counterCapacity" => $capacityRoom,
  1298.                         "racks" => $racks
  1299.                 ];
  1300.         $trunks = $this->getDoctrine()->getRepository('App\Entity\Trunk')->findAll();
  1301.         foreach ($trunks as $trunk) {
  1302.           $count = 0;
  1303.           $tempArray = array();
  1304.           $element = array();
  1305.           $tcfs = $trunk->getCableFiber();
  1306.           $ext = $this->getDoctrine()->getRepository('App\Entity\LinkExtension')->findOneByTrunk($trunk);
  1308.           foreach ($tcfs as $tcf) {
  1309.                 $exts = $tcf->getExtensions();
  1310.                 $countExts = count($exts);
  1311.             if ($ext) {
  1312.               if (in_array($tcf->getPortA()->getId(), $portsAll)) {
  1313.                 $count++;
  1314.               }
  1315.               elseif (in_array($tcf->getPortB()->getId(), $portsAll)) {
  1316.                 $count++;
  1317.               }
  1318.               else{
  1319.                 if ( $countExts > 0) {
  1320.                   if (in_array($exts[$countExts-1]->getPortB()->getId(), $portsAll)) {
  1321.                     $count++;
  1322.                   }
  1323.                 }
  1324.               }
  1325.             }
  1326.             //MODIFIED on 28 fév 2019
  1327.             $trunkRoomA = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getId();
  1328.             $trunkRoomB = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getId();
  1329.             $target = "";
  1330.             if($trunkRoomA == $id && $trunkRoomB == $id){
  1331.                 $source = $tcf->getPortA()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getTitle();
  1332.                 $target = $tcf->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getTitle();
  1333.                 if($source != $target){
  1334.                     $element["id"] = $trunk->getTrunkID();
  1335.                     $element["source"] = $source;
  1336.                     $element["target"] = $target;
  1337.                     $element["color"] = $trunk->getTypeCable()->getColor();
  1338.                     $tempArray[$source . "" . $target] = $element;
  1339.                 }
  1341.             }
  1342.             foreach ($exts as $ext1) {
  1343.                 $extRoomB = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getRoom()->getId();
  1344.                 if($trunkRoomB == $id && $extRoomB == $id){
  1345.                     $source = $target;
  1346.                     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getTitle();
  1347.                     if($source != $target){
  1348.                         $element = array();
  1349.                         $element["id"] =$trunk->getTrunkID();
  1350.                         $element["source"] = $source;
  1351.                         $element["target"] = $target;
  1352.                         $element["color"] = ($ext1->getTypeCable()) ? $ext1->getTypeCable()->getColor() : $trunk->getTypeCable()->getColor();
  1353.                         $tempArray[$source . "" . $target] = $element;
  1354.                     }
  1355.                     $trunkRoomB = $extRoomB;
  1356.                 }
  1357.                 else if($extRoomB == $id){
  1358.                     $target = $ext1->getPortB()->getInterfaceSpecific()->getEquipmentSpecific()->getRack()->getTitle();
  1359.                     $trunkRoomB = $extRoomB;
  1360.                 }
  1362.             }
  1364.           }
  1365.           $edgsArray = array();
  1366.           foreach (array_values($tempArray) as $value) {
  1367.             $capacity = $trunk->getCapacity();
  1368.             $value["id"] = $value["id"] . " (".($capacity-$count) ."/".$capacity.")";
  1369.             foreach ($edgsArray as $value1) {
  1370.                 if($value1["id"] == $value["id"]){
  1371.                     $value["id"] .= " ";
  1372.                     break;
  1373.                 }
  1374.             }
  1375.             $edgsArray[] = $value;
  1376.           }
  1377.           $edges = array_merge($edges, $edgsArray);
  1378.           // $elements = array_merge($elements, array_values($tempArray));
  1379.         }
  1380.         // var_dump($rooms);
  1381.         // $fileSystem = new Filesystem();
  1382.         // $upload_dir = $_SERVER['DOCUMENT_ROOT'].'/assets/js/sigma/data.json';
  1383.         // $fileSystem->dumpFile($upload_dir, json_encode($data));
  1384.         $tempCap = $elements[0]['counterCapacity'];
  1385.         $tempLib = $elements[0]['counterCapacity'] - $elements[0]['counterUsed'];
  1386.         return $this->render('Stat/diagram_trunk_intra-room.html.twig', array(
  1387.             "rooms"=>$rooms,
  1388.             'page_title' => "Diagramme trunk intra-room: ".$room->getTitle()."(".$tempLib. "/". $tempCap .")" ,
  1389.             'elements' => $elements,
  1390.             'edges' => $edges,
  1391.             "room_id" => $id
  1392.         ));
  1393.     }
  1394.     /**
  1395.      * @IsGranted("ROLE_CRUD")
  1396.      * @Route("/stats/diagramme/link", name="stats_diagram_link")
  1397.      */
  1398.     public function diagramLinkAction(TranslatorInterface $translator)
  1399.   {
  1400.         // print " ";
  1401.         return $this->render('Stat/diagram_link.html.twig', array(
  1402.             "sites"=>$sites,
  1403.             'page_title' => $translator->trans('Synthèse Equipements'),
  1404.         ));
  1405.     }
  1406.     public function getUsedPortCount()
  1407.     {
  1408.       ini_set("memory_limit", "-1");
  1409.       set_time_limit(0);
  1410.       $sites = array();
  1411.       $sites["counterUsed"] = 0;
  1412.       $sites["counterCapacity"] = 0;
  1413.       $sites["sites"] = array();
  1415.       $portsAllTemp = $this->getDoctrine()->getRepository('App\Entity\Port')->findAllUsedPorts();
  1416.       $portsAll = array();
  1417.       foreach ($portsAllTemp as $tempArray) {
  1418.         foreach ($tempArray as $key => $value) {
  1419.           $portsAll[] = $value;
  1420.         }
  1421.       }
  1423.       $ports = $this->getDoctrine()->getRepository('App\Entity\Port')->findAll();
  1424.        foreach ($ports as $port) {
  1425.          try {
  1426.            $interfaceSpecific = $port->getInterfaceSpecific();
  1427.            $intTypeLink = $interfaceSpecific->getInterfaceGeneric()->getTypeLink()->getTitle();
  1428.            $equipmentSpecificTemp = $interfaceSpecific->getEquipmentSpecific();
  1429.            $module = null;
  1430.            $equipmentSpecific = null;
  1431.            if(!isset($equipmentSpecificTemp)){
  1432.                $interfaceSpecificPortExterne = $port->getInterfaceSpecificPortExterne();
  1433.                if(isset($interfaceSpecificPortExterne)){
  1434.                    $equipmentSpecificTemp = $interfaceSpecificPortExterne->getEquipmentSpecific();
  1435.                    if ($equipmentSpecificTemp->isModule()) {
  1436.                      $module = $equipmentSpecificTemp;
  1437.                      $equipmentSpecific = $equipmentSpecificTemp->getParent();
  1438.                    }
  1439.                    else{
  1440.                        $equipmentSpecific = $equipmentSpecificTemp;
  1441.                    }
  1442.                }
  1443.            }
  1444.            elseif ($equipmentSpecificTemp->isModule()) {
  1445.              $module = $equipmentSpecificTemp;
  1446.              $equipmentSpecific = $equipmentSpecificTemp->getParent();
  1447.            }
  1448.            // if (isset($equipmentSpecificTemp) && $equipmentSpecificTemp->isModule()) {
  1449.            //   $module = $equipmentSpecificTemp;
  1450.            //   $equipmentSpecific = $equipmentSpecificTemp->getParent();
  1451.            // }
  1452.            else {
  1453.              $equipmentSpecific = $equipmentSpecificTemp;
  1454.            }
  1455.            if(!isset($equipmentSpecific)) continue;
  1456.            $rack = $equipmentSpecific->getRack();
  1457.            $room = $rack->getRoom();
  1458.            $site = $room->getSite();
  1459.          } catch (\Exception $e) {
  1460.            continue;
  1461.          }
  1462.          // print " ";
  1463.          if ($intTypeLink == "Simplex" || $intTypeLink == "Duplex" || ($intTypeLink == "Port Externe" && $port->getPortExterne())) {
  1464.            $sites["counterCapacity"] = $sites["counterCapacity"] + 1;
  1465.            if (isset($sites["sites"][$site->getId()])) {
  1466.               $sites["sites"][$site->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["counterCapacity"] + 1;
  1467.               $sites["sites"][$site->getId()]["rooms"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["counterCapacity"] + 1;
  1468.               if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()])) {
  1469.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"] + 1;
  1470.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterCapacity"] + 1;
  1471.                 if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()])) {
  1472.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterCapacity"] + 1;
  1473.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterCapacity"] + 1;
  1474.                   if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()])) {
  1475.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterCapacity"] + 1;
  1476.                     if ($module) {
  1477.                       $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterCapacity"] + 1;
  1478.                       if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()])) {
  1479.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterCapacity"] + 1;
  1480.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterCapacity"] + 1;
  1481.                         if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()])) {
  1482.                           $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterCapacity"] + 1;
  1483.                         }
  1484.                       }
  1485.                       else {
  1486.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()] = array("counterUsed"=>0,
  1487.                                                                                                                                                                                                             "counterCapacity"=>1,
  1488.                                                                                                                                                                                                             "name"=>$module->getEquipmentSpecificName(),
  1489.                                                                                                                                                                                                             "interfaces"=>array("counterUsed"=>0,
  1490.                                                                                                                                                                                                                                 "counterCapacity"=>1,
  1491.                                                                                                                                                                                                                                 "interfacesArray"=>array()));
  1492.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1493.                                                                                                                                                                                                                                                                                                                         "counterCapacity"=>1,
  1494.                                                                                                                                                                                                                                                                                                                         "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1495.                       }
  1496.                     }
  1497.                     else {
  1498.                       $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterCapacity"] + 1;
  1499.                       if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()])) {
  1500.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterCapacity"] + 1;
  1501.                       }
  1502.                       else {
  1503.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1504.                                                                                                                                                                                                                               "counterCapacity"=>1,
  1505.                                                                                                                                                                                                                               "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1506.                       }
  1507.                     }
  1508.                   }
  1509.                   else {
  1510.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()] = array("counterUsed"=>0,
  1511.                                                                                                                                                                     "counterCapacity"=>1,
  1512.                                                                                                                                                                     "name"=>$equipmentSpecific->getEquipmentSpecificName(),
  1513.                                                                                                                                                                       "modules"=>array("counterUsed"=>0,
  1514.                                                                                                                                                                                         "counterCapacity"=>1,
  1515.                                                                                                                                                                                         "modulesArray"=>array()),
  1516.                                                                                                                                                                       "interfaces"=>array("counterUsed"=>0,
  1517.                                                                                                                                                                                            "counterCapacity"=>1,
  1518.                                                                                                                                                                                           "interfacesArray"=>array()));
  1519.                     if ($module) {
  1520.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()] = array("counterUsed"=>0,
  1521.                                                                                                                                                                                                             "counterCapacity"=>1,
  1522.                                                                                                                                                                                                             "name"=>$module->getEquipmentSpecificName(),
  1523.                                                                                                                                                                                                             "interfaces"=>array("counterUsed"=>0,
  1524.                                                                                                                                                                                                                                 "counterCapacity"=>1,
  1525.                                                                                                                                                                                                                                 "interfacesArray"=>array()));
  1526.                         $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1527.                                                                                                                                                                                                                                                                                                                         "counterCapacity"=>1,
  1528.                                                                                                                                                                                                                                                                                                                         "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1529.                     }
  1530.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1531.                                                                                                                                                                                                                           "counterCapacity"=>1,
  1532.                                                                                                                                                                                                                           "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1533.                   }
  1534.                 }
  1535.                 else {
  1536.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()] = array("counterUsed"=>0,
  1537.                                                                                                               "counterCapacity"=>1,
  1538.                                                                                                               "name"=>$rack->getTitle(),
  1539.                                                                                                               "equipments"=>array("counterUsed"=>0,
  1540.                                                                                                                                     "counterCapacity"=>1,
  1541.                                                                                                                                     "equipmentsArray"=>array()
  1542.                                                                                                                                     ));
  1543.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()] = array("counterUsed"=>0,
  1544.                                                                                                                                                                   "counterCapacity"=>1,
  1545.                                                                                                                                                                   "name"=>$equipmentSpecific->getEquipmentSpecificName(),
  1546.                                                                                                                                                                     "modules"=>array("counterUsed"=>0,
  1547.                                                                                                                                                                                       "counterCapacity"=>1,
  1548.                                                                                                                                                                                       "modulesArray"=>array()),
  1549.                                                                                                                                                                     "interfaces"=>array("counterUsed"=>0,
  1550.                                                                                                                                                                                          "counterCapacity"=>1,
  1551.                                                                                                                                                                                         "interfacesArray"=>array()));
  1552.                   if ($module) {
  1553.                       $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()] = array("counterUsed"=>0,
  1554.                                                                                                                                                                                                           "counterCapacity"=>1,
  1555.                                                                                                                                                                                                           "name"=>$module->getEquipmentSpecificName(),
  1556.                                                                                                                                                                                                           "interfaces"=>array("counterUsed"=>0,
  1557.                                                                                                                                                                                                                               "counterCapacity"=>1,
  1558.                                                                                                                                                                                                                               "interfacesArray"=>array()));
  1559.                       $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1560.                                                                                                                                                                                                                                                                                                                       "counterCapacity"=>1,
  1561.                                                                                                                                                                                                                                                                                                                       "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1562.                   }
  1563.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1564.                                                                                                                                                                                                                         "counterCapacity"=>1,
  1565.                                                                                                                                                                                                                         "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1566.                 }
  1567.               }
  1568.               else {
  1569.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()] = array("counterUsed"=>0,
  1570.                                                                   "counterCapacity"=>1,
  1571.                                                                   "name"=>$room->getTitle(),
  1572.                                                                   "racks"=>array("counterUsed"=>0,
  1573.                                                                                   "counterCapacity"=>1,
  1574.                                                                                   "racksArray"=>array()));
  1575.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()] = array("counterUsed"=>0,
  1576.                                                                                                             "counterCapacity"=>1,
  1577.                                                                                                             "name"=>$rack->getTitle(),
  1578.                                                                                                             "equipments"=>array("counterUsed"=>0,
  1579.                                                                                                                                   "counterCapacity"=>1,
  1580.                                                                                                                                   "equipmentsArray"=>array()
  1581.                                                                                                                                   ));
  1582.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()] = array("counterUsed"=>0,
  1583.                                                                                                                                                                 "counterCapacity"=>1,
  1584.                                                                                                                                                                 "name"=>$equipmentSpecific->getEquipmentSpecificName(),
  1585.                                                                                                                                                                   "modules"=>array("counterUsed"=>0,
  1586.                                                                                                                                                                                     "counterCapacity"=>1,
  1587.                                                                                                                                                                                     "modulesArray"=>array()),
  1588.                                                                                                                                                                   "interfaces"=>array("counterUsed"=>0,
  1589.                                                                                                                                                                                        "counterCapacity"=>1,
  1590.                                                                                                                                                                                       "interfacesArray"=>array()));
  1591.                 if ($module) {
  1592.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()] = array("counterUsed"=>0,
  1593.                                                                                                                                                                                                         "counterCapacity"=>1,
  1594.                                                                                                                                                                                                         "name"=>$module->getEquipmentSpecificName(),
  1595.                                                                                                                                                                                                         "interfaces"=>array("counterUsed"=>0,
  1596.                                                                                                                                                                                                                             "counterCapacity"=>1,
  1597.                                                                                                                                                                                                                             "interfacesArray"=>array()));
  1598.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1599.                                                                                                                                                                                                                                                                                                                     "counterCapacity"=>1,
  1600.                                                                                                                                                                                                                                                                                                                     "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1601.                 }
  1602.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1603.                                                                                                                                                                                                                       "counterCapacity"=>1,
  1604.                                                                                                                                                                                                                       "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1605.               }
  1606.             }
  1607.             else {
  1608.               $sites["sites"][$site->getId()] = array("counterUsed"=>0,
  1609.                                               "counterCapacity"=>1,
  1610.                                               "name"=>$site->getTitle(),
  1611.                                               "rooms"=>array("counterUsed"=>0,
  1612.                                                               "counterCapacity"=>1,
  1613.                                                               "roomsArray"=>array()));
  1614.               $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()] = array("counterUsed"=>0,
  1615.                                                                 "counterCapacity"=>1,
  1616.                                                                 "name"=>$room->getTitle(),
  1617.                                                                 "racks"=>array("counterUsed"=>0,
  1618.                                                                                 "counterCapacity"=>1,
  1619.                                                                                 "racksArray"=>array()));
  1620.               $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()] = array("counterUsed"=>0,
  1621.                                                                                                           "counterCapacity"=>1,
  1622.                                                                                                           "name"=>$rack->getTitle(),
  1623.                                                                                                           "equipments"=>array("counterUsed"=>0,
  1624.                                                                                                                                 "counterCapacity"=>1,
  1625.                                                                                                                                 "equipmentsArray"=>array()
  1626.                                                                                                                                 ));
  1627.               $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()] = array("counterUsed"=>0,
  1628.                                                                                                                                                               "counterCapacity"=>1,
  1629.                                                                                                                                                               "name"=>$equipmentSpecific->getEquipmentSpecificName(),
  1630.                                                                                                                                                                 "modules"=>array("counterUsed"=>0,
  1631.                                                                                                                                                                                   "counterCapacity"=>1,
  1632.                                                                                                                                                                                   "modulesArray"=>array()),
  1633.                                                                                                                                                                 "interfaces"=>array("counterUsed"=>0,
  1634.                                                                                                                                                                                      "counterCapacity"=>1,
  1635.                                                                                                                                                                                     "interfacesArray"=>array()));
  1636.               if ($module) {
  1637.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()] = array("counterUsed"=>0,
  1638.                                                                                                                                                                                                       "counterCapacity"=>1,
  1639.                                                                                                                                                                                                       "name"=>$module->getEquipmentSpecificName(),
  1640.                                                                                                                                                                                                       "interfaces"=>array("counterUsed"=>0,
  1641.                                                                                                                                                                                                                           "counterCapacity"=>1,
  1642.                                                                                                                                                                                                                           "interfacesArray"=>array()));
  1643.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1644.                                                                                                                                                                                                                                                                                                                   "counterCapacity"=>1,
  1645.                                                                                                                                                                                                                                                                                                                   "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1646.               }
  1647.               $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()] = array("counterUsed"=>0,
  1648.                                                                                                                                                                                                                     "counterCapacity"=>1,
  1649.                                                                                                                                                                                                                     "name"=>$interfaceSpecific->getInterfaceGeneric()->getInterfaceNumber());
  1650.             }
  1652.           //check for nports
  1653.            $nPorts = $interfaceSpecific->getInterfaceGeneric()->getNPorts();
  1654.            if ($nPorts){
  1655.                $nPorts = json_decode($nPorts);
  1656.            } else {
  1657.                $nPorts = [];
  1658.            }
  1659.            if (!in_array($port->getOrderNo(), $nPorts)){
  1660.              if (in_array($port->getId(), $portsAll)) {
  1661.                $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1662.                $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1663.                $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1664.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1665.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1666.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1667.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] + 1;
  1668.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] + 1;
  1669.                if ($module) {
  1670.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] + 1;
  1671.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] + 1;
  1672.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] + 1;
  1673.                  try{
  1674.                     $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1675.                  }
  1676.                  catch(\Exception $ex){}
  1677.                }
  1678.                else {
  1679.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] + 1;
  1680.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1681.                }
  1683.              }
  1684.              else {
  1685.                $tcfsB = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortB($port);
  1687.                if ($tcfsB && count($tcfsB->getExtensions()) > 0) {
  1688.                  $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1689.                  $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1690.                  $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1691.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1692.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1693.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1694.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] + 1;
  1695.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] + 1;
  1696.                  if ($module) {
  1697.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] + 1;
  1698.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] + 1;
  1699.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] + 1;
  1700.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1701.                  }
  1702.                  else {
  1703.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] + 1;
  1704.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1705.                  }
  1706.                  continue;
  1707.                }
  1708.                $usedExt = $this->getDoctrine()->getRepository('App\Entity\TrunkExtension')->findOneByPortB($port);
  1709.                if ($usedExt) {
  1710.                  $tcf = $usedExt->getTrunkCableFiber();
  1711.                  $len = count($tcf->getExtensions());
  1712.                  if ($len != $usedExt->getSequenceNo()) {
  1713.                    $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1714.                    $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1715.                    $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1716.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1717.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1718.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1719.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] + 1;
  1720.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] + 1;
  1721.                    if ($module) {
  1722.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] + 1;
  1723.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] + 1;
  1724.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] + 1;
  1725.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1726.                    }
  1727.                    else {
  1728.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] + 1;
  1729.                      $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1730.                    }
  1731.                    continue;
  1732.                  }
  1733.                }
  1734.                if (count($port->getExtensionOrder()) > 1 ) {
  1735.                  $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1736.                  $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1737.                  $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1738.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1739.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1740.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1741.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["counterUsed"] + 1;
  1742.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["counterUsed"] + 1;
  1743.                  if ($module) {
  1744.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["counterUsed"] + 1;
  1745.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["counterUsed"] + 1;
  1746.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["counterUsed"] + 1;
  1747.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["modules"]["modulesArray"][$module->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1748.                  }
  1749.                  else {
  1750.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["counterUsed"] + 1;
  1751.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["equipments"]["equipmentsArray"][$equipmentSpecific->getId()]["interfaces"]["interfacesArray"][$interfaceSpecific->getId()]["counterUsed"] + 1;
  1752.                  }
  1753.                  continue;
  1754.                }
  1755.              }
  1756.            }
  1757.          }
  1758.        }
  1759.        return $sites;
  1760.     }
  1761.     public function getUsedPortSiteRoomCount()
  1762.     {
  1763.       ini_set("memory_limit", "-1");
  1764.       set_time_limit(0);
  1765.       $sites = array();
  1766.       $sites["counterUsed"] = 0;
  1767.       $sites["counterCapacity"] = 0;
  1768.       $sites["sites"] = array();
  1770.       $portsAllTemp = $this->getDoctrine()->getRepository('App\Entity\Port')->findAllUsedPorts();
  1771.       $portsAll = array();
  1772.       foreach ($portsAllTemp as $tempArray) {
  1773.         foreach ($tempArray as $key => $value) {
  1774.           $portsAll[] = $value;
  1775.         }
  1776.       }
  1778.       $ports = $this->getDoctrine()->getRepository('App\Entity\Port')->findAll();
  1779.        foreach ($ports as $port) {
  1780.          try {
  1781.            $interfaceSpecific = $port->getInterfaceSpecific();
  1782.            $intTypeLink = $interfaceSpecific->getInterfaceGeneric()->getTypeLink()->getTitle();
  1783.            $equipmentSpecificTemp = $interfaceSpecific->getEquipmentSpecific();
  1784.            $module = null;
  1785.            $equipmentSpecific = null;
  1786.            if(!isset($equipmentSpecificTemp)){
  1787.                $interfaceSpecificPortExterne = $port->getInterfaceSpecificPortExterne();
  1788.                if(isset($interfaceSpecificPortExterne)){
  1789.                    $equipmentSpecificTemp = $interfaceSpecificPortExterne->getEquipmentSpecific();
  1790.                    if ($equipmentSpecificTemp->isModule()) {
  1791.                      $module = $equipmentSpecificTemp;
  1792.                      $equipmentSpecific = $equipmentSpecificTemp->getParent();
  1793.                    }
  1794.                    else{
  1795.                        $equipmentSpecific = $equipmentSpecificTemp;
  1796.                    }
  1797.                }
  1798.            }
  1799.            elseif ($equipmentSpecificTemp->isModule()) {
  1800.              $module = $equipmentSpecificTemp;
  1801.              $equipmentSpecific = $equipmentSpecificTemp->getParent();
  1802.            }
  1803.            else {
  1804.              $equipmentSpecific = $equipmentSpecificTemp;
  1805.            }
  1806.            if(!isset($equipmentSpecific)) continue;
  1807.            $rack = $equipmentSpecific->getRack();
  1808.            $room = $rack->getRoom();
  1809.            $site = $room->getSite();
  1810.          } catch (\Exception $e) {
  1811.            continue;
  1812.          }
  1813.         // print " ";
  1814.          if ($intTypeLink == "Simplex" || $intTypeLink == "Duplex" || ($intTypeLink == "Port Externe" && $port->getPortExterne())) {
  1815.            $sites["counterCapacity"] = $sites["counterCapacity"] + 1;
  1816.            if (isset($sites["sites"][$site->getId()])) {
  1817.               $sites["sites"][$site->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["counterCapacity"] + 1;
  1818.               $sites["sites"][$site->getId()]["rooms"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["counterCapacity"] + 1;
  1819.               if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()])) {
  1820.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterCapacity"] + 1;
  1821.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterCapacity"] + 1;
  1822.                 if (isset($sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()])) {
  1823.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterCapacity"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterCapacity"] + 1;
  1825.                 }
  1826.                 else {
  1827.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()] = array("counterUsed"=>0,
  1828.                                                                                                               "counterCapacity"=>1,
  1829.                                                                                                               "name"=>$rack->getTitle());
  1830.                 }
  1831.               }
  1832.               else {
  1833.                 $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()] = array("counterUsed"=>0,
  1834.                                                                   "counterCapacity"=>1,
  1835.                                                                   "name"=>$room->getTitle());
  1836.               }
  1837.             }
  1838.             else {
  1839.               $sites["sites"][$site->getId()] = array("counterUsed"=>0,
  1840.                                               "counterCapacity"=>1,
  1841.                                               "name"=>$site->getTitle(),
  1842.                                               "rooms"=>array("counterUsed"=>0,
  1843.                                                               "counterCapacity"=>1,
  1844.                                                               "roomsArray"=>array()));
  1845.               $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()] = array("counterUsed"=>0,
  1846.                                                                 "counterCapacity"=>1,
  1847.                                                                 "name"=>$room->getTitle());
  1848.             }
  1850.           //check for nports
  1851.            $nPorts = $interfaceSpecific->getInterfaceGeneric()->getNPorts();
  1852.            if ($nPorts){
  1853.                $nPorts = json_decode($nPorts);
  1854.            } else {
  1855.                $nPorts = [];
  1856.            }
  1857.            if (!in_array($port->getOrderNo(), $nPorts)){
  1858.              if (in_array($port->getId(), $portsAll)) {
  1859.                $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1860.                $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1861.                $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1862.                $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1863.                try{
  1864.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1865.                   $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1866.                }
  1867.                catch(Exception $ex){
  1869.                }
  1870.                
  1871.              }
  1872.              else {
  1873.                $tcfsB = $this->getDoctrine()->getRepository('App\Entity\TrunkCableFiber')->findOneByPortB($port);
  1875.                if ($tcfsB && count($tcfsB->getExtensions()) > 0) {
  1876.                  $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1877.                  $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1878.                  $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1879.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1880.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1881.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1882.                  continue;
  1883.                }
  1884.                $usedExt = $this->getDoctrine()->getRepository('App\Entity\TrunkExtension')->findOneByPortB($port);
  1885.                if ($usedExt) {
  1886.                  $tcf = $usedExt->getTrunkCableFiber();
  1887.                  $len = count($tcf->getExtensions());
  1888.                  if ($len != $usedExt->getSequenceNo()) {
  1889.                    $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1890.                    $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1891.                    $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1892.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1893.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1894.                    $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1895.                    continue;
  1896.                  }
  1897.                }
  1898.                if (count($port->getExtensionOrder()) > 1 ) {
  1899.                  $sites["counterUsed"] = $sites["counterUsed"] + 1;
  1900.                  $sites["sites"][$site->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["counterUsed"] + 1;
  1901.                  $sites["sites"][$site->getId()]["rooms"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["counterUsed"] + 1;
  1902.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["counterUsed"] + 1;
  1903.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["counterUsed"] + 1;
  1904.                  $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] = $sites["sites"][$site->getId()]["rooms"]["roomsArray"][$room->getId()]["racks"]["racksArray"][$rack->getId()]["counterUsed"] + 1;
  1905.                  continue;
  1906.                }
  1907.              }
  1908.            }
  1909.          }
  1910.        }
  1911.        return $sites;
  1912.     }
  1914. }