public function bellyButton() { $users = User::whereRaw('MONTH(birthday) =' . date('m'))->whereRaw('DAY(birthday) =' . date('d'))->where('membership_expires', '>=', date('Y-m-d'))->get(); $data = array(); foreach ($users as $user) { $data[] = array('recipient' => $user->email, 'first_name' => $user->first_name); } $this->cron->sendBellyButtonBirthdayCards($data); return view('cron.belly-button-birthdays', array('users' => $users)); }
public function anyLogin() { $all = request()->all(); if (isset($all['name']) && isset($all['psw'])) { $user = User::whereRaw('name = ?', [$all['name']])->first(); if (isset($user) && $user->psw == $all['psw']) { session(['currentUser' => $user]); return redirect()->action('Bupt\\UserController@anyIndex'); } } return view('bupt.user.login', request()->all()); }
public function getFightersFor($gender, $age_group, $belt, $weight) { $min_age = $this->age_categories[$age_group][0]; $max_age = $this->age_categories[$age_group][1]; $min_birthday = Helper::calculateBirthday($min_age); $max_birthday = Helper::calculateBirthday($max_age); $results = User::whereRaw('gender = ? AND belt = ? AND weight = ? AND dob BETWEEN ? AND ? ', array($gender, $belt, $weight, $max_birthday, $min_birthday))->orderBy('dob')->get(); // $queries = DB::getQueryLog(); // $last_query = end($queries); // var_dump($results->all(), $last_query, $age_group); return $results; }
public function index() { $user = User::whereRaw('tel = ? and password = ?', array(Input::get('tel'), md5(Input::get('password'))))->first(); if ($user) { $token = uniqid(); Session::put('token', $token); Session::put('uid', $user->id); $user->school; unset($user->choolId); return array('code' => 0, 'data' => $user); } else { return array('code' => 1, 'data' => 'tel or psw error'); } }
public function login() { $user = User::whereRaw('tel = ? and password = ?', array(Input::get('tel'), md5(Input::get('password'))))->first(); if ($user) { // if ($user->nickname == '' || $user->schoolId == '' || $user->avatarUrl == ''){ // return $this->outputError('请完善用户信息', 2); // } Session::put('uid', $user->_id); $user->school; unset($user->schoolId); $user->tags; return $this->output($user); } else { return $this->outputError('tel or psw error', 2); } }
/** * Return a json search result. * * @var $search * @return json */ public function search($search) { $usersL = []; $users = User::whereRaw("name LIKE '%" . $search . "%' OR email LIKE '%" . $search . "%'")->take(10)->get(); foreach ($users as $id => $user) { $usersL[] = ['id' => $user->id, 'name' => $user->name, 'email' => $user->email, 'score' => $user->score->value]; } return response()->json($usersL); }