public function actionBebanAktivitas()
{
if (Yii::app()->request->isAjaxRequest) {
return;
}
if (isset($_POST) && !empty($_POST)) {
//require_once(Yii::app()->basePath . '/vendors/frontaccounting/ui.inc');
$format = $_POST['format'];
$start_date = $_POST['trans_date_mulai'];
$end_date = $_POST['trans_date_sampai'];
$start = 1;
$file_name = 'BebanAktivitas';
$worksheet_name = 'BebanAktivitas';
$objPHPExcel = new PHPExcel();
$this->header($objPHPExcel, $start, $worksheet_name, "LAPORAN BEBAN AKTIVITAS");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PERIODE: " . sql2long_date($start_date) . " - " . sql2long_date($end_date))->getStyle("A{$start}")->getFont()->setSize(12)->setBold(true);
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$start++;
$start++;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Sub Aktivitas")->setCellValue("B{$start}", "Total Beban")->setCellValue("C{$start}", "%")->getStyle("A{$start}:C{$start}")->getFont()->setBold(true);
$start++;
$rows = Pah::get_beban_aktivitas($start_date, $end_date);
$total = Pah::get_total_beban_aktivitas($start_date, $end_date);
$total_persen = 0;
foreach ($rows as $row) {
$total_persen += $row['total_beban'] / $total;
$total_beban = $format == 'excel' ? $row['total_beban'] : acc_format($row['total_beban']);
$persen = $format == 'excel' ? $row['total_beban'] / $total : percent_format($row['total_beban'] / $total, 2);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", $row['sub_aktivitas'])->setCellValue("B{$start}", $total_beban)->setCellValue("C{$start}", $persen);
$start++;
}
$total_format = $format == 'excel' ? $total : acc_format($total);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", 'Total')->setCellValue("B{$start}", $total_format)->setCellValue("C{$start}", $format == 'excel' ? $total_persen : percent_format($total_persen, 2));
$start++;
$end_body = $start - 1;
$styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:C{$end_body}")->applyFromArray($styleArray);
$start_row = $start_body + 1;
if ($format == 'excel') {
$objPHPExcel->setActiveSheetIndex(0)->getStyle("B{$start_row}:B{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("C{$start_row}:C{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00);
} else {
$objPHPExcel->setActiveSheetIndex(0)->getStyle("B{$start_body}:C{$end_body}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
}
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("A")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("B")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("C")->setAutoSize(true);
$this->footer($objPHPExcel, $start, $file_name, $format, "Beban Aktivitas");
Yii::app()->end();
}
}
