@php
    use App\Models\Invoice;
    use App\Models\PointSalesDetail;

    $two_months_ago = 6;

    $invoices = Invoice::join('instalasi','instalasi.id_instalasi','invoice.id_instalasi')
    ->join('produk','produk.id_produk','instalasi.id_produk')
    ->whereMonth('tgl_invoice', $two_months_ago)
    ->whereYear('tgl_invoice', now()->year)
    ->where('invoice.id_unit_instalasi',1)
    ->where('status_invoice','!=','settlement')->get();

@endphp

@foreach ($invoices as $invoice)
@php
    $pointSalesDetails = PointSalesDetail::where('id_instalasi', $invoice->id_instalasi)
    ->where('jenis_komisi', 'Reduction')
    ->limit(1)
    ->first();
@endphp
    <div>
        <p>Invoice ID: {{ $invoice->no_invoice }}</p>
        <p>Customer Name: {{ $invoice->first_name }}</p>
        <p>Status: {{ $invoice->status_invoice }}</p>
        <p>Point Sales Detail: {{ $pointSalesDetails ? $pointSalesDetails->id_instalasi : 'N/A' }}</p>
    </div>
    @if(empty($pointSalesDetails))
    @php
    /*
        $store = PointSalesDetail::create([
            'id_jc_point_sales' => null,
            'id_instalasi' => $invoice->id_instalasi,
            'id_invoice' => $invoice->id_invoice,
            'id_produk' => $invoice->id_produk,
            'jenis_komisi' => 'Reduction',
            'biaya_instalasi' => $invoice->biaya_instalasi,
            'harga_produk' => $invoice->harga_produk,
            'presentase' => 0,
            'status_point' => 'Approved'
        ]);
        */
    @endphp

    @endif
    <hr>

    @endforeach