ILIAS  Release_4_2_x_branch Revision 61807
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilLikeMediaPoolSearch.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.ilMediaPoolSearch.php';
36 
37 class ilLikeMediaPoolSearch extends ilMediaPoolSearch
38 {
39 
44  function ilLikeMediaPoolSearch(&$qp_obj)
45  {
46  parent::ilMediaPoolSearch($qp_obj);
47  }
48 
49  function __createAndCondition()
50  {
51  global $ilDB;
52 
53  /*
54  $concat = " CONCAT(";
55  $concat .= 'title,description';
56  $concat .= ") ";
57  */
58  $concat = $ilDB->concat(
59  array(
60  array('title','text')
61  ));
62 
63 
64  $and = " AND ( ";
65  $counter = 0;
66  foreach($this->query_parser->getQuotedWords() as $word)
67  {
68  if($counter++)
69  {
70  $and .= " OR";
71  }
72  #$and .= $concat;
73  #$and .= ("LIKE ('%".$word."%')");
74  #$and .= $ilDB->like($concat,'text','%'.$word.'%');
75  $and .= $ilDB->like('title','text','%'.$word.'%');
76  }
77  return $and.") ";
78  }
79 
84  public function __createKeywordAndCondition()
85  {
86  global $ilDB;
87 
88  $concat = ' keyword ';
89 
90  $and = " WHERE ";
91  $counter = 0;
92  foreach($this->query_parser->getQuotedWords() as $word)
93  {
94  if($counter++)
95  {
96  $and .= " OR ";
97  }
98  $and .= $ilDB->like($concat,'text','%'.$word.'%');
99  }
100  return $and;
101  }
102 }
103 ?>