X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=lib%2FApp%2FWeb%2FOof.pm;h=f9f34f312c139d38f3da2f4eb8f9183b22de9533;hb=HEAD;hp=93ab4fe40d62e3096a8d9dae9cef2b947897a581;hpb=85e0d9a252dc252b9f79df382ed14d07ffb688c3;p=app-web-oof.git diff --git a/lib/App/Web/Oof.pm b/lib/App/Web/Oof.pm index 93ab4fe..f9f34f3 100644 --- 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_003'; +our $VERSION = '0.000_008'; 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, $down); { sub parse_html { @@ -51,6 +59,8 @@ my ($form, $continue, $order, $details, $pay); $order = parse_html 'order'; $details = parse_html 'details'; $pay = parse_html 'pay'; + $display = parse_html 'display'; + $down = parse_html 'down'; } sub stringify_money { sprintf "£%.2f", $_[0] / 100 } @@ -62,8 +72,33 @@ sub make_slug { $slug } +sub product_to_schemaorg { + my ($include_url, %data) = @_; + my $stock = $data{stock} > 0 ? 'InStock' : 'OutOfStock'; + my @extra; + push @extra, (brand => {'@type' => 'Brand', name => $data{brand}}) if $data{brand}; + push @extra, (model => $data{model}) if $data{model}; + +{ + '@context' => 'http://schema.org/', + '@type' => 'Product', + name => $data{title}, + image => "/static/fullpics/$data{product}-1.jpg", + description => $data{subtitle}, + @extra, + 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}; @@ -77,8 +112,10 @@ sub form_table_row { sub form_app { my ($env) = @_; $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 => '*', {stock => {'>', 0}}, 'product')->hashes; my $tree = $form->clone; $tree->find('tbody')->find('tr')->iter3($data, \&form_table_row); @@ -142,7 +179,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; @@ -183,8 +220,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 for ".stringify_money($parms{total}), + ], + body => 'A new order was placed.', + )) if $ENV{OOF_EMAIL_TO}; } catch { $db{$$}->rollback; $err = [500, ['Content-type', 'text/plain'], ["Error: $_"]] @@ -226,13 +271,31 @@ sub details_app { $db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:'); my $tree = $details->clone; my ($id) = $env->{PATH_INFO} =~ m,^/(\d+),; - my $title = $db{$$}->select(products => 'title', {product => $id})->list; + my %data = %{$db{$$}->select(products => '*', {product => $id})->hash}; my @pics = ; - my $slug = make_slug $title; - $tree->find('title')->replace_content("Pictures of $title | ledparts4you"); - $tree->find('h2')->replace_content($title); + my $slug = make_slug $data{title}; + $tree->find('title')->replace_content("$data{title} | ledparts4you"); + $tree->find('h2')->replace_content($data{title}); + 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); + + $tree->fid('dd_stock')->replace_content($data{stock}); + $tree->fid('dd_price')->replace_content(stringify_money $data{price}); + for (qw/brand model/) { + if ($data{$_}) { + $tree->fid("dd_$_")->replace_content($data{$_}); + } else { + $tree->fid("dt_$_")->detach; + $tree->fid("dd_$_")->detach; + } + } + + for my $ahref ($tree->find('a')) { + $ahref->attr(href => "/form?highlight=$id") if $ahref->attr('href') eq '/'; + } [200, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]] } @@ -248,6 +311,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 { @@ -255,16 +357,29 @@ sub app { my $app = shift; sub { my $res = $app->(@_); - push @{$res->[2]}, $footer if $res->[0] == 200; + $res->[2][0] =~ s,,$footer, if $res->[0] == 200; $res; } }; + enable sub { + my $app = shift; + sub { + if (-f 'down.html') { + my $down_lit = HTML::Element::Library::super_literal read_file 'down.html'; + my $tree = $down->clone; + $tree->fid('content')->replace_content($down_lit); + return [503, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]] + } + $app->(@_) + } + }; 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; + mount '/display' => \&display_app; } }