public function SiteAuditCheckContentContentTypes::calculateScore in Site Audit 7

Implements \SiteAudit\Check\Abstract\calculateScore().

Overrides SiteAuditCheckAbstract::calculateScore

File

Check/Content/ContentTypes.php, line 96

Contains \SiteAudit\Check\Content\ContentTypes.

Class

SiteAuditCheckContentContentTypes

Class SiteAuditCheckContentContentTypes.

Code

public function calculateScore() {
  $sql_query = 'SELECT COUNT({node}.nid) AS count, {node_type}.type ';
  $sql_query .= 'FROM {node_type} ';
  $sql_query .= 'LEFT JOIN {node} ON {node}.type = {node_type}.type ';
  $sql_query .= 'GROUP BY {node_type}.type ';
  $sql_query .= 'ORDER BY count DESC ';
  $result = db_query($sql_query);
  $this->registry['content_type_counts'] = $this->registry['content_types_unused'] = array();
  $this->registry['node_count'] = 0;
  foreach ($result as $row) {
    if ($row->count == 0) {
      $this->registry['content_types_unused'][] = $row->type;
    }
    $this->registry['content_type_counts'][$row->type] = $row->count;
    $this->registry['node_count'] += $row->count;
  }

  // Check to see if no nodes exist.
  $content_type_counts = array_count_values($this->registry['content_type_counts']);
  if (count($content_type_counts) == 1 && isset($content_type_counts[0]) && $content_type_counts[0] > 0) {
    $this->registry['content_type_counts'] = array();
  }
  return SiteAuditCheckAbstract::AUDIT_CHECK_SCORE_INFO;
}