src/Entity/Training/Groupe.php line 20

Open in your IDE?
  1. <?php
  3. namespace App\Entity\Training;
  5. use ApiPlatform\Core\Annotation\ApiResource;
  6. use App\Entity\User;
  7. use App\Repository\Training\GroupeRepository;
  8. use App\Traits\Actions;
  9. use App\Entity\Schoolyear;
  10. use DateInterval;
  11. use DatePeriod;
  12. use DateTime;
  13. use Doctrine\Common\Collections\ArrayCollection;
  14. use Doctrine\Common\Collections\Collection;
  15. use Doctrine\ORM\Mapping as ORM;
  17. #[ORM\Entity(repositoryClass: GroupeRepository::class)]
  18. #[ORM\Table(name: 'hs_tc_training_groupe')]
  19. #[ApiResource]
  20. class Groupe implements \Stringable
  21. {
  22.     use Actions;
  24.     #[ORM\ManyToOne(inversedBy: 'groupes')]
  25.     private ?Training $training = null;
  26.     #[ORM\ManyToOne(targetEntity: Schoolyear::class)]
  27.     #[ORM\JoinColumn(nullable: true)]
  28.     private ?Schoolyear $schoolyear1 = null;
  30.     #[ORM\OneToMany(mappedBy: "groupe", targetEntity: Trainee::class)]
  31.     #[ORM\OrderBy(["regNumber" => "ASC"])]
  32.     private Collection $trainees;
  34.     #[ORM\OneToMany(mappedBy: "groupe", targetEntity: Planning::class, cascade: ["all"], orphanRemoval: true)]
  35.     private Collection $plannings;
  37.     #[ORM\OneToMany(mappedBy: "groupe", targetEntity: Assignation::class, cascade: ["all"], orphanRemoval: true)]
  38.     private Collection $assignations;
  40.     #[ORM\OneToMany(mappedBy: "groupe", targetEntity: Schedule::class, cascade: ["all"], orphanRemoval: true)]
  41.     private Collection $schedules;
  43.     #[ORM\ManyToOne(targetEntity: User::class, inversedBy: "groupes")]
  44.     #[ORM\JoinColumn(nullable: true)]
  45.     private ?User $responsable;
  47.     public function __construct()
  48.     {
  49.         $this->trainees = new ArrayCollection();
  50.         $this->createAt=new \DateTime('now');
  51.         $this->published=true;
  52.     }
  54.     public function getStartAt($period='formation'): ?\DateTime{
  55.         if($this->getTraining()==null){
  56.             return null;
  57.         }
  58.         $startMonth=$this->getTraining()->getListMonths()[0];
  59.         if($period=='formation' or $period=='firstYear'){
  60.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$startMonth.'/' . $this->getFirstYear()->getFirstYear(). ' 00:00');
  61.         }
  62.         elseif($period=='secondYear'){
  63.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$startMonth.'/' . ($this->getFirstYear()->getFirstYear()+1). ' 00:00');
  64.         }
  65.         else{
  66.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$startMonth.'/' . ($this->getFirstYear()->getFirstYear()+2). ' 00:00');
  67.         }
  68.     }
  69.     public function getEndAt($period='formation'): ?\DateTime{
  70.         if($this->getTraining()==null){
  71.             return null;
  72.         }
  73.         $endMonth=$this->getTraining()->getListMonths()[count($this->getTraining()->getListMonths())-1];
  74.         if($period=='thirdYear'){
  75.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$endMonth.'/' . ($this->getFirstYear()->getSecondYear()+2). ' 23:59');
  76.         }
  77.         elseif($period=='secondYear'){
  78.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$endMonth.'/' . ($this->getFirstYear()->getSecondYear()+1). ' 23:59');
  79.         }
  80.         elseif($period=='firstYear'){
  81.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$endMonth.'/' . $this->getFirstYear()->getSecondYear(). ' 23:59');
  82.         }
  83.         else{
  84.             return \DateTime::createFromFormat('d/m/Y H:i', '1/'.$endMonth.'/' . ($this->getFirstYear()->getSecondYear()+$this->getTraining()->getSchoolYearsNumber()-1). ' 23:59');
  85.         }
  87.     }
  88.     public function setTraining(Training $training)
  89.     {
  90.         $this->training = $training;
  92.         return $this;
  93.     }
  95.     public function getTraining()
  96.     {
  97.         return $this->training;
  98.     }
  100.     public function getSchoolyear1()
  101.     {
  102.         return $this->schoolyear1;
  103.     }
  105.     public function setSchoolyear1(Schoolyear $schoolyear1=null)
  106.     {
  107.         $this->schoolyear1 = $schoolyear1;
  108.         return $this;
  109.     }
  111.     public function getSchoolyear2()
  112.     {
  113.         if($this->training->getNbrYears()>=2 && $this->getSchoolyear1() != null) return $this->getSchoolyear1()->getNext();
  114.         else return null;
  115.     }
  118.     public function getSchoolyear3()
  119.     {
  120.         if($this->training->getNbrYears()>=3 && $this->getSchoolyear2() != null) return $this->getSchoolyear2()->getNext();
  121.         else return null;
  122.     }
  125.     public function addTrainee(Trainee $trainee)
  126.     {
  127.         $trainee->setGroupe($this);
  128.         $this->trainees[] = $trainee;
  130.         return $this;
  131.     }
  133.     public function removeTrainee(Trainee $trainee)
  134.     {
  135.         $this->trainees->removeElement($trainee);
  136.     }
  138.     public function getTrainees()
  139.     {
  140.         return $this->trainees;
  141.     }
  144.     public function getNbrTrainees(){
  145.         $n=0;
  146.         /** @var Trainee $trainee */
  147.         foreach ($this->trainees as $trainee){
  148.             if($trainee->getStatus()!="Abandonné") $n++;
  149.         }
  150.         return $n;
  151.     }
  152.     public function getNbrAbandonnes(){
  153.         $n=0;
  154.         /** @var Trainee $trainee */
  155.         foreach ($this->trainees as $trainee){
  156.             if($trainee->getStatus()=="Abandonné") $n++;
  157.         }
  158.         return $n;
  159.     }
  161.     public function addAssignation(Assignation $assignation)
  162.     {
  163.         $assignation->setGroupe($this);
  164.         $this->assignations[] = $assignation;
  166.         return $this;
  167.     }
  169.     public function removeAssignation(Assignation $assignation)
  170.     {
  171.         $this->assignations->removeElement($assignation);
  172.     }
  174.     public function getAssignations()
  175.     {
  176.         return $this->assignations;
  177.     }
  179.     public function getAssignationByModule(Module $module)
  180.     {
  181.         foreach ($this->assignations as $assignation){
  182.             if($assignation->getModule()==$module){
  183.                 return $assignation;
  184.             }
  185.         }
  186.         return null;
  187.     }
  188.     public function addSchedule(Schedule $schedule)
  189.     {
  190.         $schedule->setGroupe($this);
  191.         $this->schedules[] = $schedule;
  193.         return $this;
  194.     }
  196.     public function removeSchedule(Schedule $schedule)
  197.     {
  198.         $this->schedules->removeElement($schedule);
  199.     }
  201.     public function getSchedules()
  202.     {
  203.         return $this->schedules;
  204.     }
  206.     public function getResponsable(): ?User
  207.     {
  208.         return $this->responsable;
  209.     }
  211.     public function setResponsable(?User $responsable): void
  212.     {
  213.         $this->responsable = $responsable;
  214.     }
  216.     public function getOthersGroupes(){
  217.         $groupes=[];
  218.         foreach ($this->getTraining()->getGroupesBySY($this->getSchoolyear1()) as $groupe){
  219.             if($groupe !== $this) $groupes[] = $groupe;
  220.         }
  221.         return $groupes;
  223.     }
  224.     public function getNum()
  225.     {
  227.     }
  228.     public function getLabel(){
  229.         $i=1;
  230.         foreach ($this->getTraining()->getGroupesBySY($this->getSchoolyear1()) as $groupe){
  231.             if($groupe->getId()<$this->getId()) $i++;
  232.         }
  233.         $label=count($this->getTraining()->getGroupesBySY($this->getSchoolyear1()))>1?' G'.$i:'';
  234.         return $this->training->getAbbreviation().' '.$label;
  235.     }
  236.     public function getDiplome(){
  237.         return $this->getTraining()->getDiploma();
  238.     }
  239.     public function getActionsS($actionsItems=[])
  240.     {
  241.         $actions="<div class='btn-group'>" .
  242.             "<button type='button' class='btn btn-default btn-flat dropdown-toggle' data-toggle='dropdown' aria-expanded='false'>" .
  243.             "<span class='fa fa-ellipsis-v'></span>" .
  244.             "<span class='sr-only'>Toggle Dropdown</span>" .
  245.             "</button>" .
  246.             "<ul class='dropdown-menu dropdown-menu-right' role='menu'>";
  247.         if(in_array('edit',$actionsItems))
  248.         $actions.="<li><a title='Modifier' class='action' target='_self' href='javascript:void(0)' data-id='".$this->id."' data-route='".$this->getRoute('edit')."'>"
  249.             ."<i class='fa text-warning fa-fw fa-edit'></i> Modifier</a></li>";
  250.         if(in_array('show',$actionsItems))
  251.             $actions.="<li><a title='Afficher' class='action' target='_self' href='javascript:void(0)' data-id='".$this->id."' data-route='".$this->getRoute('show')."'>"
  252.             ."<i class='fa text-info fa-fw fa-eye'></i> Afficher</a></li>";
  253.         if(in_array('remove',$actionsItems))
  254.             $actions.="<li><a title='Supprimer ?' 
  255.                 data-toggle='confirmation'
  256.                 data-btn-ok-label='Supprimer' 
  257.                 data-btn-ok-icon='glyphicon glyphicon-ok'
  258.                 data-btn-ok-class='btn-success'
  259.                 data-btn-cancel-label='Annuler' 
  260.                 data-btn-cancel-icon='glyphicon glyphicon-remove'
  261.                 data-btn-cancel-class='btn-danger'
  262.                 data-title='Supprimer ?'
  263.                 data-popout='true'
  264.                 data-content='Voulez-vous vraiment supprimer cet élément ?' 
  265.                 class='action' target='_self' href='javascript:void(0)' data-id='".$this->id."' data-route='".$this->getRoute('remove')."'>"
  266.             ."<i class='fa text-red fa-fw fa-trash-o'></i> Supprimer</a></li>";
  267.         if(in_array('add_trainee',$actionsItems))
  268.             $actions.="<li><a title='Ajouter un nouveau stagiaire' class='action' target='_self' href='javascript:void(0)' data-id='".$this->id."' data-route='hs_training_center_trainee_new'>"
  269.             ."<i class='fa text-success fa-fw fa-plus'></i> Stagiaire</a></li>";
  270.         $actions.="</ul></div>";
  271.         return $actions;
  272.     }
  273.     public function getYears(){
  274.         return $this->getSchoolyear1()->getFirstYear().'-'.($this->getSchoolyear1()->getFirstYear()+$this->getTraining()->getNbrYears());
  275.     }
  276.     public function getFirstYear(){
  277.         return $this->schoolyear1;
  278.     }
  279.     public function getLastYear(){
  280.         if($this->getTraining()->getNbrYears()==3) return $this->getSchoolyear3();
  281.         elseif($this->getTraining()->getNbrYears()==2) return $this->getSchoolyear2();
  282.         return $this->schoolyear1;
  283.     }
  284.     public function getSecondYear(){
  285.         $first=intval(substr($this->schoolyear1->getTitle(),0,4));
  286.         if($this->training->getNbrYears()<2) return '-------';
  287.         else return ($first+1).'/'.($first+2);
  288.     }
  289.     public function getThirdYear(){
  290.         $first=intval(substr($this->schoolyear1->getTitle(),0,4));
  291.         if($this->training->getNbrYears()<3) return '-------';
  292.         else return ($first+2).'/'.($first+3);
  293.     }
  294.     public function getTrainingYear(Schoolyear $schoolyear){
  295.         if ($schoolyear===$this->schoolyear1) return 'first_year';
  296.         elseif($schoolyear===$this->getSchoolyear2()) return 'second_year';
  297.         elseif($schoolyear===$this->getSchoolyear3()) return 'third_year';
  298.         return "none";
  299.     }
  300.     public function getTrainingYearFr(Schoolyear $schoolyear){
  301.         if ($schoolyear===$this->schoolyear1) return '1ère année';
  302.         elseif($schoolyear===$this->getSchoolyear2()) return '2ème année';
  303.         elseif($schoolyear===$this->getSchoolyear3()) return '3ème année';
  304.         return " ";
  305.     }
  306.     public function geSchoolYear($ty){
  307.         if ($ty=='first_year') return $this->schoolyear1;
  308.         elseif($ty=='second_year') return $this->getSchoolyear2();
  309.         elseif($ty=='third_year') return $this->getSchoolyear3();
  310.         return null;
  311.     }
  312.     public function getTrainingYears(){
  313.         $sys=[$this->schoolyear1];
  314.         if($this->training->getNbrYears()>=2) $sys[]=$this->getSchoolyear2();
  315.         if($this->training->getNbrYears()>=3) $sys[]=$this->getSchoolyear3();
  316.         return $sys;
  317.     }
  318.     public function getSchoolYearByMonth($month){
  319.         $sy=null;
  320.         foreach ($this->getTrainingYears() as $schoolyear){
  321.             $level=$this->getTrainingYear($schoolyear);
  322.             $months=$this->getMonthsByYear($level, 'number');
  323.             foreach ($months as $m) if($m==$month) $sy=$schoolyear;
  324.         }
  325.         return $sy;
  326.     }
  329.     public function isEncours(Schoolyear $schoolyear){
  330.         if(in_array($schoolyear, $this->getTrainingYears())) return true;
  331.         return false;
  332.     }
  334.     public function getMonths($format='long'): array
  335.     {
  336.         $mountsArray=[
  337.             '01'=>['number'=>'01','short'=>'Janv','long'=>'Janvier'],
  338.             '02'=>['number'=>'02','short'=>'Févr','long'=>'Février'],
  339.             '03'=>['number'=>'03', 'short'=>'Mars','long'=>'Mars'],
  340.             '04'=>['number'=>'04', 'short'=>'Avr','long'=>'Avril'],
  341.             '05'=>['number'=>'05','short'=>'Mai','long'=>'Mai'],
  342.             '06'=>['number'=>'06','short'=>'Juin','long'=>'Juin'],
  343.             '07'=>['number'=>'07', 'short'=>'Juil','long'=>'Juillet'],
  344.             '08'=>['number'=>'08', 'short'=>'Aout','long'=>'Août'],
  345.             '09'=>['number'=>'09', 'short'=>'Sept','long'=>'Septembre'],
  346.             '10'=>['number'=>'10','short'=>'Oct','long'=>'Octobre'],
  347.             '11'=>['number'=>'11','short'=>'Nov','long'=>'Novembre'],
  348.             '12'=> ['number'=>'12','short'=>'Déc','long'=>'Décembre'],
  349.         ];
  350.         if($format=='short') {
  351.             $sep=" ";
  352.             $yearformat='y';
  353.         }
  354.         elseif($format=='long') {
  355.             $sep=" ";
  356.             $yearformat='Y';
  357.         }
  358.         else {
  359.             $sep="/";
  360.             $yearformat='y';
  361.         }
  362.         $months = [];
  363.         $start = $this->getStartAt();
  364.         $end = $this->getEndAt();
  365.         $interval = DateInterval::createFromDateString('1 month');
  366.         $period = new DatePeriod($start, $interval, $end);
  368.         foreach ($period as $date) {
  369.             $month = $date->format('m');
  370.             if(in_array($month, $this->getTraining()->getListMonths())){
  371.                 $monthName=$mountsArray[$month][$format];
  372.                 $year= $date->format($yearformat);
  373.                 $months[] = $monthName.$sep.$year;
  374.             }
  375.         }
  377.         return $months;
  378.     }
  379.     public function getMonthsByYear(string $year, $format='long'){
  380.         if($year=='third_year') $n=2;
  381.         elseif($year=='second_year') $n=1;
  382.         elseif ($year=='first_year') $n=0;
  383.         else return $this->getMonths($format);
  384.         return array_slice($this->getMonths($format), $n*count($this->getTraining()->getListMonths()), count($this->getTraining()->getListMonths()));
  385.     }
  387.     public function getMonth($index, $format='long'){
  388.         $mounts=$this->getMonths($format);
  389.         return $index>=0?$mounts[$index]:null;
  390.     }
  391.     public function getIndexMonth($month){
  392.         if(array_search($month,$this->getMonths())) return array_search($month,$this->getMonths());
  393.         elseif(array_search($month,$this->getMonths('short'))) return array_search($month,$this->getMonths('short'));
  394.         else return array_search($month,$this->getMonths('number'));
  395.     }
  396.     public function getShortMonth($m){
  397.         return $this->getMonth($this->getIndexMonth($m),'short');
  398.     }
  399.     public function getCurrent($format='long'){
  400.         // date_default_timezone_set('Africa/Casablanca');
  401.         $now=new \DateTime('now');
  402.         $endAt= clone $this->schoolyear1->getEndAt();
  403.         $endAt->modify('+1 years');
  404.         if($now<$this->schoolyear1->getStartAt()) return 'before';
  405.         elseif($now>$endAt) return 'after';
  406.         elseif($now->format('m')=='08' || $now->format('m')=='09') $mc='07/'.$now->format('y');
  407.         else $mc=$now->format('m/y');
  408.         $index=array_search($mc, $this->getMonths('number'));
  409.         return $this->getMonth($index, $format);
  410.     }
  411.     public function getMonthsPassed($format='long'){
  412.         if ($this->getCurrent('number')=='before') return [];
  413.         elseif ($this->getCurrent('number')=='after') return $this->getMonths($format);
  414.         else{
  415.             $index=array_search($this->getCurrent('number'), $this->getMonths('number'));
  416.             $paased=[];
  417.             for($i=0; $i<=$index; $i++){
  418.                 $paased[]=$this->getMonths($format)[$i];
  419.             }
  420.             return $paased;
  421.         }
  422.     }
  423.     public function getMonthsPassedByYear($year, $format='long'){
  424.         if ($this->getCurrent('number')=='before') return [];
  425.         elseif ($this->getCurrent('number')=='after') return $this->getMonthsByYear($year, $format);
  426.         else{
  427.             $index=array_search($this->getCurrent('number'), $this->getMonthsByYear($year, $format));
  428.             $paased=[];
  429.             for($i=0; $i<=$index; $i++){
  430.                 $paased[]=$this->getMonthsByYear($year, $format)[$i];
  431.             }
  432.             return $paased;
  433.         }
  434.     }
  435.     public function getStatutMonth($index){
  436.         if($this->getCurrent('number')==$index){
  437.             return 'current';
  438.         }
  439.         elseif($this->getCurrent('number')>$index){
  440.             return 'passed';
  441.         }
  442.         else return 'coming';
  443.     }
  444.     public function getBgClass($m){
  445.         $m=$this->getMonth($this->getIndexMonth($m), 'short');
  446.         if($this->getCurrent('short')==$m){
  447.             return 'bg-yellow';
  448.         }
  449.         elseif(in_array($m,$this->getMonthsPassed('short'),true)){
  450.             return 'bg-red';
  451.         }
  452.         else return 'bg-gray';
  453.     }
  455.     public function __toString(): string
  456.     {
  457.         return $this->training->getAbbreviation().' '.$this->getYears();
  458.     }
  459.     public function getAbreviation(Schoolyear $schoolyear){
  460.         $i=1;
  461.         foreach ($this->getTraining()->getGroupesBySY($this->getSchoolyear1()) as $groupe){
  462.             if($groupe->getId()<$this->getId()) $i++;
  463.         }
  464.         $nbGroupe=count($this->getTraining()->getGroupesBySY($this->getSchoolyear1()))>1?' G'.$i:'';
  466.         if($this->getTraining()->getNbrYears()>1){
  467.             $level=match($this->getTrainingYear($schoolyear)){
  468.                 'first_year' => '1',
  469.                 'second_year' => '2',
  470.                 'third_year' => '3',
  471.             };
  472.         }
  473.         else $level='';
  475.         return $this->training->getAbbreviation().$level.$nbGroupe;
  476.     }
  477.     public function getTraineesSorted($note){
  478.         $items=$this->getTrainees()->toArray();
  479.         usort($items,[$this, $note]);
  480.         return $items;
  481.     }
  482.     public function getTraineesSortedByAbsence($nombre, $startAt, $endAt){
  483.         // Récupérer tous les stagiaires
  484.         $trainees = $this->getTrainees();
  486.         $traineeAbsences = [];
  487.         /** @var Trainee $trainee */
  488.         foreach ($trainees as $trainee) {
  489.             // Compter les absences pour chaque stagiaire
  490.             if($trainee->getStatus()!="Abandonné")
  491.             $traineeAbsences[] = [
  492.                 'trainee' => $trainee,
  493.                 'absenceCount' => count($trainee->getAbsencesByPeriod($startAt, $endAt)),
  494.             ];
  495.         }
  496.         usort($traineeAbsences, function ($a, $b) {
  497.             return $b['absenceCount'] <=> $a['absenceCount'];
  498.         });
  501.         $top10Trainees = array_slice($traineeAbsences, 0, $nombre, true);
  503.         return array_column($top10Trainees, 'trainee');
  504.     }
  505.     public function getModulesSortedByAbsence($nombre, Schoolyear $schoolyear){
  506.         $assigns = $this->getAssignationsBySY($schoolyear);
  508.         $assignsAbsences = [];
  509.         /** @var Trainee $trainee */
  510.         foreach ($assigns as $assign) {
  511.             // Compter les absences pour chaque stagiaire
  512.             $assignsAbsences[] = [
  513.                 'assign' => $assign,
  514.                 'absenceCount' => count($assign->getAbsences()),
  515.             ];
  516.         }
  517.         usort($assignsAbsences, function ($a, $b) {
  518.             return $b['absenceCount'] <=> $a['absenceCount'];
  519.         });
  522.         $top10Assigns = array_slice($assignsAbsences, 0, $nombre, true);
  524.         return array_column($top10Assigns, 'assign');
  525.     }
  527.     public function getSeances(Schoolyear $schoolyear)
  528.     {
  529.         $allSeances = [];
  531.         foreach ($this->getAssignationsBySY($schoolyear) as $assign) {
  532.             $allSeances=array_merge($allSeances, $assign->getSeances());
  533.         }
  534.         usort($allSeances, function($a, $b) {
  535.             $dateA = DateTime::createFromFormat('d-m-Y H:i', $a->getTakesplaceOn()->format('d-m-Y').' '.$a->getStartAt());
  536.             $dateB = DateTime::createFromFormat('d-m-Y H:i', $b->getTakesplaceOn()->format('d-m-Y').' '.$b->getStartAt());
  537.             return $dateA <=> $dateB;
  538.         });
  540.         return $allSeances;
  541.     }
  542.     public function getSeancesCancelled(Schoolyear $schoolyear)
  543.     {
  544.         $allSeances = [];
  545.         foreach ($this->getAssignationsBySY($schoolyear) as $assign) {
  546.             $allSeances=array_merge($allSeances, $assign->getSeancesCancelled());
  547.         }
  548.         usort($allSeances, function($a, $b) {
  549.             $dateA = DateTime::createFromFormat('d-m-Y H:i', $a['seanceDate'].' '.$a['scheduleitem']->getStartAt());
  550.             $dateB = DateTime::createFromFormat('d-m-Y H:i', $b['seanceDate'].' '.$b['scheduleitem']->getStartAt());
  551.             return $dateA <=> $dateB;
  552.         });
  553.         return $allSeances;
  554.     }
  555.     public function getSeancesNotCreate(Schoolyear $schoolyear)
  556.     {
  557.         $allSeances = [];
  558.         foreach ($this->getAssignationsBySY($schoolyear) as $assign) {
  559.             $allSeances=array_merge($allSeances, $assign->getSeancesNotCreate());
  560.         }
  561.         usort($allSeances, function($a, $b) {
  562.             $dateA = DateTime::createFromFormat('d-m-Y H:i', $a['seanceDate'].' '.$a['scheduleitem']->getStartAt());
  563.             $dateB = DateTime::createFromFormat('d-m-Y H:i', $b['seanceDate'].' '.$b['scheduleitem']->getStartAt());
  564.             return $dateA <=> $dateB;
  565.         });
  566.         return $allSeances;
  567.     }
  570.     function mg1(Trainee $a, Trainee $b)
  571.     {
  572.         return $b->getMG('first_year') <=> $a->getMG('first_year');
  573.     }
  574.     public function getFeesByMonth(Schoolyear $schoolyear){
  575.         $months=$this->getMonthsByYear($this->getTrainingYear($schoolyear), 'number');
  576.         $fees=[];
  577.         foreach ($months as $month) {
  578.             $toPay=0;
  579.             $pay=0;
  580.             $retard=0;
  581.             foreach ($this->getTrainees() as $trainee) {
  582.                 $fee=$trainee->getFeeByTypeNameSy('monthlyPayment', $month , $this->getTrainingYear($schoolyear));
  583.                 if ($fee==null) continue;
  584.                 $toPay+=$fee->getMontant();
  585.                 $pay+=$fee->amountPaied();
  586.                 $retard+=$fee->restToPay();
  587.             }
  588.             $fees[]=['month'=>(\DateTime::createFromFormat('d/m/y','01/'.$month))->format('Y-m-d') , 'toPay'=>$toPay, 'pay'=>$pay, 'retard'=>$retard ];
  589.         }
  590.         return $fees;
  591.     }
  592.     public function getToPay($type='all', $year=null)
  593.     {
  594.         $toPay=0;
  595.         foreach ($this->getTrainees() as $trainee) {
  596.             $toPay+=$trainee->getToPay($type, $year);
  597.         }
  598.         return $toPay;
  600.     }
  602.     public function getTotalFees($type, $year=null){
  603.         $pay=0;
  604.         foreach ($this->getTrainees() as $trainee) {
  605.             $pay+=$trainee->getTotalFees($type, $year);
  606.         }
  607.         return $pay;
  609.     }
  610.     public function getPay(){
  611.         $pay=0;
  612.         foreach ($this->getTrainees() as $trainee) {
  613.             $pay+=$trainee->getPay();
  614.         }
  615.         return $pay;
  616.     }
  617.     public function getTotalPay($fees, $year=null){
  618.         $pay=0;
  619.         foreach ($this->getTrainees() as $trainee) {
  620.             $pay+=$trainee->getTotalPay($fees, $year);
  621.         }
  622.         return $pay;
  623.     }
  624.     public function getRestPay($fees, $year=null)
  625.     {
  626.         $restPay=0;
  627.         foreach ($this->getTrainees() as $trainee) {
  628.             $restPay+=$trainee->getRestPay($fees, $year);
  629.         }
  630.         return $restPay;
  631.     }
  632.     public function getNbrRetard($fees, $year=null)
  633.     {
  634.         $nbr=0;
  635.         foreach ($this->getTrainees() as $trainee) {
  636.             $nbr=$trainee->getRestPay($fees, $year)>0?$nbr+1:$nbr;
  637.         }
  638.         return $nbr;
  639.     }
  640.     public function getAdvance($fees, $year=null)
  641.     {
  642.         $advence=0;
  643.         foreach ($this->getTrainees() as $trainee) {
  644.             $advence+=$trainee->getAdvance($fees, $year);
  645.         }
  646.         return $advence;
  647.     }
  649.     public function getAssignationsBySY(Schoolyear $schoolyear){
  650.         $level=$this->getTrainingYear($schoolyear);
  651.         $modules=$this->getTraining()->getModulesByLevel($level);
  652.         return $this->assignations->filter(function (Assignation $assignation) use ($modules) {
  653.             return $modules->contains($assignation->getModule());
  654.         });
  655.     }
  656.     public function getSpecialsTrainees()
  657.     {
  658.         $specialNumber=$this->docs!==null?explode(',',$this->docs):[];
  659.         $items=[];
  660.         /** @var Trainee $trainee */
  661.         foreach ($this->getTrainees() as $trainee) {
  662.             if(in_array($trainee->getRegNumber(), $specialNumber)) $items[]=$trainee;
  663.         }
  664.         return $items;
  665.     }
  667. }