public function ServiceAuditFilesManagedNotUsed::auditfilesManagedNotUsedGetFileList in Audit Files 8.3

Same name and namespace in other branches

1. 8.2 src/ServiceAuditFilesManagedNotUsed.php \Drupal\auditfiles\ServiceAuditFilesManagedNotUsed::auditfilesManagedNotUsedGetFileList()
2. 4.x 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');
  $maximum_records = $config
    ->get('auditfiles_report_options_maximum_records');
  $scheme = $config
    ->get('auditfiles_file_system_path');
  $connection = $this->connection;
  $fu_query = $connection
    ->select('file_usage', 'fu')
    ->fields('fu', [
    'fid',
  ])
    ->execute()
    ->fetchCol();
  $query = $connection
    ->select('file_managed', 'fm')
    ->fields('fm', [
    'fid',
  ]);
  if (!empty($fu_query)) {
    $query
      ->condition('fm.fid', $fu_query, 'NOT IN');
  }
  if (!empty($scheme)) {
    $query
      ->condition('fm.uri', $scheme . '://%', 'LIKE');
  }
  if ($maximum_records > 0) {
    $query
      ->range(0, $maximum_records);
  }
  return $query
    ->execute()
    ->fetchCol();
}