public function getUserById($userId)
{
$result = User::whereId($userId)->first();
//first() function in sql returns the first value of the selected column
return $result;
}
public function checkToken(Request $data, $token)
{
$objModelUser = User::getInstance();
$whereForSearchToken = array('rawQuery' => 'pd_reset_token = ?', 'bindParams' => [$token]);
$userDetails = $objModelUser->getUserWhere($whereForSearchToken);
if ($userDetails) {
if ($data->isMethod('post')) {
$newPassword = $data->input('newpassword');
$newPassword_confirmation = $data->input('newpassword_confirmation');
$this->validate($data, ['newpassword' => 'required|min:3|confirmed', 'newpassword_confirmation' => 'required|min:3'], ['newpassword.required' => 'New Password Required']);
$whereForUpdateUser = array('rawQuery' => 'pd_reset_token = ?', 'bindParams' => [$token]);
$dataForUpdateUser = array('password' => Hash::make($newPassword), 'pd_reset_token' => '');
$updated = $objModelUser->updateUserWhere($dataForUpdateUser, $whereForUpdateUser);
return redirect('admin/login')->with(['message' => 'your password has successfully updated. please login now with the new password']);
}
return view('Admin::admin.resetpassword');
} else {
echo 'This link has expired';
}
}
public function rejectedUsersAjaxHandler(Request $request)
{
$objModelUser = User::getInstance();
$whereForUsers = array('rawQuery' => 'role = 1 and status = 3');
$allRejectedUsers = $objModelUser->getAllUsersWhere($whereForUsers);
// return view('Admin::users.rejectedusers', ['rejected_users' => $allRejectedusers]);
// $var= print_r(json_decode(json_encode($allRejectedUsers), true));
// DB::statement(DB::raw('set @rownum=0'));
// $users = DB::table('users')
// ->select([ DB::raw('@rownum := @rownum + 1 AS rownum'), 'name', 'lastname', 'username', 'email'])
// ->where('role', '=', '1')
// ->where('status', '=', '3')
// ;
// dd($allRejectedUsers);
$users = new Collection();
$allRejectedUsers = json_decode(json_encode($allRejectedUsers), true);
// dd($allRejectedUsers);
$i = 0;
foreach ($allRejectedUsers as $valueRS) {
$users->push(['id' => ++$i, 'fullname' => $valueRS['name'] . $valueRS['lastname'], 'username' => $valueRS['username'], 'email' => $valueRS['email']]);
}
return Datatables::of($users)->make(true);
}