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 = '*****@*****.**';