C:/xampp/htdocs/moodle/admin/oacleanup.php

Go to the documentation of this file.

<?php

if (!isset($CFG)) {

    require('../config.php');
    require_once($CFG->libdir.'/adminlib.php');

    admin_externalpage_setup('oacleanup');

    echo $OUTPUT->header();
    online_assignment_cleanup(true);
    echo $OUTPUT->footer();

}



function online_assignment_cleanup($output=false) {
    global $CFG, $DB, $OUTPUT;

    if ($output) {
        echo $OUTPUT->heading('Online Assignment Cleanup');
        echo '<center>';
    }


    $amv = $DB->get_field('modules', 'version', array('name'=>'assignment'));
    if ((int)$amv < 2005041400) {
        if ($output) {
            echo '</center>';
        }
        return;
    }


    $arecord = $DB->get_record('modules', array('name', 'assignment'));
    $aid = $arecord->id;


    list($ctxselect, $ctxjoin) = context_instance_preload_sql('c.id', CONTEXT_COURSE, 'ctx');
    $sql = "SELECT c.* $ctxselect FROM {course} c $ctxjoin";
    $courses = $DB->get_records_sql($sql);

    foreach ($courses as $course) {
        context_instance_preload($course);
        $context = get_context_instance(CONTEXT_COURSE, $course->id);

        if (empty($course->fullname)) {
            $fullname = get_string('course').': '.$course->id;
        } else {
            $fullname = format_string($course->fullname, true, array('context' => $context));
        }
        if ($output) echo $OUTPUT->heading($fullname);

        $sql = "SELECT *
                  FROM {course_sections}
                 WHERE course=? AND section>?
              ORDER BY section ASC";
        $params = array($course->id, $course->numsections);
        if (!($xsections = $DB->get_records_sql($sql, $params))) {
            if ($output) echo 'No extra sections<br />';
            continue;
        }

        foreach ($xsections as $xsection) {

            if ($output) echo 'Checking Section: '.$xsection->section.'<br />';

            if (!empty($xsection->sequence)) {
                $instances = explode(',', $xsection->sequence);

                foreach ($instances as $instance) {
                    $sql = "SELECT a.id
                              FROM  {course_modules} cm, {assignment} a
                             WHERE cm.id = ? AND cm.module = ? AND
                                   cm.instance = a.id AND a.assignmenttype = 'online'";
                    $params = array($instance, $aid);

                    if ($DB->record_exists_sql($sql, $params)) {

                        $newsection = $xsection->section;
                        if ($newsection > $course->numsections) {
                            if (!($zerosection = $DB->get_record('course_sections', array('course'=>$course->id, 'section'=>'0')))) {
                                continue;
                            }
                            $newsection = $zerosection->id;
                        }

                        if (!($section = $DB->get_record('course_sections', array('id'=>$newsection)))) {
                            if ($output) {
                                echo 'Serious error: Cannot retrieve section: '.$newsection.' for course: '. $fullname .'<br />';
                            }
                            continue;
                        }

                        if  (($sequence = explode(',', $section->sequence)) === false) {
                            $sequence = array();
                        }

                        array_push($sequence, $instance);

                        $section->sequence = implode(',', $sequence);

                        $DB->set_field('course_sections', 'sequence', $section->sequence, array('id'=>$section->id));


                        if (!($section = $DB->get_record('course_sections', array('id'=>$xsection->id)))) {
                            if ($output) echo 'Serious error: Cannot retrieve old section: '.$xsection->id.' for course: '.$fullname.'<br />';
                            continue;
                        }

                        if  (($sequence = explode(',', $section->sequence)) === false) {
                            $sequence = array();
                        }

                        $key = array_search($instance, $sequence);
                        unset($sequence[$key]);

                        $section->sequence = implode(',', $sequence);

                        $DB->set_field('course_sections', 'sequence', $section->sequence, array('id'=>$section->id));


                        if ($output) echo 'Online Assignment (instance '.$instance.') moved from section '.$section->id.': to section '.$newsection.'<br />';

                    }
                }
            }

            if (empty($xsection->summary) and empty($xsection->sequence)) {
                $DB->delete_records('course_sections', array('id'=>$xsection->id));
                if ($output) echo 'Deleting empty section '.$xsection->section.'<br />';
            }
        }
    }

    echo '</center>';
}