X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Farap.pl;h=67b1c4871ff43c993c36401f777679058418d69c;hb=273b5e046f1dab732ece657a756ada58d7669b9d;hp=1ed40a7f942b3b58c47961223edd1246fd3cd754;hpb=7148aad6ec1cb80332c9fba6232e3fc825807307;p=kivitendo-erp.git diff --git a/bin/mozilla/arap.pl b/bin/mozilla/arap.pl index 1ed40a7f9..67b1c4871 100644 --- a/bin/mozilla/arap.pl +++ b/bin/mozilla/arap.pl @@ -30,14 +30,14 @@ # common routines for gl, ar, ap, is, ir, oe # -use SL::Projects; +use strict; # any custom scripts for this one if (-f "bin/mozilla/custom_arap.pl") { eval { require "bin/mozilla/custom_arap.pl"; }; } -if (-f "bin/mozilla/$form->{login}_arap.pl") { - eval { require "bin/mozilla/$form->{login}_arap.pl"; }; +if (-f "bin/mozilla/$main::form->{login}_arap.pl") { + eval { require "bin/mozilla/$main::form->{login}_arap.pl"; }; } 1; @@ -47,17 +47,21 @@ require "bin/mozilla/common.pl"; # end of main sub check_name { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + + $main::auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash |' . 'purchase_delivery_order_edit | sales_delivery_order_edit'); - my ($name) = @_; + my ($name, %params) = @_; $name = $name eq "customer" ? "customer" : "vendor"; - my ($new_name, $new_id) = split /--/, $form->{$name}; + my ($new_name,$new_id) = $form->{$name} =~ /^(.*?)--(\d+)$/; my $i = 0; # if we use a selection if ($form->{"select$name"}) { @@ -72,6 +76,7 @@ sub check_name { $form->{"${name}_id"} = $new_id; + _reset_salesman_id(); IS->get_customer(\%myconfig, \%$form) if ($name eq 'customer'); IR->get_vendor(\%myconfig, \%$form) if ($name eq 'vendor'); @@ -93,9 +98,17 @@ sub check_name { $form->{calctax} = 1; # return one name or a list of names in $form->{name_list} - if (($i = $form->get_name(\%myconfig, $name)) > 1) { - &select_name($name); - exit; + $i = $form->get_name(\%myconfig, $name); + + if ($i > 1) { + if ($params{no_select}) { + # $locale->text('Customer') + # $locale->text('Vendor') + $form->error($locale->text("More than one #1 found matching, please be more specific.", $locale->text(ucfirst $name))); + } else { + &select_name($name); + ::end_of_request(); + } } if ($i == 1) { @@ -105,6 +118,7 @@ sub check_name { $form->{$name} = $form->{name_list}[0]->{name}; $form->{"old$name"} = qq|$form->{$name}--$form->{"${name}_id"}|; + _reset_salesman_id(); IS->get_customer(\%myconfig, \%$form) if ($name eq 'customer'); IR->get_vendor(\%myconfig, \%$form) if ($name eq 'vendor'); @@ -113,14 +127,14 @@ sub check_name { # name is not on file # $locale->text('Customer not on file or locked!') # $locale->text('Vendor not on file or locked!') - $msg = ucfirst $name . " not on file or locked!"; + my $msg = ucfirst $name . " not on file or locked!"; $form->error($locale->text($msg)); } } } $form->language_payment(\%myconfig); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); return $i; } @@ -129,16 +143,20 @@ sub check_name { # $locale->text('Vendor not on file!') sub select_name { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my $locale = $main::locale; - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . + $main::auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit | sales_delivery_order_edit |' . 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash'); my ($table) = @_; - @column_index = qw(ndx name address); + my @column_index = qw(ndx name address); - $label = ucfirst $table; + my $label = ucfirst $table; + my %column_data; $column_data{ndx} = qq| |; $column_data{name} = qq|| . $locale->text($label) . qq||; @@ -148,32 +166,29 @@ sub select_name { # list items with radio button on a form $form->header; - $title = $locale->text('Select from one of the names below'); + my $title = $locale->text('Select from one of the names below'); print qq| - +

$title

{script}> - - - -
$title
- |; + |; map { print "\n$column_data{$_}" } @column_index; print qq| - + |; my $i = 0; - foreach $ref (@{ $form->{name_list} }) { - $checked = ($i++) ? "" : "checked"; + my $j; + foreach my $ref (@{ $form->{name_list} }) { + my $checked = ($i++) ? "" : "checked"; $ref->{name} =~ s/\"/"/g; @@ -186,12 +201,12 @@ sub select_name { $j++; $j %= 2; print qq| - |; + |; map { print "\n$column_data{$_}" } @column_index; print qq| - + {id}> @@ -216,7 +231,7 @@ sub select_name { map { delete $form->{$_} } qw(action name_list header); # save all other form variables - foreach $key (keys %${form}) { + foreach my $key (keys %${form}) { next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key})); $form->{$key} =~ s/\"/"/g; print qq|\n|; @@ -230,24 +245,26 @@ sub select_name { - - - |; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub name_selected { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . + my $form = $main::form; + my %myconfig = %main::myconfig; + + $main::auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit | sales_delivery_order_edit | ' . 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash'); # replace the variable with the one checked # index for new item - $i = $form->{ndx}; + my $i = $form->{ndx}; + + _reset_salesman_id(); $form->{ $form->{vc} } = $form->{"new_name_$i"}; $form->{"$form->{vc}_id"} = $form->{"new_id_$i"}; @@ -266,197 +283,201 @@ sub name_selected { &update(1); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } -sub check_project { - $lxdebug->enter_sub(); +# Reset the $::form field 'salesman_id' to the ID of the currently +# logged in user. Useful when changing to a customer/vendor that has +# no salesman listed in their master data. +sub _reset_salesman_id { + my $current_employee = SL::DB::Manager::Employee->current; + $::form->{salesman_id} = $current_employee->id if $current_employee && exists $::form->{salesman_id}; +} - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . - 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash | report'); +sub select_project { + $::lxdebug->enter_sub; + + $::auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . + 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash | report'); - my $nextsub = shift || 'update'; + my ($is_global, $nextsub) = @_; + my $project_list = delete $::form->{project_list}; - for $i (1 .. $form->{rowcount}) { - my $suffix = $i ? "_$i" : ""; - my $prefix = $i ? "" : "global"; - $form->{"${prefix}project_id${suffix}"} = "" unless $form->{"${prefix}projectnumber$suffix"}; - if ($form->{"${prefix}projectnumber${suffix}"} ne $form->{"old${prefix}projectnumber${suffix}"}) { - if ($form->{"${prefix}projectnumber${suffix}"}) { + map { delete $::form->{$_} } qw(action header update); - # get new project - $form->{projectnumber} = $form->{"${prefix}projectnumber${suffix}"}; - my %params = map { $_ => $form->{$_} } qw(projectnumber description active); - if (($rows = Projects->search_projects(%params)) > 1) { + my @hiddens; + for my $key (keys %$::form) { + next if $key eq 'login' || $key eq 'password' || '' ne ref $::form->{$key}; + push @hiddens, { key => $key, value => $::form->{$key} }; + } + push @hiddens, { key => 'is_global', value => $is_global }, + { key => 'project_selected_nextsub', value => $nextsub }; - # check form->{project_list} how many there are - $form->{rownumber} = $i; - &select_project($i ? undef : 1, $nextsub); - exit; - } + $::form->header; + print $::form->parse_html_template('arap/select_project', { hiddens => \@hiddens, project_list => $project_list }); - if ($rows == 1) { - $form->{"${prefix}project_id${suffix}"} = $form->{project_list}->[0]->{id}; - $form->{"${prefix}projectnumber${suffix}"} = $form->{project_list}->[0]->{projectnumber}; - $form->{"old${prefix}projectnumber${suffix}"} = $form->{project_list}->[0]->{projectnumber}; - } else { + $::lxdebug->leave_sub; +} - # not on file - $form->error($locale->text('Project not on file!')); - } - } else { - $form->{"old${prefix}projectnumber${suffix}"} = ""; - } - } +sub project_selected { + $main::lxdebug->enter_sub(); + + my $form = $main::form; + + $main::auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . + 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash | report'); + + # replace the variable with the one checked + + # index for new item + my $i = $form->{ndx}; + + my $prefix = $form->{"is_global"} ? "global" : ""; + my $suffix = $form->{"is_global"} ? "" : "_$form->{rownumber}"; + + $form->{"${prefix}projectnumber${suffix}"} = + $form->{"new_projectnumber_$i"}; + $form->{"old${prefix}projectnumber${suffix}"} = + $form->{"new_projectnumber_$i"}; + $form->{"${prefix}project_id${suffix}"} = $form->{"new_id_$i"}; + + # delete all the new_ variables + for $i (1 .. $form->{lastndx}) { + map { delete $form->{"new_${_}_$i"} } qw(id projectnumber description); } - $lxdebug->leave_sub(); + my $nextsub = $form->{project_selected_nextsub} || 'update'; + + map { delete $form->{$_} } qw(ndx lastndx nextsub is_global project_selected_nextsub); + + call_sub($nextsub); + + $main::lxdebug->leave_sub(); } -sub select_project { - $lxdebug->enter_sub(); +sub continue { call_sub($main::form->{"nextsub"}); } - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . - 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash | report'); +1; - my ($is_global, $nextsub) = @_; +__END__ - @column_index = qw(ndx projectnumber description); +=head1 NAME - $column_data{ndx} = qq||; - $column_data{projectnumber} = qq||; - $column_data{description} = - qq||; +arap.pl - helper functions or customer/vendor retrieval - # list items with radio button on a form - $form->header; +=head1 SYNOPSIS - $title = $locale->text('Select from one of the projects below'); + check_name('vendor') - print qq| - +=head1 DESCRIPTION -{script}> +Don't use anyting in this file without extreme care, and even then be prepared for massive headaches. -{rownumber}> +It's a collection of helper routines that wrap the customer/vendor dropdown/textfield duality into something even complexer. -
 | . $locale->text('Number') . qq|| . $locale->text('Description') . qq|
- - - - - - - - - - -
$title
- - |; +=head1 FUNCTIONS - map { print "\n$column_data{$_}" } @column_index; +=head2 check_name customer|vendor - print qq| - -|; +check_name was originally meant to update the selected customer or vendor. The +way it does that has generted more hate than almost any other part of this +software. - my $i = 0; - foreach $ref (@{ $form->{project_list} }) { - $checked = ($i++) ? "" : "checked"; +What it does is: - $ref->{name} =~ s/\"/"/g; +=over 4 - $column_data{ndx} = - qq||; - $column_data{projectnumber} = - qq||; - $column_data{description} = qq||; +=item * - $j++; - $j %= 2; - print qq| - |; +It checks if a vendor or customer is given. No failsafe, vendor fallback if +$_[0] is something fancy. - map { print "\n$column_data{$_}" } @column_index; +=item * - print qq| - +It assumes, that there is a field named customer or vendor in $form. -{id}> +=item * -|; +It assumes, that this field is filled with name--id, and tries to split that. +sql ledger uses that combination to get ids into the select keys. - } +=item * - print qq| -
$ref->{projectnumber}$ref->{description}
-

+It looks for a field selectcustomer or selectvendor in $form. sql ledger used +to store a copy of the html select in there. (again, don't ask) - +=item * -|; +If this field exists, it looks for a field called oldcustomer or oldvendor, in +which the old name--id string was stored in sql ledger, and compares those. - # delete action variable - map { delete $form->{$_} } qw(action project_list header update); +=item * - # save all other form variables - foreach $key (keys %${form}) { - next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key})); - $form->{$key} =~ s/\"/"/g; - print qq|\n|; - } +if they don't match, it will set customer_id or vendor_id in $form, load the +entry (which will clobber everything in $form named like a column in customer +oder vendor) and return. - print - $cgi->hidden('-name' => 'is_global', '-default' => [$is_global]) - . $cgi->hidden('-name' => 'project_selected_nextsub', '-default' => [$nextsub]) - . qq| +=item * -
- - +If there was no select* entry, it assumes that vclimit was lower than the +number of entries, and that an input field was generated. In that case the +splitting is omitted (since users don't generally include ids in entered names) - - -|; +=item * - $lxdebug->leave_sub(); -} +It looks for a *_id field, and combines it with the given input into a name--id +entry and compares it to the old* entry. (Missing any of these will instantly +break check_namea. -sub project_selected { - $lxdebug->enter_sub(); +=item * - $auth->assert('general_ledger | vendor_invoice_edit | sales_order_edit | invoice_edit |' . - 'request_quotation_edit | sales_quotation_edit | purchase_order_edit | cash | report'); +If those do not match, $form->get_name is called to get matching results. +get_name only matches by *number and name, not by id, don't try to get it to do +so. - # replace the variable with the one checked +=item * - # index for new item - $i = $form->{ndx}; +The results are stored in $form>{name_list} but a count is returned, and +checked. - my $prefix = $form->{"is_global"} ? "global" : ""; - my $suffix = $form->{"is_global"} ? "" : "_$form->{rownumber}"; +=item * - $form->{"${prefix}projectnumber${suffix}"} = - $form->{"new_projectnumber_$i"}; - $form->{"old${prefix}projectnumber${suffix}"} = - $form->{"new_projectnumber_$i"}; - $form->{"${prefix}project_id${suffix}"} = $form->{"new_id_$i"}; +If only one result was found, *_id, * and old* are copied into $form, the entry +is loaded (like above, clobbering) - # delete all the new_ variables - for $i (1 .. $form->{lastndx}) { - map { delete $form->{"new_${_}_$i"} } qw(id projectnumber description); - } +=item * - my $nextsub = $form->{project_selected_nextsub} || 'update'; +If there is more than one, a selection dialog is rendered - map { delete $form->{$_} } qw(ndx lastndx nextsub is_global project_selected_nextsub); +=item * - call_sub($nextsub); +If none is found, an error is generated. - $lxdebug->leave_sub(); -} +=back + +=head3 I built a customer/vendor box somewhere and it doesn't work, what's wrong? + +Make sure a select* field is given if and only if you render a select box. The +actual contents are ignored, but recognition fails if not present. + +Make sure old* and *_id fields are set correctly (name--id form for old*). They +are necessary in all steps and branches. + +Since get_customer and get_vendor clobber a lot of fields, make sure what +changes exactly. + +=head3 select- version works fine, but things go awry when I use a textbox, any idea? + +If there is more than one match, check_name will display a select form, that +will redirect to the original C. Unfortunately any hidden vars or +input fields will be lost in the process unless saved before in a callback. + +If you still want to use it, you can disable this feature, like this: + + check_name('customer', no_select => 1) + +In that case multiple matches will trigger an error. -sub continue { call_sub($form->{"nextsub"}); } +Otherwise you'll have to care to include a complete state in callback. +=cut