1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
8 # SQL-Ledger, Accounting
11 # Author: Dieter Simader
12 # Email: dsimader@sql-ledger.org
13 # Web: http://www.sql-ledger.org
16 # This program is free software; you can redistribute it and/or modify
17 # it under the terms of the GNU General Public License as published by
18 # the Free Software Foundation; either version 2 of the License, or
19 # (at your option) any later version.
21 # This program is distributed in the hope that it will be useful,
22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 # GNU General Public License for more details.
25 # You should have received a copy of the GNU General Public License
26 # along with this program; if not, write to the Free Software
27 # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
28 #======================================================================
30 # Inventory Control module
32 #======================================================================
34 use POSIX qw(strftime);
35 use List::Util qw(first max);
36 use List::MoreUtils qw(any);
41 use SL::ReportGenerator;
49 our ($form, $locale, %myconfig, $lxdebug, $auth);
51 require "bin/mozilla/io.pl";
52 require "bin/mozilla/invoice_io.pl";
53 require "bin/mozilla/common.pl";
54 require "bin/mozilla/reportgenerator.pl";
59 # type=submit $locale->text('Add Part')
60 # type=submit $locale->text('Add Service')
61 # type=submit $locale->text('Add Assembly')
62 # type=submit $locale->text('Edit Part')
63 # type=submit $locale->text('Edit Service')
64 # type=submit $locale->text('Edit Assembly')
65 # $locale->text('Parts')
66 # $locale->text('Services')
67 # $locale->text('Inventory quantity must be zero before you can set this part obsolete!')
68 # $locale->text('Inventory quantity must be zero before you can set this assembly obsolete!')
69 # $locale->text('Part Number missing!')
70 # $locale->text('Service Number missing!')
71 # $locale->text('Assembly Number missing!')
72 # $locale->text('ea');
77 $lxdebug->enter_sub();
79 $auth->assert('part_service_assembly_edit');
81 my $title = 'Add ' . ucfirst $form->{item};
82 $form->{title} = $locale->text($title);
83 $form->{callback} = "$form->{script}?action=add&item=$form->{item}" unless $form->{callback};
84 $form->{unit_changeable} = 1;
86 IC->get_pricegroups(\%myconfig, \%$form);
90 $lxdebug->leave_sub();
94 $lxdebug->enter_sub();
96 $auth->assert('part_service_assembly_edit');
98 $form->{revers} = 0; # switch for backward sorting
99 $form->{lastsort} = ""; # memory for which table was sort at last time
100 $form->{ndxs_counter} = 0; # counter for added entries to top100
102 my %is_xyz = map { +"is_$_" => ($form->{searchitems} eq $_) } qw(part service assembly);
104 $form->{title} = (ucfirst $form->{searchitems}) . "s";
105 $form->{title} = $locale->text($form->{title});
106 $form->{title} = $locale->text('Assemblies') if ($is_xyz{is_assembly});
108 $form->{jsscript} = 1;
110 $form->{CUSTOM_VARIABLES} = CVar->get_configs('module' => 'IC');
111 ($form->{CUSTOM_VARIABLES_FILTER_CODE},
112 $form->{CUSTOM_VARIABLES_INCLUSION_CODE}) = CVar->render_search_options('variables' => $form->{CUSTOM_VARIABLES},
113 'include_prefix' => 'l_',
114 'include_value' => 'Y');
118 $form->get_lists('partsgroup' => 'ALL_PARTSGROUPS');
119 print $form->parse_html_template('ic/search', { %is_xyz,
120 dateformat => $myconfig{dateformat},
121 limit => $myconfig{vclimit}, });
123 $lxdebug->leave_sub();
126 sub search_update_prices {
127 $lxdebug->enter_sub();
129 $auth->assert('part_service_assembly_edit');
131 my $pricegroups = IC->get_pricegroups(\%myconfig, \%$form);
133 $form->{title} = $locale->text('Update Prices');
137 print $form->parse_html_template('ic/search_update_prices', { PRICE_ROWS => $pricegroups });
139 $lxdebug->leave_sub();
142 sub confirm_price_update {
143 $lxdebug->enter_sub();
145 $auth->assert('part_service_assembly_edit');
148 my $value_found = undef;
150 foreach my $idx (qw(sellprice listprice), (1..$form->{price_rows})) {
151 my $name = $idx =~ m/\d/ ? $form->{"pricegroup_${idx}"} : $idx eq 'sellprice' ? $locale->text('Sell Price') : $locale->text('List Price');
152 my $type = $idx =~ m/\d/ ? $form->{"pricegroup_type_${idx}"} : $form->{"${idx}_type"};
153 my $value_idx = $idx =~ m/\d/ ? "price_${idx}" : $idx;
154 my $value = $form->parse_amount(\%myconfig, $form->{$value_idx});
156 if ((0 > $value) && ($type eq 'percent')) {
157 push @errors, $locale->text('You cannot adjust the price for pricegroup "#1" by a negative percentage.', $name);
159 } elsif (!$value && ($form->{$value_idx} ne '')) {
160 push @errors, $locale->text('No valid number entered for pricegroup "#1".', $name);
162 } elsif (0 < $value) {
167 push @errors, $locale->text('No prices will be updated because no prices have been entered.') if (!$value_found);
169 my $num_matches = IC->get_num_matches_for_priceupdate();
174 $form->show_generic_error(join('<br>', @errors), 'back_button' => 1);
177 $form->{nextsub} = "update_prices";
179 map { delete $form->{$_} } qw(action header);
181 print $form->parse_html_template('ic/confirm_price_update', { HIDDENS => [ map { name => $_, value => $form->{$_} }, keys %$form ],
182 num_matches => $num_matches });
184 $lxdebug->leave_sub();
188 $lxdebug->enter_sub();
190 $auth->assert('part_service_assembly_edit');
192 my $num_updated = IC->update_prices(\%myconfig, \%$form);
194 if (-1 != $num_updated) {
195 $form->redirect($locale->text('#1 prices were updated.', $num_updated));
197 $form->error($locale->text('Could not update prices!'));
200 $lxdebug->leave_sub();
204 # $lxdebug->enter_sub();
206 # $auth->assert('part_service_assembly_edit');
208 # our ($j, $lastndx);
211 # $form->{title} = $locale->text('Top 100 hinzufuegen');
215 # push @custom_hiddens, qw(searchitems title bom titel revers lastsort sort ndxs_counter extras);
216 # push @custom_hiddens, qw(itemstatus l_linetotal l_partnumber l_description l_onhand l_unit l_sellprice l_linetotalsellprice);
218 # +{ name => 'row', value => $j },
219 # +{ name => 'nextsub', value => 'item_selected' },
220 # +{ name => 'test', value => 'item_selected' },
221 # +{ name => 'lastndx', value => $lastndx },
222 # map(+{ name => $_, value => $form->{$_} }, @custom_hiddens),
225 # my ($partnumber, $description, $unit, $sellprice, $soldtotal);
226 # # if choice set data
227 ## if ($form->{ndx}) {
228 ## for my $i (0 .. $form->{ndxs_counter}) {
230 ## # insert data into top100
231 ## push @{ $form->{parts} },
233 ## partnumber => $form->{"totop100_partnumber_$j"},
234 ## description => $form->{"totop100_description_$j"},
235 ## unit => $form->{"totop100_unit_$j"},
236 ## sellprice => $form->{"totop100_sellprice_$j"},
237 ## soldtotal => $form->{"totop100_soldtotal_$j"},
244 # # set data for next page
245 # for my $i (1 .. $form->{ndxs_counter}) {
246 # $partnumber = $form->{"totop100_partnumber_$i"};
247 # $description = $form->{"totop100_description_$i"};
248 # $unit = $form->{"totop100_unit_$i"};
249 # $sellprice = $form->{"totop100_sellprice_$i"};
250 # $soldtotal = $form->{"totop100_soldtotal_$i"};
253 # totop100_partnumber => $form->{"totop100_partnumber_$i"},
254 # totop100_description => $form->{"totop100_description_$i"},
255 # totop100_unit => $form->{"totop100_unit_$i"},
256 # totop100_sellprice => $form->{"totop100_sellprice_$i"},
257 # totop100_soldtotal => $form->{"totop100_soldtotal_$i"},
261 ##<input type=hidden name=totop100_partnumber_$i value=$form->{"totop100_partnumber_$i"}>
262 ##<input type=hidden name=totop100_description_$i value=$form->{"totop100_description_$i"}>
263 ##<input type=hidden name=totop100_unit_$i value=$form->{"totop100_unit_$i"}>
264 ##<input type=hidden name=totop100_sellprice_$i value=$form->{"totop100_sellprice_$i"}>
265 ##<input type=hidden name=totop100_soldtotal_$i value=$form->{"totop100_soldtotal_$i"}>
269 # print $form->parse_html_template('ic/choice', +{ HIDDENS => \@HIDDENS, PARTS => \@PARTS });
271 # $lxdebug->leave_sub();
275 # $lxdebug->enter_sub();
277 # $auth->assert('part_service_assembly_edit');
280 # our ($partnumber, $description, $unit, $sellprice, $soldtotal);
282 # my @sortorders = ("", "partnumber", "description", "all");
283 # my $sortorder = $sortorders[($form->{description} ? 2 : 0) + ($form->{partnumber} ? 1 : 0)];
284 # IC->get_parts(\%myconfig, \%$form, $sortorder);
286 # $form->{title} = $locale->text('Top 100 hinzufuegen');
292 # <form method=post action=ic.pl>
295 # <th class=listtop colspan=6>| . $locale->text('choice part') . qq|</th>
297 # <tr height="5"></tr>
298 # <tr class=listheading>
300 # <th class=listheading>| . $locale->text('Part Number') . qq|</th>
301 # <th class=listheading>| . $locale->text('Part Description') . qq|</th>
302 # <th class=listheading>| . $locale->text('Unit of measure') . qq|</th>
303 # <th class=listheading>| . $locale->text('Sell Price') . qq|</th>
304 # <th class=listheading>| . $locale->text('soldtotal') . qq|</th>
308 # my $i = $form->{rows};
310 # for ($j = 1; $j <= $i; $j++) {
313 # <tr class=listrow| . ($j % 2) . qq|>|;
316 # <td><input name=ndx class=radio type=radio value=$j checked></td>|;
319 # <td><input name=ndx class=radio type=radio value=$j></td>|;
322 # <td><input name="new_partnumber_$j" type=hidden value="$form->{"partnumber_$j"}">$form->{"partnumber_$j"}</td>
323 # <td><input name="new_description_$j" type=hidden value="$form->{"description_$j"}">$form->{"description_$j"}</td>
324 # <td><input name="new_unit_$j" type=hidden value="$form->{"unit_$j"}">$form->{"unit_$j"}</td>
325 # <td><input name="new_sellprice_$j" type=hidden value="$form->{"sellprice_$j"}">$form->{"sellprice_$j"}</td>
326 # <td><input name="new_soldtotal_$j" type=hidden value="$form->{"soldtotal_$j"}">$form->{"soldtotal_$j"}</td>
329 # <input name="new_id_$j" type=hidden value="$form->{"id_$j"}">|;
339 #<input type=hidden name=itemstatus value="$form->{itemstatus}">
340 #<input type=hidden name=l_linetotal value="$form->{l_linetotal}">
341 #<input type=hidden name=l_partnumber value="$form->{l_partnumber}">
342 #<input type=hidden name=l_description value="$form->{l_description}">
343 #<input type=hidden name=l_onhand value="$form->{l_onhand}">
344 #<input type=hidden name=l_unit value="$form->{l_unit}">
345 #<input type=hidden name=l_sellprice value="$form->{l_sellprice}">
346 #<input type=hidden name=l_linetotalsellprice value="$form->{l_linetotalsellprice}">
347 #<input type=hidden name=sort value="$form->{sort}">
348 #<input type=hidden name=revers value="$form->{revers}">
349 #<input type=hidden name=lastsort value="$form->{lastsort}">
351 #<input type=hidden name=bom value="$form->{bom}">
352 #<input type=hidden name=titel value="$form->{titel}">
353 #<input type=hidden name=searchitems value="$form->{searchitems}">
355 #<input type=hidden name=row value=$j>
357 #<input type=hidden name=nextsub value=item_selected>
359 #<input name=lastndx type=hidden value=$lastndx>
361 #<input name=ndxs_counter type=hidden value=$form->{ndxs_counter}>|;
365 # if (($form->{ndxs_counter}) > 0) {
366 # for ($i = 1; ($i < $form->{ndxs_counter} + 1); $i++) {
368 # $partnumber = $form->{"totop100_partnumber_$i"};
369 # $description = $form->{"totop100_description_$i"};
370 # $unit = $form->{"totop100_unit_$i"};
371 # $sellprice = $form->{"totop100_sellprice_$i"};
372 # $soldtotal = $form->{"totop100_soldtotal_$i"};
375 #<input type=hidden name=totop100_partnumber_$i value=$form->{"totop100_partnumber_$i"}>
376 #<input type=hidden name=totop100_description_$i value=$form->{"totop100_description_$i"}>
377 #<input type=hidden name=totop100_unit_$i value=$form->{"totop100_unit_$i"}>
378 #<input type=hidden name=totop100_sellprice_$i value=$form->{"totop100_sellprice_$i"}>
379 #<input type=hidden name=totop100_soldtotal_$i value=$form->{"totop100_soldtotal_$i"}>
387 #<input class=submit type=submit name=action value="|
388 # . $locale->text('TOP100') . qq|">
393 # $lxdebug->leave_sub();
397 $lxdebug->enter_sub();
399 $auth->assert('part_service_assembly_edit');
402 $form->{ndxs_counter}++;
404 if ($form->{ndxs_counter} > 0) {
406 my $index = $form->{ndx};
408 $form->{"totop100_partnumber_$form->{ndxs_counter}"} = $form->{"new_partnumber_$index"};
409 $form->{"totop100_description_$form->{ndxs_counter}"} = $form->{"new_description_$index"};
410 $form->{"totop100_unit_$form->{ndxs_counter}"} = $form->{"new_unit_$index"};
411 $form->{"totop100_sellprice_$form->{ndxs_counter}"} = $form->{"new_sellprice_$index"};
412 $form->{"totop100_soldtotal_$form->{ndxs_counter}"} = $form->{"new_soldtotal_$index"};
416 $lxdebug->leave_sub();
420 $lxdebug->enter_sub();
422 $auth->assert('part_service_assembly_edit');
424 my ($revers, $lastsort, $callback, $option, $description, $sameitem,
425 $partnumber, $unit, $sellprice, $soldtotal, $totop100, $onhand, $align);
426 my (@column_index, %column_header, %column_data);
427 my ($totalsellprice, $totallastcost, $totallistprice, $subtotalonhand, $subtotalsellprice, $subtotallastcost, $subtotallistprice);
429 $form->{top100} = "top100";
430 $form->{l_soldtotal} = "Y";
431 $form->{soldtotal} = "soldtotal";
432 $form->{sort} = "soldtotal";
433 $form->{l_qty} = "N";
434 $form->{l_linetotal} = "";
436 $form->{number} = "position";
437 $form->{l_number} = "Y";
441 $form->{title} = $locale->text('Top 100');
443 $revers = $form->{revers};
444 $lastsort = $form->{lastsort};
446 if (($form->{lastsort} eq "") && ($form->{sort} eq undef)) {
448 $form->{lastsort} = "partnumber";
449 $form->{sort} = "partnumber";
453 "$form->{script}?action=top100&searchitems=$form->{searchitems}&itemstatus=$form->{itemstatus}&bom=$form->{bom}&l_linetotal=$form->{l_linetotal}&title="
454 . $form->escape($form->{title}, 1);
456 # if we have a serialnumber limit search
457 if ($form->{serialnumber} || $form->{l_serialnumber}) {
458 $form->{l_serialnumber} = "Y";
459 unless ( $form->{bought}
462 || $form->{quoted}) {
463 $form->{bought} = $form->{sold} = 1;
466 IC->all_parts(\%myconfig, \%$form);
468 if ($form->{itemstatus} eq 'active') {
469 $option .= $locale->text('Active') . " : ";
471 if ($form->{itemstatus} eq 'obsolete') {
472 $option .= $locale->text('Obsolete') . " : ";
474 if ($form->{itemstatus} eq 'orphaned') {
475 $option .= $locale->text('Orphaned') . " : ";
477 if ($form->{itemstatus} eq 'onhand') {
478 $option .= $locale->text('On Hand') . " : ";
479 $form->{l_onhand} = "Y";
481 if ($form->{itemstatus} eq 'short') {
482 $option .= $locale->text('Short') . " : ";
483 $form->{l_onhand} = "Y";
485 if ($form->{onorder}) {
486 $form->{l_ordnumber} = "Y";
487 $callback .= "&onorder=$form->{onorder}";
488 $option .= $locale->text('On Order') . " : ";
490 if ($form->{ordered}) {
491 $form->{l_ordnumber} = "Y";
492 $callback .= "&ordered=$form->{ordered}";
493 $option .= $locale->text('Ordered') . " : ";
496 $form->{l_quonumber} = "Y";
497 $callback .= "&rfq=$form->{rfq}";
498 $option .= $locale->text('RFQ') . " : ";
500 if ($form->{quoted}) {
501 $form->{l_quonumber} = "Y";
502 $callback .= ""ed=$form->{quoted}";
503 $option .= $locale->text('Quoted') . " : ";
505 if ($form->{bought}) {
506 $form->{l_invnumber} = "Y";
507 $callback .= "&bought=$form->{bought}";
508 $option .= $locale->text('Bought') . " : ";
511 $form->{l_invnumber} = "Y";
512 $callback .= "&sold=$form->{sold}";
513 $option .= $locale->text('Sold') . " : ";
520 || $form->{quoted}) {
522 $form->{l_lastcost} = "";
523 $form->{l_name} = "Y";
524 if ($form->{transdatefrom}) {
525 $callback .= "&transdatefrom=$form->{transdatefrom}";
527 . $locale->text('From')
529 . $locale->date(\%myconfig, $form->{transdatefrom}, 1);
531 if ($form->{transdateto}) {
532 $callback .= "&transdateto=$form->{transdateto}";
534 . $locale->text('To')
536 . $locale->date(\%myconfig, $form->{transdateto}, 1);
542 if ($form->{partnumber}) {
543 $callback .= "&partnumber=$form->{partnumber}";
544 $option .= $locale->text('Part Number') . qq| : $form->{partnumber}<br>|;
547 $callback .= "&partnumber=$form->{ean}";
548 $option .= $locale->text('EAN') . qq| : $form->{ean}<br>|;
550 if ($form->{partsgroup}) {
551 $callback .= "&partsgroup=$form->{partsgroup}";
552 $option .= $locale->text('Group') . qq| : $form->{partsgroup}<br>|;
554 if ($form->{serialnumber}) {
555 $callback .= "&serialnumber=$form->{serialnumber}";
556 $option .= $locale->text('Serial Number') . qq| : $form->{serialnumber}<br>|;
558 if ($form->{description}) {
559 $callback .= "&description=$form->{description}";
560 $description = $form->{description};
561 $description =~ s/\n/<br>/g;
562 $option .= $locale->text('Part Description') . qq| : $form->{description}<br>|;
565 $callback .= "&make=$form->{make}";
566 $option .= $locale->text('Make') . qq| : $form->{make}<br>|;
568 if ($form->{model}) {
569 $callback .= "&model=$form->{model}";
570 $option .= $locale->text('Model') . qq| : $form->{model}<br>|;
572 if ($form->{drawing}) {
573 $callback .= "&drawing=$form->{drawing}";
574 $option .= $locale->text('Drawing') . qq| : $form->{drawing}<br>|;
576 if ($form->{microfiche}) {
577 $callback .= "µfiche=$form->{microfiche}";
578 $option .= $locale->text('Microfiche') . qq| : $form->{microfiche}<br>|;
580 if ($form->{l_soldtotal}) {
581 $callback .= "&soldtotal=$form->{soldtotal}";
582 $option .= $locale->text('soldtotal') . qq| : $form->{soldtotal}<br>|;
585 my @columns = $form->sort_columns(
586 qw(number partnumber ean description partsgroup bin onhand rop unit listprice linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost priceupdate weight image drawing microfiche invnumber ordnumber quonumber name serialnumber soldtotal)
589 if ($form->{l_linetotal}) {
590 $form->{l_onhand} = "Y";
591 $form->{l_linetotalsellprice} = "Y" if $form->{l_sellprice};
592 if ($form->{l_lastcost}) {
593 $form->{l_linetotallastcost} = "Y";
594 if (($form->{searchitems} eq 'assembly') && !$form->{bom}) {
595 $form->{l_linetotallastcost} = "";
598 $form->{l_linetotallistprice} = "Y" if $form->{l_listprice};
601 if ($form->{searchitems} eq 'service') {
603 # remove bin, weight and rop from list
604 map { $form->{"l_$_"} = "" } qw(bin weight rop);
606 $form->{l_onhand} = "";
608 # qty is irrelevant unless bought or sold
614 || $form->{quoted}) {
615 $form->{l_onhand} = "Y";
617 $form->{l_linetotalsellprice} = "";
618 $form->{l_linetotallastcost} = "";
622 foreach my $item (@columns) {
623 if ($form->{"l_$item"} eq "Y") {
624 push @column_index, $item;
626 # add column to callback
627 $callback .= "&l_$item=Y";
631 if ($form->{l_subtotal} eq 'Y') {
632 $callback .= "&l_subtotal=Y";
635 $column_header{number} =
636 qq|<th class=listheading nowrap>| . $locale->text('number') . qq|</th>|;
637 $column_header{partnumber} =
638 qq|<th nowrap><a class=listheading href=$callback&sort=partnumber&revers=$form->{revers}&lastsort=$form->{lastsort}>|
639 . $locale->text('Part Number')
641 $column_header{description} =
642 qq|<th nowrap><a class=listheading href=$callback&sort=description&revers=$form->{revers}&lastsort=$form->{lastsort}>|
643 . $locale->text('Part Description')
645 $column_header{partsgroup} =
646 qq|<th nowrap><a class=listheading href=$callback&sort=partsgroup>|
647 . $locale->text('Group')
649 $column_header{bin} =
650 qq|<th><a class=listheading href=$callback&sort=bin>|
651 . $locale->text('Bin')
653 $column_header{priceupdate} =
654 qq|<th nowrap><a class=listheading href=$callback&sort=priceupdate>|
655 . $locale->text('Updated')
657 $column_header{onhand} =
658 qq|<th nowrap><a class=listheading href=$callback&sort=onhand&revers=$form->{revers}&lastsort=$form->{lastsort}>|
659 . $locale->text('Qty')
661 $column_header{unit} =
662 qq|<th class=listheading nowrap>| . $locale->text('Unit') . qq|</th>|;
663 $column_header{listprice} =
664 qq|<th class=listheading nowrap>|
665 . $locale->text('List Price')
667 $column_header{lastcost} =
668 qq|<th class=listheading nowrap>| . $locale->text('Last Cost') . qq|</th>|;
669 $column_header{rop} =
670 qq|<th class=listheading nowrap>| . $locale->text('ROP') . qq|</th>|;
671 $column_header{weight} =
672 qq|<th class=listheading nowrap>| . $locale->text('Weight') . qq|</th>|;
674 $column_header{invnumber} =
675 qq|<th nowrap><a class=listheading href=$callback&sort=invnumber>|
676 . $locale->text('Invoice Number')
678 $column_header{ordnumber} =
679 qq|<th nowrap><a class=listheading href=$callback&sort=ordnumber>|
680 . $locale->text('Order Number')
682 $column_header{quonumber} =
683 qq|<th nowrap><a class=listheading href=$callback&sort=quonumber>|
684 . $locale->text('Quotation')
687 $column_header{name} =
688 qq|<th nowrap><a class=listheading href=$callback&sort=name>|
689 . $locale->text('Name')
692 $column_header{sellprice} =
693 qq|<th class=listheading nowrap>|
694 . $locale->text('Sell Price')
696 $column_header{linetotalsellprice} =
697 qq|<th class=listheading nowrap>| . $locale->text('Extended') . qq|</th>|;
698 $column_header{linetotallastcost} =
699 qq|<th class=listheading nowrap>| . $locale->text('Extended') . qq|</th>|;
700 $column_header{linetotallistprice} =
701 qq|<th class=listheading nowrap>| . $locale->text('Extended') . qq|</th>|;
703 $column_header{image} =
704 qq|<th class=listheading nowrap>| . $locale->text('Image') . qq|</a></th>|;
705 $column_header{drawing} =
706 qq|<th nowrap><a class=listheading href=$callback&sort=drawing>|
707 . $locale->text('Drawing')
709 $column_header{microfiche} =
710 qq|<th nowrap><a class=listheading href=$callback&sort=microfiche>|
711 . $locale->text('Microfiche')
714 $column_header{serialnumber} =
715 qq|<th nowrap><a class=listheading href=$callback&sort=serialnumber>|
716 . $locale->text('Serial Number')
718 $column_header{soldtotal} =
719 qq|<th nowrap><a class=listheading href=$callback&sort=soldtotal&revers=$form->{revers}&lastsort=$form->{lastsort}>|
720 . $locale->text('soldtotal')
724 my $colspan = $#column_index + 1;
731 <th class=listtop colspan=$colspan>$form->{title}</th>
735 <tr><td colspan=$colspan>$option</td></tr>
737 <tr class=listheading>
740 map { print "\n$column_header{$_}" } @column_index;
746 # add order to callback
747 $form->{callback} = $callback .= "&sort=$form->{sort}";
749 # escape callback for href
750 $callback = $form->escape($callback);
752 if (@{ $form->{parts} }) {
753 $sameitem = $form->{parts}->[0]->{ $form->{sort} };
756 # insert numbers for top100
758 foreach my $ref (@{ $form->{parts} }) {
763 # if avaible -> insert choice here
764 if (($form->{ndxs_counter}) > 0) {
765 for (my $i = 1; ($i < $form->{ndxs_counter} + 1); $i++) {
766 $partnumber = $form->{"totop100_partnumber_$i"};
767 $description = $form->{"totop100_description_$i"};
768 $unit = $form->{"totop100_unit_$i"};
769 $sellprice = $form->{"totop100_sellprice_$i"};
770 $soldtotal = $form->{"totop100_soldtotal_$i"};
773 <input type=hidden name=totop100_partnumber_$i value=$form->{"totop100_partnumber_$i"}>
774 <input type=hidden name=totop100_description_$i value=$form->{"totop100_description_$i"}>
775 <input type=hidden name=totop100_unit_$i value=$form->{"totop100_unit_$i"}>
776 <input type=hidden name=totop100_sellprice_$i value=$form->{"totop100_sellprice_$i"}>
777 <input type=hidden name=totop100_soldtotal_$i value=$form->{"totop100_soldtotal_$i"}>
781 push @{ $form->{parts} },
783 partnumber => "$partnumber",
784 description => "$description",
786 sellprice => "$sellprice",
787 soldtotal => "$soldtotal" };
790 # build data for columns
792 foreach my $ref (@{ $form->{parts} }) {
794 if ($form->{l_subtotal} eq 'Y' && !$ref->{assemblyitem}) {
795 if ($sameitem ne $ref->{ $form->{sort} }) {
796 parts_subtotal(\@column_index, \$subtotalonhand, \$subtotalsellprice, \$subtotallastcost, \$subtotallistprice);
797 $sameitem = $ref->{ $form->{sort} };
801 $ref->{exchangerate} = 1 unless $ref->{exchangerate};
802 $ref->{sellprice} *= $ref->{exchangerate};
803 $ref->{listprice} *= $ref->{exchangerate};
804 $ref->{lastcost} *= $ref->{exchangerate};
806 # use this for assemblies
807 $onhand = $ref->{onhand};
810 if ($ref->{assemblyitem}) {
812 $onhand = 0 if ($form->{sold});
815 $ref->{description} =~ s/\n/<br>/g;
817 $column_data{number} =
819 . $form->format_amount(\%myconfig, $ref->{number})
821 $column_data{partnumber} =
822 "<td align=$align>$ref->{partnumber} </a></td>";
823 $column_data{description} = "<td>$ref->{description} </td>";
824 $column_data{partsgroup} = "<td>$ref->{partsgroup} </td>";
826 $column_data{onhand} =
828 . $form->format_amount(\%myconfig, $ref->{onhand})
830 $column_data{sellprice} =
832 . $form->format_amount(\%myconfig, $ref->{sellprice})
834 $column_data{listprice} =
836 . $form->format_amount(\%myconfig, $ref->{listprice})
838 $column_data{lastcost} =
840 . $form->format_amount(\%myconfig, $ref->{lastcost})
843 $column_data{linetotalsellprice} = "<td align=right>"
844 . $form->format_amount(\%myconfig, $ref->{onhand} * $ref->{sellprice}, 2)
846 $column_data{linetotallastcost} = "<td align=right>"
847 . $form->format_amount(\%myconfig, $ref->{onhand} * $ref->{lastcost}, 2)
849 $column_data{linetotallistprice} = "<td align=right>"
850 . $form->format_amount(\%myconfig, $ref->{onhand} * $ref->{listprice}, 2)
853 if (!$ref->{assemblyitem}) {
854 $totalsellprice += $onhand * $ref->{sellprice};
855 $totallastcost += $onhand * $ref->{lastcost};
856 $totallistprice += $onhand * $ref->{listprice};
858 $subtotalonhand += $onhand;
859 $subtotalsellprice += $onhand * $ref->{sellprice};
860 $subtotallastcost += $onhand * $ref->{lastcost};
861 $subtotallistprice += $onhand * $ref->{listprice};
866 . $form->format_amount(\%myconfig, $ref->{rop}) . "</td>";
867 $column_data{weight} =
869 . $form->format_amount(\%myconfig, $ref->{weight})
871 $column_data{unit} = "<td>$ref->{unit} </td>";
872 $column_data{bin} = "<td>$ref->{bin} </td>";
873 $column_data{priceupdate} = "<td>$ref->{priceupdate} </td>";
875 $column_data{invnumber} =
876 ($ref->{module} ne 'oe')
877 ? "<td><a href=$ref->{module}.pl?action=edit&type=invoice&id=$ref->{trans_id}&callback=$callback>$ref->{invnumber}</a></td>"
878 : "<td>$ref->{invnumber}</td>";
879 $column_data{ordnumber} =
880 ($ref->{module} eq 'oe')
881 ? "<td><a href=$ref->{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&callback=$callback>$ref->{ordnumber}</a></td>"
882 : "<td>$ref->{ordnumber}</td>";
883 $column_data{quonumber} =
884 ($ref->{module} eq 'oe' && !$ref->{ordnumber})
885 ? "<td><a href=$ref->{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&callback=$callback>$ref->{quonumber}</a></td>"
886 : "<td>$ref->{quonumber}</td>";
888 $column_data{name} = "<td>$ref->{name}</td>";
890 $column_data{image} =
892 ? "<td><a href=$ref->{image}><img src=$ref->{image} height=32 border=0></a></td>"
894 $column_data{drawing} =
896 ? "<td><a href=$ref->{drawing}>$ref->{drawing}</a></td>"
898 $column_data{microfiche} =
900 ? "<td><a href=$ref->{microfiche}>$ref->{microfiche}</a></td>"
903 $column_data{serialnumber} = "<td>$ref->{serialnumber}</td>";
905 $column_data{soldtotal} = "<td align=right>$ref->{soldtotal}</td>";
909 print "<tr class=listrow$i>";
911 map { print "\n$column_data{$_}" } @column_index;
918 if ($form->{l_subtotal} eq 'Y') {
919 parts_subtotal(\@column_index, \$subtotalonhand, \$subtotalsellprice, \$subtotallastcost, \$subtotallistprice);
922 if ($form->{"l_linetotal"}) {
923 map { $column_data{$_} = "<td> </td>" } @column_index;
924 $column_data{linetotalsellprice} =
925 "<th class=listtotal align=right>"
926 . $form->format_amount(\%myconfig, $totalsellprice, 2)
928 $column_data{linetotallastcost} =
929 "<th class=listtotal align=right>"
930 . $form->format_amount(\%myconfig, $totallastcost, 2)
932 $column_data{linetotallistprice} =
933 "<th class=listtotal align=right>"
934 . $form->format_amount(\%myconfig, $totallistprice, 2)
937 print "<tr class=listtotal>";
939 map { print "\n$column_data{$_}" } @column_index;
946 <tr><td colspan=$colspan><hr size=3 noshade></td></tr>
955 <form method=post action=$form->{script}>
957 <input type=hidden name=itemstatus value="$form->{itemstatus}">
958 <input type=hidden name=l_linetotal value="$form->{l_linetotal}">
959 <input type=hidden name=l_partnumber value="$form->{l_partnumber}">
960 <input type=hidden name=l_description value="$form->{l_description}">
961 <input type=hidden name=l_onhand value="$form->{l_onhand}">
962 <input type=hidden name=l_unit value="$form->{l_unit}">
963 <input type=hidden name=l_sellprice value="$form->{l_sellprice}">
964 <input type=hidden name=l_linetotalsellprice value="$form->{l_linetotalsellprice}">
965 <input type=hidden name=sort value="$form->{sort}">
966 <input type=hidden name=revers value="$form->{revers}">
967 <input type=hidden name=lastsort value="$form->{lastsort}">
968 <input type=hidden name=parts value="$form->{parts}">
970 <input type=hidden name=bom value="$form->{bom}">
971 <input type=hidden name=titel value="$form->{titel}">
972 <input type=hidden name=searchitems value="$form->{searchitems}">|;
977 <!-- <input type=hidden name=ndxs_counter value="$form->{ndxs_counter}">-->
979 <input class=submit type=submit name=action value="|
980 . $locale->text('choice') . qq|">
987 $lxdebug->leave_sub();
992 # Warning, deep magic ahead.
993 # This function parses the requested details, sanity checks them, and converts them into a format thats usable for IC->all_parts
995 # flags coming from the form:
997 # searchitems=part revers=0 lastsort=''
1000 # partnumber ean description partsgroup serialnumber make model drawing microfiche
1001 # transdatefrom transdateto
1004 # itemstatus = active | onhand | short | obsolete | orphaned
1005 # action = continue | top100
1008 # bought sold onorder ordered rfq quoted
1009 # l_partnumber l_description l_serialnumber l_unit l_listprice l_sellprice l_lastcost
1010 # l_linetotal l_priceupdate l_bin l_rop l_weight l_image l_drawing l_microfiche
1011 # l_partsgroup l_subtotal l_soldtotal l_deliverydate l_pricegroups
1014 # nextsub revers lastsort sort ndxs_counter
1016 sub generate_report {
1017 $lxdebug->enter_sub();
1019 $auth->assert('part_service_assembly_edit');
1021 my ($revers, $lastsort, $description);
1023 my $cvar_configs = CVar->get_configs('module' => 'IC');
1025 $form->{title} = (ucfirst $form->{searchitems}) . "s";
1026 $form->{title} =~ s/ys$/ies/;
1027 $form->{title} = $locale->text($form->{title});
1030 'bin' => { 'text' => $locale->text('Bin'), },
1031 'deliverydate' => { 'text' => $locale->text('deliverydate'), },
1032 'description' => { 'text' => $locale->text('Part Description'), },
1033 'drawing' => { 'text' => $locale->text('Drawing'), },
1034 'ean' => { 'text' => $locale->text('EAN'), },
1035 'image' => { 'text' => $locale->text('Image'), },
1036 'invnumber' => { 'text' => $locale->text('Invoice Number'), },
1037 'lastcost' => { 'text' => $locale->text('Last Cost'), },
1038 'linetotallastcost' => { 'text' => $locale->text('Extended'), },
1039 'linetotallistprice' => { 'text' => $locale->text('Extended'), },
1040 'linetotalsellprice' => { 'text' => $locale->text('Extended'), },
1041 'listprice' => { 'text' => $locale->text('List Price'), },
1042 'microfiche' => { 'text' => $locale->text('Microfiche'), },
1043 'name' => { 'text' => $locale->text('Name'), },
1044 'onhand' => { 'text' => $locale->text('Stocked Qty'), },
1045 'ordnumber' => { 'text' => $locale->text('Order Number'), },
1046 'partnumber' => { 'text' => $locale->text('Part Number'), },
1047 'partsgroup' => { 'text' => $locale->text('Group'), },
1048 'priceupdate' => { 'text' => $locale->text('Updated'), },
1049 'quonumber' => { 'text' => $locale->text('Quotation'), },
1050 'rop' => { 'text' => $locale->text('ROP'), },
1051 'sellprice' => { 'text' => $locale->text('Sell Price'), },
1052 'serialnumber' => { 'text' => $locale->text('Serial Number'), },
1053 'soldtotal' => { 'text' => $locale->text('Qty in Selected Records'), },
1054 'transdate' => { 'text' => $locale->text('Transdate'), },
1055 'unit' => { 'text' => $locale->text('Unit'), },
1056 'weight' => { 'text' => $locale->text('Weight'), },
1057 'projectnumber' => { 'text' => $locale->text('Project Number'), },
1058 'projectdescription' => { 'text' => $locale->text('Project Description'), },
1061 $revers = $form->{revers};
1062 $lastsort = $form->{lastsort};
1064 # sorting and direction of sorting
1065 # ToDO: change this to the simpler field+direction method
1066 if (($form->{lastsort} eq "") && ($form->{sort} eq undef)) {
1067 $form->{revers} = 0;
1068 $form->{lastsort} = "partnumber";
1069 $form->{sort} = "partnumber";
1071 if ($form->{lastsort} eq $form->{sort}) {
1072 $form->{revers} = 1 - $form->{revers};
1074 $form->{revers} = 0;
1075 $form->{lastsort} = $form->{sort};
1079 # special case if we have a serialnumber limit search
1080 # serialnumbers are only given in invoices and orders,
1081 # so they can only pop up in bought, sold, rfq, and quoted stuff
1082 $form->{no_sn_joins} = 'Y' if ( !$form->{bought} && !$form->{sold}
1083 && !$form->{rfq} && !$form->{quoted}
1084 && ($form->{l_serialnumber} || $form->{serialnumber}));
1086 # special case for any checkbox of bought | sold | onorder | ordered | rfq | quoted.
1087 # if any of these are ticked the behavior changes slightly for lastcost
1088 # since all those are aggregation checks for the legder tables this is an internal switch
1089 # refered to as ledgerchecks
1090 $form->{ledgerchecks} = 'Y' if ( $form->{bought} || $form->{sold} || $form->{onorder}
1091 || $form->{ordered} || $form->{rfq} || $form->{quoted});
1093 # if something should be activated if something else is active, enter it here
1094 my %dependencies = (
1095 onhand => [ qw(l_onhand) ],
1096 short => [ qw(l_onhand) ],
1097 onorder => [ qw(l_ordnumber) ],
1098 ordered => [ qw(l_ordnumber) ],
1099 rfq => [ qw(l_quonumber) ],
1100 quoted => [ qw(l_quonumber) ],
1101 bought => [ qw(l_invnumber) ],
1102 sold => [ qw(l_invnumber) ],
1103 ledgerchecks => [ qw(l_name) ],
1104 serialnumber => [ qw(l_serialnumber) ],
1105 no_sn_joins => [ qw(bought sold) ],
1108 # get name of partsgroup if id is given
1110 if ($form->{partsgroup_id}) {
1111 my $pg = SL::DB::PartsGroup->new(id => $form->{partsgroup_id})->load;
1112 $pg_name = $pg->{'partsgroup'};
1115 # these strings get displayed at the top of the results to indicate the user which switches were used
1117 active => $locale->text('Active'),
1118 obsolete => $locale->text('Obsolete'),
1119 orphaned => $locale->text('Orphaned'),
1120 onhand => $locale->text('On Hand'),
1121 short => $locale->text('Short'),
1122 onorder => $locale->text('On Order'),
1123 ordered => $locale->text('Ordered'),
1124 rfq => $locale->text('RFQ'),
1125 quoted => $locale->text('Quoted'),
1126 bought => $locale->text('Bought'),
1127 sold => $locale->text('Sold'),
1128 transdatefrom => $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1),
1129 transdateto => $locale->text('To (time)') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1),
1130 partnumber => $locale->text('Part Number') . ": '$form->{partnumber}'",
1131 partsgroup => $locale->text('Group') . ": '$form->{partsgroup}'",
1132 partsgroup_id => $locale->text('Group') . ": '$pg_name'",
1133 serialnumber => $locale->text('Serial Number') . ": '$form->{serialnumber}'",
1134 description => $locale->text('Part Description') . ": '$form->{description}'",
1135 make => $locale->text('Make') . ": '$form->{make}'",
1136 model => $locale->text('Model') . ": '$form->{model}'",
1137 drawing => $locale->text('Drawing') . ": '$form->{drawing}'",
1138 microfiche => $locale->text('Microfiche') . ": '$form->{microfiche}'",
1139 l_soldtotal => $locale->text('Qty in Selected Records'),
1140 ean => $locale->text('EAN') . ": '$form->{ean}'",
1143 my @itemstatus_keys = qw(active obsolete orphaned onhand short);
1144 my @callback_keys = qw(onorder ordered rfq quoted bought sold partnumber partsgroup partsgroup_id serialnumber description make model
1145 drawing microfiche l_soldtotal l_deliverydate transdatefrom transdateto ean);
1147 # calculate dependencies
1148 for (@itemstatus_keys, @callback_keys) {
1149 next if ($form->{itemstatus} ne $_ && !$form->{$_});
1150 map { $form->{$_} = 'Y' } @{ $dependencies{$_} } if $dependencies{$_};
1153 # generate callback and optionstrings
1155 for my $key (@itemstatus_keys, @callback_keys) {
1156 next if ($form->{itemstatus} ne $key && !$form->{$key});
1157 push @options, $optiontexts{$key};
1160 # special case for lastcost
1161 if ($form->{ledgerchecks}){
1162 # ledgerchecks don't know about sellprice or lastcost. they just return a
1163 # price. so rename sellprice to price, and drop lastcost.
1164 $column_defs{sellprice}{text} = $locale->text('Price');
1165 $form->{l_lastcost} = ""
1168 if ($form->{description}) {
1169 $description = $form->{description};
1170 $description =~ s/\n/<br>/g;
1173 if ($form->{l_linetotal}) {
1174 $form->{l_qty} = "Y";
1175 $form->{l_linetotalsellprice} = "Y" if $form->{l_sellprice};
1176 $form->{l_linetotallastcost} = $form->{searchitems} eq 'assembly' && !$form->{bom} ? "" : 'Y' if $form->{l_lastcost};
1177 $form->{l_linetotallistprice} = "Y" if $form->{l_listprice};
1180 if ($form->{searchitems} eq 'service') {
1182 # remove bin, weight and rop from list
1183 map { $form->{"l_$_"} = "" } qw(bin weight rop);
1185 $form->{l_onhand} = "";
1187 # qty is irrelevant unless bought or sold
1188 if ( $form->{bought}
1193 || $form->{quoted}) {
1194 # $form->{l_onhand} = "Y";
1196 $form->{l_linetotalsellprice} = "";
1197 $form->{l_linetotallastcost} = "";
1201 # soldtotal doesn't make sense with more than one bsooqr option.
1202 # so reset it to sold (the most common option), and issue a warning
1203 my @bsooqr = qw(sold bought onorder ordered rfq quoted);
1204 if ($form->{l_subtotal} && 1 < grep { $form->{$_} } @bsooqr) {
1205 my $enabled = first { $form->{$_} } @bsooqr;
1206 $form->{$_} = '' for @bsooqr;
1207 $form->{$enabled} = 'Y';
1209 push @options, $::locale->text('Subtotal cannot distinguish betweens record types. Only one of the selected record types will be displayed: #1', $optiontexts{$enabled});
1212 IC->all_parts(\%myconfig, \%$form);
1215 partnumber description partsgroup bin onhand rop soldtotal unit listprice
1216 linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost
1217 priceupdate weight image drawing microfiche invnumber ordnumber quonumber
1218 transdate name serialnumber deliverydate ean projectnumber projectdescription
1221 my $pricegroups = SL::DB::Manager::Pricegroup->get_all(sort => 'id');
1222 my @pricegroup_columns;
1223 my %column_defs_pricegroups;
1224 if ($form->{l_pricegroups}) {
1225 @pricegroup_columns = map { "pricegroup_" . $_->id } @{ $pricegroups };
1226 %column_defs_pricegroups = map {
1227 "pricegroup_" . $_->id => {
1228 text => $::locale->text('Pricegroup') . ' ' . $_->pricegroup,
1231 } @{ $pricegroups };
1233 push @columns, @pricegroup_columns;
1235 my @includeable_custom_variables = grep { $_->{includeable} } @{ $cvar_configs };
1236 my @searchable_custom_variables = grep { $_->{searchable} } @{ $cvar_configs };
1237 my %column_defs_cvars = map { +"cvar_$_->{name}" => { 'text' => $_->{description} } } @includeable_custom_variables;
1239 push @columns, map { "cvar_$_->{name}" } @includeable_custom_variables;
1241 %column_defs = (%column_defs, %column_defs_cvars, %column_defs_pricegroups);
1242 map { $column_defs{$_}->{visible} ||= $form->{"l_$_"} ? 1 : 0 } @columns;
1243 map { $column_defs{$_}->{align} = 'right' } qw(onhand sellprice listprice lastcost linetotalsellprice linetotallastcost linetotallistprice rop weight soldtotal), @pricegroup_columns;
1245 my @hidden_variables = (qw(l_subtotal l_linetotal searchitems itemstatus bom l_pricegroups), @itemstatus_keys, @callback_keys,
1246 map({ "cvar_$_->{name}" } @searchable_custom_variables), map { "l_$_" } @columns);
1248 my $callback = build_std_url('action=generate_report', grep { $form->{$_} } @hidden_variables);
1250 my @sort_full = qw(partnumber description onhand soldtotal deliverydate);
1251 my @sort_no_revers = qw(partsgroup bin priceupdate invnumber ordnumber quonumber name image drawing serialnumber);
1253 foreach my $col (@sort_full) {
1254 $column_defs{$col}->{link} = join '&', $callback, "sort=$col", map { "$_=" . E($form->{$_}) } qw(revers lastsort);
1256 map { $column_defs{$_}->{link} = "${callback}&sort=$_" } @sort_no_revers;
1258 # add order to callback
1259 $form->{callback} = join '&', ($callback, map { "${_}=" . E($form->{$_}) } qw(sort revers));
1261 my $report = SL::ReportGenerator->new(\%myconfig, $form);
1263 my %attachment_basenames = (
1264 'part' => $locale->text('part_list'),
1265 'service' => $locale->text('service_list'),
1266 'assembly' => $locale->text('assembly_list'),
1269 $report->set_options('top_info_text' => $locale->text('Options') . ': ' . join(', ', grep $_, @options),
1270 'raw_bottom_info_text' => $form->parse_html_template('ic/generate_report_bottom'),
1271 'output_format' => 'HTML',
1272 'title' => $form->{title},
1273 'attachment_basename' => $attachment_basenames{$form->{searchitems}} . strftime('_%Y%m%d', localtime time),
1275 $report->set_options_from_form();
1276 $locale->set_numberformat_wo_thousands_separator(\%myconfig) if lc($report->{options}->{output_format}) eq 'csv';
1278 $report->set_columns(%column_defs);
1279 $report->set_column_order(@columns);
1281 $report->set_export_options('generate_report', @hidden_variables, qw(sort revers));
1283 $report->set_sort_indicator($form->{sort}, $form->{revers} ? 0 : 1);
1285 CVar->add_custom_variables_to_report('module' => 'IC',
1286 'trans_id_field' => 'id',
1287 'configs' => $cvar_configs,
1288 'column_defs' => \%column_defs,
1289 'data' => $form->{parts});
1291 CVar->add_custom_variables_to_report('module' => 'IC',
1292 'sub_module' => sub { $_[0]->{ioi} },
1293 'trans_id_field' => 'ioi_id',
1294 'configs' => $cvar_configs,
1295 'column_defs' => \%column_defs,
1296 'data' => $form->{parts});
1298 my @subtotal_columns = qw(sellprice listprice lastcost);
1299 my %subtotals = map { $_ => 0 } ('onhand', @subtotal_columns);
1300 my %totals = map { $_ => 0 } @subtotal_columns;
1302 my $same_item = @{ $form->{parts} } ? $form->{parts}[0]{ $form->{sort} } : undef;
1304 my $defaults = AM->get_defaults();
1307 foreach my $ref (@{ $form->{parts} }) {
1309 # fresh row, for inserting later
1310 my $row = { map { $_ => { 'data' => $ref->{$_} } } @columns };
1312 $ref->{exchangerate} ||= 1;
1313 $ref->{price_factor} ||= 1;
1314 $ref->{sellprice} *= $ref->{exchangerate} / $ref->{price_factor};
1315 $ref->{listprice} *= $ref->{exchangerate} / $ref->{price_factor};
1316 $ref->{lastcost} *= $ref->{exchangerate} / $ref->{price_factor};
1318 # use this for assemblies
1319 my $soldtotal = $ref->{soldtotal};
1321 if ($ref->{assemblyitem}) {
1322 $row->{partnumber}{align} = 'right';
1323 $row->{soldtotal}{data} = 0;
1324 $soldtotal = 0 if ($form->{sold});
1327 my $edit_link = build_std_url('action=edit', 'id=' . E($ref->{id}), 'callback');
1328 $row->{partnumber}->{link} = $edit_link;
1329 $row->{description}->{link} = $edit_link;
1331 foreach (qw(sellprice listprice lastcost)) {
1332 $row->{$_}{data} = $form->format_amount(\%myconfig, $ref->{$_}, 2);
1333 $row->{"linetotal$_"}{data} = $form->format_amount(\%myconfig, $ref->{onhand} * $ref->{$_}, 2);
1335 foreach ( @pricegroup_columns ) {
1336 $row->{$_}{data} = $form->format_amount(\%myconfig, $ref->{"$_"}, 2);
1340 map { $row->{$_}{data} = $form->format_amount(\%myconfig, $ref->{$_}); } qw(onhand rop weight soldtotal);
1342 $row->{weight}->{data} .= ' ' . $defaults->{weightunit};
1344 if (!$ref->{assemblyitem}) {
1345 foreach my $col (@subtotal_columns) {
1346 $totals{$col} += $soldtotal * $ref->{$col};
1347 $subtotals{$col} += $soldtotal * $ref->{$col};
1350 $subtotals{soldtotal} += $soldtotal;
1354 if ($ref->{module} eq 'oe') {
1355 # für oe gibt es vier fälle, jeweils nach kunde oder lieferant unterschiedlich:
1357 # | ist bestellt | Vom Kunde bestellt | -> edit_oe_ord_link
1358 # | Anfrage | Angebot | -> edit_oe_quo_link
1360 my $edit_oe_ord_link = build_std_url("script=oe.pl", 'action=edit', 'type=' . E($ref->{cv} eq 'vendor' ? 'purchase_order' : 'sales_order'), 'id=' . E($ref->{trans_id}), 'callback');
1361 my $edit_oe_quo_link = build_std_url("script=oe.pl", 'action=edit', 'type=' . E($ref->{cv} eq 'vendor' ? 'request_quotation' : 'sales_quotation'), 'id=' . E($ref->{trans_id}), 'callback');
1363 $row->{ordnumber}{link} = $edit_oe_ord_link;
1364 $row->{quonumber}{link} = $edit_oe_quo_link if (!$ref->{ordnumber});
1367 $row->{invnumber}{link} = build_std_url("script=$ref->{module}.pl", 'action=edit', 'type=invoice', 'id=' . E($ref->{trans_id}), 'callback');
1370 # set properties of images
1371 if ($ref->{image} && (lc $report->{options}->{output_format} eq 'html')) {
1372 $row->{image}{data} = '';
1373 $row->{image}{raw_data} = '<a href="' . H($ref->{image}) . '"><img src="' . H($ref->{image}) . '" height="32" border="0"></a>';
1375 map { $row->{$_}{link} = $ref->{$_} } qw(drawing microfiche);
1377 $report->add_data($row);
1379 my $next_ref = $form->{parts}[$idx + 1];
1381 # insert subtotal rows
1382 if (($form->{l_subtotal} eq 'Y') &&
1384 (!$next_ref->{assemblyitem} && ($same_item ne $next_ref->{ $form->{sort} })))) {
1385 my $row = { map { $_ => { 'class' => 'listsubtotal', } } @columns };
1387 if (($form->{searchitems} ne 'assembly') || !$form->{bom}) {
1388 $row->{soldtotal}->{data} = $form->format_amount(\%myconfig, $subtotals{soldtotal});
1391 map { $row->{"linetotal$_"}->{data} = $form->format_amount(\%myconfig, $subtotals{$_}, 2) } @subtotal_columns;
1392 map { $subtotals{$_} = 0 } ('soldtotal', @subtotal_columns);
1394 $report->add_data($row);
1396 $same_item = $next_ref->{ $form->{sort} };
1402 if ($form->{"l_linetotal"} && !$form->{report_generator_csv_options_for_import}) {
1403 my $row = { map { $_ => { 'class' => 'listtotal', } } @columns };
1405 map { $row->{"linetotal$_"}->{data} = $form->format_amount(\%myconfig, $totals{$_}, 2) } @subtotal_columns;
1407 $report->add_separator();
1408 $report->add_data($row);
1411 $report->generate_with_headers();
1413 $lxdebug->leave_sub();
1414 } #end generate_report
1416 sub parts_subtotal {
1417 $lxdebug->enter_sub();
1419 $auth->assert('part_service_assembly_edit');
1422 my ($column_index, $subtotalonhand, $subtotalsellprice, $subtotallastcost, $subtotallistprice) = @_;
1424 map { $column_data{$_} = "<td> </td>" } @{ $column_index };
1425 $$subtotalonhand = 0 if ($form->{searchitems} eq 'assembly' && $form->{bom});
1427 $column_data{onhand} =
1428 "<th class=listsubtotal align=right>"
1429 . $form->format_amount(\%myconfig, $$subtotalonhand)
1432 $column_data{linetotalsellprice} =
1433 "<th class=listsubtotal align=right>"
1434 . $form->format_amount(\%myconfig, $$subtotalsellprice, 2)
1436 $column_data{linetotallistprice} =
1437 "<th class=listsubtotal align=right>"
1438 . $form->format_amount(\%myconfig, $$subtotallistprice, 2)
1440 $column_data{linetotallastcost} =
1441 "<th class=listsubtotal align=right>"
1442 . $form->format_amount(\%myconfig, $$subtotallastcost, 2)
1445 $$subtotalonhand = 0;
1446 $$subtotalsellprice = 0;
1447 $$subtotallistprice = 0;
1448 $$subtotallastcost = 0;
1450 print "<tr class=listsubtotal>";
1452 map { print "\n$column_data{$_}" } @{ $column_index };
1458 $lxdebug->leave_sub();
1462 $lxdebug->enter_sub();
1464 $auth->assert('part_service_assembly_edit');
1466 # show history button
1467 $form->{javascript} = qq|<script type="text/javascript" src="js/show_history.js"></script>|;
1468 #/show hhistory button
1469 IC->get_part(\%myconfig, \%$form);
1471 $form->{"original_partnumber"} = $form->{"partnumber"};
1473 my $title = 'Edit ' . ucfirst $form->{item};
1474 $form->{title} = $locale->text($title);
1479 $lxdebug->leave_sub();
1483 $lxdebug->enter_sub();
1485 $auth->assert('part_service_assembly_edit');
1487 IC->create_links("IC", \%myconfig, \%$form);
1490 map({ $form->{selectcurrency} .= "<option>$_\n" }
1491 split(/:/, $form->{currencies}));
1493 # parts and assemblies have the same links
1494 my $item = $form->{item};
1495 if ($form->{item} eq 'assembly') {
1499 # build the popup menus
1500 $form->{taxaccounts} = "";
1501 foreach my $key (keys %{ $form->{IC_links} }) {
1502 foreach my $ref (@{ $form->{IC_links}{$key} }) {
1504 # if this is a tax field
1505 if ($key =~ /IC_tax/) {
1506 if ($key =~ /\Q$item\E/) {
1507 $form->{taxaccounts} .= "$ref->{accno} ";
1508 $form->{"IC_tax_$ref->{accno}_description"} =
1509 "$ref->{accno}--$ref->{description}";
1512 if ($form->{amount}{ $ref->{accno} }) {
1513 $form->{"IC_tax_$ref->{accno}"} = "checked";
1516 $form->{"IC_tax_$ref->{accno}"} = "checked";
1521 $form->{"select$key"} .=
1522 "<option $ref->{selected}>$ref->{accno}--$ref->{description}\n";
1523 if ($form->{amount}{$key} eq $ref->{accno}) {
1524 $form->{$key} = "$ref->{accno}--$ref->{description}";
1530 chop $form->{taxaccounts};
1532 if (($form->{item} eq "part") || ($form->{item} eq "assembly")) {
1533 $form->{selectIC_income} = $form->{selectIC_sale};
1534 $form->{selectIC_expense} = $form->{selectIC_cogs};
1535 $form->{IC_income} = $form->{IC_sale};
1536 $form->{IC_expense} = $form->{IC_cogs};
1539 delete $form->{IC_links};
1540 delete $form->{amount};
1542 $form->get_partsgroup(\%myconfig, { all => 1 });
1544 $form->{partsgroup} = "$form->{partsgroup}--$form->{partsgroup_id}";
1546 if (@{ $form->{all_partsgroup} }) {
1547 $form->{selectpartsgroup} = qq|<option>\n|;
1548 map { $form->{selectpartsgroup} .= qq|<option value="$_->{partsgroup}--$_->{id}">$_->{partsgroup}\n| } @{ $form->{all_partsgroup} };
1551 if ($form->{item} eq 'assembly') {
1553 foreach my $i (1 .. $form->{assembly_rows}) {
1554 if ($form->{"partsgroup_id_$i"}) {
1555 $form->{"partsgroup_$i"} =
1556 qq|$form->{"partsgroup_$i"}--$form->{"partsgroup_id_$i"}|;
1559 $form->get_partsgroup(\%myconfig);
1561 if (@{ $form->{all_partsgroup} }) {
1562 $form->{selectassemblypartsgroup} = qq|<option>\n|;
1565 $form->{selectassemblypartsgroup} .=
1566 qq|<option value="$_->{partsgroup}--$_->{id}">$_->{partsgroup}\n|
1567 } @{ $form->{all_partsgroup} };
1570 $lxdebug->leave_sub();
1574 $lxdebug->enter_sub();
1576 $auth->assert('part_service_assembly_edit');
1578 $form->{pg_keys} = sub { "$_[0]->{partsgroup}--$_[0]->{id}" };
1579 $form->{description_area} = ($form->{rows} = $form->numtextrows($form->{description}, 40)) > 1;
1580 $form->{notes_rows} = max 4, $form->numtextrows($form->{notes}, 40), $form->numtextrows($form->{formel}, 40);
1582 map { $form->{"is_$_"} = ($form->{item} eq $_) } qw(part service assembly);
1583 map { $form->{$_} =~ s/"/"/g; } qw(unit);
1585 $form->get_lists('price_factors' => 'ALL_PRICE_FACTORS',
1586 'partsgroup' => 'all_partsgroup',
1587 'vendors' => 'ALL_VENDORS',);
1590 IC->retrieve_buchungsgruppen(\%myconfig, $form);
1591 @{ $form->{BUCHUNGSGRUPPEN} } = grep { $_->{id} eq $form->{buchungsgruppen_id} || ($form->{id} && $form->{orphaned}) || !$form->{id} } @{ $form->{BUCHUNGSGRUPPEN} };
1593 # use JavaScript Calendar or not (yes!)
1594 $form->{jsscript} = 1;
1596 my $units = AM->retrieve_units(\%myconfig, $form);
1597 $form->{ALL_UNITS} = [ map +{ name => $_ }, sort { $units->{$a}{sortkey} <=> $units->{$b}{sortkey} } keys %$units ];
1599 $form->{defaults} = AM->get_defaults();
1601 $form->{fokus} = "ic.partnumber";
1603 $form->{CUSTOM_VARIABLES} = CVar->get_custom_variables('module' => 'IC', 'trans_id' => $form->{id});
1605 CVar->render_inputs('variables' => $form->{CUSTOM_VARIABLES}, show_disabled_message => 1)
1606 if (scalar @{ $form->{CUSTOM_VARIABLES} });
1609 #print $form->parse_html_template('ic/form_header', { ALL_PRICE_FACTORS => $form->{ALL_PRICE_FACTORS},
1610 # ALL_UNITS => $form->{ALL_UNITS},
1611 # BUCHUNGSGRUPPEN => $form->{BUCHUNGSGRUPPEN},
1612 # payment_terms => $form->{payment_terms},
1613 # all_partsgroup => $form->{all_partsgroup}});
1614 print $form->parse_html_template('ic/form_header');
1615 $lxdebug->leave_sub();
1619 $lxdebug->enter_sub();
1621 $auth->assert('part_service_assembly_edit');
1623 print $form->parse_html_template('ic/form_footer');
1625 $lxdebug->leave_sub();
1629 $lxdebug->enter_sub();
1632 my @mm_data = grep { any { $_ ne '' } @$_{qw(make model)} } map +{ make => $form->{"make_$_"}, model => $form->{"model_$_"}, lastcost => $form->{"lastcost_$_"}, lastupdate => $form->{"lastupdate_$_"}, sortorder => $form->{"sortorder_$_"} }, 1 .. $numrows;
1633 delete @{$form}{grep { m/^make_\d+/ || m/^model_\d+/ } keys %{ $form }};
1634 print $form->parse_html_template('ic/makemodel', { MM_DATA => [ @mm_data, {} ], mm_rows => scalar @mm_data + 1 });
1636 $lxdebug->leave_sub();
1640 $lxdebug->enter_sub();
1643 my ($nochange, $callback, $previousform, $linetotal, $line_purchase_price, $href);
1645 @column_index = qw(runningnumber qty unit bom partnumber description partsgroup lastcost total);
1647 if ($form->{previousform}) {
1649 @column_index = qw(qty unit bom partnumber description partsgroup total);
1653 $form->{old_callback} = $form->{callback};
1654 $callback = $form->{callback};
1655 $form->{callback} = "$form->{script}?action=display_form";
1658 map { delete $form->{$_} } qw(action header);
1660 # save form variables in a previousform variable
1661 my %form_to_save = map { ($_ => m/^ (?: listprice | sellprice | lastcost ) $/x ? $form->format_amount(\%myconfig, $form->{$_}) : $form->{$_}) }
1663 $previousform = $::auth->save_form_in_session(form => \%form_to_save);
1665 $form->{callback} = $callback;
1666 $form->{assemblytotal} = 0;
1667 $form->{assembly_purchase_price_total} = 0;
1668 $form->{weight} = 0;
1672 runningnumber => { text => $locale->text('No.'), nowrap => 1, width => '5%' },
1673 qty => { text => $locale->text('Qty'), nowrap => 1, width => '10%' },
1674 unit => { text => $locale->text('Unit'), nowrap => 1, width => '5%' },
1675 partnumber => { text => $locale->text('Part Number'), nowrap => 1, width => '20%' },
1676 description => { text => $locale->text('Part Description'), nowrap => 1, width => '50%' },
1677 lastcost => { text => $locale->text('Purchase Prices'), nowrap => 1, width => '50%' },
1678 total => { text => $locale->text('Sale Prices'), nowrap => 1, },
1679 bom => { text => $locale->text('BOM'), },
1680 partsgroup => { text => $locale->text('Group'), },
1685 for my $i (1 .. $numrows) {
1686 my (%row, @row_hiddens);
1688 $form->{"partnumber_$i"} =~ s/\"/"/g;
1690 $linetotal = $form->round_amount($form->{"sellprice_$i"} * $form->{"qty_$i"} / ($form->{"price_factor_$i"} || 1), 4);
1691 $line_purchase_price = $form->round_amount($form->{"lastcost_$i"} * $form->{"qty_$i"} / ($form->{"price_factor_$i"} || 1), 4);
1692 $form->{assemblytotal} += $linetotal;
1693 $form->{assembly_purchase_price_total} += $line_purchase_price;
1694 $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"});
1695 $linetotal = $form->format_amount(\%myconfig, $linetotal, 2);
1696 $line_purchase_price = $form->format_amount(\%myconfig, $line_purchase_price, 2);
1697 $href = qq|$form->{script}?action=edit&id=$form->{"id_$i"}&rowcount=$i&previousform=$previousform|;
1698 map { $row{$_}{data} = "" } qw(qty unit partnumber description bom partsgroup runningnumber);
1701 if (($i >= 1) && ($i == $numrows)) {
1702 if (!$form->{previousform}) {
1703 $row{partnumber}{data} = qq|<input name="partnumber_$i" size=15 value="$form->{"partnumber_$i"}">|;
1704 $row{qty}{data} = qq|<input name="qty_$i" size=5 value="$form->{"qty_$i"}">|;
1705 $row{description}{data} = qq|<input name="description_$i" size=40 value="$form->{"description_$i"}">|;
1706 $row{partsgroup}{data} = qq|<input name="partsgroup_$i" size=10 value="$form->{"partsgroup_$i"}">|;
1710 if ($form->{previousform}) {
1711 push @row_hiddens, qw(qty bom);
1712 $row{partnumber}{data} = $form->{"partnumber_$i"};
1713 $row{qty}{data} = $form->{"qty_$i"};
1714 $row{bom}{data} = $form->{"bom_$i"} ? "x" : " ";
1715 $row{qty}{align} = 'right';
1717 $row{partnumber}{data} = qq|<a href=$href>$form->{"partnumber_$i"}</a>|;
1718 $row{qty}{data} = qq|<input name="qty_$i" size=5 value="$form->{"qty_$i"}">|;
1719 $row{runningnumber}{data} = qq|<input name="runningnumber_$i" size=3 value="$i">|;
1720 $row{bom}{data} = sprintf qq|<input name="bom_$i" type=checkbox class=checkbox value=1 %s>|,
1721 $form->{"bom_$i"} ? 'checked' : '';
1723 push @row_hiddens, qw(unit description partnumber partsgroup);
1724 $row{unit}{data} = $form->{"unit_$i"};
1725 #Bei der Artikelbeschreibung und Warengruppe können Sonderzeichen verwendet
1726 #werden, die den HTML Code stören. Daher sollen diese im Template escaped werden
1727 #dies geschieht, wenn die Variable escape gesetzt ist
1728 $row{description}{data} = $form->{"description_$i"};
1729 $row{description}{escape} = 1;
1730 $row{partsgroup}{data} = $form->{"partsgroup_$i"};
1731 $row{partsgroup}{escape} = 1;
1732 $row{bom}{align} = 'center';
1735 $row{lastcost}{data} = $line_purchase_price;
1736 $row{total}{data} = $linetotal;
1737 $row{lastcost}{align} = 'right';
1738 $row{total}{align} = 'right';
1739 $row{deliverydate}{align} = 'right';
1741 push @row_hiddens, qw(id sellprice lastcost weight price_factor_id price_factor);
1742 $row{hiddens} = [ map +{ name => "${_}_$i", value => $form->{"${_}_$i"} }, @row_hiddens ];
1747 print $form->parse_html_template('ic/assembly_row', { COLUMNS => \@column_index, ROWS => \@ROWS, HEADER => \%header });
1749 $lxdebug->leave_sub();
1753 $lxdebug->enter_sub();
1755 # parse pricegroups. and no, don't rely on check_form for this...
1756 map { $form->{"price_$_"} = $form->parse_amount(\%myconfig, $form->{"price_$_"}) } 1 .. $form->{price_rows};
1758 # same for makemodel lastcosts
1759 # but parse_amount not necessary for assembly component lastcosts
1760 unless ($form->{item} eq "assembly") {
1761 map { $form->{"lastcost_$_"} = $form->parse_amount(\%myconfig, $form->{"lastcost_$_"}) } 1 .. $form->{"makemodel_rows"};
1764 if ($form->{item} eq "assembly") {
1765 my $i = $form->{assembly_rows};
1767 # if last row is empty check the form otherwise retrieve item
1768 if ( ($form->{"partnumber_$i"} eq "")
1769 && ($form->{"description_$i"} eq "")
1770 && ($form->{"partsgroup_$i"} eq "")) {
1776 IC->assembly_item(\%myconfig, \%$form);
1778 my $rows = scalar @{ $form->{item_list} };
1781 $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"});
1784 $form->{makemodel_rows}--;
1785 select_item(mode => 'IC');
1788 map { $form->{item_list}[$i]{$_} =~ s/\"/"/g }
1789 qw(partnumber description unit partsgroup);
1790 map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} }
1791 keys %{ $form->{item_list}[0] };
1792 $form->{"runningnumber_$i"} = $form->{assembly_rows};
1793 $form->{assembly_rows}++;
1801 $form->{rowcount} = $i;
1802 $form->{assembly_rows}++;
1809 } elsif (($form->{item} eq 'part') || ($form->{item} eq 'service')) {
1813 $lxdebug->leave_sub();
1817 $lxdebug->enter_sub();
1819 $auth->assert('part_service_assembly_edit');
1821 my ($parts_id, %newform, $amount, $callback);
1823 # check if there is a part number - commented out, cause there is an automatic allocation of numbers
1824 # $form->isblank("partnumber", $locale->text(ucfirst $form->{item}." Part Number missing!"));
1826 # check if there is a description
1827 $form->isblank("description", $locale->text("Part Description missing!"));
1829 $form->error($locale->text("Inventory quantity must be zero before you can set this $form->{item} obsolete!"))
1830 if $form->{obsolete} && $form->{onhand} * 1 && $form->{item} ne 'service';
1832 if (!$form->{buchungsgruppen_id}) {
1833 $form->error($locale->text("Parts must have an entry type.") . " " .
1834 $locale->text("If you see this message, you most likely just setup your LX-Office and haven't added any entry types. If this is the case, the option is accessible for administrators in the System menu.")
1838 $form->error($locale->text('Description must not be empty!')) unless $form->{description};
1839 $form->error($locale->text('Partnumber must not be set to empty!')) if $form->{id} && !$form->{partnumber};
1842 if (IC->save(\%myconfig, \%$form) == 3) {
1843 $form->error($locale->text('Partnumber not unique!'));
1845 # saving the history
1846 if(!exists $form->{addition}) {
1847 $form->{snumbers} = qq|partnumber_| . $form->{partnumber};
1848 $form->{addition} = "SAVED";
1849 $form->save_history;
1851 # /saving the history
1852 $parts_id = $form->{id};
1855 # load previous variables
1856 if ($form->{previousform}) {
1858 # save the new form variables before splitting previousform
1859 map { $newform{$_} = $form->{$_} } keys %$form;
1861 # don't trample on previous variables
1862 map { delete $form->{$_} } keys %newform;
1864 my $ic_cvar_configs = CVar->get_configs(module => 'IC');
1865 my @ic_cvar_fields = map { "cvar_$_->{name}" } @{ $ic_cvar_configs };
1867 # restore original values
1868 $::auth->restore_form_from_session($newform{previousform}, form => $form);
1869 $form->{taxaccounts} = $newform{taxaccount2};
1871 if ($form->{item} eq 'assembly') {
1873 # undo number formatting
1874 map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) }
1875 qw(weight listprice sellprice rop);
1877 $form->{assembly_rows}--;
1878 $i = $form->{assembly_rows};
1879 $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"});
1881 $form->{sellprice} -= $form->{"sellprice_$i"} * $form->{"qty_$i"};
1882 $form->{weight} -= $form->{"weight_$i"} * $form->{"qty_$i"};
1884 # change/add values for assembly item
1885 map { $form->{"${_}_$i"} = $newform{$_} } qw(partnumber description bin unit weight listprice sellprice inventory_accno income_accno expense_accno price_factor_id);
1886 map { $form->{"ic_${_}_$i"} = $newform{$_} } @ic_cvar_fields;
1888 # das ist __voll__ bekloppt, dass so auszurechnen jb 22.5.09
1889 #$form->{sellprice} += $form->{"sellprice_$i"} * $form->{"qty_$i"};
1890 $form->{weight} += $form->{"weight_$i"} * $form->{"qty_$i"};
1894 # set values for last invoice/order item
1895 $i = $form->{rowcount};
1896 $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"});
1898 map { $form->{"${_}_$i"} = $newform{$_} } qw(partnumber description bin unit listprice inventory_accno income_accno expense_accno sellprice lastcost price_factor_id);
1899 map { $form->{"ic_${_}_$i"} = $newform{$_} } @ic_cvar_fields;
1901 $form->{"longdescription_$i"} = $newform{notes};
1903 $form->{"sellprice_$i"} = $newform{lastcost} if ($form->{vendor_id});
1905 if ($form->{exchangerate} != 0) {
1906 $form->{"sellprice_$i"} /= $form->{exchangerate};
1909 map { $form->{"taxaccounts_$i"} .= "$_ " } split / /, $newform{taxaccount};
1910 chop $form->{"taxaccounts_$i"};
1911 foreach my $item (qw(description rate taxnumber)) {
1912 my $index = $form->{"taxaccounts_$i"} . "_$item";
1913 $form->{$index} = $newform{$index};
1916 # credit remaining calculation
1917 $amount = $form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) * $form->{"qty_$i"};
1919 map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"});
1920 map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{"taxaccounts_$i"} if !$form->{taxincluded};
1922 $form->{creditremaining} -= $amount;
1924 # redo number formatting, because invoice parse them!
1925 map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}) } qw(weight listprice sellprice lastcost rop);
1928 $form->{"id_$i"} = $parts_id;
1930 # Get the actual price factor (not just the ID) for the marge calculation.
1931 $form->get_lists('price_factors' => 'ALL_PRICE_FACTORS');
1932 foreach my $pfac (@{ $form->{ALL_PRICE_FACTORS} }) {
1933 next if ($pfac->{id} != $newform{price_factor_id});
1934 $form->{"marge_price_factor_$i"} = $pfac->{factor};
1937 delete $form->{ALL_PRICE_FACTORS};
1939 delete $form->{action};
1941 # restore original callback
1942 $callback = $form->unescape($form->{callback});
1943 $form->{callback} = $form->unescape($form->{old_callback});
1944 delete $form->{old_callback};
1946 $form->{makemodel_rows}--;
1948 # put callback together
1949 foreach my $key (keys %$form) {
1951 # do single escape for Apache 2.0
1952 my $value = $form->escape($form->{$key}, 1);
1953 $callback .= qq|&$key=$value|;
1955 $form->{callback} = $callback;
1961 $lxdebug->leave_sub();
1965 $lxdebug->enter_sub();
1967 $auth->assert('part_service_assembly_edit');
1969 # saving the history
1970 if(!exists $form->{addition}) {
1971 $form->{snumbers} = qq|partnumber_| . $form->{partnumber};
1972 $form->{addition} = "SAVED AS NEW";
1973 $form->save_history;
1975 # /saving the history
1977 if ($form->{"original_partnumber"} &&
1978 ($form->{"partnumber"} eq $form->{"original_partnumber"})) {
1979 $form->{partnumber} = "";
1982 $lxdebug->leave_sub();
1986 $lxdebug->enter_sub();
1988 $auth->assert('part_service_assembly_edit');
1990 # saving the history
1991 if(!exists $form->{addition}) {
1992 $form->{snumbers} = qq|partnumber_| . $form->{partnumber};
1993 $form->{addition} = "DELETED";
1994 $form->save_history;
1996 # /saving the history
1997 my $rc = IC->delete(\%myconfig, \%$form);
2000 $form->redirect($locale->text('Item deleted!')) if ($rc > 0);
2001 $form->error($locale->text('Cannot delete item!'));
2003 $lxdebug->leave_sub();
2007 $lxdebug->enter_sub();
2009 $auth->assert('part_service_assembly_edit');
2014 pricegroup => $form->{"pricegroup_$_"},
2015 pricegroup_id => $form->{"pricegroup_id_$_"},
2016 price => $form->{"price_$_"},
2019 print $form->parse_html_template('ic/price_row', { PRICES => \@PRICES });
2021 $lxdebug->leave_sub();
2024 sub parts_language_selection {
2025 $lxdebug->enter_sub();
2027 $auth->assert('part_service_assembly_edit');
2029 my $languages = IC->retrieve_languages(\%myconfig, $form);
2031 if ($form->{language_values} ne "") {
2032 foreach my $item (split(/---\+\+\+---/, $form->{language_values})) {
2033 my ($language_id, $translation, $longdescription) = split(/--\+\+--/, $item);
2035 foreach my $language (@{ $languages }) {
2036 next unless ($language->{id} == $language_id);
2038 $language->{translation} = $translation;
2039 $language->{longdescription} = $longdescription;
2041 $language->{translation_area} = ($language->{translation_rows} = $form->numtextrows($language->{translation}, 40)) > 1;
2042 $language->{longdescription_rows} = max 4, $form->numtextrows($language->{longdescription}, 40);
2049 my @header_sort = qw(name longdescription);
2050 my %header_title = ( "name" => $locale->text("Name"),
2051 "longdescription" => $locale->text("Long Description"),
2055 map(+{ "column_title" => $header_title{$_},
2060 $form->{"title"} = $locale->text("Language Values");
2062 print $form->parse_html_template("ic/parts_language_selection", { "HEADER" => \@header,
2063 "LANGUAGES" => $languages, });
2065 $lxdebug->leave_sub();
2068 sub ajax_autocomplete {
2069 $main::lxdebug->enter_sub();
2071 my $form = $main::form;
2072 my %myconfig = %main::myconfig;
2074 $form->{column} = 'description' unless $form->{column} =~ /^partnumber|description$/;
2075 $form->{$form->{column}} = $form->{q} || '';
2076 $form->{limit} = ($form->{limit} * 1) || 10;
2077 $form->{searchitems} ||= '';
2079 my @results = IC->all_parts(\%myconfig, $form);
2081 print $form->ajax_response_header(),
2082 $form->parse_html_template('ic/ajax_autocomplete');
2084 $main::lxdebug->leave_sub();
2087 sub back_to_record {
2091 delete @{$::form}{qw(action action_add action_back_to_record back_sub description item notes partnumber sellprice taxaccount2 unit vc)};
2093 $::auth->restore_form_from_session($::form->{previousform}, clobber => 1);
2094 $::form->{rowcount}--;
2095 $::form->{action} = 'display_form';
2096 $::form->{callback} = $::form->{script} . '?' . join('&', map { $::form->escape($_) . '=' . $::form->escape($::form->{$_}) } sort keys %{ $::form });
2100 sub continue { call_sub($form->{"nextsub"}); }
2103 my $action = first { $::form->{"action_${_}"} } qw(add back_to_record);
2104 $::form->error($::locale->text('No action defined.')) unless $action;
2106 $::form->{dispatched_action} = $action;