function block_tracker_report in Util 6.3

Same name and namespace in other branches

1. 7 contribs/block_tracker/block_tracker.module \block_tracker_report()

Menu callback. Report on block usage.

1 string reference to 'block_tracker_report'

block_tracker_menu in contribs/block_tracker/block_tracker.module

Implements hook_menu().

File

contribs/block_tracker/block_tracker.module, line 61

Track block usage.

Code

function block_tracker_report() {
  $output = '<div id="block-tracker-report">';
  $query = "SELECT bid, module, delta, theme, status FROM {blocks} WHERE lastused = 0 ORDER BY module, delta";
  $result = db_query($query);
  $rows = array();
  while ($row = db_fetch_object($result)) {
    $rows[] = theme('block_tracker_item', $row);
  }
  $header = array(
    t('Bid'),
    t('Module'),
    t('Delta'),
    t('Theme'),
    t('Status'),
    t('Name'),
  );
  $output .= '<h3>' . t('Unused blocks') . '</h3>';
  $output .= theme('table', $header, $rows, array(
    'style' => 'width: auto;',
  ));
  $output .= '<p>' . t('Note: this report only lists those that have been unused since this tracker was installed.
    Site usage usually varies, so sufficient time should be allowed before actng on this report.') . '</p>';

  // Unused in a week.
  $query = "SELECT bid, module, delta, theme, status FROM {blocks} WHERE lastused < %d AND lastused <> 0 ORDER BY module, delta";
  $result = db_query($query, time() - 604800);
  $rows = array();
  while ($row = db_fetch_object($result)) {
    $rows[] = theme('block_tracker_item', $row);
  }
  if ($rows) {
    $output .= '<h3>' . t('Blocks not used in the last week') . '</h3>';
    $output .= theme('table', $header, $rows, array(
      'style' => 'width: auto;',
    ));
  }
  return $output . '</div>';
}