src/Controller/VehiclesController.php line 152

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AuctionVehicles;
  6. use App\Entity\Companies;
  7. use App\Entity\Users;
  8. use App\Entity\VehicleClients;
  9. use App\Entity\VehicleDocTypes;
  10. use App\Entity\VehicleDocs;
  11. use App\Entity\VehicleRegistrations;
  12. use App\Entity\Vehicles;
  13. use App\Entity\VehicleOwnershipTransfer;
  14. use App\Entity\VehicleSales;
  15. use App\Form\VehicleRegistrationsType;
  16. use App\Form\VehiclesSearchType;
  17. use App\Service\FileHandler;
  18. use App\Service\VehiclesService;
  19. use Knp\Component\Pager\PaginatorInterface;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Component\Security\Http\Attribute\IsGranted;
  22. use Symfony\Component\ExpressionLanguage\Expression;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  25. use Symfony\Component\Form\Extension\Core\Type\TextType;
  26. use Symfony\Component\Form\Form;
  27. use Symfony\Component\HttpFoundation\JsonResponse;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpFoundation\Response;
  30. use Symfony\Component\Filesystem\Filesystem;
  31. use App\Validator\Constraints\SerialnumberVehicleRegisteration;
  32. use Symfony\Component\Validator\Validator\ValidatorInterface;
  33. use Symfony\Contracts\Translation\TranslatorInterface;
  34. use Doctrine\Persistence\ManagerRegistry;
  36. /**
  37.  * Vehicle controller.
  38.  *
  39.  * @Route("vehicles")
  40.  */
  41. #[Route('vehicles')]
  42. class VehiclesController extends AbstractController
  43. {
  44.     /**
  45.      * Lists all vehicle entities.
  46.      *
  47.      * @return \Symfony\Component\HttpFoundation\Response
  48.      */
  49.     #[Route('/', name: 'vehicles_index', methods:["GET"])]
  50.     #[IsGranted('ROLE_ADMIN')]
  51.     public function indexAction(Request $request, PaginatorInterface $paginator, VehiclesService $vehiclesService, ManagerRegistry $doctrine)
  52.     {
  53.         $locale = $request->getLocale();
  55.         $em = $doctrine->getManager();
  57.         //create the search form and bind request to it (this populates the search form fields with posted data)
  58.         $searchForm = $this->createForm(VehiclesSearchType::class,array(
  59.             'locale'                 => $locale,
  60.             'em' => $em
  61.         ));
  63.         $searchForm->handleRequest($request);
  64.         $searchFormSubmittedFields= [];
  65.         if ($searchForm->isSubmitted()) {
  66.             $submittedSearchForm = $request->query->all()[$searchForm->getConfig()->getType()->getBlockPrefix()];
  67.             $searchFormSubmittedFields = array_filter($submittedSearchForm);
  68.         }
  70.         $vehiclesSearch = $vehiclesService->listVehiclesSearch($searchFormSubmittedFields);
  72.         $repository = $paginator->paginate(
  73.             $vehiclesSearch,
  74.             $request->query->getInt('page', 1),
  75.             $request->query->getInt('limit', 20)
  76.         );
  78.         return $this->render('vehicles/index.html.twig', [
  79.             'vehicles'    => $repository,
  80.             'searchForm'  => $searchForm->createView(),
  81.             'locale'      => $locale
  82.         ]);
  83.     }
  85.     /**
  86.      * Creates a new vehicle entity.
  87.      *
  88.      * @return \Symfony\Component\HttpFoundation\RedirectResponse|\Symfony\Component\HttpFoundation\Response
  89.      */
  90.     #[Route('/new', name: 'vehicles_new', methods:["GET", "POST"])]
  91.     #[IsGranted('ROLE_ADMIN')]
  92.     public function newAction(Request $request, FileHandler $fileHandler, TranslatorInterface $translator, ValidatorInterface 
  93.             $validator, VehiclesService $vehiclesService, ManagerRegistry $doctrine)
  94.     {
  95.         $loginUser = $this->getUser();
  97.         $locale    = $request->getLocale();
  98.         $em        = $doctrine->getManager();
  99.         $existingSNVehicleId = '';
  100.         $existingVINVehicleId = '';
  101.         $existingPTVehicleId = '';
  103.         $vehicleRegistrations = new VehicleRegistrations();
  104.         $vehicle              = new Vehicles();
  106.         $registrationDoc = new VehicleDocs();
  107.         $docType         = VehicleDocTypes::DOC_TYPES['vehicle_registration']; //the document will be from vehicle_registration DocType
  108.         $registrationDoc->setDocType($em->getRepository(VehicleDocTypes::class)->find($docType));
  109.         $registrationDoc->setVehicle($vehicle);
  110.         $registrationDoc->setCreatedBy($loginUser);
  112.         $vehicleRegistrations->setVehicle($vehicle);
  113.         $vehicleRegistrations->setRegistrationDoc($registrationDoc);
  115.         $vehicleForm = $this->createForm(VehicleRegistrationsType::class, $vehicleRegistrations, ['locale' => $locale, 'attr' => ['onsubmit' => "return fnValidate()"]]);
  116.         $vehicleForm->handleRequest($request);
  118.         if ($vehicleForm->isSubmitted() && $vehicleForm->isValid()) {
  119.             $vehiclesService->createNewVehicle($vehicleRegistrations,$registrationDoc,$vehicle,$fileHandler);
  120.             $session = $request->getSession();
  121.             $session->getFlashBag()->add('success',
  122.                 $translator->trans('vehicle added successfully', [], 'vehicles')
  123.             );
  124.             return $this->redirectToRoute('vehicles_edit', ['vehicleId' => $vehicle->getVehicleId()]);
  125.         } elseif ($vehicleForm->isSubmitted() && ! $vehicleForm->isValid()) {
  126.             //in case if the form is invalid, check if serial number uniqueness validation is the constraint that was
  127.             //violated. if so, some special handling has to be performed. The user will be prompted to either proceed
  128.             //with creating the vehicle or to ignore the creation of the veihlce and go to the already existing vehicle
  129.             //with that registration serial number
  130.             $violations = $validator->validate($vehicleRegistrations);
  131.             if (0 !== count($violations->findByCodes(SerialnumberVehicleRegisteration::NOT_UNIQUE_SERIAL_ERROR))) {
  132.                 $existingSNVehicleId = $vehicleRegistrations->getExistingSNVehicleId();
  133.                 $existingVINVehicleId = $vehicleRegistrations->getExistingVINVehicleId();
  134.                 $existingPTVehicleId = $vehicleRegistrations->getExistingPTVehicleId();
  135.             }
  136.         }
  137.         return $this->render('vehicles/new.html.twig', [
  138.             'form' => $vehicleForm->createView(),
  139.             'existingSNVehicleId' => $existingSNVehicleId,
  140.             'existingVINVehicleId'=> $existingVINVehicleId,
  141.             'existingPTVehicleId' => $existingPTVehicleId
  142.         ]);
  143.     }
  145.     /**
  146.      * Displays a form to edit an existing vehicle entity or to proceed with new vehicle creation.
  147.      *
  148.      * @return \Symfony\Component\HttpFoundation\Response
  149.      */
  150.     #[Route('/{vehicleId}/edit', name: 'vehicles_edit', methods:["GET"])]
  151.     #[IsGranted(new Expression("is_granted('ROLE_ADMIN') or is_granted('ROLE_BENEFICIARY_REP')"))]
  152.     public function editAction(VehicleRegistrations $vehicleRegistrations, Request $request)
  153.     {
  154.         $locale = $request->getLocale();
  156.         $vehicle               = $vehicleRegistrations->getVehicle();
  158.         $fileRealPath = $this->getParameter('web_dir_path') . $this->getParameter('vehicle_uploaded_files') . '/' . $vehicle->getVehicleId(). '/';
  159.         $fileSystem = new Filesystem();
  160.         if(!$fileSystem->exists($fileRealPath)){
  161.             //if no dir yet for the vehicle images then create one
  162.             $fileSystem->mkdir($fileRealPath);
  163.         }
  165.         $maker = ($vehicleRegistrations->getModel())?$vehicleRegistrations->getModel()->getMaker() : '';
  166.         //populate panel 0 form: fill a VehicleRegistrations form with VehicleRegistrations entity data
  167.         $vehicleEditForm = $this->createForm(VehicleRegistrationsType::class, $vehicleRegistrations, ['locale' => $locale,'maker'=> $maker, 'attr' => ['onsubmit' => "return fnValidate()"] ]);
  169.         $owner = [];
  171.         if($vehicleRegistrations->getVehicleOwner()){
  172.             $owner['ownerId']  =$vehicleRegistrations->getVehicleOwner()->getClientId();
  173.             $owner['ownerName']  =$vehicleRegistrations->getVehicleOwner()->getName($locale);
  174.         }
  175.         return $this->render('vehicles/edit.html.twig', [
  176.             'vehicle'                     => $vehicle,
  177.             'vehicle_edit_form'           => $vehicleEditForm->createView(),
  178.             'owner'                       => $owner
  179.         ]);
  180.     }
  182.     /**
  183.      * Update an existing vehicle entity or proceed with new vehicle creation.
  184.      *
  185.      * @return \Symfony\Component\HttpFoundation\RedirectResponse
  186.      */
  187.     #[Route('/{vehicleId}/edit', name: 'vehicles_update', methods:["POST"])]
  188.     #[IsGranted(new Expression("is_granted('ROLE_ADMIN') or is_granted('ROLE_BENEFICIARY_REP')"))]
  189.     public function updateAction(Request $request, VehicleRegistrations $vehicleRegistrations, VehiclesService $vehiclesService, ManagerRegistry $doctrine) {
  191.         $locale = $request->getLocale();
  192.         $vehicle               = $vehicleRegistrations->getVehicle();
  193.         $vehicleId             = $vehicle->getVehicleId();
  194.         $registrationDoc       = $vehicleRegistrations->getRegistrationDoc();
  196.         //$registrationDoc is holding the data from DB so far. we will check if there is already imagePath for it in DB
  197.         $em                    = $doctrine->getManager();
  198.         //$form            = $request->request->get('appbundle_vehicleregistrations');
  199.         $formPostData            = $request->request->all();
  200.         $clearImage      = $formPostData['appbundle_vehicleregistrations']['registrationDoc']['clearImage'];
  201.         $vehicleEditForm = $this->createForm(VehicleRegistrationsType::class, $vehicleRegistrations , ['locale' => $locale ]);
  202.         $imageNameDB = "";
  203.         if($registrationDoc && $registrationDoc->getImagePath()){
  204.             $imageNameDB = $registrationDoc->getImagePath();
  205.         }
  206.         $vehicleDocsRepository = $em->getRepository(VehicleDocs::class);
  207.         $imagesDirWebPath      = $this->getParameter('vehicle_uploaded_files') . '/' . $vehicle->getVehicleId(). '/';
  208.         $imagesDirRealPath     = $this->getParameter('web_dir_path') . $imagesDirWebPath;
  210.         $vehicleEditForm->handleRequest($request);
  212.         //special handling for registration image as it could be an new uploaded binary image or just a path to existing image
  213.         if ($vehicleRegistrations->getRegistrationDoc()) {
  214.             //save or restore image
  215.             $vehicleDocsRepository->saveDocumentImagePathFile($vehicleRegistrations->getRegistrationDoc(), $imagesDirRealPath, $imageNameDB, $clearImage);
  216.         }
  217.         //validate, get vehicle owner and vehicle actual user preperties, then save
  218.         if ($vehicleEditForm->isSubmitted() && $vehicleEditForm->isValid()) {
  219.             $vehiclesService->updateVehicle($vehicle,$vehicleRegistrations);
  221.             return $this->redirectToRoute('vehicles_update', ['vehicleId' => $vehicleId]);
  222.         }
  223.         $owner = [];
  225.         if($vehicleRegistrations->getVehicleOwner()){
  226.             $owner['ownerId']  =$vehicleRegistrations->getVehicleOwner()->getClientId();
  227.             $owner['ownerName']  =$vehicleRegistrations->getVehicleOwner()->getName($locale);
  228.         }
  229.         return $this->render('vehicles/edit.html.twig', [
  230.             'vehicle'                     => $vehicle,
  231.             'vehicle_edit_form'           => $vehicleEditForm->createView(),
  232.             'owner'                       => $owner
  233.         ]);
  235.     }
  237.     /**
  238.      * Deletes a vehicle entity.
  239.      *
  240.      * @return \Symfony\Component\HttpFoundation\RedirectResponse
  241.      */
  242.     #[Route('/{vehicleId}', name: 'vehicles_delete', methods:["DELETE"])]
  243.     #[IsGranted('ROLE_SUPER_ADMIN')]
  244.     public function deleteAction(Request $request, Vehicles $vehicle, TranslatorInterface $translator, ManagerRegistry $doctrine)
  245.     {
  246.         $form = $this->createDeleteForm($vehicle);
  247.         $form->handleRequest($request);
  249.         if ($form->isSubmitted() && $form->isValid()) {
  250.             $em = $doctrine->getManager();
  251.             $em->remove($vehicle);
  252.             $em->flush();
  253.             $session = $request->getSession();
  254.             $session->getFlashBag()->add('success',
  255.                 $translator->trans('vehicle deleted successfully', [], 'vehicles')
  256.             );
  257.         }
  259.         return $this->redirectToRoute('vehicles_index');
  260.     }
  262.     /**
  263.      * Creates a form to delete a vehicle entity.
  264.      *
  265.      * @param Vehicles $vehicle The vehicle entity
  266.      *
  267.      * @return Form The form
  268.      */
  269.     private function createDeleteForm(Vehicles $vehicle)
  270.     {
  271.         return $this->createFormBuilder()
  272.             ->setAction($this->generateUrl('vehicles_delete', ['vehicleId' => $vehicle->getVehicleId()]))
  273.             ->setMethod('DELETE')
  274.             ->getForm()
  275.             ;
  276.     }
  279.     /**
  280.      * @return Response|JsonResponse json array makers_models under specific maker.
  281.      */
  282.     #[Route('/getUserName', name: 'get_name_ajax')]
  283.     public function getUserName(Request $request, ManagerRegistry $doctrine)
  284.     {
  285.         if ($request->isXMLHttpRequest()) {
  286.             $NID    = $request->request->get('ID');
  287.             $checkIdNumber=$NID;
  288.             $leng=strlen((string)$checkIdNumber); //check the string length and make convert to string then check length of string
  289.             if($leng!=10){
  290.                 $res = ['error' => "Id must be 10 digit",'type' => 'swal'];
  291.                 return new JsonResponse($res);
  292.             }
  294.             $repository = $doctrine->getRepository(Users::class);
  295.             $names = $repository->getUserName($NID);
  296.             if (!empty($names)) {
  297.                 $res = ['success' => true, 'names' => $names, 'type' => 'users'];
  298.             } else {
  299.                 $repository = $doctrine->getRepository(Companies::class);
  300.                 $names = $repository->getNames($NID);
  302.                 $res = empty($names) ? ['error' => "No Record Found"] : ['success' => true, 'names' => $names, 'type' => 'comp'];
  303.             }
  305.             return new JsonResponse($res);
  306.         }
  308.         return new Response('This is not ajax!', 400);
  309.     }
  311.     /**
  312.      * make a vehicle situation is marked for sale.
  313.      *
  314.      * @return Response
  315.      */
  316.     #[Route('/markedForSale', name: 'make_vehicle_marked_for_sale')]
  317.     #[IsGranted('ROLE_ADMIN')]
  318.     public function makeVehicleMarkedForSale(Request $request, ManagerRegistry $doctrine)
  319.     {
  320.         $loginUser = $this->getUser();
  321.         if ($request->isXMLHttpRequest()) {
  322.             $vehicleID = $request->request->get('vehicleID');
  323.             $em        = $doctrine->getManager();
  324.             $vehicleRepository = $em->getRepository(Vehicles::class);
  325.             $vehicle   = $vehicleRepository->find($vehicleID);
  326.             $vehicle->setOfferabilityForSale(Vehicles::SALE_OFFERABILITY['Marked_For_Sale']);
  328.             $vehicleRepository->createVehicleOfferailityLog(Vehicles::SALE_OFFERABILITY['Marked_For_Sale'] , $vehicle, $loginUser);
  329.             $em->flush();
  331.             return new JsonResponse();
  332.         }
  334.         return new Response('This is not ajax!', 400);
  335.     }
  337.     /**
  338.      *  auction information for vehicle.
  339.      *
  340.      * @return \Symfony\Component\HttpFoundation\Response
  341.      */
  342.     #[Route('/{vehicleId}/auctionInfoVehicle', name: 'auction_info_vehicle', methods:["GET"])]
  343.     #[IsGranted('ROLE_ADMIN')]
  344.     public function getAuctionInfoVehicleAction(Request $request, Vehicles $vehicle, ManagerRegistry $doctrine)
  345.     {
  346.         $locale = $request->getLocale();
  347.         $em = $doctrine->getManager();
  348.         $auctionVehicles = $em->getRepository(AuctionVehicles::class)->findBy(['vehicle' => $vehicle]);
  350.         if ($vehicle->getVehicleBeneficiaryDetails()->getBeneficiary()) {
  351.             $beneficiary = $vehicle->getVehicleBeneficiaryDetails()->getBeneficiary()->getName($locale);
  352.             $beneficiary_type = $vehicle->getVehicleBeneficiaryDetails()->getBeneficiary()->getClientType();
  353.             $beneficiary_id = $vehicle->getVehicleBeneficiaryDetails()->getBeneficiary()->getClientId();
  354.         }
  356.         return $this->render('vehicles/auctionInfoVehicle.html.twig', [
  357.             'auctionVehicles'  => $auctionVehicles,
  358.             'beneficiary'      => $beneficiary,
  359.             'beneficiary_type' => $beneficiary_type,
  360.             'beneficiary_id'   => $beneficiary_id,
  361.             'locale'           => $locale,
  362.             'vehicle'          => $vehicle,
  363.         ]);
  365.     }
  367.     /**
  368.      *  Required papers for sold vehicle ownership transfer
  369.      *
  370.      * @return \Symfony\Component\HttpFoundation\Response
  371.      */
  372.     #[Route('/{vehicleId}/soldvpapers4OT', name: 'sold_vehicle_papers_4_ot', methods:["GET"])]
  373.     #[IsGranted('ROLE_USER')]
  374.     public function soldVehiclePapers4OTAction(Request $request, Vehicles $vehicle, ManagerRegistry $doctrine)
  375.     {
  376.         $locale = $request->getLocale();
  377.         $em = $doctrine->getManager();
  378.         $plateNumber= $vehicle->getVehicleRegistrations()->getPlateNumber($locale);
  379.         $vehicleOwner= $vehicle->getVehicleRegistrations()->getVehicleOwner();
  380.         if($vehicleOwner->getClientType() == VehicleClients::CLIENT_TYPES['user'] ){
  381.             $ownerId= $vehicleOwner->getUser()->getUserId();
  382.             $ownerIdentityPhoto= $vehicleOwner->getUser()->getUserIdentityInfo()->getImagePath();
  383.             $ownerMobileNumber= $vehicleOwner->getUser()->getMobileNumber();
  384.         }elseif($vehicleOwner->getClientType() == VehicleClients::CLIENT_TYPES['company'] ){
  385.             $ownerId= $vehicleOwner->getCompany()->getCompanyId();
  386.             $ownerIdentityPhoto= $vehicleOwner->getCompany()->getCompanyRegistration()->getFilePath();
  387.         }
  389.         $renunciationLetterType= $em->getRepository(VehicleDocTypes::class)->find(
  390.             VehicleDocTypes::DOC_TYPES['letter_of_renunciation'] );
  392.         $renunciationLetter = $em->getRepository(VehicleDocs::class)->findOneBy(['vehicle'=>$vehicle, 'docType'=> $renunciationLetterType]);
  394.         return $this->render('vehicles/soldVehiclePapers4OT.html.twig', [
  395.             'locale'           => $locale,
  396.             'vehicle'          => $vehicle,
  397.             'plateNumber'          => $plateNumber,
  398.             'ownerId'          => $ownerId,
  399.             'ownerIdentityPhoto'          => $ownerIdentityPhoto,
  400.             'ownerMobileNumber'          => (isset($ownerMobileNumber))?$ownerMobileNumber:null,
  401.             'renunciationLetter'          => $renunciationLetter,
  402.         ]);
  404.     }
  406.     /**
  407.      *
  408.      * @return Response|JsonResponse json array warehouses under specific city.
  409.      */
  410.     #[Route('/getImages', name: 'get_images_ajax')]
  411.     public function getImages(Request $request)
  412.     {
  413.         if (!$request->isXMLHttpRequest()) {
  414.             return new Response('This is not ajax!', 400);
  415.         }
  417.         $vehicleId = $request->request->get('id');
  419.         $dirRelativePath = $this->getParameter('vehicle_uploaded_files') . '/' . $vehicleId . '/';
  420.         $fileSystem = new Filesystem();
  421.         if(!$fileSystem->exists($dirRelativePath)){
  422.             //if no dir yet for the vehicle images then create one
  423.             $fileSystem->mkdir($dirRelativePath);
  424.         }
  426.         $handle = opendir($dirRelativePath);
  427.         $images = [] ;
  428.         while($file = readdir($handle)){
  429.             if ($file !== '.' && $file !== '..' && in_array(mime_content_type($dirRelativePath. $file), ["image/jpeg", "image/png", "image/jpg"])) {
  430.                 $images[]= $dirRelativePath. $file ;
  431.             }
  432.         }
  434.         return new JsonResponse(array('images' =>$images ));
  435.     }
  439.     /**
  440.      * export all vehicles as csv file
  441.      * 
  442.      * @return Response
  443.      * @throws \Doctrine\DBAL\DBALException
  444.      */
  445.     #[Route('/vehiclesExport', name: 'vehicles_export', methods:["GET"])]
  446.     #[IsGranted('ROLE_SUPER_ADMIN')]
  447.     public function exportVehicles(Request $request,VehiclesService $vehiclesService){
  449.         return $vehiclesService->exportVehicles();
  450.     }
  454.     /**
  455.      * Displays a form to edit an existing vehicleRepair entity.
  456.      *
  457.      * @return \Symfony\Component\HttpFoundation\RedirectResponse|Response
  458.      */
  459.     #[Route('/vehicle_update_states', name: 'vehicle_update_states', methods:["GET"])]
  460.     #[IsGranted('ROLE_SUPER_ADMIN')]
  461.     public function vehicleUpdateStatesAction(Request $request, ManagerRegistry $doctrine){
  463.         $em     = $doctrine->getManager();
  464.         $vehiclesRepo = $em->getRepository(Vehicles::class);
  465.         $form = $this->createFormBuilder()
  466.             ->setAction($this->generateUrl('vehicle_update_states'))
  467.             ->setMethod("GET");
  469.         $form->add('vehicleIdStart', TextType::class, [
  470.             'required'           => true,
  471.             'label'              => 'Vehicle Id Start',
  472.             'translation_domain' => 'vehicles'])
  473.             ->add('vehicleIdEnd', TextType::class, [
  474.                 'required'           => true,
  475.                 'label'              => 'Vehicle Id End',
  476.                 'translation_domain' => 'vehicles'
  477.             ])
  478.             ->add('applyNewState',CheckboxType::class, array(
  479.                 'label'    => 'Apply the new state to the vehicles range',
  480.                 'required' => false
  481.             ))
  483.         ;
  484.         $vehicleUpdateStatesForm = $form->getForm();
  485.         $vehicleUpdateStatesForm->handleRequest($request);
  486.         $vehiclesStates= array();
  487.         if( $vehicleUpdateStatesForm->isSubmitted() && $vehicleUpdateStatesForm->isValid()){
  489.             $vehicleIdStart = $vehicleUpdateStatesForm->get('vehicleIdStart')->getData();
  490.             $vehicleIdEnd   = $vehicleUpdateStatesForm->get('vehicleIdEnd')->getData();
  491.             $applyNewState   = $vehicleUpdateStatesForm->get('applyNewState')->getData();
  493.             $vehicleRepository = $em->getRepository(Vehicles::class);
  494.             $query      = $vehicleRepository->createQueryBuilder('V');
  495.             $query->where('V.vehicleId >= :vehicleIdStart')
  496.                 ->setParameter('vehicleIdStart', $vehicleIdStart);
  497.             $query->andWhere('V.vehicleId <= :vehicleIdEnd')
  498.                 ->setParameter('vehicleIdEnd', $vehicleIdEnd);
  499.             $searchedVehicles = $query->getQuery()->getResult();
  500.             foreach ($searchedVehicles as $vehicle) {
  501.                 $vehicleSituation = $vehicle->getSituation();
  502.                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State'] = array();
  503.                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State'] = array();
  504.                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State'] = array();
  505.                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State'] = array();
  507.                 $vehiclesStates[$vehicle->getVehicleId()]['situation'] = $vehicle->getSituation();
  509.                 //block#1 Special case for Sold_And_Closed
  510.                 if($vehicleSituation =='Sold_And_Closed'){
  511.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Sold_And_Closed'] = 1;
  512.                     $vehiclesStates[$vehicle->getVehicleId()]['vehicleId']=$vehicle->getVehicleId();
  513.                     $vehiclesStates[$vehicle->getVehicleId()]['inconsistency']= false;
  514.                     if($applyNewState){
  515.                         $newState = $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State'];
  516.                         $vehicle->setState($newState);
  517.                         $em->persist($vehicle);
  518.                     }
  519.                     $vehiclesStates[$vehicle->getVehicleId()]['inconsistency']= false;
  520.                     continue; //break from foreach and continue with the next
  521.                 }
  523.                 //block#2 deriving vehicle states info from its sales info
  524.                 //get the approved vehicle sale if there is any
  525.                 $vehicleApprovedSale = $em->getRepository(VehicleSales::class)->getTheVehicleApprovedSale($vehicle->getVehicleId());
  526.                 if($vehicleApprovedSale){
  527.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Sold'] = 1;
  528.                     //existence of exit date tells us some info about vehicle location and it exit permission states
  529.                     if($vehicle->getExitDate()!=null){
  530.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Delivered_To_Buyer'] = 1;
  531.                     }else{
  532.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Received'] = 1;
  533.                     }
  534.                     //trying to derive OT state and exit permission state
  535.                     $vehicleOwnershipTransferRepository = $em->getRepository(VehicleOwnershipTransfer::class);
  536.                     $vehicleOwnershipTransferToBuyer = $vehicleOwnershipTransferRepository->findOneBy(
  537.                         ['sale'=>$vehicleApprovedSale, 'approvalStatus'=>VehicleOwnershipTransfer::APPROVAL_STATUSES['approved']]);
  538.                     if(!empty($vehicleOwnershipTransferToBuyer) ){
  539.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Transferred_To_Buyer'] = 1;
  540.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Permitted_To_Exit'] = 1; //if its OT is approved then it is permitted to exit
  541.                     }else{
  542.                         $vehicleInternalOTType = $vehiclesRepo->getInternalOTType($vehicle);
  543.                         if ($vehicleInternalOTType == VehicleOwnershipTransfer::OT_TYPES['internal_drop']) {
  544.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Dropped'] = 1;
  545.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Permitted_To_Exit'] = 1; //sold dropped vehicles are always permitted to exit
  546.                         } else {
  547.                             if ($vehicleInternalOTType == VehicleOwnershipTransfer::OT_TYPES['internal_transfer']) {
  548.                                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Transferred_To_Tjr'] = 1;
  549.                             }else{
  550.                                 //no OT to buyer, no internal OT, then it never transferred
  551.                                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1;
  552.                             }
  554.                             //trying to derive exit permission state by checking if the vehicle has an OT Security
  555.                             if ($vehiclesRepo->doesBuyerPayedOTSecurity($vehicleApprovedSale)) {
  556.                                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Permitted_To_Exit'] = 1;
  557.                             }else {
  558.                                 //not transferred to buyer, not dropped, no OT security, then not permitted to exit
  559.                                 $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  560.                             }
  561.                         }
  562.                     }
  563.                     if($applyNewState){
  564.                         $newState = array_merge($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State'],
  565.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State'],
  566.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State'],
  567.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']);
  568.                         $vehicle->setState($newState);
  569.                         $em->persist($vehicle);
  570.                     }
  571.                     $vehiclesStates[$vehicle->getVehicleId()]['inconsistency']= false;
  572.                     continue; //break from foreach and continue with the next
  573.                 }else{
  574.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  575.                 }
  577.                 //block#3 detect the vehicle Internal OT State for not sold vehicles
  578.                 $vehicleInternalOTType = $vehiclesRepo->getInternalOTType($vehicle);
  579.                 if($vehicleInternalOTType == VehicleOwnershipTransfer::OT_TYPES['internal_drop']) {
  580.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Dropped'] = 1;
  581.                 }elseif($vehicleInternalOTType == VehicleOwnershipTransfer::OT_TYPES['internal_transfer']) {
  582.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Transferred_To_Tjr'] = 1;
  583.                 }else{
  584.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1; //no OT to buyer, no internal OT, then it is completely untransferred
  585.                 }
  587.                 //block#4 detect the vehicle Location_State
  588.                 switch ($vehicleSituation){
  589.                     case 'In_Repair':
  590.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['In_Repair'] = 1;
  591.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  592.                         break;
  593.                     case 'New':
  594.                         if(!empty($vehicle->getVehicleRevokeRequest())){
  595.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Requested_For_Transportation'] = 1;
  596.                         }else{
  597.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['New'] = 1;
  598.                         }
  599.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  600.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1;
  601.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  602.                         break;
  603.                     case 'Under_Transportation':
  604.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Under_Transportation'] = 1;
  605.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  606.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1;
  607.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  608.                         break;
  609.                     case 'Received':
  610.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Received'] = 1;
  611.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  612.                         break;
  613.                     case 'Not_Received':
  614.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Not_Received'] = 1;
  615.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  616.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1;
  617.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  618.                         break;
  619.                     case 'Returned':
  620.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']['Returned'] = 1;
  621.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']['Not_Sold'] = 1;
  622.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']['Not_Transferred'] = 1;
  623.                         $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Permitted_To_Exit'] = 1;
  624.                         break;
  625.                 }
  626.                 //block#5 if vehicle Exit_Permission_State is still not set then assume that the vehicle is not permitted to exit
  627.                 if(empty($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']) ){
  628.                     $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']['Not_Permitted_To_Exit'] = 1;
  629.                 }
  631.                 $countVehicleLocationState  = count($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State']);
  632.                 $countVehicleSaleState  = count($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State']);
  633.                 $countVehicleOTState = count($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State']);
  634.                 $countVehicleExitPermissionState = count($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']);
  636.                 if($countVehicleLocationState == 0 || $countVehicleLocationState > 1 || $countVehicleSaleState == 0 || $countVehicleSaleState > 1 || $countVehicleOTState == 0 || $countVehicleOTState > 1 || $countVehicleExitPermissionState == 0 || $countVehicleExitPermissionState > 1
  637.                 ){
  638.                     $vehiclesStates[$vehicle->getVehicleId()]['inconsistency']= true;
  639.                 }else{
  640.                     $vehiclesStates[$vehicle->getVehicleId()]['inconsistency']= false;
  641.                     //if vehicle has no state yet and `applyNewState` checkbox was checked then update vehicle state with the derived state
  642.                     if($applyNewState && !$vehicle->getState()){
  644.                         $newState = array_merge($vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Sale_State'],
  645.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Location_State'],
  646.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_OT_State'],
  647.                             $vehiclesStates[$vehicle->getVehicleId()]['Vehicle_Exit_Permission_State']);
  648.                         $vehicle->setState($newState);
  649.                         $em->persist($vehicle);
  650.                     }
  651.                 }
  652.             }
  654.         }
  655.         $em->flush();
  656.         return $this->render('vehicles/vehicle_update_states.html.twig', [
  657.             'form'  => $vehicleUpdateStatesForm->createView(),
  658.             'vehiclesStates' => $vehiclesStates
  659.         ]);
  660.     }
  661. }