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 $fetchtemplates = array(
21 define('SVN', '$Id$');
23 $focus['search
'] = 'focus
';
25 require_once('./global.php
');
27 if (!can_perform('cansearch
'))
29 $message->error_permission();
32 define('MODE
', intval($bugsys->in['mode
']));
33 define('MODE_ANY
', ((MODE == 1) ? 1 : 0));
34 define('MODE_ALL
', ((MODE == 2) ? 1 : 0));
35 define('MODE_RAW
', ((MODE == 3) ? 1 : 0));
37 define('SEARCH_WORD_MIN
', 3);
39 $show['search
'] = true;
41 // ###################################################################
43 if (empty($_REQUEST['do']))
45 $_REQUEST['do'] = 'search
';
48 // ###################################################################
50 if ($_REQUEST['do'] == 'process
')
52 // -------------------------------------------------------------------
53 // parse out our product/component/version
54 $pcv = parse_pcv_select($bugsys->in['pcv_select
']);
56 // -------------------------------------------------------------------
58 if ($bugsys->in['summary
'])
60 $keywords = preg_split('#\s+#', $bugsys->in['summary']);
62 // #*# need to have some str to bool conversions
64 foreach ($keywords AS $word)
66 if (strlen($word) < SEARCH_WORD_MIN
)
73 $querybuild['text'] .= " +$word";
77 $querybuild['text'] .= " $word";
80 if (!preg_match('#-(.+?)#', trim($word)))
86 $hilight = preg_replace('#[^0-9a-zA-Z_ ]#', '', $hilight);
87 $hilight = trim($hilight);
88 $hilight = preg_replace('#\s#', '+', $hilight);
90 $temp = trim($querybuild['text']);
92 if (MODE_ALL OR MODE_RAW)
94 $bool_flag = ' IN BOOLEAN MODE';
97 $querybuild['text'] = "AND\n\t\t\t(\n\t\t\t\tMATCH
(bug
.summary
) AGAINST ('$temp'$bool_flag)\n\t\t\t\tOR MATCH (comment.comment) AGAINST ('$temp'$bool_flag)\n\t\t\t)";
100 // -------------------------------------------------------------------
102 if ($bugsys->in['reporter'])
104 // force email or name?? make a distinction?
105 // more elegant way to do this? probably
106 $user = $db->query_first("SELECT
* FROM user WHERE email LIKE
'%" . str_replace('%
', '\%
', $bugsys->in['reporter
']) . "' OR displayname LIKE
'%" . str_replace('%
', '\%
', $bugsys->in['reporter
']) . "%'");
109 $querybuild['reporter'] = "AND bug
.userid
= $user[userid
] OR comment
.userid
= $user[userid
]";
113 // -------------------------------------------------------------------
114 // product/component/version stuff
115 if (is_array($bugsys->in['pcv']))
117 $querybuild['pcv'] = "AND bug
.productid
= $pcv[product
] AND bug
.componentid
= $pcv[component
] AND bug
.versionid
= $pcv[version
]";
120 // -------------------------------------------------------------------
121 // severity, priority, status, resolution, assignedto
124 if ($bugsys->in['severity'])
126 $querybuild['severity'] = "AND bug
.severity
= " . intval($bugsys->in['severity']);
130 if ($bugsys->in['priority'])
132 $querybuild['priority'] = "AND bug
.priority
= " . intval($bugsys->in['priority']);
136 if ($bugsys->in['status'])
138 $querybuild['status'] = "AND bug
.status
= " . intval($bugsys->in['status']);
142 if ($bugsys->in['resolution'])
144 $querybuild['resolution'] = "AND bug
.resolution
= " . intval($bugsys->in['resolution']);
148 if ($bugsys->in['assignedto'])
150 $querybuild['assignedto'] = "AND bug
.assignedto
= " . intval($bugsys->in['assignedto']);
153 // -------------------------------------------------------------------
155 if ($bugsys->in['date'])
157 // now - (seconds/day * number of days)
158 $dateline = time() - (intval($bugsys->in['date']) * 3600);
159 $querybuild['date'] = "AND bug
.dateline
>= $dateline";
162 // -------------------------------------------------------------------
164 if ($bugsys->in
['favourite'] AND $bugsys->userinfo
['userid'])
166 $favourites = $db->query("SELECT * FROM " . TABLE_PREFIX
. "favourite WHERE userid = " . $bugsys->userinfo
['userid']);
167 while ($favourite = $db->fetch_array($favourites))
169 $ids[] = $favourite['bugid'];
171 $querybuild['favourites'] = "AND bug.bugid IN (" . implode(', ', $ids) . ")";
174 // -------------------------------------------------------------------
176 $sortby = array('bugid', 'severity', 'priority', 'status', 'resolution', 'dateline');
177 $orderby = array('ASC', 'DESC');
178 $bugsys->in
['orderby'] = strtoupper($bugsys->in
['orderby']);
179 if (in_array($bugsys->in
['sortby'], $sortby) AND in_array($bugsys->in
['orderby'], $orderby))
181 $sortclause = "ORDER BY " . $bugsys->in
['sortby'] . ' ' . $bugsys->in
['orderby'];
183 else if ($bugsys->in
['sortby'] == 'relevance')
192 // -------------------------------------------------------------------
194 $fields_fetch = $bugsys->db
->query("
196 FROM " . TABLE_PREFIX
. "bugfield AS bugfield
197 LEFT JOIN " . TABLE_PREFIX
. "bugfieldpermission AS permission
198 ON (bugfield.fieldid = permission.fieldid)
199 WHERE permission.mask <> 0
200 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}
201 AND bugfield.cansearch = 1"
203 while ($field = $bugsys->db
->fetch_array($fields_fetch))
205 if (!empty($bugsys->in
['custom']["$field[fieldid]"]) OR ($field['type'] == 'select_single' AND isset($bugsys->in
['custom']["$field[fieldid]"])))
207 if ($field['type'] == 'input_checkbox')
209 $querybuild[] = "AND bugfieldvalue.field$field[fieldid] = " . (($bugsys->in
['custom']["$field[fieldid]"] == 1) ? 0 : 1);
211 else if ($field['type'] == 'input_text')
213 $querybuild[] = "AND bugfieldvalue.field$field[fieldid] LIKE '%" . $bugsys->in
['custom']["$field[fieldid]"] . "%'";
215 else if ($field['type'] == 'select_single' AND $bugsys->in
['custom']["$field[fieldid]"] != -1)
217 $temp = unserialize($field['selects']);
218 $querybuild[] = "AND bugfieldvalue.field$field[fieldid] = '" . trim($temp[ intval($bugsys->in
['custom']["$field[fieldid]"]) ]) . "'";
223 // -------------------------------------------------------------------
224 // have to search something
225 if (count($querybuild) < 1)
227 $message->error($lang->string('You have to enter some criteria to search for'));
230 // -------------------------------------------------------------------
233 SELECT bug.*, comment.commentid,
234 user1.displayname AS firstreport,
235 user2.displayname AS lastpost
236 FROM " . TABLE_PREFIX
. "bug AS bug
237 LEFT JOIN " . TABLE_PREFIX
. "comment AS comment
238 ON (bug.bugid = comment.bugid)
239 LEFT JOIN " . TABLE_PREFIX
. "user AS user1
240 ON (bug.userid = user1.userid)
241 LEFT JOIN " . TABLE_PREFIX
. "user AS user2
242 ON (bug.lastpostby = user2.userid)
243 LEFT JOIN " . TABLE_PREFIX
. "bugvaluefill AS bugfieldvalue
244 ON (bug.bugid = bugfieldvalue.bugid)
246 " . implode("\n\t\t", $querybuild) . ((!can_perform('canviewhidden')) ? "
248 AND !comment.hidden" : "") . "
252 $search = $db->query($query);
254 $numrows = $db->num_rows($search);
258 $message->error($lang->string('No search results were returned that matched your criteria.'));
261 while ($result = $db->fetch_array($search))
263 $ids[] = $result['bugid'];
264 $results[] = $result;
267 if ($bugsys->userinfo['userid'])
270 REPLACE INTO
" . TABLE_PREFIX . "search
271 (userid
, dateline
, query
, ids
, orderby
, hilight
)
273 (" . $bugsys->userinfo['userid'] . ",
274 " . TIMENOW . ", '" . $bugsys->escape($query) . "',
275 '" . implode(',', $ids) . "', '" . $bugsys->escape($sortclause) . "',
276 '" . $bugsys->escape($hilight) . "'
283 $_REQUEST['do'] = 'results';
286 // ###################################################################
288 if ($_REQUEST['do'] == 'search')
290 if ($bugsys->userinfo['userid'] AND !$bugsys->in['new'])
292 if ($cachedsearch = $db->query_first("SELECT
* FROM
" . TABLE_PREFIX . "search WHERE userid
= " . $bugsys->userinfo['userid']))
294 $_REQUEST['do'] = 'results';
308 $pcv_select = construct_pcv_select('radio', '--');
310 // -------------------------------------------------------------------
312 $fields = construct_custom_fields($bug, true, true);
314 $bugsys->debug(count($fields) % 2);
316 foreach ($fields AS $field)
318 $bugsys->debug("i
= $i");
326 eval('$customfields .= "' . $template->fetch('customfield_bit') . '";');
332 if ((count($fields) %
2) != 0)
334 $bugsys->debug('no modulo for you');
336 eval('$customfields .= "' . $template->fetch('customfield_bit') . '";');
339 // -------------------------------------------------------------------
341 $select['severity'] = construct_datastore_select('severity', 'severity', 'severityid', 0, true);
342 $select['priority'] = construct_datastore_select('priority', 'priority', 'priorityid', 0, true);
343 $select['status'] = construct_datastore_select('status', 'status', 'statusid', 0, true);
344 $select['resolution'] = construct_datastore_select('resolution', 'resolution', 'resolutionid', 0, true);
346 $select['dev'] = '<option value="0" selected="selected"></option>';
347 foreach ($bugsys->datastore
['assignto'] AS $dev)
349 $value = $dev['userid'];
350 $label = construct_user_display($dev, false);
351 eval('$select[dev] .= "' . $template->fetch('selectoption') . '";');
354 eval('$template->flush("' . $template->fetch('search') . '");');
358 // ###################################################################
360 if ($_REQUEST['do'] == 'results')
362 $show['cached'] = false;
363 if ($bugsys->userinfo
['userid'] AND !$justprocess)
365 $search = $cachedsearch;
366 if ($search['dateline'] < TIMENOW
- 900 OR $bugsys->in
['rerun'])
368 $search = $db->query($search['query']);
369 while ($bug = $db->fetch_array($search))
371 $ids[] = $bug['bugid'];
374 $db->query("UPDATE " . TABLE_PREFIX
. "search SET ids = '" . implode(',', $ids) . "', dateline = " . TIMENOW
. " WHERE userid = " . $bugsys->userinfo
['userid']);
378 $search = $db->query("
379 SELECT bug.*, user1.displayname AS firstreport,
380 user2.displayname AS lastpost
381 FROM " . TABLE_PREFIX
. "bug AS bug
382 LEFT JOIN " . TABLE_PREFIX
. "user AS user1
383 ON (bug.userid = user1.userid)
384 LEFT JOIN " . TABLE_PREFIX
. "user AS user2
385 ON (bug.lastpostby = user2.userid)
386 WHERE bug.bugid IN ($search[ids])
389 while ($bug = $db->fetch_array($search))
394 $show['cached'] = true;
395 $hilight = $search['hilight'];
398 foreach ($results AS $bug)
400 $bug['bgcolour'] = $bugsys->datastore
['status']["$bug[status]"]['color'];
401 $bug['product'] = $bugsys->datastore
['product']["$bug[productid]"]['title'];
402 $bug['version'] = $bugsys->datastore
['version']["$bug[versionid]"]['version'];
403 $bug['status'] = $bugsys->datastore
['status']["$bug[status]"]['status'];
404 $bug['resolution'] = $bugsys->datastore
['resolution']["$bug[resolution]"]['resolution'];
405 $bug['lastposttime'] = (($bug['hiddendisplay']) ? $bug['hiddenlastposttime'] : $bug['lastposttime']);
406 $bug['lastpost'] = (($bug['hiddendisplay']) ? $bug['hiddenlastpost'] : $bug['lastpost']);
407 $bug['lastposttime'] = $datef->format($bugsys->options
['dateformat'], $bug['lastposttime']);
408 $bug['urladd'] = "&hilight=$hilight";
409 eval('$bugs .= "' . $template->fetch('trackerhome_bits
') . '";');
412 eval('$template->flush("' . $template->fetch('search_results
') . '");');
415 /*=====================================================================*\
416 || ###################################################################
419 || ###################################################################
420 \*=====================================================================*/