<?php
include_once '../lib/util.php';
$db = new DBAdmin();
echo 'Updating `json` table ... ';
$q = $db->selectAll('summary');
$db->begin();
while ($row = $q->fetch_assoc()) {
$department = $db->single('SELECT * FROM `department`
WHERE `department_id` = ?', $row['department_id']);
$icode = $db->single('SELECT `internal_code` FROM `list`
WHERE `id` = ?', $row['id']);
$teacher = array_map(function ($t) {
return implode($t);
}, $db->query('SELECT `staff`.`name` FROM `teacher`
INNER JOIN `staff` ON `staff`.`staff_id` = `teacher`.`staff_id`
WHERE `id` = ? ORDER BY `teacher`.`main` DESC', $row['id'])->fetch_all(MYSQL_ASSOC));
$semester = NULL;
if (is_null($row['semester_id']) === FALSE) {
$semester = $db->single('SELECT `description` FROM `semester`
WHERE `semester_id` = ?', $row['semester_id']);
}
$schedule = array_map(function ($a) {
return array('day' => is_null($a['day']) ? NULL : (int) $a['day'], 'period' => is_null($a['period']) ? NULL : (int) $a['period'], 'early' => (bool) $a['early'], 'late' => (bool) $a['late'], 'intensive' => (bool) $a['intensive'], 'irregular' => (bool) $a['irregular']);
}, $db->query('SELECT * FROM `schedule` WHERE `id` = ?', $row['id'])->fetch_all(MYSQL_ASSOC));
$classroom = $db->query('SELECT `department`.`name` as `place`,
`department`.`department_code` as `place_code`, `room`.`name` as `name`
FROM `classroom`INNER JOIN `room` ON
`room`.`room_id` = `classroom`.`room_id` INNER JOIN `department`
ON `department`.`department_id` = `room`.`department_id`
WHERE `classroom`.`id` = ?', $row['id'])->fetch_all(MYSQL_ASSOC);
<?php
include_once '../lib/util.php';
$db = new DBAdmin();
$begin = isset($argv[1]) ? (int) $argv[1] : 0;
$end = isset($argv[2]) ? $argv[2] : NULL;
echo 'Updating `raw` table ... ';
$year = $db->single("SELECT MAX(`value`) FROM `config`\n \tWHERE `name` = 'year'");
$q = $db->query('SELECT * FROM `list` WHERE `year` = ? ORDER BY `id`', $year);
while ($row = $q->fetch_assoc()) {
if ($begin <= $row['id'] && (is_null($end) || $row['id'] <= $end)) {
$query = "?NENDO={$row['year']}&BUKYOKU=" . "{$row['department_code']}&CODE={$row['internal_code']}";
$html = sjis2utf(file_get_contents(HTML_URL . $query));
$text = sjis2utf(file_get_contents(TEXT_URL . $query));
if (mb_strpos($text, '<TITLE>授業が見つかりません</TITLE>') !== FALSE) {
continue;
}
$db->replace('raw', array('id' => $row['id'], 'html' => $html, 'text' => $text));
}
echo "[26G[K{$row['id']}";
}
$db->close();
echo " " . PRINT_OK . PHP_EOL;
<?php
include_once '../lib/util.php';
$db = new DBAdmin();
$db->truncate('room');
$db->truncate('classroom');
echo 'Updating `classroom` table ... ';
$q = $db->query('SELECT `list`.`id`, `list`.`place`, `htmldata`.`classroom`
FROM `list` JOIN `htmldata` ON `list`.`id` = `htmldata`.`id`');
$db->begin();
while ($row = $q->fetch_assoc()) {
$place = kana($row['place']);
$rooms = trim(kana($row['classroom']));
$did = $db->single('SELECT `department_id` FROM `department`
WHERE `name` = ?', $place);
if (is_null($did)) {
if ($place) {
$did = $db->single('SELECT `department_id` FROM `department` WHERE ' . implode(' AND ', array_map(function ($s) use($db) {
return "`name` LIKE '%" . $db->escape($s) . "%'";
}, preg_split('/\\(|\\)/', $place))));
}
}
foreach (explode(' ', $rooms) as $room) {
if (is_null($did) && !$room) {
continue;
}
$db->insert('room', array('department_id' => $did, 'name' => $room));
$did = is_null($did) ? 'IS NULL' : "= '" . $db->escape($did) . "'";
$rid = $db->single("SELECT `room_id` FROM `room`\n\t\t\tWHERE `department_id` {$did} AND `name` = ?", $room);
$db->insert('classroom', array('id' => $row['id'], 'room_id' => $rid));
}
