public function GetCommentsOnDoctor()
{
$doc = json_decode($_COOKIE['doctor_user'], true);
$doc_id = $doc[0]['doc_id'];
// this should be replaced by $COOKIE reference
try {
$comments = Comments::whereDoctor_id($doc_id)->orderBy('id', 'DESC')->limit(20)->get();
foreach ($comments as $com) {
$pat = Patients::whereUser_id($com->user_id)->first();
$img = Images::whereUser_id($pat->user_id)->first();
$main_ob['com_data'] = $com;
$main_ob['pat_first_name'] = $pat->first_name;
$main_ob['pat_last_name'] = $pat->last_name;
$main_ob['pat_img'] = $img->image_path;
$res[] = $main_ob;
}
} catch (Exception $e) {
$this->LogError('AjaxController Get Comments On Doctor Function', $e);
}
return response()->json($res);
}
public function update_account(Request $request)
{
//dd($request);
if (isset($_COOKIE['user'])) {
$user = json_decode($_COOKIE['user'], true);
try {
$user_ob = User::find($user[0]['id']);
$user_ob->email = Input::get('username');
$user_ob->save();
$patient_ob = Patients::whereUser_id($user[0]['id'])->first();
//$patient_ob->first_name = Input::get('first_name');
//$patient_ob->last_name = Input::get('last_name');
$patient_ob->contact_number = Input::get('contact_no');
$patient_ob->email = Input::get('email');
$patient_ob->save();
/* Check Whether New Image Upload is Available or not */
if (isset(Input::file('profile_img')[0])) {
/* This function will upload image */
self::upload_image($request, $user[0]['id']);
/* Updates Database Images table Image_path with new path */
$img_ob = Images::whereUser_id($user[0]['id'])->first();
$img_ob->image_path = "profile_images/user_images/user_profile_img_" . $user[0]['id'] . ".png";
$img_ob->save();
}
/* Updates Cookie Details */
//$user_cookie = array(['id' => $user[0]['id'], 'first_name' => Input::get('first_name'), 'last_name' => Input::get('last_name')]);
//setcookie('user', json_encode($user_cookie), time() + 3600); // Cookie is set for 1 hour
} catch (Exception $e) {
$this->LogError('Update User Account', $e);
}
return Redirect::to('/myaccount/' . $user[0]['first_name']);
} else {
return Redirect::to('/');
}
}
public function graph1Count()
{
try {
//get the count af users accordig to registered dates
$graph1 = DB::select(DB::raw('SELECT DATE(reg_date) AS y,COUNT(*) AS item1 FROM patients GROUP BY DATE(reg_date)'));
//get the count af doctors accordig to registered dates
$graph2 = DB::select(DB::raw('SELECT DATE(reg_date) AS y,COUNT(*) AS item1 FROM doctors GROUP BY DATE(reg_date)'));
//get the count af doctors accordig to registered dates and doctor types
$graph3 = DB::select(DB::raw('SELECT DATE(reg_date) AS y ,SUM(CASE WHEN doc_type = "FORMAL" THEN 1 ELSE 0 END) AS item1, SUM(CASE WHEN doc_type = "NON_FORMAL" THEN 1 ELSE 0 END) AS item2 FROM doctors GROUP BY DATE(reg_date)'));
//get all user count
$Patients = Patients::all();
//Get formal doctor count
$Formal_doctors = Formal_doctors::all();
//Get non formal doctor count
$Non_Formal_doctors = Non_Formal_doctors::all();
//get the number of results in each quary result
$graph41 = sizeof($Patients);
$graph42 = sizeof($Formal_doctors);
$graph43 = sizeof($Non_Formal_doctors);
//pass the values through json
$res['graph_1'] = $graph1;
$res['graph_2'] = $graph2;
$res['graph_3'] = $graph3;
$res['graph_41'] = $graph41;
$res['graph_42'] = $graph42;
$res['graph_43'] = $graph43;
} catch (Exception $e) {
$this->LogError('AdminController Register_Page Function', $e);
}
return response()->json($res);
}
public function user_remove(Request $request, $user_id)
{
Patients::where('id', $user_id)->delete();
$patients = Patients::orderBy('first_name', 'desc')->get();
$patients1 = Patients::orderBy('reg_date', 'desc')->get();
$HTMLView = (string) view('admin_patients_views.home_1')->with(['comment' => $patients, 'comment1' => $patients1]);
$res['page'] = $HTMLView;
return response()->json($res);
}
public function forgotten_password_email(Request $request)
{
try {
/* Get Patients table First Name and Last Name Field */
$patient = Patients::whereEmail(Input::get('reset_ps_email'))->first();
/* Generate Random Key in Upper Case Letters with 6 characters */
$acc_code = strtoupper(substr(md5(rand()), 0, 6));
$subject['sub'] = "Reset Password at eAyurveda.lk";
$subject['email'] = Input::get('reset_ps_email');
$subject['name'] = $patient->first_name . ' ' . $patient->last_name;
Mail::send('emails.password_reset_mail', ['access_code' => $acc_code], function ($message) use($subject) {
$message->to($subject['email'], $subject['name'])->subject($subject['sub']);
});
$data['CHECK'] = "YES";
$data['EMAIL'] = Input::get('reset_ps_email');
$data['ACCESS_KEY'] = $acc_code;
} catch (Exception $e) {
$this->LogError('AjaxController Forgotten Password Email Function', $e);
}
return response()->json($data);
}
