ILIAS  trunk Revision v11.0_alpha-1744-gb0451eebef4
All Data Structures Namespaces Files Functions Variables Enumerations Enumerator Modules Pages
ilLikeUserMultiFieldSearch Class Reference
+ Inheritance diagram for ilLikeUserMultiFieldSearch:
+ Collaboration diagram for ilLikeUserMultiFieldSearch:

Public Member Functions

 performSearch ()
 
 setFields (array $a_fields)
 
 __createWhereCondition ()
 
- 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.ilLikeUserMultiFieldSearch.php.

Member Function Documentation

◆ __createWhereCondition()

ilLikeUserMultiFieldSearch::__createWhereCondition ( )

Definition at line 60 of file class.ilLikeUserMultiFieldSearch.php.

References ilAbstractSearch\$fields, and ilAbstractSearch\getFields().

Referenced by performSearch().

60  : string
61  {
62  $fields = $this->getFields();
63  $field = $fields[0];
64 
65  $and = " WHERE field_id = " . $this->db->quote($field, "text") . " AND ( ";
66  $counter = 0;
67  foreach ($this->query_parser->getQuotedWords() as $word) {
68  if ($counter++) {
69  $and .= " OR ";
70  }
71 
72  if (strpos($word, '^') === 0) {
73  $and .= $this->db->like("value", "text", substr($word, 1) . "%");
74  } else {
75  $and .= $this->db->like("value", "text", "%" . $word . "%");
76  }
77  }
78  return $and . ") ";
79  }
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ performSearch()

ilLikeUserMultiFieldSearch::performSearch ( )

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

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

33  {
34  $where = $this->__createWhereCondition();
35  $locate = $this->__createLocateString();
36 
37  $query = "SELECT usr_id " .
38  $locate .
39  "FROM usr_data_multi " .
40  $where;
41 
42  $res = $this->db->query($query);
43  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
44  $this->search_result->addEntry($row->usr_id, 'usr', $this->__prepareFound($row));
45  }
46  return $this->search_result;
47  }
$res
Definition: ltiservices.php:66
ilSearchResult $search_result
+ Here is the call graph for this function:

◆ setFields()

ilLikeUserMultiFieldSearch::setFields ( array  $a_fields)

Definition at line 50 of file class.ilLikeUserMultiFieldSearch.php.

References ilAbstractSearch\$fields.

50  : void
51  {
52  $fields = [];
53  foreach ($a_fields as $field) {
54  $fields[] = $field;
55  }
56  parent::setFields($fields);
57  }

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