From 7ad6715f6e0810df90046af7c4c905d945712476 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Sun, 10 Mar 2013 21:53:55 -0700
Subject: [PATCH] fix radius data usage report w/sqlradius_withdomain export,
 RT#19964

---
 httemplate/search/report_sqlradius_usage.html | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/httemplate/search/report_sqlradius_usage.html b/httemplate/search/report_sqlradius_usage.html
index 01215e834..7e54465d3 100644
--- a/httemplate/search/report_sqlradius_usage.html
+++ b/httemplate/search/report_sqlradius_usage.html
@@ -8,13 +8,18 @@
   'empty_label'   => 'all',
 &>
 
-% my @exporttypes = map { "'$_'" } qw(sqlradius broadband_sqlradius);
+%#more future-proof to actually ask all exports if they ->can('usage_sessions')
+% my @exporttypes = qw( sqlradius sqlradius_withdomain broadband_sqlradius
+%                       phone_sqlradius radiator
+%                     );
 <& /elements/tr-select-table.html,
   'label'         => 'Export',
   'table'         => 'part_export',
   'name_col'      => 'label',
   'hashref'       => {},
-  'extra_sql'     => ' WHERE exporttype IN('.join(',', @exporttypes).')',
+  'extra_sql'     => ' WHERE exporttype IN ( '.
+                                            join(',', map "'$_'", @exporttypes).
+                                          ')',
   'disable_empty' => 1,
   'order_by'      => 'ORDER BY exportnum',
 &>
-- 
2.11.0