function ad_activity_details in Advertisement 6.3

Same name and namespace in other branches

1. 6.2 ad.pages.inc \ad_activity_details()
2. 7 ad.pages.inc \ad_activity_details()

1 string reference to 'ad_activity_details'

ad_menu in ./ad.module

Implementation of hook_menu().

File

./ad.pages.inc, line 253

Advertisement nodes pages and forms.

Code

function ad_activity_details($node) {
  $output = '';
  drupal_set_breadcrumb(array(
    l(t('Home'), NULL),
    l(check_plain($node->title), 'node/' . $node->nid),
  ));
  if (ad_permission($node, 'access click history')) {
    $header = array(
      array(
        'data' => t('Date'),
        'field' => 'date',
        'sort' => 'desc',
      ),
      array(
        'data' => t('Action'),
        'field' => 'action',
      ),
    );
    if (isset($node->nid) && $node->nid > 0) {
      $sql = "SELECT * FROM {ad_statistics} WHERE action NOT IN ('view', 'click') AND aid = %d";
      $sql .= tablesort_sql($header);
      $result = pager_query($sql, 25, 0, NULL, $node->nid);
      while ($ad = db_fetch_object($result)) {
        $row = array();
        $row[] = format_date(strtotime($ad->date . '00'), 'large');
        $row[] = $ad->action;
        $rows[] = $row;
      }
      if (empty($rows)) {
        $output = '<p>' . t('There is no activity yet.') . '</p>';
      }
      else {
        $output = theme('table', $header, $rows);
      }
      $output .= theme('pager', NULL, 25, 0);
    }
  }
  return theme('box', t('Activity'), $output);
}