<?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);
		
		//Worksheet untuk Detail Barang
		$index 			= 	0;
		foreach ($laporan as $key) {
			$title = $key['TITLE'];
			
			if ($index==0) {
				$objPHPExcel->setActiveSheetIndex($index);
				$objPHPExcel->getActiveSheet()->setTitle("$title");
			} else {
				$objPHPExcel->createSheet();
				$objPHPExcel->setActiveSheetIndex($index);
				$objPHPExcel->getActiveSheet()->setTitle("$title");
			}
			
			//font
			$objPHPExcel->getDefaultStyle()
			->getFont()
			->setName("Calibri")
			->setSize(10);
			
			//MODEL PPH 22
			if ($key['JENIS']==1) {
				//heading
				$objPHPExcel->getActiveSheet()->setCellValue('A1', 'DAFTAR '.$title.'');
				$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Periode : ('.$tanggal_awal.' - '.$tanggal_akhir.')');
				
				//merge heading
				$objPHPExcel->getActiveSheet()->mergeCells("A1:O1");
				$objPHPExcel->getActiveSheet()->mergeCells("A2:O2");
				
				///font heading
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(15);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(14);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N4')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				
				//lebar kolom
				$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4);
				$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
				$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
				
				//Isi Tabel
				$objPHPExcel->getActiveSheet()->setCellValue('A4', 'No');
				$objPHPExcel->getActiveSheet()->setCellValue('B4', 'NPWP');
				$objPHPExcel->getActiveSheet()->setCellValue('C4', 'Alamat');
				$objPHPExcel->getActiveSheet()->setCellValue('D4', 'Tanggal Bayar');
				$objPHPExcel->getActiveSheet()->setCellValue('E4', 'NTPN');
				$objPHPExcel->getActiveSheet()->setCellValue('F4', 'ID BILLING');
				$objPHPExcel->getActiveSheet()->setCellValue('G4', 'BUKTI POTONG');
				$objPHPExcel->getActiveSheet()->setCellValue('H4', 'SP2D');
				$objPHPExcel->getActiveSheet()->setCellValue('I4', 'FP Keluaran');
				$objPHPExcel->getActiveSheet()->setCellValue('J4', 'Tanggal INV/FP');
				$objPHPExcel->getActiveSheet()->setCellValue('K4', 'No INV');
				$objPHPExcel->getActiveSheet()->setCellValue('L4', 'Nama Perusahaan');
				$objPHPExcel->getActiveSheet()->setCellValue('M4', 'DPP');
				$objPHPExcel->getActiveSheet()->setCellValue('N4', 'Tarif');
				$objPHPExcel->getActiveSheet()->setCellValue('O4', 'Subtotal');
				
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFill()->applyFromArray (
					array(
						'type'       => 'FILL_SOLID',
						'rotation'   => 0,
						'startcolor' => array(
							'rgb' => 'D6B4F4'
						),
						'endcolor'   => array(
							'argb' => 'FFFFFFFF'
						)
					)
				);
				
				$baris 	= 	5;
				$b		=	0;
				$nodat 	= 	1;
				$sel 	= 	'';
				$ntpn	=	NULL;
				$total	=	0;
				if ($key['DRPJ']!=NULL) {
					foreach ($key['DRPJ'] as $dat) {
						if ($ntpn==$dat['NTPN_RPJ'] AND $dat['NTPN_RPJ']!=NULL) {
							$b++;
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $dat['NILAI_PPH']);
							$subtotal = round(($dat['DPP_DRPJ']*$dat['RATE_PPH']),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							$ntpn = $dat['NTPN_RPJ'];
						} else {
							if ($b > 0) {
								$bb = $baris-1;
								$bar = $bb-$b;
			
								//merge heading
								$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('F'.$bar.':F'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('G'.$bar.':G'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('H'.$bar.':H'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('L'.$bar.':L'.$bb);
								
							}
							$b = 0;
							$objPHPExcel->getActiveSheet()->setCellValue('A'.$baris, $nodat++);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['NPWP_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('C'.$baris, $dat['ALAMAT_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('D'.$baris, $dat['TGLRPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('E'.$baris, $dat['NTPN_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('F'.$baris, $dat['BILLING_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('G'.$baris, $dat['BUPOT_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('H'.$baris, $dat['SP2D_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('L'.$baris, $dat['NAMA_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $dat['NILAI_PPH']);
							$subtotal = round(($dat['DPP_DRPJ']*$dat['RATE_PPH']),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							
							$ntpn = $dat['NTPN_RPJ'];
						}
						
						if ($dat['STATUS_RPJ']==0) {
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris.':H'.$baris)->getFill()->applyFromArray (
								array(
									'type'       => 'FILL_SOLID',
									'rotation'   => 0,
									'startcolor' => array(
										'rgb' => 'ed574c'
									),
									'endcolor'   => array(
										'argb' => 'FFFFFFFF'
									)
								)
							);
							$objPHPExcel->getActiveSheet()->mergeCells('B'.$baris.':H'.$baris);
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->getColor()->setRGB('FFFFFF');
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->setBold(true);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['VOID_RPJ']);
						}
						
						$sel='O'.$baris;
						$baris++;
					}
					
					$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
					
					//$bb = $baris - 1;
					//$bar = $bb - $b;
					//
					////merge heading
					//$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('F'.$bar.':F'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('J'.$bar.':J'.$bb);
					
					//Subtotal
					$total = number_format($total, 2);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setSize(12);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setBold(true);
					$objPHPExcel->getActiveSheet()->mergeCells('M'.$baris.':N'.$baris);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris)->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
					$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, "TOTAL");
					$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, "$total");
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFill()->applyFromArray (
						array(
							'type'       => 'FILL_SOLID',
							'rotation'   => 0,
							'startcolor' => array(
								'rgb' => 'c0d6e4'
							),
							'endcolor'   => array(
								'argb' => 'FFFFFFFF'
							)
						)
					);
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
				}
				$objPHPExcel->getActiveSheet()->freezePane('A5');
			//MODEL PPH 23
			} else if ($key['JENIS']==2) {
				//heading
				$objPHPExcel->getActiveSheet()->setCellValue('A1', 'DAFTAR '.$title.'');
				$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Periode : ('.$tanggal_awal.' - '.$tanggal_akhir.')');
				
				//merge heading
				$objPHPExcel->getActiveSheet()->mergeCells("A1:O1");
				$objPHPExcel->getActiveSheet()->mergeCells("A2:O2");
				
				///font heading
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(15);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(14);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N4')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				
				//lebar kolom
				$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4);
				$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
				$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
				
				//Isi Tabel
				$objPHPExcel->getActiveSheet()->setCellValue('A4', 'No');
				$objPHPExcel->getActiveSheet()->setCellValue('B4', 'NPWP');
				$objPHPExcel->getActiveSheet()->setCellValue('C4', 'Alamat');
				$objPHPExcel->getActiveSheet()->setCellValue('D4', 'Tanggal Bayar');
				$objPHPExcel->getActiveSheet()->setCellValue('E4', 'NTPN');
				$objPHPExcel->getActiveSheet()->setCellValue('F4', 'ID BILLING');
				$objPHPExcel->getActiveSheet()->setCellValue('G4', 'BUKTI POTONG');
				$objPHPExcel->getActiveSheet()->setCellValue('H4', 'SP2D');
				$objPHPExcel->getActiveSheet()->setCellValue('I4', 'FP Keluaran');
				$objPHPExcel->getActiveSheet()->setCellValue('J4', 'Tanggal INV/FP');
				$objPHPExcel->getActiveSheet()->setCellValue('K4', 'No INV');
				$objPHPExcel->getActiveSheet()->setCellValue('L4', 'Nama Perusahaan');
				$objPHPExcel->getActiveSheet()->setCellValue('M4', 'DPP');
				$objPHPExcel->getActiveSheet()->setCellValue('N4', 'Tarif');
				$objPHPExcel->getActiveSheet()->setCellValue('O4', 'Subtotal');
				
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFill()->applyFromArray (
					array(
						'type'       => 'FILL_SOLID',
						'rotation'   => 0,
						'startcolor' => array(
							'rgb' => 'D6B4F4'
						),
						'endcolor'   => array(
							'argb' => 'FFFFFFFF'
						)
					)
				);
				
				$baris 	= 	5;
				$b		=	0;
				$nodat 	= 	1;
				$sel 	= 	'';
				$bupot	=	NULL;
				$total	=	0;
				if ($key['DRPJ']!=NULL) {
					foreach ($key['DRPJ'] as $dat) {
						if ($bupot==$dat['BUPOT_RPJ'] AND $dat['BUPOT_RPJ']!=NULL) {
							$b++;
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $dat['NILAI_PPH']);
							$subtotal = round(($dat['DPP_DRPJ']*$dat['RATE_PPH']),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							
							$bupot = $dat['BUPOT_RPJ'];
						} else {
							if ($b > 0) {
								$bb = $baris-1;
								$bar = $bb-$b;
			
								//merge heading
								$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('F'.$bar.':F'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('G'.$bar.':G'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('H'.$bar.':H'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('L'.$bar.':L'.$bb);
								
							}
							$b = 0;
							$objPHPExcel->getActiveSheet()->setCellValue('A'.$baris, $nodat++);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['NPWP_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('C'.$baris, $dat['ALAMAT_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('D'.$baris, $dat['TGLRPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('E'.$baris, $dat['NTPN_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('F'.$baris, $dat['BILLING_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('G'.$baris, $dat['BUPOT_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('H'.$baris, $dat['SP2D_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('L'.$baris, $dat['NAMA_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $dat['NILAI_PPH']);
							$subtotal = round(($dat['DPP_DRPJ']*$dat['RATE_PPH']),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							
							$bupot = $dat['BUPOT_RPJ'];
						}
						
						if ($dat['STATUS_RPJ']==0) {
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFill()->applyFromArray (
								array(
									'type'       => 'FILL_SOLID',
									'rotation'   => 0,
									'startcolor' => array(
										'rgb' => 'ed574c'
									),
									'endcolor'   => array(
										'argb' => 'FFFFFFFF'
									)
								)
							);
							$objPHPExcel->getActiveSheet()->mergeCells('B'.$baris.':H'.$baris);
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->getColor()->setRGB('FFFFFF');
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->setBold(true);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['VOID_RPJ']);
						}
						
						$sel='O'.$baris;
						$baris++;
					}
					
					$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
					
					//$bb = $baris - 1;
					//$bar = $bb - $b;
					//
					////merge heading
					//$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('I'.$bar.':I'.$bb);
					
					//Subtotal
					$total = number_format($total, 2);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setSize(12);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setBold(true);
					$objPHPExcel->getActiveSheet()->mergeCells('M'.$baris.':N'.$baris);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris)->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
					$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, "TOTAL");
					$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, "$total");
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFill()->applyFromArray (
						array(
							'type'       => 'FILL_SOLID',
							'rotation'   => 0,
							'startcolor' => array(
								'rgb' => 'c0d6e4'
							),
							'endcolor'   => array(
								'argb' => 'FFFFFFFF'
							)
						)
					);
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
				}
				$objPHPExcel->getActiveSheet()->freezePane('A5');
			//MODEL PPN
			} else if ($key['JENIS']==3) {
				//heading
				$objPHPExcel->getActiveSheet()->setCellValue('A1', 'DAFTAR '.$title.'');
				$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Periode : ('.$tanggal_awal.' - '.$tanggal_akhir.')');
				
				//merge heading
				$objPHPExcel->getActiveSheet()->mergeCells("A1:O1");
				$objPHPExcel->getActiveSheet()->mergeCells("A2:O2");
				
				///font heading
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(15);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(14);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N4')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O4')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setWrapText(true);
				$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
				$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
				
				//lebar kolom
				$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4);
				$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
				$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
				
				//Isi Tabel
				$objPHPExcel->getActiveSheet()->setCellValue('A4', 'No');
				$objPHPExcel->getActiveSheet()->setCellValue('B4', 'NPWP');
				$objPHPExcel->getActiveSheet()->setCellValue('C4', 'Alamat');
				$objPHPExcel->getActiveSheet()->setCellValue('D4', 'Tanggal Bayar');
				$objPHPExcel->getActiveSheet()->setCellValue('E4', 'NTPN');
				$objPHPExcel->getActiveSheet()->setCellValue('F4', 'ID BILLING');
				$objPHPExcel->getActiveSheet()->setCellValue('G4', 'BUKTI POTONG');
				$objPHPExcel->getActiveSheet()->setCellValue('H4', 'SP2D');
				$objPHPExcel->getActiveSheet()->setCellValue('I4', 'FP Keluaran');
				$objPHPExcel->getActiveSheet()->setCellValue('J4', 'Tanggal INV/FP');
				$objPHPExcel->getActiveSheet()->setCellValue('K4', 'No INV');
				$objPHPExcel->getActiveSheet()->setCellValue('L4', 'Nama Perusahaan');
				$objPHPExcel->getActiveSheet()->setCellValue('M4', 'DPP');
				$objPHPExcel->getActiveSheet()->setCellValue('N4', 'Tarif');
				$objPHPExcel->getActiveSheet()->setCellValue('O4', 'Subtotal');
				
				$objPHPExcel->getActiveSheet()->getStyle('A4:O4')->getFill()->applyFromArray (
					array(
						'type'       => 'FILL_SOLID',
						'rotation'   => 0,
						'startcolor' => array(
							'rgb' => 'D6B4F4'
						),
						'endcolor'   => array(
							'argb' => 'FFFFFFFF'
						)
					)
				);
				
				$baris 	= 	5;
				$b		=	0;
				$nodat 	= 	1;
				$sel 	= 	'';
				$ntpn	=	NULL;
				$total	=	0;
				if ($key['DRPJ']!=NULL) {
					foreach ($key['DRPJ'] as $dat) {
						if ($ntpn==$dat['NTPN_RPJ'] AND $dat['NTPN_RPJ']!=NULL) {
							$b++;
							
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$ppn = round($dat['PPN_SO']); $ppn = "$ppn %";
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $ppn);
							$subtotal = round(($dat['DPP_DRPJ']*($dat['PPN_SO']/100)),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							
							$ntpn = $dat['NTPN_RPJ'];
						} else {
							if ($b > 0) {
								$bb = $baris-1;
								$bar = $bb-$b;
			
								//merge heading
								$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('F'.$bar.':F'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('G'.$bar.':G'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('H'.$bar.':H'.$bb);
								$objPHPExcel->getActiveSheet()->mergeCells('L'.$bar.':L'.$bb);
								
							}
							$b = 0;
							$objPHPExcel->getActiveSheet()->setCellValue('A'.$baris, $nodat++);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['NPWP_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('C'.$baris, $dat['ALAMAT_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('D'.$baris, $dat['TGLRPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('E'.$baris, $dat['NTPN_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('F'.$baris, $dat['BILLING_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('G'.$baris, $dat['BUPOT_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('H'.$baris, $dat['SP2D_RPJ']);
							$objPHPExcel->getActiveSheet()->setCellValue('I'.$baris, $dat['FP_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('J'.$baris, $dat['TGLJUAL']);
							$objPHPExcel->getActiveSheet()->setCellValue('K'.$baris, $dat['INV_PENJUALAN']);
							$objPHPExcel->getActiveSheet()->setCellValue('L'.$baris, $dat['NAMA_WAJIBPAJAK']);
							$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, $dat['DPP']);
							$ppn = round($dat['PPN_SO'],0); $ppn = "$ppn %";
							$objPHPExcel->getActiveSheet()->setCellValue('N'.$baris, $ppn);
							$subtotal = round(($dat['DPP_DRPJ']*($dat['PPN_SO']/100)),2); $total = $total+$subtotal; $subtotal = number_format($subtotal,2);
							$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, $subtotal);
							
							$ntpn = $dat['NTPN_RPJ'];
						}
						
						if ($dat['STATUS_RPJ']==0) {
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris.':H'.$baris)->getFill()->applyFromArray (
								array(
									'type'       => 'FILL_SOLID',
									'rotation'   => 0,
									'startcolor' => array(
										'rgb' => 'ed574c'
									),
									'endcolor'   => array(
										'argb' => 'FFFFFFFF'
									)
								)
							);
							$objPHPExcel->getActiveSheet()->mergeCells('B'.$baris.':H'.$baris);
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->getColor()->setRGB('FFFFFF');
							$objPHPExcel->getActiveSheet()->getStyle('B'.$baris)->getFont()->setBold(true);
							$objPHPExcel->getActiveSheet()->setCellValue('B'.$baris, $dat['VOID_RPJ']);
						}
						
						$sel='O'.$baris;
						$baris++;
					}
					
					$objPHPExcel->getActiveSheet()->getStyle('A4:'.$sel)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
					
					//$bb = $baris - 1;
					//$bar = $bb - $b;
					//
					////merge heading
					//$objPHPExcel->getActiveSheet()->mergeCells('A'.$bar.':A'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('B'.$bar.':B'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('C'.$bar.':C'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('D'.$bar.':D'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('E'.$bar.':E'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('F'.$bar.':F'.$bb);
					//$objPHPExcel->getActiveSheet()->mergeCells('J'.$bar.':J'.$bb);
					
					//Subtotal
					$total = number_format($total, 2);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setSize(12);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFont()->setBold(true);
					$objPHPExcel->getActiveSheet()->mergeCells('M'.$baris.':N'.$baris);
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris)->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
					$objPHPExcel->getActiveSheet()->setCellValue('M'.$baris, "TOTAL");
					$objPHPExcel->getActiveSheet()->setCellValue('O'.$baris, "$total");
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getFill()->applyFromArray (
						array(
							'type'       => 'FILL_SOLID',
							'rotation'   => 0,
							'startcolor' => array(
								'rgb' => 'c0d6e4'
							),
							'endcolor'   => array(
								'argb' => 'FFFFFFFF'
							)
						)
					);
					
					$objPHPExcel->getActiveSheet()->getStyle('M'.$baris.':O'.$baris)->getBorders()->applyFromArray(
						array(
							'allborders' => array(
								'style' => PHPExcel_Style_Border::BORDER_THIN,
								'color' => array(
									'rgb' => '000000'
								)
							)
						)
					);
				}
				$objPHPExcel->getActiveSheet()->freezePane('A5');
			}
			
			$index++;
		}
		
		$objPHPExcel->setActiveSheetIndex(0);
		
		$filename = "Rekap Pajak Periode ".$tanggal_awal." s.d ".$tanggal_akhir." - ". $subtitle. '.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();

?>