]>
src.bluestatic.org Git - bugdar.git/blob - admin/user.php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 require_once ( './global.php' );
23 require_once ( './includes/api_user.php' );
24 require_once ( './includes/class_sort.php' );
26 require_once ( './includes/class_api_error.php' );
27 APIError ( array ( new API_Error_Handler ( $admin ), 'admin_error' ));
29 NavLinks
:: usersPages ();
30 $navigator- > set_focus ( 'tab' , 'users' , null );
32 if (! can_perform ( 'canadminusers' ))
37 // ###################################################################
39 * Generate an inline checkbox
44 * @param bool Checked?
46 * @return string HTML checkbxo
48 function draw_checkbox ( $name , $checked )
50 return "<input type= \" checkbox \" class= \" button \" name= \"{ $name} \" value= \" 1 \" " . ( $checked == true ? ' checked="checked"' : '' ) . " />" ;
53 // ###################################################################
55 if ( empty ( $_REQUEST [ 'do' ]))
57 $_REQUEST [ 'do' ] = 'modify' ;
60 // ###################################################################
62 if ( $_REQUEST [ 'do' ] == 'kill' )
64 $user = new UserAPI ( $bugsys );
65 $user- > set ( 'userid' , $bugsys- > in
[ 'userid' ]);
66 $user- > set_condition ();
69 $admin- > redirect ( 'user.php' );
72 // ###################################################################
74 if ( $_REQUEST [ 'do' ] == 'delete' )
76 $admin- > page_confirm ( _ ( 'Are you sure you want to delete this user?' ), 'user.php' , 'kill' , array ( 'userid' => $bugsys- > input_clean ( 'userid' , TYPE_UINT
)));
79 // ###################################################################
81 if ( $_POST [ 'do' ] == 'insert' )
83 $user = new UserAPI ( $bugsys );
84 $user- > set ( 'displayname' , $bugsys- > in
[ 'displayname' ]);
85 $user- > set ( 'email' , $bugsys- > in
[ 'email' ]);
86 $user- > set ( 'showemail' , $bugsys- > in
[ 'showemail' ]);
87 $user- > set ( 'showcolors' , $bugsys- > in
[ 'showcolors' ]);
88 $user- > set ( 'usergroupid' , $bugsys- > in
[ 'usergroupid' ]);
89 $user- > set ( 'languageid' , $bugsys- > in
[ 'languageid' ]);
90 $user- > set ( 'timezone' , $bugsys- > in
[ 'timezone' ]);
91 $user- > set ( 'usedst' , $bugsys- > in
[ 'usedst' ]);
92 $user- > set ( 'password' , $bugsys- > in
[ 'password' ]);
93 $user- > set ( 'hidestatuses' , $bugsys- > in
[ 'hidestatuses' ]);
94 $user- > set ( 'defaultsortkey' , $bugsys- > in
[ 'defaultsortkey' ]);
95 $user- > set ( 'defaultsortas' , $bugsys- > in
[ 'defaultsortas' ]);
98 // post_insert will set the email options... so we now have to dump them
99 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "useremail WHERE userid = " . $user- > insertid
);
101 $bugsys- > input_clean ( 'emailopts' , TYPE_INT
);
102 if ( is_array ( $bugsys- > in
[ 'emailopts' ]))
104 foreach ( $bugsys- > in
[ 'emailopts' ] AS $relation => $bitarr )
107 foreach ( $bitarr AS $option => $yes )
109 $bitmask +
= $option * $yes ;
111 $db- > query ( "INSERT INTO " . TABLE_PREFIX
. "useremail (userid, relation, mask) VALUES (" . $user- > insertid
. ", $relation , $bitmask )" );
115 $admin- > redirect ( 'user.php?do=edit&userid=' . $user- > insertid
);
118 // ###################################################################
120 if ( $_POST [ 'do' ] == 'update' )
122 $user = new UserAPI ( $bugsys );
123 $user- > set ( 'userid' , $bugsys- > in
[ 'userid' ]);
124 $user- > set_condition ();
125 $user- > set ( 'displayname' , $bugsys- > in
[ 'displayname' ]);
126 $user- > set ( 'email' , $bugsys- > in
[ 'email' ]);
127 $user- > set ( 'showemail' , $bugsys- > in
[ 'showemail' ]);
128 $user- > set ( 'showcolors' , $bugsys- > in
[ 'showcolors' ]);
129 $user- > set ( 'usergroupid' , $bugsys- > in
[ 'usergroupid' ]);
130 $user- > set ( 'languageid' , $bugsys- > in
[ 'languageid' ]);
131 $user- > set ( 'timezone' , $bugsys- > in
[ 'timezone' ]);
132 $user- > set ( 'usedst' , $bugsys- > in
[ 'usedst' ]);
133 $user- > set ( 'password' , $bugsys- > in
[ 'password' ]);
134 $user- > set ( 'hidestatuses' , $bugsys- > in
[ 'hidestatuses' ]);
135 $user- > set ( 'defaultsortkey' , $bugsys- > in
[ 'defaultsortkey' ]);
136 $user- > set ( 'defaultsortas' , $bugsys- > in
[ 'defaultsortas' ]);
139 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "useremail WHERE userid = " . $user- > values
[ 'userid' ]);
140 $bugsys- > input_clean ( 'emailopts' , TYPE_INT
);
141 if ( is_array ( $bugsys- > in
[ 'emailopts' ]))
143 foreach ( $bugsys- > in
[ 'emailopts' ] AS $relation => $bitarr )
146 foreach ( $bitarr AS $option => $yes )
148 $bitmask +
= $option * $yes ;
150 $db- > query ( "INSERT INTO " . TABLE_PREFIX
. "useremail (userid, relation, mask) VALUES (" . $user- > values
[ 'userid' ] . ", $relation , $bitmask )" );
154 $admin- > redirect ( 'user.php?do=edit&userid=' . $user- > objdata
[ 'userid' ]);
157 // ###################################################################
159 if ( $_REQUEST [ 'do' ] == 'edit' OR $_REQUEST [ 'do' ] == 'add' )
161 $add = ( $_REQUEST [ 'do' ] == 'add' );
166 NavLinks
:: usersEdit ( $bugsys- > in
[ 'userid' ]);
167 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
169 $user = new UserAPI ( $bugsys );
170 $user- > set ( 'userid' , $bugsys- > in
[ 'userid' ]);
171 $user- > set_condition ();
176 NavLinks
:: usersAdd ();
177 $navigator- > set_focus ( 'link' , 'users-add' , 'users' );
180 $admin- > page_start (( $add ? _ ( 'Add User' ) : _ ( 'Edit User' )));
182 $admin- > form_start ( 'user.php' , ( $add ? 'insert' : 'update' ));
186 $admin- > form_hidden_field ( 'userid' , $user- > objdata
[ 'userid' ]);
189 $admin- > table_start ();
191 $admin- > table_head (( $add ? _ ( 'Add User' ) : sprintf ( _ ( 'Edit User (userid: %1 $s )' ), $user- > objdata
[ 'userid' ])));
193 $admin- > row_input ( _ ( 'Display Name' ), 'displayname' , $user- > objdata
[ 'displayname' ]);
194 $admin- > row_input ( _ ( 'Email' ), 'email' , $user- > objdata
[ 'email' ]);
195 $admin- > row_input (( $add ? _ ( 'Password' ) : _ ( 'Password (Leave blank for no change)' )), 'password' );
197 foreach ( $bugsys- > datastore
[ 'usergroup' ] AS $group )
199 $admin- > list_item ( $group [ 'title' ], $group [ 'usergroupid' ], ( $user- > objdata
[ 'usergroupid' ] == $group [ 'usergroupid' ]));
201 $admin- > row_list ( _ ( 'Usergroup' ), 'usergroupid' );
203 $admin- > row_yesno ( _ ( 'Show Email Publicly' ), 'showemail' , $user- > objdata
[ 'showemail' ]);
204 $admin- > row_yesno ( _ ( 'Show Status Colors on Bug Listings' ), 'showcolors' , $user- > objdata
[ 'showcolors' ]);
206 foreach ( $bugsys- > datastore
[ 'language' ] AS $language )
208 $admin- > list_item ( $language [ 'title' ], $language [ 'languageid' ], ( $user- > objdata
[ 'languageid' ] == $language [ 'languageid' ]));
210 $admin- > row_list ( _ ( 'Language' ), 'languageid' );
212 foreach ( $datef- > fetch_timezone_list () AS $value => $string )
214 $admin- > list_item ( $string , $value , ( $user- > objdata
[ 'timezone' ] == $value ));
216 $admin- > row_list ( _ ( 'Timezone' ), 'timezone' );
218 $admin- > row_yesno ( _ ( 'Observe Daylight Savings Time (DST)' ), 'usedst' , $user- > objdata
[ 'usedst' ]);
219 $admin- > row_text ( _ ( 'Hidden Statuses on Bug Listing' ), construct_option_select ( 'hidestatuses' , $bugsys- > datastore
[ 'status' ], $user- > objdata
[ 'hidestatuses' ], 'statusid' , 'status' , 0 , true ));
220 $admin- > row_text ( _ ( 'Default Sort Order Column' ), construct_option_select ( 'defaultsortkey' , ListSorter
:: fetch_by_text ( false ), $user- > objdata
[ 'defaultsortkey' ]));
221 $admin- > row_text ( _ ( 'Default Sort Order Direction' ), construct_option_select ( 'defaultsortas' , ListSorter
:: fetch_as_text ( false ), $user- > objdata
[ 'defaultsortas' ]));
225 // -------------------------------------------------------------------
226 $admin- > table_start ( false );
227 $admin- > table_head ( _ ( 'Email Options' ), 6 );
229 if ( $user- > objdata
[ 'userid' ])
231 $options = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "useremail WHERE userid = " . $user- > objdata
[ 'userid' ]);
232 while ( $opt = $db- > fetch_array ( $options ))
234 foreach ( $bugsys- > emailoptions
[ 'notifications' ] AS $name => $notif )
236 foreach ( $bugsys- > emailoptions
[ 'relations' ] AS $name => $relation )
238 if ( $opt [ 'mask' ] & $notif AND $opt [ 'relation' ] == $relation )
240 $checked [ " $relation" ][" $notif" ] = HTML_CHECKED
;
247 $admin- > table_column_head ( array ( '' , _ ( 'Reporter' ), _ ( 'Assignee' ), _ ( 'Favorite' ), _ ( 'Voter' ), _ ( 'Commenter' )));
249 // -------------------------------------------------------------------
251 $admin- > row_text ( _ ( 'New bug is added' ), '<div style="text-align: center">' . draw_checkbox ( 'emailopts[0][2048]' , $checked [ 0 ][ 2048 ]) . '</div>' , 'top' , 6 );
253 $admin- > row_text ( _ ( 'I am made the assignee' ), '<div style="text-align: center">' . draw_checkbox ( 'emailopts[0][32]' , $checked [ 0 ][ 32 ]) . '</div>' , 'top' , 6 );
255 $admin- > row_multi_item ( array (
256 _ ( 'Status or resolution changes' ) => 'l' ,
257 draw_checkbox ( 'emailopts[1][64]' , $checked [ 1 ][ 64 ]) => 'c' ,
258 draw_checkbox ( 'emailopts[2][64]' , $checked [ 2 ][ 64 ]) => 'c' ,
259 draw_checkbox ( 'emailopts[4][64]' , $checked [ 4 ][ 64 ]) => 'c' ,
260 draw_checkbox ( 'emailopts[8][64]' , $checked [ 8 ][ 64 ]) => 'c' ,
261 draw_checkbox ( 'emailopts[16][64]' , $checked [ 16 ][ 64 ]) => 'c' ,
264 $admin- > row_multi_item ( array (
265 _ ( "'Duplicates' field is changed" ) => 'l' ,
266 draw_checkbox ( 'emailopts[1][128]' , $checked [ 1 ][ 128 ]) => 'c' ,
267 draw_checkbox ( 'emailopts[2][128]' , $checked [ 2 ][ 128 ]) => 'c' ,
268 draw_checkbox ( 'emailopts[4][128]' , $checked [ 4 ][ 128 ]) => 'c' ,
269 draw_checkbox ( 'emailopts[8][128]' , $checked [ 8 ][ 128 ]) => 'c' ,
270 draw_checkbox ( 'emailopts[16][128]' , $checked [ 16 ][ 128 ]) => 'c' ,
273 $admin- > row_multi_item ( array (
274 _ ( 'A new comment is added' ) => 'l' ,
275 draw_checkbox ( 'emailopts[1][256]' , $checked [ 1 ][ 256 ]) => 'c' ,
276 draw_checkbox ( 'emailopts[2][256]' , $checked [ 2 ][ 256 ]) => 'c' ,
277 draw_checkbox ( 'emailopts[4][256]' , $checked [ 4 ][ 256 ]) => 'c' ,
278 draw_checkbox ( 'emailopts[8][256]' , $checked [ 8 ][ 256 ]) => 'c' ,
279 draw_checkbox ( 'emailopts[16][256]' , $checked [ 16 ][ 256 ]) => 'c' ,
282 $admin- > row_multi_item ( array (
283 _ ( 'A new attachment is added' ) => 'l' ,
284 draw_checkbox ( 'emailopts[1][512]' , $checked [ 1 ][ 512 ]) => 'c' ,
285 draw_checkbox ( 'emailopts[2][512]' , $checked [ 2 ][ 512 ]) => 'c' ,
286 draw_checkbox ( 'emailopts[4][512]' , $checked [ 4 ][ 512 ]) => 'c' ,
287 draw_checkbox ( 'emailopts[8][512]' , $checked [ 8 ][ 512 ]) => 'c' ,
288 draw_checkbox ( 'emailopts[16][512]' , $checked [ 16 ][ 512 ]) => 'c' ,
291 $admin- > row_multi_item ( array (
292 _ ( 'Any other field changes' ) => 'l' ,
293 draw_checkbox ( 'emailopts[1][1024]' , $checked [ 1 ][ 1024 ]) => 'c' ,
294 draw_checkbox ( 'emailopts[2][1024]' , $checked [ 2 ][ 1024 ]) => 'c' ,
295 draw_checkbox ( 'emailopts[4][1024]' , $checked [ 4 ][ 1024 ]) => 'c' ,
296 draw_checkbox ( 'emailopts[8][1024]' , $checked [ 8 ][ 1024 ]) => 'c' ,
297 draw_checkbox ( 'emailopts[16][1024]' , $checked [ 16 ][ 1024 ]) => 'c' ,
300 // -------------------------------------------------------------------
301 $admin- > row_submit ( null , ':save:' , ':reset:' , 6 );
309 // ###################################################################
311 if ( $_REQUEST [ 'do' ] == 'search' )
315 NavLinks
:: usersAdd ();
316 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
318 if ( is_numeric ( $bugsys- > in
[ 'userdata' ]))
320 $bugsys- > input_clean ( 'userdata' , TYPE_UINT
);
321 if ( $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "user WHERE userid = " . $bugsys- > in
[ 'userdata' ]))
323 header ( 'Location: user.php?do=edit&userid=' . $bugsys- > in
[ 'userdata' ]);
332 $bugsys- > in
[ 'userdata' ] = str_replace ( '%' , '\%' , $bugsys- > in
[ 'userdata' ]);
333 $results = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "user WHERE email LIKE '%" . $bugsys- > input_escape ( 'userdata' ) . "%' OR displayname LIKE '%" . $bugsys- > input_escape ( 'userdata' ) . "%'" );
335 if ( $db- > num_rows ( $results ) < 1 )
341 $admin- > page_start ( _ ( 'Search Results' ));
343 $admin- > table_start ();
344 $admin- > table_head ( _ ( 'Search Results' ), 4 );
345 $admin- > table_column_head ( array ( _ ( 'Display Name' ), _ ( 'Email' ), _ ( 'User ID' ), _ ( 'Actions' )));
347 while ( $row = $db- > fetch_array ( $results ))
349 $admin- > row_multi_item ( array (
350 $row [ 'displayname' ] => 'l' ,
351 $row [ 'email' ] => 'c' ,
352 $row [ 'userid' ] => 'c' ,
353 '<a href="user.php?do=edit&userid=' . $row [ 'userid' ] . '">[' . _ ( 'Edit' ) . ']</a>' => 'c'
365 $admin- > error ( _ ( 'Sorry, we could not find any users that matched your criteria.' ));
369 // ###################################################################
371 if ( $_REQUEST [ 'do' ] == 'showall' )
373 NavLinks
:: usersAdd ();
374 $navigator- > set_focus ( 'link' , 'users-showall' , 'users' );
376 LoadPaginationFramework ();
377 $pagination- > setBitProcessor ( 'AdminPageNavigatorBitCallback' );
378 $pagination- > setNavigatorProcessor ( 'AdminPageNavigatorCallback' );
380 $admin- > page_start ( _ ( 'Show All Users' ));
381 $admin- > table_start ();
382 $admin- > table_head ( _ ( 'Show All Users' ), 4 );
383 $admin- > table_column_head ( array ( _ ( 'Display Name' ), _ ( 'Email' ), _ ( 'User ID' ), _ ( 'Actions' )));
385 $count = $db- > query_first ( "SELECT COUNT(*) AS count FROM " . TABLE_PREFIX
. "user" );
386 $pagination- > setTotal ( $count [ 'count' ]);
387 $pagination- > splitPages ();
389 $users = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "user ORDER BY userid ASC LIMIT " . $pagination- > fetchLimit ( $pagination- > getPage () - 1 ) . ", " . $pagination- > getPerPage ());
390 while ( $user = $db- > fetch_array ( $users ))
392 $admin- > row_multi_item ( array (
393 $user [ 'displayname' ] => 'l' ,
394 $user [ 'email' ] => 'c' ,
395 $user [ 'userid' ] => 'c' ,
396 '<a href="user.php?do=edit&userid=' . $user [ 'userid' ] . '">[' . _ ( 'Edit' ) . ']</a>' => 'c'
402 $admin- > page_code ( $pagination- > constructPageNav ( 'user.php?do=showall' ));
407 // ###################################################################
409 if ( $_REQUEST [ 'do' ] == 'modify' )
411 NavLinks
:: usersAdd ();
412 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
414 $admin- > page_start ( _ ( 'User Search' ));
416 $admin- > form_start ( 'user.php' , 'search' );
417 $admin- > table_start ( true , '45%' );
419 $admin- > table_head ( _ ( 'User Search' ));
420 $admin- > row_input ( _ ( 'Name/Email/ID' ), 'userdata' );
422 $admin- > row_submit ( '' , ':save:' , '' );
430 /*=====================================================================*\
431 || ###################################################################
434 || ###################################################################
435 \*=====================================================================*/