function ServiceAuditFilesManagedNotUsed::_auditfiles_managed_not_used_get_file_list in Audit Files 8

Retrieves the file IDs to operate on.

Return value

array The file IDs.

File

src/ServiceAuditFilesManagedNotUsed.php, line 18

providing the service that used in 'managed not used' functionality.

Class

ServiceAuditFilesManagedNotUsed

Namespace

Drupal\auditfiles

Code

function _auditfiles_managed_not_used_get_file_list() {
  $config = \Drupal::config('auditfiles_config.settings');
  $connection = Database::getConnection();
  $query = 'SELECT fid FROM {file_managed} WHERE fid NOT IN (SELECT fid FROM {file_usage})';
  $maximum_records = $config
    ->get('auditfiles_report_options_maximum_records') ? $config
    ->get('auditfiles_report_options_maximum_records') : 250;
  if ($maximum_records > 0) {
    $query .= ' LIMIT ' . $maximum_records;
  }
  return $connection
    ->query($query)
    ->fetchCol();
}