1193 lines
60 KiB
PHP
1193 lines
60 KiB
PHP
<?php
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', TRUE);
|
|
ini_set('display_startup_errors', TRUE);
|
|
date_default_timezone_set('Europe/London');
|
|
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel.php');
|
|
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');
|
|
|
|
use PHPExcel\Style\PHPExcel_Style_Alignment;
|
|
use PHPExcel\Style\PHPExcel_Style_Fill;
|
|
|
|
$objPHPExcel = new PHPExcel();
|
|
|
|
$objPHPExcel->getProperties()->setCreator("PC Master");
|
|
$objPHPExcel->getProperties()->setLastModifiedBy("PC Master");
|
|
$objPHPExcel->getProperties()->setTitle("Laporan");
|
|
$objPHPExcel->getProperties()->setSubject("");
|
|
$objPHPExcel->getProperties()->setDescription("");
|
|
$objPHPExcel->setActiveSheetIndex(0);
|
|
|
|
// font
|
|
$objPHPExcel->getDefaultStyle()
|
|
->getFont()
|
|
->setName("Calibri")
|
|
->setSize(12);
|
|
|
|
//heading
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'PT. TRIPERWIRA MULTI PAMENANG');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN NERACA');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A3', $nama_pak);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A5', 'AKTIVA LANCAR');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D5', 'KEWAJIBAN LANCAR');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A15', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D15', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A16', 'AKTIVA TETAP');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D16', 'MODAL');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A20', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D20', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A21', 'TOTAL AKTIVA '.$totalAktiva);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D21', 'TOTAL PASIVA '.$totalPasiva);
|
|
|
|
//merge heading
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A1:F1");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A2:F2");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A3:F3");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A4:F4");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A5:C5");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("D5:F5");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A15:B15");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("D15:E15");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A16:C16");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("D16:F16");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A20:B20");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("D20:E20");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A21:C21");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("D21:F21");
|
|
|
|
///font heading
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A3')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A15')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('C15')->getFont()->setSize(14);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D15')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('F15')->getFont()->setSize(14);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('C20')->getFont()->setSize(14);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D20')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('F20')->getFont()->setSize(14);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D21')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A3')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A15:C15')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D15:F15')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20:C20')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D20:F20')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21:F21')->getFont()->setBold(true);
|
|
|
|
//set cell alignment
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:C5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D5:F5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C6:C14')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('F6:F14')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A15')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C15')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D15')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('F15')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:C16')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D16:F16')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C17:C19')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('F17:F19')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C20')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D20')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('F20')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D21')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
|
|
|
|
//lebar kolom
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(35);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(4);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(35);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
|
|
|
|
//font style
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:F16')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:F16')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5')->getFont()->getColor()->setRGB('0984f4');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D5')->getFont()->getColor()->setRGB('EC1A0A');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16')->getFont()->getColor()->setRGB('0984f4');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D16')->getFont()->getColor()->setRGB('EC1A0A');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21')->getFont()->getColor()->setRGB('0984f4');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D21')->getFont()->getColor()->setRGB('EC1A0A');
|
|
|
|
//Isi Data Neraca
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A6', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A7', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A8', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A9', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A10', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A11', '6');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A12', '7');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A13', '8');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A14', '9');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B6', 'Kas dan Setara Kas');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B7', 'Bank');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B8', 'Piutang Dagang');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B9', 'Persediaan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B10', 'Piutang Karyawan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B11', 'Piutang Pihak Ke3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B12', 'Uang Muka Pembelian');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B13', 'Pajak Dibayar Dimuka');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B14', 'PPN Lebih Bayar');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C6', $al01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C7', $al02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C8', $al03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C9', $al04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C10', $al05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C11', $al06);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C12', $al07);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C13', $al08);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C14', $al09);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D6', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D7', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D8', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D9', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D10', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D11', '6');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E6', 'Hutang Dagang');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E7', 'Hutang Pajak');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E8', 'Hutang Bank');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E9', 'Hutang Aktiva');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E10', 'Uang Muka Penjualan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E11', 'PPN Kurang Bayar');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F6', $kl01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F7', $kl02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F8', $kl03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F9', $kl04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F10', $kl05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F11', $kl06);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C15', $aktivaLancar);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F15', $kewajibanLancar);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A17', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A18', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A19', '3');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B17', 'Total Nilai Sisa Buku Inventaris Ktr');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B18', 'Total Nilai Sisa Buku Gedung Bangunan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B19', 'Total Nilai Sisa Buku Kendaraan');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C17', $at01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C18', $at02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C19', $at03);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D17', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D18', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D19', '3');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E17', 'Modal');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E18', 'Akumulasi Laba Ditahan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('E19', 'Laba Th. Berjalan');
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F17', $mo01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F18', $mo02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F19', $mo03);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C20', $aktivaTetap);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F20', $modalNeraca);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'EEEEEE'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:F16')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'EEEEEE'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F21')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->setTitle("Laporan Neraca");
|
|
|
|
//New Sheet
|
|
$objPHPExcel->createSheet();
|
|
$objPHPExcel->setActiveSheetIndex(1);
|
|
$objPHPExcel->getActiveSheet()->setTitle("Laporan Laba Rugi");
|
|
|
|
// font
|
|
$objPHPExcel->getDefaultStyle()
|
|
->getFont()
|
|
->setName("Calibri")
|
|
->setSize(12);
|
|
|
|
//heading
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'PT. TRIPERWIRA MULTI PAMENANG');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN LABA RUGI');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A3', $nama_pak);
|
|
|
|
//merge heading
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A1:D1");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A2:D2");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A3:D3");
|
|
|
|
///font heading
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2:A3')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2:A3')->getFont()->setBold(true);
|
|
|
|
//set cell alignment
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1:A3')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C6:C100')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A6:B100')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D6:D100')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
|
|
//lebar kolom
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
|
|
|
|
//font Sela Antar Subtotal
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A5:D5");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A5', 'TOTAL PENJUALAN');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A9:B9')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A9:C9')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A9')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A9:B9");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A9')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A11:D11')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A11:D11')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A11')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A11:D11");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A11', 'HARGA POKOK PENJUALAN');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:B16')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16:C16')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A16:B16");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A16', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A16')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A18:B18')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A18:C18')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A18')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A18:B18");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A18', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20:B20')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20:C20')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A20')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A20:B20");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A20', 'LABA KOTOR');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21:B21')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21:C21')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A21')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A21:D21");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A21', '(Total Penjualan - Harga Pokok Penjualan)');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A23:D23')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A23:D23')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A23')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A23:D23");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A23', 'BIAYA PENJUALAN');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A31:B31')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A31:C31')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A31')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A31:B31");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A31', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A31')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A33:D33')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A33:D33')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A33')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A33:D33");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A33', 'BIAYA UMUM DAN ADMINISTRASI');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A73:B73')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A73:C73')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A73')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A73:B73");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A73', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A73')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A75:B75')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A75:C75')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A75')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A75:B75");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A75', 'TOTAL BIAYA');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A76:B76')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A76:C76')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A76')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A76:D76");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A76', '(Biaya Penjualan + Biaya Umum dan Administrasi)');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A78:B78')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A78:C78')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A78')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A78:B78");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A78', 'LABA USAHA');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A79:B79')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A79:C79')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A79')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A79:D79");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A79', '(Laba Kotor - Total Biaya)');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A81:D81')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A81:C81')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A81')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A81:D81");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A81', 'PENDAPATAN DAN (BEBAN) LUAR USAHA');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A84:B84')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A84:C84')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A84')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A84:B84");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A84', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A84')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A88:B88')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A88:C88')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A88')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A88:B88");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A88', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A88')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A90:B90')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A90:C90')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A90')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A90:B90");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A90', 'TOTAL PENDAPATAN DAN (BEBAN) LUAR USAHA');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A91:B91')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A91:C91')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A91')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A91:D91");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A91', '(Total Pendapatan Luar Usaha - Total Beban Luar Usaha)');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A93:B93')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A93:C93')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A93')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A93:B93");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A93', 'LABA BERSIH SEBELUM PAJAK');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A94:B94')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A94:C94')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A94')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A94:D94");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A94', '(Laba Usaha + Total Pendapatan Dan (Beban) Luar Usaha)');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A96:D96')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A96:C96')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A96')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A96:D96");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A96', 'PAJAK PENGHASILAN');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A98:B98')->getFont()->setSize(15);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A98:C98')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A98')->getFont()->getColor()->setRGB('5B5B5B');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A98:B98");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A98', 'Subtotal');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A98')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A100:C100')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A100:C100')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A100')->getFont()->getColor()->setRGB('4C9D3B');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C100')->getFont()->getColor()->setRGB('5703FF');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A100:B100");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A100', 'LABA BERSIH SETELAH PAJAK');
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A101:B101')->getFont()->setSize(12);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A101:C101')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A101')->getFont()->getColor()->setRGB('F44336');
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A101:D101");
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A101', '(Laba Bersih Sebelum Pajak - Pajak Penghasilan)');
|
|
|
|
//Isi Data Total Penjualan
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A6', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B6', 'PENJUALAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C6', $tp01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D6', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D6')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D6')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A7', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B7', 'RETUR PENJUALAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C7', $tp02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D7', '-');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D7')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D7')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A8', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B8', 'POTONGAN / DISKON PENJUALAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C8', $tp03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D8', '-');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D8')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D8')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C9', $totalPenjualan);
|
|
|
|
//Isi Data Harga Pokok Penjualan
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A12', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B12', 'PERSEDIAAN AWAL');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C12', $hpp01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D12', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D12')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D12')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A13', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B13', 'PEMBELIAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C13', $hpp02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D13', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A14', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B14', 'RETUR PEMBELIAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C14', $hpp03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D14', '-');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D14')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D14')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A15', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B15', 'POT. PEMBELIAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C15', $hpp04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D15', '-');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D15')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D15')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C16', $hargaPokokPenjualan1);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A17', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B17', 'PERSEDIAAN AKHIR');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C17', $hpp05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D17', '-');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D17')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D17')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C18', $hargaPokokPenjualan2);
|
|
|
|
//Isi Data Laba Kotor
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C20', $labaKotor);
|
|
|
|
//Isi Data Biaya Penjualan
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A24', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B24', 'Biaya Operasional');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C24', $bp01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D24', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D24')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D24')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A25', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B25', 'Biaya Pengiriman');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C25', $bp02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D25', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D25')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D25')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A26', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B26', 'Biaya Service Kendaraan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C26', $bp03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D26', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D26')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D26')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A27', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B27', 'Biaya Bensin');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C27', $bp04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D27', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D27')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D27')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A28', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B28', 'Biaya Parkir Umum');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C28', $bp05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D28', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D28')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D28')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A29', '6');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B29', 'Biaya Sparepart');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C29', $bp06);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D29', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D29')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D29')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A30', '7');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B30', 'Biaya Kebutuhan Service');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C30', $bp07);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D30', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D30')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D30')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C31', $biayaPenjualan);
|
|
|
|
//Isi Data Biaya Umum dan Administrasi
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A34', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B34', 'Biaya Gaji/THR');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C34', $bua01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D34', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D34')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D34')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A35', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B35', 'Biaya Pajak PPh Psl 21');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C35', $bua02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D35', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D35')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D35')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A36', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B36', 'Biaya Incentive');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C36', $bua03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D36', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D36')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D36')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A37', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B37', 'Biaya PLN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C37', $bua04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D37', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D37')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D37')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A38', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B38', 'Biaya Telepon');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C38', $bua05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D38', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D38')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D38')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A39', '6');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B39', 'Biaya Internet');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C39', $bua06);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D39', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D39')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D39')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A40', '7');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B40', 'Biaya PDAM');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C40', $bua07);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D40', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D40')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D40')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A41', '8');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B41', 'Biaya Serv Charge Mangga Dua');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C41', $bua08);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D41', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D41')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D41')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A42', '9');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B42', 'Biaya Parkir Kary Mangga Dua');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C42', $bua09);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D42', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D42')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D42')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A43', '10');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B43', 'Biaya Pengeluaran ITC');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C43', $bua10);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D43', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D43')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D43')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A44', '11');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B44', 'Biaya Konsultan Pajak');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C44', $bua11);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D44', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D44')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D44')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A45', '12');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B45', 'Biaya ATK');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C45', $bua12);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D45', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D45')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D45')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A46', '13');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B46', 'Biaya Materai');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C46', $bua13);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D46', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D46')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D46')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A47', '14');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B47', 'Biaya Fotocopy');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C47', $bua14);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D47', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D47')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D47')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A48', '15');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B48', 'Biaya Majalah Komputer, Buku, Dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C48', $bua15);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D48', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D48')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D48')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A49', '16');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B49', 'Biaya Cetak (Stempel, Kartu Nm, Kertas Kont B55dll)');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C49', $bua16);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D49', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D49')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D49')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A50', '17');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B50', 'Biaya Surat Referensi, Jaminan, dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C50', $bua17);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D50', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D50')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D50')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A51', '18');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B51', 'Biaya Kebutuhan Kantor');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C51', $bua18);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D51', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D51')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D51')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A52', '19');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B52', 'Biaya Service Luar');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C52', $bua19);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D52', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D52')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D52')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A53', '20');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B53', 'Biaya Tol');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C53', $bua20);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D53', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D53')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D53')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A54', '21');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B54', 'Biaya Service AC');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C54', $bua21);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D54', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D54')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D54')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A55', '22');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B55', 'Biaya Pajak Kendaraan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C55', $bua22);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D55', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D55')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D55')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A56', '23');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B56', 'Biaya Sumbangan dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C56', $bua23);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D56', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D56')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D56')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A57', '24');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B57', 'Biaya Entertain');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C57', $bua24);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D57', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D57')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D57')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A58', '25');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B58', 'Biaya BPJS');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C58', $bua25);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D58', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D58')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D58')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A59', '26');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B59', 'Biaya Ass Karyawan & Ass Lainnya');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C59', $bua26);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D59', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D59')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D59')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A60', '27');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B60', 'Biaya Training, Seminar dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C60', $bua27);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D60', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D60')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D60')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A61', '28');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B61', 'Biaya Fee');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C61', $bua28);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D61', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D61')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D61')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A62', '29');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B62', 'Biaya Dinas Luar');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C62', $bua29);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D62', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D62')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D62')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A63', '30');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B63', 'Biaya Pajak PPh Psl 25 P Sgg & P Agoes dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C63', $bua30);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D63', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D63')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D63')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A64', '31');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B64', 'Biaya Penyusutan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C64', $bua31);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D64', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D64')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D64')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A65', '32');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B65', 'Biaya Kegiatan Karyawan / Futsal dll');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C65', $bua32);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D65', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D65')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D65')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A66', '33');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B66', 'Biaya Rekreasi Karyawan Kantor');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C66', $bua33);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D66', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D66')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D66')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A67', '34');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B67', 'Biaya Pengeluaran Proyek');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C67', $bua34);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D67', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D67')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D67')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A68', '35');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B68', 'Biaya Bunga Kredit');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C68', $bua35);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D68', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D68')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D68')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A69', '36');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B69', 'Biaya Kredit Bank');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C69', $bua36);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D69', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D69')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D69')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A70', '37');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B70', 'Biaya Perawatan / Perbaikan Gedung');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C70', $bua37);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D70', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D70')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D70')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A71', '38');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B71', 'Biaya Pajak Lainnya');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C71', $bua38);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D71', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D71')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D71')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A72', '39');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B72', 'Biaya Lain Lain');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C72', $bua39);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D72', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D72')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D72')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C73', $biayaUmumAdministrasi);
|
|
|
|
//Isi Data Total Biaya
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C75', $totalBiaya);
|
|
|
|
//Isi Data Laba Usaha
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C78', $labaUsaha);
|
|
|
|
//Isi Data Pendapatan Dan (Beban) Luar Usaha
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A82', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B82', 'Pendapatan Diluar Usaha');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C82', $plu01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D82', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D82')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D82')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A83', '2');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B83', 'Pendapatan Jasa Giro');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C83', $plu02);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D83', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D83')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D83')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C84', $pendapatanLuarUsaha1);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A85', '3');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B85', 'Beban Admin Bank');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C85', $plu03);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D85', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D85')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D85')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A86', '4');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B86', 'Beban Pajak Giro');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C86', $plu04);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D86', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D86')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D86')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A87', '5');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B87', 'Beban Selisih Nilai');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C87', $plu05);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D87', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D87')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D87')->getFont()->setBold(true);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C88', $pendapatanLuarUsaha2);
|
|
|
|
//Isi Data Total Pendapatan Dan (Beban) Luar Usaha
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C90', $totalPendapatanLuarUsaha);
|
|
|
|
//Isi Data Laba Bersih Sebelum Pajak
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C93', $labaBersihSebelumPajak);
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A97', '1');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('B97', 'Pajak Penghasilan');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C97', $pph01);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('D97', '+');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D97')->getFont()->setSize(16);
|
|
$objPHPExcel->getActiveSheet()->getStyle('D97')->getFont()->setBold(true);
|
|
|
|
//Isi Data Total Pajak Penghasilan
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C98', $pajakPenghasilan);
|
|
|
|
//Isi Data Laba Bersih Setelah Pajak
|
|
$objPHPExcel->getActiveSheet()->setCellValue('C100', $labaBersihSetelahPajak);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:D9')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A11')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A11:D18')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A23')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A23:D31')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A33')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A33:D73')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A81')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A81:D88')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A96')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'f3f6f4'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A96:D98')->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
|
|
//New Sheet
|
|
$objPHPExcel->createSheet();
|
|
$objPHPExcel->setActiveSheetIndex(2);
|
|
$objPHPExcel->getActiveSheet()->setTitle("Laporan Persediaan");
|
|
|
|
// font
|
|
$objPHPExcel->getDefaultStyle()
|
|
->getFont()
|
|
->setName("Calibri")
|
|
->setSize(12);
|
|
|
|
//heading
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'PT. TRIPERWIRA MULTI PAMENANG');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN PERSEDIAAN');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A3', $nama_pak);
|
|
|
|
$sel = array(
|
|
'A',
|
|
'B',
|
|
'C',
|
|
'D',
|
|
'E',
|
|
'F',
|
|
);
|
|
$nt = [
|
|
'No' => 'No',
|
|
'Kode Barang' => 'KODE_BARANG',
|
|
'Nama Barang' => 'NAMA_BARANG',
|
|
'Sisa' => 'SISA',
|
|
'HPP (Average)' => 'AVG',
|
|
'Persediaan' => 'PERSEDIAAN',
|
|
];
|
|
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A1:F1");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A2:F2");
|
|
$objPHPExcel->getActiveSheet()->mergeCells("A3:F3");
|
|
$objPHPExcel->getActiveSheet()->getStyle("A1")->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle("A2")->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle("A3")->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1:A3')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(17);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A3')->getFont()->setSize(17);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
|
|
//lebar auto
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
|
|
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
|
|
|
|
//font style
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFont()->setSize(13);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F5')->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => '9fc5e8'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
|
|
|
|
//set nama tabel
|
|
$nama_tabel = array('No', 'Kode Barang', 'Nama Barang', 'Sisa', 'HPP (Average)', 'Persediaan');
|
|
$no = 0;
|
|
foreach ($nama_tabel as $tbl) {
|
|
|
|
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '5', $tbl);
|
|
$no++;
|
|
}
|
|
|
|
//Isi Laporan
|
|
$nocell = 6;
|
|
$no = 0;
|
|
$nolpr = 1;
|
|
foreach ($persediaanDetail as $lprn) {
|
|
foreach ($nama_tabel as $tbl) {
|
|
if ($tbl == "No") {
|
|
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $nolpr);
|
|
} else {
|
|
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $lprn[$nt[$tbl]]);
|
|
}
|
|
$no++;
|
|
}
|
|
$no = 0;
|
|
$nocell++;
|
|
$nolpr++;
|
|
}
|
|
|
|
$objPHPExcel->getActiveSheet()->freezePane('A6');
|
|
$objPHPExcel->getActiveSheet()->mergeCells('A'.$nocell.':E'.$nocell);
|
|
$objPHPExcel->getActiveSheet()->setCellValue('A'.$nocell, "TOTAL");
|
|
$objPHPExcel->getActiveSheet()->getStyle('A'.$nocell)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
|
|
$objPHPExcel->getActiveSheet()->setCellValue('F'.$nocell, $al04);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A'.$nocell.':F'.$nocell)->getFont()->setSize(14);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A'.$nocell.':F'.$nocell)->getFont()->setBold(true);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A'.$nocell.':F'.$nocell)->getFill()->applyFromArray(
|
|
array(
|
|
'type' => 'FILL_SOLID',
|
|
'rotation' => 0,
|
|
'startcolor' => array(
|
|
'rgb' => 'cfe2f3'
|
|
),
|
|
'endcolor' => array(
|
|
'argb' => 'FFFFFFFF'
|
|
)
|
|
)
|
|
);
|
|
|
|
$objPHPExcel->getActiveSheet()->getStyle('A5:F'.$nocell)->applyFromArray(
|
|
array(
|
|
'borders' => array(
|
|
'allborders' => array(
|
|
'style' => PHPExcel_Style_Border::BORDER_THIN,
|
|
'color' => array('rgb' => 'FF000000')
|
|
)
|
|
)
|
|
)
|
|
);
|
|
$objPHPExcel->setActiveSheetIndex(0);
|
|
|
|
$filename = "Laporan Analisa Neraca " . $nama_pak . " ". $ts .'.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();
|