@extends('admin.layouts.app')

@section('title', 'Unpaid Customers Report')

@push('styles')
<style>
.badge {
  font-size: 13px;
  padding: 6px 10px;
  border-radius: 8px;
}
</style>
@endpush

@section('content')
<h4 class="font-weight-bold py-3 mb-0">Unpaid Customer Report</h4>

<div class="card" style="padding-right:10px;padding-left:10px;">
  <div class="card-datatable">
    <table id="example" class="table table-striped table-bordered" style="width:100%">
      <thead>
        <tr>
          <th>Name</th>
          <th>Phone</th>
          <th>Package Amount (₹)</th>
          <th>Paid Amount (₹)</th>
          <th>Balance (₹)</th>
          <th>Payment Status</th>
          <th>Package Expiry</th>
          <th>Address</th>
          <th>Action</th>
        </tr>
      </thead>
      <tbody>
        @forelse ($rows as $row)
          @php
            $pkgAmount = (float) (($row->InvoiceAmt ?? 0) > 0 ? $row->InvoiceAmt : ($row->PkgAmount ?? 0));
            $paidAmount = (float) (($row->InvoiceAmt ?? 0) > 0 ? ($row->LedgerPaidAmt ?? 0) : ($row->PaidAmount ?? 0));
            $balance = (float) ($row->Balance ?? 0);
            $validity = ! empty($row->Validity) ? date('d-M-Y', strtotime($row->Validity)) : 'N/A';
            $isExpired = ! empty($row->Validity) && $row->Validity < $today;
          @endphp
          <tr>
            <td>{{ $row->Fname }} {{ $row->Lname }}</td>
            <td>{{ $row->Phone }}</td>
            <td>{{ number_format($pkgAmount, 2) }}</td>
            <td>{{ number_format($paidAmount, 2) }}</td>
            <td><strong>{{ number_format($balance, 2) }}</strong></td>
            <td>
              @if ($paidAmount > 0)
                <span class="badge bg-warning text-dark">Partial</span>
              @else
                <span class="badge bg-danger">Unpaid</span>
              @endif
            </td>
            <td>
              @if ($isExpired)
                <span class="text-danger">{{ $validity }}</span>
              @else
                {{ $validity }}
              @endif
            </td>
            <td>{{ $row->Address }}</td>
            <td>
              @if (\Illuminate\Support\Facades\Route::has('admin.payments.create'))
                <a href="{{ route('admin.payments.create', ['UserId' => $row->id]) }}" class="badge bg-success" style="color:white;">Receive</a>
              @else
                <span class="badge bg-success" style="color:white;">Receive</span>
              @endif
              @if (\Illuminate\Support\Facades\Route::has('admin.customers.edit'))
                <a href="{{ route('admin.customers.edit', $row->id) }}" class="badge bg-primary" style="color:white;">View</a>
              @else
                <span class="badge bg-primary" style="color:white;">View</span>
              @endif
            </td>
          </tr>
        @empty
          <tr><td colspan="9" class="text-center text-muted">No unpaid customers found.</td></tr>
        @endforelse
      </tbody>
    </table>
  </div>
</div>
@endsection

@push('scripts')
<script type="text/javascript">
$(document).ready(function() {
  $('#example').DataTable({
    responsive: false,
    order: [[4, "desc"]],
    pageLength: 25,
    dom: 'Bfrtip',
    buttons: [
      {
        extend: 'excelHtml5',
        title: 'Unpaid_Customer_Report',
        text: '<i class="fa fa-file-excel"></i> Excel',
        className: 'btn btn-success btn-sm'
      }
    ]
  });
});
</script>
@endpush