103 lines
4.0 KiB
PHP
103 lines
4.0 KiB
PHP
|
<?php
|
||
|
|
// include('pdf_header.php');
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
header('Content-Type: application/force-download');
|
||
|
|
header('Content-disposition: attachment; filename=excel_ambulance_list.xls');
|
||
|
|
error_reporting(E_ERROR | E_PARSE);
|
||
|
|
?>
|
||
|
|
|
||
|
|
<body>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<div style="font-size:12px">
|
||
|
|
<td width="25%" align="left"> Run Date :
|
||
|
|
<?php echo date("d-M-Y"); ?>
|
||
|
|
</td>
|
||
|
|
<td width="50%" align="center" style="font-size:15px"><strong>AMBULANCE MOVEMENT LIST</strong></td>
|
||
|
|
<td width="25%" align="left"> User :
|
||
|
|
<?php echo $username ?>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<br>
|
||
|
|
<table border="1" width="100%" style="text-align: center;">
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$sql = base64_decode($filterkey);
|
||
|
|
//echo "hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh".$sql;
|
||
|
|
$result = mysqli_query($conn, $sql);
|
||
|
|
?>
|
||
|
|
<tr bgcolor='#eeeeee'>
|
||
|
|
<td width="5%">sr</td>
|
||
|
|
<td>Date</td>
|
||
|
|
<td>Ambulance Number</td>
|
||
|
|
<td>Driver Name</td>
|
||
|
|
<td>Dr And Paramedic Name</td>
|
||
|
|
<td>Patient</td>
|
||
|
|
<td>Client</td>
|
||
|
|
<td>Client location</td>
|
||
|
|
<td>FROM</td>
|
||
|
|
<td>TO</td>
|
||
|
|
<td>OUT KM</td>
|
||
|
|
<td>IN KM</td>
|
||
|
|
<td>Total KM</td>
|
||
|
|
<td>OUT TIME</td>
|
||
|
|
<td>IN TIME</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$count = 1;
|
||
|
|
while ($row1 = mysqli_fetch_assoc($result)) {
|
||
|
|
$client_id = getFieldFromTable('client_id', 'patient_master', 'id', $row1['patient_id']);
|
||
|
|
$location_id = getFieldFromTable('client_location_id', 'patient_master', 'id', $row1['patient_id']);
|
||
|
|
extract($row1);
|
||
|
|
?>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td><?php echo $count ?></td>
|
||
|
|
<td><?php echo date_format(date_create($row1['usage_date']), "d-m-Y ") ?></td>
|
||
|
|
|
||
|
|
<td><?php echo getTableFieldValue('ambulance_details_new', 'ambulance_number', 'id', $row1['ambulance_id']) ?>
|
||
|
|
</td>
|
||
|
|
<td><?php echo getTableFieldValue('staff_master', 'staff_name', 'staff_id', $row1['driver_id']) ?></td>
|
||
|
|
<td><?php
|
||
|
|
|
||
|
|
$paramedic_ids = $row1['paramedic_id'];
|
||
|
|
$paramedic_ids_array = array();
|
||
|
|
$paramedic_ids_array = explode(",", $paramedic_ids);
|
||
|
|
$paramedics = "";
|
||
|
|
for ($i = 0; $i < count($paramedic_ids_array); $i++) {
|
||
|
|
if ($i == 0) {
|
||
|
|
if (is_numeric($paramedic_ids_array[$i])) {
|
||
|
|
$paramedics = getTableFieldValue('staff_master', 'staff_name', 'staff_id', $paramedic_ids_array[$i]);
|
||
|
|
} else {
|
||
|
|
$paramedics = $paramedic_ids_array[$i];
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
if (is_numeric($paramedic_ids_array[$i])) {
|
||
|
|
$paramedics = $paramedics . "," . getTableFieldValue('staff_master', 'staff_name', 'staff_id', $paramedic_ids_array[$i]);
|
||
|
|
} else {
|
||
|
|
$paramedics = $paramedics . "," . $paramedic_ids_array[$i];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
echo $paramedics; ?></td>
|
||
|
|
<td><?= getTableFieldValue('patient_master', 'patient_name', 'id', $row1['patient_id']) ?></td>
|
||
|
|
<td><?= getFieldFromTable('client_name', 'client_master', 'id', $client_id) ?></td>
|
||
|
|
<td><?= getFieldFromTable('client_location', 'client_location', 'client_location_id', $location_id) ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_from'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_to'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_out_km'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_in_km'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_total_km'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_out_time'] ?></td>
|
||
|
|
<td><?php echo $row1['ambulance_in_time'] ?></td>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
$count++;
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
</body>
|