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 LIST_SELECTOR => '#quotations_and_orders';
21 use constant FORMS_SELECTOR => '#quotations_and_orders_article_assignment,#quotations_and_orders_new,#quotations_and_orders_update';
23 use Rose::Object::MakeMethods::Generic
25 scalar => [ qw(parts) ],
26 'scalar --get_set_init' => [ qw(requirement_spec rs_order js h_unit_name all_customers all_parts_time_unit) ],
29 __PACKAGE__->run_before('setup');
38 $self->render('requirement_spec_order/list', { layout => 0 });
44 if (!@{ $self->all_parts_time_unit }) {
45 return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render($self);
48 my $html = $self->render('requirement_spec_order/new', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
49 $self->js->hide(LIST_SELECTOR())
50 ->after(LIST_SELECTOR(), $html)
57 if (!$::auth->assert($::form->{quotation} ? 'sales_quotation_edit' : 'sales_order_edit', 1)) {
58 return $self->js->flash('error', t8("You do not have the permissions to access this function."))->render($self);
61 # 1. Update sections with selected part IDs.
62 my $section_attrs = $::form->{sections} || [];
63 my $sections = SL::DB::Manager::RequirementSpecItem->get_all_sorted(where => [ id => [ map { $_->{id} } @{ $section_attrs } ] ]);
64 my %sections_by_id = map { ($_->{id} => $_) } @{ $sections };
66 $sections_by_id{ $_->{id} }->update_attributes(order_part_id => $_->{order_part_id}) for @{ $section_attrs };
68 # 2. Create actual quotation/order.
69 my $order = $self->create_order(sections => $sections);
70 $order->db->with_transaction(sub {
73 $self->requirement_spec->orders(
74 @{ $self->requirement_spec->orders },
75 SL::DB::RequirementSpecOrder->new(order => $order, version => $self->requirement_spec->version)
77 $self->requirement_spec->save;
79 $self->requirement_spec->link_to_record($order);
81 $::lxdebug->message(LXDebug::WARN(), "Error creating the order object: $@");
84 $self->init_requirement_spec;
86 # 3. Notify the user and return to list.
87 my $html = $self->render('requirement_spec_order/list', { output => 0 });
88 $self->js->replaceWith(LIST_SELECTOR(), $html)
89 ->remove(FORMS_SELECTOR())
90 ->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been created.', $order->quonumber) : t8('Sales order #1 has been created.', $order->ordnumber))
97 my $order = $self->rs_order->order;
98 my $sections = $self->requirement_spec->sections_sorted;
100 if (!$::auth->assert($order->quotation ? 'sales_quotation_edit' : 'sales_order_edit', 1)) {
101 return $self->js->flash('error', t8("You do not have the permissions to access this function."))->render($self);
104 my (@orderitems, %sections_seen);
105 foreach my $item (@{ $order->items_sorted }) {
106 my $section = first { my $num = $_->fb_number; $item->description =~ m{\b\Q${num}\E\b} && !$sections_seen{ $_->id } } @{ $sections };
108 $sections_seen{ $section->id } = 1 if $section;
110 push @orderitems, { item => $item, section => $section };
113 my $html = $self->render(
114 'requirement_spec_order/update', { output => 0 },
115 orderitems => \@orderitems,
116 sections => $sections,
117 make_section_title => sub { $_[0]->fb_number . ' ' . $_[0]->title },
120 $self->js->hide(LIST_SELECTOR())
121 ->after(LIST_SELECTOR(), $html)
125 sub action_do_update {
128 my $order = $self->rs_order->order;
129 my $sections = $self->requirement_spec->sections_sorted;
130 my %orderitems_by_id = map { ($_->id => $_) } @{ $order->orderitems };
131 my %sections_by_id = map { ($_->id => $_) } @{ $sections };
132 $self->{parts} = { map { ($_->id => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->order_part_id } @{ $sections } ] ]) } };
133 my $language_id = $self->requirement_spec->customer->language_id;
137 foreach my $attributes (@{ $::form->{orderitems} || [] }) {
138 my $orderitem = $orderitems_by_id{ $attributes->{id} };
139 my $section = $sections_by_id{ $attributes->{section_id} };
140 next unless $orderitem && $section;
142 $self->create_order_item(section => $section, item => $orderitem, language_id => $language_id)->save;
143 $sections_seen{ $section->id } = 1;
146 my @new_orderitems = map { $self->create_order_item(section => $_, language_id => $language_id) }
147 grep { !$sections_seen{ $_->id } }
150 $order->orderitems([ @{ $order->orderitems }, @new_orderitems ]) if @new_orderitems;
152 $order->calculate_prices_and_taxes;
154 $order->db->with_transaction(sub {
156 $self->requirement_spec->link_to_record($order);
158 $::lxdebug->message(LXDebug::WARN(), "Error updating the order object: $@");
161 $self->init_requirement_spec;
163 my $html = $self->render('requirement_spec_order/list', { output => 0 });
164 $self->js->replaceWith(LIST_SELECTOR(), $html)
165 ->remove(FORMS_SELECTOR())
166 ->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been updated.', $order->quonumber) : t8('Sales order #1 has been updated.', $order->ordnumber))
170 sub action_edit_assignment {
173 if (!@{ $self->all_parts_time_unit }) {
174 return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render($self);
177 my $html = $self->render('requirement_spec_order/edit_assignment', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
178 $self->js->hide(LIST_SELECTOR())
179 ->after(LIST_SELECTOR(), $html)
183 sub action_save_assignment {
185 my $sections = $::form->{sections} || [];
186 SL::DB::RequirementSpecItem->new(id => $_->{id})->load->update_attributes(order_part_id => ($_->{order_part_id} || undef)) for @{ $sections };
188 my $html = $self->render('requirement_spec_order/list', { output => 0 });
189 $self->js->replaceWith(LIST_SELECTOR(), $html)
190 ->remove(FORMS_SELECTOR())
197 my $order = $self->rs_order->order;
200 $self->init_requirement_spec;
202 my $html = $self->render('requirement_spec_order/list', { output => 0 });
203 $self->js->replaceWith(LIST_SELECTOR(), $html)
204 ->flash('info', $order->quotation ? t8('Sales quotation #1 has been deleted.', $order->quonumber) : t8('Sales order #1 has been deleted.', $order->ordnumber))
215 $::auth->assert('requirement_spec_edit');
216 $::request->{layout}->use_stylesheet("${_}.css") for qw(jquery.contextMenu requirement_spec autocomplete_part);
217 $::request->{layout}->use_javascript("${_}.js") for qw(jquery.jstree jquery/jquery.contextMenu client_js requirement_spec);
222 sub init_requirement_spec {
224 $self->requirement_spec(SL::DB::RequirementSpec->new(id => $::form->{requirement_spec_id})->load) if $::form->{requirement_spec_id};
229 $self->js(SL::ClientJS->new);
232 sub init_all_customers { SL::DB::Manager::Customer->get_all_sorted }
233 sub init_h_unit_name { first { SL::DB::Manager::Unit->find_by(name => $_) } qw(Std h Stunde) };
234 sub init_rs_order { SL::DB::RequirementSpecOrder->new(id => $::form->{rs_order_id})->load };
236 sub init_all_parts_time_unit {
239 return [] unless $self->h_unit_name;
241 my @convertible_unit_names = map { $_->name } @{ SL::DB::Manager::Unit->find_by(name => $self->h_unit_name)->convertible_units };
243 return SL::DB::Manager::Part->get_all_sorted(where => [ unit => \@convertible_unit_names ]);
250 sub load_parts_for_sections {
251 my ($self, %params) = @_;
255 sub create_order_item {
256 my ($self, %params) = @_;
258 my $section = $params{section};
259 my $item = $params{item} || SL::DB::OrderItem->new;
260 my $part = $self->parts->{ $section->order_part_id };
261 my $translation = $params{language_id} ? first { $params{language_id} == $_->language_id } @{ $part->translations } : {};
262 my $description = $section->{keep_description} ? $item->description : ($translation->{translation} || $part->description);
263 my $longdescription = $translation->{longdescription} || $part->notes;
265 if (!$section->{keep_description}) {
266 $description = '<%fb_number%> <%title%>' unless $description =~ m{<%};
267 $longdescription = '<%description%>' unless $longdescription =~ m{<%};
269 $description =~ s{<% (.+?) %>}{ $section->can($1) ? $section->$1 : '<' . t8('Invalid variable #1', $1) . '>' }egx;
270 $longdescription =~ s{\<\% description \%\>}{!!!!DESCRIPTION!!!!}gx;
271 $longdescription =~ s{<[pP]> !!!!DESCRIPTION!!!! </[pP]>}{!!!!DESCRIPTION!!!!}gx;
272 $longdescription =~ s{\<\% (.+?) \%\>}{ $section->can($1) ? $::locale->quote_special_chars('HTML', $section->$1 // '') : '<' . t8('Invalid variable #1', $1) . '>' }egx;
273 $longdescription =~ s{!!!!DESCRIPTION!!!!}{ $section->description // '' }egx;
276 $item->assign_attributes(
277 parts_id => $part->id,
278 description => $description,
279 longdescription => $longdescription,
280 qty => $section->time_estimation * 1,
281 unit => $self->h_unit_name,
282 sellprice => $::form->round_amount($self->requirement_spec->hourly_rate, 2),
283 lastcost => $part->lastcost,
285 project_id => $self->requirement_spec->project_id,
292 my ($self, %params) = @_;
294 $self->{parts} = { map { ($_->{id} => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->{order_part_id} } @{ $params{sections} } ] ]) } };
296 my $customer = SL::DB::Customer->new(id => $::form->{customer_id})->load;
297 my @orderitems = map { $self->create_order_item(section => $_, language_id => $customer->language_id) } @{ $params{sections} };
298 my $employee = SL::DB::Manager::Employee->current;
299 my $order = SL::DB::Order->new(
300 globalproject_id => $self->requirement_spec->project_id,
301 transdate => DateTime->today_local,
302 reqdate => $::form->{quotation} && $customer->payment_id ? $customer->payment->calc_date : undef,
303 quotation => !!$::form->{quotation},
304 orderitems => \@orderitems,
305 customer_id => $customer->id,
306 taxincluded => $customer->taxincluded,
307 intnotes => $customer->notes,
308 language_id => $customer->language_id,
309 payment_id => $customer->payment_id,
310 taxzone_id => $customer->taxzone_id,
311 employee_id => $employee->id,
312 salesman_id => $employee->id,
313 transaction_description => $self->requirement_spec->displayable_name,
314 currency_id => $::instance_conf->get_currency_id,
317 $order->calculate_prices_and_taxes;