public function get_featured_docs()
{
try {
$featured = Featured_doc::all();
foreach ($featured as $f_doc) {
$doc_details = Doctors::whereId($f_doc->did)->first();
$temp['doc_id'] = $doc_details->id;
$temp['doc_first_name'] = $doc_details->first_name;
$temp['doc_last_name'] = $doc_details->last_name;
$temp['doc_address_2'] = $doc_details->address_2;
$temp['doc_city'] = $doc_details->city;
$img = Images::whereUser_id($doc_details->user_id)->first();
$temp['image_path'] = $img->image_path;
$featured_main[] = $temp;
}
} catch (Exception $e) {
$this->LogError('Get Featured Doctors Function', $e);
}
return $featured_main;
}
public function featuredDoctorUpdate(Request $request)
{
$count = Input::get("count");
//featured doctor id
$doc_id = Input::get("doc_id");
//doctor id
try {
//adding a new featured doctor field with a doctor
if ($count == "new") {
Featured_doc::create(['did' => $doc_id]);
} else {
//upadate the featured doctor table reacord with a new doctor id
DB::table('featured_doc')->where('fid', $count)->update(['did' => $doc_id]);
}
//get all the feateured doctors
$featured_doc = DB::table('featured_doc')->join('doctors', 'featured_doc.did', '=', 'doctors.id')->orderBy('fid', 'asc')->get();
//Get all the specialization types in the specializations 5 columns
$filter_spec = DB::select('SELECT spec_1 FROM
(
SELECT spec_1 AS spec_1 FROM specialization where spec_1 != ""
UNION
SELECT spec_2 AS spec_1 FROM specialization where spec_2 != ""
UNION
SELECT spec_3 AS spec_1 FROM specialization where spec_3 != ""
UNION
SELECT spec_4 AS spec_1 FROM specialization where spec_4 != ""
UNION
SELECT spec_5 AS spec_1 FROM specialization where spec_5 != ""
) tt WHERE spec_1 IS NOT NULL');
//$filter_treat= DB::table('treatments')->select('treat_1')->groupBy('treat_1')->get();
$filter_treat = DB::select('SELECT treat_1 FROM
(
SELECT treat_1 AS treat_1 FROM treatments where treat_1 != ""
UNION
SELECT treat_2 AS treat_1 FROM treatments where treat_2 != ""
UNION
SELECT treat_3 AS treat_1 FROM treatments where treat_3 != ""
UNION
SELECT treat_4 AS treat_1 FROM treatments where treat_4 != ""
UNION
SELECT treat_5 AS treat_1 FROM treatments where treat_5 != ""
) tt WHERE treat_1 IS NOT NULL');
//selct all the doctors not in featured doctor table
$reg_doc = DB::select(DB::raw('SELECT * FROM doctors WHERE id NOT IN (SELECT did FROM featured_doc)'));
//pass db results to the home12 page
$HTMLView = (string) view('costomize_home_views.home12')->with(['featured_doc1' => $featured_doc, 'reg_doctor' => $reg_doc, 'filter_spec' => $filter_spec, 'filter_treat' => $filter_treat]);
$res['com_data'] = $HTMLView;
return response()->json($res);
} catch (Exception $e) {
$HTMLView = (string) view('errors.adminError');
$res['com_data'] = $HTMLView;
return response()->json($res);
}
}