1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
6 ######################################################################
8 # Stuff that can be used from other modules
10 ######################################################################
17 $lxdebug->enter_sub();
21 my $old_form = $yaml->dump($form);
22 $old_form =~ s|!|!!|g;
23 $old_form =~ s|\n|!n|g;
24 $old_form =~ s|\r|!r|g;
25 $lxdebug->message(0, "yeah!???\n\n$old_form\n\n\n");
27 $lxdebug->leave_sub();
33 $lxdebug->enter_sub();
35 my ($old_form, $no_delete) = @_;
37 map({ delete($form->{$_}); } keys(%{$form})) unless ($no_delete);
38 $old_form =~ s|!r|\r|g;
39 $old_form =~ s|!n|\n|g;
40 $old_form =~ s|!!|!|g;
41 $form = YAML::Load($old_form);
43 $lxdebug->leave_sub();
47 $lxdebug->enter_sub();
49 my $url = "$form->{script}?";
51 foreach my $key ((qw(login password path), @_)) {
53 $url .= "&" unless ($first);
59 $url .= "${key}=" . E($form->{$key});
63 $lxdebug->leave_sub();
69 $lxdebug->enter_sub();
71 my ($callback_sub, @employees) = @_;
73 if (0 == scalar(@employees)) {
74 @employees = SystemBrace->get_all_employees(\%myconfig, $form);
77 my $old_form = save_form();
80 print($form->parse_html_template("generic/select_employee",
81 { "EMPLOYEES" => \@employees,
82 "old_form" => $old_form,
83 "title" => $locale->text("Select an employee"),
84 "nextsub" => "select_employee_internal",
85 "callback_sub" => $callback_sub }));
87 $lxdebug->leave_sub();
90 sub select_employee_internal {
91 $lxdebug->enter_sub();
93 my ($new_id, $new_name, $callback_sub);
95 my $new_id = $form->{"new_id_" . $form->{"selection"}};
96 my $new_name = $form->{"new_name_" . $form->{"selection"}};
97 my $callback_sub = $form->{"callback_sub"};
99 restore_form($form->{"old_form"});
101 &{ $callback_sub }($new_id, $new_name);
103 $lxdebug->leave_sub();
107 $lxdebug->enter_sub();
109 my ($callback_sub, @parts) = @_;
111 my $remap_parts_id = 0;
112 if (defined($parts[0]->{"parts_id"}) && !defined($parts[0]->{"id"})) {
114 map({ $_->{"id"} = $_->{"parts_id"}; } @parts);
117 my $remap_partnumber = 0;
118 if (defined($parts[0]->{"partnumber"}) && !defined($parts[0]->{"number"})) {
119 $remap_partnumber = 1;
120 map({ $_->{"number"} = $_->{"partnumber"}; } @parts);
124 if (defined($parts[0]->{"chargenumber"})) {
126 map({ $_->{"has_charge"} = 1; } @parts);
129 my $old_form = save_form();
132 print($form->parse_html_template("generic/select_part",
133 { "PARTS" => \@parts,
134 "old_form" => $old_form,
135 "title" => $locale->text("Select a part"),
136 "nextsub" => "select_part_internal",
137 "callback_sub" => $callback_sub,
138 "has_charge" => $has_charge,
139 "remap_parts_id" => $remap_parts_id,
140 "remap_partnumber" => $remap_partnumber }));
142 $lxdebug->leave_sub();
145 sub select_part_internal {
146 $lxdebug->enter_sub();
148 my ($new_item, $callback_sub);
150 my $re = "^new_.*_" . $form->{"selection"};
155 $new_item->{$key} = $form->{$_};
156 } grep(/$re/, keys(%{$form})));
158 if ($form->{"remap_parts_id"}) {
159 $new_item->{"parts_id"} = $new_item->{"id"};
160 delete($new_item->{"id"});
162 if ($form->{"remap_partnumber"}) {
163 $new_item->{"partnumber"} = $new_item->{"number"};
164 delete($new_item->{"number"});
167 my $callback_sub = $form->{"callback_sub"};
169 restore_form($form->{"old_form"});
171 &{ $callback_sub }($new_item);
173 $lxdebug->leave_sub();
176 sub part_selection_internal {
177 $lxdebug->enter_sub();
179 $order_by = "description";
180 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
182 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
184 $parts = Common->retrieve_parts(\%myconfig, $form, $order_by, $order_dir);
185 map({ $parts->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$parts}));
186 if (0 == scalar(@{$parts})) {
187 $form->show_generic_information($locale->text("No part was found matching the search parameters."));
188 } elsif (1 == scalar(@{$parts})) {
189 $onload = "part_selected('1')";
192 my $callback = "$form->{script}?action=part_selection_internal&";
193 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
194 (qw(login path password partnumber description input_partnumber input_description input_partsid), grep({ /^[fl]_/ } keys %$form)));
196 my @header_sort = qw(partnumber description);
197 my %header_title = ( "partnumber" => $locale->text("Part Number"),
198 "description" => $locale->text("Part description"),
202 map(+{ "column_title" => $header_title{$_},
204 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
208 $form->{"title"} = $locale->text("Select a part");
210 print($form->parse_html_template("generic/part_selection", { "HEADER" => \@header,
212 "onload" => $onload }));
214 $lxdebug->leave_sub();
217 sub project_selection_internal {
218 $lxdebug->enter_sub();
220 $order_by = "description";
221 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
223 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
225 $projects = Common->retrieve_projects(\%myconfig, $form, $order_by, $order_dir);
226 map({ $projects->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$projects}));
227 if (0 == scalar(@{$projects})) {
228 $form->show_generic_information($locale->text("No project was found matching the search parameters."));
229 } elsif (1 == scalar(@{$projects})) {
230 $onload = "project_selected('1')";
233 my $callback = "$form->{script}?action=project_selection_internal&";
234 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
235 (qw(login path password projectnumber description input_projectnumber input_description input_project_id), grep({ /^[fl]_/ } keys %$form)));
237 my @header_sort = qw(projectnumber description);
238 my %header_title = ( "projectnumber" => $locale->text("Project Number"),
239 "description" => $locale->text("Project description"),
243 map(+{ "column_title" => $header_title{$_},
245 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
249 $form->{"title"} = $locale->text("Select a project");
251 print($form->parse_html_template("generic/project_selection", { "HEADER" => \@header,
252 "PROJECTS" => $projects,
253 "onload" => $onload }));
255 $lxdebug->leave_sub();
258 sub employee_selection_internal {
259 $lxdebug->enter_sub();
262 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
264 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
266 $employees = Common->retrieve_employees(\%myconfig, $form, $order_by, $order_dir);
267 map({ $employees->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$employees}));
268 if (0 == scalar(@{$employees})) {
269 $form->show_generic_information($locale->text("No employee was found matching the search parameters."));
270 } elsif (1 == scalar(@{$employees})) {
271 $onload = "employee_selected('1')";
274 my $callback = "$form->{script}?action=employee_selection_internal&";
275 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
276 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
278 my @header_sort = qw(name);
279 my %header_title = ( "name" => $locale->text("Name"),
283 map(+{ "column_title" => $header_title{$_},
285 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
289 $form->{"title"} = $locale->text("Select an employee");
291 print($form->parse_html_template("generic/employee_selection", { "HEADER" => \@header,
292 "EMPLOYEES" => $employees,
293 "onload" => $onload }));
295 $lxdebug->leave_sub();
298 sub delivery_customer_selection {
299 $lxdebug->enter_sub();
302 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
304 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
306 $delivery = Common->retrieve_delivery_customer(\%myconfig, $form, $order_by, $order_dir);
307 map({ $delivery->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$delivery}));
308 if (0 == scalar(@{$delivery})) {
309 $form->show_generic_information($locale->text("No Customer was found matching the search parameters."));
310 } elsif (1 == scalar(@{$delivery})) {
311 $onload = "customer_selected('1')";
314 my $callback = "$form->{script}?action=delivery_customer_selection&";
315 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
316 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
318 my @header_sort = qw(name customernumber address);
319 my %header_title = ( "name" => $locale->text("Name"),
320 "customernumber" => $locale->text("Customer Number"),
321 "address" => $locale->text("Address"),
325 map(+{ "column_title" => $header_title{$_},
327 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
331 $form->{"title"} = $locale->text("Select a Customer");
333 print($form->parse_html_template("generic/select_delivery_customer", { "HEADER" => \@header,
334 "DELIVERY" => $delivery,
335 "onload" => $onload }));
337 $lxdebug->leave_sub();
340 sub vendor_selection {
341 $lxdebug->enter_sub();
344 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
346 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
348 $vendor = Common->retrieve_vendor(\%myconfig, $form, $order_by, $order_dir);
349 map({ $vendor->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$vendor}));
350 if (0 == scalar(@{$vendor})) {
351 $form->show_generic_information($locale->text("No Vendor was found matching the search parameters."));
352 } elsif (1 == scalar(@{$vendor})) {
353 $onload = "vendor_selected('1')";
356 my $callback = "$form->{script}?action=vendor_selection&";
357 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
358 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
360 my @header_sort = qw(name customernumber address);
361 my %header_title = ( "name" => $locale->text("Name"),
362 "customernumber" => $locale->text("Customer Number"),
363 "address" => $locale->text("Address"),
367 map(+{ "column_title" => $header_title{$_},
369 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
373 $form->{"title"} = $locale->text("Select a Customer");
375 print($form->parse_html_template("generic/select_vendor", { "HEADER" => \@header,
377 "onload" => $onload }));
379 $lxdebug->leave_sub();
383 $lxdebug->enter_sub();
385 my @variable_sort = ();
386 my %variable_list = ();
388 $form->{formel} =~ s/\r\n//g;
390 my ($variable_string, $formel) = split /###/,$form->{formel};
393 split /;/, $variable_string;
395 my($name, $valueunit) = split /=/,$item;
396 my($value, $unit) = split / /, $valueunit;
398 push(@variable_sort, $value);
399 $variable_list{$value} = $name;
400 $unit_list{$value} = $unit;
403 my @header_sort = qw(variable value unit);
404 my %header_title = ( "variable" => $locale->text("Variable"),
405 "value" => $locale->text("Value"),
406 "unit" => $locale->text("Unit"),
409 my @variable = map(+{ "description" => $variable_list{$_},
411 "unit" => $unit_list{$_} }, @variable_sort);
414 map(+{ "column_title" => $header_title{$_},
418 $form->{formel} = $formel;
419 $form->{"title"} = $locale->text("Please enter values");
421 print($form->parse_html_template("generic/calculate_qty", { "HEADER" => \@header,
422 "VARIABLES" => \@variable,
423 "onload" => $onload }));
425 $lxdebug->leave_sub();
428 sub set_longdescription {
429 $lxdebug->enter_sub();
432 my $callback = "$form->{script}?action=set_longdescription&";
433 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
434 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
436 $form->{"title"} = $locale->text("Enter longdescription");
438 print($form->parse_html_template("generic/set_longdescription"));
440 $lxdebug->leave_sub();
444 return $form->quote_html($_[0]);
448 return $form->quote($_[0]);
452 return $form->escape($_[0]);
456 $lxdebug->enter_sub();
458 my ($dateformat, $longformat, @indices) = @_;
460 $dateformat = $myconfig{"dateformat"} unless ($dateformat);
462 foreach my $idx (@indices) {
463 next unless (defined($form->{$idx}));
465 if (!ref($form->{$idx})) {
466 $form->{$idx} = $locale->reformat_date(\%myconfig, $form->{$idx},
467 $dateformat, $longformat);
469 } elsif (ref($form->{$idx}) eq "ARRAY") {
470 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
471 $form->{$idx}->[$i] =
472 $locale->reformat_date(\%myconfig, $form->{$idx}->[$i],
473 $dateformat, $longformat);
478 $lxdebug->leave_sub();
481 sub reformat_numbers {
482 $lxdebug->enter_sub();
484 my ($numberformat, $places, @indices) = @_;
486 return $lxdebug->leave_sub()
487 if (!$numberformat || ($numberformat eq $myconfig{"numberformat"}));
489 foreach my $idx (@indices) {
490 next unless (defined($form->{$idx}));
492 if (!ref($form->{$idx})) {
493 $form->{$idx} = $form->parse_amount(\%myconfig, $form->{$idx});
495 } elsif (ref($form->{$idx}) eq "ARRAY") {
496 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
497 $form->{$idx}->[$i] =
498 $form->parse_amount(\%myconfig, $form->{$idx}->[$i]);
503 my $saved_numberformat = $myconfig{"numberformat"};
504 $myconfig{"numberformat"} = $numberformat;
506 foreach my $idx (@indices) {
507 next unless (defined($form->{$idx}));
509 if (!ref($form->{$idx})) {
510 $form->{$idx} = $form->format_amount(\%myconfig, $form->{$idx}, $places);
512 } elsif (ref($form->{$idx}) eq "ARRAY") {
513 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
514 $form->{$idx}->[$i] =
515 $form->format_amount(\%myconfig, $form->{$idx}->[$i], $places);
520 $myconfig{"numberformat"} = $saved_numberformat;
522 $lxdebug->leave_sub();