@extends('layouts.app')
@section('customcss')
<style>
    .card-animate {
        transition: all 0.3s ease;
    }
    .card-animate:hover {
        transform: translateY(-5px);
        box-shadow: 0 0.5rem 1rem rgba(0, 0, 0, 0.15);
    }
    .search-box {
        position: relative;
    }
    .search-box .search-icon {
        position: absolute;
        top: 50%;
        right: 15px;
        transform: translateY(-50%);
        color: #878a99;
    }
    .noresult {
        padding: 3rem 0;
    }
</style>
@endsection
@section('content')
<div class="container-fluid">
    <!-- Page Title -->
    <div class="row">
        <div class="col-12">
            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                <h4 class="mb-sm-0">{{ __('Debtors & Creditors List') }}</h4>
                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="{{ url('/') }}">{{ __('Dashboard') }}</a></li>
                        <li class="breadcrumb-item"><a href="{{ route('customers.index') }}">{{ __('Customers') }}</a></li>
                        <li class="breadcrumb-item active">{{ __('Debtors List') }}</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row">
        <div class="col-xl-3 col-md-6">
            <!-- Total Debtors Card -->
            <div class="card card-animate">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1 overflow-hidden">
                            <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Debtors</p>
                        </div>
                        <div class="flex-shrink-0">
                            <h5 class="text-danger fs-14 mb-0">
                                <i class="ri-arrow-right-down-line fs-13 align-middle"></i> 
                                {{ $debtors->where('balance', '<', 0)->count() }}
                            </h5>
                        </div>
                    </div>
                    <div class="d-flex align-items-end justify-content-between mt-4">
                        <div>
                            <h4 class="fs-22 fw-semibold ff-secondary mb-4 text-danger">
                                <span class="counter-value" data-target="{{ abs($totalDebit ?? 0) }}">0</span>
                            </h4>
                            <a href="{{ route('debtors.list', ['balance_type' => 'negative']) }}" class="text-decoration-underline">View debtors only</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-danger-subtle rounded fs-3">
                                <i class="bx bx-trending-down text-danger"></i>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Total Creditors Card -->
            <div class="card card-animate">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1 overflow-hidden">
                            <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Creditors</p>
                        </div>
                        <div class="flex-shrink-0">
                            <h5 class="text-success fs-14 mb-0">
                                <i class="ri-arrow-right-up-line fs-13 align-middle"></i> 
                                {{ $debtors->where('balance', '>', 0)->count() }}
                            </h5>
                        </div>
                    </div>
                    <div class="d-flex align-items-end justify-content-between mt-4">
                        <div>
                            <h4 class="fs-22 fw-semibold ff-secondary mb-4 text-success">
                                <span class="counter-value" data-target="{{ $totalCredit ?? 0 }}">0</span>
                            </h4>
                            <a href="{{ route('debtors.list', ['balance_type' => 'positive']) }}" class="text-decoration-underline">View creditors only</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-success-subtle rounded fs-3">
                                <i class="bx bx-trending-up text-success"></i>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Net Balance Card -->
            <div class="card card-animate">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1 overflow-hidden">
                            <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Net Balance</p>
                        </div>
                        <div class="flex-shrink-0">
                            <h5 class="{{ ($netBalance ?? 0) < 0 ? 'text-danger' : 'text-success' }} fs-14 mb-0">
                                <i class="ri-arrow-{{ ($netBalance ?? 0) < 0 ? 'down' : 'up' }}-line fs-13 align-middle"></i> 
                                {{ ($netBalance ?? 0) < 0 ? 'Owing' : 'Owed' }}
                            </h5>
                        </div>
                    </div>
                    <div class="d-flex align-items-end justify-content-between mt-4">
                        <div>
                            <h4 class="fs-22 fw-semibold ff-secondary mb-4 {{ ($netBalance ?? 0) < 0 ? 'text-danger' : 'text-success' }}">
                                <span class="counter-value" data-target="{{ abs($netBalance ?? 0) }}">0</span>
                            </h4>
                            <a href="#" class="text-decoration-underline">Overall position</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-{{ ($netBalance ?? 0) < 0 ? 'warning' : 'info' }}-subtle rounded fs-3">
                                <i class="bx bx-wallet text-{{ ($netBalance ?? 0) < 0 ? 'warning' : 'info' }}"></i>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Total Accounts Card -->
            <div class="card card-animate">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1 overflow-hidden">
                            <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Accounts</p>
                        </div>
                        <div class="flex-shrink-0">
                            <h5 class="text-primary fs-14 mb-0">
                                Active
                            </h5>
                        </div>
                    </div>
                    <div class="d-flex align-items-end justify-content-between mt-4">
                        <div>
                            <h4 class="fs-22 fw-semibold ff-secondary mb-4">
                                <span class="counter-value" data-target="{{ $debtors->count() }}">0</span>
                            </h4>
                            <a href="{{ route('customers.index') }}" class="text-decoration-underline">View all customers</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-primary-subtle rounded fs-3">
                                <i class="bx bx-user-circle text-primary"></i>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Main Content Card -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header border-0">
                    <div class="row align-items-center">
                        <div class="col">
                            <h5 class="card-title mb-0">{{ __('Account Balances') }}</h5>
                        </div>
                        <div class="col-auto">
                            <button type="button" class="btn btn-soft-success btn-sm me-1" onclick="window.location='{{ route('debtors.list', array_merge(request()->all(), ['export' => 'csv'])) }}'">
                                <i class="ri-file-excel-line align-bottom me-1"></i> {{ __('Export CSV') }}
                            </button>
                            <button type="button" class="btn btn-soft-danger btn-sm" onclick="window.location='{{ route('debtors.list', array_merge(request()->all(), ['export' => 'pdf'])) }}'">
                                <i class="ri-file-pdf-line align-bottom me-1"></i> {{ __('Export PDF') }}
                            </button>
                        </div>
                    </div>
                </div>
                
                <div class="card-body border-bottom">
                    <!-- Filters -->
                    <form method="GET" action="{{ route('debtors.list') }}">
                        <div class="row g-3">
                            <div class="col-xxl-4 col-sm-6">
                                <div class="search-box">
                                    <input type="text" name="search" class="form-control search" placeholder="{{ __('Search by name or contact...') }}" value="{{ request('search') }}">
                                    <i class="ri-search-line search-icon"></i>
                                </div>
                            </div>
                            <div class="col-xxl-2 col-sm-6">
                                <select name="balance_type" class="form-control" data-choices data-choices-search-false>
                                    <option value="">{{ __('All Balances') }}</option>
                                    <option value="negative" {{ request('balance_type') == 'negative' ? 'selected' : '' }}>{{ __('Debtors Only') }}</option>
                                    <option value="positive" {{ request('balance_type') == 'positive' ? 'selected' : '' }}>{{ __('Creditors Only') }}</option>
                                </select>
                            </div>
                            <div class="col-xxl-2 col-sm-4">
                                <select name="sort_by" class="form-control" data-choices data-choices-search-false>
                                    <option value="balance" {{ request('sort_by') == 'balance' ? 'selected' : '' }}>{{ __('Sort by Balance') }}</option>
                                    <option value="name" {{ request('sort_by') == 'name' ? 'selected' : '' }}>{{ __('Sort by Name') }}</option>
                                </select>
                            </div>
                            <div class="col-xxl-2 col-sm-4">
                                <select name="sort_order" class="form-control" data-choices data-choices-search-false>
                                    <option value="desc" {{ request('sort_order') == 'desc' ? 'selected' : '' }}>{{ __('Descending') }}</option>
                                    <option value="asc" {{ request('sort_order') == 'asc' ? 'selected' : '' }}>{{ __('Ascending') }}</option>
                                </select>
                            </div>
                            <div class="col-xxl-2 col-sm-4">
                                <button type="submit" class="btn btn-primary w-100">
                                    <i class="ri-equalizer-fill me-1 align-bottom"></i> {{ __('Filter') }}
                                </button>
                            </div>
                        </div>
                    </form>
                </div>

                <div class="card-body">
                    <!-- Table -->
                    <div class="table-responsive table-card">
                        <table class="table align-middle table-nowrap table-hover" id="debtorsTable">
                            <thead class="table-light">
                                <tr>
                                    <th scope="col" style="width: 50px;">
                                        <div class="form-check">
                                            #
                                        </div>
                                    </th>
                                    <th scope="col">{{ __('Customer Name') }}</th>
                                    <th scope="col">{{ __('Contact') }}</th>
                                    <th scope="col">{{ __('Alt Contact') }}</th>
                                    <th scope="col" class="text-end">{{ __('Balance') }}</th>
                                    <th scope="col" class="text-center">{{ __('Status') }}</th>
                                    <th scope="col" class="text-center">{{ __('Actions') }}</th>
                                </tr>
                            </thead>
                            <tbody class="list">
                                @forelse($debtors as $index => $debtor)
                                    <tr>
                                        <td>
                                            <div class="form-check">
                                                {{ $index + 1 }}
                                            </div>
                                        </td>
                                        <td class="customer_name">
                                            <div class="d-flex align-items-center">
                                                <div class="flex-shrink-0 me-2">
                                                    <div class="avatar-xs">
                                                        <div class="avatar-title rounded-circle bg-{{ $debtor->balance < 0 ? 'danger' : 'success' }}-subtle text-{{ $debtor->balance < 0 ? 'danger' : 'success' }}">
                                                            {{ substr($debtor->name, 0, 1) }}
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="flex-grow-1">
                                                    <h5 class="fs-14 mb-0">
                                                        <a href="{{ route('customers.show', $debtor->id) }}" class="text-body">{{ $debtor->name }}</a>
                                                    </h5>
                                                </div>
                                            </div>
                                        </td>
                                        <td class="contact">{{ $debtor->contact ?? '-' }}</td>
                                        <td class="alt_contact">{{ $debtor->alt_contact ?? '-' }}</td>
                                        <td class="balance text-end">
                                            <span class="fw-semibold {{ $debtor->balance < 0 ? 'text-danger' : 'text-success' }}">
                                                {{ number_format($debtor->balance, 2) }}
                                            </span>
                                        </td>
                                        <td class="status text-center">
                                            @if($debtor->balance < 0)
                                                <span class="badge bg-danger-subtle text-danger">
                                                    <i class="ri-arrow-down-line align-middle"></i> {{ __('Debtor') }}
                                                </span>
                                            @else
                                                <span class="badge bg-success-subtle text-success">
                                                    <i class="ri-arrow-up-line align-middle"></i> {{ __('Creditor') }}
                                                </span>
                                            @endif
                                        </td>
                                        <td class="text-center">
                                            <div class="dropdown">
                                                <button class="btn btn-soft-secondary btn-sm dropdown" type="button" data-bs-toggle="dropdown" aria-expanded="false">
                                                    <i class="ri-more-fill align-middle"></i>
                                                </button>
                                                <ul class="dropdown-menu dropdown-menu-end">
                                                    <li>
                                                        <a class="dropdown-item" href="{{ route('customers.show', $debtor->id) }}">
                                                            <i class="ri-eye-fill align-bottom me-2 text-muted"></i> {{ __('View Details') }}
                                                        </a>
                                                    </li>
                                                    <li>
                                                        <a class="dropdown-item" href="{{ route('customers.ledger', ['customer_id' => $debtor->id]) }}">
                                                            <i class="ri-book-2-line align-bottom me-2 text-muted"></i> {{ __('View Ledger') }}
                                                        </a>
                                                    </li>
                                                    <li>
                                                        <a class="dropdown-item" href="{{ route('customers.edit', $debtor->id) }}">
                                                            <i class="ri-pencil-fill align-bottom me-2 text-muted"></i> {{ __('Edit') }}
                                                        </a>
                                                    </li>
                                                </ul>
                                            </div>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="7">
                                            <div class="noresult">
                                                <div class="text-center">
                                                    <lord-icon src="https://cdn.lordicon.com/msoeawqm.json" trigger="loop" colors="primary:#121331,secondary:#08a88a" style="width:75px;height:75px"></lord-icon>
                                                    <h5 class="mt-2">{{ __('Sorry! No Result Found') }}</h5>
                                                    <p class="text-muted mb-0">{{ __('No debtors or creditors found with current filters.') }}</p>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot class="table-light">
                                <tr>
                                    <th colspan="4" class="text-end">{{ __('TOTALS:') }}</th>
                                    <th class="text-end">
                                        <div class="text-danger mb-1">{{ __('Debtors:') }} {{ number_format(abs($totalDebit ?? 0), 2) }}</div>
                                        <div class="text-success mb-1">{{ __('Creditors:') }} {{ number_format($totalCredit ?? 0, 2) }}</div>
                                        <div class="fw-bold {{ ($netBalance ?? 0) < 0 ? 'text-danger' : 'text-success' }}">
                                            {{ __('Net:') }} {{ number_format($netBalance ?? 0, 2) }}
                                        </div>
                                    </th>
                                    <th colspan="2"></th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('customjs')
<script src="{{ asset('assets/libs/list.js/list.min.js') }}"></script>
<script>
    // Counter animation
    document.querySelectorAll('.counter-value').forEach(function(element) {
        const target = parseFloat(element.getAttribute('data-target'));
        const duration = 2000;
        const increment = target / (duration / 16);
        let current = 0;
        
        const timer = setInterval(function() {
            current += increment;
            if (current >= target) {
                element.textContent = target.toLocaleString('en-US', {minimumFractionDigits: 2, maximumFractionDigits: 2});
                clearInterval(timer);
            } else {
                element.textContent = current.toLocaleString('en-US', {minimumFractionDigits: 2, maximumFractionDigits: 2});
            }
        }, 16);
    });

    // Real-time search functionality
    const searchInput = document.querySelector('input[name="search"]');
    const tableRows = document.querySelectorAll('#debtorsTable tbody tr');
    const noResultRow = document.querySelector('.noresult');
    
    if (searchInput) {
        // Remove search input from form submission on enter
        searchInput.addEventListener('keypress', function(e) {
            if (e.key === 'Enter') {
                e.preventDefault();
                return false;
            }
        });

        searchInput.addEventListener('input', function() {
            const searchTerm = this.value.toLowerCase().trim();
            let visibleCount = 0;

            tableRows.forEach(function(row) {
                // Skip the no-result row
                if (row.querySelector('.noresult')) {
                    return;
                }

                const customerName = row.querySelector('.customer_name')?.textContent.toLowerCase() || '';
                const contact = row.querySelector('.contact')?.textContent.toLowerCase() || '';
                const altContact = row.querySelector('.alt_contact')?.textContent.toLowerCase() || '';

                // Check if search term matches any of the fields
                if (customerName.includes(searchTerm) || 
                    contact.includes(searchTerm) || 
                    altContact.includes(searchTerm) ||
                    searchTerm === '') {
                    row.style.display = '';
                    visibleCount++;
                } else {
                    row.style.display = 'none';
                }
            });

            // Show/hide no results message
            if (noResultRow) {
                if (visibleCount === 0 && searchTerm !== '') {
                    noResultRow.parentElement.style.display = '';
                } else {
                    noResultRow.parentElement.style.display = 'none';
                }
            }

            // Update row numbers
            updateRowNumbers();
        });
    }

    // Function to update row numbers after filtering
    function updateRowNumbers() {
        let visibleIndex = 1;
        tableRows.forEach(function(row) {
            if (row.style.display !== 'none' && !row.querySelector('.noresult')) {
                const numberCell = row.querySelector('td:first-child .form-check');
                if (numberCell) {
                    numberCell.textContent = visibleIndex++;
                }
            }
        });
    }

    // Auto-submit form on filter change (excluding search)
    document.querySelectorAll('select[name="balance_type"], select[name="sort_by"], select[name="sort_order"]').forEach(function(select) {
        select.addEventListener('change', function() {
            // Clear search input before submitting
            if (searchInput) {
                searchInput.value = '';
            }
            this.closest('form').submit();
        });
    });

    // Modify form submission to exclude search if using real-time search
    const filterForm = document.querySelector('form[action*="debtors"]');
    if (filterForm) {
        filterForm.addEventListener('submit', function(e) {
            // If search has value, don't submit form, let real-time search handle it
            if (searchInput && searchInput.value.trim() !== '') {
                e.preventDefault();
                return false;
            }
        });
    }
</script>
@endsection