@php
    use App\Models\Invoice;
    use App\Models\Produk;
    use App\Models\InvoiceDetail;

    $invoice = Invoice::select("invoice.id_invoice",
                "produk.id_produk",
                "produk.nama_produk",
                "produk.harga_produk",
                DB::raw('(SELECT COUNT(id_invoice_detail) FROM invoice_detail WHERE invoice_detail.id_invoice=invoice.id_invoice GROUP BY invoice.id_invoice) as total_invoice_detail'),
                )
        ->join('instalasi', 'instalasi.id_instalasi', 'invoice.id_instalasi')
        ->join('customer', 'customer.id_customer', 'instalasi.id_customer')
        ->join('produk', 'produk.id_produk', 'instalasi.id_produk')
        ->where('invoice.tgl_invoice', '2025-02-01')
        ->where('invoice.id_unit_instalasi',$_GET['id'])
        ->get();

$datetime = date('Y-m-d H:i:s');
    foreach ($invoice as $row) {
        if($row->total_invoice_detail == 0){
                $pajak = $row['harga_produk'] * 11 / 100;
                $subtotal = $row['harga_produk'] + $pajak;

                echo "INSERT INTO invoice_detail (id_invoice, id_produk, detail_nama_produk, qty_detail, harga_detail, disc_detail, disc_plus_detail, sub_total_detail, pajak_detail, persentase_pajak_detail, created_at, updated_at) VALUES ('$row[id_invoice]', '$row[id_produk]', '$row[nama_produk]','1','$row[harga_produk]',0,0,'$subtotal','$pajak', '11', '$datetime', '$datetime');";

                echo "<br>";
        }


    }



@endphp