r1116: Fix a product/productid issue... yes, another one
[bugdar.git] / includes / functions.php
1 <?php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
6 || #
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.
10 || #
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
14 || # more details.
15 || #
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 \*=====================================================================*/
21
22 // ###################################################################
23 /**
24 * Constructs HTML code <select>s from an array. You use they keys when
25 * you need to access a multi-dimensional array of data.
26 *
27 * @access public
28 *
29 * @param string HTML name of the select
30 * @param array Array of <option>s
31 * @param integer ID of the selected item, 0 for none
32 * @param string Name of the index where values are stored in the $array
33 * @param string Name of the iddex where the labels are stored in $array
34 * @param bool Value of the blank option, FALSE turns it off
35 * @param bool Construct a multiple-selection <select> menu and append "[]" to the end of the name
36 *
37 * @return string Constructed HTML output
38 */
39 function construct_option_select($name, $array, $selected = 0, $valuekey = '', $labelkey = '', $includenil = false, $multiple = false)
40 {
41 global $bugsys;
42
43 if ($multiple)
44 {
45 $selected = explode(',', $selected);
46 }
47
48 // if we're not working on a boolean false, we use it for the value (allows -1 and 0)
49 if ($includenil !== false)
50 {
51 $opts[] = '<option value="' . $includenil . '"' . ((!$selected OR (is_array($selected) AND in_array($includenil, $selected))) ? ' selected="selected"' : '') . '> ---------</option>';
52 }
53 foreach ($array AS $value => $label)
54 {
55 $newval = ($valuekey ? $label["$valuekey"] : $value);
56 $newlab = ($labelkey ? $label["$labelkey"] : $label);
57 $opts[] = '<option value="' . $newval . '"' . (($selected == $newval OR (is_array($selected) AND in_array($newval, $selected))) ? ' selected="selected"' : '') . '>' . $newlab . '</option>';
58 }
59 return '<select class="input" name="' . $name . ($multiple ? '[]' : '') . '"' . ($multiple ? ' multiple="multiple" size="' . (sizeof($array) < 8 ? sizeof($array) + 1 : 8) . '"' : '') . '>' . implode("\n\t", $opts) . "\r</select>";
60 }
61
62 // ################### Start construct_user_display ##################
63 // $userinfo needs userid, email, displayname, and showemail
64 function construct_user_display($userinfo, $html = true)
65 {
66 global $bugsys;
67
68 if (!$userinfo['userid'])
69 {
70 $userinfo['displayname'] = $bugsys->lang->string('Guest');
71 $userinfo['showemail'] = false;
72 }
73
74 if ($html)
75 {
76 eval('$username = "' . $bugsys->template->fetch('username_display') . '";');
77 }
78 else
79 {
80 if ($userinfo['showemail'])
81 {
82 $username = sprintf($bugsys->lang->string('%1$s &lt;%2$s&gt;'), $userinfo['displayname'], $userinfo['email']);
83 }
84 else
85 {
86 $username = $userinfo['displayname'];
87 }
88 }
89
90 return $username;
91 }
92
93 // ######################## Start can_perform ########################
94 // short-hand for bitwise &
95 function can_perform($bitmask, $productid = 0, $userinfo = null)
96 {
97 global $bugsys;
98
99 if ($userinfo == null)
100 {
101 $userinfo =& $bugsys->userinfo;
102 }
103
104 if (!isset($bugsys->permissions["$bitmask"]))
105 {
106 trigger_error('Invalid bitmask "' . $bitmask . '" specified for can_perform() [includes/functions.php]', E_USER_WARNING);
107 }
108
109 if (!$userinfo['permissions'])
110 {
111 $userinfo['permissions'] = (int)$bugsys->datastore['usergroup']["$userinfo[usergroupid]"]['permissions'];
112 }
113
114 if ($productid AND isset($bugsys->datastore['permission']["$userinfo[usergroupid]"]["$productid"]))
115 {
116 $inspecific = array('cansearch', 'canbeassignedto', 'canadminpanel', 'canadminbugs', 'canadminfields', 'canadminversions', 'canadminusers', 'canadmingroups', 'canadmintools');
117
118 if (!in_array($bitmask, $inspecific))
119 {
120 $bugsys->debug("verdict* on can_perform($bitmask, $productid, $userinfo[userid]) = " . ($bugsys->datastore['permission']["$userinfo[usergroupid]"]["$productid"] & $bugsys->permissions["$bitmask"]));
121 return ($bugsys->datastore['permission']["$userinfo[usergroupid]"]["$productid"] & $bugsys->permissions["$bitmask"]);
122 }
123 }
124
125 $bugsys->debug("verdict on can_perform($bitmask, $productid, $userinfo[userid]) = " . ($userinfo['permissions'] & $bugsys->permissions["$bitmask"]));
126 return ($userinfo['permissions'] & $bugsys->permissions["$bitmask"]);
127 }
128
129 // ###################################################################
130 /**
131 * Runs through a given datastore item and creates a series of <select>
132 * options.
133 *
134 * @access public
135 *
136 * @param string Datastore name
137 * @param string Array index for the label
138 * @param string Array index for the value
139 * @param mixed The selected value(s)
140 * @param bool Include a blank option? TRUE will set a null value, FALSE turns it off, anything else is used as the value for the blank option
141 * @param bool Generate it using admin printers?
142 *
143 * @return string Unelss in admin mode, returns the constructed options
144 */
145 function construct_datastore_select($datastore, $labelname, $valuename, $selectedvalue = 0, $includeblank = false, $adminmode = false)
146 {
147 global $bugsys;
148
149 if ($adminmode)
150 {
151 global $admin;
152 }
153
154 $select = '';
155
156 if ($includeblank === true OR $includeblank !== false)
157 {
158 $newval = ($inclueblank === true ? '' : $includeblank);
159 if ($adminmode)
160 {
161 $admin->list_item('', '', ((!$selectedvalue OR (is_array($selectedvalue) AND in_array($newval, $selectedvalue))) ? true : false));
162 }
163 else
164 {
165 $label = '';
166 $value = $newval;
167 $selected = ((!$selectedvalue OR (is_array($selectedvalue) AND in_array($newval, $selectedvalue))) ? true : false);
168 eval('$select .= "' . $bugsys->template->fetch('selectoption') . '";');
169 }
170 }
171
172 foreach ($bugsys->datastore["$datastore"] AS $item)
173 {
174 $label = $item["$labelname"];
175 $value = $item["$valuename"];
176 $selected = (($value == $selectedvalue OR (is_array($selectedvalue) AND in_array($value, $selectedvalue))) ? true : false);
177
178 if ($adminmode)
179 {
180 $admin->list_item($label, $value, $selected);
181 }
182 else
183 {
184 eval('$select .= "' . $bugsys->template->fetch('selectoption') . '";');
185 }
186 }
187
188 if (!$adminmode)
189 {
190 return $select;
191 }
192 }
193
194 // ################## Start construct_custom_fields ##################
195 function construct_custom_fields($bug = array(), $ignore21mask = false, $nodefault = false)
196 {
197 global $bugsys;
198 static $fields;
199
200 if (!is_array($fields))
201 {
202 $fields = array();
203 $fields_fetch = $bugsys->db->query("
204 SELECT bugfield.*, permission.mask
205 FROM " . TABLE_PREFIX . "bugfield AS bugfield
206 LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
207 ON (bugfield.fieldid = permission.fieldid)
208 WHERE (permission.mask = 2 OR permission.mask = 1)
209 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
210 );
211 while ($field = $bugsys->db->fetch_array($fields_fetch))
212 {
213 $fields["$field[fieldid]"] = $field;
214 }
215 }
216
217 $fieldvalues = $bugsys->db->query_first("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill WHERE bugid = " . $bugsys->clean($bug['bugid'], TYPE_UINT));
218
219 $fieldbits = array();
220
221 foreach ($fields AS $field)
222 {
223 if ($nodefault)
224 {
225 $field['defaultvalue'] = '';
226 }
227
228 if (!is_null($bug["field$field[fieldid]"]))
229 {
230 $bugsys->debug("not null: $field[fieldid]");
231 $value = $bug["field$field[fieldid]"];
232 }
233 else
234 {
235 $value = $field['defaultvalue'];
236 }
237
238 if ($ignore21mask AND $field['mask'] != 0)
239 {
240 $field['mask'] = 2;
241 }
242
243 if ($field['mask'] == 2)
244 {
245 switch ($field['type'])
246 {
247 case 'input_text':
248 eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_text') . '";');
249 break;
250
251 case 'input_checkbox':
252 $selected = (($value) ? ' checked="checked"' : '');
253 eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_checkbox') . '";');
254 break;
255
256 case 'select_single':
257 $selects = unserialize($field['selects']);
258 $value = trim($value);
259
260 $options = '';
261
262 $id = -1;
263 $select = '';
264 if (!$field['usedefault'] AND !trim($value))
265 {
266 $selected = ' selected="selected"';
267 }
268 else
269 {
270 $selected = '';
271 }
272 eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
273
274 foreach ($selects AS $id => $select)
275 {
276 $selected = '';
277 $select = stripslashes(trim($select));
278 if ($select == $value)
279 {
280 $selected = ' selected="selected"';
281 }
282 else if ($field['usedefault'] AND $id == 0)
283 {
284 $selected = ' selected="selected"';
285 }
286 eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
287 }
288 eval('$tempfield = "' . $bugsys->template->fetch('bugfield_select_single') . '";');
289 break;
290 }
291 }
292 else
293 {
294 $bugsys->debug('mask 1 processing');
295 if (is_null($fieldvalues["field$field[fieldid]"]))
296 {
297 $bugsys->debug("is null: $field[fieldid]");
298 if ($field['type'] == 'select_single')
299 {
300 if ($field['usedefault'])
301 {
302 $temp = unserialize($field['selects']);
303 $value = trim($temp[0]);
304 }
305 else
306 {
307 $value = $fieldvalues["field$field[fieldid]"];
308 }
309 }
310 else
311 {
312 $value = $field['defaultvalue'];
313 }
314 }
315 else
316 {
317 $value = $fieldvalues["field$field[fieldid]"];
318 }
319
320 if ($field['type'] == 'input_checkbox')
321 {
322 $value = (($value) ? 'True' : 'False');
323 }
324 $field['value'] = $value;
325 eval('$tempfield = "' . $bugsys->template->fetch('bugfield_static_text') . '";');
326 }
327 $fieldbits[] = $tempfield;
328 }
329
330 return $fieldbits;
331 }
332
333 // ################### Start process_custom_fields ###################
334 function process_custom_fields($bugid, $inputdata = array())
335 {
336 global $bugsys;
337
338 if (!$inputdata)
339 {
340 $inputdata =& $bugsys->in;
341 }
342
343 $fields = $bugsys->db->query("
344 SELECT bugfield.*
345 FROM " . TABLE_PREFIX . "bugfield AS bugfield
346 LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
347 ON (bugfield.fieldid = permission.fieldid)
348 WHERE permission.mask = 2
349 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
350 );
351 while ($field = $bugsys->db->fetch_array($fields))
352 {
353 if ($field['type'] == 'input_checkbox')
354 {
355 $fieldbuild[] = 'field' . $field['fieldid'];
356 if (isset($inputdata["field$field[fieldid]"]))
357 {
358 $fieldvalue[] = 1;
359 }
360 else
361 {
362 $fieldvalue[] = 0;
363 }
364 continue;
365 }
366
367 if ($field['required'] AND empty($inputdata["field$field[fieldid]"]))
368 {
369 $errorlist[] = sprintf($bugsys->lang->string('The "%1$s" field is a required field.'), $field['name']);
370 continue;
371 }
372
373 if (isset($inputdata["field$field[fieldid]"]))
374 {
375 $fieldbuild[] = 'field' . $field['fieldid'];
376
377 if ($field['type'] == 'input_text')
378 {
379 $fieldvalue[] = "'" . $inputdata["field$field[fieldid]"] . "'";
380 }
381 else
382 {
383 if ($inputdata["field$field[fieldid]"] == -1)
384 {
385 $fieldvalue[] = "''";
386 continue;
387 }
388
389 $temp = unserialize($field['selects']);
390 $fieldvalue[] = "'" . trim($temp[ intval($inputdata["field$field[fieldid]"]) ]) . "'";
391 }
392 }
393 }
394
395 if ($errorlist)
396 {
397 return $errorlist;
398 }
399
400 if (sizeof($fieldbuild) < 1)
401 {
402 return;
403 }
404
405 $bugsys->db->query("REPLACE INTO " . TABLE_PREFIX . "bugvaluefill (bugid, " . implode(', ', $fieldbuild) . ") VALUES ($bugid, " . implode(', ', $fieldvalue) . ")");
406 }
407
408 // ####################### Start fetch_on_bits #######################
409 function fetch_on_bits($mask, $userinfo = null)
410 {
411 global $bugsys;
412
413 if ($userinfo == null)
414 {
415 $userinfo =& $bugsys->userinfo;
416 }
417
418 $onbits = array();
419
420 $usergroupid = $userinfo['usergroupid'];
421
422 if ($bugsys->datastore['usergroup']["$usergroupid"]['permissions'] & $bugsys->permissions["$mask"] AND is_array($bugsys->datastore['product']))
423 {
424 foreach ($bugsys->datastore['product'] AS $id => $product)
425 {
426 if (!$product['componentmother'])
427 {
428 $onbits["$id"] = $id;
429 }
430 }
431 }
432
433 if (is_array($bugsys->datastore['permission']["$usergroupid"]))
434 {
435 foreach ($bugsys->datastore['permission']["$usergroupid"] AS $productid => $bit)
436 {
437 if ($bit & $bugsys->permissions["$mask"])
438 {
439 $onbits["$productid"] = $productid;
440 }
441 else
442 {
443 if ($onbits["$productid"])
444 {
445 unset($onbits["$productid"]);
446 }
447 }
448 }
449 }
450
451 if (sizeof($onbits) < 1)
452 {
453 $onbits = array(0);
454 }
455
456 return implode(',', $onbits);
457 }
458
459 // #################### Start isso_pre_parse_hook ####################
460 // the pre-parse hook for ISSO's template engine
461 function isso_pre_parse_hook($template)
462 {
463 $template = preg_replace('#\$help\[(.*)\]#', '" . fetch_help_link("\1") . "', $template);
464 return $template;
465 }
466
467 // ###################### Start fetch_help_link ######################
468 // returns a prepared link to insert into templates that opens up a
469 // help popup in the user-end
470 function fetch_help_link($topic)
471 {
472 global $bugsys;
473
474 if (isset($bugsys->datastore['help']["$topic"]))
475 {
476 eval('$temp = "' . $bugsys->template->fetch('help_link') . '";');
477 return $temp;
478 }
479 else
480 {
481 if ($bugsys->debug)
482 {
483 return "[[INVALID TOPIC: $topic]]";
484 }
485 // do we want this?
486 else if (null == 1)
487 {
488 return eval('$temp = "' . $bugsys->template->fetch('help_link') . '";');
489 }
490 }
491 }
492
493 // ###################################################################
494 /**
495 * Returns a user array of information that is specific to all visiting
496 * users (guests). This can then be passed to any function that requires
497 * user information.
498 *
499 * @access public
500 *
501 * @return array User information array
502 */
503 function fetch_guest_user()
504 {
505 global $bugsys;
506
507 return array(
508 'usergroupid' => 1,
509 'userid' => 0,
510 'email' => '',
511 'displayname' => '',
512 'showcolors' => 1,
513 'permissions' => $bugsys->datastore['usergroup'][1]['permissions'],
514 'displaytitle' => $bugsys->datastore['usergroup'][1]['displaytitle'],
515 );
516 }
517
518 // ###################################################################
519 /**
520 * Does an exhaustive permissions check on the bug. It checks for hidden
521 * bug status and ability to view hidden bugs. This normally was done
522 * at the top of each page, but it got so big, it was moved to a function.
523 *
524 * @access public
525 *
526 * @param array Bug array
527 * @param array Alternate user array
528 *
529 * @return bool Does the user have permission
530 */
531 function check_bug_permissions($bug, $userinfo = null)
532 {
533 global $bugsys;
534 if ($userinfo == null)
535 {
536 $userinfo = $bugsys->userinfo;
537 }
538
539 $bugsys->debug("checking permissions for $userinfo[userid] on bug $bug[bugid]");
540
541 if
542 (
543 !can_perform('canviewbugs', $bug['product'], $userinfo)
544 OR
545 !(
546 (
547 $bug['hidden']
548 AND
549 (
550 ($userinfo['userid'] == $bug['userid'] AND can_perform('canviewownhidden', $bug['product'], $userinfo))
551 OR
552 can_perform('canviewhidden', $bug['product'], $userinfo)
553 )
554 )
555 OR
556 !$bug['hidden']
557 )
558 )
559 {
560 return false;
561 }
562
563 return true;
564 }
565
566 /*=====================================================================*\
567 || ###################################################################
568 || # $HeadURL$
569 || # $Id$
570 || ###################################################################
571 \*=====================================================================*/
572 ?>