You are here

Home » API reference » Download Count 6.2 » download_count_views_handler_field_count.inc » download_count_views_handler_field_count

function download_count_views_handler_field_count::query in Download Count 6.2

File

includes/download_count_views_handler_field_count.inc, line 12
Download count per file views handler.

Class

download_count_views_handler_field_count
Download count per file views field handler.

Code

function query() {
  $this->table_alias = $this
    ->ensure_my_table();
  if (empty($this->relationship)) {
    $sql = "SELECT COUNT(dc.fid) FROM {download_count} dc WHERE dc.fid = " . $this->table_alias . ".fid";
    $this->field_alias = $this->query
      ->add_field(NULL, "(" . $sql . ")", $this->table_alias . '_' . $this->field);
  }
  else {
    $sql = "SELECT COUNT(dc.fid) FROM {download_count} dc WHERE dc.fid = " . $this->relationship . ".fid";
    $this->field_alias = $this->query
      ->add_field(NULL, "(" . $sql . ")", $this->relationship . '_' . $this->field);
  }
}