GradebookUtils::create_default_course_gradebook()

Complexity

Conditions	9
Paths	37

Size

Total Lines	55
Code Lines	41

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function create_default_course_gradebook(
        $course_code = null,
        $gradebook_model_id = 0
    ) {
        if (api_is_allowed_to_edit(true, true)) {
            if (!isset($course_code) || empty($course_code)) {
                $course_code = api_get_course_id();
            }
            $session_id = api_get_session_id();
            $courseInfo = api_get_course_info($course_code);

            $t = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);
            $sql = "SELECT * FROM $t 
                    WHERE c_id = '".$courseInfo['real_id']."' ";
            if (!empty($session_id)) {
                $sql .= " AND session_id = ".(int) $session_id;
            } else {
                $sql .= " AND (session_id IS NULL OR session_id = 0) ";
            }
            $sql .= " ORDER BY id";
            $res = Database::query($sql);
            if (Database::num_rows($res) < 1) {
                //there is no unique category for this course+session combination,
                $cat = new Category();
                if (!empty($session_id)) {
                    $my_session_id = api_get_session_id();
                    $s_name = api_get_session_name($my_session_id);
                    $cat->set_name($course_code.' - '.get_lang('Session').' '.$s_name);
                    $cat->set_session_id($session_id);
                } else {
                    $cat->set_name($course_code);
                }
                $cat->set_course_code($course_code);
                $cat->set_description(null);
                $cat->set_user_id(api_get_user_id());
                $cat->set_parent_id(0);
                $default_weight_setting = api_get_setting('gradebook_default_weight');
                $default_weight = isset($default_weight_setting) && !empty($default_weight_setting) ? $default_weight_setting : 100;
                $cat->set_weight($default_weight);
                $cat->set_grade_model_id($gradebook_model_id);
                $cat->set_certificate_min_score(75);

                $cat->set_visible(0);
                $cat->add();
                $category_id = $cat->get_id();
                unset($cat);
            } else {
                $row = Database::fetch_array($res);
                $category_id = $row['id'];
            }

            return $category_id;
        }

        return false;
    }