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=59a856631b5a1cfdc042664a3d7c67815453c61f;hp=27cf295d19376abb8451f7dbba43f972a7aab100;hb=a0835ba69f333931705bf31f39b82339e7c5b16a;hpb=5d7aa1e2df29f74f0fbaa8dcb21fa1f7921f30a8 diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade index 27cf295..59a8566 100644 --- a/yarrg/web/routetrade +++ b/yarrg/web/routetrade @@ -638,14 +638,18 @@ Generated by YARRG at <% % % foreach my $i (0..$#islandids) { <% $tbody->(1) %> - + % $iquery->execute($islandids[$i]); % my ($islandname) = $iquery->fetchrow_array(); % if (!$i) { + Start at <% $islandname |h %> +[what are these codes?] + % } else { % my $this_dist= $distance->($islandids[$i-1],$islandids[$i]); % $total_dist += $this_dist; + <%perl> my $total_value= 0; foreach my $sf (@subflows) { @@ -689,18 +693,31 @@ Generated by YARRG at <% } unless $$todo; $$todo->{'commodname'}= $f->{'commodname'}; $$todo->{'posinclass'}= ''; - if ($f->{'posinclass'}) { - my $findclass= $dbh->prepare(<{'posinclass'}; + + my $findclass= $dbh->prepare(<execute($f->{'commodclassid'}); - my $classinfo= $findclass->fetchrow_hashref(); + $findclass->execute($f->{'commodclassid'}); + my $classinfo= $findclass->fetchrow_hashref(); + if ($classinfo) { + my $clname= $classinfo->{'commodclass'}; + my $desc= encode_entities(sprintf "%s is under %s", + $f->{'commodname'}, $clname); + my $abbrev= substr($clname,0,1); + if ($incl) { + my $maxpic= $classinfo->{'maxposinclass'}; + $desc.= (sprintf ", commodity %d of %d", + $incl, $maxpic); + if ($classinfo->{'maxposinclass'} >= 8) { + my @tmbs= qw(0 1 2 3 4 5 6 7 8 9); + my $tmbi= ($incl+0.5)*$#tmbs/$maxpic; + $abbrev.= " ".$tmbs[$tmbi]." "; + } + } $$todo->{'posinclass'}= - sprintf "(%s %d/%d)", - $classinfo->{'commodclass'}, - $f->{'posinclass'}, - $classinfo->{'maxposinclass'} - if $classinfo->{'maxposinclass'} > 9; + "
" + .$abbrev."
"; } $$todo->{'stallname'}= $stallname; $$todo->{Price}= $price; @@ -764,7 +781,7 @@ END % tr_datarow($m,$dline); <<% $td %>><% $collectdeliver %> <<% $td %>><% $t->{'commodname'} |h %> -<<% $td %>><% $t->{'posinclass'} |h %> +<<% $td %>><% $t->{'posinclass'} %> % % my @stalls= sort keys %{ $t->{Stalls} }; % my $pstall= sub {