class.ilLikeUserOrgUnitSearch.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once './Services/Search/classes/class.ilAbstractSearch.php';
include_once './Modules/OrgUnit/classes/class.ilObjOrgUnitTree.php';
class ilLikeUserOrgUnitSearch extends ilAbstractSearch
{
        const ORG_ASSIGNMENTS_TABLE = 'orgu_user_assignments';
        
        private $org_tree = null;
        
        
        
        public function __construct($qp_obj)
        {
                parent::__construct($qp_obj);
                
                $this->org_tree = ilObjOrgUnitTree::_getInstance();
                $this->org_tree->buildTempTableWithUsrAssignements(self::ORG_ASSIGNMENTS_TABLE);
        }
        
        
        public function &performSearch()
        {
                $where = $this->__createWhereCondition();
                $locate = $this->__createLocateString();

                $query = 'SELECT user_id  '.
                        'FROM  '.self::ORG_ASSIGNMENTS_TABLE.' '.
                        $where;
                
                $GLOBALS['DIC']->logger()->src()->debug($query);
                
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->search_result->addEntry($row->user_id,'user',$this->__prepareFound($row));
                }
                
                return $this->search_result;
        }
        
        
        public function __createWhereCondition()
        {
                global $ilDB;
                
                $where = 'WHERE ';
                $counter = 0;
                foreach($this->query_parser->getQuotedWords() as $word)
                {
                        if($counter++)
                        {
                                $and .= " OR ";
                        }
                        $where .= ( 'ref_id = '.$ilDB->quote($word,'integer'));
                }
                return $where;
        }
}
?>