public static function AdminAuditTrailStorage::getSearchData in Admin Audit Trail 1.0.x
Display event data listing.
Parameters
array $getData: Filter to display data.
array $header: Data sorting type.
int $limit: Limit to display data.
Return value
array The result to display.
1 call to AdminAuditTrailStorage::getSearchData()
- OverviewForm::buildForm in src/
OverviewForm.php - Form constructor.
File
- src/
AdminAuditTrailStorage.php, line 23
Class
- AdminAuditTrailStorage
- Controller class for admin audit trail required special handling for events.
Namespace
Drupal\admin_audit_trailCode
public static function getSearchData(array $getData, array $header, $limit = NULL) {
$db = \Drupal::database();
$query = $db
->select('admin_audit_trail', 'e');
$query
->fields('e');
$table_sort = $query
->extend('Drupal\\Core\\Database\\Query\\TableSortExtender')
->orderByHeader($header);
$pager = $table_sort
->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
->limit($limit);
// Apply filters.
if (!empty($getData['type'])) {
$query
->condition('type', $getData['type']);
if (!empty($getData['operation'])) {
$query
->condition('operation', $getData['operation']);
}
}
if (!empty($getData['id'])) {
$query
->condition('ref_numeric', $getData['id']);
}
if (!empty($getData['ip'])) {
$query
->condition('ip', $getData['ip']);
}
if (!empty($getData['name'])) {
$query
->condition('ref_char', $getData['name']);
}
if (!empty($getData['path'])) {
$query
->condition('path', '%' . \Drupal::database()
->escapeLike($getData['path']) . '%', 'LIKE');
}
if (!empty($getData['keyword'])) {
$query
->condition('description', '%' . \Drupal::database()
->escapeLike($getData['keyword']) . '%', 'LIKE');
}
if (!empty($getData['user'])) {
$query
->condition('uid', $getData['user']);
}
$result = $pager
->execute();
return $result;
}