public function actionCetakPenghuniPondok() { 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']; $start = 1; $file_name = 'PenghuniPondok'; $worksheet_name = 'PenghuniPondok'; $objPHPExcel = new PHPExcel(); $this->header($objPHPExcel, $start, $worksheet_name, "DAFTAR PENGHUNI PONDOK"); $start++; $start_body = $start; $objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "No.")->setCellValue("B{$start}", "Nama Lengkap")->getStyle("A{$start}:B{$start}")->getFont()->setBold(true); $start++; $rows = Pe::get_penghuni_pondok(); $no = 0; foreach ($rows as $row) { $no++; $objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", $no)->setCellValue("B{$start}", $row['real_name']); $start++; } $end_body = $start - 1; $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))); $objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:B{$end_body}")->applyFromArray($styleArray); $start_row = $start_body + 1; $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("A")->setAutoSize(true); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("B")->setAutoSize(true); $this->footer($objPHPExcel, $start, $file_name, $format, 'Daftar Penghuni Pondok'); Yii::app()->end(); } }