Changeset 27837
- Timestamp:
- Mar 18, 2014, 11:23:38 PM (10 years ago)
- Location:
- trunk/admin
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/themes/default/template/user_list.tpl
r27811 r27837 881 881 <th>{'Status'|@translate}</th> 882 882 <th>{'Email address'|@translate}</th> 883 <th>{'Groups'|@translate}</th> 884 <th>{'Privacy level'|@translate}</th> 883 885 <th>{'registration date'|@translate}</th> 884 886 </tr> -
trunk/admin/user_list_backend.php
r26618 r27837 36 36 * you want to insert a non-database field (for example a counter or static image) 37 37 */ 38 $aColumns = array('id', 'username', 'status', 'mail_address', 're gistration_date');38 $aColumns = array('id', 'username', 'status', 'mail_address', 'recent_period', 'level', 'registration_date'); 39 39 $aColumns = trigger_change('user_list_columns', $aColumns); 40 40 … … 158 158 "aaData" => array() 159 159 ); 160 160 161 $user_ids = array(); 162 161 163 while ( $aRow = pwg_db_fetch_array( $rResult ) ) 162 164 { 165 $user_ids[] = $aRow['id']; 166 163 167 $row = array(); 164 168 for ( $i=0 ; $i<count($aColumns) ; $i++ ) … … 168 172 $row[] = l10n('user_status_'.$aRow[ $aColumns[$i] ]); 169 173 } 174 else if ( $aColumns[$i] == "level" ) 175 { 176 $row[] = $aRow[ $aColumns[$i] ] == 0 ? '' : l10n(sprintf('Level %d', $aRow[ $aColumns[$i] ])); 177 } 170 178 else if ( $aColumns[$i] != ' ' ) 171 179 { … … 177 185 } 178 186 187 // replace "recent_period" by the list of groups 188 if (count($user_ids) > 0) 189 { 190 $groups_of_user = array(); 191 192 $query = ' 193 SELECT 194 user_id, 195 GROUP_CONCAT(name ORDER BY name SEPARATOR ", ") AS groups 196 FROM '.USER_GROUP_TABLE.' 197 JOIN '.GROUPS_TABLE.' ON id = group_id 198 WHERE user_id IN ('.implode(',', $user_ids).') 199 GROUP BY user_id 200 ;'; 201 $result = pwg_query($query); 202 while ($row = pwg_db_fetch_assoc($result)) 203 { 204 $groups_of_user[ $row['user_id'] ] = $row['groups']; 205 } 206 207 $key_replace = array_search('recent_period', $aColumns); 208 209 // replacement 210 foreach (array_keys($output['aaData']) as $idx) 211 { 212 $user_id = $output['aaData'][$idx][0]; 213 $output['aaData'][$idx][$key_replace] = isset($groups_of_user[$user_id]) ? $groups_of_user[$user_id] : ''; 214 } 215 } 216 179 217 $output = trigger_change('after_render_user_list', $output); 180 218
Note: See TracChangeset
for help on using the changeset viewer.