enrol/authorize/db/mysql.php

   1 <?php //$Id$
   2
   3 // THIS FILE IS DEPRECATED!  PLEASE DO NOT MAKE CHANGES TO IT!
   4 //
   5 // IT IS USED ONLY FOR UPGRADES FROM BEFORE MOODLE 1.7, ALL
   6 // LATER CHANGES SHOULD USE upgrade.php IN THIS DIRECTORY.
   7
   8 // MySQL commands for upgrading this enrolment module
   9
  10 function enrol_authorize_upgrade($oldversion=0) {
  11     global $CFG, $THEME, $db;
  12     require_once("$CFG->dirroot/enrol/authorize/const.php");
  13
  14     $result = true;
  15
  16     if ($oldversion < 2005071600) {
  17         // Be sure, only last 4 digit is inserted.
  18         table_column('enrol_authorize', 'cclastfour', 'cclastfour', 'integer', '4', 'unsigned', '0', 'not null');
  19         table_column('enrol_authorize', 'courseid', 'courseid', 'integer', '10', 'unsigned', '0', 'not null');
  20         table_column('enrol_authorize', 'userid', 'userid', 'integer', '10', 'unsigned', '0', 'not null');
  21         // Add some indexes for speed.
  22         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize` ADD INDEX courseid(courseid)", false);
  23         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize` ADD INDEX userid(userid)", false);
  24     }
  25
  26     if ($oldversion && $oldversion < 2005071602) {
  27         notify("If you are using the authorize.net enrolment plugin for credit card
  28                 handling, please ensure that you have turned loginhttps ON in Admin >> Variables >> Security.");
  29     }
  30
  31     if ($oldversion < 2005112100) {
  32         table_column('enrol_authorize', '', 'authcode', 'varchar', '6', '', '', '', 'avscode'); // CAPTURE_ONLY
  33         table_column('enrol_authorize', '', 'status', 'integer', '10', 'unsigned', '0', 'not null', 'transid');
  34         table_column('enrol_authorize', '', 'timecreated', 'integer', '10', 'unsigned', '0', 'not null', 'status');
  35         table_column('enrol_authorize', '', 'timeupdated', 'integer', '10', 'unsigned', '0', 'not null', 'timecreated');
  36         // status index for speed.
  37         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize` ADD INDEX status(status)");
  38         // defaults.
  39         $status = AN_STATUS_AUTH | AN_STATUS_CAPTURE;
  40         execute_sql("UPDATE {$CFG->prefix}enrol_authorize SET status='$status' WHERE transid<>'0'", false);
  41         $timenow = time();
  42         execute_sql("UPDATE {$CFG->prefix}enrol_authorize SET timecreated='$timenow', timeupdated='$timenow'", false);
  43     }
  44
  45     if ($oldversion < 2005121200) {
  46         // new fields for refund and sales reports.
  47         $defaultcurrency = empty($CFG->enrol_currency) ? 'USD' : $CFG->enrol_currency;
  48         table_column('enrol_authorize', '', 'amount', 'varchar', '10', '', '0', 'not null', 'timeupdated');
  49         table_column('enrol_authorize', '', 'currency', 'varchar', '3', '', $defaultcurrency, 'not null', 'amount');
  50         modify_database("","CREATE TABLE prefix_enrol_authorize_refunds (
  51           `id` int(10) unsigned NOT NULL auto_increment,
  52           `orderid` int(10) unsigned NOT NULL default 0,
  53           `refundtype` int(1) unsigned NOT NULL default 0,
  54           `amount` varchar(10) NOT NULL default '',
  55           `transid` int(10) unsigned NULL default 0,
  56           PRIMARY KEY (`id`),
  57           KEY `orderid` (`orderid`));");
  58         // defaults.
  59         if (($courses = get_records_select('course', '', '', 'id, cost, currency'))) {
  60             foreach ($courses as $course) {
  61                 execute_sql("UPDATE {$CFG->prefix}enrol_authorize
  62                              SET amount = '$course->cost', currency = '$course->currency'
  63                              WHERE courseid = '$course->id'", false);
  64             }
  65         }
  66     }
  67
  68     if ($oldversion < 2005122200) { // settletime
  69         table_column('enrol_authorize_refunds', 'refundtype', 'status', 'integer', '1', 'unsigned', '0', 'not null');
  70         table_column('enrol_authorize_refunds', '', 'settletime', 'integer', '10', 'unsigned', '0', 'not null', 'transid');
  71         table_column('enrol_authorize', 'timeupdated', 'settletime', 'integer', '10', 'unsigned', '0', 'not null');
  72         $status = AN_STATUS_AUTH | AN_STATUS_CAPTURE;
  73         if (($settlements = get_records_select('enrol_authorize', "status='$status'", '', 'id, settletime'))) {
  74             include_once("$CFG->dirroot/enrol/authorize/authorizenetlib.php");
  75             foreach ($settlements as $settlement) {
  76                 execute_sql("UPDATE {$CFG->prefix}enrol_authorize SET settletime = '" .
  77                 authorize_getsettletime($settlement->settletime) . "' WHERE id = '$settlement->id'", false);
  78             }
  79         }
  80     }
  81
  82     if ($oldversion < 2005122800) { // no need anymore some fields.
  83         execute_sql("ALTER TABLE {$CFG->prefix}enrol_authorize DROP ccexp", false);
  84         execute_sql("ALTER TABLE {$CFG->prefix}enrol_authorize DROP cvv", false);
  85         execute_sql("ALTER TABLE {$CFG->prefix}enrol_authorize DROP avscode", false);
  86         execute_sql("ALTER TABLE {$CFG->prefix}enrol_authorize DROP authcode", false);
  87     }
  88
  89     if ($oldversion < 2006010200) { // rename an_review_day
  90         if (isset($CFG->an_review_day)) {
  91             set_config('an_capture_day', $CFG->an_review_day);
  92             delete_records('config', 'name', 'an_review_day');
  93         }
  94     }
  95
  96     if ($oldversion < 2006020100) { // rename an_cutoff_hour and an_cutoff_min to an_cutoff
  97         if (isset($CFG->an_cutoff_hour) && isset($CFG->an_cutoff_min)) {
  98             $an_cutoff_hour = intval($CFG->an_cutoff_hour);
  99             $an_cutoff_min = intval($CFG->an_cutoff_min);
 100             $an_cutoff = ($an_cutoff_hour * 60) + $an_cutoff_min;
 101             if (set_config('an_cutoff', $an_cutoff)) {
 102                 delete_records('config', 'name', 'an_cutoff_hour');
 103                 delete_records('config', 'name', 'an_cutoff_min');
 104             }
 105         }
 106     }
 107
 108     if ($oldversion < 2006021500) { // transid is int
 109         table_column('enrol_authorize', 'transid', 'transid', 'integer', '10', 'unsigned', '0', 'not null');
 110     }
 111
 112     if ($oldversion < 2006021501) { // delete an_nextmail record from config_plugins table
 113         delete_records('config_plugins', 'name', 'an_nextmail');
 114     }
 115
 116     if ($oldversion < 2006050400) { // Create transid indexes for backup & restore speed.
 117         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize` ADD INDEX transid(transid)", false);
 118         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize_refunds` ADD INDEX transid(transid)", false);
 119     }
 120
 121     if ($oldversion < 2006060500) { // delete an_nextmail record from config_plugins table
 122         delete_records('config_plugins', 'name', 'an_nextmail'); // run twice.
 123     }
 124
 125     if ($oldversion < 2006081401) { // no need an_teachermanagepay in 1.7
 126         if (isset($CFG->an_teachermanagepay)) {
 127             delete_records('config', 'name', 'an_teachermanagepay');
 128         }
 129     }
 130
 131     if ($oldversion < 2006083100) {
 132         // enums are lower case
 133         if (isset($CFG->an_acceptmethods)) {
 134             set_config('an_acceptmethods', strtolower($CFG->an_acceptmethods));
 135         }
 136         // new ENUM field: paymentmethod(cc,echeck)
 137         execute_sql("ALTER TABLE `{$CFG->prefix}enrol_authorize` ADD paymentmethod enum('cc', 'echeck') NOT NULL default 'cc' AFTER `id`", true);
 138     }
 139
 140     //////  DO NOT ADD NEW THINGS HERE!!  USE upgrade.php and the lib/ddllib.php functions.
 141
 142     return $result;
 143 }
 144
 145 ?>