ILIAS  release_8 Revision v8.19
All Data Structures Namespaces Files Functions Variables Modules Pages
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: