function votingapi_views_tables in Voting API 5
Same name and namespace in other branches
- 6 votingapi_views.inc \votingapi_views_tables()
File
- ./votingapi_views.inc, line 3
Code
function votingapi_views_tables() {
$vote_tags = _votingapi_views_values($field = 'tag', $table = 'vote');
$vote_types = _votingapi_views_values($field = 'value_type', $table = 'vote');
$vote_tags = array_unique(array_merge($vote_tags, array(
'vote',
)));
$vote_types = array_unique(array_merge($vote_types, array(
'percent',
)));
foreach ($vote_tags as $vote_tag) {
foreach ($vote_types as $vote_type) {
$table = array(
"name" => "votingapi_vote",
"provider" => "votingapi",
"join" => array(
"left" => array(
"table" => "node",
"field" => "nid",
),
"right" => array(
"field" => "content_id",
),
"extra" => array(
'content_type' => 'node',
'value_type' => $vote_type,
'tag' => $vote_tag,
),
),
"fields" => array(
"value" => array(
'name' => t("VotingAPI !type !tag value", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'handler' => votingapi_get_formatters(array(
'value_type' => $vote_type,
'tag' => $vote_tag,
)),
'value_type' => $vote_type,
'tag' => $vote_tag,
'sortable' => TRUE,
),
"timestamp" => array(
'name' => t("VotingAPI !type !tag timestamp", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'sortable' => TRUE,
'handler' => array(
"views_handler_field_date_small" => t('As Short Date'),
"views_handler_field_date" => t('As Medium Date'),
"views_handler_field_date_large" => t('As Long Date'),
"views_handler_field_since" => t('As Time Ago'),
),
'sortable' => TRUE,
'help' => "Display the time the vote was cast.",
),
"uid" => array(
'name' => t("VotingAPI !type !tag user", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'handler' => 'votingapi_views_handler_field_username',
'sortable' => TRUE,
),
),
"sorts" => array(
"value" => array(
'name' => t("VotingAPI !type !tag vote", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
),
"uid" => array(
'name' => t("VotingAPI !type !tag voter", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
),
"timestamp" => array(
'name' => t("VotingAPI !type !tag timestamp", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
),
),
'filters' => array(
'value' => array(
'name' => t("VotingAPI !type !tag value", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'operator' => 'views_handler_operator_gtlt',
'handler' => 'votingapi_handler_filter_value',
'value-type' => 'string',
'help' => t('Filter nodes by values of the individual votes users cast for them.'),
),
'timestamp' => array(
'name' => t("VotingAPI !type !tag timestamp", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'operator' => 'views_handler_operator_gtlt',
'value' => views_handler_filter_date_value_form(),
'handler' => 'views_handler_filter_timestamp',
'option' => 'string',
'help' => t('Filter nodes by the date they were voted on.') . ' ' . views_t_strings('filter date'),
),
'uid' => array(
'name' => t("VotingAPI !type !tag user", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'operator' => array(
'IS NOT NULL' => t('Has been voted on by'),
'IS NULL' => t('Has not been voted on by'),
),
'list' => array(
'***CURRENT_USER***' => t('Currently Logged In User'),
'***ANY_USER***' => t('Any user'),
),
'list-type' => 'select',
'handler' => 'votingapi_handler_filter_uid_voted',
'help' => t('Filter nodes by whether the currently logged in user has voted.'),
'content_type' => 'node',
'value_type' => $vote_type,
'tag' => $vote_tag,
),
),
);
$tables['votingapi_vote_' . preg_replace('!\\W!', '', $vote_tag) . '_' . preg_replace('!\\W!', '', $vote_type)] = $table;
$table = array(
"name" => "votingapi_vote",
"provider" => "votingapi",
"join" => array(
"left" => array(
"table" => "node",
"field" => "nid",
),
"right" => array(
"field" => "content_id",
),
"extra" => array(
'content_type' => 'node',
'value_type' => $vote_type,
'tag' => $vote_tag,
'uid' => '***CURRENT_USER***',
),
),
"fields" => array(
"value" => array(
'name' => t("VotingAPI !type !tag value (current user only)", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'field' => 'value',
'handler' => votingapi_get_formatters(array(
'value_type' => $vote_type,
'tag' => $vote_tag,
)),
'value_type' => $vote_type,
'tag' => $tag,
'sortable' => TRUE,
),
"timestamp" => array(
'name' => t("VotingAPI !type !tag timestamp (current user only)", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'sortable' => TRUE,
'handler' => array(
"views_handler_field_date_small" => t('As Short Date'),
"views_handler_field_date" => t('As Medium Date'),
"views_handler_field_date_large" => t('As Long Date'),
"views_handler_field_since" => t('As Time Ago'),
),
'sortable' => TRUE,
'help' => "Display the time the vote was cast.",
),
),
"sorts" => array(
"value" => array(
'name' => t("VotingAPI !type !tag vote", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
),
"timestamp" => array(
'name' => t("VotingAPI !type !tag timestamp", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
),
),
'filters' => array(
'value' => array(
'name' => t("VotingAPI !type !tag value (current user only)", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'operator' => 'views_handler_operator_gtlt',
'handler' => 'votingapi_handler_filter_value',
'value-type' => 'string',
'help' => t("Filter nodes by values of the current user's vote for them."),
),
'timestamp' => array(
'name' => t("VotingAPI !type !tag timestamp (current user only)", array(
'!tag' => $vote_tag,
'!type' => $vote_type,
)),
'operator' => 'views_handler_operator_gtlt',
'value' => views_handler_filter_date_value_form(),
'handler' => 'views_handler_filter_timestamp',
'option' => 'string',
'help' => t('Filter nodes by the date they were voted on by the current user.') . ' ' . views_t_strings('filter date'),
),
),
);
$tables['votingapi_vote_' . preg_replace('!\\W!', '', $vote_tag) . '_' . preg_replace('!\\W!', '', $vote_type) . '_current_user'] = $table;
}
}
$cache_tags = _votingapi_views_values($field = 'tag', $table = 'cache');
$cache_types = _votingapi_views_values($field = 'value_type', $table = 'cache');
$cache_functions = _votingapi_views_values($field = 'function', $table = 'cache');
$cache_tags = array_unique(array_merge($vote_tags, array(
'vote',
)));
$cache_types = array_unique(array_merge($cache_types, array(
'percent',
)));
$cache_functions = array_unique(array_merge($cache_functions, array(
'average',
'count',
)));
foreach ($cache_functions as $cache_function) {
foreach ($cache_tags as $cache_tag) {
foreach ($cache_types as $cache_type) {
$table = array(
"name" => "votingapi_cache",
"provider" => "votingapi",
"join" => array(
"left" => array(
"table" => "node",
"field" => "nid",
),
"right" => array(
"field" => "content_id",
),
"extra" => array(
'content_type' => 'node',
'value_type' => $cache_type,
'tag' => $cache_tag,
'function' => $cache_function,
),
),
"fields" => array(
"value" => array(
'name' => t("VotingAPI !type !tag result (!function)", array(
'!tag' => $cache_tag,
'!type' => $cache_type,
'!function' => $cache_function,
)),
'handler' => votingapi_get_formatters(array(
'value_type' => $cache_type,
'tag' => $cache_tag,
'function' => $cache_function,
)),
'value_type' => $cache_type,
'tag' => $cache_tag,
'function' => $cache_function,
'sortable' => TRUE,
),
),
"sorts" => array(
"value" => array(
'name' => t("VotingAPI !type !tag result (!function)", array(
'!tag' => $cache_tag,
'!type' => $cache_type,
'!function' => $cache_function,
)),
),
),
'filters' => array(
'value' => array(
'name' => t("VotingAPI !type !tag result (!function)", array(
'!tag' => $cache_tag,
'!type' => $cache_type,
'!function' => $cache_function,
)),
'operator' => 'views_handler_operator_gtlt',
'handler' => 'votingapi_handler_filter_value',
'value-type' => 'string',
'help' => t('Filter nodes by the aggregate results of votes cast.'),
),
),
);
$tables[implode('_', array(
'votingapi_cache',
$cache_tag,
$cache_type,
$cache_function,
))] = $table;
}
}
}
return $tables;
}
