public function generate($id = 0)
{
$data = array();
$data['reports'] = Reports::getList();
$reports = Reports::getList();
$data['reports'] = $reports;
# report
$report = Reports::getReportById($id);
$data['report'] = $report;
if (count($report) > 0) {
# get all files under this report
$reportFiles = ReportFile::getReportFilesById($report->report_id);
# get all version and sheets under this report
for ($i = 0; $i < count($reportFiles); $i++) {
// get current version
$currentFileVersion = ReportFileVersion::getCurrentVersion($reportFiles[$i]->file_id);
$reportFiles[$i]->currentFileVersion = $currentFileVersion;
// get all file versions
$allFileVersion = ReportFileVersion::getAllVersion($reportFiles[$i]->file_id);
$reportFiles[$i]->allFileVersion = $allFileVersion;
// get sheets
$reportSheets = ReportFileSheets::getSheetsByVersionId($currentFileVersion->version_id);
$reportFiles[$i]->reportSheets = $reportSheets;
}
} else {
$reportFiles = array();
}
$data['report_files'] = $reportFiles;
return view($this->viewPath . 'generate', $data);
}
/**
* Shows the list of reports
*
* @return Response
*/
public function index()
{
$data = array();
$data['records'] = Reports::getList();
return view($this->viewPath . 'list', $data);
}
