source: branches/2.1/admin/rating.php @ 6323

Revision 6323, 7.6 KB checked in by plg, 9 years ago (diff)

merge r6320 from trunk to branch 2.1

bug 1667 fixed: r6027 was fixing a minor error on tabs for Google Chrome/Safari
BUT was introducing a major visual issue for IE8. Backmerged + adds the -webkit
radius anyway.

This is a quickfix for release 2.1.1, the improved display introduced by nikrou
was nice and it would be better to have it, but working in IE8

Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2010 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
24if (!defined('PHPWG_ROOT_PATH'))
25{
26  die ("Hacking attempt!");
27}
28
29include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
30
31// +-----------------------------------------------------------------------+
32// | Check Access and exit when user status is not ok                      |
33// +-----------------------------------------------------------------------+
34check_status(ACCESS_ADMINISTRATOR);
35
36// +-----------------------------------------------------------------------+
37// |                            initialization                             |
38// +-----------------------------------------------------------------------+
39if (isset($_GET['start']) and is_numeric($_GET['start']))
40{
41  $start = $_GET['start'];
42}
43else
44{
45  $start = 0;
46}
47
48$elements_per_page=10;
49if (isset($_GET['display']) and is_numeric($_GET['display']))
50{
51  $elements_per_page = $_GET['display'];
52}
53
54$order_by_index=0;
55if (isset($_GET['order_by']) and is_numeric($_GET['order_by']))
56{
57  $order_by_index = $_GET['order_by'];
58}
59
60$page['user_filter'] = '';
61if (isset($_GET['users']))
62{
63  if ($_GET['users'] == 'user')
64  {
65    $page['user_filter'] = ' AND r.user_id <> '.$conf['guest_id'];
66  }
67  elseif ($_GET['users'] == 'guest')
68  {
69    $page['user_filter'] = ' AND r.user_id = '.$conf['guest_id'];
70  }
71}
72
73if (isset($_GET['del']) and !is_adviser())
74{
75  $del_params = urldecode( $_GET['del'] );
76  parse_str($del_params, $vars);
77  if ( !is_numeric($vars['e']) or !is_numeric($vars['u']) )
78  {
79    die('Hacking attempt');
80  }
81  $query = '
82DELETE FROM '. RATE_TABLE .'
83WHERE element_id=' . $vars['e'] . '
84AND user_id=' . $vars['u'] . '
85AND anonymous_id=\'' . $vars['a'] . '\'
86;';
87  pwg_query($query);
88  update_average_rate( $vars['e'] );
89}
90
91$users = array();
92$query = '
93SELECT '.$conf['user_fields']['username'].' as username, '.$conf['user_fields']['id'].' as id
94  FROM '.USERS_TABLE.'
95;';
96$result = pwg_query($query);
97while ($row = pwg_db_fetch_assoc($result))
98{
99  $users[$row['id']]=stripslashes($row['username']);
100}
101
102
103$query = 'SELECT COUNT(DISTINCT(i.id))
104FROM '.RATE_TABLE.' AS r, '.IMAGES_TABLE.' AS i
105WHERE r.element_id=i.id'. $page['user_filter'] .
106';';
107list($nb_images) = pwg_db_fetch_row(pwg_query($query));
108
109
110// +-----------------------------------------------------------------------+
111// |                             template init                             |
112// +-----------------------------------------------------------------------+
113
114$template->set_filename('rating', 'rating.tpl');
115
116$template->assign(
117  array(
118    'navbar' => create_navigation_bar(
119      PHPWG_ROOT_PATH.'admin.php'.get_query_string_diff(array('start','del')),
120      $nb_images,
121      $start,
122      $elements_per_page
123      ),
124    'F_ACTION' => PHPWG_ROOT_PATH.'admin.php',
125    'DISPLAY' => $elements_per_page,
126    'NB_ELEMENTS' => $nb_images,
127    )
128  );
129
130
131
132$available_order_by= array(
133    array(l10n('Rate date'), 'recently_rated DESC'),
134    array(l10n('Average rate'), 'average_rate DESC'),
135    array(l10n('Number of rates'), 'nb_rates DESC'),
136    array(l10n('Sum of rates'), 'sum_rates DESC'),
137    array(l10n('Controversy'), 'std_rates DESC'),
138    array(l10n('File name'), 'file DESC'),
139    array(l10n('Creation date'), 'date_creation DESC'),
140    array(l10n('Post date'), 'date_available DESC'),
141
142  );
143
144for ($i=0; $i<count($available_order_by); $i++)
145{
146  $template->append(
147    'order_by_options',
148    $available_order_by[$i][0]
149    );
150}
151$template->assign('order_by_options_selected', array($order_by_index) );
152
153
154$user_options = array(
155  'all'   => l10n('all'),
156  'user'  => l10n('Users'),
157  'guest' => l10n('Guests'),
158  );
159
160$template->assign('user_options', $user_options );
161$template->assign('user_options_selected', array(@$_GET['users']) );
162
163
164$query = '
165SELECT i.id,
166       i.path,
167       i.file,
168       i.tn_ext,
169       i.average_rate,
170       MAX(r.date)          AS recently_rated,
171       COUNT(r.rate)        AS nb_rates,
172       SUM(r.rate)          AS sum_rates
173  FROM '.RATE_TABLE.' AS r
174    LEFT JOIN '.IMAGES_TABLE.' AS i ON r.element_id = i.id
175  WHERE 1 = 1 ' . $page['user_filter'] . '
176  GROUP BY r.element_id
177  ORDER BY ' . $available_order_by[$order_by_index][1] .'
178  LIMIT '.$elements_per_page.' OFFSET '.$start.'
179;';
180
181$images = array();
182$result = pwg_query($query);
183while ($row = pwg_db_fetch_assoc($result))
184{
185  array_push($images, $row);
186}
187
188$template->assign( 'images', array() );
189foreach ($images as $image)
190{
191  $thumbnail_src = get_thumbnail_url($image);
192
193  $image_url = PHPWG_ROOT_PATH.'admin.php?page=picture_modify'.
194            '&amp;image_id='.$image['id'];
195
196  $query = 'SELECT *
197FROM '.RATE_TABLE.' AS r
198WHERE r.element_id='.$image['id'] . '
199ORDER BY date DESC;';
200  $result = pwg_query($query);
201  $nb_rates = pwg_db_num_rows($result);
202
203  $tpl_image = 
204     array(
205       'U_THUMB' => $thumbnail_src,
206       'U_URL' => $image_url,
207       'AVG_RATE' => $image['average_rate'],
208       'SUM_RATE' => $image['sum_rates'],
209       'NB_RATES' => (int)$image['nb_rates'],
210       'NB_RATES_TOTAL' => (int)$nb_rates,
211       'FILE' => $image['file'],
212       'rates'  => array()
213   );
214
215  while ($row = pwg_db_fetch_assoc($result))
216  {
217
218    $url_del = PHPWG_ROOT_PATH.'admin.php'.
219                get_query_string_diff(array('del'));
220
221    $del_param = 'e='.$image['id'].
222                 '&u='.$row['user_id'].
223                 '&a='.$row['anonymous_id'];
224
225    $url_del .= '&amp;del='.urlencode(urlencode($del_param));
226
227    if ( isset($users[$row['user_id']]) )
228    {
229      $user_rate = $users[$row['user_id']];
230    }
231    else
232    {
233      $user_rate = '? '. $row['user_id'];
234    }
235    if ( strlen($row['anonymous_id'])>0 )
236    {
237      $user_rate .= '('.$row['anonymous_id'].')';
238    }
239
240    $tpl_image['rates'][] =
241       array(
242         'DATE' => format_date($row['date']),
243         'RATE' => $row['rate'],
244         'USER' => $user_rate,
245         'U_DELETE' => $url_del
246     );
247  }
248  $template->append( 'images', $tpl_image );
249}
250
251// +-----------------------------------------------------------------------+
252// |                           sending html code                           |
253// +-----------------------------------------------------------------------+
254$template->assign_var_from_handle('ADMIN_CONTENT', 'rating');
255?>
Note: See TracBrowser for help on using the repository browser.