Bump version and update Changes

[app-web-oof.git] / lib / App / Web / Oof.pm

diff --git a/lib/App/Web/Oof.pm b/lib/App/Web/Oof.pm
index fa256a6965411da2ec9fca71097846d51960f8c0..0ecfd1be76bcf9761d07b2bbb9a3ca46ff533484 100644 (file)
--- a/lib/App/Web/Oof.pm
+++ b/lib/App/Web/Oof.pm
@@ -6,15 +6,18 @@ use warnings;
 use utf8;
 use parent qw/Plack::Component/;
 
-our $VERSION = '0.000_005';
+our $VERSION = '0.000_007';
 
 use DBIx::Simple;
+use Email::Sender::Simple 'sendmail';
+use Email::Simple;
 use File::Slurp;
 use HTML::TreeBuilder;
 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 {
@@ -35,8 +38,13 @@ sub HTML::Element::fclass { shift->look_down(class => qr/\b$_[0]\b/) }
 
 ##################################################
 
+my $postage_base = $ENV{OOF_POSTAGE_BASE} // 225;
+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 {
@@ -51,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 }
@@ -70,7 +79,7 @@ sub product_to_schemaorg {
                '@type'    => 'Product',
                name => $data{title},
                image => "/static/fullpics/$data{product}-1.jpg",
-               description => $data{summary},
+               description => $data{subtitle},
                offers => {
                        '@type' => 'Offer',
                        price => ($data{price} =~ s/(..)$/\.$1/r),
@@ -101,7 +110,7 @@ sub form_app {
        my $req = Plack::Request->new($env);
 
        local %highlight = map { $_ => 1 } $req->param('highlight');
-       my $data = $db{$$}->select(products => '*', {}, 'product')->hashes;
+       my $data = $db{$$}->select(products => '*', {stock => {'>', 0}}, 'product')->hashes;
        my $tree = $form->clone;
        $tree->find('tbody')->find('tr')->iter3($data, \&form_table_row);
 
@@ -165,7 +174,7 @@ sub continue_app {
        }
        $tree->look_down(name => 'discount')->detach unless $dvalue;
        $tree->fid('discount_tr')->detach unless $dvalue;
-       my $postage = 220 + 50 * ($quant - $quant_freepost);
+       my $postage = $postage_base + $postage_per_item * ($quant - $quant_freepost);
        $postage = 0 if $quant == $quant_freepost;
        $tree->fid('postage')->replace_content(stringify_money $postage);
        $total += $postage;
@@ -206,8 +215,16 @@ 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 => [
+                                       From    => $ENV{OOF_EMAIL_FROM},
+                                       To      => $ENV{OOF_EMAIL_TO},
+                                       Subject => "Order $id placed",
+                               ],
+                               body => 'A new order was placed.',
+                       )) if $ENV{OOF_EMAIL_TO};
                } catch {
                        $db{$$}->rollback;
                        $err = [500, ['Content-type', 'text/plain'], ["Error: $_"]]
@@ -254,7 +271,8 @@ sub details_app {
        my $slug = make_slug $data{title};
        $tree->find('title')->replace_content("$data{title} | ledparts4you");
        $tree->find('h2')->replace_content($data{title});
-       $tree->fid('summary')->replace_content($data{summary});
+       my $summary_literal = HTML::Element::Library::super_literal $data{summary};
+       $tree->fid('summary')->replace_content($summary_literal);
        $tree->look_down(rel => 'canonical')->attr(href => "/details/$id/$slug");
        $tree->fid('pictures')->find('li')->iter3(\@pics, \&details_list_element);
        $tree->fid('jsonld')->replace_content(encode_json product_to_schemaorg '', %data);
@@ -277,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 {
@@ -294,6 +351,7 @@ sub app {
                mount '/order'    => \&order_app;
                mount '/details'  => \&details_app;
                mount '/pay'      => \&pay_app;
+               mount '/display'  => \&display_app;
        }
 }