tambah-penjualan

<?php
include "../config/koneksi.php";
include "../config/function.php";
include "../config/fungsi_indotgl.php";
?>
<?php
$tgl=tgl_indo(date("Y m d"));
$genCode = autonumber("tblpenjualan","no_faktur",3,"INV-".date('Ymd'));
?>

<form action="penjualan/tambah.php" method="post">
<div class="form-inline">
    <div class="navbar-form pull-right">
        <div class="form-group">
            <label for="noFaktur">Nomor Faktur</label>
            <input type="text" class="form-control" id="noFaktur" name="noFaktur" value="<?php echo $genCode ?>" readonly>
        </div>
        <div class="form-group">
            <label for="tanggal">Tanggal</label>
            <input type="text" class="form-control" id="tanggal" name="tanggal" value="<?php echo $tgl ?>" readonly>
        </div>
    </div>
</div>

    <legend>Transaksi Penjualan</legend>
        <div class="form-group">
            <button type="button" class="btn btn-info" data-toggle="modal" data-target="#myModal"><b>Cari</b> <span class="glyphicon glyphicon-search"></span></button>
        </div>
        <div class="form-inline">
        <div class="form-group">
            <input type="text" class="form-control" id="kdBrg" name="kdBrg" placeholder="Kode Barang" readonly required />
        </div>
        <div class="form-group">
            <input type="text" class="form-control" id="nmBrg" name="nmBrg" placeholder="Nama Barang" readonly required />
        </div>
        <div class="form-group">
            <input type="text" class="form-control" id="stok" name="stok" placeholder="Stok Barang" readonly required />
        </div>
        <div class="form-group">
            <input type="text" class="form-control" id="hrgJual" name="hrgJual" placeholder="Harga Jual" readonly required />
        </div>
        <div class="form-group">
            <input type="text" class="form-control" id="hrgTerJual" name="hrgTerJual" placeholder="Harga Terjual" required />
        </div>
        <div class="form-group">
            <input type="text" class="form-control" id="qty" name="qty" placeholder="Masukkan Qty" required />
        </div>
        <button type="submit" class="btn btn-primary" id="tambah">Tambahkan</button>
        </div>
</form>
    <form action="penjualan/proses.php" method="post">
    <center><h3>Penjualan Sementara</h3></center>
    <div class="table-responsive">
        <table class="table table-hover">
            <thead>
                <tr>
                    <th>Kode Barang</th>
                    <th>Nama Barang</th>
                    <th>Harga Jual</th>
                    <th>Harga Terjual</th>
                    <th>Potongan</th>
                    <th>Qty</th>
                    <th>Subtotal</th>
                    <th>Aksi</th>
                </tr>
            </thead>
            <?php
            include "../config/koneksi.php";

            $query = mysql_query("select * from tblsementara order by idsementara DESC");
            $total=mysql_fetch_array(mysql_query("select sum(subtotal) as total from tblsementara"));
            while($r=mysql_fetch_array($query)){
            ?>
                <tr>
                    <td><?php echo "$r[kd_brg]" ?></td>
                    <td><?php echo "$r[nm_brg]" ?></td>
                    <td><?php echo "$r[hrg_jual]" ?></td>
                    <td><?php echo "$r[hrg_terjual]" ?></td>
                    <td><?php echo "$r[potongan]" ?></td>
                    <td><?php echo "$r[qty]" ?></td>
                    <td><?php echo "$r[subtotal]" ?></td>
                    <td>
                        <a class="btn btn-danger" href="penjualan/hapus.php?KdHapus=<?php echo $r['idsementara']?>" Onclick="return confirm('Apakah Anda Yakin Hapus Record dengan ID=<?php echo $r['idsementara']?>')" data-toggle="tooltip" data-placement="top" title="Hapus"><span class="glyphicon glyphicon-trash"></span></a>
                    </td>
                </tr>
            <?php
            }
                echo"<tr>
                    <td colspan='6'>Total</td>
                    <td colspan='7'>$total[total]</td>
                </tr>";
            ?>
        </table>
    </div>
    <pre><button type="submit" class="btn btn-primary" id="proses">Proses</button></pre>
    </form>

<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">[&times;]</span></button>
                <h4 class="modal-title" id="myModalLabel">Lookup Barang</h4>
            </div>
            <div class="modal-body">
            <div class="table-responsive">
                <table id="lookup" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>Kode Barang</th>
                            <th>Nama Barang</th>
                            <th>Harga Terjual</th>
                            <th>Stok</th>
                        </tr>
                    </thead>
                        <?php
                            //Data mentah yang ditampilkan ke tabel
                            include "../config/koneksi.php";

                            $query = mysql_query("SELECT * FROM tblbarang order by kd_brg ASC");
                            while ($data = mysql_fetch_array($query)) {
                        ?>
                            <tr class="pilih" data-kdbrg="<?php echo $data['kd_brg']; ?>" data-nmbrg="<?php echo $data['nm_brg']; ?>" data-stok="<?php echo $data['stok']; ?>" data-hrgjual="<?php echo $data['hrg_jual']; ?>">
                                <td><?php echo $data['kd_brg']; ?></td>
                                <td><?php echo $data['nm_brg']; ?></td>
                                <td><?php echo $data['hrg_jual']; ?></td>
                                <td><?php echo $data['stok']; ?></td>
                            </tr>
                        <?php
                            }
                        ?>
                    </table>
            </div>
            </div>
        </div>
    </div>
</div>
<script>
    //jika dipilih, nim akan masuk ke input dan modal di tutup
    $(document).on('click', '.pilih', function (e) {
        document.getElementById("kdBrg").value = $(this).attr('data-kdbrg');
        document.getElementById("nmBrg").value = $(this).attr('data-nmbrg');
        document.getElementById("stok").value = $(this).attr('data-stok');
        document.getElementById("hrgJual").value = $(this).attr('data-hrgjual');
        $('#myModal').modal('hide');
    });

    //tabel lookup mahasiswa
    $(function () {
        $("#lookup").dataTable();
    });

    //tooltip
    $(document).ready(function(){
        $('[data-toggle="tooltip"]').tooltip();
    });
</script>