public function exportOrder(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_ORDER);
// ヘッダ行の出力.
$app['eccube.service.csv.export']->exportHeader();
// 受注データ検索用のクエリビルダを取得.
$qb = $app['eccube.service.csv.export']->getOrderQueryBuilder($request);
// データ行の出力.
$app['eccube.service.csv.export']->setExportQueryBuilder($qb);
$app['eccube.service.csv.export']->exportData(function ($entity, $csvService) {
$Csvs = $csvService->getCsvs();
$Order = $entity;
$OrderDetails = $Order->getOrderDetails();
foreach ($OrderDetails as $OrderDetail) {
$row = array();
// CSV出力項目と合致するデータを取得.
foreach ($Csvs as $Csv) {
// 受注データを検索.
$data = $csvService->getData($Csv, $Order);
if (is_null($data)) {
// 受注データにない場合は, 受注明細を検索.
$data = $csvService->getData($Csv, $OrderDetail);
}
$row[] = $data;
}
//$row[] = number_format(memory_get_usage(true));
// 出力.
$csvService->fputcsv($row);
}
});
});
$now = new \DateTime();
$filename = 'order_' . $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;
}