public function actionPenjualanPerMobil() { if (Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $format = $_POST['format']; $start_date = $_POST['trans_date_mulai']; $end_date = $_POST['trans_date_sampai']; $id_mobil = $_POST['id_mobil']; $mobil = $this->loadModel($id_mobil, 'MtMobil'); $nopol = $mobil->nopol; $start = 1; $file_name = 'PenjualanPerMobil'; $worksheet_name = 'Penjualan per Mobil'; $objPHPExcel = new PHPExcel(); $this->header($objPHPExcel, $start, $worksheet_name, "PENJUALAN PER MOBIL"); $objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Nopol " . $nopol)->getStyle("A{$start}")->getFont()->setSize(12)->setBold(true); $start++; $objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Dari tanggal " . sql2long_date($start_date) . " sampai tanggal " . 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}", "Tanggal Transaksi")->setCellValue("B{$start}", "Ref. Dokumen")->setCellValue("C{$start}", "Total Ongkos Sewa")->setCellValue("D{$start}", "Diskon")->setCellValue("E{$start}", "Netto")->getStyle("A{$start}:E{$start}")->getFont()->setBold(true); $start++; $rows = Mt::get_lap_penjualam_per_mobil($id_mobil, $start_date, $end_date); $total = $total_disk = $total_netto = 0; // $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}", sql2date($row['trans_date']))->setCellValue("B{$start}", $row['doc_ref'])->setCellValue("C{$start}", $format == 'excel' ? $row['total'] : number_format($row['total']))->setCellValue("D{$start}", $format == 'excel' ? $row['disc'] : number_format($row['disc']))->setCellValue("E{$start}", $format == 'excel' ? $row['netto'] : number_format($row['netto'])); $total += $row['total']; $total_disk += $row['disc']; $total_netto += $row['netto']; $start++; } $objPHPExcel->setActiveSheetIndex(0)->setCellValue("B{$start}", 'Total')->setCellValue("C{$start}", $format == 'excel' ? $total : number_format($total))->setCellValue("D{$start}", $format == 'excel' ? $total_disk : number_format($total_disk))->setCellValue("E{$start}", $format == 'excel' ? $total_netto : number_format($total_netto)); $start++; $end_body = $start - 1; $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))); $objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:E{$end_body}")->applyFromArray($styleArray); $start_row = $start_body + 1; if ($format == 'excel') { $objPHPExcel->setActiveSheetIndex(0)->getStyle("C{$start_row}:E{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING); } else { $objPHPExcel->setActiveSheetIndex(0)->getStyle("C{$start_body}:E{$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); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("D")->setAutoSize(true); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("E")->setAutoSize(true); $this->footer($objPHPExcel, $start, $file_name, $format, "Penjualan per Mobil"); Yii::app()->end(); } }