ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
class.ilForumSearch.php
Go to the documentation of this file.
1<?php
2/*
3 +-----------------------------------------------------------------------------+
4 | ILIAS open source |
5 +-----------------------------------------------------------------------------+
6 | Copyright (c) 1998-2001 ILIAS open source, University of Cologne |
7 | |
8 | This program is free software; you can redistribute it and/or |
9 | modify it under the terms of the GNU General Public License |
10 | as published by the Free Software Foundation; either version 2 |
11 | of the License, or (at your option) any later version. |
12 | |
13 | This program is distributed in the hope that it will be useful, |
14 | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16 | GNU General Public License for more details. |
17 | |
18 | You should have received a copy of the GNU General Public License |
19 | along with this program; if not, write to the Free Software |
20 | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21 +-----------------------------------------------------------------------------+
22*/
23
35include_once 'Services/Search/classes/class.ilAbstractSearch.php';
36
38{
39 public function performSearch()
40 {
41 // Search in topic titles, posting title, posting
42
43 // First: search topics:
44 $this->setFields(array('thr_subject'));
45
46 $and = $this->__createTopicAndCondition();
47 $locate = $this->__createLocateString();
48
49 $query = "SELECT thr_pk,top_frm_fk frm_id " .
50 $locate .
51 "FROM frm_threads,frm_data " .
52 "WHERE top_pk = thr_top_fk " .
53 $and;
54
55 $res = $this->db->query($query);
56
57 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
58 #$thread_post = $row->thr_pk.'_0';
59 $thread_post = $row->thr_pk;
60 $this->search_result->addEntry($row->frm_id, 'frm', $this->__prepareFound($row), $thread_post);
61 }
62
63 // First: search post title, content:
64 $this->setFields(array('pos_subject','pos_message'));
65
66 $and = $this->__createPostAndCondition();
67 $locate = $this->__createLocateString();
68
69 $query = "SELECT top_frm_fk frm_id,pos_thr_fk,pos_pk " .
70 $locate .
71 "FROM frm_posts,frm_data " .
72 "WHERE pos_top_fk = top_pk " .
73 $and;
74
75 $res = $this->db->query($query);
76 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
77 #$thread_post = $row->pos_thr_fk.'_'.$row->pos_pk;
78 $thread_post = $row->pos_thr_fk;
79 $this->search_result->addEntry($row->frm_id, 'frm', $this->__prepareFound($row), $thread_post);
80 }
82 }
83
84 public function __createAndCondition()
85 {
86 echo "Overwrite me!";
87 }
88}
An exception for terminatinating execution or to throw for unit testing.
__createLocateString()
build locate string in case of AND search
setFields($a_fields)
Set fields to search.
$query
foreach($_POST as $key=> $value) $res