<h2> Detail Pembelian </h2>
<?php
$ambil = $koneksi->query("SELECT * FROM pembelian JOIN pelanggan
    ON pembelian.id_pelanggan=pelanggan.id_pelanggan
    WHERE pembelian.id_pembelian='$_GET[id]'");
$detail = $ambil->fetch_assoc();
?>


<strong><?php echo $detail['nama_pelanggan']; ?></strong><br>
<p>
    <?php echo $detail['telepon_pelanggan']; ?><br>
    <?php echo $detail['email_pelanggan']; ?>
</p>

<p>
    Tanggal :<?php echo $detail['tanggal_pembelian']; ?><br>
    Total :<?php echo $detail['total_pembelian']; ?>
</p>

<table class="table table-bordered">
    <thead>
        <tr>
            <th>No</th>
            <th>Nama Produk</th>
            <th>Harga</th>
            <th>Jumlah</th>
            <th>SubTotal</th>
        <tr>
    </thead>
    <tbody>
            <?php $nomor=1; ?>
            <?php $ambil=$koneksi->query("SELECT * FROM pembelian_produk JOIN produk ON
                pembelian_produk.id_produk=produk.id_produk
                WHERE pembelian_produk.id_pembelian='$_GET[id]'"); ?>
            <?php while($pecah=$ambil->fetch_assoc()){ ?>
            <tr>
                <td><?php echo $nomor; ?></td>
                <td><?php echo $pecah['nama_produk']; ?></td>
                <td><?php echo $pecah['harga_produk']; ?></td>
                <td><?php echo $pecah['jumlah']; ?></td>
                <td>
                    <?php echo $pecah['harga_produk']*$pecah['jumlah']; ?>
                </td>
            </tr>

            <?php $nomor++; ?>
            <?php } ?>

    </tbody>
</table>

<?php
// Import PHPMailer classes into the global namespace
// These must be at the top of your script, not inside a function
require '../vendor/phpmailer/PHPMailer/src/Exception.php';
require '../vendor/phpmailer/PHPMailer/src/PHPMailer.php';
require '../vendor/phpmailer/PHPMailer/src/SMTP.php';

//Load Composer's autoloader
require '../vendor/autoload.php';

$mail = new PHPMailer\PHPMailer\PHPMailer();                         // Passing `true` enables exceptions
try {
    //Server settings
    $mail->SMTPDebug = 2;                                 // Enable verbose debug output
    $mail->isSMTP();                                      // Set mailer to use SMTP
    $mail->Host = 'smtp.gmail.com';  // Specify main and backup SMTP servers
    $mail->SMTPAuth = true;                               // Enable SMTP authentication
    $mail->Username = 'distrokutesting@gmail.com';                 // SMTP username
    $mail->Password = 'Distrokutesting123';                           // SMTP password
    $mail->SMTPSecure = 'ssl';                            // Enable TLS encryption, `ssl` also accepted
    $mail->Port = 465;                                      // TCP port to connect to
         $mail->SMTPOptions = array(
             'ssl' => array(
                 'verify_peer' => false,
                 'verify_peer_name' => false,
                 'allow_self_signed' => true
             )
         );                                    // TCP port to connect to


    $ambil = $koneksi->query("SELECT * FROM pembelian JOIN pelanggan
    ON pembelian.id_pelanggan=pelanggan.id_pelanggan
    WHERE pembelian.id_pembelian='$_GET[id]'");
    $detail = $ambil->fetch_assoc();

    $sql = $koneksi->query("SELECT * FROM pembelian_produk JOIN produk ON
                pembelian_produk.id_produk=produk.id_produk
                WHERE pembelian_produk.id_pembelian='$_GET[id]'");
    $pecah = $sql->fetch_assoc();

    //Recipients
    $mail->setFrom('distrokutesting@gmail.com', 'Mailer');
    $mail->addAddress($detail['email_pelanggan']);     // Add a recipient
    //$mail->addAddress('ellen@example.com');               // Name is optional
    //$mail->addReplyTo('info@example.com', 'Information');
    //$mail->addCC('cc@example.com');
    //$mail->addBCC('bcc@example.com');

    //Attachments
    //$mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
    //$mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name

    //Content
    $mail->isHTML(true);                                  // Set email format to HTML
    $mail->Subject = 'PEMBERITAHUAN PEMBAYARAN';
    $mail->Body    = "<p>By Abah</p>
                        <p>Di Mohon untuk segera melakukan Pembayaran ke REKENING BANK Jateng 111-1021-0011 AN. Tim Magang Can Creative</p>
                        <br><table border='3'>
                     <tr>
                        <th>Nama</th>
                        <th>Produk</th>
                        <th>No Telepon</th>
                        <th>SubTotal</th>
                    </tr>
                    <tr>
                        <td>".$detail['nama_pelanggan']."</td>
                        <td>".$pecah['nama_produk']."</td>
                        <td>".$detail['telepon_pelanggan']."</td>
                        <td>".$detail['total_pembelian']."</td>
                    </tr>
                    </table>"
                    ;
    $mail->AltBody = 'Di Mohon untuk segera melakukan Pembayaran ke REKENING BANK Jateng 111-1021-0011 AN. Tim Magang Can Creative ';

    $mail->send();
    echo 'Message has been sent';
} catch (Exception $e) {
    echo 'Message could not be sent. Mailer Error: ', $mail->ErrorInfo;
}


?>