Fix sh/dx on 14050 so it works as expected

[spider.git] / cmd / show / dx.pl

diff --git a/cmd/show/dx.pl b/cmd/show/dx.pl
index 0728c650dbd20918d580788d91f0bcd52fa9c537..b513c614495ac40a13dc00854903da5e4a8194e0 100644 (file)
--- a/cmd/show/dx.pl
+++ b/cmd/show/dx.pl
@@ -1,7 +1,7 @@
 #
 # show dx (normal)
 #
-# $Id$
+#
 #
 
 my ($self, $line) = @_;
@@ -27,11 +27,14 @@ my $state;
 my $bystate;
 my $itu;
 my $byitu;
-my $fromdxcc;
+my $fromdxcc = 0;
+my $exact;
 my ($doqsl, $doiota, $doqra, $dofilter);
 
+my $usesql = $main::dbh && $Spot::use_db_for_search;
+
 while ($f = shift @list) {             # next field
-       #  print "f: $f list: ", join(',', @list), "\n";
+       dbg "arg: $f list: " . join(',', @list) if isdbg('shdx');
        if (!$from && !$to) {
                ($from, $to) = $f =~ m|^(\d+)[-/](\d+)$|; # is it a from -> to count?
                next if $from && $to > $from;
@@ -40,6 +43,10 @@ while ($f = shift @list) {           # next field
                ($to) = $f =~ /^(\d+)$/o if !$to; # is it a to count?
                next if $to;
        }
+       if (lc $f eq 'exact') {
+               $exact = 1;
+               next;
+       }
        if (lc $f eq 'dxcc') {
                $dxcc = 1;
                next;
@@ -49,17 +56,19 @@ while ($f = shift @list) {          # next field
                next;
        }
        if (lc $f eq 'on' && $list[0]) { # is it freq range?
-               #    print "yup freq\n";
-               if ($list[0] =~ m|^(\d+)(?:\.\d+)?[-/](\d+)(?:\.\d+)?$|) {
-                       push @freq, $1, $2;
+               dbg "freq $list[0]" if isdbg('shdx');
+               if (my ($from, $to) = $list[0] =~ m|^(\d+)(?:\.\d+)?(?:[-/](\d+)(?:\.\d+)?)?$|) {
+                       $to = $from unless defined $to;
+                       dbg "freq '$from' '$to'" if isdbg('shdx');
+                       push @freq, $from, $to;
                        shift @list;
                        next;
                } else {
                        my @r = split '/', lc $list[0];
-                       # print "r0: $r[0] r1: $r[1]\n";
+                       dbg "r0: $r[0] r1: $r[1]" if isdbg('shdx');
                        my @fr = Bands::get_freq($r[0], $r[1]);
                        if (@fr) {                      # yup, get rid of extranous param
-                               #         print "freq: ", join(',', @fr), "\n";
+                               dbg "freq: " . join(',', @fr) if isdbg('shdx');
                                push @freq, @fr;    # add these to the list
                                shift @list;
                                next;
@@ -67,22 +76,22 @@ while ($f = shift @list) {          # next field
                }
        }
        if (lc $f eq 'day' && $list[0]) {
-               #   print "got day\n";
                ($fromday, $today) = split m|[-/]|, shift(@list);
+               dbg "got day $fromday/$today" if isdbg('shdx');
                next;
        }
        if (lc $f eq 'info' && $list[0]) {
-               #   print "got info\n";
                $info = shift @list;
+               dbg "got info $info" if isdbg('shdx');
                next;
        }
        if ((lc $f eq 'spotter' || lc $f eq 'by') && $list[0]) {
-               #    print "got spotter\n";
                $spotter = uc shift @list;
                if ($list[0] && lc $list[0] eq 'dxcc') {
                        $fromdxcc = 1;
                        shift @list;
                }
+               dbg "got spotter $spotter fromdxcc $fromdxcc" if isdbg('shdx');
                next;
        }
        if (lc $f =~ /^filt/) {
@@ -173,8 +182,14 @@ if ($pre) {
                }
        } 
        unless (@ans) {
-               $pre .= '*' unless $pre =~ /[\*\?\[]/o;
+               $pre .= '*' unless $pre =~ /[\*\?\[]$/o;
                $pre = shellregex($pre);
+               if ($usesql) {
+                       $pre =~ s/\.\*/%/g;
+               } else {
+                       $pre =~ s/\.\*\$$//;
+               }
+               $pre .= '$' if $exact;
                $expr = "\$f1 =~ m{$pre}";
                $pre =~ s/[\^\$]//g;
                $hint = "m{\U$pre}";
@@ -245,6 +260,11 @@ if ($spotter) {
                $expr .= ' && ' if $expr;
                $spotter .= '*' unless $spotter =~ /[\*\?\[]/o;
                $spotter = shellregex($spotter);
+               if ($usesql) {
+                       $spotter =~ s/\.\*/%/g;
+               } else {
+                       $spotter =~ s/\.\*\$$//;
+               }
                $expr .= "\$f4 =~ m{\U$spotter}";
                $hint .= ' && ' if $hint;
                $spotter =~ s/[\^\$]//g;
@@ -314,7 +334,7 @@ if ($state) {
                push @expr, "\$f12 eq '$_'";
                push @hint, "m{$_}";
        }
-       if ($main::dbh) {
+       if ($usesql) {
                $expr .= @expr > 1 ? '(' . join(' || ', @expr) . ')' : "$expr[0]";
        } else {
                $expr .= @expr > 1 ? '(\$f12 && (' . join(' || ', @expr) . '))' : "(\$f12 && $expr[0])";
@@ -330,7 +350,7 @@ if ($bystate) {
                push @expr, "\$f13 eq '$_'";
                push @hint, "m{$_}";
        }
-       if ($main::dbh) {
+       if ($usesql) {
                $expr .= @expr > 1 ? '(' . join(' || ', @expr) . ')' : "$expr[0]";
        } else {
                $expr .= @expr > 1 ? '(\$f13 && (' . join(' || ', @expr) . '))' : "(\$f13 && $expr[0])";
@@ -362,7 +382,7 @@ if ($doqra) {
        $hint .= "m{$doqra}io";
 }
 
-#print "expr: $expr from: $from to: $to fromday: $fromday today: $today\n";
+dbg "expr: $expr from: $from to: $to fromday: $fromday today: $today" if isdbg('sh/dx');
   
 # now do the search
 my @res = Spot::search($expr, $fromday, $today, $from, $to, $hint, $dofilter ? $self : undef);