<?php

// export as excel file
if (session_id() == '') {
    session_start();
}
include 'connection.php';
include '../Classes/PHPExcel/IOFactory.php';
include '../Classes/PHPExcel.php';

$language_id = $_SESSION['tm_language_id'];

// Get language name by language id
$sql = 'SELECT name FROM languages WHERE id = ' . $language_id;	
$result = $mysqli->query($sql);

if($result->num_rows > 0) {
	
	while ($row = $result->fetch_object()) {
		$language_name = $row->name;
	}

	// Instantiate a new PHPExcel object
	$objPHPExcel = new PHPExcel();
	$objPHPExcel->setActiveSheetIndex(0);
	$rowCount = 1;
	$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, "English Original Sentence");
	$objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, "Translation of Original Sentence in " . $language_name);				

	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
			
	$filename = "Self-Assessment-Test-Sample-" . $language_name . ".xlsx";

	//Instantiate a Writer to create an OfficeOpenXML Excel .xlsx file
	$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);

	//Write the Excel file to filename some_excel_file.xlsx in the current directory
	header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
	header('Content-Disposition: attachment;filename="' . $filename . '"');
	header('Cache-Control: max-age=0');

	$objWriter->save('php://output');
	

}
?>