$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$page->addFileContentsOnce('templates/tinymce_include.html');
$page->addHeadText('<script type="text/javascript">
function checkThem(ref,state){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
checks[i].checked = state;
}
}
function unCheckThem(ref){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
checks[i].checked = false;
}
}
function selectByClass(ref,cl,state){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
if (checks[i].classList.contains(cl)) {
checks[i].checked = state;
}
}
}
</script>
');
function roleTable($dbConn, $prjm_id)
{
$result = "\n<table border='1' style='border-collapse: collapse;'>\n" . "\t<tr style='background:rgba(240,240,240,0.4)'><th>num</th><th>select</th><th>Role</th><th>Abbr</th></tr>";
$nav = new Navigation(array(), basename($PHP_SELF), $page_opening);
$page->addBodyComponent($nav);
$mailer_signature = "\n<form method='post' action='{$PHP_SELF}' name='mailerform' id='mailerform'>\n<fieldset><legend>Mailer</legend>\nThis signature will be appended to your email editor on startup. \nYou may use html enriched tex.\n<div>\n\n<b>Signature:</b><br/>\n<textarea cols='120' rows='20' id='signature' name='signature' class='mceEditor'>\n{$signature}\n</textarea >\n<input type='submit' name='set' value='Update signature'/>\n<input type='reset' name='reset' value='reset'/>\n</div>\n</fieldset>\n</form>\n";
$page->addBodyComponent(new Component($mailer_signature));
$page->addHeadText('<script language="javascript" type="text/javascript" src="' . SITEROOT . '/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
gecko_spellcheck : true,
theme_advanced_toolbar_location : "top",
mode : "textareas", /*editor_selector : "mceEditor",*/
theme_advanced_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
plugins: "advlink,searchreplace,insertdatetime,table",
plugin_insertdate_dateFormat : "%Y-%m-%d",
plugin_insertdate_timeFormat : "%H:%M:%S",
table_styles : "Header 1=header1;Header 2=header2;Header 3=header3",
table_cell_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Cell=tableCel1",
table_row_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
table_cell_limit : 100,
table_row_limit : 5,
table_col_limit : 5,
theme_advanced_buttons1_add : "search,replace,insertdate,inserttime,tablecontrols",
/* theme_advanced_buttons2 : "",
theme_advanced_buttons3 : ""*/
});
</script>
');
$page->show();
$page->addHeadText('<script language="javascript" type="text/javascript" src="' . SITEROOT . '/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
auto_resize: true,
gecko_spellcheck : true,
theme_advanced_toolbar_location : "top",
mode : "textareas", /*editor_selector : "mceEditor",*/
theme_advanced_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
plugins: "advlink,searchreplace,insertdatetime,table",
plugin_insertdate_dateFormat : "%Y-%m-%d",
plugin_insertdate_timeFormat : "%H:%M:%S",
table_styles : "Header 1=header1;Header 2=header2;Header 3=header3",
table_cell_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Cell=tableCel1",
table_row_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
table_cell_limit : 100,
table_row_limit : 5,
table_col_limit : 5,
theme_advanced_buttons1_add : "search,replace,insertdate,inserttime,tablecontrols",
/* theme_advanced_buttons2 : "",
theme_advanced_buttons3 : ""*/
});
</script>
<script type="text/javascript">
function checkThem(ref){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
checks[i].checked = true;
}
}
function unCheckThem(ref){
var checks = document.getElementsByName(ref);
var boxLength = checks.length;
for ( i=0; i < boxLength; i++ ) {
checks[i].checked = false;
}
}
</script>
');
<?php
}
?>
<?php
if ($lang == 'de') {
?>
<h2 class='normal'>Abmelden</h2>
<p>Indem du dich mit dem roten Button oben rechts oder unten abmeldest, kannst du verhindern das dein Account missbraucht werden kann.</p>
<?php
}
?>
</div>
</td>
<td valign='top'>
<?php
include 'righthandcolumn.php';
?>
</td>
</tr></table>
<!-- db_name=<?php
echo $db_name;
?>
-->
<!-- $Id: home.php 1761 2014-05-24 13:17:31Z hom $-->
<?php
$page->addBodyComponent(new Component(ob_get_clean()));
$page->addHeadText('
<script src="' . $root_url . '/js/scriptaculous/prototype.js" type="text/javascript"></script>
<script src="' . $root_url . '/js/scriptaculous/scriptaculous.js" type="text/javascript"></script>
');
$page->show();
$curriculum .= "\t\t\t<td > </td>\n";
$colsleft--;
}
$curriculum .= "\n\t\t</tr>\n";
}
$curriculum .= "</table>\n" . "<br/><b>Legend:class name [class size]</b>\n" . "</div><!-- end tabs-{$divcount} -->\n\n</div><!-- end tabs div -->\n";
$tablist .= "\t</ul>\n";
$sqlCount = "select count(*) as membercount from prj_grp join prj_tutor using(prjtg_id) where prjm_id={$prjm_id}";
$rsc = $dbConn->Execute($sqlCount);
$membercount = $rsc->fields['membercount'];
//$result .="</table>\n</div>\n";
$curriculum .= "<table border='0' style='border-collapse:collapse;><thead> <tr>\n<th class='theadleft'> </th>\n <th colspan='1' class=''><input type='reset' name='reset' value='Reset'/></th>\n <th colspan='1' class=''>{$submit_button}</th>\n </tr>\n <tr>\n<th class='theadleft'> </th>\n <th colspan='2' class=''>\n Owning tutor: {$ot_owner_id}, {$ot_roepnaam} {$ot_voorvoegsel} {$ot_achternaam}\n <input type='hidden' name='prjm_id' value='{$prjm_id}'/>\n </th>\n </tr></thead>\n<table>\n";
$form2Table->addText($tablist . $curriculum);
$form2Form->add($form2Table);
//$form1Table->add( $form1Form );
$form2Fieldset = new HtmlContainer("<div id='demo' style='margin:2em;background:rgba(255,255,255,0.5);'><b>Current member count ={$membercount}</b>");
$form2Fieldset->add($form2Form);
$page->addBodyComponent($form1Form);
$page->addBodyComponent($form2Fieldset);
$page->addBodyComponent(new Component('<!-- db_name=$db_name $Id: defgroup.php 1829 2014-12-28 19:40:37Z hom $ -->'));
$page->addHeadText('
<link type="text/css" href="css/pepper-grinder/jquery-ui-1.8.17.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.17.custom.min.js"></script>
<script>
$(function() {
$( "#tabs" ).tabs();
});
</script>
');
$page->show();
$resultSet->moveNext();
}
}
$page = new PageContainer();
$page_opening = "Put participants into groups";
$page_opening = "Select participants into project groups " . "<span style='font-size:8pt;'>prj_id {$prj_id} milestone {$milestone} prjm_id {$prjm_id}</span>";
$page->setTitle('Put participants into groups');
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
extract(getTutorOwnerData2($dbConn, $prjm_id), EXTR_PREFIX_ALL, 'ot');
$page->addBodyComponent($nav);
$templatefile = 'templates/defgroupmembers3.html';
$ie_warning = strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') ? "Internet Exploder is not supported" : "";
$template_text = file_get_contents($templatefile, true);
if ($template_text === false) {
$page->addBodyComponent(new Component("<strong>cannot read template file {$templatefile}</strong>"));
} else {
eval("\$text = \"{$template_text}\";");
$page->addBodyComponent(new Component($text));
}
$page->addHeadText('
<script src="' . $root_url . '/js/scriptaculous/prototype.js" type="text/javascript"></script>
<script src="' . $root_url . '/js/scriptaculous/scriptaculous.js" type="text/javascript"></script>
<script src="' . $root_url . '/js/scriptaculous/OptionTransfer.js" type="text/javascript"></script>
<script type="text/javascript">
var ot = new OptionTransfer("leftselect","rightselect");
</script>
');
$page->setBodyTag("<body id='body' class='" . BODY_CLASS . "' onLoad='ot.init(document.forms.grpmembers)'>");
$page->show();
} else {
$fragment = 'templates/upload_critique_noaccess.html';
}
$page->addHtmlFragment($fragment, $pp);
$page->addHeadText('
<script type="text/javascript">
function bye(){
opener.focus();
opener.location.href="$referer?doc_id=$doc_id";
opener.location.reload();
self.close();
}
function delete_crit( crit ) {
var Check = confirm("Do you want to delete this qritique?");
if (Check == true) return true; else false;
}
function invoke_editor( crit,doc_id,cmd ) {
window.open(\'critique_editor.php?critique_id=\'+crit+\'&cmd=\'+cmd+\'&doc_id=\'+doc_id, \'_blank\', \'width=800,height=670,scrollbars\');
}
function invoke_editor_new( doc_id ) {
window.open(\'critique_editor.php?critique_id=new&doc_id=\'+doc_id,\'_blank\',\'width=800,height=670,scrollbars\');
}
function bye(){
opener.focus();
opener.location.href="<?= $referer ?>?doc_id=<?= $doc_id ?>";
opener.location.reload();
self.close();
}
</script>
');
$page->show();
}
$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));
}
$sql = "SELECT '<input type=''checkbox'' name=''studenten[]'' value='''||st.snummer||'''/>' as chk," . "'<a href=''student_admin.php?snummer='||snummer||'''>'||st.snummer||'</a>' as snummer," . "'<img src='''||photo||''' style=''height:24px;width:auto;''/>' as foto,\n" . "achternaam||', '||roepnaam||coalesce(' '||voorvoegsel,'') as naam,pcn," . "email1 as email,t.tutor as slb,hoofdgrp,cohort,course_short sprogr,studieplan_short as splan,lang,sex,gebdat," . " land,plaats,pcode\n" . " from student st " . "left join student_class cl using(class_id)\n" . "natural left join studieplan \n" . "left join fontys_course fc on(st.opl=fc.course)\n" . "left join tutor t on (st.slb=t.userid)\n" . " natural join portrait\n" . "where class_id='{$oldclass_id}' " . "order by hoofdgrp,opl,sclass asc,achternaam,roepnaam";
$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();
$description = pg_escape_string($_POST['description']);
$sql = "update personal_repos set description='{$description}' where id={$fileNr}";
$resultSet = $dbConn->Execute($sql);
if (!$resultSet->EOF) {
$dbConn->log("could not save description with sql " . $sql);
}
$dbConn->log("saved {$description}");
}
$pp = array();
$sql = "select repospath,description,id as fileNr from personal_repos where owner={$snummer} and id={$fileNr}\n";
$resultSet = $dbConn->Execute($sql);
if (!$resultSet->EOF) {
$pp = array_merge($pp, $resultSet->fields);
$description = stripslashes($description);
}
//pagehead('Edit Subversion repositories');
$page = new PageContainer();
$page->addHeadText('<script type="text/javascript">
function closeAction() {
document.edit_form.action = "isubversionrepos.php";
return true;
}
</script>
');
$page->setTitle('Edit Subversion repositories');
$page_opening = "Edit Subversion repositories for {$roepnaam} {$voorvoegsel} {$achternaam} ({$snummer})";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$page->addBodyComponent($nav);
$page->addHtmlFragment('templates/svneditor.html', $pp);
$page->show();
$replyText = '';
$script = $lang = 'nl';
//echo "$user<br/>\n";
$sql = "select * from student where snummer={$judge}";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
print "error fetching judge data with {$sql} : " . $dbConn->ErrorMsg() . "<br/>\n";
}
if (!$resultSet->EOF) {
extract($resultSet->fields, EXTR_PREFIX_ALL, 'judge');
}
$lang = strtolower($judge_lang);
$page_opening = "Assessment entry form for {$judge_roepnaam} {$judge_voorvoegsel} {$judge_achternaam} ({$judge_snummer})";
$page = new PageContainer();
$page->setTitle('Peer assessment entry form');
$page->addHeadText("<script language='JavaScript' type='text/javascript'>\n/**\n * validate input\n */\nfunction validateGrade(el) {\n var rex;\n /* el is the element with the value to be tested\n */\n var locvar = el.value;\n el.value = locvar;\n rex = locvar.search(/^[0-9]{1,2}\$/);\n if (rex == -1 ) {\n alert(el.value+': Only digits (and whole numbers) are allowed!');\n return false;\n }\n if ( locvar < 1 || locvar > 10 ) {\n alert(el.value + \n\t ' is not a correct grade, use a whole figure between 1 and 10');\n return false;\n }\n return true;\n}\n</script>");
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->addLeftNavText(file_get_contents('news.html'));
ob_start();
tutorHelper($dbConn, $isTutor);
$page->addBodyComponent(new Component(ob_get_contents()));
ob_clean();
$page->addBodyComponent($nav);
ob_start();
// see if there is a reopen request
if ($isTutor && isset($_REQUEST['reopen'])) {
$sql = "begin work;\n" . "update prj_grp set prj_grp_open=true,written=false where prjtg_id={$prjtg_id} and snummer={$judge} ;\n" . "update prj_tutor set prj_tutor_open=true,assessment_complete=false where prjtg_id={$prjtg_id};\n" . "update prj_milestone set prj_milestone_open=true where prjm_id={$prjm_id};\n" . "commit;";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die("<br>Cannot update prj_grp table with \"" . $sql . '", cause ' . $dbConn->ErrorMsg() . "<br>");
/* $toAddress=$author_email2; */
/* domail($toAddress,$subject,$body,$headers); */
/* } */
} else {
$sql = "begin work;\n" . "insert into critique_history (critique_id,edit_time,critique_text) select critique_id,edit_time,critique_text\n" . "from document_critique where critique_id={$critique_id} and critiquer={$peer_id};\n " . "update document_critique set critique_text='{$critique_text_i}',edit_time=now() \n" . "where critique_id={$critique_id} and critiquer={$peer_id};" . "commit";
}
$resultSet = $dbConn->doSilent($sql);
} else {
if (isset($_REQUEST['edit_critique'])) {
$critique_id = validate($_REQUEST['edit_critique'], 'integer', 1);
}
}
}
$page = new PageContainer();
$page->setTitle('Critique_editor');
$page->addHeadText("<script type='text/javascript'>\n" . "/*\n" . " * refresh parent page on close\n" . " */\n" . "function bye(){ \n" . " opener.focus();\n" . " opener.location.reload();\n" . " self.close();\n" . "}\n" . "/*\n" . " * refresh parent page on close\n" . " */\n" . "function edit_submit(){ \n" . " opener.location.reload();\n" . " return true;\n" . "}\n" . "</script>");
// $page->addHeadText("<script language='JavaScript' type='text/javascript' src='js/html2xhtml.js'>".
// "</script>");
// $page->addHeadText("<script language='JavaScript' type='text/javascript' ".
// "src='js/richtext.js'>"."</script>");
$page->addHeadText('<script language="javascript" type="text/javascript" src="' . SITEROOT . '/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
theme_advanced_toolbar_location : "top",
mode : "textareas"
});
</script>
');
$page->addHeadText("<style type='text/css'>\n" . " p {text-align: justify;}\n" . " p:first-letter {font-size:180%; font-family: script;font-weight:bold; color:#800;}\n" . " </style>");
$form1 = new HtmlContainer("<div id='main'>");
$page->addHeadText('<script language="javascript" type="text/javascript" src="/js/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
theme: "advanced",
/*auto_resize: true,*/
gecko_spellcheck : true,
theme_advanced_toolbar_location : "top",
mode : "textareas", /*editor_selector : "mceEditor",*/
theme_advanced_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
plugins: "advlink,searchreplace,insertdatetime,table",
plugin_insertdate_dateFormat : "%Y-%m-%d",
plugin_insertdate_timeFormat : "%H:%M:%S",
table_styles : "Header 1=header1;Header 2=header2;Header 3=header3",
table_cell_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Cell=tableCel1",
table_row_styles : "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1",
table_cell_limit : 100,
table_row_limit : 5,
table_col_limit : 5,
theme_advanced_buttons1_add : "search,replace,insertdate,inserttime,tablecontrols",
/* theme_advanced_buttons2 : "",
theme_advanced_buttons3 : ""*/
});
</script>
<script type="text/javascript" src="/examdoc/js/jquery.min.js"></script>
<script src="/examdoc/js/jquery.tablesorter.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#myTable").tablesorter({widgets: ["zebra"]});
});
</script>
<link rel="stylesheet" type="text/css" href="/examdoc/css/tablesorterstyle.css"/>
');
