ilLikeUserMultiFieldSearch Class Reference

Inheritance diagram for ilLikeUserMultiFieldSearch:

Collaboration diagram for ilLikeUserMultiFieldSearch:

Public Member Functions
	__construct ($qp_obj)
	Constructor @access public. More...
	performSearch ()
	Perform search. More...
	setFields ($a_fields)
	__createWhereCondition ()
Public Member Functions inherited from ilAbstractSearch
	ilAbstractSearch (&$qp_obj)
	Constructor @access 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 @access public.

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

        {
                parent::__construct($qp_obj);
        }

Member Function Documentation

__createWhereCondition()

ilLikeUserMultiFieldSearch::__createWhereCondition

(

)

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

        {
                global $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.") ";
        }

References $ilDB, 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

(

)

Perform search.

Returns

type

Reimplemented from ilAbstractSearch.

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

        {
                $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(DB_FETCHMODE_OBJECT))
                {
                        $this->search_result->addEntry($row->usr_id,'usr',$this->__prepareFound($row));
                }
                return $this->search_result;
        }

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

Here is the call graph for this function:

setFields()

ilLikeUserMultiFieldSearch::setFields

(

$a_fields

)

Parameters

return

Reimplemented from ilAbstractSearch.

Definition at line 57 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