X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Foe.pl;h=f08daabfde2218e79c95bc7b3327eae3faa28aa2;hb=a325f1b7554914418f885c43211099baa0ce083c;hp=e281da720d20e01c7513affc42337971e9cefbd0;hpb=8a996479a2d9daea50b2ead5426a962145101896;p=kivitendo-erp.git diff --git a/bin/mozilla/oe.pl b/bin/mozilla/oe.pl index e281da720..c86de3763 100644 --- a/bin/mozilla/oe.pl +++ b/bin/mozilla/oe.pl @@ -1,4 +1,4 @@ -# #===================================================================== +#===================================================================== # LX-Office ERP # Copyright (C) 2004 # Based on SQL-Ledger Version 2.1.9 @@ -30,15 +30,22 @@ # Order entry module # Quotation module #====================================================================== -use Data::Dumper; +use POSIX qw(strftime); + +use SL::DO; +use SL::FU; use SL::OE; use SL::IR; use SL::IS; use SL::PE; +use SL::ReportGenerator; +use List::Util qw(max reduce sum); +use Data::Dumper; -require "$form->{path}/io.pl"; -require "$form->{path}/arap.pl"; +require "bin/mozilla/io.pl"; +require "bin/mozilla/arap.pl"; +require "bin/mozilla/reportgenerator.pl"; 1; @@ -55,9 +62,25 @@ require "$form->{path}/arap.pl"; # $locale->text('Workflow request_quotation'); # $locale->text('Workflow sales_quotation'); +my $oe_access_map = { + 'sales_order' => 'sales_order_edit', + 'purchase_order' => 'purchase_order_edit', + 'request_quotation' => 'request_quotation_edit', + 'sales_quotation' => 'sales_quotation_edit', +}; + +sub check_oe_access { + my $right = $oe_access_map->{$form->{type}}; + $right ||= 'DOES_NOT_EXIST'; + + $auth->assert($right); +} + sub set_headings { $lxdebug->enter_sub(); + check_oe_access(); + my ($action) = @_; if ($form->{type} eq 'purchase_order') { @@ -95,10 +118,12 @@ sub set_headings { sub add { $lxdebug->enter_sub(); + check_oe_access(); + set_headings("add"); $form->{callback} = - "$form->{script}?action=add&type=$form->{type}&vc=$form->{vc}&login=$form->{login}&path=$form->{path}&password=$form->{password}" + "$form->{script}?action=add&type=$form->{type}&vc=$form->{vc}" unless $form->{callback}; &order_links; @@ -111,25 +136,31 @@ sub add { sub edit { $lxdebug->enter_sub(); + check_oe_access(); + + # show history button + $form->{javascript} = qq||; + #/show hhistory button + $form->{simple_save} = 0; set_headings("edit"); # editing without stuff to edit? try adding it first - if ($form->{rowcount}) { - map { $id++ if $form->{"id_$_"} } (1 .. $form->{rowcount}); + if ($form->{rowcount} && !$form->{print_and_save}) { + map { $id++ if $form->{"multi_id_$_"} } (1 .. $form->{rowcount}); if (!$id) { # reset rowcount undef $form->{rowcount}; &add; + $lxdebug->leave_sub(); return; } - } else { - if (!$form->{id}) { - &add; - return; - } + } elsif (!$form->{id}) { + &add; + $lxdebug->leave_sub(); + return; } if ($form->{print_and_save}) { @@ -142,11 +173,20 @@ sub edit { set_headings("edit"); &order_links; + + $form->{rowcount} = 0; + foreach $ref (@{ $form->{form_details} }) { + $form->{rowcount}++; + map { $form->{"${_}_$form->{rowcount}"} = $ref->{$_} } keys %{$ref}; + } + &prepare_order; + if ($form->{print_and_save}) { $form->{language_id} = $language_id; $form->{printer_id} = $printer_id; } + &display_form; $lxdebug->leave_sub(); @@ -155,171 +195,68 @@ sub edit { sub order_links { $lxdebug->enter_sub(); + check_oe_access(); + # get customer/vendor - $form->all_vc(\%myconfig, $form->{vc}, - ($form->{vc} eq 'customer') ? "AR" : "AP"); + $form->all_vc(\%myconfig, $form->{vc}, ($form->{vc} eq 'customer') ? "AR" : "AP"); # retrieve order/quotation - $form->{webdav} = $webdav; - # set jscalendar - $form->{jscalendar} = $jscalendar; - - OE->retrieve(\%myconfig, \%$form); + $form->{webdav} = $webdav; + $form->{jsscript} = 1; - if ($form->{payment_id}) { - $payment_id = $form->{payment_id}; - } - if ($form->{language_id}) { - $language_id = $form->{language_id}; - } - if ($form->{taxzone_id}) { - $taxzone_id = $form->{taxzone_id}; - } + my $editing = $form->{id}; + OE->retrieve(\%myconfig, \%$form); # if multiple rowcounts (== collective order) then check if the # there were more than one customer (in that case OE::retrieve removes # the content from the field) - if ( $form->{rowcount} - && $form->{type} eq 'sales_order' - && defined $form->{customer} - && $form->{customer} eq '') { - - # $main::lxdebug->message(0, "Detected Edit order with concurrent customers"); - $form->error( - $locale->text( - 'Collective Orders only work for orders from one customer!') - ); - } + $form->error($locale->text('Collective Orders only work for orders from one customer!')) + if $form->{rowcount} && $form->{type} eq 'sales_order' + && defined $form->{customer} && $form->{customer} eq ''; - $taxincluded = $form->{taxincluded}; - $form->{shipto} = 1 if $form->{id}; - - if ($form->{"all_$form->{vc}"}) { - unless ($form->{"$form->{vc}_id"}) { - $form->{"$form->{vc}_id"} = $form->{"all_$form->{vc}"}->[0]->{id}; - } - } + $form->{"$form->{vc}_id"} ||= $form->{"all_$form->{vc}"}->[0]->{id} if $form->{"all_$form->{vc}"}; - $cp_id = $form->{cp_id}; - $intnotes = $form->{intnotes}; + $form->backup_vars(qw(payment_id language_id taxzone_id salesman_id taxincluded cp_id intnotes)); + $form->{shipto} = 1 if $form->{id}; # get customer / vendor - if ($form->{type} =~ /(purchase_order|request_quotation|receive_order)/) { - IR->get_vendor(\%myconfig, \%$form); - - #quote all_vendor Bug 133 - foreach $ref (@{ $form->{all_vendor} }) { - $ref->{name} = $form->quote($ref->{name}); - } - - } - if ($form->{type} =~ /(sales|ship)_(order|quotation)/) { - IS->get_customer(\%myconfig, \%$form); - - #quote all_vendor Bug 133 - foreach $ref (@{ $form->{all_customer} }) { - $ref->{name} = $form->quote($ref->{name}); - } + IR->get_vendor(\%myconfig, \%$form) if $form->{type} =~ /(purchase_order|request_quotation)/; + IS->get_customer(\%myconfig, \%$form) if $form->{type} =~ /sales_(order|quotation)/; - } - $form->{cp_id} = $cp_id; - if ($payment_id) { - $form->{payment_id} = $payment_id; - } - if ($language_id) { - $form->{language_id} = $language_id; - } - if ($taxzone_id) { - $form->{taxzone_id} = $taxzone_id; - } - $form->{intnotes} = $intnotes; - ($form->{ $form->{vc} }) = split /--/, $form->{ $form->{vc} }; - $form->{"old$form->{vc}"} = - qq|$form->{$form->{vc}}--$form->{"$form->{vc}_id"}|; + $form->restore_vars(qw(payment_id language_id taxzone_id intnotes cp_id)); + $form->restore_vars(qw(taxincluded)) if $form->{id}; + $form->restore_vars(qw(salesman_id)) if $editing; + $form->{forex} = $form->{exchangerate}; + $form->{employee} = "$form->{employee}--$form->{employee_id}"; - # build the popup menus + # build vendor/customer drop down comatibility... don't ask if (@{ $form->{"all_$form->{vc}"} }) { - $form->{ $form->{vc} } = - qq|$form->{$form->{vc}}--$form->{"$form->{vc}_id"}|; - map { $form->{"select$form->{vc}"} .= "|; - foreach $item (@{ $form->{payment_terms} }) { - if ($form->{payment_id} eq $item->{id}) { - $payment .= qq||; - } else { - $payment .= qq||; - } - } - if ($form->{jsscript}) { - - # with JavaScript Calendar - $button1 = qq| - {transdate}> - text('button') . qq|> - |; - $button2 = qq| - {reqdate}> - text('button') . qq|> - |; - - #write Trigger - $jsscript = - Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", - "reqdate", "BL", "trigger2"); + $form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id}; + $form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id}; - } else { + # use JavaScript Calendar or not + $form->{jsscript} = 1; + + # openclosed checkboxes + my @tmp; + push @tmp, sprintf qq||, + $form->{"delivered"} ? "checked" : "", $locale->text('Delivered') if $form->{"type"} =~ /_order$/; + push @tmp, sprintf qq||, + $form->{"closed"} ? "checked" : "", $locale->text('Closed') if $form->{id}; + $TMPL_VAR{openclosed} = sprintf qq|%s\n|, 2 * scalar @tmp, join "\n", @tmp if @tmp; + + # project ids + my @old_project_ids = ($form->{"globalproject_id"}, grep { $_ } map { $form->{"project_id_$_"} } 1..$form->{"rowcount"}); + + my $vc = $form->{vc} eq "customer" ? "customers" : "vendors"; + $form->get_lists("contacts" => "ALL_CONTACTS", + "shipto" => "ALL_SHIPTO", + "projects" => { "key" => "ALL_PROJECTS", + "all" => 0, + "old_id" => \@old_project_ids }, + "employees" => "ALL_EMPLOYEES", + "salesmen" => "ALL_SALESMEN", + "taxzones" => "ALL_TAXZONES", + "payments" => "ALL_PAYMENTS", + "currencies" => "ALL_CURRENCIES", + "departments" => "ALL_DEPARTMENTS", + $vc => { key => "ALL_" . uc($vc), + limit => $myconfig{vclimit} + 1 }, + "price_factors" => "ALL_PRICE_FACTORS"); + + # label subs + $TMPL_VAR{sales_employee_labels} = sub { $_[0]->{name} || $_[0]->{login} }; + $TMPL_VAR{shipto_labels} = sub { join "; ", grep { $_ } map { $_[0]->{"shipto${_}" } } qw(name department_1 street city) }; + $TMPL_VAR{contact_labels} = sub { join(', ', $_[0]->{"cp_name"}, $_[0]->{"cp_givenname"}) . ($_[0]->{cp_abteilung} ? " ($_[0]->{cp_abteilung})" : "") }; + $TMPL_VAR{department_labels} = sub { "$_[0]->{description}--$_[0]->{id}" }; + + # vendor/customer + $TMPL_VAR{vc_keys} = sub { "$_[0]->{name}--$_[0]->{id}" }; + $TMPL_VAR{vclimit} = $myconfig{vclimit}; + $TMPL_VAR{vc_select} = "customer_or_vendor_selection_window('$form->{vc}', '', @{[ $form->{vc} eq 'vendor' ? 1 : 0 ]}, 0)"; + push @custom_hiddens, "$form->{vc}_id"; + push @custom_hiddens, "old$form->{vc}"; + push @custom_hiddens, "select$form->{vc}"; + + # currencies and exchangerate + @values = map { $_ } @{ $form->{ALL_CURRENCIES} }; + %labels = map { $_ => $_ } @{ $form->{ALL_CURRENCIES} }; + $form->{currency} = $form->{defaultcurrency} unless $form->{currency}; + $TMPL_VAR{show_exchangerate} = $form->{currency} ne $form->{defaultcurrency}; + $TMPL_VAR{currencies} = NTI($cgi->popup_menu('-name' => 'currency', '-default' => $form->{"currency"}, + '-values' => \@values, '-labels' => \%labels)) if scalar @values; + push @custom_hiddens, "forex"; + push @custom_hiddens, "exchangerate" if $form->{forex}; + + # credit remaining + $creditwarning = (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) ? 1 : 0; + $TMPL_VAR{is_credit_remaining_negativ} = ($form->{creditremaining} =~ /-/) ? "0" : "1"; + + # business + $TMPL_VAR{business_label} = ($form->{vc} eq "customer" ? $locale->text('Customer type') : $locale->text('Vendor type')); + + push @custom_hiddens, "customer_klass" if $form->{vc} eq 'customer'; - # without JavaScript Calendar - $button1 = qq| - {transdate}>|; - $button2 = qq| - {reqdate}>|; - } + $credittext = $locale->text('Credit Limit exceeded!!!'); + + my $follow_up_vc = $form->{ $form->{vc} eq 'customer' ? 'customer' : 'vendor' }; + $follow_up_vc =~ s/--.*?//; + $TMPL_VAR{follow_up_trans_info} = ($form->{type} =~ /_quotation$/ ? $form->{quonumber} : $form->{ordnumber}) . " ($follow_up_vc)"; if ($form->{id}) { - $openclosed = qq| - - - - - - - -
| - . $locale->text('Open') . qq| | - . $locale->text('Closed') . qq|
- - -|; - } + my $follow_ups = FU->follow_ups('trans_id' => $form->{id}); - # set option selected - foreach $item ($form->{vc}, currency, department, employee) { - $form->{"select$item"} =~ s/ selected//; - $form->{"select$item"} =~ - s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; + if (scalar @{ $follow_ups }) { + $TMPL_VAR{num_follow_ups} = scalar @{ $follow_ups }; + $TMPL_VAR{num_due_follow_ups} = sum map { $_->{due} * 1 } @{ $follow_ups }; + } } - #quote select[customer|vendor] Bug 133 - $form->{"select$form->{vc}"} = $form->quote($form->{"select$form->{vc}"}); + $onload = ($form->{resubmit} && ($form->{format} eq "html")) ? "window.open('about:blank','Beleg'); document.oe.target = 'Beleg';document.oe.submit()" + : ($form->{resubmit}) ? "document.oe.submit()" + : ($creditwarning) ? "alert('$credittext')" + : "focus()"; - #build contacts - if ($form->{all_contacts}) { - - $form->{selectcontact} = ""; - foreach $item (@{ $form->{all_contacts} }) { - my $department = ($item->{cp_abteilung}) ? "--$item->{cp_abteilung}" : ""; - if ($form->{cp_id} == $item->{cp_id}) { - $form->{selectcontact} .= - ""; - } else { - $form->{selectcontact} .= ""; - } - } - } else { - $form->{selectcontact} =~ s/ selected//g; - if ($form->{cp_id} ne "") { - $form->{selectcontact} =~ s/value=$form->{cp_id}/value=$form->{cp_id} selected/; - } - } + $onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|; + $onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|; + $TMPL_VAR{onload} = $onload; + $form->{javascript} .= qq||; + $form->{javascript} .= qq||; + $form->{javascript} .= qq||; - if (@{ $form->{SHIPTO} }) { - $form->{selectshipto} = ""; - foreach $item (@{ $form->{SHIPTO} }) { - if ($item->{shipto_id} == $form->{shipto_id}) { - $form->{selectshipto} .= - ""; - } else { - $form->{selectshipto} .= - ""; - } + $form->header; - } - } else { - $form->{selectshipto} =~ s/ selected//g; - if ($form->{shipto_id} ne "") { - $form->{selectshipto} =~ s/value=$form->{shipto_id}/value=$form->{shipto_id} selected/; - } - } + $TMPL_VAR{HIDDENS} = [ map { name => $_, value => $form->{$_} }, + qw(id action type vc formname media format proforma queued printed emailed + title creditlimit creditremaining tradediscount business + max_dunning_level dunning_amount shiptoname shiptostreet shiptozipcode + shiptocity shiptocountry shiptocontact shiptophone shiptofax + shiptodepartment_1 shiptodepartment_2 shiptoemail + message email subject cc bcc taxpart taxservice taxaccounts cursor_fokus), + @custom_hiddens, + map { $_.'_rate', $_.'_description' } split / /, $form->{taxaccounts} ]; # deleted: discount + + %TMPL_VAR = ( + %TMPL_VAR, + is_sales => scalar ($form->{type} =~ /^sales_/), # these vars are exported, so that the template + is_order => scalar ($form->{type} =~ /_order$/), # may determine what to show + is_sales_quo => scalar ($form->{type} =~ /sales_quotation$/), + is_req_quo => scalar ($form->{type} =~ /request_quotation$/), + is_sales_ord => scalar ($form->{type} =~ /sales_order$/), + is_pur_ord => scalar ($form->{type} =~ /purchase_order$/), + ); - $shipto = qq| - | . $locale->text('Shipping Address') . qq| - - |; + print $form->parse_html_template("oe/form_header", { %TMPL_VAR }); + $lxdebug->leave_sub(); +} +sub form_footer { + $lxdebug->enter_sub(); + check_oe_access(); - $form->{exchangerate} = - $form->format_amount(\%myconfig, $form->{exchangerate}); + $form->{invtotal} = $form->{invsubtotal}; - if (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) { - $creditwarning = 1; - } else { - $creditwarning = 0; - } + $rows = max 2, $form->numtextrows($form->{notes}, 25, 8); + $introws = max 2, $form->numtextrows($form->{intnotes}, 35, 8); + $rows = max $rows, $introws; - $form->{creditlimit} = - $form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0"); - $form->{creditremaining} = - $form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0"); + $TMPL_VAR{notes} = qq||; + $TMPL_VAR{intnotes} = qq||; - $contact = - ($form->{selectcontact}) - ? qq|\n| - : qq||; + if (!$form->{taxincluded}) { - $exchangerate = qq| -{forex}> -|; + foreach $item (split / /, $form->{taxaccounts}) { + if ($form->{"${item}_base"}) { + $form->{invtotal} += $form->{"${item}_total"} = $form->round_amount( $form->{"${item}_base"} * $form->{"${item}_rate"}, 2); + $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); - if ($form->{currency} ne $form->{defaultcurrency}) { - if ($form->{forex}) { - $exchangerate .= - qq|| - . $locale->text('Exchangerate') - . qq|$form->{exchangerate} - {exchangerate}> -|; - } else { - $exchangerate .= - qq|| - . $locale->text('Exchangerate') - . qq|{exchangerate}>|; + $TMPL_VAR{tax} .= qq| + + $form->{"${item}_description"} | . $form->{"${item}_rate"} * 100 .qq|% + $form->{"${item}_total"} + |; + } } - } - $vclabel = ucfirst $form->{vc}; - $vclabel = $locale->text($vclabel); +# $form->{invsubtotal} = $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); # template does this - $terms = qq| - - | . $locale->text('Terms: Net') . qq| - {terms}> | - . $locale->text('days') . qq| - -|; + } else { + foreach $item (split / /, $form->{taxaccounts}) { + if ($form->{"${item}_base"}) { + $form->{"${item}_total"} = $form->round_amount( ($form->{"${item}_base"} * $form->{"${item}_rate"} / (1 + $form->{"${item}_rate"})), 2); + $form->{"${item}_netto"} = $form->round_amount( ($form->{"${item}_base"} - $form->{"${item}_total"}), 2); + $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); + $form->{"${item}_netto"} = $form->format_amount(\%myconfig, $form->{"${item}_netto"}, 2); - if ($form->{business}) { - $business = qq| + $TMPL_VAR{tax} .= qq| - | . $locale->text('Business') . qq| - $form->{business} - | . $locale->text('Trade Discount') . qq| - | - . $form->format_amount(\%myconfig, $form->{tradediscount} * 100) - . qq| % + Enthaltene $form->{"${item}_description"} | . $form->{"${item}_rate"} * 100 .qq|% + $form->{"${item}_total"} -|; - } - - if ($form->{max_dunning_level}) { - $dunning = qq| - - - - - - - - -
| . $locale->text('Max. Dunning Level') . qq|:$form->{max_dunning_level}| . $locale->text('Dunning Amount') . qq|:| - . $form->format_amount(\%myconfig, $form->{dunning_amount},2) - . qq|
- - -|; - } - - if (@{ $form->{TAXZONE} }) { - $form->{selecttaxzone} = ""; - foreach $item (@{ $form->{TAXZONE} }) { - if ($item->{id} == $form->{taxzone_id}) { - $form->{selecttaxzone} .= - ""; - } else { - $form->{selecttaxzone} .= - ""; + Nettobetrag + $form->{"${item}_netto"} + |; } - - } - } else { - $form->{selecttaxzone} =~ s/ selected//g; - if ($form->{taxzone_id} ne "") { - $form->{selecttaxzone} =~ s/value=$form->{taxzone_id}>/value=$form->{taxzone_id} selected>/; } } - $taxzone = qq| - - | . $locale->text('Steuersatz') . qq| - - - |; + $form->{oldinvtotal} = $form->{invtotal}; + print $form->parse_html_template("oe/form_footer", { + %TMPL_VAR, + webdav => $webdav, + print_options => print_options(inline => 1), + label_edit => $locale->text("Edit the $form->{type}"), + label_workflow => $locale->text("Workflow $form->{type}"), + }); - if ($form->{type} !~ /_quotation$/) { - $ordnumber = qq| - - | . $locale->text('Order Number') . qq| - - - - | - . $locale->text('Quotation Number') . qq| - - - - | - . $locale->text('Customer Order Number') . qq| - - - - | . $locale->text('Order Date') . qq| - $button1 + $lxdebug->leave_sub(); +} - - - | . $locale->text('Required by') . qq| - $button2 - -|; +sub update { + $lxdebug->enter_sub(); - $n = ($form->{creditremaining} =~ /-/) ? "0" : "1"; + my ($recursive_call) = shift; - $creditremaining = qq| - - - - - - - - - - - -
| . $locale->text('Credit Limit') . qq|$form->{creditlimit}| . $locale->text('Remaining') . qq|$form->{creditremaining}
- - $shipto - -|; - } else { - $reqlabel = - ($form->{type} eq 'sales_quotation') - ? $locale->text('Valid until') - : $locale->text('Required by'); - if ($form->{type} eq 'sales_quotation') { - $ordnumber = qq| - - | - . $locale->text('Quotation Number') . qq| - - - -|; - } else { - $ordnumber = qq| - - | . $locale->text('RFQ Number') . qq| - - - -|; + check_oe_access(); - $terms = ""; - } +# $main::lxdebug->message(0, Dumper($form)); - $ordnumber .= qq| - - | . $locale->text('Quotation Date') . qq| - $button1 - - - $reqlabel - $button2 - -|; - $creditremaining = qq| - - $shipto - |; - } + set_headings($form->{"id"} ? "edit" : "add"); - $vc = - ($form->{"select$form->{vc}"}) - ? qq|\n{vc}"}">| - : qq|{vc} value="$form->{$form->{vc}}" size=35>|; + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate) unless $recursive_call; + $form->{update} = 1; - $department = qq| - - | . $locale->text('Department') . qq| - - - - -| if $form->{selectdepartment}; + $payment_id = $form->{payment_id} if $form->{payment_id}; - $employee = qq| - -|; + &check_name($form->{vc}); - if ($form->{type} eq 'sales_order') { - if ($form->{selectemployee}) { - $employee = qq| - {customer_klass}> - - | . $locale->text('Salesperson') . qq| - - - - -|; - } - } else { - $employee = qq| - {customer_klass}> - - | . $locale->text('Employee') . qq| - - - - -|; - } - if ($form->{resubmit} && ($form->{format} eq "html")) { - $onload = - qq|window.open('about:blank','Beleg'); document.oe.target = 'Beleg';document.oe.submit()|; - } elsif ($form->{resubmit}) { - $onload = qq|document.oe.submit()|; - } else { - $onload = "fokus()"; - } + $form->{payment_id} = $payment_id if $form->{payment_id} eq ""; - $credittext = $locale->text('Credit Limit exceeded!!!'); - if ($creditwarning) { - $onload = qq|alert('$credittext')|; - } + $buysell = 'buy'; + $buysell = 'sell' if ($form->{vc} eq 'vendor'); + $form->{forex} = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, $buysell); + $form->{exchangerate} = $form->{forex} if $form->{forex}; - $form->header; + $exchangerate = $form->{exchangerate} || 1; - print qq| - +##################### process items ###################################### + # for pricegroups + $i = $form->{rowcount}; + if ( ($form->{"partnumber_$i"} eq "") + && ($form->{"description_$i"} eq "") + && ($form->{"partsgroup_$i"} eq "")) { -
{script}> - - - - + $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); -{id}> -{action}> + &check_form; + } else { -{type}> -{formname}> -{media}> -{format}> -{proforma}> + if ($form->{type} =~ /^sales/) { + IS->retrieve_item(\%myconfig, \%$form); + } else { + IR->retrieve_item(\%myconfig, \%$form); + } - - - + my $rows = scalar @{ $form->{item_list} }; -{vc}> + # hier ist das problem fuer bug 817 $form->{discount} wird nicht durchgeschliffen + # ferner fallunterscheidung fuer verkauf oder einkauf s.a. bug 736 jb 04.05.2009 + # select discount as vendor_discount from vendor || + # select discount as customer_discount from customer + $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"$form->{vc}_discount"} * 100); - + if ($rows) { + $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"}); -{discount}> -{creditlimit}> -{creditremaining}> + if ($rows > 1) { -{tradediscount}> -{business}> - + &select_item; + exit; - - - - - - - - + } else { -$jsscript + $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); + $form->{"discount_$i"} = 0 if $form->{"not_discountable_$i"}; + map { $form->{item_list}[$i]{$_} =~ s/\"/"/g } qw(partnumber description unit); + map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; + $form->{payment_id} = $form->{"part_payment_id_$i"} if $form->{"part_payment_id_$i"} ne ""; - - - - - - - - - - - - - - - - - - - - - - - - - -|; + $form->{"marge_price_factor_$i"} = $form->{item_list}->[0]->{price_factor}; - foreach $item (split / /, $form->{taxaccounts}) { - print qq| -{"${item}_rate"}> - -|; - } - $lxdebug->leave_sub(); -} - -sub form_footer { - $lxdebug->enter_sub(); - - $form->{invtotal} = $form->{invsubtotal}; - - if (($rows = $form->numtextrows($form->{notes}, 25, 8)) < 2) { - $rows = 2; - } - if (($introws = $form->numtextrows($form->{intnotes}, 35, 8)) < 2) { - $introws = 2; - } - $rows = ($rows > $introws) ? $rows : $introws; - $notes = - qq||; - $intnotes = - qq||; - - $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; - - $taxincluded = ""; - if ($form->{taxaccounts}) { - $taxincluded = qq| - {taxincluded}> | - . $locale->text('Tax Included') . qq|

-|; - } - - if (!$form->{taxincluded}) { - - foreach $item (split / /, $form->{taxaccounts}) { - if ($form->{"${item}_base"}) { - $form->{invtotal} += $form->{"${item}_total"} = - $form->round_amount( - $form->{"${item}_base"} * $form->{"${item}_rate"}, - 2); - $form->{"${item}_total"} = - $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); - - $tax .= qq| - - - - -|; - } - } - - $form->{invsubtotal} = - $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); - - $subtotal = qq| - - - - -|; - - } - - if ($form->{taxincluded}) { - foreach $item (split / /, $form->{taxaccounts}) { - if ($form->{"${item}_base"}) { - $form->{"${item}_total"} = - $form->round_amount( - ($form->{"${item}_base"} * $form->{"${item}_rate"} / - (1 + $form->{"${item}_rate"}) - ), - 2); - $form->{"${item}_netto"} = - $form->round_amount( - ($form->{"${item}_base"} - $form->{"${item}_total"}), - 2); - $form->{"${item}_total"} = - $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); - $form->{"${item}_netto"} = - $form->format_amount(\%myconfig, $form->{"${item}_netto"}, 2); - - $tax .= qq| - - - - - - - - -|; - } - } - - } - - $form->{oldinvtotal} = $form->{invtotal}; - $form->{invtotal} = - $form->format_amount(\%myconfig, $form->{invtotal}, 2, 0); - - print qq| - - - -{oldinvtotal}> - - - - -|; - - if ($webdav) { - $webdav_list = qq| - - - - -
$form->{title}
- - - - - -
- - - - - {vc}_id value=$form->{"$form->{vc}_id"}> - {vc}"}"> - - - - $creditremaining - $business - $dunning - $taxzone - $department - - - - - {defaultcurrency}> - $exchangerate - - - - - - - - - |; -# -# -# -print qq|
$vclabel$vc| - . $locale->text('Contact Person') . qq|$contact
| . $locale->text('Currency') . qq|
| . $locale->text('Shipping Point') . qq|
| . $locale->text('Ship via') . qq|
-# -# -# -# -# -# -# -# -# -#
-# -# -#
-# -# -#
-#
-
- - $openclosed - $employee - $ordnumber - $terms -
-
-
$form->{"${item}_description"}$form->{"${item}_total"}
| . $locale->text('Subtotal') . qq|$form->{invsubtotal}
Enthaltene $form->{"${item}_description"}$form->{"${item}_total"}
Nettobetrag$form->{"${item}_netto"}
- - - - - -
- - - - - - - - - - - -
| . $locale->text('Notes') . qq|| . $locale->text('Internal Notes') . qq|
$notes$intnotes
| . $locale->text('Payment Terms') . qq|
-
- $taxincluded - - $subtotal - $tax - - - - -
| . $locale->text('Total') . qq|$form->{invtotal}
-
-

Dokumente im Webdav-Repository
- - -|; - foreach $file (keys %{ $form->{WEBDAV} }) { - $webdav_list .= qq| - - - - -|; - } - $webdav_list .= qq| -
DateinameWebdavlink
$file$form->{WEBDAV}{$file}
- - -
- -|; - - print $webdav_list; - } - print qq| -{jscalendar}> -|; - print qq| - - -|; - &print_options; - - print qq| - - - - -| . $locale->text("Edit the $form->{type}") . qq|
- - - - - - -|; - - if (($form->{id})) { - print qq| -
| . $locale->text("Workflow $form->{type}") . qq|
- -|; - if (($form->{type} =~ /sales_quotation$/)) { - print qq| -|; - } - if ($form->{type} =~ /request_quotation$/) { - print qq| -|; - } - if (1) { - print qq| - -|; -} - - if ($form->{type} =~ /sales_order$/) { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- - -|; - - } elsif ($form->{type} =~ /purchase_order$/) { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- - -|; - - } else { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- -|; - } - } elsif ($form->{type} =~ /sales_order$/ && $form->{rowcount} && !$form->{proforma}) { - print qq| -
Workflow $form->{heading}
- - -|; - } - - if ($form->{menubar}) { - require "$form->{path}/menu.pl"; - &menubar; - } - - print qq| - -{rowcount}> - - - -{path}> -{login}> -{password}> - -
- - - -|; - $lxdebug->leave_sub(); -} - -sub update { - $lxdebug->enter_sub(); - - set_headings($form->{"id"} ? "edit" : "add"); - - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } - qw(exchangerate creditlimit creditremaining); - $form->{update} = 1; - - &check_name($form->{vc}); - - &check_project; - - $buysell = 'buy'; - $buysell = 'sell' if ($form->{vc} eq 'vendor'); - $form->{exchangerate} = $exchangerate - if ( - $form->{forex} = ( - $exchangerate = - $form->check_exchangerate( - \%myconfig, $form->{currency}, $form->{transdate}, $buysell - ))); - - # for pricegroups - $i = $form->{rowcount}; - - $exchangerate = ($form->{exchangerate}) ? $form->{exchangerate} : 1; - - if ( ($form->{"partnumber_$i"} eq "") - && ($form->{"description_$i"} eq "") - && ($form->{"partsgroup_$i"} eq "")) { - - $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); - &check_form; - - } else { - - if ( $form->{type} eq 'purchase_order' - || $form->{type} eq 'request_quotation') { - IR->retrieve_item(\%myconfig, \%$form); - } - if ($form->{type} eq 'sales_order' || $form->{type} eq 'sales_quotation') { - IS->retrieve_item(\%myconfig, \%$form); - } - - my $rows = scalar @{ $form->{item_list} }; - - $form->{"discount_$i"} = - $form->format_amount(\%myconfig, $form->{discount} * 100); - - if ($rows) { - $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"}); - - if ($rows > 1) { - - &select_item; - exit; - - } else { - - $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); - if ($form->{"not_discountable_$i"}) { - $form->{"discount_$i"} = 0; - } - map { $form->{item_list}[$i]{$_} =~ s/\"/"/g } - qw(partnumber description unit); - map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } - keys %{ $form->{item_list}[0] }; - if ($form->{"part_payment_id_$i"} ne "") { - $form->{payment_id} = $form->{"part_payment_id_$i"}; - } - - $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; - - ($dec) = ($s =~ /\.(\d+)/); - $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; + ($sellprice || $form->{"sellprice_$i"}) =~ /\.(\d+)/; + $decimalplaces = max 2, length $1; if ($sellprice) { $form->{"sellprice_$i"} = $sellprice; } else { - $form->{"sellprice_$i"} *= (1 - $form->{tradediscount}); - - # if there is an exchange rate adjust sellprice - $form->{"sellprice_$i"} /= $exchangerate; + $form->{"sellprice_$i"} /= $exchangerate; # if there is an exchange rate adjust sellprice } - $amount = - $form->{"sellprice_$i"} * $form->{"qty_$i"} * - (1 - $form->{"discount_$i"} / 100); - map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); - map { $form->{"${_}_base"} += $amount } - (split / /, $form->{"taxaccounts_$i"}); - map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } - split / /, $form->{taxaccounts} - if !$form->{taxincluded}; + $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * (1 - $form->{"discount_$i"} / 100); + map { $form->{"${_}_base"} = 0 } split / /, $form->{taxaccounts}; + map { $form->{"${_}_base"} += $amount } split / /, $form->{"taxaccounts_$i"}; + map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{taxaccounts} if !$form->{taxincluded}; $form->{creditremaining} -= $amount; - $form->{"sellprice_$i"} = - $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, - $decimalplaces); - $form->{"qty_$i"} = - $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty); + $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); + $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty); # get pricegroups for parts IS->get_pricegroups_for_parts(\%myconfig, \%$form); @@ -1243,8 +557,7 @@ sub update { &set_pricegroup($i); } - &display_form; - + display_form(); } else { # ok, so this is a new part @@ -1255,17 +568,16 @@ sub update { && ($form->{"description_$i"} eq "")) { $form->{rowcount}--; $form->{"discount_$i"} = ""; - &display_form; - } else { + display_form(); + } else { $form->{"id_$i"} = 0; - $form->{"unit_$i"} = $locale->text('ea'); - - &new_item; - + new_item(); } } } +##################### process items ###################################### + $lxdebug->leave_sub(); } @@ -1273,6 +585,8 @@ sub update { sub search { $lxdebug->enter_sub(); + check_oe_access(); + if ($form->{type} eq 'purchase_order') { $form->{title} = $locale->text('Purchase Orders'); $form->{vc} = 'vendor'; @@ -1280,6 +594,7 @@ sub search { $ordnumber = 'ordnumber'; $employee = $locale->text('Employee'); } + if ($form->{type} eq 'request_quotation') { $form->{title} = $locale->text('Request for Quotations'); $form->{vc} = 'vendor'; @@ -1287,27 +602,13 @@ sub search { $ordnumber = 'quonumber'; $employee = $locale->text('Employee'); } - if ($form->{type} eq 'receive_order') { - $form->{title} = $locale->text('Receive Merchandise'); - $form->{vc} = 'vendor'; - $ordlabel = $locale->text('Order Number'); - $ordnumber = 'ordnumber'; - $employee = $locale->text('Employee'); - } + if ($form->{type} eq 'sales_order') { $form->{title} = $locale->text('Sales Orders'); $form->{vc} = 'customer'; $ordlabel = $locale->text('Order Number'); $ordnumber = 'ordnumber'; - $employee = $locale->text('Salesperson'); - } - if ($form->{type} eq 'ship_order') { - $form->{title} = $locale->text('Ship Merchandise'); - $form->{vc} = 'customer'; - $ordlabel = $locale->text('Order Number'); - $ordnumber = 'ordnumber'; - $employee = $locale->text('Salesperson'); - + $employee = $locale->text('Employee'); } if ($form->{type} eq 'sales_quotation') { @@ -1318,55 +619,17 @@ sub search { $employee = $locale->text('Employee'); } - if ($form->{type} =~ /(ship|receive)_order/) { - OE->get_warehouses(\%myconfig, \%$form); - - # warehouse - if (@{ $form->{all_warehouses} }) { - $form->{selectwarehouse} = "\n" } (@{ $form->{all_departments} }); } @@ -1377,52 +640,116 @@ sub search { | if $form->{selectdepartment}; - if ($form->{type} !~ /(ship_order|receive_order)/) { - $openclosed = qq| - - | - . $locale->text('Open') . qq| - {closed}> | - . $locale->text('Closed') . qq| - -|; - } else { - - $openclosed = qq| - + my $delivered; + if (($form->{"type"} eq "sales_order") || + ($form->{"type"} eq "purchase_order")) { + $delivered = qq| + + + + + + |; } # use JavaScript Calendar or not - $form->{jsscript} = $jscalendar; + $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", "BR", "trigger3", - "transdateto", "BL", "trigger4"); - } else { - # without JavaScript Calendar - $button1 = qq| - |; - $button2 = qq| - |; + $button1 = qq| + + text('button') . qq|> + |; + $button2 = qq| + + text('button') . qq|> + |; + $button3 = qq| + + text('button') . qq|> + |; + $button4 = qq| + + text('button') . qq|> + |; + + #write Trigger + $jsscript = + Form->write_trigger(\%myconfig, "4", "transdatefrom", "BR", "trigger3", + "transdateto", "BL", "trigger4", + "reqdatefrom", "BR", "trigger5", "reqdateto", "BL", "trigger6"); + + my $vc = $form->{vc} eq "customer" ? "customers" : "vendors"; + + $form->get_lists("projects" => { "key" => "ALL_PROJECTS", + "all" => 1 }, + "employees" => "ALL_EMPLOYEES", + "salesmen" => "ALL_SALESMEN", + $vc => "ALL_" . uc($vc) + ); + + my %labels = (); + my @values = (""); + foreach my $item (@{ $form->{"ALL_PROJECTS"} }) { + push(@values, $item->{"id"}); + $labels{$item->{"id"}} = $item->{"projectnumber"}; + } + my $projectnumber = + NTI($cgi->popup_menu('-name' => 'project_id', '-values' => \@values, + '-labels' => \%labels)); + + #employees + %labels = (); + @values = (""); + foreach my $item (@{ $form->{"ALL_EMPLOYEES"} }) { + push(@values, $item->{"id"}); + $labels{$item->{"id"}} = $item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}; + } + + #salesmen + my %labels_salesmen = (); + my @values_salesmen = (''); + foreach my $item (@{ $form->{"ALL_SALESMEN"} }) { + push(@values_salesmen, $item->{"id"}); + $labels_salesmen{$item->{"id"}} = $item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}; + } + + my $employee_block = qq| + + | . $locale->text('Employee') . qq| + | . NTI($cgi->popup_menu('-name' => 'employee_id', '-values' => \@values, '-labels' => \%labels)) . qq| + + + | . $locale->text('Salesman') . qq| + | . + NTI($cgi->popup_menu('-name' => 'salesman_id', + '-values' => \@values_salesmen, + '-labels' => \%labels_salesmen)) . qq| + + |; + + %labels = (); + @values = (""); + + foreach my $item (@{ $form->{($form->{vc} eq "customer" ? "ALL_CUSTOMERS" : "ALL_VENDORS")}}) { + push(@values, $item->{name}.qq|--|.$item->{"id"}); + $labels{$item->{name}.qq|--|.$item->{"id"}} = $item->{"name"}; } + my $vc_label = $form->{vc} eq "customer" ? $locale->text('Customer') : $locale->text('Vendor'); + $vc = + $myconfig{vclimit} <= scalar(@values) + ? qq|{vc}"} =~ /^(.*)\-\-.*$/)) . qq|" name="$form->{vc}">| + : NTI($cgi->popup_menu('-name' => "$form->{vc}", + '-default' => $form->{"old$form->{vc}"}, + '-onChange' => 'document.getElementById(\'update_button\').click();', + '-values' => \@values, + '-labels' => \%labels)); $form->header; print qq| @@ -1439,53 +766,72 @@ sub search { - + - $warehouse - $department +$department +$employee_block + + + + - - $button1 - - $button2 + + + + + $button1 + $button2 + + $button3 + $button4 + + @@ -1500,9 +846,6 @@ $jsscript
-{path}> -{login}> -{password}> {vc}> {type}> @@ -1517,384 +860,255 @@ $jsscript $lxdebug->leave_sub(); } -sub orders { +sub create_subtotal_row { $lxdebug->enter_sub(); - # split vendor / customer - ($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) = - split(/--/, $form->{ $form->{vc} }); + my ($totals, $columns, $column_alignment, $subtotal_columns, $class) = @_; - OE->transactions(\%myconfig, \%$form); + my $row = { map { $_ => { 'data' => '', 'class' => $class, 'align' => $column_alignment->{$_}, } } @{ $columns } }; - $ordnumber = ($form->{type} =~ /_order$/) ? "ordnumber" : "quonumber"; + map { $row->{$_}->{data} = $form->format_amount(\%myconfig, $totals->{$_}, 2) } @{ $subtotal_columns }; - $number = $form->escape($form->{$ordnumber}); - $name = $form->escape($form->{ $form->{vc} }); - $department = $form->escape($form->{department}); - $warehouse = $form->escape($form->{warehouse}); + $row->{tax}->{data} = $form->format_amount(\%myconfig, $totals->{amount} - $totals->{netamount}, 2); - # construct href - $href = - "$form->{script}?path=$form->{path}&action=orders&type=$form->{type}&vc=$form->{vc}&login=$form->{login}&password=$form->{password}&transdatefrom=$form->{transdatefrom}&transdateto=$form->{transdateto}&open=$form->{open}&closed=$form->{closed}&$ordnumber=$number&$form->{vc}=$name&department=$department&warehouse=$warehouse"; + map { $totals->{$_} = 0 } @{ $subtotal_columns }; - # construct callback - $number = $form->escape($form->{$ordnumber}, 1); - $name = $form->escape($form->{ $form->{vc} }, 1); - $department = $form->escape($form->{department}, 1); - $warehouse = $form->escape($form->{warehouse}, 1); + $lxdebug->leave_sub(); - $callback = - "$form->{script}?path=$form->{path}&action=orders&type=$form->{type}&vc=$form->{vc}&login=$form->{login}&password=$form->{password}&transdatefrom=$form->{transdatefrom}&transdateto=$form->{transdateto}&open=$form->{open}&closed=$form->{closed}&$ordnumber=$number&$form->{vc}=$name&department=$department&warehouse=$warehouse"; + return $row; +} - @columns = - $form->sort_columns("transdate", "reqdate", "id", "$ordnumber", - "name", "netamount", "tax", "amount", - "curr", "employee", "shipvia", "open", - "closed"); +sub orders { + $lxdebug->enter_sub(); - $form->{l_open} = $form->{l_closed} = "Y" - if ($form->{open} && $form->{closed}); + check_oe_access(); - foreach $item (@columns) { - if ($form->{"l_$item"} eq "Y") { - push @column_index, $item; + $ordnumber = ($form->{type} =~ /_order$/) ? "ordnumber" : "quonumber"; - # add column to href and callback - $callback .= "&l_$item=Y"; - $href .= "&l_$item=Y"; - } - } + ($form->{ $form->{vc} }, $form->{"${form->{vc}}_id"}) = split(/--/, $form->{ $form->{vc} }); + + report_generator_set_default_sort('transdate', 1); + + OE->transactions(\%myconfig, \%$form); + + $form->{rowcount} = scalar @{ $form->{OE} }; + + my @columns = ( + "transdate", "reqdate", + "id", $ordnumber, + "name", "netamount", + "tax", "amount", + "curr", "employee", + "salesman", + "shipvia", "globalprojectnumber", + "transaction_description", "open", + "delivered", "marge_total", "marge_percent" + ); # only show checkboxes if gotten here via sales_order form. - if ($form->{type} =~ /sales_order/) { - unshift @column_index, "ids"; + my $allow_multiple_orders = $form->{type} eq 'sales_order'; + if ($allow_multiple_orders) { + unshift @columns, "ids"; } - if ($form->{l_subtotal} eq 'Y') { - $callback .= "&l_subtotal=Y"; - $href .= "&l_subtotal=Y"; - } + $form->{l_open} = $form->{l_closed} = "Y" if ($form->{open} && $form->{closed}); + $form->{l_delivered} = "Y" if ($form->{delivered} && $form->{notdelivered}); + my $attachment_basename; if ($form->{vc} eq 'vendor') { - if ($form->{type} eq 'receive_order') { - $form->{title} = $locale->text('Receive Merchandise'); - } elsif ($form->{type} eq 'purchase_order') { - $form->{title} = $locale->text('Purchase Orders'); + if ($form->{type} eq 'purchase_order') { + $form->{title} = $locale->text('Purchase Orders'); + $attachment_basename = $locale->text('purchase_order_list'); } else { - $form->{title} = $locale->text('Request for Quotations'); + $form->{title} = $locale->text('Request for Quotations'); + $attachment_basename = $locale->text('rfq_list'); } - $name = $locale->text('Vendor'); - $employee = $locale->text('Employee'); - } - if ($form->{vc} eq 'customer') { + + } else { if ($form->{type} eq 'sales_order') { - $form->{title} = $locale->text('Sales Orders'); - $employee = $locale->text('Salesperson'); - } elsif ($form->{type} eq 'ship_order') { - $form->{title} = $locale->text('Ship Merchandise'); - $employee = $locale->text('Salesperson'); + $form->{title} = $locale->text('Sales Orders'); + $attachment_basename = $locale->text('sales_order_list'); } else { - $form->{title} = $locale->text('Quotations'); - $employee = $locale->text('Employee'); + $form->{title} = $locale->text('Quotations'); + $attachment_basename = $locale->text('quotation_list'); } - $name = $locale->text('Customer'); - } - - $column_header{id} = - qq||; - $column_header{transdate} = - qq||; - $column_header{reqdate} = - qq||; - $column_header{ordnumber} = - qq||; - $column_header{quonumber} = - qq||; - $column_header{name} = - qq||; - $column_header{netamount} = - qq||; - $column_header{tax} = - qq||; - $column_header{amount} = - qq||; - $column_header{curr} = - qq||; - $column_header{shipvia} = - qq||; - $column_header{open} = - qq||; - $column_header{closed} = - qq||; - - $column_header{employee} = - qq||; - - $column_header{ids} = qq||; - - if ($form->{ $form->{vc} }) { - $option = $locale->text(ucfirst $form->{vc}); - $option .= " : $form->{$form->{vc}}"; - } - if ($form->{warehouse}) { - ($warehouse) = split /--/, $form->{warehouse}; - $option .= "\n
" if ($option); - $option .= $locale->text('Warehouse'); - $option .= " : $warehouse"; - } - if ($form->{department}) { - $option .= "\n
" if ($option); - ($department) = split /--/, $form->{department}; - $option .= $locale->text('Department') . " : $department"; - } - if ($form->{transdatefrom}) { - $option .= "\n
" - . $locale->text('From') . " " - . $locale->date(\%myconfig, $form->{transdatefrom}, 1); - } - if ($form->{transdateto}) { - $option .= "\n
" - . $locale->text('Bis') . " " - . $locale->date(\%myconfig, $form->{transdateto}, 1); - } - if ($form->{open}) { - $option .= "\n
" if ($option); - $option .= $locale->text('Open'); - } - if ($form->{closed}) { - $option .= "\n
" if ($option); - $option .= $locale->text('Closed'); } - $form->header; - - print qq| - + my $report = SL::ReportGenerator->new(\%myconfig, $form); + + my @hidden_variables = map { "l_${_}" } @columns; + push @hidden_variables, "l_subtotal", $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered ordnumber quonumber + transaction_description transdatefrom transdateto type vc employee_id salesman_id + reqdatefrom reqdateto); + + my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables); + + my %column_defs = ( + 'ids' => { 'text' => '', }, + 'transdate' => { 'text' => $locale->text('Date'), }, + 'reqdate' => { 'text' => $locale->text('Required by'), }, + 'id' => { 'text' => $locale->text('ID'), }, + 'ordnumber' => { 'text' => $locale->text('Order'), }, + 'quonumber' => { 'text' => $form->{type} eq "request_quotation" ? $locale->text('RFQ') : $locale->text('Quotation'), }, + 'name' => { 'text' => $form->{vc} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), }, + 'netamount' => { 'text' => $locale->text('Amount'), }, + 'tax' => { 'text' => $locale->text('Tax'), }, + 'amount' => { 'text' => $locale->text('Total'), }, + 'curr' => { 'text' => $locale->text('Curr'), }, + 'employee' => { 'text' => $locale->text('Employee'), }, + 'salesman' => { 'text' => $locale->text('Salesman'), }, + 'shipvia' => { 'text' => $locale->text('Ship via'), }, + 'globalprojectnumber' => { 'text' => $locale->text('Project Number'), }, + 'transaction_description' => { 'text' => $locale->text('Transaction description'), }, + 'open' => { 'text' => $locale->text('Open'), }, + 'delivered' => { 'text' => $locale->text('Delivered'), }, + 'marge_total' => { 'text' => $locale->text('Ertrag'), }, + 'marge_percent' => { 'text' => $locale->text('Ertrag prozentual'), } + ); - -
$vclabel$vc_label $vc
$ordlabel
| . $locale->text('Transaction description') . qq|
| . $locale->text('From') . qq|| . $locale->text('Bis') . qq|| . $locale->text("Project Number") . qq|$projectnumber
| . $locale->text('Order Date') . " " . $locale->text('From') . qq|| . $locale->text('Bis') . qq|
| . $locale->text('Delivery Date') . " " . $locale->text('From') . qq|| . $locale->text('Bis') . qq|
| . $locale->text('Include in Report') . qq| - $openclosed + + + + + $delivered - + - - - + + + + + - + + + + + + + + + + + - - - + + - + +
- | . $locale->text('ID') . qq| | . $locale->text('ID') . qq| $ordlabel | - . $locale->text('Date') . qq| | - . $locale->text('Required by') . qq|
$vclabel | . $locale->text('Date') . qq| | . $locale->text('Required by') . qq|
$vc_label $employee | - . $locale->text('Ship via') . qq| | . $locale->text('Ship via') . qq|
| . $locale->text('Amount') . qq| | . $locale->text('Tax') . qq| | . $locale->text('Total') . qq|
| . $locale->text('Ertrag') . qq| | . $locale->text('Ertrag prozentual') . qq|
| - . $locale->text('Amount') . qq| | - . $locale->text('Tax') . qq| | - . $locale->text('Total') . qq| | . $locale->text('Project Number') . qq| | . $locale->text('Transaction description') . qq|
| - . $locale->text('Subtotal') . qq| | . $locale->text('Subtotal') . qq| | . $locale->text('Salesman') . qq|
| - . $locale->text('ID') - . qq|| - . $locale->text('Date') - . qq|| - . $locale->text('Required by') - . qq|| - . $locale->text('Order') - . qq|| - . $locale->text('Quotation') - . qq|$name| . $locale->text('Amount') . qq|| . $locale->text('Tax') . qq|| . $locale->text('Total') . qq|| . $locale->text('Curr') . qq|| - . $locale->text('Ship via') - . qq|| . $locale->text('O') . qq|| . $locale->text('C') . qq|$employee
- - - - - - - - - - - - -
$form->{title}
$option
- - |; + foreach my $name (qw(id transdate reqdate quonumber ordnumber name employee salesman shipvia transaction_description)) { + my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir}; + $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir"; + } + + my %column_alignment = map { $_ => 'right' } qw(netamount tax amount curr); + + $form->{"l_type"} = "Y"; + map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns; + $column_defs{ids}->{visible} = $allow_multiple_orders ? 'HTML' : 0; + + $report->set_columns(%column_defs); + $report->set_column_order(@columns); + $report->set_export_options('orders', @hidden_variables, qw(sort sortdir)); + $report->set_sort_indicator($form->{sort}, $form->{sortdir}); + + my @options; + my ($department) = split m/--/, $form->{department}; + + push @options, $locale->text('Customer') . " : $form->{customer}" if $form->{customer}; + push @options, $locale->text('Vendor') . " : $form->{vendor}" if $form->{vendor}; + push @options, $locale->text('Department') . " : $department" if $form->{department}; + push @options, $locale->text('Order Number') . " : $form->{ordnumber}" if $form->{ordnumber}; + push @options, $locale->text('Notes') . " : $form->{notes}" if $form->{notes}; + push @options, $locale->text('Transaction description') . " : $form->{transaction_description}" if $form->{transaction_description}; + if ( $form->{transdatefrom} or $form->{transdateto} ) { + push @options, $locale->text('Order Date'); + push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if $form->{transdatefrom}; + push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if $form->{transdateto}; + }; + if ( $form->{reqdatefrom} or $form->{reqdateto} ) { + push @options, $locale->text('Delivery Date'); + push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{reqdatefrom}, 1) if $form->{reqdatefrom}; + push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{reqdateto}, 1) if $form->{reqdateto}; + }; + push @options, $locale->text('Open') if $form->{open}; + push @options, $locale->text('Closed') if $form->{closed}; + push @options, $locale->text('Delivered') if $form->{delivered}; + push @options, $locale->text('Not delivered') if $form->{notdelivered}; + + $report->set_options('top_info_text' => join("\n", @options), + 'raw_top_info_text' => $form->parse_html_template('oe/orders_top'), + 'raw_bottom_info_text' => $form->parse_html_template('oe/orders_bottom', { 'SHOW_CONTINUE_BUTTON' => $allow_multiple_orders }), + 'output_format' => 'HTML', + 'title' => $form->{title}, + 'attachment_basename' => $attachment_basename . strftime('_%Y%m%d', localtime time), + ); + $report->set_options_from_form(); - map { print "\n$column_header{$_}" } @column_index; + # add sort and escape callback, this one we use for the add sub + $form->{callback} = $href .= "&sort=$form->{sort}"; - print qq| - -|; + # escape callback for href + $callback = $form->escape($href); - # add sort and escape callback - $callback_escaped = $form->escape($callback . "&sort=$form->{sort}"); + my @subtotal_columns = qw(netamount amount marge_total marge_percent); - if (@{ $form->{OE} }) { - $sameitem = $form->{OE}->[0]->{ $form->{sort} }; - } + my %totals = map { $_ => 0 } @subtotal_columns; + my %subtotals = map { $_ => 0 } @subtotal_columns; - $action = "edit"; - $action = "ship_receive" if ($form->{type} =~ /(ship|receive)_order/); + my $idx = 0; - $warehouse = $form->escape($form->{warehouse}); + my $edit_url = build_std_url('action=edit', 'type', 'vc'); foreach $oe (@{ $form->{OE} }) { - $form->{rowcount} = ++$j; - - if ($form->{l_subtotal} eq 'Y') { - if ($sameitem ne $oe->{ $form->{sort} }) { - &subtotal; - $sameitem = $oe->{ $form->{sort} }; - } - } - - map { $oe->{$_} *= $oe->{exchangerate} } (qw(netamount amount)); - - $column_data{netamount} = - ""; - $column_data{tax} = ""; - $column_data{amount} = - ""; - - $totalnetamount += $oe->{netamount}; - $totalamount += $oe->{amount}; - - $subtotalnetamount += $oe->{netamount}; - $subtotalamount += $oe->{amount}; - - $column_data{ids} = - qq||; - $column_data{id} = ""; - $column_data{transdate} = ""; - $column_data{reqdate} = ""; - - $column_data{$ordnumber} = - ""; - $column_data{name} = ""; - - $column_data{employee} = ""; - $column_data{shipvia} = ""; - - if ($oe->{closed}) { - $column_data{closed} = ""; - $column_data{open} = ""; - } else { - $column_data{closed} = ""; - $column_data{open} = ""; - } - - $i++; - $i %= 2; - print " - "; - - map { print "\n$column_data{$_}" } @column_index; - - print qq| - -|; - - } - - if ($form->{l_subtotal} eq 'Y') { - &subtotal; - } - - # print totals - print qq| - |; - - map { $column_data{$_} = "" } @column_index; + map { $oe->{$_} *= $oe->{exchangerate} } @subtotal_columns; - $column_data{netamount} = - ""; - $column_data{tax} = ""; - $column_data{amount} = - ""; + $oe->{tax} = $oe->{amount} - $oe->{netamount}; + $oe->{open} = $oe->{closed} ? $locale->text('No') : $locale->text('Yes'); + $oe->{delivered} = $oe->{delivered} ? $locale->text('Yes') : $locale->text('No'); - map { print "\n$column_data{$_}" } @column_index; + map { $subtotals{$_} += $oe->{$_}; + $totals{$_} += $oe->{$_} } @subtotal_columns; - print qq| - - -
" - . $form->format_amount(\%myconfig, $oe->{netamount}, 2, " ") - . "" - . $form->format_amount(\%myconfig, $oe->{amount} - $oe->{netamount}, - 2, " ") - . "" - . $form->format_amount(\%myconfig, $oe->{amount}, 2, " ") . "$oe->{id}$oe->{transdate} $oe->{reqdate} {path}&action=$action&type=$form->{type}&id=$oe->{id}&warehouse=$warehouse&vc=$form->{vc}&login=$form->{login}&password=$form->{password}&callback=$callback_escaped>$oe->{$ordnumber}$oe->{name}$oe->{employee} $oe->{shipvia} X  X
 " - . $form->format_amount(\%myconfig, $totalnetamount, 2, " ") . "" - . $form->format_amount(\%myconfig, $totalamount - $totalnetamount, - 2, " ") - . "" - . $form->format_amount(\%myconfig, $totalamount, 2, " ") . "
-

|; + $subtotals{marge_percent} = $subtotals{netamount} ? ($subtotals{marge_total} * 100 / $subtotals{netamount}) : 0; + $totals{marge_percent} = $totals{netamount} ? ($totals{marge_total} * 100 / $totals{netamount} ) : 0; - # multiple invoice edit button only if gotten there via sales_order form. + map { $oe->{$_} = $form->format_amount(\%myconfig, $oe->{$_}, 2) } qw(netamount tax amount marge_total marge_percent); - if ($form->{type} =~ /sales_order/) { - print qq| - - - - - - - - - - |; - } + my $row = { }; - print qq| - + foreach my $column (@columns) { + next if ($column eq 'ids'); + $row->{$column} = { + 'data' => $oe->{$column}, + 'align' => $column_alignment{$column}, + }; + } -
-
{script}> + $row->{ids} = { + 'raw_data' => $cgi->hidden('-name' => "trans_id_${idx}", '-value' => $oe->{id}) + . $cgi->checkbox('-name' => "multi_id_${idx}", '-value' => 1, '-label' => ''), + 'valign' => 'center', + 'align' => 'center', + }; - + $row->{$ordnumber}->{link} = $edit_url . "&id=" . E($oe->{id}) . "&callback=${callback}"; -{type}> -{vc}> + my $row_set = [ $row ]; -{path}> -{login}> -{password}> -|; + if (($form->{l_subtotal} eq 'Y') + && (($idx == (scalar @{ $form->{OE} } - 1)) + || ($oe->{ $form->{sort} } ne $form->{OE}->[$idx + 1]->{ $form->{sort} }))) { + push @{ $row_set }, create_subtotal_row(\%subtotals, \@columns, \%column_alignment, \@subtotal_columns, 'listsubtotal'); + } - if ($form->{type} !~ /(ship|receive)_order/) { - print qq| -|; - } + $report->add_data($row_set); - if ($form->{menubar}) { - require "$form->{path}/menu.pl"; - &menubar; + $idx++; } - print qq| -
+ $report->add_separator(); + $report->add_data(create_subtotal_row(\%totals, \@columns, \%column_alignment, \@subtotal_columns, 'listtotal')); - - -|; + $report->generate_with_headers(); $lxdebug->leave_sub(); } -sub subtotal { +sub check_delivered_flag { $lxdebug->enter_sub(); - map { $column_data{$_} = " " } @column_index; + check_oe_access(); - $column_data{netamount} = - "" - . $form->format_amount(\%myconfig, $subtotalnetamount, 2, " ") - . ""; - $column_data{tax} = "" - . $form->format_amount(\%myconfig, $subtotalamount - $subtotalnetamount, - 2, " ") - . ""; - $column_data{amount} = - "" - . $form->format_amount(\%myconfig, $subtotalamount, 2, " ") . ""; + if (($form->{type} ne 'sales_order') && ($form->{type} ne 'purchase_order')) { + return $lxdebug->leave_sub(); + } - $subtotalnetamount = 0; - $subtotalamount = 0; + my $all_delivered = 0; - print " - -"; + foreach my $i (1 .. $form->{rowcount}) { + next if (!$form->{"id_$i"}); - map { print "\n$column_data{$_}" } @column_index; + if ($form->parse_amount(\%myconfig, $form->{"qty_$i"}) == $form->parse_amount(\%myconfig, $form->{"ship_$i"})) { + $all_delivered = 1; + next; + } - print qq| - -|; + $all_delivered = 0; + last; + } + + $form->{delivered} = 1 if $all_delivered; $lxdebug->leave_sub(); } @@ -1902,12 +1116,20 @@ sub subtotal { sub save_and_close { $lxdebug->enter_sub(); + check_oe_access(); + + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); + if ($form->{type} =~ /_order$/) { $form->isblank("transdate", $locale->text('Order Date missing!')); } else { $form->isblank("transdate", $locale->text('Quotation Date missing!')); } + my $idx = $form->{type} =~ /_quotation$/ ? "quonumber" : "ordnumber"; + $form->{$idx} =~ s/^\s*//g; + $form->{$idx} =~ s/\s*$//g; + $msg = ucfirst $form->{vc}; $form->isblank($form->{vc}, $locale->text($msg . " missing!")); @@ -1919,8 +1141,15 @@ sub save_and_close { &validate_items; + if($form->{payment_id}) { + $payment_id = $form->{payment_id}; + } + # if the name changed get new values if (&check_name($form->{vc})) { + if($form->{payment_id} eq "") { + $form->{payment_id} = $payment_id; + } &update; exit; } @@ -1943,6 +1172,8 @@ sub save_and_close { $err = $locale->text('Cannot save order!'); + check_delivered_flag(); + } else { if ($form->{type} eq 'sales_quotation') { $form->{label} = $locale->text('Quotation'); @@ -1967,10 +1198,18 @@ sub save_and_close { relink_accounts(); - $form->redirect( - $form->{label} . " $form->{$ordnumber} " . $locale->text('saved!')) - if (OE->save(\%myconfig, \%$form)); - $form->error($err); + $form->error($err) if (!OE->save(\%myconfig, \%$form)); + + # saving the history + if(!exists $form->{addition}) { + $form->{snumbers} = qq|ordnumber_| . $form->{ordnumber}; + $form->{addition} = "SAVED"; + $form->save_history($form->dbconnect(\%myconfig)); + } + # /saving the history + + $form->redirect($form->{label} . " $form->{$ordnumber} " . + $locale->text('saved!')); $lxdebug->leave_sub(); } @@ -1978,12 +1217,21 @@ sub save_and_close { sub save { $lxdebug->enter_sub(); + check_oe_access(); + + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); + + if ($form->{type} =~ /_order$/) { $form->isblank("transdate", $locale->text('Order Date missing!')); } else { $form->isblank("transdate", $locale->text('Quotation Date missing!')); } + my $idx = $form->{type} =~ /_quotation$/ ? "quonumber" : "ordnumber"; + $form->{$idx} =~ s/^\s*//g; + $form->{$idx} =~ s/\s*$//g; + $msg = ucfirst $form->{vc}; $form->isblank($form->{vc}, $locale->text($msg . " missing!")); @@ -1995,8 +1243,15 @@ sub save { &validate_items; + if($form->{payment_id}) { + $payment_id = $form->{payment_id}; + } + # if the name changed get new values if (&check_name($form->{vc})) { + if($form->{payment_id} eq "") { + $form->{payment_id} = $payment_id; + } &update; exit; } @@ -2019,6 +1274,8 @@ sub save { $err = $locale->text('Cannot save order!'); + check_delivered_flag(); + } else { if ($form->{type} eq 'sales_quotation') { $form->{label} = $locale->text('Quotation'); @@ -2042,6 +1299,15 @@ sub save { relink_accounts(); OE->save(\%myconfig, \%$form); + + # saving the history + if(!exists $form->{addition}) { + $form->{snumbers} = qq|ordnumber_| . $form->{ordnumber}; + $form->{addition} = "SAVED"; + $form->save_history($form->dbconnect(\%myconfig)); + } + # /saving the history + $form->{simple_save} = 1; if(!$form->{print_and_save}) { set_headings("edit"); @@ -2054,6 +1320,8 @@ sub save { sub delete { $lxdebug->enter_sub(); + check_oe_access(); + $form->header; if ($form->{type} =~ /_order$/) { @@ -2074,6 +1342,7 @@ sub delete { map { delete $form->{$_} } qw(action header); foreach $key (keys %$form) { + next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key})); $form->{$key} =~ s/\"/"/g; print qq|\n|; } @@ -2083,8 +1352,11 @@ sub delete {

$msg $form->{$ordnumber}

+ + @@ -2094,9 +1366,11 @@ sub delete { $lxdebug->leave_sub(); } -sub yes { +sub delete_order_quotation { $lxdebug->enter_sub(); + check_oe_access(); + if ($form->{type} =~ /_order$/) { $msg = $locale->text('Order deleted!'); $err = $locale->text('Cannot delete order!'); @@ -2104,8 +1378,17 @@ sub yes { $msg = $locale->text('Quotation deleted!'); $err = $locale->text('Cannot delete quotation!'); } - - $form->redirect($msg) if (OE->delete(\%myconfig, \%$form, $spool)); + if (OE->delete(\%myconfig, \%$form, $spool)){ + # saving the history + if(!exists $form->{addition}) { + $form->{snumbers} = qq|ordnumber_| . $form->{ordnumber}; + $form->{addition} = "DELETED"; + $form->save_history($form->dbconnect(\%myconfig)); + } + # /saving the history + $form->info($msg); + exit(); + } $form->error($err); $lxdebug->leave_sub(); @@ -2114,33 +1397,48 @@ sub yes { sub invoice { $lxdebug->enter_sub(); + check_oe_access(); + $auth->assert($form->{type} eq 'purchase_order' || $form->{type} eq 'request_quotation' ? 'vendor_invoice_edit' : 'invoice_edit'); + + $form->{old_employee_id} = $form->{employee_id}; + $form->{old_salesman_id} = $form->{salesman_id}; + if ($form->{type} =~ /_order$/) { # these checks only apply if the items don't bring their own ordnumbers/transdates. # The if clause ensures that by searching for empty ordnumber_#/transdate_# fields. $form->isblank("ordnumber", $locale->text('Order Number missing!')) - if (+{ map { $form->{"ordnumber_$_"}, 1 } (1 .. $form->{rowcount} - 1) } - ->{''}); + if (+{ map { $form->{"ordnumber_$_"}, 1 } (1 .. $form->{rowcount} - 1) }->{''}); $form->isblank("transdate", $locale->text('Order Date missing!')) - if (+{ map { $form->{"transdate_$_"}, 1 } (1 .. $form->{rowcount} - 1) } - ->{''}); + if (+{ map { $form->{"transdate_$_"}, 1 } (1 .. $form->{rowcount} - 1) }->{''}); # also copy deliverydate from the order $form->{deliverydate} = $form->{reqdate} if $form->{reqdate}; + $form->{orddate} = $form->{transdate}; } else { $form->isblank("quonumber", $locale->text('Quotation Number missing!')); $form->isblank("transdate", $locale->text('Quotation Date missing!')); - $form->{ordnumber} = ""; + $form->{ordnumber} = ""; + $form->{quodate} = $form->{transdate}; } + $payment_id = $form->{payment_id} if $form->{payment_id}; + # if the name changed get new values if (&check_name($form->{vc})) { + $form->{payment_id} = $payment_id if $form->{payment_id} eq ""; &update; exit; } $form->{cp_id} *= 1; + for $i (1 .. $form->{rowcount}) { + for (qw(ship qty sellprice listprice basefactor)) { + $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"}; + } + } + if ( $form->{type} =~ /_order/ && $form->{currency} ne $form->{defaultcurrency}) { @@ -2148,9 +1446,7 @@ sub invoice { $buysell = ($form->{type} eq 'sales_order') ? "buy" : "sell"; $orddate = $form->current_date(\%myconfig); - $exchangerate = - $form->check_exchangerate(\%myconfig, $form->{currency}, $orddate, - $buysell); + $exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $orddate, $buysell); if (!$exchangerate) { &backorder_exchangerate($orddate, $buysell); @@ -2158,27 +1454,14 @@ sub invoice { } } - # close orders/quotations - $form->{closed} = 1; + $form->{convert_from_oe_ids} = $form->{id}; + $form->{transdate} = $form->{invdate} = $form->current_date(\%myconfig); + $form->{duedate} = $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1); + $form->{shipto} = 1; + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); - # save order if one ordnumber has been given - # if not it's most likely a collective order, which can't be saved back - # so they just have to be closed - if (($form->{ordnumber} ne '') || ($form->{quonumber} ne '')) { - relink_accounts(); - OE->save(\%myconfig, \%$form); - } else { - OE->close_orders(\%myconfig, \%$form); - } - - $form->{transdate} = $form->{invdate} = $form->current_date(\%myconfig); - $form->{duedate} = - $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1); - - $form->{id} = ''; - $form->{closed} = 0; + delete @{$form}{qw(id closed)}; $form->{rowcount}--; - $form->{shipto} = 1; if ($form->{type} =~ /_order$/) { $form->{exchangerate} = $exchangerate; @@ -2192,7 +1475,9 @@ sub invoice { $script = "ir"; $buysell = 'sell'; } - if ($form->{type} eq 'sales_order' || $form->{type} eq 'sales_quotation') { + + if ( $form->{type} eq 'sales_order' + || $form->{type} eq 'sales_quotation') { $form->{title} = $locale->text('Add Sales Invoice'); $form->{script} = 'is.pl'; $script = "is"; @@ -2200,34 +1485,23 @@ sub invoice { } # bo creates the id, reset it - map { delete $form->{$_} } - qw(id subject message cc bcc printed emailed queued); + map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued); $form->{ $form->{vc} } =~ s/--.*//g; $form->{type} = "invoice"; # locale messages $locale = new Locale "$myconfig{countrycode}", "$script"; - require "$form->{path}/$form->{script}"; + require "bin/mozilla/$form->{script}"; map { $form->{"select$_"} = "" } ($form->{vc}, currency); - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } - qw(creditlimit creditremaining); - $currency = $form->{currency}; &invoice_links; $form->{currency} = $currency; - $form->{exchangerate} = ""; - $form->{forex} = ""; - $form->{exchangerate} = $exchangerate - if ( - $form->{forex} = ( - $exchangerate = - $form->check_exchangerate( - \%myconfig, $form->{currency}, $form->{invdate}, $buysell - ))); + $form->{forex} = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{invdate}, $buysell); + $form->{exchangerate} = $form->{forex} || ''; $form->{creditremaining} -= ($form->{oldinvtotal} - $form->{ordtotal}); @@ -2267,6 +1541,9 @@ sub invoice { sub backorder_exchangerate { $lxdebug->enter_sub(); + + check_oe_access(); + my ($orddate, $buysell) = @_; $form->header; @@ -2281,6 +1558,7 @@ sub backorder_exchangerate { map { delete $form->{$_} } qw(action header exchangerate); foreach $key (keys %$form) { + next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key})); $form->{$key} =~ s/\"/"/g; print qq|\n|; } @@ -2289,10 +1567,6 @@ sub backorder_exchangerate { print qq| -{path}> -{login}> -{password}> - @@ -2418,730 +1692,295 @@ sub create_backorder { sub save_as_new { $lxdebug->enter_sub(); + check_oe_access(); + $form->{saveasnew} = 1; $form->{closed} = 0; - map { delete $form->{$_} } qw(printed emailed queued ordnumber quonumber); + map { delete $form->{$_} } qw(printed emailed queued); + + # Let Lx-Office assign a new order number if the user hasn't changed the + # previous one. If it has been changed manually then use it as-is. + my $idx = $form->{type} =~ /_quotation$/ ? "quonumber" : "ordnumber"; + $form->{$idx} =~ s/^\s*//g; + $form->{$idx} =~ s/\s*$//g; + if ($form->{saved_xyznumber} && + ($form->{saved_xyznumber} eq $form->{$idx})) { + delete($form->{$idx}); + } &save; $lxdebug->leave_sub(); } -sub purchase_order { +sub check_for_direct_delivery_yes { $lxdebug->enter_sub(); - if ( $form->{type} eq 'sales_quotation' - || $form->{type} eq 'request_quotation') { - $form->{closed} = 1; - relink_accounts(); - OE->save(\%myconfig, \%$form); - } - - $form->{cp_id} *= 1; - - $form->{title} = $locale->text('Add Purchase Order'); - $form->{vc} = "vendor"; - $form->{type} = "purchase_order"; - - &poso; + check_oe_access(); + $form->{direct_delivery_checked} = 1; + delete @{$form}{grep /^shipto/, keys %{ $form }}; + map { s/^CFDD_//; $form->{$_} = $form->{"CFDD_${_}"} } grep /^CFDD_/, keys %{ $form }; + $form->{shipto} = 1; + purchase_order(); $lxdebug->leave_sub(); } -sub sales_order { +sub check_for_direct_delivery_no { $lxdebug->enter_sub(); - if ( $form->{type} eq 'sales_quotation' - || $form->{type} eq 'request_quotation') { - OE->close_order(\%myconfig, $form); - } - - $form->{cp_id} *= 1; + check_oe_access(); - $form->{title} = $locale->text('Add Sales Order'); - $form->{vc} = "customer"; - $form->{type} = "sales_order"; - - &poso; + $form->{direct_delivery_checked} = 1; + delete @{$form}{grep /^shipto/, keys %{ $form }}; + purchase_order(); $lxdebug->leave_sub(); } -sub poso { +sub check_for_direct_delivery { $lxdebug->enter_sub(); - $form->{transdate} = $form->current_date(\%myconfig); - delete $form->{duedate}; - - $form->{closed} = 0; + check_oe_access(); - # reset - map { delete $form->{$_} } - qw(id subject message cc bcc printed emailed queued customer vendor creditlimit creditremaining discount tradediscount oldinvtotal); - - for $i (1 .. $form->{rowcount}) { - map({ $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, - $form->{"${_}_${i}"}) - if ($form->{"${_}_${i}"}) } - qw(ship qty sellprice listprice basefactor)); + if ($form->{direct_delivery_checked} + || (!$form->{shiptoname} && !$form->{shiptostreet} && !$form->{shipto_id})) { + $lxdebug->leave_sub(); + return; } - &order_links; - - &prepare_order; + if ($form->{shipto_id}) { + Common->get_shipto_by_id(\%myconfig, $form, $form->{shipto_id}, "CFDD_"); - # format amounts - for $i (1 .. $form->{rowcount} - 1) { - map { $form->{"${_}_$i"} =~ s/\"/"/g } - qw(partnumber description unit); + } else { + map { $form->{"CFDD_${_}"} = $form->{$_ } } grep /^shipto/, keys %{ $form }; } - map { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, 0, "0") } - qw(creditlimit creditremaining); + delete $form->{action}; + $form->{VARIABLES} = [ map { { "key" => $_, "value" => $form->{$_} } } grep { ($_ ne 'login') && ($_ ne 'password') && (ref $_ eq "") } keys %{ $form } ]; - &update; + $form->header(); + print $form->parse_html_template("oe/check_for_direct_delivery"); $lxdebug->leave_sub(); + + exit 0; } -sub ship_receive { +sub purchase_order { $lxdebug->enter_sub(); - &order_links; - - &prepare_order; - - OE->get_warehouses(\%myconfig, \%$form); - - # warehouse - if (@{ $form->{all_warehouses} }) { - $form->{selectwarehouse} = "

{script}> - -{id}> - - - -{type}> -{media}> -{format}> - - - - - -{vc}> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -|; + $form->{cp_id} *= 1; - @column_index = - (partnumber, description, qty, ship, unit, bin, serialnumber); - - if ($form->{type} eq "ship_order") { - $column_data{ship} = - qq||; - } - if ($form->{type} eq "receive_order") { - $column_data{ship} = - qq||; - } - - my $colspan = $#column_index + 1; - - $column_data{partnumber} = - qq||; - $column_data{description} = - qq||; - $column_data{qty} = - qq||; - $column_data{unit} = - qq||; - $column_data{bin} = - qq||; - $column_data{serialnumber} = - qq||; + $form->{title} = $locale->text('Add Sales Order'); + $form->{vc} = "customer"; + $form->{type} = "sales_order"; - print qq| - - - - - - - - - -
$form->{title}
- - - - - -
- - - - - {vc} value="$form->{$form->{vc}}"> - {"$form->{vc}_id"}> - - $department - - - - - - - $warehouse -
$vclabel$form->{$form->{vc}}
| . $locale->text('Shipping Point') . qq| - -
| . $locale->text('Ship via') . qq| - -
-
- - $employee - - - - - - - - - {transdate}> - - - - - -
| . $locale->text('Order Number') . qq|$form->{ordnumber}
| . $locale->text('Order Date') . qq|$form->{transdate}
$shipped{shippingdate}>
-
-
| - . $locale->text('Ship') - . qq|| - . $locale->text('Recd') - . qq|| . $locale->text('Number') . qq|| - . $locale->text('Description') - . qq|| . $locale->text('Qty') . qq|| . $locale->text('Unit') . qq|| . $locale->text('Bin') . qq|| - . $locale->text('Serial No.') - . qq|
- - |; + &poso; - map { print "\n$column_data{$_}" } @column_index; + $lxdebug->leave_sub(); +} - print qq| - -|; +sub poso { + $lxdebug->enter_sub(); - for $i (1 .. $form->{rowcount} - 1) { + check_oe_access(); + $auth->assert('purchase_order_edit | sales_order_edit'); - # undo formatting - $form->{"ship_$i"} = $form->parse_amount(\%myconfig, $form->{"ship_$i"}); + $form->{transdate} = $form->current_date(\%myconfig); + delete $form->{duedate}; - # convert " to " - map { $form->{"${_}_$i"} =~ s/\"/"/g } - qw(partnumber description unit bin serialnumber); - - $description = $form->{"description_$i"}; - $description =~ s/\n/
/g; - - $column_data{partnumber} = - qq||; - $column_data{description} = - qq||; - $column_data{qty} = - qq||; - $column_data{ship} = - qq||; - $column_data{unit} = - qq||; - $column_data{bin} = - qq||; - - $column_data{serialnumber} = - qq||; - - print qq| - |; - - map { print "\n$column_data{$_}" } @column_index; - - print qq| - + $form->{convert_from_oe_ids} = $form->{id}; + $form->{closed} = 0; -{"orderitems_id_$i"}> -{"id_$i"}> - - + $form->{old_employee_id} = $form->{employee_id}; + $form->{old_salesman_id} = $form->{salesman_id}; -|; + # reset + map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued customer vendor creditlimit creditremaining discount tradediscount oldinvtotal delivered + ordnumber); + for $i (1 .. $form->{rowcount}) { + map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if ($form->{"${_}_${i}"}) } qw(ship qty sellprice listprice basefactor); } - print qq| -
$form->{"partnumber_$i"}$description| - . $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty) - . qq|format_amount(\%myconfig, $form->{"ship_$i"}) - . qq|>$form->{"unit_$i"}$form->{"bin_$i"}
-

-|; - - $form->{copies} = 1; - - &print_options; - - print qq| -
-
- - -|; + my %saved_vars = map { $_ => $form->{$_} } grep { $form->{$_} } qw(currency); - if ($form->{type} eq 'ship_order') { - print qq| - - -|; - } + &order_links; - print qq| + map { $form->{$_} = $saved_vars{$_} } keys %saved_vars; - -|; + &prepare_order; - if ($form->{menubar}) { - require "$form->{path}/menu.pl"; - &menubar; + # format amounts + for $i (1 .. $form->{rowcount} - 1) { + map { $form->{"${_}_$i"} =~ s/\"/"/g } qw(partnumber description unit); } - print qq| - -{rowcount}> - - - -{path}> -{login}> -{password}> - -
- - - -|; + &update; $lxdebug->leave_sub(); } -sub done { +sub delivery_order { $lxdebug->enter_sub(); - if ($form->{type} eq 'ship_order') { - $form->isblank("shippingdate", $locale->text('Shipping Date missing!')); - } else { - $form->isblank("shippingdate", $locale->text('Date received missing!')); - } + if ($form->{type} =~ /^sales/) { + $auth->assert('sales_delivery_order_edit'); - $total = 0; - map { - $total += $form->{"ship_$_"} = - $form->parse_amount(\%myconfig, $form->{"ship_$_"}) - } (1 .. $form->{rowcount} - 1); + $form->{vc} = 'customer'; + $form->{type} = 'sales_delivery_order'; - $form->error($locale->text('Nothing entered!')) unless $total; + } else { + $auth->assert('purchase_delivery_order_edit'); - $form->redirect($locale->text('Inventory saved!')) - if OE->save_inventory(\%myconfig, \%$form); - $form->error($locale->text('Could not save!')); + $form->{vc} = 'vendor'; + $form->{type} = 'purchase_delivery_order'; + } - $lxdebug->leave_sub(); -} + require "bin/mozilla/do.pl"; -sub search_transfer { - $lxdebug->enter_sub(); + $form->{cp_id} *= 1; + $form->{convert_from_oe_ids} = $form->{id}; + $form->{transdate} = $form->current_date(\%myconfig); + delete $form->{duedate}; - OE->get_warehouses(\%myconfig, \%$form); + $form->{old_employee_id} = $form->{employee_id}; + $form->{old_salesman_id} = $form->{salesman_id}; - # warehouse - if (@{ $form->{all_warehouses} }) { - $form->{selectwarehouse} = "