X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fis.pl;h=b603f773a1311596fcc8c66e59cb5fced35fa913;hb=7e2bf6ca0b5a77130cec0b01cfe263cd04f7e64d;hp=314f68bc1e28f290ded0330d3d195ed099842d68;hpb=043aefd5e1013d71e861011c3f4132bf84643509;p=kivitendo-erp.git diff --git a/bin/mozilla/is.pl b/bin/mozilla/is.pl index 314f68bc1..b603f773a 100644 --- a/bin/mozilla/is.pl +++ b/bin/mozilla/is.pl @@ -35,8 +35,9 @@ use SL::IS; use SL::PE; 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/drafts.pl"; 1; @@ -45,10 +46,22 @@ require "$form->{path}/arap.pl"; sub add { $lxdebug->enter_sub(); - $form->{title} = $locale->text('Add Sales Invoice'); + return $lxdebug->leave_sub() if (load_draft_maybe()); + + if ($form->{type} eq "credit_note") { + $form->{title} = $locale->text('Add Credit Note'); + + if ($form->{storno}) { + $form->{title} = $locale->text('Add Storno Credit Note'); + } + } else { + $form->{title} = $locale->text('Add Sales Invoice'); + + } + $form->{callback} = - "$form->{script}?action=add&type=$form->{type}&login=$form->{login}&path=$form->{path}&password=$form->{password}" + "$form->{script}?action=add&type=$form->{type}&login=$form->{login}&password=$form->{password}" unless $form->{callback}; $form{jsscript} = "date"; @@ -59,8 +72,6 @@ sub add { } &invoice_links; &prepare_invoice; - $form->{format} ="pdf"; - &display_form; $lxdebug->leave_sub(); @@ -69,18 +80,28 @@ sub add { sub edit { $lxdebug->enter_sub(); - $form->{title} = $locale->text('Edit Sales Invoice'); + # show history button + $form->{javascript} = qq||; + #/show hhistory button if ($myconfig{acs} =~ "AR--Add Sales Invoice" || $myconfig{acs} =~ "AR--AR") { $form->error("Access Denied"); } + $edit = 1; if ($form->{print_and_post}) { - $form->{action} = "print"; + $form->{action} = "print"; $form->{resubmit} = 1; + $language_id = $form->{language_id}; + $printer_id = $form->{printer_id}; } &invoice_links; &prepare_invoice; + if ($form->{print_and_post}) { + $form->{language_id} = $language_id; + $form->{printer_id} = $printer_id; + } + &display_form; $lxdebug->leave_sub(); @@ -100,29 +121,54 @@ sub invoice_links { if ($form->{all_customer}) { unless ($form->{customer_id}) { $form->{customer_id} = $form->{all_customer}->[0]->{id}; + $form->{salesman_id} = $form->{all_customer}->[0]->{salesman_id}; } } + + 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 ($form->{id}) { + $id = $form->{id}; + } + if ($form->{shipto_id}) { + $shipto_id = $form->{shipto_id}; + } + $cp_id = $form->{cp_id}; IS->get_customer(\%myconfig, \%$form); + #quote all_customer Bug 133 + foreach $ref (@{ $form->{all_customer} }) { + $ref->{name} = $form->quote($ref->{name}); + } + if ($id) { + $form->{id} = $id; + } IS->retrieve_invoice(\%myconfig, \%$form); $form->{cp_id} = $cp_id; - # currencies - @curr = split /:/, $form->{currencies}; - chomp $curr[0]; - $form->{defaultcurrency} = $curr[0]; - - map { $form->{selectcurrency} .= "\n" } (@{ $form->{all_departments} }); } $form->{employee} = "$form->{employee}--$form->{employee_id}"; - # sales staff - if ($form->{all_employees}) { - $form->{selectemployee} = ""; - map { $form->{selectemployee} .= "\n"; } if ($key eq "AR_paid") { @@ -189,9 +229,13 @@ sub invoice_links { sub prepare_invoice { $lxdebug->enter_sub(); - $form->{type} = "invoice"; - $form->{formname} = "invoice"; - $form->{media} = "screen"; + if ($form->{type} eq "credit_note") { + $form->{type} = "credit_note"; + $form->{formname} = "credit_note"; + } else { + $form->{type} = "invoice"; + $form->{formname} = "invoice"; + } if ($form->{id}) { @@ -201,8 +245,11 @@ sub prepare_invoice { # # get pricegroups for parts # IS->get_pricegroups_for_parts(\%myconfig, \%$form); + my $i = 0; + foreach $ref (@{ $form->{invoice_details} }) { $i++; + map { $form->{"${_}_$i"} = $ref->{$_} } keys %{$ref}; $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100); @@ -232,28 +279,224 @@ sub prepare_invoice { sub form_header { $lxdebug->enter_sub(); - # set option selected - foreach $item (qw(AR customer currency department employee contact)) { - $form->{"select$item"} =~ s/ selected//; - $form->{"select$item"} =~ - s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; + if ($form->{old_employee_id}) { + $form->{employee_id} = $form->{old_employee_id}; + } + if ($form->{old_salesman_id}) { + $form->{salesman_id} = $form->{old_salesman_id}; } - #build contacts - if ($form->{all_contacts}) { + if ($edit) { - $form->{selectcontact} = ""; - foreach $item (@{ $form->{all_contacts} }) { - if ($form->{cp_id} == $item->{cp_id}) { - $form->{selectcontact} .= - "|; + foreach $item (@{ $form->{payment_terms} }) { + if ($form->{payment_id} eq $item->{id}) { + $payment .= qq||; + } else { + $payment .= qq||; + } + } - #else {$form->{all_contacts} = 0;} + my $set_duedate_url = + "$form->{script}?login=$form->{login}&password=$form->{password}&action=set_duedate"; + + my $pjx = new CGI::Ajax( 'set_duedate' => $set_duedate_url ); + push(@ { $form->{AJAX} }, $pjx); + + my @old_project_ids = ($form->{"globalproject_id"}); + map({ push(@old_project_ids, $form->{"project_id_$_"}) + if ($form->{"project_id_$_"}); } (1..$form->{"rowcount"})); + + $form->get_lists("contacts" => "ALL_CONTACTS", + "shipto" => "ALL_SHIPTO", + "projects" => { "key" => "ALL_PROJECTS", + "all" => 0, + "old_id" => \@old_project_ids }, + "employees" => "ALL_SALESMEN", + "taxzones" => "ALL_TAXZONES", + "currencies" => "ALL_CURRENCIES", + "customers" => "ALL_CUSTOMERS"); + + my %labels; + my @values = (undef); + foreach my $item (@{ $form->{"ALL_CONTACTS"} }) { + push(@values, $item->{"cp_id"}); + $labels{$item->{"cp_id"}} = $item->{"cp_name"} . + ($item->{"cp_abteilung"} ? " ($item->{cp_abteilung})" : ""); + } + my $contact; + if (scalar @values > 1) { + $contact = qq| + + | . $locale->text('Contact Person') . qq| + | . + NTI($cgi->popup_menu('-name' => 'cp_id', '-values' => \@values, '-style' => 'width: 250px', + '-labels' => \%labels, '-default' => $form->{"cp_id"})) + . qq| + + |; + } + + %labels = (); + @values = (); + foreach my $item (@{ $form->{"ALL_SALESMEN"} }) { + push(@values, $item->{"id"}); + $labels{$item->{id}} = $item->{name} ne "" ? $item->{name} : $item->{login}; + } + + my $employees = qq| + + | . $locale->text('Employee') . qq| + | . + NTI($cgi->popup_menu('-name' => 'employee_id', '-default' => $form->{"employee_id"}, + '-values' => \@values, '-labels' => \%labels)) . qq| + + |; + + + %labels = (); + @values = (); + foreach my $item (@{ $form->{"ALL_CUSTOMERS"} }) { + push(@values, $item->{name}.qq|--|.$item->{"id"}); + $labels{$item->{name}.qq|--|.$item->{"id"}} = $item->{"name"}; + } + + $form->{selectcustomer} = ($myconfig{vclimit} > scalar(@values)); + + my $customers = qq| + | . $locale->text('Customer') . qq| + | . + (($myconfig{vclimit} <= scalar(@values)) + ? qq|| + : (NTI($cgi->popup_menu('-name' => 'customer', '-default' => $form->{oldcustomer}, + '-onChange' => 'document.getElementById(\'update_button\').click();', + '-values' => \@values, '-labels' => \%labels, '-style' => 'width: 250px')))) . qq| + + |; + + %labels = (); + @values = (""); + foreach my $item (@{ $form->{"ALL_SHIPTO"} }) { + push(@values, $item->{"shipto_id"}); + $labels{$item->{"shipto_id"}} = join "; ", grep { $_ } map { $item->{"shipto${_}" } } qw(name department_1 street city); + } + + my $shipto; + if (scalar @values > 1) { + $shipto = qq| + + | . $locale->text('Shipping Address') . qq| + | . + NTI($cgi->popup_menu('-name' => 'shipto_id', '-values' => \@values, '-style' => 'width: 250px', + '-labels' => \%labels, '-default' => $form->{"shipto_id"})) + . qq||; + } + + %labels = (); + @values = (); + foreach my $item (@{ $form->{"ALL_CURRENCIES"} }) { + push(@values, $item); + $labels{$item} = $item; + } + + $form->{currency} = $form->{defaultcurrency} unless $form->{currency}; + my $currencies; + if (scalar @values) { + $currencies = qq| + + | . $locale->text('Currency') . qq| + | . + NTI($cgi->popup_menu('-name' => 'currency', '-default' => $form->{"currency"}, + '-values' => \@values, '-labels' => \%labels)) . qq| + + |; + } + + %labels = (); + @values = (""); + foreach my $item (@{ $form->{"ALL_PROJECTS"} }) { + push(@values, $item->{"id"}); + $labels{$item->{"id"}} = $item->{"projectnumber"}; + } + my $globalprojectnumber = + NTI($cgi->popup_menu('-name' => 'globalproject_id', '-values' => \@values, + '-labels' => \%labels, + '-default' => $form->{"globalproject_id"})); + + %labels = (); + @values = (); + foreach my $item (@{ $form->{ALL_SALESMEN} }) { + push(@values, $item->{id}); + $labels{$item->{id}} = $item->{name} ne "" ? $item->{name} : $item->{login}; + } + + $salesman = + qq| + | . $locale->text('Salesman') . qq| + | . + NTI($cgi->popup_menu('-name' => 'salesman_id', '-default' => $form->{salesman_id} ? $form->{salesman_id} : $form->{employee_id}, + '-values' => \@values, '-labels' => \%labels)) + . qq| + |; + + %labels = (); + @values = (); + foreach my $item (@{ $form->{"ALL_TAXZONES"} }) { + push(@values, $item->{"id"}); + $labels{$item->{"id"}} = $item->{"description"}; + } + + if (!$form->{"id"}) { + $taxzone = qq| + + | . $locale->text('Steuersatz') . qq| + | . + NTI($cgi->popup_menu('-name' => 'taxzone_id', '-default' => $form->{"taxzone_id"}, + '-values' => \@values, '-labels' => \%labels, '-style' => 'width: 250px',)) . qq| + + |; + + } else { + $taxzone = qq| + + | . $locale->text('Steuersatz') . qq| + + + | . H($labels{$form->{"taxzone_id"}}) . qq| + + |; + } + + # set option selected + foreach $item (qw(AR customer currency department employee)) { + $form->{"select$item"} =~ s/ selected//; + $form->{"select$item"} =~ + s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; + } + + if (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) { + $creditwarning = 1; + } else { + $creditwarning = 0; + } $form->{exchangerate} = $form->format_amount(\%myconfig, $form->{exchangerate}); @@ -267,36 +510,25 @@ sub form_header { if ($form->{currency} ne $form->{defaultcurrency}) { if ($form->{forex}) { $exchangerate .= - qq|| + qq|| . $locale->text('Exchangerate') - . qq|$form->{exchangerate}{exchangerate}>|; + . qq|$form->{exchangerate}|; } else { $exchangerate .= - qq|| + qq|| . $locale->text('Exchangerate') - . qq|{exchangerate}>|; + . qq||; } } $exchangerate .= qq| -{forex}> + |; - $customer = - ($form->{selectcustomer}) - ? qq|\n| - : qq||; - - #sk - $contact = - ($form->{selectcontact}) - ? qq|\n| - : qq||; - $department = qq| | . $locale->text('Department') . qq| - - + + | if $form->{selectdepartment}; @@ -306,181 +538,243 @@ sub form_header { if ($form->{business}) { $business = qq| - | . $locale->text('Business') . qq| - $form->{business} - | . $locale->text('Trade Discount') . qq| - | + | . $locale->text('Customer type') . qq| + $form->{business}; | . $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| + + |; } $form->{fokus} = "invoice.customer"; # use JavaScript Calendar or not - $form->{jsscript} = $jscalendar; + $form->{jsscript} = 1; $jsscript = ""; - if ($form->{jsscript}) { - - # with JavaScript Calendar + if ($form->{type} eq "credit_note") { $button1 = qq| - {invdate}> - text('button') . qq|> - |; - $button2 = qq| - {duedate}> - text('button') . qq|> - |; + + |; #write Trigger $jsscript = - Form->write_trigger(\%myconfig, "2", "invdate", "BL", "trigger1", - "duedate", "BL", "trigger2"); + Form->write_trigger(\%myconfig, "1", + "invdate", "BL", + "trigger1"); } else { + $button1 = qq| + + + |; + $button2 = qq| + + + |; + $button3 = qq| + + + |; - # without JavaScript Calendar - $button1 = - qq|{invdate}>|; - $button2 = - qq|{duedate}>|; + #write Trigger + $jsscript = + Form->write_trigger(\%myconfig, "3", + "invdate", "BL", + "trigger1", "duedate", + "BL", "trigger2", + "deliverydate", "BL", + "trigger3"); } + if ($form->{resubmit} && ($form->{format} eq "html")) { - $onload = qq|window.open('about:blank','Beleg'); document.invoice.target = 'Beleg';document.invoice.submit()|; - } elsif($form->{resubmit}) { + $onload = + qq|window.open('about:blank','Beleg'); document.invoice.target = 'Beleg';document.invoice.submit()|; + } elsif ($form->{resubmit}) { $onload = qq|document.invoice.submit()|; } else { - $onload = "fokus()"; + $onload = "focus()"; } + $onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|; + $onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|; + $credittext = $locale->text('Credit Limit exceeded!!!'); + if ($creditwarning) { + $onload = qq|alert('$credittext')|; + } + + $form->{"javascript"} .= qq||; + $form->{javascript} .= qq||; + + $jsscript .= + $form->write_trigger(\%myconfig, 2, + "orddate", "BL", "trigger_orddate", + "quodate", "BL", "trigger_quodate"); + # show history button js + $form->{javascript} .= qq||; + #/show history button js $form->header; print qq| + + + + -
{script}> - - -{id}> -{action}> - -{type}> -{media}> -{format}> + +| ; - - - + $form->hide_form(qw(id action type media format queued printed emailed title vc discount + creditlimit creditremaining tradediscount business closedto locked shipped storno storno_id + max_dunning_level dunning_amount)); + print qq|

$form->{saved_message}

| if $form->{saved_message}; - -{vc}> - -{discount}> -{creditlimit}> -{creditremaining}> - -{tradediscount}> -{business}> + print qq| -{closedto}> -{locked}> + -{shipped}> - +
$form->{title}
- - - - - +
$form->{title}
-
- - - - @@ -492,37 +786,21 @@ sub form_header { - +| . $jsscript - +. qq| - - - - - - - - - - - - - - - - - - - -|; - - foreach $item (split / /, $form->{taxaccounts}) { - print qq| - - - -|; +| ; +map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_})); } + qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail shiptodepartment_1 shiptodepartment_2)); +print qq| |; +map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_})); } + qw(message email subject cc bcc taxaccounts)); +print qq||; + + foreach $item (split(/ /, $form->{taxaccounts})) { + map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_})); } + ("${item}_rate", "${item}_description", "${item}_taxnumber")); } $lxdebug->leave_sub(); } @@ -540,16 +818,16 @@ sub form_footer { } $rows = ($rows > $introws) ? $rows : $introws; $notes = - qq||; + qq||; $intnotes = - qq||; + qq||; - $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; + $form->{taxincluded} = ($form->{taxincluded} ? "checked" : ""); $taxincluded = ""; if ($form->{taxaccounts}) { $taxincluded = qq| - {taxincluded}> | + {taxincluded}> | . $locale->text('Tax Included') . qq|

|; } @@ -567,8 +845,9 @@ sub form_footer { $tax .= qq|
- - + + |; } @@ -579,8 +858,8 @@ sub form_footer { $subtotal = qq| - - + + |; @@ -606,12 +885,13 @@ sub form_footer { $tax .= qq| - - + + - - + + |; } @@ -626,28 +906,45 @@ sub form_footer { print qq|
- - - - - {customer_klass}> - {customer_id}> - - - - - - - - - $business + + + + |; +# +# +# +print qq|
| . $locale->text('Customer') . qq|$customer| - . $locale->text('Contact Person') . qq|$contact
- - - - - - - - -
| . $locale->text('Credit Limit') . qq|$form->{creditlimit}| . $locale->text('Remaining') . qq|$form->{creditremaining}
-
+ + + $customers + + + + + + $contact + $shipto + + + + + $dunning + $business - - - + + + + $taxzone $department - - - - {defaultcurrency}> - {fxgain_accno}> - {fxloss_accno}> + $currencies + + $exchangerate - - - + + - - + + -
| . $locale->text('Credit Limit') . qq|$form->{creditlimit}; | . $locale->text('Remaining') . qq| $form->{creditremaining}
| . $locale->text('Record in') . qq|| . $locale->text('Record in') . qq|
| . $locale->text('Currency') . qq|
| . $locale->text('Shipping Point') . qq|
| . $locale->text('Shipping Point') . qq| | . + $cgi->textfield("-name" => "shippingpoint", "-size" => 35, "-value" => $form->{shippingpoint}) . + qq|
| . $locale->text('Ship via') . qq|| . $locale->text('Ship via') . qq|
+
| . $locale->text('Transaction description') . qq|| . $cgi->textfield("-name" => "transaction_description", "-size" => 35, "-value" => $form->{transaction_description}) . qq|
+# +# +# +# +# +# +# +# +# +#
+# +# +#
+# +# +#
+#
+ - - - - - + $employees + $salesman +|; +if ($form->{type} eq "credit_note") { +print qq| + + - - + + $button1 + |; +} else { +print qq| + + - + $button1 - + $button2 - - + + $button3 + |; +} +print qq| + + + + + + - - + + + + + + + + + + - - + +
| . $locale->text('Salesperson') . qq|
| . $locale->text('Credit Note Number') . qq|
| . $locale->text('Invoice Number') . qq|| . $locale->text('Credit Note Date') . qq|
| . $locale->text('Invoice Number') . qq|
| . $locale->text('Invoice Date') . qq|| . $locale->text('Invoice Date') . qq|
| . $locale->text('Due Date') . qq|| . $locale->text('Due Date') . qq|
| . $locale->text('Order Number') . qq|| . $locale->text('Delivery Date') . qq|
| . $locale->text('Order Number') . qq|
| . $locale->text('Order Date') . qq| +
| . $locale->text('Quotation Number') . qq|| . $locale->text('Quotation Number') . qq|
| . $locale->text('Quotation Date') . qq| +
| . $locale->text('Customer Order Number') . qq|
| . $locale->text('Customer Order Number') . qq|| . $locale->text('Project Number') . qq|$globalprojectnumber
$form->{"${item}_description"}$form->{"${item}_total"}$form->{"${item}_description"} | + . $form->{"${item}_rate"} * 100 .qq|%$form->{"${item}_total"}
| . $locale->text('Subtotal') . qq|$form->{invsubtotal}| . $locale->text('Subtotal') . qq|$form->{invsubtotal}
Enthaltene $form->{"${item}_description"}$form->{"${item}_total"}Enthaltene $form->{"${item}_description"} | + . $form->{"${item}_rate"} * 100 .qq|%$form->{"${item}_total"}
Nettobetrag$form->{"${item}_netto"}Nettobetrag$form->{"${item}_netto"}
- - +
+ - + @@ -659,20 +956,20 @@ sub form_footer { if ($webdav) { $webdav_list = qq| - + - + -
- - + + + - + +
| . $locale->text('Notes') . qq|| . $locale->text('Internal Notes') . qq|| . $locale->text('Notes') . qq|| . $locale->text('Internal Notes') . qq|| . $locale->text('Payment Terms') . qq|
$notes $intnotes
+ + + + + + + + + + + + +
| . $locale->text('Ertrag') . qq|| . $form->format_amount(\%myconfig, $form->{marge_total}, 2, 0) . qq|
| . $locale->text('Ertrag prozentual') . qq|| . $form->format_amount(\%myconfig, $form->{marge_percent}, 2, 0) . qq| %
+
$taxincluded - +
$subtotal $tax - - + +
| . $locale->text('Total') . qq|$form->{invtotal}| . $locale->text('Total') . qq|$form->{invtotal}


Dokumente im Webdav-RepositoryDokumente im Webdav-Repository
- - +
DateinameWebdavlink
+ + |; - foreach $file (keys %{ $form->{WEBDAV} }) { + foreach $file (@{ $form->{WEBDAV} }) { $webdav_list .= qq| - - + + |; } @@ -683,15 +980,27 @@ sub form_footer { print $webdav_list; } +if ($form->{type} eq "credit_note") { + print qq| + +
DateinameWebdavlink
$file$form->{WEBDAV}{$file}$file->{name}$file->{type}
+ + + + +|; +} else { print qq|
| + . $locale->text('Payments') . qq|
- - - - + @@ -790,69 +1119,92 @@ sub form_footer { $closedto = $form->datetonum($form->{closedto}, \%myconfig); if ($form->{id}) { + my $show_storno = !$form->{storno} && !IS->has_storno(\%myconfig, $form, "ar"); + print qq| - - - - + |; + print qq| | if ($show_storno); + print qq| |; - - if (!$form->{revtrans}) { - if (!$form->{locked}) { - print qq| - - + print qq| |; - } - } + if ($form->{id} && !($form->{type} eq "credit_note")) { + print qq| + +|; + } + if ($form->{radier}) { + print qq| + +|; + } + if ($invdate > $closedto) { print qq| - - |; } } else { if ($invdate > $closedto) { - print qq| - - - - - |; + | . + NTI($cgi->submit('-name' => 'action', '-value' => $locale->text('Save draft'), + '-class' => 'submit')); } } - if ($form->{menubar}) { - require "$form->{path}/menu.pl"; - &menubar; + # button for saving history + if($form->{id} ne "") { + print qq| + |; } - - print qq| - -{rowcount}> - - - -{path}> -{login}> -{password}> - + # /button for saving history + + # mark_as_paid button + if($form->{id} ne "") { + print qq||; + } + # /mark_as_paid button + print $form->write_trigger(\%myconfig, scalar(@triggers) / 3, @triggers) . + qq| + + +| . +$cgi->hidden("-name" => "callback", "-value" => $form->{callback}) +. $cgi->hidden('-name' => 'draft_id', '-default' => [$form->{draft_id}]) +. $cgi->hidden('-name' => 'draft_description', '-default' => [$form->{draft_description}]); +map({ print $cgi->hidden("-name" => $_ , "-value" => $form->{$_});} qw(login password)); +print qq| @@ -863,6 +1215,12 @@ sub form_footer { $lxdebug->leave_sub(); } +sub mark_as_paid { + $lxdebug->enter_sub(); + &mark_as_paid_common(\%myconfig,"ar"); + $lxdebug->leave_sub(); +} + sub update { $lxdebug->enter_sub(); @@ -871,9 +1229,19 @@ sub update { if ($form->{second_run}) { $form->{print_and_post} = 0; } + + + if($form->{taxincluded}) { + $taxincluded = "checked"; + } + $form->{update} = 1; + &check_name(customer); - &check_project; + if(!$form->{taxincluded}) { + $form->{taxincluded} = $taxincluded; + } + $form->{exchangerate} = $exchangerate if ( @@ -911,7 +1279,7 @@ sub update { $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); &check_form; - } else { + } else { IS->retrieve_item(\%myconfig, \%$form); @@ -930,14 +1298,19 @@ sub update { } else { - $sellprice = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}); + $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] }; + if ($form->{"part_payment_id_$i"} ne "") { + $form->{payment_id} = $form->{"part_payment_id_$i"}; + } - $form->{"discount_$i"} = $form->{discount} * 100; + if ($form->{"not_discountable_$i"}) { + $form->{"discount_$i"} = 0; + } $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; ($dec) = ($s =~ /\.(\d+)/); @@ -1021,11 +1394,49 @@ sub update { $lxdebug->leave_sub(); } +sub post_payment { + $lxdebug->enter_sub(); + + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); + for $i (1 .. $form->{paidaccounts}) { + if ($form->{"paid_$i"}) { + $datepaid = $form->datetonum($form->{"datepaid_$i"}, \%myconfig); + + $form->isblank("datepaid_$i", $locale->text('Payment date missing!')); + + $form->error($locale->text('Cannot post payment for a closed period!')) + if ($datepaid <= $closedto); + + if ($form->{currency} ne $form->{defaultcurrency}) { + $form->{"exchangerate_$i"} = $form->{exchangerate} + if ($invdate == $datepaid); + $form->isblank("exchangerate_$i", + $locale->text('Exchangerate for payment missing!')); + } + } + } + + ($form->{AR}) = split /--/, $form->{AR}; + ($form->{AR_paid}) = split /--/, $form->{AR_paid}; + relink_accounts(); + $form->redirect($locale->text('Payment posted!')) + if (IS->post_payment(\%myconfig, \%$form)); + $form->error($locale->text('Cannot post payment!')); + + + $lxdebug->leave_sub(); +} + sub post { $lxdebug->enter_sub(); + + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); $form->isblank("invdate", $locale->text('Invoice Date missing!')); $form->isblank("customer", $locale->text('Customer missing!')); + $form->{invnumber} =~ s/^\s*//g; + $form->{invnumber} =~ s/\s*$//g; + # if oldcustomer ne customer redo form if (&check_name(customer)) { &update; @@ -1047,7 +1458,7 @@ sub post { if ($form->{currency} ne $form->{defaultcurrency}); for $i (1 .. $form->{paidaccounts}) { - if ($form->{"paid_$i"}) { + if ($form->parse_amount(\%myconfig, $form->{"paid_$i"})) { $datepaid = $form->datetonum($form->{"datepaid_$i"}, \%myconfig); $form->isblank("datepaid_$i", $locale->text('Payment date missing!')); @@ -1064,28 +1475,39 @@ sub post { } } - ($form->{AR}) = split /--/, $form->{AR}; - ($form->{AR_paid}) = split /--/, $form->{AR_paid}; + ($form->{AR}) = split /--/, $form->{AR}; + ($form->{AR_paid}) = split /--/, $form->{AR_paid}; + $form->{storno} ||= 0; $form->{label} = $locale->text('Invoice'); $form->{id} = 0 if $form->{postasnew}; # get new invnumber in sequence if no invnumber is given or if posasnew was requested - if (!$form->{invnumber} || $form->{postasnew}) { - $form->{invnumber} = $form->update_defaults(\%myconfig, "invnumber") - } - if ($print_post) { - if (!(IS->post_invoice(\%myconfig, \%$form))) { - $form->error($locale->text('Cannot post invoice!')); + if ($form->{postasnew}) { + if ($form->{type} eq "credit_note") { + undef($form->{cnnumber}); + } else { + undef($form->{invnumber}); } - } else { - $form->redirect( - $form->{label} . " $form->{invnumber} " . $locale->text('posted!')) - if (IS->post_invoice(\%myconfig, \%$form)); - $form->error($locale->text('Cannot post invoice!')); } + relink_accounts(); + $form->error($locale->text('Cannot post invoice!')) + unless IS->post_invoice(\%myconfig, \%$form); + remove_draft() if $form->{remove_draft}; + + if(!exists $form->{addition}) { + $form->{snumbers} = qq|invnumber_| . $form->{invnumber}; + $form->{addition} = $print_post ? "PRINTED AND POSTED" : + $form->{storno} ? "STORNO" : + "POSTED"; + $form->save_history($form->dbconnect(\%myconfig)); + } + + $form->redirect( $form->{label} . " $form->{invnumber} " . $locale->text('posted!')) + unless $print_post; + $lxdebug->leave_sub(); } @@ -1102,13 +1524,57 @@ sub print_and_post { } +sub use_as_template { + $lxdebug->enter_sub(); + + map { delete $form->{$_} } qw(printed emailed queued invnumber invdate deliverydate id datepaid_1 source_1 memo_1 paid_1 exchangerate_1 AP_paid_1 storno); + $form->{paidaccounts} = 1; + $form->{rowcount}--; + $form->{invdate} = $form->current_date(\%myconfig); + &display_form; + + $lxdebug->leave_sub(); +} + +sub storno { + $lxdebug->enter_sub(); + + if ($form->{storno}) { + $form->error($locale->text('Cannot storno storno invoice!')); + } + + if (IS->has_storno(\%myconfig, $form, "ar")) { + $form->error($locale->text("Invoice has already been storno'd!")); + } + + map({ my $key = $_; delete($form->{$key}) + unless (grep({ $key eq $_ } qw(login password id stylesheet type))); } + keys(%{ $form })); + + invoice_links(); + prepare_invoice(); + relink_accounts(); + + # Payments must not be recorded for the new storno invoice. + $form->{paidaccounts} = 0; + map { my $key = $_; delete $form->{$key} if grep { $key =~ /^$_/ } qw(datepaid_ source_ memo_ paid_ exchangerate_ AR_paid_) } keys %{ $form }; + + $form->{storno_id} = $form->{id}; + $form->{storno} = 1; + $form->{id} = ""; + $form->{invnumber} = "Storno zu " . $form->{invnumber}; + $form->{rowcount}++; + + post(); + $lxdebug->leave_sub(); +} + sub preview { $lxdebug->enter_sub(); $form->{preview} = 1; $old_form = new Form; for (keys %$form) { $old_form->{$_} = $form->{$_} } - $old_form->{rowcount}++; &print_form($old_form); $lxdebug->leave_sub(); @@ -1125,7 +1591,7 @@ sub delete { print qq| -{script}> + |; # delete action variable @@ -1133,11 +1599,11 @@ sub delete { foreach $key (keys %$form) { $form->{$key} =~ s/\"/"/g; - print qq|\n|; + print qq|\n|; } print qq| -

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

+

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

| . $locale->text('Are you sure you want to delete Invoice Number') @@ -1145,7 +1611,7 @@ sub delete {

- |; @@ -1153,12 +1619,94 @@ sub delete { $lxdebug->leave_sub(); } -sub yes { +sub credit_note { $lxdebug->enter_sub(); - $form->redirect($locale->text('Invoice deleted!')) - if (IS->delete_invoice(\%myconfig, \%$form, $spool)); + $form->{transdate} = $form->{invdate} = $form->current_date(\%myconfig); + $form->{duedate} = + $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1); + + $form->{id} = ''; + $form->{rowcount}--; + $form->{shipto} = 1; + + + $form->{title} = $locale->text('Add Credit Note'); + $form->{script} = 'is.pl'; + $script = "is"; + $buysell = 'buy'; + + + # bo creates the id, reset it + map { delete $form->{$_} } + qw(id invnumber subject message cc bcc printed emailed queued); + $form->{ $form->{vc} } =~ s/--.*//g; + $form->{type} = "credit_note"; + + + 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->{creditremaining} -= ($form->{oldinvtotal} - $form->{ordtotal}); + + &prepare_invoice; + + + &display_form; + + $lxdebug->leave_sub(); +} + +sub yes { + $lxdebug->enter_sub(); + if (IS->delete_invoice(\%myconfig, \%$form, $spool)) { + # saving the history + if(!exists $form->{addition}) { + $form->{snumbers} = qq|invnumber_| . $form->{invnumber}; + $form->{addition} = "DELETED"; + $form->save_history($form->dbconnect(\%myconfig)); + } + # /saving the history + $form->redirect($locale->text('Invoice deleted!')); + } $form->error($locale->text('Cannot delete invoice!')); $lxdebug->leave_sub(); } + +sub e_mail { + $lxdebug->enter_sub(); + + if (!$form->{id}) { + $print_post = 1; + + my $saved_form = save_form(); + + post(); + + my %saved_vars; + map({ $saved_vars{$_} = $form->{$_}; } qw(id invnumber)); + restore_form($saved_form); + map({ $form->{$_} = $saved_vars{$_}; } qw(id invnumber)); + } + + edit_e_mail(); + + $lxdebug->leave_sub(); +}

| + + + |; +} if ($form->{currency} eq $form->{defaultcurrency}) { @column_index = qw(datepaid source memo paid AR_paid); @@ -714,6 +1023,9 @@ sub form_footer { "; + my @triggers = (); + my $totalpaid = 0; + $form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"}); for $i (1 .. $form->{paidaccounts}) { @@ -726,59 +1038,76 @@ sub form_footer { # format amounts $totalpaid += $form->{"paid_$i"}; - $form->{"paid_$i"} = - $form->format_amount(\%myconfig, $form->{"paid_$i"}, 2); + if ($form->{"paid_$i"}) { + $form->{"paid_$i"} = + $form->format_amount(\%myconfig, $form->{"paid_$i"}, 2); + } $form->{"exchangerate_$i"} = $form->format_amount(\%myconfig, $form->{"exchangerate_$i"}); + if ($form->{"exchangerate_$i"} == 0) { + $form->{"exchangerate_$i"} = ""; + } $exchangerate = qq| |; if ($form->{currency} ne $form->{defaultcurrency}) { if ($form->{"forex_$i"}) { - $exchangerate = - qq|{"exchangerate_$i"}>$form->{"exchangerate_$i"}|; + $exchangerate = qq|$form->{"exchangerate_$i"}|; } else { - $exchangerate = - qq|{"exchangerate_$i"}>|; + $exchangerate = qq||; } } - $exchangerate .= qq| -{"forex_$i"}> -|; + $exchangerate .= qq||; $column_data{"paid_$i"} = - qq||; - $column_data{"exchangerate_$i"} = qq||; + qq||; + $column_data{"exchangerate_$i"} = qq||; $column_data{"AR_paid_$i"} = - qq||; + qq||; $column_data{"datepaid_$i"} = - qq||; + qq||; $column_data{"source_$i"} = - qq||; + qq||; $column_data{"memo_$i"} = - qq||; + qq||; map { print qq|$column_data{"${_}_$i"}\n| } @column_index; print " \n"; + push(@triggers, "datepaid_$i", "BL", "trigger_datepaid_$i"); } + my $paid_missing = $form->{oldinvtotal} - $totalpaid; + print qq| -{paidaccounts}> - -{oldinvtotal}> - + + + + + + + + + + + + +|; + + map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_})); } qw(paidaccounts selectAR_paid oldinvtotal)); + print qq|
| . $locale->text('Incoming Payments') . qq|
{"paid_$i"}>$exchangerate$exchangerate{"datepaid_$i"}> +
| . $locale->text('Total') . qq|| . H($form->format_amount(\%myconfig, $totalpaid, 2)) . qq|
| . $locale->text('Missing amount') . qq|| . H($form->format_amount(\%myconfig, $paid_missing, 2)) . qq|


|; - &print_options; + print_options(); print qq|