File: /home/cafsindia/medlocqr_com/med_lib/med_db.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_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;
if($conditions){
$medical_doc .= "%0ACritical Info:"."%0A".$conditions;
}
if($medicines){
$medical_doc .= "%0AMedication:"."%0A".$medicines;
}
if($medical_info){
$medical_doc .= "%0A".$medical_info;
}
if($hospital_information){
$medical_doc .= "%0A".$hospital_information;
}
$medical_doc .= "%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>";
if($conditions){
$personal_medical_line .="<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Critical Info</td>
<td style='padding: 8px;'>: $conditions</td>
</tr>";
}
if($medicines){
$personal_medical_line .="<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Medicines</td>
<td style='padding: 8px;'>: $medicines</td>
</tr>";
}
if($hospital_information){
$personal_medical_line .="<tr style='border-bottom: 0px;'>
<td style='padding: 8px;width:13%;'>Hospital info</td>
<td style='padding: 8px;'>: $hospital_information</td>
</tr>";
}
$personal_medical_line .="<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"));
}
function get_tracker_data($tracking_id){
$tracker_info = $this->runQuery("Select ordered,ordered_date,shipped,shipped_date,intransit,intransit_date,deliverd,deliverd_date from cw_medlocker where transaction_id = '$tracking_id'");
$tracker_result = $this->result($tracker_info);
if($tracker_result){
$timeline_map = "";
$shipped_text = "active";
$intransit_text = "active";
$deliverd_text = "active";
foreach ($tracker_result as $key => $value) {
$ordered = $value->ordered;
$ordered_date = date("d-m-Y",strtotime($value->ordered_date));
$shipped = (int)$value->shipped;
$shipped_date = date("d-m-Y",strtotime($value->shipped_date));
$intransit = (int)$value->intransit;
$intransit_date = date("d-m-Y",strtotime($value->intransit_date));
$deliverd = (int)$value->deliverd;
$deliverd_date = date("d-m-Y",strtotime($value->deliverd_date));
if($shipped !== 1){
$shipped_text = "";
$shipped_date = "";
}
if($intransit !== 1){
$intransit_text = "";
$intransit_date = "";
}
if($deliverd !== 1){
$deliverd_text = "";
$deliverd_date = "";
}
if((int)$ordered === 1){
$timeline_map .= "<li class='active step0'><span style='font-weight:bold;'>Ordered</span> <br><span>$ordered_date</span></li>
<li class='$shipped_text step0'><span style='font-weight:bold;'>Shipped</span> <br><span>$shipped_date</span></li>
<li class='$intransit_text step0'><span style='font-weight:bold;'>Intransist</span> <br> <span>$intransit_date</span></li>
<li class='$deliverd_text step0'><span style='font-weight:bold;'>Delivered </span><br> <span>$deliverd_date</span></li>";
return json_encode(array('sts' => TRUE,'timeline_map' => $timeline_map));
}else{
return json_encode(array('sts' => FALSE, 'msg' =>"Please Check Your Track Id"));
}
}
}else{
return json_encode(array('sts' => FALSE, 'msg' =>"Please Check Your Track Id"));
}
}
/*
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>
*/
}
?>