@extends('dompdf.LayoutBoostrapOnly')

@section('content')
<div >
    <div class="row">
        <h3>Bincard Stock</h3>
        <p class="small">Year&nbsp;: <b>{{$year}}</b></p>
        <p class="small">Month  &nbsp;: <b>{{$month}}</b></p>
        <p class="small">SKU  &nbsp;: 
            @if ($sku == null)
                <b>All</b>
            @else
               <b>{{$sku}}</b>
            @endif    
        </p>
    </div>

    <div class="row">
        <table>
            <thead>
                <tr>
                    <th style="text-align: center;">No</th>
                    <th style="text-align: center;">SKU</th>
                    <th style="text-align: center;">Product</th>
                    <th style="text-align: center;">Reference</th>
                    <th style="text-align: center;">Date</th>
                    <th style="text-align: center;">Qty<br>In</th>
                    <th style="text-align: center;">Qty<br>Out</th>
                    <th style="text-align: center;">Last Stock</th>
                </tr>
            </thead>
            <tbody id="table_view_detail">
                @foreach ($datalist as $key => $value)
                @php
                    $no_set    = $key+1;
                    $value_temp = $value->first_stock;
                @endphp
                    <tr>
                      <td style="text-align: center;"> {{$no_set}}  </td> 
                      <td style="text-align: center;"> {{$value->sku}}  </td> 
                      <td style="text-align: left;"> {{$value->product_name}}  </td> 
                      <td colspan="4" style="text-align: center;"> First Stock  </td> 
                      <td style="text-align: right;">{{number_format($value->first_stock,0,',','.')}}</td> 
                    </tr>
                    @foreach ($value->details as $key_detail => $value_detail)
                        @php
                            $value_temp = $value_temp + $value_detail->qtyin - $value_detail->qtyout;
                            $date_set = date("d-m-Y", strtotime($value_detail->carddate));
                        @endphp
                        <tr> 
                            <td colspan="3" style="text-align: center;"> </td> 
                            <td style="text-align: center;"> {{$value_detail->reference}}  </td> 
                            <td style="text-align: center;"> {{$date_set}}  </td> 
                            <td style="text-align: right;"> {{number_format($value_detail->qtyin,0,',','.')}}  </td> 
                            <td style="text-align: right;"> {{number_format($value_detail->qtyout,0,',','.')}}  </td> 
                            <td style="text-align: right;"> {{number_format($value_temp,0,',','.')}}</td> 
                        </tr>
                    @endforeach
                    <tr>
                        <td colspan="5" style="text-align: center;"> Total  </td> 
                        <td style="text-align: right;"> {{number_format($value->in_stock,0,',','.')}}</td> 
                        <td style="text-align: right;"> {{number_format($value->out_stock,0,',','.')}}  </td> 
                        <td style="text-align: right;"> {{number_format($value->last_stock,0,',','.')}} </td> 
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
        
@endsection