$dbconfig = $config->Database;
$db = new Database($dbconfig['host'], $dbconfig['user'], $dbconfig['pass'], $dbconfig['name']);
if (!$db) {
throw new Exception("Couldn't connect to the database.");
}
$subjects = $db->listSubjects();
foreach ($subjects as $subject) {
//Skip subjects that don't match $label, if necessary
if (!empty($label) && $subject['subjectLabel'] !== $label) {
continue;
}
//skip unlocked subjects
if ((int) $subject['locked'] == 0) {
continue;
}
$xml = getSubjectDataAsXml($subject['subjectLabel'], $db);
// header('Content-type: application/xml');
// print $xml->saveXML();die;
//get /final/data
$xpath = new DOMXPath($xml);
$result = $xpath->query('/result/final/data');
if (!$result || !$result->length) {
die;
}
$finalxml = $result->item(0);
$hasEDU_OCCU = xmlHasValuesForFields($finalxml, $EDU_OCCU);
$hasHI = xmlHasValuesForFields($finalxml, $HI);
if ($hasEDU_OCCU && $hasHI) {
$found[] = $subject['subjectLabel'];
}
}
$format = strtolower(trim($_GET['format']));
}
$subjectLabel = trim(strtoupper($_GET['label']));
$xml = "";
try {
$config = new \NRG\Configuration("../config.ini.php");
$dbconfig = $config->Database;
$db = new Database($dbconfig['host'], $dbconfig['user'], $dbconfig['pass'], $dbconfig['name']);
if (!$db) {
throw new Exception("Couldn't connect to the database.");
}
$xml = NULL;
if ($final) {
$xml = getSubjectFinalDataAsXML($subjectLabel, $db);
} else {
$xml = getSubjectDataAsXml($subjectLabel, $db);
/** WARNING: This function caches the XSL file. */
$result = applyXSLtoXML($xml, XSL_SUBJECT_DATA);
// header('Content-type: application/xml');
// print $xml->saveXML();die;
$xml = new DomDocument();
$xml->loadXML($result);
// header('Content-type: application/xml');
// print $xml->saveXML();die;
$rows = $xml->getElementsByTagName('rows')->item(0);
$hasDiff = diffRows($rows);
}
} catch (Exception $e) {
ajax_error($e->getMessage());
}
$content_type = 'application/xml';
