my $max_edate = 0;
foreach my $cust_bill_pkg ( $self->cust_bill_pkg ) {
next unless $cust_bill_pkg->pkgnum > 0;
- $min_sdate = $cust_bill_pkg->sdate if $cust_bill_pkg->sdate < $min_sdate;
- $max_edate = $cust_bill_pkg->edate if $cust_bill_pkg->edate > $max_edate;
+ $min_sdate = $cust_bill_pkg->sdate
+ if length($cust_bill_pkg->sdate) && $cust_bill_pkg->sdate < $min_sdate;
+ $max_edate = $cust_bill_pkg->edate
+ if length($cust_bill_pkg->edate) && $cust_bill_pkg->edate > $max_edate;
}
$invoice_data{'bill_period'} = '';
# this only works with Latex
my @newlines;
my @newsections;
+
+ # after this, we'll have only two sections per DID:
+ # Calls Summary and Calls Detail
foreach my $section ( @sections ) {
if($section->{'post_total'}) {
$section->{'description'} = 'Calls Summary: '.$section->{'phonenum'};
push @newsections, \%calls_detail;
}
}
+
+ # after this, each usage class is collapsed/summarized into a single
+ # line under the Calls Summary section
foreach my $newsection ( @newsections ) {
- if($newsection->{'post_total'}) {
+ if($newsection->{'post_total'}) { # this means Calls Summary
foreach my $section ( @sections ) {
next unless ($section->{'phonenum'} eq $newsection->{'phonenum'}
&& !$section->{'post_total'});
section => $newsection,
duration => $section->{'duration'},
description => $newdesc,
- amount => $section->{'amount'},
+ amount => sprintf("%.2f",$section->{'amount'}),
product_code => 'N/A',
};
push @newlines, $line;
}
}
}
+
+ # after this, Calls Details is populated with all CDRs
foreach my $newsection ( @newsections ) {
- if(!$newsection->{'post_total'}) {
+ if(!$newsection->{'post_total'}) { # this means Calls Details
foreach my $line ( @lines ) {
next unless (scalar(@{$line->{'ext_description'}}) &&
$line->{'section'}->{'phonenum'} eq $newsection->{'phonenum'}
);
my @extdesc = @{$line->{'ext_description'}};
- my $extdesc = $extdesc[0];
- $extdesc =~ s/scriptsize/normalsize/g if $format eq 'latex';
- $line->{'ext_description'} = [ $extdesc ];
+ my @newextdesc;
+ foreach my $extdesc ( @extdesc ) {
+ $extdesc =~ s/scriptsize/normalsize/g if $format eq 'latex';
+ push @newextdesc, $extdesc;
+ }
+ $line->{'ext_description'} = \@newextdesc;
$line->{'section'} = $newsection;
push @newlines, $line;
}
}
}
+
return(\@newsections, \@newlines);
}