ilMyStaffAccess Class Reference

Class ilMyStaffAccess. More...

Inheritance diagram for ilMyStaffAccess:

Collaboration diagram for ilMyStaffAccess:

Public Member Functions
	hasCurrentUserAccessToMyStaff ()
	hasCurrentUserAccessToUser ($usr_id=0)
	hasCurrentUserAccessToLearningProgressInObject ($ref_id=0)
	hasCurrentUserAccessToCourseLearningProgressForAtLeastOneUser ()
	countOrgusOfUserWithAtLeastOneOperation ($user_id)
	getUsersForUserOperationAndContext ($user_id, $org_unit_operation_string=self::DEFAULT_ORG_UNIT_OPERATION, $context=self::DEFAULT_CONTEXT, $tmp_table_name_prefix=self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX)
	getUsersForUser ($user_id)
	buildTempTableCourseMemberships ($temporary_table_name_prefix=self::TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS, array $only_courses_of_user_ids=array())
	buildTempTableOrguMemberships ($temporary_table_name_prefix=self::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS, array $only_orgus_of_user_ids=array())
	dropTempTable ($temporary_table_name)
Public Member Functions inherited from ilObjectAccess
	_checkAccess ($a_cmd, $a_permission, $a_ref_id, $a_obj_id, $a_user_id="")
	Checks wether a user may invoke a command or not (this method is called by ilAccessHandler::checkAccess) More...
	_checkCondition ($a_obj_id, $a_operator, $a_value, $a_usr_id)
	check condition More...
	canBeDelivered (ilWACPath $ilWACPath)
	Parameters ilWACPath $ilWACPath Returns bool More...

Static Public Member Functions
static	getInstance ()
Static Public Member Functions inherited from ilObjectAccess
static	_getCommands ()
	get commands More...
static	_checkGoto ($a_target)
	check whether goto script will succeed More...
static	_isOffline ($a_obj_id)
	Type-specific implementation of general status, has to be overwritten if object type does not support centralized offline handling. More...
static	_preloadData ($a_obj_ids, $a_ref_ids)
	Preload data. More...

Data Fields
const	TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_SPEC_PERMISSIONS = 'tmp_obj_spec_perm'
const	TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_DEFAULT_PERMISSIONS = 'tmp_obj_def_perm'
const	TMP_DEFAULT_TABLE_NAME_PREFIX_IL_ORGU_DEFAULT_PERMISSIONS = 'tmp_orgu_def_perm'
const	TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS = 'tmp_crs_members'
const	TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS = 'tmp_orgu_members'
const	TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX = 'tmp_obj_user_matr'
const	DEFAULT_ORG_UNIT_OPERATION = ilOrgUnitOperation::OP_ACCESS_ENROLMENTS
const	DEFAULT_CONTEXT = 'crs'

Static Protected Attributes
static	$instance = null
static	$orgu_users_of_current_user_show_staff_permission

Private Member Functions
	__construct ()

Detailed Description

Class ilMyStaffAccess.

Author

: Martin Studer ms@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 8 of file class.ilMyStaffAccess.php.

Constructor & Destructor Documentation

__construct()

ilMyStaffAccess::__construct ( )

private

Definition at line 57 of file class.ilMyStaffAccess.php.

    {
    }

Member Function Documentation

buildTempTableCourseMemberships()

ilMyStaffAccess::buildTempTableCourseMemberships	(		$temporary_table_name_prefix = self::TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS,
		array	$only_courses_of_user_ids = array()
	)

Parameters

string	$temporary_table_name_prefix
array	$only_courses_of_user_ids

Returns

string

Definition at line 593 of file class.ilMyStaffAccess.php.

References $DIC, and dropTempTable().

Referenced by getUsersForUser().

    {
        global $DIC;

        $temporary_table_name = $temporary_table_name_prefix . "_user_id_" . $DIC->user()->getId();

        if ($temporary_table_name != self::TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS . "_user_id_" . $DIC->user()->getId()
            || count($only_courses_of_user_ids) > 0) {
            $this->dropTempTable($temporary_table_name);
        }

        $q = "CREATE TEMPORARY TABLE IF NOT EXISTS " . $temporary_table_name . " 
                (INDEX i1(ref_id), INDEX i2 (usr_id), INDEX i3 (position_id), INDEX i4 (orgu_id))
                AS (
                                        SELECT crs_members_crs_ref.ref_id, crs_members.usr_id, orgu_ua.position_id, orgu_ua.orgu_id
                                                FROM (
                                                        SELECT obj_id, usr_id FROM obj_members WHERE member = 1
                                                        AND " . $DIC->database()->in('obj_members.usr_id', $only_courses_of_user_ids, false, 'integer') . " 
                                                UNION
                                                        SELECT obj_id, usr_id FROM crs_waiting_list
                                                        WHERE " . $DIC->database()->in('crs_waiting_list.usr_id', $only_courses_of_user_ids, false, 'integer') . " 
                                                UNION
                                                        SELECT obj_id, usr_id FROM il_subscribers
                                                        WHERE " . $DIC->database()->in('il_subscribers.usr_id', $only_courses_of_user_ids, false, 'integer') . " 
                                                ) AS crs_members
                                                INNER JOIN object_reference AS crs_members_crs_ref on crs_members_crs_ref.obj_id = crs_members.obj_id
                                                INNER JOIN il_orgu_ua AS orgu_ua on orgu_ua.user_id = crs_members.usr_id
                          );";

        $DIC->database()->manipulate($q);

        return $temporary_table_name;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

buildTempTableOrguMemberships()

ilMyStaffAccess::buildTempTableOrguMemberships	(		$temporary_table_name_prefix = self::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS,
		array	$only_orgus_of_user_ids = array()
	)

Parameters

string	$temporary_table_name_prefix
array	$only_orgus_of_user_ids

Returns

string

Definition at line 634 of file class.ilMyStaffAccess.php.

References $DIC, and dropTempTable().

Referenced by getUsersForUser().

    {
        global $DIC;

        $temporary_table_name = $temporary_table_name_prefix . "_user_id_" . $DIC->user()->getId();

        if ($temporary_table_name != self::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS . "_user_id_" . $DIC->user()->getId()
            || count($only_orgus_of_user_ids) > 0) {
            $this->dropTempTable($temporary_table_name);
        }

        $q = "CREATE TEMPORARY TABLE IF NOT EXISTS " . $temporary_table_name . " 
                        (INDEX i1(orgu_id), INDEX i2 (tree_path), INDEX i3 (tree_child), INDEX i4 (tree_parent), INDEX i5 (tree_lft), INDEX i6 (tree_rgt), INDEX i7 (user_position_id), INDEX i8 (user_id))
                AS (
                                        SELECT  orgu_ua.orgu_id AS orgu_id,
                                                        tree_orgu.path AS tree_path,
                                                        tree_orgu.child AS tree_child,
                                                        tree_orgu.parent AS tree_parent,
                                                        tree_orgu.lft AS tree_lft,
                                                        tree_orgu.rgt AS tree_rgt,
                                                        orgu_ua.position_id AS user_position_id,
                                                        orgu_ua.user_id AS user_id
                                                        FROM
                                                        il_orgu_ua AS orgu_ua
                                                        INNER JOIN object_reference AS obj_ref on obj_ref.ref_id = orgu_ua.orgu_id AND obj_ref.deleted is null
                                                        LEFT JOIN tree AS tree_orgu ON tree_orgu.child = orgu_ua.orgu_id";

        if (count($only_orgus_of_user_ids) > 0) {
            $q .= " WHERE " . $DIC->database()->in('orgu_ua.user_id', $only_orgus_of_user_ids, false, 'integer') . " ";
        }

        $q .= ");";

        $DIC->database()->manipulate($q);

        return $temporary_table_name;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

countOrgusOfUserWithAtLeastOneOperation()

ilMyStaffAccess::countOrgusOfUserWithAtLeastOneOperation

(

$user_id

)

Parameters

int

$user_id

Returns

int

Definition at line 138 of file class.ilMyStaffAccess.php.

References $context, $DIC, and ilOrgUnitOperationQueries\findByOperationString().

    {
        global $DIC;

        $q = "SELECT COUNT(orgu_ua.orgu_id) AS 'cnt' FROM il_orgu_permissions AS perm
                                INNER JOIN il_orgu_ua AS orgu_ua ON orgu_ua.position_id = perm.position_id
                                INNER JOIN il_orgu_op_contexts AS contexts on contexts.id = perm.context_id AND contexts.context is not NULL
                                WHERE orgu_ua.user_id = " . $DIC->database()->quote($user_id, 'integer') . " AND perm.operations is not NULL AND perm.parent_id = -1";

        $set = $DIC->database()->query($q);
        $rec = $DIC->database()->fetchAssoc($set);

        return $rec['cnt'];
    }

Here is the call graph for this function:

dropTempTable()

ilMyStaffAccess::dropTempTable

(

$temporary_table_name

)

Parameters

string

$temporary_table_name

Returns

bool

Definition at line 678 of file class.ilMyStaffAccess.php.

References $DIC.

Referenced by buildTempTableCourseMemberships(), buildTempTableOrguMemberships(), and getUsersForUser().

    {
        global $DIC;

        $q = "DROP TABLE IF EXISTS " . $temporary_table_name;
        $DIC->database()->manipulate($q);

        return true;
    }

Here is the caller graph for this function:

getInstance()

static ilMyStaffAccess::getInstance ( )

static

Returns

self

Definition at line 31 of file class.ilMyStaffAccess.php.

References $DIC.

Referenced by ilMStListCoursesTableGUI\__construct(), ilMStListUsersTableGUI\__construct(), ilMStShowUserCoursesTableGUI\__construct(), ilMStListCoursesGUI\__construct(), ilMStListUsersGUI\__construct(), ilMStShowUserGUI\__construct(), ilMStListCourses\getData(), ilUserUtil\getPossibleStartingPoints(), ilStaffGlobalScreenProvider\getStaticSubItems(), ilMyStaffGUI\getUserLpStatusAsHtml(), and ilMyStaffGUI\getUserLpStatusAsText().

    {
        global $DIC;

        if (self::$instance === null) {
            self::$instance = new self();

            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_SPEC_PERMISSIONS . "_" . self::DEFAULT_ORG_UNIT_OPERATION . "_"
                . self::DEFAULT_CONTEXT);
            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_DEFAULT_PERMISSIONS . "_" . self::DEFAULT_ORG_UNIT_OPERATION
                . "_" . self::DEFAULT_CONTEXT);
            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_ORGU_DEFAULT_PERMISSIONS . "_" . self::DEFAULT_ORG_UNIT_OPERATION
                . "_" . self::DEFAULT_CONTEXT);
            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS . "_user_id_" . $DIC->user()->getId());
            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS . "_user_id_" . $DIC->user()->getId());
            self::$instance->dropTempTable(self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX . "_" . self::DEFAULT_ORG_UNIT_OPERATION . "_"
                . self::DEFAULT_CONTEXT);
        }

        return self::$instance;
    }

Here is the caller graph for this function:

getUsersForUser()

ilMyStaffAccess::getUsersForUser

(

$user_id

)

Parameters

int

$user_id

Returns

array

Definition at line 217 of file class.ilMyStaffAccess.php.

References $context, $DIC, $GLOBALS, buildTempTableCourseMemberships(), buildTempTableOrguMemberships(), dropTempTable(), ilOrgUnitOperationQueries\findByOperationString(), ilOrgUnitOperation\OP_ACCESS_ENROLMENTS, and user().

Referenced by hasCurrentUserAccessToUser().

    {
        global $DIC;

        $tmp_orgu_members = $this->buildTempTableOrguMemberships(self::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS, array());

        $q = "SELECT  " . $tmp_orgu_members . ".user_id AS usr_id
                        FROM 
                                " . $tmp_orgu_members . "
                                INNER JOIN il_orgu_ua AS orgu_ua_current_user on orgu_ua_current_user.user_id = " . $DIC->database()->quote($user_id, 'integer') . "
                                INNER JOIN il_orgu_authority AS auth ON auth.position_id = orgu_ua_current_user.position_id
                                WHERE
                                (
                                /* Identische OrgUnit wie Current User; Nicht Rekursiv; Fixe Position */
                                        (orgu_ua_current_user.orgu_id = " . $tmp_orgu_members . ".orgu_id AND auth.scope = 1
                                                AND auth.over = " . $tmp_orgu_members . ".user_position_id AND auth.over <> -1
                                        )
                                        OR
                                        /* Identische OrgUnit wie Current User; Nicht Rekursiv; Position egal */
                                        (orgu_ua_current_user.orgu_id = " . $tmp_orgu_members . ".orgu_id AND auth.scope = 1 AND auth.over = -1)
                                        OR
                                        /* Kinder OrgUnit wie Current User */
                                        (
                                                (
                                                        " . $tmp_orgu_members . ".orgu_id = orgu_ua_current_user.orgu_id OR
                                                        " . $tmp_orgu_members . ".tree_path LIKE CONCAT(\"%.\",orgu_ua_current_user.orgu_id ,\".%\")
                                                        OR
                                                        " . $tmp_orgu_members . ".tree_path LIKE  CONCAT(\"%.\",orgu_ua_current_user.orgu_id )
                                                )
                                                AND 
                                                (
                                                        (
                                                                (
                                                                        /* Gleiche Position */
                                                                        auth.over = " . $tmp_orgu_members . ".user_position_id AND auth.over <> -1
                                                                )
                                                                OR
                                                                (
                                                                        /* Position Egal */
                                                                        auth.over = -1
                                                                )
                                                        )
                                                        AND auth.scope = 2
                                                )
                                        )
                                )";

        $user_set = $DIC->database()->query($q);

        $arr_users = array();

        while ($rec = $DIC->database()->fetchAssoc($user_set)) {
            $arr_users[$rec['usr_id']] = $rec['usr_id'];
        }

        return $arr_users;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getUsersForUserOperationAndContext()

ilMyStaffAccess::getUsersForUserOperationAndContext	(		$user_id,
			$org_unit_operation_string = self::DEFAULT_ORG_UNIT_OPERATION,
			$context = self::DEFAULT_CONTEXT,
			$tmp_table_name_prefix = self::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX
	)

Parameters

int	$user_id
string	$org_unit_operation_string
string	$context
string	$tmp_table_name_prefix

Returns

array

Definition at line 192 of file class.ilMyStaffAccess.php.

References $context, and $DIC.

Referenced by hasCurrentUserAccessToCourseLearningProgressForAtLeastOneUser().

    {
        global $DIC;

        $tmp_table_name = $this->buildTempTableIlobjectsUserMatrixForUserOperationAndContext($user_id, $org_unit_operation_string, $context, $tmp_table_name_prefix);

        $q = 'SELECT usr_id FROM ' . $tmp_table_name;

        $user_set = $DIC->database()->query($q);

        $arr_users = array();

        while ($rec = $DIC->database()->fetchAssoc($user_set)) {
            $arr_users[$rec['usr_id']] = $rec['usr_id'];
        }

        return $arr_users;
    }

Here is the caller graph for this function:

hasCurrentUserAccessToCourseLearningProgressForAtLeastOneUser()

ilMyStaffAccess::hasCurrentUserAccessToCourseLearningProgressForAtLeastOneUser

(

)

Returns

bool

Definition at line 119 of file class.ilMyStaffAccess.php.

References $DIC, getUsersForUserOperationAndContext(), and ilOrgUnitOperation\OP_READ_LEARNING_PROGRESS.

    {
        global $DIC;

        $arr_usr_id = $this->getUsersForUserOperationAndContext($DIC->user()
            ->getId(), ilOrgUnitOperation::OP_READ_LEARNING_PROGRESS, self::DEFAULT_CONTEXT);
        if (count($arr_usr_id) > 0) {
            return true;
        }

        return false;
    }

Here is the call graph for this function:

hasCurrentUserAccessToLearningProgressInObject()

ilMyStaffAccess::hasCurrentUserAccessToLearningProgressInObject

(

$ref_id = 0

)

Parameters

int

$ref_id

Returns

bool

Definition at line 108 of file class.ilMyStaffAccess.php.

References $DIC, and ilOrgUnitOperation\OP_READ_LEARNING_PROGRESS.

    {
        global $DIC;

        return $DIC->access()->checkPositionAccess(ilOrgUnitOperation::OP_READ_LEARNING_PROGRESS, $ref_id);
    }

hasCurrentUserAccessToMyStaff()

ilMyStaffAccess::hasCurrentUserAccessToMyStaff

(

)

Returns

bool

Definition at line 65 of file class.ilMyStaffAccess.php.

References $DIC, ilOrgUnitOperationQueries\findByOperationString(), and ilOrgUnitOperation\OP_ACCESS_ENROLMENTS.

    {
        global $DIC;

        if (!$DIC->settings()->get("enable_my_staff")) {
            return false;
        }

        $operation = ilOrgUnitOperationQueries::findByOperationString(ilOrgUnitOperation::OP_ACCESS_ENROLMENTS, self::DEFAULT_CONTEXT);
        if (!$operation) {
            return false;
        }
        if ($this->countOrgusOfUserWithOperationAndContext($DIC->user()->getId(), ilOrgUnitOperation::OP_ACCESS_ENROLMENTS, self::DEFAULT_CONTEXT)
            > 0) {
            return true;
        }

        return false;
    }

Here is the call graph for this function:

hasCurrentUserAccessToUser()

ilMyStaffAccess::hasCurrentUserAccessToUser

(

$usr_id = 0

)

Parameters

int

$usr_id

Returns

bool

Definition at line 91 of file class.ilMyStaffAccess.php.

References $DIC, and getUsersForUser().

    {
        global $DIC;

        if (in_array($usr_id, $this->getUsersForUser($DIC->user()->getId()))) {
            return true;
        }

        return false;
    }

Here is the call graph for this function:

Field Documentation

$instance

ilMyStaffAccess::$instance = null

staticprotected

Definition at line 21 of file class.ilMyStaffAccess.php.

$orgu_users_of_current_user_show_staff_permission

ilMyStaffAccess::$orgu_users_of_current_user_show_staff_permission

staticprotected

Definition at line 25 of file class.ilMyStaffAccess.php.

DEFAULT_CONTEXT

const ilMyStaffAccess::DEFAULT_CONTEXT = 'crs'

Definition at line 17 of file class.ilMyStaffAccess.php.

Referenced by ilMStListCoursesGUI\getActions(), ilMStListCourses\getData(), ilMStListCoursesTableGUI\initFilter(), ilMStShowUserCoursesTableGUI\initFilter(), and ilMStShowUserCoursesTableGUI\parseData().

DEFAULT_ORG_UNIT_OPERATION

const ilMyStaffAccess::DEFAULT_ORG_UNIT_OPERATION = ilOrgUnitOperation::OP_ACCESS_ENROLMENTS

Definition at line 16 of file class.ilMyStaffAccess.php.

TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_CRS_MEMBERS = 'tmp_crs_members'

Definition at line 13 of file class.ilMyStaffAccess.php.

TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_DEFAULT_PERMISSIONS

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_DEFAULT_PERMISSIONS = 'tmp_obj_def_perm'

Definition at line 11 of file class.ilMyStaffAccess.php.

TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_SPEC_PERMISSIONS

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_SPEC_PERMISSIONS = 'tmp_obj_spec_perm'

Definition at line 10 of file class.ilMyStaffAccess.php.

TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_OBJ_USER_MATRIX = 'tmp_obj_user_matr'

Definition at line 15 of file class.ilMyStaffAccess.php.

Referenced by ilMStListCourses\getData().

TMP_DEFAULT_TABLE_NAME_PREFIX_IL_ORGU_DEFAULT_PERMISSIONS

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_IL_ORGU_DEFAULT_PERMISSIONS = 'tmp_orgu_def_perm'

Definition at line 12 of file class.ilMyStaffAccess.php.

TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS

const ilMyStaffAccess::TMP_DEFAULT_TABLE_NAME_PREFIX_ORGU_MEMBERS = 'tmp_orgu_members'

Definition at line 14 of file class.ilMyStaffAccess.php.

---

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

• Services/MyStaff/classes/class.ilMyStaffAccess.php