<?php include('./mpdf57/mpdf.php'); ob_start(); ?> <style> td { padding: 3px 5px 3px 5px; border-right: 1px solid #666666; border-bottom: 1px solid #666666; } .head td { font-weight: bold; font-size: 12px; background: #b7f0ff; } table .main tbody tr td { font-size: 12px; } table, table .main { width: 100%; border-top: 1px solid #666; border-left: 1px solid #666; border-collapse: collapse; background: #fff; } h1 { font-size:20px; } </style> <table class='main' repeat_header="1" cellspacing="0" width="100%" style="width:100%"> <thead> <tr class="head"> <td align='center' height="30">No.</td> <td>Kode Barang</td> <td align='center'>Nama Barang</td> <td align='right'>Saldo Stok</td> </tr> </thead> <tbody> <tr><td align='center'>1</td><td>PSG-001</td><td>Pasta Gigi</td><td align='right'>150</td></tr> <tr><td align='center'>2</td><td>SBM-002</td><td>Sabun Mandi</td><td align='right'>63</td></tr> <tr><td align='center'>3</td><td>PML-008</td><td>Pembersih Lantai</td><td align='right'>260</td></tr> </tbody> </table> <?php $content = ob_get_clean(); $header = '<table cellpadding=0 cellspacing=0 style="border:none;"> <tr><td style="border:none;" align="left"><img src="img/logo-disini.jpg" width="42"></td> <td width="100%" style="border:none;"><h1>Laporan Stok Barang</h1></td></tr></table>'; $footer = '<table cellpadding=0 cellspacing=0 style="border:none;"> <tr><td style="margin-right:-5px;border:none;" align="left"> Dicetak: '.date("Y-m-d H:i").'</td> <td style="margin-right:-5px;border:none;" align="right"> Halaman: {PAGENO} / {nb}</td></tr></table>'; try { $mpdf=new mPDF('utf-8', "A4", 9 ,'Arial', 5, 5, 20, 5, 5, 4); $mpdf->SetTitle("Laporan Stok Barang"); $mpdf->setHTMLHeader($header); $mpdf->setHTMLFooter($footer); $mpdf->WriteHTML($content); $mpdf->Output("laporan-stok.pdf","I"); } catch(Exception $e) { echo $e; exit; } ?>
<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...
Comments
Post a Comment