71 lines
3.2 KiB
PHP
71 lines
3.2 KiB
PHP
<table border="1" height="100" width="100%">
|
|
<tr><th colspan="2" style="background-color: blue;color: white"><center>TRAINING/PROGRAM</center></th></tr>
|
|
<tr>
|
|
<?php $sql = "select count(*) as count_training from training_master";
|
|
//echo $sql;
|
|
$result = mysqli_query($conn, $sql);
|
|
//echo $result;
|
|
$row = mysqli_fetch_array($result);?>
|
|
<td width="50%"><center><strong>TRIAGE</strong></center></td>
|
|
<td width="50%"><center><strong><?php echo $row['count_training']?></strong></center></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<br>
|
|
|
|
<table border="1" height="350" width="100%">
|
|
<tr><th colspan="3" style="background-color: blue;color: white"><center>TT Vaccination</center></th></tr>
|
|
<tr>
|
|
<td></td>
|
|
<td width="30%"><center><strong><?php echo date('d-M-Y', strtotime(' -1 day'))?></strong></center></td>
|
|
<td><center><strong>Total Cases</strong></center></td>
|
|
</tr>
|
|
<tr>
|
|
<?php $sql_vac_wc = "select count(id) as count_vac_wc from vaccination_details a left join patient_master b on b.id = a.emp_id left join designation d on d.designation_id = b.designation_id where d.designation_code in ('GAT','MGR','SRM','SRGM','DYM','DVM','DGM','AGM','GM','AM','AVP','SRE','GET','MT','DAT') and DATE(a.last_modified) = date(NOW()-INTERVAL 1 DAY)";
|
|
|
|
$result_vac_wc = mysqli_query($conn,$sql_vac_wc);
|
|
|
|
$row_vac_wc = mysqli_fetch_array($result_vac_wc);
|
|
|
|
$sql_vac_wc_total = "select count(id) as count_vac_wc from vaccination_details a left join patient_master b on b.id = a.emp_id left join designation d on d.designation_id = b.designation_id where d.designation_code in ('GAT','MGR','SRM','SRGM','DYM','DVM','DGM','AGM','GM','AM','AVP','SRE','GET','MT','DAT')";
|
|
|
|
$result_vac_wc_total = mysqli_query($conn,$sql_vac_wc_total);
|
|
|
|
$row_vac_wc_total = mysqli_fetch_array($result_vac_wc_total);?>
|
|
<td><center><strong>WC</strong></center></td>
|
|
<td><?php echo $row_vac_wc['count_vac_wc'];?></td>
|
|
<td><?php echo $row_vac_wc_total['count_vac_wc']?></td>
|
|
</tr>
|
|
<tr>
|
|
<?php $sql_vac_bc = "select count(id) as count_vac_bc from vaccination_details a left join patient_master b on b.id = a.emp_id left join designation d on d.designation_id = b.designation_id where d.designation_code in ('APP','TEMP','TT1','TT2') and DATE(a.last_modified) = date(NOW()-INTERVAL 1 DAY)";
|
|
|
|
$result_vac_bc = mysqli_query($conn,$sql_vac_bc);
|
|
|
|
$row_vac_bc = mysqli_fetch_array($result_vac_bc);
|
|
|
|
$sql_vac_bc_total = "select count(id) as count_vac_Bc from vaccination_details a left join patient_master b on b.id = a.emp_id left join designation d on d.designation_id = b.designation_id where d.designation_code in ('APP','TEMP','TT1','TT2')";
|
|
|
|
$result_vac_bc_total = mysqli_query($conn,$sql_vac_bc_total);
|
|
|
|
$row_vac_bc_total = mysqli_fetch_array($result_vac_bc_total);?>
|
|
<td><center><strong>BC</strong></center></td>
|
|
<td><?php echo $row_vac_bc['count_vac_bc'];?></td>
|
|
<td><?php echo $row_vac_bc_total['count_vac_bc']?></td>
|
|
</tr>
|
|
<tr>
|
|
<td><center><strong>External Agency</strong></center></td>
|
|
<td></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr>
|
|
<td><center><strong>Pre-employment</strong></center></td>
|
|
<td></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr>
|
|
<td><center><strong>TOTAL</strong></center></td>
|
|
<td></td>
|
|
<td></td>
|
|
</tr>
|
|
|
|
</table>
|