@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">{{ __('Creditors & Debtors 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('suppliers.index') }}">{{ __('Suppliers') }}</a></li>
                        <li class="breadcrumb-item active">{{ __('Creditors List') }}</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row">
        <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-danger fs-14 mb-0">
                                <i class="ri-arrow-right-up-line fs-13 align-middle"></i> 
                                {{ $suppliers->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="{{ $totalCreditors ?? 0 }}">0</span>
                            </h4>
                            <a href="{{ route('suppliers.creditors.list', ['balance_type' => 'creditors']) }}" class="text-decoration-underline">We owe suppliers</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-danger-subtle rounded fs-3">
                                <i class="bx bx-trending-up text-danger"></i>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <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-success fs-14 mb-0">
                                <i class="ri-arrow-right-down-line fs-13 align-middle"></i> 
                                {{ $suppliers->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="{{ abs($totalDebtors ?? 0) }}">0</span>
                            </h4>
                            <a href="{{ route('suppliers.creditors.list', ['balance_type' => 'debtors']) }}" class="text-decoration-underline">Suppliers owe us</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-success-subtle rounded fs-3">
                                <i class="bx bx-trending-down 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 ? 'up' : 'down' }}-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 Suppliers 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="{{ $suppliers->count() }}">0</span>
                            </h4>
                            <a href="{{ route('suppliers.index') }}" class="text-decoration-underline">View all suppliers</a>
                        </div>
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-primary-subtle rounded fs-3">
                                <i class="bx bx-store 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">{{ __('Supplier Balances') }}</h5>
                        </div>
                        <div class="col-auto">
                            <button type="button" class="btn btn-soft-success btn-sm me-1" onclick="window.location='{{ route('suppliers.creditors.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('suppliers.creditors.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('suppliers.creditors.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="creditors" {{ request('balance_type') == 'creditors' ? 'selected' : '' }}>{{ __('Creditors Only') }}</option>
                                    <option value="debtors" {{ request('balance_type') == 'debtors' ? 'selected' : '' }}>{{ __('Debtors 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="suppliersTable">
                            <thead class="table-light">
                                <tr>
                                    <th scope="col" style="width: 50px;">
                                        <div class="form-check">
                                            #
                                        </div>
                                    </th>
                                    <th scope="col">{{ __('Supplier 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($suppliers as $index => $supplier)
                                    <tr>
                                        <td>
                                            <div class="form-check">
                                                {{ $index + 1 }}
                                            </div>
                                        </td>
                                        <td class="supplier_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-{{ $supplier->balance > 0 ? 'danger' : 'success' }}-subtle text-{{ $supplier->balance > 0 ? 'danger' : 'success' }}">
                                                            {{ substr($supplier->name, 0, 1) }}
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="flex-grow-1">
                                                    <h5 class="fs-14 mb-0">
                                                        <a href="{{ route('suppliers.show', $supplier->id) }}" class="text-body">{{ $supplier->name }}</a>
                                                    </h5>
                                                </div>
                                            </div>
                                        </td>
                                        <td class="contact">{{ $supplier->contact ?? '-' }}</td>
                                        <td class="alt_contact">{{ $supplier->alt_contact ?? '-' }}</td>
                                        <td class="balance text-end">
                                            <span class="fw-semibold {{ $supplier->balance > 0 ? 'text-danger' : 'text-success' }}">
                                                {{ number_format($supplier->balance, 2) }}
                                            </span>
                                        </td>
                                        <td class="status text-center">
                                            @if($supplier->balance > 0)
                                                <span class="badge bg-danger-subtle text-danger">
                                                    <i class="ri-arrow-up-line align-middle"></i> {{ __('Creditor') }}
                                                </span>
                                            @else
                                                <span class="badge bg-success-subtle text-success">
                                                    <i class="ri-arrow-down-line align-middle"></i> {{ __('Debtor') }}
                                                </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('suppliers.show', $supplier->id) }}">
                                                            <i class="ri-eye-fill align-bottom me-2 text-muted"></i> {{ __('View Details') }}
                                                        </a>
                                                    </li>
                                                    <li>
                                                        <a class="dropdown-item" href="{{ route('suppliers.ledger', ['supplier_id' => $supplier->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('suppliers.edit', $supplier->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 suppliers with outstanding balances found.') }}</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">{{ __('Creditors:') }} {{ number_format($totalCreditors ?? 0, 2) }}</div>
                                        <div class="text-success mb-1">{{ __('Debtors:') }} {{ number_format(abs($totalDebtors ?? 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);
    });

    // Auto-submit form on filter change
    document.querySelectorAll('select[name="balance_type"], select[name="sort_by"], select[name="sort_order"]').forEach(function(select) {
        select.addEventListener('change', function() {
            this.closest('form').submit();
        });
    });
</script>
@endsection