File: /home/cafsindia/medlocqr_com/admin/app/api_controller.php
<?php
$frm = "";
/* Module Initilization */
$json = file_get_contents('php://input');
$json = json_decode($json);
$frm = $json->data->frm;
if (isset($frm)){
require("./api_model.php");
$api_model = new api_model;
}else
if(isset($_post["frm"])){
$frm = $_post['frm'];
require("./api_model.php");
$api_model = new api_model;
}
if($frm === "qr_code_generation"){
$prime_id = $_REQUEST['prime_id'];
$mysql_rslt = $api_model->get_data("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. "' and cw_medlocker.trans_status = 1");
$content = "";
$med_link = "";
foreach ($mysql_rslt as $key => $value){
$name = $value->person_name;
$mobile_no = $value->mobile_no;
$gender = $value->gender;
$address = $value->address;
$dob = date("d-m-Y",strtotime($value->dob));
$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;
$upload_front_page = $value->upload_front_page;
$upload_back_page = $value->upload_back_page;
$medical_document = $value->medical_document;
if((int)$gender === 1){
$gender = 'Male';
}else
if((int)$gender === 1){
$gender = 'Female';
}else{
$gender = 'Others';
}
$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 ."";
}
$med_document = "";
if($medical_document){
$med_link = str_replace("index.php/medlocker",$medical_document,$_SERVER['HTTP_REFERER']);
$med_document = "Medical Document : ". $med_link ."";
}
if((int)$medical_info === 1){
$medical_info = "Manual";
}else{
$medical_info = "Medical";
}
$content = "Name :".$name."\nMobile :".$mobile_no."\nDOB :".$dob."\nGender :".$gender. "\nAddress :".$address. "\n".$upload_pages."\nBlood Group :".$blood_group."\nMedical Information :".$medical_info."\nConditions :".$conditions. "\nMedicines :".$medicines. "\nHospital Information :".$hospital_information."\nEmergency Contact :".$emergency_contact."\nEmergency Name :".$emergency_name."\nRelationship :".$relationship. "\nContact :".$contact. "\n\t" . $med_document;
}
$url = 'http://chart.apis.google.com/chart';
$image = $api_model->QRCODE($size=300,$filename=$name,$content,$url);
if($image){
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename='.basename($image));
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($image));
ob_clean();
flush();
readfile($image);
unlink($image);
exit;
}
//return_rslt($frm,$image);
}else
if($frm === "get_state_list"){
$mysql_state_rslt = $api_model->get_state_data("select prime_state_id,state_name from cw_state where trans_status = 1");
if($mysql_state_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch State Records","rslt"=>$mysql_state_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No State Data Found","error"=>""));
}
}else
if($frm === "get_city_list"){
$mysql_city_rslt = $api_model->get_city_data("select prime_city_id,state,city_name from cw_city where trans_status = 1");
if($mysql_city_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch City Records","rslt"=>$mysql_city_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No City Data Found","error"=>""));
}
}else
if($frm === "get_country_list"){
$mysql_country_rslt = $api_model->get_country_data("select prime_country_id,country_code from cw_country where trans_status = 1");
if($mysql_country_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch Country Records","rslt"=>$mysql_country_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No Country Data Found","error"=>""));
}
}else
if($frm === "get_blood_group_list"){
$mysql_blood_group_rslt = $api_model->get_blood_group_data("select prime_blood_group_id,blood_group from cw_blood_group where trans_status = 1");
if($mysql_blood_group_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch Blood Group Records","rslt"=>$mysql_blood_group_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No Blood Group Are Found","error"=>""));
}
}else
if($frm === "get_material_type_list"){
$mysql_material_type_rslt = $api_model->get_material_type_data("select prime_material_type_id,material_name,price,material from cw_material_type where trans_status = 1");
if($mysql_material_type_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch Meterial type Records","rslt"=>$mysql_material_type_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No Meterial type Data Found","error"=>""));
}
}else
if($frm === "get_gender_list"){
$mysql_gender_rslt = $api_model->get_gender_data("select prime_gender_id,gender from cw_gender where trans_status = 1");
if($mysql_gender_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Fetch Gender Records","rslt"=>$mysql_gender_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"No Gender Data Found","error"=>""));
}
}else
if($frm === "bulk_insert"){
$action = $json->data->action;
$offline_data = $json->data;
$clould_id = $offline_data->clould_id;
$order_id = $offline_data->order_id;
$hospital_name = $offline_data->Hospital_name;
$bulk_data = $offline_data->bulk_data;
$mysql_select_rslt = $api_model->select_data("Select count(*) as count from cw_bulk_offline_data where clould_id = '".$clould_id."' and order_id = '".$order_id."' and trans_status = 1");
if($mysql_select_rslt[0]->count){
echo json_encode(array('sts' => FALSE, "msg" => "Cloud Id Already Exist","rslt"=>"","error"=>""));
}else{
$mysql_offline_insert_rslt = $api_model->insert_data("INSERT INTO cw_bulk_offline_data (`clould_id`, `order_id`, `hospital_name`) VALUES ('".$clould_id."','".$order_id."','".$hospital_name."')");
if($mysql_offline_insert_rslt){
$insert_values = "";
foreach($bulk_data as $bulk_data){
$proof_type = $bulk_data->proof_type;
$name = $bulk_data->name;
$mobile_no = $bulk_data->mobile_no;
$dob = date("Y-m-d",strtotime($bulk_data->dob));
$gender = $bulk_data->gender;
$address = $bulk_data->address;
$medical_info = $bulk_data->medical_info;
$blood_group = $bulk_data->blood_group;
$conditions = $bulk_data->conditions;
$medicines = $bulk_data->medicines;
$hospital_information = $bulk_data->hospital_information;
$emergency_contact = $bulk_data->emergency_contact;
$city = $bulk_data->city;
$state = $bulk_data->state;
$pincode = $bulk_data->pincode;
$country_code = $bulk_data->country_code;
$emergency_name = $bulk_data->emergency_name;
$relationship = $bulk_data->relationship;
$contact = $bulk_data->contact;
$delivery_address = $bulk_data->delivery_address;
$material_type = $bulk_data->material_type;
$trans_created_by = "1";
$trans_created_date = date("Y-m-d h:i:s");
// INSERT QUERY FOR CW_MEDLOCKER TABLE
$insert_values .= "(\"$proof_type\",\"$name\",\"$mobile_no\",\"$dob\",\"$gender\",\"$address\",\"$medical_info\",\"$blood_group\",\"$conditions\",\"$medicines\",\"$hospital_information\",\"$emergency_contact\",\"$city\",\"$state\",\"$pincode\",\"$country_code\",\"$emergency_name\",\"$relationship\",\"$contact\",\"$delivery_address\",\"$material_type\",\"$mysql_offline_insert_rslt\",\"$trans_created_by\",\"$trans_created_date\"),";
}
if(isset($insert_values)){
$insert_values = rtrim($insert_values,",");
$mysql_medlocker_insert_rslt = $api_model->insert_data("INSERT INTO cw_medlocker (`proof_type`, `person_name`, `mobile_no`, `dob`, `gender`, `address`, `medical_info`, `blood_group`, `conditions`, `medicines`, `hospital_information`, `emergency_contact`,`city`, `state`, `pincode`, `country_code`, `emergency_name`, `relationship`, `contact`, `delivery_address`, `material_type`, `prime_offline_id`, `trans_created_by`, `trans_created_date`) VALUES $insert_values");
if($mysql_medlocker_insert_rslt) {
echo json_encode(array('sts' => TRUE, "msg" => "Records Successfully Inserted","rslt"=>"","error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Insert Error","rslt"=>"","error"=>""));
}
}
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Insert Error","rslt"=>"","error"=>""));
}
}
}else
if($frm === "get_status"){
$clould_id = $json->data->clould_id;
$order_id = $json->data->order_id;
$mysql_select_rslt = $api_model->select_data("Select ordered,ordered_date,shipped,shipped_date,intransit,intransit_date,deliverd,deliverd_date from cw_bulk_offline_data where clould_id = '".$clould_id."' and order_id = '".$order_id."' and trans_status = 1");
if($mysql_select_rslt){
echo json_encode(array('sts' => TRUE, "msg" => "Records Successfully Selected","rslt"=>$mysql_select_rslt,"error"=>""));
}else{
echo json_encode(array('sts' => FALSE, "msg" => "Records Select Error","rslt"=>"","error"=>""));
}
}else{
echo json_encode(array(
'Status' => 400,
'success' => False,
'data' => "Bad Request"
));
}
function return_rslt($frm,$rslt){
if(!$rslt){
echo json_encode(array('success' => FALSE, 'sts' =>"No Record found"));
}else{
echo json_encode(array('success' => TRUE, "$frm" => $rslt));
}
}
?>