use utf8;
use parent qw/Plack::Component/;
-our $VERSION = '0.000_004';
+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 {
##################################################
+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 {
$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 }
$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};
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);
}
$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;
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: $_"]]
$db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:');
my $tree = $details->clone;
my ($id) = $env->{PATH_INFO} =~ m,^/(\d+),;
- my ($title, $summary) = $db{$$}->select(products => [qw/title summary/], {product => $id})->list;
+ my %data = %{$db{$$}->select(products => '*', {product => $id})->hash};
my @pics = <static/fullpics/$id-*>;
- my $slug = make_slug $title;
- $tree->find('title')->replace_content("Pictures of $title | ledparts4you");
- $tree->find('h2')->replace_content($title);
- $tree->fid('summary')->replace_content($summary);
+ 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]]
}
[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 {
$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;
}
}
projects / app-web-oof.git / blobdiff