From 61e8e75f45382cfa5ad6a52be58c9744dee8cba8 Mon Sep 17 00:00:00 2001
From: Jonathan Prykop <jonathan@freeside.biz>
Date: Sat, 19 Sep 2015 20:32:00 -0500
Subject: [PATCH] RT#37488: Tower/sector selection box is showing disabled
 towers [removed disabled when using tower_sector]

---
 httemplate/elements/select-tower_sector.html | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/httemplate/elements/select-tower_sector.html b/httemplate/elements/select-tower_sector.html
index 458bcddcf..76ff25223 100644
--- a/httemplate/elements/select-tower_sector.html
+++ b/httemplate/elements/select-tower_sector.html
@@ -2,6 +2,8 @@
 <& /elements/select-table.html,
     table       => 'tower_sector',
     name_col    => 'description',
+    addl_from   => 'JOIN tower USING (towernum)',
+    extra_sql   => q(WHERE disabled = '' OR disabled IS NULL),
     order_by    => 'ORDER BY towernum,sectorname',
     empty_label => ' ',
     @_ 
-- 
2.11.0