@extends('layouts.admin')
@section('content')
<div class="card">
    <div class="card-header">
        Stock Reports
    </div>

    <div class="card-body">
        <div class="form-group">
            <form action="{{ route('admin.stock-reports.filter') }}" method="GET">
                <div class="form-row d-flex align-items-center">
                    <div class="col-12 col-md-3">
                        <label class="required" for="date_from">Date From</label>
                        <input class="form-control date {{ $errors->has('date_from') ? 'is-invalid' : '' }}" type="text" name="date_from" id="date_from" value="{{ old('date_from', request()->input('date_from')) }}" required>
                        @if($errors->has('date_from'))
                            <div class="invalid-feedback">
                                {{ $errors->first('date_from') }}
                            </div>
                        @endif
                    </div>
                    <div class="col-12 col-md-3">
                        <label class="required" for="date_to">Date To</label>
                        <input class="form-control date {{ $errors->has('date_to') ? 'is-invalid' : '' }}" type="text" name="date_to" id="date_to" value="{{ old('date_to', request()->input('date_to')) }}" required>
                        @if($errors->has('date_to'))
                            <div class="invalid-feedback">
                                {{ $errors->first('date_to') }}
                            </div>
                        @endif
                    </div>
                    <div class="col-12 col-md-3">
                        <label class="required" for="warehouse">Warehouse</label>
                        <select class="form-control select2 {{ $errors->has('warehouse') ? 'is-invalid' : '' }}" name="warehouse" id="warehouse">
                            <option value="" hidden>Select an warehouse</option>
                            @foreach($warehouses as $id => $warehouse_name)
                                <option value="{{ $id }}" {{ request()->input('warehouse') == $id ? 'selected' : '' }}>{{ $warehouse_name }}</option>
                            @endforeach
                        </select>
                        @if($errors->has('warehouse'))
                            <div class="invalid-feedback">
                                {{ $errors->first('warehouse') }}
                            </div>
                        @endif
                    </div>
                    <div class="col-12 col-md-2">
                        <button class="btn btn-success d-inline-block" type="submit">Filter</button>
                    </div>
                </div>
            </form>
        </div>

        @isset ($reportData)
            <div class="form-group">
                <table class="table table-sm table-bordered">
                    <tbody>
                        @foreach ($reportData as $item_name => $data)
                            <tr>
                                <th>Product Name : </th>
                                <th colspan="6">{{ $item_name }}</th>
                            </tr>
                            <tr>
                                <th>Date</th>
                                <th>Refno</th>
                                <th>Title</th>
                                <th>OB Qty</th>
                                <th>In Qty</th>
                                <th>Out Qty</th>
                                <th>Bal Qty</th>
                            </tr>
                            @php
                                $bal_qty = 0;
                            @endphp
                            @foreach ($data as $transaction)
                            <tr>
                                @php
                                    $bal_qty += $transaction->ob_qty + $transaction->in_qty - $transaction->out_qty;
                                @endphp
                                <td>{{ $transaction->date }}</td>
                                <td>{{ $transaction->refno }}</td>
                                <td>{{ $transaction->title }}</td>
                                <td>{{ $transaction->ob_qty }}</td>
                                <td>{{ $transaction->in_qty }}</td>
                                <td>{{ $transaction->out_qty }}</td>
                                <td>{{ $bal_qty }}</td>
                            </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                </table>
            </div>
        @else
            <p class="text-center">There is no any data currently.</p>
        @endisset
        
        {{-- @if ($reportData)
            <div class="form-group">
                <table class="table table-sm table-bordered">
                    <tbody>
                        @foreach ($reportData as $mainKey => $mainData)
                            <tr>
                                <th>No.</th>
                                <th>Merchandiser Name</th>
                                <th>Date Visited</th>
                                <th>Number of merchant visited</th>
                            </tr>
                            <tr>
                                <td>{{ $mainKey + 1 }}</td>
                                <td>{{ $mainData['employee_name'] }}</td>
                                <td>{{ $mainData['date'] }}</td>
                                <td>{{ $mainData['number_merchants'] }}</td>
                            </tr>
                            <tr>
                                <td colspan="4"></td>
                            </tr>
                            @foreach($mainData['availableStores'] as $subKey => $availableStore)
                                <tr>
                                    <td></td>
                                    <td>{{ $availableStore['store_name'] }}</td>
                                    <td class="p-0">
                                        <table class="table table-bordered table-striped m-0">
                                            <thead>
                                                <th style="width: 10%;">#</th>
                                                <th style="width: 80%;">Product Name</th>
                                                <th style="width: 10%;">Quantity</th>
                                            </thead>
                                            <tbody>
                                                @foreach ($availableStore['products'] as $key => $product)
                                                    <tr>
                                                        <td>{{ $key + 1 }}</td>
                                                        <td>{{ $product['product_name'] }}</td>
                                                        <td>{{ $product['quantity'] }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </td>
                                    <td>{{ $availableStore['feedback'] }}</td>
                                </tr>
                            @endforeach
                            @if(!$loop->last)
                            <tr><td colspan="4"></td></tr>
                            @endif
                        @endforeach
                    </tbody>
                </table>
            </div>
            <div class="form-group">
                <a class="btn btn-success" href="{{ route('admin.merchandise-reports.export', ['date_from' => request()->input('date_from'), 'date_to' => request()->input('date_to')]) }}">Export</a>
                <a class="btn btn-info" href="{{ route('admin.merchandise-reports.print', ['date_from' => request()->input('date_from'), 'date_to' => request()->input('date_to')]) }}">Print</a>
            </div>
        @else
        @endif --}}
    </div>
</div>
@endsection

@section('scripts')
@parent
{{-- <script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.1/dist/chart.min.js"></script> --}}
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js"></script>
@endsection