@extends('layouts.reports')
@section('title', "Balanço $year")
@section('report_title', "Balanço $year")
@section('contente')
    @php $numMonths = $untilMonth; @endphp
    @php $lastMonth = str_pad($numMonths, 2, '0', STR_PAD_LEFT); @endphp
    <p>
        <strong>Período: </strong>
        {{ "01/01/$year" }} a {{ date('t', strtotime("$year-$lastMonth-01")) . "/$lastMonth/$year" }}
    </p>
    <table>
        <thead class="bg-blue">
        <tr>
            <th colspan="3">Meses =></th>
            @for($m=1; $m<=$numMonths; $m++)
                <th colspan="2">{{ str_pad($m, 2, '0', STR_PAD_LEFT) }}</th>
            @endfor
            <th>TOTAL</th>
        </tr>
        <tr>
            <th style="width: 20px">#</th>
            <th>Produto</th>
            <th style="width: 40px">Tam.</th>
            @for($m=1; $m<=$numMonths; $m++)
                <th style="width: 30px">Vnd.</th>
                <th style="width: 30px">Est.</th>
            @endfor
            <th style="width: 50px">Vendas</th>
        </tr>
        </thead>
        <tbody>
        @php $cont = 0; @endphp
        @foreach($balance as $product)
            @php $cont++; @endphp
            @php $total = 0; @endphp
            <tr class="striped">
                <th scope="row">{{ $cont }}</th>
                <td>{{ $product->product_name }}</td>
                <td style="text-align: center">{{ $product->size }}</td>
                @foreach($product->months as $month=>$values)
                    @if($month > $numMonths)
                        @break(1);
                    @endif
                    @php $total += $values->vendas; @endphp
                    <th>{{ $values->vendas }}</th>
                    <th>{{ $values->stock }}</th>
                @endforeach
                <th>{{ $total }}</th>
            </tr>
        @endforeach
        </tbody>
    </table>
@endsection