View source
<?php
function og_views_tables() {
$languages = module_invoke('locale', 'supported_languages', FALSE, TRUE);
$group_post_type_options = $group_type_options = array();
foreach (og_get_types('group') as $type) {
$group_type_options[$type] = node_get_types('name', $type);
}
foreach (og_get_types('group_post') as $type) {
$group_post_type_options[$type] = node_get_types('name', $type);
}
return array(
'og' => array(
'name' => 'og',
'join' => array(
'left' => array(
'table' => 'node',
'field' => 'nid',
),
'right' => array(
'field' => 'nid',
),
),
'fields' => array(
'description' => array(
'name' => t('OG: Group: Description'),
),
'count' => array(
'name' => t('OG: Group: Members count'),
'handler' => 'og_handler_field_count',
'help' => t('Number of members for a group. Excludes memberships which are pending approval.'),
'sortable' => FALSE,
'notafield' => TRUE,
),
'post_count' => array(
'name' => t('OG: Group: Post count'),
'handler' => 'og_handler_post_count',
'sortable' => FALSE,
'notafield' => TRUE,
'help' => t('Number of published posts in a group. Can be restricted by node type using the <em>Option</em> dropdown.'),
'option' => array(
'#type' => 'select',
'#options' => array_merge(array(
'all' => t('All'),
), $group_post_type_options),
'#default_value' => 'all',
),
),
'post_count_new' => array(
'name' => t('OG: Group: Post count *new*'),
'handler' => 'og_handler_post_count_new',
'sortable' => FALSE,
'notafield' => TRUE,
'help' => t('Number of new posts in a group for the current user. The <em>new</em> indicator may be optionally appended using the <em>Option</em> dropdown.'),
'option' => array(
'#type' => 'select',
'#options' => array(
'normal' => t('Normal'),
'withmark' => t('With new mark'),
),
),
),
'selective' => array(
'name' => t('OG: Group: Selective'),
),
'private' => array(
'name' => t('OG: Group: Private'),
'handler' => 'og_handler_field_private',
'sortable' => TRUE,
'help' => t('Displays whether a group is private or public with respect to groups.'),
),
'subscribe' => array(
'name' => t('OG: Group: Join Link'),
'handler' => 'og_handler_field_subscribe',
'addlfields' => array(
'selective',
),
'sortable' => FALSE,
'notafield' => TRUE,
'help' => t('Displays a links for joining a group when a user is not already a member.'),
),
'language' => array(
'name' => t('OG: Group: Language'),
'handler' => 'og_handler_field_language',
'sortable' => TRUE,
'help' => t('Displays the language selected for a given group.'),
),
),
'filters' => array(
'directory' => array(
'name' => t('OG: Group: List in directory'),
'operator' => array(
'=' => 'Is',
),
'list' => 'views_handler_operator_yesno',
'list-type' => 'select',
'help' => t('Admin specifies whether or not a group appears in the public listings.'),
),
'private' => array(
'name' => t('OG: Group: Private'),
'operator' => array(
'=' => 'Is',
),
'list' => 'views_handler_operator_yesno',
'list-type' => 'select',
'help' => t('Is the group home page private or not.'),
),
'selective' => array(
'name' => t('OG: Group: Selective'),
'operator' => 'views_handler_operator_or',
'list-type' => 'list',
'list' => array(
OG_OPEN => t('Open'),
OG_MODERATED => t('Moderated'),
OG_INVITE_ONLY => t('Invite Only'),
OG_CLOSED => t('Closed'),
),
'help' => t('The group preference which determines how membership requests are managed (moderated, invite only, etc.).'),
),
'language' => array(
'name' => t('OG: Group: Language'),
'operator' => 'views_handler_operator_andor',
'option' => 'string',
'value-type' => 'array',
'value' => array(
'#type' => 'select',
'#options' => $languages['name'],
'#multiple' => TRUE,
),
'help' => t('Restrict groups to specific languages.'),
),
),
),
'og_ancestry' => array(
'name' => 'og_ancestry',
'join' => array(
'left' => array(
'table' => 'node',
'field' => 'nid',
),
'right' => array(
'field' => 'nid',
),
),
'filters' => array(
'gid' => array(
'name' => t('OG: Post in specified group (by number)'),
'handler' => 'og_handler_filter_gid',
'operator' => array(
'=' => 'Is',
),
'help' => t('Filter for posts in specified organic groups. <em>Value</em> should be a one or more node ids (i.e. integers), separated by commas or pluses. Like taxonomy, pluses indicate that the post must appear in one of the specified groups, whereas commas indicate that the post must appear in every specified group. The page context (if View is a page) will be set to the first listed group. That means that blocks and breadcrumbs (and theme and locale, if applicable) will be based upon the first specified node id.'),
),
'group_name_like' => array(
'name' => t('OG: Post in specified groups (by name)'),
'handler' => 'og_handler_filter_group_name_like',
'operator' => 'views_handler_operator_like',
'help' => t('Filter for posts in specified organic groups. Value should be a one or more group names (partial name is supported), separated by commas or pluses. Like taxonomy, pluses indicate that the post must appear in one of the specified groups, whereas commas indicate that the post must appear in every specified group. The page context is <strong>not</strong> be set the the first specified group (unfortunately, you must use <em>OG: Post in specified group (by number)</em> for that).'),
),
'gtype' => array(
'name' => t('OG: Post in specified group type'),
'list' => $group_type_options,
'list-type' => 'list',
'operator' => 'views_handler_operator_or',
'value-type' => 'array',
'field' => 'group_nid',
'handler' => 'og_handler_filter_post_og_type',
'help' => t('Filter for a given organic group type.'),
),
'picg' => array(
'name' => t('OG: Posts in current group'),
'help' => t('Posts in current group. Useful for blocks where determining context is hard. If page is not in any group context, no nodes are listed and thus a block would not appear.'),
'operator' => 'views_handler_operator_eqneq',
'list' => 'views_handler_filter_groupcurrent',
'list-type' => 'select',
'handler' => 'og_handler_filter_picg',
),
'is_public' => array(
'name' => t('OG: Public'),
'help' => t('Posts marked as Public, which are viewable by non group members as well.'),
'operator' => array(
'=' => t('Is'),
),
'list' => 'views_handler_operator_yesno',
'list-type' => 'select',
'field' => 'is_public',
'handler' => 'og_handler_filter_public',
),
),
'fields' => array(
'is_public' => array(
'name' => t('OG: Public'),
'handler' => 'og_handler_field_yesempty',
'help' => t('Displays <em>yes</em> if post is public according to OG.'),
),
),
),
'og_node_data' => array(
'name' => 'node',
'join' => array(
'left' => array(
'table' => 'og_ancestry',
'field' => 'group_nid',
),
'right' => array(
'field' => 'nid',
),
),
'fields' => array(
'title' => array(
'name' => t('OG: Group names'),
'handler' => 'og_handler_field_nodelink',
'notafield' => TRUE,
'help' => t('Display links to any groups that are affiliated with a post.'),
),
),
),
'og_uid' => array(
'name' => 'og_uid',
'join' => array(
'left' => array(
'table' => 'node',
'field' => 'nid',
),
'right' => array(
'field' => 'nid',
),
'extra' => array(
'is_active' => 1,
),
),
'fields' => array(
'managelink' => array(
'name' => t('OG: Manage membership link'),
'handler' => 'og_handler_field_managelink',
'sortable' => FALSE,
'notafield' => TRUE,
),
'is_admin' => array(
'name' => t('OG: Is member an admin in a group'),
'handler' => 'og_handler_field_yesempty',
'sortable' => FALSE,
),
),
'filters' => array(
'currentuidsimple' => array(
'field' => 'uid',
'name' => t("OG: Group in user's groups"),
'operator' => 'views_handler_operator_eqneq',
'list' => 'views_handler_filter_usercurrent',
'list-type' => 'select',
'help' => t('Groups are filtered to where current user is a member.'),
),
),
),
'og_uid_node' => array(
'name' => 'og_uid',
'join' => array(
'left' => array(
'table' => 'og_node_data',
'field' => 'nid',
),
'right' => array(
'field' => 'nid',
),
'extra' => array(
'is_active' => 1,
),
),
'filters' => array(
'currentuid' => array(
'field' => 'uid',
'name' => t('OG: Post in User Subbed Groups'),
'operator' => 'views_handler_operator_eqneq',
'list' => 'views_handler_filter_usercurrent',
'list-type' => 'select',
'help' => t('Posts are filtered to groups that current user is a member of.'),
),
),
),
'og_views' => array(
'name' => 'node',
'join' => array(
'left' => array(
'table' => 'node',
'field' => 'nid',
),
'right' => array(
'field' => 'nid',
),
),
'filters' => array(
'og_type_selector' => array(
'field' => 'type',
'name' => t('OG: node type (selector)'),
'list' => $group_type_options,
'list-type' => 'list',
'operator' => 'views_handler_operator_or',
'value-type' => 'array',
'help' => t('A node type selector that is limited to og-enabled node types. Use as exposed filter that only contains og node types.'),
),
'og_type' => array(
'field' => 'type',
'name' => t('OG: type'),
'operator' => array(
'=' => t('Is'),
),
'list' => array(
'a group node',
),
'list-type' => 'select',
'handler' => 'og_handler_filter_og_type',
'help' => t('Restrict to node types which have been designated behave as groups.'),
),
),
),
);
}
function og_views_arguments() {
$args = array(
'gid' => array(
'name' => t("OG: Group nid(s)"),
'handler' => 'og_handler_argument_gid',
'help' => t('Filter for the one or more organic groups. Groups should be specified as a comma or plus delimited list of node ids, like taxonomy URLs. '),
),
'name' => array(
'name' => t("OG: Group name"),
'handler' => 'og_handler_argument_group_name_like',
'option' => array(
'#type' => 'select',
'#options' => 'views_handler_operator_like',
),
'help' => t('Filter for the one or more organic groups. Groups should be specified by name, or part of a name. Use the <em>Option</em> field to specify how to match the supplied name.'),
),
'og_uid' => array(
'name' => t('OG: User is subscribed to group'),
'handler' => 'og_views_handler_argument_uid',
'help' => t("Filter for groups that user is subscribed to. User is specified by user ID (integer). This argument exposes a user's group subscriptions to other users. Depending on your site, this may be a violation of their privacy. Use it thoughfully."),
),
);
return $args;
}
function og_handler_argument_gid($op, &$query, $argtype, $arg = '') {
switch ($op) {
case 'summary':
og_handler_summary($fieldinfo, $query);
return $fieldinfo;
case 'link':
if ($name = $query->title) {
return l($name, "node/" . intval($query->group_nid));
}
else {
return t('All posts');
}
break;
case 'sort':
$query->orderby[] = ' num_nodes ' . $argtype;
break;
case 'filter':
og_views_break_phrase($arg, $query);
break;
case 'title':
return db_result(db_query_range('SELECT title FROM {node} WHERE nid = %d', $query, 0, 1));
}
}
function og_views_handler_argument_uid($op, &$query, $a1, $a2 = null) {
switch ($op) {
case 'filter':
$query
->ensure_table('og_uid');
$query
->add_where("og_uid.uid = %d", $a2);
break;
case 'title':
return db_result(db_query('SELECT name FROM {users} WHERE uid = %d', $a2));
}
}
function og_handler_argument_group_name_like($op, &$query, $argtype, $arg = '') {
switch ($op) {
case 'summary':
og_handler_summary($fieldinfo, $query);
return $fieldinfo;
case 'link':
if ($name = $query->title) {
return l($name, "node/{$query->group_nid}");
}
else {
return t('All posts');
}
break;
case 'sort':
$query->orderby[] = ' num_nodes ' . $argtype;
break;
case 'filter':
$query
->ensure_table('og_node_data');
$filterinfo['table'] = 'og_node_data';
$filterinfo['field'] = 'title';
$filter = array(
'value' => $arg,
'operator' => $argtype['options'],
);
views_handler_filter_like('handler', $filter, $filterinfo, $query);
break;
case 'title':
return check_plain($query);
}
}
function og_handler_summary(&$fieldinfo, &$query) {
$query
->ensure_table('og_ancestry');
$query
->ensure_table('og_node_data');
$query
->add_field('title', 'og_node_data');
$query
->add_field('group_nid', 'og_ancestry');
$fieldinfo['field'] = 'og_node_data.nid';
}
function og_views_default_views() {
$view = new stdClass();
$view->name = 'og_mytracker';
$view->description = t('Shows all activity in subscribed groups.');
$view->access = array(
0 => '2',
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('Recent posts in my groups');
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = t('There are no posts in your subscribed groups.');
$view->page_empty_format = '1';
$view->page_type = 'table';
$view->url = 'group/mytracker';
$view->use_pager = TRUE;
$view->nodes_per_page = '25';
$view->menu = TRUE;
$view->menu_title = t('My recent');
$view->menu_tab = TRUE;
$view->menu_tab_weight = '0';
$view->menu_tab_default = FALSE;
$view->menu_tab_default_parent = NULL;
$view->menu_tab_default_parent_type = 'tab';
$view->menu_parent_tab_weight = '0';
$view->menu_parent_title = '';
$view->sort = array();
$view->argument = array(
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'og_node_data',
'field' => 'title',
'label' => 'Group',
),
array(
'tablename' => 'node',
'field' => 'type',
'label' => 'Type',
'sortable' => '1',
),
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Title'),
'handler' => 'views_handler_field_nodelink_with_mark',
'sortable' => '1',
'options' => 'link',
),
array(
'tablename' => 'users',
'field' => 'name',
'label' => t('Author'),
'sortable' => '1',
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'comment_count',
'label' => t('Replies'),
'handler' => 'views_handler_comments_with_new',
'sortable' => '1',
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'last_comment_timestamp',
'label' => t('Last post'),
'handler' => 'views_handler_field_since',
'sortable' => '1',
'defaultsort' => 'DESC',
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'og_uid_node',
'field' => 'currentuid',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
),
);
$view->exposed_filter = array();
$view->requires = array(
'og_node_data',
'node',
'users',
'og_uid_node',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_unread';
$view->description = t('Shows unread posts in subscribed groups.');
$view->access = array(
0 => '2',
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('Unread posts in my groups');
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = t('There are no new posts in your subscribed groups.');
$view->page_empty_format = '1';
$view->page_type = 'table';
$view->url = 'group/myunread';
$view->use_pager = TRUE;
$view->nodes_per_page = '25';
$view->menu = TRUE;
$view->menu_title = t('My unread');
$view->menu_tab = TRUE;
$view->menu_tab_weight = '-5';
$view->menu_tab_default = TRUE;
$view->menu_tab_default_parent = NULL;
$view->menu_tab_default_parent_type = 'normal';
$view->menu_parent_tab_weight = '0';
$view->menu_parent_title = '';
$view->sort = array();
$view->argument = array(
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'og_node_data',
'field' => 'title',
'label' => t('Group'),
),
array(
'tablename' => 'node',
'field' => 'type',
'label' => t('Type'),
'sortable' => '1',
),
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Title'),
'handler' => 'views_handler_field_nodelink_with_mark',
'sortable' => '1',
'options' => 'link',
),
array(
'tablename' => 'users',
'field' => 'name',
'label' => t('Author'),
'sortable' => '1',
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'comment_count',
'label' => t('Replies'),
'handler' => 'views_handler_comments_with_new',
'sortable' => '1',
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'last_comment_timestamp',
'label' => t('Last post'),
'handler' => 'views_handler_field_since',
'sortable' => '1',
'defaultsort' => 'DESC',
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'og_uid_node',
'field' => 'currentuid',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
),
array(
'tablename' => 'history',
'field' => 'timestamp',
'operator' => '0',
'options' => '',
'value' => array(
0 => '0',
),
),
);
$view->exposed_filter = array();
$view->requires = array(
'og_node_data',
'node',
'users',
'node_comment_statistics',
'og_uid_node',
'history',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_ghp_ron';
$view->description = t('OG: Group home page - River of news. Default');
$view->page = TRUE;
$view->page_type = 'teaser';
$view->access = array();
$view->view_args_php = '';
$view->sort = array(
array(
'tablename' => 'node',
'field' => 'sticky',
'sortorder' => 'DESC',
'options' => '',
),
array(
'tablename' => 'node',
'field' => 'created',
'sortorder' => 'DESC',
'options' => '',
),
);
$view->argument = array(
array(
'type' => 'gid',
'argdefault' => '1',
'title' => '%1',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
);
$view->use_pager = TRUE;
$view->nodes_per_page = '50';
$view->exposed_filter = array();
$view->requires = array(
node,
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_my';
$view->description = t("List user's subscribed groups and provide link to manage subscription");
$view->access = array(
0 => '2',
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('My groups');
$view->page_header = t('You might be interested in an <a href="!url" rel="nofollow">OPML feed containing feeds from all your subscribed groups</a>.', array(
'!url' => url('og/opml'),
));
$view->page_header_format = '1';
$view->page_footer = '<?php
$url = url("og/opml");
return theme(\'opml_icon\', $url);
?>';
$view->page_footer_format = '2';
$view->page_empty = t('No subscribed groups');
$view->page_empty_format = '1';
$view->page_type = 'table';
$view->url = 'og/my';
$view->use_pager = TRUE;
$view->nodes_per_page = '50';
$view->menu = TRUE;
$view->menu_title = '';
$view->menu_tab = TRUE;
$view->menu_tab_weight = '0';
$view->menu_tab_default = FALSE;
$view->menu_tab_default_parent = NULL;
$view->menu_tab_default_parent_type = 'tab';
$view->menu_parent_tab_weight = '0';
$view->menu_parent_title = '';
$view->sort = array(
array(
'tablename' => 'node',
'field' => 'title',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->argument = array(
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Group'),
'handler' => 'views_handler_field_nodelink',
'options' => 'link',
),
array(
'tablename' => 'users',
'field' => 'name',
'label' => t('Manager'),
),
array(
'tablename' => 'og',
'field' => 'count',
'label' => t('Members'),
),
array(
'tablename' => 'og_uid',
'field' => 'managelink',
'label' => t('Manage'),
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'og_uid',
'field' => 'currentuidsimple',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
),
array(
'tablename' => 'og_views',
'field' => 'og_type',
'operator' => '=',
'options' => '',
'value' => '0',
),
);
$view->exposed_filter = array();
$view->requires = array(
'node',
'users',
'og',
'og_uid',
'og_views',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og';
$view->description = 'groups directory';
$view->access = array();
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('Groups directory');
$view->page_header = '';
$view->page_header_format = '2';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = t('No groups');
$view->page_empty_format = '1';
$view->page_type = 'table';
$view->url = 'og/all';
$view->use_pager = TRUE;
$view->nodes_per_page = '90';
$view->menu = TRUE;
$view->menu_title = t('Groups');
$view->menu_tab = TRUE;
$view->menu_tab_weight = '-5';
$view->menu_tab_default = TRUE;
$view->menu_tab_default_parent = NULL;
$view->menu_tab_default_parent_type = 'normal';
$view->menu_parent_tab_weight = '-5';
$view->menu_parent_title = '';
$view->sort = array();
$view->argument = array(
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Group'),
'handler' => 'views_handler_field_nodelink',
'sortable' => '1',
'options' => 'link',
),
array(
'tablename' => 'users',
'field' => 'name',
'label' => t('Manager'),
),
array(
'tablename' => 'og',
'field' => 'count',
'label' => t('Members'),
),
array(
'tablename' => 'og',
'field' => 'description',
'label' => t('Description'),
),
array(
'tablename' => 'og',
'field' => 'subscribe',
'label' => t('Join'),
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'og',
'field' => 'directory',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'node',
'field' => 'title',
'operator' => 'contains',
'options' => '',
'value' => '\'\'',
),
array(
'tablename' => 'og_views',
'field' => 'og_type',
'operator' => '=',
'options' => '',
'value' => '0',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Search for a group by name'),
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '0',
),
);
$view->requires = array(
'node',
'users',
'og',
'og_views',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_tracker';
$view->description = t('Shows active posts across the whole site');
$view->access = array();
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('Recent posts across whole site');
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = '';
$view->page_empty_format = '1';
$view->page_type = 'table';
$view->url = 'group/tracker';
$view->use_pager = TRUE;
$view->nodes_per_page = '25';
$view->menu = TRUE;
$view->menu_title = t('Recent posts');
$view->menu_tab = TRUE;
$view->menu_tab_weight = '5';
$view->menu_tab_default = FALSE;
$view->menu_tab_default_parent = NULL;
$view->menu_tab_default_parent_type = 'tab';
$view->menu_parent_tab_weight = '0';
$view->menu_parent_title = '';
$view->sort = array(
array(
'tablename' => 'node_comment_statistics',
'field' => 'last_comment_timestamp',
'sortorder' => 'DESC',
'options' => 'normal',
),
);
$view->argument = array(
array(
'type' => 'uid',
'argdefault' => '2',
'title' => t('Recent posts for %1'),
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
array(
'type' => 'rss_feed',
'argdefault' => '2',
'title' => '',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'node',
'field' => 'type',
'label' => 'Type',
),
array(
'tablename' => 'node',
'field' => 'title',
'label' => t('Title'),
'handler' => 'views_handler_field_nodelink_with_mark',
'options' => 'link',
),
array(
'tablename' => 'users',
'field' => 'name',
'label' => t('Author'),
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'comment_count',
'label' => t('Replies'),
'handler' => 'views_handler_comments_with_new',
),
array(
'tablename' => 'og_node_data',
'field' => 'title',
'label' => t('Groups'),
),
array(
'tablename' => 'node_comment_statistics',
'field' => 'last_comment_timestamp',
'label' => t('Last post'),
'handler' => 'views_handler_field_since',
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
);
$view->exposed_filter = array();
$view->requires = array(
'node_comment_statistics',
'node',
'users',
'og_node_data',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_search';
$view->description = t('Search within a particular group');
$view->access = array();
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = t('Search');
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = t('No posts found.');
$view->page_empty_format = '1';
$view->page_type = 'teaser';
$view->url = 'og/search';
$view->use_pager = TRUE;
$view->nodes_per_page = '50';
$view->sort = array(
array(
'tablename' => 'node',
'field' => 'created',
'sortorder' => 'DESC',
'options' => 'normal',
),
);
$view->argument = array(
array(
'type' => 'gid',
'argdefault' => '1',
'title' => t('Search results for %1'),
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array();
$view->filter = array(
array(
'tablename' => 'temp_search_results',
'field' => 'word',
'operator' => '=',
'options' => '',
'value' => '',
),
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'temp_search_results',
'field' => 'word',
'label' => t('Enter keyword'),
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
);
$view->requires = array(
'node',
'temp_search_results',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_comments_recent';
$view->description = t('Display recent comments block in a group');
$view->access = array();
$view->view_args_php = '';
$view->block = TRUE;
$view->block_title = t('Recent comments');
$view->block_header = '';
$view->block_header_format = '1';
$view->block_footer = '';
$view->block_footer_format = '1';
$view->block_empty = '';
$view->block_empty_format = '1';
$view->block_type = 'list';
$view->nodes_per_block = '10';
$view->block_more = FALSE;
$view->block_use_page_header = FALSE;
$view->block_use_page_footer = FALSE;
$view->block_use_page_empty = FALSE;
$view->sort = array(
array(
'tablename' => 'comments',
'field' => 'timestamp',
'sortorder' => 'DESC',
'options' => 'normal',
),
);
$view->argument = array();
$view->field = array(
array(
'tablename' => 'comments',
'field' => 'subject',
'label' => '',
'handler' => 'views_handler_field_commentlink',
'options' => 'link',
),
array(
'tablename' => 'comments',
'field' => 'name',
'label' => '',
),
);
$view->filter = array(
array(
'tablename' => 'node_comment_statistics',
'field' => 'comment_count',
'operator' => '>=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'comments',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => COMMENT_PUBLISHED,
),
array(
'tablename' => 'og_ancestry',
'field' => 'picg',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_GID***',
),
);
$view->exposed_filter = array();
$view->requires = array(
'comments',
'node_comment_statistics',
'og_ancestry',
);
$views[$view->name] = $view;
$view = new stdClass();
$view->name = 'og_recent_type_term';
$view->description = t('Recent posts for current term filtered by node type and/or taxonomy term');
$view->access = array();
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = '';
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = '';
$view->page_empty_format = '1';
$view->page_type = 'list';
$view->url = '';
$view->use_pager = TRUE;
$view->nodes_per_page = '10';
$view->sort = array(
array(
'tablename' => 'node',
'field' => 'sticky',
'sortorder' => 'DESC',
'options' => '',
),
array(
'tablename' => 'node',
'field' => 'created',
'sortorder' => 'DESC',
'options' => 'normal',
),
);
$view->argument = array(
array(
'type' => 'nodetype',
'argdefault' => '2',
'title' => '%1',
'options' => '',
'wildcard' => '*',
'wildcard_substitution' => 'all',
),
array(
'type' => 'taxletter',
'argdefault' => '2',
'title' => '%1 - %2',
'options' => '',
'wildcard' => '',
'wildcard_substitution' => '',
),
);
$view->field = array(
array(
'tablename' => 'node',
'field' => 'title',
'label' => '',
'handler' => 'views_handler_field_nodelink_with_mark',
'options' => 'link',
),
);
$view->filter = array(
array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array(
'tablename' => 'og_ancestry',
'field' => 'picg',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_GID***',
),
);
$view->exposed_filter = array();
$view->requires = array(
'node',
'og_ancestry',
);
$views[$view->name] = $view;
return $views;
}
function og_handler_field_count($fieldinfo, $fielddata, $value, $data) {
global $user;
$cnt = db_num_rows(db_query(og_list_users_sql(), $data->nid));
return in_array($data->nid, array_keys($user->og_groups)) ? l($cnt, "og/users/{$data->nid}") : $cnt;
}
function og_handler_field_private($fieldinfo, $fielddata, $value, $data) {
return $value ? t('Private') : t('Public');
}
function og_handler_field_language($fieldinfo, $fielddata, $value, $data) {
global $locale;
$languages = module_invoke('locale', 'supported_languages', FALSE, TRUE);
if ($languages['name'][$value] && $value != key($languages['name'])) {
return $languages['name'][$value];
}
}
function og_handler_post_count($fieldinfo, $fielddata, $value, $data) {
$where = '';
if ($fielddata['options'] != 'all') {
$where = " AND n.type = '%s'";
}
$cnt = db_result(db_query(db_rewrite_sql("SELECT COUNT(n.nid) FROM {node} n INNER JOIN {og_ancestry} oga ON n.nid = oga.nid WHERE n.status = 1 AND oga.group_nid = %d {$where}"), $data->nid, $fielddata['options']));
return $cnt;
}
function og_handler_post_count_new($fieldinfo, $fielddata, $value, $data) {
global $user;
$cnt = db_result(db_query(db_rewrite_sql('SELECT COUNT(*) FROM {node} n INNER JOIN {og_ancestry} oga ON n.nid = oga.nid LEFT JOIN {history} h ON n.nid=h.nid AND h.uid = %d WHERE n.status = 1 AND oga.group_nid = %d AND h.timestamp IS NULL AND n.created > %d'), $user->uid, $data->nid, NODE_NEW_LIMIT));
if ($cnt) {
if ($fielddata['options'] == 'normal') {
return $cnt;
}
else {
return $cnt . theme('mark', MARK_NEW);
}
}
}
function og_handler_field_subscribe($fieldinfo, $fielddata, $value, $data) {
global $user;
if (!in_array($data->nid, array_keys($user->og_groups))) {
switch ($data->og_selective) {
case OG_CLOSED:
return '<em>' . t('Closed') . '</em>';
case OG_INVITE_ONLY:
return '<em>' . t('Invite only') . '</em>';
default:
return og_subscribe_link($data);
}
}
}
function og_handler_filter_public($op, $filter, $filterinfo, &$query) {
$query
->ensure_table('og_ancestry');
if ($filter['value']) {
$query
->add_where('(og_ancestry.is_public IS NULL OR og_ancestry.is_public = 1)');
}
else {
$query
->add_where('og_ancestry.is_public = 0');
}
}
function og_handler_field_nodelink($fieldinfo, $fielddata, $value, $data) {
$result = og_get_node_groups_result($data->nid);
while ($row = db_fetch_object($result)) {
$links[] = l($row->title, "node/{$row->group_nid}");
}
if ($links) {
return implode(', ', $links);
}
}
function og_handler_field_managelink($fieldinfo, $fielddata, $value, $data) {
return l(t('my membership'), "og/manage/{$data->nid}", NULL, drupal_get_destination());
}
function og_handler_field_yesempty($fieldinfo, $fielddata, $value, $data) {
return $value ? t('yes') : '';
}
function og_handler_filter_gid($op, $filter, $filterinfo, &$query) {
og_views_break_phrase($filter['value'], $query);
}
function og_handler_filter_og_type($op, $filter, $filterinfo, &$query) {
list($types, $in) = og_get_sql_args();
$query
->add_where("node.type {$in}", $types);
}
function og_handler_filter_post_og_type($op, $filter, $filterinfo, &$query) {
$query
->ensure_table('og_ancestry');
$query
->add_table('og_node_data');
$types = $filter['value'];
$placeholders = array_fill(0, count($types), "'%s'");
if ($filter['operator'] == 'NOR') {
$not = 'NOT';
$ornull = ' OR (og_node_data.type IS NULL)';
}
$query
->add_where("(og_node_data.type " . $not . " IN (" . implode(", ", $placeholders) . "))" . $ornull, $types);
}
function og_handler_filter_picg($op, $filter, $filterinfo, &$query) {
$query
->ensure_table('og_ancestry');
$query
->add_where("og_ancestry.group_nid = ***CURRENT_GID***");
}
function views_handler_filter_groupcurrent() {
return array(
'***CURRENT_GID***' => t('Current group'),
);
}
function og_handler_filter_group_name_like($op, $filter, $filterinfo, &$query) {
$query
->ensure_table('og_node_data');
$filterinfo['table'] = 'og_node_data';
$filterinfo['field'] = 'title';
views_handler_filter_like($op, $filter, $filterinfo, $query);
}
function og_views_query_substitutions($view) {
$groupnode = og_get_group_context();
return array(
'***CURRENT_GID***' => $groupnode ? $groupnode->nid : -1,
);
}
function og_views_url_tokens() {
return array(
'$group' => 'og_url_group',
);
}
function og_views_break_phrase($string, &$query) {
list($and_or, $gids) = _views_break_phrase($string);
$and_or = strtoupper($and_or);
if ($and_or == 'OR') {
$query
->ensure_table('og_ancestry');
$cond = array_fill(0, count($gids), "og_ancestry.group_nid = %d");
$query
->add_where(implode(" {$and_or} ", $cond), $gids);
}
else {
foreach ((array) $gids as $gid) {
$num = $query
->add_table('og_ancestry');
$tablename = $query
->get_table_name('og_ancestry', $num);
$query
->add_where("{$tablename}.group_nid = %d", $gid);
}
}
if ($GLOBALS['current_view']->build_type == 'page' && is_numeric($gids[0])) {
$node = node_load($gids[0]);
og_set_group_context($node);
}
}
