From: levinse <levinse>
Date: Sun, 24 Apr 2011 15:09:11 +0000 (+0000)
Subject: modify invoice DID summary date range calculation, RT10886
X-Git-Tag: freeside_2_3_0~339
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=6d10f9863e64529026e2ff4ec144608e846f0a6a

modify invoice DID summary date range calculation, RT10886
---

diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm
index 5d3851244..3fbf03bf5 100644
--- a/FS/FS/cust_bill.pm
+++ b/FS/FS/cust_bill.pm
@@ -4062,10 +4062,12 @@ sub _items_extra_usage_sections {
 sub _did_summary {
     my $self = shift;
     my $end = $self->_date;
-    my @cust_bill = sort { $a->_date <=> $b->_date }
-        grep { $_->_date < $self->_date }
-          qsearch( 'cust_bill', { 'custnum' => $self->custnum } );
-    my $start = $cust_bill[-1]->_date+1; # since last invoice
+
+    # start at date of previous invoice + 1 second or 0 if no previous invoice
+    my $start = $self->scalar_sql("SELECT max(_date) FROM cust_bill WHERE custnum = ? and invnum != ?",$self->custnum,$self->invnum);
+    $start = 0 if !$start;
+    $start++;
+
     my $cust_main = $self->cust_main;
     my @pkgs = $cust_main->all_pkgs;
     my($num_activated,$num_deactivated,$num_portedin,$num_portedout,$minutes)