5 * Copyright 2004 (c) Dominik Haas, GForge Team
12 require_once('common/search/SearchQuery.class.php');
14 class TasksSearchQuery extends SearchQuery {
24 * flag if non public items are returned
26 * @var boolean $showNonPublic
33 * @param string $words words we are searching for
34 * @param int $offset offset
35 * @param boolean $isExact if we want to search for all the words or if only one matching the query is sufficient
36 * @param int $groupId group id
37 * @param array $sections sections to search in
38 * @param boolean $showNonPublic flag if private sections are searched too
40 function TasksSearchQuery($words, $offset, $isExact, $groupId, $sections=SEARCH__ALL_SECTIONS, $showNonPublic=false) {
41 $this->groupId = $groupId;
42 $this->showNonPublic = $showNonPublic;
44 $this->SearchQuery($words, $offset, $isExact);
46 $this->setSections($sections);
50 * getQuery - get the sql query built to get the search results
52 * @return string sql query to execute
57 if(count($this->words)) {
58 $tsquery0 = "headline(project_task.summary, q) AS summary,";
59 $words = $this->getFormattedWords();
60 $tsquery = ", to_tsquery('$words') AS q, project_task_idx";
61 $tsmatch = "vectors @@ q";
63 $tsjoin = ' AND project_task.project_task_id = project_task_idx.project_task_id';
64 $orderBy = "ORDER BY project_group_list.project_name, rank(vectors, q) DESC, project_task.project_task_id";
65 $phraseOp = $this->getOperator();
67 $tsquery0 = "summary, ";
72 $orderBy = "ORDER BY project_group_list.project_name, project_task.project_task_id";
76 if(count($this->phrases)) {
77 $phraseCond .= $phraseOp.'('
78 . ' ('.$this->getMatchCond('summary', $this->phrases).')'
79 . ' OR ('.$this->getMatchCond('details', $this->phrases).'))';
81 $sql = 'SELECT project_task.project_task_id,project_task.percent_complete,'
83 . ' project_task.start_date,project_task.end_date,users.firstname||\' \'||users.lastname AS realname, project_group_list.project_name, project_group_list.group_project_id '
84 . ' FROM project_task, users, project_group_list '
86 . ' WHERE project_task.created_by = users.user_id'
88 . ' AND project_task.group_project_id = project_group_list.group_project_id '
89 . ' AND project_group_list.group_id ='.$this->groupId.' ';
90 if ($this->sections != SEARCH__ALL_SECTIONS) {
91 $sql .= 'AND project_group_list.group_project_id in ('.$this->sections.') ';
93 if (!$this->showNonPublic) {
94 $sql .= 'AND project_group_list.is_public = 1 ';
96 $sql .= "AND ($tsmatch $phraseCond) $orderBy";
98 $sql = 'SELECT project_task.project_task_id,project_task.summary,project_task.percent_complete,'
99 . ' project_task.start_date,project_task.end_date,users.firstname||\' \'||users.lastname AS realname, project_group_list.project_name, project_group_list.group_project_id '
100 . ' FROM project_task, users, project_group_list'
101 . ' WHERE project_task.created_by = users.user_id'
102 . ' AND project_task.group_project_id = project_group_list.group_project_id '
103 . ' AND project_group_list.group_id ='.$this->groupId.' ';
104 if ($this->sections != SEARCH__ALL_SECTIONS) {
105 $sql .= 'AND project_group_list.group_project_id in ('.$this->sections.') ';
107 if (!$this->showNonPublic) {
108 $sql .= 'AND project_group_list.is_public = 1 ';
110 $sql .= 'AND(('.$this->getIlikeCondition('summary', $this->words).')'
111 . ' OR ('.$this->getIlikeCondition('details', $this->words).'))'
112 . ' ORDER BY project_group_list.project_name, project_task.project_task_id';
118 * getSections - returns the list of available subprojects
120 * @param $groupId int group id
121 * @param $showNonPublic boolean if we should consider non public sections
123 function getSections($groupId, $showNonPublic=false) {
124 $sql = 'SELECT group_project_id, project_name FROM project_group_list WHERE group_id = '.$groupId.'';
125 if (!$showNonPublic) {
126 $sql .= ' AND is_public = 1';
128 $sql .= ' ORDER BY project_name';
131 $res = db_query($sql);
132 while($data = db_fetch_array($res)) {
133 $sections[$data['group_project_id']] = $data['project_name'];