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();
20 foreach my $key (keys(%{$form})) {
21 push(@names, "\$form->{\"$key\"}");
22 push(@values, $form->{$key});
24 my $dumper = Data::Dumper->new(\@values, \@names);
26 my $old_form = $dumper->Dump();
28 $lxdebug->leave_sub();
34 $lxdebug->enter_sub();
36 my ($old_form, $no_delete) = @_;
38 map({ delete($form->{$_}); } keys(%{$form})) unless ($no_delete);
41 $lxdebug->leave_sub();
45 $lxdebug->enter_sub();
47 my ($callback_sub, @employees) = @_;
49 if (0 == scalar(@employees)) {
50 @employees = SystemBrace->get_all_employees(\%myconfig, $form);
53 my $old_form = save_form();
56 print($form->parse_html_template("generic/select_employee",
57 { "EMPLOYEES" => \@employees,
58 "old_form" => $old_form,
59 "title" => $locale->text("Select an employee"),
60 "nextsub" => "select_employee_internal",
61 "callback_sub" => $callback_sub }));
63 $lxdebug->leave_sub();
66 sub select_employee_internal {
67 $lxdebug->enter_sub();
69 my ($new_id, $new_name, $callback_sub);
71 my $new_id = $form->{"new_id_" . $form->{"selection"}};
72 my $new_name = $form->{"new_name_" . $form->{"selection"}};
73 my $callback_sub = $form->{"callback_sub"};
75 restore_form($form->{"old_form"});
77 &{ $callback_sub }($new_id, $new_name);
79 $lxdebug->leave_sub();
83 $lxdebug->enter_sub();
85 my ($callback_sub, @parts) = @_;
87 my $remap_parts_id = 0;
88 if (defined($parts[0]->{"parts_id"}) && !defined($parts[0]->{"id"})) {
90 map({ $_->{"id"} = $_->{"parts_id"}; } @parts);
93 my $remap_partnumber = 0;
94 if (defined($parts[0]->{"partnumber"}) && !defined($parts[0]->{"number"})) {
95 $remap_partnumber = 1;
96 map({ $_->{"number"} = $_->{"partnumber"}; } @parts);
100 if (defined($parts[0]->{"chargenumber"})) {
102 map({ $_->{"has_charge"} = 1; } @parts);
105 my $old_form = save_form();
108 print($form->parse_html_template("generic/select_part",
109 { "PARTS" => \@parts,
110 "old_form" => $old_form,
111 "title" => $locale->text("Select a part"),
112 "nextsub" => "select_part_internal",
113 "callback_sub" => $callback_sub,
114 "has_charge" => $has_charge,
115 "remap_parts_id" => $remap_parts_id,
116 "remap_partnumber" => $remap_partnumber }));
118 $lxdebug->leave_sub();
121 sub select_part_internal {
122 $lxdebug->enter_sub();
124 my ($new_item, $callback_sub);
126 my $re = "^new_.*_" . $form->{"selection"};
131 $new_item->{$key} = $form->{$_};
132 } grep(/$re/, keys(%{$form})));
134 if ($form->{"remap_parts_id"}) {
135 $new_item->{"parts_id"} = $new_item->{"id"};
136 delete($new_item->{"id"});
138 if ($form->{"remap_partnumber"}) {
139 $new_item->{"partnumber"} = $new_item->{"number"};
140 delete($new_item->{"number"});
143 my $callback_sub = $form->{"callback_sub"};
145 restore_form($form->{"old_form"});
147 &{ $callback_sub }($new_item);
149 $lxdebug->leave_sub();
152 sub part_selection_internal {
153 $lxdebug->enter_sub();
155 $order_by = "description";
156 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
158 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
160 $parts = Common->retrieve_parts(\%myconfig, $form, $order_by, $order_dir);
161 map({ $parts->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$parts}));
162 if (0 == scalar(@{$parts})) {
163 $form->show_generic_information($locale->text("No part was found matching the search parameters."));
164 } elsif (1 == scalar(@{$parts})) {
165 $onload = "part_selected('1')";
168 my $callback = "$form->{script}?action=part_selection_internal&";
169 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
170 (qw(login path password partnumber description input_partnumber input_description input_partsid), grep({ /^[fl]_/ } keys %$form)));
172 my @header_sort = qw(partnumber description);
173 my %header_title = ( "partnumber" => $locale->text("Part Number"),
174 "description" => $locale->text("Part description"),
178 map(+{ "column_title" => $header_title{$_},
180 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
184 $form->{"title"} = $locale->text("Select a part");
186 print($form->parse_html_template("generic/part_selection", { "HEADER" => \@header,
188 "onload" => $onload }));
190 $lxdebug->leave_sub();
193 sub project_selection_internal {
194 $lxdebug->enter_sub();
196 $order_by = "description";
197 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
199 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
201 $projects = Common->retrieve_projects(\%myconfig, $form, $order_by, $order_dir);
202 map({ $projects->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$projects}));
203 if (0 == scalar(@{$projects})) {
204 $form->show_generic_information($locale->text("No project was found matching the search parameters."));
205 } elsif (1 == scalar(@{$projects})) {
206 $onload = "project_selected('1')";
209 my $callback = "$form->{script}?action=project_selection_internal&";
210 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
211 (qw(login path password projectnumber description input_projectnumber input_description input_project_id), grep({ /^[fl]_/ } keys %$form)));
213 my @header_sort = qw(projectnumber description);
214 my %header_title = ( "projectnumber" => $locale->text("Project Number"),
215 "description" => $locale->text("Project description"),
219 map(+{ "column_title" => $header_title{$_},
221 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
225 $form->{"title"} = $locale->text("Select a project");
227 print($form->parse_html_template("generic/project_selection", { "HEADER" => \@header,
228 "PROJECTS" => $projects,
229 "onload" => $onload }));
231 $lxdebug->leave_sub();
234 sub employee_selection_internal {
235 $lxdebug->enter_sub();
238 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
240 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
242 $employees = Common->retrieve_employees(\%myconfig, $form, $order_by, $order_dir);
243 map({ $employees->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$employees}));
244 if (0 == scalar(@{$employees})) {
245 $form->show_generic_information($locale->text("No employee was found matching the search parameters."));
246 } elsif (1 == scalar(@{$employees})) {
247 $onload = "employee_selected('1')";
250 my $callback = "$form->{script}?action=employee_selection_internal&";
251 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
252 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
254 my @header_sort = qw(name);
255 my %header_title = ( "name" => $locale->text("Name"),
259 map(+{ "column_title" => $header_title{$_},
261 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
265 $form->{"title"} = $locale->text("Select an employee");
267 print($form->parse_html_template("generic/employee_selection", { "HEADER" => \@header,
268 "EMPLOYEES" => $employees,
269 "onload" => $onload }));
271 $lxdebug->leave_sub();
274 sub delivery_customer_selection {
275 $lxdebug->enter_sub();
278 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
280 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
282 $delivery = Common->retrieve_delivery_customer(\%myconfig, $form, $order_by, $order_dir);
283 map({ $delivery->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$delivery}));
284 if (0 == scalar(@{$delivery})) {
285 $form->show_generic_information($locale->text("No Customer was found matching the search parameters."));
286 } elsif (1 == scalar(@{$delivery})) {
287 $onload = "customer_selected('1')";
290 my $callback = "$form->{script}?action=delivery_customer_selection&";
291 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
292 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
294 my @header_sort = qw(name customernumber address);
295 my %header_title = ( "name" => $locale->text("Name"),
296 "customernumber" => $locale->text("Customer Number"),
297 "address" => $locale->text("Address"),
301 map(+{ "column_title" => $header_title{$_},
303 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
307 $form->{"title"} = $locale->text("Select a Customer");
309 print($form->parse_html_template("generic/select_delivery_customer", { "HEADER" => \@header,
310 "DELIVERY" => $delivery,
311 "onload" => $onload }));
313 $lxdebug->leave_sub();
316 sub vendor_selection {
317 $lxdebug->enter_sub();
320 $order_by = $form->{"order_by"} if (defined($form->{"order_by"}));
322 $order_dir = $form->{"order_dir"} if (defined($form->{"order_dir"}));
324 $vendor = Common->retrieve_vendor(\%myconfig, $form, $order_by, $order_dir);
325 map({ $vendor->[$_]->{"selected"} = $_ ? 0 : 1; } (0..$#{$vendor}));
326 if (0 == scalar(@{$vendor})) {
327 $form->show_generic_information($locale->text("No Vendor was found matching the search parameters."));
328 } elsif (1 == scalar(@{$vendor})) {
329 $onload = "vendor_selected('1')";
332 my $callback = "$form->{script}?action=vendor_selection&";
333 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
334 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
336 my @header_sort = qw(name customernumber address);
337 my %header_title = ( "name" => $locale->text("Name"),
338 "customernumber" => $locale->text("Customer Number"),
339 "address" => $locale->text("Address"),
343 map(+{ "column_title" => $header_title{$_},
345 "callback" => $callback . "order_by=${_}&order_dir=" . ($order_by eq $_ ? 1 - $order_dir : $order_dir),
349 $form->{"title"} = $locale->text("Select a Customer");
351 print($form->parse_html_template("generic/select_vendor", { "HEADER" => \@header,
353 "onload" => $onload }));
355 $lxdebug->leave_sub();
359 $lxdebug->enter_sub();
361 my @variable_sort = ();
362 my %variable_list = ();
364 $form->{formel} =~ s/\r\n//g;
366 my ($variable_string, $formel) = split /###/,$form->{formel};
369 split /;/, $variable_string;
371 my($name, $valueunit) = split /=/,$item;
372 my($value, $unit) = split / /, $valueunit;
374 push(@variable_sort, $value);
375 $variable_list{$value} = $name;
376 $unit_list{$value} = $unit;
379 my @header_sort = qw(variable value unit);
380 my %header_title = ( "variable" => $locale->text("Variable"),
381 "value" => $locale->text("Value"),
382 "unit" => $locale->text("Unit"),
385 my @variable = map(+{ "description" => $variable_list{$_},
387 "unit" => $unit_list{$_} }, @variable_sort);
390 map(+{ "column_title" => $header_title{$_},
394 $form->{formel} = $formel;
395 $form->{"title"} = $locale->text("Please enter values");
397 print($form->parse_html_template("generic/calculate_qty", { "HEADER" => \@header,
398 "VARIABLES" => \@variable,
399 "onload" => $onload }));
401 $lxdebug->leave_sub();
404 sub set_longdescription {
405 $lxdebug->enter_sub();
408 my $callback = "$form->{script}?action=set_longdescription&";
409 map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" }
410 (qw(login path password name input_name input_id), grep({ /^[fl]_/ } keys %$form)));
412 $form->{"title"} = $locale->text("Enter longdescription");
414 print($form->parse_html_template("generic/set_longdescription"));
416 $lxdebug->leave_sub();
420 return $form->quote_html($_[0]);
424 return $form->quote($_[0]);
428 $lxdebug->enter_sub();
430 my ($dateformat, $longformat, @indices) = @_;
432 $dateformat = $myconfig{"dateformat"} unless ($dateformat);
434 foreach my $idx (@indices) {
435 next unless (defined($form->{$idx}));
437 if (!ref($form->{$idx})) {
438 $form->{$idx} = $locale->reformat_date(\%myconfig, $form->{$idx},
439 $dateformat, $longformat);
441 } elsif (ref($form->{$idx}) eq "ARRAY") {
442 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
443 $form->{$idx}->[$i] =
444 $locale->reformat_date(\%myconfig, $form->{$idx}->[$i],
445 $dateformat, $longformat);
450 $lxdebug->leave_sub();
453 sub reformat_numbers {
454 $lxdebug->enter_sub();
456 my ($numberformat, $places, @indices) = @_;
458 return $lxdebug->leave_sub()
459 if (!$numberformat || ($numberformat eq $myconfig{"numberformat"}));
461 foreach my $idx (@indices) {
462 next unless (defined($form->{$idx}));
464 if (!ref($form->{$idx})) {
465 $form->{$idx} = $form->parse_amount(\%myconfig, $form->{$idx});
467 } elsif (ref($form->{$idx}) eq "ARRAY") {
468 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
469 $form->{$idx}->[$i] =
470 $form->parse_amount(\%myconfig, $form->{$idx}->[$i]);
475 my $saved_numberformat = $myconfig{"numberformat"};
476 $myconfig{"numberformat"} = $numberformat;
478 foreach my $idx (@indices) {
479 next unless (defined($form->{$idx}));
481 if (!ref($form->{$idx})) {
482 $form->{$idx} = $form->format_amount(\%myconfig, $form->{$idx}, $places);
484 } elsif (ref($form->{$idx}) eq "ARRAY") {
485 for (my $i = 0; $i < scalar(@{$form->{$idx}}); $i++) {
486 $form->{$idx}->[$i] =
487 $form->format_amount(\%myconfig, $form->{$idx}->[$i], $places);
492 $myconfig{"numberformat"} = $saved_numberformat;
494 $lxdebug->leave_sub();