on this post i share my code to make PDF file using TCPDF
download TCPDF from this here
https://github.com/tecnickcom/tcpdf
i make NEW folder name report and extract TCPDF into tcpdf folder
1- make button from Print PDF on hooks file (My table name is Employee)
Code: Select all
function Employee_dv($selectedID, $memberInfo, &$html, &$args) {
if(isset($_REQUEST['dvprint_x'])) return;
ob_start(); ?>
<script>
$j(function(){
<?php if($selectedID){ ?>
$j('#Employee_dv_action_buttons .btn-toolbar').append(
'<div class="btn-group-vertical btn-group-lg" style="width: 100%;">' +
'<button type="button" class="btn btn-warning btn-lg" onclick="Emp_Archive()">' +
'<i class="glyphicon glyphicon-collapse-up"></i> Archive </button>' +
'<button type="button" class="btn btn-info btn-lg" onclick="Report()">' +
'<i class="glyphicon glyphicon-ok"></i> Report </button>' +
'</div>'
);
<?php } ?>
});
function Emp_Archive(){
var selectedID = '<?php echo urlencode($selectedID); ?>';
window.location = 'report/Archive.php?EmpID=' + selectedID;
}
function Report(){
var selectedID = '<?php echo urlencode($selectedID); ?>';
window.location = 'report/Emp_pdf.php?EmpID=' + selectedID;
}
</script>
<?php
$form_code = ob_get_contents();
ob_end_clean();
$html .= $form_code;
}
and add this code
Code: Select all
<?php
$report_dir = dirname(__FILE__);
include("$report_dir /../lib.php");
$Emp_id = intval($_REQUEST['EmpID']);
require_once('tcpdf/tcpdf.php');
$pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false);
// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set font
$pdf->SetFont('aealarabiya', '', 13);
// add a page
$pdf->AddPage();
$res = sql("SELECT t1.Code, t1.EmployeeName, t1.Work_Status, t1.Start_Work ,t2.Status FROM employee t1 join Status t2 on t1.Status=t2.ID WHERE t1.ID = {$Emp_id}", $eo);
while($row = db_fetch_assoc($res)){
$cosas[] = $row;
}
$html = '';
foreach($cosas as $row){
$Code = $row['Code'];
$EmployeeName = $row['EmployeeName'];
$Status = $row['Status'];
$Work_Status = $row['Work_Status'];
$Start_Work = $row['Start_Work'];
$html .= '<><h2 align="center"><font color="#000066"><b>بسم الله الرØمن الرØيم</font></h2>';
$html .= '<><h2 align="center"><font color="#FF0000"><b>اختبار إنشاء مل٠بالعربية</font></h2>';
$html .= '<><h2 align="center"><font color="#000066"><b>'.$Code.'</b></font><font color="#FF0000"> - '.$EmployeeName.'</font></h2>';
$html .= '
<table nobr="true" border="1" cellpadding="5" align="center">
<tr>
<td><font color="#FF0000">Status</font></td>
<td>'.$Status.'</td>
<td><font color="#FF0000">Work Status</font></td>
<td>'.$Work_Status.'</td>
</tr>
<tr>
<td><font color="#FF0000">Start Work</font></td>
<td>'.$Start_Work.'</td>
<td><font color="#FF0000">Start Work</font></td>
<td>'.$Start_Work.'</td>
</tr>
</table>';
}
$pdf->SetFont('aealarabiya', '', 10);
$pdf->writeHTML($html, true, 0, true, 0);
$pdf->lastPage();
$pdffile= $pdf->output('Reporte.pdf', 'I');
?>