ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5
ilLikeMediaPoolSearch Class Reference
+ Inheritance diagram for ilLikeMediaPoolSearch:
+ Collaboration diagram for ilLikeMediaPoolSearch:

Public Member Functions

 ilLikeMediaPoolSearch (&$qp_obj)
 Constructor public. More...
 
 __createAndCondition ()
 
 __createKeywordAndCondition ()
 Condition for mob keyword search. More...
 
- Public Member Functions inherited from ilMediaPoolSearch
 ilMediaPoolSearch (&$query_parser)
 Constructor public. More...
 
performSearch ()
 
 performKeywordSearch ()
 
- Public Member Functions inherited from ilAbstractSearch
 ilAbstractSearch (&$qp_obj)
 Constructor public. More...
 
 setFields ($a_fields)
 Set fields to search. More...
 
 getFields ()
 Get fields to search. More...
 
 setFilter ($a_filter)
 set object type to search in More...
 
 setIdFilter ($a_id_filter)
 Set id filter Filters search by given object id. More...
 
 getIdFilter ()
 Get Id filter. More...
 
 appendToFilter ($a_type)
 Append object type to filter. More...
 
 getFilter ()
 get object type to search in More...
 
 __createLocateString ()
 build locate string in case of AND search More...
 
 __prepareFound (&$row)
 
performSearch ()
 

Additional Inherited Members

- Data Fields inherited from ilAbstractSearch
 $db = null
 
 $query_parser = null
 
 $search_result = null
 
 $object_types
 

Detailed Description

Definition at line 37 of file class.ilLikeMediaPoolSearch.php.

Member Function Documentation

◆ __createAndCondition()

ilLikeMediaPoolSearch::__createAndCondition ( )

Definition at line 49 of file class.ilLikeMediaPoolSearch.php.

References $ilDB.

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  }
global $ilDB

◆ __createKeywordAndCondition()

ilLikeMediaPoolSearch::__createKeywordAndCondition ( )

Condition for mob keyword search.

Returns

Definition at line 84 of file class.ilLikeMediaPoolSearch.php.

References $ilDB.

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  }
global $ilDB

◆ ilLikeMediaPoolSearch()

ilLikeMediaPoolSearch::ilLikeMediaPoolSearch ( $qp_obj)

Constructor public.

Definition at line 44 of file class.ilLikeMediaPoolSearch.php.

45  {
46  parent::ilMediaPoolSearch($qp_obj);
47  }

The documentation for this class was generated from the following file: