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'));
}
