search.php

   1 <?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 \*=====================================================================*/
  12
  13 $fetchtemplates = array(
  14         'search',
  15         'search_results',
  16         //'search_results_bit'
  17 );
  18
  19 require_once('./global.php');
  20
  21 if (!can_perform('cansearch'))
  22 {
  23         echo 'no permission';
  24         exit;
  25 }
  26
  27 define('MODE', intval($bugsys->in['mode']));
  28 define('MODE_ANY', ((MODE == 1) ? 1 : 0));
  29 define('MODE_ALL', ((MODE == 2) ? 1 : 0));
  30 define('MODE_RAW', ((MODE == 3) ? 1 : 0));
  31
  32 define('SEARCH_WORD_MIN', 3);
  33
  34 // ###################################################################
  35
  36 if (empty($_REQUEST['do']))
  37 {
  38         $_REQUEST['do'] = 'search';
  39 }
  40
  41 // ###################################################################
  42
  43 if ($_REQUEST['do'] == 'results')
  44 {
  45         // -------------------------------------------------------------------
  46         // parse out our product/component/version
  47         $pcv = parse_pcv_select($bugsys->in['pcv_select']);
  48
  49         // -------------------------------------------------------------------
  50         // handle keywords
  51         if ($bugsys->in['summary'])
  52         {
  53                 $keywords = preg_split('#\s+#', $bugsys->in['summary']);
  54
  55                 // #*# need to have some str to bool conversions
  56
  57                 foreach ($keywords AS $word)
  58                 {
  59                         if (strlen($word) < SEARCH_WORD_MIN)
  60                         {
  61                                 continue;
  62                         }
  63
  64                         if (MODE_ALL)
  65                         {
  66                                 $querybuild['text'] .= " +$word";
  67                         }
  68                         else
  69                         {
  70                                 $querybuild['text'] .= " $word";
  71                         }
  72
  73                         if (!preg_match('#-(.+?)#', trim($word)))
  74                         {
  75                                 $hilight .= " $word";
  76                         }
  77                 }
  78
  79                 $hilight = preg_replace('#[^0-9a-zA-Z_ ]#', '', $hilight);
  80                 $hilight = trim($hilight);
  81                 $hilight = preg_replace('#\s#', '+', $hilight);
  82
  83                 $temp = trim($querybuild['text']);
  84
  85                 if (MODE_ALL OR MODE_RAW)
  86                 {
  87                         $bool_flag = ' IN BOOLEAN MODE';
  88                 }
  89
  90                 $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)";
  91         }
  92
  93         // -------------------------------------------------------------------
  94         // reporter
  95         if ($bugsys->in['reporter'])
  96         {
  97                 // force email or name?? make a distinction?
  98                 // more elegant way to do this? probably
  99                 $user = $db->query_first("SELECT * FROM user WHERE email = '" . $bugsys->in['reporter'] . "' OR MATCH (displayname) AGAINST ('" . $bugsys->in['reporter'] . "')");
 100                 if ($user['userid'])
 101                 {
 102                         $querybuild['reporter'] = "AND bug.userid = $user[userid] OR comment.userid = $user[userid]";
 103                 }
 104         }
 105
 106         // -------------------------------------------------------------------
 107         // product/component/version stuff
 108         if (is_array($bugsys->in['pcv']))
 109         {
 110                 $querybuild['pcv'] = "AND bug.productid = $pcv[product] AND bug.componentid = $pcv[component] AND bug.versionid = $pcv[version]";
 111         }
 112
 113         // -------------------------------------------------------------------
 114         // severity, priority, status, resolution, assignedto
 115
 116         // severity
 117         if ($bugsys->in['severity'])
 118         {
 119                 $querybuild['severity'] = "AND bug.severity = " . intval($bugsys->in['severity']);
 120         }
 121
 122         // priority
 123         if ($bugsys->in['priority'])
 124         {
 125                 $querybuild['priority'] = "AND bug.priority = " . intval($bugsys->in['priority']);
 126         }
 127
 128         // status
 129         if ($bugsys->in['status'])
 130         {
 131                 $querybuild['status'] = "AND bug.status = " . intval($bugsys->in['status']);
 132         }
 133
 134         // resolution
 135         if ($bugsys->in['resolution'])
 136         {
 137                 $querybuild['resolution'] = "AND bug.resolution = " . intval($bugsys->in['resolution']);
 138         }
 139
 140         // assignment
 141         if ($bugsys->in['assignedto'])
 142         {
 143                 $querybuild['assignedto'] = "AND bug.assignedto = " . intval($bugsys->in['assignedto']);
 144         }
 145
 146         // -------------------------------------------------------------------
 147         // date
 148         if ($bugsys->in['date'])
 149         {
 150                 // now - (seconds/day * number of days)
 151                 $dateline = time() - (intval($bugsys->in['date']) * 3600);
 152                 $querybuild['date'] = "AND bug.dateline >= $dateline";
 153         }
 154
 155         // -------------------------------------------------------------------
 156         // sort by
 157         $sortby = array('bugid', 'severity', 'priority', 'status', 'resolution', 'dateline');
 158         $orderby = array('ASC', 'DESC');
 159         $bugsys->in['orderby'] = strtoupper($bugsys->in['orderby']);
 160         if (in_array($bugsys->in['sortby'], $sortby) AND in_array($bugsys->in['orderby'], $orderby))
 161         {
 162                 $sortclause = "ORDER BY " . $bugsys->in['sortby'] . ' ' . $bugsys->in['orderby'];
 163         }
 164         else if ($bugsys->in['sortby'] == 'relevance')
 165         {
 166                 $sortclause = '';
 167         }
 168         else
 169         {
 170                 echo 'bad sort';
 171                 exit;
 172         }
 173
 174         // -------------------------------------------------------------------
 175         // do the search
 176         $search = $db->query("
 177                 SELECT bug.*, comment.commentid,
 178                         user1.displayname AS firstreport,
 179                         user2.displayname AS lastpost
 180                 FROM " . TABLE_PREFIX . "bug AS bug
 181                 LEFT JOIN "  . TABLE_PREFIX . "comment AS comment
 182                         ON (bug.bugid = comment.bugid)
 183                 LEFT JOIN user AS user1
 184                         ON (bug.userid = user1.userid)
 185                 LEFT JOIN user AS user2
 186                         ON (bug.lastpostby = user2.userid)
 187                 WHERE bug.bugid <> 0
 188                         " . implode("\n\t\t\t", $querybuild) . "
 189                 $sortclause"
 190         );
 191
 192         $numrows = $db->num_rows($search);
 193
 194         if ($numrows < 1)
 195         {
 196                 echo 'no results found';
 197                 exit;
 198         }
 199
 200         while ($bug = $db->fetch_array($search))
 201         {
 202                 $bug['product'] = $bugsys->datastore['product']["$bug[productid]"]['title'];
 203                 $bug['version'] = $bugsys->datastore['version']["$bug[versionid]"]['version'];
 204                 $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
 205                 $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
 206                 $bug['lastpostinfo'] = datelike('standard', $bug['lastposttime']) . ' by ' . $bug['lastpost'];
 207                 $bug['urladd'] = "&amp;hilight=$hilight";
 208                 eval('$bugs .= "' . $template->fetch('trackerhome_bits') . '";');
 209         }
 210
 211         eval('$template->flush("' . $template->fetch('search_results') . '");');
 212
 213 //      print_r($querybuild);
 214 }
 215
 216 // ###################################################################
 217
 218 if ($_REQUEST['do'] == 'search')
 219 {
 220         $pcv_select = construct_pcv_select('radio', '--');
 221
 222         $blankselect = '<option value="0">- Choose -</option>';
 223
 224         $select['severity'] = $blankselect;
 225         foreach ($bugsys->datastore['severity'] AS $severity)
 226         {
 227                 $value = $severity['severityid'];
 228                 $label = $severity['severity'];
 229                 eval('$select[severity] .= "' . $template->fetch('selectoption') . '";');
 230         }
 231
 232         $select['priority'] = $blankselect;
 233         foreach ($bugsys->datastore['priority'] AS $priority)
 234         {
 235                 $value = $priority['priorityid'];
 236                 $label = $priority['priority'];
 237                 eval('$select[priority] .= "' . $template->fetch('selectoption') . '";');
 238         }
 239
 240         $select['status'] = $blankselect;
 241         foreach ($bugsys->datastore['status'] AS $status)
 242         {
 243                 $value = $status['statusid'];
 244                 $label = $status['status'];
 245                 eval('$select[status] .= "' . $template->fetch('selectoption') . '";');
 246         }
 247
 248         $select['resolution'] = $blankselect;
 249         foreach ($bugsys->datastore['resolution'] AS $resolution)
 250         {
 251                 $value = $resolution['resolutionid'];
 252                 $label = $resolution['resolution'];
 253                 eval('$select[resolution] .= "' . $template->fetch('selectoption') . '";');
 254         }
 255
 256         $select['dev'] = $blankselect;
 257         foreach ($bugsys->datastore['assignto'] AS $dev)
 258         {
 259                 $value = $dev['userid'];
 260                 $label = construct_user_display($dev, false);
 261                 eval('$select[dev] .= "' . $template->fetch('selectoption') . '";');
 262         }
 263
 264         eval('$template->flush("' . $template->fetch('search') . '");');
 265 }
 266
 267 /*=====================================================================*\
 268 || ###################################################################
 269 || # $HeadURL$
 270 || # $Id$
 271 || ###################################################################
 272 \*=====================================================================*/
 273 ?>