ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5
ilLikeMediaCastSearch Class Reference

Class ilLikeMediaCastSearch. More...

+ Inheritance diagram for ilLikeMediaCastSearch:
+ Collaboration diagram for ilLikeMediaCastSearch:

Public Member Functions

 ilLikeMediaCastSearch (&$qp_obj)
 Constructor public. More...
 
 __createWhereCondition ()
 
- Public Member Functions inherited from ilMediaCastSearch
 ilMediaCastSearch (&$query_parser)
 Constructor public. More...
 
performSearch ()
 
- 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

Class ilLikeMediaCastSearch.

Performs Mysql Like search

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e
Version
$Id$

Definition at line 36 of file class.ilLikeMediaCastSearch.php.

Member Function Documentation

◆ __createWhereCondition()

ilLikeMediaCastSearch::__createWhereCondition ( )

Definition at line 49 of file class.ilLikeMediaCastSearch.php.

References $ilDB.

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

◆ ilLikeMediaCastSearch()

ilLikeMediaCastSearch::ilLikeMediaCastSearch ( $qp_obj)

Constructor public.

Definition at line 43 of file class.ilLikeMediaCastSearch.php.

44  {
45  parent::ilMediaCastSearch($qp_obj);
46  }

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