ilLikeForumSearch Class Reference

Inheritance diagram for ilLikeForumSearch:

Collaboration diagram for ilLikeForumSearch:

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

Member Function Documentation

__createPostAndCondition()

ilLikeForumSearch::__createPostAndCondition

(

)

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

                                              : string
    {

        /*
        $concat  = " CONCAT(";
        $concat .= 'pos_message,pos_subject';
        $concat .= ") ";
        */
        $concat = $this->db->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 .= $this->db->like($concat, 'clob', '%' . $word . '%');
        }
        return $and . ") ";
    }

__createTopicAndCondition()

ilLikeForumSearch::__createTopicAndCondition

(

)

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

                                               : string
    {
        $field = 'thr_subject ';
        $and = " AND( ";

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

---

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

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