@extends('admin.layouts.master')
@section('title', 'Sale Report | Vogue Technics')

@section('styles')
    <style>
        .table td,
        .table th {
            font-size: 10px;
            border: 1px solid #dee2e6 !important;
            /* border: 1px solid #000000 !important; */
            vertical-align: middle !important;
            text-align: center !important;
            color: var(--bs-table-color-state, var(--bs-table-color-type, var(--bs-table-color))); !important;
            /* color: #000000 !important; */
            padding: 4px !important;
            border-collapse: collapse !important;
        }
        [data-bs-theme="dark"] .table td,
        [data-bs-theme="dark"] .table th,
        [data-bs-theme="dark"] .table tr
        {
            background: transparent !important;
        }
        /* .table tr {
            border: 1px solid #000000 !important;
        } */

        @media print {
            @page {
                size: A4 portrait;
                margin: 6mm;
            }

            html,
            body {
                background: #fff !important;
                margin: 0 !important;
                padding: 0 !important;
                overflow: visible !important;
                color: #000 !important;
            }

            body * {
                visibility: hidden !important;
                background: #fff !important;
            }

            .print-area,
            .print-area * {
                width: 100% !important;
                visibility: visible !important;
            }

            .print-area {
                position: absolute !important;
                left: 0 !important;
                top: 0 !important;
                width: 100% !important;
                overflow: visible !important;
            }

            .card,
            .card-body,
            .card-header,
            .table-responsive,
            .row,
            .col-12 {
                border: 0 !important;
                box-shadow: none !important;
                padding: 0 !important;
                margin: 0 !important;
                overflow: visible !important;
                background: #fff !important;
                color: #000 !important;
            }

            .table {
                table-layout: auto !important;
                width: 100% !important;
                border-collapse: collapse;
                color: #000 !important;
            }

            .table td,
            .table th {
                width: auto !important;
                font-size: 7px !important;
                padding: 2px !important;
                word-wrap: break-word;
                overflow-wrap: break-word;
                color: #000 !important;
            }

            .table-responsive {
                overflow: visible !important;
            }

            .no-print {
                display: none !important;
            }
        }
    </style>
@endsection

@section('content')
    <section>
        <div class="row">
            <div class="col-12 no-print">
                <div class="card">
                    <div class="card-header py-2">
                        <h3 class="card-title m-0">Filters</h3>
                    </div>
                    <div class="card-body">
                        <form method="GET" action="{{ route('reports.sale') }}" class="row g-3 align-items-end">
                            <div class="col-12 col-md-3">
                                <label class="form-label" for="from_date">From Date</label>
                                <input type="text" id="from_date" name="from_date" class="form-control flatpickr-date" placeholder="YYYY-MM-DD" value="{{ request('from_date') ?? now()->format('Y-m-d') }}">
                            </div>
                            <div class="col-12 col-md-3">
                                <label class="form-label" for="to_date">To Date</label>
                                <input type="text" id="to_date" name="to_date" class="form-control flatpickr-date" placeholder="YYYY-MM-DD" value="{{ request('to_date') ?? now()->format('Y-m-d') }}">
                            </div>
                            <div class="col-12 col-md-3">
                                <label class="form-label" for="vrm">VRM</label>
                                <input type="text" id="vrm" name="vrm" class="form-control" placeholder="ASDFGHJK" value="{{ request('vrm') ?? '' }}">
                            </div>
                            <div class="col-12 col-md-3">
                                <label for="user_id" class="form-label">User</label>
                                <select id="user_id" name="user_id" class="select2 form-select" data-allow-clear="true" data-placeholder="Select User">
                                    <option value=""></option>
                                    @foreach ($users as $user)
                                        <option value="{{ $user->id }}"
                                            {{ (string) request('user_id') === (string) $user->id ? 'selected' : '' }}>
                                            {{ $user->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-12 mt-4">
                                <div class="d-flex gap-2 justify-content-end">
                                    <button type="submit" class="btn btn-primary">Apply Filters</button>
                                    <a href="{{ route(
                                        'reports.sale',
                                        array_filter([
                                            'from_date' => request('from_date'),
                                            'to_date' => request('to_date'),
                                            'user_id' => request('user_id'),
                                            'vrm' => request('vrm'),
                                            'export' => 'csv',
                                        ]),
                                    ) }}"
                                        class="btn btn-primary">
                                        <i class="icon-base ti tabler-file-spreadsheet me-1"></i>Download CSV
                                    </a>
                                    <a href="{{ route('reports.sale') }}" class="btn btn-label-secondary">Reset</a>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>

            <div class="col-12 mt-4 print-area">
                <div class="card">
                    <div class="card-header py-3 d-flex justify-content-between align-items-center no-print">
                        <h3 class="card-title mb-0">Sale Report</h3>
                        <button type="button" class="btn btn-primary" id="printSaleReport">
                            <i class="icon-base ti tabler-printer me-1"></i>Print
                        </button>
                    </div>
                    <div class="card-header py-2 d-none d-print-block">
                        <h3 class="card-title mb-1">Sale Report</h3>
                        <p class="mb-0 text-muted small">
                            @if (request('from_date') || request('to_date'))
                                Period:
                                {{ request('from_date') ?: 'Start' }}
                                to
                                {{ request('to_date') ?: 'Today' }}
                            @endif
                            @if (request('user_id'))
                                |
                                User:
                                {{ optional($users->firstWhere('id', (int) request('user_id')))->name ?: 'Selected User' }}
                            @endif
                            @if (request('vrm'))
                                |
                                VRM:
                                {{ request('vrm') }}
                            @endif
                        </p>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered" id="saleReportTable" style="border: 2px solid #dee2e6;">
                                <thead>
                                    <tr style="background-color:#f8f9fa;border:1px solid #dee2e6;">
                                        <th rowspan="2"><b>Sr #</b></th>
                                        <th rowspan="2"><b>Sale #</b></th>
                                        <th rowspan="2"><b>VRM</b></th>
                                        <th rowspan="2"><b>Customer</b></th>
                                        <th rowspan="2"><b>Date</b></th>
                                        <th rowspan="2"><b>Created By</b></th>
                                        <th colspan="5"><b>Parts Detail</b></th>
                                        <th rowspan="2" style="text-align: end;"><b>Sub Total</b></th>
                                        <th rowspan="2" style="text-align: end;"><b>Initial Deposit</b></th>
                                        <th rowspan="2" style="text-align: end;"><b>Discount</b></th>
                                        <th rowspan="2" style="text-align: end;"><b>VAT</b></th>
                                        <th rowspan="2" style="text-align: end;"><b>Total</b></th>
                                    </tr>
                                    <tr style="background-color:#f8f9fa;border:1px solid #dee2e6;">
                                        <th><b>Part Name</b></th>
                                        <th><b>Description</b></th>
                                        <th style="text-align: end;"><b>Qty</b></th>
                                        <th style="text-align: end;"><b>Unit Price</b></th>
                                        <th style="text-align: end;"><b>Total</b></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($saleInvoices as $invoice)

                                        @php
                                            $rowCount = max(1, $invoice->details->count());
                                        @endphp

                                        @if ($invoice->details->count())
                                            @foreach ($invoice->details as $detail)
                                                <tr>
                                                    @if ($loop->first)
                                                        <td rowspan="{{ $rowCount }}">{{ $loop->parent->iteration }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="white-space: nowrap">
                                                            <a href="{{ route('sale-invoices.invoice.show', $invoice->id) }}" target="_blank">
                                                                {{ $invoice->sale_number }}
                                                            </a>
                                                        </td>
                                                        <td rowspan="{{ $rowCount }}">{{ $invoice->vrm ?: 'N/A' }}</td>
                                                        <td rowspan="{{ $rowCount }}">{{ $invoice->name ?: 'N/A' }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="white-space: nowrap">{{ optional($invoice->date)->format('d-M-Y') }}</td>
                                                        <td rowspan="{{ $rowCount }}">{{ $invoice->createdByUser?->name ?: 'N/A' }}</td>
                                                    @endif

                                                    <td>{{ $detail->part?->name ?: 'N/A' }}</td>
                                                    <td>{{ $detail->description ?: 'N/A' }}</td>
                                                    <td style="text-align: end;">{{ $detail->qty }}</td>
                                                    <td style="text-align: end;">{{ number_format((float) $detail->amount, 2) }}</td>
                                                    <td style="text-align: end;">{{ number_format((float) $detail->total_amount, 2) }}</td>

                                                    @if ($loop->first)
                                                        <td rowspan="{{ $rowCount }}" style="text-align: end;">{{ number_format((float) $invoice->sub_total, 2) }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="text-align: end;">{{ number_format((float) $invoice->initial_deposit, 2) }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="text-align: end;">{{ number_format((float) $invoice->discount, 2) }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="text-align: end;">{{ number_format((float) $invoice->vat, 2) }}</td>
                                                        <td rowspan="{{ $rowCount }}" style="text-align: end;">{{ number_format((float) $invoice->total, 2) }}</td>
                                                    @endif
                                                </tr>
                                            @endforeach
                                        @else
                                            <tr>
                                                <td>{{ $loop->iteration }}</td>
                                                <td>
                                                    <a href="{{ route('sale-invoices.invoice.show', $invoice->id) }}" target="_blank">
                                                        {{ $invoice->sale_number }}
                                                    </a>
                                                </td>
                                                <td>{{ $invoice->vrm ?: 'N/A' }}</td>
                                                <td>{{ $invoice->name ?: 'N/A' }}</td>
                                                <td>{{ optional($invoice->date)->format('d-M-Y') }}</td>
                                                <td>{{ $invoice->createdByUser?->name ?: 'N/A' }}</td>

                                                <td>N/A</td>
                                                <td>N/A</td>
                                                <td style="text-align:end;">0</td>
                                                <td style="text-align:end;">0.00</td>
                                                <td style="text-align:end;">0.00</td>

                                                <td style="text-align:end;">{{ number_format((float) $invoice->sub_total, 2) }}</td>
                                                <td style="text-align:end;">{{ number_format((float) $invoice->initial_deposit, 2) }}</td>
                                                <td style="text-align:end;">{{ number_format((float) $invoice->discount, 2) }}</td>
                                                <td style="text-align:end;">{{ number_format((float) $invoice->vat, 2) }}</td>
                                                <td style="text-align:end;">{{ number_format((float) $invoice->total, 2) }}</td>
                                            </tr>
                                        @endif

                                        {{-- <tr style="background-color:#f8f9fa;border:1px solid #dee2e6;">
                                            <td colspan="3"><b>Served By:</b>
                                                {{ $invoice->served_by ?: 'N/A' }}</td>
                                            <td colspan="4"><b>Bank:</b> {{ $invoice->bank?->name ?: 'N/A' }}</td>
                                            <td colspan="4"><b>Sort Code:</b> {{ $invoice->bank?->sort_code ?: 'N/A' }}</td>
                                            <td colspan="4"><b>Account #:</b>
                                                {{ $invoice->bank?->account_number ?: 'N/A' }}</td>
                                        </tr> --}}
                                    @empty
                                        <tr>
                                            <td colspan="15" class="text-center">
                                                No sale report data found for the selected filters.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="11" style="text-align: right;"><b>Grand Total</b></th>
                                        <th style="text-align: end;"><b>{{ number_format((float) $saleInvoices->sum('sub_total'), 2) }}</b></th>
                                        <th style="text-align: end;"><b>{{ number_format((float) $saleInvoices->sum('initial_deposit'), 2) }}</b></th>
                                        <th style="text-align: end;"><b>{{ number_format((float) $saleInvoices->sum('discount'), 2) }}</b></th>
                                        <th style="text-align: end;"><b>{{ number_format((float) $saleInvoices->sum('vat'), 2) }}</b></th>
                                        <th style="text-align: end;"><b>{{ number_format((float) $saleInvoices->sum('total'), 2) }}</b></th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection

@section('scripts')
    <script>
        $(document).ready(function() {
            $('#printSaleReport').on('click', function() {
                window.print();
            });
        });
    </script>
@endsection