SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | session_start(); | |
| 3 | if (($_SESSION['level']=="Kasir")and($_SESSION['status']=="Aktif")and isset($_SESSION['id_pegawai'])){
| |
| 4 | include "../koneksi.php"; | |
| 5 | ?> | |
| 6 | <!DOCTYPE html> | |
| 7 | <html> | |
| 8 | <head> | |
| 9 | <title>Transaki Penjualan</title> | |
| 10 | <link rel="stylesheet" href="css/bootstrap.css"> | |
| 11 | <script src="js/jquery.js"></script> | |
| 12 | <script src="js/jquery.ui.datepicker.js"></script> | |
| 13 | <script> | |
| 14 | //mendeksripsikan variabel yang akan digunakan | |
| 15 | var nota; | |
| 16 | var tanggal; | |
| 17 | var kode; | |
| 18 | var nama; | |
| 19 | var harga; | |
| 20 | var jumlah; | |
| 21 | var pegawai; | |
| 22 | var stok; | |
| 23 | $(function(){
| |
| 24 | //meload file pk dengan operator ambil barang dimana nantinya | |
| 25 | //isinya akan masuk di combo box | |
| 26 | ||
| 27 | ||
| 28 | //meload isi tabel | |
| 29 | $("#barang").load("pk.php","op=barang");
| |
| 30 | ||
| 31 | //mengkosongkan input text dengan masing2 id berikut | |
| 32 | $("#nama").val("");
| |
| 33 | $("#harga").val("");
| |
| 34 | $("#jumlah").val("");
| |
| 35 | $("#stok").val("");
| |
| 36 | ||
| 37 | //jika ada perubahan di kode barang | |
| 38 | $("#kode").change(function(){
| |
| 39 | kode=$("#kode").val();
| |
| 40 | ||
| 41 | //tampilkan status loading dan animasinya | |
| 42 | $("#status").html("loading. . .");
| |
| 43 | $("#loading").show();
| |
| 44 | ||
| 45 | //lakukan pengiriman data | |
| 46 | $.ajax({
| |
| 47 | url:"proses.php", | |
| 48 | data:"op=ambildata&kode="+kode, | |
| 49 | cache:false, | |
| 50 | dataType: "json", | |
| 51 | success:function(msg){
| |
| 52 | data=msg.split("|");
| |
| 53 | ||
| 54 | //masukan isi data ke masing - masing field | |
| 55 | $("#nama").val(data[0]);
| |
| 56 | $("#harga").val(data[1]);
| |
| 57 | $("#stok").val(data[3]);
| |
| 58 | $("#pegawai").focus();
| |
| 59 | $("#jumlah").focus();
| |
| 60 | //hilangkan status animasi dan loading | |
| 61 | $("#status").html("");
| |
| 62 | $("#loading").hide();
| |
| 63 | } | |
| 64 | }); | |
| 65 | }); | |
| 66 | ||
| 67 | //jika tombol tambah di klik | |
| 68 | $("#tambah").click(function(){
| |
| 69 | kode=$("#kode").val();
| |
| 70 | stok=$("#stok").val();
| |
| 71 | jumlah=$("#jumlah").val();
| |
| 72 | pegawai=$("#pegawai").val();
| |
| 73 | if(kode==""){
| |
| 74 | alert("Kode Buku Harus diisi..");
| |
| 75 | exit(); | |
| 76 | }else if(jumlah > stok){
| |
| 77 | alert("Stok tidak terpenuhi");
| |
| 78 | $("#jumlah").focus();
| |
| 79 | exit(); | |
| 80 | }else if(jumlah < 1){
| |
| 81 | alert("Jumlah beli tidak boleh 0");
| |
| 82 | $("#jumlah").focus();
| |
| 83 | exit(); | |
| 84 | } | |
| 85 | nama=$("#nama").val();
| |
| 86 | harga=$("#harga").val();
| |
| 87 | ||
| 88 | ||
| 89 | $("#status").html("sedang diproses. . .");
| |
| 90 | $("#loading").show();
| |
| 91 | ||
| 92 | $.ajax({
| |
| 93 | url:"pk.php", | |
| 94 | data:"op=tambah&kode="+kode+"&nama="+nama+"&harga="+harga+"&jumlah="+jumlah+"&pegawai="+pegawai, | |
| 95 | cache:false, | |
| 96 | success:function(msg){
| |
| 97 | if(msg=="sukses"){
| |
| 98 | $("#status").html("Berhasil disimpan. . .");
| |
| 99 | ||
| 100 | }else{
| |
| 101 | $("#status").html("ERROR. . .");
| |
| 102 | } | |
| 103 | $("#loading").hide();
| |
| 104 | $("#nama").val("");
| |
| 105 | $("#harga").val("");
| |
| 106 | $("#jumlah").val("");
| |
| 107 | $("#stok").val("");
| |
| 108 | $("#kode").load("pk.php","op=ambilbarang");
| |
| 109 | $("#barang").load("pk.php","op=barang");
| |
| 110 | } | |
| 111 | }); | |
| 112 | }); | |
| 113 | ||
| 114 | //jika tombol proses diklik | |
| 115 | $("#proses").click(function(){
| |
| 116 | kode=$("#kode").val();
| |
| 117 | stok=$("#stok").val();
| |
| 118 | pegawai=$("#pegawai").val();
| |
| 119 | ||
| 120 | if(kode==""){
| |
| 121 | alert("Tidak ada data yang akan diproses..");
| |
| 122 | exit(); | |
| 123 | } | |
| 124 | nota=$("#nota").val();
| |
| 125 | tanggal=$("#tanggal").val();
| |
| 126 | ||
| 127 | $.ajax({
| |
| 128 | url:"pk.php", | |
| 129 | data:"op=proses¬a="+nota+"&tanggal="+tanggal, | |
| 130 | cache:false, | |
| 131 | success:function(msg){
| |
| 132 | if(msg=='sukses'){
| |
| 133 | $("#status").html('Transaksi Pembelian berhasil');
| |
| 134 | alert('Transaksi Berhasil');
| |
| 135 | windows.location('?page=penjualan');
| |
| 136 | }else{
| |
| 137 | $("#status").html('Transaksi Gagal');
| |
| 138 | alert('Transaksi Gagal');
| |
| 139 | ||
| 140 | } | |
| 141 | $("#kode").val("");
| |
| 142 | $("#barang").val("");
| |
| 143 | $("#loading").hide();
| |
| 144 | $("#nama").val("");
| |
| 145 | $("#harga").val("");
| |
| 146 | $("#jumlah").val("");
| |
| 147 | $("#stok").val("");
| |
| 148 | $("#pegawai").val("");
| |
| 149 | } | |
| 150 | }) | |
| 151 | }) | |
| 152 | }); | |
| 153 | </script> | |
| 154 | </head> | |
| 155 | <body> | |
| 156 | <div class="container"> | |
| 157 | <?php | |
| 158 | include "db/koneksi.php"; | |
| 159 | include "fungsi_indotgl.php"; | |
| 160 | - | switch($p){
|
| 160 | + | |
| 161 | - | default: |
| 161 | + | |
| 162 | if($p==null){
| |
| 163 | echo "<table class='table table-bordered'> | |
| 164 | <tr> | |
| 165 | <td colspan='3'><a href='?page=penjualan&act=tambah' class='btn btn-primary'>Input Transaksi</a></td> | |
| 166 | </tr> | |
| 167 | <tr> | |
| 168 | <td>ID Penjualan</td> | |
| 169 | <td>Tanggal</td> | |
| 170 | <td>Jumlah</td> | |
| 171 | <td>Nama Kasir</td> | |
| 172 | <td>Tools</td> | |
| 173 | </tr>"; | |
| 174 | $query=mysql_query("select a.id_penjualan, a.tanggal, a.total, b.nama from tabel_penjualan a,
| |
| 175 | tabel_pegawai b where a.id_pegawai=b.id_pegawai"); | |
| 176 | while($r=mysql_fetch_array($query)){
| |
| 177 | echo "<tr> | |
| 178 | <td><a href='?page=penjualan&act=detail¬a=$r[id_penjualan]'>$r[id_penjualan]</a></td>";?> | |
| 179 | <td><?php echo tgl_indo($r['tanggal']);?></td> | |
| 180 | <td align="right">Rp. <?php echo number_format($r[total]);?>,-</td><?php echo " | |
| 181 | <td>$r[nama]</td> | |
| 182 | <td><a href='?page=penjualan&act=detail¬a=$r[id_penjualan]'>Cetak Nota</a></td> | |
| 183 | </tr>"; | |
| 184 | } | |
| 185 | echo"</table>"; | |
| 186 | - | break; |
| 186 | + | |
| 187 | - | case "tambah": |
| 187 | + | } |
| 188 | ||
| 189 | if($p=="tambah"){
| |
| 190 | $tgl=date('Y-m-d');
| |
| 191 | //untuk autonumber di nota | |
| 192 | $auto=mysql_query("select * from tabel_penjualan order by id_penjualan desc limit 1");
| |
| 193 | $no=mysql_fetch_array($auto); | |
| 194 | $angka=$no['id_penjualan']+1; | |
| 195 | echo "<div class='navbar-form pull-right'> | |
| 196 | ID Penjualan: <input type='text' id='nota' value='$angka' readonly > | |
| 197 | <input type='text' id='tanggal' value='$tgl' readonly> | |
| 198 | </div>"; | |
| 199 | ||
| 200 | echo'<legend>Transaksi Penjualan</legend> | |
| 201 | <label>ID Buku</label> | |
| 202 | <input type="text" id="kode" placeholder="Kode Buku" class="span2"> | |
| 203 | <input type="hidden" id="nama" placeholder="Nama Barang" readonly> | |
| 204 | <input type="hidden" id="harga" placeholder="Harga" class="span2" readonly> | |
| 205 | <input type="hidden" id="stok" placeholder="stok" class="span1" readonly> | |
| 206 | <input type="text" id="jumlah" placeholder="Jumlah Beli" class="span1"> | |
| 207 | ||
| 208 | <input type="hidden" size=5 id="pegawai" value="'.$_SESSION['id_pegawai'].'"> | |
| 209 | <button id="tambah" class="btn">Tambah</button> | |
| 210 | <span id="status"></span> | |
| 211 | <table id="barang" class="table table-bordered"> | |
| 212 | ||
| 213 | </table> | |
| 214 | <div class="form-actions"> | |
| 215 | - | break; |
| 215 | + | |
| 216 | - | case "detail": |
| 216 | + | |
| 217 | } | |
| 218 | if($p=="detail"){
| |
| 219 | echo "<legend>Nota Penjualan</legend>"; | |
| 220 | $nota=$_GET['nota']; | |
| 221 | $query=mysql_query("select b.id_penjualan, a.id_buku, c.nama,
| |
| 222 | a.harga, a.jumlah, a.subtotal | |
| 223 | from tabel_detail_penjualan a, tabel_penjualan b,tabel_buku c | |
| 224 | where b.id_penjualan= a.id_penjualan and c.id_buku=a.id_buku | |
| 225 | and a.id_penjualan= '$nota'"); | |
| 226 | $nomor=mysql_fetch_array(mysql_query("select * from tabel_penjualan where id_penjualan='$nota'"));
| |
| 227 | echo "<div class='navbar-form pull-right'> | |
| 228 | Nota : <input type='text' value='$nomor[id_penjualan]' disabled> | |
| 229 | <input type='text' value='$nomor[tanggal]' disabled> | |
| 230 | </div>"; | |
| 231 | echo "<table class='table table-hover'> | |
| 232 | <thead> | |
| 233 | <tr> | |
| 234 | <td>Kode Barang</td> | |
| 235 | <td>Nama</td> | |
| 236 | <td>Harga</td> | |
| 237 | <td>Jumlah</td> | |
| 238 | <td>Subtotal</td> | |
| 239 | </tr> | |
| 240 | </thead>"; | |
| 241 | while($r=mysql_fetch_row($query)){
| |
| 242 | echo "<tr> | |
| 243 | <td>$r[1]</td> | |
| 244 | <td>$r[2]</td> | |
| 245 | <td>$r[3]</td> | |
| 246 | <td>$r[4]</td> | |
| 247 | <td>$r[5]</td> | |
| 248 | </tr>"; | |
| 249 | } | |
| 250 | echo "<tr> | |
| 251 | <td colspan='4'><h4 align='right'>Total</h4></td> | |
| 252 | <td colspan='5'><h4>$nomor[total]</h4></td> | |
| 253 | - | break; |
| 253 | + | |
| 254 | </table>"; | |
| 255 | ||
| 256 | } | |
| 257 | ?> | |
| 258 | </div> | |
| 259 | </body> | |
| 260 | <?php | |
| 261 | } else {
| |
| 262 | echo "<script>alert('Anda tidak berhak mengakses halaman ini..')
| |
| 263 | location.href='../index.php'</script>"; | |
| 264 | } | |
| 265 | ?> | |
| 266 | </html> |