X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fic.pl;h=3383316ace35b6504d51637818a490ab4a4d27fa;hb=893bff3a5c0106b467578b470deac53f87173689;hp=fc0da269e7d0244cf5f3961d3f312a7cd4363d7e;hpb=b6dc5623d93c1be1c54248d4512e80f495af2899;p=kivitendo-erp.git diff --git a/bin/mozilla/ic.pl b/bin/mozilla/ic.pl index fc0da269e..3383316ac 100644 --- a/bin/mozilla/ic.pl +++ b/bin/mozilla/ic.pl @@ -30,9 +30,9 @@ # Inventory Control module # #====================================================================== -#$locale->text('ea'); use POSIX qw(strftime); +use List::Util qw(max); use SL::IC; use SL::ReportGenerator; @@ -52,18 +52,32 @@ require "bin/mozilla/reportgenerator.pl"; 1; +# Parserhappy(R): +# type=submit $locale->text('Add Part') +# type=submit $locale->text('Add Service') +# type=submit $locale->text('Add Assembly') +# type=submit $locale->text('Edit Part') +# type=submit $locale->text('Edit Service') +# type=submit $locale->text('Edit Assembly') +# $locale->text('Parts') +# $locale->text('Services') +# $locale->text('Inventory quantity must be zero before you can set this part obsolete!') +# $locale->text('Inventory quantity must be zero before you can set this assembly obsolete!') +# $locale->text('Part Number missing!') +# $locale->text('Service Number missing!') +# $locale->text('Assembly Number missing!') +# $locale->text('ea'); + # end of main sub add { $lxdebug->enter_sub(); - $form->{title} = $locale->text('Add ' . ucfirst $form->{item}); - - $form->{callback} = - "$form->{script}?action=add&item=$form->{item}&login=$form->{login}&password=$form->{password}" - unless $form->{callback}; + $auth->assert('part_service_assembly_edit'); - $form->{"unit_changeable"} = 1; + $form->{title} = $locale->text('Add ' . ucfirst $form->{item}); + $form->{callback} = "$form->{script}?action=add&item=$form->{item}" unless $form->{callback}; + $form->{unit_changeable} = 1; IC->get_pricegroups(\%myconfig, \%$form); &link_part; @@ -75,540 +89,53 @@ sub add { sub search { $lxdebug->enter_sub(); - my ($button1, $button2, $onhand, $makemodel, $serialnumber, $l_serialnumber, $toplevel, $bought); - - $form->{title} = (ucfirst $form->{searchitems}) . "s"; - $form->{title} = $locale->text($form->{title}); - - # switch for backward sorting - $form->{revers} = 0; + $auth->assert('part_service_assembly_edit'); - # memory for which table was sort at last time - $form->{lastsort} = ""; + $form->{revers} = 0; # switch for backward sorting + $form->{lastsort} = ""; # memory for which table was sort at last time + $form->{ndxs_counter} = 0; # counter for added entries to top100 - # counter for added entries to top100 - $form->{ndxs_counter} = 0; + my %is_xyz = map { +"is_$_" => ($form->{searchitems} eq $_) } qw(part service assembly); - # $locale->text('Parts') - # $locale->text('Services') + $form->{title} = (ucfirst $form->{searchitems}) . "s"; + $form->{title} = $locale->text($form->{title}); + $form->{title} = $locale->text('Assemblies') if ($is_xyz{assembly}); - # use JavaScript Calendar or not $form->{jsscript} = 1; - my $jsscript = ""; - if ($form->{jsscript}) { - - # with JavaScript Calendar - $button1 = qq| - - text('button') . qq|> - |; - $button2 = qq| - - text('button') . qq|> - |; - - #write Trigger - $jsscript = Form->write_trigger(\%myconfig, "2", "transdatefrom", "BL", "trigger1", "transdateto", "BL", "trigger2"); - } else { - - # without JavaScript Calendar - $button1 = qq| |; - $button2 = qq| |; - } - - unless ($form->{searchitems} eq 'service') { - - $onhand = qq|  | . $locale->text('On Hand') . qq| -  | . $locale->text('Short') . qq| -|; - - $makemodel = qq| - - | . $locale->text('Make') . qq| - | . $locale->text('Model') . qq| - -|; - - $serialnumber = qq| - | . $locale->text('Serial Number') . qq| -|; - - $l_serialnumber = qq| -  | . $locale->text('Serial Number') . qq| -|; - - } - - if ($form->{searchitems} eq 'assembly') { - - $form->{title} = $locale->text('Assemblies'); - - $toplevel = qq| - - - -  | - . $locale->text('Top Level') . qq| -  | - . $locale->text('Individual Items') . qq| - - -|; - - $bought = qq| - - - - - - - - - $button1 - - $button2 - -
- - - - - - - - - - - - - - - - - - - -
| . $locale->text('Sold') . qq|

| . $locale->text('Ordered') . qq|

| . $locale->text('Quoted') . qq|
-
 | . $locale->text('From') . qq|| . $locale->text('To (time)') . qq|
- - -|; - - } else { - - $bought = qq| - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -
| . $locale->text('Bought') . qq|| . $locale->text('Sold') . qq|

| . $locale->text('On Order') . qq|| . $locale->text('Ordered') . qq|

| . $locale->text('RFQ') . qq|| . $locale->text('Quoted') . qq|
-
  - - - - $button1 - - $button2 - -
| . $locale->text('From') . qq|| . $locale->text('To (time)') . qq|
-
- - -|; - } $form->header; - print qq| - - -
{script}> - -{searchitems}> - - - - - - - - - - - - -
$form->{title}
- - - - - - - - - - - - - - - $serialnumber - - $makemodel - - - - - - - $toplevel - - - - - $bought - - - - - - - - -
| . $locale->text('Part Number') . qq|| . $locale->text('EAN') . qq|
| - . $locale->text('Part Description') . qq|
| . $locale->text('Group') . qq|
| . $locale->text('Drawing') . qq|| . $locale->text('Microfiche') . qq|
-  | - . $locale->text('Active') . qq| - $onhand -  | - . $locale->text('Obsolete') . qq| -  | - . $locale->text('Orphaned') . qq| -
-
-
| - . $locale->text('Include in Report') . qq| - - - - - $l_serialnumber - - - - - - - - - - - - - - - - - - - - - - - - - -
 | - . $locale->text('Part Number') . qq| | - . $locale->text('Part Description') . qq| | - . $locale->text('Unit of measure') . qq|
 | - . $locale->text('List Price') . qq| | - . $locale->text('Sell Price') . qq| | - . $locale->text('Last Cost') . qq| | - . $locale->text('Line Total') . qq|
 | - . $locale->text('Updated') . qq| | - . $locale->text('Bin') . qq| | - . $locale->text('ROP') . qq| | - . $locale->text('Weight') . qq|
 | - . $locale->text('Image') . qq| | - . $locale->text('Drawing') . qq| | - . $locale->text('Microfiche') . qq| | - . $locale->text('Group') . qq|
 | - . $locale->text('Subtotal') . qq| | - . $locale->text('soldtotal') . qq| | - . $locale->text('deliverydate') . qq|
-
-

- -$jsscript - - + print $form->parse_html_template('ic/search', { %is_xyz, + dateformat => $myconfig{dateformat}, }); -{login}> -{password}> - - - - - - - -
- - -
- - - -|; $lxdebug->leave_sub(); } #end search() sub search_update_prices { $lxdebug->enter_sub(); - my ($onhand, $makemodel, $serialnumber, $l_serialnumber, $toplevel, $bought); - - $form->{title} = $locale->text('Update prices'); - IC->get_pricegroups(\%myconfig, \%$form); - - # use JavaScript Calendar or not -# $form->{jsscript} = 1; -# $jsscript = ""; -# if ($form->{jsscript}) { -# -# # with JavaScript Calendar -# $button1 = qq| -# -# text('button') . qq|> -# |; -# $button2 = qq| -# -# text('button') . qq|> -# |; -# -# #write Trigger -# $jsscript = -# Form->write_trigger(\%myconfig, "2", "transdatefrom", "BL", "trigger1", -# "transdateto", "BL", "trigger2"); -# } else { -# -# # without JavaScript Calendar -# $button1 = qq| -# |; -# $button2 = qq| -# |; -# } - - $onhand = qq| -  | - . $locale->text('On Hand') . qq| -  | - . $locale->text('Short') . qq| -|; - - $makemodel = qq| - - | . $locale->text('Make') . qq| - - | . $locale->text('Model') . qq| - - -|; - - $serialnumber = qq| - | . $locale->text('Serial Number') . qq| - -|; - - $l_serialnumber = qq| -  | - . $locale->text('Serial Number') . qq| -|; - + $auth->assert('part_service_assembly_edit'); + my $pricegroups = IC->get_pricegroups(\%myconfig, \%$form); $form->header; - print qq| - - -
{script}> - - - - - - - - " + ? "" : ""; $column_data{ordnumber} = ($ref->{module} eq 'oe') - ? "" + ? "" : ""; $column_data{quonumber} = ($ref->{module} eq 'oe' && !$ref->{ordnumber}) - ? "" + ? "" : ""; $column_data{name} = ""; @@ -1436,9 +912,6 @@ sub addtop100 { {script}> -{login}> -{password}> - @@ -1459,7 +932,7 @@ sub addtop100 { print $totop100; print qq| - + @@ -1497,14 +970,17 @@ sub addtop100 { # l_partsgroup l_subtotal l_soldtotal l_deliverydate # # hiddens: -# nextsub login password revers lastsort sort ndxs_counter +# nextsub revers lastsort sort ndxs_counter # sub generate_report { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + my ($revers, $lastsort, $description); $form->{title} = (ucfirst $form->{searchitems}) . "s"; + $form->{title} =~ s/ys$/ies/; $form->{title} = $locale->text($form->{title}); my $revers = $form->{revers}; @@ -1597,8 +1073,6 @@ sub generate_report { push @options, $optiontexts{$key}; } - IC->all_parts(\%myconfig, \%$form); - # special case for lastcost $form->{l_lastcost} = "" if $form->{ledgerchecks}; @@ -1642,6 +1116,8 @@ sub generate_report { $form->{l_lastcost} = "" if ($form->{searchitems} eq 'assembly' && !$form->{bom}); + IC->all_parts(\%myconfig, \%$form); + my @columns = qw(partnumber description partsgroup bin onhand rop unit listprice linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost priceupdate weight image drawing microfiche invnumber ordnumber quonumber name serialnumber soldtotal deliverydate); @@ -1700,7 +1176,7 @@ sub generate_report { ); $report->set_options('top_info_text' => $locale->text('Options') . ': ' . join(', ', grep $_, @options), - 'raw_bottom_info_text' => $form->parse_html_template2('ic/generate_report_bottom'), + 'raw_bottom_info_text' => $form->parse_html_template('ic/generate_report_bottom'), 'output_format' => 'HTML', 'title' => $form->{title}, 'attachment_basename' => $attachment_basenames{$form->{searchitems}} . strftime('_%Y%m%d', localtime time), @@ -1820,6 +1296,8 @@ sub generate_report { sub parts_subtotal { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + # imports our (%column_data, @column_index); our ($subtotalonhand, $totalsellprice, $totallastcost, $totallistprice, $subtotalsellprice, $subtotallastcost, $subtotallistprice); @@ -1863,6 +1341,9 @@ sub parts_subtotal { sub edit { $lxdebug->enter_sub(); + + $auth->assert('part_service_assembly_edit'); + # show history button $form->{javascript} = qq||; #/show hhistory button @@ -1881,6 +1362,8 @@ sub edit { sub link_part { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + IC->create_links("IC", \%myconfig, \%$form); # currencies @@ -1942,10 +1425,7 @@ sub link_part { if (@{ $form->{all_partsgroup} }) { $form->{selectpartsgroup} = qq||; - foreach my $item (@{ $form->{payment_terms} }) { - if ($form->{payment_id} eq $item->{id}) { - $payment .= qq||; - } else { - $payment .= qq||; - } - } - - - if (($rows = $form->numtextrows($form->{notes}, 40)) < 2) { - $rows = 4; - } - - $notes = - qq||; - if (($rows = $form->numtextrows($form->{description}, 40)) > 1) { - $description = - qq||; - } else { - $description = - qq||; - } + $auth->assert('part_service_assembly_edit'); - $ean = qq||; + $form->{eur} = $eur; # config dumps into namespace - yuck + $form->{pg_keys} = sub { "$_[0]->{partsgroup}--$_[0]->{id}" }; + $form->{description_area} = ($form->{rows} = $form->numtextrows($form->{description}, 40)) > 1; + $form->{notes_rows} = max 4, $form->numtextrows($form->{notes}, 40), $form->numtextrows($form->{formel}, 40); - foreach my $item (split / /, $form->{taxaccounts}) { - $form->{"IC_tax_$item"} = ($form->{"IC_tax_$item"}) ? "checked" : ""; - } + map { $form->{"is_$_"} = ($form->{item} eq $_) } qw(part service assembly); + map { $form->{$_} =~ s/"/"/g; } qw(unit); + + $form->get_lists('price_factors' => 'ALL_PRICE_FACTORS', + 'partsgroup' => 'all_partsgroup'); IC->retrieve_buchungsgruppen(\%myconfig, $form); - if (@{ $form->{BUCHUNGSGRUPPEN} }) { - foreach my $item (@{ $form->{BUCHUNGSGRUPPEN} }) { - if ($item->{id} == $form->{buchungsgruppen_id}) { - $form->{selectbuchungsgruppe} .= - " - - - |; - - - # set option - foreach my $item (qw(IC IC_income IC_expense)) { - if ($form->{$item}) { - if ($form->{id} && $form->{orphaned}) { - $form->{"select$item"} =~ s/ selected//; - $form->{"select$item"} =~ - s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; - } else { - $form->{"select$item"} = qq| - - - -|; - if (!$eur) { - $linkaccounts = qq| - - - - - |; - } - - if ($form->{item} eq "part") { - - $linkaccounts .= qq| - - - - - - - - - - -|; - - $weight = qq| - - - - -|; - - } - - if ($form->{item} eq "assembly") { - - $lastcost = ""; - - $linkaccounts = qq| - - - - - -|; - - $weight = qq| - - - - -|; - - } - - if ($form->{item} eq "service") { - - $linkaccounts = qq| - - - - - - - - - - -|; - - } - $linkaccounts = qq||; - - if ($form->{IC_cogs_default}) { - $form->{IC_expense_default} = $form->{IC_cogs_default}; - } - - if (($form->{item} eq "service") || ($form->{item} eq "part")) { - $linkaccounts .= qq||; - } - if ($form->{item} eq "part") { - $linkaccounts .= qq||; - } - - if ($form->{item} ne 'service') { - $n = ($form->{onhand} > 0) ? "1" : "0"; - $rop = qq| - - - - -|; - - if ($form->{item} eq 'assembly') { - $rop .= qq| - - - - -|; - } - - $rop .= qq| - - - - -|; - - $bin = qq| - - - - -|; - $vegv = qq| - - - - - - - - -|; - $notdiscountableok = ($form->{not_discountable}) == 1 ? "checked" : ""; - $notdiscountable .= qq| - - - - -|; - - $formula = - qq||; - - $formula_label = $locale->text('Formula'); - - $imagelinks = qq| - - - -|; - - } - - if ($form->{id}) { - $obsolete = qq| - - - - -|; - } - $shopok = $form->{shop} == 1 ? "checked" : ""; - $shop .= qq| - - - - -|; - - - # type=submit $locale->text('Add Part') - # type=submit $locale->text('Add Service') - # type=submit $locale->text('Add Assembly') + @{ $form->{BUCHUNGSGRUPPEN} } = grep { $_->{id} eq $form->{buchungsgruppen_id} || ($form->{id} && $form->{orphaned}) || !$form->{id} } @{ $form->{BUCHUNGSGRUPPEN} }; - # type=submit $locale->text('Edit Part') - # type=submit $locale->text('Edit Service') - # type=submit $locale->text('Edit Assembly') - # use JavaScript Calendar or not - my ($jsscript, $button1); + # use JavaScript Calendar or not (yes!) $form->{jsscript} = 1; - $jsscript = ""; - if ($form->{jsscript}) { - - # with JavaScript Calendar - $button1 = qq| - - - |; - - #write Trigger - $jsscript = - Form->write_trigger(\%myconfig, "1", "priceupdate", "BL", "trigger1"); - } else { - - # without JavaScript Calendar - $button1 = qq| - |; - } - - my $unit_select = ''; - if (!$form->{"unit_changeable"}) { - $unit_select .= '' . $form->{"unit"}; - } else { - my $units = AM->retrieve_units(\%myconfig, $form, $form->{"item"} eq "service" ? "service" : "dimension"); - $unit_select .= AM->unit_select_html($units, "unit", $form->{"unit"}); - } - my $price_factor; - if (0 < scalar @{ $form->{ALL_PRICE_FACTORS} }) { - my @values = ('', map { $_->{id} } @{ $form->{ALL_PRICE_FACTORS} }); - my %labels = map { $_->{id} => $_->{description} } @{ $form->{ALL_PRICE_FACTORS} }; - - $price_factor = - qq||; - } + $units = AM->retrieve_units(\%myconfig, $form); + $form->{ALL_UNITS} = [ map +{ name => $_ }, sort { $units->{$a}{sortkey} <=> $units->{$b}{sortkey} } keys %$units ]; $form->{fokus} = "ic.partnumber"; - $form->header; - - print qq| - - - - -{script}> - -{id}> -{item}> - - - -{onhand}> -{orphaned}> - -{rowcount}> - - - - -
$form->{title}
- - - - - - - - - - - - - $serialnumber - - $makemodel - - - - - - - $toplevel - - - - - $bought - - - - |; - print qq| - - - - - -
| . $locale->text('Part Number') . qq|
| - . $locale->text('Part Description') . qq|
| . $locale->text('Group') . qq|
| . $locale->text('Drawing') . qq|| . $locale->text('Microfiche') . qq|
-  | - . $locale->text('Active') . qq| - $onhand -  | - . $locale->text('Obsolete') . qq| -  | - . $locale->text('Orphaned') . qq| -
-
-
- - - - - - - - - - - - - - - - -|; - for my $i (1 .. $form->{price_rows}) { - print qq| - - - - - - -|; - } - - print qq| -
| . $locale->text('Preisklasse') . qq|| . $locale->text('Preis') . qq|| . $locale->text('Prozentual/Absolut') . qq|
| . $locale->text('Sell Price') . qq|/
| . $locale->text('List Price') . qq|/
$form->{"pricegroup_$i"}/
-

- -{price_rows}> + print $form->parse_html_template('ic/search_update_prices', { PRICE_ROWS => $pricegroups }); -{login}> -{password}> - -
- - - - - -|; $lxdebug->leave_sub(); } #end search() sub confirm_price_update { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); $form->{nextsub} = "update_prices"; $form->header; - print qq| - - -
{script}> -|; - - # delete action variable map { delete $form->{$_} } qw(action header); - - foreach my $key (keys %$form) { - $form->{$key} =~ s/\"/"/g; - print qq|\n|; - } - - print qq| -

| . $locale->text('Confirm!') . qq|

- -

| - . $locale->text('Are you sure you want to update the prices') -. qq|

- -

- -

-|; + + print $form->parse_html_template('ic/confirm_price_update', { HIDDENS => [ map { name => $_, value => $form->{$_} }, keys %$form ] }); $lxdebug->leave_sub(); } @@ -616,6 +143,8 @@ sub confirm_price_update { sub update_prices { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + if (IC->update_prices(\%myconfig, \%$form)) { $form->redirect($form->{update_count} . $locale->text('prices updated!')); } else { @@ -625,256 +154,205 @@ sub update_prices { $lxdebug->leave_sub(); } -sub choice { - $lxdebug->enter_sub(); - - our ($j, $lastndx); - my ($totop100); - - $form->{title} = $locale->text('Top 100 hinzufuegen'); - - $form->header; - - print qq| - - -
{script}> - - {searchitems}> - - - - |; - - print qq| - - - - - - - - - -
| . $locale->text('Part Number') . qq|| . $locale->text('Part Description') . qq|
-
|; - - print qq| - -{login}> -{password}> - - - - - - - - - - - - - - - - - - - - - - - - - -{ndxs_counter}> - -{extras}>|; - - my ($partnumber, $description, $unit, $sellprice, $soldtotal); - # if choice set data - if ($form->{ndx}) { - for (my $i = 0; $i < $form->{ndxs_counter}; $i++) { - - # prepeare data - $partnumber = $form->{"totop100_partnumber_$j"}; - $description = $form->{"totop100_description_$j"}; - $unit = $form->{"totop100_unit_$j"}; - $sellprice = $form->{"totop100_sellprice_$j"}; - $soldtotal = $form->{"totop100_soldtotal_$j"}; - - # insert data into top100 - push @{ $form->{parts} }, - { number => "", - partnumber => "$partnumber", - description => "$description", - unit => "$unit", - sellprice => "$sellprice", - soldtotal => "$soldtotal" }; - } #rof - } #fi - - $totop100 = ""; - - # set data for next page - if (($form->{ndxs_counter}) > 0) { - for (my $i = 1; ($i < $form->{ndxs_counter} + 1); $i++) { - $partnumber = $form->{"totop100_partnumber_$i"}; - $description = $form->{"totop100_description_$i"}; - $unit = $form->{"totop100_unit_$i"}; - $sellprice = $form->{"totop100_sellprice_$i"}; - $soldtotal = $form->{"totop100_soldtotal_$i"}; - - $totop100 .= qq| -{"totop100_partnumber_$i"}> -{"totop100_description_$i"}> -{"totop100_unit_$i"}> -{"totop100_sellprice_$i"}> -{"totop100_soldtotal_$i"}> - |; - } #rof - } #fi - - print $totop100; - - print qq| - -
- - - |; - $lxdebug->leave_sub(); -} #end choice - -sub list { - $lxdebug->enter_sub(); - - our ($lastndx); - our ($partnumber, $description, $unit, $sellprice, $soldtotal); - - my @sortorders = ("", "partnumber", "description", "all"); - my $sortorder = $sortorders[($form->{description} ? 2 : 0) + ($form->{partnumber} ? 1 : 0)]; - IC->get_parts(\%myconfig, \%$form, $sortorder); - - $form->{title} = $locale->text('Top 100 hinzufuegen'); - - $form->header; - - print qq| - -
- - - - - - - - - - - - - |; - - my $j = 0; - my $i = $form->{rows}; - - for ($j = 1; $j <= $i; $j++) { - - print qq| - |; - if ($j == 1) { - print qq| - |; - } else { - print qq| - |; - } - print qq| - - - - - - - - |; - } - - print qq| - -
| . $locale->text('choice part') . qq|
 | . $locale->text('Part Number') . qq|| . $locale->text('Part Description') . qq|| . $locale->text('Unit of measure') . qq|| . $locale->text('Sell Price') . qq|| . $locale->text('soldtotal') . qq|
$form->{"partnumber_$j"}$form->{"description_$j"}$form->{"unit_$j"}$form->{"sellprice_$j"}$form->{"soldtotal_$j"}
- -
- - -{login}> -{password}> - - - - - - - - - - - - - - - - - - - - - - - -{ndxs_counter}>|; - - my $totop100 = ""; - - if (($form->{ndxs_counter}) > 0) { - for ($i = 1; ($i < $form->{ndxs_counter} + 1); $i++) { - - $partnumber = $form->{"totop100_partnumber_$i"}; - $description = $form->{"totop100_description_$i"}; - $unit = $form->{"totop100_unit_$i"}; - $sellprice = $form->{"totop100_sellprice_$i"}; - $soldtotal = $form->{"totop100_soldtotal_$i"}; - - $totop100 .= qq| -{"totop100_partnumber_$i"}> -{"totop100_description_$i"}> -{"totop100_unit_$i"}> -{"totop100_sellprice_$i"}> -{"totop100_soldtotal_$i"}> - |; - } #rof - } #fi - - print $totop100; - - print qq| - +#sub choice { +# $lxdebug->enter_sub(); +# +# $auth->assert('part_service_assembly_edit'); +# +# our ($j, $lastndx); +# my ($totop100); +# +# $form->{title} = $locale->text('Top 100 hinzufuegen'); +# +# $form->header; +# +# push @custom_hiddens, qw(searchitems title bom titel revers lastsort sort ndxs_counter extras); +# push @custom_hiddens, qw(itemstatus l_linetotal l_partnumber l_description l_onhand l_unit l_sellprice l_linetotalsellprice); +# my @HIDDENS = ( +# +{ name => 'row', value => $j }, +# +{ name => 'nextsub', value => 'item_selected' }, +# +{ name => 'test', value => 'item_selected' }, +# +{ name => 'lastndx', value => $lastndx }, +# map(+{ name => $_, value => $form->{$_} }, @custom_hiddens), +# ); +# +# my ($partnumber, $description, $unit, $sellprice, $soldtotal); +# # if choice set data +## if ($form->{ndx}) { +## for my $i (0 .. $form->{ndxs_counter}) { +## +## # insert data into top100 +## push @{ $form->{parts} }, +## { number => "", +## partnumber => $form->{"totop100_partnumber_$j"}, +## description => $form->{"totop100_description_$j"}, +## unit => $form->{"totop100_unit_$j"}, +## sellprice => $form->{"totop100_sellprice_$j"}, +## soldtotal => $form->{"totop100_soldtotal_$j"}, +## }; +## } #rof +## } #fi +# +# $totop100 = ""; +# +# # set data for next page +# for my $i (1 .. $form->{ndxs_counter}) { +# $partnumber = $form->{"totop100_partnumber_$i"}; +# $description = $form->{"totop100_description_$i"}; +# $unit = $form->{"totop100_unit_$i"}; +# $sellprice = $form->{"totop100_sellprice_$i"}; +# $soldtotal = $form->{"totop100_soldtotal_$i"}; +# +# push @PARTS, { +# totop100_partnumber => $form->{"totop100_partnumber_$i"}, +# totop100_description => $form->{"totop100_description_$i"}, +# totop100_unit => $form->{"totop100_unit_$i"}, +# totop100_sellprice => $form->{"totop100_sellprice_$i"}, +# totop100_soldtotal => $form->{"totop100_soldtotal_$i"}, +# } +# +## $totop100 .= qq| +##{"totop100_partnumber_$i"}> +##{"totop100_description_$i"}> +##{"totop100_unit_$i"}> +##{"totop100_sellprice_$i"}> +##{"totop100_soldtotal_$i"}> +## |; +# } #rof +# +# print $form->parse_html_template('ic/choice', +{ HIDDENS => \@HIDDENS, PARTS => \@PARTS }); +# +# $lxdebug->leave_sub(); +#} #end choice -
- - -|; - $lxdebug->leave_sub(); -} #end list() +#sub list { +# $lxdebug->enter_sub(); +# +# $auth->assert('part_service_assembly_edit'); +# +# our ($lastndx); +# our ($partnumber, $description, $unit, $sellprice, $soldtotal); +# +# my @sortorders = ("", "partnumber", "description", "all"); +# my $sortorder = $sortorders[($form->{description} ? 2 : 0) + ($form->{partnumber} ? 1 : 0)]; +# IC->get_parts(\%myconfig, \%$form, $sortorder); +# +# $form->{title} = $locale->text('Top 100 hinzufuegen'); +# +# $form->header; +# +# print qq| +# +#
+# +# +# +# +# +# +# +# +# +# +# +# +# |; +# +# my $j = 0; +# my $i = $form->{rows}; +# +# for ($j = 1; $j <= $i; $j++) { +# +# print qq| +# |; +# if ($j == 1) { +# print qq| +# |; +# } else { +# print qq| +# |; +# } +# print qq| +# +# +# +# +# +# +# +# |; +# } +# +# print qq| +# +#
| . $locale->text('choice part') . qq|
 | . $locale->text('Part Number') . qq|| . $locale->text('Part Description') . qq|| . $locale->text('Unit of measure') . qq|| . $locale->text('Sell Price') . qq|| . $locale->text('soldtotal') . qq|
$form->{"partnumber_$j"}$form->{"description_$j"}$form->{"unit_$j"}$form->{"sellprice_$j"}$form->{"soldtotal_$j"}
+# +#
+# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +# +#{ndxs_counter}>|; +# +# my $totop100 = ""; +# +# if (($form->{ndxs_counter}) > 0) { +# for ($i = 1; ($i < $form->{ndxs_counter} + 1); $i++) { +# +# $partnumber = $form->{"totop100_partnumber_$i"}; +# $description = $form->{"totop100_description_$i"}; +# $unit = $form->{"totop100_unit_$i"}; +# $sellprice = $form->{"totop100_sellprice_$i"}; +# $soldtotal = $form->{"totop100_soldtotal_$i"}; +# +# $totop100 .= qq| +#{"totop100_partnumber_$i"}> +#{"totop100_description_$i"}> +#{"totop100_unit_$i"}> +#{"totop100_sellprice_$i"}> +#{"totop100_soldtotal_$i"}> +# |; +# } #rof +# } #fi +# +# print $totop100; +# +# print qq| +# +# +#
+# +# +#|; +# $lxdebug->leave_sub(); +#} #end list() sub top100 { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + if ($form->{ndx}) { $form->{ndxs_counter}++; @@ -896,6 +374,8 @@ sub top100 { sub addtop100 { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + my ($revers, $lastsort, $callback, $option, $description, $sameitem, $partnumber, $unit, $sellprice, $soldtotal, $totop100, $onhand, $align); my (@column_index, %column_header, %column_data); @@ -925,7 +405,7 @@ sub addtop100 { } #fi $callback = - "$form->{script}?action=top100&login=$form->{login}&password=$form->{password}&searchitems=$form->{searchitems}&itemstatus=$form->{itemstatus}&bom=$form->{bom}&l_linetotal=$form->{l_linetotal}&title=" + "$form->{script}?action=top100&searchitems=$form->{searchitems}&itemstatus=$form->{itemstatus}&bom=$form->{bom}&l_linetotal=$form->{l_linetotal}&title=" . $form->escape($form->{title}, 1); # if we have a serialnumber limit search @@ -1028,16 +508,13 @@ sub addtop100 { } if ($form->{serialnumber}) { $callback .= "&serialnumber=$form->{serialnumber}"; - $option .= - $locale->text('Serial Number') . qq| : $form->{serialnumber}
|; + $option .= $locale->text('Serial Number') . qq| : $form->{serialnumber}
|; } if ($form->{description}) { - $callback .= "&description=$form->{description}"; + $callback .= "&description=$form->{description}"; $description = $form->{description}; - $description =~ s/ -/
/g; - $option .= - $locale->text('Part Description') . qq| : $form->{description}
|; + $description =~ s/\n/
/g; + $option .= $locale->text('Part Description') . qq| : $form->{description}
|; } if ($form->{make}) { $callback .= "&make=$form->{make}"; @@ -1269,8 +746,8 @@ sub addtop100 { } #rof } #fi # build data for columns + my $i = 0; foreach my $ref (@{ $form->{parts} }) { - my $i = 0; if ($form->{l_subtotal} eq 'Y' && !$ref->{assemblyitem}) { if ($sameitem ne $ref->{ $form->{sort} }) { @@ -1293,8 +770,7 @@ sub addtop100 { $onhand = 0 if ($form->{sold}); } - $ref->{description} =~ s/ -/
/g; + $ref->{description} =~ s/\n/
/g; $column_data{number} = "
" @@ -1356,15 +832,15 @@ sub addtop100 { $column_data{invnumber} = ($ref->{module} ne 'oe') - ? "{module}.pl?action=edit&type=invoice&id=$ref->{trans_id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{invnumber}{module}.pl?action=edit&type=invoice&id=$ref->{trans_id}&callback=$callback>$ref->{invnumber}$ref->{invnumber}{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{ordnumber}{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&callback=$callback>$ref->{ordnumber}$ref->{ordnumber}{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{quonumber}{module}.pl?action=edit&type=$ref->{type}&id=$ref->{trans_id}&callback=$callback>$ref->{quonumber}$ref->{quonumber}$ref->{name}
| . $locale->text('Buchungsgruppe') . qq|
| - . $locale->text('Last Cost') . qq|{lastcost}>
| . $locale->text('Inventory') . qq|
| . $locale->text('Revenue') . qq|
| . $locale->text('Expense') . qq|
| . $locale->text('Weight') . qq| - - - - -
- {weight}> -
-
| . $locale->text('Revenue') . qq|
| . $locale->text('Weight') . qq| - - - - -
-  $form->{weight} - {weight}> -
-
| . $locale->text('Revenue') . qq|
| . $locale->text('Expense') . qq|
| . $locale->text('On Hand') . qq| | - . $form->format_amount(\%myconfig, $form->{onhand}) . qq|
| . $locale->text('Stock') . qq|{stock}>
| . $locale->text('ROP') . qq|{rop}>
| . $locale->text('Bin') . qq|{bin}>
| - . $locale->text('Verrechnungseinheit') . qq|{ve}>
| - . $locale->text('Business Volume') . qq|{gv}>
| - . $locale->text('Not Discountable') . qq|
- - - - - - - - - - - -
| . $locale->text('Image') . qq|| . $locale->text('Microfiche') . qq|
| . $locale->text('Drawing') . qq|
-
| . $locale->text('Obsolete') . qq|{obsolete}>
| - . $locale->text('Shopartikel') . qq|
text('button') . qq|>
| - . $locale->text('Price Factor') - . qq|| - . NTI($cgi->popup_menu('-name' => 'price_factor_id', - '-default' => $form->{price_factor_id}, - '-values' => \@values, - '-labels' => \%labels)) - . qq|
- - - - - - - - - - - $imagelinks -$jsscript -|; + $form->header; + print $form->parse_html_template('ic/form_header', { ALL_PRICE_FACTORS => $form->{ALL_PRICE_FACTORS}, + ALL_UNITS => $form->{ALL_UNITS}, + BUCHUNGSGRUPPEN => $form->{BUCHUNGSGRUPPEN}, + payment_terms => $form->{payment_terms}, + all_partsgroup => $form->{all_partsgroup}}); $lxdebug->leave_sub(); } sub form_footer { $lxdebug->enter_sub(); - if ($form->{item} eq "assembly") { - - print qq| - - - - {assembly_rows}> -|; - } - - print qq| - {login}> - {password}> - - - - {vc}> - - - -
$form->{title}
- - - - - - - - - - - - -
| . $locale->text('Part Number') . qq|| . $locale->text('Part Description') . qq|$group
$description$partsgroup
-
- - - - - -
- - - - - - - - - - - - - - - - - - - - - - - -
- - $buchungsgruppe - $linkaccounts -
-
| . $locale->text('Notes') . qq|$formula_label
- $notes - - $formula -
| . $locale->text('EAN-Code') . qq|
- - - $ean -
- - - - - -
| . $locale->text('Payment Terms') . qq|
-
-
- - - - $button1 - - - - - - - - - - $lastcost - $price_factor - - - - - $weight - $rop - $bin - $notdiscountable - $vegv - $shop - $obsolete -
| - . $locale->text('Updated') . qq|
| . $locale->text('List Price') . qq|{listprice}>
| . $locale->text('Sell Price') . qq|{sellprice}>
| . $locale->text('Unit') . qq|$unit_select
-
-
- - - - - -
| - . $locale->text('Total') . qq| | - . $form->format_amount(\%myconfig, $form->{assemblytotal}, 2) . qq|
-

- -
- - |; - - unless ($form->{item} eq "service") { - print qq| - {makemodel_rows}> - |; - } - - print qq| - {price_rows}>|; - - print qq| - |; - - if ($form->{id}) { - - if (!$form->{previousform}) { - print qq| - |; - } - - if ($form->{orphaned}) { - if (!$form->{previousform}) { - if ($form->{item} eq 'assembly') { - if (!$form->{onhand}) { - print qq| - |; - } - } else { - print qq| - |; - } - } - } - } + $auth->assert('part_service_assembly_edit'); - if (!$form->{previousform}) { - if ($form->{menubar}) { - require "bin/mozilla/menu.pl"; - &menubar; - } - } -# button for saving history - if($form->{id} ne "") { - print qq| - {id} - . qq|); name=history id=history value=| - . $locale->text('history') - . qq|>|; - } -# /button for saving history - print qq| - - - - - - - -|; + print $form->parse_html_template('ic/form_footer'); $lxdebug->leave_sub(); } @@ -2580,32 +1500,8 @@ sub makemodel_row { $lxdebug->enter_sub(); my ($numrows) = @_; - print qq| - - - - - - - -|; - - for my $i (1 .. $numrows) { - $form->{"make_$i"} =~ s/\"/"/g; - $form->{"model_$i"} =~ s/\"/"/g; - print qq| - - - - -|; - } - - print qq| -
| . $locale->text('Make') . qq|| . $locale->text('Model') . qq|
- - -|; + my @mm_data = grep { any { $_ ne '' } @$_{qw(make model)} } map +{ make => $form->{"make_$_"}, model => $form->{"model_$_"} }, 1 .. $numrows; + print $form->parse_html_template('ic/makemodel', { MM_DATA => [ @mm_data, {} ], mm_rows => scalar @mm_data + 1 }); $lxdebug->leave_sub(); } @@ -2733,7 +1629,7 @@ sub assembly_row { } else { $href = - qq|$form->{script}?action=edit&id=$form->{"id_$i"}&login=$form->{login}&password=$form->{password}&rowcount=$i&previousform=$previousform|; + qq|$form->{script}?action=edit&id=$form->{"id_$i"}&rowcount=$i&previousform=$previousform|; $column_data{partnumber} = qq|$form->{"partnumber_$i"}|; $column_data{runningnumber} = @@ -2839,6 +1735,8 @@ sub update { sub save { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + my ($parts_id, %newform, $previousform, $amount, $callback); # check if there is a part number - commented out, cause there is an automatic allocation of numbers @@ -2864,13 +1762,6 @@ sub save { $form->error($locale->text('Description must not be empty!')) unless $form->{description}; $form->error($locale->text('Partnumber must not be set to empty!')) if $form->{id} && !$form->{partnumber}; - # expand dynamic strings - # $locale->text('Inventory quantity must be zero before you can set this part obsolete!') - # $locale->text('Inventory quantity must be zero before you can set this assembly obsolete!') - # $locale->text('Part Number missing!') - # $locale->text('Service Number missing!') - # $locale->text('Assembly Number missing!') - # save part $lxdebug->message($LXDebug::DEBUG1, "ic.pl: sellprice in save = $form->{sellprice}\n"); if (IC->save(\%myconfig, \%$form) == 3) { @@ -2932,6 +1823,8 @@ sub save { map { $form->{"${_}_$i"} = $newform{$_} } qw(partnumber description bin unit listprice inventory_accno income_accno expense_accno sellprice lastcost price_factor_id); + $form->{"longdescription_$i"} = $newform{notes}; + $form->{"sellprice_$i"} = $newform{lastcost} if ($form->{vendor_id}); if ($form->{exchangerate} != 0) { @@ -2999,6 +1892,8 @@ sub save { sub save_as_new { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + # saving the history if(!exists $form->{addition}) { $form->{snumbers} = qq|partnumber_| . $form->{partnumber}; @@ -3017,6 +1912,9 @@ sub save_as_new { sub delete { $lxdebug->enter_sub(); + + $auth->assert('part_service_assembly_edit'); + # saving the history if(!exists $form->{addition}) { $form->{snumbers} = qq|partnumber_| . $form->{partnumber}; @@ -3036,32 +1934,17 @@ sub delete { sub price_row { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + my ($numrows) = @_; - print qq| - - - - - - - -|; - for my $i (1 .. $numrows) { - print qq| - - - - - -|; - } + my @PRICES = map +{ + pricegroup => $form->{"pricegroup_$_"}, + pricegroup_id => $form->{"pricegroup_id_$_"}, + price => $form->{"price_$_"}, + }, 1 .. $numrows; - print qq| -
| . $locale->text('Preisklasse') . qq|| . $locale->text('Preis') . qq|
$form->{"pricegroup_$i"}
- - -|; + print $form->parse_html_template('ic/price_row', { PRICES => \@PRICES }); $lxdebug->leave_sub(); } @@ -3069,14 +1952,25 @@ sub price_row { sub parts_language_selection { $lxdebug->enter_sub(); + $auth->assert('part_service_assembly_edit'); + our ($onload); my $languages = IC->retrieve_languages(\%myconfig, $form); + if ($form->{language_values} ne "") { + foreach $item (split(/---\+\+\+---/, $form->{language_values})) { + my ($language_id, $translation, $longdescription) = split(/--\+\+--/, $item); - my $callback = "$form->{script}?action=parts_language_selection&"; - map({ $callback .= "$_=" . $form->escape($form->{$_}) . "&" } - (qw(login password name input_name), grep({ /^[fl]_/ } keys %$form))); + foreach my $language (@{ $languages }) { + next unless ($language->{id} == $language_id); + + $language->{translation} = $translation; + $language->{longdescription} = $longdescription; + last; + } + } + } my @header_sort = qw(name longdescription); my %header_title = ( "name" => $locale->text("Name"), @@ -3092,9 +1986,9 @@ sub parts_language_selection { $form->{"title"} = $locale->text("Language Values"); $form->header(); - print($form->parse_html_template("ic/parts_language_selection", { "HEADER" => \@header, - "LANGUAGES" => $languages, - "onload" => $onload })); + print $form->parse_html_template("ic/parts_language_selection", { "HEADER" => \@header, + "LANGUAGES" => $languages, + "onload" => $onload }); $lxdebug->leave_sub(); }