/**
* @Rest\Get("/single_query_report/{id}/export_csv")
* @Rest\View(template=":default:index.html.twig",serializerEnableMaxDepthChecks=true, serializerGroups={"Default"})
*/
public function exportCsvSingleQueryReportAction(\AppBundle\Entity\SingleQueryReport $singleQueryReport, Request $request)
{
try {
$results = $singleQueryReport->export($this->container, $request);
} catch (\Exception $e) {
$httpCode = $e->getCode() > 0 ? $e->getCode() : 500;
throw new HttpException($httpCode, $e->getMessage());
}
$headerRow = [];
foreach ($results['columns'] as $column) {
$headerRow[] = $column['label'];
}
$data = [$headerRow];
foreach ($results['data'] as $row) {
$dataRow = [];
foreach ($results['columns'] as $column) {
$dataRow[] = Csv::getCastedValueFromFormat($row[$column['name']], Csv::getFormatFromName($column['type']));
}
$data[] = $dataRow;
}
Csv::sendResponse($singleQueryReport->getFileName(), $data, $request);
}
