]>
src.bluestatic.org Git - bugdar.git/blob - admin/fields.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' => 'Single-Line Text Box' ,
22 'input_checkbox' => 'Checkbox Flag' ,
23 'select_single' => '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 ( phrase ( 'error_invalid_id' ));
43 $db- > query ( "DELETE FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = $field [fieldid]" );
44 $db- > query ( "ALTER TABLE " . TABLE_PREFIX
. "bugvaluefill DROP field $field [fieldid]" );
45 $db- > query ( "OPTIMIZE TABLE " . TABLE_PREFIX
. "bugvaluefill" );
47 $admin- > redirect ( 'fields.php?do=modify' , 'The field has been successfully removed from the system.' );
50 // ###################################################################
52 if ( $_REQUEST [ 'do' ] == 'delete' )
54 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
57 $admin- > error ( phrase ( 'error_invalid_id' ));
60 $admin- > page_confirm ( 'Are you sure you want to delete this bug field? Doing so will remove everything for this field and it cannot be undone!' , "fields.php?do=kill&fieldid= $field [fieldid]" );
63 // ###################################################################
65 if ( $_REQUEST [ 'do' ] == 'update' )
70 $type = $bugsys- > in
[ 'type' ];
72 if ( $bugsys- > in
[ 'fieldid' ])
74 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
77 $admin- > error ( phrase ( 'error_invalid_id' ));
82 $type = $field [ 'type' ];
85 if ( empty ( $bugsys- > in
[ 'shortname' ]) AND $add )
87 $admin- > error ( 'You must specify a short name/call name.' );
89 /*if ((preg_match('#[^a-z0-9_]#', $bugsys->in['shortname']) OR !preg_match('#^[a-z]#', $bugsys->in['shortname']) OR preg_match('#[^a-z0-9]$#', $bugsys->in['shortname'])) AND $add)
91 $admin->error('The short name can only contain lowercase letters, numbers, and underscores; it must also begin with a letter and cannot end in anything but a letter or a number.');
94 if ( empty ( $bugsys- > in
[ 'name' ]))
96 $admin- > error ( 'You must specify a display name.' );
98 if (! isset ( $TYPES [ " $type" ]) AND $add )
100 $admin- >error('Invalid field type specified.');
106 $extrafields = 'defaultvalue, regexmatch, maxlength';
107 $extradata = " '" . $bugsys- >in[' defaultvalue
'] . "' , '" . $bugsys- >in[' regexmatch
'] . "' , " . intval( $bugsys- >in['maxlength']);
108 $extraupdate = " defaultvalue
= '" . $bugsys- >in[' defaultvalue
'] . "' , regexmatch
= '" . $bugsys- >in[' regexmatch
'] . "' , maxlength
= " . intval( $bugsys- >in['maxlength']);
111 case 'input_checkbox':
112 $extrafields = 'defaultvalue';
113 $extradata = intval( $bugsys- >in['defaultvalue']);
114 $extraupdate = " defaultvalue
= " . intval( $bugsys- >in['defaultvalue']);
117 case 'select_single':
118 $extrafields = 'selects, usedefault';
120 // can't use explode() here because explode() returns !empty() when splitting an empty string
121 // so we have to use preg_split with the PREG_SPLIT_NO_EMPTY flag to prevent this
122 $selects = preg_split(" #\n#", trim($bugsys->in['selects']), 0, PREG_SPLIT_NO_EMPTY);
123 array_walk ( $selects , 'trim' );
124 if ( count ( $selects ) < 1 )
126 $admin- > error ( 'You need to specify some select values.' );
129 $extradata = "'" . $bugsys- > escape ( serialize ( $selects )) . "', " . intval ( $bugsys- > in
[ 'usedefault' ]);
130 $extraupdate = "selects = '" . $bugsys- > escape ( serialize ( $selects )) . "', usedefault = " . intval ( $bugsys- > in
[ 'usedefault' ]);
136 if ( $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE shortname = '" . $bugsys- > in
[ 'shortname' ] . "'" ) OR $bugsys- > in
[ 'shortname' ] == 'bugid' )
138 $admin- > error ( 'That short name is already in use, please change it so it is unique.' );
145 name, description, type, required, cansearch, $extrafields )
148 #'" . $bugsys- > in
[ 'shortname' ] . "',
149 '" . $bugsys- > in
[ 'name' ] . "',
150 '" . $bugsys- > in
[ 'description' ] . "', ' $type' , " . intval ( $bugsys- > in
[ 'required' ]) . ",
151 " . intval ( $bugsys- > in
[ 'cansearch' ]) . ", $extradata
155 $fieldid = $db- > insert_id ();
157 $db- > query ( "ALTER TABLE " . TABLE_PREFIX
. "bugvaluefill ADD field $fieldid MEDIUMTEXT NULL" );
158 $db- > query ( "OPTIMIZE TABLE " . TABLE_PREFIX
. "bugvaluefill" );
163 UPDATE " . TABLE_PREFIX
. "bugfield
164 SET name = '" . $bugsys- > in
[ 'name' ] . "',
165 description = '" . $bugsys- > in
[ 'description' ] . "',
166 required = " . intval ( $bugsys- > in
[ 'required' ]) . ",
167 cansearch = " . intval ( $bugsys- > in
[ 'cansearch' ]) . ",
169 WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ])
173 $admin- > redirect ( 'fields.php?do=modify' , (( $add ) ? 'The custom bug field has been added.' : 'The bug field has been updated.' ));
176 // ###################################################################
178 if ( $_REQUEST [ 'do' ] == 'add' OR $_REQUEST [ 'do' ] == 'edit' )
180 $add = (( $_REQUEST [ 'do' ] == 'add' ) ? true : false );
181 $typeselect = (( $add AND empty ( $bugsys- > in
[ 'step' ])) ? true : false );
182 $edit = (( $add ) ? false : true );
184 $admin- > page_start ( phrase ((( $add ) ? 'add_new_field' : 'edit_field' )));
185 $admin- > form_start ( 'fields.php' , (( $typeselect ) ? 'add' : 'update' ));
186 if ( $add AND ! $typeselect )
188 $admin- > form_hidden_field ( 'type' , $bugsys- > in
[ 'type' ]);
192 $admin- > form_hidden_field ( 'step' , 1 );
193 $admin- > table_start ( true , '40%' );
194 $admin- > table_head ( 'Select Type' );
198 $admin- > table_start ();
199 $admin- > table_head ((( $add ) ? phrase ( 'add_new_field' ) . ' - ' . $TYPES [ $bugsys- > in
[ 'type' ] ] : phrase ( 'edit_field' )));
204 $field = $db- > query_first ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE fieldid = " . intval ( $bugsys- > in
[ 'fieldid' ]));
207 $admin- > error ( phrase ( 'error_invalid_id' ));
210 $admin- > form_hidden_field ( 'fieldid' , $field [ 'fieldid' ]);
215 $type = (( $add ) ? $bugsys- > in
[ 'type' ] : $field [ 'type' ]);
218 // show type selector
219 if ( empty ( $bugsys- > in
[ 'step' ]) AND $add )
221 foreach ( $TYPES AS $name => $description )
223 $admin- > list_item ( $description , $name );
225 $admin- > row_list ( 'Select field type' , 'type' , false );
227 $admin- > row_submit ();
230 // have type, do that funkay thing!
233 if (! isset ( $TYPES [ " $type" ]))
235 $admin- >error(phrase('error_invalid_id'));
239 $admin- >row_span('Global Fields', 'thead', 'center');
240 $admin- >row_text('Field Type', $TYPES [" $type" ]);
241 #$admin->row_input('Short Name/Call Name', 'shortname', $field['shortname']);
242 $admin- > row_input ( 'Display Name' , 'name' , $field [ 'name' ]);
243 $admin- > row_textarea ( 'Description' , 'description' , $field [ 'description' ]);
244 $admin- > row_yesno ( 'Required' , 'required' , $field [ 'required' ]);
245 $admin- > row_yesno ( 'Can Be Searched' , 'cansearch' , (( isset ( $field [ 'cansearch' ])) ? $field [ 'cansearch' ] : true ));
247 // type-specific fields
248 $admin- > row_span ( 'Type-Specific Fields' , 'thead' , 'center' );
253 $admin- > row_input ( 'Default Value' , 'defaultvalue' , $field [ 'defaultvalue' ]);
254 $admin- > row_input ( 'Regular Expression Match' , 'regexmatch' , $field [ 'regexmatch' ]);
255 $admin- > row_input ( 'Maximum Length' , 'maxlength' , $field [ 'maxlength' ], 2 , 10 );
258 case 'input_checkbox' :
259 $admin- > row_yesno ( 'Checked By Default' , 'defaultvalue' , $field [ 'defaultvalue' ]);
262 case 'select_single' :
263 $admin- > row_textarea ( 'Selection Values' , 'selects' , stripslashes ( implode ( " \n " , unserialize ( $field [ 'selects' ]))));
264 $admin- > row_yesno ( 'Make the First Option Default' , 'usedefault' , $field [ 'usedefault' ]);
269 $admin- > row_submit ((( $edit ) ? '<a href="fields.php?do=delete&fieldid=' . $field [ 'fieldid' ] . '">[Delete Field]</a>' : '' ));
277 // ###################################################################
279 if ( $_REQUEST [ 'do' ] == 'modify' )
281 $admin- > page_start ( phrase ( 'additional_bug_fields' ));
283 $admin- > table_start ();
284 $admin- > table_head ( phrase ( 'additional_bug_fields' ), 3 );
285 $admin- > table_column_head ( array ( 'Display Name/Description' , 'Field ID' , 'Actions' ));
287 $fields = $db- > query ( "SELECT * FROM " . TABLE_PREFIX
. "bugfield ORDER BY fieldid ASC" );
288 while ( $field = $db- > fetch_array ( $fields ))
290 $admin- > row_multi_item (
292 " $field [name]<div class= \" smallfont \" ><em> $field [description]</em></div>" => 'l' ,
293 "(fieldid: $field [fieldid])" => 'c' ,
294 "<a href= \" fields.php?do=edit&fieldid= $field [fieldid] \" >[Edit]</a> <a href= \" fields.php?do=delete&fieldid= $field [fieldid] \" >[Delete]</a>" => 'c'
299 $admin- > row_span ( '<input type="button" name="addug" value=" ' . phrase ( 'add_new_field' ) . ' " onclick="window.location = \' fields.php?do=add \' ;" />' , 'tfoot' , 'center' , 3 );
305 /*=====================================================================*\
306 || ###################################################################
309 || ###################################################################
310 \*=====================================================================*/