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> |