abel/shopee-apps
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
shopee-apps/application/views/cetak/notused/excel_rekappajak.php
T
abel db327c0305 copy dari repo om Irfan
2026-06-13 16:02:07 +10:00

727 lines
39 KiB
PHP
Raw Permalink Blame History

<?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();
?>
Reference in New Issue View Git Blame Copy Permalink