Context Navigation

source: trunk/admin/history.php @ 22679

Last change on this file since 22679 was 21894, checked in by rvelices, 12 years ago
tag names in admin history search were not being displayed using rander_tag_name event
Property svn:eol-style set to `LF`
File size: 18.2 KB

Line
1	<?php
2	// +-----------------------------------------------------------------------+
3	// \| Piwigo - a PHP based photo gallery \|
4	// +-----------------------------------------------------------------------+
5	// \| Copyright(C) 2008-2013 Piwigo Team http://piwigo.org \|
6	// \| Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net \|
7	// \| Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick \|
8	// +-----------------------------------------------------------------------+
9	// \| This program is free software; you can redistribute it and/or modify \|
10	// \| it under the terms of the GNU General Public License as published by \|
11	// \| the Free Software Foundation \|
12	// \| \|
13	// \| This program is distributed in the hope that it will be useful, but \|
14	// \| WITHOUT ANY WARRANTY; without even the implied warranty of \|
15	// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU \|
16	// \| General Public License for more details. \|
17	// \| \|
18	// \| You should have received a copy of the GNU General Public License \|
19	// \| along with this program; if not, write to the Free Software \|
20	// \| Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, \|
21	// \| USA. \|
22	// +-----------------------------------------------------------------------+
23
24	/**
25	* Display filtered history lines
26	*/
27
28	// +-----------------------------------------------------------------------+
29	// \| functions \|
30	// +-----------------------------------------------------------------------+
31
32	// +-----------------------------------------------------------------------+
33	// \| initialization \|
34	// +-----------------------------------------------------------------------+
35
36	if (!defined('PHPWG_ROOT_PATH'))
37	{
38	die('Hacking attempt!');
39	}
40
41	include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
42	include_once(PHPWG_ROOT_PATH.'admin/include/functions_history.inc.php');
43
44	if (isset($_GET['start']) and is_numeric($_GET['start']))
45	{
46	$page['start'] = $_GET['start'];
47	}
48	else
49	{
50	$page['start'] = 0;
51	}
52
53	$types = array('none', 'picture', 'high', 'other');
54
55	$display_thumbnails = array('no_display_thumbnail' => l10n('No display'),
56	'display_thumbnail_classic' => l10n('Classic display'),
57	'display_thumbnail_hoverbox' => l10n('Hoverbox display')
58	);
59
60	// +-----------------------------------------------------------------------+
61	// \| Check Access and exit when user status is not ok \|
62	// +-----------------------------------------------------------------------+
63
64	check_status(ACCESS_ADMINISTRATOR);
65
66	// +-----------------------------------------------------------------------+
67	// \| Build search criteria and redirect to results \|
68	// +-----------------------------------------------------------------------+
69
70	$page['errors'] = array();
71	$search = array();
72
73	if (isset($_POST['submit']))
74	{
75	// dates
76	if (!empty($_POST['start_year']))
77	{
78	$search['fields']['date-after'] = sprintf(
79	'%d-%02d-%02d',
80	$_POST['start_year'],
81	$_POST['start_month'],
82	$_POST['start_day']
83	);
84	}
85
86	if (!empty($_POST['end_year']))
87	{
88	$search['fields']['date-before'] = sprintf(
89	'%d-%02d-%02d',
90	$_POST['end_year'],
91	$_POST['end_month'],
92	$_POST['end_day']
93	);
94	}
95
96	if (empty($_POST['types']))
97	{
98	$search['fields']['types'] = $types;
99	}
100	else
101	{
102	$search['fields']['types'] = $_POST['types'];
103	}
104
105	$search['fields']['user'] = $_POST['user'];
106
107	if (!empty($_POST['image_id']))
108	{
109	$search['fields']['image_id'] = intval($_POST['image_id']);
110	}
111
112	if (!empty($_POST['filename']))
113	{
114	$search['fields']['filename'] = str_replace(
115	'*',
116	'%',
117	pwg_db_real_escape_string($_POST['filename'])
118	);
119	}
120
121	if (!empty($_POST['ip']))
122	{
123	$search['fields']['ip'] = str_replace(
124	'*',
125	'%',
126	pwg_db_real_escape_string($_POST['ip'])
127	);
128	}
129
130	$search['fields']['display_thumbnail'] = $_POST['display_thumbnail'];
131	// Display choise are also save to one cookie
132	if (!empty($_POST['display_thumbnail'])
133	and isset($display_thumbnails[$_POST['display_thumbnail']]))
134	{
135	$cookie_val = $_POST['display_thumbnail'];
136	}
137	else
138	{
139	$cookie_val = null;
140	}
141
142	pwg_set_cookie_var('display_thumbnail', $cookie_val, strtotime('+1 month') );
143
144	// TODO manage inconsistency of having $_POST['image_id'] and
145	// $_POST['filename'] simultaneously
146
147	if (!empty($search))
148	{
149	// register search rules in database, then they will be available on
150	// thumbnails page and picture page.
151	$query ='
152	INSERT INTO '.SEARCH_TABLE.'
153	(rules)
154	VALUES
155	(\''.serialize($search).'\')
156	;';
157	pwg_query($query);
158
159	$search_id = pwg_db_insert_id(SEARCH_TABLE);
160
161	redirect(
162	PHPWG_ROOT_PATH.'admin.php?page=history&search_id='.$search_id
163	);
164	}
165	else
166	{
167	array_push($page['errors'], l10n('Empty query. No criteria has been entered.'));
168	}
169	}
170
171	// +-----------------------------------------------------------------------+
172	// \| template init \|
173	// +-----------------------------------------------------------------------+
174
175	$template->set_filename('history', 'history.tpl');
176
177	// TabSheet initialization
178	history_tabsheet();
179
180	$template->assign(
181	array(
182	'U_HELP' => get_root_url().'admin/popuphelp.php?page=history',
183	'F_ACTION' => get_root_url().'admin.php?page=history'
184	)
185	);
186
187	// +-----------------------------------------------------------------------+
188	// \| history lines \|
189	// +-----------------------------------------------------------------------+
190
191	if (isset($_GET['search_id'])
192	and $page['search_id'] = (int)$_GET['search_id'])
193	{
194	// what are the lines to display in reality ?
195	$query = '
196	SELECT rules
197	FROM '.SEARCH_TABLE.'
198	WHERE id = '.$page['search_id'].'
199	;';
200	list($serialized_rules) = pwg_db_fetch_row(pwg_query($query));
201
202	$page['search'] = unserialize($serialized_rules);
203
204	if (isset($_GET['user_id']))
205	{
206	if (!is_numeric($_GET['user_id']))
207	{
208	die('user_id GET parameter must be an integer value');
209	}
210
211	$page['search']['fields']['user'] = $_GET['user_id'];
212
213	$query ='
214	INSERT INTO '.SEARCH_TABLE.'
215	(rules)
216	VALUES
217	(\''.serialize($page['search']).'\')
218	;';
219	pwg_query($query);
220
221	$search_id = pwg_db_insert_id(SEARCH_TABLE);
222
223	redirect(
224	PHPWG_ROOT_PATH.'admin.php?page=history&search_id='.$search_id
225	);
226	}
227
228	$data = trigger_event('get_history', array(), $page['search'], $types);
229	usort($data, 'history_compare');
230
231	$page['nb_lines'] = count($data);
232
233	$history_lines = array();
234	$user_ids = array();
235	$username_of = array();
236	$category_ids = array();
237	$image_ids = array();
238	$has_tags = false;
239
240	foreach ($data as $row)
241	{
242	$user_ids[$row['user_id']] = 1;
243
244	if (isset($row['category_id']))
245	{
246	$category_ids[$row['category_id']] = 1;
247	}
248
249	if (isset($row['image_id']))
250	{
251	$image_ids[$row['image_id']] = 1;
252	}
253
254	if (isset($row['tag_ids']))
255	{
256	$has_tags = true;
257	}
258
259	$history_lines[] = $row;
260	}
261
262	// prepare reference data (users, tags, categories...)
263	if (count($user_ids) > 0)
264	{
265	$query = '
266	SELECT '.$conf['user_fields']['id'].' AS id
267	, '.$conf['user_fields']['username'].' AS username
268	FROM '.USERS_TABLE.'
269	WHERE id IN ('.implode(',', array_keys($user_ids)).')
270	;';
271	$result = pwg_query($query);
272
273	$username_of = array();
274	while ($row = pwg_db_fetch_assoc($result))
275	{
276	$username_of[$row['id']] = stripslashes($row['username']);
277	}
278	}
279
280	if (count($category_ids) > 0)
281	{
282	$query = '
283	SELECT id, uppercats
284	FROM '.CATEGORIES_TABLE.'
285	WHERE id IN ('.implode(',', array_keys($category_ids)).')
286	;';
287	$uppercats_of = simple_hash_from_query($query, 'id', 'uppercats');
288
289	$name_of_category = array();
290
291	foreach ($uppercats_of as $category_id => $uppercats)
292	{
293	$name_of_category[$category_id] = get_cat_display_name_cache(
294	$uppercats
295	);
296	}
297	}
298
299	if (count($image_ids) > 0)
300	{
301	$query = '
302	SELECT
303	id,
304	IF(name IS NULL, file, name) AS label,
305	filesize,
306	file,
307	path,
308	representative_ext
309	FROM '.IMAGES_TABLE.'
310	WHERE id IN ('.implode(',', array_keys($image_ids)).')
311	;';
312	// $label_of_image = simple_hash_from_query($query, 'id', 'label');
313	$label_of_image = array();
314	$filesize_of_image = array();
315	$file_of_image = array();
316	$path_of_image = array();
317	$representative_ext_of_image = array();
318
319	$result = pwg_query($query);
320	while ($row = pwg_db_fetch_assoc($result))
321	{
322	$label_of_image[ $row['id'] ] = $row['label'];
323
324	if (isset($row['filesize']))
325	{
326	$filesize_of_image[ $row['id'] ] = $row['filesize'];
327	}
328
329	$file_of_image[ $row['id'] ] = $row['file'];
330	$path_of_image[ $row['id'] ] = $row['path'];
331	$representative_ext_of_image[ $row['id'] ] = $row['representative_ext'];
332	}
333	}
334
335	if ($has_tags > 0)
336	{
337	$query = '
338	SELECT
339	id,
340	name
341	FROM '.TAGS_TABLE;
342	$name_of_tag = simple_hash_from_query($query, 'id', 'name');
343	}
344
345	$i = 0;
346	$first_line = $page['start'] + 1;
347	$last_line = $page['start'] + $conf['nb_logs_page'];
348
349	$summary['total_filesize'] = 0;
350	$summary['guests_IP'] = array();
351
352	foreach ($history_lines as $line)
353	{
354	if (isset($line['image_type']) and $line['image_type'] == 'high')
355	{
356	if (isset($filesize_of_image[$line['image_id']]))
357	{
358	$summary['total_filesize'] += $filesize_of_image[$line['image_id']];
359	}
360	}
361
362	if ($line['user_id'] == $conf['guest_id'])
363	{
364	if (!isset($summary['guests_IP'][ $line['IP'] ]))
365	{
366	$summary['guests_IP'][ $line['IP'] ] = 0;
367	}
368
369	$summary['guests_IP'][ $line['IP'] ]++;
370	}
371
372	$i++;
373
374	if ($i < $first_line or $i > $last_line)
375	{
376	continue;
377	}
378
379	$user_string = '';
380	if (isset($username_of[$line['user_id']]))
381	{
382	$user_string.= $username_of[$line['user_id']];
383	}
384	else
385	{
386	$user_string.= $line['user_id'];
387	}
388	$user_string.= ' <a href="';
389	$user_string.= PHPWG_ROOT_PATH.'admin.php?page=history';
390	$user_string.= '&search_id='.$page['search_id'];
391	$user_string.= '&user_id='.$line['user_id'];
392	$user_string.= '">+</a>';
393
394	$tags_string = '';
395	if (isset($line['tag_ids']))
396	{
397	$tags_string = preg_replace(
398	'/(\d+)/e',
399	'isset($name_of_tag["$1"]) ? trigger_event("render_tag_name", $name_of_tag["$1"]) : "$1"',
400	str_replace(
401	',',
402	', ',
403	$line['tag_ids']
404	)
405	);
406	}
407
408	$image_string = '';
409	if (isset($line['image_id']))
410	{
411	$picture_url = make_picture_url(
412	array(
413	'image_id' => $line['image_id'],
414	)
415	);
416
417	if (isset($file_of_image[$line['image_id']]))
418	{
419	$element = array(
420	'id' => $line['image_id'],
421	'file' => $file_of_image[$line['image_id']],
422	'path' => $path_of_image[$line['image_id']],
423	'representative_ext' => $representative_ext_of_image[$line['image_id']],
424	);
425	$thumbnail_display = $page['search']['fields']['display_thumbnail'];
426	}
427	else
428	{
429	$thumbnail_display = 'no_display_thumbnail';
430	}
431
432	$image_title = '('.$line['image_id'].')';
433
434	if (isset($label_of_image[$line['image_id']]))
435	{
436	$image_title.= ' '.$label_of_image[$line['image_id']];
437	}
438	else
439	{
440	$image_title.= ' unknown filename';
441	}
442
443	$image_string = '';
444
445	switch ($thumbnail_display)
446	{
447	case 'no_display_thumbnail':
448	{
449	$image_string= '<a href="'.$picture_url.'">'.$image_title.'</a>';
450	break;
451	}
452	case 'display_thumbnail_classic':
453	{
454	$image_string =
455	'<a class="thumbnail" href="'.$picture_url.'">'
456	.'<span><img src="'.DerivativeImage::thumb_url($element)
457	.'" alt="'.$image_title.'" title="'.$image_title.'">'
458	.'</span></a>';
459	break;
460	}
461	case 'display_thumbnail_hoverbox':
462	{
463	$image_string =
464	'<a class="over" href="'.$picture_url.'">'
465	.'<span><img src="'.DerivativeImage::thumb_url($element)
466	.'" alt="'.$image_title.'" title="'.$image_title.'">'
467	.'</span>'.$image_title.'</a>';
468	break;
469	}
470	}
471	}
472
473	$template->append(
474	'search_results',
475	array(
476	'DATE' => $line['date'],
477	'TIME' => $line['time'],
478	'USER' => $user_string,
479	'IP' => $line['IP'],
480	'IMAGE' => $image_string,
481	'TYPE' => $line['image_type'],
482	'SECTION' => $line['section'],
483	'CATEGORY' => isset($line['category_id'])
484	? ( isset($name_of_category[$line['category_id']])
485	? $name_of_category[$line['category_id']]
486	: 'deleted '.$line['category_id'] )
487	: '',
488	'TAGS' => $tags_string,
489	)
490	);
491	}
492
493	$summary['nb_guests'] = 0;
494	if (count(array_keys($summary['guests_IP'])) > 0)
495	{
496	$summary['nb_guests'] = count(array_keys($summary['guests_IP']));
497
498	// we delete the "guest" from the $username_of hash so that it is
499	// avoided in next steps
500	unset($username_of[ $conf['guest_id'] ]);
501	}
502
503	$summary['nb_members'] = count($username_of);
504
505	$member_strings = array();
506	foreach ($username_of as $user_id => $user_name)
507	{
508	$member_string = $user_name.' <a href="';
509	$member_string.= get_root_url().'admin.php?page=history';
510	$member_string.= '&search_id='.$page['search_id'];
511	$member_string.= '&user_id='.$user_id;
512	$member_string.= '">+</a>';
513
514	$member_strings[] = $member_string;
515	}
516
517	$template->assign(
518	'search_summary',
519	array(
520	'NB_LINES' => l10n_dec(
521	'%d line filtered', '%d lines filtered',
522	$page['nb_lines']
523	),
524	'FILESIZE' => $summary['total_filesize'] != 0 ? ceil($summary['total_filesize']/1024).' MB' : '',
525	'USERS' => l10n_dec(
526	'%d user', '%d users',
527	$summary['nb_members'] + $summary['nb_guests']
528	),
529	'MEMBERS' => sprintf(
530	l10n_dec('%d member', '%d members', $summary['nb_members']).': %s',
531	implode(
532	', ',
533	$member_strings
534	)
535	),
536	'GUESTS' => l10n_dec(
537	'%d guest', '%d guests',
538	$summary['nb_guests']
539	),
540	)
541	);
542	}
543
544	// +-----------------------------------------------------------------------+
545	// \| navigation bar \|
546	// +-----------------------------------------------------------------------+
547
548	if (isset($page['search_id']))
549	{
550	$navbar = create_navigation_bar(
551	get_root_url().'admin.php'.get_query_string_diff(array('start')),
552	$page['nb_lines'],
553	$page['start'],
554	$conf['nb_logs_page']
555	);
556
557	$template->assign('navbar', $navbar);
558	}
559
560	// +-----------------------------------------------------------------------+
561	// \| filter form \|
562	// +-----------------------------------------------------------------------+
563
564	$form = array();
565
566	if (isset($page['search']))
567	{
568	if (isset($page['search']['fields']['date-after']))
569	{
570	$tokens = explode('-', $page['search']['fields']['date-after']);
571
572	$form['start_year'] = (int)$tokens[0];
573	$form['start_month'] = (int)$tokens[1];
574	$form['start_day'] = (int)$tokens[2];
575	}
576
577	if (isset($page['search']['fields']['date-before']))
578	{
579	$tokens = explode('-', $page['search']['fields']['date-before']);
580
581	$form['end_year'] = (int)$tokens[0];
582	$form['end_month'] = (int)$tokens[1];
583	$form['end_day'] = (int)$tokens[2];
584	}
585
586	$form['types'] = $page['search']['fields']['types'];
587
588	if (isset($page['search']['fields']['user']))
589	{
590	$form['user'] = $page['search']['fields']['user'];
591	}
592	else
593	{
594	$form['user'] = null;
595	}
596
597	$form['image_id'] = @$page['search']['fields']['image_id'];
598	$form['filename'] = @$page['search']['fields']['filename'];
599	$form['ip'] = @$page['search']['fields']['ip'];
600
601	$form['display_thumbnail'] = @$page['search']['fields']['display_thumbnail'];
602	}
603	else
604	{
605	// by default, at page load, we want the selected date to be the current
606	// date
607	$form['start_year'] = $form['end_year'] = date('Y');
608	$form['start_month'] = $form['end_month'] = date('n');
609	$form['start_day'] = $form['end_day'] = date('j');
610	$form['types'] = $types;
611	// Hoverbox by default
612	$form['display_thumbnail'] =
613	pwg_get_cookie_var('display_thumbnail', 'no_display_thumbnail');
614	}
615
616
617	$month_list = $lang['month'];
618	$month_list[0]='------------';
619	ksort($month_list);
620
621	$template->assign(
622	array(
623	'IMAGE_ID' => @$form['image_id'],
624	'FILENAME' => @$form['filename'],
625	'IP' => @$form['ip'],
626
627	'month_list' => $month_list,
628
629	'START_DAY_SELECTED' => @$form['start_day'],
630	'START_MONTH_SELECTED' => @$form['start_month'],
631	'START_YEAR' => @$form['start_year'],
632
633	'END_DAY_SELECTED' => @$form['end_day'],
634	'END_MONTH_SELECTED' => @$form['end_month'],
635	'END_YEAR' => @$form['end_year'],
636	)
637	);
638
639	$template->assign(
640	array(
641	'type_option_values' => $types,
642	'type_option_selected' => $form['types']
643	)
644	);
645
646
647	$query = '
648	SELECT
649	'.$conf['user_fields']['id'].' AS id,
650	'.$conf['user_fields']['username'].' AS username
651	FROM '.USERS_TABLE.'
652	ORDER BY username ASC
653	;';
654	$template->assign(
655	array(
656	'user_options' => simple_hash_from_query($query, 'id','username'),
657	'user_options_selected' => array(@$form['user'])
658	)
659	);
660
661	$template->assign('display_thumbnails', $display_thumbnails);
662	$template->assign('display_thumbnail_selected', $form['display_thumbnail']);
663
664	// +-----------------------------------------------------------------------+
665	// \| html code display \|
666	// +-----------------------------------------------------------------------+
667
668	$template->assign_var_from_handle('ADMIN_CONTENT', 'history');
669	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: