<?php  //$Id: upgrade.php,v 1.1.2.2 2006/10/26 17:43:08 stronk7 Exp $

// This file keeps track of upgrades to 
// the autoattendmod module
//
// Sometimes, changes between versions involve
// alterations to database structures and other
// major things that may break installations.
//
// The upgrade function in this file will attempt
// to perform all the necessary actions to upgrade
// your older installtion to the current version.
//
// If there's something it cannot do itself, it
// will tell you what you need to do.
//
// The commands in here will all be database-neutral,
// using the functions defined in lib/ddllib.php

function xmldb_autoattendmod_upgrade($oldversion=0)
{

    global $CFG, $THEME, $DB;

    $result = true;
    $dbman = $DB->get_manager();

/// And upgrade begins here. For each one, you'll need one 
/// block of code similar to the next one. Please, delete 
/// this comment lines once this file start handling proper
/// upgrade code.

/// if ($result && $oldversion < YYYYMMDD00) { //New version in version.php
///     $result = result of "/lib/ddllib.php" function calls
/// }

    // 2014060500
    if ($oldversion < 2014060500) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('homeroom',  XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '1', 'introformat');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // 2014060800
    if ($oldversion < 2014060800) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('namepattern',  XMLDB_TYPE_CHAR, '16', null, XMLDB_NOTNULL, null, 'fullname', 'introformat');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // 2014061300
    if ($oldversion < 2014061300) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('feedback',  XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '1', 'homeroom');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // 2014120100
    if ($oldversion < 2014120100) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('emailenable',  XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'namepattern');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('allreports',  XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'emailenable');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // 2016010400
    if ($oldversion < 2016010400) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('emailkey', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'allreports');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('emailuser', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'emailkey');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // 2016011200
    if ($oldversion < 2016011200) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('backupblock', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0', 'feedback');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('dbversion', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '2', 'backupblock');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }


    ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    // Ver.3.0

    // autoattendmod
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod');
        //
        $field = new xmldb_field('backupblock');
        if ($dbman->field_exists($table, $field)) {
            $dbman->drop_field($table, $field);
        }
        //
        $field = new xmldb_field('idnumber', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '1', 'feedback');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('pagerawsize', XMLDB_TYPE_INTEGER, '3', null, XMLDB_NOTNULL, null, '15', 'idnumber');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('pagecolsize', XMLDB_TYPE_INTEGER, '3', null, XMLDB_NOTNULL, null, '15', 'pagerawsize');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        $field = new xmldb_field('ipresolvurl', XMLDB_TYPE_CHAR, '255', null, null, null, 'http://wq.apnic.net/apnic-bin/whois.pl?searchtext=%s', 'pagecolsize');
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
    }

    // autoattendmod_sessions
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod_sessions');
        $table->add_field('id',          XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
        $table->add_field('course',      XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('classid',     XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('creator',     XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('sessdate',    XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('starttime',   XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('endtime',     XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('latetime',    XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('takenby',     XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('timetaken',   XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('method',      XMLDB_TYPE_CHAR,    '1' ,  null, XMLDB_NOTNULL, null, 'S');
        $table->add_field('attendkey',   XMLDB_TYPE_CHAR,    '36',  null, null,          null, '');
        $table->add_field('denysameip',  XMLDB_TYPE_INTEGER, '2',   null, XMLDB_NOTNULL, null, '1');
        $table->add_field('allowip',     XMLDB_TYPE_CHAR,    '255', null, null,          null, null);
        $table->add_field('desctiption', XMLDB_TYPE_CHAR,    '255', null, null,          null, null);
        $table->add_field('state',       XMLDB_TYPE_CHAR,    '1' ,  null, XMLDB_NOTNULL, null, 'N');
        $table->add_field('timemodified',XMLDB_TYPE_INTEGER, '10',  null, XMLDB_NOTNULL, null, '0');
        //
        $table->add_key  ('primary',   XMLDB_KEY_PRIMARY,     array('id'));
        $table->add_index('course',    XMLDB_INDEX_NOTUNIQUE, array('course'));
        $table->add_index('classid',   XMLDB_INDEX_NOTUNIQUE, array('classid'));
        $table->add_index('sessdate',  XMLDB_INDEX_NOTUNIQUE, array('sessdate'));
        $table->add_index('starttime', XMLDB_INDEX_NOTUNIQUE, array('starttime'));
        //
        if (!$dbman->table_exists($table)) {
            $dbman->create_table($table);
        }
    }

    // autoattendmod_students
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod_students');
        $table->add_field('id',         XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
        $table->add_field('course',     XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('attsid',     XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('studentid',  XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('status',     XMLDB_TYPE_CHAR,    '1' , null, XMLDB_NOTNULL, null, 'Y');
        $table->add_field('called',     XMLDB_TYPE_CHAR,    '1' , null, XMLDB_NOTNULL, null, 'D');
        $table->add_field('calledby',   XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('calledtime', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('sentemail',  XMLDB_TYPE_INTEGER, '3',  null, XMLDB_NOTNULL, null, '0');
        $table->add_field('remarks',    XMLDB_TYPE_CHAR,    '50', null, null,          null, null);
        $table->add_field('ipaddress',  XMLDB_TYPE_CHAR,    '42', null, XMLDB_NOTNULL, null, null);
        //
        $table->add_key  ('primary',     XMLDB_KEY_PRIMARY,     array('id'));
        $table->add_index('course',      XMLDB_INDEX_NOTUNIQUE, array('course'));
        $table->add_index('attsid',      XMLDB_INDEX_NOTUNIQUE, array('attsid'));
        $table->add_index('studentid',   XMLDB_INDEX_NOTUNIQUE, array('studentid'));
        $table->add_index('attstudentid',XMLDB_INDEX_UNIQUE,    array('attsid, studentid'));
        //
        if (!$dbman->table_exists($table)) {
            $dbman->create_table($table);
        }
    }

    // autoattendmod_settings
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod_settings');
        $table->add_field('id',         XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
        $table->add_field('course',     XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('classid',    XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('status',     XMLDB_TYPE_CHAR,    '1' , null, XMLDB_NOTNULL, null, 'Y');
        $table->add_field('acronym',    XMLDB_TYPE_CHAR,    '10', null, null         , null, '');
        $table->add_field('title',      XMLDB_TYPE_CHAR,    '24', null, null         , null, '');
        $table->add_field('description',XMLDB_TYPE_CHAR,    '64', null, null         , null, '');
        $table->add_field('grade',      XMLDB_TYPE_INTEGER, '5' , null, XMLDB_NOTNULL, null, '0');
        //
        $table->add_key  ('primary', XMLDB_KEY_PRIMARY,     array('id'));
        $table->add_index('course',  XMLDB_INDEX_NOTUNIQUE, array('course'));
        //
        if (!$dbman->table_exists($table)) {
            $dbman->create_table($table);
            //
            $rec = new stdClass();
            $rec->id = 0;
            $rec->courseid = 0;
            $rec->status = 'P';
            $rec->grade  =  2;
            $DB->insert_record('autoattendmod_settings', $rec);
            $rec->status = 'L';
            $rec->grade  =  1;
            $DB->insert_record('autoattendmod_settings', $rec);
            $rec->status = 'E';
            $rec->grade  =  1;
            $DB->insert_record('autoattendmod_settings', $rec);
            $rec->status = 'X';
            $rec->grade  =  0;
            $DB->insert_record('autoattendmod_settings', $rec);
            $rec->status = 'Y';
            $rec->grade  =  0;
            $DB->insert_record('autoattendmod_settings', $rec);
        }
    }

    // autoattendmod_classes
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod_classes');
        $table->add_field('id',          XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
        $table->add_field('course',      XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('creator',     XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('name',        XMLDB_TYPE_CHAR,    '50', null, XMLDB_NOTNULL, null, null);
        $table->add_field('timemodified',XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        //
        $table->add_key  ('primary', XMLDB_KEY_PRIMARY,     array('id'));
        $table->add_index('course',  XMLDB_INDEX_NOTUNIQUE, array('course'));
        //
        if (!$dbman->table_exists($table)) {
            $dbman->create_table($table);
        }
    }

    // autoattendmod_classifies
    if ($oldversion < 2016012000) {
        $table = new xmldb_table('autoattendmod_classifies');
        $table->add_field('id',       XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
        $table->add_field('course',   XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('studentid',XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        $table->add_field('classid',  XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
        //
        $table->add_key  ('primary',     XMLDB_KEY_PRIMARY,     array('id'));
        $table->add_index('course',      XMLDB_INDEX_NOTUNIQUE, array('course'));
        $table->add_index('studentid',   XMLDB_INDEX_NOTUNIQUE, array('studentid'));
        $table->add_index('crsstudentid',XMLDB_INDEX_UNIQUE,    array('course', 'studentid'));
        //
        if (!$dbman->table_exists($table)) {
            $dbman->create_table($table);
        }
    }

    ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    //
    return true;
}