chamilo / chamilo-lms

    /**

     * Delete all results for this evaluation

     */

    public function delete_results()

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_RESULT);

        $sql = 'DELETE FROM '.$table.'

                WHERE evaluation_id = '.intval($this->id);

        Database::query($sql);

    }

    /**

     * Delete this evaluation and all underlying results.

     * Not delete this category from the database,when visible=3 is category eliminated

     * @param int $courseId

     */

    public function update_category_delete($courseId)

    {

        $tbl_grade_categories = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = 'UPDATE '.$tbl_grade_categories.' SET visible=3

                WHERE c_id ="'.intval($courseId).'"';

        Database::query($sql);

    }

     /**

     * Delete this category from the database

     * Delete this category from the database

     * @param int $courseId

     */

    public static function deleteCategoryFromCourse($courseId)

    {

        $table = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = 'DELETE FROM '.$table.' 

                WHERE c_id ="'.intval($courseId).'"';

        Database::query($sql);

    }

    /**

     * @param int $course_id

     * @return boolean|null

     * */

    public function lock($locked)

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = "UPDATE $table SET locked = '".intval($locked)."'

                WHERE id='".intval($this->id)."'";

        Database::query($sql);

    }

    /**

     * @param $locked

     * @param string $course_code

     * @return integer if exists, false else

     */

    public static function course_exists($course_code)

    {

        $sql = 'SELECT 1 FROM '.Database::get_main_table(TABLE_MAIN_COURSE).'

                WHERE code="' . Database::escape_string($course_code).'"';

        return Database::num_rows(Database::query($sql));

    }

    /**

     * Send an email to tutor after the auth-suscription of a student in your course

     * @param int $locked 1 or unlocked 0

     *

     * */

    public function lock($locked)

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = "UPDATE $table SET locked = '".intval($locked)."'

                WHERE id='".$this->id."'";

        Database::query($sql);

    }

    /**

     * Get current user ranking