ESH/open_ime_long_term_pdf.php

1532 lines
25 KiB
PHP
Raw Permalink Normal View History

2024-10-23 18:28:06 +05:30
<?php include_once('tcpdf/tcpdf.php');
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$lg = Array();
$l['a_meta_charset'] = 'UTF-8';
$l['a_meta_dir'] = 'ltr';
$l['a_meta_language'] = 'hi';
$lg['w_page'] = 'page';
// set some language-dependent strings (optional)
$pdf->setLanguageArray($lg);
// ---------------------------------------------------------
// set font
$pdf->SetFont('freesans', '', 12);
// add a page
$pdf->AddPage();
// Hindi content
include('includes/config/config.php');
include_once("includes/functions.php");
error_reporting(0);
while (ob_get_level())
ob_end_clean();
header("Content-Encoding: None", true);
$sql_patient_physical_parameters="select a.*,b.*,c.*,a.height,a.weight,a.waist,a.bp,e.file_name, e.emp_sign as sign, e.qualification,e.registration_no,e.emp_id as sign_id, f.company_name, f.company_logo, f.image_type from company_profile f, medical_examination a inner join patient_master b on b.id=a.patient_id left join designation c on b.designation_id=c.designation_id left join tbl_users d on d.user_id=a.approved_by left join employee_signature e on d.emp_id=e.emp_id where a.medical_exam_id='".$_REQUEST['medical_exam_id']."' ";
//echo $sql_patient_physical_parameters;
$result_patient_physical_parameters= mysqli_query($conn,$sql_patient_physical_parameters);
$row_patient_physical_parameters= mysqli_fetch_assoc($result_patient_physical_parameters);
@extract($row_patient_physical_parameters);
$doc_emp_id = getFieldfromTable ( 'emp_id', 'tbl_users', 'user_id', $sign_medical_officer );
$doctor_name = getFieldfromTable ( 'patient_name', 'patient_master', 'id', $doc_emp_id );
$pdf->setCellPaddings( $left = '2px', $top = '2px', $right = '2px', $bottom = '2px');
$path = 'images/';
$filename = $company_name;
$filepath = $path.$filename;
// If a physical file is not available then create it
// If the DB data is fresher than the file then make a new file
$result = file_put_contents($filepath, $company_logo);
if($result === FALSE)
{
die(__FILE__.'<br>Error - Line #'.__LINE__.': Could not create '.$filepath);
}
$pdf->Image($filepath,12, 12, 40, 30, '', '', '', false, 150, '', false, false, 0, false, false, false );
$html = <<<EOD
<style>
.tbl1{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
}
.tbl1 td{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
padding: 1px;
}
</style>
<table class="tbl1">
<tr>
<td rowspan="4"> </td>
<td rowspan="4" align="center"><b>MAIHAR IU</b></td>
<td><b>Department</b></td>
<td><b>OCCUPATIONAL HEALTH CENTRE</b></td>
</tr>
<tr >
<td><b>Document No.</b></td>
<td><b>F-MED-09</b></td>
</tr>
<tr >
<td><b>Revision</b></td>
<td><b>0.0</b></td>
</tr>
<tr >
<td><b>Implementation Date</b></td>
<td><b>01.04.2016</b></td>
</tr>
<tr >
<td align="center" colspan="4"><b>Initial Medical Examination Card (LongTerm)</b></td>
</tr>
</table>
EOD;
$pdf->WriteHTML($html, true, 0, true, 0);
$medical_entry_date=strtoupper(date_format(date_create($row_patient_physical_parameters['medical_entry_date']),"d-M-Y "));
$dob=strtoupper(date_format(date_create($row_patient_physical_parameters['dob']),"d-M-Y "));
$address='VILL-'.$village.',POST-'.$post.',PS-'.$ps.',TEHSIL-'.$tehsil.',DIST-'.$district.',STATE-'.$state.'(PINCODE-'.$pin_code.')';
$from = new DateTime($dob);
$to = new DateTime('today');
$age= $from->diff($to)->y;
if($gender=='M')
$gender="Male";
elseif ($gender=='F')
$gender="Female";
$txt = <<<EOD
<style>
.tbl1{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
}
.tbl1 td{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
padding: 1px;
}
</style>
<table class="tbl1">
<tr>
<td width="20%" >SR.NO.</td>
<td width="80%" colspan="3" >{$serial_no}</td>
</tr>
<tr>
<td width="20%" >NAME</td>
<td width="60%" colspan="3" >{$patient_name}</td>
<td width="20%" colspan="2" rowspan="7"></td>
</tr>
<tr>
<td width="20%" >FATHER NAME</td>
<td width="60%" colspan="3" >{$father_name}</td>
</tr>
<tr>
<td>AGE/SEX</td>
<td colspan="3">{$age} {$gender}</td>
</tr>
<tr>
<td>ADDRESS</td>
<td colspan="3">{$address}</td>
</tr>
<tr>
<td>GRADE/POST</td>
<td colspan="3">{$designation_name}</td>
</tr>
<tr>
<td>MOBILE.NO.</td>
<td colspan="3">{$primary_phone}</td>
</tr>
<tr>
<td>GATE PASS NO./P NO</td>
<td >{$emp_code}</td>
<td>DATE</td>
<td>{$medical_entry_date}</td>
</tr>
<tr>
<td colspan="6" align="center" ><b>TO BE FILLED IN BY THE CANDIDATE</b></td>
</tr>
<tr>
<td colspan="6" ><b>9.HISTORY PAST AND PRESENT ILLNESS [ if YES write if NO write X ]
</b></td>
</tr>
EOD;
$past_present_illness_array = explode(',', $past_present_illness);
$result_section = mysqli_query($conn,"SET NAMES utf8");
$sql_section = "select * from history_parameter where param_id in (1,2,3,4,5,7,9,11) order by param_id asc";
$count=1;
$result_section = mysqli_query($conn,$sql_section);
while ($row_section = mysqli_fetch_assoc($result_section)) {
$check="";
if(in_array($row_section['param_id'],$past_present_illness_array))
$check="";
else
$check="X";
if($count%2!=0){
$txt.=<<<EOD
<tr >
EOD;
}
$txt.=<<<EOD
<td width="50%" colspan="3">
{$row_section['param_name']} ({$row_section['param_name_hindi']}) {$check}</td>
EOD;
if($count%2==0){
$txt.=<<<EOD
</tr>
EOD;
}
$count++;
}
$txt.=<<<EOD
<tr>
<td colspan="6">
<b>10. PAST OCCUPATIONAL HISTORY</b>
</td>
</tr>
<tr>
<td width="25%">NAME OF ORGANIZATION</td>
<td width="25%">TRADE/DESIGNATION </td>
<td width="25%">PERIOD OF SERVICE- IN YEARS </td>
<td width="25%">PAST OCCUPATIONAL ILLNESS</td>
</tr>
EOD;
$sql_past_occupational_history=" select * from past_occupational_history where medical_exam_id='".$_REQUEST['medical_exam_id']."' ";
$result_past_occupational_history = mysqli_query($conn,$sql_past_occupational_history);
if(mysqli_num_rows($result_past_occupational_history)>0){
while($row_past_occupational_history= mysqli_fetch_assoc($result_past_occupational_history)){
$txt.=<<<EOD
<tr>
<td width="25%">{$row_past_occupational_history['org_name']} </td>
<td width="25%">{$row_past_occupational_history['trade_designation']} </td>
<td width="25%">{$row_past_occupational_history['period_services']}</td>
<td width="25%">{$row_past_occupational_history['past_occu_illness']}</td>
</tr>
EOD;
}
}else{
$txt.=<<<EOD
<tr>
<td width="25%"></td>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%"></td>
</tr>
<tr>
<td width="25%"></td>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%"></td>
</tr>
EOD;
}
$txt.=<<<EOD
<tr>
<td colspan="4" ><b>11.PERSONAL INFORMATION</b></td>
</tr>
EOD;
$sql_patient_personal_info=" select * from patient_personal_information where medical_exam_id='".$_REQUEST['medical_exam_id']."' ";
$result_patient_personal_info = mysqli_query($conn,$sql_patient_personal_info);
$row_patient_personal_info= mysqli_fetch_assoc($result_patient_personal_info);
@extract($row_patient_personal_info);
$date_of_exam=strtoupper(date_format(date_create($row_patient_personal_info['date_of_exam']),"d-M-Y "));
$txt.=<<<EOD
<tr>
<td width="25%" >I. DATE OF BIRTH </td>
<td colspan="3" >{$dob}</td>
</tr>
<tr>
<td width="25%" >II. IDENTIFICATION MARK </td>
<td colspan="3" >{$identi_mark} </td>
</tr>
<tr>
<td width="25%" >III. DATE OF EXAMINATION </td>
<td colspan="3" >{$date_of_exam} </td>
</tr>
<tr>
<td width="25%" >IV. MARRIED/UNMARRIED </td>
<td colspan="3" >{$marital_status} </td>
</tr>
<tr>
<td width="25%" >V. NO. OF CHILDREN </td>
<td colspan="3" >{$no_of_child} </td>
</tr>
<tr>
<td width="25%" >VI. WHETHER ADOPTING ANY METHOD OF FAMILY PLANNING </td>
<td colspan="3" >{$adopting_family_planning} </td>
</tr>
<tr>
<td width="25%" >VII. SMOKING / TOBACCO / ALCOHOL</td>
<td colspan="3" >{$addiction} </td>
</tr>
</table>
EOD;
$pdf->writeHTML($txt, true, false, false, false, '');
// ---------------------------------------------------------
$pdf->AddPage();
$query_for_doctor="select UPPER(patient_name) as patient_name from patient_master where id=$sign_id ";
$result_for_doctor = @mysqli_query($conn,$query_for_doctor);
$row_for_doctor = @mysqli_fetch_array($result_for_doctor);
@extract($row_for_doctor);
$txt1.=<<<EOD
<style>
.tbl1{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
}
.tbl1 td{
font-size:8px;
border: 1px solid black;
border-collapse: collapse;
font-weight:1200;
padding: 1px;
}
</style>
<table class="tbl1">
<tr>
<td width="100%" colspan="6" >12.DECLARARTION:
<p>CERTIFIED THAT THE PARTICULARS GIVEN BY ME IN THE FOREGOING ABOVE ARE TRUE, COMPLETE AND CORRECT TO THE BEST OF MY
KNOWLEDGE AND BELIEF. IF ANY OF THIS INFORMATION IS FOUND TO BE FALSE/INCOMPLETE/ INCORRECT, ONLY I SHALL BE RESPONSIBLE FOR IT
AND COMPANY HAVE FULL RIGHT TO CANCEL MY APPOINTMENT OR TERMINATE MY SERVICE CONTRACT.
</p>
<p>मैं अपने पूरे होशोहवाश में यह प्रमाणित करता हूँ कि मेरे द्वारा दी गयी उपरोक्त समस्त जानकारी पूर्णत सही है, अगर मेरे
द्वारा दी गयी कोई जानकारी गलत पाई जाती है तो उसके लिए पूर्णत मैं जिम्मेदार हूं एवं कंपनी को यह अधिकार है कि
वो मुझे नौकरी में रखे अथवा मेरी सेवाओं को समाप्त कर दे
</p>
<p><b>SIGNATURE/LEFT THUMB IMPRESSION OF CANDIDATE</b><br/><br/><br/>
</p>
{$date_of_exam}<br>
<b>DATE</b>
</td>
</tr>
<tr>
<td colspan="6" align="center"><b>RECORD OF MEDICAL EXAMINATION</b></td>
</tr>
<tr>
<td> Height(cms)</td><td>{$height}</td>
<td> WAIST(cms)</td><td>{$waist}</td>
<td colspan="2"><b >CLINICAL EXAMINATION</b></td>
</tr>
<tr>
<td>WEIGHT(kgs)</td><td>{$weight}</td>
<td> HIP(cms)</td><td>{$hip}</td>
<td > NAILS</td><td>{$nails}</td>
</tr>
<tr>
<td> BMI(cms)</td><td>{$bmi}</td>
<td></td>
<td></td>
<td >PULSE</td><td>{$pulse}</td>
</tr>
<tr>
<td colspan="4" align="center"><b style="margin-left: 188px ">VISION</b></td>
<td >BP</td><td>{$bp}&nbsp;&nbsp;MM OF HG</td>
</tr>
<tr>
<td ></td>
<td ></td>
<td >RT.EYE </td><td>LT.EYE</td>
<td colspan="2"><b>ABDOMEN</b></td>
</tr>
<tr>
<td >DISTANT VISION</td><td>WITHOUT GLASSES</td>
<td>6/{$dis_without_right_eye}</td><td>6/{$dis_without_left_eye}</td>
<td >LIVER</td> <td >{$liver }</td>
</tr>
<tr>
<td ></td><td>WITH GLASSES</td>
<td>6/{$dis_with_right_eye}</td><td>6/{$dis_with_left_eye}</td>
<td >Speen</td> <td >{$speen }</td>
</tr>
<tr>
<td >NEAR VISION</td><td>WITHOUT GLASSES</td>
<td>N/{$near_without_right_eye}</td><td>N/{$near_without_left_eye}</td>
<td >TENDERNESS</td> <td >{$tenderness }</td>
</tr>
<tr>
<td ></td><td>WITH GLASSES</td>
<td>N/{$near_with_right_eye}</td><td>N/{$near_with_right_eye}</td>
<td >ANY OTHER ABNORMALITY</td> <td >{$any_other_abnormality }</td>
</tr>
<tr>
<td ></td>
<td ></td>
<td ></td>
<td ></td>
<td >SKIN</td>
<td >{$skin }</td>
</tr>
<tr>
<td colspan="2">COLOR VISION</td>
<td colspan="2">{$color_vision }</td>
<td >RS</td>
<td >{$rs }</td>
</tr>
<tr>
<td colspan="4"><b>CVS</b></td>
<td >MUSCULO SKELETAL</td>
<td >{$musculo_skeletal }</td>
</tr>
<tr>
<td >S1</td>
<td >{$s1}</td>
<td >S2</td>
<td >{$s2}</td>
<td >CNS</td>
<td >{$cns }</td>
</tr>
<tr>
<td >ANY OTHER SOUND</td>
<td >{$any_other_sound}</td>
<td >ECG (12 LEAD) FINDINGS</td>
<td >{$ecg_findings}</td>
<td colspan="2"><b>ENT</b> </td>
</tr>
<tr>
<td >2D ECHO/TMT FINDINGS</td>
<td >{$tmt_findings}</td>
<td ></td>
<td ></td>
<td >Conversational Hearing </td>
<td >{$conversational_hearing }</td>
</tr>
<tr>
<td colspan="4" ></td>
<td >AUROSCOPY </td>
<td >{$auroscopy }</td>
</tr>
<tr>
<td colspan="4" ></td>
<td >EAC </td>
<td >{$eac }</td>
</tr>
<tr>
<td colspan="4"></td>
<td >NOSE </td>
<td >{$nose }</td>
</tr>
<tr>
<td colspan="4"></td>
<td >THROAT </td>
<td >{$throat }</td>
</tr>
<tr>
<td colspan="6"><b>14. ILO CLASSIFICATION OF CHEST RADIOGRAPH (Enclosed Chest Radiograph)</b></td>
</tr>
<tr>
<td colspan="2" >PROFUSION OF PNEUMOCONIOTIC OPACITIES</td>
<td colspan="2" >GRADES</td>
<td colspan="2" >Types</td>
</tr>
<tr>
<td colspan="2" >{$profusion_opacities}</td>
<td colspan="2" >{$grade}</td>
<td colspan="2" >{$type}</td>
</tr>
<br>
<br>
<br>
<tr>
<td colspan="6"><b> RESULT OF SPIROMETRY (REPORT ENCLOSED)</b></td>
</tr>
<tr>
<td colspan="3" >PARAMETERS </td>
<td >PREDICTED VALUE</td>
<td >PERFORMED VALUE</td>
<td >% OF PREDICTED</td>
</tr>
<tr>
<td colspan="3">FORCED VITAL CAPACITY (FVC)</td>
<td >{$fvc_pre}</td>
<td >{$fvc_post}</td>
<td >{$fvc}</td>
</tr>
<tr>
<td colspan="3">FORCED EXPIRATORY VOLUME IN 1 SEC (FEV1)</td>
<td >{$fev1_pre}</td>
<td >{$fev1_post}</td>
<td >{$fev1}</td>
</tr>
<tr>
<td colspan="3">FEV1/FVC</td>
<td >{$fev1_fvc_pre}</td>
<td >{$fev1_fvc_post}</td>
<td >{$fev1_fvc}</td>
</tr>
<tr>
<td colspan="3">PEAK EXPIRATORY FLOW</td>
<td >{$peak_expiratory_flow_pre}</td>
<td >{$peak_expiratory_flow_post}</td>
<td >{$peak_expiratory_flow}</td>
</tr>
<tr>
<td colspan="6"><b> AUDIOMETRY FINDINGS ( REPORT ENCLOSED) </b></td>
</tr>
<tr>
<td colspan="2">CONDUCTION TYPE </td>
<td colspan="2" align="center">LEFT EAR</td>
<td colspan="2" align="center">RIGHT EAR</td>
</tr>
<tr>
<td colspan="2">AIR CONDUCTION</td>
<td colspan="2"> {$air_cond_left}</td>
<td colspan="2"> {$air_cond_right}</td>
</tr>
<tr>
<td colspan="2">BONE CONDUCTION</td>
<td colspan="2"> {$bone_cond_left}</td>
<td colspan="2"> {$bone_cond_left}</td>
</tr>
<tr >
<td colspan="6" align="center"><b style="font-weight: 800">INVESTIGATIONS</b></td>
</tr>
<tr>
<td align="center" colspan="6" ><b> BLOOD GROUP </b><span style="margin-left:20px">{$blood_group}</span></td>
</tr>
<tr>
<td > HB </td><td>{$hb}</td>
<td >TLC</td><td>{$tlc}</td>
<td > DLC-N</td><td>{$dlc_n}</td>
</tr>
<tr>
<td > DLC-L</td><td>{$dlc_l}</td>
<td > DLC-M</td><td>{$dlc_m}</td>
<td > DLC-E</td><td>{$dlc_e}</td>
</tr>
<tr>
<td > ESR</td><td>{$esr}</td>
<td > S. UREA</td><td>{$s_urea}</td>
<td >S.CREATININE</td><td>{$s_creatinine}</td>
</tr>
<tr>
<td > BLOOD SUGAR </td><td>{$blood_sugar}</td>
<td > VDRL</td><td>{$vdrl}</td>
<td >HBSAG </td><td>{$hbsag}</td>
</tr>
<tr>
<td >HIV </td><td>{$hiv}</td>
<td > LIPID PROFILE</td><td>{$lipid_profile}</td>
</tr>
<tr>
<td align="center" colspan="6" ><b> URINE RE/ME</b><span style="margin-left:20px"></span></td>
</tr>
<tr>
<td > APPEARANCE</td><td>{$appearance}</td>
<td >PUS CELLS</td><td>{$pus_cells}</td>
<td > RBCS</td><td>{$rbcs}</td>
</tr>
<tr>
<td > EPITHELIAL CELLS</td><td>{$epithelial_cells}</td>
<td > OTHER RELEVANT FINDINGS </td><td>{$other_relevant_findings}</td>
<td > ALBUMIN </td><td>{$albumin}</td>
</tr>
<tr>
<td > SUGAR</td><td colspan="5">{$sugar}</td>
</tr>
<tr>
<td >STOOL RE/ME</td><td colspan="5" >{$stool_re_me}</td>
</tr>
<tr>
<td >OPINION OF THE MO</td><td colspan="5" >{$opinion_mo}</td>
</tr>
<tr>
<td >REMARKS BY MEDICAL ASSISTANT</td><td colspan="5">{$opinion_remarks_medical_assistant}</td>
</tr>
<tr>
<td >REMARKS BY DOCTOR</td ><td colspan="5">{$opinion_remarks}</td>
</tr>
<tr>
<td colspan="6" align="right">
<p><br/><br/><br/><br/><b>SIGNATURE OF MEDICAL OFFICER<BR/>(WITH STAMP)</b></p>
</td>
</tr>
<tr>
<td >DOCTOR NAME</td ><td colspan="5">{$doctor_name}</td>
</tr>
<tr>
<td >QUALIFICATION</td ><td colspan="5">{$approving_doc_qualification}</td>
</tr>
<tr>
<td >REGISTRATION NO</td ><td colspan="5">{$approving_doc_regd_no}</td>
</tr>
</table>
EOD;
$pdf->writeHTML($txt1, true, false, false, false, '');
// $path = 'images/';
// $filename = $file_name;
// $filepath = $path.$filename;
error_log("paathhhhhh".$filepath);
// If a physical file is not available then create it
// If the DB data is fresher than the file then make a new file
if(!is_file($filepath) || strtotime($row['last_update']) > filemtime($filepath))
{
$result = file_put_contents('', $row_patient_physical_parameters['approving_doc_sign_img']);
error_log("imagggggggge".$row_patient_physical_parameters['approving_doc_sign_img']);
if($result === FALSE)
{
// die(__FILE__.'<br>Error - Line #'.__LINE__.': Could not create '.$filepath);
}
}
$pdf->Image('',114, 206, 30, 10, '', '', '', false, 150, '', false, false, 0, false, false, false );
ob_end_clean();
//Close and output PDF document
$pdf->Output('example_018.pdf', 'I');
?>