Advertisement
Guest User

Untitled

a guest
Mar 20th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. <?php
  2. require_once ('../config.php');
  3. require_once __DIR__ . '/vendor/autoload.php';
  4. $mpdf = new \Mpdf\Mpdf();
  5. $html = '<style type="text/css">
  6. .tabel { border-collapse:collapse; }
  7. .tabel th { padding: 8px 5px; background-color: #f60; color:#fff; }
  8. </style>';
  9.  
  10. $html .= ' <page>
  11.  
  12. <div style="padding:4mm; border:1px solid;" align ="center">
  13. <span style="font-size:25px;">Aplikasi Laba Rugi</span>
  14. </div>
  15.  
  16. <div style="padding:20px 0 10px 0; font-size:15px;">
  17. Laporan Data Barang
  18. </div>
  19.  
  20. <table border="1" cellpadding="10" cellspacing="0">
  21. <tr>
  22. <th>Kode Barang</th>
  23. <th>Tanggal</th>
  24. <th>Nama Barang</th>
  25. <th>Harga Terjual /pc</th>
  26. <th>Total Harga</th>
  27. <th>Jumlah</th>
  28. <th>Laba</th>
  29. </tr>';
  30. $no = 1;
  31. $tanggal_a = $_POST['tanggal_a'];
  32. $tanggal_b = $_POST['tanggal_b'];
  33. $laba = $conn -> query("SELECT * FROM barang_laku WHERE tanggal BETWEEN '$tanggal_a' AND '$tanggal_b'");
  34.  
  35. while ($data = $laba -> fetch_assoc()) {
  36. # code...
  37.  
  38.  
  39. $html
  40. .= '
  41.  
  42. <tr>
  43. <td>'. $no++ .'</td>
  44. <td>'.date('d F Y', strtotime($data['tanggal'])).'</td>
  45. <td>'. $data["nama"].'</td>
  46. <td>Rp.'. number_format($data["harga"]).',-</td>
  47. <td>Rp.'. number_format($data["total_harga"]).',-</td>
  48. <td>'. $data["jumlah"].'</td>
  49. <td>Rp.'.number_format($data["laba"]).',-</td>
  50.  
  51. </tr>';
  52. }
  53.  
  54.  
  55.  
  56. $html .= '
  57. </table>
  58. </page>
  59. ';
  60. $mpdf->WriteHTML($html);
  61. $mpdf->Output();
  62.  
  63. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement