/**
* Get Logs
*
* @url GET /logs
*/
public function getPrivateLogs()
{
$authIdUser = parent::CheckAuthentication(true, true);
$logs = null;
if (isset($_GET['action'])) {
$action = $_GET['action'];
} else {
$action = null;
}
if (isset($_GET['agent'])) {
$agent = $_GET['agent'];
} else {
$agent = null;
}
if (isset($_GET['from'])) {
$from = $_GET['from'];
} else {
$from = 0;
}
if (isset($_GET['count'])) {
$count = $_GET['count'];
} else {
$count = 50;
}
$sql = "SELECT Action, Agent, UserEmail, DateTime, Ip, Location FROM Log ";
$sql .= " WHERE LogId > 0 ";
// Filter by action
if ($action != null && strlen($action) > 0) {
$sql .= " AND Action = '" . $action . "' ";
}
// Filter by agent
if ($agent != null && strlen($agent) > 0) {
$sql .= " AND Agent = '" . $agent . "' ";
}
$sql .= " ORDER BY LogId DESC LIMIT {$from}, {$count} ";
$result = $this->mysqli->query($sql) or die($authIssueText);
$recordsCount = mysqli_num_rows($result);
if ($recordsCount >= 1 && $result != null) {
while ($row = mysqli_fetch_array($result)) {
$logs[] = array(Action => $row['Action'], Agent => $row['Agent'], Email => $row['UserEmail'], DateTime => gmdate("D, d M Y H:i:s", $row['DateTime']), Ip => $row['Ip'], Location => $row['Location']);
}
}
return $logs;
}
