<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel.php');
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');

use PHPExcel\Style\PHPExcel_Style_Alignment;
use PHPExcel\Style\PHPExcel_Style_Fill;

$objPHPExcel = new PHPExcel();

$objPHPExcel->getProperties()->setCreator("PC Master");
$objPHPExcel->getProperties()->setLastModifiedBy("PC Master");
$objPHPExcel->getProperties()->setTitle("Laporan");
$objPHPExcel->getProperties()->setSubject("");
$objPHPExcel->getProperties()->setDescription("");

$objPHPExcel->setActiveSheetIndex(0);

/////// font
$objPHPExcel->getDefaultStyle()
	->getFont()
	->setName("Calibri")
	->setSize(11);

//////heading
// $objPHPExcel->getActiveSheet()->setCellValue('A1', '26 ' . $bln_awal . ' ' . $tahun_awal . ' Sampai 25 ' . $bln_akhir . ' ' . $tahun_akhir);

//merge heading
$objPHPExcel->getActiveSheet()->mergeCells("A1:G1");

///font heading
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20);

//set cell alignment
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal('')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal('')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal('')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal('')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A3:G3')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');


//lebar kolom
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(6);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(40);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(9);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(14);

//font style 
$objPHPExcel->getActiveSheet()->getStyle('A3:G3')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A3:G3')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A3', 'NO');
$objPHPExcel->getActiveSheet()->setCellValue('B3', 'NAMA KARYAWAN');
$objPHPExcel->getActiveSheet()->setCellValue('C3', 'TANGGAL');
$objPHPExcel->getActiveSheet()->setCellValue('D3', 'JAM MASUK');
$objPHPExcel->getActiveSheet()->setCellValue('E3', 'JAM KELUAR');
$objPHPExcel->getActiveSheet()->setCellValue('F3', 'TELAT');
$objPHPExcel->getActiveSheet()->setCellValue('G3', 'TOTAL TELAT');

// $objPHPExcel->getActiveSheet()->getStyle('A3:I3')->getFill()->setFillType('FILL_SOLID');
// $objPHPExcel->getActiveSheet()->getStyle('A3:I3')->getFill()->set
$objPHPExcel->getActiveSheet()->getStyle('A3:G3')->getFill()->applyFromArray(
	array(
		'type'       => 'FILL_SOLID',
		'rotation'   => 0,
		'startcolor' => array(
			'rgb' => 'c0c0bf'
		),
		'endcolor'   => array(
			'argb' => 'FFFFFFFF'
		)
	)
);


// Set password for readonly activesheet
// $objPHPExcel->getSecurity()->setLockWindows(true);
// $objPHPExcel->getSecurity()->setLockStructure(true);
// $objPHPExcel->getSecurity()->setWorkbookPassword($pass);

// Set password for readonly data
// $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
// $objPHPExcel->getActiveSheet()->getProtection()->setPassword($pass);


// $filename = "Absensi 26 " . $bln_awal . " " . $tahun_awal . " s.d 25 " . $bln_akhir . " " . $tahun_akhir . '.xlsx';
// $filename = "sfkjdhjaopjd.xlsx";

// // header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
// // header('Content-Disposition: attachment;filename="sfkjdhjaopjd.xlsx"');
// // header('Cache-Control: max-age=0');
// $file = "abc.xlsx";

// header('Content-Description: File Transfer');
// header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
// header('Content-Disposition: attachment; filename=' . basename($file));
// header('Content-Transfer-Encoding: binary');
// header('Expires: 0');
// header('Cache-Control: must-revalidate');
// header('Pragma: public');
// header('Content-Length: ' . filesize($file));
// ob_clean();
// flush();
// readfile($file);
// $objWriter = PHPExcel_IOFactory::createwriter($objPHPExcel, 'Excel2007');
// $objWriter->save('php://output');
// $objWriter->save(str_replace('.php', '.xlsx', __FILE__));

$test = "0";
//$filename = "Master Supplier Periode.xlsx";
$filename = "Laporan Analisa Pembelian s.d " . $test . '.xlsx';

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');

header('Cache-Control: max-age=0');

$writer = PHPExcel_IOFactory::createwriter($objPHPExcel, 'Excel2007');
$writer->save('php://output');
exit();