X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=lib%2FApp%2FWeb%2FOof.pm;h=637f3935180bd294206ca02aec1c83a676c70ed4;hb=c51bcbe6a3d80499a2806c7a45c3f871b71bdb3b;hp=b8fbaf5f637519f686489cb9d21e9875e285e29d;hpb=6e33dd6846a44f56a5c8bd187f0a89e4893c7b4a;p=app-web-oof.git diff --git a/lib/App/Web/Oof.pm b/lib/App/Web/Oof.pm index b8fbaf5..637f393 100644 --- a/lib/App/Web/Oof.pm +++ b/lib/App/Web/Oof.pm @@ -6,14 +6,18 @@ use warnings; use utf8; use parent qw/Plack::Component/; -our $VERSION = '0.000_001'; +our $VERSION = '0.000_006'; 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 Try::Tiny; sub HTML::Element::iter3 { my ($self, $data, $code) = @_; @@ -33,8 +37,13 @@ sub HTML::Element::fclass { shift->look_down(class => qr/\b$_[0]\b/) } ################################################## -my $db; -my ($form, $continue, $order); +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); { sub parse_html { @@ -47,25 +56,59 @@ my ($form, $continue, $order); $form = parse_html 'form'; $continue = parse_html 'continue'; $order = parse_html 'order'; + $details = parse_html 'details'; + $pay = parse_html 'pay'; } sub stringify_money { sprintf "£%.2f", $_[0] / 100 } +sub make_slug { + my $slug = $_[0]; + $slug =~ y/ /-/; + $slug =~ y/a-zA-Z0-9-//cd; + $slug +} + +sub product_to_schemaorg { + my ($include_url, %data) = @_; + my $stock = $data{stock} > 0 ? 'InStock' : 'OutOfStock'; + +{ + '@context' => 'http://schema.org/', + '@type' => 'Product', + name => $data{title}, + image => "/static/fullpics/$data{product}-1.jpg", + description => $data{summary}, + offers => { + '@type' => 'Offer', + price => ($data{price} =~ s/(..)$/\.$1/r), + priceCurrency => 'GBP', + availability => "http://schema.org/$stock", + ($include_url ? (url => "/details/$data{product}/" . make_slug $data{title}) : ()) + } + } +} + +our %highlight; sub form_table_row { my ($data, $tr) = @_; + $tr->attr(class => 'highlight') if $highlight{$data->{product}}; $tr->fclass($_)->replace_content($data->{$_}) for qw/title subtitle stock/; $tr->fclass('price')->replace_content(stringify_money $data->{price}); + $tr->fclass('freepost')->detach unless $data->{freepost}; $tr->fclass('title')->attr('data-product', $data->{product}); - $tr->fclass('title')->attr('data-summary', $data->{summary}); + $tr->fclass('title')->attr('href', '/details/'.$data->{product}.'/'.make_slug $data->{title}); +# $tr->fclass('title')->attr('data-summary', $data->{summary}); $tr->look_down(_tag => 'input')->attr(max => $data->{stock}); $tr->look_down(_tag => 'input')->attr(name => 'quant'.$data->{product}); } sub form_app { my ($env) = @_; - $db //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + my $req = Plack::Request->new($env); - my $data = $db->select(products => '*', {}, 'product')->hashes; + local %highlight = map { $_ => 1 } $req->param('highlight'); + my $data = $db{$$}->select(products => '*', {}, 'product')->hashes; my $tree = $form->clone; $tree->find('tbody')->find('tr')->iter3($data, \&form_table_row); @@ -75,22 +118,23 @@ sub form_app { sub continue_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 continue_app { my ($env) = @_; - $db //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); my $tree = $continue->clone; my $req = Plack::Request->new($env); my $params = $req->body_parameters; - my ($quant, $total, @data, @notes); + my ($quant, $quant_freepost, $total, @data, @notes) = (0) x 3; for (sort keys %$params) { next unless /^quant/; next unless $params->{$_}; - my $data = $db->select(products => '*', {product => substr $_, 5})->hash; + my $data = $db{$$}->select(products => '*', {product => substr $_, 5})->hash; $data->{quantity} = $params->{$_}; if ($data->{stock} == 0) { push @notes, 'Item is out of stock and was removed from order: '.$data->{title}; @@ -102,17 +146,20 @@ sub continue_app { } $data->{subtotal} = $data->{price} * $data->{quantity}; $quant += $data->{quantity}; + $quant_freepost += $data->{quantity} if $data->{freepost}; $total += $data->{subtotal}; push @data, $data } + return [500, ['Content-type' => 'text/plain'], ['Error: no items in order.']] unless $quant; + $tree->fid('subtotal')->replace_content(stringify_money $total); my $dvalue; if ($params->{discount}) { - my $discount = $db->select(discounts => '*', {discount => $params->{discount}})->hash; + my $discount = $db{$$}->select(discounts => '*', {discount => $params->{discount}})->hash; if (!defined $discount) { push @notes, 'Discount code incorrect. No discount applied.' - } elsif ($db->select(orders => 'COUNT(*)', {discount => $params->{discount}})->list) { + } elsif ($db{$$}->select(orders => 'COUNT(*)', {discount => $params->{discount}})->list) { push @notes, 'Discount code already used once. No discount applied.' } else { $dvalue = int (0.5 + $discount->{fraction} * $total) if $discount->{fraction}; @@ -125,7 +172,8 @@ sub continue_app { } $tree->look_down(name => 'discount')->detach unless $dvalue; $tree->fid('discount_tr')->detach unless $dvalue; - my $postage = 220 + 50 * $quant; + 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; $tree->fid('total')->replace_content(stringify_money $total); @@ -141,31 +189,126 @@ sub continue_app { sub order_app { my ($env) = @_; - $db //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); my $tree = $order->clone; my $req = Plack::Request->new($env); - my $id = sprintf "%X", time; # Not good enough! - - $db->begin_work; - $db->insert(orders => {id => $id, %{$req->body_parameters}}); - my $products = decode_json $req->body_parameters->{products}; - for my $prod (@$products) { - my $stock = $db->select(products => 'stock', {product => $prod->{product}})->list; - die "Not enough of " .$prod->{title}."\n" if $prod->{quantity} > $stock; - $db->update(products => {stock => $stock - $prod->{quantity}}, {product => $prod->{product}}); + my ($id) = $env->{PATH_INFO} =~ m,^/([0-9A-F]+),; + if ($id) { + my $total = $db{$$}->select(orders => 'total', {id => $id})->list or + return [500, ['Content-type', 'text/plain'], ['Order not found']]; + $tree->fid('orderid')->replace_content($id); + $tree->look_down(name => 'order')->attr(value => $id); + $tree->fid('total')->replace_content(stringify_money $total); + $tree->find('script')->attr('data-amount', $total); + return [200, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]] + } else { + my %parms = %{$req->body_parameters}; + my $id = sprintf "%X%04X", time, $$; + my $err; + try { + $db{$$}->begin_work; + my $products = decode_json $req->body_parameters->{products}; + for my $prod (@$products) { + my $stock = $db{$$}->select(products => 'stock', {product => $prod->{product}})->list; + 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{$$}->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: $_"]] + }; + return $err if $err; + return [303, [Location => "/order/$id"], []] + } +} + +sub cancel { + my ($order) = @_; + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + $order = $db{$$}->select(orders => '*', {id => $order})->hash; + my $products = decode_json $order->{products}; + $db{$$}->begin_work; + try { + for my $prod (@$products) { + my $stock = $db{$$}->select(products => 'stock', {product => $prod->{product}})->list; + $db{$$}->update(products => {stock => $stock + $prod->{quantity}}, {product => $prod->{product}}); + } + $db{$$}->delete(orders => {id => $order->{id}}); + $db{$$}->commit; + } catch { + $db{$$}->rollback; + die $_ + } +} + +sub details_list_element { + my ($data, $li) = @_; + $li->find('a')->attr(href => "/$data"); + my $thumb = $data =~ s/fullpics/thumbs/r; + $thumb = $data unless -f $thumb; + $li->find('img')->attr(src => "/$thumb"); +} + +sub details_app { + my ($env) = @_; + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + my $tree = $details->clone; + my ($id) = $env->{PATH_INFO} =~ m,^/(\d+),; + my %data = %{$db{$$}->select(products => '*', {product => $id})->hash}; + my @pics = ; + 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}); + $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); + + for my $ahref ($tree->find('a')) { + $ahref->attr(href => "/form?highlight=$id") if $ahref->attr('href') eq '/'; } - $db->commit; - $tree->fid('orderid')->replace_content($id); [200, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]] } +sub pay_app { + my ($env) = @_; + my $req = Plack::Request->new($env); + $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); + my $order = $req->body_parameters->{order}; + my $token = $req->body_parameters->{stripeToken}; + return [500, ['Content-type' => 'text/html; charset=utf-8'], ['No token received, payment did not succeed.']] unless $token; + $db{$$}->update(orders => {stripe_token => $token}, {id => $order}); + [200, ['Content-type' => 'text/html; charset=utf-8'], [$pay->as_HTML]]; +} + sub app { + my $footer = read_file 'tmpl/footer.html'; builder { + enable sub { + my $app = shift; + sub { + my $res = $app->(@_); + $res->[2][0] =~ s,,$footer, if $res->[0] == 200; + $res; + } + }; mount '/' => sub { [301, [Location => '/form'], []] }; mount '/form' => \&form_app; mount '/continue' => \&continue_app; mount '/order' => \&order_app; + mount '/details' => \&details_app; + mount '/pay' => \&pay_app; } } @@ -183,8 +326,10 @@ App::Web::Oof - Oversimplified order form / ecommerce website =head1 DESCRIPTION Oof (Oversimplified order form) is a very simple ecommerce website. -As of this moment it is incomplete (although functional), hence the -version number. +It is the code behind L. + +This version is reasonably functional, yet not very reusable, hence +the version number. =head1 AUTHOR