class.ilRoleAutoComplete.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilRoleAutoComplete
{
        public static function getList($a_str)
        {
                global $ilDB;
                
                $ilDB->setLimit(20);
                $query = "SELECT o1.title role,o2.title container FROM object_data o1 ".
                        "JOIN rbac_fa fa ON o1.obj_id = rol_id ".
                        "JOIN tree t1 ON fa.parent =  t1.child ".
                        "JOIN object_reference obr ON ref_id = t1.parent ".
                        "JOIN object_data o2 ON obr.obj_id = o2.obj_id ".
                        "WHERE o1.type = 'role' ".
                        "AND assign = 'y' ".
                        "AND ".$ilDB->like('o1.title','text','%'.$a_str.'%')." ".
                        "AND fa.parent != 8 ".
                        "ORDER BY role,container";
                        
                $res = $ilDB->query($query);
                $counter = 0;
                $result = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $result[$counter] = new stdClass();
                        $result[$counter]->value = $row->role;
                        $result[$counter]->label = $row->role." (".$row->container.")";
                        ++$counter;
                }

                if($counter == 0)
                {
                        return self::getListByObject($a_str);
                }
                
                include_once './Services/JSON/classes/class.ilJsonUtil.php';
                return ilJsonUtil::encode($result);
        }
        
        public static function getListByObject($a_str)
        {
                global $rbacreview,$ilDB;
                
                include_once './Services/JSON/classes/class.ilJsonUtil.php';
                $result = array();
                
                if(strpos($a_str,'@') !== 0)
                {
                        return ilJsonUtil::encode($result);
                }
                
                $a_str = substr($a_str,1);
                
                $ilDB->setLimit(100);
                $query = "SELECT ref_id, title FROM object_data ode ".
                        "JOIN object_reference ore ON ode.obj_id = ore.obj_id ".
                        "WHERE ".$ilDB->like('title', 'text',$a_str.'%').' '.
                        'ORDER BY title';
                $res = $ilDB->query($query);
                $counter = 0;
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $rolf = $rbacreview->getRoleFolderIdOfObject($row->ref_id);
                        if($rolf)
                        {
                                foreach($rbacreview->getRolesOfRoleFolder($rolf,false) as $rol_id)
                                {
                                        $role = ilObject::_lookupTitle($rol_id);
                                        
                                        $result[$counter] = new stdClass();
                                        $result[$counter]->value = $role;
                                        $result[$counter]->label = $role." (".$row->title.")";
                                        ++$counter;
                                }
                        }
                }
                return ilJsonUtil::encode($result);
        }
}
?>