public function confirm($email, $code)
{
$user = User::where('email', $email)->where('confirmation_code', $code)->first();
$user->confirmation_code = null;
$user->status = 'active';
return \Redirect::route('login');
}
public function show($email)
{
$student = User::where('type', 'student')->where('email', $email)->first();
if (empty($student)) {
abort(404);
}
if (Auth::user()->email != $student->email) {
abort(403);
}
return view('front.examresults.index')->with('result', $student->result()->first())->with('student', $student);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
foreach (['Aman', 'Kanat', 'Murat', 'Orozbek', 'Nurtilek', 'Toktobay'] as $name) {
$user = new User();
$user->first_name = $name;
$user->last_name = str_random();
$user->slug = str_slug($user->first_name . '-' . $user->last_name);
$user->type = 'student';
$user->email = $name . '@gmail.com';
$user->birth_date = date('Y-m-d');
$user->phone = random_int(8, 12);
$user->translateOrNew('ru')->education = str_random(20);
$user->translateOrNew('kg')->education = str_random(20);
$user->translateOrNew('ru')->job = str_random(10);
$user->translateOrNew('kg')->job = str_random(10);
$user->translateOrNew('ru')->bio = str_random(500);
$user->translateOrNew('kg')->bio = str_random(500);
$user->status = 'active';
$user->save();
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function import(Request $request)
{
$this->validate($request, ['csv' => 'required']);
$file = $request->file('csv');
if ('csv' != $file->getClientOriginalExtension()) {
return redirect()->back()->withErrors('incorrect_type');
}
$csv = array_map('str_getcsv', file($file->getRealPath()));
array_shift($csv);
if ($csv) {
ExamResult::truncate();
foreach ($csv as $row) {
if ($user = User::where('email', $row[0])->first()) {
$examresult = new ExamResult();
$examresult->student_id = $user->id;
$examresult->points = $row[1];
$examresult->save();
}
}
}
return redirect(route('admin.examresult.index'));
}
public function studentList()
{
$users = User::where('type', 'student')->paginate(config('college.users_per_page'));
return view('front.users.list', compact('users'))->with('list', 'student');
}
public function import(Request $request)
{
$this->validate($request, ['csv' => 'required']);
$file = $request->file('csv');
if ('csv' != $file->getClientOriginalExtension()) {
return redirect()->back()->withErrors('incorrect_type');
}
$csv = array_map('str_getcsv', file($file->getRealPath()));
array_shift($csv);
if ($csv) {
foreach ($csv as $row) {
if (!User::where('email', $row[0])->first()) {
$newUser = new User();
$newUser->email = $row[0];
$newUser->first_name = $row[1];
$newUser->last_name = $row[2];
$newUser->type = $row[3];
$newUser->status = 'active';
$newUser->save();
}
}
}
return redirect(route('admin.user.index'));
}
