ilLikeObjectSearch Class Reference

Inheritance diagram for ilLikeObjectSearch:

Collaboration diagram for ilLikeObjectSearch:

Public Member Functions
	__createWhereCondition ()
Public Member Functions inherited from ilObjectSearch
	__construct (&$qp_obj)
	Constructor @access public. More...
	performSearch ()
	__createInStatement ()
	setCreationDateFilterDate (ilDate $day)
	Set creation date filter. More...
	setCreationDateFilterOperator ($a_operator)
	getCreationDateFilterDate ()
	getCreationDateFilterOperator ()
Public Member Functions inherited from ilAbstractSearch
	__construct ($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 ilObjectSearch
const	CDATE_OPERATOR_BEFORE = 1
const	CDATE_OPERATOR_AFTER = 2
const	CDATE_OPERATOR_ON = 3
Data Fields inherited from ilAbstractSearch
	$db = null
	$query_parser = null
	$search_result = null
	$object_types

Detailed Description

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

Member Function Documentation

__createWhereCondition()

ilLikeObjectSearch::__createWhereCondition

(

)

Definition at line 39 of file class.ilLikeObjectSearch.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        /*
        $concat  = " CONCAT(";
        $concat .= 'title,description';
        $concat .= ") ";
        */
        
        $concat = $ilDB->concat(
            array(
                array('title','text'),
                array('description','text'))
        );
        
 
        $where = "WHERE (";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $where .= "OR";
            }
            
            $where .= $ilDB->like($concat, 'text', '%' . $word . '%');
            
            #$where .= $concat;
            #$where .= ("LIKE ('%".$word."%') ");
        }
        $where .= ') ';
        return $where;
    }

References $DIC, and $ilDB.

---

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

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