src/Service/ServiceTeaminfo.php line 2135

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\Entity\User;
  6. use App\Entity\Entreprise;
  7. use App\Entity\ProjectFacturation;
  8. use App\Entity\Site;
  9. use App\Entity\Tikets;
  10. use App\Entity\ProjectFrais;
  11. use App\Entity\TicketReseaux;
  12. use App\Entity\Interventions;
  13. use App\Entity\Projects;
  14. use App\Entity\ProjectUsers;
  15. use App\Entity\ProjectEquipe;
  16. use App\Entity\Equipes;
  17. use App\Entity\Notifications;
  18. use App\Entity\InterventionsMateriel;
  19. use App\Entity\InterventionAffectedTags;
  20. use App\Entity\InterventionImages;
  21. use App\Entity\InterventionAffectedUsers;
  22. use App\Entity\InterventionAffectedEquipes;
  23. use App\Entity\ProjectSuiviTravaux;
  24. use App\Entity\ProjectAffectedDays;
  25. use App\Entity\ProjectsAutoPlanifiedTasks;
  26. use App\Repository\SiteRepository;
  27. use App\Repository\InterventionsRepository;
  28. use App\Repository\ProjectsRepository;
  29. use Doctrine\ORM\EntityManagerInterface;
  30. use Symfony\Component\DependencyInjection\ContainerInterface;
  31. use Twig\Environment;
  32. use Symfony\Component\HttpFoundation\RequestStack;
  33. use Symfony\Component\HttpFoundation\Response;
  34. use Symfony\Component\HttpFoundation\Cookie;
  35. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  36. use Symfony\Component\HttpFoundation\Session\Session;
  37. use Symfony\Component\Validator\Constraints\DateTime;
  38. use Symfony\Component\Routing\RouterInterface;
  40. use \Ovh\Api;
  42. class ServiceTeaminfo
  43. {
  44.     private $SiteRepository;
  45.     private $em;
  46.     private $container;
  47.     private $twig;
  48.     protected $requestStack;
  49.     private $tokenStorage;
  50.     private $InterventionsRepository;
  51.     private $ProjectsRepository;
  52.     public $currentView;
  53.     public $currentProjectVue;
  54.     public $currentTicketVue;
  55.     public $currentCongesVue;
  56.     public $currentProjectYearVue;
  57.     public const DEFAULT_LIMIT = 50;
  58.     public const DEFAULT_LIMIT_PROJECTS = 50;
  59.     public const INTERVENTION_FILTER = "intervention_filter";
  60.     public const TICKET_FILTER = "ticket_filter";
  61.     public const PROJECT_FILTER = "project_filter";
  62.     public const PROJECT_PLANIFICATEUR_FILTER = "project_planificateur_filter";
  63.     public const PROJECT_INTERVENANT_FILTER = "project_intervenant_filter";
  64.     public const CONGE_FILTER = "conge_filter";
  65.     public $widthsAndDefaultView;
  66.     public $projectVue;
  67.     public $ticketVue;
  68.     public $days;
  69.     public $image_extensions;
  70.     public const COLORS = array('#EC083C', '#DA3C78', '#7E349D', '#0077C0', '#07ABA0', '#F1892D', '#39F3E5', '#FA51E9', '#08D333', '#F59C66', "#FF69B4", "#FF0000", "#FFA500", "#FFFF00", "#808000", "#800000", "#008000", "#800080", "#FF00FF", "#00FF00", "#008080", "#00FFFF", "#0000FF", "#000080", "#808080", "#CD5C5C", "#FFEBCD", "#BC8F8F", "#D2691E");
  71.     public const DARK_COLORS = array("#C71585", "#8B0000", "#FF4500", "#BDB76B", "#006400", "#008080", "#191970", "#800000", "#6495ED", "#000000", "#BC8F8F", "#FFD700", "#696969", "#4682B4", "#3CB371", "#FFF804", "#DC143C", "#E9967A", "#FF00FF", "#FF1493");
  72.     public const MORNING_START = "08:00";
  73.     public const MORNING_END = "13:00";
  74.     public const MIDDAY_START = "14:00";
  75.     public const MIDDAY_END = "18:00";
  76.     public const MONTHS = array(
  77.         '1' => array('key' => 'Jan', 'libelle' => 'Janvier'),
  78.         '2' => array('key' => 'Feb', 'libelle' => 'Février'),
  79.         '3' => array('key' => 'Mar', 'libelle' => 'Mars'),
  80.         '4' => array('key' => 'Apr', 'libelle' => 'Avril'),
  81.         '5' => array('key' => 'May', 'libelle' => 'Mai'),
  82.         '6' => array('key' => 'Jun', 'libelle' => 'Juin'),
  83.         '7' => array('key' => 'Jul', 'libelle' => 'Juillet'),
  84.         '8' => array('key' => 'Aug', 'libelle' => 'Aout'),
  85.         '9' => array('key' => 'Sep', 'libelle' => 'Septembre'),
  86.         '10' => array('key' => 'Oct', 'libelle' => 'Octobre'),
  87.         '11' => array('key' => 'Nov', 'libelle' => 'Novembre'),
  88.         '12' => array('key' => 'Dec', 'libelle' => 'Décembre')
  89.     );
  91.     private $router;
  94.     public function __construct(?RouterInterface $router, ?SiteRepository $SiteRepository, ?EntityManagerInterface $em, ?ContainerInterface $container, ?Environment $twig, ?RequestStack $requestStack, ?TokenStorageInterface $tokenStorage, ?InterventionsRepository $InterventionsRepository, ?ProjectsRepository $ProjectsRepository)
  95.     {
  96.         $this->SiteRepository = $SiteRepository;
  97.         $this->InterventionsRepository = $InterventionsRepository;
  98.         $this->ProjectsRepository = $ProjectsRepository;
  99.         $this->em = $em;
  100.         $this->container = $container;
  101.         $this->twig = $twig;
  102.         $this->requestStack = $requestStack;
  103.         $this->tokenStorage = $tokenStorage;
  104.         $this->router = $router;
  105.         $this->image_extensions = explode(",", $container->getParameter('extension_accepte'));
  106.         $this->widthsAndDefaultView = array(
  107.             "etat" => array("width" => "60", "default" => 1, "libelle" => 'Etat'),
  108.             "client" => array("width" => "150", "default" => 1, "libelle" => 'Client'),
  109.             "type" => array("width" => "150", "default" => 1, "libelle" => 'Type intervention'),
  110.             "description" => array("width" => "250", "default" => 1, "libelle" => 'Description'),
  111.             "date" => array("width" => "90", "default" => 1, "libelle" => 'Date'),
  112.             "heure_debut" => array("width" => "135", "default" => 1, "libelle" => 'Heure de début'),
  113.             "facturation" => array("width" => "160", "default" => 1, "libelle" => 'Facturation'),
  114.             "technicien" => array("width" => "150", "default" => 1, "libelle" => 'Technicien'),
  115.             "adresse" => array("width" => "210", "default" => 0, "libelle" => 'Adresse de l\' intervention'),
  116.             "tags" => array("width" => "300", "default" => 0, "libelle" => 'Tags'),
  117.             "duree" => array("width" => "90", "default" => 0, "libelle" => 'Durée'),
  118.             "nb_documents" => array("width" => "171", "default" => 0, "libelle" => 'Nombre de document'),
  119.             "tickets_reseaux" => array("width" => "160", "default" => 0, "libelle" => 'Ticket réseau'),
  120.             "site" => array("width" => "180", "default" => 0, "libelle" => 'Site'),
  121.             "interlocutor" => array("width" => "150", "default" => 0, "libelle" => 'Référant'),
  123.         );
  125.         $this->projectVue = array(
  126.             "libelle" => array("width" => "300", "default" => 1, "libelle" => 'Libelle'),
  127.             "date_debut" => array("width" => "90", "default" => 1, "libelle" => 'Date de début'),
  128.             "date_fin" => array("width" => "90", "default" => 1, "libelle" => 'Date de fin'),
  129.             "etat" => array("width" => "120", "default" => 1, "libelle" => 'Etat'),
  130.             "client" => array("width" => "150", "default" => 0, "libelle" => 'Client'),
  131.             "nb_heures_estimer" => array("width" => "90", "default" => 0, "libelle" => 'Nombre d\'heures estimé'),
  132.             "nb_heure_planifier" => array("width" => "90", "default" => 0, "libelle" => 'Nombre d\'heures plannifiées'),
  133.             "avancement" => array("width" => "110", "default" => 0, "libelle" => 'Avancement'),
  134.             "planificateurs" => array("width" => "150", "default" => 0, "libelle" => 'Planificateurs'),
  135.             "intervenants" => array("width" => "200", "default" => 0, "libelle" => 'Intervenants'),
  136.             "materiels" => array("width" => "150", "default" => 0, "libelle" => 'Matériels'),
  137.             "interlocutor" => array("width" => "150", "default" => 0, "libelle" => 'Référant'),
  138.         );
  141.         $this->ticketVue = array(
  142.             "client_ticket" => array("width" => "150", "default" => 1, "libelle" => 'Client'),
  143.             "date" => array("width" => "90", "default" => 1, "libelle" => 'Date'),
  144.             "statut" => array("width" => "90", "default" => 1, "libelle" => 'Statut'),
  145.             "description" => array("width" => "250", "default" => 1, "libelle" => 'Description'),
  146.             "criticite" => array("width" => "90", "default" => 1, "libelle" => 'Criticité'),
  147.             "site" => array("width" => "150", "default" => 1, "libelle" => 'Site'),
  148.             "type_ticket" => array("width" => "150", "default" => 0, "libelle" => 'Type de ticket'),
  149.             "tags" => array("width" => "150", "default" => 0, "libelle" => 'Tags'),
  150.             "saisie_par" => array("width" => "150", "default" => 0, "libelle" => 'Saisie par'),
  151.             "ticket_affecte_a" => array("width" => "150", "default" => 0, "libelle" => 'Ticket affecte a'),
  152.             "ticket_supervise_par" => array("width" => "150", "default" => 0, "libelle" => 'Ticket supervisé par'),
  153.             "date_prev_real" => array("width" => "150", "default" => 0, "libelle" => 'Date prévisionnelle de réalisation'),
  154.             "date_ech" => array("width" => "150", "default" => 0, "libelle" => 'Date d\'échéance'),
  155.         );
  158.         $this->projectVueUserClient = array(
  159.             "id" => 0,
  160.             "libelle" => 1,
  161.             "date_debut" => 1,
  162.             "date_fin" => 1,
  163.             "etat" => 0,
  164.             "client" => 0,
  165.             "nb_heures_estimer" => 1,
  166.             "nb_heure_planifier" => 0,
  167.             "avancement" => 0,
  168.             "planificateurs" => 0,
  169.             "intervenants" => 0,
  170.             "materiels" => 0,
  171.             "interlocutor" => 0,
  172.         );
  175.         $this->projectYearVue = array(
  176.             "intervenant" => array("default" => 1, "libelle" => 'Intervenant'),
  177.             "project" => array("default" => 0, "libelle" => 'Projets'),
  178.             "client" => array("default" => 0, "libelle" => 'Clients'),
  179.             "devis" => array("default" => 0, "libelle" => 'Devis'),
  180.             "manager" => array("default" => 0, "libelle" => 'Maîtrise d\'oeuvre'),
  181.             "fournisseur" => array("default" => 0, "libelle" => 'Fournisseurs'),
  182.             "lot" => array("default" => 0, "libelle" => 'Lots'),
  183.             "agrement" => array("default" => 0, "libelle" => 'Contrat d\'agrément '),
  184.             "sous-traitant" => array("default" => 0, "libelle" => 'Sous-traitant'),
  185.             "fusion_intervenant" => array("default" => 0, "libelle" => 'Fusion des intervenants'),
  186.         );
  189.         $this->days = array(
  190.             'lundi' => 'Lundi',
  191.             'mardi' => 'Mardi',
  192.             'mercredi' => 'Mercredi',
  193.             'jeudi' => 'Jeudi',
  194.             'vendredi' => 'Vendredi',
  195.             'samedi' => 'Samedi',
  196.             'dimanche' => 'Dimanche'
  197.         );
  199.         if ($this->requestStack) {
  200.             if ($this->requestStack->getCurrentRequest()) {
  201.                 $cookies = $this->requestStack->getCurrentRequest()->cookies;
  203.                 if ($cookies->has('current_intervention_vue')) {
  204.                     $current_vue = unserialize($cookies->get('current_intervention_vue'));
  206.                     if ($current_vue)
  207.                         $this->currentView = array_keys($current_vue, "1");
  208.                 }
  210.                 if ($cookies->has('current_project_vue')) {
  211.                     $current_project_vue = unserialize($cookies->get('current_project_vue'));
  213.                     if ($current_project_vue)
  214.                         $this->currentProjectVue = array_keys($current_project_vue, "1");
  215.                 }
  217.                 if ($cookies->has('current_ticket_vue')) {
  218.                     $current_ticket_vue = unserialize($cookies->get('current_ticket_vue'));
  220.                     if ($current_ticket_vue)
  221.                         $this->currentTicketVue = array_keys($current_ticket_vue, "1");
  222.                 }
  224.                 if ($cookies->has('current_project_year_vue')) {
  225.                     $current_project_year_vue = (array) json_decode($cookies->get('current_project_year_vue'));
  227.                     if ($current_project_year_vue)
  228.                         $this->currentProjectYearVue = array_keys($current_project_year_vue, "1");
  229.                 }
  230.             }
  231.         }
  233.     }
  237.     public function GetSites()
  238.     {
  239.         $ids_sites = 0;
  240.         $request = $this->requestStack->getCurrentRequest();
  241.         $cookies = $request->cookies;
  242.         $sites = $cookies->get('site');
  244.         if ($sites)
  245.             $ids_sites = explode(',', $sites);
  247.         return $ids_sites;
  248.     }
  252.     public function IsJournalProjet()
  253.     {
  254.         $entreprise = $this->em->getRepository('App\Entity\Entreprise')->find($this->container->getParameter('entreprise_id'));
  256.         return $entreprise->getIsJournalProjet();
  258.     }
  261.     public function generatePdf($content, $Dossier, $nom)
  262.     {
  263.         $request = $this->requestStack->getCurrentRequest();
  265.         $base_path = $request->server->get('DOCUMENT_ROOT') . $request->getBasePath();
  266.         $base_url = $request->getSchemeAndHttpHost() . $request->getBasePath();
  268.         $server_path = "/" . $Dossier . "/" . date("Y") . '/';
  269.         if (!file_exists($base_path . $server_path))
  270.             mkdir($base_path . $server_path, 0777);
  272.         $server_path .= date("m") . '/';
  273.         if (!file_exists($base_path . $server_path))
  274.             mkdir($base_path . $server_path, 0777);
  276.         $server_path .= date("d") . '/';
  277.         if (!file_exists($base_path . $server_path))
  278.             mkdir($base_path . $server_path, 0777);
  280.         $file_name = $nom . uniqid() . ".pdf";
  281.         $url = $base_url . $server_path . $file_name;
  283.         $pdf_file = $this->generate_pdf($content, array(), $file_name, $base_path . $server_path);
  285.         return $url;
  286.     }
  288.     public function formatPrice($prix, $currency = true)
  289.     {
  290.         $price_format = number_format($prix, 2, ",", " ");
  292.         if ($currency == true)
  293.             $price_format .= " €";
  295.         return $price_format;
  296.     }
  298.     function set_user_duree($User)
  299.     {
  300.         $count_jour = $this->InterventionsRepository->DureeInterventionByUser($User->getId(), true);
  301.         $Duree = $this->InterventionsRepository->DureeInterventionByUser($User->getId());
  303.         if ($count_jour)
  304.             $User->setTotalInterventionsJours($count_jour);
  305.         else
  306.             $User->setTotalInterventionsJours(0);
  308.         if ($Duree)
  309.             $User->setTotalInterventionsReel($Duree);
  310.         else
  311.             $User->setTotalInterventionsReel(0);
  313.         $this->em->persist($User);
  314.         $this->em->flush();
  316.     }
  319.     public function listeSites()
  320.     {
  321.         $entreprise_id = $this->container->getParameter('entreprise_id');
  322.         $sites = $this->em->getRepository(Site::class)->findBy(['entreprise' => $entreprise_id, 'deleted' => null]);
  324.         $entreprise = $this->em->getRepository(Entreprise::class)->find($entreprise_id);
  325.         $id_client_interne = $entreprise->getCompteInterne()->getId();
  327.         $user_connected = $this->tokenStorage->getToken()->getUser();
  328.         $current_site_id = $user_connected->getSiteRatachement()->getId();
  329.         $request = $this->requestStack->getCurrentRequest();
  330.         $cookies = $request->cookies;
  331.         $sites_ids = array();
  333.         if (!$cookies->has('site')) {
  334.             $response = new Response();
  335.             $cookie = new Cookie('site', $current_site_id, time() + (365 * 24 * 60 * 60), '/', null, false, false);
  336.             $response->headers->setCookie($cookie);
  337.             $response->sendHeaders();
  339.             array_push($sites_ids, $current_site_id);
  340.         } else {
  341.             $sites_ids = $this->GetSites();
  342.         }
  344.         $has_atelier = 0;
  346.         foreach ($sites as $site) {
  347.             if (in_array($site->getId(), $sites_ids)) {
  348.                 if ($site->getHasAtelier() != 0)
  349.                     $has_atelier = 1;
  350.             }
  351.         }
  353.         $html = $this->twig->render('sites/select_site.html.twig', [
  354.             'sites' => $sites,
  355.             'sites_ids' => $sites_ids,
  356.             'current_site_id' => $current_site_id,
  357.             'current_site_atelier' => $has_atelier,
  358.             'id_client_interne' => $id_client_interne
  359.         ]);
  361.         return $html;
  362.     }
  367.     public function FormattedDuration($duree_minute, $displayDays = true)
  368.     {
  369.         if ($duree_minute && $duree_minute !== "" && $duree_minute != 0) {
  370.             $nb_heure = 0;
  371.             $jours = 0;
  372.             $signe_negative = "";
  375.             if ($duree_minute < 0) {
  376.                 $duree_minute = -$duree_minute;
  377.                 $signe_negative = "-";
  378.             }
  381.             if ($duree_minute >= 60) {
  382.                 $nb_heure = (int) ($duree_minute / 60);
  383.                 $duree_minute = $duree_minute % 60;
  384.             }
  386.             if ($displayDays) {
  387.                 $jours = (int) ($nb_heure / 24);
  388.                 $nb_heure = $nb_heure % 24;
  389.             }
  393.             if ($nb_heure == 0)
  394.                 $nb_heure = '00';
  396.             if ($nb_heure < 10 && $nb_heure > 0)
  397.                 $nb_heure = '0' . strval($nb_heure);
  399.             $duree_minute = round($duree_minute, 0);
  401.             if ($duree_minute < 10)
  402.                 $duree_minute = '0' . strval($duree_minute);
  404.             if ($displayDays && $jours > 0)
  405.                 return $signe_negative . ' ' . $jours . ' j ' . $nb_heure . ' h ' . $duree_minute . ' min';
  406.             else
  407.                 return $signe_negative . ' ' . $nb_heure . ' h ' . $duree_minute . ' min';
  408.         }
  410.         return '00:00';
  411.     }
  417.     public function get_indicateurs()
  418.     {
  419.         $request = $this->requestStack->getCurrentRequest();
  420.         $cookies = $request->cookies;
  422.         if ($cookies->has('indicateurs')) {
  423.             $data = unserialize($cookies->get('indicateurs'), ["allowed_classes" => false]);
  424.         } else {
  425.             $user = $this->tokenStorage->getToken()->getUser();
  426.             $nb_interventions_non_facture = 0;
  427.             $nb_interventions_a_venir = 0;
  428.             $nb_expired_licence = 0;
  429.             $nb_ticket_reseau = 0;
  430.             $nb_mes_ticket_reseau = 0;
  431.             $nb_tickets = 0;
  433.             if ($user != "anon.") {
  434.                 $id = $user->getID();
  436.                 if (array_search("ROLE_admin", $user->getRoles()) !== false) {
  437.                     $nb_interventions_non_facture = $this->getNbInterventionsNonFacture();
  438.                     $nb_mes_interventions_non_facture = $this->getNbInterventionsNonFacture($id);
  439.                     $nb_ticket_reseau = $this->getNbTicketsReseau();
  440.                     $nb_mes_ticket_reseau = $this->getNbTicketsReseau($id);
  441.                     $nb_interventions_a_venir = $this->getNbInterventionsAVenir();
  442.                     $nb_mes_interventions_a_venir = $this->getNbInterventionsAVenir($id);
  443.                     $nb_expired_licence = $this->getNbExpiredLicence();
  444.                     $resultNbTickets = $this->getNbticketNonTermineEtBloque();
  445.                     $resultNbTickets_atelier = $this->getNbticketAtelierNonTermineEtBloque();
  446.                 } else {
  447.                     $nb_mes_interventions_non_facture = $this->getNbInterventionsNonFacture($id);
  448.                     $nb_mes_ticket_reseau = $this->getNbTicketsReseau($id);
  449.                     $nb_mes_interventions_a_venir = $this->getNbInterventionsAVenir($id);
  450.                     $nb_expired_licence = $this->getNbExpiredLicence($id);
  451.                     $resultNbTickets = $this->getNbticketNonTermineEtBloque($id);
  452.                     $resultNbTickets_atelier = $this->getNbticketAtelierNonTermineEtBloque($id);
  453.                 }
  454.             }
  456.             $nb_tickets = $nb_ticket_reseau + $resultNbTickets['nb_tickets_non_termine'];
  458.             $data = array(
  459.                 'nb_interventions_non_facture' => $nb_interventions_non_facture,
  460.                 'nb_mes_interventions_non_facture' => $nb_mes_interventions_non_facture,
  461.                 'nb_interventions_a_venir' => $nb_interventions_a_venir,
  462.                 'nb_mes_interventions_a_venir' => $nb_mes_interventions_a_venir,
  463.                 'nb_expired_licence' => $nb_expired_licence,
  464.                 'nb_tickets_non_termine' => $resultNbTickets_atelier['nb_tickets_non_termine'],
  465.                 'nb_tickets_bloque' => $resultNbTickets_atelier['nb_tickets_bloque'],
  466.                 'nb_mes_ticket_reseau' => $nb_mes_ticket_reseau,
  467.                 'nb_ticket_reseau' => $nb_ticket_reseau,
  468.                 'nb_tickets' => $nb_tickets
  469.             );
  471.             $response = new Response();
  472.             $cookie = new Cookie('indicateurs', serialize($data), time() + (365 * 24 * 60 * 60), '/', null, false, false);
  473.             $response->headers->setCookie($cookie);
  474.             $response->sendHeaders();
  475.         }
  477.         $html = $this->twig->render('user_indicateurs.html.twig', $data);
  479.         if ($request->get("is_ajax_call"))
  480.             return new Response($html);
  482.         return $html;
  483.     }
  488.     public function getNbInterventionsNonFacture($id = null)
  489.     {
  490.         $sql = "
  491.             SELECT count(distinct(i.id)) as nb_interventions 
  492.             FROM interventions as i
  493.             INNER JOIN intervention_affected_users as u ON  i.id = u.intervention_id
  494.             WHERE i.facture= 'a_facturer' AND i.deleted is null    
  495.         ";
  497.         if ($id)
  498.             $sql .= " AND u.user_id = '" . addslashes($id) . "'";
  500.         $request = $this->em->getConnection()->prepare($sql);
  501.         $request->execute();
  502.         $result = $request->fetchAll();
  504.         return $result[0]["nb_interventions"];
  505.     }
  510.     public function getNbTicketsReseau($id = null)
  511.     {
  512.         $sql = "
  513.             SELECT count(*) as nb_ticket_reseau 
  514.             FROM ticket_reseaux 
  515.             WHERE statut BETWEEN 2 and 3
  516.             and deleted IS NULL
  517.             and archived IS NULL
  518.         ";
  520.         if ($id)
  521.             $sql .= "  AND user_ticket_affected_id='" . addslashes($id) . "'";
  523.         $request = $this->em->getConnection()->prepare($sql);
  524.         $request->execute();
  525.         $result = $request->fetchAll();
  527.         return $result[0]["nb_ticket_reseau"];
  528.     }
  533.     public function getNbInterventionsAVenir($id = null)
  534.     {
  535.         $now = strtotime(date("Y-m-d H:i:s"));
  536.         $date_60 = date("Y-m-d H:i:s", strtotime('+ 60 day', $now));
  538.         $sql = "
  539.             SELECT count(distinct(i.id)) as interventions_a_venir 
  540.             FROM `interventions` as i 
  541.         ";
  543.         if ($id) {
  544.             $sql .= "
  545.                 INNER JOIN intervention_affected_users as u ON  i.id = u.intervention_id             
  546.                 WHERE i.date > '" . addslashes($now) . "' AND i.deleted is null AND u.user_id = '" . addslashes($id) . "'
  547.             ";
  548.         } else {
  549.             $sql .= " WHERE i.date > '" . addslashes($now) . "' AND i.deleted is null";
  550.         }
  552.         $request = $this->em->getConnection()->prepare($sql);
  553.         $request->execute();
  554.         $result = $request->fetchAll();
  556.         return $result[0]["interventions_a_venir"];
  557.     }
  562.     public function getNbExpiredLicence($id = null)
  563.     {
  564.         $now = strtotime(date("Y-m-d H:i:s"));
  565.         $date_60 = date("Y-m-d H:i:s", strtotime('+ 60 day', $now));
  567.         $sql = '
  568.             SELECT count(*) as expired_licence
  569.             FROM `assignedlicence` 
  570.             WHERE date < "' . addslashes($date_60) . '" and archived IS NULL  and deleted IS NULL    
  571.         ';
  573.         if ($id)
  574.             $sql .= ' AND user_id = "' . addslashes($id) . '"';
  576.         $request = $this->em->getConnection()->prepare($sql);
  577.         $request->execute();
  578.         $result = $request->fetchAll();
  580.         return $result[0]["expired_licence"];
  581.     }
  586.     public function getNbticketNonTermineEtBloque($id = null)
  587.     {
  588.         $nb_tickets_non_termine = 0;
  589.         $nb_tickets_bloque = 0;
  591.         $conditions = array(
  592.             'archived' => null,
  593.             'deleted' => null,
  594.             'statut' => 5
  595.         );
  597.         if ($id)
  598.             $conditions['user_ticket_affected'] = $id;
  600.         $tickets = $this->em->getRepository(TicketReseaux::class)->findBy($conditions);
  602.         foreach ($tickets as $ticket) {
  603.             $duree = $ticket->getDuree();
  604.             $nb_tickets_non_termine++;
  606.             if ($duree == 1)
  607.                 $nb_tickets_bloque++;
  608.         }
  610.         return array(
  611.             'nb_tickets_non_termine' => $nb_tickets_non_termine,
  612.             'nb_tickets_bloque' => $nb_tickets_bloque
  613.         );
  614.     }
  619.     public function getNbticketAtelierNonTermineEtBloque($id = null)
  620.     {
  621.         $nb_tickets_non_termine = 0;
  622.         $nb_tickets_bloque = 0;
  624.         $conditions = array(
  625.             'archived' => null,
  626.             'deleted' => null,
  627.             'etat' => array(1, 2, 3)
  628.         );
  630.         if ($id)
  631.             $conditions['user'] = $id;
  633.         $tickets = $this->em->getRepository(Tikets::class)->findBy($conditions);
  635.         foreach ($tickets as $ticket) {
  636.             $duree = $ticket->getEtat();
  637.             $site = $ticket->getSite()->getId();
  638.             $nb_tickets_non_termine++;
  640.             if ($duree == 1 and $site == 2)
  641.                 $nb_tickets_bloque++;
  642.         }
  644.         return array(
  645.             'nb_tickets_non_termine' => $nb_tickets_non_termine,
  646.             'nb_tickets_bloque' => $nb_tickets_bloque
  647.         );
  648.     }
  650.     public function getNumber($string)
  651.     {
  652.         $number = preg_replace("/[^0-9.]/", "", $string);
  653.         return $number;
  654.     }
  658.     public function sendSms($telephone, $msg)
  659.     {
  660.         //format numero de tel
  661.         $telephone = str_replace(" ", "", $telephone);
  663.         if (strlen($telephone) == 10)
  664.             $telephone = substr($telephone, 1, 9);
  666.         $telephone = "+33" . $telephone;
  668.         /******SMS****/
  669.         $endpoint = $this->container->getParameter('ovh_sms_endpoint');
  670.         $applicationKey = $this->container->getParameter('ovh_sms_applicationKey');
  671.         $applicationSecret = $this->container->getParameter('ovh_sms_applicationSecret');
  672.         $consumer_key = $this->container->getParameter('ovh_sms_consumer_key');
  673.         $fixedMessage = substr($msg, 0, 140);
  675.         try {
  676.             $conn = new Api($applicationKey, $applicationSecret, $endpoint, $consumer_key);
  678.             $smsServices = $conn->get('/sms/');
  680.             $content = (object) array(
  681.                 "charset" => "UTF-8",
  682.                 "class" => "phoneDisplay",
  683.                 "coding" => "7bit",
  684.                 "message" => $fixedMessage,
  685.                 "noStopClause" => false,
  686.                 "priority" => "high",
  687.                 "receivers" => [$telephone],
  688.                 "senderForResponse" => true,
  689.                 "validityPeriod" => 2880
  690.             );
  693.             $resultPostJob = $conn->post('/sms/' . $smsServices[0] . '/jobs', $content);
  694.             $result = $conn->get('/sms/' . $smsServices[0] . '/jobs');
  695.             if (count($resultPostJob["validReceivers"]) < 1) {
  696.                 $return_msg = "SMS non envoyé : Format incorrect ou numéro non activé.";
  697.             } else {
  698.                 $return_msg = "valide";
  699.             }
  702.         } catch (\Exception $e) {
  703.             $return_msg = $e->getMessage();
  704.         }
  706.         return $return_msg;
  707.     }
  713.     public function get_extension_file($path)
  714.     {
  715.         $ext = pathinfo($path, PATHINFO_EXTENSION);
  717.         if ($ext == "jpg")
  718.             $ext = "jpeg";
  720.         return $ext;
  721.     }
  726.     public function get_name_file($path)
  727.     {
  728.         return pathinfo($path, PATHINFO_FILENAME);
  729.     }
  734.     public function decode_img_base64($img, $ext = null)
  735.     {
  736.         return base64_decode(preg_replace('#^data:image/\w+;base64,#i', '', $img));
  738.     }
  743.     public function decode_PDF_base64($img)
  744.     {
  745.         $img = str_replace('data:application/pdf;base64,', '', $img);
  746.         $img = str_replace(' ', '+', $img);
  748.         return base64_decode($img);
  749.     }
  754.     function get_mb($size)
  755.     {
  756.         return sprintf("%4.2f", $size / 1048576);
  757.     }
  759.     function generateSlug($text)
  760.     {
  761.         $text = preg_replace('~[^\pL\d]+~u', '-', $text);
  762.         $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
  763.         $text = preg_replace('~[^-\w]+~', '', $text);
  764.         $text = trim($text, '-');
  765.         $text = strtolower($text);
  766.         if (empty($text)) {
  767.             return 'n-a';
  768.         }
  769.         return $text;
  770.     }
  772.     public function upload_image($image_data = null, $file = null, $use_file_extenstion = false, $update_file = false, $frais_projet = null, $extension = null, $projet_id = null)
  773.     {
  774.         $image_ext = explode(",", $this->container->getParameter('extension_accepte'));
  776.         $request = $this->requestStack->getCurrentRequest();
  777.         $host = "https://" . $request->server->get('HTTP_HOST');
  778.         $base = (!empty($request->server->get('BASE'))) ? $request->server->get('BASE') : '';
  779.         $base_url = $host . $base;
  781.         $server_path = $request->server->get('DOCUMENT_ROOT') . $request->getBasePath();
  783.         if ($extension == null)
  784.             $extension = "png";
  786.         $originalFileName = "";
  788.         if ($file and $update_file == false) {
  789.             $extension = pathinfo($file->getClientOriginalName(), PATHINFO_EXTENSION);
  790.         }
  792.         if ($update_file == true)
  793.             $extension = $this->get_extension_file($file->getClientOriginalName());
  796.         if (in_array(strtoupper($extension), $image_ext) || $use_file_extenstion || $update_file) {
  797.             $location = $server_path . "/uploads/" . date("Y") . '/';
  798.             if (!file_exists($location))
  799.                 mkdir($location, 0777);
  801.             $location .= date("m") . '/';
  802.             if (!file_exists($location))
  803.                 mkdir($location, 0777);
  805.             $location .= date("d") . '/';
  806.             if (!file_exists($location))
  807.                 mkdir($location, 0777);
  809.             $slug = $image_data ? uniqid() . $extension : $this->generateSlug(pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME));
  810.             $num = 0;
  811.             $filename = $slug . '.' . $extension;
  813.             while (file_exists($location . '/' . $filename)) {
  814.                 $num++;
  815.                 $filename = $slug . '-' . $num . '.' . $extension;
  816.             }
  818.             if ($file) {
  819.                 $file->move($location, $filename);
  820.                 $originalFileName = $file->getClientOriginalName();
  821.             }
  823.             $location .= $filename;
  824.             if ($image_data)
  825.                 file_put_contents($location, $image_data);
  827.             $location = str_replace($server_path, $base_url, $location);
  828.             $path = "/uploads/" . date("Y") . '/' . date("m") . '/' . date("d") . '/' . $filename;
  830.             if (!$request->hasSession())
  831.                 $request->setSession(new Session());
  833.             if ($frais_projet[0] == true and $frais_projet[1] == false) {
  834.                 if ($originalFileName == "" && $num != null)
  835.                     $originalFileName = $num;
  837.                 if ($projet_id == true)
  838.                     $this->set_session_img_upload('ImagesUploaded', $originalFileName, $path, $request);
  840.                 return $path;
  841.             }
  843.             if ($frais_projet[0] == true and $frais_projet[1] == true) {
  844.                 $response = [];
  845.                 $path = "/uploads/" . date("Y") . '/' . date("m") . '/' . date("d") . '/' . $filename;
  846.                 if ($originalFileName == "" && $num != null)
  847.                     $originalFileName = $num;
  849.                 $response[] = $this->twig->render('document/document_liste.html.twig', ['id' => $num, 'path' => $path]);
  851.                 $response[] = $path;
  853.                 $this->set_session_img_upload('ImagesUploaded_frais', $originalFileName, $path, $request);
  854.                 return $response;
  855.             }
  857.             array_pop($image_ext);
  859.             $add_to_session = false;
  861.             if ($use_file_extenstion) {
  862.                 $add_to_session = true;
  863.                 $response = $this->twig->render('document/file_container.html.twig', ['id' => $num, 'path' => $path, 'isImage' => in_array(strtoupper($extension), $image_ext), 'filename' => $originalFileName]);
  864.             } elseif ($update_file) {
  865.                 $response = ["path" => $path, "isImage" => in_array(strtoupper($extension), $image_ext), 'filename' => $originalFileName];
  866.             } else {
  867.                 $add_to_session = true;
  868.                 $response = $this->twig->render('document/document_liste.html.twig', ['id' => $num, 'path' => $path]);
  869.             }
  871.             if ($add_to_session)
  872.                 $this->set_session_img_upload('ImagesUploaded', $originalFileName, $path, $request);
  873.             return $response;
  874.         }
  875.         return false;
  876.     }
  883.     public function getIconFile($extension)
  884.     {
  885.         if (in_array(strtoupper($extension), $this->image_extensions))
  886.             return "image";
  887.         else
  888.             return "pe-7s-file";
  891.         if ($extension == "pdf")
  892.             return 'fa-file-pdf';
  893.         else if ($extension == "docx")
  894.             return 'fa-file-word';
  895.         else if ($extension == "pptx")
  896.             return 'fa-file-powerpoint';
  897.         else if ($extension == "mkv")
  898.             return 'fa-file-video';
  899.         else if ($extension == "zip")
  900.             return 'fa-file-archive';
  901.     }
  907.     public function set_session_img_upload($session_name, $file_name, $path, $request)
  908.     {
  909.         $session = $request->getSession();
  910.         $images = $session->get($session_name, []);
  911.         $images[$file_name] = $path;
  912.         $session->set($session_name, $images);
  913.     }
  918.     public function generate_pdf($html, $vars = array(), $filename = 'download.pdf', $path, $size = 'A4')
  919.     {
  920.         // Run wkhtmltopdf
  922.         $descriptorspec = array(
  923.             0 => array('pipe', 'r'), // stdin
  924.             1 => array('pipe', 'w'), // stdout
  925.             2 => array('pipe', 'w'), // stderr
  926.         );
  928.         $process = proc_open('wkhtmltopdf -q -d 72 --page-size ' . $size . ' --encoding UTF-8 -T 0mm -B 0mm -L 0mm -R 0mm -O landscape - -', $descriptorspec, $pipes);
  930.         // Send the HTML on stdin
  931.         fwrite($pipes[0], $html);
  932.         fclose($pipes[0]);
  934.         // Read the outputs
  935.         $pdf = stream_get_contents($pipes[1]);
  936.         $errors = stream_get_contents($pipes[2]);
  938.         // Close the process
  939.         fclose($pipes[1]);
  940.         $return_value = proc_close($process);
  942.         // Output the results
  943.         if ($errors) {
  944.             throw new Exception('PDF generation failed: ' . $errors);
  945.         } else {
  946.             file_put_contents($path . $filename, $pdf);
  948.             return $pdf;
  949.         }
  950.     }
  955.     public function removeSpecialCaracters($str)
  956.     {
  957.         $search = array('À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'Ç', 'È', 'É', 'Ê', 'Ë', 'Ì', 'Í', 'Î', 'Ï', 'Ò', 'Ó', 'Ô', 'Õ', 'Ö', 'Ù', 'Ú', 'Û', 'Ü', 'Ý', 'à', 'á', 'â', 'ã', 'ä', 'å', 'ç', 'è', 'é', 'ê', 'ë', 'ì', 'í', 'î', 'ï', 'ð', 'ò', 'ó', 'ô', 'õ', 'ö', 'ù', 'ú', 'û', 'ü', 'ý', 'ÿ');
  958.         $replace = array('A', 'A', 'A', 'A', 'A', 'A', 'C', 'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', 'O', 'O', 'O', 'O', 'O', 'U', 'U', 'U', 'U', 'Y', 'a', 'a', 'a', 'a', 'a', 'a', 'c', 'e', 'e', 'e', 'e', 'i', 'i', 'i', 'i', 'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'y', 'y');
  960.         return str_replace($search, $replace, $str);
  961.     }
  966.     public function resetCookieIndicateur()
  967.     {
  968.         $cookies = $this->requestStack->getCurrentRequest()->cookies;
  970.         if ($cookies->has('indicateurs')) {
  971.             $response = new Response();
  972.             $response->headers->clearCookie('indicateurs', '/', null);
  973.             $response->sendHeaders();
  974.         }
  975.     }
  981.     public function getDefaultView($matriceVue)
  982.     {
  983.         $defaultView = array();
  985.         foreach ($matriceVue as $key => $value) {
  986.             $defaultView[$key] = $value["default"];
  987.         }
  988.         ;
  990.         return ($defaultView);
  991.     }
  997.     public function getWidths()
  998.     {
  999.         $widthsColumnsView = array();
  1001.         foreach ($this->widthsAndDefaultView as $key => $value) {
  1002.             $widthsColumnsView[$key] = $value["width"];
  1003.         }
  1004.         ;
  1006.         return ($widthsColumnsView);
  1007.     }
  1014.     public function getTotalInterventionProjet($project_id, $update = false)
  1015.     {
  1017.         $project = $this->em->getRepository(Projects::class)->find($project_id);
  1018.         $interventions = $this->em->getRepository(Interventions::class)->projectInterventionByProjectAndIntervenantPlanifer($project_id);
  1019.         $duree_total = 0;
  1021.         foreach ($interventions as $intervention) {
  1022.             $difference = $intervention->GetDureeIntervention();
  1023.             $duree = 0;
  1025.             if ($difference) {
  1027.                 $duree = ($difference->d * 24 * 60) + ($difference->h * 60) + $difference->i;
  1028.                 $users = $this->em->getRepository(InterventionAffectedUsers::class)->getInterveneatnCount($intervention->getId()) ?? 0;
  1029.                 $duree *= $users;
  1030.                 $duree_total += $duree;
  1031.             }
  1032.         }
  1034.         $result = $this->FormattedDuration($duree_total);
  1036.         if ($update) {
  1037.             $project->setNbHeurePlanifier($duree_total);
  1038.             $this->em->persist($project);
  1039.             $this->em->flush();
  1041.             return;
  1042.         }
  1044.         return $result;
  1045.     }
  1051.     public function getProjectIntervenantsInterventions($project_id, $date = null, $date_fin = null, $orderByDate = false, $without_date_limit = false)
  1052.     {
  1053.         $project = $this->em->getRepository(Projects::class)->find($project_id);
  1055.         $projectUsers = $this->em->getRepository(ProjectUsers::class)->findBy(["project" => $project_id, "type" => ["intervenant", "jointeur"]]);
  1056.         $interventions = array();
  1057.         $users = array();
  1059.         if ($date and is_null($date_fin)) {
  1060.             $start_date = $end_date = $date->format("Y-m-d");
  1061.             $date_debut = new \DateTime($date->format("Y-m-d"));
  1062.             $date_fin = $date->add(new \DateInterval('P1D'));
  1063.         } else {
  1064.             if ($date and $date_fin) {
  1065.                 $date_debut = $date;
  1066.             } else {
  1067.                 $date_debut = clone $project->getDateDebut();
  1068.                 $date_fin = clone $project->getDateFin();
  1069.             }
  1071.             $start_date = $date_debut->format("Y-m-d");
  1072.             $end_date = $date_fin->format("Y-m-d");
  1073.             $date_fin = $date_fin->modify('+1 day');
  1074.         }
  1076.         $days = new \DatePeriod($date_debut, new \DateInterval('P1D'), $date_fin);
  1078.         foreach ($projectUsers as $element) {
  1079.             $user = $element->getUser();
  1080.             $user_object = array();
  1081.             $user_object["label"] = $this->getPrefixUser($user) . $user->getNom() . ' ' . $user->getPrenom();
  1082.             $user_object["id"] = $user->getId();
  1083.             $user_object["path"] = "";
  1085.             array_push($users, $user_object);
  1087.             $filters = [
  1088.                 'users' => [$user->getId()],
  1089.                 'projects' => [$project_id]
  1090.             ];
  1092.             if (!$without_date_limit) {
  1093.                 $filters['start_date'] = $start_date;
  1094.                 $filters['end_date'] = $end_date;
  1095.             }
  1097.             $user_interventions = $this->InterventionsRepository->getInterventionsByFilters($filters, $orderByDate);
  1099.             if ($without_date_limit) {
  1100.                 foreach ($user_interventions as $key => $intervention) {
  1101.                     $interventions[$user->getId()][] = $intervention;
  1102.                 }
  1103.             } else {
  1104.                 foreach ($days as $day) {
  1105.                     foreach ($user_interventions as $key => $intervention) {
  1106.                         if ($intervention["date"] == $day)
  1107.                             $interventions[$user->getId()][] = $intervention;
  1108.                     }
  1109.                 }
  1110.             }
  1111.         }
  1113.         return array(
  1114.             "users" => $users,
  1115.             "interventions" => $interventions,
  1116.         );
  1117.     }
  1122.     function update_user_duree_intervention($action = null, $old_intervention = null, $new_intervention = null, $OldInterventionAffectedUsers = null)
  1123.     {
  1124.         if ($action == "update") {
  1125.             if ($new_intervention) {
  1126.                 $NewInterventionAffectedUsers = $this->em->getRepository(InterventionAffectedUsers::class)->findBy(array('intervention' => $new_intervention->getId()));
  1128.                 foreach ($NewInterventionAffectedUsers as $NewuserAffected) {
  1129.                     $this->set_user_duree($NewuserAffected->getUser());
  1130.                 }
  1131.             }
  1133.             if ($old_intervention) {
  1134.                 $OldInterventionAffectedUsers = $this->em->getRepository(InterventionAffectedUsers::class)->findBy(array('intervention' => $old_intervention->getId()));
  1136.                 foreach ($OldInterventionAffectedUsers as $OlduserAffected) {
  1137.                     $this->set_user_duree($OlduserAffected->getUser());
  1138.                 }
  1139.             }
  1141.             if ($OldInterventionAffectedUsers) {
  1142.                 foreach ($OldInterventionAffectedUsers as $OlduserAffected) {
  1143.                     $this->set_user_duree($OlduserAffected->getUser());
  1144.                 }
  1145.             }
  1146.         }
  1148.         if ($action == "delete") {
  1149.             foreach ($OldInterventionAffectedUsers as $OlduserAffected) {
  1150.                 $this->set_user_duree($OlduserAffected->getUser());
  1151.             }
  1152.         }
  1154.         return new Response("done");
  1155.     }
  1158.     public function getProjectEquipesInterventions($project_id, $date = null, $date_fin = null, $orderByDate = false, $without_date_limit = false)
  1159.     {
  1160.         $project = $this->em->getRepository(Projects::class)->find($project_id);
  1162.         $projectEquipes = $this->em->getRepository(ProjectEquipe::class)->findBy(["project" => $project_id]);
  1163.         $interventions = array();
  1164.         $equipes = array();
  1166.         if ($date and is_null($date_fin)) {
  1167.             $start_date = $end_date = $date->format("Y-m-d");
  1168.             $date_debut = new \DateTime($date->format("Y-m-d"));
  1169.             $date_fin = $date->add(new \DateInterval('P1D'));
  1170.         } else {
  1171.             if ($date and $date_fin) {
  1172.                 $date_debut = $date;
  1173.             } else {
  1174.                 $date_debut = clone $project->getDateDebut();
  1175.                 $date_fin = clone $project->getDateFin();
  1176.             }
  1178.             $start_date = $date_debut->format("Y-m-d");
  1179.             $end_date = $date_fin->format("Y-m-d");
  1180.             $date_fin = $date_fin->modify('+1 day');
  1181.         }
  1183.         $days = new \DatePeriod($date_debut, new \DateInterval('P1D'), $date_fin);
  1185.         foreach ($projectEquipes as $element) {
  1186.             $equipe = $element->getEquipe();
  1188.             $object = array();
  1189.             $object["libelle"] = "Equipe " . $equipe->getLibelle();
  1190.             $object["id"] = $equipe->getId();
  1191.             $object["path"] = "";
  1192.             $equipes_users = $this->em->getRepository(Equipes::class)->findListUsers($equipe->getId());
  1194.             $users_ids = array();
  1196.             foreach ($equipes_users as $equipe_user) {
  1197.                 $users_ids[] = $equipe_user["id"];
  1198.             }
  1200.             $object["users"] = $users_ids;
  1202.             array_push($equipes, $object);
  1204.             $filters = [
  1205.                 'equipes' => [$equipe->getId()],
  1206.                 'projects' => [$project_id]
  1207.             ];
  1209.             if (!$without_date_limit) {
  1210.                 $filters['start_date'] = $start_date;
  1211.                 $filters['end_date'] = $end_date;
  1212.             }
  1214.             $equipe_interventions = $this->InterventionsRepository->getInterventionsByFilters($filters, $orderByDate);
  1216.             if ($without_date_limit) {
  1217.                 foreach ($equipe_interventions as $key => $intervention) {
  1218.                     $interventions[$equipe->getId()][] = $intervention;
  1219.                 }
  1220.             } else {
  1221.                 foreach ($days as $day) {
  1222.                     foreach ($equipe_interventions as $key => $intervention) {
  1223.                         if ($intervention["date"] == $day)
  1224.                             $interventions[$equipe->getId()][] = $intervention;
  1225.                     }
  1226.                 }
  1227.             }
  1228.         }
  1230.         return array(
  1231.             "equipes" => $equipes,
  1232.             "equipes_interventions" => $interventions,
  1233.         );
  1234.     }
  1239.     public function add_notification($id_user, $content, $id_intervention = null)
  1240.     {
  1241.         $user = $this->em->getRepository(User::class)->find($id_user);
  1243.         $notification = new Notifications();
  1245.         if ($id_intervention) {
  1246.             $intervention = $this->em->getRepository(Interventions::class)->find($id_intervention);
  1247.             $notification->setIntervention($intervention);
  1248.         }
  1250.         $notification->setUser($user);
  1251.         $notification->setContent($content);
  1252.         $notification->setDateCreation(new \DateTime());
  1254.         $this->em->persist($notification);
  1255.         $this->em->flush();
  1256.     }
  1263.     public function getNumberNotifications()
  1264.     {
  1265.         $user = $this->tokenStorage->getToken()->getUser();
  1266.         $notifications = $this->em->getRepository(Notifications::class)->findBy(array('user' => $user, 'readed' => null));
  1268.         $count = 0;
  1269.         if ($notifications)
  1270.             $count = count($notifications);
  1272.         return $count;
  1273.     }
  1279.     public function getDureeUntilToday($date)
  1280.     {
  1281.         $dateRecent = new \DateTime($date);
  1282.         $today = new \DateTime('now');
  1283.         $interval = $dateRecent->diff($today);
  1285.         if ($interval->days) {
  1286.             if ($interval->days == 1)
  1287.                 $duree = "un jour";
  1288.             else
  1289.                 $duree = $interval->days . " jours";
  1290.         } elseif ($interval->h) {
  1291.             if ($interval->h == 1)
  1292.                 $duree = "une heure";
  1293.             else
  1294.                 $duree = $interval->h . " heures";
  1295.         } elseif ($interval->i) {
  1296.             if ($interval->i == 1)
  1297.                 $duree = "une minute";
  1298.             else
  1299.                 $duree = $interval->i . " minutes";
  1300.         } else {
  1301.             $duree = "quelques secondes";
  1302.         }
  1304.         return $duree;
  1305.     }
  1313.     public function getEntrepriseHoursFromDate($date, $planification_auto = false)
  1314.     {
  1315.         $entreprise_id = $this->container->getParameter('entreprise_id');
  1316.         $entreprise = $this->em->getRepository(Entreprise::class)->find($entreprise_id);
  1318.         $days = array_keys($this->days);
  1319.         $horaires = $entreprise->getHoraires();
  1321.         $day_num = intval($date->format("N")) - 1;
  1323.         if (!$planification_auto) {
  1324.             $morning_start = self::MORNING_START;
  1325.             $morning_end = self::MORNING_END;
  1326.             $midday_start = self::MIDDAY_START;
  1327.             $midday_end = self::MIDDAY_END;
  1328.         } else {
  1329.             $morning_start = "";
  1330.             $morning_end = "";
  1331.             $midday_start = "";
  1332.             $midday_end = "";
  1333.         }
  1335.         if ($horaires[$days[$day_num]]["matin"]["closed"] == false) {
  1336.             if ($horaires[$days[$day_num]]["matin"]["debut"])
  1337.                 $morning_start = $horaires[$days[$day_num]]["matin"]["debut"];
  1339.             if ($horaires[$days[$day_num]]["matin"]["fin"])
  1340.                 $morning_end = $horaires[$days[$day_num]]["matin"]["fin"];
  1341.         }
  1343.         if ($horaires[$days[$day_num]]["apresMidi"]["closed"] == false) {
  1344.             if ($horaires[$days[$day_num]]["apresMidi"]["debut"])
  1345.                 $midday_start = $horaires[$days[$day_num]]["apresMidi"]["debut"];
  1347.             if ($horaires[$days[$day_num]]["apresMidi"]["fin"])
  1348.                 $midday_end = $horaires[$days[$day_num]]["apresMidi"]["fin"];
  1349.         }
  1351.         return array(
  1352.             'morning_start_hour' => $morning_start,
  1353.             'morning_end_hour' => $morning_end,
  1354.             'midday_start_hour' => $midday_start,
  1355.             'midday_end_hour' => $midday_end
  1356.         );
  1357.     }
  1362.     public function getListInterventions($lists_interventions_intervenants)
  1363.     {
  1364.         if (isset($lists_interventions_intervenants["interventions"]))
  1365.             $interventions = $lists_interventions_intervenants["interventions"];
  1366.         else
  1367.             $interventions = $lists_interventions_intervenants["equipes_interventions"];
  1369.         $interventionsByUser = array_values($interventions);
  1370.         $array_interventions = array();
  1372.         foreach ($interventionsByUser as $interventionByUser) {
  1373.             $array_interventions = array_merge($array_interventions, $interventionByUser);
  1374.         }
  1376.         return $array_interventions;
  1377.     }
  1384.     public function getListIntervenants($lists_interventions_intervenants)
  1385.     {
  1386.         $all_users = $lists_interventions_intervenants["users"];
  1387.         $interventions = $lists_interventions_intervenants["interventions"];
  1388.         $interventions_users = array_keys($interventions);
  1390.         $result = array_filter($all_users, function ($value, $key) use ($interventions_users) {
  1391.             return in_array($value["id"], $interventions_users);
  1392.         }, ARRAY_FILTER_USE_BOTH);
  1394.         return $result;
  1395.     }
  1400.     public function getListEquipes($lists_interventions_intervenants)
  1401.     {
  1402.         $all_equipes = $lists_interventions_intervenants["equipes"];
  1403.         $interventions = $lists_interventions_intervenants["equipes_interventions"];
  1404.         $interventions_equipes = array_keys($interventions);
  1406.         $result = array_filter($all_equipes, function ($value, $key) use ($interventions_equipes) {
  1407.             return in_array($value["id"], $interventions_equipes);
  1408.         }, ARRAY_FILTER_USE_BOTH);
  1410.         return $result;
  1411.     }
  1417.     public function timeToMinute($time)
  1418.     {
  1419.         $start_date = new \DateTime('now');
  1420.         $difference = $start_date->modify("+1 minutes")->diff(new \DateTime('now +' . $time));
  1422.         $duree = ($difference->d * 24 * 60) + ($difference->h * 60) + $difference->i;
  1424.         return $duree;
  1425.     }
  1431.     public function minuteToInputTime($minutes)
  1432.     {
  1433.         $heures = 0;
  1435.         while ($minutes >= 60) {
  1436.             $heures++;
  1437.             $minutes -= 60;
  1438.         }
  1440.         $time = $this->intToStrForTime($heures) . ":" . $this->intToStrForTime($minutes);
  1442.         return $time;
  1443.     }
  1447.     function intToStrForTime($int)
  1448.     {
  1449.         if ($int == 0)
  1450.             return '00';
  1451.         elseif ($int <= 9)
  1452.             return '0' . $int;
  1453.         elseif ($int >= 10)
  1454.             return $int;
  1455.         else
  1456.             return '99';
  1457.     }
  1463.     public function calc_taux_frais($id_projet)
  1464.     {
  1465.         $projet = $this->em->getRepository(Projects::class)->find($id_projet);
  1466.         $projet_frais = $this->em->getRepository(ProjectFrais::class)->findBy(['project' => $projet, 'deleted' => null]);
  1468.         $taux_frais = 0;
  1470.         foreach ($projet_frais as $val) {
  1471.             $taux_frais += $val->getQuantity() * $val->getPrixUnitaire();
  1472.         }
  1474.         return $taux_frais;
  1475.     }
  1483.     public function total_main_oeuvre($id)
  1484.     {
  1485.         $total_main_oeuvre = $this->em->getRepository('App\Entity\ProjectSuiviTravaux')->getTotalMainOeuvre($id);
  1487.         return $total_main_oeuvre ?? 0;
  1488.     }
  1495.     public function restant_facture_regler($id = null)
  1496.     {
  1497.         $request = $this->requestStack->getCurrentRequest();
  1499.         if ($request->get("id_projet"))
  1500.             $id = $request->get("id_projet");
  1502.         if (!$request->get("devis")) {
  1503.             ;
  1504.             $projet = $this->em->getRepository(Projects::class)->find($id);
  1505.             $devis = $projet->getDevis();
  1506.         } else {
  1507.             $devis = floatval($request->get("devis"));
  1508.         }
  1510.         $projet_facturation = $this->em->getRepository(ProjectFacturation::class)->findBy(["project" => $id]);
  1512.         $facture = 0;
  1513.         $regler = 0;
  1515.         foreach ($projet_facturation as $val) {
  1516.             $facture += $val->getMontantFacture();
  1517.             $regler += $val->getMontantRegle();
  1518.         }
  1519.         ;
  1521.         if ($request->get("id_projet"))
  1522.             return new Response(json_encode(["facture" => $facture, "regler" => $regler]));
  1523.         else
  1524.             return [$facture, $regler];
  1525.     }
  1532.     private function setJointeurItem(&$item)
  1533.     {
  1534.         if (array_key_exists("user_id", $item) && array_key_exists("project_id", $item)) {
  1535.             $project_user = $this->em->getRepository(ProjectUsers::class)->findOneBy(["project" => $item["project_id"], "user" => $item["user_id"], "type" => "jointeur"]);
  1537.             if ($project_user)
  1538.                 $item["dotted_border"] = true;
  1539.         }
  1540.     }
  1544.     private function getItemForWeekType($old_date, $intervention_date, $week_start, $week_end, $item, $items, $client_name, $is_last_intervention, $get_clients)
  1545.     {
  1547.         $next_date = clone $old_date;
  1548.         $next_date->add(new \DateInterval("P7D"));
  1549.         $intervention_date_str = $intervention_date->format("Y-m-d");
  1551.         $is_in_same_or_next_week = $intervention_date_str >= substr($item['start_date'], 0, 10) && ($intervention_date_str <= $week_end->format("Y-m-d") || $intervention_date_str <= $next_date->format("Y-m-d"));
  1553.         if ($is_last_intervention) {
  1554.             if ($is_in_same_or_next_week) {
  1555.                 if ($get_clients && !in_array($client_name, $item['clients']))
  1556.                     $item['clients'][] = $client_name;
  1558.                 $item['end_date'] = $old_date->format('Y-m-d') . " 23:59:00";
  1560.                 if ($intervention_date_str > $week_end->format('Y-m-d'))
  1561.                     $item['end_date'] = $next_date->format('Y-m-d') . " 23:59:00";
  1562.             } else {
  1563.                 $item['end_date'] = $old_date->format('Y-m-d') . " 23:59:00";
  1564.                 $this->setJointeurItem($item);
  1565.                 $items[] = $item;
  1567.                 $week_dates = $this->getWeekStartAndEndDate($intervention_date);
  1568.                 $week_start = $week_dates['week_start'];
  1569.                 $week_end = $week_dates['week_end'];
  1571.                 $item['start_date'] = $week_start->format('Y-m-d 00:00:00');
  1572.                 $item['end_date'] = $week_end->format('Y-m-d') . " 23:59:00";
  1574.                 if ($get_clients)
  1575.                     $item['clients'] = [$client_name];
  1576.             }
  1578.             $this->setJointeurItem($item);
  1579.             $items[] = $item;
  1580.         } else {
  1581.             if ($is_in_same_or_next_week) {
  1582.                 if ($get_clients && !in_array($client_name, $item['clients']))
  1583.                     $item['clients'][] = $client_name;
  1585.                 if ($intervention_date_str > $week_end->format('Y-m-d'))
  1586.                     $old_date = $next_date;
  1587.             } else {
  1588.                 $item['end_date'] = $old_date->format('Y-m-d') . " 23:59:00";
  1589.                 $this->setJointeurItem($item);
  1590.                 $items[] = $item;
  1592.                 if ($get_clients)
  1593.                     $item['clients'] = [$client_name];
  1595.                 $week_dates = $this->getWeekStartAndEndDate($intervention_date);
  1596.                 $week_start = $week_dates['week_start'];
  1598.                 $item['start_date'] = $week_start->format('Y-m-d 00:00:00');
  1599.                 $old_date = $week_end = $week_dates['week_end'];
  1600.             }
  1601.         }
  1603.         return array(
  1604.             'item' => $item,
  1605.             'items' => $items,
  1606.             'old_date' => $old_date,
  1607.             'week_start' => $old_date,
  1608.             'week_end' => $old_date,
  1609.         );
  1610.     }
  1615.     public function getClientForDate($start, $end = null, $user_id = null, $equipe_id = null)
  1616.     {
  1617.         $clients_ids = [];
  1618.         $clients_name = [];
  1619.         $end = $end ?? $start;
  1621.         $filters = [
  1622.             "start_date" => $start,
  1623.             "end_date" => $end,
  1624.         ];
  1626.         if ($user_id)
  1627.             $filters["users"] = [$user_id];
  1628.         else
  1629.             $filters["equipes"] = [$equipe_id];
  1631.         $clients = $this->em->getRepository(Interventions::class)->getInterventionsByFilters($filters, false, false, false, false, false, true);
  1634.         return array_column($clients, 'client');
  1635.     }
  1637.     public function getItemForDayType($old_date, $intervention_date, $old_end_hour, $item_end_hour, $item, $items, $client_name, $is_last_intervention, $get_clients, $graphic_view_colors, $object_key, $cookie_updated)
  1638.     {
  1640.         $next_date = clone $old_date;
  1641.         $next_date->add(new \DateInterval("P1D"));
  1642.         $is_same_client = false;
  1644.         if ($intervention_date->format("Y-m-d") == $next_date->format("Y-m-d")) {
  1645.             if (isset($item["user_id"])) {
  1646.                 $old_client = $this->getClientForDate($old_date->format("d-m-Y"), null, $item["user_id"]);
  1647.                 $new_client = $this->getClientForDate($next_date->format("d-m-Y"), null, $item["user_id"]);
  1648.                 $is_same_client = empty(array_diff($old_client, $new_client)) && empty(array_diff($new_client, $old_client));
  1651.             }
  1652.             if (isset($item["equipe_id"])) {
  1653.                 $old_client = $this->getClientForDate($old_date->format("d-m-Y"), null, null, $item["equipe_id"]);
  1654.                 $new_client = $this->getClientForDate($next_date->format("d-m-Y"), null, null, $item["equipe_id"]);
  1655.                 $is_same_client = empty(array_diff($old_client, $new_client)) && empty(array_diff($new_client, $old_client));
  1656.             }
  1657.         }
  1659.         if ($is_last_intervention) {
  1660.             if ($intervention_date->format("Y-m-d") == $old_date->format("Y-m-d") || (($intervention_date->format("Y-m-d") == $next_date->format("Y-m-d")) && $is_same_client)) {
  1661.                 if ($get_clients && !in_array($client_name, $item['clients']))
  1662.                     $item['clients'][] = $client_name;
  1664.                 $item['end_date'] = $intervention_date->format('Y-m-d') . " 23:59:00";
  1665.             } else {
  1666.                 $item['end_date'] = $old_date->format('Y-m-d') . " 23:59:00";
  1667.                 $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  1668.                 $items[] = $item;
  1670.                 $item['start_date'] = $intervention_date->format('Y-m-d H:i:s');
  1671.                 $item['end_date'] = $intervention_date->format('Y-m-d') . " 23:59:00";
  1673.                 if ($get_clients)
  1674.                     $item['clients'] = [$client_name];
  1675.             }
  1676.             $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  1677.             $items[] = $item;
  1678.         } else {
  1679.             if ($intervention_date->format("Y-m-d") == $old_date->format("Y-m-d") || (($intervention_date->format("Y-m-d") == $next_date->format("Y-m-d")) && $is_same_client)) {
  1680.                 if ($get_clients && !in_array($client_name, $item['clients']))
  1681.                     $item['clients'][] = $client_name;
  1683.                 $old_date = $intervention_date;
  1684.                 $old_end_hour = $item_end_hour;
  1685.             } else {
  1686.                 $item['end_date'] = $old_date->format('Y-m-d') . " 23:59:00";
  1688.                 $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  1689.                 $items[] = $item;
  1691.                 if ($get_clients)
  1692.                     $item['clients'] = [$client_name];
  1694.                 $item['start_date'] = $intervention_date->format('Y-m-d H:i:s');
  1695.                 $old_date = $intervention_date;
  1696.             }
  1697.         }
  1699.         return array(
  1700.             'item' => $item,
  1701.             'items' => $items,
  1702.             'old_date' => $old_date,
  1703.             'old_end_hour' => $old_end_hour,
  1704.         );
  1705.     }
  1707.     public function addClinetColor(&$item, $graphic_view_colors, $object_key, $cookie_updated)
  1708.     {
  1709.         $start_dateTime = \DateTime::createFromFormat('Y-m-d H:i:s', $item['start_date']);
  1710.         $end_dateTime = \DateTime::createFromFormat('Y-m-d H:i:s', $item['end_date']);
  1712.         $start = $start_dateTime->format('Y-m-d');
  1713.         $end = $end_dateTime->format('Y-m-d');
  1715.         $client_id = null;
  1717.         if (isset($item["user_id"])) {
  1718.             $client_id = $this->getClientForDate($start, $end, $item["user_id"])[0];
  1719.         }
  1721.         if (isset($item["equipe_id"])) {
  1722.             $client_id = $this->getClientForDate($start, $end, null, $item["equipe_id"])[0];
  1723.         }
  1724.         $color_item = $this->getItemColor($client_id, $graphic_view_colors, $object_key, $cookie_updated)['item_color'];
  1725.         $item['color'] = $color_item;
  1727.         return $item;
  1728.     }
  1732.     private function getItemForHourType($item, $items, $intervention, $isNewItem, $item_start_date, $intervention_date, $old_date, $old_start_hour, $old_end_hour, $client_name, $is_last_intervention, $get_clients, $graphic_view_colors, $object_key, $cookie_updated)
  1733.     {
  1734.         $item_hours = $this->getItemHours($intervention);
  1736.         $item_start_hour = $item_hours['item_start_hour'];
  1737.         $item_end_hour = $item_hours['item_end_hour'];
  1739.         if ($isNewItem || ($item_start_date == $intervention_date->format("Y-m-d") && $item_start_hour < $old_start_hour))
  1740.             $old_start_hour = $item_start_hour;
  1742.         if ($old_end_hour == null)
  1743.             $old_end_hour = $item_end_hour;
  1745.         if ($is_last_intervention) {
  1746.             if ($get_clients)
  1747.                 $items = $this->addLastItemWeekView($intervention_date, $old_date, $item, $items, $item_start_date, $item_start_hour, $item_end_hour, $old_start_hour, $old_end_hour, $client_name, $graphic_view_colors, $object_key, $cookie_updated);
  1748.             else
  1749.                 $items = $this->addLastItemWeekView($intervention_date, $old_date, $item, $items, $item_start_date, $item_start_hour, $item_end_hour, $old_start_hour, $old_end_hour, false, $graphic_view_colors, $object_key, $cookie_updated);
  1750.         } else {
  1751.             $next_date = clone $old_date;
  1752.             $next_date->add(new \DateInterval("P1D"));
  1754.             $isSameDay = $intervention_date->format("Y-m-d") == $old_date->format("Y-m-d");
  1755.             $isNextDay = $intervention_date->format("Y-m-d") == $next_date->format("Y-m-d");
  1756.             $isNextHour = $old_end_hour == "23:59:00" && $item_start_hour == "00:00:00";
  1757.             $is_same_client = false;
  1760.             if (($isNextDay && $isNextHour) || ($isSameDay && ($old_end_hour == "11:59:00" && $item_start_hour == "12:00:00"))) {
  1762.                 $old_time_start = $old_date->format("d-m-Y") . " " . $old_start_hour;
  1763.                 $old_time_end = $old_date->format("d-m-Y") . " " . $old_end_hour;
  1765.                 if ($isNextDay) {
  1766.                     $new_time_start = $next_date->format("d-m-Y") . " " . $item_start_hour;
  1767.                     $new_time_end = $next_date->format("d-m-Y") . " " . $item_end_hour;
  1768.                 } else {
  1769.                     $new_time_start = $old_date->format("d-m-Y") . " " . $item_start_hour;
  1770.                     $new_time_end = $old_date->format("d-m-Y") . " " . $item_end_hour;
  1771.                 }
  1773.                 if (isset($item["user_id"])) {
  1774.                     $old_client = $this->getClientForDate($old_time_start, $old_time_end, $item["user_id"]);
  1775.                     $new_client = $this->getClientForDate($new_time_start, $new_time_end, $item["user_id"]);
  1776.                     $is_same_client = empty(array_diff($old_client, $new_client)) && empty(array_diff($new_client, $old_client));
  1777.                 }
  1778.                 if (isset($item["equipe_id"])) {
  1779.                     $old_client = $this->getClientForDate($old_date->format("d-m-Y"), null, null, $item["equipe_id"]);
  1780.                     $new_client = $this->getClientForDate($next_date->format("d-m-Y"), null, null, $item["equipe_id"]);
  1781.                     $is_same_client = empty(array_diff($old_client, $new_client)) && empty(array_diff($new_client, $old_client));
  1782.                 }
  1783.             }
  1785.             if ($isSameDay || ($isNextDay && $isNextHour && $is_same_client)) {
  1786.                 if ($get_clients && !in_array($client_name, $item['clients']))
  1787.                     $item['clients'][] = $intervention->getClient()->GetLibelleClient();
  1789.                 $old_date = $intervention_date;
  1790.                 $old_end_hour = $item_end_hour;
  1791.             } else {
  1792.                 $item['start_date'] = $item_start_date . ' ' . $old_start_hour;
  1793.                 $item['end_date'] = $old_date->format('Y-m-d') . ' ' . $old_end_hour;
  1795.                 $old_date = $intervention_date;
  1797.                 $item_start_date = $intervention_date->format('Y-m-d');
  1798.                 $old_start_hour = $item_start_hour;
  1799.                 $old_end_hour = $item_end_hour;
  1801.                 $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  1802.                 $items[] = $item;
  1804.                 if ($get_clients)
  1805.                     $item['clients'] = [$client_name];
  1806.             }
  1807.         }
  1809.         return array(
  1810.             'item' => $item,
  1811.             'items' => $items,
  1812.             'old_date' => $old_date,
  1813.             'old_start_hour' => $old_start_hour,
  1814.             'old_end_hour' => $old_end_hour,
  1815.             'item_start_date' => $item_start_date,
  1816.         );
  1817.     }
  1821.     public function getWeekStartAndEndDate($date, $year = null)
  1822.     {
  1823.         $week = $date->format("W");
  1825.         if (!$year)
  1826.             $year = $date->format("Y");
  1828.         $week_start = clone $date;
  1829.         $week_start = $week_start->setISODate($year, $week, 1);
  1831.         if ($week_start > $date)
  1832.             $week_start->setISODate(--$year, $week, 1);
  1834.         $week_end = clone $week_start;
  1835.         $week_end = $week_end->modify("+6 days");
  1837.         return array(
  1838.             'week_start' => $week_start,
  1839.             'week_end' => $week_end
  1840.         );
  1841.     }
  1846.     public function getItemsForUsersAndMateriels($object_id, $object_key, $interventions, $items, $item, $show_type, $cookie_updated, $graphic_view_colors, $projects = null)
  1847.     {
  1848.         $old_date = null;
  1849.         $item_start_date = null;
  1850.         $item_start_hour = null;
  1851.         $item_end_hour = null;
  1852.         $old_start_hour = null;
  1853.         $old_end_hour = null;
  1854.         $get_clients = false;
  1855.         $week_start = null;
  1856.         $week_end = null;
  1858.         foreach ($interventions as $key => $intervention) {
  1859.             if (is_array($intervention))
  1860.                 $intervention_date = $intervention['date'];
  1861.             else {
  1862.                 $intervention_date = $intervention->getDate();
  1863.                 $get_clients = true;
  1864.             }
  1866.             $isNewItem = false;
  1868.             if ($old_date == null) {
  1869.                 if ($item_start_date != null && $show_type == "hour") {
  1870.                     $old_date = new \Datetime($item_start_date);
  1871.                 } else {
  1872.                     $isNewItem = true;
  1873.                     $old_date = $intervention_date;
  1874.                     $item_start_date = $intervention_date->format('Y-m-d');
  1876.                     if ($show_type === "week") {
  1877.                         $week_dates = $this->getWeekStartAndEndDate($intervention_date);
  1878.                         $week_start = $week_dates['week_start'];
  1879.                         $old_date = $week_end = $week_dates['week_end'];
  1880.                         $item['start_date'] = $week_start->format('Y-m-d 00:00:00');
  1881.                     }
  1882.                 }
  1883.                 if ($projects) {
  1884.                     if (array_key_exists("project_id", $item) && array_key_exists($item["project_id"], $projects) && array_key_exists("color", $projects[$item["project_id"]]))
  1885.                         $item['project_color'] = $projects[$item["project_id"]]["color"];
  1886.                     else {
  1887.                         $project_key = array_search($item["project_id"], array_column($projects, 'id'));
  1888.                         $item['project_color'] = $projects[$project_key]["color"];
  1889.                     }
  1890.                 } elseif ($object_id) {
  1891.                     $item_color_result = $this->getItemColor($object_id, $graphic_view_colors, $object_key, $cookie_updated);
  1892.                     $item['color'] = $item_color_result['item_color'];
  1893.                     $cookie_updated = $item_color_result['cookie_updated'];
  1894.                     $graphic_view_colors = $item_color_result['graphic_view_colors'];
  1895.                 }
  1897.                 if ($show_type == "day")
  1898.                     $item['start_date'] = $intervention_date->format('Y-m-d H:i:s');
  1899.             }
  1901.             if ($get_clients && !array_key_exists('clients', $item))
  1902.                 $item['clients'] = [];
  1904.             $client_name = $get_clients ? $intervention->getClient()->GetLibelleClient() : null;
  1906.             $is_last_intervention = $key == (count($interventions) - 1);
  1908.             if ($show_type === "day" || $show_type === "week") {
  1909.                 $items_result = [];
  1911.                 if ($show_type === "day") {
  1912.                     $items_result = $this->getItemForDayType($old_date, $intervention_date, $old_end_hour, $item_end_hour, $item, $items, $client_name, $is_last_intervention, $get_clients, $graphic_view_colors, $object_key, $cookie_updated);
  1913.                     $old_end_hour = $items_result['old_end_hour'];
  1914.                 } else {
  1915.                     $items_result = $this->getItemForWeekType($old_date, $intervention_date, $week_start, $week_end, $item, $items, $client_name, $is_last_intervention, $get_clients);
  1916.                     $week_start = $items_result['week_start'];
  1917.                     $week_end = $items_result['week_end'];
  1918.                 }
  1919.                 $item = $items_result['item'];
  1920.                 $items = $items_result['items'];
  1921.                 $old_date = $items_result['old_date'];
  1924.             } else {
  1925.                 $hour_items_result = $this->getItemForHourType($item, $items, $intervention, $isNewItem, $item_start_date, $intervention_date, $old_date, $old_start_hour, $old_end_hour, $client_name, $is_last_intervention, $get_clients, $graphic_view_colors, $object_key, $cookie_updated);
  1926.                 $item = $hour_items_result['item'];
  1927.                 $items = $hour_items_result['items'];
  1928.                 $old_date = $hour_items_result['old_date'];
  1929.                 $old_start_hour = $hour_items_result['old_start_hour'];
  1930.                 $old_end_hour = $hour_items_result['old_end_hour'];
  1931.                 $item_start_date = $hour_items_result['item_start_date'];
  1933.             }
  1934.         }
  1936.         return array(
  1937.             "items" => $items,
  1938.             "graphic_view_colors" => $graphic_view_colors,
  1939.             "cookie_updated" => $cookie_updated,
  1940.         );
  1941.     }
  1949.     private function getItemHours($intervention)
  1950.     {
  1951.         $date = null;
  1952.         $start_hour = null;
  1953.         $end_hour = null;
  1955.         if (is_array($intervention)) {
  1956.             $date = $intervention['date'];
  1957.             $start_hour = $intervention["heure_debut"];
  1958.             $end_hour = $intervention["heure_fin"];
  1959.         } else {
  1960.             $date = $intervention->getDate();
  1961.             $start_hour = $intervention->getHeureDebut();
  1962.             $end_hour = $intervention->getHeureFin();
  1963.         }
  1965.         $entreprise_horaires = $this->getEntrepriseHoursFromDate($date);
  1966.         $morning_end_hour = $entreprise_horaires["morning_end_hour"];
  1967.         $midday_start_hour = $entreprise_horaires["midday_start_hour"];
  1969.         if ($start_hour < $morning_end_hour)
  1970.             $item_start_hour = '00:00:00';
  1971.         else
  1972.             $item_start_hour = '12:00:00';
  1974.         if ($end_hour > $midday_start_hour)
  1975.             $item_end_hour = '23:59:00';
  1976.         else
  1977.             $item_end_hour = '11:59:00';
  1979.         return array(
  1980.             "item_start_hour" => $item_start_hour,
  1981.             "item_end_hour" => $item_end_hour,
  1982.         );
  1983.     }
  1993.     public function getItemColor($object_id, $graphic_view_colors, $i, $cookie_updated)
  1994.     {
  1995.         $request = $this->requestStack->getCurrentRequest();
  1996.         $cookies = $request->cookies;
  1998.         if (array_key_exists($object_id, $graphic_view_colors)) {
  1999.             $item_color = $graphic_view_colors[$object_id];
  2000.         } else {
  2001.             // $Exsist = false ;
  2002.             // while (!$Exsist) {
  2004.             // $item_color = $this->getRandomColorCode();
  2006.             // if (!in_array( $item_color, array_values($graphic_view_colors)))        $Exsist = true;
  2007.             // }
  2009.             $cookie_updated = true;
  2010.             $item_color = $this->getRandomColorCode();
  2011.             $graphic_view_colors[$object_id] = $item_color;
  2012.         }
  2014.         return array(
  2015.             'item_color' => $item_color,
  2016.             'cookie_updated' => $cookie_updated,
  2017.             'graphic_view_colors' => $graphic_view_colors,
  2018.         );
  2019.     }
  2023.     function getRandomColorCode()
  2024.     {
  2026.         $r = str_pad(dechex(rand(0, 255)), 2, '0', STR_PAD_LEFT);
  2027.         $g = str_pad(dechex(rand(0, 255)), 2, '0', STR_PAD_LEFT);
  2028.         $b = str_pad(dechex(rand(0, 255)), 2, '0', STR_PAD_LEFT);
  2031.         $colorCode = '#' . $r . $g . $b;
  2033.         return $colorCode;
  2034.     }
  2037.     private function addLastItemWeekView($intervention_date, $old_date, $item, $items, $item_start_date, $item_start_hour, $item_end_hour, $old_start_hour, $old_end_hour, $client_name, $graphic_view_colors, $object_key, $cookie_updated)
  2038.     {
  2039.         $next_date = clone $old_date;
  2040.         $next_date->add(new \DateInterval("P1D"));
  2042.         if ($intervention_date->format("Y-m-d") == $old_date->format("Y-m-d") || ($next_date->format("Y-m-d") == $intervention_date->format('Y-m-d') && ($old_end_hour == "23:59:00" && $item_start_hour == "00:00:00"))) {
  2043.             $item['start_date'] = $item_start_date . ' ' . $old_start_hour;
  2044.             $item['end_date'] = $intervention_date->format('Y-m-d') . ' ' . $item_end_hour;
  2046.             if ($client_name && !in_array($client_name, $item['clients']))
  2047.                 $item['clients'][] = $client_name;
  2048.         } else {
  2049.             $item['start_date'] = $item_start_date . ' ' . $old_start_hour;
  2050.             $item['end_date'] = $old_date->format('Y-m-d') . ' ' . $old_end_hour;
  2051.             $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  2052.             $items[] = $item;
  2054.             if ($client_name)
  2055.                 $item['clients'] = [$client_name];
  2057.             $item['start_date'] = $intervention_date->format('Y-m-d') . ' ' . $item_start_hour;
  2058.             $item['end_date'] = $intervention_date->format('Y-m-d') . ' ' . $item_end_hour;
  2059.         }
  2060.         $item = $this->addClinetColor($item, $graphic_view_colors, $object_key, $cookie_updated);
  2061.         $items[] = $item;
  2063.         return $items;
  2064.     }
  2073.     public function pageTypeCookies($page_name, $dataPageType)
  2074.     {
  2075.         $request = $this->requestStack->getCurrentRequest();
  2076.         $session = $request->getSession();
  2078.         $pageTypeValue = $session->get('page-type', []);
  2080.         if (is_array($page_name)) {
  2081.             $pageTypeValue[$page_name[0]] = $dataPageType[0];
  2082.             $pageTypeValue[$page_name[1]] = $dataPageType[1];
  2083.         } else
  2084.             $pageTypeValue[$page_name] = $dataPageType;
  2086.         $session->set('page-type', $pageTypeValue);
  2087.     }
  2094.     public function GetTypeCookies($pageName, $is_intervention = false)
  2095.     {
  2096.         $request = $this->requestStack->getCurrentRequest();
  2097.         $session = $request->getSession();
  2099.         $pageTypeValue = $session->get('page-type', []);
  2101.         if (isset($pageTypeValue[$pageName])) {
  2102.             if ($is_intervention) {
  2103.                 $res = array("path" => $pageTypeValue[$pageName]);
  2105.                 if (array_key_exists("InterventionsType", $pageTypeValue) && $pageTypeValue["InterventionsType"])
  2106.                     $res["type"] = $pageTypeValue["InterventionsType"];
  2108.                 return $res;
  2109.             }
  2111.             return $pageTypeValue[$pageName];
  2112.         } else {
  2113.             return "liste";
  2114.         }
  2115.     }
  2121.     public function checkClientAccess($id_client, UrlGeneratorInterface $urlGenerator = null)
  2122.     {
  2123.         $connectionUrl = $urlGenerator ? $urlGenerator->generate('connexion') : $this->router->generate('connexion');
  2125.         if (!$this->tokenStorage->getToken()) {
  2126.             return new RedirectResponse($connectionUrl);
  2127.         }
  2129.         $user = $this->tokenStorage->getToken()->getUser();
  2131.         if (!$user) {
  2132.             return new RedirectResponse($connectionUrl);
  2133.         }
  2135.         $clientUser = $user->getClient();
  2137.         if ($clientUser) {
  2138.             $id_clientUser = $clientUser->getId();
  2140.             if ($id_clientUser != $id_client) {
  2141.                 return 'home';
  2142.             }
  2143.         }
  2145.         return "access";
  2146.     }
  2151.     public function getEntrepriseId()
  2152.     {
  2153.         $entreprise_id = $this->container->getParameter('entreprise_id');
  2155.         return $entreprise_id;
  2156.     }
  2165.     public function objectFilterToArray($filter)
  2166.     {
  2167.         $parameters = array();
  2169.         if ($filter) {
  2170.             foreach ($filter as $key => $value) {
  2171.                 if ($value) {
  2172.                     if (strpos($key, '[]')) {
  2173.                         $newkey = str_replace('[]', '', $key);
  2174.                         $parameters[$newkey] = $value;
  2175.                     } else {
  2176.                         if ($key !== "")
  2177.                             $parameters[$key] = $value;
  2178.                     }
  2179.                 }
  2180.             }
  2181.         }
  2183.         return $parameters;
  2184.     }
  2194.     public function add_intervention($client, $address, $items, $start_date, $start_hour, $end_hour, $project, $is_intervention_add_check = false, $type = null, $isEquipe = false, $makeUpdateProductivity = false, $forceDureeCalc = false)
  2195.     {
  2197.         $entreprise_id = $this->container->getParameter('entreprise_id');
  2198.         $entreprise = $this->em->getRepository(Entreprise::class)->find($entreprise_id);
  2200.         $intervention = new Interventions();
  2202.         $intervention->setClient($client);
  2203.         $intervention->setAdresseClient($address);
  2205.         if ($type)
  2206.             $intervention->setType($type);
  2208.         if ($project) {
  2209.             $intervention->setType("forfait_contrat_projets");
  2210.             $intervention->setProject($project);
  2211.         }
  2213.         $intervention->setClientName($client->GetLibelleClient());
  2214.         $intervention->setDate($start_date->format("Y-m-d"));
  2215.         $intervention->setHeureDebut($start_hour);
  2216.         $intervention->setHeureFin($end_hour);
  2218.         $client_interne = $entreprise->getCompteInterne();
  2219.         $client_interne_id = $client_interne->getId();
  2221.         if ($client->getId() != $client_interne_id) {
  2222.             $intervention->setSite($client->getSiteAffectation());
  2223.         } else {
  2224.             $site = $this->em->getRepository(Site::class)->findOneBy(['adresse' => $address->getId()]);
  2226.             if ($site)
  2227.                 $intervention->setSite($site);
  2229.             if ($is_intervention_add_check) {
  2230.                 $intervention->setFacture("");
  2231.                 $intervention->setType("offert");
  2232.             }
  2233.         }
  2235.         $equipes = [];
  2236.         $users = [];
  2237.         $equipes_old_productivities = [];
  2239.         if ($is_intervention_add_check) {
  2240.             if ($items) {
  2241.                 $tab = $items;
  2242.                 sort($tab);
  2243.                 $les_intervenant = [];
  2245.                 foreach ($tab as $interv) {
  2246.                     $test_type = explode("|", $interv);
  2248.                     if ($test_type[0] == "e") {
  2249.                         $equipe = $this->em->getRepository(Equipes::class)->find($test_type[1]);
  2250.                         $equipes[$equipe->getId()] = $equipe;
  2252.                         if ($makeUpdateProductivity && $project && $project->getIsAutoPlanified()) {
  2253.                             $equipes_old_productivities[$equipe->getId()] = $this->getEquipeProductivityByDate($equipe->getId(), $start_date->format("Y-m-d"))["old_productivite"];
  2254.                         }
  2255.                     } elseif ($test_type[0] == "u") {
  2256.                         array_push($les_intervenant, intval($test_type[1]));
  2257.                     }
  2258.                 }
  2260.                 if (count($les_intervenant) > 0)
  2261.                     $users = $les_intervenant;
  2262.                 else
  2263.                     $users = [];
  2264.             }
  2265.         } else {
  2266.             $intervention->setType("");
  2267.             $listTechniciensNames = "";
  2269.             if ($isEquipe) {
  2270.                 $equipes = [$items];
  2271.             } else {
  2272.                 $users = [$items->getId()];
  2273.                 $intervention->setTechniciensNames($items->getNom() . " " . $items->getPrenom() . "|");
  2274.             }
  2275.         }
  2277.         $intervention->setDescription("");
  2278.         $intervention->setFacture("");
  2280.         if ($project && !$is_intervention_add_check)
  2281.             $intervention->setEtatIntervention("resolu");
  2283.         $this->em->persist($intervention);
  2284.         $this->em->flush();
  2286.         $update_users = $this->SetInterventionUsers($users, $intervention);
  2288.         if (count($equipes) > 0)
  2289.             $update_equipes = $this->setEquipes($equipes, $intervention);
  2291.         if ($project) {
  2292.             $this->getTotalInterventionProjet($intervention->getProject()->getId(), true);
  2293.             $result = $this->setProjectAffectedDayByIntervention($intervention, 'add');
  2294.         }
  2298.         if (!$is_intervention_add_check || $forceDureeCalc) {
  2299.             $this->setDureeIntervention($intervention);
  2300.         }
  2303.         if (count($equipes_old_productivities) > 0) {
  2304.             foreach ($equipes_old_productivities as $equipe_id => $equipe_old_productivity) {
  2305.                 $update_productivity_result = $this->update_productivity($equipe_id, $intervention->getDate()->format('Y-m-d'), $project->getId(), "add", $equipe_old_productivity);
  2306.             }
  2307.         }
  2309.         return $intervention;
  2310.     }
  2317.     public function setEquipes($equipes, $intervention, $updateProductivity = false, $old_equipes = null)
  2318.     {
  2319.         foreach ($equipes as $equipe) {
  2320.             $old_productivity = null;
  2322.             if ($updateProductivity && !in_array($equipe->getId(), $old_equipes)) {
  2323.                 $old_productivity = $this->getEquipeProductivityByDate($equipe->getId(), $intervention->getDate()->format("Y-m-d"))["old_productivite"];
  2324.                 unset($old_equipes[$equipe->getId()]);
  2325.             }
  2327.             $this->addInterventionAffectedEquipe($intervention, $equipe);
  2329.             if ($old_productivity !== null) {
  2330.                 $this->update_productivity($equipe->getId(), $intervention->getDate()->format('Y-m-d'), $intervention->getProject()->getId(), "add", $old_productivity);
  2331.             }
  2332.         }
  2333.     }
  2340.     public function addInterventionAffectedEquipe($intervention, $equipe)
  2341.     {
  2342.         $interventionAffectedEquipe = $this->em->getRepository(InterventionAffectedEquipes::class)->findOneBy(["equipe" => $equipe->getId(), "intervention" => $intervention->getId()]);
  2344.         if (!$interventionAffectedEquipe) {
  2345.             $InterventionAffectedEquipes = new InterventionAffectedEquipes();
  2347.             $InterventionAffectedEquipes->setEquipe($equipe);
  2348.             $InterventionAffectedEquipes->setIntervention($intervention);
  2350.             $this->em->persist($InterventionAffectedEquipes);
  2351.             $this->em->flush();
  2352.         }
  2353.     }
  2361.     function SetInterventionUsers($users, $intervention, $modify_check = false, $old_date = null)
  2362.     {
  2363.         $projectUsersIds = null;
  2365.         if ($intervention->getProject()) {
  2366.             $projectUsersIds = array();
  2368.             $projectUsers = $this->em->getRepository(ProjectUsers::class)->findBy(["project" => $intervention->getProject()->getId()]);
  2370.             foreach ($projectUsers as $object) {
  2371.                 $projectUsersIds[] = $object->getUser()->getId();
  2372.             }
  2373.         }
  2375.         if (($users) && (strpos($users[0], "|") != false)) {
  2376.             $tab = $users;
  2377.             sort($tab);
  2379.             $equipes_intervention = [];
  2380.             $les_intervenant = [];
  2382.             $intervEquipe = $this->em->getRepository(InterventionAffectedEquipes::class)->findBy(['intervention' => $intervention->getId()]);
  2384.             $old_equipes = [];
  2385.             $updateProductivity = $modify_check && $intervention->getProject() && $intervention->getProject()->getIsAutoPlanified();
  2387.             $date = $intervention->getDate()->format("Y-m-d");
  2389.             if ($old_date !== null)
  2390.                 $date = $old_date;
  2392.             if ($intervEquipe) {
  2393.                 foreach ($intervEquipe as $intervE) {
  2394.                     $old_productivity = null;
  2395.                     $equipe_id = $intervE->getEquipe()->getId();
  2396.                     $old_equipes[$equipe_id] = $equipe_id;
  2398.                     if ($updateProductivity) {
  2399.                         if (!in_array("e|" . $equipe_id, $tab)) {
  2400.                             $productivity = $this->getEquipeProductivityByDate($intervE->getEquipe()->getId(), $date, true);
  2402.                             $old_productivity = $productivity["old_productivite"];
  2403.                             $new_productivity = $productivity["new_productivite"];
  2404.                         }
  2405.                     }
  2407.                     if ($old_productivity != null) {
  2408.                         $dateObj = \DateTime::createFromFormat('Y-m-d', $date);
  2410.                         $this->add_project_intervention_task($intervention->getProject(), $intervE->getEquipe(), $dateObj, $old_productivity, $new_productivity);
  2412.                         $update_productivity_result = $this->update_productivity($equipe_id, $date, $intervention->getProject()->getId(), "remove", $old_productivity);
  2414.                         $this->em->remove($intervE);
  2415.                         $this->em->flush();
  2416.                     }
  2417.                 }
  2418.             }
  2420.             //delete id equipe exist in the list tab and the database
  2421.             foreach ($intervEquipe as $i) {
  2422.                 if (in_array("e|" . $i->getEquipe()->getId(), $tab)) {
  2423.                     $pos = array_search("e|" . $i->getEquipe()->getId(), $tab);
  2424.                     array_splice($tab, $pos, 1);
  2425.                 }
  2426.             }
  2428.             //Add the new intervention
  2429.             foreach ($tab as $interv) {
  2430.                 $test_type = explode("|", $interv);
  2432.                 if ($test_type[0] == "e") {
  2433.                     $equipe = $this->em->getRepository(Equipes::class)->find($test_type[1]);
  2434.                     array_push($equipes_intervention, $equipe);
  2435.                 } else {
  2436.                     array_push($les_intervenant, intval($test_type[1]));
  2437.                 }
  2438.             }
  2440.             if (count($equipes_intervention) > 0)
  2441.                 $this->setEquipes($equipes_intervention, $intervention, $updateProductivity, $old_equipes);
  2442.             if (count($les_intervenant) > 0)
  2443.                 $users = $les_intervenant;
  2444.             else
  2445.                 $users = [];
  2446.         }
  2448.         $users = $users ?? [];
  2449.         foreach ($users as $id_user) {
  2450.             $userObj = $this->em->getRepository(User::class)->find($id_user);
  2451.             $interventionAffectedUser = $this->em->getRepository(InterventionAffectedUsers::class)->findOneBy(["user" => $id_user, "intervention" => $intervention->getId()]);
  2453.             if (!$interventionAffectedUser) {
  2454.                 $user = new InterventionAffectedUsers();
  2456.                 $user->setIntervention($intervention);
  2457.                 $user->setUser($userObj);
  2459.                 $this->em->persist($user);
  2460.                 $this->em->flush();
  2461.             }
  2463.             if ($projectUsersIds && !in_array($id_user, $projectUsersIds)) {
  2464.                 $projectUser = new ProjectUsers();
  2466.                 $projectUser->setProject($intervention->getProject());
  2467.                 $projectUser->setUser($userObj);
  2468.                 $projectUser->setType("intervenant");
  2470.                 $this->em->persist($projectUser);
  2471.                 $this->em->flush();
  2472.             }
  2473.         }
  2475.         return true;
  2476.     }
  2482.     function setDureeIntervention($intervention)
  2483.     {
  2484.         $originalDate = $intervention->getDate();
  2485.         $originalDate = $originalDate->format('Y-m-d H:i:s');
  2486.         $newDate = date("d-m-Y", strtotime($originalDate));
  2488.         $difference = $intervention->GetDureeIntervention();
  2489.         $duree = ($difference->d * 24 * 60) + ($difference->h * 60) + $difference->i;
  2491.         $users = $this->em->getRepository(InterventionAffectedUsers::class)->findBy(["intervention" => $intervention]);
  2492.         $equipes = $this->em->getRepository(InterventionAffectedEquipes::class)->findBy(["intervention" => $intervention]);
  2493.         $duree *= count($users) + count($equipes);
  2495.         $intervention->setDuree($duree);
  2497.         $this->em->flush();
  2498.     }
  2503.     public function setProjectAffectedDayByIntervention($intervention, $type, $old_date = null, $old_start_hour = null, $old_end_hour = null)
  2504.     {
  2505.         $projectAffectedDay = $this->em->getRepository(ProjectAffectedDays::class)->findOneBy(array('project' => $intervention->getProject(), 'date' => $intervention->getDate()));
  2507.         if (!$projectAffectedDay) {
  2508.             $projectAffectedDay = new ProjectAffectedDays();
  2510.             $projectAffectedDay->setProject($intervention->getProject());
  2511.             $projectAffectedDay->setDate($intervention->getDate());
  2512.             $projectAffectedDay->setMatin(0);
  2513.             $projectAffectedDay->setApreMidi(0);
  2514.         }
  2516.         $entreprise_horaires = $this->getEntrepriseHoursFromDate($intervention->getDate());
  2517.         $morning_end_hour = $entreprise_horaires["morning_end_hour"];
  2518.         $midday_start_hour = $entreprise_horaires["midday_start_hour"];
  2520.         $new_morning_value = null;
  2521.         $new_midday_value = null;
  2523.         if ($type == "delete") {
  2524.             if ($projectAffectedDay->getMatin() >= 1)
  2525.                 $new_morning_value = $projectAffectedDay->getMatin() - 1;
  2527.             if ($projectAffectedDay->getApreMidi() >= 1)
  2528.                 $new_midday_value = $projectAffectedDay->getApreMidi() - 1;
  2529.         } elseif ($type == "add") {
  2530.             $new_morning_value = $projectAffectedDay->getMatin() + 1;
  2531.             $new_midday_value = $projectAffectedDay->getApreMidi() + 1;
  2532.         } else {
  2533.             if ($old_date != $intervention->getDate()) {
  2534.                 $oldProjectAffectedDay = $this->em->getRepository(ProjectAffectedDays::class)->findOneBy(array('project' => $intervention->getProject(), 'date' => $old_date));
  2536.                 if ($oldProjectAffectedDay) {
  2537.                     if ($old_start_hour < $morning_end_hour && $oldProjectAffectedDay->getMatin() > 0)
  2538.                         $oldProjectAffectedDay->setMatin($oldProjectAffectedDay->getMatin() - 1);
  2540.                     if ($old_end_hour > $midday_start_hour && $oldProjectAffectedDay->getApreMidi() > 0)
  2541.                         $oldProjectAffectedDay->setApreMidi($oldProjectAffectedDay->getApreMidi() - 1);
  2543.                     $this->em->flush();
  2544.                 }
  2545.             } else {
  2546.                 if ($old_start_hour < $morning_end_hour && $projectAffectedDay->getMatin() > 0)
  2547.                     $projectAffectedDay->setMatin($projectAffectedDay->getMatin() - 1);
  2549.                 if ($old_end_hour > $midday_start_hour && $projectAffectedDay->getApreMidi() > 0)
  2550.                     $projectAffectedDay->setApreMidi($projectAffectedDay->getApreMidi() - 1);
  2552.                 $this->em->flush();
  2553.             }
  2555.             $new_morning_value = $projectAffectedDay->getMatin() + 1;
  2556.             $new_midday_value = $projectAffectedDay->getApreMidi() + 1;
  2557.         }
  2559.         if ($new_morning_value && $intervention->getHeureDebut() < $morning_end_hour)
  2560.             $projectAffectedDay->setMatin($new_morning_value);
  2562.         if ($new_midday_value && $intervention->getHeureFin() > $midday_start_hour)
  2563.             $projectAffectedDay->setApreMidi($new_midday_value);
  2565.         $this->em->persist($projectAffectedDay);
  2566.         $this->em->flush();
  2568.         return new Response("done");
  2569.     }
  2577.     function add_project_intervention_task($current_project, $object, $date, $old_productivity, $new_productivity, $addToCurrent = false)
  2578.     {
  2579.         if ($addToCurrent)
  2580.             $projects = [$current_project];
  2581.         else {
  2582.             if ($object instanceof User)
  2583.                 $projects = $this->ProjectsRepository->getUsersInterventionByDate($current_project, $object, $date);
  2584.             else
  2585.                 $projects = $this->ProjectsRepository->getEquipesInterventionByDate($current_project, $object, $date);
  2586.         }
  2588.         foreach ($projects as $project) {
  2589.             $ProjectsAutoPlanifiedTasks = new ProjectsAutoPlanifiedTasks();
  2591.             $ProjectsAutoPlanifiedTasks->setProject($project);
  2592.             $ProjectsAutoPlanifiedTasks->setDate($date);
  2593.             $ProjectsAutoPlanifiedTasks->setOldProductivity($old_productivity);
  2594.             $ProjectsAutoPlanifiedTasks->setNewProductivity($new_productivity);
  2596.             if ($object instanceof User)
  2597.                 $ProjectsAutoPlanifiedTasks->setUser($object);
  2598.             else
  2599.                 $ProjectsAutoPlanifiedTasks->setEquipe($object);
  2601.             $this->em->persist($ProjectsAutoPlanifiedTasks);
  2602.             $this->em->flush();
  2603.         }
  2605.         return true;
  2606.     }
  2614.     public function update_productivity($equipe_id, $date, $project_id, $action, $old_productivity)
  2615.     {
  2616.         $date_productivity_data = $this->getEquipeProductivityByDate($equipe_id, $date);
  2618.         if ($date_productivity_data) {
  2619.             $project = $this->em->getRepository(Projects::class)->find($project_id);
  2621.             if ($project->getIsAutoPlanified()) {
  2622.                 $new_productivity = 0;
  2624.                 if ($project->getTotalProductivity())
  2625.                     $new_productivity = floatval($project->getTotalProductivity());
  2627.                 switch ($action) {
  2628.                     case "add":
  2629.                         $new_productivity += $date_productivity_data["old_productivite"];
  2631.                         break;
  2632.                     case "remove":
  2633.                         $old_productivity ? $new_productivity -= $old_productivity : $new_productivity -= $date_productivity_data["old_productivite"];
  2635.                         break;
  2636.                     default:
  2637.                         break;
  2638.                 }
  2640.                 $project->setTotalProductivity($new_productivity);
  2641.                 $this->em->flush();
  2643.                 $projects = $date_productivity_data["projects"];
  2644.                 $other_projects = array();
  2646.                 if ($projects) {
  2647.                     $other_projects = array_values(
  2648.                         array_filter(array_column($projects, 'id'), function ($id) use ($project_id) {
  2649.                             return $id != $project_id;
  2650.                         })
  2651.                     );
  2652.                 }
  2654.                 $result = array(
  2655.                     "equipe_productivity" => $date_productivity_data["old_productivite"],
  2656.                     "new_productivity" => $new_productivity,
  2657.                     "other_projects" => $other_projects
  2658.                 );
  2660.                 if ($old_productivity != $date_productivity_data["old_productivite"]) {
  2661.                     foreach ($other_projects as $other_project_id) {
  2662.                         $other_project = $this->em->getRepository(Projects::class)->find($other_project_id);
  2663.                         $equipe = $this->em->getRepository(Equipes::class)->find($equipe_id);
  2664.                         $date_object = new \Datetime($date);
  2666.                         if ($action == "remove" && $old_productivity === false)
  2667.                             $task = $this->add_project_intervention_task($other_project, $equipe, $date_object, $date_productivity_data["new_productivite"], $date_productivity_data["old_productivite"], true);
  2668.                         else
  2669.                             $task = $this->add_project_intervention_task($other_project, $equipe, $date_object, $old_productivity, $date_productivity_data["old_productivite"], true);
  2670.                     }
  2671.                 }
  2673.                 return $result;
  2674.             }
  2676.             return "project is not auto planified";
  2677.         }
  2678.     }
  2685.     public function unassign_user_from_intervention($intervention, $user_id)
  2686.     {
  2688.         $this->UpdateSuiviTravaux($intervention->getId(), "deleted", ['user_id' => $user_id]);
  2690.         $interventionAffectedUser = $this->em->getRepository(InterventionAffectedUsers::class)->findOneBy(['intervention' => $intervention->getId(), 'user' => $user_id]);
  2691.         if ($interventionAffectedUser) {
  2693.             $this->em->remove($interventionAffectedUser);
  2694.             $this->em->flush();
  2696.             $this->update_user_duree_intervention("delete", null, null, $interventionAffectedUser);
  2697.             $this->update_intervention_new_field($intervention);
  2699.             $interventionAffectedUsers = $this->em->getRepository(InterventionAffectedUsers::class)->findBy(['intervention' => $intervention->getId()]);
  2700.             $interventionAffectedEquipes = $this->em->getRepository(InterventionAffectedEquipes::class)->findBy(['intervention' => $intervention->getId()]);
  2702.             if (empty($interventionAffectedUsers) && empty($interventionAffectedEquipes)) {
  2703.                 $this->em->getRepository(InterventionsMateriel::class)->remove_InterventionMateriel($intervention);
  2704.                 $this->em->getRepository(InterventionAffectedEquipes::class)->remove_InterventionAffectedEquipes($intervention);
  2705.                 $this->em->getRepository(InterventionAffectedTags::class)->remove_InterventionAffectedTagsRepository($intervention);
  2706.                 $this->em->getRepository(InterventionImages::class)->remove_InterventionImagesRepository($intervention);
  2707.                 $this->InterventionsRepository->remove_interventions($intervention);
  2708.                 $this->UpdateSuiviTravaux($intervention->getId(), "deleted");
  2709.             }
  2710.             $this->UpdateStatProject($intervention->getProject(), "MainOeuvre");
  2712.             return true;
  2713.         }
  2715.         return false;
  2716.     }
  2723.     public function unassign_equipe_from_intervention($intervention, $equipe_id)
  2724.     {
  2725.         $interventionAffectedEquipe = $this->em->getRepository(InterventionAffectedEquipes::class)->findOneBy(['intervention' => $intervention->getId(), 'equipe' => $equipe_id]);
  2727.         if ($interventionAffectedEquipe) {
  2728.             $old_productivity = null;
  2730.             if ($intervention->getProject()->getIsAutoPlanified()) {
  2731.                 $old_productivity = $this->getEquipeProductivityByDate($equipe_id, $intervention->getDate()->format("Y-m-d"))["old_productivite"];
  2732.             }
  2734.             $this->em->remove($interventionAffectedEquipe);
  2735.             $this->em->flush();
  2737.             $this->update_intervention_new_field($intervention);
  2739.             $interventionAffectedUsers = $this->em->getRepository(InterventionAffectedUsers::class)->findBy(['intervention' => $intervention->getId()]);
  2740.             $interventionAffectedEquipes = $this->em->getRepository(InterventionAffectedEquipes::class)->findBy(['intervention' => $intervention->getId()]);
  2742.             if (empty($interventionAffectedUsers) && empty($interventionAffectedEquipes)) {
  2743.                 $this->em->getRepository(InterventionsMateriel::class)->remove_InterventionMateriel($intervention);
  2744.                 $this->em->getRepository(InterventionAffectedEquipes::class)->remove_InterventionAffectedEquipes($intervention);
  2745.                 $this->em->getRepository(InterventionAffectedTags::class)->remove_InterventionAffectedTagsRepository($intervention);
  2746.                 $this->em->getRepository(InterventionImages::class)->remove_InterventionImagesRepository($intervention);
  2747.                 $this->InterventionsRepository->remove_interventions($intervention);
  2748.                 $this->UpdateSuiviTravaux($intervention->getId(), "deleted");
  2749.             }
  2750.             $this->UpdateStatProject($intervention->getProject(), "MainOeuvre");
  2752.             if ($intervention->getProject()->getIsAutoPlanified()) {
  2753.                 $update_productivity_result = $this->update_productivity($equipe_id, $intervention->getDate()->format("Y-m-d"), $intervention->getProject()->getId(), "remove", $old_productivity);
  2755.                 return new Response(json_encode(["new_productivite" => $update_productivity_result["new_productivity"]]));
  2756.             }
  2757.         }
  2758.         return new Response("done");
  2759.     }
  2769.     function update_intervention_new_field($intervention)
  2770.     {
  2771.         if ($intervention->getClient()->getType() == "professionnel")
  2772.             $intervention->setClientName(trim($intervention->getClient()->getDenomination()));
  2773.         elseif ($intervention->getClient()->getType() == "particulier")
  2774.             $intervention->setClientName($intervention->getClient()->getNom() . ' ' . $intervention->getClient()->getPrenom());
  2776.         $sql = "
  2777.             SELECT u.nom ,u.prenom FROM `intervention_affected_users` as iau
  2778.             left join user as u on u.id=iau.user_id
  2779.             where iau.intervention_id = " . $intervention->getId();
  2781.         $request = $this->em->getConnection()->prepare($sql);
  2782.         $request->execute();
  2783.         $affected_users = $request->fetchAll();
  2785.         $technicien = "";
  2787.         foreach ($affected_users as $key1 => $value1) {
  2788.             $technicien .= $value1["nom"] . " " . $value1["prenom"] . "|";
  2789.         }
  2791.         $intervention->setTechniciensNames($technicien);
  2793.         $facturation_intervention = "";
  2795.         if ($intervention->getType() == "forfait_contrat_projets")
  2796.             $facturation_intervention .= "Forfait Contrat Projets";
  2797.         elseif ($intervention->getType() == "hors_forfait")
  2798.             $facturation_intervention .= "Hors forfait";
  2799.         elseif ($intervention->getType() == "offert")
  2800.             $facturation_intervention .= "Offert";
  2802.         if ($intervention->getOffre() && $intervention->getType() != "hors_forfait") {
  2803.             if ($intervention->getOffre()->getLibelle() != NULL)
  2804.                 $facturation_intervention .= ": " . $intervention->getOffre()->getLibelle();
  2805.         }
  2807.         if ($intervention->getFacture() == "facture")
  2808.             $facturation_intervention .= "- Facturé";
  2809.         elseif ($intervention->getFacture() == "a_facturer")
  2810.             $facturation_intervention .= "- A Facturer";
  2811.         elseif ($intervention->getFacture() == "offre")
  2812.             $facturation_intervention .= "- Offre";
  2814.         $intervention->setFacturationLibelle($facturation_intervention);
  2816.         $this->setDureeIntervention($intervention);
  2818.         $this->em->flush();
  2820.         return $intervention->getId();
  2821.     }
  2826.     private function getUserOrEquipeProductivityByDate($object_productivity, $object_id, $date, $affected, $isUser = false)
  2827.     {
  2828.         $entreprise_id = $this->container->getParameter('entreprise_id');
  2829.         $entreprise = $this->em->getRepository(Entreprise::class)->find($entreprise_id);
  2831.         $horaires = $entreprise->getHoraires();
  2832.         $nb_half_days = 0;
  2833.         $old_productivite = 0;
  2834.         $new_productivite = 0;
  2836.         foreach ($this->days as $day_name => $day) {
  2837.             if ($horaires[$day_name]["matin"]["closed"] == false)
  2838.                 $nb_half_days++;
  2840.             if ($horaires[$day_name]["apresMidi"]["closed"] == false)
  2841.                 $nb_half_days++;
  2842.         }
  2844.         if ($nb_half_days !== 0) {
  2845.             $productivite = $object_productivity / $nb_half_days;
  2846.             $projects = $this->ProjectsRepository->getProductsForUserOrEquipeByDate($object_id, $date, $isUser);
  2847.             $checkIfDefaultUser = false;
  2849.             if ($isUser)
  2850.                 $checkIfDefaultUser = $entreprise->getDefaultJointeur()->getId() == $object_id;
  2852.             if (!$affected) {
  2853.                 if ($checkIfDefaultUser) {
  2854.                     $old_productivite = $productivite;
  2855.                     $new_productivite = $productivite;
  2856.                 } elseif (count($projects) >= 1) {
  2857.                     $old_productivite = $productivite / (count($projects));
  2858.                     $new_productivite = $productivite / (count($projects) + 1);
  2859.                 } else {
  2860.                     $new_productivite = $productivite;
  2861.                 }
  2862.             } else {
  2863.                 if ($checkIfDefaultUser) {
  2864.                     $old_productivite = $productivite;
  2865.                     $new_productivite = $productivite;
  2866.                 } elseif (count($projects) > 1) {
  2867.                     $old_productivite = $productivite / (count($projects));
  2868.                     $new_productivite = $productivite / (count($projects) - 1);
  2869.                 } else {
  2870.                     $old_productivite = $productivite;
  2871.                 }
  2872.             }
  2874.             return array(
  2875.                 "old_productivite" => $old_productivite,
  2876.                 "new_productivite" => $new_productivite,
  2877.                 "projects" => $projects
  2878.             );
  2879.         }
  2881.         return;
  2882.     }
  2890.     public function getEquipeProductivityByDate($equipe_id, $date, $affected = false)
  2891.     {
  2892.         $equipe = $this->em->getRepository(Equipes::class)->find($equipe_id);
  2894.         if ($equipe->getProductivite()) {
  2895.             return $this->getUserOrEquipeProductivityByDate($equipe->getProductivite(), $equipe_id, $date, $affected);
  2896.         }
  2898.         return;
  2899.     }
  2900.     function CalculeMargeProject($Project, $is_frais = false, $is_main_oeuvre = false, $is_marge = false, $devis_value = null)
  2901.     {
  2903.         $taux_frais = $this->calc_taux_frais($Project->getId());
  2905.         $total_main_oeuvre = $this->total_main_oeuvre($Project->getId());
  2907.         if ($devis_value) {
  2908.             $marge = $devis_value - $total_main_oeuvre - $taux_frais;
  2909.             $Project->setDevis($devis_value);
  2910.         } else
  2911.             $marge = $Project->getDevis() - $total_main_oeuvre - $taux_frais;
  2913.         if ($is_frais)
  2914.             $Project->setFrais($taux_frais);
  2916.         if ($is_main_oeuvre)
  2917.             $Project->setMainOeuvre($total_main_oeuvre);
  2919.         $Project->setMarge($marge);
  2921.         $this->em->persist($Project);
  2923.         $this->em->flush();
  2925.         if ($is_marge)
  2926.             return $marge;
  2928.         return $Project;
  2929.     }
  2934.     function UpdateStatProject($Project, $Action = "", $Old_year = null)
  2935.     {
  2936.         switch ($Action) {
  2937.             case "FACTURATION":
  2938.                 $SommeFactureAndSommeRegle = $this->em->getRepository(ProjectFacturation::class)->SommeFactureAndSommeRegle($Project);
  2940.                 $Project->setSommeRegle($SommeFactureAndSommeRegle[0]["Regle"]);
  2941.                 $Project->setSommeFacture($SommeFactureAndSommeRegle[0]["Facture"]);
  2942.                 $Project->setNonRegle($SommeFactureAndSommeRegle[0]["Facture"] - $SommeFactureAndSommeRegle[0]["Regle"]);
  2944.                 break;
  2945.             case "FRAIS":
  2947.                 $Project = $this->CalculeMargeProject($Project, true);
  2949.                 break;
  2951.             case "MainOeuvre":
  2953.                 $Project = $this->CalculeMargeProject($Project, false, true);
  2955.                 break;
  2956.         }
  2958.         $this->em->persist($Project);
  2959.         $this->em->flush();
  2961.         $this->getTotalInterventionProjet($Project->getId(), true);
  2964.     }
  2968.     public function getJointeurProductivityByDate($user_id, $date, $affected = false)
  2969.     {
  2970.         $user = $this->em->getRepository(User::class)->find($user_id);
  2972.         if ($user->getProductiviteM2()) {
  2973.             return $this->getUserOrEquipeProductivityByDate($user->getProductiviteM2(), $user_id, $date, $affected, true);
  2974.         }
  2976.         return;
  2977.     }
  2984.     public function getPrefixUser($user)
  2985.     {
  2986.         $prefix_user = "";
  2988.         if ($user->getTache() && $user->getTache() === "Jointeur")
  2989.             $prefix_user = "Jointeur ";
  2991.         return $prefix_user;
  2992.     }
  2996.     public function getPageLink($list, $vue_graphique, $pageType)
  2997.     {
  2998.         $user = $this->tokenStorage->getToken()->getUser();
  2999.         $request = $this->requestStack->getCurrentRequest();
  3000.         $session = $request->getSession();
  3002.         $urlInSession = $session->get('page-type', []);
  3004.         if (in_array("ROLE_vue_details", $user->getRoles()) && !in_array("ROLE_vue_graphique", $user->getRoles()))
  3005.             return $list;
  3006.         else if (!in_array("ROLE_vue_details", $user->getRoles()) && in_array("ROLE_vue_graphique", $user->getRoles())) {
  3007.             if ($pageType == "Interventions" && $urlInSession && array_key_exists("InterventionsType", $urlInSession))
  3008.                 return $vue_graphique . "?type=" . $urlInSession["InterventionsType"];
  3010.             return $vue_graphique;
  3011.         } else {
  3013.             if ($urlInSession && array_key_exists($pageType, $urlInSession) && $urlInSession[$pageType] == "graphique") {
  3014.                 if ($pageType == "Interventions" && $urlInSession && array_key_exists("InterventionsType", $urlInSession))
  3015.                     return $vue_graphique . "?type=" . $urlInSession["InterventionsType"];
  3016.                 else
  3017.                     return $vue_graphique;
  3018.             }
  3020.             return $list;
  3021.         }
  3022.     }
  3024.     public function get_type_and_size_file($path, $id)
  3025.     {
  3026.         $info_documents = array();
  3028.         $fileSize = 0;
  3030.         $imageExtensions = ['jpg', 'jpeg', 'png', 'gif'];
  3032.         $urlParts = parse_url($path);
  3034.         if (isset($urlParts['path']))
  3035.             $path = $urlParts['path'];
  3037.         $pathWithoutFirstSlash = ltrim($path, '/');
  3039.         if (file_exists($pathWithoutFirstSlash))
  3040.             $fileSize = filesize($pathWithoutFirstSlash);
  3042.         $fileExtension = $this->get_extension_file($path);
  3044.         $info_documents[$id] = [
  3045.             'type' => in_array(strtolower($fileExtension), $imageExtensions) ? 'image' : 'document',
  3046.             'size' => $fileSize
  3047.         ];
  3049.         return $info_documents;
  3051.     }
  3054.     function setProjectSuiviTravaux($project_id, $item_id, $date, $heure_reel, $projectSuiviTravaux_id = null, $isEquipe = false)
  3055.     {
  3056.         $project = $this->em->getRepository(Projects::class)->find($project_id);
  3058.         $intervenant = null;
  3060.         if (!$isEquipe)
  3061.             $intervenant = $this->em->getRepository(User::class)->find($item_id);
  3062.         else
  3063.             $equipe = $this->em->getRepository(Equipes::class)->find($item_id);
  3065.         if ($projectSuiviTravaux_id) {
  3066.             $projectSuiviTravaux = $this->em->getRepository(ProjectSuiviTravaux::class)->find($projectSuiviTravaux_id);
  3068.             if ($projectSuiviTravaux->getHeureReel() != $heure_reel) {
  3069.                 $taux_minute = $projectSuiviTravaux->getTauHoraire() / 60;
  3070.                 $taux_minute_project = $projectSuiviTravaux->getUserTauHoriare() / 60;
  3071.                 $projectSuiviTravaux->setHeureReel($heure_reel);
  3072.                 $projectSuiviTravaux->setHeuresUser($heure_reel);
  3073.                 $projectSuiviTravaux->setHeuresClient($heure_reel);
  3074.                 $projectSuiviTravaux->setSommeUser($heure_reel * $taux_minute);
  3075.                 $projectSuiviTravaux->setSommeClient($heure_reel * $taux_minute_project);
  3076.             }
  3077.         } else {
  3078.             $projectSuiviTravaux = new ProjectSuiviTravaux();
  3080.             $projectSuiviTravaux->setProject($project);
  3081.             $projectSuiviTravaux->setUser($intervenant);
  3082.             $projectSuiviTravaux->setDate($date);
  3084.             if ($isEquipe) {
  3085.                 $projectSuiviTravaux->setEquipe($equipe);
  3087.                 if ($this->em->getRepository(Equipes::class)->getTauxHoraire($equipe->getId())) {
  3088.                     $taux = $this->em->getRepository(Equipes::class)->getTauxHoraire($equipe->getId())['taux_horaire'] ?? 0;
  3089.                     $projectSuiviTravaux->setTauHoraire($taux);
  3090.                     $taux_minute = $taux / 60;
  3091.                 } else {
  3092.                     $projectSuiviTravaux->setTauHoraire(0);
  3093.                     $taux_minute = 0;
  3094.                 }
  3095.             } else {
  3096.                 $projectSuiviTravaux->setUser($intervenant);
  3098.                 if ($intervenant->getTauxHoraire()) {
  3099.                     $projectSuiviTravaux->setTauHoraire($intervenant->getTauxHoraire());
  3100.                     $taux_minute = $intervenant->getTauxHoraire() / 60;
  3101.                 } else {
  3102.                     $projectSuiviTravaux->setTauHoraire(0);
  3103.                     $taux_minute = 0;
  3104.                 }
  3105.             }
  3107.             if ($project->getTauxHoraire()) {
  3108.                 $projectSuiviTravaux->setUserTauHoriare($project->getTauxHoraire());
  3109.                 $taux_minute_project = $project->getTauxHoraire() / 60;
  3110.             } else {
  3111.                 $projectSuiviTravaux->setUserTauHoriare(0);
  3112.                 $taux_minute_project = 0;
  3113.             }
  3115.             $projectSuiviTravaux->setHeuresUser($heure_reel);
  3116.             $projectSuiviTravaux->setHeureReel($heure_reel);
  3117.             $projectSuiviTravaux->setHeuresClient($heure_reel);
  3118.             $projectSuiviTravaux->setSommeUser($heure_reel * $taux_minute);
  3119.             $projectSuiviTravaux->setSommeClient($heure_reel * $taux_minute_project);
  3121.             $this->em->persist($projectSuiviTravaux);
  3122.         }
  3124.         $this->em->flush();
  3125.     }
  3129.     public function heures_reels($data, $type)
  3130.     {
  3131.         $heures_reels = [];
  3132.         $items = isset($data[$type]) ? $data[$type] : (isset($data['users']) ? $data['users'] : $data['equipes']);
  3133.         $interventions = isset($data["equipes_interventions"]) ? $data["equipes_interventions"] : (isset($data["interventions"]) ? $data["interventions"] : []);
  3135.         foreach ($items as $item) {
  3136.             $id_item = $item['id'];
  3137.             $minutes = 0;
  3138.             if (isset($interventions[$id_item])) {
  3139.                 foreach ($interventions[$id_item] as $intervention) {
  3140.                     $array_times = explode(":", $intervention["duree_intervention"]);
  3141.                     $minutes += ($array_times[0] * 60 + $array_times[1]);
  3142.                 }
  3143.                 $heures_reels[$id_item] = $minutes;
  3144.             }
  3145.         }
  3146.         return $heures_reels;
  3147.     }
  3149.     public function addSuiviTravauxProject($project_id, $item, $intervention, $isEquipe)
  3150.     {
  3151.         $projectSuiviTravaux = $this->em->getRepository(ProjectSuiviTravaux::class)->findByProjectAndUserAndDate($project_id, $item->getId(), $intervention->getDate()->format("Y-m-d"));
  3152.         $projectSuiviTravaux_id = $projectSuiviTravaux ? $projectSuiviTravaux[0]->getId() : null;
  3154.         $dataIntervention = clone $intervention->getDate();
  3155.         $data = $this->getProjectIntervenantsInterventions($project_id, $dataIntervention);
  3156.         $heures_reels = $this->heures_reels($data, $isEquipe ? "equipes" : "users");
  3157.         $heures_reel = isset($heures_reels[$item->getId()]) ? $heures_reels[$item->getId()] : 0;
  3159.         $this->setProjectSuiviTravaux($project_id, $item->getId(), $intervention->getDate(), $heures_reel, $projectSuiviTravaux_id, $isEquipe);
  3160.     }
  3163.     public function UpdateSuiviTravaux($intervention_id, $action, $params = [])
  3164.     {
  3165.         $intervention = $this->em->getRepository(Interventions::class)->find($intervention_id);
  3166.         if (!empty($intervention)) {
  3167.             switch ($action) {
  3168.                 case "deleted":
  3169.                     $filter = [
  3170.                         'project' => $intervention->getProject(),
  3171.                         'date' => $intervention->getDate()
  3172.                     ];
  3174.                     if (isset($params['user_id']))
  3175.                         $filter['user'] = $params['user_id'];
  3177.                     $ProjectSuiviTravauxList = $this->em->getRepository(ProjectSuiviTravaux::class)->findby($filter);
  3179.                     foreach ($ProjectSuiviTravauxList as $ProjectSuiviTravaux) {
  3180.                         if ($intervention->getDuree() >= $ProjectSuiviTravaux->getHeureReel())
  3181.                             $this->em->remove($ProjectSuiviTravaux);
  3182.                         else {
  3183.                             $newDuree = $ProjectSuiviTravaux->getHeureReel() - $intervention->getDuree();
  3184.                             $oldDuree = $ProjectSuiviTravaux->getHeureReel();
  3185.                             $ProjectSuiviTravaux->setHeureReel($newDuree);
  3186.                             $ProjectSuiviTravaux->setHeuresUser($ProjectSuiviTravaux->getHeuresUser() - $intervention->getDuree());
  3187.                             $ProjectSuiviTravaux->setHeuresClient($ProjectSuiviTravaux->getHeuresClient() - $intervention->getDuree());
  3188.                             $ProjectSuiviTravaux->setSommeUser($this->getNewsPrice($newDuree, $oldDuree, $ProjectSuiviTravaux->getSommeUser()));
  3189.                             $ProjectSuiviTravaux->setSommeClient($this->getNewsPrice($newDuree, $oldDuree, $ProjectSuiviTravaux->getSommeUser()));
  3190.                         }
  3192.                         $this->em->flush();
  3193.                     }
  3194.                     break;
  3196.                 default:
  3197.                     break;
  3198.             }
  3199.             if (!empty($intervention->getProject()))
  3200.                 $this->UpdateStatProject($intervention->getProject(), "MainOeuvre");
  3201.         }
  3202.         return 'done';
  3203.     }
  3204.     function getNewsPrice($newDuree, $oldDuree, $oldPrice)
  3205.     {
  3206.         $newPrice = round((($oldPrice / $oldDuree) * $newDuree), 2);
  3207.         return $newPrice;
  3208.     }
  3210.     function UpdateUserSuiviTravaux($user_id)
  3211.     {
  3212.         $user = $this->em->getRepository(User::class)->find($user_id);
  3213.         $ProjectSuiviTravauxList = $this->em->getRepository(ProjectSuiviTravaux::class)->findby(['user' => $user_id]);
  3215.         foreach ($ProjectSuiviTravauxList as $ProjectSuiviTravaux) {
  3216.             $ProjectSuiviTravaux->setTauHoraire($user->getTauxHoraire());
  3217.             $ProjectSuiviTravaux->setSommeUser(round($user->getTauxHoraire() * ($ProjectSuiviTravaux->getHeuresUser() / 60)), 2);
  3218.             $this->em->flush();
  3220.             $this->UpdateStatProject($ProjectSuiviTravaux->getProject(), "MainOeuvre");
  3221.         }
  3222.         return 'done';
  3223.     }
  3224.     public function getEntrepriseClosedDays()
  3225.     {
  3226.         $entreprise_id = $this->container->getParameter('entreprise_id');
  3227.         $entreprise = $this->em->getRepository(Entreprise::class)->find($entreprise_id);
  3229.         $horaires = $entreprise->getHoraires();
  3230.         $d = 1;
  3232.         $closed_days = array();
  3234.         foreach ($horaires as $day) {
  3235.             if ($day["matin"]["closed"] == true && $day["apresMidi"]["closed"] == true)
  3236.                 $closed_days[] = $d % 7;
  3238.             $d++;
  3239.         }
  3241.         return $closed_days;
  3242.     }
  3243. }