330 lines
9.2 KiB
PHP
330 lines
9.2 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
$start_date=$_POST['startDate2'];
|
|
$end_date = $_POST['endDate2'];
|
|
?>
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
<style>
|
|
|
|
@page{
|
|
margin: 15px;
|
|
}
|
|
|
|
.btn {
|
|
background-color: #4CAF50;
|
|
border-radius : 5%; /* Green */
|
|
border: none;
|
|
color: white;
|
|
padding: 5px 8px;
|
|
text-align: center;
|
|
text-decoration: none;
|
|
display: inline-block;
|
|
font-size: 12px;
|
|
margin: 4px 2px;
|
|
cursor: pointer;
|
|
}
|
|
@media print {
|
|
#printPageButton {
|
|
display: none;
|
|
}
|
|
}
|
|
|
|
</style>
|
|
<?php include('pdf_ohc_header.php')?>
|
|
|
|
|
|
<div align="right">
|
|
<strong>TML/REC/OHC/53</strong>
|
|
</div>
|
|
|
|
<table width="100%">
|
|
<tr>
|
|
|
|
<td align="center" style="font-size: 15px"><strong>POHC Record</strong></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<!-- <td align="left" style="font-size: 12px"><strong>For Month: <?php echo $month_name; ?></strong></td> -->
|
|
<td align="right" style="font-size: 15px"><button align ="center" id="printPageButton" class="btn btn-success" onClick="window.print();">Print</button></td>
|
|
</tr>
|
|
|
|
</table>
|
|
<table border="1" width="100%" cellspacing="0">
|
|
<?php
|
|
|
|
|
|
$sqll="SELECT count(*) as total FROM `medical_examination` a JOIN patient_master b on a.patient_id=b.id WHERE a.medical_entry_date between STR_TO_DATE('".$start_date."', '%d-%m-%Y') AND STR_TO_DATE('".$end_date."', '%d-%m-%Y') and a.task='pohc' and a.forward_status = 'A' ORDER BY a.medical_entry_date ASC";
|
|
|
|
$result_sqll=mysqli_query($conn,$sqll);
|
|
$num_rows=mysqli_num_rows($result_sqll);
|
|
$row0= mysqli_fetch_assoc($result_sqll);
|
|
// error_log("total".$row0['total']);
|
|
|
|
$sql="SELECT DATE_FORMAT(a.medical_entry_date, '%d-%m-%y') as date,a.*,b.patient_name,b.designation_id,b.employer_contractor_id,b.blood_group as blood,b.dob,b.gender,b.emp_code,b.bu_id FROM `medical_examination` a JOIN patient_master b on a.patient_id=b.id where a.medical_entry_date between STR_TO_DATE('".$start_date."', '%d-%m-%Y') AND STR_TO_DATE('".$end_date."', '%d-%m-%Y') and a.task='pohc' and a.forward_status = 'A' ORDER BY a.medical_entry_date ASC";
|
|
error_log($sql);
|
|
|
|
$result = mysqli_query($conn,$sql);
|
|
|
|
?>
|
|
|
|
<strong>
|
|
|
|
|
|
<tr bgcolor="#eeeeee">
|
|
<td >Sr.</td>
|
|
<td align="left" width="5%" >POHC NO</td>
|
|
<td align="left" width="5%" >Date Of Exam</td>
|
|
<td align="left" width="5%" > Name </td>
|
|
<td align="left" width="5%" > Employee Code </td>
|
|
<td align="left" width="5%" > Business Unit </td>
|
|
<td align="left" width="5%" > Age </td>
|
|
<td align="left" width="5%" > Sex </td>
|
|
<td align="left" width="5%" > Height (in cms)</td>
|
|
<td align="left" width="5%" > Weight (in kgs)</td>
|
|
<td width="5%" align="left" >BMI</td>
|
|
|
|
|
|
<td valign="top" align="left" width="3%" >BP SYS</td>
|
|
<td valign="top" align="left" width="3%" >BP DIA</td>
|
|
<td valign="top" align="left" width="3%" >Blood group</td>
|
|
<td valign="top" align="left" width="3%" >HB%</td>
|
|
<td valign="top" align="left" width="3%" >TLC</td>
|
|
<td valign="top" align="left" width="3%" >L (gm%)</td>
|
|
<td valign="top" align="left" width="3%" >N (gm%)</td>
|
|
<td valign="top" align="left" width="3%" >M (gm%)</td>
|
|
<td valign="top" align="left" width="3%" >E (gm%)</td>
|
|
<td valign="top" align="left" width="3%" >ESR</td>
|
|
<td valign="top" align="left" width="3%" >URIC ACID</td>
|
|
<td valign="top" align="left" width="3%" >Serum Creatinine</td>
|
|
<td valign="top" align="left" width="3%" >FBS/RBS/PPBS (MG/DL)</td>
|
|
<td valign="top" align="left" width="3%" >Total Bilirubin</td>
|
|
<td valign="top" align="left" width="3%" >Conj</td>
|
|
<td valign="top" align="left" width="3%" >Unconj</td>
|
|
<td valign="top" align="left" width="3%" >SGOT</td>
|
|
<td valign="top" align="left" width="3%" >SGPT</td>
|
|
<td valign="top" align="left" width="3%" >Alkaline Phosphatase</td>
|
|
<td valign="top" align="left" width="3%" >Total Protein</td>
|
|
<td valign="top" align="left" width="3%" >Albumin</td>
|
|
<td valign="top" align="left" width="3%" >Globulin</td>
|
|
<td valign="top" align="left" width="3%" >Total Cholestrol</td>
|
|
<td valign="top" align="left" width="3%" >(LDL) Cholestrol</td>
|
|
<td valign="top" align="left" width="3%" >(VLDL) Cholestrol</td>
|
|
<td valign="top" align="left" width="3%" >(HDL) Cholestrol</td>
|
|
<td valign="top" align="left" width="3%" >Triglycerides</td>
|
|
<td valign="top" align="left" width="3%" >Audio</td>
|
|
<td valign="top" align="left" width="3%" >Spiro</td>
|
|
<td valign="top" align="left" width="3%" >ECG</td>
|
|
<td valign="top" align="left" width="3%" >XRAY</td>
|
|
<td width="3%" align="left" >BMI Score</td>
|
|
<td width="3%" align="left" >BP Score</td>
|
|
<td width="3%" align="left" >RBS Score</td>
|
|
<td width="3%" align="left" >CHOLESTROL Score</td>
|
|
<td valign="top" align="left" width="3%" >Total Score</td>
|
|
|
|
|
|
</tr>
|
|
|
|
|
|
|
|
<?php
|
|
$count=1;
|
|
while ($row1= mysqli_fetch_assoc($result)){
|
|
extract($row1);
|
|
$num_rows = mysqli_num_rows($result);
|
|
error_log($row1['employer_contractor_id']);
|
|
|
|
$bp = explode("/", $row1['bp']);
|
|
|
|
$bp_sum = 0;
|
|
$bmi_sum = 0;
|
|
$rbs_sum = 0;
|
|
$cholestrol_sum = 0;
|
|
$health_index_sum = 0;
|
|
|
|
$bmi_score = 0;
|
|
$bp_score = 0;
|
|
|
|
$tc_score = 0;
|
|
|
|
$rbs_score = 0;
|
|
|
|
if($row1['bmi'] > 30){
|
|
$bmi_score = 0;
|
|
}
|
|
|
|
elseif ($row1['bmi'] > 25 && $row1['bmi'] < 30) {
|
|
$bmi_score = 2;
|
|
}
|
|
|
|
else{
|
|
$bmi_score = 4;
|
|
}
|
|
|
|
if($bp[0]>140 && $bp[1]>90){
|
|
$bp_score = 0;
|
|
}
|
|
|
|
elseif ($bp[0]>120 && $bp[0]<140 && $bp[1]>80 && $bp[1]<90) {
|
|
$bp_score = 2;
|
|
}
|
|
|
|
else{
|
|
$bp_score = 4;
|
|
}
|
|
|
|
|
|
if($row1['blood_sugar_rbs'] > 200){
|
|
$rbs_score = 0;
|
|
}
|
|
|
|
elseif ($row1['blood_sugar_rbs'] > 139 && $row1['blood_sugar_rbs'] < 200) {
|
|
$rbs_score = 2;
|
|
}
|
|
|
|
else{
|
|
$rbs_score = 4;
|
|
}
|
|
|
|
if($row1['bmi'] > 30){
|
|
$bmi_score = 0;
|
|
}
|
|
|
|
elseif ($row1['bmi'] > 25 && $row1['bmi'] < 30) {
|
|
$bmi_score = 2;
|
|
}
|
|
|
|
else{
|
|
$bmi_score = 4;
|
|
}
|
|
|
|
if($row1['total_cholestrol'] > 240){
|
|
$tc_score=0;
|
|
}
|
|
else if($row1['total_cholestrol'] > 200 && $row1['total_cholestrol'] < 240){
|
|
$tc_score=2;
|
|
}
|
|
else{
|
|
$tc_score=4;
|
|
}
|
|
|
|
$total_score = $bmi_score + $bp_score + $rbs_score + $tc_score;
|
|
|
|
|
|
$bp_sum = $bp_sum+$bp_score;
|
|
$bmi_sum = $bmi_sum+$bmi_score;
|
|
$rbs_sum = $rbs_sum+$rbs_score;
|
|
$cholestrol_sum = $cholestrol_sum+$tc_score;
|
|
$health_index_sum = $health_index_sum+$health_index;
|
|
|
|
|
|
$bp_avg = $bp_sum/$num_rows;
|
|
$bmi_avg = $bmi_sum/$num_rows;
|
|
$rbs_avg = $rbs_sum/$num_rows;
|
|
$cholestrol_avg = $cholestrol_sum/$num_rows;
|
|
$health_index_avg = $health_index_sum/$row0['total'];
|
|
|
|
|
|
|
|
?>
|
|
|
|
<tr>
|
|
|
|
|
|
<td><?php echo $count?></td>
|
|
|
|
<td><?php echo $row1['pohc_no']?></td>
|
|
<td><?php echo $row1['date']?></td>
|
|
|
|
<td><?php echo $row1['patient_name']?></td>
|
|
<td><?php echo $row1['emp_code']?></td>
|
|
<td><?php echo getTableFieldValue('bussiness_unit','bu_name','bu_id',$row1['bu_id'])?></td>
|
|
<td><?php echo ageCalculator($row1['dob'])?></td>
|
|
|
|
<td><?php echo $row1['gender']?></td>
|
|
<td><?php echo $row1['height']?></td>
|
|
<td><?php echo $row1['weight']?></td>
|
|
<td><?php echo $row1['bmi']?></td>
|
|
<td><?php echo $bp[0]?></td>
|
|
<td><?php echo $bp[1]?></td>
|
|
<td><?php echo $row1['blood']?></td>
|
|
<td><?php echo $row1['hb']?></td>
|
|
<td><?php echo $row1['tlc']?></td>
|
|
<td><?php echo $row1['dlc_l']?></td>
|
|
<td><?php echo $row1['dlc_n']?></td>
|
|
<td><?php echo $row1['dlc_m']?></td>
|
|
<td><?php echo $row1['dlc_e']?></td>
|
|
<!-- <td><?php echo $row1['platelets']?></td> -->
|
|
<td><?php echo $row1['esr']?></td>
|
|
<td><?php echo $row1['uric_acid']?></td>
|
|
<td><?php echo $row1['s_creatinine']?></td>
|
|
<td><?php echo $row1['blood_sugar_fbs']?>/<?php echo $row1['blood_sugar_rbs']?>/<?php echo $row1['blood_sugar_ppbs']?></td>
|
|
<td><?php echo $row1['total_bilirubin']?></td>
|
|
<td><?php echo $row1['conj']?></td>
|
|
<td><?php echo $row1['uniconj']?></td>
|
|
<td><?php echo $row1['sgop']?></td>
|
|
<td><?php echo $row1['sgpt']?></td>
|
|
<td><?php echo $row1['alk_phosphatase']?></td>
|
|
<td><?php echo $row1['total_protein']?></td>
|
|
<td><?php echo $row1['albumin']?></td>
|
|
<td><?php echo $row1['globulin']?></td>
|
|
<td><?php echo $row1['total_cholestrol']?></td>
|
|
<td><?php echo $row1['ldl']?></td>
|
|
<td><?php echo $row1['vldl']?></td>
|
|
<td><?php echo $row1['hdl']?></td>
|
|
<td><?php echo $row1['tryglycerides']?></td>
|
|
<td><?php echo $row1['audio_findings']?></td>
|
|
<td><?php echo $row1['spirometry_remarks']?></td>
|
|
<td><?php echo $row1['ecg_findings']?></td>
|
|
<td><?php echo $row1['xray_findings']?></td>
|
|
<td><?php echo $bmi_score?></td>
|
|
<td><?php echo $bp_score?></td>
|
|
<td><?php echo $rbs_score?></td>
|
|
<td><?php echo $tc_score?></td>
|
|
<td><?php echo $total_score;?></td>
|
|
|
|
|
|
|
|
|
|
</tr>
|
|
<?php
|
|
$count++;
|
|
}
|
|
?>
|
|
<tr Height="10px">
|
|
<td colspan="41"><b>TOTAL: <?php echo $row0['total']?></b></td>
|
|
<td><b>AVERAGE</b></td>
|
|
<td ><b><?php echo $bp_avg;?></b></td>
|
|
<td ><b><?php echo $bmi_avg;?></b></td>
|
|
<td ><b><?php echo $rbs_avg;?></b></td>
|
|
<td ><b><?php echo $cholestrol_avg;?></b></td>
|
|
<td ><b><?php echo $health_index_avg;?></b></td>
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
|
|
</table>
|
|
</body>
|
|
|
|
<script>
|
|
$(document).ready(function(){
|
|
window.print();
|
|
|
|
});
|
|
</script>
|
|
|
|
|