class.ilLikeUserMultiFieldSearch.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once './Services/Search/classes/class.ilAbstractSearch.php';
 
class ilLikeUserMultiFieldSearch extends ilAbstractSearch
{
 
        public function __construct($qp_obj)
        {
                parent::__construct($qp_obj);
        }
        
        public function performSearch()
        {
                $where = $this->__createWhereCondition();
                $locate = $this->__createLocateString();
 
                $query = "SELECT usr_id  ".
                        $locate.
                        "FROM usr_data_multi ".
                        $where;
                
                $res = $this->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->search_result->addEntry($row->usr_id,'usr',$this->__prepareFound($row));
                }
                return $this->search_result;
        }
        
        
        public function setFields($a_fields)
        {
                foreach($a_fields as $field)
                {
                        $fields[] = $field;
                }
                parent::setFields($fields ? $fields : array());
        }
        
 
        function __createWhereCondition()
        {
                global $ilDB;
                
                $fields = $this->getFields();
                $field = $fields[0];
 
                $and = "  WHERE field_id = ".$ilDB->quote($field, "text")." AND ( ";
                $counter = 0;
                foreach($this->query_parser->getQuotedWords() as $word)
                {
                        if($counter++)
                        {
                                $and .= " OR ";
                        }
 
                        if(strpos($word,'^') === 0)
                        {
                                $and .= $ilDB->like("value", "text", substr($word,1)."%");
                        }
                        else
                        {
                                $and .= $ilDB->like("value", "text", "%".$word."%");
                        }
                }
                return $and.") ";
        }
}
?>