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

Public Member Functions

 ilLikeMediaPoolSearch (&$qp_obj)
 Constructor @access public. More...
 
 __createAndCondition ()
 
 __createKeywordAndCondition ()
 Condition for mob keyword search. More...
 
- Public Member Functions inherited from ilMediaPoolSearch
 ilMediaPoolSearch (&$query_parser)
 Constructor @access public. More...
 
performSearch ()
 
 performKeywordSearch ()
 
- Public Member Functions inherited from ilAbstractSearch
 ilAbstractSearch (&$qp_obj)
 Constructor @access 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.

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

References $ilDB.

◆ __createKeywordAndCondition()

ilLikeMediaPoolSearch::__createKeywordAndCondition ( )

Condition for mob keyword search.

Returns

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

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 }

References $ilDB.

◆ ilLikeMediaPoolSearch()

ilLikeMediaPoolSearch::ilLikeMediaPoolSearch ( $qp_obj)

Constructor @access 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: