From 6a688141978ccd79300218f48cce9a42e1ad1a91 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Mon, 17 Jul 2006 06:22:32 +0000
Subject: Bug 277377: Classifications should support sort keys - Patch by Olav
 Vitters <bugzilla-mozilla@bkor.dhs.org> r=LpSolit a=justdave

---
 Bugzilla/Classification.pm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/Classification.pm')

diff --git a/Bugzilla/Classification.pm b/Bugzilla/Classification.pm
index 63a826dc3..3d264b704 100644
--- a/Bugzilla/Classification.pm
+++ b/Bugzilla/Classification.pm
@@ -31,6 +31,7 @@ use constant DB_COLUMNS => qw(
     classifications.id
     classifications.name
     classifications.description
+    classifications.sortkey
 );
 
 our $columns = join(", ", DB_COLUMNS);
@@ -122,6 +123,7 @@ sub products {
 sub id          { return $_[0]->{'id'};          }
 sub name        { return $_[0]->{'name'};        }
 sub description { return $_[0]->{'description'}; }
+sub sortkey     { return $_[0]->{'sortkey'};     }
 
 ###############################
 ####      Subroutines      ####
@@ -131,7 +133,7 @@ sub get_all_classifications {
     my $dbh = Bugzilla->dbh;
 
     my $ids = $dbh->selectcol_arrayref(q{
-        SELECT id FROM classifications ORDER BY name});
+        SELECT id FROM classifications ORDER BY sortkey, name});
 
     my @classifications;
     foreach my $id (@$ids) {
-- 
cgit v1.2.3-24-g4f1b