ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5
ilLikeUserMultiFieldSearch Class Reference
+ Inheritance diagram for ilLikeUserMultiFieldSearch:
+ Collaboration diagram for ilLikeUserMultiFieldSearch:

Public Member Functions

 __construct ($qp_obj)
 Constructor public. More...
 
 performSearch ()
 Perform search. More...
 
 setFields ($a_fields)
 
 __createWhereCondition ()
 
- Public Member Functions inherited from ilAbstractSearch
 ilAbstractSearch (&$qp_obj)
 Constructor public. More...
 
 setFields ($a_fields)
 Set fields to search. More...
 
 getFields ()
 Get fields to search. More...
 
 setFilter ($a_filter)
 set object type to search in More...
 
 setIdFilter ($a_id_filter)
 Set id filter Filters search by given object id. More...
 
 getIdFilter ()
 Get Id filter. More...
 
 appendToFilter ($a_type)
 Append object type to filter. More...
 
 getFilter ()
 get object type to search in More...
 
 __createLocateString ()
 build locate string in case of AND search More...
 
 __prepareFound (&$row)
 
performSearch ()
 

Additional Inherited Members

- Data Fields inherited from ilAbstractSearch
 $db = null
 
 $query_parser = null
 
 $search_result = null
 
 $object_types
 

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ilLikeUserMultiFieldSearch::__construct (   $qp_obj)

Constructor public.

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

25  {
26  parent::__construct($qp_obj);
27  }

Member Function Documentation

◆ __createWhereCondition()

ilLikeUserMultiFieldSearch::__createWhereCondition ( )

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

References $ilDB, and ilAbstractSearch\getFields().

Referenced by performSearch().

68  {
69  global $ilDB;
70 
71  $fields = $this->getFields();
72  $field = $fields[0];
73 
74  $and = " WHERE field_id = ".$ilDB->quote($field, "text")." AND ( ";
75  $counter = 0;
76  foreach($this->query_parser->getQuotedWords() as $word)
77  {
78  if($counter++)
79  {
80  $and .= " OR ";
81  }
82 
83  if(strpos($word,'^') === 0)
84  {
85  $and .= $ilDB->like("value", "text", substr($word,1)."%");
86  }
87  else
88  {
89  $and .= $ilDB->like("value", "text", "%".$word."%");
90  }
91  }
92  return $and.") ";
93  }
getFields()
Get fields to search.
global $ilDB
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ performSearch()

ilLikeUserMultiFieldSearch::performSearch ( )

Perform search.

Returns
type

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

References $query, $res, $row, ilAbstractSearch\$search_result, ilAbstractSearch\__createLocateString(), __createWhereCondition(), and DB_FETCHMODE_OBJECT.

34  {
35  $where = $this->__createWhereCondition();
36  $locate = $this->__createLocateString();
37 
38  $query = "SELECT usr_id ".
39  $locate.
40  "FROM usr_data_multi ".
41  $where;
42 
43  $res = $this->db->query($query);
44  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
45  {
46  $this->search_result->addEntry($row->usr_id,'usr',$this->__prepareFound($row));
47  }
48  return $this->search_result;
49  }
__createLocateString()
build locate string in case of AND search
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
+ Here is the call graph for this function:

◆ setFields()

ilLikeUserMultiFieldSearch::setFields (   $a_fields)
Parameters

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

58  {
59  foreach($a_fields as $field)
60  {
61  $fields[] = $field;
62  }
63  parent::setFields($fields ? $fields : array());
64  }

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