if (isset($_POST['maillist'])) {
createGenericMaillistByClassid($dbConn, $oldclass_id);
}
$pp['mailalias'] = $prefix . '@fontysvenlo.org';
$oclassSelectorClass = new ClassSelectorClass($dbConn, $oldclass_id);
$pp['oldClassSelector'] = $oclassSelectorClass->setSelectorName('oldclass_id')->addConstraint('student_count <>0')->setAutoSubmit(true)->getSelector();
$nclassSelectorClass = new ClassSelectorClass($dbConn, $newclass_id);
$pp['newClassSelector'] = $nclassSelectorClass->setSelectorName('newclass_id')->getSelector();
$page = new PageContainer();
$page_opening = "Move students between student_class.";
$page->setTitle($page_opening);
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$page->addBodyComponent($nav);
$css = '<link rel=\'stylesheet\' type=\'text/css\' href=\'' . SITEROOT . '/style/tablesorterstyle.css\'/>';
$page->addScriptResource('js/jquery.js');
$page->addScriptResource('js/jquery.tablesorter.js');
$page->addHeadText($css);
$page->addJqueryFragment('$("#myTable").tablesorter({widgets: [\'zebra\'],headers: {0:{sorter:false}}});
var table = $("#myTable");
table.bind("sortEnd",function() {
var i = 0;
table.find("tr:gt(0)").each(function(){
$(this).find("td:eq(0)").text(i);
i++;
});
}); ');
$filename = '/home/maillists/' . $prefix . '.maillist';
$pp['filetime'] = 'never';
if (file_exists($filename)) {
$pp['filetime'] = date("Y-m-d H:i:s", filemtime($filename));
$result = $dbConn->Affected_Rows();
if ($result == 0) {
$sql = "update meeloopmail set subject_nl='{$pp['subject_nl']}',\n" . "subject_de='{$pp['subject_de']}',\n" . "mailbody_nl='{$mailbody_nl}',\n" . "mailbody_de='{$mailbody_de}'\n" . "where owner={$peer_id} and meeloop_datum='{$pp['meeloop_datum']}'";
$dbConn->Execute($sql);
$result = $dbConn->Affected_Rows();
}
}
if (isset($_POST['mail']) && isset($_POST['domail'])) {
$mail = $_POST['mail'];
$mailset = '\'' . implode("','", $mail) . '\'';
$sql_de = "select meelopen_id,email as email1, \n" . "roepnaam ||' '||coalesce(tussenvoegsel,'')||' '||achternaam as name\n" . "from meelopen\n" . "where taal ='DE' and meelopen_id in ({$mailset})";
$sql_nl = "select meelopen_id,email as email1, \n" . "roepnaam ||' '||coalesce(tussenvoegsel,'')||' '||achternaam as name\n" . "from meelopen\n" . "where taal ='NL' and meelopen_id in ({$mailset})";
//$dbConn->log( $sql );
formMailer($dbConn, $sql_de, $pp['subject_de'], $pp['mailbody_de'], $sender, $sender_name);
formMailer($dbConn, $sql_nl, $pp['subject_nl'], $pp['mailbody_nl'], $sender, $sender_name);
// update invitation
$sql = "begin work;\n" . "update meelopen set invitation=now()::date where meelopen_id in ({$mailset});\n" . "update meeloopmail set invitation_datum = now()::date where owner={$peer_id} and meeloop_datum='{$pp['meeloop_datum']}';\n" . "commit";
$rs = $dbConn->Execute($sql);
if ($rs === false) {
$dbConn->Execute('rollback');
}
}
$sql = "select '<input type=''checkbox'' name=''mail[]'' value='''||meelopen_id||'''/>' as chk,\n" . "achternaam,roepnaam,tussenvoegsel,plaats,land,postcode,email,sex,datum_in,invitation \n" . "from meelopen where participation isnull order by invitation desc,land,achternaam";
$pp['rtable'] = new SimpleTableFormatter($dbConn, $sql, $page);
$pp['rtable']->setCheckColumn(0)->setCheckName('mail[]')->setColorChangerColumn(10)->setTabledef("<table id='myTable' class='tablesorter' summary='meeloop studenten'" . " style='empty-cells:show;border-collapse:collapse' border='1'>");
$page->addHtmlFragment('templates/meeloopdag.html', $pp);
$page->addHeadText(file_get_contents('templates/simpledatepicker.html'));
$page->addScriptResource('js/jquery-1.7.1.min.js');
$page->addScriptResource('js/jquery-ui-1.8.17.custom.min.js');
$page->addJqueryFragment('$(\'#meeloop_datum\').datepicker(dpoptions);');
$page->show();
