1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
<?php
function timestats($type, $subtype, $relative = false){
// Start date
$entities = elgg_get_entities(array('types' => $type,'subtypes'=>$subtype,'limit' => 1,'order_by'=>'e.time_created asc'));
$firstentity = $entities[0];
$initial_time = $firstentity->time_created;
$initial_date = getdate($initial_time);
$start_month = mktime(0, 0, 0, $initial_date["mon"], 1, $initial_date["year"]);
$current_date = $start_month;
// End date
$last_time = time();
$last_date = getdate($last_time);
// Interval (week)
$interval = 7*24*60*60;
$total = elgg_get_entities(array('types' => $type,'subtypes'=>$subtype,'limit' => 99999, 'count'=>true));
$timestats = array();
while($current_date<$last_time) {
$count = elgg_get_entities(array(
'types' => $type,
'subtypes' => $subtype,
'limit' => 99999,
'count' => true,
'created_time_lower' => $current_date,
'created_time_upper'=>$current_date+$interval
));
if (empty($count))
$count = 0;
$accumulated += $count;
$timestats[$current_date] = $relative? $count : $accumulated;
$current_date += $interval;
}
return $timestats;
}
function timestats_setup_sidebar_menu(){
$tabs = array(
'user' => array(
'text' => elgg_echo('item:user'),
'href' => 'graphs/timestats?type=user',
'priority' => 200,
),
'group' => array(
'text' => elgg_echo('groups'),
'href' => 'graphs/timestats?type=group',
'priority' => 300,
),
);
$db_prefix = elgg_get_config('dbprefix');
$result = get_data("SELECT * from {$db_prefix}entity_subtypes");
foreach($result as $row){
$type = $row->type;
$subtype = $row->subtype;
$tabs[$type.':'.$subtype] = array(
'text' => elgg_echo("item:$type:$subtype"),
'href' => "graphs/timestats?type=$type&subtype=$subtype",
'priority' => 400,
);
}
unset($tabs['object:plugin']);
unset($tabs['object:widget']);
// sets default selected item
if (strpos(full_url(), 'type') === false) {
$tabs['user']['selected'] = true;
}
foreach ($tabs as $name => $tab) {
$tab['name'] = $name;
elgg_register_menu_item('page', $tab);
}
}
|
