X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=lib%2FApp%2FWeb%2FOof.pm;h=405ffb52a1cae80c430216fdb7c2bb73f35d1868;hb=8526cf2b23162d75ad55a4ee7587224a921b9ec2;hp=3310dd1e6bbdaa69792723dd503371b36dbe9ba4;hpb=8bbff1bcc40acc652541fcda101bda44de264921;p=app-web-oof.git

diff --git a/lib/App/Web/Oof.pm b/lib/App/Web/Oof.pm
index 3310dd1..405ffb5 100644
--- a/lib/App/Web/Oof.pm
+++ b/lib/App/Web/Oof.pm
@@ -6,9 +6,11 @@ use warnings;
 use utf8;
 use parent qw/Plack::Component/;
 
-our $VERSION = '0.000_003';
+our $VERSION = '0.000_005';
 
 use DBIx::Simple;
+use Email::Sender::Simple 'sendmail';
+use Email::Simple;
 use File::Slurp;
 use HTML::TreeBuilder;
 use HTML::Element::Library;
@@ -62,8 +64,29 @@ sub make_slug {
 	$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};
@@ -77,7 +100,9 @@ sub form_table_row {
 sub form_app {
 	my ($env) = @_;
 	$db{$$} //= DBIx::Simple->connect($ENV{OOF_DSN} // 'dbi:Pg:');
+	my $req = Plack::Request->new($env);
 
+	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);
@@ -164,7 +189,8 @@ sub order_app {
 	my $req = Plack::Request->new($env);
 	my ($id) = $env->{PATH_INFO} =~ m,^/([0-9A-F]+),;
 	if ($id) {
-		my $total = $db{$$}->select(orders => 'total', {id => $id})->list;
+		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);
@@ -184,6 +210,14 @@ sub order_app {
 			}
 			$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: $_"]]
@@ -193,6 +227,25 @@ sub order_app {
 	}
 }
 
+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");
@@ -206,13 +259,19 @@ 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 = <static/fullpics/$id-*>;
-	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});
+	$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 '/';
+	}
 
 	[200, ['Content-type' => 'text/html; charset=utf-8'], [$tree->as_HTML]]
 }
@@ -235,7 +294,7 @@ sub app {
 			my $app = shift;
 			sub {
 				my $res = $app->(@_);
-				push @{$res->[2]}, $footer if $res->[0] == 200;
+				$res->[2][0] =~ s,</body>,$footer</body>, if $res->[0] == 200;
 				$res;
 			}
 		};