Symfony Profiler

<?php
namespace App\Service;
use App\Repository\OrderItemRepository;
use App\Repository\OrderRepository;
use Doctrine\ORM\QueryBuilder;
use EasyCorp\Bundle\EasyAdminBundle\Collection\FieldCollection;
use Goodby\CSV\Export\Standard\Exporter;
use Goodby\CSV\Export\Standard\ExporterConfig;
use Symfony\Component\HttpFoundation\HeaderUtils;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\StreamedResponse;
class CsvExporter
{
private $orderItemRepository;
private $orderRepository;
public function __construct(OrderRepository $orderRepository, OrderItemRepository $orderItemRepository)
{
$this->orderItemRepository = $orderItemRepository;
$this->orderRepository = $orderRepository;
}
public function createResponseFromQueryBuilder(QueryBuilder $queryBuilder, FieldCollection $fields, string $filename): Response
{
$result = $queryBuilder->getQuery()->getArrayResult();
// Convert DateTime objects into strings
$data = [];
foreach ($result as $index => $row) {
$tempArr = [];
foreach ($row as $columnKey => $columnValue) {
$data[$index][$columnKey] = $columnValue instanceof \DateTimeInterface
? $columnValue->format('Y-m-d')
: $columnValue;
}
}
// Humanize headers based on column labels in EA
if (isset($data[0])) {
$headers = [];
$properties = array_keys($data[0]);
foreach ($properties as $property) {
$headers[$property] = ucfirst($property);
foreach ($fields as $field) {
// Override property name if a custom label was set
if ($property === $field->getProperty() && $field->getLabel()) {
$headers[$property] = $field->getLabel();
// And stop iterating
break;
}
}
}
// Add headers to the final data array
array_unshift($data, $headers);
}
$response = new StreamedResponse(function () use ($data) {
$config = new ExporterConfig();
$exporter = new Exporter($config);
$exporter->export('php://output', $data);
});
$dispositionHeader = $response->headers->makeDisposition(
HeaderUtils::DISPOSITION_ATTACHMENT,
$filename
);
$response->headers->set('Content-Disposition', $dispositionHeader);
$response->headers->set('Content-Type', 'text/csv; charset=utf-8');
return $response;
}
public function createOrderResponseFromQueryBuilder(QueryBuilder $queryBuilder, FieldCollection $fields, string $filename): Response
{
$result = $queryBuilder->getQuery()->getResult();
$data = [];
foreach ($result as $record) {
$orderItems = $record->getOrderItems();
$index = 0;
foreach ($orderItems as $orderItem) {
if ($index == 0){
$data[] = [
'id' => $record->getOrderId(),
'orderDate' => $record->getDate()->format('Y-m-d'),
'hcp' => $record->getHcp(),
'patient' => $record->getCustomer()->getName(),
'productName' => $orderItem->getName(),
'quantity' => $orderItem->getQuantity(),
'productPrice' => $orderItem->getPriceString(),
'shippingCost' => $record->getShippingCostString(),
'totalPrice' => $record->getTotalString(),
'paymentStatus' => $record->getPaymentStatus(),
];
} else {
$data[] = [
'id' => '',
'orderDate' => '',
'hcp' => '',
'patient' => '',
'productName' => $orderItem->getName(),
'quantity' => $orderItem->getQuantity(),
'productPrice' => $orderItem->getPriceString(),
'shippingCost' => '',
'totalPrice' => '',
'paymentStatus' => '',
];
}
$index++;
}
}
// Humanize headers based on column labels in EA
if (isset($data[0])) {
$headers = [];
$properties = array_keys($data[0]);
foreach ($properties as $property) {
$headers[$property] = ucfirst($property);
foreach ($fields as $field) {
// Override property name if a custom label was set
if ($property === $field->getProperty() && $field->getLabel()) {
$headers[$property] = $field->getLabel();
// And stop iterating
break;
}
}
}
// Add headers to the final data array
array_unshift($data, $headers);
}
$response = new StreamedResponse(function () use ($data) {
$config = new ExporterConfig();
$exporter = new Exporter($config);
$exporter->export('php://output', $data);
});
$dispositionHeader = $response->headers->makeDisposition(
HeaderUtils::DISPOSITION_ATTACHMENT,
$filename
);
$response->headers->set('Content-Disposition', $dispositionHeader);
$response->headers->set('Content-Type', 'text/csv; charset=utf-8');
return $response;
}
}

src/Service/CsvExporter.php line 75