ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
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
35include_once 'Services/Search/classes/class.ilMediaPoolSearch.php';
36
38{
39
44 function ilLikeMediaPoolSearch(&$qp_obj)
45 {
46 parent::ilMediaPoolSearch($qp_obj);
47 }
48
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
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?>
ilLikeMediaPoolSearch(&$qp_obj)
Constructor @access public.
__createKeywordAndCondition()
Condition for mob keyword search.
global $ilDB