+sub display_table_row {
+ my ($data, $tr) = @_;
+ $tr->fclass($_)->replace_content($data->{$_}) for qw/title subtitle quantity/;
+ $tr->fclass('freepost')->detach unless $data->{freepost};
+ $tr->fclass('price')->replace_content(stringify_money $data->{subtotal});
+ $tr->fclass('title')->attr('data-product', $data->{product});
+}
+
+sub display_order {
+ my ($data, $div) = @_;
+ my @products = @{decode_json $data->{products}};
+ $div->find('table')->iter3(\@products, \&display_table_row);
+ $div->fclass('name')->replace_content($data->{first_name} . ' ' . $data->{last_name});
+ $div->fclass('stripe_token')->replace_content($data->{stripe_token}) if $data->{stripe_token};
+}
+
+my $csv_header = 'Address_line_1,Address_line_2,Address_line_3,Address_line_4,Postcode,First_name,Last_name,Email,Weight(Kg),Compensation(�),Signature(y/n),Reference,Contents,Parcel_value(�),Delivery_phone,Delivery_safe_place,Delivery_instructions' . "\n";
+
+sub make_hermes_csv {
+ my ($order) = @_;
+ my $csv = Text::CSV->new;
+ my @fields = map { $order->{$_} } qw/address1 address2 address3 address4 postcode first_name last_name email/;
+ $csv->combine(@fields, '', '', 'n', '', '', '', $order->{phone}, $order->{safe_place}, $order->{instructions});
+ $csv->string
+}
+
+sub display_app {
+ my ($env) = @_;
+ $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:');
+ my $req = Plack::Request->new($env);
+ my $n = int ($req->param('n') // 10);
+ my @orders = $db{$$}->query("SELECT * FROM orders ORDER BY date DESC LIMIT $n")->hashes;
+ my $tree = $display->clone;
+ $tree->fclass('order')->iter3(\@orders, \&display_order);
+ my $csv = join "\n", map { make_hermes_csv $_ } @orders;
+ $tree->fid('hermes_csv')->replace_content($csv_header . $csv);
+ [200, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]];
+}
+