public function getEventsFor($logLevels = null, $objectIDs = null, $objectTypes = null, $activityCodes = null, $limit = -1, $startTime = null, $endTime = null, $users = null)
{
$clauses = null;
$usersFilter = null;
if (!is_null($logLevels)) {
$logLevels = (array) $logLevels;
$logLevels = implode(",", $logLevels);
$clauses[] = "log_level IN ({$logLevels})";
}
if (!is_null($objectIDs) && !empty($objectIDs)) {
$objectIDs = (array) $objectIDs;
$objectIDs = implode(",", $objectIDs);
$clauses[] = "object_id IN ({$objectIDs})";
}
if (!is_null($objectTypes) && !empty($objectTypes)) {
$objectTypes = (array) $objectTypes;
$objectTypes = $this->db->prepare_string(implode("','", $objectTypes));
$clauses[] = "object_type IN ('{$objectTypes}')";
}
if (!is_null($activityCodes)) {
$activityCodes = (array) $activityCodes;
$activityCodes = "('" . implode("','", $activityCodes) . "')";
$clauses[] = "activity IN {$activityCodes}";
}
if (!is_null($startTime)) {
$clauses[] = "fired_at >= {$startTime}";
}
if (!is_null($endTime)) {
$clauses[] = "fired_at <= {$endTime}";
}
if (!is_null($users)) {
$usersFilter = " JOIN {$this->tables['transactions']} T " . " ON T.id = E.transaction_id AND T.user_id IN ({$users}) ";
}
$query = "SELECT E.id FROM {$this->tables['events']} E {$usersFilter}";
if ($clauses) {
$query .= " WHERE " . implode(" AND ", $clauses);
}
$query .= " ORDER BY transaction_id DESC,fired_at DESC";
return tlEvent::createObjectsFromDBbySQL($this->db, $query, 'id', "tlEvent", true, tlEvent::TLOBJ_O_GET_DETAIL_FULL, $limit);
}
