| 1 | efrain | 1 | <?php
 | 
        
           |  |  | 2 | // This file is part of Moodle - http://moodle.org/
 | 
        
           |  |  | 3 | //
 | 
        
           |  |  | 4 | // Moodle is free software: you can redistribute it and/or modify
 | 
        
           |  |  | 5 | // it under the terms of the GNU General Public License as published by
 | 
        
           |  |  | 6 | // the Free Software Foundation, either version 3 of the License, or
 | 
        
           |  |  | 7 | // (at your option) any later version.
 | 
        
           |  |  | 8 | //
 | 
        
           |  |  | 9 | // Moodle is distributed in the hope that it will be useful,
 | 
        
           |  |  | 10 | // but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
        
           |  |  | 11 | // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
        
           |  |  | 12 | // GNU General Public License for more details.
 | 
        
           |  |  | 13 | //
 | 
        
           |  |  | 14 | // You should have received a copy of the GNU General Public License
 | 
        
           |  |  | 15 | // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
 | 
        
           |  |  | 16 |   | 
        
           |  |  | 17 | /**
 | 
        
           |  |  | 18 |  * Database enrolment plugin settings and presets.
 | 
        
           |  |  | 19 |  *
 | 
        
           |  |  | 20 |  * @package    enrol_database
 | 
        
           |  |  | 21 |  * @copyright  2010 Petr Skoda {@link http://skodak.org}
 | 
        
           |  |  | 22 |  * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 | 
        
           |  |  | 23 |  */
 | 
        
           |  |  | 24 |   | 
        
           |  |  | 25 | defined('MOODLE_INTERNAL') || die();
 | 
        
           |  |  | 26 |   | 
        
           |  |  | 27 | if ($ADMIN->fulltree) {
 | 
        
           |  |  | 28 |   | 
        
           |  |  | 29 |     //--- general settings -----------------------------------------------------------------------------------
 | 
        
           |  |  | 30 |     $settings->add(new admin_setting_heading('enrol_database_settings', '', get_string('pluginname_desc', 'enrol_database')));
 | 
        
           |  |  | 31 |   | 
        
           |  |  | 32 |     $settings->add(new admin_setting_heading('enrol_database_exdbheader', get_string('settingsheaderdb', 'enrol_database'), ''));
 | 
        
           |  |  | 33 |   | 
        
           |  |  | 34 |     $options = array('', "access", "ado_access", "ado", "ado_mssql", "borland_ibase", "csv", "db2", "fbsql", "firebird", "ibase", "informix72", "informix", "mssql", "mssql_n", "mssqlnative", "mysql", "mysqli", "mysqlt", "oci805", "oci8", "oci8po", "odbc", "odbc_mssql", "odbc_oracle", "oracle", "pdo", "postgres64", "postgres7", "postgres", "proxy", "sqlanywhere", "sybase", "vfp");
 | 
        
           |  |  | 35 |     $options = array_combine($options, $options);
 | 
        
           |  |  | 36 |     $settings->add(new admin_setting_configselect('enrol_database/dbtype', get_string('dbtype', 'enrol_database'), get_string('dbtype_desc', 'enrol_database'), '', $options));
 | 
        
           |  |  | 37 |   | 
        
           |  |  | 38 |     $settings->add(new admin_setting_configtext('enrol_database/dbhost', get_string('dbhost', 'enrol_database'), get_string('dbhost_desc', 'enrol_database'), 'localhost'));
 | 
        
           |  |  | 39 |   | 
        
           |  |  | 40 |     $settings->add(new admin_setting_configtext('enrol_database/dbuser', get_string('dbuser', 'enrol_database'), '', ''));
 | 
        
           |  |  | 41 |   | 
        
           |  |  | 42 |     $settings->add(new admin_setting_configpasswordunmask('enrol_database/dbpass', get_string('dbpass', 'enrol_database'), '', ''));
 | 
        
           |  |  | 43 |   | 
        
           |  |  | 44 |     $settings->add(new admin_setting_configtext('enrol_database/dbname', get_string('dbname', 'enrol_database'), get_string('dbname_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 45 |   | 
        
           |  |  | 46 |     $settings->add(new admin_setting_configtext('enrol_database/dbencoding', get_string('dbencoding', 'enrol_database'), '', 'utf-8'));
 | 
        
           |  |  | 47 |   | 
        
           |  |  | 48 |     $settings->add(new admin_setting_configtext('enrol_database/dbsetupsql', get_string('dbsetupsql', 'enrol_database'), get_string('dbsetupsql_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 49 |   | 
        
           |  |  | 50 |     $settings->add(new admin_setting_configcheckbox('enrol_database/dbsybasequoting', get_string('dbsybasequoting', 'enrol_database'), get_string('dbsybasequoting_desc', 'enrol_database'), 0));
 | 
        
           |  |  | 51 |   | 
        
           |  |  | 52 |     $settings->add(new admin_setting_configcheckbox('enrol_database/debugdb', get_string('debugdb', 'enrol_database'), get_string('debugdb_desc', 'enrol_database'), 0));
 | 
        
           |  |  | 53 |   | 
        
           |  |  | 54 |   | 
        
           |  |  | 55 |   | 
        
           |  |  | 56 |     $settings->add(new admin_setting_heading('enrol_database_localheader', get_string('settingsheaderlocal', 'enrol_database'), ''));
 | 
        
           |  |  | 57 |   | 
        
           |  |  | 58 |     $options = array('id'=>'id', 'idnumber'=>'idnumber', 'shortname'=>'shortname');
 | 
        
           |  |  | 59 |     $settings->add(new admin_setting_configselect('enrol_database/localcoursefield', get_string('localcoursefield', 'enrol_database'), '', 'idnumber', $options));
 | 
        
           |  |  | 60 |   | 
        
           |  |  | 61 |     $options = array('id'=>'id', 'idnumber'=>'idnumber', 'email'=>'email', 'username'=>'username'); // only local users if username selected, no mnet users!
 | 
        
           |  |  | 62 |     $settings->add(new admin_setting_configselect('enrol_database/localuserfield', get_string('localuserfield', 'enrol_database'), '', 'idnumber', $options));
 | 
        
           |  |  | 63 |   | 
        
           |  |  | 64 |     $options = array('id'=>'id', 'shortname'=>'shortname');
 | 
        
           |  |  | 65 |     $settings->add(new admin_setting_configselect('enrol_database/localrolefield', get_string('localrolefield', 'enrol_database'), '', 'shortname', $options));
 | 
        
           |  |  | 66 |   | 
        
           |  |  | 67 |     $options = array('id'=>'id', 'idnumber'=>'idnumber');
 | 
        
           |  |  | 68 |     $settings->add(new admin_setting_configselect('enrol_database/localcategoryfield', get_string('localcategoryfield', 'enrol_database'), '', 'id', $options));
 | 
        
           |  |  | 69 |   | 
        
           |  |  | 70 |   | 
        
           |  |  | 71 |     $settings->add(new admin_setting_heading('enrol_database_remoteheader', get_string('settingsheaderremote', 'enrol_database'), ''));
 | 
        
           |  |  | 72 |   | 
        
           |  |  | 73 |     $settings->add(new admin_setting_configtext('enrol_database/remoteenroltable', get_string('remoteenroltable', 'enrol_database'), get_string('remoteenroltable_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 74 |   | 
        
           |  |  | 75 |     $settings->add(new admin_setting_configtext('enrol_database/remotecoursefield', get_string('remotecoursefield', 'enrol_database'), get_string('remotecoursefield_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 76 |   | 
        
           |  |  | 77 |     $settings->add(new admin_setting_configtext('enrol_database/remoteuserfield', get_string('remoteuserfield', 'enrol_database'), get_string('remoteuserfield_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 78 |   | 
        
           |  |  | 79 |     $settings->add(new admin_setting_configtext('enrol_database/remoterolefield', get_string('remoterolefield', 'enrol_database'), get_string('remoterolefield_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 80 |   | 
        
           |  |  | 81 |     $otheruserfieldlabel = get_string('remoteotheruserfield', 'enrol_database');
 | 
        
           |  |  | 82 |     $otheruserfielddesc  = get_string('remoteotheruserfield_desc', 'enrol_database');
 | 
        
           |  |  | 83 |     $settings->add(new admin_setting_configtext('enrol_database/remoteotheruserfield', $otheruserfieldlabel, $otheruserfielddesc, ''));
 | 
        
           |  |  | 84 |   | 
        
           |  |  | 85 |     if (!during_initial_install()) {
 | 
        
           |  |  | 86 |         $options = get_default_enrol_roles(context_system::instance());
 | 
        
           |  |  | 87 |         $student = get_archetype_roles('student');
 | 
        
           |  |  | 88 |         $student = reset($student);
 | 
        
           |  |  | 89 |         $settings->add(new admin_setting_configselect('enrol_database/defaultrole',
 | 
        
           |  |  | 90 |             get_string('defaultrole', 'enrol_database'),
 | 
        
           |  |  | 91 |             get_string('defaultrole_desc', 'enrol_database'),
 | 
        
           |  |  | 92 |             $student->id ?? null,
 | 
        
           |  |  | 93 |             $options));
 | 
        
           |  |  | 94 |     }
 | 
        
           |  |  | 95 |   | 
        
           |  |  | 96 |     $settings->add(new admin_setting_configcheckbox('enrol_database/ignorehiddencourses', get_string('ignorehiddencourses', 'enrol_database'), get_string('ignorehiddencourses_desc', 'enrol_database'), 0));
 | 
        
           |  |  | 97 |   | 
        
           |  |  | 98 |     $options = array(ENROL_EXT_REMOVED_UNENROL        => get_string('extremovedunenrol', 'enrol'),
 | 
        
           |  |  | 99 |                      ENROL_EXT_REMOVED_KEEP           => get_string('extremovedkeep', 'enrol'),
 | 
        
           |  |  | 100 |                      ENROL_EXT_REMOVED_SUSPEND        => get_string('extremovedsuspend', 'enrol'),
 | 
        
           |  |  | 101 |                      ENROL_EXT_REMOVED_SUSPENDNOROLES => get_string('extremovedsuspendnoroles', 'enrol'));
 | 
        
           |  |  | 102 |     $settings->add(new admin_setting_configselect('enrol_database/unenrolaction', get_string('extremovedaction', 'enrol'), get_string('extremovedaction_help', 'enrol'), ENROL_EXT_REMOVED_UNENROL, $options));
 | 
        
           |  |  | 103 |   | 
        
           |  |  | 104 |   | 
        
           |  |  | 105 |   | 
        
           |  |  | 106 |     $settings->add(new admin_setting_heading('enrol_database_newcoursesheader', get_string('settingsheadernewcourses', 'enrol_database'), ''));
 | 
        
           |  |  | 107 |   | 
        
           |  |  | 108 |     $settings->add(new admin_setting_configtext('enrol_database/newcoursetable', get_string('newcoursetable', 'enrol_database'), get_string('newcoursetable_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 109 |   | 
        
           |  |  | 110 |     $settings->add(new admin_setting_configtext('enrol_database/newcoursefullname', get_string('newcoursefullname', 'enrol_database'), '', 'fullname'));
 | 
        
           |  |  | 111 |   | 
        
           |  |  | 112 |     $settings->add(new admin_setting_configtext('enrol_database/newcourseshortname', get_string('newcourseshortname', 'enrol_database'), '', 'shortname'));
 | 
        
           |  |  | 113 |   | 
        
           |  |  | 114 |     $settings->add(new admin_setting_configtext('enrol_database/newcourseidnumber', get_string('newcourseidnumber', 'enrol_database'), '', 'idnumber'));
 | 
        
           |  |  | 115 |   | 
        
           | 1441 | ariadna | 116 |     $settings->add(new admin_setting_configtext(
 | 
        
           |  |  | 117 |         'enrol_database/newcoursestartdate',
 | 
        
           |  |  | 118 |         get_string('newcoursestartdate', 'enrol_database'),
 | 
        
           |  |  | 119 |         get_string('newcoursestartdate_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 120 |   | 
        
           |  |  | 121 |     $settings->add(new admin_setting_configtext(
 | 
        
           |  |  | 122 |         'enrol_database/newcourseenddate',
 | 
        
           |  |  | 123 |         get_string('newcourseenddate', 'enrol_database'),
 | 
        
           |  |  | 124 |         get_string('newcourseenddate_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 125 |   | 
        
           | 1 | efrain | 126 |     $settings->add(new admin_setting_configtext('enrol_database/newcoursecategory', get_string('newcoursecategory', 'enrol_database'), '', ''));
 | 
        
           |  |  | 127 |   | 
        
           |  |  | 128 |     $settings->add(new admin_settings_coursecat_select('enrol_database/defaultcategory',
 | 
        
           |  |  | 129 |         get_string('defaultcategory', 'enrol_database'),
 | 
        
           |  |  | 130 |         get_string('defaultcategory_desc', 'enrol_database'), 1));
 | 
        
           |  |  | 131 |   | 
        
           |  |  | 132 |     $settings->add(new admin_setting_configtext('enrol_database/templatecourse', get_string('templatecourse', 'enrol_database'), get_string('templatecourse_desc', 'enrol_database'), ''));
 | 
        
           |  |  | 133 | }
 |