@extends('admin.layouts.resource-layout')

@section('title')
    <h3>Остатки</h3>
@endsection

@section('resource-content')

    <div class="page-filter clearfix">
        <form action="?" method="GET">
            <div class="row">

                <div class="col-sm-4">
                    <div class="form-group">
                        <label for="wh" class="col-form-label">склад</label>
                        <select id="wh" class="form-control" name="wh">
                            <option value=""></option>
                            @foreach ($wareHouses as $value => $label)
                                <option value="{{ $value }}" {{ $value == request('wh') ? 'selected' : '' }}>{{ $label }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-sm-4">
                    <div class="form-group">
                        <label for="date" class="col-form-label">дата</label>
                        <input id="date" class="form-control picker-date" name="date" value="{{ request('date') ? request('date') : \Carbon\Carbon::now()->format('Y-m-d') }}">
                    </div>
                </div>
                <div class="col-sm-4">
                    <div class="form-group text-right">
                        <label class="col-form-label">&nbsp;</label><br />
                        <button title="Поиск" type="submit" class="btn bg-orange"><i class="fa fa-search" aria-hidden="true"></i></button>
                        <button title="Скачать" type="submit" class="btn btn-info" name="excel"><i class="fa fa-download" aria-hidden="true"></i></button>
                        <a title="Очистить" href="?" class="btn btn-default"><i class="fa fa-retweet" aria-hidden="true"></i></a>
                    </div>
                </div>

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


    <div class="row">
        <div class="col-xs-12">
            <div class="x_panel">
                <div class="x_content">

                    <table class="table table-hover  table-border jambo_table">
                        <thead>
                            <tr>
                                <th>@sortablelink('product.title', 'склад')</th>
                                <th>остаток</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $all_balance = 0; @endphp
                            @foreach ($items as $item)
                                @php $balances_sum = $item->balance_sum1 - $item->balance_sum2;  @endphp
                                @if($balances_sum > 0)
                                    <tr>
                                        <td>{{ $item->sklad->title }}</td>
                                        <td>{{ $balances_sum }}</td>
                                    </tr>
                                    @php $all_balance += $balances_sum; @endphp
                                @endif
                                
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td class="text-right">Сумма</td>
                                <td>{{ $all_balance }}</td>
                            </tr>
                        </tfoot>
                    </table>

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

@endsection