@extends('layouts.reports')
@section('title', "Despesas em um Período")
@section('report_title', "Despesas em um Período")
@section('contente')
    <p><strong>Período: </strong>{{ \App\Helpers\HlpDate::dateDbToBr($data_inicio) }}
        a {{ \App\Helpers\HlpDate::dateDbToBr($data_fim) }}</p>
    <table>
        <thead class="bg-blue">
        <tr>
            <th style="width: 5%">#</th>
            <th>Fornecedor</th>
            <th style="width: 18%">CNPJ</th>
            <th style="width: 10%">Data</th>
            <th style="width: 15%">Valor (R$)</th>
        </tr>
        </thead>
        <tbody>
        @php
            $total = 0;
            $cont = 0;
        @endphp
        @foreach($shoppings as $shopping)
            @php $cont++; @endphp
            @php $valor = 0; @endphp
            @foreach($shopping->itens as $item)
                @php
                    $valor += $item->quantity * $item->price;
                @endphp
            @endforeach
            @php
                $total += $valor;
            @endphp
            <tr class="striped">
                <th scope="row">{{ $cont }}</th>
                <td>{{ $shopping->supplier->corporate_name }}</td>
                <td style="text-align: center">{{ $shopping->supplier->cnpj }}</td>
                <td style="text-align: center">{{ HlpDate::dateDbToBr($shopping->date) }}</td>
                <td style="text-align: center">{{ number_format($valor, 2, ',', '.') }}</td>
            </tr>
        @endforeach
        </tbody>
        <tfoot>
        <tr>
            <th colspan="4" class="bg-blue" style="text-align: right; padding-right: 10px">TOTAL (R$):</th>
            <th class="bg-blue">{{ number_format($total, 2, ',', '.') }}</th>
        </tr>
        </tfoot>
    </table>
@endsection