/** * Get admin users logins archive list * @access public * @param int $id * @param int $page [optional] * @param string $browser [optional] * @param string $loginDate [optional] * @param string $sortField [optional] * @param string $orderBy [optional] * @return array */ public function getLogins($id, $page = 1, $browser = '', $loginDate = '', $sortField = '', $orderBy = '') { $select = $this->db->select()->from('userLogin')->joinLeft('user', 'userLogin.userId = user.id', 'username'); if ($id > 0) { $select->where('userId = ?', $id); } if ($browser != '') { $select->where($this->db->quoteInto("userAgent LIKE ? ", '%' . $browser . '%')); } if ($loginDate != '') { $select->where('dateLogin LIKE ?', '%' . $loginDate . '%'); } if ($sortField != "") { $select->order($sortField . ' ' . $orderBy); } $dotPaginator = new Dot_Paginator($select, $page, $this->settings->resultsPerPage); return $dotPaginator->getData(); }
/** * Get admin users logins archive list * @access public * @param int $id * @param int $page [optional] * @return array */ public function getLogins($id, $page = 1) { $select = $this->db->select()->from('adminLogin')->joinLeft('admin', 'adminLogin.adminId=admin.id', 'username'); if ($id > 0) { $select->where('adminId = ?', $id); } $select->order('dateLogin DESC'); $dotPaginator = new Dot_Paginator($select, $page, $this->settings->resultsPerPage); return $dotPaginator->getData(); }