ilLikeForumSearch Class Reference

Inheritance diagram for ilLikeForumSearch:

Collaboration diagram for ilLikeForumSearch:

Public Member Functions
	__createPostAndCondition ()
	__createTopicAndCondition ()
Public Member Functions inherited from ilForumSearch
&	performSearch ()
	__createAndCondition ()
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 37 of file class.ilLikeForumSearch.php.

Member Function Documentation

__createPostAndCondition()

ilLikeForumSearch::__createPostAndCondition

(

)

Definition at line 40 of file class.ilLikeForumSearch.php.

References $counter, $ilDB, and array.

        {
                global $ilDB;
                
                /*
                $concat  = " CONCAT(";
                $concat .= 'pos_message,pos_subject';
                $concat .= ") ";
                */
                $concat = $ilDB->concat(
                        array(
                                array('pos_subject','text'),
                                array('pos_message','text')));

                $and = "  AND ( ";
                $counter = 0;
                foreach($this->query_parser->getQuotedWords() as $word)
                {
                        if($counter++)
                        {
                                $and .= " OR";
                        }
                        #$and .= $concat;
                        #$and .= ("LIKE ('%".$word."%')");
                        $and .= $ilDB->like($concat,'clob','%'.$word.'%');
                }
                return $and.") ";
        }

__createTopicAndCondition()

ilLikeForumSearch::__createTopicAndCondition

(

)

Definition at line 69 of file class.ilLikeForumSearch.php.

References $counter, and $ilDB.

        {
                global $ilDB;

                $field = 'thr_subject ';
                $and = " AND( ";

                $counter = 0;
                foreach($this->query_parser->getQuotedWords() as $word)
                {
                        if($counter++)
                        {
                                $and .= " OR ";
                        }
                        #$and .= $field;
                        #$and .= ("LIKE ('%".$word."%')");
                        $and .= $ilDB->like($field,'text','%'.$word.'%');
                }
                return $and." ) ";
        }

---

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

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