function _auditfiles_referenced_not_used_get_file_data in Audit Files 7.4

Same name and namespace in other branches

1. 7.3 auditfiles.referencednotused.inc \_auditfiles_referenced_not_used_get_file_data()

Retrieves information about an individual file from the database.

Parameters

string $reference_id: The ID for keeping track of the reference.

array $row_data: The data to use for creating the row.

Return value

array The row for the table on the report, with the file's information formatted for display.

2 calls to _auditfiles_referenced_not_used_get_file_data()

auditfiles_referenced_not_used_form in ./auditfiles.referencednotused.inc

Generates the report.

_auditfiles_referenced_not_used_batch_display_process_operation in ./auditfiles.referencednotused.inc

The batch process for displaying the files.

File

./auditfiles.referencednotused.inc, line 704

Generates report showing files referenced by content, but not in file_usage.

Code

function _auditfiles_referenced_not_used_get_file_data($reference_id, array $row_data) {
  $row = array();

  // Get the data for this record.
  $query = "SELECT * FROM {" . $row_data['table'] . "} WHERE " . $row_data['column'] . " = " . $row_data['file_id'];
  $result = db_query($query)
    ->fetchAll();
  $result = reset($result);
  if ($result->entity_type == 'node') {
    $entity_id_display = l('node/' . $result->entity_id, 'node/' . $result->entity_id);
  }
  else {
    $entity_id_display = $result->entity_id;
  }

  // Add the initial data to the row.
  $row = array(
    'file_id' => $result->{$row_data['column']},
    'entity_type' => $result->entity_type,
    'bundle' => array(
      'data' => $result->bundle,
      'hidden' => TRUE,
    ),
    'entity_id' => array(
      'data' => $result->entity_id,
      'hidden' => TRUE,
    ),
    'entity_id_display' => $entity_id_display,
    'field' => $row_data['table'] . '.' . $row_data['column'],
    'table' => array(
      'data' => $row_data['table'],
      'hidden' => TRUE,
    ),
    'uri' => 'No file object exists for this reference.',
    'filename' => array(
      'data' => '',
      'hidden' => TRUE,
    ),
    'filemime' => '--',
    'filesize' => '--',
  );

  // If there is a file in the file_managed table, add some of that
  // information to the row, too.
  $file_managed = file_load($result->{$row_data['column']});
  if (!empty($file_managed)) {
    $row['uri'] = $file_managed->uri;
    $row['filename'] = array(
      'data' => $file_managed->filename,
      'hidden' => TRUE,
    );
    $row['filemime'] = $file_managed->filemime;
    $row['filesize'] = $file_managed->filesize;
  }
  return $row;
}