chamilo / chamilo-lms

     * @param int $gradebook_id

     * @return array|resource

     */

    public function get_skills_by_gradebook($gradebook_id)

    {

        $gradebook_id = intval($gradebook_id);

        $sql = "SELECT skill.id, skill.name FROM {$this->table_skill} skill

                INNER JOIN {$this->table_skill_rel_gradebook} skill_rel_gradebook

                ON skill.id = skill_rel_gradebook.skill_id

                WHERE skill_rel_gradebook.gradebook_id = $gradebook_id";

        $result = Database::query($sql);

        $result = Database::store_result($result, 'ASSOC');

        return $result;

    }

    /**

     * Displays the title + grid

     * @param int $skill_id

     * @return array|resource

     */

    public function get_gradebooks_by_skill($skill_id)

    {

        $skill_id = intval($skill_id);

        $sql = "SELECT g.* FROM {$this->table_gradebook} g

                INNER JOIN {$this->table_skill_rel_gradebook} sg

                    ON g.id = sg.gradebook_id

                 WHERE sg.skill_id = $skill_id";

        $result = Database::query($sql);

        $result = Database::store_result($result, 'ASSOC');

        return $result;

    }

    /**

     * Get one level childrens

     * @param int $skill_id

     * @return array

     */

    public function get_courses_by_skill($skill_id)

    {

        $skill_id = intval($skill_id);

        $sql = "SELECT c.title, c.code

                FROM {$this->table_gradebook} g

                INNER JOIN {$this->table_skill_rel_gradebook} sg

                ON g.id = sg.gradebook_id

                INNER JOIN {$this->table_course} c

                ON c.code = g.course_code

                WHERE sg.skill_id = $skill_id

                AND (g.session_id IS NULL OR g.session_id = 0)";

        $result   = Database::query($sql);

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Check if the user has the skill

     * @param int $skillId The skill id

     * @return array

     */

    public function getSessionsBySkill($skillId)

    {

        $skillId = intval($skillId);

        $sql = "SELECT s.id, s.name

                FROM {$this->table_gradebook} g

                INNER JOIN {$this->table_skill_rel_gradebook} sg ON g.id = sg.gradebook_id

                INNER JOIN {$this->sessionTable} s ON g.session_id = s.id

                WHERE sg.skill_id = $skillId

                AND g.session_id > 0";

        $result   = Database::query($sql);

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Check if the $fromUser can comment the $toUser skill issue