ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilLikeShopObjectSearch.php
Go to the documentation of this file.
1<?php
2/*
3 +-----------------------------------------------------------------------------+
4 | ILIAS open source |
5 +-----------------------------------------------------------------------------+
6 | Copyright (c) 1998-2008 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
24include_once 'Services/Search/classes/class.ilShopObjectSearch.php';
25
36{
37 public function __construct($qp_obj)
38 {
39 parent::__construct($qp_obj);
40 }
41
42 public function __createWhereCondition()
43 {
44 global $ilDB;
45
46 $where = '';
47 $types = array();
48 $values = array();
49
50 $where .= 'WHERE (payment_objects.status = 1 OR payment_objects.status = 2) AND (';
51 $counter = 0;
52 foreach($this->query_parser->getQuotedWords() as $word)
53 {
54 if($counter++)
55 {
56 $where .= 'OR';
57 }
58 $concat = $ilDB->concat(
59 array(
60 array('title','text'),
61 array('description','text')));
62 $where .= $this->db->like($concat, 'text', '%%'.$word.'%%');
63
64 }
65 $where .= ') ';
66
67 if($this->getFilterShopTopicId() != 0)
68 {
69 $where .= ' AND pt_topic_fk = %s ';
70 $types[] = 'integer';
71 $values[] = $this->getFilterShopTopicId();
72 }
73
74 return array(
75 'query' => $where,
76 'types' => $types,
77 'values' => $values
78 );
79 }
80}
81?>
global $ilDB