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


$db = mdb2_open($dsn);

$res = mdb2_query($db, <<<EOQ
SELECT grp2vak.grp2vak_id, lessen.les_id, grp.naam, grp.grp_id AS grp_id
FROM lessen
LEFT JOIN lessen2grp2vak ON lessen2grp2vak.les_id = lessen.les_id AND lessen2grp2vak.grp2vak_id IS NULL
JOIN entities2lessen ON entities2lessen.les_id = lessen.les_id
JOIN entities ON entities2lessen.entity_id = entities.entity_id AND entities.entity_type = 4
JOIN ovckb2entities ON ovckb2entities.entity_id = entities.entity_id
JOIN ovckb.grp ON ovckb2entities.ovckb_id = grp.grp_id
LEFT JOIN ovckb.vak ON afkorting = vakken
LEFT JOIN ovckb.grp2vak ON grp2vak.grp_id = grp.grp_id AND grp2vak.vak_id = vak.vak_id
EOQ
);

while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
	mdb2_exec($db, <<<EOQ
INSERT IGNORE INTO lessen2grp2vak ( les_id, grp2vak_id, grp_naam, grp_id ) VALUES ( {$row['les_id']}, %i, '%q', %i )
EOQ
, $row['grp2vak_id'],  $row['naam'], $row['grp_id']);
}
?>