You are here

Home » API reference » OA Comment 7.2 » views_handler_field_oa_comment_timestamp_updated_comments.inc » views_handler_field_oa_comment_timestamp_updated_comments

function views_handler_field_oa_comment_timestamp_updated_comments::query in OA Comment 7.2

Called to add the field to a query.

Overrides views_handler_field::query

File

views/views_handler_field_oa_comment_timestamp_updated_comments.inc, line 13
Definition of views_handler_field_oa_comment_timestamp_updated_comments.

Class

views_handler_field_oa_comment_timestamp_updated_comments
Filter to show how many new comments on a post since user last visited it.

Code

function query() {
  $limit = time() - (REQUEST_TIME - NODE_NEW_LIMIT);
  $this
    ->ensure_my_table();
  $field = "{$this->table_alias}.{$this->real_field}";
  $node = $this->query
    ->ensure_table('node', $this->relationship);
  $comment = $this->query
    ->ensure_table('comment', 'comment_node');
  $params = $this->options['group_type'] != 'group' ? array(
    'function' => $this->options['group_type'],
  ) : array();
  $this->field_alias = $this->query
    ->add_field(NULL, "CASE WHEN (({$field} IS NULL or ({$comment}.changed > {$field} AND {$comment}.created <= {$field})) AND {$comment}.status = 1)  THEN 1 ELSE 0 END", $this->table . '_' . $this->field, $params);
}