@extends('layouts.admin')


@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }
    </style>
@endpush


@section('content')
    <section class="content">
        <div class="container-fluid pt-2">
            <h4 class="text-center mb-4">Inventory List (Accessories & Assets)</h4>

            {{-- ✅ Filter Form --}}
            {{-- ✅ Filter Form --}}
            <form action="{{ route('account.report') }}" method="GET" class="mb-4">
                <div class="row">
                    {{-- From / To dates --}}
                    <div class="col-md-3 col-sm-6 mb-2">
                        <label for="from_date">From Date:</label>
                        <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
                    </div>
                    <div class="col-md-3 col-sm-6 mb-2">
                        <label for="to_date">To Date:</label>
                        <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
                    </div>

                    {{-- Outlet --}}
                    <div class="col-md-3 col-sm-6 mb-2">
                        <label for="outlet">Outlet:</label>
                        <select name="outlet" class="form-control">
                            <option value="">-- All Outlets --</option>
                            @foreach ($outlets as $outlet)
                                <option value="{{ $outlet->id }}"
                                    {{ request('outlet') == $outlet->id ? 'selected' : '' }}>
                                    {{ $outlet->outlet_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    {{-- NEW: Group --}}
                    {{-- Filter Form (only the two new selects shown) --}}
                    <div class="col-md-3 col-sm-6 mb-2">
                        <label for="groupID">Group:</label>
                        <select name="groupID" id="groupID" class="form-control">
                            <option value="">-- All Groups --</option>
                            @foreach ($group as $g)
                                <option value="{{ $g->id }}" {{ request('groupID') == $g->id ? 'selected' : '' }}>
                                    {{ $g->group_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3 col-sm-6 mb-2">
                        <label for="subGroupID">Sub‑Group:</label>
                        <select name="subGroupID" id="subGroupID" class="form-control">
                            <option value="">-- All Sub‑Groups --</option>
                            @foreach ($sub_group as $sg)
                                <option value="{{ $sg->id }}"
                                    {{ request('subGroupID') == $sg->id ? 'selected' : '' }}>
                                    {{ $sg->sub_group_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>


                    {{-- Search button (pushes to next row if screen is narrow) --}}
                    <div class="col-md-3 col-sm-6 mb-2 btn_mt">
                        <button type="submit" class="btn btn-primary d-block w-100">Search</button>
                    </div>
                </div>
            </form>

            <div class="mb-3 d-flex gap-2">
                <a href="{{ route('account.report.excel', request()->all()) }}" class="btn btn-success btn-sm">
                    Download Excel
                </a>
                <a href="{{ route('account.report.pdf', request()->all()) }}" class="btn btn-danger btn-sm">
                    Download PDF
                </a>
            </div>

            {{-- ✅ Responsive Table --}}
            <div class="table-responsive">
                <table class="table table-bordered table-sm mt-3 text-nowrap">
                    <thead class="thead-light">
                        <tr>
                            <th>Sl</th>
                            <th>Bill No</th>
                            <th>Date</th>
                            <th>Outlet</th>
                            <th>Group</th>
                            <th>Sub Group</th>
                            <th>Description</th>
                            <th>Qty</th>
                            <th>Rate</th>
                            <th>Value</th>
                            <th>Supplier</th>
                            <th>Address</th>
                            <th>Warranty</th>
                            <th>Remarks</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $total = 0;
                            $outletNames = $outlets->pluck('outlet_name', 'id');
                            $supplierNames = $supplier->pluck('supplier_name', 'id');
                            $group_typeNames = $group->pluck('group_name', 'id');
                            $sub_group_typeNames = $sub_group->pluck('sub_group_name', 'id');
                        @endphp

                        @forelse($assets as $key => $item)
                            <tr>
                                <td>{{ $key + 1 }}</td>
                                <td>{{ $item->billNo }}</td>
                                <td>{{ $item->entryDate }}</td>
                                <td>{{ $outletNames[$item->outlet] ?? '-' }}</td>
                                <td>{{ $group_typeNames[$item->groupID] ?? '-' }}
                                </td>
                                <td>{{ $sub_group_typeNames[$item->subGroupID] ?? '-' }}</td>
                                <td>{{ $item->description }}</td>
                                <td>{{ $item->quantity }}</td>
                                <td>{{ $item->rate }}</td>
                                <td>{{ $item->amount }}</td>
                                <td>{{ $supplierNames[$item->supplier] ?? '-' }}</td>
                                <td>{{ $item->address }}</td>
                                <td>{{ $item->waranty }}</td>
                                <td>{{ $item->remarks }}</td>
                            </tr>
                            @php $total += $item->amount; @endphp
                        @empty
                            <tr>
                                <td colspan="13" class="text-center">No data found</td>
                            </tr>
                        @endforelse
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="8" class="text-right">Total</th>
                            <th colspan="5" class="bg-warning">{{ number_format($total, 2) }}</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </section>
@endsection