]>
src.bluestatic.org Git - bugdar.git/blob - user.php
e30eab715b13c1826317351717d5cb3c2ec1893d
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 $bugsys- > input_clean ( 'emailopts' , TYPE_INT
);
99 foreach ( $bugsys- > in
[ 'emailopts' ] AS $relation => $bitarr )
102 foreach ( $bitarr AS $option => $yes )
104 $bitmask +
= $option * $yes ;
106 $db- > query ( "INSERT INTO " . TABLE_PREFIX
. "useremail (userid, relation, mask) VALUES (" . $bugsys- > userinfo
[ 'userid' ] . ", $relation , $bitmask )" );
109 $admin- > redirect ( 'user.php?do=edit&userid=' . $user- > insertid
);
112 // ###################################################################
114 if ( $_POST [ 'do' ] == 'update' )
116 $user = new UserAPI ( $bugsys );
117 $user- > set ( 'userid' , $bugsys- > in
[ 'userid' ]);
118 $user- > set_condition ();
119 $user- > set ( 'displayname' , $bugsys- > in
[ 'displayname' ]);
120 $user- > set ( 'email' , $bugsys- > in
[ 'email' ]);
121 $user- > set ( 'showemail' , $bugsys- > in
[ 'showemail' ]);
122 $user- > set ( 'showcolors' , $bugsys- > in
[ 'showcolors' ]);
123 $user- > set ( 'usergroupid' , $bugsys- > in
[ 'usergroupid' ]);
124 $user- > set ( 'languageid' , $bugsys- > in
[ 'languageid' ]);
125 $user- > set ( 'timezone' , $bugsys- > in
[ 'timezone' ]);
126 $user- > set ( 'usedst' , $bugsys- > in
[ 'usedst' ]);
127 $user- > set ( 'password' , $bugsys- > in
[ 'password' ]);
128 $user- > set ( 'hidestatuses' , $bugsys- > in
[ 'hidestatuses' ]);
129 $user- > set ( 'defaultsortkey' , $bugsys- > in
[ 'defaultsortkey' ]);
130 $user- > set ( 'defaultsortas' , $bugsys- > in
[ 'defaultsortas' ]);
133 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "useremail WHERE userid = " . $bugsys- > userinfo
[ 'userid' ]);
134 $bugsys- > input_clean ( 'emailopts' , TYPE_INT
);
135 foreach (( array ) $bugsys- > in
[ 'emailopts' ] AS $relation => $bitarr )
138 foreach ( $bitarr AS $option => $yes )
140 $bitmask +
= $option * $yes ;
142 $db- > query ( "INSERT INTO " . TABLE_PREFIX
. "useremail (userid, relation, mask) VALUES (" . $user- > values
[ 'userid' ] . ", $relation , $bitmask )" );
145 $admin- > redirect ( 'user.php?do=edit&userid=' . $user- > objdata
[ 'userid' ]);
148 // ###################################################################
150 if ( $_REQUEST [ 'do' ] == 'edit' OR $_REQUEST [ 'do' ] == 'add' )
152 $add = ( $_REQUEST [ 'do' ] == 'add' );
157 NavLinks
:: usersEdit ( $bugsys- > in
[ 'userid' ]);
158 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
160 $user = new UserAPI ( $bugsys );
161 $user- > set ( 'userid' , $bugsys- > in
[ 'userid' ]);
162 $user- > set_condition ();
167 NavLinks
:: usersAdd ();
168 $navigator- > set_focus ( 'link' , 'users-add' , 'users' );
171 $admin- > page_start (( $add ? _ ( 'Add User' ) : _ ( 'Edit User' )));
173 $admin- > form_start ( 'user.php' , ( $add ? 'insert' : 'update' ));
177 $admin- > form_hidden_field ( 'userid' , $user- > objdata
[ 'userid' ]);
180 $admin- > table_start ();
182 $admin- > table_head (( $add ? _ ( 'Add User' ) : sprintf ( _ ( 'Edit User (userid: %1 $s )' ), $user- > objdata
[ 'userid' ])));
184 $admin- > row_input ( _ ( 'Display Name' ), 'displayname' , $user- > objdata
[ 'displayname' ]);
185 $admin- > row_input ( _ ( 'Email' ), 'email' , $user- > objdata
[ 'email' ]);
186 $admin- > row_input (( $add ? _ ( 'Password' ) : _ ( 'Password (Leave blank for no change)' )), 'password' );
188 foreach ( $bugsys- > datastore
[ 'usergroup' ] AS $group )
190 $admin- > list_item ( $group [ 'title' ], $group [ 'usergroupid' ], ( $user- > objdata
[ 'usergroupid' ] == $group [ 'usergroupid' ]));
192 $admin- > row_list ( _ ( 'Usergroup' ), 'usergroupid' );
194 $admin- > row_yesno ( _ ( 'Show Email Publicly' ), 'showemail' , $user- > objdata
[ 'showemail' ]);
195 $admin- > row_yesno ( _ ( 'Show Status Colors on Bug Listings' ), 'showcolors' , $user- > objdata
[ 'showcolors' ]);
197 foreach ( $bugsys- > datastore
[ 'language' ] AS $language )
199 $admin- > list_item ( $language [ 'title' ], $language [ 'languageid' ], ( $user- > objdata
[ 'languageid' ] == $language [ 'languageid' ]));
201 $admin- > row_list ( _ ( 'Language' ), 'languageid' );
203 foreach ( $datef- > fetch_timezone_list () AS $value => $string )
205 $admin- > list_item ( $string , $value , ( $user- > objdata
[ 'timezone' ] == $value ));
207 $admin- > row_list ( _ ( 'Timezone' ), 'timezone' );
209 $admin- > row_yesno ( _ ( 'Observe Daylight Savings Time (DST)' ), 'usedst' , $user- > objdata
[ 'usedst' ]);
210 $admin- > row_text ( _ ( 'Hidden Statuses on Bug Listing' ), construct_option_select ( 'hidestatuses' , $bugsys- > datastore
[ 'status' ], $user- > objdata
[ 'hidestatuses' ], 'statusid' , 'status' , 0 , true ));
211 $admin- > row_text ( _ ( 'Default Sort Order Column' ), construct_option_select ( 'defaultsortkey' , ListSorter
:: fetch_by_text ( false ), $user- > objdata
[ 'defaultsortkey' ]));
212 $admin- > row_text ( _ ( 'Default Sort Order Direction' ), construct_option_select ( 'defaultsortas' , ListSorter
:: fetch_as_text ( false ), $user- > objdata
[ 'defaultsortas' ]));
216 // -------------------------------------------------------------------
217 $admin- > table_start ( false );
218 $admin- > table_head ( _ ( 'Email Options' ), 6 );
220 $options = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "useremail WHERE userid = " . $user- > objdata
[ 'userid' ]);
221 while ( $opt = $db- > fetch_array ( $options ))
223 foreach ( $bugsys- > emailoptions
[ 'notifications' ] AS $name => $notif )
225 foreach ( $bugsys- > emailoptions
[ 'relations' ] AS $name => $relation )
227 if ( $opt [ 'mask' ] & $notif AND $opt [ 'relation' ] == $relation )
229 $checked [ " $relation" ][" $notif" ] = HTML_CHECKED
;
235 $admin- > table_column_head ( array ( '' , _ ( 'Reporter' ), _ ( 'Assignee' ), _ ( 'Favorite' ), _ ( 'Voter' ), _ ( 'Commenter' )));
237 // -------------------------------------------------------------------
239 $admin- > row_text ( _ ( 'New bug is added' ), '<div style="text-align: center">' . draw_checkbox ( 'emailopts[0][2048]' , $checked [ 0 ][ 2048 ]) . '</div>' , 'top' , 6 );
241 $admin- > row_text ( _ ( 'I am made the assignee' ), '<div style="text-align: center">' . draw_checkbox ( 'emailopts[0][32]' , $checked [ 0 ][ 32 ]) . '</div>' , 'top' , 6 );
243 $admin- > row_multi_item ( array (
244 _ ( 'Status or resolution changes' ) => 'l' ,
245 draw_checkbox ( 'emailopts[1][64]' , $checked [ 1 ][ 64 ]) => 'c' ,
246 draw_checkbox ( 'emailopts[2][64]' , $checked [ 2 ][ 64 ]) => 'c' ,
247 draw_checkbox ( 'emailopts[4][64]' , $checked [ 4 ][ 64 ]) => 'c' ,
248 draw_checkbox ( 'emailopts[8][64]' , $checked [ 8 ][ 64 ]) => 'c' ,
249 draw_checkbox ( 'emailopts[16][64]' , $checked [ 16 ][ 64 ]) => 'c' ,
252 $admin- > row_multi_item ( array (
253 _ ( "'Duplicates' field is changed" ) => 'l' ,
254 draw_checkbox ( 'emailopts[1][128]' , $checked [ 1 ][ 128 ]) => 'c' ,
255 draw_checkbox ( 'emailopts[2][128]' , $checked [ 2 ][ 128 ]) => 'c' ,
256 draw_checkbox ( 'emailopts[4][128]' , $checked [ 4 ][ 128 ]) => 'c' ,
257 draw_checkbox ( 'emailopts[8][128]' , $checked [ 8 ][ 128 ]) => 'c' ,
258 draw_checkbox ( 'emailopts[16][128]' , $checked [ 16 ][ 128 ]) => 'c' ,
261 $admin- > row_multi_item ( array (
262 _ ( 'A new comment is added' ) => 'l' ,
263 draw_checkbox ( 'emailopts[1][256]' , $checked [ 1 ][ 256 ]) => 'c' ,
264 draw_checkbox ( 'emailopts[2][256]' , $checked [ 2 ][ 256 ]) => 'c' ,
265 draw_checkbox ( 'emailopts[4][256]' , $checked [ 4 ][ 256 ]) => 'c' ,
266 draw_checkbox ( 'emailopts[8][256]' , $checked [ 8 ][ 256 ]) => 'c' ,
267 draw_checkbox ( 'emailopts[16][256]' , $checked [ 16 ][ 256 ]) => 'c' ,
270 $admin- > row_multi_item ( array (
271 _ ( 'A new attachment is added' ) => 'l' ,
272 draw_checkbox ( 'emailopts[1][512]' , $checked [ 1 ][ 512 ]) => 'c' ,
273 draw_checkbox ( 'emailopts[2][512]' , $checked [ 2 ][ 512 ]) => 'c' ,
274 draw_checkbox ( 'emailopts[4][512]' , $checked [ 4 ][ 512 ]) => 'c' ,
275 draw_checkbox ( 'emailopts[8][512]' , $checked [ 8 ][ 512 ]) => 'c' ,
276 draw_checkbox ( 'emailopts[16][512]' , $checked [ 16 ][ 512 ]) => 'c' ,
279 $admin- > row_multi_item ( array (
280 _ ( 'Any other field changes' ) => 'l' ,
281 draw_checkbox ( 'emailopts[1][1024]' , $checked [ 1 ][ 1024 ]) => 'c' ,
282 draw_checkbox ( 'emailopts[2][1024]' , $checked [ 2 ][ 1024 ]) => 'c' ,
283 draw_checkbox ( 'emailopts[4][1024]' , $checked [ 4 ][ 1024 ]) => 'c' ,
284 draw_checkbox ( 'emailopts[8][1024]' , $checked [ 8 ][ 1024 ]) => 'c' ,
285 draw_checkbox ( 'emailopts[16][1024]' , $checked [ 16 ][ 1024 ]) => 'c' ,
288 // -------------------------------------------------------------------
289 $admin- > row_submit ( null , ':save:' , ':reset:' , 6 );
297 // ###################################################################
299 if ( $_REQUEST [ 'do' ] == 'search' )
303 NavLinks
:: usersAdd ();
304 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
306 if ( is_numeric ( $bugsys- > in
[ 'userdata' ]))
308 $bugsys- > input_clean ( 'userdata' , TYPE_UINT
);
309 if ( $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "user WHERE userid = " . $bugsys- > in
[ 'userdata' ]))
311 header ( 'Location: user.php?do=edit&userid=' . $bugsys- > in
[ 'userdata' ]);
320 $bugsys- > in
[ 'userdata' ] = str_replace ( '%' , '\%' , $bugsys- > in
[ 'userdata' ]);
321 $results = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "user WHERE email LIKE '%" . $bugsys- > input_escape ( 'userdata' ) . "%' OR displayname LIKE '%" . $bugsys- > input_escape ( 'userdata' ) . "%'" );
323 if ( $db- > num_rows ( $results ) < 1 )
329 $admin- > page_start ( _ ( 'Search Results' ));
331 $admin- > table_start ();
332 $admin- > table_head ( _ ( 'Search Results' ), 4 );
333 $admin- > table_column_head ( array ( _ ( 'Display Name' ), _ ( 'Email' ), _ ( 'User ID' ), _ ( 'Actions' )));
335 while ( $row = $db- > fetch_array ( $results ))
337 $admin- > row_multi_item ( array (
338 $row [ 'displayname' ] => 'l' ,
339 $row [ 'email' ] => 'c' ,
340 $row [ 'userid' ] => 'c' ,
341 '<a href="user.php?do=edit&userid=' . $row [ 'userid' ] . '">[' . _ ( 'Edit' ) . ']</a>' => 'c'
353 $admin- > error ( _ ( 'Sorry, we could not find any users that matched your criteria.' ));
357 // ###################################################################
359 if ( $_REQUEST [ 'do' ] == 'modify' )
361 NavLinks
:: usersAdd ();
362 $navigator- > set_focus ( 'link' , 'users-pages-users' , 'users-pages' );
364 $admin- > page_start ( _ ( 'User Search' ));
366 $admin- > form_start ( 'user.php' , 'search' );
367 $admin- > table_start ( true , '45%' );
369 $admin- > table_head ( _ ( 'User Search' ));
370 $admin- > row_input ( _ ( 'Name/Email/ID' ), 'userdata' );
372 $admin- > row_submit ( '' , ':save:' , '' );
380 /*=====================================================================*\
381 || ###################################################################
384 || ###################################################################
385 \*=====================================================================*/