]>
src.bluestatic.org Git - bugdar.git/blob - admin/field.php
2 /*=====================================================================*\
3 || ################################################################### ||
4 || # BugStrike [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
7 || # This file may not be reproduced in any way without permission. # ||
8 || # --------------------------------------------------------------- # ||
9 || # User License Agreement at http://www.iris-studios.com/license/ # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 require_once ( './global.php' );
15 if (! can_perform ( 'canadminfields' ))
21 'input_text' => $lang- > string ( 'Single-Line Text Box' ),
22 'input_checkbox' => $lang- > string ( 'Checkbox Flag' ),
23 'select_single' => $lang- > string ( 'Drop-Down Menu' ),
26 // ###################################################################
28 if ( empty ( $_REQUEST [ 'do' ]))
30 $_REQUEST [ 'do' ] = 'modify' ;
33 // ###################################################################
35 if ( $_REQUEST [ 'do' ] == 'kill' )
37 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
40 $admin- > error ( $lang- > getlex ( 'error_invalid_id' ));
43 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = $field [fieldid]" );
44 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "bugfieldpermission WHERE fieldid = $field [fieldid]" );
45 $db- > query ( "ALTER TABLE " . TABLE_PREFIX
. "bugvaluefill DROP field $field [fieldid]" );
46 $db- > query ( "OPTIMIZE TABLE " . TABLE_PREFIX
. "bugvaluefill" );
48 $admin- > redirect ( 'field.php?do=modify' );
51 // ###################################################################
53 if ( $_REQUEST [ 'do' ] == 'delete' )
55 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
58 $admin- > error ( $lang- > getlex ( 'error_invalid_id' ));
61 $admin- > page_confirm ( $lang- > string ( 'Are you sure you want to delete this bug field? Doing so will remove everything for this field and it cannot be undone!' ), "field.php?do=kill&fieldid= $field [fieldid]" );
64 // ###################################################################
66 if ( $_REQUEST [ 'do' ] == 'update' )
71 $type = $bugsys- > in
[ 'type' ];
73 if ( $bugsys- > in
[ 'fieldid' ])
75 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
78 $admin- > error ( $lang- > getlex ( 'error_invalid_id' ));
83 $type = $field [ 'type' ];
86 if ( empty ( $bugsys- > in
[ 'name' ]))
88 $admin- > error ( $lang- > string ( 'You must specify a display name.' ));
90 if (! isset ( $TYPES [ " $type" ]) AND $add )
92 $admin- >error( $lang- >string('Invalid field type specified.'));
98 $extrafields = 'defaultvalue, regexmatch, maxlength';
99 $extradata = " '" . $bugsys- >in[' defaultvalue
'] . "' , '" . $bugsys- >in[' regexmatch
'] . "' , " . intval( $bugsys- >in['maxlength']);
100 $extraupdate = " defaultvalue
= '" . $bugsys- >in[' defaultvalue
'] . "' , regexmatch
= '" . $bugsys- >in[' regexmatch
'] . "' , maxlength
= " . intval( $bugsys- >in['maxlength']);
103 case 'input_checkbox':
104 $extrafields = 'defaultvalue';
105 $extradata = intval( $bugsys- >in['defaultvalue']);
106 $extraupdate = " defaultvalue
= " . intval( $bugsys- >in['defaultvalue']);
109 case 'select_single':
110 $extrafields = 'selects, usedefault';
112 // can't use explode() here because explode() returns !empty() when splitting an empty string
113 // so we have to use preg_split with the PREG_SPLIT_NO_EMPTY flag to prevent this
114 $selects = preg_split(" #\n#", trim($bugsys->in['selects']), 0, PREG_SPLIT_NO_EMPTY);
115 array_walk ( $selects , 'trim' );
116 if ( count ( $selects ) < 1 )
118 $admin- > error ( $lang- > string ( 'You need to specify some select values.' ));
121 $extradata = "'" . $bugsys- > escape ( serialize ( $selects )) . "', " . intval ( $bugsys- > in
[ 'usedefault' ]);
122 $extraupdate = "selects = '" . $bugsys- > escape ( serialize ( $selects )) . "', usedefault = " . intval ( $bugsys- > in
[ 'usedefault' ]);
130 (name, description, type, required, cansearch, $extrafields )
132 ('" . $bugsys- > in
[ 'name' ] . "',
133 '" . $bugsys- > in
[ 'description' ] . "', ' $type' , " . intval ( $bugsys- > in
[ 'required' ]) . ",
134 " . intval ( $bugsys- > in
[ 'cansearch' ]) . ", $extradata
138 $fieldid = $db- > insert_id ();
140 $db- > query ( "ALTER TABLE " . TABLE_PREFIX
. "bugvaluefill ADD field $fieldid MEDIUMTEXT NULL" );
141 $db- > query ( "OPTIMIZE TABLE " . TABLE_PREFIX
. "bugvaluefill" );
146 UPDATE " . TABLE_PREFIX
. "bugfield
147 SET name = '" . $bugsys- > in
[ 'name' ] . "',
148 description = '" . $bugsys- > in
[ 'description' ] . "',
149 required = " . intval ( $bugsys- > in
[ 'required' ]) . ",
150 cansearch = " . intval ( $bugsys- > in
[ 'cansearch' ]) . ",
152 WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ])
155 $fieldid = intval ( $bugsys- > in
[ 'fieldid' ]);
158 foreach ( $bugsys- > in
[ 'custom' ] AS $usergroupid => $mask )
160 $values [] = intval ( $usergroupid ) . ", $fieldid , " . intval ( $mask );
164 REPLACE INTO " . TABLE_PREFIX
. "bugfieldpermission
165 (usergroupid, fieldid, mask)
167 (" . implode ( "), \n\t\t\t (" , $values ) . ")"
170 $admin- > redirect ( 'field.php?do=modify' , ( $add ? $lang- > string ( 'The custom field has been added' ) : $lang- > string ( 'The custom field has been updated' )));
173 // ###################################################################
175 if ( $_REQUEST [ 'do' ] == 'add' OR $_REQUEST [ 'do' ] == 'edit' )
177 $add = (( $_REQUEST [ 'do' ] == 'add' ) ? true : false );
178 $typeselect = (( $add AND empty ( $bugsys- > in
[ 'step' ])) ? true : false );
179 $edit = (( $add ) ? false : true );
181 $admin- > page_start (( $add ? $lang- > string ( 'Add New Custom Field' ) : $lang- > string ( 'Edit Custom Field' )));
182 $admin- > form_start ( 'field.php' , ( $typeselect ? 'add' : 'update' ));
183 if ( $add AND ! $typeselect )
185 $admin- > form_hidden_field ( 'type' , $bugsys- > in
[ 'type' ]);
189 $admin- > form_hidden_field ( 'step' , 1 );
190 $admin- > table_start ( true , '40%' );
191 $admin- > table_head ( $lang- > string ( 'Select Type' ));
195 $admin- > table_start ();
196 $admin- > table_head (( $add ? $lang- > string ( 'Add New Bug Field' ) . ' - ' . $TYPES [ $bugsys- > in
[ 'type' ] ] : $lang- > string ( 'Edit Field' )));
201 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
204 $admin- > error ( $lang- > getlex ( 'error_invalid_id' ));
207 $admin- > form_hidden_field ( 'fieldid' , $field [ 'fieldid' ]);
212 $type = (( $add ) ? $bugsys- > in
[ 'type' ] : $field [ 'type' ]);
215 // show type selector
216 if ( empty ( $bugsys- > in
[ 'step' ]) AND $add )
218 foreach ( $TYPES AS $name => $description )
220 $admin- > list_item ( $description , $name );
222 $admin- > row_list ( $lang- > string ( 'Field Type' ), 'type' , false );
224 $admin- > row_submit ();
227 // have type, do that funkay thing!
230 if (! isset ( $TYPES [ " $type" ]))
232 $admin- >error( $lang- >getlex('error_invalid_id'));
236 $admin- >row_span( $lang- >string('Global Fields'), 'thead', 'center');
237 $admin- >row_text( $lang- >string('Field Type'), $TYPES [" $type" ]);
238 $admin- > row_input ( $lang- > string ( 'Display Name' ), 'name' , $field [ 'name' ]);
239 $admin- > row_textarea ( $lang- > string ( 'Description' ), 'description' , $field [ 'description' ]);
240 $admin- > row_yesno ( $lang- > string ( 'Required' ), 'required' , $field [ 'required' ]);
241 $admin- > row_yesno ( $lang- > string ( 'Can Be Searched' ), 'cansearch' , (( isset ( $field [ 'cansearch' ])) ? $field [ 'cansearch' ] : true ));
243 // type-specific fields
244 $admin- > row_span ( $lang- > string ( 'Type-Specific Fields' ), 'thead' , 'center' );
249 $admin- > row_input ( $lang- > string ( 'Default Value' ), 'defaultvalue' , $field [ 'defaultvalue' ]);
250 $admin- > row_input ( $lang- > string ( 'Regular Expression Match' ), 'regexmatch' , $field [ 'regexmatch' ]);
251 $admin- > row_input ( $lang- > string ( 'Maximum Length' ), 'maxlength' , $field [ 'maxlength' ], 2 , 10 );
254 case 'input_checkbox' :
255 $admin- > row_yesno ( $lang- > string ( 'Checked By Default' ), 'defaultvalue' , $field [ 'defaultvalue' ]);
258 case 'select_single' :
259 $admin- > row_textarea ( $lang- > string ( 'Selection Values' ), 'selects' , stripslashes ( implode ( " \n " , unserialize ( $field [ 'selects' ]))));
260 $admin- > row_yesno ( $lang- > string ( 'Make the First Option Default' ), 'usedefault' , $field [ 'usedefault' ]);
266 // custom field permissions
267 $admin- > table_start ();
268 $admin- > table_head ( $lang- > string ( 'Custom Field Permissions' ));
272 $perms = $db- > query ( "SELECT usergroupid, mask FROM " . TABLE_PREFIX
. "bugfieldpermission WHERE fieldid = $field [fieldid]" );
273 while ( $perm = $db- > fetch_array ( $perms ))
275 $permissions [ " $perm [usergroupid]" ] = $perm [ 'mask' ];
279 $usergroups = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "usergroup ORDER BY usergroupid" );
280 while ( $usergroup = $db- > fetch_array ( $usergroups ))
283 $admin- > list_item ( $lang- > string ( 'No Permission' ), 0 , $permissions [ " $usergroup [usergroupid]" ] == 0 );
284 $admin- > list_item ( $lang- > string ( 'Can View Field' ), 1 , $permissions [ " $usergroup [usergroupid]" ] == 1 );
285 $admin- > list_item ( $lang- > string ( 'Can View, Edit Field' ), 2 , $permissions [ " $usergroup [usergroupid]" ] == 2 );
286 $admin- > row_list ( $usergroup [ 'title' ], "custom[ $usergroup [usergroupid]]" );
292 $admin- > table_start ();
293 $admin- > row_submit ((( $edit ) ? '<a href="field.php?do=delete&fieldid=' . $field [ 'fieldid' ] . '">[' . $lang- > string ( 'Delete Field' ) . ']</a>' : '' ));
301 // ###################################################################
303 if ( $_REQUEST [ 'do' ] == 'modify' )
305 $admin- > page_start ( $lang- > string ( 'Additional Bug Fields' ));
307 $admin- > table_start ();
308 $admin- > table_head ( $lang- > string ( 'Additional Bug Fields' ), 3 );
309 $admin- > table_column_head ( array ( $lang- > string ( 'Display Name/Description' ), $lang- > string ( 'Field ID' ), $lang- > string ( 'Actions' )));
311 $fields = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield ORDER BY fieldid ASC" );
312 while ( $field = $db- > fetch_array ( $fields ))
314 $admin- > row_multi_item (
316 " $field [name]<div class= \" smallfont \" ><em> $field [description]</em></div>" => 'l' ,
317 " $field [fieldid]" => 'c' ,
318 "<a href= \" field.php?do=edit&fieldid= $field [fieldid] \" >[" . $lang- > string ( 'Edit' ) . "]</a> <a href= \" field.php?do=delete&fieldid= $field [fieldid] \" >[" . $lang- > string ( 'Delete' ) . "]</a>" => 'c'
323 $admin- > row_span ( '<a href="field.php?do=add">[' . $lang- > string ( 'Add New Bug Field' ) . ']</a>' , 'tfoot' , 'center' , 3 );
329 /*=====================================================================*\
330 || ###################################################################
333 || ###################################################################
334 \*=====================================================================*/