[freeside-users] Managing invoices

[Ljupco Vangelski]

Ivan Kohler wrote:
> On Mon, Oct 29, 2007 at 08:24:10PM +0100, Ljupco Vangelski wrote:
>   
>> 2. Is it possible to remove the detailed view (call rate for every 
>> number) on the invoice (for a particular customer)? For example one 
>> customer has 100 rated calls and wants to see only the total value (not 
>> each call separately).
>>     
>
> I don't believe there's currently an option for that, though I'm sure it 
> would be straighforward to add.
>
>   
I found a way to do this, bi commenting out the following lines in: 
/usr/local/etc/{conf-file}/invoice_html

     foreach my $line ( @detail_items ) {
            $OUT .=
              '<tr class="invoice_desc">'.
                '<td align="center">'. $line->{'ref'}. '</td>'.
                '<td align="left">'. $line->{'description'}. '</td>'.
                '<td align="right">'. $line->{'amount'}. '</td>'.
              '</tr>'
            ;
            foreach my $ext_desc ( @{$line->{'ext_description'} } ) {
              $OUT .=
                '<tr class="invoice_extdesc">'.
                  '<td></td>'.
                  '<td align="left">- '. $ext_desc. '</td>'.
                  '<td></td>'.
                '</tr>'
            }
          }


This way, only the total amount is printed (not every rate detail).

>> 4. Is it possible to create different rate plans for different day periods?
>>     
>
> Peak vs. off-peak is not a current feature.
>
>   

Maybe just another column with type time in the cdr table should be 
added which will be equal to calldate (update cdr set time=calldate), 
and that way queries can be sent based on the day period. The rating 
engine should be modified to take that into consideration for 
peak/off-peak and holidays.

Thanks for the reply