public function processRequest()
{
global $_SESSION;
global $_REQUEST;
$excelFormat = 'Excel2007';
$fileExtension = 'xlsx';
if (isset($_REQUEST[$this->name]) && isset($_REQUEST['filetype'])) {
switch ($_REQUEST['filetype']) {
case 'Excel2007':
$fileExtension = 'xlsx';
$excelFormat = 'Excel2007';
break;
case 'Excel2003':
$fileExtension = 'xls';
$excelFormat = 'Excel5';
break;
default:
case 'csv':
$fileExtension = 'csv';
$excelFormat = 'CSV';
// all work here
$this->writeCSVFile($this->query, $this->filename . '.' . $fileExtension);
break;
case 'AMC-exam':
$fileExtension = 'csv';
$excelFormat = 'CSV';
// all work here
$this->writeAMCFile($this->query, $this->filename . '.' . $fileExtension);
break;
case 'PROGRESS-set':
$fileExtension = 'txt';
$excelFormat = 'CSV';
// all work here
$this->writeProgresFile($this->query, $this->filename . '.' . $fileExtension);
break;
}
require_once 'queryToXlsx.php';
$student_encoding_relation = ' student_email s ';
$xlsWriter = new XLSWriter($this->dbConn, $this->query);
$xlsWriter->setFilename($this->filename . '.' . $fileExtension)->setTitle($this->title)->setLinkText($this->linkText)->setLinkUrl($this->url)->setAutoZebra($this->autoZebra)->setWeights($this->weights)->setWeightedSumsColumn($this->weightSumsColumn)->setFirstWeightColumn($this->firstWeightsColumn)->setExcelFormat($excelFormat);
if (isset($this->rowparser)) {
$xlsWriter->setRowParser($this->rowparser);
}
if (isset($this->rainBow)) {
$xlsWriter->setRainBow($this->rainBow);
}
if ($this->colorChangerColumn >= 0) {
$xlsWriter->setColorChangerColumn($this->colorChangerColumn);
}
$xlsWriter->writeXlsx($this->query);
exit(0);
}
}
