<?php
//error_reporting(E_ALL);
error_reporting(E_ALL ^ E_DEPRECATED);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Bangkok');

define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');

/** Include PHPExcel */
require_once 'Classes/PHPExcel.php';


// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
							 ->setLastModifiedBy("Maarten Balliauw")
							 ->setTitle("PHPExcel Test Document")
							 ->setSubject("PHPExcel Test Document")
							 ->setDescription("Test document for PHPExcel, generated using PHP classes.")
							 ->setKeywords("office PHPExcel php")
							 ->setCategory("Test result file");


// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'เลขที่')
            ->setCellValue('B1', 'เลขประจำตัว')
            ->setCellValue('C1', 'ชื่อ-สกุล')
            ->setCellValue('D1', 'ชั้น')
            ->setCellValue('E1', 'คะแนนเต็ม')
            ->setCellValue('F1', 'สอบได้')
            ->setCellValue('G1', 'ร้อยละ')
            ->setCellValue('H1', 'ใช้เวลาสอบ')	
            ->setCellValue('I1', 'สอบเสร็จ');

// Miscellaneous glyphs, UTF-8
require 'configs/host.php';
$idsubject=$_GET["idsubject"];
mysql_query( "SET NAMES utf8");

$ql="SELECT
  `exp_users`.`user_email`,
  `exp_users`.`user_fullname`,
  `exp_users`.`user_class`,
  `exp_users`.`number_no`,  
  `exp_test_results`.`tr_correct_answer`,
  `exp_test_results`.`tr_exam_date`,
  `exp_test_results`.`tr_time_taken`,  
  `exp_test_results`.`tr_total_question`
FROM
  `exp_test_results`
INNER JOIN `exp_users`
ON `exp_users`.`user_id` = `exp_test_results`.`tr_user_id` where tr_subject_id='$idsubject' 
order by `exp_users`.`user_id`,`exp_users`.`user_class` ASC";
$qr=mysql_query($ql);
$row_num=mysql_num_rows($qr);
$i = 2;
while($rs = mysql_fetch_array($qr))
{
	$sum_sc=($rs['tr_correct_answer']*100)/$rs['tr_total_question'];
	$score_p=number_format($sum_sc, 2, '.', '');
	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, '="'.$rs['number_no'].'"');	
	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, '="'.$rs['user_email'].'"');
	$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $rs['user_fullname']);
	$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth('30');
	$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $rs['user_class']);
	$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $rs['tr_total_question']);
	$objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $rs['tr_correct_answer']);
	$objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $score_p.'%');
	$objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $rs['tr_time_taken']);	
	$objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $rs['tr_exam_date']);
	$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth('30');

	$i++;
}
mysql_close($cn);

// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('คะแนนสอบ');


// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);


// Save Excel 2007 file
$callStartTime = microtime(true);
/*
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
$callEndTime = microtime(true);
$callTime = $callEndTime - $callStartTime;

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="exExcel.xlsx"');
header('Cache-Control: max-age=0');
*/
$today=date('dmY');
$file = "$today.xlsx";
header('Content-disposition: attachment; filename='.$file);
header('Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');
ob_end_clean();
ob_start();
flush(); 

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');

// Save Excel 95 file
/*
$callStartTime = microtime(true);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save(str_replace('.php', '.xls', __FILE__));
$callEndTime = microtime(true);
$callTime = $callEndTime - $callStartTime;
*/

?>