@extends('layouts.reportes')

@section('content')

@php
$t_venta=0;
$t_gasto = 0;
$t_abono = 0;
@endphp

<div class="container-fluid">
   <div class="row">
      <div class="col">

         <p class="text-center h3">REPORTE DE GANANCIAS DE BOLSA</p>


         <div class="row my-5">
            <div class="col">
               <p class="text-center h3">VENTA DE BOLSA DE UTILES</p>

               <table class="table">
                  <thead>
                     <tr>
                        <th>RECIBO</th>
                        <th>ARTICULO</th>
                        <th>PRECIO COSTO</th>
                        <th>PRECIO VENTA / UNITARIO</th>
                        <th>CANTIDAD VENDIDA</th>
                        <th>DESCUENTO</th>
                        <th>TOTAL DE VENTA</th>
                        <th>GANANCIA TOTAL</th>
                     </tr>
                  </thead>
                  <tbody>

                     @foreach ($ventas as $ven )
                     @php
                     $gan = 0;
                     $gan = $ven->total - ( $ven->p_costo * $ven->cantidad );

                     $tb_sin += $ven->p_venta * $ven->cantidad;
                     $tb_con += $ven->total;
                     $tb_des += $ven->descuento;
                     $tb_gan += $gan;
                     @endphp
                     <tr>
                        <td>{{$ven->factura_id}}</td>
                        <td class="text-uppercase">{{$ven->nombre}} <br> @php
                           echo $ven->decripcion;
                           @endphp</td>
                        <td>Q. {{number_format($ven->p_costo,2)}}</td>
                        <td>Q. {{number_format($ven->p_venta,2)}}</td>
                        <td>{{$ven->cantidad}}</td>
                        <td>Q. {{number_format($ven->descuento,2)}}</td>
                        <td>Q. {{number_format($ven->total,2)}}</td>
                        <td>Q {{number_format($gan, 2)}}</td>
                     </tr>
                     @endforeach
                  </tbody>
               </table>

               <p class="text-center text-uppercase h4">Total de Ventas Sin Descuentos: <b>Q. {{number_format($tb_sin, 2)}}</b> </p>
               <p class="text-center text-uppercase h4">Total de Ventas Con Descuentos: <b>Q. {{number_format($tb_con, 2)}}</b> </p>
               <p class="text-center text-uppercase h4">Total de Descuentos: <b>Q. {{number_format($tb_des, 2)}}</b> </p>
               <p class="text-center text-uppercase h4">Total de Ganancias: <b>Q. {{number_format($tb_gan, 2)}}</b> </p>

            </div>
         </div>
         <div class="row my-5">
            <div class="col">
               <p class="text-center h3">COMPRA DE BOLSA DE UTILES</p>

               <table class="table">
                  <thead>
                     <tr>
                        <th>#</th>
                        <th>BOLSA</th>
                        <th>CANTIDAD</th>
                        <th>FECHA DE COMPRA</th>
                        <th>TIPO</th>
                        <th>USUARIO</th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach ($compra as $art)
                     <tr>
                        <td>{{$art->id}}</td>
                        <td>{{$art->nombre}}</td>
                        <td>{{$art->cantidad}}</td>
                        <td>{{$art->created_at}}</td>
                        <td>{{$art->tipo}}</td>
                        <th>{{$art->name}}</th>
                     </tr>
                     @endforeach
                  </tbody>
               </table>
            </div>
         </div>


         <div class="row">
            <div class="col">

               <p class="h3 text-center">GASTOS BOLSA</p>


               <table class="table">
                  <thead>
                     <tr>
                        <th>Fecha</th>
                        <th>Valor</th>
                        <th>Factura</th>
                        <th>Descripcion</th>
                        <th>Tipo</th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach ($gastos as $dt)
                     @php
                     $t_gasto += $dt->valor;
                     @endphp
                     <tr>
                        <td scope="row">{{$dt->fecha}}</td>
                        <td>Q. {{number_format($dt->valor, 2)}}</td>
                        <td>{{$dt->factura}}</td>
                        <td>{{$dt->descripcion}}</td>
                        <td>GASTO {{$dt->tipo}}</td>
                     </tr>
                     @endforeach

                  </tbody>
               </table>

               <h4>Total: Q. {{number_format($t_gasto, 2)}}</hh4>


            </div>
         </div>

         <div class="row">
            <div class="col">

               <p class="h3 text-center">ABONOS BOLSA</p>

               <div class="table-responsive">
                  <table class="table">
                     <thead>
                        <tr>
                           <th>#</th>
                           <th>Estudiante</th>
                           <th>Grado</th>
                           <th>Tipo</th>
                           <th>Valor</th>
                           <th>Boleta</th>
                           <th>Banco</th>
                           <th>Estado</th>
                           <th>Descripcion</th>
                           <th>Usuario</th>
                        </tr>
                     </thead>
                     <tbody>
                        @foreach ($abonos as $a )
                        <tr>
                           <td>{{$a->id}}</td>
                           <td>{{$a->nombre_estudiante}}</td>
                           <td>{{$a->nombre}}</td>
                           <td>{{$a->tipo}}</td>
                           <td>Q. {{number_format($a->valor, 2)}}</td>
                           <td>{{$a->boleta}}</td>
                           <td>{{$a->banco}}</td>
                           <td>{{$a->estado}}</td>
                           <td></td>
                           <td>{{$a->name}}</td>
                        </tr>
                        @php
                        $t_abono += $a->valor;
                        @endphp
                        @endforeach
                     </tbody>
                  </table>
               </div>


            </div>
         </div>


      </div>
   </div>
</div>

@endsection