74 lines
2.5 KiB
PHP
74 lines
2.5 KiB
PHP
<?php //include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
|
|
|
|
|
|
//include('pop_up_top.php');
|
|
header('Content-Type: application/force-download');
|
|
header('Content-disposition: attachment; filename=dropped_beneficiary_excel.xls');
|
|
?>
|
|
|
|
|
|
<table border="1">
|
|
<?php
|
|
$ohc_type_id = "ohc_type_id = " . $_SESSION['current_ohcttype'];
|
|
|
|
$sql = "SELECT * FROM dropout_beneficiary WHERE $ohc_type_id ";
|
|
//echo $sql;
|
|
$result = mysqli_query($conn, $sql);
|
|
?><tr>
|
|
|
|
<td width="3%">Sr.</td>
|
|
<td width="7%">Beneficiary Name</td>
|
|
<td width="7%">Address</td>
|
|
<td width="10%">Old Enrolled Batch Name</td>
|
|
<td width="10%">New Enrolled Batch Name</td>
|
|
<td width="10%">Dropout Date</td>
|
|
<td width="10%">Status</td>
|
|
<td width="10%">Remark</td>
|
|
|
|
</tr>
|
|
|
|
<?php
|
|
while($row=mysqli_fetch_array($result)){
|
|
$beneficiary_name = getFieldFromTable('beneficiary_name','beneficiary_enquiry','patient_id',$row['enquiry_id']);
|
|
$village = getFieldFromTable('village', 'patient_master', 'id', $row['enquiry_id']);
|
|
$state = getFieldFromTable('state', 'patient_master', 'id', $row['enquiry_id']);
|
|
$tehsil = getFieldFromTable('tehsil', 'patient_master', 'id', $row['enquiry_id']);
|
|
$district = getFieldFromTable('district', 'patient_master', 'id', $row['enquiry_id']);
|
|
|
|
$state = getFieldFromTable('name', 'states', 'id', $state);
|
|
$tehsil = getFieldFromTable('name', 'tehsils', 'id', $tehsil);
|
|
$district = getFieldFromTable('name', 'districts', 'id', $district);
|
|
$address = $village.','.$state.','.$tehsil.','.$district;
|
|
|
|
$batch_name = getFieldFromTable('batch_name','training_batch_master','batch_id',getFieldFromTable('batch_id','beneficiary_enquiry','id',$row['enquiry_id']));
|
|
$old_batch = getFieldFromTable('batch_name','training_batch_master','batch_id',$row['old_batch']);
|
|
if ($row['dpd'] && $row['dpd'] !== '0000-00-00') {
|
|
$date = date_format(date_create($row['dpd']), "d-m-Y");
|
|
} else {
|
|
$date = 'dd-mm-yyyy';
|
|
}
|
|
|
|
|
|
?>
|
|
<tr>
|
|
<td><?php echo $count?></td>
|
|
<td><?php echo $beneficiary_name ?></td>
|
|
<td><?php echo $address ?></td>
|
|
<td><?php echo $old_batch?></td>
|
|
<td><?php echo $batch_name ?></td>
|
|
<td><?php echo $date ?></td>
|
|
<td><?php echo $row['dropout_status']?></td>
|
|
<td><?php echo $row['remark']?></td>
|
|
|
|
</tr>
|
|
<?php
|
|
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
//include('pdf_footer.php');
|
|
?>
|