ilMStListCompetencesSkills Class Reference

Class ilMStListCompetencesSkills. More...

Collaboration diagram for ilMStListCompetencesSkills:

Public Member Functions
	__construct (Container $dic)
	ilMStListCompetencesSkills constructor. More...
	getData (array $options)

Protected Member Functions
	getAdditionalWhereStatement (array $filters)

Protected Attributes
Container	$dic

Detailed Description

Class ilMStListCompetencesSkills.

Author

Theodor Truffer tt@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 27 of file class.ilMStListCompetencesSkills.php.

Constructor & Destructor Documentation

__construct()

ilMStListCompetencesSkills::__construct

(

Container

$dic

)

ilMStListCompetencesSkills constructor.

Parameters

Container

$dic

Definition at line 35 of file class.ilMStListCompetencesSkills.php.

    {
        $this->dic = $dic;
    }

References $dic.

Member Function Documentation

getAdditionalWhereStatement()

ilMStListCompetencesSkills::getAdditionalWhereStatement ( array  $filters )

protected

Definition at line 113 of file class.ilMStListCompetencesSkills.php.

                                                                  : string
    {
        $wheres = [];
 
        if (!empty($filters['skill'])) {
            $wheres[] = "sktree.title LIKE '%" . $filters['skill'] . "%'";
        }
 
        if (!empty($filters['skill_level'])) {
            $wheres[] = "lvl.title LIKE '%" . $filters['skill_level'] . "%'";
        }
 
        if (!empty($filters['user'])) {
            $wheres[] = "(" . $this->dic->database()->like(
                "ud.login",
                "text",
                "%" . $filters['user'] . "%"
            ) . " " . "OR " . $this->dic->database()
                                                                            ->like(
                                                                                "ud.firstname",
                                                                                "text",
                                                                                "%" . $filters['user'] . "%"
                                                                            ) . " " . "OR " . $this->dic->database()
                                                                                                                                        ->like(
                                                                                                                                            "ud.lastname",
                                                                                                                                            "text",
                                                                                                                                            "%" . $filters['user'] . "%"
                                                                                                                                        ) . " " . "OR " . $this->dic->database()
                                                                                                                                                                                                    ->like(
                                                                                                                                                                                                        "ud.email",
                                                                                                                                                                                                        "text",
                                                                                                                                                                                                        "%" . $filters['user'] . "%"
                                                                                                                                                                                                    ) . ") ";
        }
 
        if (!empty($filters['org_unit'])) {
            $wheres[] = 'ud.usr_id IN (SELECT user_id FROM il_orgu_ua WHERE orgu_id = ' .
                $this->dic->database()->quote($filters['org_unit'], 'integer') . ')';
        }
 
        return empty($wheres) ? '' : ' AND ' . implode(' AND ', $wheres);
    }

Referenced by getData().

Here is the caller graph for this function:

getData()

ilMStListCompetencesSkills::getData ( array  $options )

final

Parameters

int[]

$options

Returns

ilMStListCompetencesSkill[]

Definition at line 44 of file class.ilMStListCompetencesSkills.php.

                                                 : ListFetcherResult
    {
        //Permission Filter
        $operation_access = ilOrgUnitOperation::OP_VIEW_COMPETENCES;
 
        $select = 'SELECT sktree.title as skill_title, skill_node_id, ulvl.trigger_obj_id, ulvl.user_id, login, firstname, lastname, email, lvl.title as skill_level';
 
        $query = $select .
            ' FROM skl_personal_skill sk ' .
            ' INNER JOIN usr_data ud ON ud.usr_id = sk.user_id ' .
            ' INNER JOIN skl_tree_node sktree ON sktree.obj_id = sk.skill_node_id ' .
            ' INNER JOIN (SELECT user_id, trigger_obj_id, skill_id, MAX(level_id) AS level_id ' .
            ' FROM skl_user_has_level WHERE self_eval = 0 GROUP BY skill_id, user_id) ulvl ON sk.skill_node_id = ulvl.skill_id AND sk.user_id = ulvl.user_id ' .
            ' INNER JOIN skl_level lvl ON lvl.id = ulvl.level_id ' .
            ' WHERE ';
 
        $users_per_position = ilMyStaffAccess::getInstance()->getUsersForUserPerPosition($this->dic->user()->getId());
 
        if (empty($users_per_position)) {
            return new ListFetcherResult([], 0);
        }
 
        $arr_query = [];
        foreach ($users_per_position as $position_id => $users) {
            $obj_ids = ilMyStaffAccess::getInstance()->getIdsForUserAndOperation(
                $this->dic->user()->getId(),
                $operation_access
            );
            $arr_query[] = $query . $this->dic->database()->in(
                'ulvl.trigger_obj_id',
                $obj_ids,
                false,
                'integer'
            ) . " AND " . $this->dic->database()->in('sk.user_id ', $users, false, 'integer')
                . $this->getAdditionalWhereStatement((array) $options['filters']);
        }
 
        $union_query = "SELECT * FROM ((" . implode(') UNION (', $arr_query) . ")) as a_table";
 
        $set = $this->dic->database()->query($union_query);
        $numRows = $this->dic->database()->numRows($set);
 
        if ($options['sort']) {
            $union_query .= " ORDER BY " . $options['sort']['field'] . " " . $options['sort']['direction'];
        }
 
        if (isset($options['limit']['start']) && isset($options['limit']['end'])) {
            $union_query .= " LIMIT " . $options['limit']['start'] . "," . $options['limit']['end'];
        }
 
        $set = $this->dic->database()->query($union_query);
 
        $skills = [];
        while ($rec = $this->dic->database()->fetchAssoc($set)) {
            $skills[] = new ilMStListCompetencesSkill(
                intval($rec['skill_node_id']),
                $rec['skill_title'],
                $rec['skill_level'],
                $rec['login'],
                $rec['lastname'],
                $rec['firstname'],
                $rec['email'],
                intval($rec['user_id'])
            );
        }
 
        return new ListFetcherResult($skills, $numRows);
    }

References $query, getAdditionalWhereStatement(), and ilOrgUnitOperation\OP_VIEW_COMPETENCES.

Here is the call graph for this function:

Field Documentation

$dic

Container ilMStListCompetencesSkills::$dic

protected

Definition at line 29 of file class.ilMStListCompetencesSkills.php.

Referenced by __construct().

---

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

• Services/MyStaff/classes/ListCompetences/Skills/class.ilMStListCompetencesSkills.php