chamilo / chamilo-lms

     * @param array $skill_list

     * @return array

     */

    public function get_user_by_skills($skill_list)

    {

        $users = array();

        if (!empty($skill_list)) {

            $skill_list = array_map('intval', $skill_list);

            $skill_list = implode("', '", $skill_list);

            $sql = "SELECT user_id FROM {$this->table}

                    WHERE skill_id IN ('$skill_list') ";

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

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

        }

        return $users;

    }

    /**

     * Get the achieved skills for the user

     * @return int Current max ID + 1 (we start from 0)

     * @assert (0, '') === 1

     */

    public function get_max_order($field_id)

    {

        $field_id = intval($field_id);

        $sql = "SELECT MAX(option_order)

                FROM {$this->table}

                WHERE field_id = $field_id";

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

        $max = 1;

        if (Database::num_rows($res) > 0) {

            $row = Database::fetch_array($res);

            $max = $row[0] + 1;

        }

        return $max;

    }

    /**

     * Update the option using the given params