X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Foe.pl;h=eb5772ef8571443c3ee2505dce80a0c908029d56;hb=6dc16826718038718653bb07b130299fe2366e45;hp=91e178dc589ca4c0425a3269a1dda954a7ddc7e9;hpb=4dbb09950c9f5596646537c12d991c99086fe7c1;p=kivitendo-erp.git diff --git a/bin/mozilla/oe.pl b/bin/mozilla/oe.pl index 91e178dc5..eb5772ef8 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,7 +30,7 @@ # Order entry module # Quotation module #====================================================================== - +use Data::Dumper; use SL::OE; use SL::IR; @@ -41,31 +41,66 @@ require "$form->{path}/io.pl"; require "$form->{path}/arap.pl"; 1; + # end of main +# For locales.pl: +# $locale->text('Edit the purchase_order'); +# $locale->text('Edit the sales_order'); +# $locale->text('Edit the request_quotation'); +# $locale->text('Edit the sales_quotation'); -sub add { +# $locale->text('Workflow purchase_order'); +# $locale->text('Workflow sales_order'); +# $locale->text('Workflow request_quotation'); +# $locale->text('Workflow sales_quotation'); + +sub set_headings { $lxdebug->enter_sub(); + my ($action) = @_; + if ($form->{type} eq 'purchase_order') { - $form->{title} = $locale->text('Add Purchase Order'); - $form->{vc} = 'vendor'; + $form->{title} = $action eq "edit" ? + $locale->text('Edit Purchase Order') : + $locale->text('Add Purchase Order'); + $form->{heading} = $locale->text('Purchase Order'); + $form->{vc} = 'vendor'; } if ($form->{type} eq 'sales_order') { - $form->{title} = $locale->text('Add Sales Order'); - $form->{vc} = 'customer'; + $form->{title} = $action eq "edit" ? + $locale->text('Edit Sales Order') : + $locale->text('Add Sales Order'); + $form->{heading} = $locale->text('Sales Order'); + $form->{vc} = 'customer'; } if ($form->{type} eq 'request_quotation') { - $form->{title} = $locale->text('Add Request for Quotation'); - $form->{vc} = 'vendor'; + $form->{title} = $action eq "edit" ? + $locale->text('Edit Request for Quotation') : + $locale->text('Add Request for Quotation'); + $form->{heading} = $locale->text('Request for Quotation'); + $form->{vc} = 'vendor'; } if ($form->{type} eq 'sales_quotation') { - $form->{title} = $locale->text('Add Quotation'); - $form->{vc} = 'customer'; + $form->{title} = $action eq "edit" ? + $locale->text('Edit Quotation') : + $locale->text('Add Quotation'); + $form->{heading} = $locale->text('Quotation'); + $form->{vc} = 'customer'; } - $form->{callback} = "$form->{script}?action=add&type=$form->{type}&vc=$form->{vc}&login=$form->{login}&path=$form->{path}&password=$form->{password}" unless $form->{callback}; - + $lxdebug->leave_sub(); +} + +sub add { + $lxdebug->enter_sub(); + + set_headings("add"); + + $form->{callback} = + "$form->{script}?action=add&type=$form->{type}&vc=$form->{vc}&login=$form->{login}&path=$form->{path}&password=$form->{password}" + unless $form->{callback}; + &order_links; &prepare_order; &display_form; @@ -73,89 +108,150 @@ sub add { $lxdebug->leave_sub(); } - sub edit { $lxdebug->enter_sub(); - if ($form->{type} eq 'purchase_order') { - $form->{title} = $locale->text('Edit Purchase Order'); - $form->{heading} = $locale->text('Purchase Order'); - $form->{vc} = 'vendor'; - } - if ($form->{type} eq 'sales_order') { - $form->{title} = $locale->text('Edit Sales Order'); - $form->{heading} = $locale->text('Sales Order'); - $form->{vc} = 'customer'; - } - if ($form->{type} eq 'request_quotation') { - $form->{title} = $locale->text('Edit Request for Quotation'); - $form->{heading} = $locale->text('Request for Quotation'); - $form->{vc} = 'vendor'; + $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 (!$id) { + + # reset rowcount + undef $form->{rowcount}; + &add; + return; + } + } else { + if (!$form->{id}) { + &add; + return; + } } - if ($form->{type} eq 'sales_quotation') { - $form->{title} = $locale->text('Edit Quotation'); - $form->{heading} = $locale->text('Quotation'); - $form->{vc} = 'customer'; + + if ($form->{print_and_save}) { + $form->{action} = "print"; + $form->{resubmit} = 1; + $language_id = $form->{language_id}; + $printer_id = $form->{printer_id}; } - + + set_headings("edit"); + &order_links; &prepare_order; + if ($form->{print_and_save}) { + $form->{language_id} = $language_id; + $form->{printer_id} = $printer_id; + } &display_form; - + $lxdebug->leave_sub(); } - - sub order_links { $lxdebug->enter_sub(); + # 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); + 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}; + } + + + # 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!') + ); + } + $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}; } } - - $cp_id = $form->{cp_id}; - $intnotes=$form->{intnotes}; + + $cp_id = $form->{cp_id}; + $intnotes = $form->{intnotes}; + # get customer / vendor - if ($form->{type} =~ /(purchase_order|request_quotation|receive_order)/ ) { + 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}); + } + } $form->{cp_id} = $cp_id; - - $form->{intnotes}=$intnotes; - ($form->{$form->{vc}}) = split /--/, $form->{$form->{vc}}; - $form->{"old$form->{vc}"} = qq|$form->{$form->{vc}}--$form->{"$form->{vc}_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"}|; # build the popup menus 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}) { - if ($form->{jsscript}) - { # with JavaScript Calendar $button1 = qq| {transdate}> - text('button').qq|> + text('button') . qq|> |; - $button2 = qq| + $button2 = qq| {reqdate}> - text('button').qq|> + text('button') . qq|> |; + #write Trigger - $jsscript = Form->write_trigger(\%myconfig,"2","transdate","BL","trigger1","reqdate","BL","trigger2"); + $jsscript = + Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", + "reqdate", "BL", "trigger2"); - } - else - { - # without JavaScript Calendar - $button1 = qq| + } else { + + # without JavaScript Calendar + $button1 = qq| {transdate}>|; - $button2 = qq| + $button2 = qq| {reqdate}>|; - } - - + } + if ($form->{id}) { $openclosed = qq| - - + +
|.$locale->text('Open').qq| |.$locale->text('Closed').qq| | + . $locale->text('Open') . qq| | + . $locale->text('Closed') . qq|
@@ -264,121 +395,229 @@ sub form_header { } # set option selected - foreach $item ($form->{vc}, currency, department, employee, contact) { + 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}/; + $form->{"select$item"} =~ + s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; } + #quote select[customer|vendor] Bug 133 + $form->{"select$form->{vc}"} = $form->quote($form->{"select$form->{vc}"}); + #build contacts if ($form->{all_contacts}) { - - $form->{selectcontact} = ""; - foreach $item (@{$form->{all_contacts}}) { - if ($form->{cp_id} == $item->{cp_id}) - { - $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/; + } + } + + + if (@{ $form->{SHIPTO} }) { + $form->{selectshipto} = ""; + foreach $item (@{ $form->{SHIPTO} }) { + if ($item->{shipto_id} == $form->{shipto_id}) { + $form->{selectshipto} .= + ""; + } else { + $form->{selectshipto} .= + ""; } - } - - $form->{exchangerate} = $form->format_amount(\%myconfig, $form->{exchangerate}); - - $form->{creditlimit} = $form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0"); - $form->{creditremaining} = $form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0"); - - $contact = ($form->{selectcontact}) ? qq|\n| : qq||; - + + } + } else { + $form->{selectshipto} =~ s/ selected//g; + if ($form->{shipto_id} ne "") { + $form->{selectshipto} =~ s/value=$form->{shipto_id}/value=$form->{shipto_id} selected/; + } + } + + $shipto = qq| + | . $locale->text('Shipping Address') . qq| + + |; + + + + + $form->{exchangerate} = + $form->format_amount(\%myconfig, $form->{exchangerate}); + + if (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) { + $creditwarning = 1; + } else { + $creditwarning = 0; + } + + $form->{creditlimit} = + $form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0"); + $form->{creditremaining} = + $form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0"); + + $contact = + ($form->{selectcontact}) + ? qq|\n| + : qq||; + $exchangerate = qq| {forex}> |; if ($form->{currency} ne $form->{defaultcurrency}) { if ($form->{forex}) { - $exchangerate .= qq||.$locale->text('Exchangerate').qq|$form->{exchangerate} + $exchangerate .= + qq|| + . $locale->text('Exchangerate') + . qq|$form->{exchangerate} {exchangerate}> |; } else { - $exchangerate .= qq||.$locale->text('Exchangerate').qq|{exchangerate}>|; + $exchangerate .= + qq|| + . $locale->text('Exchangerate') + . qq|{exchangerate}>|; } } - $vclabel = ucfirst $form->{vc}; $vclabel = $locale->text($vclabel); $terms = qq| - |.$locale->text('Terms: Net').qq| - {terms}> |.$locale->text('days').qq| + | . $locale->text('Terms: Net') . qq| + {terms}> | + . $locale->text('days') . qq| |; - if ($form->{business}) { $business = qq| - |.$locale->text('Business').qq| + | . $locale->text('Business') . qq| $form->{business} - |.$locale->text('Trade Discount').qq| - |.$form->format_amount(\%myconfig, $form->{tradediscount} * 100).qq| % + | . $locale->text('Trade Discount') . qq| + | + . $form->format_amount(\%myconfig, $form->{tradediscount} * 100) + . qq| % |; } + 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} .= + ""; + } + + } + } 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| + + + |; + if ($form->{type} !~ /_quotation$/) { $ordnumber = qq| - |.$locale->text('Order Number').qq| + | . $locale->text('Order Number') . qq| - |.$locale->text('Quotation Number').qq| + | + . $locale->text('Quotation Number') . qq| - |.$locale->text('Customer Order Number').qq| + | + . $locale->text('Customer Order Number') . qq| - |.$locale->text('Order Date').qq| + | . $locale->text('Order Date') . qq| $button1 - |.$locale->text('Required by').qq| + | . $locale->text('Required by') . qq| $button2 |; - + $n = ($form->{creditremaining} =~ /-/) ? "0" : "1"; - + $creditremaining = qq| - + - +
|.$locale->text('Credit Limit').qq|| . $locale->text('Credit Limit') . qq| $form->{creditlimit} |.$locale->text('Remaining').qq|| . $locale->text('Remaining') . qq| $form->{creditremaining}
+ $shipto |; } else { - $reqlabel = ($form->{type} eq 'sales_quotation') ? $locale->text('Valid until') : $locale->text('Required by'); + $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| + | + . $locale->text('Quotation Number') . qq| @@ -386,7 +625,7 @@ sub form_header { } else { $ordnumber = qq| - |.$locale->text('RFQ Number').qq| + | . $locale->text('RFQ Number') . qq| @@ -394,11 +633,10 @@ sub form_header { $terms = ""; } - $ordnumber .= qq| - |.$locale->text('Quotation Date').qq| + | . $locale->text('Quotation Date') . qq| $button1 @@ -406,14 +644,20 @@ sub form_header { $button2 |; - + $creditremaining = qq| + + $shipto + |; } - $vc = ($form->{"select$form->{vc}"}) ? qq|\n{vc}"}">| : qq|{vc} value="$form->{$form->{vc}}" size=35>|; + $vc = + ($form->{"select$form->{vc}"}) + ? qq|\n{vc}"}">| + : qq|{vc} value="$form->{$form->{vc}}" size=35>|; $department = qq| - |.$locale->text('Department').qq| + | . $locale->text('Department') . qq| @@ -427,8 +671,9 @@ sub form_header { if ($form->{type} eq 'sales_order') { if ($form->{selectemployee}) { $employee = qq| + {customer_klass}> - |.$locale->text('Salesperson').qq| + | . $locale->text('Salesperson') . qq| @@ -436,30 +681,49 @@ sub form_header { |; } } else { - $employee = qq| + $employee = qq| + {customer_klass}> - |.$locale->text('Employee').qq| + | . $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()"; + } + + $credittext = $locale->text('Credit Limit exceeded!!!'); + if ($creditwarning) { + $onload = qq|alert('$credittext')|; + } - $form->header; - + print qq| - + -
{script}> +{script}> + + + + {id}> +{action}> {type}> {formname}> {media}> {format}> +{proforma}> @@ -493,28 +757,51 @@ sub form_header { $vc {vc}_id value=$form->{"$form->{vc}_id"}> {vc}"}"> - |.$locale->text('Contact Person').qq| + | + . $locale->text('Contact Person') . qq| $contact $creditremaining $business + $dunning + $taxzone $department - |.$locale->text('Currency').qq| + | . $locale->text('Currency') . qq| {defaultcurrency}> $exchangerate - |.$locale->text('Shipping Point').qq| + | . $locale->text('Shipping Point') . qq| - |.$locale->text('Ship via').qq| + | . $locale->text('Ship via') . qq| - - + |; +# +# +# +# +# +# +# +# +# +# +# +#
+# +# +#
+# +# +#
+# +# +print qq| @@ -528,7 +815,7 @@ sub form_header {
- + $jsscript @@ -541,10 +828,12 @@ $jsscript + + - + @@ -565,7 +854,6 @@ $jsscript $lxdebug->leave_sub(); } - sub form_footer { $lxdebug->enter_sub(); @@ -578,26 +866,33 @@ sub form_footer { $introws = 2; } $rows = ($rows > $introws) ? $rows : $introws; - $notes = qq||; - $intnotes = qq||; + $notes = + qq||; + $intnotes = + qq||; $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; $taxincluded = ""; if ($form->{taxaccounts}) { $taxincluded = qq| - {taxincluded}> |.$locale->text('Tax Included').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->{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->{"${item}_description"} $form->{"${item}_total"} @@ -606,11 +901,12 @@ sub form_footer { } } - $form->{invsubtotal} = $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); - + $form->{invsubtotal} = + $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); + $subtotal = qq| - |.$locale->text('Subtotal').qq| + | . $locale->text('Subtotal') . qq| $form->{invsubtotal} |; @@ -618,15 +914,24 @@ sub form_footer { } 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| + 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| Enthaltene $form->{"${item}_description"} $form->{"${item}_total"} @@ -638,13 +943,12 @@ sub form_footer { |; } } - - + } - - $form->{oldinvtotal} = $form->{invtotal}; - $form->{invtotal} = $form->format_amount(\%myconfig, $form->{invtotal}, 2, 0); + $form->{oldinvtotal} = $form->{invtotal}; + $form->{invtotal} = + $form->format_amount(\%myconfig, $form->{invtotal}, 2, 0); print qq| @@ -654,13 +958,16 @@ sub form_footer { - - + + + +
|.$locale->text('Notes').qq||.$locale->text('Internal Notes').qq|| . $locale->text('Notes') . qq|| . $locale->text('Internal Notes') . qq|
$notes $intnotes
| . $locale->text('Payment Terms') . qq|
@@ -669,7 +976,7 @@ sub form_footer { $subtotal $tax - |.$locale->text('Total').qq| + | . $locale->text('Total') . qq| $form->{invtotal} @@ -685,26 +992,25 @@ sub form_footer { |; - if ($webdav) { - $webdav_list = qq| + $webdav_list = qq| - + Dokumente im Webdav-Repository |; - foreach $file (keys %{ $form->{WEBDAV}}) { - $webdav_list .= qq| - + foreach $file (keys %{ $form->{WEBDAV} }) { + $webdav_list .= qq| + |; - } - $webdav_list .= qq| + } + $webdav_list .= qq|
Dateiname Webdavlink
$file $form->{WEBDAV}{$file}
@@ -712,12 +1018,12 @@ sub form_footer { |; -print $webdav_list; -} -print qq| + print $webdav_list; + } + print qq| {jscalendar}> |; -print qq| + print qq| |; @@ -728,55 +1034,86 @@ print qq| -Bearbeiten des $form->{heading}
- - - - - +| . $locale->text("Edit the $form->{type}") . qq|
+ + + + + + |; - if ($form->{id}) { - print qq| -
Workflow $form->{heading}
- -|; - if ($form->{type} =~ /quotation$/) { + 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| +|; } - print qq| - + if (1) { + print qq| + |; +} - if ($form->{type} =~ /sales_order$/) { - print qq| + if ($form->{type} =~ /sales_order$/) { + print qq|
$form->{heading} als neue Vorlage verwenden für
- - + + |; - } elsif ($form->{type} =~ /purchase_order$/) { - print qq| + } elsif ($form->{type} =~ /purchase_order$/) { + print qq|
$form->{heading} als neue Vorlage verwenden für
- - + + |; - - } else { - print qq| + + } 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| + + print qq| {rowcount}> @@ -794,32 +1131,45 @@ Bearbeiten des $form->{heading}
$lxdebug->leave_sub(); } - sub update { $lxdebug->enter_sub(); - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); + 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))); - + $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}; - my $i = $form->{rowcount}; $exchangerate = ($form->{exchangerate}) ? $form->{exchangerate} : 1; - if (($form->{"partnumber_$i"} eq "") && ($form->{"description_$i"} eq "") && ($form->{"partsgroup_$i"} eq "")) { + 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') { + + 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') { @@ -827,119 +1177,146 @@ sub update { } my $rows = scalar @{ $form->{item_list} }; - - $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{discount} * 100); + + $form->{"discount_$i"} = + $form->format_amount(\%myconfig, $form->{discount} * 100); if ($rows) { - $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"}); - + $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"}); + if ($rows > 1) { - - &select_item; - exit; - + + &select_item; + exit; + } else { - - $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); - - map { $form->{item_list}[$i]{$_} =~ s/\"/"/g } qw(partnumber description unit); - map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; - - $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; - - ($dec) = ($s =~ /\.(\d+)/); - $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; + + $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; if ($sellprice) { - $form->{"sellprice_$i"} = $sellprice; - } else { - # if there is an exchange rate adjust sellprice - $form->{"sellprice_$i"} /= $exchangerate; - } - - $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"}); + $form->{"sellprice_$i"} = $sellprice; + } else { + + $form->{"sellprice_$i"} *= (1 - $form->{tradediscount}); + + # if there is an exchange rate adjust sellprice + $form->{"sellprice_$i"} /= $exchangerate; + } + + $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); + + # get pricegroups for parts + IS->get_pricegroups_for_parts(\%myconfig, \%$form); + + # build up html code for prices_$i + &set_pricegroup($i); } &display_form; } else { + # ok, so this is a new part # ask if it is a part or service item - if ($form->{"partsgroup_$i"} && ($form->{"partsnumber_$i"} eq "") && ($form->{"description_$i"} eq "")) { - $form->{rowcount}--; - $form->{"discount_$i"} = ""; - &display_form; + if ( $form->{"partsgroup_$i"} + && ($form->{"partsnumber_$i"} eq "") + && ($form->{"description_$i"} eq "")) { + $form->{rowcount}--; + $form->{"discount_$i"} = ""; + &display_form; } else { - - $form->{"id_$i"} = 0; - $form->{"unit_$i"} = $locale->text('ea'); - &new_item; + $form->{"id_$i"} = 0; + $form->{"unit_$i"} = $locale->text('ea'); + + &new_item; } } } + $lxdebug->leave_sub(); } - - sub search { $lxdebug->enter_sub(); - + if ($form->{type} eq 'purchase_order') { $form->{title} = $locale->text('Purchase Orders'); - $form->{vc} = 'vendor'; - $ordlabel = $locale->text('Order Number'); - $ordnumber = 'ordnumber'; - $employee = $locale->text('Employee'); + $form->{vc} = 'vendor'; + $ordlabel = $locale->text('Order Number'); + $ordnumber = 'ordnumber'; + $employee = $locale->text('Employee'); } if ($form->{type} eq 'request_quotation') { $form->{title} = $locale->text('Request for Quotations'); - $form->{vc} = 'vendor'; - $ordlabel = $locale->text('RFQ Number'); - $ordnumber = 'quonumber'; - $employee = $locale->text('Employee'); + $form->{vc} = 'vendor'; + $ordlabel = $locale->text('RFQ Number'); + $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'); + $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'); + $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'); + $form->{vc} = 'customer'; + $ordlabel = $locale->text('Order Number'); + $ordnumber = 'ordnumber'; + $employee = $locale->text('Salesperson'); } - + if ($form->{type} eq 'sales_quotation') { $form->{title} = $locale->text('Quotations'); - $form->{vc} = 'customer'; - $ordlabel = $locale->text('Quotation Number'); - $ordnumber = 'quonumber'; - $employee = $locale->text('Employee'); + $form->{vc} = 'customer'; + $ordlabel = $locale->text('Quotation Number'); + $ordnumber = 'quonumber'; + $employee = $locale->text('Employee'); } if ($form->{type} =~ /(ship|receive)_order/) { @@ -948,13 +1325,16 @@ sub search { # warehouse if (@{ $form->{all_warehouses} }) { $form->{selectwarehouse} = "
@@ -1116,53 +1518,64 @@ $jsscript $lxdebug->leave_sub(); } - sub orders { $lxdebug->enter_sub(); # split vendor / customer - ($form->{$form->{vc}}, $form->{"$form->{vc}_id"}) = split(/--/, $form->{$form->{vc}}); + ($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) = + split(/--/, $form->{ $form->{vc} }); OE->transactions(\%myconfig, \%$form); $ordnumber = ($form->{type} =~ /_order$/) ? "ordnumber" : "quonumber"; - $number = $form->escape($form->{$ordnumber}); - $name = $form->escape($form->{$form->{vc}}); + $number = $form->escape($form->{$ordnumber}); + $name = $form->escape($form->{ $form->{vc} }); $department = $form->escape($form->{department}); - $warehouse = $form->escape($form->{warehouse}); - + $warehouse = $form->escape($form->{warehouse}); + # 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"; + $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"; # 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); - - $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"; + $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); - @columns = $form->sort_columns("transdate", "reqdate", "id", "$ordnumber", "name", "netamount", "tax", "amount", "curr", "employee", "shipvia", "open", "closed"); + $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"; - $form->{l_open} = $form->{l_closed} = "Y" if ($form->{open} && $form->{closed}) ; + @columns = + $form->sort_columns("transdate", "reqdate", "id", "$ordnumber", + "name", "netamount", "tax", "amount", + "curr", "employee", "shipvia", "open", + "closed"); + + $form->{l_open} = $form->{l_closed} = "Y" + if ($form->{open} && $form->{closed}); foreach $item (@columns) { if ($form->{"l_$item"} eq "Y") { push @column_index, $item; - + # add column to href and callback $callback .= "&l_$item=Y"; - $href .= "&l_$item=Y"; + $href .= "&l_$item=Y"; } } - + + # only show checkboxes if gotten here via sales_order form. + if ($form->{type} =~ /sales_order/) { + unshift @column_index, "ids"; + } + if ($form->{l_subtotal} eq 'Y') { $callback .= "&l_subtotal=Y"; - $href .= "&l_subtotal=Y"; + $href .= "&l_subtotal=Y"; } - - + if ($form->{vc} eq 'vendor') { if ($form->{type} eq 'receive_order') { $form->{title} = $locale->text('Receive Merchandise'); @@ -1171,7 +1584,7 @@ sub orders { } else { $form->{title} = $locale->text('Request for Quotations'); } - $name = $locale->text('Vendor'); + $name = $locale->text('Vendor'); $employee = $locale->text('Employee'); } if ($form->{vc} eq 'customer') { @@ -1187,25 +1600,52 @@ sub orders { } $name = $locale->text('Customer'); } - - $column_header{id} = qq||.$locale->text('ID').qq||; - $column_header{transdate} = qq||.$locale->text('Date').qq||; - $column_header{reqdate} = qq||.$locale->text('Required by').qq||; - $column_header{ordnumber} = qq||.$locale->text('Order').qq||; - $column_header{quonumber} = qq||.$locale->text('Quotation').qq||; - $column_header{name} = qq|$name|; - $column_header{netamount} = qq||.$locale->text('Amount').qq||; - $column_header{tax} = qq||.$locale->text('Tax').qq||; - $column_header{amount} = qq||.$locale->text('Total').qq||; - $column_header{curr} = qq||.$locale->text('Curr').qq||; - $column_header{shipvia} = qq||.$locale->text('Ship via').qq||; - $column_header{open} = qq||.$locale->text('O').qq||; - $column_header{closed} = qq||.$locale->text('C').qq||; - - $column_header{employee} = qq|$employee|; - - - if ($form->{$form->{vc}}) { + + $column_header{id} = + qq|| + . $locale->text('ID') + . qq||; + $column_header{transdate} = + qq|| + . $locale->text('Date') + . qq||; + $column_header{reqdate} = + qq|| + . $locale->text('Required by') + . qq||; + $column_header{ordnumber} = + qq|| + . $locale->text('Order') + . qq||; + $column_header{quonumber} = + qq|| + . $locale->text('Quotation') + . qq||; + $column_header{name} = + qq|$name|; + $column_header{netamount} = + qq|| . $locale->text('Amount') . qq||; + $column_header{tax} = + qq|| . $locale->text('Tax') . qq||; + $column_header{amount} = + qq|| . $locale->text('Total') . qq||; + $column_header{curr} = + qq|| . $locale->text('Curr') . qq||; + $column_header{shipvia} = + qq|| + . $locale->text('Ship via') + . qq||; + $column_header{open} = + qq|| . $locale->text('O') . qq||; + $column_header{closed} = + qq|| . $locale->text('C') . qq||; + + $column_header{employee} = + qq|$employee|; + + $column_header{ids} = qq||; + + if ($form->{ $form->{vc} }) { $option = $locale->text(ucfirst $form->{vc}); $option .= " : $form->{$form->{vc}}"; } @@ -1218,13 +1658,17 @@ sub orders { if ($form->{department}) { $option .= "\n
" if ($option); ($department) = split /--/, $form->{department}; - $option .= $locale->text('Department')." : $department"; + $option .= $locale->text('Department') . " : $department"; } if ($form->{transdatefrom}) { - $option .= "\n
".$locale->text('From')." ".$locale->date(\%myconfig, $form->{transdatefrom}, 1); + $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); + $option .= "\n
" + . $locale->text('Bis') . " " + . $locale->date(\%myconfig, $form->{transdateto}, 1); } if ($form->{open}) { $option .= "\n
" if ($option); @@ -1234,12 +1678,13 @@ sub orders { $option .= "\n
" if ($option); $option .= $locale->text('Closed'); } - + $form->header; print qq| +
@@ -1253,17 +1698,17 @@ sub orders {
$form->{title}
|; -map { print "\n$column_header{$_}" } @column_index; + map { print "\n$column_header{$_}" } @column_index; -print qq| + print qq| |; # add sort and escape callback - $callback = $form->escape($callback . "&sort=$form->{sort}"); + $callback_escaped = $form->escape($callback . "&sort=$form->{sort}"); if (@{ $form->{OE} }) { - $sameitem = $form->{OE}->[0]->{$form->{sort}}; + $sameitem = $form->{OE}->[0]->{ $form->{sort} }; } $action = "edit"; @@ -1272,48 +1717,61 @@ print qq| $warehouse = $form->escape($form->{warehouse}); foreach $oe (@{ $form->{OE} }) { + $form->{rowcount} = ++$j; if ($form->{l_subtotal} eq 'Y') { - if ($sameitem ne $oe->{$form->{sort}}) { - &subtotal; - $sameitem = $oe->{$form->{sort}}; + 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} = ""; + + $column_data{netamount} = + ""; + $column_data{tax} = ""; + $column_data{amount} = + ""; $totalnetamount += $oe->{netamount}; - $totalamount += $oe->{amount}; + $totalamount += $oe->{amount}; $subtotalnetamount += $oe->{netamount}; - $subtotalamount += $oe->{amount}; + $subtotalamount += $oe->{amount}; - $column_data{id} = ""; + $column_data{ids} = + qq||; + $column_data{id} = ""; $column_data{transdate} = ""; - $column_data{reqdate} = ""; + $column_data{reqdate} = ""; - $column_data{$ordnumber} = ""; + $column_data{$ordnumber} = + ""; $column_data{name} = ""; $column_data{employee} = ""; - $column_data{shipvia} = ""; + $column_data{shipvia} = ""; if ($oe->{closed}) { $column_data{closed} = ""; - $column_data{open} = ""; + $column_data{open} = ""; } else { $column_data{closed} = ""; - $column_data{open} = ""; + $column_data{open} = ""; } - $i++; $i %= 2; + $i++; + $i %= 2; print " "; - + map { print "\n$column_data{$_}" } @column_index; print qq| @@ -1321,20 +1779,27 @@ print qq| |; } - + if ($form->{l_subtotal} eq 'Y') { &subtotal; } - + # print totals print qq| |; - + map { $column_data{$_} = "" } @column_index; - - $column_data{netamount} = ""; - $column_data{tax} = ""; - $column_data{amount} = ""; + + $column_data{netamount} = + ""; + $column_data{tax} = ""; + $column_data{amount} = + ""; map { print "\n$column_data{$_}" } @column_index; @@ -1346,7 +1811,27 @@ 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, " ")."" + . $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->{id}$oe->{transdate} $oe->{reqdate} $oe->{reqdate} {path}&action=$action&type=$form->{type}&id=$oe->{id}&warehouse=$warehouse&vc=$form->{vc}&login=$form->{login}&password=$form->{password}&callback=$callback>$oe->{$ordnumber}{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} $oe->{shipvia} X   XX
 ".$form->format_amount(\%myconfig, $totalnetamount, 2, " ")."".$form->format_amount(\%myconfig, $totalamount - $totalnetamount, 2, " ")."".$form->format_amount(\%myconfig, $totalamount, 2, " ")."" + . $form->format_amount(\%myconfig, $totalnetamount, 2, " ") . "" + . $form->format_amount(\%myconfig, $totalamount - $totalnetamount, + 2, " ") + . "" + . $form->format_amount(\%myconfig, $totalamount, 2, " ") . "

+|; + + # multiple invoice edit button only if gotten there via sales_order form. + + if ($form->{type} =~ /sales_order/) { + print qq| + + + + + + + + + + |; + } + + print qq| +

{script}> @@ -1363,7 +1848,8 @@ print qq| if ($form->{type} !~ /(ship|receive)_order/) { print qq| -|; +|; } if ($form->{menubar}) { @@ -1381,24 +1867,30 @@ print qq| $lxdebug->leave_sub(); } - - sub subtotal { $lxdebug->enter_sub(); map { $column_data{$_} = " " } @column_index; - - $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, " ").""; + + $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, " ") . ""; $subtotalnetamount = 0; - $subtotalamount = 0; + $subtotalamount = 0; print " "; - + map { print "\n$column_data{$_}" } @column_index; print qq| @@ -1408,8 +1900,7 @@ sub subtotal { $lxdebug->leave_sub(); } - -sub save { +sub save_and_close { $lxdebug->enter_sub(); if ($form->{type} =~ /_order$/) { @@ -1417,15 +1908,16 @@ sub save { } else { $form->isblank("transdate", $locale->text('Quotation Date missing!')); } - + $msg = ucfirst $form->{vc}; $form->isblank($form->{vc}, $locale->text($msg . " missing!")); -# $locale->text('Customer missing!'); -# $locale->text('Vendor missing!'); - - $form->isblank("exchangerate", $locale->text('Exchangerate missing!')) if ($form->{currency} ne $form->{defaultcurrency}); - + # $locale->text('Customer missing!'); + # $locale->text('Vendor missing!'); + + $form->isblank("exchangerate", $locale->text('Exchangerate missing!')) + if ($form->{currency} ne $form->{defaultcurrency}); + &validate_items; # if the name changed get new values @@ -1435,7 +1927,7 @@ sub save { } $form->{id} = 0 if $form->{saveasnew}; - + # this is for the internal notes section for the [email] Subject if ($form->{type} =~ /_order$/) { if ($form->{type} eq 'sales_order') { @@ -1445,17 +1937,17 @@ sub save { $ordnumber = "ordnumber"; } else { $form->{label} = $locale->text('Purchase Order'); - + $numberfld = "ponumber"; $ordnumber = "ordnumber"; } $err = $locale->text('Cannot save order!'); - + } else { if ($form->{type} eq 'sales_quotation') { $form->{label} = $locale->text('Quotation'); - + $numberfld = "sqnumber"; $ordnumber = "quonumber"; } else { @@ -1464,20 +1956,101 @@ sub save { $numberfld = "rfqnumber"; $ordnumber = "quonumber"; } - + $err = $locale->text('Cannot save quotation!'); - + + } + + # get new number in sequence if no number is given or if saveasnew was requested + if (!$form->{$ordnumber} || $form->{saveasnew}) { + $form->{$ordnumber} = $form->update_defaults(\%myconfig, $numberfld); } - $form->{$ordnumber} = $form->update_defaults(\%myconfig, $numberfld) unless $form->{$ordnumber}; - - $form->redirect($form->{label}." $form->{$ordnumber} ".$locale->text('saved!')) if (OE->save(\%myconfig, \%$form)); + relink_accounts(); + + $form->redirect( + $form->{label} . " $form->{$ordnumber} " . $locale->text('saved!')) + if (OE->save(\%myconfig, \%$form)); $form->error($err); $lxdebug->leave_sub(); } +sub save { + $lxdebug->enter_sub(); + if ($form->{type} =~ /_order$/) { + $form->isblank("transdate", $locale->text('Order Date missing!')); + } else { + $form->isblank("transdate", $locale->text('Quotation Date missing!')); + } + + $msg = ucfirst $form->{vc}; + $form->isblank($form->{vc}, $locale->text($msg . " missing!")); + + # $locale->text('Customer missing!'); + # $locale->text('Vendor missing!'); + + $form->isblank("exchangerate", $locale->text('Exchangerate missing!')) + if ($form->{currency} ne $form->{defaultcurrency}); + + &validate_items; + + # if the name changed get new values + if (&check_name($form->{vc})) { + &update; + exit; + } + + $form->{id} = 0 if $form->{saveasnew}; + + # this is for the internal notes section for the [email] Subject + if ($form->{type} =~ /_order$/) { + if ($form->{type} eq 'sales_order') { + $form->{label} = $locale->text('Sales Order'); + + $numberfld = "sonumber"; + $ordnumber = "ordnumber"; + } else { + $form->{label} = $locale->text('Purchase Order'); + + $numberfld = "ponumber"; + $ordnumber = "ordnumber"; + } + + $err = $locale->text('Cannot save order!'); + + } else { + if ($form->{type} eq 'sales_quotation') { + $form->{label} = $locale->text('Quotation'); + + $numberfld = "sqnumber"; + $ordnumber = "quonumber"; + } else { + $form->{label} = $locale->text('Request for Quotation'); + + $numberfld = "rfqnumber"; + $ordnumber = "quonumber"; + } + + $err = $locale->text('Cannot save quotation!'); + + } + + $form->{$ordnumber} = $form->update_defaults(\%myconfig, $numberfld) + unless $form->{$ordnumber}; + + relink_accounts(); + + OE->save(\%myconfig, \%$form); + $form->{simple_save} = 1; + if(!$form->{print_and_save}) { + set_headings("edit"); + &update; + exit; + } + $lxdebug->leave_sub(); +} sub delete { $lxdebug->enter_sub(); @@ -1485,13 +2058,13 @@ sub delete { $form->header; if ($form->{type} =~ /_order$/) { - $msg = $locale->text('Are you sure you want to delete Order Number'); + $msg = $locale->text('Are you sure you want to delete Order Number'); $ordnumber = 'ordnumber'; } else { $msg = $locale->text('Are you sure you want to delete Quotation Number'); $ordnumber = 'quonumber'; } - + print qq| @@ -1507,23 +2080,21 @@ sub delete { } print qq| -

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

+

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

$msg $form->{$ordnumber}

- +

|; - $lxdebug->leave_sub(); } - - sub yes { $lxdebug->enter_sub(); @@ -1534,22 +2105,29 @@ sub yes { $msg = $locale->text('Quotation deleted!'); $err = $locale->text('Cannot delete quotation!'); } - + $form->redirect($msg) if (OE->delete(\%myconfig, \%$form, $spool)); $form->error($err); $lxdebug->leave_sub(); } - - sub invoice { $lxdebug->enter_sub(); - + if ($form->{type} =~ /_order$/) { - $form->isblank("ordnumber", $locale->text('Order Number missing!')); - $form->isblank("transdate", $locale->text('Order Date missing!')); + # 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) } + ->{''}); + $form->isblank("transdate", $locale->text('Order Date missing!')) + if (+{ map { $form->{"transdate_$_"}, 1 } (1 .. $form->{rowcount} - 1) } + ->{''}); + + # also copy deliverydate from the order + $form->{deliverydate} = $form->{reqdate} if $form->{reqdate}; } else { $form->isblank("quonumber", $locale->text('Quotation Number missing!')); $form->isblank("transdate", $locale->text('Quotation Date missing!')); @@ -1562,15 +2140,18 @@ sub invoice { exit; } - ($null, $form->{cp_id}) = split /--/, $form->{contact}; $form->{cp_id} *= 1; - - if ($form->{type} =~ /_order/ && $form->{currency} ne $form->{defaultcurrency}) { + + if ( $form->{type} =~ /_order/ + && $form->{currency} ne $form->{defaultcurrency}) { + # check if we need a new exchangerate $buysell = ($form->{type} eq 'sales_order') ? "buy" : "sell"; - - $orddate = $form->current_date(\%myconfig); - $exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $orddate, $buysell); + + $orddate = $form->current_date(\%myconfig); + $exchangerate = + $form->check_exchangerate(\%myconfig, $form->{currency}, $orddate, + $buysell); if (!$exchangerate) { &backorder_exchangerate($orddate, $buysell); @@ -1578,16 +2159,24 @@ sub invoice { } } - # close orders/quotations $form->{closed} = 1; - OE->save(\%myconfig, \%$form); + # 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->{duedate} = + $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1); + + $form->{id} = ''; $form->{closed} = 0; $form->{rowcount}--; $form->{shipto} = 1; @@ -1597,26 +2186,26 @@ sub invoice { &create_backorder; } - - if ($form->{type} eq 'purchase_order' || $form->{type} eq 'request_quotation') { - $form->{title} = $locale->text('Add Vendor Invoice'); + if ( $form->{type} eq 'purchase_order' + || $form->{type} eq 'request_quotation') { + $form->{title} = $locale->text('Add Vendor Invoice'); $form->{script} = 'ir.pl'; - $script = "ir"; - $buysell = 'sell'; + $script = "ir"; + $buysell = 'sell'; } if ($form->{type} eq 'sales_order' || $form->{type} eq 'sales_quotation') { - $form->{title} = $locale->text('Add Sales Invoice'); + $form->{title} = $locale->text('Add Sales Invoice'); $form->{script} = 'is.pl'; - $script = "is"; - $buysell = 'buy'; + $script = "is"; + $buysell = 'buy'; } - - + # bo creates the id, reset it - map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued); - $form->{$form->{vc}} =~ s/--.*//g; + 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"; @@ -1624,43 +2213,59 @@ sub invoice { map { $form->{"select$_"} = "" } ($form->{vc}, currency); - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(creditlimit creditremaining); + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(creditlimit creditremaining); $currency = $form->{currency}; &invoice_links; - $form->{currency} = $currency; + $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->{exchangerate} = $exchangerate + if ( + $form->{forex} = ( + $exchangerate = + $form->check_exchangerate( + \%myconfig, $form->{currency}, $form->{invdate}, $buysell + ))); + $form->{creditremaining} -= ($form->{oldinvtotal} - $form->{ordtotal}); &prepare_invoice; # format amounts for $i (1 .. $form->{rowcount}) { - $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"}); - + $form->{"discount_$i"} = + $form->format_amount(\%myconfig, $form->{"discount_$i"}); + ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); - $dec = length $dec; + $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; - $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); - $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); + # copy delivery date from reqdate for order -> invoice conversion + $form->{"deliverydate_$i"} = $form->{"reqdate_$i"} + unless $form->{"deliverydate_$i"}; + + $form->{"sellprice_$i"} = + $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, + $decimalplaces); + + (my $dec_qty) = ($form->{"qty_$i"} =~ /\.(\d+)/); + $dec_qty = length $dec_qty; + $form->{"qty_$i"} = + $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty); + + map { $form->{"${_}_$i"} =~ s/\"/"/g } + qw(partnumber description unit); - map { $form->{"${_}_$i"} =~ s/\"/"/g } qw(partnumber description unit); - } - &display_form; $lxdebug->leave_sub(); } - - sub backorder_exchangerate { $lxdebug->enter_sub(); my ($orddate, $buysell) = @_; @@ -1682,7 +2287,7 @@ sub backorder_exchangerate { } $form->{title} = $locale->text('Add Exchangerate'); - + print qq| {path}> @@ -1699,15 +2304,15 @@ sub backorder_exchangerate { - + - + - +
|.$locale->text('Currency').qq|| . $locale->text('Currency') . qq| $form->{currency}
|.$locale->text('Date').qq|| . $locale->text('Date') . qq| $orddate
|.$locale->text('Exchangerate').qq|| . $locale->text('Exchangerate') . qq|
@@ -1720,7 +2325,8 @@ sub backorder_exchangerate {
- + @@ -1728,43 +2334,43 @@ sub backorder_exchangerate { |; - $lxdebug->leave_sub(); } - sub save_exchangerate { $lxdebug->enter_sub(); $form->isblank("exchangerate", $locale->text('Exchangerate missing!')); - $form->{exchangerate} = $form->parse_amount(\%myconfig, $form->{exchangerate}); - $form->save_exchangerate(\%myconfig, $form->{currency}, $form->{exchangeratedate}, $form->{exchangerate}, $form->{buysell}); - + $form->{exchangerate} = + $form->parse_amount(\%myconfig, $form->{exchangerate}); + $form->save_exchangerate(\%myconfig, $form->{currency}, + $form->{exchangeratedate}, + $form->{exchangerate}, $form->{buysell}); + &invoice; $lxdebug->leave_sub(); } - sub create_backorder { $lxdebug->enter_sub(); - + $form->{shipped} = 1; - + # figure out if we need to create a backorder # items aren't saved if qty != 0 for $i (1 .. $form->{rowcount}) { - $totalqty += $qty = $form->{"qty_$i"}; + $totalqty += $qty = $form->{"qty_$i"}; $totalship += $ship = $form->{"ship_$i"}; - + $form->{"qty_$i"} = $qty - $ship; } if ($totalship == 0) { map { $form->{"ship_$_"} = $form->{"qty_$_"} } (1 .. $form->{rowcount}); $form->{ordtotal} = 0; - $form->{shipped} = 0; + $form->{shipped} = 0; return; } @@ -1774,17 +2380,23 @@ sub create_backorder { return; } - @flds = (qw(partnumber description qty ship unit sellprice discount id inventory_accno bin income_accno expense_accno listprice assembly taxaccounts partsgroup)); + @flds = ( + qw(partnumber description qty ship unit sellprice discount id inventory_accno bin income_accno expense_accno listprice assembly taxaccounts partsgroup) + ); for $i (1 .. $form->{rowcount}) { - map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}) } qw(sellprice discount); + map { + $form->{"${_}_$i"} = + $form->format_amount(\%myconfig, $form->{"${_}_$i"}) + } qw(sellprice discount); } + relink_accounts(); OE->save(\%myconfig, \%$form); - + # rebuild rows for invoice - @a = (); + @a = (); $count = 0; for $i (1 .. $form->{rowcount}) { @@ -1797,97 +2409,102 @@ sub create_backorder { $count++; } } - + $form->redo_rows(\@flds, \@a, $count, $form->{rowcount}); $form->{rowcount} = $count; - + $lxdebug->leave_sub(); } - - sub save_as_new { $lxdebug->enter_sub(); $form->{saveasnew} = 1; - $form->{closed} = 0; - map { delete $form->{$_} } qw(printed emailed queued); + $form->{closed} = 0; + map { delete $form->{$_} } qw(printed emailed queued ordnumber quonumber); &save; $lxdebug->leave_sub(); } - sub purchase_order { $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"; - + $form->{vc} = "vendor"; + $form->{type} = "purchase_order"; + &poso; - + $lxdebug->leave_sub(); } - sub sales_order { $lxdebug->enter_sub(); - - if ($form->{type} eq 'sales_quotation'|| $form->{type} eq 'request_quotation') { + if ( $form->{type} eq 'sales_quotation' + || $form->{type} eq 'request_quotation') { $form->{closed} = 1; - OE->save(\%myconfig, \%$form); + relink_accounts(); + OE->save(\%myconfig, \%$form); } - - ($null, $form->{cp_id}) = split /--/, $form->{contact}; + $form->{cp_id} *= 1; - + $form->{title} = $locale->text('Add Sales Order'); - $form->{vc} = "customer"; - $form->{type} = "sales_order"; - + $form->{vc} = "customer"; + $form->{type} = "sales_order"; + &poso; - + $lxdebug->leave_sub(); } - sub poso { $lxdebug->enter_sub(); - - + $form->{transdate} = $form->current_date(\%myconfig); delete $form->{duedate}; - + $form->{closed} = 0; # reset - map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued customer vendor creditlimit creditremaining discount tradediscount oldinvtotal); - + map { delete $form->{$_} } + qw(id subject message cc bcc printed emailed queued customer vendor creditlimit creditremaining discount tradediscount oldinvtotal); + &order_links; &prepare_order; # format amounts for $i (1 .. $form->{rowcount} - 1) { - map { $form->{"${_}_$i"} =~ s/\"/"/g } qw(partnumber description unit); + map { $form->{"${_}_$i"} =~ s/\"/"/g } + qw(partnumber description unit); } - map { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, 0, "0") } qw(creditlimit creditremaining); + map { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, 0, "0") } + qw(creditlimit creditremaining); &update; $lxdebug->leave_sub(); } - sub ship_receive { $lxdebug->enter_sub(); &order_links; - + &prepare_order; OE->get_warehouses(\%myconfig, \%$form); @@ -1896,7 +2513,8 @@ sub ship_receive { if (@{ $form->{all_warehouses} }) { $form->{selectwarehouse} = "