<?php
	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);
		$objPHPExcel->getActiveSheet()->setTitle("Rekap $nama_pab");
		
		$this->load->model('AllModels', 'Amod');
	
		//font utama
		$objPHPExcel->getDefaultStyle()->getFont()->setName("Calibri")->setSize(11);

		//heading
		$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Rekap Absensi ('.$nama_pab.')');
		$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Periode : ['.$awal.' - '.$akhir.']');
		
		//font heading
		$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(15);
		$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(13);
		$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(32);
		
		//font style 
		$objPHPExcel->getActiveSheet()->setCellValue('A4', 'NO');
		$objPHPExcel->getActiveSheet()->setCellValue('B4', 'NAMA');
		
		$codiff = 0;
		if ($diff>=1) {
			$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('C4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='C4';
		}
		if ($diff>=2) {
			$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('D4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='D4';
		}
		if ($diff>=3) {
			$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('E4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='E4';
		}
		if ($diff>=4) {
			$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('F4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='F4';
		}
		if ($diff>=5) {
			$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('G4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='G4';
		}
		if ($diff>=6) {
			$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('H4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='H4';
		}
		if ($diff>=7) {
			$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('I4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='I4';
		}
		if ($diff>=8) {
			$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('J4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='J4';
		}
		if ($diff>=9) {
			$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('K4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='K4';
		}
		if ($diff>=10) {
			$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('L4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='L4';
		}
		if ($diff>=11) {
			$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('M4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='M4';
		}
		if ($diff>=12) {
			$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('N4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='N4';
		}
		if ($diff>=13) {
			$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('O4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='O4';
		}
		if ($diff>=14) {
			$objPHPExcel->getActiveSheet()->getStyle('P')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('P4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='P4';
		}
		if ($diff>=15) {
			$objPHPExcel->getActiveSheet()->getStyle('Q')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('Q4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='Q4';
		}
		if ($diff>=16) {
			$objPHPExcel->getActiveSheet()->getStyle('R')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('R4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='R4';
		}
		if ($diff>=17) {
			$objPHPExcel->getActiveSheet()->getStyle('S')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('S4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='S4';
		}
		if ($diff>=18) {
			$objPHPExcel->getActiveSheet()->getStyle('T')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('T4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='T4';
		}
		if ($diff>=19) {
			$objPHPExcel->getActiveSheet()->getStyle('U')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('U4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='U4';
		}
		if ($diff>=20) {
			$objPHPExcel->getActiveSheet()->getStyle('V')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('V4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='V4';
		}
		if ($diff>=21) {
			$objPHPExcel->getActiveSheet()->getStyle('W')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('W4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='W4';
		}
		if ($diff>=22) {
			$objPHPExcel->getActiveSheet()->getStyle('X')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('X4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='X4';
		}
		if ($diff>=23) {
			$objPHPExcel->getActiveSheet()->getStyle('Y')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('Y4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='Y4';
		}
		if ($diff>=24) {
			$objPHPExcel->getActiveSheet()->getStyle('Z')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('Z4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='Z4';
		}
		if ($diff>=25) {
			$objPHPExcel->getActiveSheet()->getStyle('AA')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AA4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AA4';
		}
		if ($diff>=26) {
			$objPHPExcel->getActiveSheet()->getStyle('AB')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AB4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AB4';
		}
		if ($diff>=27) {
			$objPHPExcel->getActiveSheet()->getStyle('AC')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AC4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AC4';
		}
		if ($diff>=28) {
			$objPHPExcel->getActiveSheet()->getStyle('AD')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AD4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AD4';
		}
		if ($diff>=29) {
			$objPHPExcel->getActiveSheet()->getStyle('AE')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AE4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AE4';
		}
		if ($diff>=30) {
			$objPHPExcel->getActiveSheet()->getStyle('AF')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AF4', $laporan[0]['REKAPALL'][$codiff++]['TANGGAL']);
			$sel='AF4';
		}
		
		$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getFont()->setSize(12);
		$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getFont()->setBold(true);
	
		$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getFill()->applyFromArray (
			array(
				'type'       => 'FILL_SOLID',
				'rotation'   => 0,
				'startcolor' => array(
					'rgb' => 'c0c0bf'
				),
				'endcolor'   => array(
					'argb' => 'FFFFFFFF'
				)
			)
		);
		
		//Terlambat, Cuti, Izin, Libur
		if ($diff==20) {
			$objPHPExcel->getActiveSheet()->getStyle('W:Z')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('W4:Z4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('W4:Z4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('W4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('X4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('Y4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('Z4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('W4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('X4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('Y4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('Z4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==21) {
			$objPHPExcel->getActiveSheet()->getStyle('X:AA')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('X4:AA4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('X4:AA4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('X4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('Y4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('Z4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AA4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('X4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('Y4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('Z4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==22) {
			$objPHPExcel->getActiveSheet()->getStyle('Y:AB')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('Y4:AB4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('Y4:AB4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('Y4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('Z4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AA4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AB4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('Y4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('Z4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AB4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==23) {
			$objPHPExcel->getActiveSheet()->getStyle('Z:AC')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('Z4:AC4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('Z4:AC4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('Z4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AA4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AB4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AC4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('Z4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AB4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AC4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==24) {
			$objPHPExcel->getActiveSheet()->getStyle('AA:AD')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AA4:AD4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AA4:AD4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AA4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AB4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AC4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AD4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AB4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AC4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AD4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==25) {
			$objPHPExcel->getActiveSheet()->getStyle('AB:AE')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AB4:AE4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AB4:AE4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AB4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AC4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AD4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AE4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AB4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AC4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AD4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AE4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==26) {
			$objPHPExcel->getActiveSheet()->getStyle('AC:AF')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AC4:AF4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AC4:AF4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AC4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AD4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AE4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AF4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AC4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AD4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AE4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AF4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==27) {
			$objPHPExcel->getActiveSheet()->getStyle('AD:AG')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AD4:AG4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AD4:AG4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AD4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AE4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AF4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AG4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AD4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AE4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AF4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AG4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==28) {
			$objPHPExcel->getActiveSheet()->getStyle('AE:AH')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AE4:AH4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AE4:AH4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AE4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AF4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AG4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AH4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AE4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AF4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AG4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AH4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==29) {
			$objPHPExcel->getActiveSheet()->getStyle('AF:AI')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AF4:AI4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AF4:AI4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AF4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AG4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AH4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AI4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AF4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AG4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AH4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AI4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		} else if ($diff==30) {
			$objPHPExcel->getActiveSheet()->getStyle('AG:AJ')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
			$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setAutoSize(true);
			$objPHPExcel->getActiveSheet()->getStyle('AG4:AJ4')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle('AG4:AJ4')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->setCellValue('AG4', 'TELAT');
			$objPHPExcel->getActiveSheet()->setCellValue('AH4', 'CUTI');
			$objPHPExcel->getActiveSheet()->setCellValue('AI4', 'SAKIT');
			$objPHPExcel->getActiveSheet()->setCellValue('AJ4', 'TIDAK MASUK');
			$objPHPExcel->getActiveSheet()->getStyle('AG4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F57C7C'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AH4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => '6FA8DC'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AI4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F6B26B'
					)
				)
			);
			$objPHPExcel->getActiveSheet()->getStyle('AJ4')->getFill()->applyFromArray (
				array(
					'type'       => 'FILL_SOLID',
					'rotation'   => 0,
					'startcolor' => array(
						'rgb' => 'F3CFEF'
					)
				)
			);
		}
		
		//Data Absensi
		$baris 		= 	5;
		$no 		= 	1;
		$nola		=	0;
		$nore		=	0;
		$codiff 	= 	0;
		$sel 		= 	'';
		
		if ($karyawan != null) {
			if (is_array($karyawan) || is_object($karyawan)) {
				foreach ($karyawan as $key) {
					$objPHPExcel->getActiveSheet()->setCellValue('A'.$baris, $no++);
					$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $key['NAMA_PANGGILAN_KARYAWAN']);
					//Set Data di Setiap Harinya
					if ($diff>=1) {
						$sel='C'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' 	=> $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=2) {
						$sel='D'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=3) {
						$sel='E'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=4) {
						$sel='F'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=5) {
						$sel='G'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=6) {
						$sel='H'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=7) {
						$sel='I'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=8) {
						$sel='J'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=9) {
						$sel='K'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=10) {
						$sel='L'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=11) {
						$sel='M'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=12) {
						$sel='N'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=13) {
						$sel='O'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=14) {
						$sel='P'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=15) {
						$sel='Q'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=16) {
						$sel='R'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=17) {
						$sel='S'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=18) {
						$sel='T'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=19) {
						$sel='U'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=20) {
						$sel='V'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=21) {
						$sel='W'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=22) {
						$sel='X'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=23) {
						$sel='Y'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=24) {
						$sel='Z'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=25) {
						$sel='AA'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=26) {
						$sel='AB'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=27) {
						$sel='AC'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=28) {
						$sel='AD'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=29) {
						$sel='AE'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					if ($diff>=30) {
						$sel='AF'.$baris;
						$set = $this->Amod->getStatus_byTELAT($laporan[$nola]['REKAPALL'][$nore]['TELAT'], $sel);
						$objPHPExcel->getActiveSheet()->setCellValue($sel, $set['STAT']);
						$objPHPExcel->getActiveSheet()->getStyle($sel)->getFill()->applyFromArray(
							array(
								'type'       => 'FILL_SOLID',
								'rotation'   => 0,
								'startcolor' => array(
									'rgb' => $set['FILL']
								),
							)
						);
						$nore++;
					}
					//Set Total Terlambat, Cuti, Sakit, Libur, Tidak Masuk 
					if ($diff==20) {
						$objPHPExcel->getActiveSheet()->setCellValue('W'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('X'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('Y'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('Z'.$baris, $laporan[$nola]['COUNT8']);
						$sel='Z'.$baris;
					} else if ($diff==21) {
						$objPHPExcel->getActiveSheet()->setCellValue('X'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('Y'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('Z'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AA'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AA'.$baris;
					} else if ($diff==22) {
						$objPHPExcel->getActiveSheet()->setCellValue('Y'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('Z'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AA'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AB'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AB'.$baris;
					} else if ($diff==23) {
						$objPHPExcel->getActiveSheet()->setCellValue('Z'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AA'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AB'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AC'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AC'.$baris;
					} else if ($diff==24) {
						$objPHPExcel->getActiveSheet()->setCellValue('AA'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AB'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AC'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AD'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AD'.$baris;
					} else if ($diff==25) {
						$objPHPExcel->getActiveSheet()->setCellValue('AB'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AC'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AD'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AE'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AE'.$baris;
					} else if ($diff==26) {
						$objPHPExcel->getActiveSheet()->setCellValue('AC'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AD'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AE'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AF'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AF'.$baris;
					} else if ($diff==27) {
						$objPHPExcel->getActiveSheet()->setCellValue('AD'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AE'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AF'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AG'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AG'.$baris;
					} else if ($diff==28) {
						$objPHPExcel->getActiveSheet()->setCellValue('AE'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AF'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AG'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AH'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AH'.$baris;
					} else if ($diff==29) {
						$objPHPExcel->getActiveSheet()->setCellValue('AF'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AG'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AH'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AI'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AI'.$baris;
					} else if ($diff==30) {
						$objPHPExcel->getActiveSheet()->setCellValue('AG'.$baris, $laporan[$nola]['COUNT2']);
						$objPHPExcel->getActiveSheet()->setCellValue('AH'.$baris, $laporan[$nola]['COUNT3']);
						$objPHPExcel->getActiveSheet()->setCellValue('AI'.$baris, $laporan[$nola]['COUNT4']);
						$objPHPExcel->getActiveSheet()->setCellValue('AJ'.$baris, $laporan[$nola]['COUNT8']);
						$sel='AJ'.$baris;
					}
					
					$baris++;
					$nola++;
					$nore = 0; 
				}
			}
			
			$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getBorders()->applyFromArray(
	            array(
	                'allborders' => array(
	                    'style' => PHPExcel_Style_Border::BORDER_THIN,
	                    'color' => array(
	                        'rgb' => '000000'
	                    )
	                )
	            )
	      	);
		}
		
		$objPHPExcel->getActiveSheet()->freezePane('C5');
		
		$filename = "Laporan Absensi Periode " .$nama_pab. '.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();

?>