diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2019-04-21 16:14:13 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2019-04-21 22:01:12 -0400 |
| commit | aa55eded7431d4781b7105b9b895f4b20e575f01 (patch) | |
| tree | 4dd33af324057d66ee0c2361c4a0818982f34f0a /httemplate/elements/select-tower_sector.html | |
| parent | 609e7cb967020e23f147f4e1b475fed97e37db30 (diff) | |
RT# 83039 - only towers with sectors shown on provisioning page when export requires sectors
Conflicts:
httemplate/elements/select-table.html
Diffstat (limited to 'httemplate/elements/select-tower_sector.html')
| -rw-r--r-- | httemplate/elements/select-tower_sector.html | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/httemplate/elements/select-tower_sector.html b/httemplate/elements/select-tower_sector.html index 76ff25223..4dfd23dcc 100644 --- a/httemplate/elements/select-tower_sector.html +++ b/httemplate/elements/select-tower_sector.html @@ -3,7 +3,7 @@ table => 'tower_sector', name_col => 'description', addl_from => 'JOIN tower USING (towernum)', - extra_sql => q(WHERE disabled = '' OR disabled IS NULL), + extra_sql => $extra_sql, order_by => 'ORDER BY towernum,sectorname', empty_label => ' ', @_ @@ -67,4 +67,7 @@ foreach my $towernum (keys %sectors_of) { } my $empty_label = $opt{'empty_label'} || 'Include services with no sector'; + +my $extra_sql = q(WHERE (disabled = '' OR disabled IS NULL)); +$extra_sql .= q( AND sectorname != '_default') if $opt{'sectorsonly'}; </%init> |