add access to more order fields for subscription order summary

diff --git a/site/cgi-bin/modules/BSE/DB/Mysql.pm b/site/cgi-bin/modules/BSE/DB/Mysql.pm
index 814eef5a28ecc6b7e3790f728cc55736a6053a71..01605bd9a0bc95c4ff8809a099370f4d18f6fa26 100644 (file)
--- a/site/cgi-bin/modules/BSE/DB/Mysql.pm
+++ b/site/cgi-bin/modules/BSE/DB/Mysql.pm
@@ -5,7 +5,7 @@ use vars qw/@ISA/;
 use Carp 'confess';
 @ISA = qw(BSE::DB);
 
-our $VERSION = "1.006";
+our $VERSION = "1.007";
 
 use vars qw($VERSION $MAX_CONNECTION_AGE);
 
@@ -378,7 +378,7 @@ SQL
 select count(*) as "count" from order_item where subscription_id = ?
 SQL
    subscriptionOrderSummary => <<SQL,
-select od.id, od.userId, od.orderDate, od.siteuser_id, 
+select od.id, od.userId, od.orderDate, od.siteuser_id, od.billFirstName, od.billLastName, od.filled, 
     sum(oi.subscription_period * oi.units) as "subscription_period"
   from orders od, order_item oi
   where oi.subscription_id = ? and od.id = oi.orderId and od.complete <> 0