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

    <div class="card-body">
        <div class="form-group">
            <form action="{{ route('admin.sales-detail-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>
                    {{-- @cannot('isWarehouse')
                        <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>
                    @endcannot --}}
                    <div class="col-12 col-md-2">
                        <button class="btn btn-success d-inline-block" type="submit">Filter</button>
                    </div>
                </div>
            </form>
        </div>

        @isset ($recordData)
            <div class="form-group">
                <table class="table table-sm table-bordered">
                    <tbody>
                        @php
                            $grandTotalAmount = 0.00;
                        @endphp
                        <tr>
                            <th>Salesperson Name</th>
                            <th>Details</th>
                        </tr>
                        @foreach ($recordData as $salesperson_name => $data)
                            <tr>
                                <td>{{ $salesperson_name }}</td>
                                <td class="p-0">
                                @php
                                    $totalAmount = 0.00;
                                @endphp
                                    <table class="w-100">
                                        <tr>
                                            <th style="width: 80%;">Product Name</th>
                                            <th style="width: 10%;">Qty</th>
                                            <th style="width: 10%;">Amount (RM)</th>
                                        </tr>
                                        @foreach ($data as $element)
                                            @php
                                                $totalAmount += $element->amount;
                                            @endphp
                                            <tr>
                                                <td>{{ $element->product_name }}</td>
                                                <td align="center">{{ $element->quantity }}</td>
                                                <td align="right">{{ number_format($element->amount, 2, '.', '') }}</td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="2" align="right" style="width: 80%;"><b>Total:</b></td>
                                            <td align="right" style="width: 20%;">{{ number_format($totalAmount, 2, '.', '') }}</td>
                                            @php
                                                $grandTotalAmount += $totalAmount;
                                            @endphp
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        @endforeach
                        <tr>
                            <td></td>
                            <td class="p-0">
                                <table class="w-100">
                                    <tbody>
                                        <tr>
                                            <td colspan="2" align="right" style="width: 80%;">Grand Total Amount:</td>
                                            <td style="width: 20%;" align="right">{{ number_format($grandTotalAmount, 2, '.', '') }}</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>

            <div class="form-group">
                <a class="btn btn-success" href="{{ route('admin.sales-detail-reports.export', ['date_from' => request()->input('date_from'), 'date_to' => request()->input('date_to'), 'employee' => request()->input('employee')]) }}">Export</a>
                <a class="btn btn-info" href="{{ route('admin.sales-detail-reports.print', ['date_from' => request()->input('date_from'), 'date_to' => request()->input('date_to'), 'employee' => request()->input('employee')]) }}">Print</a>
            </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