Changeset 72 for trunk/DNSDB.pm

Timestamp:

02/16/11 18:04:21 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

Checkpoint - adding sort-on-title-click to record list columns

• HTML seems complete
• Still need to store sort type, direction in session
• Still need to pass sort info into record retrieval sub in DNSDB.pm

File:

• trunk/DNSDB.pm (modified) (2 diffs)

trunk/DNSDB.pm

@@ -927 +927 @@
 ## for order, need to map input to column names
   my $order = shift || 'host';
+  my $direction = shift || 'ASC';
 
   my $sql = "SELECT record_id,host,type,val,distance,weight,port,ttl FROM ";
@@ -934 +935 @@
     $sql .= " records where domain_id=$id";
   }
-  $sql .= " and not type=$reverse_typemap{SOA} order by $order";
+  $sql .= " and not type=$reverse_typemap{SOA} order by $order $direction";
 ##fixme:  need to set nstart properly (offset is not internally multiplied with limit)
   $sql .= " limit $nrecs offset ".($nstart*$nrecs) if $nstart ne 'all';