aboutsummaryrefslogtreecommitdiff
path: root/views/default/admin/settings/tidypics/stats.php
blob: 25ace77dabc15e9ceb625fb3c0a4da6bc471f423 (plain)
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
<?php
/**
 * Tidypics admin stats page.
 */

$stats = array();

// number of images
$img_type = get_subtype_id('object', 'image');
$query = "SELECT count(guid) as total from {$CONFIG->dbprefix}entities where subtype={$img_type}";
$total = get_data_row($query);
$num_images = $total->total;
$stats['images'] = $total->total;

// number of albums
$img_type = get_subtype_id('object', 'album');
$query = "SELECT count(guid) as total from {$CONFIG->dbprefix}entities where subtype={$img_type}";
$total = get_data_row($query);
$num_albums = $total->total;
$stats['albums'] = $total->total;

$options = array(
	'count' => true,
	'type' => 'object',
	'subtype' => 'image',
	'annotation_name' => 'generic_comment'
);

// number of comments on photos
$stats['photo_comments'] = elgg_get_annotations($options);

// number of comments on albums
$options['subtype'] = 'album';
$stats['album_comments'] = elgg_get_annotations($options);

// number of views on images
$options['subtype'] = 'image';
$options['annotation_name'] = 'tp_view';
$stats['views'] = elgg_get_annotations($options);

// number of photo tags on images
if (elgg_get_plugin_setting('tagging', 'tidypics') != 'disabled') {
	$options['annotation_name'] = 'phototag';
	$stats['tags'] = elgg_get_annotations($options);
}

$content = '<table class="elgg-table-alt">';

foreach ($stats as $str => $value) {
	$str = elgg_echo("tidypics:stats:$str");
	$value = (int)$value;
	
	$content .= <<<HTML
	<tr>
		<td>$str:</td>
		<td>$value</td>
	</tr>
HTML;
}

$content .= '</table>';

echo elgg_view_module('inline', elgg_echo('tidypics:stats'), $content);