1 package SL::DB::Buchungsgruppe;
5 use SL::DB::MetaSetup::Buchungsgruppe;
6 use SL::DB::Manager::Buchungsgruppe;
7 use SL::DB::Helper::ActsAsList;
9 __PACKAGE__->meta->add_relationship(
10 inventory_account => {
11 type => 'many to one',
12 class => 'SL::DB::Chart',
13 column_map => { inventory_accno_id => 'id' },
17 __PACKAGE__->meta->initialize;
23 push @errors, $::locale->text('The description is missing.') if !$self->description;
30 require SL::DB::Manager::Chart;
31 return SL::DB::Manager::Chart->find_by(id => $self->inventory_accno_id) ? SL::DB::Manager::Chart->find_by(id => $self->inventory_accno_id)->accno() : undef;
34 sub inventory_accno_description {
36 require SL::DB::Manager::Chart;
37 return SL::DB::Manager::Chart->find_by(id => $self->inventory_accno_id) ? SL::DB::Manager::Chart->find_by(id => $self->inventory_accno_id)->description() : undef;
41 my ($self, $taxzone) = @_;
43 require SL::DB::TaxZone;
44 require SL::DB::TaxzoneChart;
46 my $taxzone_id = ref $taxzone && $taxzone->isa('SL::DB::TaxZone') ? $taxzone->id : $taxzone;
47 my $taxzone_chart = SL::DB::Manager::TaxzoneChart->find_by(taxzone_id => $taxzone_id, buchungsgruppen_id => $self->id);
48 return $taxzone_chart->income_accno_id if $taxzone_chart;
51 sub expense_accno_id {
52 my ($self, $taxzone) = @_;
53 require SL::DB::TaxZone;
54 require SL::DB::TaxzoneChart;
56 my $taxzone_id = ref $taxzone && $taxzone->isa('SL::DB::TaxZone') ? $taxzone->id : $taxzone;
57 my $taxzone_chart = SL::DB::Manager::TaxzoneChart->find_by(taxzone_id => $taxzone_id, buchungsgruppen_id => $self->id);
58 return $taxzone_chart->expense_accno_id if $taxzone_chart;
62 my ($self, $taxzone) = @_;
64 require SL::DB::TaxZone;
65 require SL::DB::TaxzoneChart;
67 my $taxzone_id = ref $taxzone && $taxzone->isa('SL::DB::TaxZone') ? $taxzone->id : $taxzone;
68 my $taxzone_chart = SL::DB::Manager::TaxzoneChart->find_by(taxzone_id => $taxzone_id, buchungsgruppen_id => $self->id);
69 return $taxzone_chart->income_accno if $taxzone_chart;
73 my ($self, $taxzone) = @_;
75 require SL::DB::TaxZone;
76 require SL::DB::TaxzoneChart;
78 my $taxzone_id = ref $taxzone && $taxzone->isa('SL::DB::TaxZone') ? $taxzone->id : $taxzone;
79 my $taxzone_chart = SL::DB::Manager::TaxzoneChart->find_by(taxzone_id => $taxzone_id, buchungsgruppen_id => $self->id);
80 return $taxzone_chart->expense_accno if $taxzone_chart;
85 return SL::DB::Manager::TaxzoneChart->get_all(where => [ buchungsgruppen_id => $self->id ]);
97 SL::DB::Buchungsgruppe - RDBO wrapper for the C<buchungsgruppen> table
103 =item C<expense_accno_id $taxzone>
105 Return the chart ID for the expense account for the given taxzone
106 (either the DB id or an instance of L<SL::DB::TaxZone>).
108 =item C<expense_account>
110 Return the chart (an instance of L<SL::DB::Chart>) for the expense
111 account for the given taxzone (either the DB id or an instance of
114 =item C<income_accno_id>
116 Return the chart ID for the income account for the given taxzone
117 (either the DB id or an instance of L<SL::DB::TaxZone>).
120 =item C<income_account>
122 Return the chart (an instance of L<SL::DB::Chart>) for the income
123 account for the given taxzone (either the DB id or an instance of
134 Sven Schöling E<lt>s.schoeling@linet-services.deE<gt>,
135 Moritz Bunkus E<lt>m.bunkus@linet-services.deE<gt>