ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
ilLikeForumSearch Class Reference
+ Inheritance diagram for ilLikeForumSearch:
+ Collaboration diagram for ilLikeForumSearch:

Public Member Functions

 ilForumSearch (&$qp_obj)
 Constructor @access public. More...
 
 __createPostAndCondition ()
 
 __createTopicAndCondition ()
 
- Public Member Functions inherited from ilForumSearch
 ilForumSearch (&$query_parser)
 Constructor @access public. More...
 
performSearch ()
 
 __createAndCondition ()
 
- 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 37 of file class.ilLikeForumSearch.php.

Member Function Documentation

◆ __createPostAndCondition()

ilLikeForumSearch::__createPostAndCondition ( )

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

51 {
52 global $ilDB;
53
54 /*
55 $concat = " CONCAT(";
56 $concat .= 'pos_message,pos_subject';
57 $concat .= ") ";
58 */
59 $concat = $ilDB->concat(
60 array(
61 array('pos_subject','text'),
62 array('pos_message','text')));
63
64 $and = " AND ( ";
65 $counter = 0;
66 foreach($this->query_parser->getQuotedWords() as $word)
67 {
68 if($counter++)
69 {
70 $and .= " OR";
71 }
72 #$and .= $concat;
73 #$and .= ("LIKE ('%".$word."%')");
74 $and .= $ilDB->like($concat,'clob','%'.$word.'%');
75 }
76 return $and.") ";
77 }
global $ilDB

References $ilDB.

◆ __createTopicAndCondition()

ilLikeForumSearch::__createTopicAndCondition ( )

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

80 {
81 global $ilDB;
82
83 $field = 'thr_subject ';
84 $and = " AND( ";
85
86 $counter = 0;
87 foreach($this->query_parser->getQuotedWords() as $word)
88 {
89 if($counter++)
90 {
91 $and .= " OR ";
92 }
93 #$and .= $field;
94 #$and .= ("LIKE ('%".$word."%')");
95 $and .= $ilDB->like($field,'text','%'.$word.'%');
96 }
97 return $and." ) ";
98 }

References $ilDB.

◆ ilForumSearch()

ilLikeForumSearch::ilForumSearch ( $qp_obj)

Constructor @access public.

Reimplemented from ilForumSearch.

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

45 {
46 parent::ilForumSearch($qp_obj);
47 }

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