Insert update Delete Laravel 5.1
Submitted by Darshan Malani - 8 years ago
insert update delete UserController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers\Controller;
class BloodPressureController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return view('front.bp_pulse')->with('user_id',\Auth::User()->id);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$error = false;
$status_code = 200;
$result =[];
if($id != "" && $id > 0) {
try{
$user_pulse = \App\Models\User_pulse::find($id);
if($user_pulse){
$guid = $user_pulse->guid;
$user_pulse->delete();
$result["guid"] = $guid;
$result['message'] = 'User Pulse Removed Successfully.';
}
else{
$error = true;
$result['error_message'] = 'Record does not exists.';
}
}catch(\Exception $ex){
$error = true;
$status_code = $ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}else{
$error =true;
$status_code = 400;
$result['message']='Request data is empty';
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function loggedBpPulse($user_id, Request $request){
$error =false;
$status_code = 200;
$user_bp_pulse_goals = array();
$from_server = $request->get('from_server');
$start_date = date('Y-m-d', strtotime($request->get('start_date')) );
$end_date = date('Y-m-d', strtotime($request->get('end_date')) );
$user_bp_pulse_history_data = [];
if($user_id !="" && $user_id > 0){
try{
$user = \App\Models\User::find($user_id);
if($user != null){
if($from_server){ //get last 7 weight
$user_bp_pulse_history_data = $user->blood_pressure_pulse()->with('pulse')->whereDate('log_date', '>=', $start_date)
->whereDate('log_date', '<=', $end_date)
->get();
$user_bp_pulse_last_log = $user->blood_pressure_pulse()->with('pulse')
->orderBy('log_date')
->get();
$user_bp_pulse_goals = $user->User_bp_pulse_goal()->get();
$bppulse = [];
$result_count = count($user_bp_pulse_goals);
if($result_count > 0){
foreach ($user_bp_pulse_goals as $item)
{
if(($item['bp_type'])=='systolic')
{
$bppulse['systolic'] = $item['goal'];
$bppulse['start_date_systolic'] = $item['start_date'];
$bppulse['goal_date_systolic'] = $item['goal_date'];
}
if(($item['bp_type'])=='diastolic')
{
$bppulse['diastolic'] = $item['goal'];
$bppulse['start_date_diastolic'] = $item['start_date'];
$bppulse['goal_date_diastolic'] = $item['goal_date'];
}
if(($item['bp_type'])=='heart_rate')
{
$bppulse['heart_rate'] = $item['goal'];
$bppulse['start_date_pulse'] = $item['start_date'];
$bppulse['goal_date_pulse'] = $item['goal_date'];
}
if(($item['goal_date']) != null)
{
$bppulse['goal_date'] = $item['goal_date'];
}
if(($item['user_id']) != null)
{
$bppulse['user_id'] = $item['user_id'];
}
}
$bppulse_progress = new \App\Common\BpPulse_progress($bppulse);
$result['bppulse_progress'] =$bppulse_progress->getBpPulseProgress();
$result['user_bp_pulse_goals'] = $bppulse;
}
$result['user_bp_pulse_history_data'] = $user_bp_pulse_history_data ? $user_bp_pulse_history_data : [];
$result['user_bp_pulse_last_log'] = $user_bp_pulse_last_log ? $user_bp_pulse_last_log :[];
}
else{
$user_bp_pulse_history_data = $user->blood_pressure_pulse()->with('pulse')->get();
$result = $user_bp_pulse_history_data;
}
}else{
$error = true;
$status_code = 404;
$result['message']='No Patient Found.';
}
}catch(\Exception $ex){
$error = true;
$status_code =$ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function loggedPulse($user_id){
$error =false;
$status_code = 200;
if($user_id !="" && $user_id > 0){
try{
$user = \App\Models\User::find($user_id);
if($user != null){
$get_user_pulse = \App\Models\User_pulse::where('user_id',$user_id)->orderBy('id')->get();
$result = $get_user_pulse;
}else{
$error = true;
$status_code = 404;
$result['message']='No Patient Found.';
}
}
catch(\Exception $ex){
$error = true;
$status_code =$ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function logBpPulse(Request $request){
$error = false;
$status_code = 200;
$result =[];
$input = $request->all();
$today = date("Y-m-d");
$user_agent = "";
if(!empty($input)) {
try{
$user_id = $input['user_id'];
$user = \App\Models\User::find($user_id);
if($user != null){
if(empty($input['log_date'])){
$input['log_date'] = $today;
}
// get pulse id
$log_pulse = $this->add_pulse($input);
if(count($log_pulse)>0)
{
$input['user_pulse_id'] = $log_pulse['log_pulse']['id'];
if(isset($input['guid_server'])){
$current_timestamp = \Carbon\Carbon::now()->timestamp;
$input['guid'] = guid();
$input['timestamp'] = $current_timestamp;
$user_agent = 'server';
}
$check_user_bp_pulse = $user->blood_pressure_pulse()->where('guid', $input['guid'])
->first();
if(!empty($check_user_bp_pulse)){
$check_user_bp_pulse->update($input);
$id = $check_user_bp_pulse->id;
$guid = $check_user_bp_pulse->guid;
}
else{
$log_blood_pressure = $user->blood_pressure_pulse()->create($input);
$id = $log_blood_pressure->id;
$guid = $log_blood_pressure->guid;
}
// for iPhone notification
if($user_agent != "" && $user_agent == 'server'){
$notification['user_id'] = $user_id;
$notification['notification_text'] = 'BP_PULSE_ADDED';
sendNotification($notification);
}
$result['log_blood_pressure'] = array("id"=>$id, "guid"=>$guid);
$result['message']='Blood Pressure And Pulse Logged Successfully.';
}
else{
$error = true;
$result['message']='Pulse data not inserted properly';
}
}else{
$error = true;
$status_code = 404;
$result['message']='No Patient Found.';
}
}catch(\Exception $ex){
throw $ex;
$error = true;
$status_code = $ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}else{
$error =true;
$status_code = 400;
$result['message']='Request data is empty';
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function logPulse(Request $request){
$error = false;
$status_code = 200;
$result =[];
$input = $request->all();
$result = $this->add_pulse($input);
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function add_pulse($input){
$result = [];
$today = date("Y-m-d");
$user_agent = "";
if(!empty($input)) {
try{
$user_id = $input['user_id'];
$user = \App\Models\User::find($user_id);
if($user != null){
if(empty($input['log_date'])){
$input['log_date'] = $today;
}
if(isset($input['guid_server'])){
$current_timestamp = \Carbon\Carbon::now()->timestamp;
$input['guid'] = guid();
$input['timestamp'] = $current_timestamp;
$user_agent = 'server';
}
$check_user_pulse = $user->user_pulse()->where('guid', $input['guid'])
->first();
if(!empty($check_user_pulse)){
$check_user_pulse->update($input);
$id = $check_user_pulse->id;
$guid = $check_user_pulse->guid;
}
else{
$log_pulse = $user->user_pulse()->create($input);
$id = $log_pulse->id;
$guid = $log_pulse->guid;
}
if($id>0){
// for iPhone notification
if($user_agent != "" && $user_agent == 'server'){
$notification['user_id'] = $user_id;
$notification['notification_text'] = 'BP_PULSE_ADDED';
sendNotification($notification);
}
$result['log_pulse'] = array("id"=>$id, "guid"=>$guid );
$result['message']='Pulse Logged Successfully.';
}
}else{
$error = true;
$status_code = 404;
$result['message']='No Patient Found.';
}
}catch(\Exception $ex){
throw $ex;
$error = true;
$status_code = $ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}else{
$error =true;
$status_code = 400;
$result['message']='Request data is empty';
}
return $result;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function deleteBpPulse($id)
{
$error = false;
$status_code = 200;
$result =[];
if($id != "" && $id > 0) {
try{
$user_bp_pulse = \App\Models\Blood_pressure_pulse::find($id);
if($user_bp_pulse){
$guid = $user_bp_pulse->guid;
$user_pulse_id = $user_bp_pulse->user_pulse_id;
$user_bp_pulse->delete();
$user_pulse = \App\Models\User_pulse::find($user_pulse_id);
if($user_pulse){
$user_pulse->delete();
}
$result["guid"] = $guid;
$result['message'] = 'User Bp & Pulse Removed Successfully.';
}
else{
$error = true;
$result['error_message'] = 'Record does not exists.';
}
}catch(\Exception $ex){
$error = true;
$status_code = $ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}else{
$error =true;
$status_code = 400;
$result['message']='Request data is empty';
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function calculateMonthlyBpPulsesummary($user_id){
$result= [];
$error =false;
$status_code = 200;
if($user_id !="" && $user_id > 0){
try{
$user = \App\Models\User::find($user_id);
if($user != null){
$current_summary = 0;
$req_month = \Input::get('req_month');
$req_year = \Input::get('req_year');
$month = $req_month ? $req_month : date('m');
$year = $req_year ? $req_year : date('Y');
$user_bp_pulse_data = \DB::select('SELECT
user_pulse.*, user_bp_pulse.`systolic`, user_bp_pulse.`diastolic`
FROM
user_pulse
INNER JOIN
(SELECT MAX(u.id) AS maxid
FROM user_pulse u WHERE u.user_id=? GROUP BY u.log_date) AS user_pulse2 ON
user_pulse.id = user_pulse2.maxid
INNER JOIN user_bp_pulse ON user_pulse.id = user_bp_pulse.`user_pulse_id`
WHERE user_pulse.`deleted_at` IS NULL
AND user_pulse.user_id = ?
AND MONTH(user_pulse.log_date) = ?
AND YEAR(user_pulse.log_date) = ?
AND user_bp_pulse.`deleted_at` IS NULL
ORDER BY user_pulse.`log_date` ASC', [$user_id, $user_id, $month, $year]);
$user_goals = $user->User_bp_pulse_goal()->where('user_id', $user_id)->get();
$bp_pulse_goal = [];
if($user_goals->count() > 0){
$bp_pulse_goal['bp_type'] = $user_goals['0']['goal_date'];
foreach ($user_goals as $key => $bp_pulse_data) {
if($bp_pulse_data->bp_type == 'systolic'){
$bp_pulse_goal['systolic'] = $bp_pulse_data->goal;
}else if($bp_pulse_data->bp_type == 'diastolic'){
$bp_pulse_goal['diastolic'] = $bp_pulse_data->goal;
}else if($bp_pulse_data->bp_type == 'heart_rate'){
$bp_pulse_goal['heart_rate'] = $bp_pulse_data->goal;
}
}
}
$result['goals_data'] = $bp_pulse_goal ? $bp_pulse_goal:null;
$result['bp_pulse_data'] = $user_bp_pulse_data;
$weekly_data_bp_pulse = $this->getAverageSystolicDystolicPulse($user_id, $req_month,$req_year,$user);
$result['avg_data'] = $weekly_data_bp_pulse;
}else{
$error = true;
$status_code = 404;
$result['message']='No Patient Found.';
}
}catch(\Exception $ex){
$error = true;
$status_code =$ex->getCode();
$result['error_code'] = $ex->getCode();
$result['error_message'] = $ex->getMessage();
}
}
return response()->json(['error' => $error,'response'=>$result],$status_code)
->setCallback(\Request::input('callback'));
}
public function getAverageSystolicDystolicPulse($user_id, $req_month, $req_year,$user){
$result= [];
// get weekly average data
if($user_id !="" && $user_id > 0){
$current_systolic = 0;
$month = $req_month ? $req_month : date('m');
$year = $req_year ? $req_year : date('Y');
$weekly_data = [];
$temp_date = $year."-".$month."-01";
$month_day = date("t", strtotime($temp_date));
$first_day_this_month = date('Y-m-d', strtotime('01-'.$month.'-'.$year)); // hard-coded '01' for first day
$last_day_this_month = date('Y-m-d', strtotime($month_day.'-'.$month.'-'.$year));
$month_weeks = array();
for($date = $first_day_this_month; $date <= $last_day_this_month; $date = date('Y-m-d', strtotime($date. ' + 7 days')))
{
$week = date('W', strtotime($date));
$year = date('Y', strtotime($date));
$from = date("Y-m-d", strtotime("{$year}-W{$week}-0"));
if($from < $first_day_this_month) $from = $first_day_this_month;
$to = date("Y-m-d", strtotime("{$year}-W{$week}-6"));
if($to > $last_day_this_month) $to = $last_day_this_month;
$month_weeks[] = array("start_date" => $from, "end_date" => $to );
}
$week_no = 1;
$total_sys = 0;
$total_dystolic = 0;
$total_pulse = 0;
for($j=0; $j < count($month_weeks); $j++){
$start_date = date('Y-m-d', strtotime($month_weeks[$j]['start_date']));
$end_date = date('Y-m-d', strtotime($month_weeks[$j]['end_date']));
$datetime1 = date_create($start_date);
$datetime2 = date_create($end_date);
$diff_days = date_diff($datetime1, $datetime2);
$diff_days = $diff_days->format('%d');
$diff_days = $diff_days +1;
$user_goals = $user->User_bp_pulse_goal()->where('user_id', $user_id)->get();
$bm_goal = [];
if($user_goals->count() > 0){
$bm_goal['bp_type'] = $user_goals['0']['goal_date'];
foreach ($user_goals as $key => $bm_data) {
if($bm_data->bp_type == 'systolic'){
$bm_goal['systolic'] = $bm_data->goal;
}else if($bm_data->bp_type == 'diastolic'){
$bm_goal['diastolic'] = $bm_data->goal;
}else if($bm_data->bp_type == 'heart_rate'){
$bm_goal['heart_rate'] = $bm_data->goal;
}
}
}
// get user goals data
$result['goals_data'] = $bm_goal ? $bm_goal:null;
$systolic_goal = $result['goals_data']['systolic'];
$diastolic_goal = $result['goals_data']['diastolic'];
$pulse_goal = $result['goals_data']['heart_rate'];
$sum = \DB::select('SELECT
user_pulse.*, user_bp_pulse.`systolic`, user_bp_pulse.`diastolic`,user_pulse.`pulse`
FROM
user_pulse
INNER JOIN
(SELECT MAX(u.id) AS maxid
FROM user_pulse u WHERE u.user_id=? GROUP BY u.log_date ) AS user_pulse2 ON
user_pulse.id = user_pulse2.maxid
INNER JOIN user_bp_pulse ON user_pulse.id = user_bp_pulse.`user_pulse_id`
WHERE (user_pulse.log_date BETWEEN ? AND ?)
AND user_pulse.user_id = ?
ORDER BY user_pulse.`log_date` ASC', [$user_id, $start_date,$end_date,$user_id]);
$systolic_sum_data = 0;
$diastolic_sum_data = 0;
$pulse_sum_data = 0;
foreach($sum as $key=>$value)
{
$systolic_sum_data += $value->systolic;
$diastolic_sum_data += $value->diastolic;
$pulse_sum_data += $value->pulse;
}
$systolic_sum = $systolic_sum_data;
$diastolic_sum = $diastolic_sum_data;
$pulse_sum = $pulse_sum_data;
$total_sys = $total_sys + $systolic_sum;
$total_dystolic = $total_dystolic + $diastolic_sum;
$total_pulse = $total_pulse + $pulse_sum;
$weekly_data_day_count = max($systolic_sum, $diastolic_sum, $pulse_sum);
if($diff_days > 0 && $weekly_data_day_count > 0){
$weekly_data1 = array();
$weekly_data1['total_systolic_weekly_avg'] = round( $systolic_sum/$diff_days , 2 );
$weekly_data1['total_diastolic_weekly_avg'] = round( $diastolic_sum/$diff_days , 2 );
$weekly_data1['total_pulse_weekly_avg'] = round( $pulse_sum/$diff_days , 2 );
$calculatePercent_systolic = calculateBpPercent($weekly_data1['total_systolic_weekly_avg'], $systolic_goal);
// compare goals data and set automatically css class.
if($calculatePercent_systolic > 95){
$weekly_data1['weekly_systolic_class_avg'] = "text-deficit";
}
elseif($weekly_data1['total_systolic_weekly_avg'] > 139){
$weekly_data1['weekly_systolic_class_avg'] = "text-excess";
}
else{
$weekly_data1['weekly_systolic_class_avg'] = "text-neutral";
}
// diastolic
$calculatePercent_diastolic = calculateBpPercent($weekly_data1['total_diastolic_weekly_avg'], $diastolic_goal);
if($calculatePercent_diastolic > 95){
$weekly_data1['weekly_diastolic_class_avg'] = "text-deficit";
}
elseif($weekly_data1['total_diastolic_weekly_avg'] > 89){
$weekly_data1['weekly_diastolic_class_avg'] = "text-excess";
}
else{
$weekly_data1['weekly_diastolic_class_avg'] = "text-neutral";
}
$calculatePercent_pulse_week = calculateBpPercent($weekly_data1['total_pulse_weekly_avg'], $pulse_goal);
if($calculatePercent_pulse_week > 95){
$weekly_data1['weekly_pulse_class_avg'] = "text-deficit";
}
elseif($weekly_data1['total_pulse_weekly_avg'] > 149 ){
$weekly_data1['weekly_pulse_class_avg'] = "text-excess";
}
else{
$weekly_data1['weekly_pulse_class_avg'] = "text-neutral";
}
$weekly_data[$j+1] = $weekly_data1;
}
else{
$weekly_data[$j+1] = [];
}
}
// return weekly data
$result['week_wise_avg'] = $weekly_data;
// intilization montly data
$monthly_average = [];
$monthly_average['monthly_avg_systolic'] = round( ($total_sys) / $month_day , 2);
$monthly_average['monthly_avg_dystolic'] = round( ($total_dystolic) / $month_day , 2);
$monthly_average['monthly_avg_pulse'] = round( ($total_pulse) / $month_day , 2);
// set automatically css class using compate goals systolic
$calculatePercent_systolic_month = calculateBpPercent($monthly_average['monthly_avg_systolic'], $systolic_goal);
if($calculatePercent_systolic_month > 95){
$monthly_average['monthly_systolic_class_avg'] = "text-deficit";
}elseif($monthly_average['monthly_avg_systolic'] > 139){
$monthly_average['monthly_systolic_class_avg'] = "text-excess";
}else{
$monthly_average['monthly_systolic_class_avg'] = "text-neutral";
}
//dystolic
$calculatePercent_dystolic_month = calculateBpPercent($monthly_average['monthly_avg_dystolic'], $diastolic_goal);
if($calculatePercent_dystolic_month > 95){
$monthly_average['monthly_dystolic_class_avg'] = "text-deficit";
}elseif($monthly_average['monthly_avg_dystolic'] > 89){
$monthly_average['monthly_dystolic_class_avg'] = "text-excess";
}else{
$monthly_average['monthly_dystolic_class_avg'] = "text-neutral";
}
//heart rate
$calculatePercent_pulse_month = calculateBpPercent($monthly_average['monthly_avg_pulse'], $pulse_goal);
if($calculatePercent_pulse_month > 95){
$monthly_average['monthly_pulse_class_avg'] = "text-deficit";
}elseif($monthly_average['monthly_avg_pulse'] > 149){
$monthly_average['monthly_pulse_class_avg'] = "text-excess";
}else{
$monthly_average['monthly_pulse_class_avg'] = "text-neutral";
}
$result['monthly_avg'] = $monthly_average;
}
// end: get weekly average data
return $result;
}
}
Stats
-
0 likes
- 6413 views