$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"/> ');