ILIAS  release_8 Revision v8.24
ilLikeMediaPoolSearch Class Reference
+ Inheritance diagram for ilLikeMediaPoolSearch:
+ Collaboration diagram for ilLikeMediaPoolSearch:

Public Member Functions

 __createAndCondition ()
 
 __createKeywordAndCondition ()
 Condition for mob keyword search. More...
 
- Public Member Functions inherited from ilMediaPoolSearch
 performSearch ()
 
 performKeywordSearch ()
 
- Public Member Functions inherited from ilAbstractSearch
 __construct (ilQueryParser $qp_obj)
 
 setFields (array $a_fields)
 
 getFields ()
 
 setFilter (array $a_filter)
 
 setIdFilter (array $a_id_filter)
 
 getIdFilter ()
 
 appendToFilter (string $a_type)
 
 getFilter ()
 
 __createLocateString ()
 
 __prepareFound (object $row)
 
 performSearch ()
 

Additional Inherited Members

- Protected Attributes inherited from ilAbstractSearch
ilDBInterface $db
 
ilQueryParser $query_parser
 
ilSearchResult $search_result
 
array $object_types
 

Detailed Description

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

Member Function Documentation

◆ __createAndCondition()

ilLikeMediaPoolSearch::__createAndCondition ( )

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

39 : string
40 {
41 $concat = $this->db->concat(
42 array(
43 array('title','text')
44 )
45 );
46
47
48 $and = " AND ( ";
49 $counter = 0;
50 foreach ($this->query_parser->getQuotedWords() as $word) {
51 if ($counter++) {
52 $and .= " OR";
53 }
54 #$and .= $concat;
55 #$and .= ("LIKE ('%".$word."%')");
56 #$and .= $ilDB->like($concat,'text','%'.$word.'%');
57 $and .= $this->db->like('title', 'text', '%' . $word . '%');
58 }
59 return $and . ") ";
60 }

◆ __createKeywordAndCondition()

ilLikeMediaPoolSearch::__createKeywordAndCondition ( )

Condition for mob keyword search.

Returns
string

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

66 : string
67 {
68 $concat = ' keyword ';
69
70 $and = " WHERE ";
71 $counter = 0;
72 foreach ($this->query_parser->getQuotedWords() as $word) {
73 if ($counter++) {
74 $and .= " OR ";
75 }
76 $and .= $this->db->like($concat, 'text', '%' . $word . '%');
77 }
78 return $and;
79 }

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