diff options
Diffstat (limited to 'bin/cust_bill-credit34')
| -rwxr-xr-x | bin/cust_bill-credit34 | 205 |
1 files changed, 205 insertions, 0 deletions
diff --git a/bin/cust_bill-credit34 b/bin/cust_bill-credit34 new file mode 100755 index 000000000..f3e579b32 --- /dev/null +++ b/bin/cust_bill-credit34 @@ -0,0 +1,205 @@ +#!/usr/bin/perl -w + +use strict; +use vars qw( $opt_d $opt_s $opt_p $opt_m $opt_c $opt_e $opt_r ); +use Getopt::Std; +use Date::Parse qw(str2time); +use FS::UID qw( dbh adminsuidsetup ); +use FS::Record qw( qsearch qsearchs ); +use FS::cust_main_county; +use FS::cust_bill; +use FS::msg_template; +use FS::cust_credit; +use FS::cust_credit_bill; + +getopts('d:s:pm:c:er'); + +my $user = shift or &usage; +adminsuidsetup $user; + +#i should be an option +my $taxname = 'HST, ON'; +my $rate = '13'; + +my $oldAutoCommit = $FS::UID::AutoCommit; +local $FS::UID::AutoCommit = 0; +my $dbh = dbh; + +# only pkgpart 34 + +### +# find invoices +### + +#my $extra_sql = $opt_s ? " AND cust_main.state = '$opt_s' " : ''; + +my $start_date = $opt_d ? str2time($opt_d) : 0; +my $end_date = 1375471643; + +my @cust_bill = qsearch({ + 'select' => 'cust_bill.*', + 'table' => 'cust_bill', + 'addl_from' => 'LEFT JOIN cust_main USING ( custnum )', + 'hashref' => { '_date' => { op=>'>', value=>$start_date } }, + 'extra_sql' => " AND _date < $end_date ", +# 'extra_sql' => $extra_sql, +}); + +my( @billpkgnums, @setuprecurs, @amounts ); + +foreach my $cust_bill ( @cust_bill ) { + + my $tax = $cust_bill->tax; + + my $cust_main = $cust_bill->cust_main; + + next if $cust_bill->charged == 0 + or $tax == 0 + or $cust_main->tax eq 'Y'; + + my $credit = 0; + + @billpkgnums = (); + @setuprecurs = (); + @amounts = (); + + foreach my $cust_bill_pkg ( $cust_bill->cust_bill_pkg ) { + my $cust_pkg = $cust_bill_pkg->cust_pkg or next; + + my $loc = $cust_pkg->cust_location_or_main; + next if $opt_s && $loc->state ne $opt_s; + + my $part_pkg = $cust_pkg->part_pkg; + next unless $cust_pkg->pkgpart == 34; #only pkgpart 34 + + #my $amount = $cust_bill_pkg->setup + $cust_bill_pkg->recur; + #$credit += $rate * $amount / 100; + + if ( $cust_bill_pkg->setup ) { + my $scredit = sprintf('%.2f', ($rate * $cust_bill_pkg->setup / 100) + 0.00000001); + $credit += $scredit; + push @setuprecurs, 'setup'; + push @billpkgnums, $cust_bill_pkg->billpkgnum; + push @amounts, $scredit; + } + + if ( $cust_bill_pkg->recur ) { + my $rcredit = sprintf('%.2f', ($rate * $cust_bill_pkg->recur / 100) + 0.00000001); + $credit += $rcredit; + push @setuprecurs, 'recur'; + push @billpkgnums, $cust_bill_pkg->billpkgnum; + push @amounts, $rcredit; + } + + } + + $credit = sprintf('%.2f', $credit + 0.00000001); + + next if $credit == 0; + + #$credit = sprintf('%.2f', $credit + 0.00000001); + + warn "invoice ". $cust_bill->invnum. ": credit of $credit is more than orignally taxed ($tax)\n" if $credit > $tax; + + warn "invoice ". $cust_bill->invnum. ": credit of $credit is more than 50% of originally taxed ($tax)\n" if $credit-0.01 > $tax/2; + + #my $cr_percent = sprintf('%.1f', 100 * $credit / $tax); + + if ( $opt_p ) { + #print $cust_bill->invnum. ','. $cust_bill->custnum. ",$tax,$credit,$cr_percent%\n"; + print $cust_bill->invnum. ','. $cust_bill->custnum. ',"'. + $cust_bill->cust_main->name. '",'. "$tax,$credit\n"; + } + + if ( $opt_m && ! $opt_r ) { + + my $msg_template = qsearchs('msg_template', { 'msgnum' => $opt_m } ) + or die "Template $opt_m not found"; + my $error = $msg_template->send( + 'cust_main' => $cust_main, + 'object' => $cust_main, + ); + if ( $error ) { + warn "error sending email for invnum ". $cust_bill->invnum. ','. + " custnum ". $cust_bill->custnum. ": $error\n"; + } + } + + if ( $opt_c ) { + my $cust_credit = new FS::cust_credit { + 'custnum' => $cust_main->custnum, + 'amount' => $credit, + 'reasonnum' => $opt_c, + }; + my $error = $cust_credit->insert; + if ( $error ) { + warn "error inserting credit: $error\n"; + } + my $cust_credit_bill = new FS::cust_credit_bill { + 'crednum' => $cust_credit->crednum, + 'invnum' => $cust_bill->invnum, + 'amount' => $credit, + }; + my $aerror = $cust_credit_bill->insert; + if ( $aerror ) { + warn "error applying credit to invnum ". $cust_bill->invnum. ": $aerror\n"; + } + } + + if ( $opt_e && ! $opt_r ) { + eval { $cust_bill->email }; + if ( $@ ) { + warn "error sending invnum ". $cust_bill->invnum. ','. + " custnum ". $cust_bill->custnum. ": $@\n"; + } + } + +} + +if ( $opt_r ) { + $dbh->rollback or die $dbh->errstr; #if $oldAutoCommit; +} else { + $dbh->commit or die $dbh->errstr; #if $oldAutoCommit; +} + +sub usage { + die "usage: cust_bill-credit [ -d date ] [ -s state ] [ -p ] [ -m templatenum ] [ -c reasonnum ] [ -e ] [ -r ] employee_username\n"; +} + +=head1 NAME + +cust_bill-credit + +=head1 SYNOPSIS + + cust_bill-credit [ -d date ] [ -s state ] [ -p ] [ -m templatenum ] [ -c reasonnum ] [ -e ] employee_username + +=head1 DESCRIPTION + +Command-line tool to search for and credit invoices. + +-d: Search for invoices starting from this date + +-s: Search for invoices for packages within this state + +-p: Print an informational line for each invoice with invnum, custnum, original tax amount, calculate credit, and credit percentage of original. + +-m: Send an email to the customer with this message template. + +-c: Credit the invoice for one-half of the taxation amount, using this reason. + +-e: re-Email invoice + +-r: dRy run + +employee_username + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::part_pkg> + +=cut + +1; |