API tools faq
paste
Advertisement
Guest User

cetak_tunggakan.php

a guest
Dec 8th, 2019
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
raw download clone embed print report
  1. <?php include_once "../inc/indo.php"; ?>
  2. <?php include_once "../inc/conn.php"; ?>
  3. <?php include_once "../inc/rupiah.php";
  4. error_reporting(0); ?>
  5. <!DOCTYPE html>
  6. <html>
  7.  
  8. <head>
  9. <title>Cetak Bukti Pembayaran</title>
  10. </head>
  11.  
  12. <body>
  13. <table border="0" width="100%">
  14. <tr>
  15.  
  16. <td width="7%"><img src="../img/logo.png" width="70" align="left"></td>
  17. <td colspan="2" width="80%">
  18. <center><b>
  19. <font size="5">YAYASAN PENDIDIKAN MAKH <br>
  20. SMP ADVENT TONDANO</font>
  21. </b>
  22. <br>
  23. Jln. Wolter Monginsidi Kelurahan Rerewokan Kec. Tondano Barat 95615
  24. </center>
  25. </td>
  26.  
  27. <td width="7%"><img src="../img/logo.png" width="70" align="right"></td>
  28. </tr>
  29. <tr>
  30. <td colspan="4">
  31. <hr color="black">
  32. </td>
  33. </tr>
  34. <tr>
  35. <td colspan="4" align="center"><b>LAPORAN PEMBAYARAN SPP</b></td>
  36. </tr>
  37. <tr>
  38. <td></td>
  39. <td></td>
  40. <td align="right" colspan="2">Tahun Ajaran : <?php echo $_GET['ta'] ?></td>
  41. </tr>
  42. <tr>
  43. <td colspan="4">
  44. <table width=100% border="1" cellspacing=0>
  45. <thead>
  46. <tr>
  47. <th>NO</th>
  48. <th>NIS</th>
  49. <th>Nama</th>
  50. <th>Jumlah Bulan</th>
  51. <th>Biaya</th>
  52. <th>Total</th>
  53. </tr>
  54. </thead>
  55. <tbody>
  56. <?php
  57. $no = 1;
  58. $sql = mysqli_query($link, "SELECT distinct(nis) FROM temp_pembayaran where tahun_ajaran = '$_GET[ta]'");
  59. while ($tampil = mysqli_fetch_row($sql)) {
  60. $sql1 = mysqli_query($link, "SELECT nama FROM siswa where nisn='$tampil[0]'");
  61. while ($tampil1 = mysqli_fetch_row($sql1)) { ?>
  62. <tr>
  63. <td><?php echo $no++; ?></td>
  64. <td><?php echo $tampil[0]; ?></td>
  65. <td><?php echo $tampil1[0]; ?></td>
  66. <td>
  67. <?php
  68. $bulan = mysqli_query($link, "SELECT count(id) FROM temp_pembayaran where no_transaksi='' AND tahun_ajaran = '$_GET[ta]' AND nis='$tampil[0]'");
  69. while ($bln = mysqli_fetch_row($bulan)) {
  70. echo $bln[0];
  71. $a = $bln[0];
  72. }
  73. ?>
  74. </td>
  75. <td>
  76. <?php
  77. $sql1 = mysqli_query($link, "SELECT jumlah_tagihan FROM biaya where nisn='$tampil[0]' AND tahun_ajaran ='$_GET[ta]'");
  78. while ($sqla = mysqli_fetch_row($sql1)) {
  79. echo $sqla[0];
  80. $b = $sqla[0];
  81. } ?>
  82. </td>
  83. <td>
  84. <?php
  85. $sql_a = $a * $b;
  86. $c += $sql_a;
  87. echo $sql_b = rupiah($a * $b);
  88. ?>
  89. </td>
  90. </tr>
  91. <?php }
  92. } ?>
  93. <tr>
  94. <td colspan="5">
  95. Total
  96. </td>
  97. <td>
  98. <?php //include_once "aksi_tunggakan.php";
  99. echo rupiah($c);
  100. ?>
  101. </td>
  102. </tr>
  103. </tbody>
  104.  
  105. </table>
  106. </td>
  107. </tr>
  108. </table>
  109. </body>
  110.  
  111. </html>
  112. <script type="text/javascript">
  113. window.print();
  114. </script>
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!