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%2Fquery_routesearch;h=9c583b8899338489228249fef319dc360e7d3883;hp=c45b56a06690f51173d15a918b17121c8dc647ea;hb=59316f0dcddd4e5d15e47dfde36f513e1685c4ae;hpb=b003b70daab49984677a1cfadced9da9ee9be19a diff --git a/yarrg/web/query_routesearch b/yarrg/web/query_routesearch index c45b56a..9c583b8 100644 --- a/yarrg/web/query_routesearch +++ b/yarrg/web/query_routesearch @@ -36,13 +36,17 @@ <%args> $quri $dbh +$baseqf $queryqf $islandstring => ''; $capacitystring => ''; $lossperleague => ''; $capitalstring => ''; $distance => ''; +$prselector +$someresults $emsgokorprint +$allargs <%perl> @@ -63,12 +67,15 @@ my $maxcountea=15; +

Find most profitable routes and trades

% if ($qa->{Dropdowns}) { This feature is not available from the "drop down menus" interface. % } else { +% $prselector->('RouteSearchType'); +
<& enter_route, qa=>$qa, dbh=>$dbh, emsg_r=>\$emsg, warningfs_r=>\@warningfs, @@ -89,13 +96,15 @@ This feature is not available from the "drop down menus" interface. - + % my $ours= sub { $_[0] =~ m/^lossperleague|^islandstring|^capitalstring|^capacitystring|^distance/; }; <& "lookup:formhidden", ours => $ours &> % }
+
+
<%perl> if (!$emsg && $maxdist > $maxmaxdist) { @@ -103,9 +112,12 @@ if (!$emsg && $maxdist > $maxmaxdist) { " supported, sorry."; } -$emsgokorprint->($emsg) or return; -@islandids or return; -defined $routeparams->{MaxMass} or defined $routeparams->{MaxVolume} or return; +print("
"), return + unless $emsgokorprint->($emsg) + and @islandids + and $allargs->{'submit'} + and (defined $routeparams->{MaxMass} or + defined $routeparams->{MaxVolume}); #---------- prepare island names ---------- @@ -136,7 +148,9 @@ foreach my $k (qw(MaxMass MaxVolume MaxCapital)) { push @rsargs, defined $routeparams->{LossPerLeaguePct} ? $routeparams->{LossPerLeaguePct}*0.01 : 1e-9; push @rsargs, '0'; -push @rsargs, 'search',$maxdist, $maxcountea,$maxcountea, 'any', @islandids; +push @rsargs, 'search',$maxdist, $maxcountea,$maxcountea; +push @rsargs, $ARGS{RouteSearchType} ? 'circ' : 'any'; +push @rsargs, @islandids; m/[^-.0-9a-zA-Z]/ and die "$_ $& ?" foreach @rsargs; @@ -147,7 +161,7 @@ if ($qa->{'debug'}) { } unshift @rsargs, - sourcebasedir().'/yarrg/routesearch', + 'nice', sourcebasedir().'/yarrg/routesearch', '-d', dbw_filename($qa->{'Ocean'}), '-C', webdatadir().'/_concur.', '.lock'; @@ -198,10 +212,13 @@ while (<$fh>) { for ($i=1; $i < @i-1; $i++) { push @{ $item->{Vias} }, $i[$i]; } - my %linkqf= %$queryqf; + my %linkqf= (%$baseqf, %$queryqf); delete $linkqf{'query'}; $linkqf{'routestring'}= join ', ', @fi; $item->{Url}= $quri->(%linkqf); + $item->{ArchesString}= join ', ', @a; + $item->{ViasString}= join ' ', map { $_.',' } @{ $item->{Vias} }; + $item->{RouteSortString}= join ', ', @i; $results{$ap}{$isles}= $item; } @@ -252,6 +269,8 @@ seconds of CPU time so more processing resources should be available soon. return; } +$someresults->(); + % foreach my $ap (qw(A P)) { % if ($ap eq 'A') { @@ -259,44 +278,66 @@ seconds of CPU time so more processing resources should be available soon. % } else {

Best routes for profit per league

% } - +
- + +% my $ci=0; +% my $rowid= "r${ap}$isles"; $rowid =~ y/ /_/; +% foreach my $k (qw(A P Leagues ArchesString +% Start RouteSortString Finish)) { +% $sortkeys{$ci}{$rowid}= $item->{$k}; +% $ci++; +% } + % $datarow ^= 1; % } # $isles
Profit Dist. Archipelagoes -Route + +Route +
Abs. Per.lg. - +(link to plan) Start Via Finish -
% my $datarow=0; +% my %sortkeys; % foreach my $isles (sort { % $results{$ap}{$b}{$ap} <=> % $results{$ap}{$a}{$ap} % } keys %{$results{$ap}}) { % my $item= $results{$ap}{$isles}; -
<% $item->{A} |h %> <% $item->{P} |h %> <% $item->{Leagues} |h %> -<% join ', ', @{ $item->{Archs} } |h %> +<% + $item->{ArchesString} |h %> <% $item->{Start} |h %>, -<% join ' ', map { $_.',' } @{ $item->{Vias} } |h %> +<% $item->{ViasString} |h %> <% $item->{Finish} |h %>
+<&| tabsort, table => "ap${ap}_table", sortkeys => "ap${ap}_sortkeys", + throw => "ap${ap}_sortrow", rowclass => "datarow", cols => [ + { DoReverse => 1, Numeric => 1 }, + { DoReverse => 1, Numeric => 1 }, + { DoReverse => 1, Numeric => 1 }, + { }, + { }, + { }, + { }, + ] &> + ap<% $ap %>_sortkeys= <% to_json_protecttags(\%sortkeys) %>; + % } # $ap

@@ -308,7 +349,4 @@ Per league values count each island visited as one to be sailed. All profit figures are somewhat approximate; get a complete trading plan for a route for accurate information. -<%perl> - - - +