<?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; } ?>
file config.php <?php $db_uname = 'root'; $db_passwd = ''; $db_name = 'layar_biru'; //database yang dipilih $db_host = 'localhost'; $xbase_dir = 'D:\ACADEMIC\htdocs\layar_biru\files'; $die_on_mysql_error = false; // when investigating errors, set this to true $from_encoding=""; //Encoding of database, e.g. CP866 or empty, if convert is not required file prefil.dbf <?php include "config.php"; // please copy the config.sample.php and edit the correct fields include "classes/XBase/Table.php"; include "classes/XBase/Column.php"; include "classes/XBase/Record.php"; include "classes/DBFhandler.php"; use XBase\Table; // Initializing vars ini_set( 'memory_limit', '2048M' ); set_time_limit( 0 ); $time_start = time(); $files = scandir($xbase_dir) or die ("Error! Could not open directory '$xbase_dir'."); $conn = new mysqli($db_host,...
Comments
Post a Comment