1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
<?php
/**
* @file
* Definition of views_handler_field_ncs_last_comment_name.
*/
/**
* 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, 'bool' => 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', array(
'account' => $account
));
}
else {
return $this->sanitize_value($this->get_value($values));
}
}
}
|
