Example #1
0
 /**
  * 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']];
 }