/** * 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); } }
/** * Display a listing of the resource. * * @return Response */ public function index() { $competition_question = CompetitionQuestion::with('competitiongroupusers')->orderBy('id', 'desc')->first(); $groupuserlist = $competition_question->competitiongroupusers; $groupusers = array(); $group = array(); if ($groupuserlist) { foreach ($groupuserlist as $key => $rows) { $group[$rows->group_name][] = $rows; } $groupusers = $group; } // return response()->json($response); return view('groupusers.list', compact('groupusers')); }
/** * Store a newly created User in storage. * POST /users * * @param Request $request * * @return Response */ public function store(Request $request) { if (sizeof(User::$rules) > 0) { $validator = $this->validateRequestOrFail($request, User::$rules); if ($validator) { return $validator; } } $input = $request->all(); $exist = User::where('username', $input['username'])->first(); if ($exist) { return response()->json(['error' => 'This username is already exist.', 'error_mm' => 'အမည္တူရိွေနပါသည္။ အေနာက္တြင္ ဂဏန္း တစ္ခုခုထည့္ပါ။ ဥပမာ။။ Nyo Nyo1'], 400); } $input['objectId'] = str_random(10); $input['password'] = bcrypt($input['password']); $users = $this->userRepository->create($input); if (isset($input['tlg_city_address']) && $input['tlg_city_address'] && isset($input['isTlgTownshipExit']) && $input['isTlgTownshipExit']) { $role = new Role(); $role->name = 'TLGUSER'; $role->userId = $users->objectId; $role->save(); $users['role'] = $role->name; } else { $users['role'] = 'User'; } //Check for game $competition_question = CompetitionQuestion::where('start_date', '>', date('Y-m-d H:i:s'))->orwhere('end_date', '>', date('Y-m-d H:i:s'))->orderBy('id', 'desc')->first(); //return response()->json($competition_question); if ($competition_question) { $group_user = CompetitionGroupUser::where('competition_question_id', $competition_question->id)->orderBy('id', 'desc')->first(); //dd($group_user); if ($competition_question->user_count > 1) { $group_user_count = CompetitionGroupUser::where('competition_question_id', $competition_question->id)->where('group_name', $group_user->group_name)->count(); if ($group_user_count == $competition_question->user_count) { //Create New Group $group_name = explode(" - ", $group_user->group_name); if (count($group_name) > 1) { $competition_group_user = new CompetitionGroupUser(); $competition_group_user->group_name = $group_name[0] . ' - ' . ($group_name[1] + 1); $competition_group_user->group_city = isset($users->tlg_city_address) ? $users->tlg_city_address : ''; $competition_group_user->user_id = $users->id; $competition_group_user->username = $users->username; $competition_group_user->phone = $users->phoneNo; $competition_group_user->profile_img = isset($users->user_profile_img) ? $users->user_profile_img : ''; $competition_group_user->competition_question_id = $competition_question->id; $competition_group_user->save(); } } else { //Create in Existing Group $competition_group_user = new CompetitionGroupUser(); $competition_group_user->group_name = $group_user->group_name; $competition_group_user->group_city = isset($users->tlg_city_address) ? $users->tlg_city_address : ''; $competition_group_user->user_id = $users->id; $competition_group_user->username = $users->username; $competition_group_user->phone = $users->phoneNo; $competition_group_user->profile_img = isset($users->user_profile_img) ? $users->user_profile_img : ''; $competition_group_user->competition_question_id = $competition_question->id; $competition_group_user->save(); } } else { $group_name = explode(" - ", $group_user->group_name); if (count($group_name) > 1) { $competition_group_user = new CompetitionGroupUser(); $competition_group_user->group_name = $group_name[0] . ' - ' . ($group_name[1] + 1); $competition_group_user->group_city = isset($users->tlg_city_address) ? $users->tlg_city_address : ''; $competition_group_user->user_id = $users->id; $competition_group_user->username = $users->username; $competition_group_user->phone = $users->phoneNo; $competition_group_user->profile_img = isset($users->user_profile_img) ? $users->user_profile_img : ''; $competition_group_user->competition_question_id = $competition_question->id; $competition_group_user->save(); } } } return $this->sendResponse($users->toArray(), "User saved successfully"); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { try { DB::beginTransaction(); $question = new CompetitionQuestion(); $question->question = $request->question; $question->question_mm = $request->question_mm; $question->description = $request->description; $question->description_mm = $request->description_mm; $question->instruction_about_game = $request->instruction_about_game; $question->start_date = $request->start_date; $question->end_date = $request->end_date; $question->save(); $users = User::all(); if ($users) { $group_users = array(); foreach ($users as $i => $user) { //Grouping if (isset($user['tlg_city_address']) && $user['tlg_city_address']) { $group_users[$user['tlg_city_address']][] = $user; } } $group_index = 1; $i = 0; foreach ($group_users as $key => $city) { foreach ($city as $user) { if ($i % 5 == 0) { $group_name = 'Group - ' . $group_index++; } $group_user = new CompetitionGroupUser(); $group_user->group_name = $group_name; $group_user->user_id = $user['id']; $group_user->username = $user['username']; $group_user->phone = $user['phoneNo']; $group_user->profile_img = isset($user['user_profile_img']) ? json_encode($user['user_profile_img']) : null; $group_user->group_city = $key; $group_user->competition_question_id = $question->id; $group_user->save(); $i++; } } } else { DB::rollBack(); return response()->json('Something went wrong in parse.', 400); } DB::commit(); } catch (Exception $e) { DB::rollBack(); return response()->json('Something went wrong.', 400); } return response()->json($question); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { CompetitionQuestion::where('id', $id)->delete(); return redirect('/admin/competition-question')->withMessages('Successfully deleted.'); }
/** * Show the form for editing the specified MutipleQuestion. * * @param int $id * * @return Response */ public function edit($id) { $mutipleQuestion = $this->mutipleQuestionRepository->find($id); if (empty($mutipleQuestion)) { Flash::error('MutipleQuestion not found'); return redirect(route('mutipleQuestions.index')); } $question = CompetitionQuestion::orderBy('id', 'desc')->get(); $questions = []; foreach ($question as $key => $value) { $questions[$value->id] = $value->question; } return view('mutipleQuestions.edit')->with(['mutipleQuestion' => $mutipleQuestion, 'questions' => $questions]); }
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(); $user_count = CompetitionQuestion::where('id', $request->question_id)->pluck('user_count'); foreach ($group_list as $key => $value) { $profile_img = json_decode($value->profile_img, true); if ($profile_img) { $group_list[$key]['image_url'] = $profile_img['url']; } else { $group_list[$key]['image_url'] = "http://url"; } $group_list[$key]['total_has_answer'] = count($group_list) * $user_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); }