ILIAS  release_7 Revision v7.30-3-g800a261c036
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 @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 39 of file class.ilLikeForumSearch.php.

40 {
41 global $DIC;
42
43 $ilDB = $DIC['ilDB'];
44
45 /*
46 $concat = " CONCAT(";
47 $concat .= 'pos_message,pos_subject';
48 $concat .= ") ";
49 */
50 $concat = $ilDB->concat(
51 array(
52 array('pos_subject','text'),
53 array('pos_message','text'))
54 );
55
56 $and = " AND ( ";
57 $counter = 0;
58 foreach ($this->query_parser->getQuotedWords() as $word) {
59 if ($counter++) {
60 $and .= " OR";
61 }
62 #$and .= $concat;
63 #$and .= ("LIKE ('%".$word."%')");
64 $and .= $ilDB->like($concat, 'clob', '%' . $word . '%');
65 }
66 return $and . ") ";
67 }
global $DIC
Definition: goto.php:24
global $ilDB

References $DIC, and $ilDB.

◆ __createTopicAndCondition()

ilLikeForumSearch::__createTopicAndCondition ( )

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

70 {
71 global $DIC;
72
73 $ilDB = $DIC['ilDB'];
74
75 $field = 'thr_subject ';
76 $and = " AND( ";
77
78 $counter = 0;
79 foreach ($this->query_parser->getQuotedWords() as $word) {
80 if ($counter++) {
81 $and .= " OR ";
82 }
83 #$and .= $field;
84 #$and .= ("LIKE ('%".$word."%')");
85 $and .= $ilDB->like($field, 'text', '%' . $word . '%');
86 }
87 return $and . " ) ";
88 }

References $DIC, and $ilDB.


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