Changeset 395 for branches/stable/cgi-bin/search.cgi

Timestamp:

02/19/10 16:24:54 (15 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Finish basic node tracking - add link in header, extend search tool to

handle the appropriate lookup

File:

• branches/stable/cgi-bin/search.cgi (modified) (1 diff)

branches/stable/cgi-bin/search.cgi

@@ -187 +187 @@
     printError "No matches found.  Try eliminating one of the criteria,".
         " or making one or more criteria more general.";
+  } else {
+    # Add the limit/offset clauses
+    $sql .= " order by cidr";
+    $sql .= " limit $RESULTS_PER_PAGE offset $offset" if $RESULTS_PER_PAGE != 0;
+    # And tell the user.
+    print "<div class=heading>Searching...............</div>\n";
+    queryResults($sql, $webvar{page}, $count);
+  }
+
+} elsif ($webvar{stype} eq 'n') {
+  # Node search.
+
+  my $sql = "SELECT cidr,custid,type,city,description FROM searchme".
+        " WHERE cidr IN (SELECT block FROM noderef WHERE node_id=$webvar{node})";
+
+  # Find the offset for multipage results
+  my $offset = ($webvar{page}-1)*$RESULTS_PER_PAGE;
+
+  # Find out how many rows the "core" query will return.
+  my $count = countRows($sql);
+
+  if ($count == 0) {
+    printError "No customers currently listed as connected through this node.";
   } else {
     # Add the limit/offset clauses