public function getPositions($options = []) { $options += ['search' => false] + Paginate::$defaultOptions; $paginate = new Paginate($options); $query = $this->db->from('positions')->where('account_id', 5); if ($s = $options['search']) { $query->where('name LIKE ?', $s . '%'); } $result = $paginate->process($query); return [$this->mapObjects($result), $paginate]; }
public function getShifts($options = []) { $options += ['user_id' => false] + Paginate::$defaultOptions; $paginate = new Paginate($options); $query = $this->db->from('shifts'); if ($uid = $options['user_id']) { $query->where('user_id', $uid); } $result = $paginate->process($query); return [$this->mapObjects($result), $paginate]; }