/**
* 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);
}
