/**
* Add Report Row
*
* @return object
*/
public static function addReportRow($data = array(), $report_id)
{
$report = new PreparednessResponseRow();
$report->report_id = $report_id;
$report->regionfilter = $data['regionfilter'];
$report->region_provincemunicipalitycity = $data['region_provincemunicipalitycity'];
$report->nhts_pr_2011 = $data['nhts_pr_2011'];
$report->nso_population_2010 = $data['nso_population_2010'];
$report->no_of_pantawid_beneficiaries = $data['no_of_pantawid_beneficiaries'];
$report->save();
return $report;
}
/**
* View report by id
*
* @return Response
*/
public function view_report($id)
{
$data = array();
$report = PreparednessResponse::getReportById($id);
$data['report'] = $report;
$reportRows = PreparednessResponseRow::getReportRowsByReportId($id);
$data['reportRows'] = $reportRows;
return view($this->viewPath . 'view_report', $data);
}
/**
* Parses report then save to database
*
* @return object
*/
public static function parsePreparednessResponse($file, $report)
{
try {
Excel::load($file, function ($reader) use($report) {
foreach ($reader->toArray() as $row) {
if ($row['regionfilter'] != '') {
PreparednessResponseRow::addReportRow($row, $report->report_id);
}
}
});
} catch (\Exception $e) {
echo 'error here: ' . $e->getMessage();
return $e->getMessage();
}
}
