List categories without headings on the admin screen

1 files changed, 9 insertions, 0 deletions

diff --git a/app/models/public_body_category.rb b/app/models/public_body_category.rb
index c0d8e07c6..2e2c8d74e 100644
--- a/app/models/public_body_category.rb
+++ b/app/models/public_body_category.rb
@@ -40,6 +40,15 @@ class PublicBodyCategory < ActiveRecord::Base
         categories
     end
 
+    def self.without_headings
+        sql = %Q| SELECT * FROM public_body_categories pbc
+                  WHERE pbc.id NOT IN (
+                      SELECT public_body_category_id AS id
+                      FROM public_body_categories_public_body_headings
+                  ) |
+        PublicBodyCategory.find_by_sql(sql)
+    end
+
     # Called from the data files themselves
     def self.add(locale, categories)
         @heading = nil