public function get_community_suggestions()
{
try {
$com_sug = Doctors::whereDoc_type('NON_FORMAL')->orderBy('id', 'DESC')->limit(5)->get();
foreach ($com_sug as $doc) {
$temp['doc_id'] = $doc->id;
$temp['doc_first_name'] = $doc->first_name;
$temp['doc_last_name'] = $doc->last_name;
$temp['doc_address_2'] = $doc->address_2;
$temp['doc_city'] = $doc->city;
/* Get suggested User */
$non_formal = Non_Formal_doctors::whereDoctor_id($doc->id)->first();
$user = User::whereId($non_formal->suggested_user)->first();
$temp['sug_user_name'] = $user->name;
/* Get suggested User Image */
$img = Images::whereUser_id($user->id)->first();
$temp['image_path'] = $img->image_path;
$featured_main[] = $temp;
}
} catch (Exception $e) {
$this->LogError('Get Community Suggestion Doctors Function', $e);
}
return $featured_main;
}
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);
}