X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=lib%2FApp%2FWeb%2FOof.pm;h=0ecfd1be76bcf9761d07b2bbb9a3ca46ff533484;hb=06dc23e9eec3a128b566725ae146f11a0f729d99;hp=c3aeeb1883c5b07012a273a876da0a926bead690;hpb=889f48be6eceea1099e58d1a092545a91b0d236c;p=app-web-oof.git

diff --git a/lib/App/Web/Oof.pm b/lib/App/Web/Oof.pm
index c3aeeb1..0ecfd1b 100644
--- a/lib/App/Web/Oof.pm
+++ b/lib/App/Web/Oof.pm
@@ -6,7 +6,7 @@ use warnings;
 use utf8;
 use parent qw/Plack::Component/;
 
-our $VERSION = '0.000_006';
+our $VERSION = '0.000_007';
 
 use DBIx::Simple;
 use Email::Sender::Simple 'sendmail';
@@ -17,6 +17,7 @@ use HTML::Element::Library;
 use JSON::MaybeXS qw/encode_json decode_json/;
 use Plack::Builder;
 use Plack::Request;
+use Text::CSV;
 use Try::Tiny;
 
 sub HTML::Element::iter3 {
@@ -43,7 +44,7 @@ my $postage_per_item = $ENV{OOF_POSTAGE_PER_ITEM} // 50;
 ##################################################
 
 my %db;
-my ($form, $continue, $order, $details, $pay);
+my ($form, $continue, $order, $details, $pay, $display);
 
 {
 	sub parse_html {
@@ -58,6 +59,7 @@ my ($form, $continue, $order, $details, $pay);
 	$order    = parse_html 'order';
 	$details  = parse_html 'details';
 	$pay      = parse_html 'pay';
+	$display  = parse_html 'display';
 }
 
 sub stringify_money { sprintf "£%.2f", $_[0] / 100 }
@@ -213,7 +215,7 @@ sub order_app {
 				die "Not enough of " .$prod->{title}."\n" if $prod->{quantity} > $stock;
 				$db{$$}->update(products => {stock => $stock - $prod->{quantity}}, {product => $prod->{product}});
 			}
-			$db{$$}->insert(orders => {id => $id, %parms});
+			$db{$$}->insert(orders => {id => $id, date => time, %parms});
 			$db{$$}->commit;
 			sendmail (Email::Simple->create(
 				header => [
@@ -293,6 +295,45 @@ sub pay_app {
 	[200, ['Content-type' => 'text/html; charset=utf-8'], [$pay->as_HTML]];
 }
 
+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]];
+}
+
 sub app {
 	my $footer = read_file 'tmpl/footer.html';
 	builder {
@@ -310,6 +351,7 @@ sub app {
 		mount '/order'    => \&order_app;
 		mount '/details'  => \&details_app;
 		mount '/pay'      => \&pay_app;
+		mount '/display'  => \&display_app;
 	}
 }