detail

<h2 class="text-center" style="font-size: 20;color:darkorange;">Detail Pembelian</h2>

<?php
    $cut=$conn->query("SELECT * FROM pembelian jOIN pelanggan ON pembelian.id_pelanggan = pelanggan.id_pelanggan WHERE pembelian.id_pembelian= '$_GET[id]'");
    $detail=$cut->fetch_assoc();

    $id_pembelian = $_GET['id'];
   $cut = $conn->query("SELECT * FROM pembayaran LEFT JOIN pembelian
   ON pembayaran.id_pembelian= pembelian.id_pembelian
   WHERE pembelian.id_pembelian = '$id_pembelian'");
   $put = $cut->fetch_assoc();
?>
<!-- <pre><?= print_r($detail); ?></pre> -->

<div class="row">
    <div class="col-md-4">
        <h2 style="color: blue;">Pembelian</h2>
            <p>
            <strong> Status Pembelian : <?=$detail['status_pembelian']; ?></strong> <br>
            <strong>Jenis Pembayaran : <?php $nama_bayar = $put['nama_bayar'];
                if($nama_bayar==1)$nama_bayar='Transfer BRI';
                if($nama_bayar==2)$nama_bayar='COD';
                echo $nama_bayar;?></strong><br>
                Tanggal Pembelian :
                    <?=$detail['tanggal_pembelian']; ?><br>
                Total Pembelian : Rp <?= number_format ($detail['total_pembelian']); ?>
            </p>
    </div>
    <div class="col-md-4">
        <h2 style="color:blue;">Pelanggan</h2>
        <p>
        <strong>Nama Pelanggan: <?= $detail['nama_pelanggan']; ?></strong> <br>
           Alamat : <?= $detail['alamat_pelanggan']; ?> <br>
            Email : <?= $detail['email_pelanggan']; ?> <br>
            No Hp : <?= $detail['no_hp_pelanggan']; ?>
        </p>
    </div>
    <div class="col-md-4">
        <h2 style="color:blue;">Pengiriman</h2>
        <p>
        <strong> Kota Pengiriman : <?=$detail['nama_kota']; ?></strong> <br>
            Tarif : Rp <?=number_format($detail['tarif']); ?> <br>
            Alamat pengiriman : <?=$detail['alamat_tujuan']; ?>
        </p>
    </div>
</div>
<div class="table-responsive">
<table class="table table-bordered table-striped table-hover">
    <thead>
        <tr>
            <th>No</th>
            <th>Nama Produk</th>
            <th>harga</th>
            <th>Jumlah</th>
            <th>Subtotal</th>
        </tr>
    </thead>
    <tbody>
        <?php $number=1; ?>
        <?php $cut=$conn->query("SELECT * FROM pembelian_produk JOIN produk ON pembelian_produk.id_produk = produk.id_produk WHERE pembelian_produk.id_pembelian='$_GET[id]'"); ?>
        <?php while($put=$cut->fetch_assoc()) { ?>
        <tr>
            <td><?= $number; ?></td>
            <td><?= $put['nama_produk']; ?></td>
            <td>Rp <?= number_format($put['harga_produk']); ?></td>
            <td><?= $put['jumlah']; ?></td>
            <td>Rp <?= number_format($put['harga_produk']*$put['jumlah']); ?></td>
        </tr>
        <?php $number++; ?>
        <?php } ?>
    </tbody>
</table>
</div>
<div class="col-md-6">
<p>Tanda Terima Pesanan</p><br><br>
<p class="text-left"> .........................................</p>
<a href="index.php?halaman=pembelian" class="btn btn-warning"><i class="fa fa-backward" aria-hidden="true"></i> Kembali</a>
<a href="print.php" class="btn btn-success" target="_blank"><i class="fa fa-print" aria-hidden="true"></i> Cetak </a>
</div>