File: /home/cafsindia/medlocqr_com/med_lib/med_db_bk.php
<?php
/**********************************************************
Filename: lp_db.php
Description: life planner specific database operations
Author: uday
Created on: AUG, 01 2018
Approved on:
Reviewed on:
------------------------------------------------------------
Modification Details
Changed by:
------------------------------------------------------------
**********************************************************/
class med_db extends DBObject{
private $dbObj = null;
function __construct(){
$this->open_db();
}
function getDBObject(){
$this->dbObj = $this->get_db();
return $this->dbObj;
}
function get_medlocker_data($prime_id){
$med_info = $this->runQuery("Select *,cw_blood_group.blood_group as blood_group_name from cw_medlocker inner join cw_blood_group on cw_blood_group.prime_blood_group_id = cw_medlocker.blood_group where prime_medlocker_id = '$prime_id'");
$med_rows = $this->result($med_info);
$personal_line = "";
$medical_line = "";
$emergency_line = "";
$proof_doc = "";
$medical_doc = "";
$proof_th = "";
$medical_th = "";
$emergency_th = "";
$emergency_doc = "";
foreach ($med_rows as $key => $value) {
$name = $value->person_name;
$mobile_no = $value->mobile_no;
$dob = date("d-m-Y",strtotime($value->dob));
$gender = $value->gender;
$address = $value->address;
$proof_type = $value->proof_type;
$upload_front_page = $value->upload_front_page;
$upload_back_page = $value->upload_back_page;
$blood_group = $value->blood_group_name;
$medical_info = $value->medical_info;
$conditions = $value->conditions;
$medicines = $value->medicines;
$hospital_information = $value->hospital_information;
$emergency_contact = $value->emergency_contact;
$emergency_name = $value->emergency_name;
$relationship = $value->relationship;
$contact = $value->contact;
$medical_document = $value->medical_document;
if((int)$gender === 1){
$gender = "Male";
}else
if((int)$gender === 2){
$gender = "Female";
}else{
$gender = "Other";
}
if((int)$proof_type !== 1){
$proof_th = "<tr><td>Front Page : <a target='_blank' href='../".$upload_front_page."'>View</a></td></tr>
<tr><td>Back Page : <a target='_blank' href='../".$upload_back_page."'>View</a></td></tr>";
}
$upload_pages = "";
if((int)$proof_type === 1){
$proof_type = "Manual";
}else{
$proof_type = "Aadhaar";
$upload_pages = "Front Page : ". $upload_front_page ." \n Back Page : ". $upload_back_page ."";
}
/*if((int)$medical_info !== 1){
$medical_info = "Manual";
$medical_th = "<tr><td>Medical Document : <a target='_blank' href='../".$medical_document."'>View Document</a></td></tr>";
// $medical_doc = "<tr><img src='https://chart.googleapis.com/chart?cht=qr&chs=100x100&chl=Name :$name \n Mobile :$mobile_no \n DOB :$dob \n Gender :$gender \n Address :$address \n $upload_pages \n Blood Group :$blood_group \n Medical Information :$medical_info \n Conditions :$conditions \n Medicines :$medicines \nHospital Information :$hospital_information \n Emergency Contact :$emergency_contact \n Emergency Name :$emergency_name \n Relationship :$relationship \n Contact :$contact \n Medical Document :$medical_document&choe=UTF-8' width='250' height='250'></tr>";
$medical_doc = "<td><img src='https://chart.googleapis.com/chart?"; // url
$medical_doc .= "cht=qr&chs=300x300&chl="; // required data
$medical_doc .= "Name :".$name."%0AMobile :".$mobile_no."%0ADOB :".$dob."%0AGender :".$gender. "%0AAddress :".$address. "%0A".$upload_pages."%0ABlood Group :".$blood_group."%0AMedical Information :".$medical_info."%0AConditions :".$conditions. "%0AMedicines :".$medicines. "%0AHospital Information :".$hospital_information."%0AEmergency Contact :".$emergency_contact."%0AEmergency Name :".$emergency_name."%0ARelationship :".$relationship. "%0AContact :".$contact."%0AMedical Document :".$medical_document. "%0A\t";
$medical_doc .= " &choe=UTF-8' width='250' height='250'><td>";
}
else{*/
$medical_info = "Medical";
$medical_th = "<tr><td>Blood Group : $blood_group</td></tr>
<tr><td>Conditions : $conditions</td></tr>
<tr><td>Medicines : $medicines</td></tr>
<tr><td>Hospital info : $hospital_information</td></tr>";
$medical_doc = "<td><img src='https://chart.googleapis.com/chart?"; // url
$medical_doc .= "cht=qr&chs=300x300&chl="; // required data
$medical_doc .= "Name :".$name."%0AGender/DOB :".$gender."/".$dob."%0ABlood Group :".$blood_group."%0ACritical Info:"."%0A".$conditions."%0A".$medicines. "%0A".$medical_info. "%0A".$hospital_information."%0AEmergency:".$emergency_name.','.$contact. "%0A\t";
$medical_doc .= " &choe=UTF-8' width='250' height='250'><td>";
/*}*/
$personal_medical_line = "<table>
<tbody>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Name</td>
<td style='padding: 8px;'>: $name</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Gender/DOB</td>
<td style='padding:8px;'>: $gender/$dob</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Blood Group</td>
<td style='padding: 8px;'>: $blood_group</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Critical Info</td>
<td style='padding: 8px;'>: $conditions</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Medicines</td>
<td style='padding: 8px;'>: $medicines</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Hospital info</td>
<td style='padding: 8px;'>: $hospital_information</td>
</tr>
<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Emergency</td>
<td style='padding: 8px;'>: $emergency_name, $contact</td>
</tr>
</tbody>
</table>";
$scan_code_line = "<table class='responsive-table over-hide' style='table-layout: fixed; width: 100%'>
<tbody style='text-align:center;'>
$medical_doc
</tbody>
</table>";
}
return json_encode(array('sts' => TRUE, 'personal_medical_line' =>"$personal_medical_line", 'prime_id' =>$prime_id, 'scan_code_line' =>"$scan_code_line", 'msg' =>"Successfully Inserted"));
}
/*
UDY REMOVE
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Name: $name</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Gender/DOB : $gender/$dob</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Blood Group : $blood_group</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Critical Info : $conditions</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Medicines : $medicines</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Hospital info : $hospital_information</td></tr>
<tr style='border-bottom: 0px;'><td style='padding: 8px;'>Emergency : $emergency_name, $contact</td></tr>
*/
}
?>