src/Twig/AppExtension.php line 78

Open in your IDE?
  1. <?php
  2. namespace App\Twig;
  4. use App\Entity\Avoir;
  5. use App\Entity\AvoirFactureFinance;
  6. use App\Entity\AvoirMontantTvaProject;
  7. use App\Entity\CommentEtap;
  8. use App\Entity\EfacData;
  9. use App\Entity\Entreprise;
  10. use App\Entity\EquipementCommandeProduitPrixDetail;
  11. use App\Entity\EquipementFournisseur;
  12. use App\Entity\Etap14;
  13. use App\Entity\Etap171;
  14. use App\Entity\Etap172;
  15. use App\Entity\Etap173;
  16. use App\Entity\Etap174;
  17. use App\Entity\Etap175;
  18. use App\Entity\Etaps;
  19. use App\Entity\EtapsCategory;
  20. use App\Entity\FactureFinance;
  21. use App\Entity\FactureFinanceMontantTvaProject;
  22. use App\Entity\FactureFinancePaiementDetail;
  23. use App\Entity\Fournisseur;
  24. use App\Entity\FournisseurProject;
  25. use App\Entity\HistoryFactureAvoir;
  26. use App\Entity\MeltdChamps;
  27. use App\Entity\ParametrageXlsProject;
  28. use App\Entity\Project;
  29. use App\Entity\Spv;
  30. use App\Entity\StatusTracker;
  31. use App\Entity\StatusTrackerConstruction;
  32. use App\Entity\TypologieProject;
  33. use App\Entity\User;
  34. use App\Entity\UserDroit;
  35. use App\Entity\UserDroitGlobal;
  36. use App\Entity\TypeValorisation;
  38. use App\Services\CompteRenduService;
  39. use App\Services\EquipementCommandeService;
  40. use App\Services\EtapsService;
  41. use App\Services\FactureFinanceService;
  42. use App\Services\FactureService;
  43. use App\Services\FournisseurService;
  44. use App\Services\Notifications;
  45. use App\Services\ProjectService;
  46. use App\Services\UploadService;
  47. use Twig\Extension\AbstractExtension;
  48. use Twig\TwigFilter;
  49. use Twig\TwigFunction;
  50. use Twig\Environment;
  51. use Doctrine\ORM\EntityManagerInterface;
  52. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  54. class AppExtension extends AbstractExtension
  55. {
  56.     private $twig;
  57.     private $params;
  59.     public function __construct(
  60.         Environment $twig,
  61.         EntityManagerInterface $em,
  62.         ParameterBagInterface $params,
  63.         EtapsService $etapsService,
  64.         Notifications $notifications,
  65.         ProjectService $projectService,
  66.         FactureFinanceService $factureFinanceService,
  67.         UploadService $uploadService,
  68.         FournisseurService $fournisseurService,
  69.         EquipementCommandeService $equipementCommandeService,
  70.         CompteRenduService $compteRenduService
  71.     ) {
  72.         $this->twig = $twig;
  73.         $this->em = $em;
  74.         $this->params = $params;
  75.         $this->etapsService = $etapsService;
  76.         $this->uploadService = $uploadService;
  77.         $this->notifications = $notifications;
  78.         $this->projectService = $projectService;
  79.         $this->factureFinanceService = $factureFinanceService;
  80.         $this->fournisseurService = $fournisseurService;
  81.         $this->equipementCommandeService = $equipementCommandeService;
  82.         $this->compteRenduService = $compteRenduService;
  83.     }
  85.     public function getFunctions()
  86.     {
  87.         return [
  88.             new TwigFunction('getEtapNameByNum', [$this, 'getEtapNameByNum']),
  89.             new TwigFunction('getTimelinePointEtapByNum', [$this, 'getTimelinePointEtapByNum']),
  90.             new TwigFunction('getCommentEtapByNum', [$this, 'getCommentEtapByNum']),
  91.             new TwigFunction('checkCommentEtapByNum', [$this, 'checkCommentEtapByNum']),
  92.             new TwigFunction('getEtapByNumAndProject', [$this, 'getEtapByNumAndProject']),
  93.             new TwigFunction('getNotisNotLu', [$this, 'getNotisNotLu']),
  94.             new TwigFunction('getSpvs', [$this, 'getSpvs']),
  95.             new TwigFunction('getEpcs', [$this, 'getEpcs']),
  96.             new TwigFunction('getUserByRoles', [$this, 'getUserByRoles']),
  97.             new TwigFunction('checkOpenEtap', [$this, 'checkOpenEtap']),
  98.             new TwigFunction('getDocsPartage', [$this, 'getDocsPartage']),
  99.             new TwigFunction('getAbreviation', [$this, 'getAbreviation']),
  100.             new TwigFunction('checkInformationProprietaireEtap6Raccordement', [$this, 'checkInformationProprietaireEtap6Raccordement']),
  101.             new TwigFunction('completudeCategory', [$this, 'completudeCategory']),
  102.             new TwigFunction('completudeDocsCategory', [$this, 'completudeDocsCategory']),
  103.             new TwigFunction('espaceNumber', [$this, 'espaceNumber']),
  104.             new TwigFunction('getDocUploadMultipleNotArchive', [$this, 'getDocUploadMultipleNotArchive']),
  105.             new TwigFunction('getDocUploadMultipleNotArchiveString', [$this, 'getDocUploadMultipleNotArchiveString']),
  106.             new TwigFunction('getDocUploadMultipleNotArchiveEntity', [$this, 'getDocUploadMultipleNotArchiveEntity']),
  107.             new TwigFunction('getDocUploadMultipleNotArchiveEntityImage', [$this, 'getDocUploadMultipleNotArchiveEntityImage']),
  108.             new TwigFunction('checkEtap3StatusFermee', [$this, 'checkEtap3StatusFermee']),
  109.             new TwigFunction('checkEtap3StatusName', [$this, 'checkEtap3StatusName']),
  110.             new TwigFunction('checkEtap3Status', [$this, 'checkEtap3Status']),
  111.             new TwigFunction('getDocsName', [$this, 'getDocsName']),
  112.             new TwigFunction('disabledOptionFileName', [$this, 'disabledOptionFileName']),
  113.             new TwigFunction('getAllFileNameTimeLine', [$this, 'getAllFileNameTimeLine']),
  114.             new TwigFunction('getAllFileNameTimeLineCategory', [$this, 'getAllFileNameTimeLineCategory']),
  115.             new TwigFunction('getAllFileNameTimeLineManyToMany', [$this, 'getAllFileNameTimeLineManyToMany']),
  116.             new TwigFunction('getAllFileNameTimeLineManyToMany2', [$this, 'getAllFileNameTimeLineManyToMany2']),
  117.             new TwigFunction('getAllFileNameFactureProject', [$this, 'getAllFileNameFactureProject']),
  118.             new TwigFunction('getAllFileNameAvoirProject', [$this, 'getAllFileNameAvoirProject']),
  119.             new TwigFunction('getHistoriqueAvoirFacture', [$this, 'getHistoriqueAvoirFacture']),
  120.             new TwigFunction('sommeValue', [$this, 'sommeValue']),
  121.             new TwigFunction('getAvoirByFacture', [$this, 'getAvoirByFacture']),
  122.             new TwigFunction('getfacturesByAvoir', [$this, 'getfacturesByAvoir']),
  123.             new TwigFunction('getMontantAvoirRestantByFacture', [$this, 'getMontantAvoirRestantByFacture']),
  124.             new TwigFunction('checkBailExpiree', [$this, 'checkBailExpiree']),
  125.             new TwigFunction('checkPCDPExpiree', [$this, 'checkPCDPExpiree']),
  126.             new TwigFunction('getEtapByProject', [$this, 'getEtapByProject']),
  127.             new TwigFunction('getStatusTrackerDates', [$this, 'getStatusTrackerDates']),
  128.             new TwigFunction('checkT0Expiree', [$this, 'checkT0Expiree']),
  129.             new TwigFunction('checkBailExpireeTimeline', [$this, 'checkBailExpireeTimeline']),
  130.             new TwigFunction('checkAlertPcExpireeTimeline', [$this, 'checkAlertPcExpireeTimeline']),
  131.             new TwigFunction('checkAlertT0ExpireeTimeline', [$this, 'checkAlertT0ExpireeTimeline']),
  132.             new TwigFunction('getDevsRapport', [$this, 'getDevsRapport']),
  133.             new TwigFunction('getDevsRapportSortant', [$this, 'getDevsRapportSortant']),
  134.             new TwigFunction('getDevsRapportConstructionSortant', [$this, 'getDevsRapportConstructionSortant']),
  135.             new TwigFunction('getDevsRapportConstruction', [$this, 'getDevsRapportConstruction']),
  136.             new TwigFunction('getAncientStatut', [$this, 'getAncientStatut']),
  137.             new TwigFunction('getStatutDate', [$this, 'getStatutDate']),
  138.             new TwigFunction('getAncientStatutConstruction', [$this, 'getAncientStatutConstruction']),
  139.             new TwigFunction('getStatutDateConstruction', [$this, 'getStatutDateConstruction']),
  140.             new TwigFunction('getFournisseursActive', [$this, 'getFournisseursActive']),
  141.             new TwigFunction('getChampsUpdates', [$this, 'getChampsUpdates']),
  142.             new TwigFunction('getTimeComment', [$this, 'getTimeComment']),
  143.             new TwigFunction('getCommentsProject', [$this, 'getCommentsProject']),
  144.             new TwigFunction('getChampsExport', [$this, 'getChampsExport']),
  145.             new TwigFunction('getTypologie', [$this, 'getTypologie']),
  146.             new TwigFunction('getEtapsByCategory', [$this, 'getEtapsByCategory']),
  147.             new TwigFunction('getAllIntervenant', [$this, 'getAllIntervenant']),
  148.             new TwigFunction('getAllParentAndActiveColonneXls', [$this, 'getAllParentAndActiveColonneXls']),
  149.             new TwigFunction('checkEtapIntervenant', [$this, 'checkEtapIntervenant']),
  150.             new TwigFunction('checkResponsableInProject', [$this, 'checkResponsableInProject']),
  151.             new TwigFunction('checkResponsableFoncierInProject', [$this, 'checkResponsableFoncierInProject']),
  152.             new TwigFunction('checkResponsableDeveloppementInProject', [$this, 'checkResponsableDeveloppementInProject']),
  153.             new TwigFunction('checkConstructeurInProject', [$this, 'checkConstructeurInProject']),
  154.             new TwigFunction('getSuiviBudget', [$this, 'getSuiviBudget']),
  155.             new TwigFunction('checkEtapStatusColorByDoc', [$this, 'checkEtapStatusColorByDoc']),
  156.             new TwigFunction('checkEtapStatusColorByDocEtap4Construction', [$this, 'checkEtapStatusColorByDocEtap4Construction']),
  157.             new TwigFunction('checkEtapStatusColorByDocEtap3Construction', [$this, 'checkEtapStatusColorByDocEtap3Construction']),
  158.             new TwigFunction('getDoeListFile', [$this, 'getDoeListFile']),
  159.             new TwigFunction('getBailListFile', [$this, 'getBailListFile']),
  160.             new TwigFunction('getStatusDetailStr', [$this, 'getStatusDetailStr']),
  161.             new TwigFunction('getTemplateMeltdChampsUpdate', [$this, 'getTemplateMeltdChampsUpdate']),
  162.             new TwigFunction('getTemplateMeltdChampsUpdateForm', [$this, 'getTemplateMeltdChampsUpdateForm']),
  163.             new TwigFunction('getNameChampGlobale', [$this, 'getNameChampGlobale']),
  164.             new TwigFunction('checkCalvuisUpdate', [$this, 'checkCalvuisUpdate']),
  165.             new TwigFunction('getConstructeurProject', [$this, 'getConstructeurProject']),
  166.             new TwigFunction('getMontantFinalTtcFacture', [$this, 'getMontantFinalTtcFacture']),
  167.             new TwigFunction('getFournisseurIsNotaire', [$this, 'getFournisseurIsNotaire']),
  168.             new TwigFunction('checkFournisseurRibActive', [$this, 'checkFournisseurRibActive']),
  169.             new TwigFunction('checkAltareaFacture', [$this, 'checkAltareaFacture']),
  170.             new TwigFunction('checkCodeProjectFacture', [$this, 'checkCodeProjectFacture']),
  171.             new TwigFunction('checkAlertEtap1And2', [$this, 'checkAlertEtap1And2']),
  172.             new TwigFunction('getDateFichierFactureFinancePaiement', [$this, 'getDateFichierFactureFinancePaiement']),
  173.             new TwigFunction('checkDroitProfileExtern', [$this, 'checkDroitProfileExtern']),
  174.             new TwigFunction('getUserNotaire', [$this, 'getUserNotaire']),
  175.             new TwigFunction('getUserByTitreIntervenant', [$this, 'getUserByTitreIntervenant']),
  176.             new TwigFunction('getVisitesQuestionByQuestion', [$this, 'getVisitesQuestionByQuestion']),
  177.             new TwigFunction('getQuestionColor', [$this, 'getQuestionColor']),
  178.             new TwigFunction('checkNextQuestionVisiteCompteRendu', [$this, 'checkNextQuestionVisiteCompteRendu']),
  179.             new TwigFunction('checkPrevQuestionVisiteCompteRendu', [$this, 'checkPrevQuestionVisiteCompteRendu']),
  180.             new TwigFunction('findAllProjectActive', [$this, 'findAllProjectActive']),
  181.             new TwigFunction('getAllPhotosForCompteRendu', [$this, 'getAllPhotosForCompteRendu']),
  182.             new TwigFunction('getAllEtapsPhotosMultiple', [$this, 'getAllEtapsPhotosMultiple']),
  183.             new TwigFunction('getTypeValorisation', [$this, 'getTypeValorisation']),
  184.             new TwigFunction('getEntrepriseActive', [$this, 'getEntrepriseActive']),
  185.             new TwigFunction('getfournisseurEquipement', [$this, 'getfournisseurEquipement']),
  186.             new TwigFunction('getEquipementPalettesWithCommande', [$this, 'getEquipementPalettesWithCommande']),
  187.             new TwigFunction('getEquipementProduitCommande', [$this, 'getEquipementProduitCommande']),
  188.             new TwigFunction('getEquipementProduitSousCommande', [$this, 'getEquipementProduitSousCommande']),
  189.             new TwigFunction('getEquipementCommandeFile', [$this, 'getEquipementCommandeFile']),
  190.             new TwigFunction('getEquipementProduitTabSousCommande', [$this, 'getEquipementProduitTabSousCommande']),
  191.             new TwigFunction('getTabEquipementBylogisticionReferenceAndStatus', [$this, 'getTabEquipementBylogisticionReferenceAndStatus']),
  192.             new TwigFunction('getTabEquipementLogisticienByReference', [$this, 'getTabEquipementLogisticienByReference']),
  193.             new TwigFunction('getTabEquipementTotalByReference', [$this, 'getTabEquipementTotalByReference']),
  194.             new TwigFunction('document_types', [EfacData::class, 'getDocumentTypes']),
  195.             new TwigFunction('getProjectPriceService', [$this, 'getProjectPriceService']),
  196.         ];
  197.     }
  200.     public function getFilters()
  201.     {
  202.         return array(
  204.         );
  205.     }
  207.     public function getTabEquipementTotalByReference($referenceId){
  208.         $tab = $this->equipementCommandeService->getTabEquipementTotalByReference($referenceId);
  209.         return $tab ;
  210.     }
  211.     public function getTabEquipementLogisticienByReference($referenceId){
  212.         $tab = $this->equipementCommandeService->getTabEquipementLogisticienByReference($referenceId);
  213.         return $tab ;
  214.     }
  215.     public function getTabEquipementBylogisticionReferenceAndStatus($logisticienReference,$status){
  216.         $tab = $this->equipementCommandeService->getTabEquipementBylogisticionReferenceAndStatus($logisticienReference,$status);
  217.         return $tab ;
  218.     }
  219.     public function getEquipementProduitTabSousCommande($commande){
  220.         $tab = $this->equipementCommandeService->getEquipementProduitTabSousCommande($commande);
  221.         return $tab ;
  222.     }
  223.     public function getEquipementCommandeFile($commande){
  224.         $tab = $this->equipementCommandeService->getEquipementCommandeFile($commande);
  225.         return $tab ;
  226.     }
  227.     public function getEquipementProduitSousCommande($sousCommande){
  228.         $tab = $this->equipementCommandeService->getEquipementProduitSousCommande($sousCommande);
  229.         return $tab ;
  230.     }
  231.     public function getEquipementProduitCommande($commande){
  232.         $tab = $this->equipementCommandeService->getEquipementProduitCommande($commande);
  233.         return $tab ;
  234.     }
  235.     public function getEquipementPalettesWithCommande($commande){
  236.         $tab = $this->equipementCommandeService->getEquipementPalettesWithCommande($commande);
  237.         return $tab ;
  238.     }
  239.     public function getfournisseurEquipement(){
  240.         $fournisseurs = $this->em->getRepository(EquipementFournisseur::class)->findAll();
  241.         return $fournisseurs ;
  242.     }
  243.     public function getProjectPriceService($tvaFactureFinanceId,$projectId,$isAvoir = false){
  244.         if($isAvoir){
  245.             $factureFinanceMontantTvaProject = $this->em->getRepository(AvoirMontantTvaProject::class)->getMontantTvaProjectByIdTvaAndPorjectId($tvaFactureFinanceId,$projectId);
  246.         }else{
  247.             $factureFinanceMontantTvaProject = $this->em->getRepository(FactureFinanceMontantTvaProject::class)->getMontantTvaProjectByIdTvaAndPorjectId($tvaFactureFinanceId,$projectId);
  248.         }
  249.         return $factureFinanceMontantTvaProject;
  250.     }
  251.     public function getEntrepriseActive(){
  252.         $entreprises = $this->em->getRepository(Entreprise::class)->getAllActive();
  253.         return $entreprises ;
  254.     }
  256.     public function getAllPhotosForCompteRendu($project){
  257.         return  $this->compteRenduService->getAllPhotosForCompteRendu($project);
  258.     }
  260.     public function findAllProjectActive(){
  261.         return  $this->em->getRepository(Project::class)->findAllProjectActive();
  262.     }
  263.     public function checkNextQuestionVisiteCompteRendu($token){
  264.         return  $this->compteRenduService->checkIsNext($token);
  265.     }
  266.     public function checkPrevQuestionVisiteCompteRendu($token){
  267.         return  $this->compteRenduService->checkIsPrev($token);
  268.     }
  269.     public function getQuestionColor($question){
  270.         $vistesByQuestion = $this->compteRenduService->getQuestionColor($question);
  271.         return $vistesByQuestion;
  272.     }
  273.     public function getVisitesQuestionByQuestion($question){
  274.         $vistesByQuestion = $this->compteRenduService->getQuestionsByVisite($question);
  275.         return $vistesByQuestion;
  276.     }
  278.     public function getUserByTitreIntervenant($titre){
  279.         $fournisseurs = $this->fournisseurService->getUserByTitreIntervenant($titre);
  280.         return $fournisseurs ;
  281.     }
  282.     public function getUserNotaire(){
  283.         $users = $this->fournisseurService->getUserNotaire();
  284.         return $users ;
  285.     }
  286.     public function checkFournisseurRibActive($fournisseur){
  287.         $montant = $this->fournisseurService->checkFournisseurRibActive($fournisseur);
  288.         return $montant ;
  289.     }
  290.     public function checkAltareaFacture($facture){
  291.         $montant = $this->factureFinanceService->checkAltareaFacture($facture);
  292.         return $montant ;
  293.     }
  294.     public function checkCodeProjectFacture($facture){
  295.         $data = $this->factureFinanceService->checkFactureFinanceCodeProject($facture);
  296.         return $data ;
  297.     }
  298.     public function getMontantFinalTtcFacture($facture){
  299.         $montant = $this->factureFinanceService->getMontantFinalTtcFacture($facture);
  300.         return $montant ;
  301.     }
  303.     public function getFournisseurIsNotaire($user){
  304.         $fournissueur = $this->em->getRepository(Fournisseur::class)->findOneBy(['user'=>$user->getId()]);
  305.         return $fournissueur ? $fournissueur->getIsNotaire() :false;
  306.     }
  307.     public function getConstructeurProject(){
  308.         $constructeurProject = $this->em->getRepository(FournisseurProject::class)->getConstructeurProject();
  309.         return $constructeurProject ;
  310.     }
  311.     public function checkCalvuisUpdate($project){
  312.         $champs = $this->em->getRepository(MeltdChamps::class)->getNotValideByProject($project);
  313.         return $champs ;
  314.     }
  315.     public function getNameChampGlobale($meltedId){
  316.        $name = $this->projectService->getNameChampGlobale($meltedId);
  317.        return $name ;
  318.     }
  319.     public function getTemplateMeltdChampsUpdate($project,$etap,$champName,$user,$isEtap = 1){
  320.         if(in_array($user->getTypeAcces(),[User::ACCES_intervenant,User::ACCES_visiteur,User::ACCES_comptable])){
  321.             $arrays = $this->em->getRepository(UserDroitGlobal::class)->getByUserAndChamp($user->getId(),'isUploadDoc');
  322.             if(!$arrays){
  323.                 return 'disabled';
  324.             }
  325.         }
  326.         if($isEtap){
  327.             $melted = $this->em->getRepository(MeltdChamps::class)->findOneBy(['project'=>$project->getId(),'numEtap'=>$etap->getEtap()->getNum(),'champName'=>$champName]);
  328.         }else{
  329.             $melted = $this->em->getRepository(MeltdChamps::class)->findOneBy(['project'=>$project->getId(),'champName'=>$champName,'isProject'=>true]);
  330.         }
  331.         if($melted && (in_array('ROLE_SUPER_ADMINISTRATOR',$user->getRoles()) || in_array('ROLE_ADMIN',$user->getRoles()) || in_array('ROLE_ADMINISTRATEUR_FINANCIER',$user->getRoles()))){
  332.             return $this->twig->render('user/etaps/tooltip-champs-border.html.twig', [
  333.                 'melted' => $melted
  334.             ]);
  335.         }else {
  336.             return '';
  337.         }
  338.     }
  339.     public function getTemplateMeltdChampsUpdateForm($project,$etap,$champName,$user,$isEtap = 1){
  340.         if($isEtap){
  341.             $melted = $this->em->getRepository(MeltdChamps::class)->findOneBy(['project'=>$project->getId(),'numEtap'=>$etap->getEtap()->getNum(),'champName'=>$champName]);
  342.         }else{
  343.             $melted = $this->em->getRepository(MeltdChamps::class)->findOneBy(['project'=>$project->getId(),'champName'=>$champName,'isProject'=>true]);
  344.         }
  345.         if($melted && (in_array('ROLE_SUPER_ADMINISTRATOR',$user->getRoles()) || in_array('ROLE_ADMIN',$user->getRoles()) || in_array('ROLE_ADMINISTRATEUR_FINANCIER',$user->getRoles()))){
  346.             return $this->twig->render('user/etaps/tooltip-champs-form.html.twig', [
  347.                 'melted' => $melted
  348.             ]);
  349.         }else {
  350.             return '';
  351.         }
  352.     }
  354.     public function getStatusDetailStr($project,$cat){
  355.         return $this->etapsService->getStatusDetailStr($project,$cat);
  356.     }
  357.     public function getDoeListFile($project){
  358.         return $this->projectService->getDoeListFile($project);
  359.     }
  360.     public function getBailListFile($project){
  361.         return $this->projectService->getBailListFile($project);
  363.     }
  364.     public function checkEtapStatusColorByDocEtap4Construction($project){
  365.         return $this->etapsService->checkEtapStatusColorByDocEtap4Construction($project);
  367.     }
  368.     public function checkEtapStatusColorByDocEtap3Construction($project){
  369.         return $this->etapsService->checkEtapStatusColorByDocEtap3Construction($project);
  371.     }
  372.     public function checkEtapStatusColorByDoc($etap){
  373.         return $this->etapsService->checkEtapStatusColorByDoc($etap);
  375.     }
  376.     public function getSuiviBudget($project){
  377.         $tab = $this->projectService->getTabFacturationParProject($project);
  378.         return $tab;
  379.     }
  380.     public function checkResponsableFoncierInProject($responsableUser,$project){
  381.         $arrays = $project->getResponsableFoncierUser();
  382.         foreach ($arrays as $item){
  383.             $responsable = $item->getResponsable();
  384.             if($responsable == $responsableUser){
  385.                 return true;
  386.                 break;
  387.             }
  388.         }
  389.         return false;
  390.     }
  391.     public function checkResponsableInProject($responsableUser,$project){
  392.         $arrays = $project->getResponsableUser();
  393.         foreach ($arrays as $item){
  394.             $responsable = $item->getResponsable();
  395.             if($responsable == $responsableUser){
  396.                 return true;
  397.                 break;
  398.             }
  399.         }
  400.         return false;
  401.     }
  402.     public function checkResponsableDeveloppementInProject($responsableUser,$project){
  403.         $arrays = $project->getResponsableDeveloppement();
  404.         foreach ($arrays as $item){
  405.             $responsable = $item->getResponsable();
  406.             if($responsable == $responsableUser){
  407.                 return true;
  408.                 break;
  409.             }
  410.         }
  411.         return false;
  412.     }
  413.     public function checkConstructeurInProject($constructeurUser,$project){
  414.         $arrays = $project->getConstructeurUser();
  415.         foreach ($arrays as $item){
  416.             $constructeur = $item->getConstructeur();
  417.             if($constructeur == $constructeurUser){
  418.                 return true;
  419.                 break;
  420.             }
  421.         }
  422.         return false;
  423.     }
  424.     public function checkEtapIntervenant($etapNum,$user){
  425.         $arrays = $this->em->getRepository(UserDroit::class)->getByEtapNumUser($etapNum,$user->getId());
  426.         return $arrays;
  427.     }
  428.     public function checkDroitProfileExtern($user,$champ){
  429.         if(in_array($user->getTypeAcces(),[User::ACCES_intervenant,User::ACCES_visiteur,User::ACCES_comptable])){
  430.             $arrays = $this->em->getRepository(UserDroitGlobal::class)->getByUserAndChamp($user->getId(),$champ);
  431.             return $arrays;
  432.         }else{
  433.             return true;
  434.         }
  436.     }
  437.     public function getAllParentAndActiveColonneXls($parentId){
  438.         $arrays = $this->em->getRepository(ParametrageXlsProject::class)->getAllParentAndActive($parentId);
  439.         return $arrays;
  440.     }
  441.     public function getAllIntervenant(){
  442.         $arrays = $this->em->getRepository(User::class)->getIntervenants();
  443.         return $arrays;
  444.     }
  445.     public function getEtapsByCategory($categoryNum,$isNewConstruction){
  446.         $arrays = $this->em->getRepository(Etaps::class)->getEtapsByCategory($categoryNum,$isNewConstruction);
  447.         return $arrays;
  448.     }
  449.     public function getTypologie(){
  450.         $arrays = $this->em->getRepository(TypologieProject::class)->findAll();
  451.         return $arrays;
  452.     }
  454.     public function getCommentsProject($project){
  455.         $arrays = $this->projectService->getCommentsProject($project);
  456.         return $arrays;
  457.     }
  459.     public function getTimeComment($dateTime){
  460.         $str = $this->projectService->getTimeComment($dateTime);
  461.         return $str;
  462.     }
  464.     public function getChampsUpdates(){
  465.         $array = $this->etapsService->getChampsUpdates();
  466.         return $array;
  467.     }
  468.     public function getChampsExport(){
  469.         $array = $this->etapsService->getChampsExport();
  470.         return $array;
  471.     }
  472.     public function getFournisseursActive(){
  473.         $fournisseurs = $this->em->getRepository(Fournisseur::class)->findAllActive();
  474.         return $fournisseurs;
  475.     }
  477.     public function getAncientStatut($project,$date,$date2,$isNew=1){
  478.         if($isNew == 1){
  479.             $statusTrackers = $this->em->getRepository(StatusTracker::class)->getNewStatut($date,$date2,$project->getId());
  480.             if($statusTrackers){
  481.                 if(count($statusTrackers)>=1){
  482.                     return isset($statusTrackers[0]) ? $this->projectService->getStatusTrackerStr($statusTrackers[0]->getStatus()): '-';
  483.                 }
  484.             }
  485.         }else{
  486.             $statusTrackers = $this->em->getRepository(StatusTracker::class)->getAncientStatut($date,$project->getId());
  487.             if($statusTrackers){
  488.                 if(count($statusTrackers)>0){
  489.                     return isset($statusTrackers[0]) ? $this->projectService->getStatusTrackerStr($statusTrackers[0]->getStatus()): '-';
  490.                 }
  491.             }
  492.         }
  493.         return '-';
  494.     }
  496.     public function getStatutDate($project,$date){
  497.         $statusTrackers = $this->em->getRepository(StatusTracker::class)->getAncientStatut($date,$project->getId());
  498.         if($statusTrackers){
  499.             if(count($statusTrackers)>0){
  500.                 return $statusTrackers[0];
  501.             }
  502.         }
  503.         return false;
  504.     }
  506.     public function getDevsRapportSortant($projects,$status){
  507.         $array = [];
  508.         if($projects){
  509.             foreach ($projects as $statusTracker){
  510.                 if($statusTracker->getProject()->getDeveloppeur()){
  511.                     if($status >= $statusTracker->getStatus() ){
  512.                         $array[$statusTracker->getProject()->getDeveloppeur()->getId()]['projects']['moins'][] = $statusTracker->getProject() ;
  513.                     }else {
  514.                         $array[$statusTracker->getProject()->getDeveloppeur()->getId()]['projects']['plus'][] = $statusTracker->getProject() ;
  515.                     }
  516.                     $array[$statusTracker->getProject()->getDeveloppeur()->getId()]['developeur'] = $statusTracker->getProject()->getDeveloppeur()? $statusTracker->getProject()->getDeveloppeur()->getFirstname().' '.$statusTracker->getProject()->getDeveloppeur()->getLastname(): null ;
  517.                     $array[$statusTracker->getProject()->getDeveloppeur()->getId()]['coulour'] = $statusTracker->getProject()->getDeveloppeur()? $statusTracker->getProject()->getDeveloppeur()->getCouleurRapport(): null ;
  518.                 }else{
  519.                   $array['notDev']['notDev'][] = $statusTracker->getProject() ;
  520.                   $array['notDev']['coulour'] = null ;
  521.                 }
  522.             }
  523.         }
  524.         return $array ;
  525.     }
  527.     public function getDevsRapport($projects){
  528.         $array = [];
  529.         if($projects){
  530.             foreach ($projects as $project){
  531.                 if($project->getDeveloppeur()){
  532.                     $array[$project->getDeveloppeur()->getId()]['projects'][] = $project ;
  533.                     $array[$project->getDeveloppeur()->getId()]['developeur'] = $project->getDeveloppeur()? $project->getDeveloppeur()->getFirstname().' '.$project->getDeveloppeur()->getLastname(): null ;
  534.                     $array[$project->getDeveloppeur()->getId()]['coulour'] = $project->getDeveloppeur()? $project->getDeveloppeur()->getCouleurRapport(): null ;
  535.                 }else{
  536.                     $array['notDev']['notDev'][] = $project ;
  537.                     $array['notDev']['coulour'] = null ;
  538.                 }
  539.             }
  540.         }
  541.         if($array) {
  542.             foreach ($array as &$item) {
  543.                 if (isset($item['projects'])) {
  544.                     $item['pourcentage'] = count($item['projects'])/count($projects) * 100;
  545.                 }elseif(isset($item['notDev'])){
  546.                     $item['pourcentage'] = count($item['notDev'])/count($projects) * 100;
  547.                 }
  548.             }
  549.         }
  550.         $pourcentage = array_column($array, 'pourcentage');
  551.         array_multisort($pourcentage, SORT_DESC, $array);
  552.         return $array ;
  553.     }
  555.     public function getDevsRapportConstructionSortant($projects,$status){
  556.         $array = [];
  557.         if($projects){
  558.             foreach ($projects as $statusTracker){
  559.                 if($statusTracker->getProject()->getResponsableUser() && count($statusTracker->getProject()->getResponsableUser())){
  560.                     $responsable0 = $statusTracker->getProject()->getResponsableUser()[0];
  561.                     if($status >= $statusTracker->getStatus() ){
  562.                         $array[$responsable0->getResponsable()->getId()]['projects']['moins'][] = $statusTracker->getProject() ;
  563.                     }else {
  564.                         $array[$responsable0->getResponsable()->getId()]['projects']['plus'][] = $statusTracker->getProject() ;
  565.                     }
  566.                     foreach ($statusTracker->getProject()->getResponsableUser() as $responsable){
  567.                         $array[$responsable0->getResponsable()->getId()]['responsableConstruction'][] =  $responsable->getResponsable()->getFirstname().' '.$responsable->getResponsable()->getLastname() ;
  568.                     }
  569.                     $array[$responsable0->getResponsable()->getId()]['coulour'] = $responsable0 ? $responsable0->getResponsable()->getCouleurRapport(): null ;
  570.                 }else{
  571.                     $array['notDev']['notDev'][] = $statusTracker->getProject() ;
  572.                     $array['notDev']['coulour'] = null ;
  573.                 }
  574.             }
  575.         }
  576.         return $array ;
  577.     }
  579.     public function getDevsRapportConstruction($projects){
  580.         $array = [];
  581.         if($projects){
  582.             foreach ($projects as $project){
  583.                 if($project->getResponsableUser() && count($project->getResponsableUser())>0){
  584.                     $responsable0 = $project->getResponsableUser()[0];
  585.                     $array[$responsable0->getResponsable()->getId()]['projects'][] = $project ;
  586.                     foreach ($project->getResponsableUser() as $responsable){
  587.                         $array[$responsable0->getResponsable()->getId()]['responsableConstruction'][] =  $responsable->getResponsable()->getFirstname().' '.$responsable->getResponsable()->getLastname() ;
  588.                     }
  589.                     $array[$responsable0->getResponsable()->getId()]['coulour'] = $responsable0 ? $responsable0->getResponsable()->getCouleurRapport(): null ;
  590.                 }else{
  591.                     $array['notDev']['notDev'][] = $project ;
  592.                     $array['notDev']['coulour'] = null ;
  593.                 }
  594.             }
  595.         }
  596.         if($array) {
  597.             foreach ($array as &$item) {
  598.                 if (isset($item['projects'])) {
  599.                     $item['pourcentage'] = count($item['projects'])/count($projects) * 100;
  600.                 }elseif(isset($item['notDev'])){
  601.                     $item['pourcentage'] = count($item['notDev'])/count($projects) * 100;
  602.                 }
  603.             }
  604.         }
  605.         $pourcentage = array_column($array, 'pourcentage');
  606.         array_multisort($pourcentage, SORT_DESC, $array);
  607.         return $array ;
  608.     }
  610.     public function getAncientStatutConstruction($project,$date,$date2,$isNew=1){
  611.         if($isNew == 1){
  612.             $statusTrackers = $this->em->getRepository(StatusTrackerConstruction::class)->getNewStatut($date,$date2,$project->getId());
  613.             if($statusTrackers){
  614.                 if(count($statusTrackers)>=1){
  615.                     return isset($statusTrackers[0]) ? $this->projectService->getStatusTrackerConstructionStr($statusTrackers[0]->getStatus()): '-';
  616.                 }
  617.             }
  618.         }else{
  619.             $statusTrackers = $this->em->getRepository(StatusTrackerConstruction::class)->getAncientStatut($date,$project->getId());
  620.             if($statusTrackers){
  621.                 if(count($statusTrackers)>0){
  622.                     return isset($statusTrackers[0]) ? $this->projectService->getStatusTrackerConstructionStr($statusTrackers[0]->getStatus()): '-';
  623.                 }
  624.             }
  625.         }
  626.         return '-';
  627.     }
  629.     public function getStatutDateConstruction($project,$date){
  630.         $statusTrackers = $this->em->getRepository(StatusTrackerConstruction::class)->getAncientStatut($date,$project->getId());
  631.         if($statusTrackers){
  632.             if(count($statusTrackers)>0){
  633.                 return $statusTrackers[0];
  634.             }
  635.         }
  636.         return false;
  637.     }
  639.     public function getEtapByProject($project,$etapNum){
  640.         $etapEntityClass = 'App\\Entity\\Etap' . $etapNum;
  641.         $etapEntity = $this->em->getRepository($etapEntityClass)->findOneBy(['project' => $project->getId()]);
  642.         return $etapEntity ;
  643.     }
  646.     /**
  647.      * Retourne un tableau [status => date d'entrée réelle la plus ancienne] à partir de l'historique statusTracker du projet.
  648.      * Utilisé par le panneau "Calendrier" du détail projet.
  649.      */
  650.     public function getStatusTrackerDates($project){
  651.         $dates = [];
  652.         if($project){
  653.             foreach ($project->getStatusTracker() as $statusTracker){
  654.                 $status = $statusTracker->getStatus();
  655.                 if($status === null || $status === ''){
  656.                     continue;
  657.                 }
  658.                 $status = (int)$status;
  659.                 $createdAt = $statusTracker->getCreatedAt();
  660.                 if($createdAt === null){
  661.                     continue;
  662.                 }
  663.                 if(!isset($dates[$status]) || $createdAt < $dates[$status]){
  664.                     $dates[$status] = $createdAt;
  665.                 }
  666.             }
  667.         }
  668.         return $dates;
  669.     }
  671.     public function getAllEtapsPhotosMultiple($project){
  672.         $photos = [];
  673.         $etapsDone = [];
  674.         $etaps = $this->em->getRepository(Etaps::class)->findAll();
  675.         foreach ($etaps as $etapDef){
  676.             $num = $etapDef->getNum();
  677.             if(isset($etapsDone[$num])){
  678.                 continue;
  679.             }
  680.             $etapsDone[$num] = true;
  681.             $etapEntityClass = 'App\\Entity\\Etap' . $num;
  682.             if(!class_exists($etapEntityClass)){
  683.                 continue;
  684.             }
  685.             $etapEntity = $this->em->getRepository($etapEntityClass)->findOneBy(['project' => $project->getId()]);
  686.             if($etapEntity && method_exists($etapEntity, 'getFilePhotosMultiple')){
  687.                 foreach ($etapEntity->getFilePhotosMultiple() as $doc){
  688.                     if(!$doc->getIsArchived() && $this->checkIfInArrayString(['.png', '.jpg', '.jpeg', 'heic'], strtolower($doc->getPath()))){
  689.                         $photos[] = $doc;
  690.                     }
  691.                 }
  692.             }
  693.         }
  694.         return $photos;
  695.     }
  696.     public function getMontantAvoirRestantByFacture($facture){
  697.         $mantantTotalAvoir = 0;
  698.         $mantantTotalAvoirRestant = 0;
  699.         if($facture){
  700.             $avoirs = $this->em->getRepository(AvoirFactureFinance::class)->findBy(['financeFacture'=>$facture->getId()]);
  701.             $mantantFacture = (float)(str_replace(',','.',$facture->getMonatantTtc()));
  702.             if($avoirs){
  703.                 foreach ($avoirs as $avoir){
  704.                     if($avoir->getMonatantAvoirTtc()){
  705.                         $mantantTotalAvoir += (float)(str_replace(',','.',$avoir->getMonatantAvoirTtc()));
  706.                     }else{
  707.                         $mantantTotalAvoir += 0;
  708.                     }
  709.                 }
  710.             }
  711.             if($mantantFacture >= $mantantTotalAvoir){
  712.                 $mantantTotalAvoirRestant = 0;
  713.             }else{
  714.                 $mantantTotalAvoirRestant = $mantantTotalAvoir - $mantantFacture;
  715.             }
  716.         }
  717.         return $mantantTotalAvoirRestant;
  718.     }
  719.     public function getAvoirByFacture($facture){
  720.         $avoirs = $this->em->getRepository(AvoirFactureFinance::class)->findBy(['financeFacture'=>$facture->getId()]);
  721.         return $avoirs;
  722.     }
  723.     public function getfacturesByAvoir($avoir){
  724.         $avoirs = $this->em->getRepository(AvoirFactureFinance::class)->findBy(['avoir'=>$avoir->getId()]);
  725.         return $avoirs;
  726.     }
  727.     public function sommeValue($val1,$val2){
  728.         $val1 = (float)(str_replace(',','.',$val1));
  729.         $val2 = (float)(str_replace(',','.',$val2));
  730.         return $val1 + $val2;
  731.     }
  732.     public function getHistoriqueAvoirFacture($avoir=null,$facture=null){
  733.         $array = null;
  734.         if($avoir){
  735.             $array = $this->em->getRepository(HistoryFactureAvoir::class)->findBy(['avoir'=>$avoir->getId()],['id'=>'desc']);
  736.         }elseif($facture){
  737.             $array = $this->em->getRepository(HistoryFactureAvoir::class)->findBy(['factureFinance'=>$facture->getId()],['id'=>'desc']);
  738.         }
  739.         return $array;
  740.     }
  741.     public function checkBailExpireeTimeline($project){
  742.         $rep = $this->notifications->getAlertBailTimeline($project);
  743.         return $rep;
  744.     }
  745.     public function checkAlertPcExpireeTimeline($project){
  746.         $rep = $this->notifications->getAlertPcTimeline($project);
  747.         return $rep;
  748.     }
  749.     public function checkAlertT0ExpireeTimeline($project){
  750.         $rep = $this->notifications->getAlertT0Timeline($project);
  751.         return $rep;
  752.     }
  753.     public function checkBailExpiree($project){
  754.         $rep = $this->notifications->getAlertBail($project);
  755.         return $rep;
  756.     }
  757.     public function checkPCDPExpiree($project){
  758.         $rep = $this->notifications->getAlertPc($project);
  759.         return $rep;
  760.     }
  761.     public function checkAlertEtap1And2($project){
  762.         $rep = $this->etapsService->getAlertsEtap1AndEtap2($project);
  763.         return $rep;
  764.     }
  765.     public function checkT0Expiree($project){
  766.         $rep = $this->notifications->getAlertT0($project);
  767.         return $rep;
  768.     }
  769.     public function disabledOptionFileName($project,$fileNameInput,$etapNum){
  770.         $etapNum = $etapNum;
  771.         $fileName = $fileNameInput;
  772.         $etapClass = 'App\\Entity\\Etap'.$etapNum;
  773.         $etap = $this->em->getRepository($etapClass)->findOneBy(['project'=>$project->getId()]);
  774.         $isNotEmpty = false;
  775.         if($etap){
  776.             $classMetadata = $this->em->getClassMetadata($etapClass);
  777.             $associationMappings = $classMetadata->getAssociationMapping($fileName);
  778.             if ($associationMappings['type'] === \Doctrine\ORM\Mapping\ClassMetadata::MANY_TO_MANY){
  779.                 $nameGeteurFiled = 'get'.ucfirst($fileName);
  780.                 $filedValue = $etap->{$nameGeteurFiled}();
  781.                 if(!$filedValue->isEmpty()){
  782.                     if($fileName == 'fileCrdSigneeMultiple'){
  783.                         foreach ($filedValue as $item){
  784.                             if($item->getIsArchived()){
  786.                             }else{
  787.                                 $isNotEmpty = true;
  788.                             }
  789.                         }
  790.                         $filedValue2 = $etap->getFileCrdSigneeSansPtfMultiple();
  791.                         if(!$filedValue2->isEmpty()) {
  792.                             foreach ($filedValue2 as $item) {
  793.                                 if ($item->getIsArchived()) {
  795.                                 } else {
  796.                                     $isNotEmpty = true;
  797.                                 }
  798.                             }
  799.                         }
  800.                     }elseif ($fileName == 'fileCrdSigneeSansPtfMultiple'){
  801.                         foreach ($filedValue as $item){
  802.                             if($item->getIsArchived()){
  804.                             }else{
  805.                                 $isNotEmpty = true;
  806.                             }
  807.                         }
  808.                         $filedValue2 = $etap->getFileCrdSigneeMultiple();
  809.                         if(!$filedValue2->isEmpty()){
  810.                             foreach ($filedValue2 as $item){
  811.                                 if($item->getIsArchived()){
  813.                                 }else{
  814.                                     $isNotEmpty = true;
  815.                                 }
  816.                             }
  817.                         }
  818.                     }
  819.                     else{
  820.                         foreach ($filedValue as $item){
  821.                             if($item->getIsArchived()){
  823.                             }else{
  824.                                 $isNotEmpty = true;
  825.                             }
  826.                         }
  827.                     }
  829.                 }
  830.             }else{
  831.                 $nameGeteurFiled = 'get'.ucfirst($fileName);
  832.                 $filedValue = $etap->{$nameGeteurFiled}();
  833.                 if($filedValue){
  834.                     $isNotEmpty = true;
  835.                 }
  836.             }
  837.         }
  839.         return $isNotEmpty;
  840.     }
  841.     public function getAllFileNameTimeLine($project,$fileNameInput,$etapNum){
  842.         $etapNum = $etapNum;
  843.         $fileName = $fileNameInput;
  844.         $etapClass = 'App\\Entity\\Etap'.$etapNum;
  845.         $etap = $this->em->getRepository($etapClass)->findOneBy(['project'=>$project->getId()]);
  846.         $targetEntity = 'App\Entity\DocUpload';
  847.         $file = [];
  848.         if($etap){
  849.             $classMetadata = $this->em->getClassMetadata($etapClass);
  850.             $associationMappings = $classMetadata->getAssociationMapping($fileName);
  851.             if($associationMappings['targetEntity'] === $targetEntity){
  852.                 if ($associationMappings['type'] === \Doctrine\ORM\Mapping\ClassMetadata::MANY_TO_MANY){
  853.                     $nameGeteurFiled = 'get'.ucfirst($fileName);
  854. //                    if($etapNum == 10){
  855. //                        $condition = false;
  856. //                        if($etap->getIsPtf()){
  857. //                            if(in_array($fileName,['filePtfMultiple','fileCrdSigneeMultiple','filePreuveVirementMultiple'])){
  858. //                                $condition = true;
  859. //                            }
  860. //                        }else{
  861. //                            if(in_array($fileName,['fileCrdSigneeSansPtfMultiple','filePreuveVirementSansPtfMultiple'])){
  862. //                                $condition = true;
  863. //                            }
  864. //                        }
  865. //                        if($condition){
  866. //                            $filedValue = $etap->{$nameGeteurFiled}();
  867. //                            if(!$filedValue->isEmpty()){
  868. //                                foreach ($filedValue as $item){
  869. //                                    if($item->getIsArchived()){
  870. //
  871. //                                    }else{
  872. //                                        $file[] = $item;
  873. //                                    }
  874. //                                }
  875. //                            }
  876. //                        }
  877. //                    }else{
  878.                         $filedValue = $etap->{$nameGeteurFiled}();
  879.                         if(!$filedValue->isEmpty()){
  880.                             foreach ($filedValue as $item){
  881.                                 if($item->getIsArchived()){
  883.                                 }else{
  884.                                     $file[] = $item;
  885.                                 }
  886.                             }
  887.                         }
  888. //                    }
  889.                 }else{
  890.                     $nameGeteurFiled = 'get'.ucfirst($fileName);
  891.                     $filedValue = $etap->{$nameGeteurFiled}();
  892.                     if($filedValue){
  893.                         $file[] = $filedValue;
  894.                     }
  895.                 }
  896.             }
  897.         }
  898.         return $file;
  899.     }
  900.     public function getAllFileNameTimeLineCategory($project,$etapNum){
  901.         $etapNum = $etapNum;
  902.         $etapClass = 'App\\Entity\\Etap'.$etapNum;
  903.         $etap = $this->em->getRepository($etapClass)->findOneBy(['project'=>$project->getId()]);
  904.         $file = [];
  905.         $fileName = 'categorys';
  906.         if($etap){
  907.             $classMetadata = $this->em->getClassMetadata($etapClass);
  908.             $ssociationMappings = $classMetadata->getAssociationMappings();
  909.             if(array_key_exists('categorys',$ssociationMappings)){
  910.                 $associationMappings = $classMetadata->getAssociationMapping($fileName);
  911.                 if(isset($associationMappings['targetEntity']) && $associationMappings['targetEntity'] == 'App\Entity\CategoryDocument'){
  912.                     if ($associationMappings['type'] === \Doctrine\ORM\Mapping\ClassMetadata::ONE_TO_MANY){
  913.                         $nameGeteurFiled = 'get'.ucfirst($fileName);
  914.                         $filedValueCat = $etap->{$nameGeteurFiled}();
  915.                         if(!$filedValueCat->isEmpty()){
  916.                             foreach ($filedValueCat as $item){
  917.                                 if(!$item->getDocuments()->isEmpty()){
  918.                                     foreach ($item->getDocuments() as $document){
  919.                                         $doc = $document->getDocUpload() ;
  920.                                         if($doc){
  921.                                             $file[] = $doc;
  922.                                         }
  923.                                     }
  924.                                 }
  925.                             }
  926.                         }
  927.                     }
  928.                 }
  929.             }
  930.         }
  931.         return $file;
  932.     }
  934.     public function getAllFileNameTimeLineManyToMany($project,$etapNum,$etapsFilesManyToManyName,$fileNameInput,$class){
  935.         $etapNum = $etapNum;
  936.         $etapClass = 'App\\Entity\\Etap'.$etapNum;
  937.         $etap = $this->em->getRepository($etapClass)->findOneBy(['project'=>$project->getId()]);
  938.         $file = [];
  939.         $fileName = $fileNameInput;
  940.         $targetEntity = 'App\Entity\DocUpload';
  941.         if($etap){
  942.             $classMetadata = $this->em->getClassMetadata($etapClass);
  943.             $ssociationMappings = $classMetadata->getAssociationMappings();
  944.             if(array_key_exists($etapsFilesManyToManyName,$ssociationMappings)){
  945.                 $associationMappings = $classMetadata->getAssociationMapping($etapsFilesManyToManyName);
  946.                 if(isset($associationMappings['targetEntity'])){
  947.                     if ($associationMappings['type'] === \Doctrine\ORM\Mapping\ClassMetadata::ONE_TO_MANY){
  948.                         $nameGeteurFiled = 'get'.ucfirst($etapsFilesManyToManyName);
  949.                         $filedValueCat = $etap->{$nameGeteurFiled}();
  950.                         if(!$filedValueCat->isEmpty()){
  951.                             $etapClassDetail = 'App\\Entity\\'.$class;
  952.                             $classMetadataDetail = $this->em->getClassMetadata($etapClassDetail);
  953.                             $ssociationMappingsDetail = $classMetadataDetail->getAssociationMappings();
  954.                             if(array_key_exists($fileNameInput,$ssociationMappingsDetail)){
  955.                                 foreach ($filedValueCat as $item){
  956.                                     $associationMappingsDetail = $classMetadataDetail->getAssociationMapping($fileNameInput);
  957.                                     if($associationMappingsDetail['targetEntity'] === $targetEntity){
  958.                                         if ($associationMappingsDetail['type'] === \Doctrine\ORM\Mapping\ClassMetadata::MANY_TO_MANY){
  959.                                             $nameGeteurFiledDetail = 'get'.ucfirst($fileName);
  960.                                             $filedValueDetail = $item->{$nameGeteurFiledDetail}();
  961.                                             if(!$filedValueDetail->isEmpty()){
  962.                                                 foreach ($filedValueDetail as $item2){
  963.                                                     if($item2->getIsArchived()){
  965.                                                     }else{
  966.                                                         $file[] = $item2;
  967.                                                     }
  968.                                                 }
  969.                                             }
  970.                                         }else{
  971.                                             $nameGeteurFiledDetail = 'get'.ucfirst($fileName);
  972.                                             $filedValueDetail = $item->{$nameGeteurFiledDetail}();
  973.                                             if($filedValueDetail){
  974.                                                 $file[] = $filedValueDetail;
  975.                                             }
  976.                                         }
  977.                                     }
  978.                                 }
  979.                             }
  980.                         }
  981.                     }
  982.                 }
  983.             }
  984.         }
  985.         return $file;
  986.     }
  988.     public function getAllFileNameTimeLineManyToMany2($project,$etapNum,$etapsFilesManyToManyName,$fileNameInput,$class,$etapsFilesManyToManyName2,$class2){
  989.         $etapNum = $etapNum;
  990.         $etapClass = 'App\\Entity\\Etap'.$etapNum;
  991.         $etap = $this->em->getRepository($etapClass)->findOneBy(['project'=>$project->getId()]);
  992.         $file = [];
  993.         $fileName = $fileNameInput;
  994.         $targetEntity = 'App\Entity\DocUpload';
  995.         if($etap){
  996.             $classMetadata = $this->em->getClassMetadata($etapClass);
  997.             $ssociationMappings = $classMetadata->getAssociationMappings();
  998.             if(array_key_exists($etapsFilesManyToManyName,$ssociationMappings)){
  999.                 $associationMappings = $classMetadata->getAssociationMapping($etapsFilesManyToManyName);
  1000.                 if(isset($associationMappings['targetEntity'])){
  1001.                     if ($associationMappings['type'] === \Doctrine\ORM\Mapping\ClassMetadata::ONE_TO_MANY){
  1002.                         $nameGeteurFiled = 'get'.ucfirst($etapsFilesManyToManyName);
  1003.                         $filedValueCat = $etap->{$nameGeteurFiled}();
  1004.                         if(!$filedValueCat->isEmpty()){
  1005.                             $etapClassDetail = 'App\\Entity\\'.$class;
  1006.                             $classMetadataDetail = $this->em->getClassMetadata($etapClassDetail);
  1007.                             $ssociationMappingsDetail = $classMetadataDetail->getAssociationMappings();
  1009.                             if(array_key_exists($etapsFilesManyToManyName2,$ssociationMappingsDetail)) {
  1010.                                 foreach ($filedValueCat as $item1) {
  1011.                                     $associationMappings2 = $classMetadataDetail->getAssociationMapping($etapsFilesManyToManyName2);
  1012.                                     if (isset($associationMappings2['targetEntity'])) {
  1013.                                         if ($associationMappings2['type'] === \Doctrine\ORM\Mapping\ClassMetadata::ONE_TO_MANY) {
  1014.                                             $nameGeteurFiled2 = 'get' . ucfirst($etapsFilesManyToManyName2);
  1015.                                             $filedValueCat2 = $item1->{$nameGeteurFiled2}();
  1016.                                             if (!$filedValueCat2->isEmpty()) {
  1017.                                                 $etapClassDetail2 = 'App\\Entity\\' . $class2;
  1018.                                                 $classMetadataDetail2 = $this->em->getClassMetadata($etapClassDetail2);
  1019.                                                 $ssociationMappingsDetail2 = $classMetadataDetail2->getAssociationMappings();
  1020.                                                 if(array_key_exists($fileNameInput,$ssociationMappingsDetail2)){
  1021.                                                     foreach ($filedValueCat2 as $item){
  1022.                                                         $associationMappingsDetail2 = $classMetadataDetail2->getAssociationMapping($fileNameInput);
  1023.                                                         if($associationMappingsDetail2['targetEntity'] === $targetEntity){
  1024.                                                             if ($associationMappingsDetail2['type'] === \Doctrine\ORM\Mapping\ClassMetadata::MANY_TO_MANY){
  1025.                                                                 $nameGeteurFiledDetail = 'get'.ucfirst($fileName);
  1026.                                                                 $filedValueDetail = $item->{$nameGeteurFiledDetail}();
  1027.                                                                 if(!$filedValueDetail->isEmpty()){
  1028.                                                                     foreach ($filedValueDetail as $item2){
  1029.                                                                         if($item2->getIsArchived()){
  1031.                                                                         }else{
  1032.                                                                             $file[] = $item2;
  1033.                                                                         }
  1034.                                                                     }
  1035.                                                                 }
  1036.                                                             }else{
  1037.                                                                 $nameGeteurFiledDetail = 'get'.ucfirst($fileName);
  1038.                                                                 $filedValueDetail = $item->{$nameGeteurFiledDetail}();
  1039.                                                                 if($filedValueDetail){
  1040.                                                                     $file[] = $filedValueDetail;
  1041.                                                                 }
  1042.                                                             }
  1043.                                                         }
  1044.                                                     }
  1045.                                                 }
  1046.                                             }
  1047.                                         }
  1048.                                     }
  1049.                                 }
  1050.                             }
  1055.                         }
  1056.                     }
  1057.                 }
  1058.             }
  1059.         }
  1060.         return $file;
  1061.     }
  1062.     public function getAllFileNameFactureProject($project){
  1063.         $factures = $this->em->getRepository(FactureFinance::class)->getFacturesProject([$project->getId()]);
  1064.         $file = [];
  1065.         foreach ($factures as $facture){
  1066.             if($facture->getFileFacture()){
  1067.                 $file[] = $facture->getFileFacture();
  1068.             }
  1069.         }
  1070.         return $file;
  1071.     }
  1072.     public function getAllFileNameAvoirProject($project){
  1073.         $factures = $this->em->getRepository(Avoir::class)->getAvoirsProject([$project->getId()]);
  1074.         $file = [];
  1075.         foreach ($factures as $facture){
  1076.             if($facture->getFileAvoir()){
  1077.                 $file[] = $facture->getFileAvoir();
  1078.             }
  1079.         }
  1080.         return $file;
  1081.     }
  1082.     public function getDocsName($project = null){
  1083.         $docsName = $this->projectService->getDocsName($project);
  1084.         return $docsName;
  1085.     }
  1086.     public function checkEtap3StatusFermee($project){
  1087.         $etap171 = $this->em->getRepository(Etap171::class)->findOneBy(['project'=>$project->getId()]);
  1088.         $etap172 = $this->em->getRepository(Etap172::class)->findOneBy(['project'=>$project->getId()]);
  1089.         $etap173 = $this->em->getRepository(Etap173::class)->findOneBy(['project'=>$project->getId()]);
  1090.         $etap174 = $this->em->getRepository(Etap174::class)->findOneBy(['project'=>$project->getId()]);
  1091.         $etap175 = $this->em->getRepository(Etap175::class)->findOneBy(['project'=>$project->getId()]);
  1092.         if(($etap171 && $etap171->getStatus() == Etaps::STATUS_FERMEE)
  1093.             && ($etap172 && $etap172->getStatus() == Etaps::STATUS_FERMEE)
  1094.             && ($etap173 && $etap173->getStatus() == Etaps::STATUS_FERMEE)
  1095.             && ($etap174 && $etap174->getStatus() == Etaps::STATUS_FERMEE)
  1096.             && ($etap175 && $etap175->getStatus() == Etaps::STATUS_FERMEE)
  1097.         ){
  1098.             return true;
  1099.         }else{
  1100.             return false;
  1101.         }
  1102.     }
  1103.     public function checkEtap3Status($project){
  1104.         $etap171 = $this->em->getRepository(Etap171::class)->findOneBy(['project'=>$project->getId()]);
  1105.         $etap172 = $this->em->getRepository(Etap172::class)->findOneBy(['project'=>$project->getId()]);
  1106.         $etap173 = $this->em->getRepository(Etap173::class)->findOneBy(['project'=>$project->getId()]);
  1107.         $etap174 = $this->em->getRepository(Etap174::class)->findOneBy(['project'=>$project->getId()]);
  1108.         $etap175 = $this->em->getRepository(Etap175::class)->findOneBy(['project'=>$project->getId()]);
  1109.         if(($etap171 && $etap171->getStatus() == Etaps::STATUS_FERMEE)
  1110.             && ($etap172 && $etap172->getStatus() == Etaps::STATUS_FERMEE)
  1111.             && ($etap173 && $etap173->getStatus() == Etaps::STATUS_FERMEE)
  1112.             && ($etap174 && $etap174->getStatus() == Etaps::STATUS_FERMEE)
  1113.             && ($etap175 && $etap175->getStatus() == Etaps::STATUS_FERMEE)
  1114.         ){
  1115.             return Etaps::STATUS_FERMEE;
  1116.         }elseif(($etap171 && $etap171->getStatus() == Etaps::STATUS_VALIDE)
  1117.             && ($etap172 && $etap172->getStatus() == Etaps::STATUS_VALIDE)
  1118.             && ($etap173 && $etap173->getStatus() == Etaps::STATUS_VALIDE)
  1119.             && ($etap174 && $etap174->getStatus() == Etaps::STATUS_VALIDE)
  1120.             && ($etap175 && $etap175->getStatus() == Etaps::STATUS_VALIDE)
  1121.         ){
  1122.             return Etaps::STATUS_VALIDE;
  1123.         }elseif(($etap171 && in_array($etap171->getStatus() , [Etaps::STATUS_DEMANDE]))
  1124.             || ($etap172 && in_array($etap172->getStatus() , [Etaps::STATUS_DEMANDE]))
  1125.             || ($etap173 && in_array($etap173->getStatus() , [Etaps::STATUS_DEMANDE]))
  1126.             || ($etap174 && in_array($etap174->getStatus() , [Etaps::STATUS_DEMANDE]))
  1127.             || ($etap175 && in_array($etap175->getStatus() , [Etaps::STATUS_DEMANDE]))
  1128.         ){
  1129.             return Etaps::STATUS_DEMANDE;
  1130.         }elseif(($etap171 && in_array($etap171->getStatus() , [Etaps::STATUS_EN_ATTENT]))
  1131.             || ($etap172 && in_array($etap172->getStatus() , [Etaps::STATUS_EN_ATTENT]))
  1132.             || ($etap173 && in_array($etap173->getStatus() , [Etaps::STATUS_EN_ATTENT]))
  1133.             || ($etap174 && in_array($etap174->getStatus() , [Etaps::STATUS_EN_ATTENT]))
  1134.             || ($etap175 && in_array($etap175->getStatus() , [Etaps::STATUS_EN_ATTENT]))
  1135.         ){
  1136.             return Etaps::STATUS_EN_ATTENT;
  1137.         }elseif(($etap171 && in_array($etap171->getStatus() , [Etaps::STATUS_REFUSE]))
  1138.             || ($etap172 && in_array($etap172->getStatus() , [Etaps::STATUS_REFUSE]))
  1139.             || ($etap173 && in_array($etap173->getStatus() , [Etaps::STATUS_REFUSE]))
  1140.             || ($etap174 && in_array($etap174->getStatus() , [Etaps::STATUS_REFUSE]))
  1141.             || ($etap175 && in_array($etap175->getStatus() , [Etaps::STATUS_REFUSE]))
  1142.         ){
  1143.             return Etaps::STATUS_REFUSE;
  1144.         }
  1145.         elseif(($etap171 && in_array($etap171->getStatus() , [Etaps::STATUS_EN_COURS]))
  1146.             || ($etap172 && in_array($etap172->getStatus() , [Etaps::STATUS_EN_COURS]))
  1147.             || ($etap173 && in_array($etap173->getStatus() , [Etaps::STATUS_EN_COURS]))
  1148.             || ($etap174 && in_array($etap174->getStatus() , [Etaps::STATUS_EN_COURS]))
  1149.             || ($etap175 && in_array($etap175->getStatus() , [Etaps::STATUS_EN_COURS]))
  1150.         ){
  1151.             return Etaps::STATUS_EN_COURS;
  1152.         }else{
  1153.             return false;
  1154.         }
  1155.     }
  1156.     public function checkEtap3StatusName($project){
  1157.         $etap171 = $this->em->getRepository(Etap171::class)->findOneBy(['project'=>$project->getId()]);
  1158.         $etap172 = $this->em->getRepository(Etap172::class)->findOneBy(['project'=>$project->getId()]);
  1159.         $etap173 = $this->em->getRepository(Etap173::class)->findOneBy(['project'=>$project->getId()]);
  1160.         $etap174 = $this->em->getRepository(Etap174::class)->findOneBy(['project'=>$project->getId()]);
  1161.         $etap175 = $this->em->getRepository(Etap175::class)->findOneBy(['project'=>$project->getId()]);
  1162.         if(($etap171 && $etap171->getStatus() == Etaps::STATUS_EN_ATTENT)
  1163.             || ($etap172 && $etap172->getStatus() == Etaps::STATUS_EN_ATTENT)
  1164.             || ($etap173 && $etap173->getStatus() == Etaps::STATUS_EN_ATTENT)
  1165.             || ($etap174 && $etap174->getStatus() == Etaps::STATUS_EN_ATTENT)
  1166.             || ($etap175 && $etap175->getStatus() == Etaps::STATUS_EN_ATTENT)
  1167.         ){
  1168.             return 'En attente de validation';
  1169.         }elseif (($etap171 && $etap171->getStatus() == Etaps::STATUS_REFUSE)
  1170.             || ($etap172 && $etap172->getStatus() == Etaps::STATUS_REFUSE)
  1171.             || ($etap173 && $etap173->getStatus() == Etaps::STATUS_REFUSE)
  1172.             || ($etap174 && $etap174->getStatus() == Etaps::STATUS_REFUSE)
  1173.             || ($etap175 && $etap175->getStatus() == Etaps::STATUS_REFUSE)
  1174.         ){
  1175.            return 'L\'etape a été refusé';
  1176.         }elseif (($etap171 && $etap171->getStatus() == Etaps::STATUS_DEMANDE)
  1177.             || ($etap172 && $etap172->getStatus() == Etaps::STATUS_DEMANDE)
  1178.             || ($etap173 && $etap173->getStatus() == Etaps::STATUS_DEMANDE)
  1179.             || ($etap174 && $etap174->getStatus() == Etaps::STATUS_DEMANDE)
  1180.             || ($etap175 && $etap175->getStatus() == Etaps::STATUS_DEMANDE)
  1181.         ){
  1182.             return 'Demande de complément';
  1183.         }else{
  1184.             return false;
  1185.         }
  1186.     }
  1187.     public function getDocUploadMultipleNotArchiveEntity($array){
  1188.         $val = null;
  1189.         if(count($array)>0){
  1190.             foreach ($array as $value){
  1191.                 if(!$value->getIsArchived()){
  1192.                     $val =  $value;
  1193.                 }
  1194.             }
  1195.         }
  1196.         return $val;
  1197.     }
  1198.     public function getDocUploadMultipleNotArchiveEntityImage($array){
  1199.         $val = null;
  1200.         if(count($array)>0){
  1201.             foreach ($array as $value){
  1202.                 if(!$value->getIsArchived() and ($this->checkIfInArrayString(['.png', '.jpg','.jpeg','heic'],$value->getPath()))){
  1203.                     $val =  $value;
  1204.                 }
  1205.             }
  1206.         }
  1207.         return $val;
  1208.     }
  1209.     private function checkIfInArrayString($array, $searchingFor) {
  1210.         foreach ($array as $element) {
  1211.             if (strpos($searchingFor, $element) !== false) {
  1212.                 return true;
  1213.             }
  1214.         }
  1215.         return false;
  1216.     }
  1217.     public function getDocUploadMultipleNotArchive($array){
  1218.         $token = null;
  1219.         if(count($array)>0){
  1220.             foreach ($array as $value){
  1221.                 if(!$value->getIsArchived()){
  1222.                     $token =  $value->getToken();
  1223.                 }
  1224.             }
  1225.         }
  1226.         return $token;
  1227.     }
  1228.     public function getDocUploadMultipleNotArchiveString($array){
  1229.         $strTokens = '';
  1230.         if(count($array)>0){
  1231.             $lastArray = $array[count($array)-1];
  1232.             foreach ($array as $value){
  1233.                 if(!$value->getIsArchived()){
  1234.                     $strTokens .=  $value->getToken();
  1235.                     if($value->getId() != $lastArray->getId()){
  1236.                         $strTokens .= ',';
  1237.                     }
  1238.                 }
  1240.             }
  1241.         }
  1242.         return $strTokens;
  1243.     }
  1244.     public function espaceNumber($str,$chiffreApresVergule = 3){
  1245.         $formattedNumber = str_replace(',','.',$str);
  1246.         if($formattedNumber and is_numeric($formattedNumber)){
  1247.             if(strpos($formattedNumber,'.') or strpos($formattedNumber,',')){
  1248.                 if(strpos($formattedNumber,'.')){
  1249.                     $formattedNumber = number_format($formattedNumber, $chiffreApresVergule, '.', ' ');
  1250.                 }else{
  1251.                     $formattedNumber = number_format($formattedNumber, $chiffreApresVergule, ',', ' ');
  1252.                 }
  1254.             }else{
  1255.                 $formattedNumber = number_format($formattedNumber, 0, '0', ' ');
  1256.             }
  1257.         }
  1258.         return $formattedNumber;
  1259.     }
  1260.     public function checkInformationProprietaireEtap6Raccordement($project){
  1261.         $etap = $this->em->getRepository(Etap14::class)->findOneBy(['project'=>$project->getId()]);
  1262.         if($etap){
  1263.             if(!empty($etap->getAdresseMiseEnService()) or !empty($etap->getCityMiseEnService()) or !empty($etap->getCodePostalMiseEnService()) or !empty($etap->getFirstnameProprietaire()) or !empty($etap->getLastnameProprietaire()) or !empty($etap->getPhoneProprietaire()) ){
  1264.                 return true;
  1265.             }
  1266.         }
  1267.         return false;
  1268.     }
  1269.     public function getAbreviation($user=null){
  1270.         $name = '';
  1271.         $nameAB = 'X';
  1272.         $role = '';
  1273.         $entreprise = null;
  1274.         if($user){
  1275.             $name = ucwords((string)$user->getFirstname()).' '.ucwords((string)$user->getLastname());
  1276.             $role = $user->getRoleStringComplet();
  1277.             $entreprise = $user->getEntreprise() ? ucfirst($user->getEntreprise()->getName()) : null;
  1278.             $nameAB = substr((string)$user->getFirstname(), 0, 1) .substr((string)$user->getLastname(), 0, 1);
  1279.         }
  1280.         return ['entreprise'=>$entreprise,'role'=>$role,'name' => $name,'nameAB' => strtoupper($nameAB)];
  1281.     }
  1282.     public function getDocsPartage($project){
  1283.         $docs = $this->uploadService->getFilesPorjectPartage($project);
  1284.         return $docs ;
  1285.     }
  1286.     public function getEpcs($role){
  1287.         $users = $this->em->getRepository(User::class)->getUserByRole($role);
  1288.         return $users ;
  1289.     }
  1290.     public function getUserByRoles($roles){
  1291.         $users = $this->em->getRepository(User::class)->getUserByRoles($roles);
  1292.         return $users ;
  1293.     }
  1294.     public function checkOpenEtap($etap){
  1295.         if($etap) {
  1296.             if ($etap->getEtap()->getCategory()->getNum() == 1) {
  1297.                 if($etap->getProject()->getIsOpenCat1()){
  1298.                     return true;
  1299.                 }
  1300.             } elseif ($etap->getEtap()->getCategory()->getNum() == 2) {
  1301.                 if($etap->getProject()->getIsOpenCat2()){
  1302.                     return true;
  1303.                 }
  1304.             } elseif ($etap->getEtap()->getCategory()->getNum() == 3) {
  1305.                 if($etap->getProject()->getIsOpenCat3()){
  1306.                     return true;
  1307.                 }
  1308.             } elseif ($etap->getEtap()->getCategory()->getNum() == 4) {
  1309.                 if($etap->getProject()->getIsOpenCat4()){
  1310.                     return true;
  1311.                 }
  1312.             }
  1313.         }
  1314.         return false;
  1315.     }
  1316.     public function completudeCategory($project){
  1317.         $array = $this->etapsService->completudeValideEtapProject($project);
  1318.         $cats = $this->em->getRepository(EtapsCategory::class)->findAll();
  1319.         if(isset($array['category'])){
  1320.             return $this->twig->render('user/etaps/completude.html.twig', [
  1321.                 'completude' => $array,
  1322.                 'cats' => $cats,
  1323.             ]);
  1324.         }else{
  1325.             return [];
  1326.         }
  1327.     }
  1328.     public function completudeDocsCategory($project){
  1329.         $array = $this->etapsService->completudeValideDocumentEtapProject($project);
  1330.         $cats = $this->em->getRepository(EtapsCategory::class)->findAll();
  1331.         if(isset($array['category'])){
  1332.             return $this->twig->render('user/etaps/completudeDocs.html.twig', [
  1333.                 'completude' => $array,
  1334.                 'cats' => $cats,
  1335.                 'project' => $project,
  1336.             ]);
  1337.         }else{
  1338.             return [];
  1339.         }
  1340.     }
  1341.     public function getNotisNotLu($user){
  1343.         $notifs = $this->notifications->getNotifictionNotLu($user);
  1344.         return $notifs;
  1345.     }
  1346.     public function getSpvs(){
  1348.         $spvs = $this->em->getRepository(Spv::class)->getSpvEnabled();
  1349.         return $spvs;
  1350.     }
  1351.     public function getEtapNameByNum($num){
  1352.         $etap = $this->em->getRepository(Etaps::class)->findOneBy(['num'=>$num]);
  1353.         return $etap ? $etap->getName():' ';
  1354.     }
  1355.     public function getEtapByNumAndProject($num,$project){
  1356.         $etapEntity = 'App\\Entity\\Etap'.$num;
  1357.         if($project){
  1358.             $etap = $this->em->getRepository($etapEntity)->findOneBy(['project'=>$project->getId()]);
  1359.             return $etap ;
  1360.         }else{
  1361.             return null;
  1362.         }
  1363.     }
  1364.     public function getTimelinePointEtapByNum($project,$num,$etapCurrent){
  1365.         if(is_object($project)){
  1366.             $etapEntity = 'App\\Entity\\Etap'.$num;
  1367.             $etap = $this->em->getRepository($etapEntity)->findOneBy(['project'=>$project->getId()]);
  1368.             return $this->twig->render('user/etaps/timeline-point.html.twig', [
  1369.                 'etap' => $etap,
  1370.                 'etapCurrent' => $etapCurrent
  1371.             ]);
  1373.         }
  1374.         return ' ';
  1375.     }
  1376.     public function getCommentEtapByNum($project,$num){
  1377.         if(is_object($project)){
  1378.             $comments = $this->em->getRepository(CommentEtap::class)->findBy(['project'=>$project->getId(),'etapNum'=>$num]);
  1379.             $response = $this->twig->render('user/etaps/etapComment.html.twig',['comments'=>$comments,'multiple'=>true]);
  1380.             return $response;
  1382.         }
  1383.         return ' ';
  1384.     }
  1385.     public function checkCommentEtapByNum($project,$num){
  1386.         if(is_object($project)){
  1387.             $comments = $this->em->getRepository(CommentEtap::class)->findBy(['project'=>$project->getId(),'etapNum'=>$num]);
  1388.             if($comments){
  1389.                 return true;
  1390.             }
  1391.         }
  1392.         return false;
  1393.     }
  1394.     public function getDateFichierFactureFinancePaiement($factureFinancePaiment){
  1395.         if(is_object($factureFinancePaiment)){
  1396.             $details = $this->em->getRepository(FactureFinancePaiementDetail::class)->findBy(['factureFinancePaiement'=>$factureFinancePaiment->getId()]);
  1397.            if($details){
  1398.                $detail = $details[0];
  1399.                if($detail->getFactureFinance() && $detail->getFactureFinance()->getDatePaiementGenerateFichier()){
  1400.                    return $detail->getFactureFinance()->getDatePaiementGenerateFichier();
  1401.                }
  1402.            }
  1405.         }
  1406.         return null;
  1407.     }
  1409.     public function getTypeValorisation(){
  1410.         $typeValorisations = $this->em->getRepository(TypeValorisation::class)->findAll();
  1411.         return $typeValorisations;
  1412.     }
  1413. }