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();
}
}
