src/Controller/MainController.php line 38

Open in your IDE?
  1. <?php
  2. /*
  3.  * Autor:       Carlos Iglesias
  4.  * Description: Main Controller to handle routes and views, future FTLController
  5.  * Date:        08/December/2020
  6.  */
  7. namespace App\Controller;
  9. use App\Service\FileService;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  18. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  19. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  20. use Symfony\Component\Serializer\Serializer;
  21. use Symfony\Component\Serializer\Normalizer\DateTimeNormalizer;
  23. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  24. use Symfony\Component\Form\Extension\Core\Type\FileType;
  27. use App\Service\ParseService;
  28. use App\Service\ShipmentService;
  29. use Carbon\Carbon;
  31. set_time_limit(0);
  32. class MainController extends AbstractController
  33. {
  34.     
  35.     #[Route('/', name:'upload')]
  36.     public function subirArchivo(Request $request, SessionInterface $session, FileService $fileService)
  37.     {
  38.         return $this->render('/upload.html.twig');
  39.     }
  40.     
  42.     /**
  43.      * @Route("/upload-file", name="_upload_file")
  44.      */
  45.     public function objectTypeInstanceUploadFile(Request $request, FileService $fileService)
  46.     {
  47.         $file = $request->files->get('file');
  48.         if(!$file){
  49.             return $this->json([]);
  50.         }
  52.         $path = $_ENV["PATH_ARCHIVOS"];
  53.         $uploadedFile = $fileService->createFile($file, $path);
  54.         $headerResult = $fileService->getSpreadSheetHeaders($uploadedFile, $path);
  55.         
  56.         return $this->json($headerResult);
  57.     }
  59.     /**
  60.      * @Route("/shipments", name="_shipments")
  61.      */
  62.     public function tablaQuotes(Request $request)
  63.     {
  64.         return $this->render('/listado.html.twig');
  65.     }
  67.     /**
  68.      * @Route("/getAllShipments", name="_get_all_shipments")
  69.      */
  70.     public function getAllShipments(Request $request, ShipmentService $shipmentService)
  71.     {        
  72.         $fechaActual   = new \DateTime();
  73.         //$currentPage = $request->query->get('currentPage') ?? 1;
  74.         //dd($request->query->get('order'));
  75.         //$fechaClon = clone $fechaActual;
  76.         //$fechaHace1Mes = date_modify($fechaClon,'-100day');
  77.         $offSet = $request->query->get('start');
  78.         $limit = $request->query->get('length');
  79.         $order = $request->query->get('order') ?? ['column' => 'id', 'type' => 'asc'];
  80.         $colums = $request->query->get('columns') ?? [];
  81.         $shipments = $shipmentService->getAllShipmentsDelMes($offSet, $limit, $order, $colums);
  82.         
  83.         $logs = [];
  84.         foreach($shipments['results'] as $shipment){
  85.             if($shipment->getEmpatado() != true){
  86.                 $logs[] = [
  87.                     "IdShip"                    => $shipment->getIdShip(),
  88.                     "OpenDate"                  => $shipment->getOpenDate() != null ? Carbon::instance($shipment->getOpenDate())->toDateString() : null,
  89.                     "Shipper"                   => $shipment->getShipper(),
  90.                     "OpenedBy"                  => $shipment->getOpenedBy(),
  91.                     "Branch"                    => $shipment->getBranch(),
  92.                     "Type"                      => $shipment->getType(),
  93.                     "SubType"                   => $shipment->getSubType(),
  94.                     "Routing"                   => $shipment->getRouting(),
  95.                     "Origin"                    => $shipment->getOrigin(),
  96.                     "Consignee"                 => $shipment->getConsignee(),
  97.                     "FinalDestination"          => $shipment->getFinalDestination(),
  98.                     "OpenPayableLocal"          => $shipment->getOpenPayableLocal(),
  99.                     "OpenReceivableProfit"      => $shipment->getOpenReceivableProfit(),
  100.                     "OpenPayableProfit"         => $shipment->getOpenPayableProfit(),
  101.                     "OpenReceivableLocal"       => $shipment->getOpenReceivableLocal(),
  102.                     "ActualProfit"              => $shipment->getActualProfit(),
  103.                     "SpecialServiceType"        => $shipment->getSpecialServiceType(),
  104.                     "Customer"                  => $shipment->getCustomer(),
  105.                     "FinalArrivalDate"          => $shipment->getFinalArrivalDate() != null ? Carbon::instance($shipment->getFinalArrivalDate())->toDateString() : null,
  106.                     "FirstPickupETA"            => $shipment->getFirstPickupETA() != null ? Carbon::instance($shipment->getFirstPickupETA())->toDateString() : null,
  107.                     "FromWhere"                 => $shipment->getFromWhere(),
  108.                     "TrailerNo"                 => $shipment->getTrailerNo(),
  109.                     "CarrierNo"                 => $shipment->getCarrierNo(),
  110.                     "EstimatedFinalArrivalDate" => $shipment->getEstimatedFinalArrivalDate() != null ? Carbon::instance($shipment->getEstimatedFinalArrivalDate())->toDateString() : null,
  111.                     "Salesman"                  => $shipment->getSalesman(),
  112.                     "FromPortCountry"           => $shipment->getFromPort(),
  113.                     "ToWhere"                   => $shipment->getToWhere(),
  114.                     "ToPortCountry"             => $shipment->getToPortCountry(),
  115.                     'ActualFinalArrivalDate'    => $shipment->getActualFinalArrivalDate() != null ? Carbon::instance($shipment->getActualFinalArrivalDate())->toDateString() : null
  116.                 ];  
  117.             } 
  118.         }
  119.         
  120.          return $this->json([
  121.                 'data' => $logs, 
  122.                 'recordsTotal' => $shipments['totalRecords'],
  123.                 'recordsFiltered' => $shipments['totalRecords']
  124.         ]);
  125.     }
  126.     /**
  127.      * @Route("/pushEmpate", name="_push_empate")
  128.      */
  129.     public function pushEmpate(Request $request, ShipmentService $shipmentService)
  130.     {
  131.         $empateArray = [
  132.         //Para crear un empate
  133.             'month'         => $request->query->get('month'),
  134.             'openDate'      => $request->query->get('openDate'),
  135.             'requestForm'   => $request->query->get('request'),
  136.             'idShip'        => $request->query->get('idShip'),
  137.             'openedBy'      => $request->query->get('openedBy'),
  138.             'customer'      => $request->query->get('customer'),
  139.             'subtype'       => $request->query->get('subtype'),
  140.             'fromWhere'     => $request->query->get('fromWhere'),
  141.             'fromPort'      => $request->query->get('fromPort'),
  142.             'toWhere'       => $request->query->get('toWhere'),
  143.             'toPort'        => $request->query->get('toPort'),
  144.             'eid'           => $request->query->get('eid'),
  145.             'estimatedDate' => $request->query->get('estimatedDate'),
  146.             'carrier'       => $request->query->get('carrier'),
  147.             'cliente'       => $request->query->get('cliente'),
  148.             'branch'        => $request->query->get('branch'),
  149.             'salesman'      => $request->query->get('salesman'),
  150.             'notes'         => $request->query->get('notas'),
  151.             'shipIdViejo'   => $request->query->get('shipIdViejo'),
  152.             'empateId'      => $request->query->get('empateId'),
  153.             'status'        => $request->query->get('status'),
  154.             'statusReinicio'=> $request->query->get('statusReinicio'),
  155.             'cotizacion'    => $request->query->get('cotizacion'),
  156.         ];
  158.         $shipmentService->crearEmpate($empateArray);
  160.         return $this->json(["data" => true]);
  162.     }
  164.     /**
  165.      * @Route("/truckReport", name="_truck_report")
  166.      */
  167.     public function tablaEmpates(Request $request)
  168.     {
  169.         return $this->render('/truckReport.html.twig');
  170.     }
  172.     /**
  173.      * @Route("/getAllEmpates", name="_get_all_empates")
  174.      */
  175.     public function getAllEmpates(Request $request, ShipmentService $shipmentService)
  176.     {
  177.         $empates = $shipmentService->getAllEmpates();
  178.         
  179.         $logs = [];
  180.         foreach($empates as $empate){
  181.             $fechaNull = new \DateTime('-0001-11-30');
  182.                 $logs[] = [
  183.                     'month'         => ($empate->getMonth() == $fechaNull) ? '' : $empate->getMonth(),
  184.                     'openDate'      => ($empate->getOpenDate() == $fechaNull) ? '' : $empate->getOpenDate(),
  185.                     'requestForm'   => $empate->getRequest(),
  186.                     'idShip'        => $empate->getIdShip(),
  187.                     'openedBy'      => $empate->getOpenedBy(),
  188.                     'customer'      => $empate->getCustomer(),
  189.                     'subtype'       => $empate->getSubtype(),
  190.                     'fromWhere'     => $empate->getFromWhere(),
  191.                     'fromPort'      => $empate->getFromPort(),
  192.                     'toWhere'       => $empate->getToWhere(),
  193.                     'toPort'        => $empate->getToPort(),
  194.                     'etd'           => ($empate->getETD() == $fechaNull) ? '' : $empate->getETD(),
  195.                     'estimatedDate' => ($empate->getEstimatedArrivalDate() == $fechaNull) ? '' : $empate->getEstimatedArrivalDate(),
  196.                     'carrier'       => $empate->getCarrier(),
  197.                     'cliente'       => $empate->getClienteEmpate(),
  198.                     'branch'        => $empate->getBranch(),
  199.                     'salesman'      => $empate->getSalesman(),
  200.                     'notes'         => $empate->getNotes(),
  201.                     'linkedTo'      => $empate->getLinkedTo()?->getIdShip(),
  202.                     'id'            => $empate->getId(),
  203.                     'status'        => $empate->getStatus(),
  204.                     'statusReinicio'=> $empate->getStatusReinicio(),
  205.                     'cotizacion'    => $empate->getCotizacion()
  206.                 ];  
  207.         }
  209.         // return $this->json($logs);
  210.         $encoders = [new JsonEncoder()];
  211.         $normalizers = [ new DateTimeNormalizer(array('datetime_format' => 'Y-m-d')), new ObjectNormalizer()];
  212.         $serializer = new Serializer($normalizers, $encoders);
  213.         $quotesTO= $serializer->serialize( ['data'=>$logs], 'json');
  214.         return new Response ($quotesTO);
  215.     }
  217.     /**
  218.      * @Route("/rutas", name="_rutas")
  219.      */
  220.     public function rutas(Request $request, ShipmentService $shipmentService)
  221.     {
  222.         $fechaActual   = new \DateTime();        
  223.         $fechaClon = clone $fechaActual;
  224.         $fechaHace1Mes = date_modify($fechaClon,'-45day');
  225.         $rutasOrigen = $shipmentService->getAllRoutesOrigen($fechaHace1Mes, $fechaActual);
  226.         $rutasDestino = $shipmentService->getAllRoutesDestino($fechaHace1Mes, $fechaActual);
  227.         $subTypes = $shipmentService->getAllSubTypes($fechaHace1Mes, $fechaActual);
  228.         $shipmentsRoutes = $shipmentService->getAllRoutes($fechaHace1Mes, $fechaActual, null, null, null, null, null);
  230.         
  231.         return $this->render('/filtro_ciudad.html.twig', [
  232.             'origenes' => $rutasOrigen,
  233.             'destinos' => $rutasDestino,
  234.             'searchedText' => null,
  235.             'shipments' => $shipmentsRoutes,
  236.             'subTypes' => $subTypes
  237.         ]);
  238.     }
  240.     /**
  241.      * @Route("/filtrarShipments", name="_filtrar_shipments")
  242.      */
  243.     public function filtrarShipments(Request $request, ShipmentService $shipmentService)
  244.     {
  245.         $origenes = $request->query->get("origenes");
  246.         $destinos = $request->query->get("destinos");
  247.         $subTypes = $request->query->get("subTypes");
  248.         $fromWhenString = $request->query->get("fromWhen");
  249.         $toWhenString = $request->query->get("toWhen");
  250.         $mostrarComo = $request->query->get("mostrarComo");
  251.         
  252.         $fromWhen = ($fromWhenString) ? new \DateTime($fromWhenString) : null;
  253.         $toWhen = ($toWhenString) ? new \DateTime($toWhenString) : null;
  255.         $name = $request->query->get("name");
  256.         $fechaActual   = new \DateTime();        
  257.         $fechaClon = clone $fechaActual;
  258.         $fechaHace1Mes = date_modify($fechaClon,'-45day');
  260.         if($mostrarComo == 'list'){
  261.             $resultados = $shipmentService->getRouting($fechaHace1Mes, $fechaActual, $origenes, $destinos, $fromWhen, $toWhen);
  262.             
  263.             if(!empty($resultados)){
  264.                 $shipments = [];
  265.                 foreach($resultados as $resultado){
  266.                     $shipments[] = [
  267.                         'id' => $resultado->getId(),
  268.                         'origin' => $resultado->getOrigin(),
  269.                         'idShip' => $resultado->getIdShip(),
  270.                         'shipper'=> $resultado->getShipper(),
  271.                         'type' => $resultado->getType(),
  272.                         'subType' => $resultado->getSubType(),
  273.                         'customer'=> $resultado->getCustomer(),
  274.                         'finalArrivalDate' => ($resultado->getFinalArrivalDate() != null) ? ($resultado->getFinalArrivalDate())->format('d-m-Y') : null,
  275.                         'finalDestination' => $resultado->getFinalDestination(),
  276.                         'actualFinalArrivalDate' => ($resultado->getActualFinalArrivalDate() != null) ? ($resultado->getActualFinalArrivalDate())->format('d-m-Y') : null,
  277.                     ];
  278.                 }
  279.                 $response = $this->renderView('render_shipments_routes.html.twig', [
  280.                     'shipments' => $shipments,
  281.                     'showInTwoColumns' => true
  282.                 ]);
  283.                 return $this->json(["data" => $response]);
  284.             }else{
  285.                 return $this->json(["data" => 'No hay embarques con estas características.']);
  286.             }
  287.         }else{
  288.             $resultados = $shipmentService->getAllRoutes($fechaHace1Mes, $fechaActual, $origenes, $destinos, $fromWhen, $toWhen, $subTypes);
  289.             
  290.             if(!empty($resultados)){
  291.                 $response = $this->renderView('shipment_list_template.html.twig', [
  292.                     'shipments' => $resultados,
  293.                 ]);
  294.                 return $this->json(["data" => $response]);
  295.             }else{
  296.                 return $this->json(["data" => 'Tú búsqueda no arrojo ningún resultado.']);
  297.             }
  298.         }
  299.     }
  301.     /**
  302.      * @Route("/getShipmentByRouting", name="_get_shipment_by_routing")
  303.      */
  304.     public function getShipmentByRouting(Request $request, ShipmentService $shipmentService)
  305.     {
  306.         $origen = $request->query->get("origen");
  307.         $destino = $request->query->get("destino");
  308.         $fromWhenString = $request->query->get("fromWhen");
  309.         $toWhenString = $request->query->get("toWhen");
  310.         $subTypes = $request->query->get("subTypes");
  311.         
  312.         $fromWhen = ($fromWhenString) ? new \DateTime($fromWhenString) : null;
  313.         $toWhen = ($toWhenString) ? new \DateTime($toWhenString) : null;
  314.         $fechaActual   = new \DateTime();        
  315.         $fechaClon = clone $fechaActual;
  316.         $fechaHace1Mes = date_modify($fechaClon,'-45day');
  317.         $resultados = $shipmentService->getRouting( $fechaHace1Mes, $fechaActual, $origen, $destino, $fromWhen, $toWhen, $subTypes);
  318.         if(!empty($resultados)){
  319.             $shipments = [];
  320.             foreach($resultados as $resultado){
  321.                 $shipments[] = [
  322.                     'id' => $resultado->getId(),
  323.                     'origin' => $resultado->getOrigin(),
  324.                     'idShip' => $resultado->getIdShip(),
  325.                     'shipper'=> $resultado->getShipper(),
  326.                     'type' => $resultado->getType(),
  327.                     'subType' => $resultado->getSubType(),
  328.                     'customer'=> $resultado->getCustomer(),
  329.                     'finalArrivalDate' => ($resultado->getFinalArrivalDate() != null) ? ($resultado->getFinalArrivalDate())->format('d-m-Y') : null,
  330.                     'finalDestination' => $resultado->getFinalDestination(),
  331.                     'actualFinalArrivalDate' => ($resultado->getActualFinalArrivalDate() != null) ? ($resultado->getActualFinalArrivalDate())->format('d-m-Y') : null,
  332.                 ];
  333.             }
  334.             $response = $this->renderView('render_shipments_routes.html.twig', [
  335.                 'shipments' => $shipments,
  336.                 'showInTwoColumns' => false
  337.             ]);
  338.             return $this->json(["data" => $response]);
  339.         }else{
  340.             return $this->json(["data" => 'No hay embarques con estas características.']);
  341.         }
  342.     }
  343.     /**
  344.      * @Route("/desempatarEmpate", name="_desempatar_empate")
  345.      */
  346.     public function desempatarEmpate(Request $request, ShipmentService $shipmentService)
  347.     {
  348.         $idShip = $request->query->get("idShip");
  349.         $empate = $shipmentService->getEmpateById($idShip);
  350.         $shipmentService->desempatarEmpate($empate);
  351.         return $this->json(["data" => 'true']);
  352.     }
  354.     /**
  355.      * @Route("/metas", name="_metas")
  356.      */
  357.     public function metas(Request $request)
  358.     {   
  359.         $meses = ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio',
  360.             'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'];
  361.         return $this->render('admin/metas.html.twig', ['meses' => $meses]);
  362.     }
  363. }