require_once 'peerlib/component.inc';
require_once 'navigation2.inc';
require_once 'peerlib/SimpleTableFormatter.php';
require_once 'peerlib/mailFunctions.php';
$pp = array();
$page = new PageContainer();
$page->setTitle("Plan meeloopdag");
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), "Plan een meeloopdag");
$page->addBodyComponent($nav);
//$css = "<link rel='stylesheet' type='text/css' href='style/tablesorterstyle.css'/>";
//$page->addScriptResource('js/jquery.js');
//$page->addScriptResource('js/jquery.tablesorter.js');
//$page->addJqueryFragment( '$("#myTable").tablesorter({widgets: [\'zebra\'],headers: {0:{sorter:false}}});' );
//$page->addHeadText($css);
$page->addHeadFragment('templates/tinymce_include.html');
$pp['subject_de'] = 'Einladung zum Schnuppertag an der Fontys FH in Venlo';
$pp['subject_nl'] = 'Uitnodiging voor een meeloopdag bij Fontys Hogescholen in Venlo';
$pp['mailbody_de'] = file_get_contents('templates/meeloop_mailbody_de.html', true);
$pp['mailbody_nl'] = file_get_contents('templates/meeloop_mailbody_nl.html', true);
$sql = "select 0 as sorter,m.*,s.roepnaam||coalesce(' '||s.voorvoegsel||' ',' ')||s.achternaam as mail_author from meeloopmail m join student s on (owner=snummer) where owner={$peer_id} \n" . "union\n" . "select 1 as sorter,m.* ,s.roepnaam||coalesce(' '||s.voorvoegsel||' ',' ')||s.achternaam as mail_author from meeloopmail m join student s on (owner=snummer) \n" . "order by sorter,meeloop_datum desc limit 1";
$resultSet = $dbConn->Execute($sql);
if ($resultSet !== false && !$resultSet->EOF) {
$pp = array_merge($pp, $resultSet->fields);
}
$sqlsender = "select rtrim(email1) as sender,roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam as sender_name," . "coalesce(signature," . "'sent by the peerweb service on behalf of '||roepnaam||coalesce(' '||voorvoegsel,'')||' '||achternaam)\n" . " as signature from student left join email_signature using(snummer) where snummer='{$peer_id}'";
$rs = $dbConn->Execute($sqlsender);
if (!$rs->EOF) {
extract($rs->fields);
} else {
$replyto = '*****@*****.**';
