@extends('layouts.app')

@section('content')
<style>
/* Modern Table Styling */
.modern-table {
    border-collapse: separate;
    border-spacing: 0;
}

.modern-table thead th {
    background: #17479E !important;
    color: white !important;
    border: none !important;
    padding: 1.2rem 1.5rem !important;
    font-weight: 700 !important;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    font-size: 0.85rem;
}

.modern-table tbody tr {
    transition: all 0.2s ease;
}

.modern-table tbody tr:hover {
    background: rgba(23, 71, 158, 0.08) !important;
}

.modern-btn {
    background: #17479E !important;
    color: white !important;
    border: 1px solid #17479E !important;
    border-radius: 8px;
    padding: 0.6rem 1rem;
    font-weight: 600;
    transition: all 0.3s ease;
    text-decoration: none;
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    font-size: 0.875rem;
    white-space: nowrap;
}

.modern-btn:hover {
    background: #0f3470 !important;
    color: white !important;
    border-color: #0f3470 !important;
    transform: translateY(-2px);
    box-shadow: 0 4px 12px rgba(23, 71, 158, 0.3);
}

.card {
    border-radius: 16px !important;
    border: none !important;
    box-shadow: 0 8px 25px rgba(23, 71, 158, 0.15);
}

.dropdown {
    position: static !important;
}

.dropdown-menu {
    border: none;
    box-shadow: 0 8px 30px rgba(0,0,0,0.15);
    border-radius: 12px;
    padding: 8px 0;
    min-width: 200px;
    z-index: 9999 !important;
    margin-top: 0.5rem;
    position: absolute !important;
}

.dropdown-item {
    padding: 12px 20px;
    font-size: 14px;
    font-weight: 500;
    border-radius: 6px;
    margin: 2px 8px;
    transition: background-color 0.2s ease, color 0.2s ease;
    display: flex;
    align-items: center;
    color: #333;
}

.dropdown-item:hover {
    background: #17479E;
    color: white !important;
}

.dropdown-item:hover i {
    color: white !important;
}

.dropdown-item i {
    margin-right: 10px;
    width: 20px;
    text-align: center;
    flex-shrink: 0;
}

.dropdown-divider {
    margin: 6px 12px;
    border-color: #e9ecef;
}

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

.card-body {
    overflow-x: auto;
}

.form-control, .form-select {
    border: 2px solid rgba(23, 71, 158, 0.1);
    border-radius: 8px;
    padding: 0.75rem 1rem;
    transition: all 0.3s ease;
}

.form-control:focus, .form-select:focus {
    border-color: #17479E;
    box-shadow: 0 0 0 0.2rem rgba(23, 71, 158, 0.25);
}

.icon-wrapper {
    background: rgba(23, 71, 158, 0.1);
    padding: 0.5rem;
    border-radius: 8px;
    display: inline-flex;
    align-items: center;
    justify-content: center;
}

.quick-filter-btn {
    border-radius: 20px;
    padding: 0.4rem 1rem;
    font-size: 0.875rem;
    transition: all 0.3s ease;
}

.quick-filter-btn:hover {
    transform: translateY(-2px);
    box-shadow: 0 4px 12px rgba(23, 71, 158, 0.2);
}
</style>

{{-- PAGE HEADER WITH BREADCRUMB --}}
<div class="card border-0 shadow-sm mb-4" style="background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);">
    <div class="card-body py-3">
        <div class="d-flex flex-wrap align-items-center justify-content-between gap-3">
            
            {{-- Title Section --}}
            <div class="d-flex align-items-center gap-3">
                <div class="icon-wrapper">
                    <i class="fas fa-hand-holding-usd text-primary fs-4"></i>
                </div>
                <h5 class="fw-bold mb-0 text-dark">Salary Loans</h5>
            </div>
            
            {{-- Breadcrumb Path --}}
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0">
                    <li class="breadcrumb-item">
                        <a href="{{ route('dashboard') }}" class="text-decoration-none text-secondary">
                            <i class="fas fa-home me-1"></i>Dashboard
                        </a>
                    </li>
                    <li class="breadcrumb-item active" aria-current="page">
                        <span class="badge bg-primary text-white" style="font-weight: 500;">
                            Salary Loans
                        </span>
                    </li>
                </ol>
            </nav>
            
        </div>
    </div>
</div>

{{-- IMPROVED FILTER CARD --}}
<form action="{{ route('deductions.salary.loans') }}" method="GET" id="filterForm">
    <div class="card mb-4">
        
        {{-- CARD HEADER: Title na Count --}}
        <div class="card-header py-3" style="background: linear-gradient(135deg, #f8f9fa 0%, #ffffff 100%); border-bottom: 2px solid rgba(23, 71, 158, 0.1);">
            <div class="d-flex justify-content-between align-items-center">
                {{-- Title kuu ya Filter --}}
                <div class="d-flex align-items-center gap-2">
                    <div class="icon-wrapper">
                        <i class="bi bi-funnel-fill text-primary fs-5"></i>
                    </div>
                    <h6 class="mb-0 fw-bold text-dark">Filter Options</h6>
                </div>
                
                {{-- Count ya records --}}
                <div class="d-flex align-items-center gap-2">
                    <span class="text-muted fw-normal" style="font-size: 0.9rem;">Total Loans:</span>
                    <span class="badge bg-primary px-3 py-2" style="font-size: 0.95rem; font-weight: 600;">
                        {{ number_format($salaryLoans->total()) }}
                    </span>
                </div>
            </div>
        </div>

        {{-- CARD BODY: Form ya Filters --}}
        <div class="card-body p-4">
            <div class="row g-4">
                
                {{-- ROW 1: Date, Check Number, First Name --}}
                <div class="col-lg-4 col-md-6">
                    <label for="date" class="form-label fw-semibold text-dark mb-2">
                        <i class="bi bi-calendar-event text-primary me-2"></i>
                        Check Date
                    </label>
                    <input type="date" 
                           name="date" 
                           id="date" 
                           class="form-control"
                           value="{{ request('date', $date) }}">
                    <small class="text-muted mt-1 d-block">
                        <i class="bi bi-info-circle me-1"></i>
                        Filter by payment date
                    </small>
                </div>
                
                <div class="col-lg-4 col-md-6">
                    <label for="checkNumber" class="form-label fw-semibold text-dark mb-2">
                        <i class="bi bi-hash text-primary me-2"></i>
                        Check Number
                    </label>
                    <input type="text" 
                           name="checkNumber" 
                           id="checkNumber" 
                           class="form-control" 
                           placeholder="Enter check number" 
                           value="{{ request('checkNumber', $checkNumber) }}">
                    <small class="text-muted mt-1 d-block">
                        <i class="bi bi-info-circle me-1"></i>
                        Search by check number
                    </small>
                </div>

                <div class="col-lg-4 col-md-6">
                    <label for="firstName" class="form-label fw-semibold text-dark mb-2">
                        <i class="bi bi-person text-primary me-2"></i>
                        First Name
                    </label>
                    <input type="text" 
                           name="firstName" 
                           id="firstName" 
                           class="form-control" 
                           placeholder="Enter first name" 
                           value="{{ request('firstName', $firstName) }}">
                    <small class="text-muted mt-1 d-block">
                        <i class="bi bi-info-circle me-1"></i>
                        Search by first name
                    </small>
                </div>

                {{-- ROW 2: Middle Name, Last Name, Action Buttons --}}
                <div class="col-lg-4 col-md-6">
                    <label for="middleName" class="form-label fw-semibold text-dark mb-2">
                        <i class="bi bi-person-badge text-primary me-2"></i>
                        Middle Name
                    </label>
                    <input type="text" 
                           name="middleName" 
                           id="middleName" 
                           class="form-control" 
                           placeholder="Enter middle name" 
                           value="{{ request('middleName', $middleName) }}">
                    <small class="text-muted mt-1 d-block">
                        <i class="bi bi-info-circle me-1"></i>
                        Search by middle name
                    </small>
                </div>

                <div class="col-lg-4 col-md-6">
                    <label for="lastName" class="form-label fw-semibold text-dark mb-2">
                        <i class="bi bi-person-check text-primary me-2"></i>
                        Last Name
                    </label>
                    <input type="text" 
                           name="lastName" 
                           id="lastName" 
                           class="form-control" 
                           placeholder="Enter last name" 
                           value="{{ request('lastName', $lastName) }}">
                    <small class="text-muted mt-1 d-block">
                        <i class="bi bi-info-circle me-1"></i>
                        Search by last name
                    </small>
                </div>

                {{-- ACTION BUTTONS --}}
                <div class="col-lg-4 col-md-12">
                    <label class="form-label fw-semibold text-dark mb-2 d-none d-lg-block">
                        &nbsp;
                    </label>
                    <div class="d-flex gap-2">
                        {{-- Filter Button --}}
                        <button type="submit" name="action" value="view" class="btn btn-primary flex-fill">
                            <i class="bi bi-funnel me-2"></i>
                            Apply Filter
                        </button>
                        
                        {{-- Export Button --}}
                        <button type="submit" name="action" value="export" class="btn btn-success flex-fill">
                            <i class="bi bi-file-earmark-excel me-2"></i>
                            Export Excel
                        </button>
                    </div>
                </div>
                
            </div>
            
            {{-- QUICK FILTERS --}}
            <div class="row mt-4 pt-3" style="border-top: 1px dashed rgba(23, 71, 158, 0.2);">
                <div class="col-12">
                    <div class="d-flex flex-wrap align-items-center gap-2">
                        <small class="text-muted fw-semibold me-2">
                            <i class="bi bi-lightning-fill me-1"></i>
                            Quick Filters:
                        </small>
                        <button type="button" class="btn btn-sm btn-outline-primary quick-filter-btn" onclick="setToday()">
                            <i class="bi bi-calendar-check me-1"></i>
                            Today
                        </button>
                        <button type="button" class="btn btn-sm btn-outline-primary quick-filter-btn" onclick="setThisMonth()">
                            <i class="bi bi-calendar-month me-1"></i>
                            This Month
                        </button>
                        <button type="button" class="btn btn-sm btn-outline-primary quick-filter-btn" onclick="setLastMonth()">
                            <i class="bi bi-calendar2-month me-1"></i>
                            Last Month
                        </button>
                        <a href="{{ route('deductions.salary.loans') }}" class="btn btn-sm btn-outline-secondary quick-filter-btn ms-auto">
                            <i class="bi bi-arrow-clockwise me-1"></i>
                            Reset All
                        </a>
                    </div>
                </div>
            </div>
            
        </div>
    </div>
</form>

{{-- SALARY LOAN LIST TABLE --}}
<div class="card border-0 shadow-lg">
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0 modern-table" style="width:100%">
                <thead>
                    <tr class="text-white">
                        <th width="60" class="text-center border-0">
                            <div class="d-flex align-items-center justify-content-center">
                                <i class="fas fa-hashtag me-1"></i>
                                <span class="fw-bold">SN</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-id-card me-2"></i>
                                <span class="fw-bold">Check Number</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-user me-2"></i>
                                <span class="fw-bold">Name</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-money-bill-wave me-2"></i>
                                <span class="fw-bold">Monthly Salary</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-calculator me-2"></i>
                                <span class="fw-bold">Deduction Amount</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-wallet me-2"></i>
                                <span class="fw-bold">Balance Amount</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-file-alt me-2"></i>
                                <span class="fw-bold">Description</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-code me-2"></i>
                                <span class="fw-bold">Vote Code</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-building me-2"></i>
                                <span class="fw-bold">Department</span>
                            </div>
                        </th>
                        <th class="border-0">
                            <div class="d-flex align-items-center">
                                <i class="fas fa-calendar-alt me-2"></i>
                                <span class="fw-bold">Month</span>
                            </div>
                        </th>
                        <th class="border-0 text-center">
                            <div class="d-flex align-items-center justify-content-center">
                                <i class="fas fa-tools me-2"></i>
                                <span class="fw-bold">Actions</span>
                            </div>
                        </th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($salaryLoans as $index => $record)
                    <tr>
                        <td class="text-center align-middle">
                            <div class="badge" style="background: #17479E; color: white; font-weight: bold; width: 35px; height: 35px; display: flex; align-items: center; justify-content: center; border-radius: 50%;">
                                {{ $salaryLoans->firstItem() + $index }}
                            </div>
                        </td>
                        <td class="align-middle">{{ $record->checkNumber }}</td>
                        <td class="align-middle text-uppercase">{{ $record->firstName }} {{ $record->middleName }} {{ $record->lastName }}</td>
                        <td class="align-middle">
                            <span class="badge bg-info-subtle text-info px-2 py-1">
                                TSh {{ number_format($record->monthlySalary, 2) }}
                            </span>
                        </td>
                        <td class="align-middle">
                            <span class="badge bg-warning-subtle text-warning px-2 py-1">
                                TSh {{ number_format($record->deductionAmount, 2) }}
                            </span>
                        </td>
                        <td class="align-middle">
                            <span class="badge bg-success-subtle text-success px-2 py-1">
                                TSh {{ number_format($record->balanceAmount, 2) }}
                            </span>
                        </td>
                        <td class="align-middle">{{ $record->deductionDesc }}</td>
                        <td class="align-middle">{{ $record->voteCode }}</td>
                        <td class="align-middle text-uppercase">{{ $record->deptName }}</td>
                        <td class="align-middle">{{ number_format($record->month, 0) }}</td>
                        <td class="align-middle text-center">
                            <div class="dropdown">
                                <button class="btn btn-sm dropdown-toggle modern-btn" type="button" data-bs-toggle="dropdown" aria-expanded="false">
                                    <i class="fas fa-cog"></i> Actions
                                </button>
                                <ul class="dropdown-menu shadow border-0" style="min-width: 200px;">
                                    <li>
                                        <a class="dropdown-item" href="{{ route('deductions.details', ['checkNumber' => $record->checkNumber]) }}">
                                            <i class="bx bx-show text-primary"></i>Loan Details
                                        </a>
                                    </li>
                                    <li><hr class="dropdown-divider"></li>
                                    <li>
                                        <a class="dropdown-item" href="{{ route('deductions.contributiondetails', ['checkNumber' => $record->checkNumber]) }}">
                                            <i class="bx bx-show text-info"></i>Contribution Details
                                        </a>
                                    </li>
                                </ul>
                            </div>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="11" class="text-center py-5">
                            <div class="text-muted">
                                <i class="fas fa-inbox fa-3x mb-3 opacity-50"></i>
                                <h5>No salary loans found</h5>
                                <p>No salary loan records available for the selected filters.</p>
                            </div>
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
    
    {{-- PAGINATION FOOTER --}}
    @if($salaryLoans->hasPages())
    <div class="card-footer bg-light">
        <div class="d-flex justify-content-between align-items-center">
            <div class="text-muted small">
                Showing {{ $salaryLoans->firstItem() }} to {{ $salaryLoans->lastItem() }} of {{ $salaryLoans->total() }} entries
            </div>
            <div>
                {{ $salaryLoans->links('pagination::bootstrap-5') }}
            </div>
        </div>
    </div>
    @endif
</div>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">

<script>
    // Quick Filter Functions
    function setToday() {
        const today = new Date();
        const dateStr = today.toISOString().split('T')[0];
        document.getElementById('date').value = dateStr;
    }

    function setThisMonth() {
        const now = new Date();
        const firstDay = new Date(now.getFullYear(), now.getMonth(), 1);
        const dateStr = firstDay.toISOString().split('T')[0];
        document.getElementById('date').value = dateStr;
    }

    function setLastMonth() {
        const now = new Date();
        const firstDayLastMonth = new Date(now.getFullYear(), now.getMonth() - 1, 1);
        const dateStr = firstDayLastMonth.toISOString().split('T')[0];
        document.getElementById('date').value = dateStr;
    }

    // NOTE: DataTables initialization has been removed to use Laravel pagination instead
</script>
@endsection