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

Public Member Functions

 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 17 of file class.ilMediaPoolSearch.php.

Member Function Documentation

◆ performKeywordSearch()

ilMediaPoolSearch::performKeywordSearch ( )

Definition at line 43 of file class.ilMediaPoolSearch.php.

44 {
45 $this->setFields(array('keyword'));
46
47 $and = $this->__createKeywordAndCondition();
48 $locate = $this->__createLocateString();
49
50
51 $query = "SELECT mep_id, child " .
52 $locate .
53 "FROM mep_item mi " .
54 "JOIN mep_tree ON mi.obj_id = child " .
55 "JOIN il_meta_keyword mk ON foreign_id = mk.obj_id " .
56 $and .
57 "AND obj_type = 'mob'";
58
59 $res = $this->db->query($query);
60 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
61 $this->search_result->addEntry(
62 (int) $row->mep_id,
63 'mep',
64 $this->__prepareFound($row),
65 (int) $row->child
66 );
67 }
69 }
setFields(array $a_fields)
ilSearchResult $search_result
$res
Definition: ltiservices.php:69
$query

References $query, $res, ilAbstractSearch\$search_result, ilAbstractSearch\__createLocateString(), ilDBConstants\FETCHMODE_OBJECT, and ilAbstractSearch\setFields().

+ Here is the call graph for this function:

◆ performSearch()

ilMediaPoolSearch::performSearch ( )

Reimplemented from ilAbstractSearch.

Definition at line 19 of file class.ilMediaPoolSearch.php.

20 {
21 $this->setFields(array('title'));
22
23 $and = $this->__createAndCondition();
24 $locate = $this->__createLocateString();
25
26 $query = "SELECT mep_id,obj_id " .
27 $locate .
28 "FROM mep_tree JOIN mep_item ON child = obj_id " .
29 $and;
30
31 $res = $this->db->query($query);
32 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
33 $this->search_result->addEntry(
34 (int) $row->mep_id,
35 'mep',
36 $this->__prepareFound($row),
37 (int) $row->obj_id
38 );
39 }
41 }

References $query, $res, ilAbstractSearch\$search_result, ilAbstractSearch\__createLocateString(), ilDBConstants\FETCHMODE_OBJECT, and ilAbstractSearch\setFields().

+ Here is the call graph for this function:

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