$csvout = $_REQUEST['csvout'];
$csvout_checked = $csvout == 'Y' ? 'checked' : '';
}
// <a href='../emailaddress.php?snummer=snummer'>snummer</a>
$fdate = date('Ymd-Hi');
$filename = 'jaag_buit-' . $fdate;
$sql = "select * from jaag_buit_html";
$sqlcsv = "select * from jaag_buit";
$spreadSheetWriter = new SpreadSheetWriter($dbConn, $sqlcsv);
$spreadSheetWriter->setFilename($filename)->setTitle("Jaag buit {$fdate}")->setLinkUrl($server_url . $PHP_SELF)->setFilename($filename)->setAutoZebra(true);
$spreadSheetWriter->processRequest();
$spreadSheetWidget = $spreadSheetWriter->getWidget();
pagehead2('Jaag Buit', $scripts);
$page_opening = "Resultaat van jaagactie tot nu toe";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
echo $nav->show();
?>
<div id='navmain' style='padding:1em;'>
<fieldset><legend>Select output type</legend>
<form method="get" name="project" action="<?php
echo $PHP_SELF;
?>
">
<input type='submit' name='get' value='Get' />
Excel file:
<?php
echo $spreadSheetWidget;
?>
</form><br/>
</fieldset>
<div align='center'>
}
$scripts = '<script type="text/javascript" src="js/jquery.js"></script>
<script src="js/jquery.tablesorter.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#myTable").tablesorter({widgets: [\'zebra\']});
});
</script>
<link rel=\'stylesheet\' type=\'text/css\' href=\'' . SITEROOT . '/style/tablesorterstyle.css\'/>
';
$myClassSelector = new ClassSelectorClass($dbConn, $class_id);
$classSelectorWidget = $myClassSelector->setAutoSubmit(true)->setSelectorName('newclass_id')->getSelector();
$sql = "select distinct snummer,achternaam,roepnaam,voorvoegsel,lang \n" . " from student \n" . "join student_class using(class_id)\n" . " where class_id={$class_id} " . " order by achternaam,roepnaam";
$rainbow = new RainBow();
$memberTable = simpletableString($dbConn, $sql, "<table id='myTable' class='tablesorter' summary='your requested data'" . " style='empty-cells:show;border-collapse:collapse' border='1'>");
pagehead2('Add/move individual student to class.', $scripts);
$page_opening = "Add individual student to a class. <span style='font-size:6pt;'>class_id {$class_id}</span>";
$nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening);
$nav->setInterestMap($tabInterestCount);
$nav->show();
include_once 'templates/addtoclass.html';
?>
<!-- db_name=<?php
echo $db_name;
?>
-->
<!-- $Id: addtoclass.php 1853 2015-07-25 14:17:12Z hom $ -->
</body>
</html>
}
</style>
<link href="css/bootstrap-responsive.css" rel="stylesheet">
<!--[if lt IE 9]>
<script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/bootstrap-typeahead.js"></script>
<script src="js/bootstrap-datepicker.js"></script>
<script src="js/bootstrap-collapse.js"></script>
<?php
$nav = new Navigation();
$nav->show($command, $params, $currentuser);
//echo "Type:".User::Current()->type;
?>
<?php
$currentpage->show($command, $params, $currentuser);
?>
</body>
</html>
