ILIAS  release_4-4 Revision
ilAdvancedMDSearch Class Reference
+ Inheritance diagram for ilAdvancedMDSearch:
+ Collaboration diagram for ilAdvancedMDSearch:

Public Member Functions

 __construct ($query_parser)
 Constructor. More...
 
 setDefinition ($a_def)
 set Definition More...
 
 getDefinition ()
 get definition More...
 
 performSearch ()
 perform search More...
 
 setTimeRange ($start, $end)
 set time range More...
 
- 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 ()
 

Protected Attributes

 $definition
 

Additional Inherited Members

- Data Fields inherited from ilAbstractSearch
 $db = null
 
 $query_parser = null
 
 $search_result = null
 
 $object_types
 

Detailed Description

Author
Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om
Version
$Id$

Definition at line 35 of file class.ilAdvancedMDSearch.php.

Constructor & Destructor Documentation

◆ __construct()

ilAdvancedMDSearch::__construct (   $query_parser)

Constructor.

public

Parameters
objquery parser

Definition at line 46 of file class.ilAdvancedMDSearch.php.

References ilAbstractSearch\$query_parser.

47  {
48  parent::__construct($query_parser);
49  }

Member Function Documentation

◆ getDefinition()

ilAdvancedMDSearch::getDefinition ( )

get definition

public

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

References $definition.

Referenced by performSearch().

70  {
71  return $this->definition;
72  }
+ Here is the caller graph for this function:

◆ performSearch()

ilAdvancedMDSearch::performSearch ( )

perform search

public

Parameters

Definition at line 81 of file class.ilAdvancedMDSearch.php.

References $query, $res, $row, ilAbstractSearch\$search_result, ilAbstractSearch\__createLocateString(), DB_FETCHMODE_OBJECT, getDefinition(), ilAbstractSearch\getFilter(), ilAbstractSearch\setFields(), ilAdvancedMDFieldDefinition\TYPE_DATE, ilAdvancedMDFieldDefinition\TYPE_DATETIME, ilAdvancedMDFieldDefinition\TYPE_SELECT, and ilAdvancedMDFieldDefinition\TYPE_TEXT.

82  {
83  global $ilDB;
84 
85  $this->setFields(array('value'));
86 
87  $and = '';
88  if(count($this->getFilter()))
89  {
90  $and = "AND ".$ilDB->in('type',$this->getFilter(),false,'text');
91  }
92 
93 
94  switch($this->getDefinition()->getFieldType())
95  {
98  $query = "SELECT amv.obj_id,type ".
99  "FROM adv_md_values amv ".
100  "JOIN object_data od ON amv.obj_id = od.obj_id ".
101  "WHERE value >= ".$ilDB->quote($this->range_start ,'text')." ".
102  "AND value <= ".$ilDB->quote($this->range_end ,'text')." ".
103  "AND field_id = ".$this->db->quote($this->getDefinition()->getFieldId() ,'integer')." ".
104  $and;
105  break;
106 
109  $where = $this->__createWhereCondition();
110  $locate = $this->__createLocateString();
111 
112  $query = "SELECT amv.obj_id,type ".
113  $locate.
114  "FROM adv_md_values amv ".
115  "JOIN object_data od ON amv.obj_id = od.obj_id ".
116  $where.
117  "AND field_id = ".$this->db->quote($this->getDefinition()->getFieldId() ,'integer')." ".
118  $and;
119  break;
120 
121  }
122 
123  if($query)
124  {
125  $res = $this->db->query($query);
126  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
127  {
128  $this->search_result->addEntry($row->obj_id,$row->type,$this->__prepareFound($row));
129  }
130  }
131  return $this->search_result;
132  }
__createLocateString()
build locate string in case of AND search
setFields($a_fields)
Set fields to search.
getFilter()
get object type to search in
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
getDefinition()
get definition
+ Here is the call graph for this function:

◆ setDefinition()

ilAdvancedMDSearch::setDefinition (   $a_def)

set Definition

public

Parameters
objfield definition object

Definition at line 58 of file class.ilAdvancedMDSearch.php.

59  {
60  $this->definition = $a_def;
61  }

◆ setTimeRange()

ilAdvancedMDSearch::setTimeRange (   $start,
  $end 
)

set time range

public

Parameters
intunix start time
intunix end time

Definition at line 142 of file class.ilAdvancedMDSearch.php.

143  {
144  $this->range_start = $start;
145  $this->range_end = $end;
146  }

Field Documentation

◆ $definition

ilAdvancedMDSearch::$definition
protected

Definition at line 37 of file class.ilAdvancedMDSearch.php.

Referenced by getDefinition().


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