API tools faq
paste
Ikki_wrs

rep

Ikki_wrs
Jul 22nd, 2016
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.95 KB | None | 0 0
raw download clone embed print report
  1. ------------ halaman re-p.php-------------
  2. <?php
  3. require_once "../../config/koneksi.php";
  4. ?>
  5. <!DOCTYPE html>
  6. <html lang="en">
  7. <head>
  8. <meta charset="utf-8">
  9. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  10. <meta name="viewport" content="width=device-width, initial-scale=1">
  11. <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
  12. <title>Sysco Admin Finance</title>
  13.  
  14. <!-- favicon -->
  15. <link rel="shortcut icon" href="">
  16.  
  17. <!-- Bootstrap -->
  18. <link href="../../assets/css/bootstrap.min.css" rel="stylesheet">
  19. <link href="../../assets/css/datepicker.min.css" rel="stylesheet">
  20.  
  21. <!-- styles -->
  22. <link href="../../assets/css/style.css" rel="stylesheet">
  23. <link rel="shortcut icon" href="../favicon.ico">
  24. <link rel="stylesheet" type="text/css" href="../css/normalize.css" />
  25. <link rel="stylesheet" type="text/css" href="../css/demo.css" />
  26. <link rel="stylesheet" type="text/css" href="../css/component.css" />
  27. <script src="../js/modernizr.custom.js"></script>
  28. </head>
  29. <body>
  30. <br><br>
  31. <link href="../assets/css/bootstrap.css" rel="stylesheet" />
  32. <link href="../assets/css/font-awesome.css" rel="stylesheet" />
  33. <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
  34.  
  35. <!-- Fungsi untuk membatasi karakter yang diinputkan -->
  36. <script language="javascript">
  37. function getkey(e)
  38. {
  39. if (window.event)
  40. return window.event.keyCode;
  41. else if (e)
  42. return e.which;
  43. else
  44. return null;
  45. }
  46.  
  47. function goodchars(e, goods, field)
  48. {
  49. var key, keychar;
  50. key = getkey(e);
  51. if (key == null) return true;
  52.  
  53. keychar = String.fromCharCode(key);
  54. keychar = keychar.toLowerCase();
  55. goods = goods.toLowerCase();
  56.  
  57. // check goodkeys
  58. if (goods.indexOf(keychar) != -1)
  59. return true;
  60. // control keys
  61. if ( key==null || key==0 || key==8 || key==9 || key==27 )
  62. return true;
  63.  
  64. if (key == 13) {
  65. var i;
  66. for (i = 0; i < field.form.elements.length; i++)
  67. if (field == field.form.elements[i])
  68. break;
  69. i = (i + 1) % field.form.elements.length;
  70. field.form.elements[i].focus();
  71. return false;
  72. };
  73. // else return false
  74. return false;
  75. }
  76. </script>
  77. </head>
  78. <body>
  79. <div class="container-fluid">
  80. <form action="r-p.php" method="get" target="_blank">
  81. <div class="form-group">
  82. <label class="col-sm-2 control-label">Cabang</label>
  83. <table width="600"><td width="300"><div class="col-sm-3">
  84. <select name="cabang" class="form-control" required>
  85. <option value=""> - Pilih - </option>
  86. <option value="mataram">Mataram</option>
  87. <option value="bertais">Bertais</option>
  88. <option value="selong">Selong</option>
  89. <option value="tanjung">tanjung</option>
  90. <option value="praya">Praya</option>
  91. <option value="taliwang">Taliwang</option>
  92. <option value="sumbawa">Sumbawa</option>
  93. <option value="bima">Bima</option>
  94. <option value="sompu">Dompu</option>
  95. <option value="pusat">Pusat</option>
  96. </select>
  97. </div></td></table>
  98. </div>
  99.  
  100. <div class="form-group">
  101. <label class="col-sm-2 control-label">Dari Tanggal</label>
  102. <table width="600"><td width="300"><div class="col-sm-3">
  103. <input name="tgl_a" type="text" class="form-control date-picker" id="tgl_a" autocomplete="off" size="50" data-date-format="yyyy-mm-dd" >
  104. </div></td></table>
  105. </div>
  106. <div class="form-group">
  107. <label class="col-sm-2 control-label">Sampai Tanggal</label>
  108. <table width="600"><td width="300"><div class="col-sm-3">
  109. <input name="tgl_b" type="text" class="form-control date-picker" id="tgl_b" autocomplete="off" size="50" data-date-format="yyyy-mm-dd" >
  110. </div></td></table>
  111. </div>
  112.  
  113.  
  114. <hr/>
  115. <div class="form-group">
  116. <div class="col-sm-offset-2 col-sm-10">
  117. <input type="submit" class="btn btn-info " name="Cetak" value="Cetak">
  118. <a href="../bbm.php" class="btn btn-default btn-reset">Batal</a>
  119. </div>
  120. </div>
  121. </form>
  122.  
  123. </div> <!-- /.container-fluid -->
  124. <ul id="gn-menu" class="gn-menu-main">
  125. <li class="gn-trigger">
  126. <a class="gn-icon gn-icon-menu"><span>Menu</span></a>
  127. <nav class="gn-menu-wrapper">
  128. <div class="gn-scroller">
  129. <ul class="gn-menu">
  130. <li><a class="gn-icon gn-icon-archive" href="../bbm.php">Beranda BBM</a></li>
  131. <li><a class="gn-icon gn-icon-archive" href="../staff/index.php">Data Karyawan</a></li>
  132. <li><a class="gn-icon gn-icon-archive" href="../kendaraan/index.php">Data Kendaraan</a></li>
  133. <li><a class="gn-icon gn-icon-archive" href="../supir/index.php">Data Supir</a></li>
  134. <li><a class="gn-icon gn-icon-archive" href="../bbm/index.php">Data BBM</a>
  135. <li><a class="gn-icon gn-icon-archive" href="../voucher/index.php">Data Transaksi</a>
  136. </li>
  137.  
  138. <li><a class="gn-icon gn-icon-archive" href="index.php">Laporan</a>
  139. </ul>
  140. </div><!-- /gn-scroller -->
  141. </nav>
  142. </li>
  143. <li><a class="codrops-icon codrops-icon-prev" href="../config/log.php?op=out"><span>Log Out</span></a></li>
  144. </ul>
  145.  
  146.  
  147.  
  148. <footer class="footer">
  149. <div class="container-fluid">
  150. <p class="text-muted pull-left">&copy; 2016 Bu5eT KDA</p>
  151. <p class="text-muted pull-right ">System By <a href="" target="_blank">Krida Dinamik Autonusa</a></p>
  152. </div>
  153. </footer>
  154.  
  155. <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
  156. <script src="../../assets/js/jquery.min.js"></script>
  157. <!-- Include all compiled plugins (below), or include individual files as needed -->
  158. <script src="../../assets/js/bootstrap.min.js"></script>
  159. <script src="../../assets/js/bootstrap-datepicker.min.js"></script>
  160. </div><!-- /container -->
  161. <script src="../js/classie.js"></script>
  162. <script src="../js/gnmenu.js"></script>
  163. <script>
  164. new gnMenu( document.getElementById( 'gn-menu' ) );
  165. </script>
  166. <script type="text/javascript">
  167. $(function () {
  168.  
  169. //datepicker plugin
  170. $('.date-picker').datepicker({
  171. autoclose: true,
  172. todayHighlight: true
  173. });
  174.  
  175. // toolip
  176. $('[data-toggle="tooltip"]').tooltip();
  177. })
  178. </script>
  179. </body>
  180. </html>
  181.  
  182.  
  183. -------------------------------------------------------- halaman r-p.php ------
  184. <?php
  185. $nama_dokumen='PDF With MPDF';
  186. define('_MPDF_PATH','../MPDF60/');
  187. include(_MPDF_PATH . "mpdf.php");
  188. $mpdf=new mPDF('utf-8', 'A4');
  189. ob_start();
  190. ?>
  191. <table width="1251" style="border-collapse:collapse;">
  192. <tr>
  193. <td width="75" align="center" style="border:1px solid #999;padding:4px 8px;">No. Vouc</td>
  194. <td width="89" align="center" style="border:1px solid #999;padding:4px 8px;">Tanggal</td>
  195. <td width="167" align="center" style="border:1px solid #999;padding:4px 8px;">Nama</td>
  196. <td width="79" align="center" style="border:1px solid #999;padding:4px 8px;">Nopol</td>
  197. <td width="122" align="center" style="border:1px solid #999;padding:4px 8px;">Jenis Kendaraan</td>
  198. <td width="135" align="center" style="border:1px solid #999;padding:4px 8px;">Keterangan</td>
  199. <td width="89" align="center" style="border:1px solid #999;padding:4px 8px;">Cabang</td>
  200. <td width="94" align="center" style="border:1px solid #999;padding:4px 8px;">Jenis Subsidi</td>
  201. <td width="65" align="center" style="border:1px solid #999;padding:4px 8px;">Liter</td>
  202. <td width="85" align="center" style="border:1px solid #999;padding:4px 8px;">Harga</td>
  203. <td width="97" align="center" style="border:1px solid #999;padding:4px 8px;">Total</td>
  204. </tr>
  205. <?php include "../../config/koneksi.php";
  206. if(isset($_GET['Cetak'])){
  207. $aa=$_GET['tgl_a'];
  208. $ab=$_GET['tgl_b'];
  209. $cb=$_GET['cabang'];
  210. //$no = 1;
  211. $query = mysqli_query($db, "Select a.cabang,a.no_voucher,a.tgl_voucher,a.jam,a.km_akhir,a.liter,a.total,b.nip,b.nama, c.nopol,c.jenis,c.ket,d.id_bbm,d.jenis_bbm,d.harga,a.cabang,sum(a.total)as jumlah from voucher a, karyawan b,trasportasi c,bbm d where a.nip=b.nip and a.nopol=c.nopol and a.id_bbm=d.id_bbm and. a.cabang ='$cb' and a.tgl_voucher>='$aa' and a.tgl_voucher<='$ab' group by a.no_voucher order by c.nopol asc ") or die('Query Error : '.mysqli_error($db));
  212. while ($lol = mysqli_fetch_assoc($query)) {
  213. echo "
  214. <tr>
  215.  
  216.  
  217. <td width='40' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[no_voucher]</td>
  218. <td width='40' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[tgl_voucher]</td>
  219. <td width='100' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[nama]</td>
  220. <td width='50' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[nopol]</td>
  221. <td width='40' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[jenis]</td>
  222. <td width='100' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[ket]</td>
  223. <td width='85' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[cabang]</td>
  224. <td width='40' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[jenis_bbm]</td>
  225. <td width='40' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[liter]</td>
  226. <td width='85' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[harga]</td>
  227. <td width='97' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[total]</td>
  228. </tr>
  229. <tr>
  230. <td colspan='10'><td width='85' align='left' style='border:1px solid #999;padding:4px 8px;'>$lol[jumlah]</td>
  231. </tr>
  232. "; } }?>
  233. <!-- -->
  234.  
  235. </table>
  236. <?php
  237. $html = ob_get_contents();
  238. ob_end_clean();
  239. $mpdf->WriteHTML(utf8_encode($html));
  240. $mpdf->Output($nama_dokumen.".pdf" ,'I');
  241. exit;
  242. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!