SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include "../config/koneksi.php"; | |
| 3 | include "./library/librari.php"; | |
| 4 | ?> | |
| 5 | <center><h2>DAFTAR BARANG</h2></center> | |
| 6 | <button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#ModalTambah"><span class="glyphicon glyphicon-plus"></span> Tambah Data</button> | |
| 7 | <br></br> | |
| 8 | <!-- Modal --> | |
| 9 | <div id="ModalTambah" class="modal fade" role="dialog"> | |
| 10 | <div class="modal-dialog"> | |
| 11 | ||
| 12 | <!-- Modal content--> | |
| 13 | <div class="modal-content"> | |
| 14 | <div class="modal-header"> | |
| 15 | <button type="button" class="close" data-dismiss="modal">×</button> | |
| 16 | <h4 class="modal-title"><span class="glyphicon glyphicon-plus"></span> Tambah Barang</h4> | |
| 17 | </div> | |
| 18 | <div class="modal-body"> | |
| 19 | <form class="form-horizontal" action="barang/simpan.php" method="post"> | |
| 20 | <div class="form-group"> | |
| 21 | <label class="col-sm-2 control-label">Kode Barang</label> | |
| 22 | <div class="col-sm-10"> | |
| 23 | <input type="text" class="form-control" id="inputKdBrg" name="kdBrg" value="<?=autonumber("tblbarang","kd_brg",3,"KB")?>" disabled />
| |
| 24 | <input type="hidden" class="form-control" id="inputKdBrg" name="kdBrg" value="<?=autonumber("tblbarang","kd_brg",3,"KB")?>" />
| |
| 25 | </div> | |
| 26 | </div> | |
| 27 | <div class="form-group"> | |
| 28 | <label class="col-sm-2 control-label">Nama Barang</label> | |
| 29 | <div class="col-sm-10"> | |
| 30 | <input type="text" class="form-control" id="inputNmBrg" name="nmBrg" placeholder="Input Nama Barang" autocomplete="off" required /> | |
| 31 | </div> | |
| 32 | </div> | |
| 33 | <div class="form-group"> | |
| 34 | <label class="col-sm-2 control-label">Ukuran</label> | |
| 35 | <div class="col-sm-10"> | |
| 36 | <?php | |
| 37 | echo "<select class='form-control' name='ukuran'>"; | |
| 38 | echo "<option value=0 selected>-Pilih Ukuran Barang-</option>"; | |
| 39 | include "../config/koneksi.php"; | |
| 40 | $sqlukuran = "select * from tblukuran order by id_ukuran ASC"; | |
| 41 | $queryukuran = mysql_query($sqlukuran); | |
| 42 | while($dataukuran = mysql_fetch_array($queryukuran)) | |
| 43 | {
| |
| 44 | echo "<option value='$dataukuran[ukuran]'>$dataukuran[ukuran]</option>"; | |
| 45 | } | |
| 46 | echo "</select>"; | |
| 47 | ?> | |
| 48 | </div> | |
| 49 | </div> | |
| 50 | <div class="form-group"> | |
| 51 | <label class="col-sm-2 control-label">Harga Jual</label> | |
| 52 | <div class="col-sm-10"> | |
| 53 | <input type="text" class="form-control" id="inputHrgJual" name="hrgJual" placeholder="Input Harga Jual" autocomplete="off" required /> | |
| 54 | </div> | |
| 55 | </div> | |
| 56 | <div class="form-group"> | |
| 57 | <label class="col-sm-2 control-label">Stock</label> | |
| 58 | <div class="col-sm-10"> | |
| 59 | <input type="text" class="form-control" id="inputStokAwal" name="stok" placeholder="Input Stock Barang" autocomplete="off" required /> | |
| 60 | </div> | |
| 61 | </div> | |
| 62 | <div class="form-group"> | |
| 63 | <div class="col-sm-offset-2 col-sm-10"> | |
| 64 | <button type="submit" class="btn btn-primary">Add</button> | |
| 65 | <button type="reset" class="btn btn-danger">Reset</button> | |
| 66 | </div> | |
| 67 | </div> | |
| 68 | </form> | |
| 69 | </div> | |
| 70 | <div class="modal-footer"> | |
| 71 | <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> | |
| 72 | </div> | |
| 73 | </div> | |
| 74 | ||
| 75 | </div> | |
| 76 | </div> | |
| 77 | <div class="table-responsive"> | |
| 78 | <table class="table table-hover" id="barang"> | |
| 79 | <thead> | |
| 80 | <tr> | |
| 81 | <th>No</th> | |
| 82 | <th>Kode Barang</th> | |
| 83 | <th>Nama Barang</th> | |
| 84 | <th>Ukuran</th> | |
| 85 | <th>Harga Jual</th> | |
| 86 | <th>Stock</th> | |
| 87 | <th>Tanggal Insert</th> | |
| 88 | <th>Aksi</th> | |
| 89 | </tr> | |
| 90 | </thead> | |
| 91 | <tbody> | |
| 92 | <?php | |
| 93 | include "../config/koneksi.php"; | |
| 94 | ||
| 95 | $no=1; | |
| 96 | $sql = mysql_query("select * from tblbarang order by kd_brg ASC");
| |
| 97 | $jumlah_data = mysql_num_rows($sql); | |
| 98 | while($data = mysql_fetch_array($sql)) | |
| 99 | {
| |
| 100 | ?> | |
| 101 | <tr> | |
| 102 | <td><?php echo "$no" ?></td> | |
| 103 | <td><?php echo "$data[kd_brg]" ?></td> | |
| 104 | <td><?php echo "$data[nm_brg]" ?></td> | |
| 105 | <td><?php echo "$data[ukuran]" ?></td> | |
| 106 | <td><?php echo "$data[hrg_jual]" ?></td> | |
| 107 | <td><?php echo "$data[stok]" ?></td> | |
| 108 | <td><?php echo "$data[tgl_insert]" ?></td> | |
| 109 | <td> | |
| 110 | <a class="btn btn-warning" href="?page=ubahBarang&KdUbah=<?php echo $data['kd_brg']?>" data-toggle="tooltip" data-placement="top" title="Ubah"><span class="glyphicon glyphicon-pencil"></span></a> | |
| 111 | <a class="btn btn-danger" href="barang/hapus.php?KdHapus=<?php echo $data['kd_brg']?>" Onclick="return confirm('Apakah Anda Yakin Hapus Record dengan User ID=<?php echo $data['kd_brg']?>')" data-toggle="tooltip" data-placement="top" title="Hapus"><span class="glyphicon glyphicon-trash"></span></a>
| |
| 112 | </td> | |
| 113 | </tr> | |
| 114 | - | </tbody> |
| 114 | + | |
| 115 | <?php | |
| 116 | $no++; | |
| 117 | } | |
| 118 | ?> | |
| 119 | </table> | |
| 120 | <script> | |
| 121 | $(document).ready(function(){
| |
| 122 | $('#barang').dataTable();
| |
| 123 | }); | |
| 124 | </script> | |
| 125 | <?php | |
| 126 | echo "Jumlah Data : $jumlah_data"; | |
| 127 | ?> | |
| 128 | </div> | |
| 129 | ||
| 130 | <script> | |
| 131 | $(document).ready(function(){
| |
| 132 | $('[data-toggle="tooltip"]').tooltip();
| |
| 133 | }); | |
| 134 | </script> |