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(ilDBConstants::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(ilDBConstants::FETCHMODE_OBJECT)) {
            foreach ($rbacreview->getRolesOfRoleFolder($row->ref_id, 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);
    }
}