Guest User

Untitled

a guest
Nov 3rd, 2013
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.05 KB | None | 0 0
  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. success:function(msg){
  51. data=msg.split("|");
  52.  
  53. //masukan isi data ke masing - masing field
  54. $("#nama").val(data[0]);
  55. $("#harga").val(data[1]);
  56. $("#stok").val(data[3]);
  57. $("#pegawai").focus();
  58. $("#jumlah").focus();
  59. //hilangkan status animasi dan loading
  60. $("#status").html("");
  61. $("#loading").hide();
  62. }
  63. });
  64. });
  65.  
  66. //jika tombol tambah di klik
  67. $("#tambah").click(function(){
  68. kode=$("#kode").val();
  69. stok=$("#stok").val();
  70. jumlah=$("#jumlah").val();
  71. pegawai=$("#pegawai").val();
  72. if(kode==""){
  73. alert("Kode Buku Harus diisi..");
  74. exit();
  75. }else if(jumlah > stok){
  76. alert("Stok tidak terpenuhi");
  77. $("#jumlah").focus();
  78. exit();
  79. }else if(jumlah < 1){
  80. alert("Jumlah beli tidak boleh 0");
  81. $("#jumlah").focus();
  82. exit();
  83. }
  84. nama=$("#nama").val();
  85. harga=$("#harga").val();
  86.  
  87.  
  88. $("#status").html("sedang diproses. . .");
  89. $("#loading").show();
  90.  
  91. $.ajax({
  92. url:"pk.php",
  93. data:"op=tambah&kode="+kode+"&nama="+nama+"&harga="+harga+"&jumlah="+jumlah+"&pegawai="+pegawai,
  94. cache:false,
  95. success:function(msg){
  96. if(msg=="sukses"){
  97. $("#status").html("Berhasil disimpan. . .");
  98.  
  99. }else{
  100. $("#status").html("ERROR. . .");
  101. }
  102. $("#loading").hide();
  103. $("#nama").val("");
  104. $("#harga").val("");
  105. $("#jumlah").val("");
  106. $("#stok").val("");
  107. $("#kode").load("pk.php","op=ambilbarang");
  108. $("#barang").load("pk.php","op=barang");
  109. }
  110. });
  111. });
  112.  
  113. //jika tombol proses diklik
  114. $("#proses").click(function(){
  115. kode=$("#kode").val();
  116. stok=$("#stok").val();
  117. pegawai=$("#pegawai").val();
  118.  
  119. if(kode==""){
  120. alert("Tidak ada data yang akan diproses..");
  121. exit();
  122. }
  123. nota=$("#nota").val();
  124. tanggal=$("#tanggal").val();
  125.  
  126. $.ajax({
  127. url:"pk.php",
  128. data:"op=proses&nota="+nota+"&tanggal="+tanggal,
  129. cache:false,
  130. success:function(msg){
  131. if(msg=='sukses'){
  132. $("#status").html('Transaksi Pembelian berhasil');
  133. alert('Transaksi Berhasil');
  134. windows.location('?page=penjualan');
  135. }else{
  136. $("#status").html('Transaksi Gagal');
  137. alert('Transaksi Gagal');
  138.  
  139. }
  140. $("#kode").val("");
  141. $("#barang").val("");
  142. $("#loading").hide();
  143. $("#nama").val("");
  144. $("#harga").val("");
  145. $("#jumlah").val("");
  146. $("#stok").val("");
  147. $("#pegawai").val("");
  148. }
  149. })
  150. })
  151. });
  152. </script>
  153. </head>
  154. <body>
  155. <div class="container">
  156. <?php
  157. include "db/koneksi.php";
  158. include "fungsi_indotgl.php";
  159. $p=isset($_GET['act'])?$_GET['act']:null;
  160. switch($p){
  161. default:
  162. echo "<table class='table table-bordered'>
  163. <tr>
  164. <td colspan='3'><a href='?page=penjualan&act=tambah' class='btn btn-primary'>Input Transaksi</a></td>
  165. </tr>
  166. <tr>
  167. <td>ID Penjualan</td>
  168. <td>Tanggal</td>
  169. <td>Jumlah</td>
  170. <td>Nama Kasir</td>
  171. <td>Tools</td>
  172. </tr>";
  173. $query=mysql_query("select a.id_penjualan, a.tanggal, a.total, b.nama from tabel_penjualan a,
  174. tabel_pegawai b where a.id_pegawai=b.id_pegawai");
  175. while($r=mysql_fetch_array($query)){
  176. echo "<tr>
  177. <td><a href='?page=penjualan&act=detail&nota=$r[id_penjualan]'>$r[id_penjualan]</a></td>";?>
  178. <td><?php echo tgl_indo($r['tanggal']);?></td>
  179. <td align="right">Rp. <?php echo number_format($r[total]);?>,-</td><?php echo "
  180. <td>$r[nama]</td>
  181. <td><a href='?page=penjualan&act=detail&nota=$r[id_penjualan]'>Cetak Nota</a></td>
  182. </tr>";
  183. }
  184. echo"</table>";
  185.  
  186. break;
  187. case "tambah":
  188. $tgl=date('Y-m-d');
  189. //untuk autonumber di nota
  190. $auto=mysql_query("select * from tabel_penjualan order by id_penjualan desc limit 1");
  191. $no=mysql_fetch_array($auto);
  192. $angka=$no['id_penjualan']+1;
  193. echo "<div class='navbar-form pull-right'>
  194. ID Penjualan: <input type='text' id='nota' value='$angka' readonly >
  195. <input type='text' id='tanggal' value='$tgl' readonly>
  196. </div>";
  197.  
  198. echo'<legend>Transaksi Penjualan</legend>
  199. <label>ID Buku</label>
  200. <input type="text" id="kode" placeholder="Kode Buku" class="span2">
  201. <input type="hidden" id="nama" placeholder="Nama Barang" readonly>
  202. <input type="hidden" id="harga" placeholder="Harga" class="span2" readonly>
  203. <input type="hidden" id="stok" placeholder="stok" class="span1" readonly>
  204. <input type="text" id="jumlah" placeholder="Jumlah Beli" class="span1">
  205.  
  206. <input type="hidden" size=5 id="pegawai" value="'.$_SESSION['id_pegawai'].'">
  207. <button id="tambah" class="btn">Tambah</button>
  208. <span id="status"></span>
  209. <table id="barang" class="table table-bordered">
  210.  
  211. </table>
  212. <div class="form-actions">
  213. <button id="proses">Proses</button>
  214. </div>';
  215. break;
  216. case "detail":
  217. echo "<legend>Nota Penjualan</legend>";
  218. $nota=$_GET['nota'];
  219. $query=mysql_query("select b.id_penjualan, a.id_buku, c.nama,
  220. a.harga, a.jumlah, a.subtotal
  221. from tabel_detail_penjualan a, tabel_penjualan b,tabel_buku c
  222. where b.id_penjualan= a.id_penjualan and c.id_buku=a.id_buku
  223. and a.id_penjualan= '$nota'");
  224. $nomor=mysql_fetch_array(mysql_query("select * from tabel_penjualan where id_penjualan='$nota'"));
  225. echo "<div class='navbar-form pull-right'>
  226. Nota : <input type='text' value='$nomor[id_penjualan]' disabled>
  227. <input type='text' value='$nomor[tanggal]' disabled>
  228. </div>";
  229. echo "<table class='table table-hover'>
  230. <thead>
  231. <tr>
  232. <td>Kode Barang</td>
  233. <td>Nama</td>
  234. <td>Harga</td>
  235. <td>Jumlah</td>
  236. <td>Subtotal</td>
  237. </tr>
  238. </thead>";
  239. while($r=mysql_fetch_row($query)){
  240. echo "<tr>
  241. <td>$r[1]</td>
  242. <td>$r[2]</td>
  243. <td>$r[3]</td>
  244. <td>$r[4]</td>
  245. <td>$r[5]</td>
  246. </tr>";
  247. }
  248. echo "<tr>
  249. <td colspan='4'><h4 align='right'>Total</h4></td>
  250. <td colspan='5'><h4>$nomor[total]</h4></td>
  251. </tr>
  252. </table>";
  253. break;
  254. }
  255. ?>
  256. </div>
  257. </body>
  258. <?php
  259. } else {
  260. echo "<script>alert('Anda tidak berhak mengakses halaman ini..')
  261. location.href='../index.php'</script>";
  262. }
  263. ?>
  264. </html>
Advertisement
Add Comment
Please, Sign In to add comment