public function ServiceAuditFilesManagedNotUsed::auditfilesManagedNotUsedGetFileList in Audit Files 4.x

Same name and namespace in other branches

1. 8.3 src/ServiceAuditFilesManagedNotUsed.php \Drupal\auditfiles\ServiceAuditFilesManagedNotUsed::auditfilesManagedNotUsedGetFileList()
2. 8.2 src/ServiceAuditFilesManagedNotUsed.php \Drupal\auditfiles\ServiceAuditFilesManagedNotUsed::auditfilesManagedNotUsedGetFileList()

Retrieves the file IDs to operate on.

Return value

array The file IDs.

File

src/ServiceAuditFilesManagedNotUsed.php, line 71

Class

ServiceAuditFilesManagedNotUsed

Service managed not used functions.

Namespace

Drupal\auditfiles

Code

public function auditfilesManagedNotUsedGetFileList() {
  $config = $this->configFactory
    ->get('auditfiles.settings');
  $connection = $this->connection;
  $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();
}