@extends('layouts.app')

@section('title', 'Assessments')

@section('content')
    <div>
        <div class="d-flex align-items-center justify-content-between mb-3">
            <h4 class="mb-0"><i class="bi bi-calculator me-2"></i>Assessments</h4>
        </div>

        {{-- Top Filters (client-side only) --}}
        <div class="card shadow-sm mb-3">
            <div class="card-body">
                <form class="row g-2" id="filtersForm">
                    <div class="col-md-3">
                        <label class="form-label small text-muted">Quick Filter (q)</label>
                        <input type="text" id="fltQ" class="form-control form-control-sm"
                            placeholder="application no / business / type / status">
                    </div>
                    <div class="col-md-2">
                        <label class="form-label small text-muted">Tax Year</label>
                        <input type="number" id="fltYear" class="form-control form-control-sm" placeholder="e.g. 2025">
                    </div>
                    <div class="col-md-3 d-flex align-items-end gap-2">
                        <button type="button" id="btnApply" class="btn btn-primary btn-sm">
                            <i class="bi bi-search me-1"></i> Apply
                        </button>
                        <button type="button" id="btnReset" class="btn btn-outline-secondary btn-sm">
                            <i class="bi bi-arrow-clockwise me-1"></i> Reset
                        </button>
                    </div>
                </form>
            </div>
        </div>

        {{-- Table (static rows rendered via PHP loop) --}}
        <div class="card shadow-sm">
            <div class="card-body">
                <div class="table-responsive">
                    <table id="assessmentsTable" class="table table-sm table-bordered align-middle" style="width:100%">
                        <thead class="table-light">
                            <tr>
                                <th class="bg-success text-white">Application No</th>
                                <th class="bg-success text-white">Business</th>
                                <th class="bg-success text-white">Type</th>
                                <th class="bg-success text-white">Tax Year</th>
                                <th class="bg-success text-white">Subtotal</th>
                                <th class="bg-success text-white">Surcharge</th>
                                <th class="bg-success text-white">Interest</th>
                                <th class="bg-success text-white">Total Due</th>
                                <th class="bg-success text-white">Status</th>
                                <th class="bg-success text-white">Assessed At</th>
                                <th class="bg-success text-white" style="width:100px;">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                // Static sample dataset; swap with real data later
                                $rows = [
                                    [
                                        'app_no' => 'APP-2025-0001',
                                        'business' => 'Acme Retail Hub',
                                        'type' => 'New',
                                        'year' => 2025,
                                        'subtotal' => 10000,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2025-01-10 14:32',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0002',
                                        'business' => 'Bluefin Bistro',
                                        'type' => 'Renewal',
                                        'year' => 2025,
                                        'subtotal' => 7500,
                                        'surcharge' => 150,
                                        'interest' => 75,
                                        'status' => 'For Payment',
                                        'assessed_at' => '2025-01-12 09:05',
                                    ],
                                    [
                                        'app_no' => 'APP-2024-0103',
                                        'business' => 'Cloud Nine Salon',
                                        'type' => 'Renewal',
                                        'year' => 2024,
                                        'subtotal' => 5200,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2024-12-28 16:10',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0004',
                                        'business' => 'Dawn Logistics',
                                        'type' => 'New',
                                        'year' => 2025,
                                        'subtotal' => 20000,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2025-01-15 11:20',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0005',
                                        'business' => 'Evergreen Pharmacy',
                                        'type' => 'Renewal',
                                        'year' => 2025,
                                        'subtotal' => 12300,
                                        'surcharge' => 246,
                                        'interest' => 61.5,
                                        'status' => 'For Payment',
                                        'assessed_at' => '2025-01-18 10:02',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0006',
                                        'business' => 'Frosty Scoops',
                                        'type' => 'New',
                                        'year' => 2025,
                                        'subtotal' => 3800,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2025-01-20 13:44',
                                    ],
                                    [
                                        'app_no' => 'APP-2024-0107',
                                        'business' => 'Golden Gear Auto',
                                        'type' => 'Renewal',
                                        'year' => 2024,
                                        'subtotal' => 8600,
                                        'surcharge' => 172,
                                        'interest' => 43,
                                        'status' => 'For Payment',
                                        'assessed_at' => '2024-12-22 09:30',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0008',
                                        'business' => 'Harbor Techworks',
                                        'type' => 'New',
                                        'year' => 2025,
                                        'subtotal' => 25000,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2025-01-22 15:18',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0009',
                                        'business' => 'Island Books & Café',
                                        'type' => 'New',
                                        'year' => 2025,
                                        'subtotal' => 4200,
                                        'surcharge' => 84,
                                        'interest' => 21,
                                        'status' => 'For Payment',
                                        'assessed_at' => '2025-01-23 08:12',
                                    ],
                                    [
                                        'app_no' => 'APP-2025-0010',
                                        'business' => 'Jade Wellness Center',
                                        'type' => 'Renewal',
                                        'year' => 2025,
                                        'subtotal' => 9950,
                                        'surcharge' => 0,
                                        'interest' => 0,
                                        'status' => 'Assessed',
                                        'assessed_at' => '2025-01-25 17:55',
                                    ],
                                ];
                                $nf = function ($n) {
                                    return number_format((float) $n, 2, '.', ',');
                                };
                            @endphp

                            @foreach ($rows as $r)
                                @php
                                    $total = (float) $r['subtotal'] + (float) $r['surcharge'] + (float) $r['interest'];
                                @endphp
                                <tr>
                                    <td>{{ $r['app_no'] }}</td>
                                    <td>{{ $r['business'] }}</td>
                                    <td>{{ $r['type'] }}</td>
                                    <td class="text-end">{{ (int) $r['year'] }}</td>
                                    <td class="text-end">{{ $nf($r['subtotal']) }}</td>
                                    <td class="text-end">{{ $nf($r['surcharge']) }}</td>
                                    <td class="text-end">{{ $nf($r['interest']) }}</td>
                                    <td class="text-end fw-semibold">{{ $nf($total) }}</td>
                                    <td>{{ $r['status'] }}</td>
                                    <td>{{ $r['assessed_at'] }}</td>
                                    <td class="text-center">
                                        <div class="btn-group btn-group-sm">
                                            <button class="btn btn-outline-primary" type="button" disabled
                                                title="View (static)">
                                                <i class="bi bi-eye"></i>
                                            </button>
                                            <button class="btn btn-outline-secondary" type="button" disabled
                                                title="Print (static)">
                                                <i class="bi bi-printer"></i>
                                            </button>
                                        </div>
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>

                <div class="small text-muted mt-2">
                    Tip: Use the table’s search box for quick, global matching; top filters narrow before the table renders.
                </div>
            </div>
        </div>
    </div>
@endsection

@push('scripts')
    <script>
        (function() {
            'use strict';

            $(function() {
                const toNum = function(v) {
                    if (v == null) return 0;
                    var s = String(v).replace(/[, ]+/g, '');
                    var n = Number(s);
                    return isFinite(n) ? n : 0;
                };

                const rowClasses = 'table-warning table-danger table-light';

                const table = $('#assessmentsTable').DataTable({
                    processing: false,
                    serverSide: false, // client-side only
                    searching: true,
                    lengthChange: true,
                    order: [
                        [9, 'desc']
                    ], // Assessed At (col index 9) desc
                    columnDefs: [
                        // ensure numeric sorting for money columns
                        {
                            targets: [4, 5, 6, 7],
                            render: function(data, type) {
                                var n = toNum(data);
                                if (type === 'sort' || type === 'type') return n;
                                // keep existing formatted string for display
                                return data;
                            }
                        }
                    ],
                    rowCallback: function(row) {
                        $(row).removeClass(rowClasses);
                        var $cells = $('td', row);
                        var surcharge = toNum($cells.eq(5).text());
                        var interest = toNum($cells.eq(6).text());
                        var total = toNum($cells.eq(7).text());
                        if (total < 0) {
                            $(row).addClass('table-danger');
                        } else if (surcharge + interest > 0) {
                            $(row).addClass('table-warning');
                        } else if (total === 0) {
                            $(row).addClass('table-light');
                        }
                    }
                });

                // Top filter wiring (client-side)
                $('#btnApply').on('click', function() {
                    var q = $('#fltQ').val() || '';
                    var year = $('#fltYear').val() || '';
                    table.search(q);
                    table.column(3).search(year); // Tax Year col index
                    table.draw();
                });

                $('#btnReset').on('click', function() {
                    $('#fltQ').val('');
                    $('#fltYear').val('');
                    table.search('');
                    table.columns().search('');
                    table.draw();
                });
            });
        })();
    </script>
@endpush