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 Attributes inherited from ilAbstractSearch
ilDBInterface	$db
ilQueryParser	$query_parser
ilSearchResult	$search_result
array	$object_types

Detailed Description

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

Member Function Documentation

__createWhereCondition()

ilLikeUserMultiFieldSearch::__createWhereCondition

(

)

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

                                            : string
    {
        $fields = $this->getFields();
        $field = $fields[0];
 
        $and = "  WHERE field_id = " . $this->db->quote($field, "text") . " AND ( ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }
 
            if (strpos($word, '^') === 0) {
                $and .= $this->db->like("value", "text", substr($word, 1) . "%");
            } else {
                $and .= $this->db->like("value", "text", "%" . $word . "%");
            }
        }
        return $and . ") ";
    }

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

Referenced by performSearch().

Here is the call graph for this function:

Here is the caller graph for this function:

performSearch()

ilLikeUserMultiFieldSearch::performSearch

(

)

Reimplemented from ilAbstractSearch.

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

                                   : ilSearchResult
    {
        $where = $this->__createWhereCondition();
        $locate = $this->__createLocateString();
 
        $query = "SELECT usr_id  " .
            $locate .
            "FROM usr_data_multi " .
            $where;
 
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->search_result->addEntry($row->usr_id, 'usr', $this->__prepareFound($row));
        }
        return $this->search_result;
    }

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

Here is the call graph for this function:

setFields()

ilLikeUserMultiFieldSearch::setFields

(

array

$a_fields

)

Reimplemented from ilAbstractSearch.

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

                                              : void
    {
        $fields = [];
        foreach ($a_fields as $field) {
            $fields[] = $field;
        }
        parent::setFields($fields);
    }

References ilAbstractSearch\$fields.

---

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

• Services/Search/classes/Like/class.ilLikeUserMultiFieldSearch.php