use strict;
use parent qw(SL::Controller::Base);
-use List::Util qw(sum);
+use List::Util qw(max min sum);
use SL::DB::Order;
use SL::DB::ProjectType;
use SL::Locale::String;
use Rose::Object::MakeMethods::Generic (
- scalar => [ qw(project_types) ],
- 'scalar --get_set_init' => [ qw(models) ],
+ scalar => [ qw(orders) ],
+ 'scalar --get_set_init' => [ qw(project_types models) ],
);
__PACKAGE__->run_before(sub { $::auth->assert('sales_order_edit'); });
sub action_list {
my ($self) = @_;
- $self->project_types(SL::DB::Manager::ProjectType->get_all_sorted);
-
$self->make_filter_summary;
$self->prepare_report;
- $self->{orders} = $self->models->get;
+ $self->orders($self->models->get);
$self->calculate_data;
sub calculate_data {
my ($self) = @_;
- foreach my $order (@{ $self->{orders} }) {
+ foreach my $order (@{ $self->orders }) {
my @delivery_orders = @{ $order->linked_records(direction => 'to', to => 'DeliveryOrder', via => 'Order', query => [ '!customer_id' => undef ]) };
my @invoices = @{ $order->linked_records(direction => 'to', to => 'Invoice', via => [ 'Order', 'DeliveryOrder' ]) };
map({ @{ $_->storno_invoices } } grep { $_->storno && !$_->storno_id } @invoices),
);
- $order->{delivered_amount} = sum map { $self->sum_relevant_items(order => $order, other => $_, by_order => 1) } @delivery_orders;
- $order->{billed_amount} = sum map { $self->sum_relevant_items(order => $order, other => $_) } @invoices;
- $order->{paid_amount} = sum map { $_->paid * $_->netamount / (($_->amount * 1) || ($_->netamount * 1) || 1) } @invoices;
- my $billed_amount = sum map { $_->netamount } @invoices;
+ $order->{delivered_amount} = sum(map { $self->sum_relevant_items(order => $order, other => $_, by_order => 1) } @delivery_orders) // 0;
+ $order->{billed_amount} = sum(map { $self->sum_relevant_items(order => $order, other => $_) } @invoices) // 0;
+ $order->{paid_amount} = sum(map { $_->paid * $_->netamount / (($_->amount * 1) || ($_->netamount * 1) || 1) } @invoices) // 0;
+ my $billed_amount = sum(map { $_->netamount } @invoices) // 0;
$order->{other_amount} = $billed_amount - $order->{billed_amount};
$order->{billable_amount} = $order->{delivered_amount} - $order->{billed_amount};
if ($order->periodic_invoices_config) {
- my @dates = $order->periodic_invoices_config->calculate_invoice_dates(past_dates => 1, end_date => DateTime->today_local);
- $order->{net_amount} = $order->netamount * scalar(@dates);
+ $order->{net_amount} = $self->calculate_periodic_invoices_order_netamount($order);
} else {
$order->{net_amount} = $order->netamount;
}
}
+sub calculate_periodic_invoices_order_netamount {
+ my ($self, $order) = @_;
+
+ my $year = DateTime->today_local->year;
+ my $year_start = DateTime->new_local(day => 1, month => 1, year => $year);
+ my $year_end = DateTime->new_local(day => 31, month => 12, year => $year);
+
+ my $cfg = $order->periodic_invoices_config;
+ my $period_len = $cfg->get_billing_period_length;
+ my $num_months = 0;
+ my $cur_date = $cfg->start_date->clone;
+ my $end_date = $cfg->terminated ? $cfg->end_date : undef;
+ $end_date //= $year_end;
+ $end_date = min $end_date, $year_end;
+
+ while ($cur_date <= $end_date) {
+ $num_months += $period_len if $cur_date >= $year_start;
+ $cur_date->add(months => $period_len);
+ }
+
+ return $num_months * $order->netamount / $order->periodic_invoices_config->get_order_value_period_length;
+}
+
sub sum_items {
my ($self, %params) = @_;
$data->{$_}->{data} = $::form->format_amount(\%::myconfig, $data->{$_}->{data}, 2) for grep { !m/_p$/ } @{ $self->{number_columns} };
};
- return $self->report_generator_list_objects(report => $self->{report}, objects => $self->{orders}, data_callback => $modify_data);
+ return $self->report_generator_list_objects(report => $self->{report}, objects => $self->orders, data_callback => $modify_data);
}
sub make_filter_summary {
$self->{filter_summary} = join ', ', @filter_strings;
}
+sub init_project_types { SL::DB::Manager::ProjectType->get_all_sorted }
+
sub init_models {
my ($self) = @_;