franck@0: <?php
franck@2: // $Id: og_statistics.views.inc,v 1.2.2.2 2009/08/12 19:53:28 dereine Exp $
franck@0: 
franck@0: /**
franck@0:  * @file
franck@0:  *   Views Integration of og_statitics.
franck@0:  */
franck@0: 
franck@0: /**
franck@0:  * Implementation of hook_views_data().
franck@0:  */
franck@0: function og_statistics_views_data() {
franck@0:   $data = array();
franck@0:   $data += og_statistics_views_og_statistics();
franck@0:   return $data;
franck@0: }
franck@0: 
franck@0: function og_statistics_views_og_statistics() {
franck@0:   $data['og_statistics']['table']['group'] = t('OG Statistics');
franck@0: 
franck@0:   $data['og_statistics']['table']['join'] = array(
franck@0:     'node' => array(
franck@0:       'left_field' => 'nid',
franck@0:       'field' => 'nid',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['members_count'] = array(
franck@0:     'title' => t('Group Statistic: Members Count'),
franck@0:     'real field' => 'members_count',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['posts_count'] = array(
franck@0:     'title' => t('Group Statistic: Posts Count'),
franck@0:     'real field' => 'posts_count',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['comments_count'] = array(
franck@0:     'title' => t('Group Statistic: Comments Count'),
franck@0:     'real field' => 'comments_count',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['last_node_timestamp'] = array(
franck@0:     'title' => t('Group Statistic: Last inserted/updated Node-time'),
franck@0:     'real field' => 'last_node_timestamp',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort_date',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['last_comment_timestamp'] = array(
franck@0:     'title' => t('Group Statistic: Last Comment-time'),
franck@0:     'real field' => 'last_comment_timestamp',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort_date',
franck@0:     ),
franck@0:   );
franck@0:   $data['og_statistics']['last_member_timestamp'] = array(
franck@0:     'title' => t('Group Statistic: last Member subscription'),
franck@0:     'real field' => 'last_member_timestamp',
franck@0:     'field' => array(
franck@0:       'handler' => 'views_handler_field_numeric',
franck@0:       'click sortable' => TRUE,
franck@0:     ),
franck@0:     'sort' => array(
franck@0:       'handler' => 'views_handler_sort_date',
franck@0:     ),
franck@0:   );
franck@2: 
franck@2:   // Add relationship to node table for last node posted.
franck@2:   $data['og_statistics']['last_node_nid'] = array(
franck@2:     'title' => 'Group Statistic: Last Node posted',
franck@2:     'help' => 'Create a relationship to for the last node posted',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'node',
franck@2:       'field' => 'nid',
franck@2:       'label' => t('node'),
franck@2:     ),
franck@2:   );
franck@2:   // Add relationship to user table for last node posted.
franck@2:   $data['og_statistics']['last_node_uid'] = array(
franck@2:     'title' => 'Group Statistic: User that created the last node posted',
franck@2:     'help' => 'Create a relationship to the user that last posted a node.',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'users',
franck@2:       'field' => 'uid',
franck@2:       'label' => t('user'),
franck@2:     ),
franck@2:   );
franck@2: 
franck@2:   // Add relationship to node table for last comment posted.
franck@2:   $data['og_statistics']['last_comment_nid'] = array(
franck@2:     'title' => 'Group Statistic: Node the last comment was posted to',
franck@2:     'help' => 'Create a relationship to the last comment posted',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'node',
franck@2:       'field' => 'nid',
franck@2:       'label' => t('node'),
franck@2:     ),
franck@2:   );
franck@2:   // Add relationship to user table for last comment posted.
franck@2:   $data['og_statistics']['last_comment_uid'] = array(
franck@2:     'title' => 'Group Statistic: User that posted the last comment',
franck@2:     'help' => 'Create a relationship to the user that last posted a comment.',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'users',
franck@2:       'field' => 'uid',
franck@2:       'label' => t('user'),
franck@2:     ),
franck@2:   );
franck@2:   // Add relationship to the comment table for the last comment posted.
franck@2:   $data['og_statistics']['last_comment_cid'] = array(
franck@2:     'title' => 'Group Statistic: Comment last posted',
franck@2:     'help' => 'Create a relationship to the last comment posted',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'comments',
franck@2:       'field' => 'cid',
franck@2:       'label' => t('comment'),
franck@2:     ),
franck@2:   );
franck@2: 
franck@2:   // Add relationship to the users table for the last member.
franck@2:   $data['og_statistics']['last_member_uid'] = array(
franck@2:     'title' => 'Group Statistic: Last member to join',
franck@2:     'help' => 'Create a relationship to the last user to join',
franck@2:     'relationship' => array(
franck@2:       'handler' => 'views_handler_relationship',
franck@2:       'base' => 'users',
franck@2:       'field' => 'uid',
franck@2:       'label' => t('user'),
franck@2:     ),
franck@2:   );
franck@2:   
franck@0:   return $data;
franck@0: }
franck@0: