X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fweb%2Fquery_routesearch;h=b6d543fae1c7c122c72485a36c5bf30146f4505b;hb=757318e3924059c13338aada3b29d668c20f6c36;hp=93fcf0bc1bda2c57d793b0ed7a7b3e196ab12494;hpb=20bea992a857ea1f03f19d81f7164b113a560e83;p=ypp-sc-tools.web-live.git

diff --git a/yarrg/web/query_routesearch b/yarrg/web/query_routesearch
index 93fcf0b..b6d543f 100644
--- a/yarrg/web/query_routesearch
+++ b/yarrg/web/query_routesearch
@@ -46,13 +46,19 @@ $emsgokorprint
 </%args>
 
 <%perl>
+use BSD::Resource;
+
 my $emsg;
 my @warningfs;
 my @islandids;
 
+my $maxmaxdist=35;
+my $maxcpu=90;
+
 my $qa= \%ARGS;
 my $routeparams= { EmsgRef => \$emsg, SayRequiredCapacity => 1 };
 my $maxdist;
+my $maxcountea=10;
 
 </%perl>
 
@@ -91,7 +97,141 @@ This feature is not available from the "drop down menus" interface.
 </form>
 <%perl>
 
+if (!$emsg && $maxdist > $maxmaxdist) {
+	$emsg= "Searching for routes of more than $maxmaxdist leagues is not".
+		" supported, sorry.";
+}
+
 $emsgokorprint->($emsg) or return;
 @islandids or return;
+defined $routeparams->{MaxMass} or defined $routeparams->{MaxVolume} or return;
+
+#---------- prepare island names ----------
+
+my $islandname_stmt= $dbh->prepare(<<END);
+	SELECT islandname, archipelago
+	  FROM islands
+	 WHERE islandid = ?
+END
+
+my $isleinfo = sub {
+	my ($id) = @_;
+	$islandname_stmt->execute($id);
+	my $row= $islandname_stmt->fetchrow_hashref();
+	local $_= $row->{'islandname'};
+	s/ Island$//;
+	return $_, $row->{'archipelago'};
+};
+
+#---------- compute the results ----------
+
+my @rsargs= qw(-DN);
+
+foreach my $k (qw(MaxMass MaxVolume MaxCapital)) {
+	my $v= $routeparams->{$k};
+	push @rsargs, (defined $v ? $v : -1);
+}
+push @rsargs, defined $routeparams->{LossPerLeaguePct}
+	? $routeparams->{LossPerLeaguePct}*0.01 : 1e-9;
+push @rsargs, '0';
+push @rsargs, 'search',$maxdist, $maxcountea,$maxcountea, 'any', @islandids;
+
+m/[^-.0-9a-zA-Z]/ and die "$_ $& ?" foreach @rsargs;
+
+if ($qa->{'debug'}) {
+</%perl>
+[[ <% "@rsargs" |h %> ]]<br><pre>
+<%perl>
+}
+
+unshift @rsargs, sourcebasedir().'/yarrg/routesearch',
+	'-d', dbw_filename($qa->{'Ocean'});
+
+my %results; # $results{$ap}{"5 6 9 10"} = { stuff }
+
+my $fh= new IO::File;
+my $child= $fh->open("-|"); defined $child or die $!;
+if (!$child) {
+	my $cpu= BSD::Resource::RLIMIT_CPU;
+	my ($soft,$hard)= getrlimit($cpu);
+	setrlimit($cpu,$maxcpu,$hard) or die $! if $hard<=$maxcpu;
+	exec @rsargs;
+	die $!;
+}
+
+while (<$fh>) {
+	chomp;
+	if ($qa->{'debug'}) {
+</%perl>
+<% $_ |h %>
+<%perl>
+	}
+	next unless
+  m/^ \@ *\d+ ([ap])\# *\d+ \|.*\| *\d+ +(\d+) +(\d+) *\| ([0-9 ]+)$/;
+	my ($ap,$isles) = (uc $1,$4);
+	next if $results{$ap} && %{$results{$ap}} >= $maxcountea;
+	my $item= { A => $2, P => $3 };
+	my (@i, @a);
+	foreach (split / /, $isles) {
+		my ($name,$arch)= $isleinfo->($_);
+		push @i, $name;
+		push @a, $arch unless @a && $a[-1] eq $arch;
+	}
+	$item->{Isles}= [ @i ];
+	$item->{Archs}= [ @a ];
+	$item->{Start}= $i[0];
+	$item->{Finish}= $i[-1];
+	$item->{Vias}= [ ];
+	my $i;
+	for ($i=1; $i < @i-1; $i++) {
+		push @{ $item->{Vias} }, $i[$i];
+	}
+	$results{$ap}{$isles}= $item;
+}
+
+if ($qa->{'debug'}) {
+	print "</pre>\n";
+}
+
+</%perl>
+% foreach my $ap (qw(A P)) {
+<h2>ap=<% $ap %></h2>
+<table rules=groups>
+<colgroup span=2>
+<colgroup span=1>
+<colgroup span=3>
+<tbody>
+<tr>
+<th colspan=2>Profit
+<th>Archipelagoes
+<th colspan=3>Route
+<tr>
+<th>Abs.
+<th>Per.lg.
+<th>
+<th>Start
+<th>Via
+<th>Finish
+<tbody>
+%	my $datarow=0;
+%	foreach my $isles (sort {
+%			$results{$ap}{$b}{$ap} <=>
+%			$results{$ap}{$a}{$ap}
+%		} keys %{$results{$ap}}) {
+%		my $item= $results{$ap}{$isles};
+<tr class="datarow<% $datarow %>">
+<td align=right><% $item->{A} |h %>
+<td align=right><% $item->{P} |h %>
+<td align=left><% join ', ', @{ $item->{Archs} } |h %>
+<td align=left><% $item->{Start} |h %>,
+<td align=left><% join ' ', map { $_.',' } @{ $item->{Vias} } |h %>
+<td align=left><% $item->{Finish} |h %>
+</td>
+%		$datarow ^= 1;
+%	} # $isles
+</table>
+% } # $ap
+<%perl>
+
 
 </%perl>