3 * FusionForge search engine
5 * Copyright 2004, Dominik Haas
6 * Copyright 2009, Roland Mas
7 * Copyright (C) 2012 Alain Peyrat - Alcatel-Lucent
8 * http://fusionforge.org
10 * This file is part of FusionForge. FusionForge is free software;
11 * you can redistribute it and/or modify it under the terms of the
12 * GNU General Public License as published by the Free Software
13 * Foundation; either version 2 of the Licence, or (at your option)
16 * FusionForge is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
21 * You should have received a copy of the GNU General Public License along
22 * with FusionForge; if not, write to the Free Software Foundation, Inc.,
23 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
26 require_once $gfcommon.'search/SearchQuery.class.php';
28 class TasksSearchQuery extends SearchQuery {
38 * flag if non public items are returned
40 * @var boolean $showNonPublic
47 * @param string $words words we are searching for
48 * @param int $offset offset
49 * @param boolean $isExact if we want to search for all the words or if only one matching the query is sufficient
50 * @param int $groupId group id
51 * @param array $sections sections to search in
52 * @param boolean $showNonPublic flag if private sections are searched too
54 function __construct($words, $offset, $isExact, $groupId, $sections=SEARCH__ALL_SECTIONS, $showNonPublic=false) {
55 $this->groupId = $groupId;
56 $this->showNonPublic = $showNonPublic;
58 parent::__construct($words, $offset, $isExact);
60 $this->setSections($sections);
64 * getQuery - get the query built to get the search results
66 * @return array query+params array
69 $qpa = db_construct_qpa () ;
74 if (forge_get_config('use_fti')) {
75 $words = $this->getFTIwords();
77 if (count($this->phrases)) {
78 $qpa = db_construct_qpa ($qpa,
79 'SELECT x.* FROM (SELECT project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.percent_complete, project_task.start_date, project_task.end_date, users.realname, project_group_list.project_name, project_task.summary||$1||project_task.details||$1||coalesce(ff_string_agg(project_messages.body), $1) as full_string_agg, project_task_idx.vectors FROM project_task LEFT OUTER JOIN project_messages USING (project_task_id), users, project_group_list, project_task_idx WHERE users.user_id = project_task.created_by AND project_task.group_project_id = project_group_list.group_project_id AND project_group_list.group_id = $2 ',
80 array ($this->field_separator, $this->groupId)) ;
82 if ($this->sections != SEARCH__ALL_SECTIONS) {
83 $qpa = db_construct_qpa ($qpa,
84 'AND project_group_list.group_project_id = ANY ($1) ',
85 array (db_int_array_to_any_clause ($this->sections))) ;
88 $qpa = db_construct_qpa ($qpa,
89 ' AND project_task.project_task_id = project_task_idx.project_task_id AND vectors @@ to_tsquery($1) GROUP BY project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.percent_complete, project_task.start_date, project_task.end_date, users.realname, project_group_list.project_name, project_task.details, vectors) AS x WHERE ',
91 $qpa = $this->addMatchCondition ($qpa, 'full_string_agg') ;
92 $qpa = db_construct_qpa ($qpa,
93 ' ORDER BY ts_rank(vectors, to_tsquery($1)) DESC',
96 $qpa = db_construct_qpa ($qpa,
97 'SELECT project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.percent_complete, project_task.start_date, project_task.end_date, users.realname, project_group_list.project_name, project_task_idx.vectors FROM project_task, users, project_group_list, project_task_idx WHERE users.user_id = project_task.created_by AND project_task.group_project_id = project_group_list.group_project_id AND project_group_list.group_id = $1 ',
98 array ($this->groupId)) ;
100 if ($this->sections != SEARCH__ALL_SECTIONS) {
101 $qpa = db_construct_qpa ($qpa,
102 'AND project_group_list.group_project_id = ANY ($1) ',
103 array (db_int_array_to_any_clause ($this->sections))) ;
106 $qpa = db_construct_qpa ($qpa,
107 'AND project_task.project_task_id = project_task_idx.project_task_id AND vectors @@ to_tsquery($1) ORDER BY ts_rank(vectors, to_tsquery($1)) DESC',
112 $qpa = db_construct_qpa ($qpa,
113 'SELECT x.* FROM (SELECT project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.percent_complete, project_task.start_date, project_task.end_date, users.realname, project_group_list.project_name, project_task.summary||$1||project_task.details||$1||coalesce(ff_string_agg(project_messages.body), $1) as full_string_agg FROM project_task LEFT OUTER JOIN project_messages USING (project_task_id), users, project_group_list WHERE users.user_id = project_task.created_by AND project_task.group_project_id = project_group_list.group_project_id AND project_group_list.group_id = $2 ',
114 array ($this->field_separator, $this->groupId)) ;
116 if ($this->sections != SEARCH__ALL_SECTIONS) {
117 $qpa = db_construct_qpa ($qpa,
118 'AND project_group_list.group_project_id = ANY ($1) ',
119 array (db_int_array_to_any_clause ($this->sections))) ;
122 $qpa = db_construct_qpa ($qpa,
123 'GROUP BY project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.percent_complete, project_task.start_date, project_task.end_date, users.realname, project_group_list.project_name, project_task.details) AS x WHERE ',
125 $qpa = $this->addIlikeCondition ($qpa, 'full_string_agg') ;
126 $qpa = db_construct_qpa ($qpa,
127 ' ORDER BY project_task_id') ;
134 * getSections - returns the list of available subprojects
136 * @param $groupId int group id
137 * @param $showNonPublic boolean if we should consider non public sections
139 static function getSections($groupId, $showNonPublic=false) {
140 $sql = 'SELECT group_project_id, project_name FROM project_group_list WHERE group_id=$1' ;
141 $sql .= ' ORDER BY project_name';
144 $res = db_query_params ($sql,
146 while($data = db_fetch_array($res)) {
147 if (forge_check_perm('pm',$data['group_project_id'],'read')) {
148 $sections[$data['group_project_id']] = $data['project_name'];
157 // c-file-style: "bsd"