@extends('admin.layout.app')
@section('content')
    <div class="content-wrapper">
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card elevation-0">
                            <div class="card-header">
                                <h3 class="card-title"><i class="fas fa-users"></i> Direct Dues report</h3>
                                <div class="card-tools">
                                </div>
                            </div>
                            <div class="card-body pt-0">
                                <div class="table-responsive">
                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th>Sr</th>
                                                <th>Bill No</th>
                                                <th>Customer Name</th>
                                                <th>Customer Phone</th>
                                                <th>Total</th>
                                                <th>Remaining</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

                                        <tbody>
                                            @forelse($sales as $key => $sale)
                                                <tr>
                                                    <td>{{ $key + 1 }}</td>
                                                    <td>{{ $sale->bill_no }}</td>
                                                    <td>{{ $sale->customer->name ?? '-' }}</td>
                                                    <td>{{ $sale->customer->phone ?? '-' }}</td>
                                                    <td>{{ number_format($sale->total, 2) }}</td>
                                                    <td>{{ number_format($sale->remaining, 2) }}</td>
                                                    <td>
                                                        @php
                                                            $phone = $sale->customer->phone ?? '';

                                                            // remove spaces, +, -, brackets
                                                            $phone = preg_replace('/[^0-9]/', '', $phone);

                                                            // ✅ Pakistan format convert 03xx... => 92xx...
                                                            if(strlen($phone) == 11 && substr($phone, 0, 1) == '0'){
                                                                $phone = '92' . substr($phone, 1);
                                                            }
                                                            
                                                            $msg = "سلام ".$sale->customer->name.
                                                                "، آپ کا بل نمبر ".$sale->bill_no.
                                                                "، Rs ".$sale->remaining.
                                                                " واجب الادا ہے، براہ کرم اسے جلد از جلد ادا کریں۔".
                                                                " : اسلام آباد ٹائرز اینڈ رمز G10/4، اسلام آباد";
                                                        @endphp

                                                        @if(!empty($phone))
                                                            <a href="https://wa.me/{{ $phone }}?text={{ urlencode($msg) }}"
                                                            target="_blank"
                                                            class="btn btn-sm btn-outline-info">
                                                                <i class="fab fa-whatsapp text-success"></i> Whatsapp
                                                            </a>
                                                        @else
                                                            <span>-</span>
                                                        @endif

                                                    </td>
                                                </tr>
                                            @empty
                                                <tr>
                                                    <td colspan="6" class="text-center">No installment dues found.</td>
                                                </tr>
                                            @endforelse
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>
@endsection