/**
* Gets the records for a specific page and limit
* @param mixed/int $limit Set to all if you want to retrieve all records.
* @param int $page The page you want to retrieve
* @return \stdClass The records from the query
*/
public function get_records($limit = 25, $page = 1)
{
//init
$this->limit = $limit;
$this->pageNumber = $page;
//Set the limit
$query = $limit == 'all' ? $this->sqlString : $this->sqlString . ' limit ' . ($this->pageNumber - 1) * $this->limit . ', ' . $this->limit;
$records = DatabaseUtil::get($this->mysqli, $query, $this->passValues);
//Make an object of the result so that it is more organized
$result = new \stdClass();
$result->records = $records;
$result->page = $this->pageNumber;
$result->limit = $this->limit;
$result->total = $this->totalRecords;
return $result;
}
/**
* Logs a user in
* @param string $userEmail Email address the user is trying to login as
* @param string $password The password the user is trying to login as
* @return bool|string Returns false if the login is successful or returns an error string if unsuccessful
*/
public static function login($userEmail, $password)
{
//Retrieve information from the users table
if (!($conn = DatabaseUtil::db_connect(DatabaseUtil::DATABASE_USER))) {
return 'Database Error contact administration.';
}
if ($result = DatabaseUtil::get($conn, 'SELECT * FROM users WHERE emailAddress=? LIMIT 1', [$userEmail])) {
//check the password
$result = array_shift($result);
if (self::hash($password, $result->salt) == $result->password) {
SessionUtil::session_set('loggedIn', self::user_token($result->salt));
SessionUtil::session_set('user', serialize($result));
} else {
return 'Email or Password are incorrect.';
}
} else {
return 'Email or Password are incorrect.';
}
}
private function add_user()
{
$user = new \stdClass();
$user->userName = param('txtName');
$user->emailAddress = param('txtEmail');
$user->company = param('txtCompany');
$user->salt = AuthenticationUtil::salt();
$user->password = AuthenticationUtil::hash(param('txtPassword'), $user->salt);
$user->privs = array_sum(param('cbxPrivs'));
//Make connection
if (!($dbConnection = DatabaseUtil::db_connect(DatabaseUtil::DATABASE_USER))) {
return 'Error with database connection. Contact DB admin. ';
}
if (!($error = DatabaseUtil::insert($dbConnection, 'users', $user))) {
return 'User Added';
} else {
return $error;
}
}