ILIAS  Release_3_10_x_branch Revision 61812
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilLikeMetaDataSearch.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 
35 include_once 'Services/Search/classes/class.ilMetaDataSearch.php';
36 
38 {
39 
44  function ilLikeMetaDataSearch(&$qp_obj)
45  {
46  parent::ilMetaDataSearch($qp_obj);
47  }
48 
49  // Private
51  {
52  $concat = ' keyword ';
53  $where = " WHERE (";
54  $counter = 0;
55  foreach($this->query_parser->getQuotedWords() as $word)
56  {
57  if($counter++)
58  {
59  $where .= "OR";
60  }
61  $where .= $concat;
62  $where .= (" LIKE ('%".$word."%')");
63  }
64  return $where.') ';
65  }
66 
68  {
69  $concat = ' entity ';
70  $where = " WHERE (";
71  $counter = 0;
72  foreach($this->query_parser->getQuotedWords() as $word)
73  {
74  if($counter++)
75  {
76  $where .= "OR";
77  }
78  $where .= $concat;
79  $where .= (" LIKE ('%".$word."%')");
80  }
81  return $where.') ';
82  }
84  {
85  #$concat = ' CONCAT(title,coverage) '; // broken if coverage is null
86  // TODO: fix coverage search
87  $concat = ' title ';
88 
89  $where = " WHERE (";
90  $counter = 0;
91  foreach($this->query_parser->getQuotedWords() as $word)
92  {
93  if($counter++)
94  {
95  $where .= "OR";
96  }
97  $where .= $concat;
98  $where .= (" LIKE ('%".$word."%')");
99  }
100  return $where.' )';
101  }
102 
104  {
105  $concat = ' description ';
106  $where = " WHERE (";
107  $counter = 0;
108  foreach($this->query_parser->getQuotedWords() as $word)
109  {
110  if($counter++)
111  {
112  $where .= "OR";
113  }
114  $where .= $concat;
115  $where .= (" LIKE ('%".$word."%')");
116  }
117  return $where.') ';
118  }
119 }
120 ?>