function uc_cart_links_report in Ubercart 7.3

Same name and namespace in other branches

1. 5 uc_cart_links/uc_cart_links.module \uc_cart_links_report()
2. 6.2 uc_cart_links/uc_cart_links.admin.inc \uc_cart_links_report()

Displays the Cart Links report.

Return value

HTML output.

1 string reference to 'uc_cart_links_report'

uc_cart_links_menu in uc_cart_links/uc_cart_links.module

Implements hook_menu().

File

uc_cart_links/uc_cart_links.admin.inc, line 86

Cart Links administration menu items.

Code

function uc_cart_links_report() {
  $header = array(
    array(
      'data' => t('ID'),
      'field' => 'cart_link_id',
    ),
    array(
      'data' => t('Clicks'),
      'field' => 'clicks',
    ),
    array(
      'data' => t('Last click'),
      'field' => 'last_click',
      'sort' => 'desc',
    ),
  );
  $query = db_select('uc_cart_link_clicks')
    ->extend('PagerDefault')
    ->extend('TableSort')
    ->fields('uc_cart_link_clicks')
    ->limit(25)
    ->element(1)
    ->orderByHeader($header);
  $rows = array();
  $result = $query
    ->execute();
  foreach ($result as $data) {
    $rows[] = array(
      check_plain($data->cart_link_id),
      $data->clicks,
      format_date($data->last_click, 'short'),
    );
  }
  $build['report'] = array(
    '#theme' => 'table',
    '#header' => $header,
    '#rows' => $rows,
    '#empty' => t('No Cart Links have been tracked yet.'),
  );
  $build['pager'] = array(
    '#theme' => 'pager',
    '#element' => 1,
  );
  return $build;
}