source: branches/2.6/admin/rating.php @ 26901

Revision 26901, 7.1 KB checked in by rvelices, 6 years ago (diff)

merge -r26900 from trunk to 2.6
admin rating user improvements

  • add last rate date for user
  • add consensus deviation but only based on the best rated photos (e.g. how much this user tries to change the best rated photos)
  • Property svn:eol-style set to LF
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based photo gallery                                    |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2014 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
37include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');
38$tabsheet = new tabsheet();
39$tabsheet->set_id('rating');
40$tabsheet->select('rating');
41$tabsheet->assign();
42
43// +-----------------------------------------------------------------------+
44// |                            initialization                             |
45// +-----------------------------------------------------------------------+
46if (isset($_GET['start']) and is_numeric($_GET['start']))
47{
48  $start = $_GET['start'];
49}
50else
51{
52  $start = 0;
53}
54
55$elements_per_page=10;
56if (isset($_GET['display']) and is_numeric($_GET['display']))
57{
58  $elements_per_page = $_GET['display'];
59}
60
61$order_by_index=0;
62if (isset($_GET['order_by']) and is_numeric($_GET['order_by']))
63{
64  $order_by_index = $_GET['order_by'];
65}
66
67$page['user_filter'] = '';
68if (isset($_GET['users']))
69{
70  if ($_GET['users'] == 'user')
71  {
72    $page['user_filter'] = ' AND r.user_id <> '.$conf['guest_id'];
73  }
74  elseif ($_GET['users'] == 'guest')
75  {
76    $page['user_filter'] = ' AND r.user_id = '.$conf['guest_id'];
77  }
78}
79
80$users = array();
81$query = '
82SELECT '.$conf['user_fields']['username'].' as username, '.$conf['user_fields']['id'].' as id
83  FROM '.USERS_TABLE.'
84;';
85$result = pwg_query($query);
86while ($row = pwg_db_fetch_assoc($result))
87{
88  $users[$row['id']]=stripslashes($row['username']);
89}
90
91
92$query = 'SELECT COUNT(DISTINCT(r.element_id))
93FROM '.RATE_TABLE.' AS r
94WHERE 1=1'. $page['user_filter'];
95list($nb_images) = pwg_db_fetch_row(pwg_query($query));
96
97
98// +-----------------------------------------------------------------------+
99// |                             template init                             |
100// +-----------------------------------------------------------------------+
101
102$template->set_filename('rating', 'rating.tpl');
103
104$template->assign(
105  array(
106    'navbar' => create_navigation_bar(
107      PHPWG_ROOT_PATH.'admin.php'.get_query_string_diff(array('start','del')),
108      $nb_images,
109      $start,
110      $elements_per_page
111      ),
112    'F_ACTION' => PHPWG_ROOT_PATH.'admin.php',
113    'DISPLAY' => $elements_per_page,
114    'NB_ELEMENTS' => $nb_images,
115    )
116  );
117
118
119
120$available_order_by= array(
121    array(l10n('Rate date'), 'recently_rated DESC'),
122    array(l10n('Rating score'), 'score DESC'),
123    array(l10n('Average rate'), 'avg_rates DESC'),
124    array(l10n('Number of rates'), 'nb_rates DESC'),
125    array(l10n('Sum of rates'), 'sum_rates DESC'),
126    array(l10n('File name'), 'file DESC'),
127    array(l10n('Creation date'), 'date_creation DESC'),
128    array(l10n('Post date'), 'date_available DESC'),
129  );
130
131for ($i=0; $i<count($available_order_by); $i++)
132{
133  $template->append(
134    'order_by_options',
135    $available_order_by[$i][0]
136    );
137}
138$template->assign('order_by_options_selected', array($order_by_index) );
139
140
141$user_options = array(
142  'all'   => l10n('all'),
143  'user'  => l10n('Users'),
144  'guest' => l10n('Guests'),
145  );
146
147$template->assign('user_options', $user_options );
148$template->assign('user_options_selected', array(@$_GET['users']) );
149
150
151$query = '
152SELECT i.id,
153    i.path,
154    i.file,
155    i.representative_ext,
156    i.rating_score       AS score,
157    MAX(r.date)          AS recently_rated,
158    ROUND(AVG(r.rate),2) AS avg_rates,
159    COUNT(r.rate)        AS nb_rates,
160    SUM(r.rate)          AS sum_rates
161  FROM '.RATE_TABLE.' AS r
162    LEFT JOIN '.IMAGES_TABLE.' AS i ON r.element_id = i.id
163  WHERE 1 = 1 ' . $page['user_filter'] . '
164  GROUP BY i.id,
165        i.path,
166        i.file,
167        i.representative_ext,
168        i.rating_score,
169        r.element_id
170  ORDER BY ' . $available_order_by[$order_by_index][1] .'
171  LIMIT '.$elements_per_page.' OFFSET '.$start.'
172;';
173
174$images = array();
175$result = pwg_query($query);
176while ($row = pwg_db_fetch_assoc($result))
177{
178  $images[] = $row;
179}
180
181$template->assign( 'images', array() );
182foreach ($images as $image)
183{
184  $thumbnail_src = DerivativeImage::thumb_url($image);
185
186  $image_url = get_root_url().'admin.php?page=photo-'.$image['id'];
187
188  $query = 'SELECT *
189FROM '.RATE_TABLE.' AS r
190WHERE r.element_id='.$image['id'] . '
191ORDER BY date DESC;';
192  $result = pwg_query($query);
193  $nb_rates = pwg_db_num_rows($result);
194
195  $tpl_image = 
196    array(
197      'id' => $image['id'],
198      'U_THUMB' => $thumbnail_src,
199      'U_URL' => $image_url,
200      'SCORE_RATE' => $image['score'],
201       'AVG_RATE' => $image['avg_rates'],
202       'SUM_RATE' => $image['sum_rates'],
203       'NB_RATES' => (int)$image['nb_rates'],
204       'NB_RATES_TOTAL' => (int)$nb_rates,
205       'FILE' => $image['file'],
206       'rates'  => array()
207   );
208
209  while ($row = pwg_db_fetch_assoc($result))
210  {
211    if ( isset($users[$row['user_id']]) )
212    {
213      $user_rate = $users[$row['user_id']];
214    }
215    else
216    {
217      $user_rate = '? '. $row['user_id'];
218    }
219    if ( strlen($row['anonymous_id'])>0 )
220    {
221      $user_rate .= '('.$row['anonymous_id'].')';
222    }
223
224    $row['USER'] = $user_rate;
225    $tpl_image['rates'][] = $row;
226  }
227  $template->append( 'images', $tpl_image );
228}
229
230// +-----------------------------------------------------------------------+
231// |                           sending html code                           |
232// +-----------------------------------------------------------------------+
233$template->assign_var_from_handle('ADMIN_CONTENT', 'rating');
234?>
Note: See TracBrowser for help on using the repository browser.