webform_handler_field_submission_count.inc in Webform 7.4
File
views/webform_handler_field_submission_count.inc
View source
<?php
class webform_handler_field_submission_count extends views_handler_field {
public function construct() {
parent::construct();
$this->count_type = $this->definition['count_type'];
if ($this->count_type == 'node') {
$this->additional_fields['nid'] = 'nid';
$this->additional_fields['type'] = 'type';
}
elseif ($this->count_type == 'users') {
$this->additional_fields['uid'] = 'uid';
}
}
public function option_definition() {
$options = parent::option_definition();
$options['label'] = array(
'default' => '# of Submissions',
'translatable' => TRUE,
);
return $options;
}
public function query() {
$this
->ensure_my_table();
$this
->add_additional_fields();
}
public function render($values) {
global $user;
$output = NULL;
if ($this->count_type == 'node' && variable_get('webform_node_' . $values->{$this->aliases['type']}, FALSE)) {
module_load_include('inc', 'webform', 'includes/webform.submissions');
$node = node_load($values->{$this->aliases['nid']});
if (webform_results_access($node, $user)) {
$count = webform_get_submission_count($node->nid);
$output = l($count, "node/{$node->nid}/webform-results");
}
elseif (webform_submission_access($node, NULL, 'list', $user)) {
$count = webform_get_submission_count($node->nid, $user->uid);
$output = l($count, "node/{$node->nid}/submissions");
}
else {
$output = webform_get_submission_count($node->nid);
}
}
elseif ($this->count_type == 'users') {
$output = db_select('webform_submissions')
->condition('uid', $values->{$this->aliases['uid']})
->countQuery()
->execute()
->fetchField();
}
return $output;
}
}