<html>
    <head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet">
	<link href="css/charisma-app.css" rel="stylesheet">
    <link href='bower_components/fullcalendar/dist/fullcalendar.css' rel='stylesheet'>
    <link href='bower_components/fullcalendar/dist/fullcalendar.print.css' rel='stylesheet' media='print'>
    <link href='bower_components/chosen/chosen.min.css' rel='stylesheet'>
    <link href='bower_components/colorbox/example3/colorbox.css' rel='stylesheet'>
    <link href='bower_components/responsive-tables/responsive-tables.css' rel='stylesheet'>
    <link href='bower_components/bootstrap-tour/build/css/bootstrap-tour.min.css' rel='stylesheet'>
    <link href='css/jquery.noty.css' rel='stylesheet'>
    <link href='css/noty_theme_default.css' rel='stylesheet'>
    <link href='css/elfinder.min.css' rel='stylesheet'>
    <link href='css/elfinder.theme.css' rel='stylesheet'>
    <link href='css/jquery.iphone.toggle.css' rel='stylesheet'>
    <link href='css/uploadify.css' rel='stylesheet'>
    <link href='css/animate.min.css' rel='stylesheet'>
        <title>Etat par plat préparé</title>
    </head>
      <body style="font-family:'Montserrat';font-size:17px;" onload="window.print();">
            <div class="container">
		   <div class="row">
		    <div class="col-md-12">  
                <center>
				<br/>				
				<img src="{{public_path('assets/img/logohopital.jpg')}}"/><br/><br/>
				<p><b>Ordre Hospitalier de St Jean de Dieu TANGUIETA</b></p>
				<hr style="width:150px;" />
				<p><b></b></p>
				</center>
		    </div>
		</div></div>
		<!--BLOC DU GERANT-->
		<div class="container">
		<div class="row"> 
                <div class="col-md-4" style="margin-left:20px;">
					@php
					$date_debut= explode('-', $date_debut);
					$date_debut= array_reverse($date_debut);
					$date_debut= implode('/', $date_debut);
					
					$date_fin= explode('-', $date_fin);
					$date_fin= array_reverse($date_fin);
					$date_fin= implode('/', $date_fin);
					@endphp
					<p><b>Par plats préparé du :</b> {{$date_debut}} au {{$date_fin}}</p>
			        </div>
				<div class="col-md-4">  
                    &nbsp;
		        </div>
		</div>
		</div>
     <center>
        <table class="rpp" border='1' style="border-collapse: collapse;margin-left:25px;width:700px" cellspacing="3">
		<thead>
			  <tr>
				<th style="text-align:center;">N°</th>
				<th style="text-align:center;">Désignation</th>
				<th style="text-align:center;">Qte utilisé</th>
				<th style="text-align:center;">Plats attendus</th>
				<th style="text-align:center;">Vendus</th>
				<th style="text-align:center;">Écart</th>
			</tr>
			</thead>
        <tbody>
					@foreach($produits as $produit)
					@php
					
					   $idcat = $produit->cat_id;
					 
					   $idprod = $produit->pv_id;

					   $totap = DB::table('ligne_utilisation')->where('pf_id', $produit->id)->get()->sum('nbre');
					   $totqte = DB::table('ligne_utilisation')->where('pf_id', $produit->id)->get()->sum('qte');
					   
					 
						$totvente0 = DB::table('ligne_vente')->where('produit_id', $produit->id)->where('etat', 'Validée')->get()->sum('qte');
						$totvente2 = DB::table('ligne_vente_client')->where('produit_id', $produit->id)->where('etat', 'Validée')->get()->sum('qte');
						$totvente = $totvente0 + $totvente2;
						
						$ecart = $totap - $totvente;
						
					@endphp
	<tr>
        <td style="text-align:center;font-size:15px;">{{$loop->iteration}}</td>
        <td style="text-align:center;font-size:15px;">{{$produit->designation}}</td>
        <td style="text-align:center;font-size:15px;">{{$totqte}}</td>
        <td style="text-align:center;font-size:15px;">{{$totap}} {{$produit->unite_mesure}}</td>
        <td style="text-align:center;font-size:15px;">{{$totvente}} {{$produit->unite_mesure}}</td>
        
		<td style="text-align:center;font-size:15px;">
		    
			@if( 0 >= $ecart )
            <span class="badge badge-danger badge-shadow">
			{{$ecart}} {{$produit->unite_mesure}}
			</span>
			@else
			<span class="badge badge-success badge-shadow">
			{{$ecart}} {{$produit->unite_mesure}}
			</span>
			@endif
        </td>
    </tr>
	@endforeach
                        </tbody>
        </table>
		<p style="margin-left:430px;margin-top:90px;"><strong>Gérant,</strong><br/>
        Ce <?php echo date('d-m-Y');?>
        </p>
      </div>
        <footer style="position:fixed;bottom:0;text-align:center;">
        <p align="center"><strong><font color="#dc2a26">&copy; Ordre Hospitalier de St Jean de Dieu TANGUIETA 2019-2020</font> </strong>  </p>
        </footer>
      </body>
     </html> 