- #=====================================================================
- #
- # Tax support module for LedgerSMB
- # LedgerSMB::Tax
- # Default simple tax application
- #
- # LedgerSMB
- # Small Medium Business Accounting software
- # http://www.ledgersmb.org/
- #
- #
- # Copyright (C) 2006
- # This work contains copyrighted information from a number of sources all used
- # with permission. It is released under the GNU General Public License
- # Version 2 or, at your option, any later version. See COPYRIGHT file for
- # details.
- #
- #
- #======================================================================
- # This package contains tax related functions:
- #
- # apply_taxes - applies taxes to the given subtotal
- # extract_taxes - extracts taxes from the given total
- # initialize_taxes - loads taxes from the database
- # calculate_taxes - calculates taxes
- #
- #====================================================================
- package Tax;
- use Math::BigFloat;
- sub init_taxes {
- my ( $form, $taxaccounts, $taxaccounts2 ) = @_;
- my $dbh = $form->{dbh};
- @taxes = ();
- my @accounts = split / /, $taxaccounts;
- if ( defined $taxaccounts2 ) {
- my @tmpaccounts = @accounts;
- $#accounts = 0;
- for my $acct ( split / /, $taxaccounts2 ) {
- if ( $taxaccounts =~ /\s$acct\s/ ) {
- push @accounts, $acct;
- }
- }
- }
- my $query = qq|SELECT t.taxnumber, c.description,
- t.rate, t.chart_id, t.pass, m.taxmodulename
- FROM tax t INNER JOIN chart c ON (t.chart_id = c.id)
- INNER JOIN taxmodule m ON (t.taxmodule_id = m.taxmodule_id)
- WHERE c.accno = ?|;
- my $sth = $dbh->prepare($query);
- foreach $taxaccount (@accounts) {
- next if ( !defined $taxaccount );
- if ( defined $taxaccounts2 ) {
- next if $taxaccount !~ /$taxaccounts2/;
- }
- $sth->execute($taxaccount) || $form->dberror($query);
- my $ref = $sth->fetchrow_hashref;
- my $module = $ref->{'taxmodulename'};
- require "LedgerSMB/Taxes/${module}.pm";
- $module =~ s/\//::/g;
- my $tax = ( eval 'Taxes::' . $module )->new();
- $tax->pass( $ref->{'pass'} );
- $tax->account($taxaccount);
- $tax->rate( Math::BigFloat->new( $ref->{'rate'} ) );
- $tax->taxnumber( $ref->{'taxnumber'} );
- $tax->chart( $ref->{'chart'} );
- $tax->description( $ref->{'description'} );
- $tax->value( Math::BigFloat->bzero() );
- push @taxes, $tax;
- $sth->finish;
- }
- return @taxes;
- }
- sub calculate_taxes {
- my ( $taxes, $form, $subtotal, $extract ) = @_;
- my $total = Math::BigFloat->bzero();
- my %passes;
- foreach my $tax (@taxes) {
- push @{ $passes{ $tax->pass } }, $tax;
- }
- my @passkeys = sort keys %passes;
- @passkeys = reverse @passkeys if $extract;
- foreach my $pass (@passkeys) {
- my $passrate = Math::BigFloat->bzero();
- my $passtotal = Math::BigFloat->bzero();
- foreach my $tax ( @{ $passes{$pass} } ) {
- $passrate += $tax->rate;
- }
- foreach my $tax ( @{ $passes{$pass} } ) {
- $passtotal += $tax->apply_tax( $form, $subtotal + $total )
- if not $extract;
- $passtotal +=
- $tax->extract_tax( $form, $subtotal - $total, $passrate )
- if $extract;
- }
- $total += $passtotal;
- }
- return $total;
- }
- sub apply_taxes {
- my ( $taxes, $form, $subtotal ) = @_;
- return $subtotal + calculate_taxes( $taxes, $form, $subtotal, 0 );
- }
- sub extract_taxes {
- my ( $taxes, $form, $subtotal ) = @_;
- return $subtotal - calculate_taxes( $taxes, $form, $subtotal, 1 );
- }
- 1;
|