kivitendo/SL/DB/PurchaseInvoice.pm @ d55cf346
| 82515b2d | Sven Schöling | package SL::DB::PurchaseInvoice;
|
||
use strict;
|
||||
| a93f1e39 | Moritz Bunkus | use Carp;
|
||
| b186a8eb | Moritz Bunkus | use Data::Dumper;
|
||
| a93f1e39 | Moritz Bunkus | |||
| 82515b2d | Sven Schöling | use SL::DB::MetaSetup::PurchaseInvoice;
|
||
use SL::DB::Manager::PurchaseInvoice;
|
||||
| a34c05f3 | Moritz Bunkus | use SL::DB::Helper::AttrHTML;
|
||
| f63af42d | Moritz Bunkus | use SL::DB::Helper::AttrSorted;
|
||
| e9fb6244 | Moritz Bunkus | use SL::DB::Helper::LinkedRecords;
|
||
| 15f58ff3 | Geoffrey Richardson | use SL::DB::Helper::Payment qw(:ALL);
|
||
| f6ed86ef | Geoffrey Richardson | use SL::Locale::String qw(t8);
|
||
| 0d34b381 | Geoffrey Richardson | use Rose::DB::Object::Helpers qw(has_loaded_related forget_related);
|
||
| f6ed86ef | Geoffrey Richardson | |||
| 5547891f | Moritz Bunkus | # The calculator hasn't been adjusted for purchase invoices yet.
|
||
# use SL::DB::Helper::PriceTaxCalculator;
|
||||
| 82515b2d | Sven Schöling | |||
| ce004da6 | Moritz Bunkus | __PACKAGE__->meta->add_relationship(
|
||
invoiceitems => {
|
||||
type => 'one to many',
|
||||
class => 'SL::DB::InvoiceItem',
|
||||
column_map => { id => 'trans_id' },
|
||||
manager_args => { with_objects => [ 'part' ] }
|
||||
},
|
||||
| fc1490e8 | Moritz Bunkus | sepa_export_items => {
|
||
type => 'one to many',
|
||||
class => 'SL::DB::SepaExportItem',
|
||||
column_map => { id => 'ap_id' },
|
||||
manager_args => { with_objects => [ 'sepa_export' ] }
|
||||
},
|
||||
| ba85807b | Moritz Bunkus | sepa_exports => {
|
||
type => 'many to many',
|
||||
map_class => 'SL::DB::SepaExportItem',
|
||||
map_from => 'ap',
|
||||
map_to => 'sepa_export',
|
||||
},
|
||||
| 325c539c | Moritz Bunkus | custom_shipto => {
|
||
type => 'one to one',
|
||||
class => 'SL::DB::Shipto',
|
||||
column_map => { id => 'trans_id' },
|
||||
query_args => [ module => 'AP' ],
|
||||
},
|
||||
| 0395c036 | Geoffrey Richardson | transactions => {
|
||
type => 'one to many',
|
||||
class => 'SL::DB::AccTransaction',
|
||||
column_map => { id => 'trans_id' },
|
||||
manager_args => { with_objects => [ 'chart' ],
|
||||
sort_by => 'acc_trans_id ASC' }
|
||||
},
|
||||
| ce004da6 | Moritz Bunkus | );
|
||
| 82515b2d | Sven Schöling | |||
__PACKAGE__->meta->initialize;
|
||||
| a34c05f3 | Moritz Bunkus | __PACKAGE__->attr_html('notes');
|
||
| f63af42d | Moritz Bunkus | __PACKAGE__->attr_sorted('items');
|
||
| a34c05f3 | Moritz Bunkus | |||
| 0845c4b7 | Moritz Bunkus | sub items { goto &invoiceitems; }
|
||
| ae906113 | Moritz Bunkus | sub add_items { goto &add_invoiceitems; }
|
||
| 7203ed2f | Geoffrey Richardson | sub record_number { goto &invnumber; };
|
||
| 4ac74078 | Moritz Bunkus | |||
| a93f1e39 | Moritz Bunkus | sub is_sales {
|
||
# For compatibility with Order, DeliveryOrder
|
||||
croak 'not an accessor' if @_ > 1;
|
||||
return 0;
|
||||
}
|
||||
| 16c6be41 | Moritz Bunkus | sub date {
|
||
goto &transdate;
|
||||
}
|
||||
| 704f339f | Sven Schöling | sub reqdate {
|
||
goto &duedate;
|
||||
}
|
||||
| 1e2673bb | Sven Schöling | sub customervendor {
|
||
goto &vendor;
|
||||
}
|
||||
| f6ed86ef | Geoffrey Richardson | sub abbreviation {
|
||
my $self = shift;
|
||||
return t8('AP Transaction (abbreviation)') if !$self->invoice && !$self->storno;
|
||||
return t8('AP Transaction (abbreviation)') . '(' . t8('Storno (one letter abbreviation)') . ')' if !$self->invoice && $self->storno;
|
||||
return t8('Invoice (one letter abbreviation)'). '(' . t8('Storno (one letter abbreviation)') . ')' if $self->storno;
|
||||
return t8('Invoice (one letter abbreviation)');
|
||||
| 6a12a968 | Niclas Zimmermann | };
|
||
sub link {
|
||||
my ($self) = @_;
|
||||
my $html;
|
||||
$html = SL::Presenter->get->purchase_invoice($self, display => 'inline') if $self->invoice;
|
||||
$html = SL::Presenter->get->ap_transaction($self, display => 'inline') if !$self->invoice;
|
||||
return $html;
|
||||
| f6ed86ef | Geoffrey Richardson | }
|
||
| 704f339f | Sven Schöling | |||
| 7203ed2f | Geoffrey Richardson | sub invoice_type {
|
||
my ($self) = @_;
|
||||
return 'ap_transaction' if !$self->invoice;
|
||||
return 'purchase_invoice';
|
||||
}
|
||||
sub displayable_type {
|
||||
my ($self) = @_;
|
||||
return t8('AP Transaction') if $self->invoice_type eq 'ap_transaction';
|
||||
return t8('Purchase Invoice');
|
||||
}
|
||||
sub displayable_name {
|
||||
join ' ', grep $_, map $_[0]->$_, qw(displayable_type record_number);
|
||||
};
|
||||
| b1267126 | Geoffrey Richardson | sub create_ap_row {
|
||
my ($self, %params) = @_;
|
||||
# needs chart as param
|
||||
# to be called after adding all AP_amount rows
|
||||
# only allow this method for ap invoices (Kreditorenbuchung)
|
||||
die if $self->invoice and not $self->vendor_id;
|
||||
my $acc_trans = [];
|
||||
my $chart = $params{chart} || SL::DB::Manager::Chart->find_by(id => $::instance_conf->get_ap_chart_id);
|
||||
die "illegal chart in create_ap_row" unless $chart;
|
||||
die "receivables chart must have link 'AP'" . Dumper($chart) unless $chart->link eq 'AP';
|
||||
# hardcoded entry for no tax, tax_id and taxkey should be 0
|
||||
my $tax = SL::DB::Manager::Tax->find_by(id => 0, taxkey => 0) || die "Can't find tax with id 0 and taxkey 0";
|
||||
my $sign = $self->vendor_id ? 1 : -1;
|
||||
my $acc = SL::DB::AccTransaction->new(
|
||||
amount => $self->amount * $sign,
|
||||
chart_id => $params{chart}->id,
|
||||
chart_link => $params{chart}->link,
|
||||
transdate => $self->transdate,
|
||||
taxkey => $tax->taxkey,
|
||||
tax_id => $tax->id,
|
||||
);
|
||||
$self->add_transactions( $acc );
|
||||
push( @$acc_trans, $acc );
|
||||
return $acc_trans;
|
||||
};
|
||||
sub add_ap_amount_row {
|
||||
my ($self, %params ) = @_;
|
||||
# only allow this method for ap invoices (Kreditorenbuchung)
|
||||
die "not an ap invoice" if $self->invoice and not $self->vendor_id;
|
||||
die "add_ap_amount_row needs a chart object as chart param" unless $params{chart} && $params{chart}->isa('SL::DB::Chart');
|
||||
die unless $params{chart}->link =~ /AP_amount/;
|
||||
my $acc_trans = [];
|
||||
my $roundplaces = 2;
|
||||
my ($netamount,$taxamount);
|
||||
$netamount = $params{amount} * 1;
|
||||
my $tax = SL::DB::Manager::Tax->find_by(id => $params{tax_id}) || die "Can't find tax with id " . $params{tax_id};
|
||||
if ( $tax and $tax->rate != 0 ) {
|
||||
($netamount, $taxamount) = Form->calculate_tax($params{amount}, $tax->rate, $self->taxincluded, $roundplaces);
|
||||
};
|
||||
next unless $netamount; # netamount mustn't be zero
|
||||
my $sign = $self->vendor_id ? -1 : 1;
|
||||
my $acc = SL::DB::AccTransaction->new(
|
||||
amount => $netamount * $sign,
|
||||
chart_id => $params{chart}->id,
|
||||
chart_link => $params{chart}->link,
|
||||
transdate => $self->transdate,
|
||||
taxkey => $tax->taxkey,
|
||||
tax_id => $tax->id,
|
||||
project_id => $params{project_id},
|
||||
);
|
||||
$self->add_transactions( $acc );
|
||||
push( @$acc_trans, $acc );
|
||||
if ( $taxamount ) {
|
||||
my $acc = SL::DB::AccTransaction->new(
|
||||
amount => $taxamount * $sign,
|
||||
chart_id => $tax->chart_id,
|
||||
chart_link => $tax->chart->link,
|
||||
transdate => $self->transdate,
|
||||
taxkey => $tax->taxkey,
|
||||
tax_id => $tax->id,
|
||||
project_id => $params{project_id},
|
||||
);
|
||||
$self->add_transactions( $acc );
|
||||
push( @$acc_trans, $acc );
|
||||
};
|
||||
return $acc_trans;
|
||||
};
|
||||
| b186a8eb | Moritz Bunkus | sub mark_as_paid {
|
||
my ($self) = @_;
|
||||
$self->update_attributes(paid => $self->amount);
|
||||
}
|
||||
| 82515b2d | Sven Schöling | 1;
|
||
| b186a8eb | Moritz Bunkus | |||
__END__
|
||||
=pod
|
||||
=encoding UTF-8
|
||||
=head1 NAME
|
||||
SL::DB::PurchaseInvoice: Rose model for purchase invoices (table "ap")
|
||||
=head1 FUNCTIONS
|
||||
=over 4
|
||||
=item C<mark_as_paid>
|
||||
Marks the invoice as paid by setting its C<paid> member to the value of C<amount>.
|
||||
=back
|
||||
=head1 AUTHOR
|
||||
Moritz Bunkus E<lt>m.bunkus@linet-services.deE<gt>
|
||||
=cut
|