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
	__construct ($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.

    {
        parent::__construct($qp_obj);
    }

Member Function Documentation

__createWhereCondition()

ilLikeUserMultiFieldSearch::__createWhereCondition

(

)

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

References $DIC, $ilDB, and ilAbstractSearch\getFields().

Referenced by performSearch().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $fields = $this->getFields();
        $field = $fields[0];

        $and = "  WHERE field_id = " . $ilDB->quote($field, "text") . " AND ( ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR ";
            }

            if (strpos($word, '^') === 0) {
                $and .= $ilDB->like("value", "text", substr($word, 1) . "%");
            } else {
                $and .= $ilDB->like("value", "text", "%" . $word . "%");
            }
        }
        return $and . ") ";
    }

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 ilDBConstants\FETCHMODE_OBJECT.

    {
        $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;
    }

Here is the call graph for this function:

setFields()

ilLikeUserMultiFieldSearch::setFields

(

$a_fields

)

Parameters

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

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

---

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

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