<?php
require_once('../med_lib/medObject.php');
$libObject =  medObject::newObject('med_db');
$real_db   = $libObject->getDBObject();
$frm = "";
if(isset($_POST['frm'])){
	$frm = $_POST['frm'];
}
if($frm === "save_data"){
	$personal_data = "";
	if(isset($_POST['personal_data'])){
		$personal_data = $_POST['personal_data'];
		$personal_data = json_decode($personal_data);
	}
	$medical_data = "";
	if(isset($_POST['medical_data'])){
		$medical_data = $_POST['medical_data'];
		$medical_data = json_decode($medical_data);
	}
	$qry_key     = "";
	$qry_value   = "";
	$upd_query   = "";
	foreach($personal_data as $form_data){
		$name  = $real_db->real_escape_string($form_data->name);
		$value = $real_db->real_escape_string($form_data->value);
		if($name === "dob"){
			$value    = new DateTime($value);
			$value    = $value->format("Y-m-d");
		}
		if($name === "person_id"){
			$person_id = $value;
		}	
		if($value){
			$qry_key     .= "$name,";
			$qry_value   .= "'$value',";
		}
	}
	foreach($medical_data as $medical){
		$name  = $real_db->real_escape_string($medical->name);
		$value = $real_db->real_escape_string($medical->value);			
		if($value){
			$qry_key     .= "$name,";
			$qry_value   .= "'$value',";
		}
	}
	$created_on = date("Y-m-d h:i:s");
	$qry_key   .= "trans_created_date,";
	$qry_value .= "'$created_on',";	
	$upd_query .= "trans_updated_by = '$created_on',";
	$qry_key    = rtrim($qry_key,',');
	$qry_value  = rtrim($qry_value,',');

	if((int)$person_id === 0){
		$query     = "insert into cw_medlocker ($qry_key) values ($qry_value)";
		$prime_id = $libObject->runQuery_insert_id($query);
		if($prime_id){
			echo $libObject->get_medlocker_data($prime_id);
		}else{
			return json_encode(array('sts' => TRUE, 'msg' =>"Please try after sometime.."));
		}
	}	
}else
if($frm === "save_payment"){
	$response = "";
	if(isset($_POST['response'])){
		$response = $_POST['response'];
	}
	$prime_id = "";
	if(isset($_POST['prime_id'])){
		$prime_id = $_POST['prime_id'];
	}
	$transaction_id = "";
	if(isset($_POST['transaction_id'])){
		$transaction_id = $_POST['transaction_id'];
	}
	$delivery_address = "";
	if(isset($_POST['delivery_address'])){
		$delivery_address = $real_db->real_escape_string($_POST['delivery_address']);
	}
	$material_type = "";
	if(isset($_POST['material_type'])){
		$material_type = $_POST['material_type'];
	}
	$payment_type = "";
	if(isset($_POST['payment_type'])){
		$payment_type = $_POST['payment_type'];
	}
	$qry = "";
	if((int)$payment_type === 1){
		$qry = "ordered = '1',ordered_date = '".date("Y-m-d")."',";
	}
	
	$created_on = date("Y-m-d h:i:s");
	$query     = "UPDATE cw_medlocker SET $qry delivery_address = '".$delivery_address."',material_type = '".$material_type."',transaction_id = '".$transaction_id."',trans_updated_date = '".$created_on."' where prime_medlocker_id = '".$prime_id."'";
	if($libObject->runQuery($query)){
		$query     = "insert into cw_medlocker_payment (prime_medlocker_id,transaction_id,razor_order_id,payment_status,trans_created_date) values ('".$prime_id."','".$transaction_id."','".$response."','".$payment_type."','".$created_on."')";
		$result = $libObject->runQuery_insert_id($query);
		if($result){
			echo json_encode(array('sts' => TRUE, "msg"=>"Completed","payment_type"=>$payment_type,"transaction_id"=>$transaction_id));
		}else{
			echo json_encode(array('sts' => FALSE, 'msg' =>"Failed.."));
		}
	}else{
		echo json_encode(array('sts' => FALSE, 'msg' =>"Please try after sometime.."));
	}		
}else
if($frm === "track_data"){
	$tracking_id = "";
	if(isset($_POST['tracking_id'])){
		$tracking_id = $_POST['tracking_id'];
	}
	echo $libObject->get_tracker_data($tracking_id);
}else{
	echo json_encode(array('sts' => FALSE, 'info' =>"No Record found"));
}
?>