public function viewSearch(Request $request)
{
$input = $request->all();
$questions = Question::where('question', 'LIKE', '%' . $input['search'] . '%')->orWhere('answer', 'LIKE', '%' . $input['search'] . '%')->select('question', 'answer')->get();
$specialquestions = Specialquestion::where('question', 'LIKE', '%' . $input['search'] . '%')->orWhere('answer', 'LIKE', '%' . $input['search'] . '%')->select('question', 'answer')->get();
return view('admin/search')->with(['questions' => $questions, 'specialquestions' => $specialquestions, 'string' => $input['search']]);
}
public function submitSpecialQuiz(Request $request)
{
$input = $request->all();
$inputs = [];
foreach ($input as $key => $value) {
if (substr($key, 0, strlen('answer')) === 'answer') {
$inputs[$key] = 'required';
$question_id = explode('_', $key)[1];
}
}
$inputs['banker'] = ['max:5'];
$this->validate($request, $inputs);
$year = date('Y');
$month = date('n');
$day = date('j');
$user_id = Auth::user()->id;
foreach ($inputs as $key => $validation) {
if (substr($key, 0, strlen('answer')) === 'answer') {
$question_id = explode('_', $key)[1];
$specialquestion = Specialquestion::find($question_id);
$specialquiz = Specialquiz::find($specialquestion->quiz_id);
if (!($specialquiz->year == $year && $specialquiz->month == $month && $specialquiz->day == $day)) {
return redirect()->route('specialquiz');
}
$answer = Specialanswer::where('question_id', $question_id)->where('user_id', $user_id)->where('submitted', 1)->get();
if (isset($input['banker']) && in_array($question_id, $input['banker'])) {
$banker = 1;
} else {
$banker = 0;
}
if (!count($answer)) {
Specialanswer::create(['question_id' => $question_id, 'user_id' => $user_id, 'answer' => $input[$key], 'banker' => $banker, 'submitted' => 1]);
}
}
}
return redirect()->route('specialquiz');
}