public function delete_budgetallocation($id = 0) { $budgetallocation_model = new budgetallocation_model(); if ($id > 0) { $deleteResult = $budgetallocation_model->deleteBudgetAllocation($id); if ($deleteResult) { $form_message = 'Delete Success!'; $this->load->view('header'); $this->load->view('nav'); $this->load->view('budgetallocation_list', array('budgetallocation_data' => $budgetallocation_model->getBudgetAllocation(), 'form_message' => $form_message, $this->redirectIndex($id))); $this->load->view('footer'); } } }
public function budgetAllocation($sectorID) { $reports_model = new reports_model(); $budgetallocation_model = new budgetallocation_model(); $sectorName = $budgetallocation_model->sectorName($sectorID); $sName = $sectorName->sector_name; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); $getBudgetAllocation = $reports_model->getBudgetAlloc($sectorID); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Distribution of LSWDO with budget allocation (present year) in ' . $sName . ' sector, by region, Philippines'); //autosize column $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); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->getStartColor()->setRGB('FF0000'); // $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(-1);a $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1); $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(20); $objPHPExcel->getActiveSheet()->mergeCells('B1:G2'); //Center text merge columns $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); // $col = 'A'; // $row = 5; $objPHPExcel->getActiveSheet()->setCellValue('A3', 'Region'); $objPHPExcel->getActiveSheet()->getStyle('A3')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->setCellValue('B3', $sName . ' Sector'); $objPHPExcel->getActiveSheet()->mergeCells('A3:A5'); $objPHPExcel->getActiveSheet()->mergeCells('B3:G3'); //Center text merge columns $objPHPExcel->getActiveSheet()->getStyle('B3')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->mergeCells('B6:e6'); $objPHPExcel->getActiveSheet()->freezePane('B6'); //Header $objPHPExcel->getActiveSheet()->setCellValue('B4', 'Average PSWDO Allocation'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->setCellValue('C4', 'Average No. of Target Beneficiaries'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->setCellValue('D4', 'Average CSWDO Allocation'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->setCellValue('E4', 'Average No. of Target Beneficiaries'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->setCellValue('F4', 'Average MSWDO Allocation'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); $objPHPExcel->getActiveSheet()->setCellValue('G4', 'Average No. of Target Beneficiaries'); $objPHPExcel->getActiveSheet()->getStyle('B4')->getAlignment()->applyFromArray(array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)); //Start Editing //Part1 $row2 = 7; $col2 = 'A'; foreach ($getBudgetAllocation as $budgetUtil) { $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->region_name); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BudgetPresentP); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BeneTargetP); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BudgetPresentC); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BeneTargetC); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BudgetPresentM); $col2++; $objPHPExcel->getActiveSheet()->setCellValue($col2 . $row2, $budgetUtil->BeneTargetM); if ($col2 == 'G') { $col2 = 'A'; } $row2++; } $col3 = 'B'; $row3 = $row2 - 1; $objPHPExcel->getActiveSheet()->setCellValue('A' . $row2, 'Total'); for ($i = 0; $i < 6; $i++) { $objPHPExcel->getActiveSheet()->setCellValue($col3 . $row2, '=SUM(' . $col3 . '7:' . $col3 . $row3 . ')'); $col3++; } //End Editing // //border $objPHPExcel->getActiveSheet()->getStyle('A1:' . $objPHPExcel->getActiveSheet()->getHighestColumn() . $objPHPExcel->getActiveSheet()->getHighestRow())->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); // Rename worksheet (worksheet, not filename) $objPHPExcel->setActiveSheetIndex(0)->setTitle('Budget Allocation)'); // Add new sheet // Add some data // Set active sheet index to the first sheet, so Excel opens this as the first asheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Excel2007) //clean the output buffer ob_end_clean(); //this is the header given from PHPExcel examples. but the output seems somewhat corrupted in some cases. //header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); //so, we use this header instead. // $regionName = $this->reports_model->getRegionName($region); $filename = 'Non-CompliantIndicator.xlsx'; header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename=' . $filename); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output'); }