public function selectTrafficUpdate(Requests\TrafficCheck $request) { $account_details = RegisterUsers::where('email', Auth::user()->email)->get(); $habit_exist = RegisterHabits::where('account_id', $account_details[0]->id)->count(); if ($habit_exist == 1) { RegisterHabits::where('account_id', $account_details[0]->id)->update(['traffic' => $request->get('traffic')]); } else { if ($habit_exist == 0) { $input = new RegisterHabits(); $input->account_id = $account_details[0]->id; // 'Cause the variable account_id is a array. $input->traffic = $request->get('traffic'); $input->save(); } } return redirect()->intended('/general'); }
public function Console() { $subject_list_1 = SubjectList::where('subject_id', '<', 20000)->get(); for ($i = 0; $i < 9; $i++) { $subject_count_1[$subject_list_1[$i]->subject_id] = RegisterSubjects::where('reg_subject_1', $subject_list_1[$i]->subject_id)->count(); $subject_count_1[$subject_list_1[$i]->subject_id] = RegisterSubjects::where('reg_subject_1', $subject_list_1[$i]->subject_id)->count(); } $subject_list_2 = SubjectList::where('subject_id', '>', 20000)->get(); for ($i = 0; $i < 5; $i++) { $subject_count_2[$subject_list_2[$i]->subject_id] = RegisterSubjects2::where('reg_subject_2', $subject_list_2[$i]->subject_id)->count(); $subject_count_2[$subject_list_2[$i]->subject_id] = RegisterSubjects2::where('reg_subject_2', $subject_list_2[$i]->subject_id)->count(); } $meat_count = RegisterHabits::where('meat_veg', 1)->count(); $veg_count = RegisterHabits::where('meat_veg', 0)->count(); $total_count = RegisterUsers::where('type', '<>', 'super')->count(); $total_count_with_reg_complete = RegisterDetails::where('phone', '!=', '')->count() - 1; $settings_value = Settings::all(); return view('console.index', compact('settings_value', 'total_count_with_reg_complete', 'meat_count', 'veg_count', 'subject_list_1', 'subject_list_2', 'subject_count_1', 'subject_count_2', 'total_count')); }