<?php
ob_start();
session_start();
include 'fonctions.php';
?>
<page orientation="paysage" style="font-size: 18px">
<?php
$datedfr=$_SESSION['datedfr'];
$i=0;
$datedus=changedatefrus($datedfr);
while ($i<=10){
$req="SELECT DAYNAME('$datedus')";
$resultb=mysql_query($req);
$data=mysql_fetch_array($resultb);
$jours[$i]=$data[0];
$jour[$i]=changejourusfr($jours[$i]);
$dateus[$i]=$datedus;
$date[$i]=changedateusfr($datedus);
$reqt="SELECT DATE_ADD('$datedus', INTERVAL 1 DAY)";
$resultat=mysql_query($reqt);
$data2=mysql_fetch_array($resultat);
$datedus=$data2[0];
$i++;
}
$i--;
$dateffr=$date[$i];
$datedfr=$date[0];
$datedus=changedatefrus($datedfr);
$datefus=changedatefrus($dateffr);
$heured=convertDateHeure($datedfr);
$heuref=convertDateHeure($dateffr);
$diff=($heuref/24)-($heured/24);
$i=0;
echo '<h3 > Planning hebdomadaire de production</h3>';
echo '<table border="1" style="border:thin solid #483D8B; align:center; border-spacing:6px" width=100%>';
echo '<tr>';
echo '<th align=center rowspan="3" style=WIDTH:10%> GROUPES</th>';
while ($i<$diff){
echo '<th align=center colspan="2" style=WIDTH:9%>'.$jour[$i].'</th>';
$i++;
}
echo '</tr><tr>';
$i=0;
while ($i<$diff){
echo '<th align=center colspan="2" style=WIDTH:9%>'.$date[$i].'</th>';
$i++;
}
echo '</tr><tr>';
$i=0;
while ($i<$diff){
echo '<td align=center style=WIDTH:4,5%>Repas</td><td align=center style=WIDTH:4,5%>Pique-nique</td>';
$i++;
}
echo '</tr><tr>';
echo '<th align=center style=WIDTH:10%>Petits D�jeuners</th>';
$i=0;
while ($i<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$i++;
}
echo '</tr><tr>';
$connec=connexion();
$req="SELECT DISTINCT Id_eta FROM periode WHERE Curdate BETWEEN '$datedus' AND '$datefus'";
$res=mysql_query($req);
$nbj=mysql_num_rows($res);
$req="SELECT Nom_eta, Curdate, Petit_dej, Gouter, Repas_midi, Repas_soir, Pik_nik_midi, Pik_nik_soir, Id_eta FROM contrat as A1, periode as A2 WHERE A1.Id_auto=A2.Id_eta AND Curdate BETWEEN '$datedus' AND '$datefus' ORDER BY Nom_eta ASC, Curdate ASC";
$res=mysql_query($req);
$nbi=mysql_num_rows($res);
$i=0;
while ($data=mysql_fetch_array($res)){
$nometa[$i]=$data[0];
$curdate[$i]=$data[1];
$ptidej[$i]=$data[2];
$gouter[$i]=$data[3];
$rpmid[$i]=$data[4];
$rpsoir[$i]=$data[5];
$pkmid[$i]=$data[6];
$pksoir[$i]=$data[7];
$ideta[$i]=$data[8];
$i++;
}
$j=0;
$i=0;
// Affichage du nb de petit dej
while ($j<$nbj){
echo '<td algin=center style=WIDTH:10%>'.$nometa[$i].'</td>';
$x=0;
while ($curdate[$i]!=$dateus[$x]){
echo '<td style=WIDTH:4,5%> </td><td style=WIDTH:4,5%> </td>';
$x++;
}
$a=$i;
while ($ideta[$i]==$ideta[$a]){
if ($x<$diff){
if ($curdate[$i]==$dateus[$x]){
if ($ptidej[$i]!=0){
echo '<td align=center style=width:4,5% bgcolor=#66CDAA>'.$ptidej[$i].'</td><td style=WIDTH:4,5%> </td>';
$tot[$x]+=$ptidej[$i];
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}
$a=$i;
$i++;
$x++;
}
if ($x<$diff){
while ($x<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
}
$j++;
echo '</tr><tr>';
}
echo '<th> TOTAL</th>';
$i=0;
while ($i<$diff){
if ($tot[$i]!=""){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot[$i].'</td><td style=width:4,5%> </td>';
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
$i++;
}
// Affichage du nb de dejeuner
echo '</tr><tr><td style=border:0%> </td>';
$i=0;
while ($i<$diff){
echo '<td height=10% style=border:0%> </td><td height=10% style=border:0%> </td>';
$i++;
}
echo '</tr><tr>';
echo '<th> D�jeuners </th>';
$i=0;
while ($i<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$i++;
}
echo '</tr><tr>';
$j=0;
$i=0;
while ($j<$nbj){
echo '<td algin=center style=width:10%>'.$nometa[$i].'</td>';
$x=0;
while ($curdate[$i]!=$dateus[$x]){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
$a=$i;
while ($ideta[$i]==$ideta[$a]){
if ($x<$diff){
if ($curdate[$i]==$dateus[$x]){
if ($rpmid[$i]!=0){
echo '<td align=center bgcolor=#66CDAA style=width:4,5%>'.$rpmid[$i].'</td><td style=width:4,5%> </td>';
$tot1[$x]+=$rpmid[$i];
}else if ($pkmid[$i]!=0){
echo '<td style=width:4,5%> </td><td align=center bgcolor=#CD5C5C style=width:4,5%>'.$pkmid[$i].'</td>';
$tot1pk[$x]+=$pkmid[$i];
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}
$a=$i;
$i++;
$x++;
}
if ($x<$diff){
while ($x<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
}
$j++;
echo '</tr><tr>';
}
echo '<th> TOTAL</th>';
$i=0;
while ($i<$diff){
if ( ($tot1[$i]!="") && ($tot1pk[$i]!="") ){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot1[$i].'</td><td align=center bgcolor=#778899 style=width:4,5%>'.$tot1pk[$i].'</td>';
}else if ($tot1[$i]!=""){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot1[$i].'</td><td style=width:4,5%> </td>';
}else if ($tot1pk[$i]!=""){
echo '<td style=width:4,5%> </td><td align=center bgcolor=#778899 style=width:4,5%>'.$tot1pk[$i].'</td>';
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
$i++;
}
//Affichage du nb de gouter
$req2bis="SELECT DISTINCT Id_eta FROM periode WHERE Gouter !='' AND Curdate BETWEEN '$datedus' AND '$datefus'";
$res2bis=mysql_query($req2bis);
$nbgout=mysql_num_rows($res2bis);
$req2="SELECT Nom_eta, Id_eta, Gouter, Curdate FROM contrat as A1, periode as A2 WHERE A1.Id_auto=A2.Id_eta AND Curdate BETWEEN '$datedus' AND '$datefus' AND Gouter !='' ORDER BY Nom_eta ASC, Curdate ASC";
$res2=mysql_query($req2);
if (mysql_num_rows($res2)!=0){
echo '</tr><tr><td style=border:0%> </td>';
$i=0;
while ($i<$diff){
echo '<td height=10% style=border:0%> </td><td height=10% style=border:0%> </td>';
$i++;
}
echo '</tr><tr>';
$i=0;
while ($data2=mysql_fetch_array($res2)){
$nometa2[$i]=$data2[0];
$ideta2[$i]=$data2[1];
$gouter2[$i]=$data2[2];
$curdate2[$i]=$data2[3];
$i++;
}
echo '<th style=width:10%> Go�ters </th>';
$i=0;
while ($i<$diff){
echo '<td style=width:9%> </td><td style=width:9%> </td>';
$i++;
}
echo '</tr><tr>';
$j=0;
$i=0;
while ($j<$nbgout){
echo '<td algin=center style=width:10%>'.$nometa2[$i].'</td>';
$x=0;
while ($curdate2[$i]!=$dateus[$x]){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
$a=$i;
while ($ideta2[$i]==$ideta2[$a]){
if ($x<$diff){
if ($curdate2[$i]==$dateus[$x]){
if ($gouter2[$i]!=0){
echo '<td align=center bgcolor=#66CDAA style=width:4,5%>'.$gouter2[$i].'</td><td style=width:4,5%> </td>';
$tot2[$x]+=$gouter2[$i];
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}
$a=$i;
$i++;
$x++;
}
if ($x<$diff){
while ($x<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
}
$j++;
echo '</tr><tr>';
}
echo '<th> TOTAL</th>';
$i=0;
while ($i<$diff){
if ($tot2[$i]!=""){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot2[$i].'</td><td style=width:4,5%> </td>';
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
$i++;
}
}
// Affichage du nb de diner
echo '</tr><tr><td style=border:0%> </td>';
$i=0;
while ($i<$diff){
echo '<td height=10% style=border:0%> </td><td height=10% style=border:0%> </td>';
$i++;
}
echo '</tr><tr>';
echo '<th style=width:10%> D�ners </th>';
$i=0;
while ($i<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$i++;
}
echo '</tr><tr>';
$j=0;
$i=0;
while ($j<$nbj){
echo '<td algin=center style=width:10%>'.$nometa[$i].'</td>';
$x=0;
while ($curdate[$i]!=$dateus[$x]){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
$a=$i;
while ($ideta[$i]==$ideta[$a]){
if ($x<$diff){
if ($curdate[$i]==$dateus[$x]){
if ($rpsoir[$i]!=0){
echo '<td align=center bgcolor=#66CDAA style=width:4,5%>'.$rpsoir[$i].'</td><td style=width:4,5%> </td>';
$tot3[$x]+=$rpsoir[$i];
}else if ($pkmid[$i]!=0){
echo '<td style=width:4,5%> </td><td align=center bgcolor=#CD5C5C style=width:4,5%>'.$pksoir[$i].'</td>';
$tot3pk[$x]+=$pksoir[$i];
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
}
$a=$i;
$i++;
$x++;
}
if ($x<$diff){
while ($x<$diff){
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
$x++;
}
}
$j++;
echo '</tr><tr>';
}
echo '<th> TOTAL</th>';
$i=0;
while ($i<$diff){
if ( ($tot3[$i]!="") && ($tot3pk[$i]!="") ){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot3[$i].'</td><td align=center bgcolor=#778899 style=width:4,5%>'.$tot3pk[$i].'</td>';
}else if ($tot3[$i]!=""){
echo '<td align=center bgcolor=#808080 style=width:4,5%>'.$tot3[$i].'</td><td style=width:4,5%> </td>';
}else if ($tot3pk[$i]!=""){
echo '<td style=width:4,5%> </td><td align=center bgcolor=#778899 style=width:4,5%>'.$tot3pk[$i].'</td>';
}else{
echo '<td style=width:4,5%> </td><td style=width:4,5%> </td>';
}
$i++;
}
echo '</tr></table>';
mysql_close();
?>
</page>
<?php
$content = ob_get_clean();
require_once(dirname(__FILE__).'\html2pdf.class.php');
$html2pdf = new HTML2PDF('P','A4', 'fr');
$html2pdf->WriteHTML($content, isset($_GET['vuehtml']));
$html2pdf->Output('editionFicheIndiv2.pdf');
?>