55 lines
1.9 KiB
PHP
55 lines
1.9 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
|
|
// Set headers for the Excel file
|
|
header('Content-Type: application/vnd.ms-excel');
|
|
header('Content-Disposition: attachment; filename="Veterinary Treatment list.xls"');
|
|
header('Pragma: no-cache');
|
|
header('Expires: 0');
|
|
|
|
?>
|
|
<h2 style="text-align: center;">Veterinary Treatment list</h2>
|
|
<table border="1" cellspacing="0" cellpadding="5">
|
|
<?php
|
|
|
|
$sql = "SELECT * FROM stock_issue";
|
|
$result = mysqli_query($conn, $sql);
|
|
?>
|
|
<tr bgcolor='#eeeeee'>
|
|
<th>Sr</th>
|
|
<th>Issue Ref No</th>
|
|
<th>Issue Date</th>
|
|
<th>Beneficiary</th>
|
|
<th>Agency</th>
|
|
<th>Program</th>
|
|
<th>Activity</th>
|
|
<!-- <th>Issued By</th> -->
|
|
<th>Remarks</th>
|
|
|
|
</tr>
|
|
<?php
|
|
$i = 1;
|
|
while ($rowOfprograme = mysqli_fetch_array($result)) {
|
|
?>
|
|
<tr>
|
|
<td style="text-align: center;"><?php echo $i; ?></td>
|
|
<td style="text-align: center;"><?php echo $rowOfprograme['issue_ref_no']; ?></td>
|
|
<td style="text-align: center;"><?php echo $rowOfprograme['issue_date']; ?></td>
|
|
<td style="text-align: center;"><?php echo getFieldFromTable('patient_name','patient_master','id', $rowOfprograme['beneficiary']) ?></td>
|
|
<td style="text-align: center;"><?php echo getFieldFromTable('agency_name', 'agency', 'id ', $rowOfprograme['distribution_vendor']); ?></td>
|
|
<td style="text-align: center;"><?php echo getFieldFromTable('program_name', 'program_master', 'program_id ', $rowOfprograme['program_name']); ?></td>
|
|
<td style="text-align: center;"><?php echo getFieldFromTable('program_name', 'program_master', 'program_id ', $rowOfprograme['activity_name']); ?></td>
|
|
<!-- <td style="text-align: center;"></?php echo getFieldFromTable('staff_name', 'staff_master', 'staff_id ', $rowOfprograme['issued_By']);?></td> -->
|
|
<td style="text-align: center;"><?php echo $rowOfprograme['remarks']; ?></td>
|
|
|
|
</tr>
|
|
<?php
|
|
$i++;
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|