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

    <div class="card-body">
        <div class="form-group">
            <form action="{{ route('admin.sales-invoice-reports.filter') }}" method="GET">
                <div class="form-row d-flex align-items-center">
                    <div class="col-12 col-md-2">
                        <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-2">
                        <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">Customer</label>
                        <select class="form-control select2 {{ $errors->has('customer') ? 'is-invalid' : '' }}" name="customer" id="customer">
                            <option value="" hidden>Select a customer</option>
                            @foreach($customers as $id => $customer_name)
                                <option value="{{ $id }}" {{ request()->input('customer') == $id ? 'selected' : '' }}>{{ $customer_name }}</option>
                            @endforeach
                        </select>
                        @if($errors->has('customer'))
                            <div class="invalid-feedback">
                                {{ $errors->first('customer') }}
                            </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 $agent_name => $data)
                            <tr>
                                <th>Agent Name : </th>
                                <th colspan="6">{{ $agent_name }}</th>
                            </tr>
                            <tr>
                                <th>Issue Date</th>
                                <th>Due Date</th>
                                <th>Tax</th>
                                <th>Discount</th>
                                <th>Remark</th>
                                <th>Amount (RM)</th>
                            </tr>
                            @php
                                $amount = 0;
                            @endphp
                            @foreach ($data as $transaction)
                                <tr>
                                    @php
                                        $amount += $transaction->subtotal_amount;
                                    @endphp
                                    <td>{{ $transaction->issue_date }}</td>
                                    <td>{{ $transaction->due_date }}</td>
                                    <td>{{ number_format((float)$transaction->tax, 2, '.', '') }}</td>
                                    <td>{{ number_format((float)$transaction->discount, 2, '.', '') }}</td>
                                    <td>{{ $transaction->remark }}</td>
                                    <td>{{ number_format((float)$transaction->subtotal_amount, 2, '.', '') }}</td>
                                </tr>
                            @endforeach
                            <tr>
                                <th colspan="5">Total Amount : </th>
                                <th>{{ number_format((float)$amount, 2, '.', '') }}</th>
                            </tr>
                        @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