@extends('layouts.app')

@section('title', 'Advance Payments')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header bg-primary text-white">
                    <h4 class="mb-0">
                        <i class="fas fa-money-bill-wave me-2"></i>Advance Payments Management
                    </h4>
                </div>
                <div class="card-body">
                    <!-- Statistics Cards -->
                    <div class="row mb-4">
                        <div class="col-md-2">
                            <div class="card bg-info text-white">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">{{ $stats['total_advance_payments'] }}</h5>
                                    <small>Total Advance Payments</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-success text-white">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">{{ $stats['active_advance_payments'] }}</h5>
                                    <small>Active Payments</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-warning text-white">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['total_amount'], 2) }}</h5>
                                    <small>Total Amount</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-primary text-white">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['remaining_amount'], 2) }}</h5>
                                    <small>Remaining Amount</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-secondary text-white">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['used_amount'], 2) }}</h5>
                                    <small>Used Amount</small>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Filtered Statistics (shown when filters are applied) -->
                    @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                    <div class="alert alert-info mb-4">
                        <div class="row">
                            <div class="col-12">
                                <h6 class="mb-3"><i class="fas fa-filter me-2"></i>Filtered Results</h6>
                            </div>
                            <div class="col-md-4">
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <strong>Filtered Payments:</strong>
                                    <span class="badge badge-primary badge-lg">{{ $filteredStats['filtered_advance_payments'] }}</span>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <strong>Filtered Total Amount:</strong>
                                    <span class="badge badge-success badge-lg">৳{{ number_format($filteredStats['filtered_total_amount'], 2) }}</span>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="d-flex justify-content-between align-items-center mb-2">
                                    <strong>Filtered Remaining Amount:</strong>
                                    <span class="badge badge-warning badge-lg">৳{{ number_format($filteredStats['filtered_remaining_amount'], 2) }}</span>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif

                    <!-- Filters -->
                    <div class="card mb-4">
                        <div class="card-header">
                            <h6 class="mb-0">Filters</h6>
                        </div>
                        <div class="card-body">
                            <form method="GET" action="{{ route('reseller.advance-payments') }}">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="user_id">User</label>
                                            <select class="form-control" id="user_id" name="user_id">
                                                <option value="">All Users</option>
                                                @foreach($users as $user)
                                                    <option value="{{ $user->id }}" {{ request('user_id') == $user->id ? 'selected' : '' }}>
                                                        {{ $user->name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="status">Status</label>
                                            <select class="form-control" id="status" name="status">
                                                <option value="">All Status</option>
                                                <option value="active" {{ request('status') == 'active' ? 'selected' : '' }}>Active</option>
                                                <option value="used" {{ request('status') == 'used' ? 'selected' : '' }}>Used</option>
                                                <option value="expired" {{ request('status') == 'expired' ? 'selected' : '' }}>Expired</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="date_from">Date From</label>
                                            <input type="date" class="form-control" id="date_from" name="date_from" value="{{ request('date_from') }}">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="date_to">Date To</label>
                                            <input type="date" class="form-control" id="date_to" name="date_to" value="{{ request('date_to') }}">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label>&nbsp;</label>
                                            <button type="submit" class="btn btn-primary btn-block">Filter</button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

                    <!-- Table Summary Cards -->
                    <div class="card mb-4" style="border: 2px solid #007bff; box-shadow: 0 0.125rem 0.25rem rgba(0,0,0,0.075);">
                        <div class="card-header" style="background-color: #007bff; color: white;">
                            <h5 class="mb-0">
                                <i class="fas fa-chart-bar"></i>
                                @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                    Filtered Summary
                                @else
                                    Current Page Summary
                                @endif
                            </h5>
                        </div>
                        <div class="card-body" style="background-color: #f8f9fa;">
                            <div class="row text-center">
                                <div class="col-md-3 mb-3">
                                    <div class="p-3" style="border-right: 1px solid #dee2e6;">
                                        <h6 class="text-muted mb-2">Total Payments</h6>
                                        <h3 class="mb-0" style="color: #17a2b8;">
                                            <i class="fas fa-list-ol"></i>
                                            @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                                {{ $filteredStats['filtered_advance_payments'] }}
                                            @else
                                                {{ $advancePayments->total() }}
                                            @endif
                                        </h3>
                                        <small class="text-muted">Records</small>
                                    </div>
                                </div>
                                <div class="col-md-3 mb-3">
                                    <div class="p-3" style="border-right: 1px solid #dee2e6;">
                                        <h6 class="text-muted mb-2">Total Amount</h6>
                                        <h3 class="mb-0" style="color: #28a745;">
                                            <i class="fas fa-money-bill-wave"></i>
                                            @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                                ৳{{ number_format($filteredStats['filtered_total_amount'], 2) }}
                                            @else
                                                ৳{{ number_format($advancePayments->sum('amount'), 2) }}
                                            @endif
                                        </h3>
                                        <small class="text-muted">BDT</small>
                                    </div>
                                </div>
                                <div class="col-md-3 mb-3">
                                    <div class="p-3" style="border-right: 1px solid #dee2e6;">
                                        <h6 class="text-muted mb-2">Remaining Amount</h6>
                                        <h3 class="mb-0" style="color: #ffc107;">
                                            <i class="fas fa-wallet"></i>
                                            @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                                ৳{{ number_format($filteredStats['filtered_remaining_amount'], 2) }}
                                            @else
                                                ৳{{ number_format($advancePayments->sum('remaining_amount'), 2) }}
                                            @endif
                                        </h3>
                                        <small class="text-muted">BDT</small>
                                    </div>
                                </div>
                                <div class="col-md-3 mb-3">
                                    <div class="p-3">
                                        <h6 class="text-muted mb-2">Used Amount</h6>
                                        <h3 class="mb-0" style="color: #dc3545;">
                                            <i class="fas fa-hand-holding-usd"></i>
                                            @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                                ৳{{ number_format($filteredStats['filtered_total_amount'] - $filteredStats['filtered_remaining_amount'], 2) }}
                                            @else
                                                ৳{{ number_format($advancePayments->sum('amount') - $advancePayments->sum('remaining_amount'), 2) }}
                                            @endif
                                        </h3>
                                        <small class="text-muted">BDT</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Advance Payments Table -->
                    <div class="table-responsive">
                        <table class="table table-striped table-hover">
                            <thead class="thead-dark">
                                <tr>
                                    <th>ID</th>
                                    <th>User</th>
                                    <th>Invoice</th>
                                    <th>Amount</th>
                                    <th>Remaining</th>
                                    <th>Payment Method</th>
                                    <th>Payment Date</th>
                                    <th>Status</th>
                                    <th>Reference</th>
                                    <th>Created By</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($advancePayments as $advancePayment)
                                    <tr>
                                        <td>{{ $advancePayment->id }}</td>
                                        <td>
                                            <strong>{{ $advancePayment->user->name ?? 'N/A' }}</strong>
                                            <br>
                                            <small class="text-muted">{{ $advancePayment->user->email ?? '' }}</small>
                                        </td>
                                        <td>
                                            @if($advancePayment->salesInvoice)
                                                <a href="{{ route('reseller.sales-invoices.show', $advancePayment->salesInvoice->id) }}" class="text-primary">
                                                    #{{ $advancePayment->salesInvoice->invoice_no }}
                                                </a>
                                            @else
                                                <span class="text-muted">N/A</span>
                                            @endif
                                        </td>
                                        <td>
                                            <strong class="text-success">৳{{ number_format($advancePayment->amount, 2) }}</strong>
                                        </td>
                                        <td>
                                            <strong class="text-primary">৳{{ number_format($advancePayment->remaining_amount, 2) }}</strong>
                                        </td>
                                        <td>
                                            <span class="badge badge-info">{{ ucfirst(str_replace('_', ' ', $advancePayment->payment_method)) }}</span>
                                        </td>
                                        <td>{{ $advancePayment->payment_date->format('d M Y') }}</td>
                                        <td>
                                            @if($advancePayment->status == 'active')
                                                <span class="badge badge-success">Active</span>
                                            @elseif($advancePayment->status == 'used')
                                                <span class="badge badge-warning">Used</span>
                                            @else
                                                <span class="badge badge-danger">Expired</span>
                                            @endif
                                        </td>
                                        <td>
                                            <small class="text-muted">{{ $advancePayment->reference_number }}</small>
                                        </td>
                                        <td>
                                            <small>{{ $advancePayment->createdBy->name ?? 'N/A' }}</small>
                                        </td>
                                        <td>
                                            <div class="btn-group" role="group">
                                                <button type="button" class="btn btn-sm btn-info" title="View Details" onclick="viewAdvancePayment({{ $advancePayment->id }})">
                                                    <i class="fas fa-eye"></i>
                                                </button>
                                                @if($advancePayment->status == 'active' && $advancePayment->remaining_amount > 0)
                                                    <button type="button" class="btn btn-sm btn-warning" title="Use Payment" onclick="useAdvancePayment({{ $advancePayment->id }})">
                                                        <i class="fas fa-hand-holding-usd"></i>
                                                    </button>
                                                @endif
                                            </div>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="11" class="text-center text-muted py-4">
                                            <i class="fas fa-inbox fa-2x mb-2"></i>
                                            <br>
                                            No advance payments found
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                            @if($advancePayments->count() > 0)
                            <tfoot class="bg-light font-weight-bold">
                                <tr>
                                    <td colspan="3" class="text-right"><strong>Total (Current Page):</strong></td>
                                    <td>
                                        <strong class="text-success" style="font-size: 1.1em;">
                                            ৳{{ number_format($advancePayments->sum('amount'), 2) }}
                                        </strong>
                                    </td>
                                    <td>
                                        <strong class="text-primary" style="font-size: 1.1em;">
                                            ৳{{ number_format($advancePayments->sum('remaining_amount'), 2) }}
                                        </strong>
                                    </td>
                                    <td colspan="6"></td>
                                </tr>
                                @if(request()->hasAny(['user_id', 'status', 'date_from', 'date_to']))
                                <tr class="bg-info text-white">
                                    <td colspan="3" class="text-right"><strong>Grand Total (All Filtered):</strong></td>
                                    <td>
                                        <strong style="font-size: 1.1em;">
                                            ৳{{ number_format($filteredStats['filtered_total_amount'], 2) }}
                                        </strong>
                                    </td>
                                    <td>
                                        <strong style="font-size: 1.1em;">
                                            ৳{{ number_format($filteredStats['filtered_remaining_amount'], 2) }}
                                        </strong>
                                    </td>
                                    <td colspan="6"></td>
                                </tr>
                                @endif
                            </tfoot>
                            @endif
                        </table>
                    </div>

                    <!-- Pagination -->
                    @if($advancePayments->hasPages())
                        <div class="d-flex justify-content-center mt-4">
                            {{ $advancePayments->appends(request()->query())->links() }}
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>

<!-- View Advance Payment Modal -->
<div class="modal fade" id="viewAdvancePaymentModal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header bg-info text-white">
                <h5 class="modal-title">Advance Payment Details</h5>
                <button type="button" class="close text-white" data-dismiss="modal">
                    <span>&times;</span>
                </button>
            </div>
            <div class="modal-body" id="advancePaymentDetails">
                <!-- Content will be loaded here -->
            </div>
        </div>
    </div>
</div>

@endsection

@push('scripts')
<script>
function viewAdvancePayment(id) {
    // Load advance payment details via AJAX
    $.get(`/reseller/advance-payments/${id}/details`, function(data) {
        $('#advancePaymentDetails').html(data);
        $('#viewAdvancePaymentModal').modal('show');
    });
}

function useAdvancePayment(id) {
    if (confirm('Are you sure you want to use this advance payment?')) {
        // Implement advance payment usage logic
        alert('Advance payment usage functionality will be implemented here');
    }
}
</script>
@endpush