/** * Display a listing of the MutipleAnswer. * * @return Response */ public function index() { $mutipleAnswers = null; $competition_question = CompetitionQuestion::orderBy('id', 'desc')->first(); if ($competition_question) { $multipleQuestionId = MutipleQuestion::where('question_id', $competition_question->id)->lists('id'); if (count($multipleQuestionId) > 0) { $mutipleAnswers = MutipleAnswer::with(['groupUser.user', 'competitionAnswers', 'multipleQuestion'])->wherein('mutiple_question_id', $multipleQuestionId)->get(); } else { $mutipleAnswers = MutipleAnswer::with(['groupUser.user', 'competitionAnswers', 'multipleQuestion'])->get(); } return view('mutipleAnswers.index')->with('mutipleAnswers', $mutipleAnswers); } }
public function search($input) { $query = MutipleQuestion::query(); $columns = Schema::getColumnListing('mutipleQuestions'); $attributes = array(); foreach ($columns as $attribute) { if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } else { $attributes[$attribute] = null; } } return [$query->get(), $attributes]; }
public function correct($id) { $multipleAnswer = MutipleAnswer::find($id); if ($multipleAnswer) { $competitionAnswer = new CompetitionAnswer(); $multipleQuestion = MutipleQuestion::where('id', $multipleAnswer->mutiple_question_id)->first(); $competitionAnswer->question_id = $multipleQuestion->question_id; $competitionAnswer->competition_group_user_id = $multipleAnswer->user_id; $competitionAnswer->mutiple_answer_id = $multipleAnswer->id; $competitionAnswer->answer = $multipleAnswer->answer; $competitionAnswer->answer_mm = $multipleAnswer->answer; $competitionAnswer->status = 1; $competitionAnswer->correct = 1; $competitionAnswer->save(); return redirect(URL::previous()); } }
/** * Show the form for editing the specified MutipleOption. * * @param int $id * * @return Response */ public function edit($id) { $mutipleOption = $this->mutipleOptionRepository->find($id); if (empty($mutipleOption)) { Flash::error('MutipleOption not found'); return redirect(route('mutipleOptions.index')); } $mutipleQuestion = MutipleQuestion::orderBy('id', 'desc')->get(); $mutipleQuestions = []; foreach ($mutipleQuestion as $key => $value) { $mutipleQuestions[$value->id] = $value->question; } return view('mutipleOptions.edit')->with(['mutipleOption' => $mutipleOption, 'mutipleQuestions' => $mutipleQuestions]); }
public function getGroupUser(Request $request) { $validator = Validator::make($request->all(), ['question_id' => 'required', 'user_id' => 'required']); if ($validator->fails()) { if ($validator->errors()->has('question_id')) { return response()->json($validator->errors()->first('question_id'), 400); } if ($validator->errors()->has('group_user_id')) { return response()->json($validator->errors()->first('user_id'), 400); } } $group_name = CompetitionGroupUser::where('competition_question_id', $request->question_id)->where('user_id', $request->user_id)->pluck('group_name'); $group_user_ids = CompetitionGroupUser::where('group_name', $group_name)->where('competition_question_id', $request->question_id)->lists('id'); $group_list = CompetitionGroupUser::with('answer')->where('competition_question_id', $request->question_id)->where('group_name', $group_name)->get(); $muti_question_count = MutipleQuestion::where('question_id', $request->question_id)->count(); foreach ($group_list as $key => $value) { $profile_img = json_decode($value->profile_img, true); if ($profile_img) { $group_list[$key]['image_url'] = isset($profile_img['url']) ? $profile_img['url'] : ''; } else { $group_list[$key]['image_url'] = "http://url"; } $group_list[$key]['limited_answer'] = $muti_question_count; $group_list[$key]['total_has_answer'] = count($group_list) * $muti_question_count; $group_list[$key]['current_has_answer'] = MutipleAnswer::wherein('user_id', $group_user_ids)->count(); $group_list[$key]['init_answer'] = null; foreach ($group_list[$key]['answer'] as $i => $value) { if ($i == 0) { $group_list[$key]['init_answer'] = $value; } } } return response()->json($group_list); }