views_handler_field_ncs_last_comment_name.inc in Views (for Drupal 7) 6.3

File

modules/comment/views_handler_field_ncs_last_comment_name.inc

<?php

/**
 * Field handler to present the name of the last comment poster.
 *
 * @ingroup views_field_handlers
 */
class views_handler_field_ncs_last_comment_name extends views_handler_field {
  function query() {

    // last_comment_name only contains data if the user is anonymous. So we
    // have to join in a specially related user table.
    $this
      ->ensure_my_table();

    // join 'users' to this table via vid
    $join = new views_join();
    $join
      ->construct('users', $this->table_alias, 'last_comment_uid', 'uid');
    $join->extra = array(
      array(
        'field' => 'uid',
        'operator' => '!=',
        'value' => '0',
      ),
    );

    // ncs_user alias so this can work with the sort handler, below.
    //    $this->user_table = $this->query->add_relationship(NULL, $join, 'users', $this->relationship);
    $this->user_table = $this->query
      ->ensure_table('ncs_users', $this->relationship, $join);
    $this->field_alias = $this->query
      ->add_field(NULL, "COALESCE({$this->user_table}.name, {$this->table_alias}.{$this->field})", $this->table_alias . '_' . $this->field);
    $this->user_field = $this->query
      ->add_field($this->user_table, 'name');
    $this->uid = $this->query
      ->add_field($this->table_alias, 'last_comment_uid');
  }
  function option_definition() {
    $options = parent::option_definition();
    $options['link_to_user'] = array(
      'default' => TRUE,
    );
    return $options;
  }
  function render($values) {
    if (!empty($this->options['link_to_user'])) {
      $account = new stdClass();
      $account->name = $this
        ->get_value($values);
      $account->uid = $values->{$this->uid};
      return theme('username', $account);
    }
    else {
      return $this
        ->sanitize_value($this
        ->get_value($values));
    }
  }

}

Classes

Name	Description
views_handler_field_ncs_last_comment_name	Field handler to present the name of the last comment poster.