ILIAS  trunk Revision v11.0_alpha-1811-gd2d5443e411
All Data Structures Namespaces Files Functions Variables Enumerations Enumerator 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 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  }

◆ __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  }

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