ILIAS  release_5-0 Revision 5.0.0-1144-gc4397b1f870
All Data Structures Namespaces Files Functions Variables Modules Pages
ilLikeForumSearch Class Reference
+ Inheritance diagram for ilLikeForumSearch:
+ Collaboration diagram for ilLikeForumSearch:

Public Member Functions

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

References $ilDB.

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

◆ __createTopicAndCondition()

ilLikeForumSearch::__createTopicAndCondition ( )

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

References $ilDB.

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  }
global $ilDB

◆ ilForumSearch()

ilLikeForumSearch::ilForumSearch ( $qp_obj)

Constructor public.

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: