API tools faq
paste
Advertisement
GWibisono

Pembayaran (tes)

GWibisono
Jun 6th, 2012
999
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.01 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. error_reporting(1);
  3. if($_POST['bayar']){
  4.     echo'<pre>';print_r($_POST);die('</pre>');
  5.     require('proses/doInsertTransaksi.php');
  6. }
  7.  
  8. ?>
  9.  
  10. <html>
  11.  
  12. <head>
  13.   <title>Data List</title>
  14.  
  15.  
  16. </head>
  17.  
  18. <body>
  19.  
  20. <?php
  21. include("connect.php");
  22.            
  23.         //$id_transaksi = 0;
  24.  
  25.         $query = "SELECT max(id_transaksi) as maxID FROM master_transaksi";
  26.      
  27.         $hasil = mysql_query($query);
  28.         $data  = mysql_fetch_array($hasil);
  29.         $idMax = $data['maxID'];
  30.  
  31.         $noUrut = (int) substr($idMax, 2, 4);
  32.         $noUrut++;
  33.                  
  34.         $newID = 'TR' . sprintf("%05s", $noUrut) . 'P';
  35.  
  36.         $date = date("F-d-Y");
  37.  
  38.             echo "<table align='center'>";
  39.             echo "<form action='' name='formTrans' method='POST'>";
  40.             //proses/doInsertTransaksi.php
  41.              echo"<tr bgcolor='iceblue'>";
  42.               echo "<td align='center' colspan='9' >
  43. <font face='ARIALblack' size='20' color='white'>";
  44.               echo " SKY.Net POS System <br>
  45. <br>
  46. </td>";
  47.              echo"</tr>";
  48.              echo"<tr bgcolor='iceblue'>";
  49.               echo "<td align='left' colspan='9'>
  50. <font face='calibri' color='white'>$date</td>";
  51.              echo "</tr>";
  52.              echo"<tr bgcolor='iceblue'>";
  53.               echo "<td align='left' colspan='9'>
  54. <font face='calibri' color='white'> No Transaksi: </br> $newID </td>";
  55.              echo "</tr>";
  56.              echo"<tr bgcolor='iceblue'>";
  57.               echo "<td align='center' width='8' >
  58. <font face='calibri' color='white'> No </td>";
  59.               echo "<td align='center' width='10'>
  60. <font face='calibri' color='white'> ID Produk </td>";
  61.               echo "<td align='center'>
  62.               <font face='calibri' color='white'> Nama Produk </td>";
  63.               echo "<td align='center'>
  64. <font face='calibri' color='white'> Kategori Produk </td>";
  65.               echo "<td align='center'>
  66. <font face='calibri' color='white'> Harga Satuan </td>";
  67.               echo "<td align='center'>
  68. <font face='calibri' color='white'> Stok </td>";
  69.               echo "<td align='center'>
  70. <font face='calibri' color='white'> QTY </td>";
  71.               echo "<td align='center'>
  72. <font face='calibri' color='white'> Total Harga </td>";
  73.              echo "</tr>";
  74.  
  75.                 $nomor = 0;
  76.                 $grand_total = 0;
  77.  
  78.                 //foreach($_POST['merk'] as $id){
  79.     foreach($_POST['merk'] as $id){
  80.  
  81.                 $query = "select id_produk, merk_produk, kategori, harga_jual, jumlah_stok FROM master_produk " .
  82.                         "WHERE merk_produk = '$id' ";
  83.                 $result = mysql_query($query, $conn)or
  84.                   die(mysql_error()."An error occure in SQL query <br> Query: $query");
  85.  
  86.         while($line = mysql_fetch_row($result)){
  87.                        
  88.                      $nomor++;
  89.                      $qty = $_POST['banyak'][$id];
  90.  
  91.                      $idproduk = $line[0];
  92.                      $merk = $line[1];
  93.                      $kategori = $line[2];
  94.                      $harga_jual = $line[3];
  95.                      $jumlah_stok = $line[4];
  96.                      $jumlah_harga = $harga_jual*$qty;
  97.                      $grand_total += $jumlah_harga;
  98.                    
  99.     echo"<tr bgcolor='iceblue'>";
  100.     echo "<td align='center' >
  101. <font face='calibri' color='white'> $nomor </td>";
  102.     echo "<td>
  103. <input type='text' size='8%' name='idproduk' value='$idproduk' disabled='disabled'>
  104. </td>";
  105.     echo "<td>
  106. <input type='text' size='35%' name='merk' value='$merk' disabled='disabled'>
  107. </td>";
  108.     echo "<td>
  109. <input type='text' size='13%' name='kategori' value='$kategori' disabled='disabled'>
  110. </td>";
  111.     echo "<td>
  112. <input type='text' size='20%' name='harga' value='$harga_jual' disabled='disabled'>
  113. </td>";
  114.     echo "<td>
  115. <input type='text' size='2%' name='stok' value='$jumlah_stok' disabled='disabled'>
  116. </td>";
  117.     echo "<td>
  118. <input type='text' size='2%' name='QTY' value='$qty' disabled='disabled'>
  119. </td>";
  120.     echo "<td>
  121. <input type='text' size='20%' name='total' value='$jumlah_harga' disabled='disabled'>
  122. </td>";
  123.     echo "</tr>";
  124.         }
  125.     }      
  126.    
  127.     echo"<tr bgcolor='iceblue'>";
  128.     echo "<td align='right' colspan='9'>
  129. <font face='calibri' color='white'>Grand Total: ";
  130.     echo "<input type='text' name='total' value='$grand_total' disabled='disabled'> </td>";
  131.     echo "</tr>";
  132.     echo"<tr bgcolor='iceblue'>";
  133.     echo "<td align='right' colspan='9'>
  134. <font face='calibri' color='white'> ";
  135.     echo "<input type='submit' name='bayar' value='Bayar'> </td>";
  136.     echo "</tr>";
  137.     echo "</form>";
  138.     echo "</table>";
  139.  
  140. ?>
  141.  
  142. </body>
  143.  
  144. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!