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