public function findUnusedStudentsForFormAsExcel($form_ID)
{
// get the data
$enumlib = new EnumLib();
$dataXML = simplexml_load_string($enumlib->findStudentsForForm($form_ID, ""));
// make a new Excel sheet
$phpexcelObj = new PHPExcel();
$phpexcelObj->createSheet();
// put some headings in
$phpexcelObj->getActiveSheet()->setCellValue('A1', "Student Number");
$phpexcelObj->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$phpexcelObj->getActiveSheet()->setCellValue('B1', "Student name");
$phpexcelObj->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
// format a bit
$phpexcelObj->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$phpexcelObj->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
for ($i = 0; $i < count($dataXML->student); $i++) {
$phpexcelObj->getActiveSheet()->setCellValue('A' . ($i + 2), $dataXML->student[$i]->studentnum);
$phpexcelObj->getActiveSheet()->setCellValue('B' . ($i + 2), $dataXML->student[$i]->fname . ' ' . $dataXML->student[$i]->lname);
}
return $phpexcelObj;
}
$returnStr = $authlib->upload_csv($_FILES['file']);
break;
case 'liststudents':
include 'lib/EnumLib.php';
$enumLib = new EnumLib();
$returnStr = $enumLib->getStudents();
break;
case 'liststudentsbysearchstr':
include 'lib/EnumLib.php';
$enumLib = new EnumLib();
$returnStr = $enumLib->findStudents(isset($_REQUEST['searchstr']) ? $_REQUEST['searchstr'] : '');
break;
case 'liststudentsbysearchstrforform':
include 'lib/EnumLib.php';
$enumLib = new EnumLib();
$returnStr = $enumLib->findStudentsForForm($_REQUEST['formid'], isset($_REQUEST['searchstr']) ? $_REQUEST['searchstr'] : '', isset($_REQUEST['site']) ? $_REQUEST['site'] : -1);
break;
case 'listunusedstudentsforformAsExcel':
include 'lib/EnumLib.php';
$reportsLib = new ReportsLib();
$phpexcelObj = $reportsLib->findUnusedStudentsForFormAsExcel($_REQUEST['formid']);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="OSCE_Missing_students_report.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = new PHPExcel_Writer_Excel2007($phpexcelObj);
$objWriter->save('php://output');
break;
case 'getstudentbyid':
include 'lib/EnumLib.php';
$enumLib = new EnumLib();
$returnStr = $enumLib->getStudentByID($_REQUEST['id']);
