public function export(Application $app, Request $request)
{
// タイムアウトを無効にする.
set_time_limit(0);
// sql loggerを無効にする.
$em = $app['orm.em'];
$em->getConfiguration()->setSQLLogger(null);
$response = new StreamedResponse();
$response->setCallback(function () use($app, $request) {
// CSV種別を元に初期化.
$app['eccube.service.csv.export']->initCsvType(CsvType::CSV_TYPE_CATEGORY);
// ヘッダ行の出力.
$app['eccube.service.csv.export']->exportHeader();
$qb = $app['eccube.repository.category']->createQueryBuilder('c')->orderBy('c.rank', 'DESC');
// データ行の出力.
$app['eccube.service.csv.export']->setExportQueryBuilder($qb);
$app['eccube.service.csv.export']->exportData(function ($entity, $csvService) {
$Csvs = $csvService->getCsvs();
/** @var $Category \Eccube\Entity\Category */
$Category = $entity;
// CSV出力項目と合致するデータを取得.
$row = array();
foreach ($Csvs as $Csv) {
$row[] = $csvService->getData($Csv, $Category);
}
//$row[] = number_format(memory_get_usage(true));
// 出力.
$csvService->fputcsv($row);
});
});
$now = new \DateTime();
$filename = 'category_' . $now->format('YmdHis') . '.csv';
$response->headers->set('Content-Type', 'application/octet-stream');
$response->headers->set('Content-Disposition', 'attachment; filename=' . $filename);
$response->send();
log_info('カテゴリCSV出力ファイル名', array($filename));
return $response;
}