1. <?php
3. namespace App\Controller;
5. use App\Entity\Intervention;
6. use App\Repository\InterventionRepository;
7. use App\Repository\LieuRepository;
8. use JpGraph\JpGraph;
9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
10. use Symfony\Component\HttpFoundation\Response;
11. use Symfony\Component\Routing\Annotation\Route;
13. use Amenadiel\JpGraph\Graph;
14. use Amenadiel\JpGraph\Plot;
15. use Amenadiel\JpGraph\Themes;
16. use App\Entity\Lieu;
17. use App\Entity\Position;
18. use App\Entity\Secteur;
19. use App\Repository\ClientRepository;
20. use App\Repository\FaclieuRepository;
21. use App\Repository\FactuRepository;
22. use App\Repository\InterfaitRepository;
23. use App\Repository\SecteurposiRepository;
24. use App\Repository\SecteurRepository;
25. use App\service\produitService;
26. use App\service\servicedivers;
27. use DateTimeImmutable;
28. use PhpParser\Node\Stmt\Foreach_;
29. use Symfony\Component\HttpFoundation\Request;
31. //require_once ('jpgraph/jpgraph.php');
32. //require_once ('jpgraph/jpgraph_bar.php');
33. #[Route('/graph', name: 'graph_')]
34. class GraphJpgraphController extends AbstractController
35. {
36.     #[Route('/inter/{id}/{pdf}', name: 'inter')]
37.     public function index(Intervention $intervention,string $pdf,LieuRepository $lieuRepository,InterfaitRepository $interfaitRepository,InterventionRepository $interventionRepository)
38.     {
39.         
40.         $servicedivers= new servicedivers();
41.         $lieu=$lieuRepository->getlieuid($intervention->getContrat());
42.         $dateini=date_timestamp_get($intervention->getdate());
43.         $moiact=date('n',$dateini);
44.         $inter=$interventionRepository->getInterventionIdcontrat($intervention->getContrat());
45.         $date=time();
46.            $d=[];
47.           //  $d[]=date('d/m/y',time());
48.             foreach ($inter as $k) {
49.                 $a=date_timestamp_get($k->getdate());
50.               //  $d[]=date('d/m/y',$a);
51.                 if($date>$a){
52.                     $date=$a;
53.                 }
54.             }
55.            // $d[]=date('d/m/y',$date);
56.            // $d[]=date('d/m/y',$dateini);
57.            //
58.             $moid=date('m',$dateini);
59.             $and=date('y',$dateini);
60.            // $d[]=$moid;
61.           //  $d[]=$and;
62.             $valdeb=$moid+($and*12);
63.            // $d[]=$valdeb;
64.         $moi=date('m',$date);
65.         $an=date('y',$date);
66.     //   $d[]=$moi;
67.       //  $d[]=$an;
68.             $valfin=$moi+($an*12);
69.             $moi=($valdeb-$valfin)+1;
70.             
71.            // $d[]=$valfin;
72.            // $d[]=$moi;
73.           $mod="deux";
74.             if($moi<=6){
75.                 $mod="6m";
76.             }elseif($moi<=12){
77.                 $mod="an";
78.             }
79.            
80.            // $d[]=$mod;
81.          //dd($d);
82. $anact=date('y',$dateini);
83. $anact++;
84. $anact--;
85.          
86. //$titre="intervention"." ".$numcontre;
87. $titre="intervention du ".date('d/m/y',date_timestamp_get($intervention->getdate()));
88. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
89. $i=11;
90. //echo $moiact."  nnn";
91. $moiact--;
92. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
93. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
94. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
95. $moisfini=array("","","","","","","","","","","","");
97. //$d[]=$moiact;
98. switch ($mod) {
99.     case "6m":
100.         while($i>=0){
101.             //    echo $mois[$moiact]."  nn";
102.             $moisfini[($i-1)]=$mois[$moiact];
103.             $a=$moiact+1;
104.             $moisanscol6[$i]=array($a,$anact,2);
105.             $moisanscol6[($i-1)]=array($a,$anact,1);
106.             $moiact--;
107.             if($moiact==-1){
108.                 $moiact=11;$anact--;
109.             }
110.             $i--;$i--;
111.         }
112.         break;
113.     case "an":
114. while($i>=0){
115.     //    echo $mois[$moiact]."  nn";
116.     $moisfini[$i]=$mois[$moiact];
117.     $a=$moiact+1;
118.     $moisanscol[$i]=array($a,$anact);
119.     $moiact--;
120.     if($moiact==-1){
121.         $moiact=11;$anact--;
122.     }
123.     $i--;
124. }
125.         break;
126.     default:
127.         //2 anx
128. while($i>=0){
129.     //    echo $mois[$moiact]."  nn";
130.     $moisfini[$i]=$mois[$moiact];
131.     $a=$moiact+1;
132.     $moisanscol[$i]=array($a,$anact);
133.     $moisanscolpres[$i]=array($a,($anact-1));
134.     $moiact--;
135.     if($moiact==-1){
136.         $moiact=11;$anact--;
137.     }
138.     $i--;
139. }
140.         break;
141. }
142. //$d[]=$moisfini;
143. //$d[]=$moisanscol;
144. //$d[]=$moisanscolpres;
145. //dd($d);
147. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
148. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
149. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
150. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
151. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
152. $data1ye=[0,0,0,0,0,0,0,0,0,0,0,0];
153. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
154. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
155. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
156. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
157. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
158. $data2ye=[0,0,0,0,0,0,0,0,0,0,0,0];
159. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
160. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
161. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$diver=0;
162. $produitser= new produitService();$datr=[];$da=0;
163. foreach ($inter as $re) {
164.    // dd($re);$da
165.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$diver=0;
166. $interfa=$interfaitRepository->getinterfait($re->getId());
167.     $datr[$da]=[];
168.     $datr[$da]['inter']=$re;
169.     $datr[$da]['interfait']=$interfa;$dat=[];
170. foreach ($interfa as $interfai) {
171. if($interfai->getClientfait()==0){}
172.     if($interfai->getinter()>=0){
173.         
174.    // $dat[]=["grigno"=>$interfai->getGrign(),"remi"=>$interfai->getRemit(),"reste"=>$interfai->getReste(),"chan"=>$interfai->getChan(),"conso"=>$interfai->getConso()];
176.   
178.    $grigno=$grigno+$interfai->getGrign();
179.     $remi=$remi+$interfai->getRemit();
180.     $reste=$reste+$interfai->getReste();
182.     $chan=$chan+$interfai->getChan();
183.     $diver=$diver+$interfai->getConso();
184. //$interfai->getProduit()
186.    
187. $conso=$conso+$produitser->getidvol($interfai->getProduit());
188.         $dat[]=["consot"=>$conso,"chan"=>$interfai->getChan(),"reste"=>$interfai->getReste(),"remi"=>$interfai->getRemit(),"conso"=>$interfai->getConso(),"prod"=>$interfai->getProduit(),"prod2"=>$produitser->getidvol($interfai->getProduit())];
189.         }
191.     } $dateinter=date_timestamp_get($re->getdate());
193.     $datr[$da]['date']=date('d/m/y',$dateinter);
194.     $datr[$da]['retour1']=$dat;
195.     $datr[$da]['retour']=["grigno"=>$grigno,"remi"=>$remi,"reste"=>$reste,"chan"=>$chan,"conso"=>$conso];
196.         for($i=0; $i<=11;$i++){
198.                    
199.             switch ($mod) {
200.                 case "6m":
201.                     
202.                    // dd($dateinter);
203.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
204.                         $day15=0;
205.                         $d=date('d',$dateinter);
206.                         //    echo $d." l ";
207.                         if(1<=$d && $d<=15){
208.         
209.                             $day15=1;
210.                         }elseif(16<=$d && $d<=31){
211.                             $day15=2;
212.                         }
213.                         //    echo $day15." l  ".$re['id']." ffff<br>";
214.         
215.                         if($moisanscol6[$i][2]==$day15){
216.                           
217.                                 $data1ya[$i]=$reste+$data1ya[$i];
218.                                 $data1yb[$i]=$grigno+$data1yb[$i];
219.                                 $data1yc[$i]=$remi+$data1yc[$i];
220.                          
221.                                 $data1yd[$i]=$chan+$data1yd[$i];
222.                                 $data1ye[$i]=$diver+$data1ye[$i];
223.                                 
224.         //echo $con1[$i];
225.                             $con1[$i]=$con1[$i]+$conso;
226.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
227.                                 }
228.                     }
229.                             
230.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
231.                     if($plushaut<=$a){
232.                         $plushaut=$a;}
233.                     if($plushautli<=$con1[$i]){
234.                         $plushautli=$con1[$i];}
235.                     break;
236.                 case "an":
237.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
238.                         
239.                         $data1ya[$i]=$reste+$data1ya[$i];
240.                         $data1yb[$i]=$grigno+$data1yb[$i];
241.                         $data1yc[$i]=$remi+$data1yc[$i];
242.                         
243.                         $data1yd[$i]=$chan+$data1yd[$i];
244.                         $data1ye[$i]=$diver+$data1ye[$i];
245.                         
246.         
247.                         $con1[$i]=$con1[$i]+$conso;
248.                     }
249.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
250.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
251.                     if($plushaut<=$a){
252.                         $plushaut=$a;}
253.                     if($plushautli<=$con1[$i]){
254.                         $plushautli=$con1[$i];}
255.                     break;
256.                 default:
257.                     //2 anx
258.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
259.                         
260.                             $data1ya[$i]=$reste+$data1ya[$i];
261.                             $data1yb[$i]=$grigno+$data1yb[$i];
262.                             $data1yc[$i]=$remi+$data1yc[$i];
263.                         
264.                             $data1yd[$i]=$chan+$data1yd[$i];
265.                             $data1ye[$i]=$diver+$data1ye[$i];
266.                         
267.                         $con1[$i]=$con1[$i]+$conso;
268.         
269.                     }
270.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
271.                         
272.                             $data2ya[$i]=$reste+$data2ya[$i];
273.                             $data2yb[$i]=$grigno+$data2yb[$i];
274.                             $data2yc[$i]=$remi+$data2yc[$i];
275.                         
276.                             $data2yd[$i]=$chan+$data2yd[$i];
277.                             $data2ye[$i]=$diver+$data2ye[$i];
278.                         
279.                             $con2[$i]=$con2[$i]+$conso;
280.                     }
281.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
282.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
283.                     if($plushaut<=$a){
284.                         $plushaut=$a;}
285.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
286.                     if($plushaut<=$a){
287.                         $plushaut=$a;}
288.                 if($plushautli<=$con1[$i]){
289.                         $plushautli=$con1[$i];}
290.                     if($plushautli<=$con2[$i]){
291.                         $plushautli=$con2[$i];}
292.                     break;
293.             }
294.         
295.         
296.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
297.         }
298.         $da++;
300. }
301. $datr[]=[$data1ya,$data1yb,$data1yc,$data1yd,$con1];
302. $datr[]=[$data2ya,$data2yb,$data2yc,$data2yd,$con2];
303. //dd($datr);
304. $plushautli=$plushautli+100;
305. $aacol=$servicedivers->grahi($plushautli);
306. $ak=$aacol*6;
307. //echo $aacol." b ";
308. //    echo $aacol2." ".$aava." <br>";
309. //echo $aacol."<br>".$aacol2;
310. $a3=array(0,0,0,0,0,0,0,0);
311. for($i=1;$i<=6;$i++){
312.     $a3[$i]=$aacol*$i;
313. }
314. $v=$plushaut/3;//valeur max
315. if($v>=1){
316. $vm=$plushautli/$v;//valeur divition
318. $con1[0]=$con1[0]/$vm;
319. $con1[1]=$con1[1]/$vm;
320. $con1[2]=$con1[2]/$vm;
321. $con1[3]=$con1[3]/$vm;
322. $con1[4]=$con1[4]/$vm;
323. $con1[5]=$con1[5]/$vm;
324. $con1[6]=$con1[6]/$vm;
325. $con1[7]=$con1[7]/$vm;
326. $con1[8]=$con1[8]/$vm;
327. $con1[9]=$con1[9]/$vm;
328. $con1[10]=$con1[10]/$vm;
329. $con1[11]=$con1[11]/$vm;
330. $con2[0]=$con2[0]/$vm;
331. $con2[1]=$con2[1]/$vm;
332. $con2[2]=$con2[2]/$vm;
333. $con2[3]=$con2[3]/$vm;
334. $con2[4]=$con2[4]/$vm;
335. $con2[5]=$con2[5]/$vm;
336. $con2[6]=$con2[6]/$vm;
337. $con2[7]=$con2[7]/$vm;
338. $con2[8]=$con2[8]/$vm;
339. $con2[9]=$con2[9]/$vm;
340. $con2[10]=$con2[10]/$vm;
341. $con2[11]=$con2[11]/$vm;}
345. $plushaut=$plushaut+100;
348. $aacol=$servicedivers->grahi($plushaut);
349. $aacol2=$aacol/2;
350. //    echo $aacol2." ".$aava." <br>";
351. //echo $aacol."<br>".$aacol2;
352. $a1=array(0,0,0,0,0,0,0,0);
353. $a2=array($aacol2,0,0,0,0,0,0);
354. for($i=1;$i<=6;$i++){
355.     $a1[$i]=$aacol*$i;
356.     $a2[$i]=$aacol2+($aacol*($i-1));
357. }
359. /*
361. switch ($mod) {
362.     case "6m":
363.     case "an":
364.          $con1=$servicedivers->aligngraph($con1);
365.         $b1plota = new Plot\BarPlot($data1ya);
366.         $b1plotb = new Plot\BarPlot($data1yb);
367.         $b1plotc = new Plot\BarPlot($data1yc);
368.         $b1plotd = new Plot\BarPlot($data1yd);
369.         $b1plot = new Plot\AccBarPlot(array($b1plotc,$b1plotd,$b1plotb,$b1plota));
370.         //$gbplot = new GroupBarPlot($b1plot);
371.         $lplot1 = new Plot\LinePlot($con1);
372.         $graph->Add($b1plot);
373.         $graph->AddY2($lplot1);
374.         break;
375.     default:
376.         $con2=$servicedivers->aligngraph($con2);
377.         $con1=$servicedivers->aligngraph($con1);
378.         $b1plota = new Plot\BarPlot($data1ya);
379.         $b1plotb = new Plot\BarPlot($data1yb);
380.         $b1plotc = new Plot\BarPlot($data1yc);
381.         $b1plotd = new Plot\BarPlot($data1yd);
382.         $b2plota = new Plot\BarPlot($data2ya);
383.         $b2plotb = new Plot\BarPlot($data2yb);
384.         $b2plotc = new Plot\BarPlot($data2yc);
385.         $b2plotd = new Plot\BarPlot($data2yd);
386.         $b1plot = new Plot\AccBarPlot(array($b1plotc,$b1plotd,$b1plotb,$b1plota));
387.         $b2plot = new Plot\AccBarPlot(array($b2plotc,$b2plotd,$b2plotb,$b2plota));
388.         $gbplot = new Plot\GroupBarPlot(array($b1plot,$b2plot));
389.         $lplot1 = new Plot\LinePlot($con1);
390.         $lplot2 = new Plot\LinePlot($con2);
392.         $graph->Add($gbplot);
394.         $graph->AddY2($lplot1);
395.         $graph->AddY2($lplot2);
396.         break;
397. }
399. */
402. //dd($data1ya);
403. // Create the graph.
404. $graph    = new Graph\Graph(700, 350);
405. $graph->SetScale('textlin');
406. $graph->SetMarginColor('white');
407. $graph->yaxis->SetTickPositions($a1,$a2);
408. //$graph->y2axis->SetTickPositions($a3);
409. $graph->SetBox(false);
410. // Setup title
411. $graph->title->Set($titre);
413. // Create the first bar
414. switch ($mod) {
415.        default:
416.        $bplotb = new Plot\BarPlot($data2ya);
417.        $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
418.        $bplotb->SetColor("#239B56");
419.        $bplotb->SetLegend("asia");
420.        
421.        // Create the second bar
422.        $bplot2b = new Plot\BarPlot($data2yb);
423.        $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
424.        $bplot2b->SetColor("#C0392B");
425.        $bplot2b->SetLegend("euro ");
426.        $bplot3b = new Plot\BarPlot($data2yc);
427.        $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
428.        $bplot3b->SetColor("#2874A6");
429.        $bplot3b->SetLegend("mouche");
430.        $bplot4b = new Plot\BarPlot($data2yd);
431.        $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
432.        $bplot4b->SetColor("#717D7E");/**/
433.        $bplot4b->SetLegend("papillon");
434.        $bplot5b = new Plot\BarPlot($data2ye);
435.        $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
436.        $bplot5b->SetColor("#717D7E");/**/
437.        $bplot5b->SetLegend("orien");
438.        
439.        
440.        
441.        // And join them in an accumulated bar
442.        
443.        // And join them in an accumulated bar
444.        $p2 = new Plot\LinePlot($con2);
445.        $p2->mark->SetType(MARK_FILLEDCIRCLE);
446.        $p2->mark->SetFillColor('green');
447.        $p2->mark->SetWidth(4);
448.        $p2->SetColor('yellow');
449.        $p2->SetCenter();
450.        $p2->SetLegend("prod");
451.        $bplot = new Plot\BarPlot($data1ya);
452.        $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
453.        $bplot->SetColor("#239B56");
454.        $bplot->SetLegend("asia ");
455.        // Create the second bar
456.        $bplot2 = new Plot\BarPlot($data1yb);
457.        $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
458.        $bplot2->SetColor("#C0392B");
459.        $bplot2->SetLegend("euro");
460.        $bplot3 = new Plot\BarPlot($data1yc);
461.        $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
462.        $bplot3->SetColor("#2874A6");
463.        $bplot3->SetLegend("mouche");
464.        $bplot4 = new Plot\BarPlot($data1yd);
465.        $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
466.        $bplot4->SetColor("#717D7E");
467.        $bplot4->SetLegend("papillon");/**/
468.        $bplot5 = new Plot\BarPlot($data1ye);
469.        $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
470.        $bplot5->SetColor("#717D7E");
471.        $bplot5->SetLegend("orien");/**/
472.        
473.        $p1 = new Plot\LinePlot($con1);
474.        $p1->mark->SetType(MARK_FILLEDCIRCLE);
475.        $p1->mark->SetFillColor('blue');
476.        $p1->mark->SetWidth(4);
477.        $p1->SetColor('blue');
478.        $p1->SetCenter();
479.        $p1->SetLegend("prod");;
480.     
481.        
484. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
485. $accbplotb = new Plot\AccBarPlot([ $bplot5b,$bplot4b,$bplot3b,$bplot2b,$bplotb]);
486. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
487. //$graph->Add($accbplot);
488. $graph->Add($bar);
489. $graph->Add($p1);
490. $graph->Add($p2);
491. break;
492.     case "6m":
493.         case "an":
494.             $bplot = new Plot\BarPlot($data1ya);
495.             $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
496.             $bplot->SetColor("#239B56");
497.             $bplot->SetLegend("asia ");
498.             // Create the second bar
499.             $bplot2 = new Plot\BarPlot($data1yb);
500.             $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
501.             $bplot2->SetColor("#C0392B");
502.             $bplot2->SetLegend("euro");
503.             $bplot3 = new Plot\BarPlot($data1yc);
504.             $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
505.             $bplot3->SetColor("#2874A6");
506.             $bplot3->SetLegend("mouche");
507.             $bplot4 = new Plot\BarPlot($data1yd);
508.             $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
509.             $bplot4->SetColor("#717D7E");
510.             $bplot4->SetLegend("papillon");/**/
511.             $bplot5 = new Plot\BarPlot($data1ye);
512.             $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
513.             $bplot5->SetColor("#717D7E");
514.             $bplot5->SetLegend("orien");/**/
515.             
516.             $p1 = new Plot\LinePlot($con1);
517.             $p1->mark->SetType(MARK_FILLEDCIRCLE);
518.             $p1->mark->SetFillColor('blue');
519.             $p1->mark->SetWidth(4);
520.             $p1->SetColor('blue');
521.             $p1->SetCenter();
522.             $p1->SetLegend("prod");;
524. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
526. $graph->Add($accbplot);
527. $graph->Add($p1);
528. break;
529.         }
530. //dd($con1);
531. $graph->SetMargin(40,20,46,80);
532. $graph->xaxis->SetTickLabels($moisfini);
534. if($pdf=="oui"){
535.     switch ($mod) {
536.         case "6m":
537.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."grapmois.png";
538.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."grapmois.png";
539.             break;
540.         case "an":
541.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."grapan.png";
542.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."grapan.png";
543.             break;
544.         default:
545.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."grap2an.png";
546.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."grap2an.png";
547.             break;
548.     }
549.     if(file_exists($fichiergrah)){
550.         unlink($fichiergrah) ;
551.     }
552.     $graph->Stroke($fichiergrah);
553.   //  dd($fichiergrah);
554. return $fichiergrah;
555.     }else{
556.     $graph->Stroke();
557.     }
560. //$graph->Stroke();
561.       /*  return $this->render('graph_jpgraph/index.html.twig', [
562.             'controller_name' => 'GraphJpgraphController',
563.         ]);*/
564.     }
565.     #[Route('/secteur/{id}/{ids}/{pdf}', name: 'secteur')]
566.     public function secteur(Secteur $secteur,
567.     string $ids,
568.     string $pdf,
569.     LieuRepository $lieuRepository,
570.     InterfaitRepository $interfaitRepository,
571.     InterventionRepository $interventionRepository,
572.     SecteurposiRepository $secteurposiRepository,
573.     )
574.     {
575.         
576.         $intervention=$interventionRepository->find($ids);   
577.         $servicedivers= new servicedivers();
578.         $lieu=$lieuRepository->getlieuid($intervention->getContrat());
579.         $dateini=date_timestamp_get($intervention->getdate());
580.         $moiact=date('n',$dateini);
581.         $inter=$interventionRepository->getInterventionIdcontrat($intervention->getContrat());
582.         $date=time();
583.            $d=[];
584.           //  $d[]=date('d/m/y',time());
585.             foreach ($inter as $k) {
586.                 $a=date_timestamp_get($k->getdate());
587.               //  $d[]=date('d/m/y',$a);
588.                 if($date>$a){
589.                     $date=$a;
590.                 }
591.             }
592.            // $d[]=date('d/m/y',$date);
593.            // $d[]=date('d/m/y',$dateini);
594.            //
595.             $moid=date('m',$dateini);
596.             $and=date('y',$dateini);
597.            // $d[]=$moid;
598.           //  $d[]=$and;
599.             $valdeb=$moid+($and*12);
600.            // $d[]=$valdeb;
601.         $moi=date('m',$date);
602.         $an=date('y',$date);
603.     //   $d[]=$moi;
604.       //  $d[]=$an;
605.             $valfin=$moi+($an*12);
606.             $moi=($valdeb-$valfin)+1;
607.             
608.            // $d[]=$valfin;
609.            // $d[]=$moi;
610.           $mod="deux";
611.             if($moi<=6){
612.                 $mod="6m";
613.             }elseif($moi<=12){
614.                 $mod="an";
615.             }
616.            // $d[]=$mod;
617.         // dd($d);
618. $anact=date('y',$dateini);
619. $anact++;
620. $anact--;
621.          
622. //$titre="intervention"." ".$numcontre;
623. $titre="secteur ".$secteur->getSecteur()." : intervention du ".date('d/m/y',date_timestamp_get($intervention->getdate()));
624. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
625. $i=11;
626. //echo $moiact."  nnn";
627. $moiact--;
628. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
629. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
630. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
631. $moisfini=array("","","","","","","","","","","","");
633. //$d[]=$moiact;
634. switch ($mod) {
635.     case "6m":
636.         while($i>=0){
637.             //    echo $mois[$moiact]."  nn";
638.             $moisfini[($i-1)]=$mois[$moiact];
639.             $a=$moiact+1;
640.             $moisanscol6[$i]=array($a,$anact,2);
641.             $moisanscol6[($i-1)]=array($a,$anact,1);
642.             $moiact--;
643.             if($moiact==-1){
644.                 $moiact=11;$anact--;
645.             }
646.             $i--;$i--;
647.         }
648.         break;
649.     case "an":
650. while($i>=0){
651.     //    echo $mois[$moiact]."  nn";
652.     $moisfini[$i]=$mois[$moiact];
653.     $a=$moiact+1;
654.     $moisanscol[$i]=array($a,$anact);
655.     $moiact--;
656.     if($moiact==-1){
657.         $moiact=11;$anact--;
658.     }
659.     $i--;
660. }
661.         break;
662.     default:
663.         //2 anx
664. while($i>=0){
665.     //    echo $mois[$moiact]."  nn";
666.     $moisfini[$i]=$mois[$moiact];
667.     $a=$moiact+1;
668.     $moisanscol[$i]=array($a,$anact);
669.     $moisanscolpres[$i]=array($a,($anact-1));
670.     $moiact--;
671.     if($moiact==-1){
672.         $moiact=11;$anact--;
673.     }
674.     $i--;
675. }
676.         break;
677. }
678. //$d[]=$moisfini;
679. //$d[]=$moisanscol;
680. //dd($d);
682. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
683. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
684. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
685. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
686. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
687. $data1ye=[0,0,0,0,0,0,0,0,0,0,0,0];
688. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
689. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
690. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
691. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
692. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
693. $data2ye=[0,0,0,0,0,0,0,0,0,0,0,0];
694. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
695. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
696. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$divers=0;
697. $produitser= new produitService();$datr=[];$da=0;
698. foreach ($inter as $re) {
699.    // dd($re);$da
700.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$divers=0;
701. $interfa=$interfaitRepository->getinterfait($re->getId());
702.     $datr[$da]=[];
703.     $datr[$da]['inter']=$re;
704.     $datr[$da]['interfait']=$interfa;
705. foreach ($interfa as $interfai) {
706.     if ($secteurposiRepository->valPosiSecteur($interfai->getPosi(),$secteur->getId())) {
707. if($interfai->getClientfait()==0){}
708.     if($interfai->getinter()>=0){
709.   
710.             $prod =$interfai->getProduit();
711.         
712.     $grigno=$grigno+$interfai->getGrign();
713.     $remi=$remi+$interfai->getRemit();
714.     $reste=$reste+$interfai->getReste();
715.      
716.     $chan=$chan+$interfai->getChan();
717.     $divers=$divers+$interfai->getConso();    
718.     $conso=$conso+$produitser->getidvol($interfai->getProduit());
719.         }
720.     }
721.     } $dateinter=date_timestamp_get($re->getdate());
722.     $datr[$da]['date']=date('d/m/y',$dateinter);
723.         for($i=0; $i<=11;$i++){
725.                    
726.             switch ($mod) {
727.                 case "6m":
728.                     
729.                    // dd($dateinter);
730.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
731.                         $day15=0;
732.                         $d=date('d',$dateinter);
733.                         //    echo $d." l ";
734.                         if(1<=$d && $d<=15){
735.         
736.                             $day15=1;
737.                         }elseif(16<=$d && $d<=31){
738.                             $day15=2;
739.                         }
740.                         //    echo $day15." l  ".$re['id']." ffff<br>";
741.         
742.                         if($moisanscol6[$i][2]==$day15){
743.                        
744.                                 $data1ya[$i]=$reste+$data1ya[$i];
745.                                 $data1yb[$i]=$grigno+$data1yb[$i];
746.                                 $data1yc[$i]=$remi+$data1yc[$i];
747.                            
748.                                 $data1yd[$i]=$chan+$data1yd[$i];
749.                                 $data1ye[$i]=$divers+$data1ye[$i];
750.                             
751.         //echo $con1[$i];
752.                             $con1[$i]=$con1[$i]+$conso;
753.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
754.                                 }
755.                     }
756.                             
757.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
758.                     if($plushaut<=$a){
759.                         $plushaut=$a;}
760.                     if($plushautli<=$con1[$i]){
761.                         $plushautli=$con1[$i];}
762.                     break;
763.                 case "an":
764.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
765.                         
766.                         $data1ya[$i]=$reste+$data1ya[$i];
767.                         $data1yb[$i]=$grigno+$data1yb[$i];
768.                         $data1yc[$i]=$remi+$data1yc[$i];
769.                         
770.                         $data1yd[$i]=$chan+$data1yd[$i];
771.                         $data1ye[$i]=$divers+$data1ye[$i];
772.                         
773.         
774.                         $con1[$i]=$con1[$i]+$conso;
775.                     }
776.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
777.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
778.                     if($plushaut<=$a){
779.                         $plushaut=$a;}
780.                     
781.                     if($plushautli<=$con1[$i]){
782.                         $plushautli=$con1[$i];}
783.                     break;
784.                 default:
785.                     //2 anx
786.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
787.                         
788.                             $data1ya[$i]=$reste+$data1ya[$i];
789.                             $data1yb[$i]=$grigno+$data1yb[$i];
790.                             $data1yc[$i]=$remi+$data1yc[$i];
791.                         
792.                             $data1yd[$i]=$chan+$data1yd[$i];
793.                             $data1ye[$i]=$divers+$data1ye[$i];
794.                         
795.                         $con1[$i]=$con1[$i]+$conso;
796.         
797.                     }
798.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
799.                         
800.                             $data2ya[$i]=$reste+$data2ya[$i];
801.                             $data2yb[$i]=$grigno+$data2yb[$i];
802.                             $data2yc[$i]=$remi+$data2yc[$i];
803.                        
804.                             $data2yd[$i]=$chan+$data2yd[$i];
805.                             $data2ye[$i]=$divers+$data2ye[$i];
806.                         
807.                             $con2[$i]=$con2[$i]+$conso;
808.                     }
809.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
810.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
811.                     if($plushaut<=$a){
812.                         $plushaut=$a;}
813.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
814.                     if($plushaut<=$a){
815.                         $plushaut=$a;}
816.                     
817.                     if($plushautli<=$con1[$i]){
818.                         $plushautli=$con1[$i];}
819.                     if($plushautli<=$con2[$i]){
820.                         $plushautli=$con2[$i];}
821.                     break;
822.             }
823.         
824.         
825.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
826.         }
827.         $da++;
829. }
830. $v=$plushaut/3;//valeur max
831. if($v>=1){
832. $vm=$plushautli/$v;//valeur divition
834. $con1[0]=$con1[0]/$vm;
835. $con1[1]=$con1[1]/$vm;
836. $con1[2]=$con1[2]/$vm;
837. $con1[3]=$con1[3]/$vm;
838. $con1[4]=$con1[4]/$vm;
839. $con1[5]=$con1[5]/$vm;
840. $con1[6]=$con1[6]/$vm;
841. $con1[7]=$con1[7]/$vm;
842. $con1[8]=$con1[8]/$vm;
843. $con1[9]=$con1[9]/$vm;
844. $con1[10]=$con1[10]/$vm;
845. $con1[11]=$con1[11]/$vm;
846. $con2[0]=$con2[0]/$vm;
847. $con2[1]=$con2[1]/$vm;
848. $con2[2]=$con2[2]/$vm;
849. $con2[3]=$con2[3]/$vm;
850. $con2[4]=$con2[4]/$vm;
851. $con2[5]=$con2[5]/$vm;
852. $con2[6]=$con2[6]/$vm;
853. $con2[7]=$con2[7]/$vm;
854. $con2[8]=$con2[8]/$vm;
855. $con2[9]=$con2[9]/$vm;
856. $con2[10]=$con2[10]/$vm;
857. $con2[11]=$con2[11]/$vm;}
858. //dd($datr);
859. $plushautli=$plushautli+100;
860. $aacol=$servicedivers->grahi($plushautli);
861. $ak=$aacol*6;
862. //echo $aacol." b ";
863. //    echo $aacol2." ".$aava." <br>";
864. //echo $aacol."<br>".$aacol2;
865. $a3=array(0,0,0,0,0,0,0,0);
866. for($i=1;$i<=6;$i++){
867.     $a3[$i]=$aacol*$i;
868. }
871. $plushaut=$plushaut+100;
874. $aacol=$servicedivers->grahi($plushaut);
875. $aacol2=$aacol/2;
876. //    echo $aacol2." ".$aava." <br>";
877. //echo $aacol."<br>".$aacol2;
878. $a1=array(0,0,0,0,0,0,0,0);
879. $a2=array($aacol2,0,0,0,0,0,0);
880. for($i=1;$i<=6;$i++){
881.     $a1[$i]=$aacol*$i;
882.     $a2[$i]=$aacol2+($aacol*($i-1));
883. }
887. $datay1 = [13, 8, 19, 7, 17, 6];
888. $datay2 = [4, 5, 2, 7, 5, 25];
889. //dd($data1ya);
890. // Create the graph.
891. $graph    = new Graph\Graph(700, 350);
892. $graph->SetScale('textlin');
893. $graph->SetMarginColor('white');
894. $graph->yaxis->SetTickPositions($a1,$a2);
895. //$graph->y2axis->SetTickPositions($a3);
896. $graph->SetBox(false);
897. // Setup title
898. $graph->title->Set($titre);
900. // Create the first bar
901. switch ($mod) {
902.        default:
903.      
904. $bplotb = new Plot\BarPlot($data2ya);
905. $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
906. $bplotb->SetColor("#239B56");
907. $bplotb->SetLegend("asia");
909. // Create the second bar
910. $bplot2b = new Plot\BarPlot($data2yb);
911. $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
912. $bplot2b->SetColor("#C0392B");
913. $bplot2b->SetLegend("euro ");
914. $bplot3b = new Plot\BarPlot($data2yc);
915. $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
916. $bplot3b->SetColor("#2874A6");
917. $bplot3b->SetLegend("mouche");
918. $bplot4b = new Plot\BarPlot($data2yd);
919. $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
920. $bplot4b->SetColor("#717D7E");/**/
921. $bplot4b->SetLegend("papillon");
922. $bplot5b = new Plot\BarPlot($data2ye);
923. $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
924. $bplot5b->SetColor("#717D7E");/**/
925. $bplot5b->SetLegend("orien");
929. // And join them in an accumulated bar
931. // And join them in an accumulated bar
932. $p2 = new Plot\LinePlot($con2);
933. $p2->mark->SetType(MARK_FILLEDCIRCLE);
934. $p2->mark->SetFillColor('green');
935. $p2->mark->SetWidth(4);
936. $p2->SetColor('yellow');
937. $p2->SetCenter();
938. $p2->SetLegend("prod");
939. $bplot = new Plot\BarPlot($data1ya);
940. $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
941. $bplot->SetColor("#239B56");
942. $bplot->SetLegend("asia ");
943. // Create the second bar
944. $bplot2 = new Plot\BarPlot($data1yb);
945. $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
946. $bplot2->SetColor("#C0392B");
947. $bplot2->SetLegend("euro");
948. $bplot3 = new Plot\BarPlot($data1yc);
949. $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
950. $bplot3->SetColor("#2874A6");
951. $bplot3->SetLegend("mouche");
952. $bplot4 = new Plot\BarPlot($data1yd);
953. $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
954. $bplot4->SetColor("#717D7E");
955. $bplot4->SetLegend("papillon");/**/
956. $bplot5 = new Plot\BarPlot($data1ye);
957. $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
958. $bplot5->SetColor("#717D7E");
959. $bplot5->SetLegend("orien");/**/
961. $p1 = new Plot\LinePlot($con1);
962. $p1->mark->SetType(MARK_FILLEDCIRCLE);
963. $p1->mark->SetFillColor('blue');
964. $p1->mark->SetWidth(4);
965. $p1->SetColor('blue');
966. $p1->SetCenter();
967. $p1->SetLegend("prod");;
969. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
970. $accbplotb = new Plot\AccBarPlot([$bplot5b, $bplot4b,$bplot3b,$bplot2b,$bplotb]);
972. //$graph->Add($accbplot);
973. //$graph->Add($accbplotb);
974. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
975. //$graph->Add($accbplot);
976. $graph->Add($bar);
977. $graph->Add($p1);
978. $graph->Add($p2);
979. break;
980.     case "6m":
981.         case "an":
982.             $bplot = new Plot\BarPlot($data1ya);
983.        $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
984.        $bplot->SetColor("#239B56");
985.        $bplot->SetLegend("asia ");
986.        // Create the second bar
987.        $bplot2 = new Plot\BarPlot($data1yb);
988.        $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
989.        $bplot2->SetColor("#C0392B");
990.        $bplot2->SetLegend("euro");
991.        $bplot3 = new Plot\BarPlot($data1yc);
992.        $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
993.        $bplot3->SetColor("#2874A6");
994.        $bplot3->SetLegend("mouche");
995.        $bplot4 = new Plot\BarPlot($data1yd);
996.        $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
997.        $bplot4->SetColor("#717D7E");
998.        $bplot4->SetLegend("papillon");/**/
999.        $bplot5 = new Plot\BarPlot($data1ye);
1000.        $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1001.        $bplot5->SetColor("#717D7E");
1002.        $bplot5->SetLegend("orien");/**/
1003.        
1004.        $p1 = new Plot\LinePlot($con1);
1005.        $p1->mark->SetType(MARK_FILLEDCIRCLE);
1006.        $p1->mark->SetFillColor('blue');
1007.        $p1->mark->SetWidth(4);
1008.        $p1->SetColor('blue');
1009.        $p1->SetCenter();
1010.        $p1->SetLegend("prod");;
1012. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
1014. $graph->Add($accbplot);
1015. $graph->Add($p1);
1016. break;
1017.         }
1018. //dd($con1);
1019. $graph->SetMargin(40,20,46,80);
1020. $graph->xaxis->SetTickLabels($moisfini);
1022. if($pdf=="oui"){
1023.     switch ($mod) {
1024.         case "6m":
1025.             $fichiergrah=$this->getParameter('grapph_directory')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grapmois.png";
1026.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grapmois.png";
1027.             break;
1028.         case "an":
1029.             $fichiergrah=$this->getParameter('grapph_directory')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grapan.png";
1030.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grapan.png";
1031.             break;
1032.         default:
1033.             $fichiergrah=$this->getParameter('grapph_directory')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grap2an.png";
1034.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."secteur".$secteur->getId()."-".$intervention->getId().uniqid()."grap2an.png";
1035.             break;
1036.     }
1037.     if(file_exists($fichiergrah)){
1038.         unlink($fichiergrah) ;
1039.     }
1040.     $graph->Stroke($fichiergrah);
1041. return $fichiergrah2;
1042.     }else{
1043.     $graph->Stroke();
1044.     }
1047. //$graph->Stroke();
1048.       /*  return $this->render('graph_jpgraph/index.html.twig', [
1049.             'controller_name' => 'GraphJpgraphController',
1050.         ]);*/
1051.     }
1055.     #[Route('/posi/{id}/{ids}/{pdf}', name: 'posi')]
1056.     public function posi(Position $position,
1057.     string $ids,
1058.     string $pdf,Request $request,
1059.     LieuRepository $lieuRepository,
1060.     InterfaitRepository $interfaitRepository,
1061.     InterventionRepository $interventionRepository,
1062.     SecteurposiRepository $secteurposiRepository,
1063.     )
1064.     {
1065.         
1067.         $posi1 = $request->query->getInt('posi1',0);
1068.         $posi2 = $request->query->getInt('posi2',0);
1069.         $posi3 = $request->query->getInt('posi3',0);
1070.         $posi4 = $request->query->getInt('posi4',0);
1071.         $posi5 = $request->query->getInt('posi5',0);
1072.         $posi6 = $request->query->getInt('posi6',0);
1073.         $posi7 = $request->query->getInt('posi7',0);
1074.         $posi8 = $request->query->getInt('posi8',0);
1075.         $posi9 = $request->query->getInt('posi9',0);
1076.         $posi10 = $request->query->getInt('posi10',0);
1077.         $posi11 = $request->query->getInt('posi11',0);
1078.         $posi12 = $request->query->getInt('posi12',0);
1079.         $posi13 = $request->query->getInt('posi13',0);
1080.         $posi14 = $request->query->getInt('posi14',0);
1081.         $posi15 = $request->query->getInt('posi15',0);
1082.         $posi16 = $request->query->getInt('posi16',0);
1083.         $posi17 = $request->query->getInt('posi17',0);
1084.         $posi18 = $request->query->getInt('posi18',0);
1085.         $posi19 = $request->query->getInt('posi19',0);
1086.         $posi=array();
1087.         $posi[]=$position->getId();
1088.         if($posi1!=0){$posi[]=$posi1;}
1089.         if($posi2!=0){$posi[]=$posi2;}
1090.         if($posi3!=0){$posi[]=$posi3;}
1091.         if($posi4!=0){$posi[]=$posi4;}
1092.         if($posi5!=0){$posi[]=$posi5;}
1093.         if($posi6!=0){$posi[]=$posi6;}
1094.         if($posi7!=0){$posi[]=$posi7;}
1095.         if($posi8!=0){$posi[]=$posi8;}
1096.         if($posi9!=0){$posi[]=$posi9;}
1097.         if($posi10!=0){$posi[]=$posi10;}
1098.         if($posi11!=0){$posi[]=$posi11;}
1099.         if($posi12!=0){$posi[]=$posi12;}
1100.         if($posi13!=0){$posi[]=$posi13;}
1101.         if($posi14!=0){$posi[]=$posi14;}
1102.         if($posi15!=0){$posi[]=$posi15;}
1103.         if($posi16!=0){$posi[]=$posi16;}
1104.         if($posi17!=0){$posi[]=$posi17;}
1105.         if($posi18!=0){$posi[]=$posi18;}
1106.         if($posi19!=0){$posi[]=$posi19;}
1107.         $intervention=$interventionRepository->find($ids);   
1108.         $servicedivers= new servicedivers();
1109.         $lieu=$lieuRepository->getlieuid($intervention->getContrat());
1110.         $dateini=date_timestamp_get($intervention->getdate());
1111.         $moiact=date('n',$dateini);
1112.         $inter=$interventionRepository->getInterventionIdcontrat($intervention->getContrat());
1113.         $date=time();
1114.            $d=[];
1115.           //  $d[]=date('d/m/y',time());
1116.             foreach ($inter as $k) {
1117.                 $a=date_timestamp_get($k->getdate());
1118.               //  $d[]=date('d/m/y',$a);
1119.                 if($date>$a){
1120.                     $date=$a;
1121.                 }
1122.             }
1123.            // $d[]=date('d/m/y',$date);
1124.            // $d[]=date('d/m/y',$dateini);
1125.            //
1126.             $moid=date('m',$dateini);
1127.             $and=date('y',$dateini);
1128.            // $d[]=$moid;
1129.           //  $d[]=$and;
1130.             $valdeb=$moid+($and*12);
1131.            // $d[]=$valdeb;
1132.         $moi=date('m',$date);
1133.         $an=date('y',$date);
1134.     //   $d[]=$moi;
1135.       //  $d[]=$an;
1136.             $valfin=$moi+($an*12);
1137.             $moi=($valdeb-$valfin)+1;
1138.             
1139.            // $d[]=$valfin;
1140.            // $d[]=$moi;
1141.           $mod="deux";
1142.             if($moi<=6){
1143.                 $mod="6m";
1144.             }elseif($moi<=12){
1145.                 $mod="an";
1146.             }
1147.            // $d[]=$mod;
1148.         // dd($d);
1149. $anact=date('y',$dateini);
1150. $anact++;
1151. $anact--;
1152.          
1153. //$titre="intervention"." ".$numcontre;
1154. $titre="position ".$position->getNumero();
1155. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
1156. $i=11;
1157. //echo $moiact."  nnn";
1158. $moiact--;
1159. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
1160. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
1161. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
1162. $moisfini=array("","","","","","","","","","","","");
1164. //$d[]=$moiact;
1165. switch ($mod) {
1166.     case "6m":
1167.         while($i>=0){
1168.             //    echo $mois[$moiact]."  nn";
1169.             $moisfini[($i-1)]=$mois[$moiact];
1170.             $a=$moiact+1;
1171.             $moisanscol6[$i]=array($a,$anact,2);
1172.             $moisanscol6[($i-1)]=array($a,$anact,1);
1173.             $moiact--;
1174.             if($moiact==-1){
1175.                 $moiact=11;$anact--;
1176.             }
1177.             $i--;$i--;
1178.         }
1179.         break;
1180.     case "an":
1181. while($i>=0){
1182.     //    echo $mois[$moiact]."  nn";
1183.     $moisfini[$i]=$mois[$moiact];
1184.     $a=$moiact+1;
1185.     $moisanscol[$i]=array($a,$anact);
1186.     $moiact--;
1187.     if($moiact==-1){
1188.         $moiact=11;$anact--;
1189.     }
1190.     $i--;
1191. }
1192.         break;
1193.     default:
1194.         //2 anx
1195. while($i>=0){
1196.     //    echo $mois[$moiact]."  nn";
1197.     $moisfini[$i]=$mois[$moiact];
1198.     $a=$moiact+1;
1199.     $moisanscol[$i]=array($a,$anact);
1200.     $moisanscolpres[$i]=array($a,($anact-1));
1201.     $moiact--;
1202.     if($moiact==-1){
1203.         $moiact=11;$anact--;
1204.     }
1205.     $i--;
1206. }
1207.         break;
1208. }
1209. //$d[]=$moisfini;
1210. //$d[]=$moisanscol;
1211. //dd($d);
1213. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
1214. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1215. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
1216. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1217. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
1218. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
1219. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1220. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
1221. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1222. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
1223. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
1224. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
1225. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$divers=0;
1226. $produitser= new produitService();$datr=[];$da=0;
1227. foreach ($inter as $re) {
1228.    // dd($re);$da
1229.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$divers=0;
1230. $interfa=$interfaitRepository->getinterfait($re->getId());
1232.     $datr[$da]=[];
1233.     $datr[$da]['inter']=$re;
1234.     $datr[$da]['interfait']=$interfa;
1235. foreach ($interfa as $interfai) {
1236.     $valider=0;
1237.     foreach ($posi as $posipp) {
1238.        if($posipp==$interfai->getPosi()){
1239.         $valider=1;
1240.        }
1241.     }
1242.     //if ($interfai->getPosi()==$position->getId()) {
1243.         if ($valider==1) {
1244. if($interfai->getClientfait()==0){}
1245.     if($interfai->getinter()>=0){
1246.      
1247.             $prod =$interfai->getProduit();
1248.         
1249.     $grigno=$grigno+$interfai->getGrign();
1250.     $remi=$remi+$interfai->getRemit();
1251.     $reste=$reste+$interfai->getReste();
1252.     
1253.     $chan=$chan+$interfai->getChan();
1254.     $divers=$divers+$interfai->getConso();
1256.     $conso=$conso+$produitser->getidvol($interfai->getProduit());
1257.         }
1258.     }
1259.     } $dateinter=date_timestamp_get($re->getdate());
1260.     $datr[$da]['date']=date('d/m/y',$dateinter);
1261.         for($i=0; $i<=11;$i++){
1263.                    
1264.             switch ($mod) {
1265.                 case "6m":
1266.                     
1267.                    // dd($dateinter);
1268.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
1269.                         $day15=0;
1270.                         $d=date('d',$dateinter);
1271.                         //    echo $d." l ";
1272.                         if(1<=$d && $d<=15){
1273.         
1274.                             $day15=1;
1275.                         }elseif(16<=$d && $d<=31){
1276.                             $day15=2;
1277.                         }
1278.                         //    echo $day15." l  ".$re['id']." ffff<br>";
1279.         
1280.                         if($moisanscol6[$i][2]==$day15){
1281.                        
1282.                                 $data1ya[$i]=$reste+$data1ya[$i];
1283.                                 $data1yb[$i]=$grigno+$data1yb[$i];
1284.                                 $data1yc[$i]=$remi+$data1yc[$i];
1285.                            
1286.                                 $data1yd[$i]=$chan+$data1yd[$i];
1287.                                 $data1ye[$i]=$divers+$data1yd[$i];
1288.                             
1289.         //echo $con1[$i];
1290.                             $con1[$i]=$con1[$i]+$conso;
1291.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
1292.                                 }
1293.                     }
1294.                             
1295.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i];
1296.                     if($plushaut<=$a){
1297.                         $plushaut=$a;}
1298.                     if($plushautli<=$con1[$i]){
1299.                         $plushautli=$con1[$i];}
1300.                     break;
1301.                 case "an":
1302.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
1303.                         
1304.                         $data1ya[$i]=$reste+$data1ya[$i];
1305.                         $data1yb[$i]=$grigno+$data1yb[$i];
1306.                         $data1yc[$i]=$remi+$data1yc[$i];
1307.                         
1308.                         $data1yd[$i]=$chan+$data1yd[$i];
1309.                         $data1ye[$i]=$divers+$data1yd[$i];
1310.                         
1311.         
1312.                         $con1[$i]=$con1[$i]+$conso;
1313.                     }
1314.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
1315.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
1316.                     if($plushaut<=$a){
1317.                         $plushaut=$a;}
1318.                     if($plushautli<=$con1[$i]){
1319.                         $plushautli=$con1[$i];}
1320.                     break;
1321.                 default:
1322.                     //2 anx
1323.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
1324.                         
1325.                             $data1ya[$i]=$reste+$data1ya[$i];
1326.                             $data1yb[$i]=$grigno+$data1yb[$i];
1327.                             $data1yc[$i]=$remi+$data1yc[$i];
1328.                         
1329.                             $data1yd[$i]=$chan+$data1yd[$i];
1330.                             $data1ye[$i]=$divers+$data1yd[$i];
1331.                         
1332.                         $con1[$i]=$con1[$i]+$conso;
1333.         
1334.                     }
1335.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
1336.                         
1337.                             $data2ya[$i]=$reste+$data2ya[$i];
1338.                             $data2yb[$i]=$grigno+$data2yb[$i];
1339.                             $data2yc[$i]=$remi+$data2yc[$i];
1340.                        
1341.                             $data2yd[$i]=$chan+$data2yd[$i];
1342.                             $data2ye[$i]=$divers+$data2yd[$i];
1343.                         
1344.                             $con2[$i]=$con2[$i]+$conso;
1345.                     }
1346.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
1347.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
1348.                     if($plushaut<=$a){
1349.                         $plushaut=$a;}
1350.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
1351.                     if($plushaut<=$a){
1352.                         $plushaut=$a;}
1353.                     if($plushautli<=$con1[$i]){
1354.                         $plushautli=$con1[$i];}
1355.                     if($plushautli<=$con2[$i]){
1356.                         $plushautli=$con2[$i];}
1357.                     break;
1358.             }
1359.         
1360.         
1361.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
1362.         }
1363.         $da++;
1365. }
1367. $v=$plushaut/3;//valeur max
1368. if($v>=1){
1369. $vm=$plushautli/$v;//valeur divition
1371. $con1[0]=$con1[0]/$vm;
1372. $con1[1]=$con1[1]/$vm;
1373. $con1[2]=$con1[2]/$vm;
1374. $con1[3]=$con1[3]/$vm;
1375. $con1[4]=$con1[4]/$vm;
1376. $con1[5]=$con1[5]/$vm;
1377. $con1[6]=$con1[6]/$vm;
1378. $con1[7]=$con1[7]/$vm;
1379. $con1[8]=$con1[8]/$vm;
1380. $con1[9]=$con1[9]/$vm;
1381. $con1[10]=$con1[10]/$vm;
1382. $con1[11]=$con1[11]/$vm;
1383. $con2[0]=$con2[0]/$vm;
1384. $con2[1]=$con2[1]/$vm;
1385. $con2[2]=$con2[2]/$vm;
1386. $con2[3]=$con2[3]/$vm;
1387. $con2[4]=$con2[4]/$vm;
1388. $con2[5]=$con2[5]/$vm;
1389. $con2[6]=$con2[6]/$vm;
1390. $con2[7]=$con2[7]/$vm;
1391. $con2[8]=$con2[8]/$vm;
1392. $con2[9]=$con2[9]/$vm;
1393. $con2[10]=$con2[10]/$vm;
1394. $con2[11]=$con2[11]/$vm;}
1395. //dd($datr);
1396. $plushautli=$plushautli+100;
1397. $aacol=$servicedivers->grahi($plushautli);
1398. $ak=$aacol*6;
1399. //echo $aacol." b ";
1400. //    echo $aacol2." ".$aava." <br>";
1401. //echo $aacol."<br>".$aacol2;
1402. $a3=array(0,0,0,0,0,0,0,0);
1403. for($i=1;$i<=6;$i++){
1404.     $a3[$i]=$aacol*$i;
1405. }
1408. $plushaut=$plushaut+100;
1411. $aacol=$servicedivers->grahi($plushaut);
1412. $aacol2=$aacol/2;
1413. //    echo $aacol2." ".$aava." <br>";
1414. //echo $aacol."<br>".$aacol2;
1415. $a1=array(0,0,0,0,0,0,0,0);
1416. $a2=array($aacol2,0,0,0,0,0,0);
1417. for($i=1;$i<=6;$i++){
1418.     $a1[$i]=$aacol*$i;
1419.     $a2[$i]=$aacol2+($aacol*($i-1));
1420. }
1424. $datay1 = [13, 8, 19, 7, 17, 6];
1425. $datay2 = [4, 5, 2, 7, 5, 25];
1426. //dd($data1ya);
1427. // Create the graph.
1428. $graph    = new Graph\Graph(700, 350);
1429. $graph->SetScale('textlin');
1430. $graph->SetMarginColor('white');
1431. $graph->yaxis->SetTickPositions($a1,$a2);
1432. //$graph->y2axis->SetTickPositions($a3);
1433. $graph->SetBox(false);
1434. // Setup title
1435. $graph->title->Set($titre);
1437. // Create the first bar
1438. switch ($mod) {
1439.        default:
1440.        $bplotb = new Plot\BarPlot($data2ya);
1441. $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
1442. $bplotb->SetColor("#239B56");
1443. $bplotb->SetLegend("asia");
1445. // Create the second bar
1446. $bplot2b = new Plot\BarPlot($data2yb);
1447. $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
1448. $bplot2b->SetColor("#C0392B");
1449. $bplot2b->SetLegend("euro ");
1450. $bplot3b = new Plot\BarPlot($data2yc);
1451. $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
1452. $bplot3b->SetColor("#2874A6");
1453. $bplot3b->SetLegend("mouche");
1454. $bplot4b = new Plot\BarPlot($data2yd);
1455. $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1456. $bplot4b->SetColor("#717D7E");/**/
1457. $bplot4b->SetLegend("papillon");
1458. $bplot5b = new Plot\BarPlot($data2ye);
1459. $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1460. $bplot5b->SetColor("#717D7E");/**/
1461. $bplot5b->SetLegend("orien");
1465. // And join them in an accumulated bar
1467. // And join them in an accumulated bar
1468. $p2 = new Plot\LinePlot($con2);
1469. $p2->mark->SetType(MARK_FILLEDCIRCLE);
1470. $p2->mark->SetFillColor('green');
1471. $p2->mark->SetWidth(4);
1472. $p2->SetColor('yellow');
1473. $p2->SetCenter();
1474. $p2->SetLegend("prod");
1475. $bplot = new Plot\BarPlot($data1ya);
1476. $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
1477. $bplot->SetColor("#239B56");
1478. $bplot->SetLegend("asia ");
1479. // Create the second bar
1480. $bplot2 = new Plot\BarPlot($data1yb);
1481. $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
1482. $bplot2->SetColor("#C0392B");
1483. $bplot2->SetLegend("euro");
1484. $bplot3 = new Plot\BarPlot($data1yc);
1485. $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
1486. $bplot3->SetColor("#2874A6");
1487. $bplot3->SetLegend("mouche");
1488. $bplot4 = new Plot\BarPlot($data1yd);
1489. $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1490. $bplot4->SetColor("#717D7E");
1491. $bplot4->SetLegend("papillon");/**/
1492. $bplot5 = new Plot\BarPlot($data1ye);
1493. $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1494. $bplot5->SetColor("#717D7E");
1495. $bplot5->SetLegend("orien");/**/
1497. $p1 = new Plot\LinePlot($con1);
1498. $p1->mark->SetType(MARK_FILLEDCIRCLE);
1499. $p1->mark->SetFillColor('blue');
1500. $p1->mark->SetWidth(4);
1501. $p1->SetColor('blue');
1502. $p1->SetCenter();
1503. $p1->SetLegend("prod");;
1505. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
1506. $accbplotb = new Plot\AccBarPlot([ $bplot5b,$bplot4b,$bplot3b,$bplot2b,$bplotb]);
1508. //$graph->Add($accbplot);
1509. //$graph->Add($accbplotb);
1510. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
1511. //$graph->Add($accbplot);
1512. $graph->Add($bar);
1513. $graph->Add($p1);
1514. $graph->Add($p2);
1515. break;
1516.     case "6m":
1517.         case "an":
1518.             $bplot = new Plot\BarPlot($data1ya);
1519.             $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
1520.             $bplot->SetColor("#239B56");
1521.             $bplot->SetLegend("asia ");
1522.             // Create the second bar
1523.             $bplot2 = new Plot\BarPlot($data1yb);
1524.             $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
1525.             $bplot2->SetColor("#C0392B");
1526.             $bplot2->SetLegend("euro");
1527.             $bplot3 = new Plot\BarPlot($data1yc);
1528.             $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
1529.             $bplot3->SetColor("#2874A6");
1530.             $bplot3->SetLegend("mouche");
1531.             $bplot4 = new Plot\BarPlot($data1yd);
1532.             $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1533.             $bplot4->SetColor("#717D7E");
1534.             $bplot4->SetLegend("papillon");/**/
1535.             $bplot5 = new Plot\BarPlot($data1ye);
1536.             $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1537.             $bplot5->SetColor("#717D7E");
1538.             $bplot5->SetLegend("orien");/**/
1539.             
1540.             $p1 = new Plot\LinePlot($con1);
1541.             $p1->mark->SetType(MARK_FILLEDCIRCLE);
1542.             $p1->mark->SetFillColor('blue');
1543.             $p1->mark->SetWidth(4);
1544.             $p1->SetColor('blue');
1545.             $p1->SetCenter();
1546.             $p1->SetLegend("prod");;
1548. $accbplot = new Plot\AccBarPlot([$bplot4,$bplot4,$bplot3, $bplot2,$bplot]);
1550. $graph->Add($accbplot);
1551. $graph->Add($p1);
1552. break;
1553.         }
1554. //dd($con1);
1555. $graph->SetMargin(40,20,46,80);
1556. $graph->xaxis->SetTickLabels($moisfini);
1558. if($pdf=="oui"){
1559.     switch ($mod) {
1560.         case "6m":
1561.             $fichiergrah=$this->getParameter('grapph_directory')."multigrah-".$intervention->getId().uniqid()."grapmois.png";
1562.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."multigrah-".$intervention->getId().uniqid()."grapmois.png";
1563.             break;
1564.         case "an":
1565.             $fichiergrah=$this->getParameter('grapph_directory')."multigrah-".$intervention->getId().uniqid()."grapan.png";
1566.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."multigrah-".$intervention->getId().uniqid()."grapan.png";
1567.             break;
1568.         default:
1569.             $fichiergrah=$this->getParameter('grapph_directory')."multigrah-".$intervention->getId().uniqid()."grap2an.png";
1570.             $fichiergrah2=$this->getParameter('grapph_directory_dos')."multigrah-".$intervention->getId().uniqid()."grap2an.png";
1571.             break;
1572.     }
1573.     if(file_exists($fichiergrah)){
1574.         unlink($fichiergrah) ;
1575.     }
1576.     $graph->Stroke($fichiergrah);
1577. return $fichiergrah2;
1578.     }else{
1579.     $graph->Stroke();
1580.     }
1583.     }
1585.     #[Route('/faclieu/{id}/{pdf}/{idfac}', name: 'faclieu')]
1586.     public function donner(Lieu $lieu,string $pdf,int $idfac,
1587.     FactuRepository $factuRepository,
1588.     LieuRepository $lieuRepository,
1589.     InterfaitRepository $interfaitRepository,
1590.     InterventionRepository $interventionRepository)
1591.     {
1592.         $intervention=$interventionRepository->getdernierparlieu($lieu);
1593.        // dd($intervention);
1594.        $factu=$factuRepository->find($idfac);
1595.         $servicedivers= new servicedivers();
1596.     
1597.         if($intervention->getContrat()<=0){
1598. $intervention= new Intervention();$date= new DateTimeImmutable();
1599. $intervention->setDate($date);$intervention->setContrat(0);
1600.         }
1601.      //   $lieu=$lieuRepository->find($intervention->getContrat());
1602.         $dateini=date_timestamp_get($intervention->getdate());
1604.         $moiact=date('n',$dateini);
1605.         $interf=$interventionRepository->getInterventionIdcontrat($intervention->getContrat());
1606.         $inter=[];
1607.         foreach ($interf as $k) {
1608.             if($k->getFact()==$idfac){
1609.            $inter[]=$k;}
1610.         }
1611.         $date=time();
1612.            $d=[];
1613.           //  $d[]=date('d/m/y',time());
1614.             foreach ($inter as $k) {
1615.                 $a=date_timestamp_get($k->getdate());
1616.               //  $d[]=date('d/m/y',$a);
1617.                 if($date>$a){
1618.                     $date=$a;
1619.                 }
1620.             }
1621.            // $d[]=date('d/m/y',$date);
1622.            // $d[]=date('d/m/y',$dateini);
1623.            //
1624.             $moid=date('m',$dateini);
1625.             $and=date('y',$dateini);
1626.            // $d[]=$moid;
1627.           //  $d[]=$and;
1628.             $valdeb=$moid+($and*12);
1629.            // $d[]=$valdeb;
1630.         $moi=date('m',$date);
1631.         $an=date('y',$date);
1632.     //   $d[]=$moi;
1633.       //  $d[]=$an;
1634.             $valfin=$moi+($an*12);
1635.             $moi=($valdeb-$valfin)+1;
1636.             
1637.            // $d[]=$valfin;
1638.            // $d[]=$moi;
1639.           $mod="deux";
1640.             if($moi<=6){
1641.                 $mod="6m";
1642.             }elseif($moi<=12){
1643.                 $mod="an";
1644.             }
1645.            
1646.            // $d[]=$mod;
1647.          //dd($d);
1648. $anact=date('y',$dateini);
1649. $anact++;
1650. $anact--;
1651.          
1652. //$titre="intervention"." ".$numcontre;
1653. $titre="dernier relever le ".date('d/m/y',date_timestamp_get($intervention->getdate()));
1654. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
1655. $i=11;
1656. //echo $moiact."  nnn";
1657. $moiact--;
1658. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
1659. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
1660. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
1661. $moisfini=array("","","","","","","","","","","","");
1663. //$d[]=$moiact;
1664. switch ($mod) {
1665.     case "6m":
1666.         while($i>=0){
1667.             //    echo $mois[$moiact]."  nn";
1668.             $moisfini[($i-1)]=$mois[$moiact];
1669.             $a=$moiact+1;
1670.             $moisanscol6[$i]=array($a,$anact,2);
1671.             $moisanscol6[($i-1)]=array($a,$anact,1);
1672.             $moiact--;
1673.             if($moiact==-1){
1674.                 $moiact=11;$anact--;
1675.             }
1676.             $i--;$i--;
1677.         }
1678.         break;
1679.     case "an":
1680. while($i>=0){
1681.     //    echo $mois[$moiact]."  nn";
1682.     $moisfini[$i]=$mois[$moiact];
1683.     $a=$moiact+1;
1684.     $moisanscol[$i]=array($a,$anact);
1685.     $moiact--;
1686.     if($moiact==-1){
1687.         $moiact=11;$anact--;
1688.     }
1689.     $i--;
1690. }
1691.         break;
1692.     default:
1693.         //2 anx
1694. while($i>=0){
1695.     //    echo $mois[$moiact]."  nn";
1696.     $moisfini[$i]=$mois[$moiact];
1697.     $a=$moiact+1;
1698.     $moisanscol[$i]=array($a,$anact);
1699.     $moisanscolpres[$i]=array($a,($anact-1));
1700.     $moiact--;
1701.     if($moiact==-1){
1702.         $moiact=11;$anact--;
1703.     }
1704.     $i--;
1705. }
1706.         break;
1707. }
1708. //$d[]=$moisfini;
1709. //$d[]=$moisanscol;
1710. //$d[]=$moisanscolpres;
1711. //dd($d);
1713. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
1714. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1715. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
1716. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1717. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
1718. $data1ye=[0,0,0,0,0,0,0,0,0,0,0,0];
1719. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
1720. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1721. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
1722. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
1723. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
1724. $data2ye=[0,0,0,0,0,0,0,0,0,0,0,0];
1725. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
1726. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
1727. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$diver=0;
1728. $produitser= new produitService();$datr=[];$da=0;
1729. foreach ($inter as $re) {
1730.    // dd($re);$da
1731.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$diver=0;
1732. $interfa=$interfaitRepository->getinterfait($re->getId());
1733.     $datr[$da]=[];
1734.     $datr[$da]['inter']=$re;
1735.     $datr[$da]['interfait']=$interfa;$dat=[];
1736. foreach ($interfa as $interfai) {
1737. if($interfai->getClientfait()==0){}
1738.     if($interfai->getinter()>=0){
1739.         
1740.    // $dat[]=["grigno"=>$interfai->getGrign(),"remi"=>$interfai->getRemit(),"reste"=>$interfai->getReste(),"chan"=>$interfai->getChan(),"conso"=>$interfai->getConso()];
1742.   
1744.    $grigno=$grigno+$interfai->getGrign();
1745.     $remi=$remi+$interfai->getRemit();
1746.     $reste=$reste+$interfai->getReste();
1748.     $chan=$chan+$interfai->getChan();
1749.     $diver=$diver+$interfai->getConso();
1750. //$interfai->getProduit()
1752.    
1753. $conso=$conso+$produitser->getidvol($interfai->getProduit());
1754.         $dat[]=["consot"=>$conso,"chan"=>$interfai->getChan(),"reste"=>$interfai->getReste(),"remi"=>$interfai->getRemit(),"conso"=>$interfai->getConso(),"prod"=>$interfai->getProduit(),"prod2"=>$produitser->getidvol($interfai->getProduit())];
1755.         }
1757.     } $dateinter=date_timestamp_get($re->getdate());
1759.     $datr[$da]['date']=date('d/m/y',$dateinter);
1760.     $datr[$da]['retour1']=$dat;
1761.     $datr[$da]['retour']=["grigno"=>$grigno,"remi"=>$remi,"reste"=>$reste,"chan"=>$chan,"conso"=>$conso];
1762.         for($i=0; $i<=11;$i++){
1764.                    
1765.             switch ($mod) {
1766.                 case "6m":
1767.                     
1768.                    // dd($dateinter);
1769.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
1770.                         $day15=0;
1771.                         $d=date('d',$dateinter);
1772.                         //    echo $d." l ";
1773.                         if(1<=$d && $d<=15){
1774.         
1775.                             $day15=1;
1776.                         }elseif(16<=$d && $d<=31){
1777.                             $day15=2;
1778.                         }
1779.                         //    echo $day15." l  ".$re['id']." ffff<br>";
1780.         
1781.                         if($moisanscol6[$i][2]==$day15){
1782.                           
1783.                                 $data1ya[$i]=$reste+$data1ya[$i];
1784.                                 $data1yb[$i]=$grigno+$data1yb[$i];
1785.                                 $data1yc[$i]=$remi+$data1yc[$i];
1786.                          
1787.                                 $data1yd[$i]=$chan+$data1yd[$i];
1788.                                 $data1ye[$i]=$diver+$data1ye[$i];
1789.                                 
1790.         //echo $con1[$i];
1791.                             $con1[$i]=$con1[$i]+$conso;
1792.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
1793.                                 }
1794.                     }
1795.                             
1796.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
1797.                     if($plushaut<=$a){
1798.                         $plushaut=$a;}
1799.                     if($plushautli<=$con1[$i]){
1800.                         $plushautli=$con1[$i];}
1801.                     break;
1802.                 case "an":
1803.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
1804.                         
1805.                         $data1ya[$i]=$reste+$data1ya[$i];
1806.                         $data1yb[$i]=$grigno+$data1yb[$i];
1807.                         $data1yc[$i]=$remi+$data1yc[$i];
1808.                         
1809.                         $data1yd[$i]=$chan+$data1yd[$i];
1810.                         $data1ye[$i]=$diver+$data1ye[$i];
1811.                         
1812.         
1813.                         $con1[$i]=$con1[$i]+$conso;
1814.                     }
1815.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
1816.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
1817.                     if($plushaut<=$a){
1818.                         $plushaut=$a;}
1819.                     if($plushautli<=$con1[$i]){
1820.                         $plushautli=$con1[$i];}
1821.                     break;
1822.                 default:
1823.                     //2 anx
1824.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
1825.                         
1826.                             $data1ya[$i]=$reste+$data1ya[$i];
1827.                             $data1yb[$i]=$grigno+$data1yb[$i];
1828.                             $data1yc[$i]=$remi+$data1yc[$i];
1829.                         
1830.                             $data1yd[$i]=$chan+$data1yd[$i];
1831.                             $data1ye[$i]=$diver+$data1ye[$i];
1832.                         
1833.                         $con1[$i]=$con1[$i]+$conso;
1834.         
1835.                     }
1836.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
1837.                         
1838.                             $data2ya[$i]=$reste+$data2ya[$i];
1839.                             $data2yb[$i]=$grigno+$data2yb[$i];
1840.                             $data2yc[$i]=$remi+$data2yc[$i];
1841.                         
1842.                             $data2yd[$i]=$chan+$data2yd[$i];
1843.                             $data2ye[$i]=$diver+$data2ye[$i];
1844.                         
1845.                             $con2[$i]=$con2[$i]+$conso;
1846.                     }
1847.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
1848.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
1849.                     if($plushaut<=$a){
1850.                         $plushaut=$a;}
1851.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
1852.                     if($plushaut<=$a){
1853.                         $plushaut=$a;}
1854.                 if($plushautli<=$con1[$i]){
1855.                         $plushautli=$con1[$i];}
1856.                     if($plushautli<=$con2[$i]){
1857.                         $plushautli=$con2[$i];}
1858.                     break;
1859.             }
1860.         
1861.         
1862.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
1863.         }
1864.         $da++;
1866. }
1867. $datr[]=[$data1ya,$data1yb,$data1yc,$data1yd,$con1];
1868. $datr[]=[$data2ya,$data2yb,$data2yc,$data2yd,$con2];
1869. //dd($datr);
1870. $plushautli=$plushautli+100;
1871. $aacol=$servicedivers->grahi($plushautli);
1872. $ak=$aacol*6;
1873. //echo $aacol." b ";
1874. //    echo $aacol2." ".$aava." <br>";
1875. //echo $aacol."<br>".$aacol2;
1876. $a3=array(0,0,0,0,0,0,0,0);
1877. for($i=1;$i<=6;$i++){
1878.     $a3[$i]=$aacol*$i;
1879. }
1880. $v=$plushaut/3;//valeur max
1881. if($v>=1){
1882. $vm=$plushautli/$v;//valeur divition
1884. $con1[0]=$con1[0]/$vm;
1885. $con1[1]=$con1[1]/$vm;
1886. $con1[2]=$con1[2]/$vm;
1887. $con1[3]=$con1[3]/$vm;
1888. $con1[4]=$con1[4]/$vm;
1889. $con1[5]=$con1[5]/$vm;
1890. $con1[6]=$con1[6]/$vm;
1891. $con1[7]=$con1[7]/$vm;
1892. $con1[8]=$con1[8]/$vm;
1893. $con1[9]=$con1[9]/$vm;
1894. $con1[10]=$con1[10]/$vm;
1895. $con1[11]=$con1[11]/$vm;
1896. $con2[0]=$con2[0]/$vm;
1897. $con2[1]=$con2[1]/$vm;
1898. $con2[2]=$con2[2]/$vm;
1899. $con2[3]=$con2[3]/$vm;
1900. $con2[4]=$con2[4]/$vm;
1901. $con2[5]=$con2[5]/$vm;
1902. $con2[6]=$con2[6]/$vm;
1903. $con2[7]=$con2[7]/$vm;
1904. $con2[8]=$con2[8]/$vm;
1905. $con2[9]=$con2[9]/$vm;
1906. $con2[10]=$con2[10]/$vm;
1907. $con2[11]=$con2[11]/$vm;
1908. }
1911. $plushaut=$plushaut+100;
1914. $aacol=$servicedivers->grahi($plushaut);
1915. $aacol2=$aacol/2;
1916. //    echo $aacol2." ".$aava." <br>";
1917. //echo $aacol."<br>".$aacol2;
1918. $a1=array(0,0,0,0,0,0,0,0);
1919. $a2=array($aacol2,0,0,0,0,0,0);
1920. for($i=1;$i<=6;$i++){
1921.     $a1[$i]=$aacol*$i;
1922.     $a2[$i]=$aacol2+($aacol*($i-1));
1923. }
1926. // Create the graph.
1927. $graph    = new Graph\Graph(700, 350);
1928. $graph->SetScale('textlin');
1929. $graph->SetMarginColor('white');
1930. $graph->yaxis->SetTickPositions($a1,$a2);
1931. //$graph->y2axis->SetTickPositions($a3);
1932. $graph->SetBox(false);
1933. // Setup title
1934. $graph->title->Set($titre);
1936. // Create the first bar
1937. switch ($mod) {
1938.        default:
1939.        $bplotb = new Plot\BarPlot($data2ya);
1940.        $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
1941.        $bplotb->SetColor("#239B56");
1942.        $bplotb->SetLegend("asia");
1943.        
1944.        // Create the second bar
1945.        $bplot2b = new Plot\BarPlot($data2yb);
1946.        $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
1947.        $bplot2b->SetColor("#C0392B");
1948.        $bplot2b->SetLegend("euro ");
1949.        $bplot3b = new Plot\BarPlot($data2yc);
1950.        $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
1951.        $bplot3b->SetColor("#2874A6");
1952.        $bplot3b->SetLegend("mouche");
1953.        $bplot4b = new Plot\BarPlot($data2yd);
1954.        $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1955.        $bplot4b->SetColor("#717D7E");/**/
1956.        $bplot4b->SetLegend("papillon");
1957.        $bplot5b = new Plot\BarPlot($data2ye);
1958.        $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1959.        $bplot5b->SetColor("#717D7E");/**/
1960.        $bplot5b->SetLegend("orien");
1961.        
1962.        
1963.        
1964.        // And join them in an accumulated bar
1965.        
1966.        // And join them in an accumulated bar
1967.        $p2 = new Plot\LinePlot($con2);
1968.        $p2->mark->SetType(MARK_FILLEDCIRCLE);
1969.        $p2->mark->SetFillColor('green');
1970.        $p2->mark->SetWidth(4);
1971.        $p2->SetColor('yellow');
1972.        $p2->SetCenter();
1973.        $p2->SetLegend("prod");
1974.        $bplot = new Plot\BarPlot($data1ya);
1975.        $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
1976.        $bplot->SetColor("#239B56");
1977.        $bplot->SetLegend("asia ");
1978.        // Create the second bar
1979.        $bplot2 = new Plot\BarPlot($data1yb);
1980.        $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
1981.        $bplot2->SetColor("#C0392B");
1982.        $bplot2->SetLegend("euro");
1983.        $bplot3 = new Plot\BarPlot($data1yc);
1984.        $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
1985.        $bplot3->SetColor("#2874A6");
1986.        $bplot3->SetLegend("mouche");
1987.        $bplot4 = new Plot\BarPlot($data1yd);
1988.        $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1989.        $bplot4->SetColor("#717D7E");
1990.        $bplot4->SetLegend("papillon");/**/
1991.        $bplot5 = new Plot\BarPlot($data1ye);
1992.        $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
1993.        $bplot5->SetColor("#717D7E");
1994.        $bplot5->SetLegend("orien");/**/
1995.        
1996.        $p1 = new Plot\LinePlot($con1);
1997.        $p1->mark->SetType(MARK_FILLEDCIRCLE);
1998.        $p1->mark->SetFillColor('blue');
1999.        $p1->mark->SetWidth(4);
2000.        $p1->SetColor('blue');
2001.        $p1->SetCenter();
2002.        $p1->SetLegend("prod");;
2003.     
2004.        
2007. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
2008. $accbplotb = new Plot\AccBarPlot([ $bplot5b,$bplot4b,$bplot3b,$bplot2b,$bplotb]);
2009. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
2010. //$graph->Add($accbplot);
2011. $graph->Add($bar);
2012. $graph->Add($p1);
2013. $graph->Add($p2);
2014. break;
2015.     case "6m":
2016.         case "an":
2017.             $bplot = new Plot\BarPlot($data1ya);
2018.             $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
2019.             $bplot->SetColor("#239B56");
2020.             $bplot->SetLegend("asia ");
2021.             // Create the second bar
2022.             $bplot2 = new Plot\BarPlot($data1yb);
2023.             $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
2024.             $bplot2->SetColor("#C0392B");
2025.             $bplot2->SetLegend("euro");
2026.             $bplot3 = new Plot\BarPlot($data1yc);
2027.             $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
2028.             $bplot3->SetColor("#2874A6");
2029.             $bplot3->SetLegend("mouche");
2030.             $bplot4 = new Plot\BarPlot($data1yd);
2031.             $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2032.             $bplot4->SetColor("#717D7E");
2033.             $bplot4->SetLegend("papillon");/**/
2034.             $bplot5 = new Plot\BarPlot($data1ye);
2035.             $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2036.             $bplot5->SetColor("#717D7E");
2037.             $bplot5->SetLegend("orien");/**/
2038.             
2039.             $p1 = new Plot\LinePlot($con1);
2040.             $p1->mark->SetType(MARK_FILLEDCIRCLE);
2041.             $p1->mark->SetFillColor('blue');
2042.             $p1->mark->SetWidth(4);
2043.             $p1->SetColor('blue');
2044.             $p1->SetCenter();
2045.             $p1->SetLegend("prod");;
2047. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
2049. $graph->Add($accbplot);
2050. $graph->Add($p1);
2051. break;
2052.         }
2054. $graph->SetMargin(40,20,46,80);
2055. $graph->xaxis->SetTickLabels($moisfini);
2057. if($pdf=="oui"){
2058.     switch ($mod) {
2059.         case "6m":
2060.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."donnergrapmoism.png";
2061.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."donnergrapmoism.png";
2062.             break;
2063.         case "an":
2064.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."donnergrapanm.png";
2065.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."donnergrapanm.png";
2066.             break;
2067.         default:
2068.             $fichiergrah=$this->getParameter('grapph_directory').$intervention->getId().uniqid()."donnergrap2anm.png";
2069.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$intervention->getId().uniqid()."donnergrap2anm.png";
2070.             break;
2071.     }
2072.     if(file_exists($fichiergrah)){
2073.         unlink($fichiergrah) ;
2074.     }
2075.     $graph->Stroke($fichiergrah);
2076.    // dd($fichiergrah);
2077. return $fichiergrah;
2078.     }else{
2079.     $graph->Stroke();
2080.     }
2083. //$graph->Stroke();
2084.       /*  return $this->render('graph_jpgraph/index.html.twig', [
2085.             'controller_name' => 'GraphJpgraphController',
2086.         ]);*/
2087.     }
2089.     
2090.     #[Route('/facpro/{pdf}/{idfac}/{idproduit}', name: 'facpro')]
2091.     public function produit(string $pdf,int $idfac,
2092.     int $idproduit,FactuRepository $factuRepository,
2093.     LieuRepository $lieuRepository,
2094.     InterfaitRepository $interfaitRepository,
2095.     ClientRepository $clientRepository,
2096.     FaclieuRepository $faclieuRepository,
2097.     InterventionRepository $interventionRepository)
2098.     {
2100.         
2101.     $inter=[];
2102.     if($idfac==0){
2103.         $interf=$interventionRepository->touteinter();
2104.     
2105.         foreach ($interf as $k) {
2106.            $inter[]=$k;
2107.         }
2108.   
2109. }else{
2110. $factu=$factuRepository->getidfactuform($idfac, $clientRepository, $lieuRepository, $faclieuRepository);
2111.         foreach ($factu['lieuinfo'] as $k) {
2112.             # code...
2113.         
2114.         $interf=$interventionRepository->getInterventionIdcontrat($k['lieuid']);
2115.     
2116.         foreach ($interf as $k) {
2117.             if($k->getFact()==$idfac){
2118.            $inter[]=$k;}
2119.         }
2120.     }  
2121.     }
2122.     //dd($inter);
2123.         $dateinitila=new Intervention;
2124.     foreach ($inter as $k) {
2125.        if($dateinitila->getDate()<=$k->getDate()){
2126.         $dateinitila=$k;
2127.        }
2128.     }
2129.        // dd($intervention);
2130.        $factu=$factuRepository->find($idfac);
2131.         $servicedivers= new servicedivers();
2132.         $dateini=date_timestamp_get($dateinitila->getdate());
2134.         $moiact=date('n',$dateini);
2135.       
2136.         $date=time();
2137.            $d=[];
2138.           //  $d[]=date('d/m/y',time());
2139.             foreach ($inter as $k) {
2140.                 $a=date_timestamp_get($k->getdate());
2141.               //  $d[]=date('d/m/y',$a);
2142.                 if($date>$a){
2143.                     $date=$a;
2144.                 }
2145.             }
2146.            // $d[]=date('d/m/y',$date);
2147.            // $d[]=date('d/m/y',$dateini);
2148.            //
2149.             $moid=date('m',$dateini);
2150.             $and=date('y',$dateini);
2151.            // $d[]=$moid;
2152.           //  $d[]=$and;
2153.             $valdeb=$moid+($and*12);
2154.            // $d[]=$valdeb;
2155.         $moi=date('m',$date);
2156.         $an=date('y',$date);
2157.     //   $d[]=$moi;
2158.       //  $d[]=$an;
2159.             $valfin=$moi+($an*12);
2160.             $moi=($valdeb-$valfin)+1;
2161.             
2162.            // $d[]=$valfin;
2163.            // $d[]=$moi;
2164.           $mod="deux";
2165.             if($moi<=6){
2166.                 $mod="6m";
2167.             }elseif($moi<=12){
2168.                 $mod="an";
2169.             }
2170.            
2171.            // $d[]=$mod;
2172.          //dd($d);
2173. $anact=date('y',$dateini);
2174. $anact++;
2175. $anact--;
2176.          
2177. //$titre="intervention"." ".$numcontre;
2178. $titre="dernier relever le ".date('d/m/y',date_timestamp_get($dateinitila->getdate()));
2179. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
2180. $i=11;
2181. //echo $moiact."  nnn";
2182. $moiact--;
2183. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
2184. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
2185. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
2186. $moisfini=array("","","","","","","","","","","","");
2188. //$d[]=$moiact;
2189. switch ($mod) {
2190.     case "6m":
2191.         while($i>=0){
2192.             //    echo $mois[$moiact]."  nn";
2193.             $moisfini[($i-1)]=$mois[$moiact];
2194.             $a=$moiact+1;
2195.             $moisanscol6[$i]=array($a,$anact,2);
2196.             $moisanscol6[($i-1)]=array($a,$anact,1);
2197.             $moiact--;
2198.             if($moiact==-1){
2199.                 $moiact=11;$anact--;
2200.             }
2201.             $i--;$i--;
2202.         }
2203.         break;
2204.     case "an":
2205. while($i>=0){
2206.     //    echo $mois[$moiact]."  nn";
2207.     $moisfini[$i]=$mois[$moiact];
2208.     $a=$moiact+1;
2209.     $moisanscol[$i]=array($a,$anact);
2210.     $moiact--;
2211.     if($moiact==-1){
2212.         $moiact=11;$anact--;
2213.     }
2214.     $i--;
2215. }
2216.         break;
2217.     default:
2218.         //2 anx
2219. while($i>=0){
2220.     //    echo $mois[$moiact]."  nn";
2221.     $moisfini[$i]=$mois[$moiact];
2222.     $a=$moiact+1;
2223.     $moisanscol[$i]=array($a,$anact);
2224.     $moisanscolpres[$i]=array($a,($anact-1));
2225.     $moiact--;
2226.     if($moiact==-1){
2227.         $moiact=11;$anact--;
2228.     }
2229.     $i--;
2230. }
2231.         break;
2232. }
2233. //$d[]=$moisfini;
2234. //$d[]=$moisanscol;
2235. //$d[]=$moisanscolpres;
2236. //dd($d);
2238. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
2239. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2240. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
2241. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2242. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
2243. $data1ye=[0,0,0,0,0,0,0,0,0,0,0,0];
2244. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
2245. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2246. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
2247. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2248. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
2249. $data2ye=[0,0,0,0,0,0,0,0,0,0,0,0];
2250. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
2251. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
2252. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$diver=0;
2253. $produitser= new produitService();$datr=[];$da=0;
2254. $int=[];
2255. $int2=[];
2256. foreach ($inter as $re) {
2257.    // dd($re);$da
2258. //$int[]=$re;
2259.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$diver=0;
2260. $interfa=$interfaitRepository->getinterfait($re->getId());
2261.     $datr[$da]=[];
2262.     $datr[$da]['inter']=$re;
2263.     $datr[$da]['interfait']=$interfa;$dat=[];
2264. foreach ($interfa as $interfai) {
2265.     if($interfai->getProdavan()==$idproduit) {
2266. if($interfai->getClientfait()==0){}
2267.     if($interfai->getinter()>=0){
2268.         //$int2[]=$interfai;
2269.    // $dat[]=["grigno"=>$interfai->getGrign(),"remi"=>$interfai->getRemit(),"reste"=>$interfai->getReste(),"chan"=>$interfai->getChan(),"conso"=>$interfai->getConso()];
2271.   
2273.    $grigno=$grigno+$interfai->getGrign();
2274.     $remi=$remi+$interfai->getRemit();
2275.     $reste=$reste+$interfai->getReste();
2277.     $chan=$chan+$interfai->getChan();
2278.     $diver=$diver+$interfai->getConso();
2279. //$interfai->getProduit()
2281.    
2282. $conso=$conso+$produitser->getidvol($interfai->getProduit());
2283.         $dat[]=["consot"=>$conso,"chan"=>$interfai->getChan(),"reste"=>$interfai->getReste(),"remi"=>$interfai->getRemit(),"conso"=>$interfai->getConso(),"prod"=>$interfai->getProduit(),"prod2"=>$produitser->getidvol($interfai->getProduit())];
2284.         }
2285.     }
2287.     } $dateinter=date_timestamp_get($re->getdate());
2289.     $datr[$da]['date']=date('d/m/y',$dateinter);
2290.     $datr[$da]['retour1']=$dat;
2291.     $datr[$da]['retour']=["grigno"=>$grigno,"remi"=>$remi,"reste"=>$reste,"chan"=>$chan,"conso"=>$conso];
2292.         for($i=0; $i<=11;$i++){
2294.                    
2295.             switch ($mod) {
2296.                 case "6m":
2297.                     
2298.                    // dd($dateinter);
2299.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
2300.                         $day15=0;
2301.                         $d=date('d',$dateinter);
2302.                         //    echo $d." l ";
2303.                         if(1<=$d && $d<=15){
2304.         
2305.                             $day15=1;
2306.                         }elseif(16<=$d && $d<=31){
2307.                             $day15=2;
2308.                         }
2309.                         //    echo $day15." l  ".$re['id']." ffff<br>";
2310.         
2311.                         if($moisanscol6[$i][2]==$day15){
2312.                           
2313.                                 $data1ya[$i]=$reste+$data1ya[$i];
2314.                                 $data1yb[$i]=$grigno+$data1yb[$i];
2315.                                 $data1yc[$i]=$remi+$data1yc[$i];
2316.                          
2317.                                 $data1yd[$i]=$chan+$data1yd[$i];
2318.                                 $data1ye[$i]=$diver+$data1ye[$i];
2319.                                 
2320.         //echo $con1[$i];
2321.                             $con1[$i]=$con1[$i]+$conso;
2322.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
2323.                                 }
2324.                     }
2325.                             
2326.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2327.                     if($plushaut<=$a){
2328.                         $plushaut=$a;}
2329.                     if($plushautli<=$con1[$i]){
2330.                         $plushautli=$con1[$i];}
2331.                     break;
2332.                 case "an":
2333.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
2334.                         
2335.                         $data1ya[$i]=$reste+$data1ya[$i];
2336.                         $data1yb[$i]=$grigno+$data1yb[$i];
2337.                         $data1yc[$i]=$remi+$data1yc[$i];
2338.                         
2339.                         $data1yd[$i]=$chan+$data1yd[$i];
2340.                         $data1ye[$i]=$diver+$data1ye[$i];
2341.                         
2342.         
2343.                         $con1[$i]=$con1[$i]+$conso;
2344.                     }
2345.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
2346.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2347.                     if($plushaut<=$a){
2348.                         $plushaut=$a;}
2349.                     if($plushautli<=$con1[$i]){
2350.                         $plushautli=$con1[$i];}
2351.                     break;
2352.                 default:
2353.                     //2 anx
2354.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
2355.                         
2356.                             $data1ya[$i]=$reste+$data1ya[$i];
2357.                             $data1yb[$i]=$grigno+$data1yb[$i];
2358.                             $data1yc[$i]=$remi+$data1yc[$i];
2359.                         
2360.                             $data1yd[$i]=$chan+$data1yd[$i];
2361.                             $data1ye[$i]=$diver+$data1ye[$i];
2362.                         
2363.                         $con1[$i]=$con1[$i]+$conso;
2364.         
2365.                     }
2366.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
2367.                         
2368.                             $data2ya[$i]=$reste+$data2ya[$i];
2369.                             $data2yb[$i]=$grigno+$data2yb[$i];
2370.                             $data2yc[$i]=$remi+$data2yc[$i];
2371.                         
2372.                             $data2yd[$i]=$chan+$data2yd[$i];
2373.                             $data2ye[$i]=$diver+$data2ye[$i];
2374.                         
2375.                             $con2[$i]=$con2[$i]+$conso;
2376.                     }
2377.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
2378.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2379.                     if($plushaut<=$a){
2380.                         $plushaut=$a;}
2381.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
2382.                     if($plushaut<=$a){
2383.                         $plushaut=$a;}
2384.                 if($plushautli<=$con1[$i]){
2385.                         $plushautli=$con1[$i];}
2386.                     if($plushautli<=$con2[$i]){
2387.                         $plushautli=$con2[$i];}
2388.                     break;
2389.             }
2390.         
2391.         
2392.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
2393.         }
2394.         $da++;
2396. }
2397. //dd($int,$int2);
2398. $datr[]=[$data1ya,$data1yb,$data1yc,$data1yd,$con1];
2399. $datr[]=[$data2ya,$data2yb,$data2yc,$data2yd,$con2];
2400. //dd($datr);
2401. $plushautli=$plushautli+100;
2402. $aacol=$servicedivers->grahi($plushautli);
2403. $ak=$aacol*6;
2404. //echo $aacol." b ";
2405. //    echo $aacol2." ".$aava." <br>";
2406. //echo $aacol."<br>".$aacol2;
2407. $a3=array(0,0,0,0,0,0,0,0);
2408. for($i=1;$i<=6;$i++){
2409.     $a3[$i]=$aacol*$i;
2410. }
2411. $v=$plushaut/3;//valeur max
2412. if($v>=1){
2413. $vm=$plushautli/$v;//valeur divition
2415. $con1[0]=$con1[0]/$vm;
2416. $con1[1]=$con1[1]/$vm;
2417. $con1[2]=$con1[2]/$vm;
2418. $con1[3]=$con1[3]/$vm;
2419. $con1[4]=$con1[4]/$vm;
2420. $con1[5]=$con1[5]/$vm;
2421. $con1[6]=$con1[6]/$vm;
2422. $con1[7]=$con1[7]/$vm;
2423. $con1[8]=$con1[8]/$vm;
2424. $con1[9]=$con1[9]/$vm;
2425. $con1[10]=$con1[10]/$vm;
2426. $con1[11]=$con1[11]/$vm;
2427. $con2[0]=$con2[0]/$vm;
2428. $con2[1]=$con2[1]/$vm;
2429. $con2[2]=$con2[2]/$vm;
2430. $con2[3]=$con2[3]/$vm;
2431. $con2[4]=$con2[4]/$vm;
2432. $con2[5]=$con2[5]/$vm;
2433. $con2[6]=$con2[6]/$vm;
2434. $con2[7]=$con2[7]/$vm;
2435. $con2[8]=$con2[8]/$vm;
2436. $con2[9]=$con2[9]/$vm;
2437. $con2[10]=$con2[10]/$vm;
2438. $con2[11]=$con2[11]/$vm;
2439. }
2442. $plushaut=$plushaut+100;
2445. $aacol=$servicedivers->grahi($plushaut);
2446. $aacol2=$aacol/2;
2447. //    echo $aacol2." ".$aava." <br>";
2448. //echo $aacol."<br>".$aacol2;
2449. $a1=array(0,0,0,0,0,0,0,0);
2450. $a2=array($aacol2,0,0,0,0,0,0);
2451. for($i=1;$i<=6;$i++){
2452.     $a1[$i]=$aacol*$i;
2453.     $a2[$i]=$aacol2+($aacol*($i-1));
2454. }
2457. // Create the graph.
2458. $graph    = new Graph\Graph(700, 350);
2459. $graph->SetScale('textlin');
2460. $graph->SetMarginColor('white');
2461. $graph->yaxis->SetTickPositions($a1,$a2);
2462. //$graph->y2axis->SetTickPositions($a3);
2463. $graph->SetBox(false);
2464. // Setup title
2465. $graph->title->Set($titre);
2467. // Create the first bar
2468. switch ($mod) {
2469.        default:
2470.        $bplotb = new Plot\BarPlot($data2ya);
2471.        $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
2472.        $bplotb->SetColor("#239B56");
2473.        $bplotb->SetLegend("asia");
2474.        
2475.        // Create the second bar
2476.        $bplot2b = new Plot\BarPlot($data2yb);
2477.        $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
2478.        $bplot2b->SetColor("#C0392B");
2479.        $bplot2b->SetLegend("euro ");
2480.        $bplot3b = new Plot\BarPlot($data2yc);
2481.        $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
2482.        $bplot3b->SetColor("#2874A6");
2483.        $bplot3b->SetLegend("mouche");
2484.        $bplot4b = new Plot\BarPlot($data2yd);
2485.        $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2486.        $bplot4b->SetColor("#717D7E");/**/
2487.        $bplot4b->SetLegend("papillon");
2488.        $bplot5b = new Plot\BarPlot($data2ye);
2489.        $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2490.        $bplot5b->SetColor("#717D7E");/**/
2491.        $bplot5b->SetLegend("orien");
2492.        
2493.        
2494.        
2495.        // And join them in an accumulated bar
2496.        
2497.        // And join them in an accumulated bar
2498.        $p2 = new Plot\LinePlot($con2);
2499.        $p2->mark->SetType(MARK_FILLEDCIRCLE);
2500.        $p2->mark->SetFillColor('green');
2501.        $p2->mark->SetWidth(4);
2502.        $p2->SetColor('yellow');
2503.        $p2->SetCenter();
2504.        $p2->SetLegend("prod");
2505.        $bplot = new Plot\BarPlot($data1ya);
2506.        $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
2507.        $bplot->SetColor("#239B56");
2508.        $bplot->SetLegend("asia ");
2509.        // Create the second bar
2510.        $bplot2 = new Plot\BarPlot($data1yb);
2511.        $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
2512.        $bplot2->SetColor("#C0392B");
2513.        $bplot2->SetLegend("euro");
2514.        $bplot3 = new Plot\BarPlot($data1yc);
2515.        $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
2516.        $bplot3->SetColor("#2874A6");
2517.        $bplot3->SetLegend("mouche");
2518.        $bplot4 = new Plot\BarPlot($data1yd);
2519.        $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2520.        $bplot4->SetColor("#717D7E");
2521.        $bplot4->SetLegend("papillon");/**/
2522.        $bplot5 = new Plot\BarPlot($data1ye);
2523.        $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2524.        $bplot5->SetColor("#717D7E");
2525.        $bplot5->SetLegend("orien");/**/
2526.        
2527.        $p1 = new Plot\LinePlot($con1);
2528.        $p1->mark->SetType(MARK_FILLEDCIRCLE);
2529.        $p1->mark->SetFillColor('blue');
2530.        $p1->mark->SetWidth(4);
2531.        $p1->SetColor('blue');
2532.        $p1->SetCenter();
2533.        $p1->SetLegend("prod");;
2534.     
2535.        
2538. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
2539. $accbplotb = new Plot\AccBarPlot([ $bplot5b,$bplot4b,$bplot3b,$bplot2b,$bplotb]);
2540. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
2541. //$graph->Add($accbplot);
2542. $graph->Add($bar);
2543. $graph->Add($p1);
2544. $graph->Add($p2);
2545. break;
2546.     case "6m":
2547.         case "an":
2548.             $bplot = new Plot\BarPlot($data1ya);
2549.             $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
2550.             $bplot->SetColor("#239B56");
2551.             $bplot->SetLegend("asia ");
2552.             // Create the second bar
2553.             $bplot2 = new Plot\BarPlot($data1yb);
2554.             $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
2555.             $bplot2->SetColor("#C0392B");
2556.             $bplot2->SetLegend("euro");
2557.             $bplot3 = new Plot\BarPlot($data1yc);
2558.             $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
2559.             $bplot3->SetColor("#2874A6");
2560.             $bplot3->SetLegend("mouche");
2561.             $bplot4 = new Plot\BarPlot($data1yd);
2562.             $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2563.             $bplot4->SetColor("#717D7E");
2564.             $bplot4->SetLegend("papillon");/**/
2565.             $bplot5 = new Plot\BarPlot($data1ye);
2566.             $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
2567.             $bplot5->SetColor("#717D7E");
2568.             $bplot5->SetLegend("orien");/**/
2569.             
2570.             $p1 = new Plot\LinePlot($con1);
2571.             $p1->mark->SetType(MARK_FILLEDCIRCLE);
2572.             $p1->mark->SetFillColor('blue');
2573.             $p1->mark->SetWidth(4);
2574.             $p1->SetColor('blue');
2575.             $p1->SetCenter();
2576.             $p1->SetLegend("prod");;
2578. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
2580. $graph->Add($accbplot);
2581. $graph->Add($p1);
2582. break;
2583.         }
2584. //dd($con1);
2585. $graph->SetMargin(40,20,46,80);
2586. $graph->xaxis->SetTickLabels($moisfini);
2588. if($pdf=="oui"){
2589.     switch ($mod) {
2590.         case "6m":
2591.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid().uniqid()."produitgrapmoism.png";
2592.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid().uniqid()."produitgrapmoism.png";
2593.             break;
2594.         case "an":
2595.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid().uniqid()."produitgrapanm.png";
2596.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid().uniqid()."produitgrapanm.png";
2597.             break;
2598.         default:
2599.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid().uniqid()."produitgrap2anm.png";
2600.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid().uniqid()."produitgrap2anm.png";
2601.             break;
2602.     }
2603.     if(file_exists($fichiergrah)){
2604.         unlink($fichiergrah) ;
2605.     }
2606.     $graph->Stroke($fichiergrah);
2607. return $fichiergrah;
2608.     }else{
2609.     $graph->Stroke();
2610.     }
2613. //$graph->Stroke();
2614.       /*  return $this->render('graph_jpgraph/index.html.twig', [
2615.             'controller_name' => 'GraphJpgraphController',
2616.         ]);*/
2617.     }
2619.     #[Route('/facconte/{pdf}/{idfac}/{idproduit}', name: 'facconte')]
2620.     public function conte(string $pdf,int $idfac,
2621.     int $idproduit,FactuRepository $factuRepository,
2622.     LieuRepository $lieuRepository,
2623.     InterfaitRepository $interfaitRepository,
2624.     ClientRepository $clientRepository,
2625.     FaclieuRepository $faclieuRepository,
2626.     InterventionRepository $interventionRepository)
2627.     {
2629.      /*   $factu=$factuRepository->getidfactuform($idfac, $clientRepository, $lieuRepository, $faclieuRepository);
2630.     $inter=[];
2631.         foreach ($factu['lieuinfo'] as $k) {
2632.             # code...
2633.         
2634.         $interf=$interventionRepository->getInterventionIdcontrat($k['lieuid']);
2635.     
2636.         foreach ($interf as $k) {
2637.             if($k->getFact()==$idfac){
2638.            $inter[]=$k;}
2639.         }
2640.     }
2641. */
2642.     $inter=[];
2643.     if($idfac==0){
2644.         $interf=$interventionRepository->touteinter();
2645.     
2646.         foreach ($interf as $k) {
2647.            $inter[]=$k;
2648.         }
2649.   
2650. }else{
2651. $factu=$factuRepository->getidfactuform($idfac, $clientRepository, $lieuRepository, $faclieuRepository);
2652.         foreach ($factu['lieuinfo'] as $k) {
2653.             # code...
2654.         
2655.         $interf=$interventionRepository->getInterventionIdcontrat($k['lieuid']);
2656.     
2657.         foreach ($interf as $k) {
2658.             if($k->getFact()==$idfac){
2659.            $inter[]=$k;}
2660.         }
2661.     }  
2662.     }
2663.    // dd($inter);
2664.         $dateinitila=new Intervention;
2665.     foreach ($inter as $k) {
2666.        if($dateinitila->getDate()<=$k->getDate()){
2667.         $dateinitila=$k;
2668.        }
2669.     }
2670.     //dd($inter);
2671.        // dd($intervention);
2672.        $factu=$factuRepository->find($idfac);
2673.         $servicedivers= new servicedivers();
2674.         $dateini=date_timestamp_get($dateinitila->getdate());
2676.         $moiact=date('n',$dateini);
2677.       
2678.         $date=time();
2679.            $d=[];
2680.           //  $d[]=date('d/m/y',time());
2681.             foreach ($inter as $k) {
2682.                 $a=date_timestamp_get($k->getdate());
2683.               //  $d[]=date('d/m/y',$a);
2684.                 if($date>$a){
2685.                     $date=$a;
2686.                 }
2687.             }
2688.            // $d[]=date('d/m/y',$date);
2689.            // $d[]=date('d/m/y',$dateini);
2690.            //
2691.             $moid=date('m',$dateini);
2692.             $and=date('y',$dateini);
2693.            // $d[]=$moid;
2694.           //  $d[]=$and;
2695.             $valdeb=$moid+($and*12);
2696.            // $d[]=$valdeb;
2697.         $moi=date('m',$date);
2698.         $an=date('y',$date);
2699.     //   $d[]=$moi;
2700.       //  $d[]=$an;
2701.             $valfin=$moi+($an*12);
2702.             $moi=($valdeb-$valfin)+1;
2703.             
2704.            // $d[]=$valfin;
2705.            // $d[]=$moi;
2706.           $mod="deux";
2707.             if($moi<=6){
2708.                 $mod="6m";
2709.             }elseif($moi<=12){
2710.                 $mod="an";
2711.             }
2712.            
2713.            // $d[]=$mod;
2714.          //dd($d);
2715. $anact=date('y',$dateini);
2716. $anact++;
2717. $anact--;
2718.          
2719. //$titre="intervention"." ".$numcontre;
2720. $titre="dernier relever le ".date('d/m/y',date_timestamp_get($dateinitila->getdate()));
2721. $mois=array("jan","fev","mars","avr","mai",'juin',"juil","aout","sept","oct","nov","dec");
2722. $i=11;
2723. //echo $moiact."  nnn";
2724. $moiact--;
2725. $moisanscol=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
2726. $moisanscol6=array(array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0),array(0,0,0));
2727. $moisanscolpres=array(array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0),array(0,0));
2728. $moisfini=array("","","","","","","","","","","","");
2730. //$d[]=$moiact;
2731. switch ($mod) {
2732.     case "6m":
2733.         while($i>=0){
2734.             //    echo $mois[$moiact]."  nn";
2735.             $moisfini[($i-1)]=$mois[$moiact];
2736.             $a=$moiact+1;
2737.             $moisanscol6[$i]=array($a,$anact,2);
2738.             $moisanscol6[($i-1)]=array($a,$anact,1);
2739.             $moiact--;
2740.             if($moiact==-1){
2741.                 $moiact=11;$anact--;
2742.             }
2743.             $i--;$i--;
2744.         }
2745.         break;
2746.     case "an":
2747. while($i>=0){
2748.     //    echo $mois[$moiact]."  nn";
2749.     $moisfini[$i]=$mois[$moiact];
2750.     $a=$moiact+1;
2751.     $moisanscol[$i]=array($a,$anact);
2752.     $moiact--;
2753.     if($moiact==-1){
2754.         $moiact=11;$anact--;
2755.     }
2756.     $i--;
2757. }
2758.         break;
2759.     default:
2760.         //2 anx
2761. while($i>=0){
2762.     //    echo $mois[$moiact]."  nn";
2763.     $moisfini[$i]=$mois[$moiact];
2764.     $a=$moiact+1;
2765.     $moisanscol[$i]=array($a,$anact);
2766.     $moisanscolpres[$i]=array($a,($anact-1));
2767.     $moiact--;
2768.     if($moiact==-1){
2769.         $moiact=11;$anact--;
2770.     }
2771.     $i--;
2772. }
2773.         break;
2774. }
2775. //$d[]=$moisfini;
2776. //$d[]=$moisanscol;
2777. //$d[]=$moisanscolpres;
2778. //dd($d);
2780. $data1ya=[0,0,0,0,0,0,0,0,0,0,0,0];
2781. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2782. $data1yc=[0,0,0,0,0,0,0,0,0,0,0,0];
2783. $data1yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2784. $data1yd=[0,0,0,0,0,0,0,0,0,0,0,0];
2785. $data1ye=[0,0,0,0,0,0,0,0,0,0,0,0];
2786. $data2ya=[0,0,0,0,0,0,0,0,0,0,0,0];
2787. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2788. $data2yc=[0,0,0,0,0,0,0,0,0,0,0,0];
2789. $data2yb=[0,0,0,0,0,0,0,0,0,0,0,0];
2790. $data2yd=[0,0,0,0,0,0,0,0,0,0,0,0];
2791. $data2ye=[0,0,0,0,0,0,0,0,0,0,0,0];
2792. $con1=[0,0,0,0,0,0,0,0,0,0,0,0];
2793. $con2=[0,0,0,0,0,0,0,0,0,0,0,0];
2794. $grigno=0;$remi=0;$reste=0;$conso=0;$plushaut=0;$plushautli=0;$diver=0;
2795. $produitser= new produitService();$datr=[];$da=0;
2796. $int=[];
2797. $int2=[];
2799. foreach ($inter as $re) {
2800.    // dd($re);$da
2801.    $int[]=$re;
2802.     $grigno=0;$remi=0;$reste=0;$chan=0;$conso=0;$diver=0;
2803. $interfa=$interfaitRepository->getinterfait($re->getId());
2804.     $datr[$da]=[];
2805.     $datr[$da]['inter']=$re;
2806.     $datr[$da]['interfait']=$interfa;$dat=[];
2807. foreach ($interfa as $interfai) {
2809.     if($interfai->getPiegeancien()==$idproduit) { 
2810. if($interfai->getClientfait()==0){}
2811.     if($interfai->getinter()>=0){
2812.         $int2[]=$interfai;
2813.    // $dat[]=["grigno"=>$interfai->getGrign(),"remi"=>$interfai->getRemit(),"reste"=>$interfai->getReste(),"chan"=>$interfai->getChan(),"conso"=>$interfai->getConso()];
2815.   
2817.    $grigno=$grigno+$interfai->getGrign();
2818.     $remi=$remi+$interfai->getRemit();
2819.     $reste=$reste+$interfai->getReste();
2821.     $chan=$chan+$interfai->getChan();
2822.     $diver=$diver+$interfai->getConso();
2823. //$interfai->getProduit()
2825.    
2826. $conso=$conso+$produitser->getidvol($interfai->getProduit());
2827.       //  $dat[]=["consot"=>$conso,"chan"=>$interfai->getChan(),"reste"=>$interfai->getReste(),"remi"=>$interfai->getRemit(),"conso"=>$interfai->getConso(),"prod"=>$interfai->getProduit(),"prod2"=>$produitser->getidvol($interfai->getProduit())];
2828.         }
2829.    }
2831.     } $dateinter=date_timestamp_get($re->getdate());
2833.    // $datr[$da]['date']=date('d/m/y',$dateinter);
2834.    // $datr[$da]['retour1']=$dat;
2835.    // $datr[$da]['retour']=["grigno"=>$grigno,"remi"=>$remi,"reste"=>$reste,"chan"=>$chan,"conso"=>$conso];
2836.         for($i=0; $i<=11;$i++){
2838.                    
2839.             switch ($mod) {
2840.                 case "6m":
2841.                     
2842.                    // dd($dateinter);
2843.                     if($moisanscol6[$i][0]==date('m',$dateinter) && $moisanscol6[$i][1]==date('y',$dateinter) ){
2844.                         $day15=0;
2845.                         $d=date('d',$dateinter);
2846.                         //    echo $d." l ";
2847.                         if(1<=$d && $d<=15){
2848.         
2849.                             $day15=1;
2850.                         }elseif(16<=$d && $d<=31){
2851.                             $day15=2;
2852.                         }
2853.                         //    echo $day15." l  ".$re['id']." ffff<br>";
2854.         
2855.                         if($moisanscol6[$i][2]==$day15){
2856.                           
2857.                                 $data1ya[$i]=$reste+$data1ya[$i];
2858.                                 $data1yb[$i]=$grigno+$data1yb[$i];
2859.                                 $data1yc[$i]=$remi+$data1yc[$i];
2860.                          
2861.                                 $data1yd[$i]=$chan+$data1yd[$i];
2862.                                 $data1ye[$i]=$diver+$data1ye[$i];
2863.                                 
2864.         //echo $con1[$i];
2865.                             $con1[$i]=$con1[$i]+$conso;
2866.                         //    echo " + ".$conso." = ".$con1[$i]." - ".$i."<br>";
2867.                                 }
2868.                     }
2869.                             
2870.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2871.                     if($plushaut<=$a){
2872.                         $plushaut=$a;}
2873.                     if($plushautli<=$con1[$i]){
2874.                         $plushautli=$con1[$i];}
2875.                     break;
2876.                 case "an":
2877.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
2878.                         
2879.                         $data1ya[$i]=$reste+$data1ya[$i];
2880.                         $data1yb[$i]=$grigno+$data1yb[$i];
2881.                         $data1yc[$i]=$remi+$data1yc[$i];
2882.                         
2883.                         $data1yd[$i]=$chan+$data1yd[$i];
2884.                         $data1ye[$i]=$diver+$data1ye[$i];
2885.                         
2886.         
2887.                         $con1[$i]=$con1[$i]+$conso;
2888.                     }
2889.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
2890.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2891.                     if($plushaut<=$a){
2892.                         $plushaut=$a;}
2893.                     if($plushautli<=$con1[$i]){
2894.                         $plushautli=$con1[$i];}
2895.                     break;
2896.                 default:
2897.                     //2 anx
2898.                     if($moisanscol[$i][0]==date('m',$dateinter) && $moisanscol[$i][1]==date('y',$dateinter) ){
2899.                         
2900.                         $data1ya[$i]=$reste+$data1ya[$i];
2901.                         $data1yb[$i]=$grigno+$data1yb[$i];
2902.                         $data1yc[$i]=$remi+$data1yc[$i];
2903.                         
2904.                             $data1yd[$i]=$chan+$data1yd[$i];
2905.                             $data1ye[$i]=$diver+$data1ye[$i];
2906.                         
2907.                         $con1[$i]=$con1[$i]+$conso;
2908.         
2909.                     }
2910.                     if($moisanscolpres[$i][0]==date('m',$dateinter) && $moisanscolpres[$i][1]==date('y',$dateinter) ){
2911.                         
2912.                         $data2ya[$i]=$reste+$data2yc[$i];
2913.                         $data2yb[$i]=$grigno+$data2yb[$i];
2914.                         $data2yc[$i]=$remi+$data2ya[$i];
2915.                         
2916.                             $data2yd[$i]=$chan+$data2yd[$i];
2917.                             $data2ye[$i]=$diver+$data2ye[$i];
2918.                         
2919.                             $con2[$i]=$con2[$i]+$conso;
2920.                     }
2921.                     //    echo $con1[$i]." b  ".$data1ya[$i]." f ".$remi." ".$grigno." ".$re['id']." ".$i." <br>";
2922.                     $a=$data1ya[$i]+$data1yb[$i]+$data1yc[$i]+$data1yd[$i]+$data1ye[$i];
2923.                     if($plushaut<=$a){
2924.                         $plushaut=$a;}
2925.                     $a=$data2ya[$i]+$data2yb[$i]+$data2yc[$i]+$data2yd[$i]+$data2ye[$i];
2926.                     if($plushaut<=$a){
2927.                         $plushaut=$a;}
2928.                 if($plushautli<=$con1[$i]){
2929.                         $plushautli=$con1[$i];}
2930.                     if($plushautli<=$con2[$i]){
2931.                         $plushautli=$con2[$i];}
2932.                     break;
2933.             }
2934.         
2935.         
2936.         //    echo $con1[$i]." h ".$con2[$i]." l ".$plushautli." id ".$re['id']."<br>";
2937.         }
2938.         $da++;
2940. }
2941. //dd($int,$int2);
2942. //dd($data1ya,$data1yb,$data1yc,$data1yd,$data1ye);
2943. //$datr[]=[$data1ya,$data1yb,$data1yc,$data1yd,$con1];
2944. //$datr[]=[$data2ya,$data2yb,$data2yc,$data2yd,$con2];
2945. //dd($datr);
2946. $plushautli=$plushautli+100;
2947. $aacol=$servicedivers->grahi($plushautli);
2948. $ak=$aacol*6;
2949. //echo $aacol." b ";
2950. //    echo $aacol2." ".$aava." <br>";
2951. //echo $aacol."<br>".$aacol2;
2952. $a3=array(0,0,0,0,0,0,0,0);
2953. for($i=1;$i<=6;$i++){
2954.     $a3[$i]=$aacol*$i;
2955. }
2956. $v=$plushaut/3;//valeur max
2957. if($v>=1){
2958. $vm=$plushautli/$v;//valeur divition
2960. $con1[0]=$con1[0]/$vm;
2961. $con1[1]=$con1[1]/$vm;
2962. $con1[2]=$con1[2]/$vm;
2963. $con1[3]=$con1[3]/$vm;
2964. $con1[4]=$con1[4]/$vm;
2965. $con1[5]=$con1[5]/$vm;
2966. $con1[6]=$con1[6]/$vm;
2967. $con1[7]=$con1[7]/$vm;
2968. $con1[8]=$con1[8]/$vm;
2969. $con1[9]=$con1[9]/$vm;
2970. $con1[10]=$con1[10]/$vm;
2971. $con1[11]=$con1[11]/$vm;
2972. $con2[0]=$con2[0]/$vm;
2973. $con2[1]=$con2[1]/$vm;
2974. $con2[2]=$con2[2]/$vm;
2975. $con2[3]=$con2[3]/$vm;
2976. $con2[4]=$con2[4]/$vm;
2977. $con2[5]=$con2[5]/$vm;
2978. $con2[6]=$con2[6]/$vm;
2979. $con2[7]=$con2[7]/$vm;
2980. $con2[8]=$con2[8]/$vm;
2981. $con2[9]=$con2[9]/$vm;
2982. $con2[10]=$con2[10]/$vm;
2983. $con2[11]=$con2[11]/$vm;
2984. }
2987. $plushaut=$plushaut+100;
2990. $aacol=$servicedivers->grahi($plushaut);
2991. $aacol2=$aacol/2;
2992. //    echo $aacol2." ".$aava." <br>";
2993. //echo $aacol."<br>".$aacol2;
2994. $a1=array(0,0,0,0,0,0,0,0);
2995. $a2=array($aacol2,0,0,0,0,0,0);
2996. for($i=1;$i<=6;$i++){
2997.     $a1[$i]=$aacol*$i;
2998.     $a2[$i]=$aacol2+($aacol*($i-1));
2999. }
3002. // Create the graph.
3003. $graph    = new Graph\Graph(700, 350);
3004. $graph->SetScale('textlin');
3005. $graph->SetMarginColor('white');
3006. $graph->yaxis->SetTickPositions($a1,$a2);
3007. //$graph->y2axis->SetTickPositions($a3);
3008. $graph->SetBox(false);
3009. // Setup title
3010. $graph->title->Set($titre);
3012. // Create the first bar
3013. switch ($mod) {
3014.        default:
3015.        $bplotb = new Plot\BarPlot($data2ya);
3016.        $bplotb->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
3017.        $bplotb->SetColor("#239B56");
3018.        $bplotb->SetLegend("asia");
3019.        
3020.        // Create the second bar
3021.        $bplot2b = new Plot\BarPlot($data2yb);
3022.        $bplot2b->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
3023.        $bplot2b->SetColor("#C0392B");
3024.        $bplot2b->SetLegend("euro ");
3025.        $bplot3b = new Plot\BarPlot($data2yc);
3026.        $bplot3b->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
3027.        $bplot3b->SetColor("#2874A6");
3028.        $bplot3b->SetLegend("mouche");
3029.        $bplot4b = new Plot\BarPlot($data2yd);
3030.        $bplot4b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3031.        $bplot4b->SetColor("#717D7E");/**/
3032.        $bplot4b->SetLegend("papillon");
3033.        $bplot5b = new Plot\BarPlot($data2ye);
3034.        $bplot5b->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3035.        $bplot5b->SetColor("#717D7E");/**/
3036.        $bplot5b->SetLegend("orien");
3037.        
3038.        
3039.        
3040.        // And join them in an accumulated bar
3041.        
3042.        // And join them in an accumulated bar
3043.        $p2 = new Plot\LinePlot($con2);
3044.        $p2->mark->SetType(MARK_FILLEDCIRCLE);
3045.        $p2->mark->SetFillColor('green');
3046.        $p2->mark->SetWidth(4);
3047.        $p2->SetColor('yellow');
3048.        $p2->SetCenter();
3049.        $p2->SetLegend("prod");
3050.        $bplot = new Plot\BarPlot($data1ya);
3051.        $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
3052.        $bplot->SetColor("#239B56");
3053.        $bplot->SetLegend("asia ");
3054.        // Create the second bar
3055.        $bplot2 = new Plot\BarPlot($data1yb);
3056.        $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
3057.        $bplot2->SetColor("#C0392B");
3058.        $bplot2->SetLegend("euro");
3059.        $bplot3 = new Plot\BarPlot($data1yc);
3060.        $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
3061.        $bplot3->SetColor("#2874A6");
3062.        $bplot3->SetLegend("mouche");
3063.        $bplot4 = new Plot\BarPlot($data1yd);
3064.        $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3065.        $bplot4->SetColor("#717D7E");
3066.        $bplot4->SetLegend("papillon");/**/
3067.        $bplot5 = new Plot\BarPlot($data1ye);
3068.        $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3069.        $bplot5->SetColor("#717D7E");
3070.        $bplot5->SetLegend("orien");/**/
3071.        
3072.        $p1 = new Plot\LinePlot($con1);
3073.        $p1->mark->SetType(MARK_FILLEDCIRCLE);
3074.        $p1->mark->SetFillColor('blue');
3075.        $p1->mark->SetWidth(4);
3076.        $p1->SetColor('blue');
3077.        $p1->SetCenter();
3078.        $p1->SetLegend("prod");;
3079.     
3080.        
3083. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
3084. $accbplotb = new Plot\AccBarPlot([ $bplot5b,$bplot4b,$bplot3b,$bplot2b,$bplotb]);
3085. $bar = new plot\GroupBarPlot(array($accbplot,$accbplotb));
3086. //$graph->Add($accbplot);
3087. $graph->Add($bar);
3088. $graph->Add($p1);
3089. $graph->Add($p2);
3090. break;
3091.     case "6m":
3092.         case "an":
3093.             $bplot = new Plot\BarPlot($data1ya);
3094.             $bplot->SetFillGradient("#239B56", "#239B56", GRAD_VERT);
3095.             $bplot->SetColor("#239B56");
3096.             $bplot->SetLegend("asia ");
3097.             // Create the second bar
3098.             $bplot2 = new Plot\BarPlot($data1yb);
3099.             $bplot2->SetFillGradient("#C0392B", "#C0392B", GRAD_VERT);
3100.             $bplot2->SetColor("#C0392B");
3101.             $bplot2->SetLegend("euro");
3102.             $bplot3 = new Plot\BarPlot($data1yc);
3103.             $bplot3->SetFillGradient("#2874A6", "#2874A6", GRAD_VERT);
3104.             $bplot3->SetColor("#2874A6");
3105.             $bplot3->SetLegend("mouche");
3106.             $bplot4 = new Plot\BarPlot($data1yd);
3107.             $bplot4->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3108.             $bplot4->SetColor("#717D7E");
3109.             $bplot4->SetLegend("papillon");/**/
3110.             $bplot5 = new Plot\BarPlot($data1ye);
3111.             $bplot5->SetFillGradient("#717D7E", "#717D7E", GRAD_VERT);
3112.             $bplot5->SetColor("#717D7E");
3113.             $bplot5->SetLegend("orien");/**/
3114.             
3115.             $p1 = new Plot\LinePlot($con1);
3116.             $p1->mark->SetType(MARK_FILLEDCIRCLE);
3117.             $p1->mark->SetFillColor('blue');
3118.             $p1->mark->SetWidth(4);
3119.             $p1->SetColor('blue');
3120.             $p1->SetCenter();
3121.             $p1->SetLegend("prod");;
3123. $accbplot = new Plot\AccBarPlot([$bplot5,$bplot4,$bplot3, $bplot2,$bplot]);
3125. $graph->Add($accbplot);
3126. $graph->Add($p1);
3127. break;
3128.         }
3129. //dd($con1);
3130. $graph->SetMargin(40,20,46,80);
3131. $graph->xaxis->SetTickLabels($moisfini);
3133. if($pdf=="oui"){
3134.     switch ($mod) {
3135.         case "6m":
3136.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid()."contegrapmoism.png";
3137.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid()."contegrapmoism.png";
3138.             break;
3139.         case "an":
3140.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid()."contegrapanm.png";
3141.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid()."contegrapanm.png";
3142.             break;
3143.         default:
3144.             $fichiergrah=$this->getParameter('grapph_directory').$dateinitila->getId().uniqid()."contegrap2anm.png";
3145.             $fichiergrah2=$this->getParameter('grapph_directory_dos').$dateinitila->getId().uniqid()."contegrap2anm.png";
3146.             break;
3147.     }
3148.     if(file_exists($fichiergrah)){
3149.         unlink($fichiergrah) ;
3150.     }
3151.     $graph->Stroke($fichiergrah);
3152.    
3153. return $fichiergrah;
3154.     }else{
3155.     $graph->Stroke();
3156.     }
3159. //$graph->Stroke();
3160.       /*  return $this->render('graph_jpgraph/index.html.twig', [
3161.             'controller_name' => 'GraphJpgraphController',
3162.         ]);*/
3163.     }
3167.    }