/**
* Gets all user limited with page and limit
*
* @param int $page
* @param into $limit
* @return object
*/
public function getAll($page = 1, $limit = 40)
{
$users = $this->dc->qb()->select('*')->from($this->dc->p($this->config->get('foolz/foolframe', 'foolauth', 'table_name')), 't')->setMaxResults($limit)->setFirstResult($page * $limit - $limit)->execute()->fetchAll();
$users = User::forge($this->getContext(), $users);
$count = $this->dc->qb()->select('COUNT(*) as count')->from($this->dc->p($this->config->get('foolz/foolframe', 'foolauth', 'table_name')), 't')->execute()->fetch();
return ['result' => $users, 'count' => $count['count']];
}
public function save(array $data = [])
{
foreach ($data as $key => $item) {
$this->{$key} = $item;
}
$set = [];
foreach ($this->editable_fields as $filter) {
$set[$filter] = $this->{$filter};
}
if (!is_null($set['password']) && $set['password'] !== '') {
$set['password'] = password_hash($set['password'], PASSWORD_BCRYPT, ['cost' => 10]);
} else {
unset($set['password']);
}
$query = $this->dc->qb()->update($this->dc->p($this->config->get('foolz/foolframe', 'foolauth', 'table_name')))->where('id = :id')->setParameter(':id', $this->id);
foreach ($set as $key => $item) {
$query->set($this->dc->getConnection()->quoteIdentifier($key), $this->dc->getConnection()->quote($item));
}
$query->execute();
}
/**
* Remove the entry for a ban (unban)
*
* @return \Foolz\FoolFuuka\Model\Ban
*/
public function delete()
{
$this->dc->qb()->delete($this->dc->p('banned_posters'))->where('id = :id')->setParameter(':id', $this->id)->execute();
return $this;
}
