Advertisement
Guest User

Untitled

a guest
Jul 30th, 2016
929
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.03 KB | None | 0 0
  1. <h1>Laporan Penjualan </h1>
  2. <?php
  3. include("koneksi.php");
  4.  
  5.  
  6. if(isset($_POST["hapus"]))
  7. {
  8. $a=$_POST["id_transaksi1"];
  9. $sqlnya="delete from tblpenjualan where idtransaksi = '$a'";
  10. $hasil=mysqli_query($koneksinya,$sqlnya);
  11. }
  12.  
  13. if(isset($_POST["detail"]))
  14. {
  15. $a=$_POST["id_transaksi1"];
  16. $sqlnya="select * from tblpenjualandetail where idtransaksi='$a'";
  17. $hasil=mysqli_query($koneksinya,$sqlnya);
  18.  
  19. echo "<center><table></center>";
  20. echo "<tr><td>No</td><td>ID Transaksi</td><td>Kode Barang </td> <td>Jumlah Barang</td><td>Harga</td></tr>";
  21. if(mysqli_num_rows($hasil)>0)
  22. {
  23. while($baris=mysqli_fetch_assoc($hasil))
  24. {
  25. $a=$baris["idtransaksi"];
  26. $b=$baris["KodeBrg"];
  27. $c=$baris["Stock"];
  28. $d=$baris["HargaJual"];
  29. $e=$baris["iddetail"];
  30. echo "<form action='' method='post'>";
  31. echo "<tr><td><input type='text' value = '$e' name='id_detail1'></td>";
  32. echo "<td><input type='text' value = '$a' name='id_transaksi1'></td>";
  33. echo "<td><input type='text' value = '$b' name='kodebrg1'></td>";
  34. echo "<td><input type='text' value = '$c' name='qty1'></td>";
  35. echo "<td><input type='text' value = '$d' name='hrgjual1'></td></tr>";
  36. echo "</form>";
  37. }
  38. }
  39. }else{
  40.  
  41. if(isset($_POST["simpan"]))
  42. {
  43. $a=$_POST["tanggal_transaksi1"];
  44. $sqlnya="select * from tblpenjualan where tanggal_transaksi='$a'";
  45. $hasil=mysqli_query($koneksinya,$sqlnya);
  46.  
  47. echo "<table>";
  48. echo "<tr><td>Kode Pembelian</td><td>Grand Total </td> <td>Tanggal</td><td>Waktu</td></tr>";
  49. if(mysqli_num_rows($hasil)>0)
  50. {
  51. while($baris=mysqli_fetch_assoc($hasil))
  52. {
  53. $a=$baris["id_transaksi"];
  54. $b=$baris["tanggal_transaksi"];
  55. $c=$baris["waktu_transaksi"];
  56. $d=$baris["total_harga"];
  57. echo "<form action='' method='post'>";
  58. echo "<tr><td><input type='text' value = '$a' name='id_transaksi1'></td>";
  59. echo "<td><input type='text' value = '$d' name='total_harga1'></td>";
  60. echo "<td><input type='text' value = '$b' name='tanggal_transaksi1'></td>";
  61. echo "<td><input type='text' value = '$c' name='waktu_transaksi1'></td>";
  62. echo "<td><input type='submit' value='delete' name='hapus'></td>";
  63. echo "<td><input type='submit' value='Detail Transaksi' name='detail'></td></tr>";
  64. echo "</form>";
  65. }
  66. }
  67. }
  68. else{
  69. $sqlnya="select * from tblpenjualan";
  70. $hasil=mysqli_query($koneksinya,$sqlnya);
  71.  
  72. echo "<table>";
  73. echo "<tr><td>Kode Pembelian</td><td>Grand Total </td> <td>Tanggal</td></tr>";
  74. if(mysqli_num_rows($hasil)>0)
  75. {
  76. while($baris=mysqli_fetch_assoc($hasil))
  77. {
  78. $a=$baris["idtransaksi"];
  79. $b=$baris["tanggal"];
  80. // $c=$baris["waktu_transaksi"];
  81. $d=$baris["grandtotal"];
  82. echo "<form action='' method='post'>";
  83. echo "<tr><td><input type='text' value = '$a' name='id_transaksi1'></td>";
  84. echo "<td><input type='text' value = '$d' name='total_harga1'></td>";
  85. echo "<td><input type='text' value = '$b' name='tanggal_transaksi1'></td>";
  86. // echo "<td><input type='text' value = '$c' name='waktu_transaksi1'></td>";
  87. // echo "<td><input type='submit' value='Delete' name='hapus'></td>";
  88. echo "<td><input type='submit' value='Detail' name='detail'></td></tr>";
  89. echo "</form>";
  90. }
  91. }
  92. }
  93. echo "</table>";
  94. }
  95. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement