Export Orders to CSV From the Admin Panel: PR Review

Finance exports orders every month by asking an engineer to run a query. This adds an export endpoint the admin panel links to, with an optional from date. Each row has the order, the customer, the total, and the number of items. There's a test that checks the header row.

Asrc/Controller/Admin/OrderExportController.php1 of 3

Files Changed

src/Controller/Admin/

config/

tests/

src/Controller/Admin/OrderExportController.php

PHP · Click a line number to comment · Tap a line to comment

@@ -0,0 +1,31 @@

<?php

namespace App\Controller\Admin;

use App\Db;

class OrderExportController

{

public function __construct(private Db $db)

{

}

public function export(): void

{

$from = $_GET['from'] ?? '1970-01-01';

$orders = $this->db->query(

"SELECT id, customer_name, email, total_cents, created_at FROM orders WHERE created_at >= '$from' ORDER BY id"

)->fetchAll();

header('Content-Type: text/csv');

header('Content-Disposition: attachment; filename="orders.csv"');

$out = fopen('php://output', 'w');

fputcsv($out, ['id', 'customer', 'email', 'total', 'created']);

foreach ($orders as $order) {

$items = $this->db->query("SELECT COUNT(*) FROM order_items WHERE order_id = {$order['id']}")->fetchColumn();

fputcsv($out, [$order['id'], $order['customer_name'], $order['email'], $order['total_cents'] / 100, $order['created_at'], $items]);

}

fclose($out);

}

src/Controller/Admin/OrderExportController.php

config/routes.php

tests/OrderExportTest.php