Changeset 909

Timestamp:

08/17/17 16:17:38 (7 years ago)

Author:

Kris Deugau

Message:

/trunk

Promote single-letter type searches to "class" searches
Add filtering on "available"

File:

• trunk/cgi-bin/search-rpc.cgi (modified) (2 diffs)

trunk/cgi-bin/search-rpc.cgi

@@ -162 +162 @@
 
   if ($args{type}) {
+    # assume alloctype class if we only get one letter
+    $args{type} = "_$args{type}" if $args{type} =~ /^.$/;
     my $notflag = '';
     if ($args{type} =~ /^NOT:/) {
@@ -235 +237 @@
   }
 
+  # Filter on "available", because we can.
+  if ($args{available} && $args{available} =~ /^[yn]$/) {
+    push @fields, "s.available";
+    push @matchtypes, '=';
+    push @vals, $args{available};
+  }
+
   my $cols = "s.cidr, s.custid, s.type, s.city, s.description, s.id, s.parent_id, s.available, s.vrf, a.dispname";
   my $sql = qq(SELECT $cols FROM searchme s JOIN alloctypes a ON s.type = a.type);