ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
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 Member Functions inherited from ilAbstractSearch
 getValidObjectTypes (ilObjectDefinition $object_definition)
 
- Protected Attributes inherited from ilAbstractSearch
ilDBInterface $db
 
ilQueryParser $query_parser
 
ilSearchResult $search_result
 
array $object_types = []
 

Detailed Description

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

Member Function Documentation

◆ __createAndCondition()

ilLikeMediaPoolSearch::__createAndCondition ( )

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

32 : string
33 {
34 $concat = $this->db->concat(
35 array(
36 array('title','text')
37 )
38 );
39
40
41 $and = " AND ( ";
42 $counter = 0;
43 foreach ($this->query_parser->getQuotedWords() as $word) {
44 if ($counter++) {
45 $and .= " OR";
46 }
47 #$and .= $concat;
48 #$and .= ("LIKE ('%".$word."%')");
49 #$and .= $ilDB->like($concat,'text','%'.$word.'%');
50 $and .= $this->db->like('title', 'text', '%' . $word . '%');
51 }
52 return $and . ") ";
53 }
$counter

References $counter.

◆ __createKeywordAndCondition()

ilLikeMediaPoolSearch::__createKeywordAndCondition ( )

Condition for mob keyword search.

Returns
string

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

59 : string
60 {
61 $concat = ' keyword ';
62
63 $and = " WHERE ";
64 $counter = 0;
65 foreach ($this->query_parser->getQuotedWords() as $word) {
66 if ($counter++) {
67 $and .= " OR ";
68 }
69 $and .= $this->db->like($concat, 'text', '%' . $word . '%');
70 }
71 return $and;
72 }

References $counter.


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