1 package SL::Controller::RequirementSpecOrder;
6 use parent qw(SL::Controller::Base);
8 use List::MoreUtils qw(uniq);
9 use List::Util qw(first);
15 use SL::DB::RequirementSpec;
16 use SL::DB::RequirementSpecOrder;
17 use SL::Helper::Flash;
18 use SL::Locale::String;
20 use constant TAB_ID => 'ui-tabs-4';
22 use Rose::Object::MakeMethods::Generic
24 scalar => [ qw(parts) ],
25 'scalar --get_set_init' => [ qw(requirement_spec rs_order js h_unit_name all_customers all_parts) ],
28 __PACKAGE__->run_before('setup');
37 $self->render('requirement_spec_order/list', { layout => 0 });
43 my $html = $self->render('requirement_spec_order/new', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
44 $self->js->html('#' . TAB_ID(), $html)
51 # 1. Update sections with selected part IDs.
52 my $section_attrs = $::form->{sections} || [];
53 my $sections = SL::DB::Manager::RequirementSpecItem->get_all(where => [ id => [ map { $_->{id} } @{ $section_attrs } ] ]);
54 my %sections_by_id = map { ($_->{id} => $_) } @{ $sections };
56 $sections_by_id{ $_->{id} }->update_attributes(order_part_id => $_->{order_part_id}) for @{ $section_attrs };
58 # 2. Create actual quotation/order.
59 my $order = $self->create_order(sections => $sections);
62 $self->requirement_spec->orders(
63 @{ $self->requirement_spec->orders },
64 SL::DB::RequirementSpecOrder->new(order => $order, version => $self->requirement_spec->version)
66 $self->requirement_spec->save;
67 $self->init_requirement_spec;
69 # 3. Notify the user and return to list.
70 my $html = $self->render('requirement_spec_order/list', { output => 0 });
71 $self->js->html('#' . TAB_ID(), $html)
72 ->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been created.', $order->quonumber) : t8('Sales order #1 has been created.', $order->ordnumber))
79 my $order = $self->rs_order->order;
80 my $sections = $self->requirement_spec->sections_sorted;
82 my (@orderitems, %sections_seen);
83 foreach my $item (@{ $order->items_sorted }) {
84 my $section = first { my $num = $_->fb_number; $item->description =~ m{\b\Q${num}\E\b} && !$sections_seen{ $_->id } } @{ $sections };
86 $sections_seen{ $section->id } = 1 if $section;
88 push @orderitems, { item => $item, section => $section };
91 my $html = $self->render(
92 'requirement_spec_order/update', { output => 0 },
93 orderitems => \@orderitems,
94 sections => $sections,
95 make_section_title => sub { $_[0]->fb_number . ' ' . $_[0]->title },
98 $self->js->html('#' . TAB_ID(), $html)
102 sub action_do_update {
105 my $order = $self->rs_order->order;
106 my $sections = $self->requirement_spec->sections_sorted;
107 my %orderitems_by_id = map { ($_->id => $_) } @{ $order->orderitems };
108 my %sections_by_id = map { ($_->id => $_) } @{ $sections };
109 $self->{parts} = { map { ($_->id => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->order_part_id } @{ $sections } ] ]) } };
113 foreach my $attributes (@{ $::form->{orderitems} || [] }) {
114 my $orderitem = $orderitems_by_id{ $attributes->{id} };
115 my $section = $sections_by_id{ $attributes->{section_id} };
116 next unless $orderitem && $section;
118 $self->create_order_item(section => $section, item => $orderitem)->save;
119 $sections_seen{ $section->id } = 1;
122 my @new_orderitems = map { $self->create_order_item(section => $_) }
123 grep { !$sections_seen{ $_->id } }
126 $order->orderitems([ @{ $order->orderitems }, @new_orderitems ]) if @new_orderitems;
128 $order->calculate_prices_and_taxes;
131 $self->init_requirement_spec;
133 my $html = $self->render('requirement_spec_order/list', { output => 0 });
134 $self->js->html('#' . TAB_ID(), $html)
135 ->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been updated.', $order->quonumber) : t8('Sales order #1 has been updated.', $order->ordnumber))
139 sub action_edit_assignment {
142 my $html = $self->render('requirement_spec_order/edit_assignment', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
143 $self->js->html('#' . TAB_ID(), $html)
147 sub action_save_assignment {
149 my $sections = $::form->{sections} || [];
150 SL::DB::RequirementSpecItem->new(id => $_->{id})->load->update_attributes(order_part_id => ($_->{order_part_id} || undef)) for @{ $sections };
152 my $html = $self->render('requirement_spec_order/list', { output => 0 });
153 $self->js->html('#' . TAB_ID(), $html)
160 my $html = $self->render('requirement_spec_order/list', { output => 0 });
161 $self->js->html('#' . TAB_ID(), $html)
172 $::auth->assert('sales_quotation_edit');
173 $::request->{layout}->use_stylesheet("${_}.css") for qw(jquery.contextMenu requirement_spec);
174 $::request->{layout}->use_javascript("${_}.js") for qw(jquery.jstree jquery/jquery.contextMenu client_js requirement_spec);
179 sub init_requirement_spec {
181 $self->requirement_spec(SL::DB::RequirementSpec->new(id => $::form->{requirement_spec_id})->load) if $::form->{requirement_spec_id};
186 $self->js(SL::ClientJS->new);
189 sub init_all_customers { SL::DB::Manager::Customer->get_all_sorted }
190 sub init_all_parts { SL::DB::Manager::Part->get_all_sorted }
191 sub init_h_unit_name { first { SL::DB::Manager::Unit->find_by(name => $_) } qw(Std h Stunde) };
192 sub init_rs_order { SL::DB::RequirementSpecOrder->new(id => $::form->{rs_order_id})->load };
198 sub load_parts_for_sections {
199 my ($self, %params) = @_;
203 sub create_order_item {
204 my ($self, %params) = @_;
206 my $section = $params{section};
207 my $item = $params{item} || SL::DB::OrderItem->new;
208 my $part = $self->parts->{ $section->order_part_id };
209 my $description = $section->{keep_description} ? $item->description : $part->description;
211 if (!$section->{keep_description}) {
212 $description = '<%fb_number%> <%title%>' unless $description =~ m{<%};
213 $description =~ s{<% (.+?) %>}{$section->$1}egx;
216 $item->assign_attributes(
217 parts_id => $part->id,
218 description => $description,
219 qty => $section->time_estimation * 1,
220 unit => $self->h_unit_name,
221 sellprice => $::form->round_amount($self->requirement_spec->hourly_rate, 2),
222 lastcost => $part->lastcost,
224 project_id => $self->requirement_spec->project_id,
231 my ($self, %params) = @_;
233 $self->{parts} = { map { ($_->{id} => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->{order_part_id} } @{ $params{sections} } ] ]) } };
235 my @orderitems = map { $self->create_order_item(section => $_) } @{ $params{sections} };
236 my $employee = SL::DB::Manager::Employee->current;
237 my $customer = SL::DB::Customer->new(id => $::form->{customer_id})->load;
238 my $order = SL::DB::Order->new(
239 globalproject_id => $self->requirement_spec->project_id,
240 transdate => DateTime->today_local,
241 reqdate => $::form->{quotation} && $customer->payment_id ? $customer->payment->calc_date : undef,
242 quotation => !!$::form->{quotation},
243 orderitems => \@orderitems,
244 customer_id => $customer->id,
245 taxincluded => $customer->taxincluded,
246 intnotes => $customer->notes,
247 language_id => $customer->language_id,
248 payment_id => $customer->payment_id,
249 taxzone_id => $customer->taxzone_id,
250 employee_id => $employee->id,
251 salesman_id => $employee->id,
252 transaction_description => $self->requirement_spec->displayable_name,
253 currency_id => $::instance_conf->get_currency_id,
256 $order->calculate_prices_and_taxes;