<?php
require 'vendor/autoload.php';
use Dompdf\Dompdf;
include "koneksi.php";

$faktur = mysqli_real_escape_string($conn, $_GET['faktur']);

// Ambil Data
$header = mysqli_query($conn, "SELECT * FROM tabel_penjualan WHERE no_faktur_penjualan = '$faktur'");
$d_h = mysqli_fetch_assoc($header);
$rinci = mysqli_query($conn, "SELECT * FROM tabel_rinci_penjualan WHERE no_faktur_penjualan = '$faktur'");

$html = '
<style>
    body { font-family: sans-serif; font-size: 12px; }
    .header { text-align: center; margin-bottom: 20px; }
    table { width: 100%; border-collapse: collapse; margin-top: 10px; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background-color: #f2f2f2; }
    .text-right { text-align: right; }
    .total-box { margin-top: 20px; font-size: 16px; font-weight: bold; text-align: right; }
</style>

<div class="header">
    <h2>NOTA PENJUALAN</h2>
    <p>No. Faktur: '.substr($faktur,8,7).' | Tanggal: '.date('d/m/Y', strtotime($d_h['tgl_penjualan'])).'</p>
</div>

<table>
    <thead>
        <tr>
            <th>Barang</th>
            <th class="text-right">Harga</th>
            <th class="text-right">Pajak</th>
            <th class="text-right">Subtotal</th>
        </tr>
    </thead>
    <tbody>';

while($r = mysqli_fetch_assoc($rinci)) {
    $html .= '
        <tr>
            <td>'.$r['nm_barang'].' ('.$r['kd_barang'].')</td>
            <td class="text-right">'.number_format($r['harga'], 0, ',', '.').'</td>
            <td class="text-right">'.number_format($r['nppn'], 0, ',', '.').'</td>
            <td class="text-right">'.number_format(($r['sub_total_jual']+$r['nppn']), 0, ',', '.').'</td>
        </tr>';
}

$html .= '
    </tbody>
</table>

<div class="total-box">
    TOTAL NETTO: Rp '.number_format($d_h['netto'], 0, ',', '.').'
</div>

<div style="margin-top: 40px;">
    <table border="0" style="border:none;">
        <tr>
            <td style="border:none; width: 70%;"></td>
            <td style="border:none; text-align:center;">
                Hormat Kami,<br><br><br><br>
                ( .................... )
            </td>
        </tr>
    </table>
</div>';

$dompdf = new Dompdf();
$dompdf->loadHtml($html);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();
$dompdf->stream("Nota_".$faktur.".pdf", ["Attachment" => 0]);