/**
* 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();
}
