From f41b94c1ec31bbff084b7429c1aec495aca2ab1e Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Sun, 23 Aug 2009 16:41:47 +0100 Subject: [PATCH] WIP trade plan --- yarrg/web/routetrade | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade index cb0ef93..6bc7277 100644 --- a/yarrg/web/routetrade +++ b/yarrg/web/routetrade @@ -466,6 +466,41 @@ $addcols->({ Total => 0 }, qw( +% if ($optimise) { # ========== TRADING PLAN ========== +% +% my $iquery= $dbh->prepare('SELECT islandname FROM islands +% WHERE islandid = ?'); +% +

Voyage trading plan

+ +% foreach my $i (0..$#islandids) { +Buy or sell flow +% } +% } +% } +
+% $iquery->execute($islandids[$i]); +% my ($islandname) = $iquery->fetchrow_array(); +% if (!$i) { +Start at <% $islandname |h %> +% } else { +Sail to <% $islandname |h %> +% } + +% foreach my $od (qw(dst org)) { +% my $sign= $od eq 'dst' ? -1 : +1; +% foreach my $f (sort { +% $a->{'commodname'} cmp $b->{'commodname'} +% or $sign * ($a->{"${od}_price"} <=> $b->{"${od}_price"}) +% or $a->{"${od}_stallname"} cmp $b->{"${od}_stallname"} +% } @flows) { +% next if $f->{Suppress}; +% next unless $f->{"${od}_id"} == $islandids[$i]; +% next unless $f->{OptQty}; +
+% +% } # ========== TRADING PLAN ========== + <%init> use CommodsWeb; use Commods; -- 2.30.2