#!/usr/bin/php
<?
require 'config.php';
require 'common.php';


$db = mdb2_open($dsn);
mdb2_exec($db, "DELETE FROM ovckb2entities WHERE 1");


$res = mdb2_query($db, "SELECT ppl_id, login FROM ovckb.ppl WHERE type = 'personeel' AND active IS NOT NULL");
while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
	$entity_id = mdb2_single_val($db, "SELECT entity_id FROM entities WHERE entity_name = '%q' AND entity_type = ".DOCENT, $row['login']);

	if (!$entity_id) {
		//echo('Docent '.$row['login']." niet gevonden in rooster.\n");
		continue;
	}

	mdb2_exec($db, "INSERT IGNORE INTO ovckb2entities ( ovckb_id, entity_id ) VALUES ( {$row['ppl_id']}, $entity_id )");
}

$res = mdb2_query($db, "SELECT grp_id, naam FROM ovckb.grp WHERE schooljaar = '1314' AND grp_type_id = 2");
while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
	//$search = $row['naam'];
	/*
	if (preg_match('/^(VIP_wi)/', $row['naam']) || strlen($row['naam']) == 2) {
		continue;
	} else if (preg_match('/^([1-3])(H|V)(H|V)?((kunst|cen|science|sport|mm)\d?)$/', $row['naam'], $matches)) {
		$search = $matches[1].'_.'.$matches[1].$matches[2].$matches[3].$matches[4];
		//echo($row['naam'].' is '.$search."\n");
		//print_r($matches);
	} else if (preg_match('/^([4-6](H|V))([a-z]+[A-Z]?\d)$/', $row['naam'], $matches)) {
		$search = $matches[1].'.'.$matches[3];
	} else*/
       	if (preg_match('/^(([1-3][GAH])\d+[ABCG])$/', $row['naam'], $matches)) {
		$search = $matches[2].'.'.$matches[1];
	} else if ($row['naam'] == '4ET2') $search = '4BBL.4ET2';/*else if (preg_match('/^(OPDC1|VAVO|X_CT|X_ET|X_UV|XDRA|XLOO|[4-6](H|V)[A-L]|5GH|5JK|5KOK|[2345](TLH|UV|ZW|CT|ET|GH|LWT|KOK|JK)\d?)$/', $row['naam'])) {
		switch ($row['naam']) {
		case '4ZW2':
			$search = '4KBL.'.$row['naam'];
			break;
		case '4JK':
		case '4GH':
		case '4KOK':
			$search = '4VM2.'.$row['naam'];
			break;
		case '3CT1':
		case '3ET1':
		case '3UV1':
		case '3ZW1':
		case '3ZW2':
			$search = '3KBL.'.$row['naam'];
			break;
		case '3ZW3':
		case '3ET2':
			$search = '3BBL.'.$row['naam'];
			break;
		case '3UV2':
		case '3CT2':
			$search = '3VM2.'.$row['naam'];
			break;
		case '4ZW1':
		case '4ZW2':
		case '4UV1':
		case '4CT1':
		case '4ET1':
			$search = '4KBL.'.$row['naam'];
			break;
		case '4ET2':
		case '4ZW3':
		case '4UV2':
			$search = '4BBL.'.$row['naam'];
			break;
		case '5GH':
		case '5JK':
		case '5KOK':
			$search = '5VM2.'.$row['naam'];
			break;
		default:
			$search = $row['naam'];
		}
	} else if (preg_match('/^([2345])(VM2|T|B|K)([a-z]+)_?(\d?\d?)$/', $row['naam'], $matches)) {
		switch ($matches[2]) {
		case 'T':
			$search = $matches[1].'TLH.'.$matches[3].$matches[4];
			break;
		case 'K':
			$search = $matches[1].'KBL.'.$matches[3].$matches[4];
			break;
		case 'B':
			$search = $matches[1].'BBL.'.$matches[3].$matches[4];
			break;
		case 'VM2':
			$search = $matches[1].'VM2.'.$matches[3].$matches[4];
			break;
		default:
			fatal_error('unhandled '.$row['naam']);
		}
	} else if (preg_match('/^([12][A-L][A-L]?\d|[34][ED]B\d)$/', $row['naam'])) {
		continue; // BHC?
	} else if (preg_match('/(3KBmt|4KBtr|3HV|OPDC2|XKAA|X_DRA|X_LOO|X_ZWB|X_ROC|XMAN|XREL|XSTO|XHEF|XOPB)$/', $row['naam'])) {
		continue; // ????
	//} else if (preg_match('/([234])(VM2|K|B|T)([a-z]+_?\d)/', $row['naam'], $matches)) {
	//	print_r($matches);
	//	switch ($matches[2]) {
	} else {
		echo('not found '.$row['naam']."\n");
	}
	 */
	else {
		$search = $row['naam'];
	}
	$entity_id = mdb2_single_val($db, "SELECT entity_id FROM entities WHERE entity_name LIKE '%q' AND entity_type = ".LESGROEP, $search);

	if (!$entity_id) {
		echo('Lesgroep '.$search.'/'.$row['naam']." niet gevonden in rooster.\n");
		continue;
	}

	mdb2_exec($db, "INSERT IGNORE INTO ovckb2entities ( ovckb_id, entity_id ) VALUES ( {$row['grp_id']}, $entity_id )");
}
?>