// along with Rogō. If not, see <http://www.gnu.org/licenses/>.
/**
*
* @author Simon Wilkinson
* @version 1.0
* @copyright Copyright (c) 2014 The University of Nottingham
* @package
*/
require '../include/sysadmin_auth.inc';
require_once '../classes/schoolutils.class.php';
$school = '';
$faculty = '';
if (isset($_POST['submit'])) {
$school = trim($_POST['school']);
$faculty = trim($_POST['facultyID']);
if (SchoolUtils::school_exists_in_faculty($faculty, $school, $mysqli)) {
$error = 'duplicate';
} else {
$insert_id = SchoolUtils::add_school($faculty, $school, $mysqli);
header("location: list_schools.php");
exit;
}
}
$faculties = 0;
$faculty_list = array();
$result = $mysqli->prepare("SELECT id, name FROM faculty WHERE deleted IS NULL ORDER BY name");
$result->execute();
$result->bind_result($facultyID, $name);
while ($result->fetch()) {
$faculty_list[] = array($facultyID, $name);
$faculties++;
$result->bind_param('i', $schoolid);
$result->execute();
$result->store_result();
$result->bind_result($school, $curr_faculty);
$result->fetch();
if ($result->num_rows == 0) {
$result->close();
$msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email'));
$notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true);
}
$result->close();
if (isset($_POST['submit'])) {
$school_tmp = trim($_POST['school']);
$faculty = trim($_POST['faculty']);
$changed = ($curr_faculty != $faculty or $school != $school_tmp);
if ($changed and SchoolUtils::school_exists_in_faculty($faculty, $school_tmp, $mysqli)) {
$error = 'duplicate';
$school = $school_tmp;
$curr_faculty = $faculty;
} else {
if ($changed) {
$result = $mysqli->prepare("UPDATE schools SET facultyID = ?, school = ? WHERE id = ?");
$result->bind_param('isi', $faculty, $school_tmp, $schoolid);
$result->execute();
$result->close();
$logger = new Logger($mysqli);
if ($school != $school_tmp) {
$logger->track_change('School', $schoolid, $userObject->get_user_ID(), $school, $school_tmp, $string['name']);
}
if ($curr_faculty != $faculty) {
$logger->track_change('School', $schoolid, $userObject->get_user_ID(), $curr_faculty, $faculty, $string['faculty']);
/*
***** NOW UPDATE THE INSTALLER SCRIPT *****
*/
$configObj = Config::get_instance();
$cfg_web_root = $configObj->get('cfg_web_root');
// 15/08/2012 - cczsa1 adding unknown school and faculty
require_once $cfg_web_root . 'classes/facultyutils.class.php';
require_once $cfg_web_root . 'classes/schoolutils.class.php';
$facultystatus = FacultyUtils::facultyname_exists('UNKNOWN Faculty', $mysqli);
if (!FacultyUtils::facultyname_exists('UNKNOWN Faculty', $mysqli)) {
$facultyID = FacultyUtils::add_faculty('UNKNOWN Faculty', $mysqli);
echo "<li>Adding Unknown Faculty</li>\n";
} else {
$facultyID = FacultyUtils::facultyid_by_name('UNKNOWN Faculty', $mysqli);
}
if (!SchoolUtils::school_exists_in_faculty($facultyID, 'UNKNOWN School', $mysqli) and $facultyID !== false) {
$schoolID = SchoolUtils::add_school($facultyID, 'UNKNOWN School', $mysqli);
echo "<li>Adding Unknown School</li>\n";
}
$result = $mysqli->prepare("SELECT id FROM " . $cfg_db_database . ".`schools` WHERE school='UNKNOWN School'");
$result->execute();
$result->store_result();
$result->bind_result($id1);
$result->fetch();
$rows = $result->num_rows();
$result->free_result();
$result->close();
if ($rows == 0) {
$schoolID = SchoolUtils::add_school($facultyID, 'UNKNOWN School', $mysqli);
echo "<li>Adding Unknown School</li>\n";
}
