X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-live.git;a=blobdiff_plain;f=yarrg%2Fweb%2Froutetrade;h=03ef3e1e8dc4ab99bfc8b29cfc8b69750268845c;hp=59b02674f1034bb82c983f803afa44e54600075b;hb=ea09579bdbec295cfe7735a262e06055a1f69835;hpb=54f130dd25e32cfeb3e52b11b50fffc2f93d18ad diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade index 59b0267..03ef3e1 100644 --- a/yarrg/web/routetrade +++ b/yarrg/web/routetrade @@ -419,6 +419,7 @@ foreach my $f (@flows) { % my $optimise= 1; +% my $opt_how; % if (!$specific) { % $optimise= 0; @@ -505,7 +506,7 @@ foreach my $ci (0..($#islandids-1)) { } #print " RELEVANT $ci COUNT ".scalar(@rel_subflows)." "; if (!@rel_subflows) { - foreach my $mv (qw(mass volume)) { + foreach my $mv (qw(mass volume capital)) { $sail_total[$ci]{$mv}= 0; } next; @@ -580,16 +581,23 @@ if ($qa->{'debug'}) { <%perl> } -{ +my $try_solve= sub { + my ($how, @opts) = @_; my $input= pipethrough_prep(); print $input $cplex or die $!; my $output= pipethrough_run_along($input, undef, 'glpsol', - qw(glpsol --tmlim 5 --memlim 5 --intopt --cuts --bfs - --cpxlp /dev/stdin -o /dev/stdout)); - print "
\n" if $qa->{'debug'};
+		qw(glpsol --tmlim 5 --memlim 20), @opts,
+		qw( --cpxlp /dev/stdin -o /dev/stdout));
+	if ($qa->{'debug'}) {
+		print "

@opts

\n
\n";
+	}
+	$expected_total_profit= undef;
+	$_->{OptQty}= undef foreach @subflows;
 	my $found_section= 0;
 	my $glpsol_out= '';
 	my $continuation='';
+	my $timelimit= 0;
+	my $somemip= 0;
 	while (<$output>) {
 		$glpsol_out.= $_;
 		print encode_entities($_) if $qa->{'debug'};
@@ -598,6 +606,14 @@ if ($qa->{'debug'}) {
 			$found_section= 1;
 			next;
 		}
+		if ((m/^Integer optimization begins/ .. 0) &&
+		    m/^\+ \s* \d+\: \s* mip \s* = \s* \d/) {
+			$somemip= 1;
+			next;
+		}
+		if (m/^TIME LIMIT EXCEEDED/) {
+			$timelimit= 1;
+		}
 		if (m/^Objective:\s+totalprofit = (\d+(?:\.\d*)?) /) {
 			$expected_total_profit= $1;
 		}
@@ -618,7 +634,7 @@ if ($qa->{'debug'}) {
 		my ($varname, $qty) = m/^
 			\s* \d+ \s+
 			(\w+) \s+ (?: [A-Z*]+ \s+ )?
-			([+-e0-9.]+) \s
+			([-+0-9]+)(?: [.e][-+e0-9.]* )? \s
 			/x or die "$cplex \n==\n $glpsol_out $_ ?";
 		if ($varname =~ m/^f(\d+)s(\d+)_/) {
 			my ($ix,$orgix) = ($1,$2);
@@ -630,7 +646,7 @@ if ($qa->{'debug'}) {
 			$sf->{OptQty}= $qty;
 			$sf->{OptProfit}= $qty * $flow->{'unitprofit'};
 			$sf->{OptCapital}= $qty * $flow->{'org_price'};
-		} elsif ($varname =~ m/^(mass|volume)_(\d+)$/) {
+		} elsif ($varname =~ m/^(mass|volume|capital)_(\d+)$/) {
 			my ($mv,$ix) = ($1,$2);
 			$sail_total[$ix]{$mv}= $qty;
 		}
@@ -640,8 +656,28 @@ if ($qa->{'debug'}) {
 	pipethrough_run_finish($output,$prerr);
 	map { defined $_->{OptQty} or die "$prerr $_->{Flow}{Ix}" } @subflows;
 	defined $expected_total_profit or die "$prerr ?";
+	return 0 unless $somemip || !$timelimit;
+	$opt_how= $how;
+	return 1;
 };
 
+unless ($try_solve->('Optimisation successful',
+		     qw( --intopt --cuts --bfs )) or
+	$try_solve->('Complex problem, downgraded'.
+		     ' to rounded-down LP.',
+		     qw( --nomip ))) {
+
+

Optimisation failed

+The linear/mixed-integer optimisation failed. +Please report this problem. + +
+<% $cplex |h %>
+
+<%perl> + return; +} + $addcols->({ DoReverse => 1, TotalSubflows => 1, Special => sub { my ($flow,$col,$v,$spec) = @_; if ($flow->{ExpectedUnitProfit} < 0) { @@ -664,9 +700,9 @@ $addcols->({ Total => 0, DoReverse => 1, TotalSubflows => 1 }, qw(

Contents

% } else { @@ -688,51 +724,57 @@ Generated by YARRG at <% % } % if ($optimise) { # ========== TRADING PLAN ========== -% -% my $iquery= $dbh->prepare('SELECT islandname FROM islands -% WHERE islandid = ?'); -% my %da_ages; -% my $total_total= 0; -% my $total_dist= 0; -% -

Voyage trading plan

+<%perl> +my $iquery= $dbh->prepare('SELECT islandname FROM islands + WHERE islandid = ?'); +my %da_ages; +my $total_total= 0; +my $total_dist= 0; +my @oldest= (-1, 'nowhere'); +my $plan_html= ''; + +my $plan_table_info= printable($m) ? 'width=100%' : ''; +$plan_html .= < +END - > -% my $tbody= sub { -% if (!printable($m)) { return ''; } -%# return " -% $iquery->execute($islandids[$i]); -% my ($islandname) = $iquery->fetchrow_array(); -% if (!$i) { +my $tbody= sub { + if (!printable($m)) { return ''; } + my ($c)= qw(40 00)[$_[0]]; + return "\n"; + $iquery->execute($islandids[$i]); + my ($islandnamepr)= encode_entities( $iquery->fetchrow_array() ); + + if (!$i) { + $plan_html .= < -Start at <% $islandname |h %> +Start at $islandnamepr -% } -<%perl> +END + } my $age_reported= 0; my %flowlists; #print " -

"; -% my ($c)= qw(40 00)[$_[0]]; -% return "
"; -% }; -% -% foreach my $i (0..$#islandids) { -<% $tbody->(1) %> -
"; +}; + +foreach my $i (0..$#islandids) { + $plan_html .= $tbody->(1); + $plan_html .= "
[what are these codes?] -% } else { -% my $this_dist= $distance->($islandids[$i-1],$islandids[$i]); -% $total_dist += $this_dist; +END + } else { + my $this_dist= $distance->($islandids[$i-1],$islandids[$i]); + $total_dist += $this_dist; + $plan_html .= < -<%perl> +END my $total_value= 0; foreach my $sf (@subflows) { next unless $sf->{Org} < $i && $sf->{Dst} >= $i; $total_value += $sf->{OptQty} * $sf->{Flow}{'dst_price'}; } - -Sail to <% $islandname |h %> -- <% $this_dist |h %> leagues, - <% $total_value %>poe at risk + $plan_html .= <Sail to $islandnamepr +- $this_dist leagues, $total_value poe at risk
" if $qa->{'debug'}; @@ -817,66 +859,72 @@ END my ($xinfo) = @_; return unless defined $total_to_show; my ($totaldesc,$totalwas) = @$total_to_show; - + $plan_html .= < -<% $xinfo %> -<% $totaldesc %> -<% $totalwas |h %> total -<%perl> +$xinfo +$totaldesc +$totalwas total +END $total_to_show= undef; }; - -% my $show_flows= sub { -% my ($od,$arbitrage,$collectdeliver) = @_; -% my $todo= $flowlists{$od}; -% return unless $todo; -% foreach my $tkey (sort keys %$todo) { -% my $t= $todo->{$tkey}; -% next if $t->{"${od}Arbitrage"} != $arbitrage; -% $show_total_now->(''); -% if (!$age_reported++) { -% my $age= $now - $t->{Timestamp}; -% my $cellid= "da_${i}"; -% $da_ages{$cellid}= $age; -\ -(Data age: <% prettyprint_age($age) %>) -% } elsif (!defined $total) { -% $total= 0; -<% $tbody->(0) %> -% } -% $total += $t->{Total}; -% my $span= 0 + keys %{ $t->{Stalls} }; -% my $td= "td rowspan=$span"; -% my %linkqf= (%{ $qa->{'baseqf'} }, %{ $qa->{'queryqf'} }); -% $linkqf{'query'}= 'commod'; -% $linkqf{'commodstring'}= $t->{'commodname'}; -% $linkqf{'commodid'}= $t->{'commodid'}; -% tr_datarow($m,$dline); -<<% $td %>><% $collectdeliver %> -<<% $td %>><% $t->{'commodname'} |h %> -<<% $td %>><% $t->{'posinclass'} %> -% -% my @stalls= sort keys %{ $t->{Stalls} }; -% my $pstall= sub { -% my $name= $stalls[$_[0]]; -<% $name |h %> -% }; -% -% $pstall->(0); -<<% $td %> align=right><% $t->{Price} |h %> poe ea. -<<% $td %> align=right><% $t->{Qty} |h %> unit(s) -<<% $td %> align=right><% $t->{Total} |h %> total -% -% foreach my $stallix (1..$#stalls) { -% tr_datarow($m,$dline); -% $pstall->($stallix); -% } -% -% $dline ^= 1; -% } -% }; -<%perl> + my $show_flows= sub { + my ($od,$arbitrage,$collectdeliver) = @_; + my $todo= $flowlists{$od}; + return unless $todo; + foreach my $tkey (sort keys %$todo) { + my $t= $todo->{$tkey}; + next if $t->{"${od}Arbitrage"} != $arbitrage; + $show_total_now->(''); + if (!$age_reported++) { + my $age= $now - $t->{Timestamp}; + @oldest= ($age,$islandnamepr) if $oldest[0] < $age; + my $cellid= "da_${i}"; + my $agepr= prettyprint_age($age); + $da_ages{$cellid}= $age; + $plan_html .= <(Data age: $agepr) +END + } elsif (!defined $total) { + $total= 0; + $plan_html .= $tbody->(0); + } + $total += $t->{Total}; + my $span= 0 + keys %{ $t->{Stalls} }; + my $td= "td rowspan=$span"; + my %linkqf= (%{ $qa->{'baseqf'} }, %{ $qa->{'queryqf'} }); + $linkqf{'query'}= 'commod'; + $linkqf{'commodstring'}= $t->{'commodname'}; + $linkqf{'commodid'}= $t->{'commodid'}; + my $linkqfpr= encode_entities( $quri->(%linkqf) ); + my $commodnamepr= encode_entities($t->{'commodname'}); + $plan_html .= tr_datarow_s($m,$dline) . <$collectdeliver +<$td>$commodnamepr +<$td>$t->{'posinclass'} +END + my @stalls= sort keys %{ $t->{Stalls} }; + my $pstall= sub { + my $namepr= encode_entities( $stalls[$_[0]] ); + $plan_html .= <$namepr +END + }; + + $pstall->(0); + $plan_html .= <$t->{Price} poe ea. +<$td align=right>$t->{Qty} unit(s) +<$td align=right>$t->{Total} total +END + foreach my $stallix (1..$#stalls) { + $plan_html .= tr_datarow_s($m,$dline); + $pstall->($stallix); + } + + $dline ^= 1; + } + }; $show_flows->('dst',0,'Deliver'); $show_total->('Proceeds',1); $show_flows->('org',1,'Collect'); $show_total->('(Arbitrage) outlay',-1); @@ -900,23 +948,65 @@ END } $show_total_now->($totals); } - -<% $tbody->(1) %>
Total distance: <% $total_dist %> leagues. + +my $cashflowpr= $total_total < 0 + ? -$total_total." loss" + : $total_total." gain"; + +my $max_capital= 0; +foreach my $cap (map { $_->{capital} } @sail_total) { + $max_capital= $cap if $cap > $max_capital; +} + +$da_ages{'oldest'}= $oldest[0]; + +$plan_html .= $tbody->(1) . < +Total distance: $total_dist leagues. Overall net cash flow -<% - $total_total < 0 ? -$total_total." loss" : $total_total." gain" - %> +$cashflowpr
+END + + +% if (!printable($m)) { +

Summary

+% } + + + + + + + + +
Distance: + <% $total_dist %> leagues, + <% scalar(@islandids) %> island(s) +
Planned net cash flow: + <% $cashflowpr %> +
Expected profit on average: approx. + + <% sprintf "%d", $expected_total_profit %> poe + (considering expected losses, but ignoring rum consumed) +
Capital required: + + <% $max_capital %> poe or less +
Oldest market data used: + <% prettyprint_age($oldest[0]) %> + (<% $oldest[1] %>) +
<% $opt_how %> +
+

+ +

Voyage trading plan

+<% $plan_html %> <& query_age:dataages, id2age => \%da_ages &> -Expected average profit: - approx. <% sprintf "%d", $expected_total_profit %> poe - (considering expected losses, but ignoring rum consumed) % % } # ========== TRADING PLAN ========== % if (!printable($m)) { -

Data age summary

+

Relevant data ages

<%perl> my $sth_i= $dbh->prepare(<