SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | session_start(); | |
| 3 | require 'koneksi.php'; | |
| 4 | $id_pembelian = $_GET['id']; | |
| 5 | $cut = $conn->query("SELECT * FROM pembayaran LEFT JOIN pembelian
| |
| 6 | ON pembayaran.id_pembelian= pembelian.id_pembelian | |
| 7 | WHERE pembelian.id_pembelian = '$id_pembelian'"); | |
| 8 | $put = $cut->fetch_assoc(); | |
| 9 | ||
| 10 | // echo "<pre>"; | |
| 11 | // print_r($put); | |
| 12 | // echo "</pre>"; | |
| 13 | ||
| 14 | ||
| 15 | //left join antara table bayar dan table pembayaran | |
| 16 | $id_bayar = $_GET['id']; | |
| 17 | $cut = $conn->query("SELECT * FROM bayar LEFT JOIN pembayaran ON bayar.id_bayar=pembayaran.id_bayar WHERE pembayaran.id_bayar='$id_bayar'");
| |
| 18 | $id= $cut->fetch_assoc(); | |
| 19 | echo "<pre>"; | |
| 20 | print_r($id); | |
| 21 | echo "</pre>"; | |
| 22 | ||
| 23 | //jika data pembayaran belum ada | |
| 24 | if (empty($put)) | |
| 25 | {
| |
| 26 | echo "<script> alert('Belum ada pembayaran');
| |
| 27 | document.location.href='riwayatbelanja.php'; | |
| 28 | </script>"; | |
| 29 | ||
| 30 | } | |
| 31 | ?> | |
| 32 | <!DOCTYPE html> | |
| 33 | <html lang="en"> | |
| 34 | <head> | |
| 35 | <meta charset="UTF-8"> | |
| 36 | <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| 37 | <link href="admin/assets/css/font-awesome.css" rel="stylesheet" /> | |
| 38 | <link rel="stylesheet" href="admin/assets/css/bootstrap.css"> | |
| 39 | <link href="style.css" rel="stylesheet"> | |
| 40 | <title>Nanda Foods</title> | |
| 41 | </head> | |
| 42 | <body> | |
| 43 | <?php include 'header.php';?> | |
| 44 | <div class="container"> | |
| 45 | <div class="row"> | |
| 46 | <div class="col-md-6"> | |
| 47 | <table class="table table-striped"> | |
| 48 | <tr> | |
| 49 | <th>Nama Penyetor</th> | |
| 50 | <td><?= $put['nama']; ?></td> | |
| 51 | </tr> | |
| 52 | <tr> | |
| 53 | <th>jenis pembayaran</th> | |
| 54 | - | <td><?= $put['nama_bayar']; ?></td> |
| 54 | + | <td><?php |
| 55 | $nama_bayar= $put['nama_bayar']; | |
| 56 | if($nama_bayar==1)$nama_bayar='Transfer'; | |
| 57 | if($nama_bayar==2)$nama_bayar='COD'; | |
| 58 | echo $nama_bayar; | |
| 59 | ?></td> | |
| 60 | </tr> | |
| 61 | ||
| 62 | <tr> | |
| 63 | <th>Tanggal</th> | |
| 64 | <td><?=$put['tanggal_pembayaran']; ?></td> | |
| 65 | </tr> | |
| 66 | <tr> | |
| 67 | <th>Jumlah</th> | |
| 68 | <td>Rp <?= number_format($put['jumlah']); ?></td> | |
| 69 | </tr> | |
| 70 | </table> | |
| 71 | </div> | |
| 72 | <div class="col-md-6"> | |
| 73 | <img src="bukti_pembayaran/<?=$put['bukti_pembayaran']; ?>" class="img-responsive"> | |
| 74 | </div> | |
| 75 | </div> | |
| 76 | <a href="riwayatbelanja.php" class="btn btn-danger" style="color: black;"><i class="fa fa-backward" aria-hidden="true"></i> Kembali</a> | |
| 77 | </div> | |
| 78 | <script src="admin/assets/js/jquery-1.10.2.js"></script> | |
| 79 | <script src="admin/assets/js/bootstrap.min.js"></script> | |
| 80 | </body> | |
| 81 | </html> |
