franck@0
|
1 <?php |
franck@2
|
2 // $Id: og_statistics.views.inc,v 1.2.2.2 2009/08/12 19:53:28 dereine Exp $ |
franck@0
|
3 |
franck@0
|
4 /** |
franck@0
|
5 * @file |
franck@0
|
6 * Views Integration of og_statitics. |
franck@0
|
7 */ |
franck@0
|
8 |
franck@0
|
9 /** |
franck@0
|
10 * Implementation of hook_views_data(). |
franck@0
|
11 */ |
franck@0
|
12 function og_statistics_views_data() { |
franck@0
|
13 $data = array(); |
franck@0
|
14 $data += og_statistics_views_og_statistics(); |
franck@0
|
15 return $data; |
franck@0
|
16 } |
franck@0
|
17 |
franck@0
|
18 function og_statistics_views_og_statistics() { |
franck@0
|
19 $data['og_statistics']['table']['group'] = t('OG Statistics'); |
franck@0
|
20 |
franck@0
|
21 $data['og_statistics']['table']['join'] = array( |
franck@0
|
22 'node' => array( |
franck@0
|
23 'left_field' => 'nid', |
franck@0
|
24 'field' => 'nid', |
franck@0
|
25 ), |
franck@0
|
26 ); |
franck@0
|
27 $data['og_statistics']['members_count'] = array( |
franck@0
|
28 'title' => t('Group Statistic: Members Count'), |
franck@0
|
29 'real field' => 'members_count', |
franck@0
|
30 'field' => array( |
franck@0
|
31 'handler' => 'views_handler_field_numeric', |
franck@0
|
32 'click sortable' => TRUE, |
franck@0
|
33 ), |
franck@0
|
34 'sort' => array( |
franck@0
|
35 'handler' => 'views_handler_sort', |
franck@0
|
36 ), |
franck@0
|
37 ); |
franck@0
|
38 $data['og_statistics']['posts_count'] = array( |
franck@0
|
39 'title' => t('Group Statistic: Posts Count'), |
franck@0
|
40 'real field' => 'posts_count', |
franck@0
|
41 'field' => array( |
franck@0
|
42 'handler' => 'views_handler_field_numeric', |
franck@0
|
43 'click sortable' => TRUE, |
franck@0
|
44 ), |
franck@0
|
45 'sort' => array( |
franck@0
|
46 'handler' => 'views_handler_sort', |
franck@0
|
47 ), |
franck@0
|
48 ); |
franck@0
|
49 $data['og_statistics']['comments_count'] = array( |
franck@0
|
50 'title' => t('Group Statistic: Comments Count'), |
franck@0
|
51 'real field' => 'comments_count', |
franck@0
|
52 'field' => array( |
franck@0
|
53 'handler' => 'views_handler_field_numeric', |
franck@0
|
54 'click sortable' => TRUE, |
franck@0
|
55 ), |
franck@0
|
56 'sort' => array( |
franck@0
|
57 'handler' => 'views_handler_sort', |
franck@0
|
58 ), |
franck@0
|
59 ); |
franck@0
|
60 $data['og_statistics']['last_node_timestamp'] = array( |
franck@0
|
61 'title' => t('Group Statistic: Last inserted/updated Node-time'), |
franck@0
|
62 'real field' => 'last_node_timestamp', |
franck@0
|
63 'field' => array( |
franck@0
|
64 'handler' => 'views_handler_field_numeric', |
franck@0
|
65 'click sortable' => TRUE, |
franck@0
|
66 ), |
franck@0
|
67 'sort' => array( |
franck@0
|
68 'handler' => 'views_handler_sort_date', |
franck@0
|
69 ), |
franck@0
|
70 ); |
franck@0
|
71 $data['og_statistics']['last_comment_timestamp'] = array( |
franck@0
|
72 'title' => t('Group Statistic: Last Comment-time'), |
franck@0
|
73 'real field' => 'last_comment_timestamp', |
franck@0
|
74 'field' => array( |
franck@0
|
75 'handler' => 'views_handler_field_numeric', |
franck@0
|
76 'click sortable' => TRUE, |
franck@0
|
77 ), |
franck@0
|
78 'sort' => array( |
franck@0
|
79 'handler' => 'views_handler_sort_date', |
franck@0
|
80 ), |
franck@0
|
81 ); |
franck@0
|
82 $data['og_statistics']['last_member_timestamp'] = array( |
franck@0
|
83 'title' => t('Group Statistic: last Member subscription'), |
franck@0
|
84 'real field' => 'last_member_timestamp', |
franck@0
|
85 'field' => array( |
franck@0
|
86 'handler' => 'views_handler_field_numeric', |
franck@0
|
87 'click sortable' => TRUE, |
franck@0
|
88 ), |
franck@0
|
89 'sort' => array( |
franck@0
|
90 'handler' => 'views_handler_sort_date', |
franck@0
|
91 ), |
franck@0
|
92 ); |
franck@2
|
93 |
franck@2
|
94 // Add relationship to node table for last node posted. |
franck@2
|
95 $data['og_statistics']['last_node_nid'] = array( |
franck@2
|
96 'title' => 'Group Statistic: Last Node posted', |
franck@2
|
97 'help' => 'Create a relationship to for the last node posted', |
franck@2
|
98 'relationship' => array( |
franck@2
|
99 'handler' => 'views_handler_relationship', |
franck@2
|
100 'base' => 'node', |
franck@2
|
101 'field' => 'nid', |
franck@2
|
102 'label' => t('node'), |
franck@2
|
103 ), |
franck@2
|
104 ); |
franck@2
|
105 // Add relationship to user table for last node posted. |
franck@2
|
106 $data['og_statistics']['last_node_uid'] = array( |
franck@2
|
107 'title' => 'Group Statistic: User that created the last node posted', |
franck@2
|
108 'help' => 'Create a relationship to the user that last posted a node.', |
franck@2
|
109 'relationship' => array( |
franck@2
|
110 'handler' => 'views_handler_relationship', |
franck@2
|
111 'base' => 'users', |
franck@2
|
112 'field' => 'uid', |
franck@2
|
113 'label' => t('user'), |
franck@2
|
114 ), |
franck@2
|
115 ); |
franck@2
|
116 |
franck@2
|
117 // Add relationship to node table for last comment posted. |
franck@2
|
118 $data['og_statistics']['last_comment_nid'] = array( |
franck@2
|
119 'title' => 'Group Statistic: Node the last comment was posted to', |
franck@2
|
120 'help' => 'Create a relationship to the last comment posted', |
franck@2
|
121 'relationship' => array( |
franck@2
|
122 'handler' => 'views_handler_relationship', |
franck@2
|
123 'base' => 'node', |
franck@2
|
124 'field' => 'nid', |
franck@2
|
125 'label' => t('node'), |
franck@2
|
126 ), |
franck@2
|
127 ); |
franck@2
|
128 // Add relationship to user table for last comment posted. |
franck@2
|
129 $data['og_statistics']['last_comment_uid'] = array( |
franck@2
|
130 'title' => 'Group Statistic: User that posted the last comment', |
franck@2
|
131 'help' => 'Create a relationship to the user that last posted a comment.', |
franck@2
|
132 'relationship' => array( |
franck@2
|
133 'handler' => 'views_handler_relationship', |
franck@2
|
134 'base' => 'users', |
franck@2
|
135 'field' => 'uid', |
franck@2
|
136 'label' => t('user'), |
franck@2
|
137 ), |
franck@2
|
138 ); |
franck@2
|
139 // Add relationship to the comment table for the last comment posted. |
franck@2
|
140 $data['og_statistics']['last_comment_cid'] = array( |
franck@2
|
141 'title' => 'Group Statistic: Comment last posted', |
franck@2
|
142 'help' => 'Create a relationship to the last comment posted', |
franck@2
|
143 'relationship' => array( |
franck@2
|
144 'handler' => 'views_handler_relationship', |
franck@2
|
145 'base' => 'comments', |
franck@2
|
146 'field' => 'cid', |
franck@2
|
147 'label' => t('comment'), |
franck@2
|
148 ), |
franck@2
|
149 ); |
franck@2
|
150 |
franck@2
|
151 // Add relationship to the users table for the last member. |
franck@2
|
152 $data['og_statistics']['last_member_uid'] = array( |
franck@2
|
153 'title' => 'Group Statistic: Last member to join', |
franck@2
|
154 'help' => 'Create a relationship to the last user to join', |
franck@2
|
155 'relationship' => array( |
franck@2
|
156 'handler' => 'views_handler_relationship', |
franck@2
|
157 'base' => 'users', |
franck@2
|
158 'field' => 'uid', |
franck@2
|
159 'label' => t('user'), |
franck@2
|
160 ), |
franck@2
|
161 ); |
franck@2
|
162 |
franck@0
|
163 return $data; |
franck@0
|
164 } |
franck@0
|
165 |