public function Index() { $settings_value = Settings::all(); $expiresAt = Carbon::now()->addMinutes(10); if (Cache::has('TimeControlling')) { $previous_renew_time = Cache::get('TimeControlling'); $diffMinutes = $previous_renew_time->diffInMinutes(); if ($diffMinutes >= 10) { Cache::put('TimeControlling', Carbon::now(), $expiresAt); } } else { Cache::add('TimeControlling', Carbon::now(), $expiresAt); $diffMinutes = 0; } $subject_list_1 = SubjectList::where('subject_id', '<', 20000)->get(); for ($i = 0; $i < 9; $i++) { if (Cache::has($subject_list_1[$i]->subject_id)) { if ($diffMinutes >= 10) { Cache::put($subject_list_1[$i]->subject_id, RegisterSubjects::where('reg_subject_1', $subject_list_1[$i]->subject_id)->count(), $expiresAt); } $subject_count_1[$subject_list_1[$i]->subject_id] = Cache::get($subject_list_1[$i]->subject_id, '請重新整理一次'); } else { Cache::add($subject_list_1[$i]->subject_id, RegisterSubjects::where('reg_subject_1', $subject_list_1[$i]->subject_id)->count(), $expiresAt); $subject_count_1[$subject_list_1[$i]->subject_id] = Cache::get($subject_list_1[$i]->subject_id, '請重新整理一次'); } } $subject_list_2 = SubjectList::where('subject_id', '>', 20000)->get(); for ($i = 0; $i < 5; $i++) { if (Cache::has($subject_list_2[$i]->subject_id)) { if ($diffMinutes >= 10) { Cache::put($subject_list_2[$i]->subject_id, RegisterSubjects2::where('reg_subject_2', $subject_list_2[$i]->subject_id)->count(), $expiresAt); } $subject_count_2[$subject_list_2[$i]->subject_id] = Cache::get($subject_list_2[$i]->subject_id, '請重新整理一次'); } else { Cache::add($subject_list_2[$i]->subject_id, RegisterSubjects2::where('reg_subject_2', $subject_list_2[$i]->subject_id)->count(), $expiresAt); $subject_count_2[$subject_list_2[$i]->subject_id] = Cache::get($subject_list_2[$i]->subject_id, '請重新整理一次'); } } return view('index', compact('subject_list_1', 'subject_list_2', 'subject_count_1', 'subject_count_2', 'settings_value')); }
public function startup() { parent::startup(); $this->template->setting = $this->setting = $this->settings->findAllByKeys(); $this->template->wfont = $this->getHttpRequest()->getCookie('wfont'); }
public function selectSubjectUpdate(Requests\SelectSubjectCheck $request) { $settings_value = Settings::all(); if ($settings_value[0]->value > Carbon::now() && $settings_value[1]->value < Carbon::now()) { return view('errors.RegisterInValid'); } $account_details = RegisterUsers::where('email', Auth::user()->email)->get(); $first_day_data_exist = RegisterSubjects::where('account_id', $account_details[0]->id)->count(); $second_day_data_exist = RegisterSubjects2::where('account_id', $account_details[0]->id)->count(); /* If User Doesn't Select the Subject, the Data Would Not Be Saved */ /* If User Has Filled the Form Before, We Will Update the Previous Data */ /* First Day Registration Data */ if ($first_day_data_exist == 1) { if ($request->get('reg_subject_1') != 0) { RegisterSubjects::where('account_id', $account_details[0]->id)->update(['reg_subject_1' => $request->get('reg_subject_1')]); } else { RegisterSubjects::where('account_id', $account_details[0]->id)->delete(); } } else { if ($first_day_data_exist == 0 && $request->get('reg_subject_1')) { $input = new RegisterSubjects(); $input->account_id = $account_details[0]->id; // 'Cause the variable account_id is a array. $input->reg_subject_1 = $request->get('reg_subject_1'); $input->already_pick_1 = 0; $input->ps = 'NORMAL'; $input->priority = 0; $input->reg_time = Carbon::Now(); $input->save(); } } /* If User Doesn't Select the Subject, the Data Would Not Be Saved */ /* If User Has Filled the Form Before, We Will Update the Previous Data */ /* Second Day Registration Data */ if ($second_day_data_exist == 1) { if ($request->get('reg_subject_2') != 0) { RegisterSubjects2::where('account_id', $account_details[0]->id)->update(['reg_subject_2' => $request->get('reg_subject_2')]); } else { RegisterSubjects2::where('account_id', $account_details[0]->id)->delete(); } } else { if ($second_day_data_exist == 0 && $request->get('reg_subject_2')) { $input = new RegisterSubjects2(); $input->account_id = $account_details[0]->id; // 'Cause the variable account_id is a array. $input->reg_subject_2 = $request->get('reg_subject_2'); $input->already_pick_2 = 0; $input->ps = 'NORMAL'; $input->priority = 0; $input->reg_time = Carbon::Now(); $input->save(); } } $user_habits_exist = RegisterHabits::where('account_id', $account_details[0]->id)->count(); if ($user_habits_exist) { return redirect()->intended('/general'); } else { return redirect()->intended('/general/select-habits'); } }
public function OldMemberQuery() { $reg_start = Settings::where('id', 1)->get(); $user_details = RegisterUsers::where('reg_time', '<', $reg_start[0]->value)->get(); return view('console.old-member-query', compact('user_details')); }