X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fis.pl;h=459e1b9446ef40f03b7c6807360c497df5b9540a;hb=1514a9d0b358fad627d81e8c88f71536c4e0aaba;hp=3e7704972c7d605482b5e8668dee85395450d1c9;hpb=b3721e4e65d62ea30b68b00ac77b4495b1f17337;p=kivitendo-erp.git diff --git a/bin/mozilla/is.pl b/bin/mozilla/is.pl index 3e7704972..459e1b944 100644 --- a/bin/mozilla/is.pl +++ b/bin/mozilla/is.pl @@ -37,6 +37,7 @@ use Data::Dumper; require "$form->{path}/io.pl"; require "$form->{path}/arap.pl"; +require "bin/mozilla/drafts.pl"; 1; @@ -45,7 +46,19 @@ 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}" @@ -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,26 +121,64 @@ 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; + if ($payment_id) { + $form->{payment_id} = $payment_id; + } + if ($language_id) { + $form->{language_id} = $language_id; + } + if ($taxzone_id) { + $form->{taxzone_id} = $taxzone_id; + } + if ($shipto_id) { + $form->{shipto_id} = $shipto_id; + } + # currencies - @curr = split /:/, $form->{currencies}; + @curr = split(/:/, $form->{currencies}); chomp $curr[0]; $form->{defaultcurrency} = $curr[0]; - map { $form->{selectcurrency} .= "\n" } @curr; $form->{oldcustomer} = "$form->{customer}--$form->{customer_id}"; - if ($form->{all_customer}) { + if (@{ $form->{all_customer} }) { $form->{customer} = "$form->{customer}--$form->{customer_id}"; - map { $form->{selectcustomer} .= "\n" } (@{ $form->{all_customer} }); } @@ -130,7 +189,7 @@ sub invoice_links { map { $form->{selectdepartment} .= - "\n" } (@{ $form->{all_departments} }); } @@ -139,7 +198,7 @@ sub invoice_links { # sales staff if ($form->{all_employees}) { $form->{selectemployee} = ""; - map { $form->{selectemployee} .= "\n" } (@{ $form->{all_employees} }); } @@ -149,7 +208,8 @@ sub invoice_links { foreach $key (keys %{ $form->{AR_links} }) { foreach $ref (@{ $form->{AR_links}{$key} }) { - $form->{"select$key"} .= "\n"; } if ($key eq "AR_paid") { @@ -189,9 +249,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 +265,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 +299,150 @@ 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 ($edit) { + + if ($form->{type} eq "credit_note") { + $form->{title} = $locale->text('Edit Credit Note'); + + if ($form->{storno}) { + $form->{title} = $locale->text('Edit Storno Credit Note'); + } + } else { + $form->{title} = $locale->text('Edit Sales Invoice'); + + if ($form->{storno}) { + $form->{title} = $locale->text('Edit Storno Invoice'); + } + } + } + + $form->{radier} = + ($form->current_date(\%myconfig) eq $form->{gldate}) ? 1 : 0; + + $payment = qq||; + foreach $item (@{ $form->{payment_terms} }) { + if ($form->{payment_id} eq $item->{id}) { + $payment .= qq||; + } else { + $payment .= qq||; + } } - #build contacts - if ($form->{all_contacts}) { + my $set_duedate_url = + "$form->{script}?login=$form->{login}&path=$form->{path}&password=$form->{password}&action=set_duedate"; + + my $pjx = new CGI::Ajax( 'set_duedate' => $set_duedate_url ); + push(@ { $form->{AJAX} }, $pjx); - $form->{selectcontact} = ""; - foreach $item (@{ $form->{all_contacts} }) { - if ($form->{cp_id} == $item->{cp_id}) { - $form->{selectcontact} .= - ""; } else { - $form->{selectcontact} .= ""; } + + } + } else { + $form->{selecttaxzone} =~ s/ selected//g; + if ($form->{taxzone_id} ne "") { + $form->{selecttaxzone} =~ s/value=\"$form->{taxzone_id}\"/value=\"$form->{taxzone_id}\" selected/; } } - #else {$form->{all_contacts} = 0;} + $taxzone = qq| + + | . $locale->text('Steuersatz') . qq| + + + |; + + 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"); + + 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 = + NTI($cgi->popup_menu('-name' => 'cp_id', '-values' => \@values, + '-labels' => \%labels, '-default' => $form->{"cp_id"})); + + %labels = (); + @values = (""); + foreach my $item (@{ $form->{"ALL_SHIPTO"} }) { + push(@values, $item->{"shipto_id"}); + $labels{$item->{"shipto_id"}} = + $item->{"shiptoname"} . " " . $item->{"shiptodepartment_1"}; + } + + my $shipto = qq| + | . $locale->text('Shipping Address') . qq| + | . + NTI($cgi->popup_menu('-name' => 'shipto_id', '-values' => \@values, + '-labels' => \%labels, '-default' => $form->{"shipto_id"})) + . 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}, + '-values' => \@values, '-labels' => \%labels)) + . 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}/; + } + + #quote customer Bug 133 + $form->{selectcustomer} = $form->quote($form->{selectcustomer}); + + #substitute \n and \r to \s (bug 543) + $form->{selectcustomer} =~ s/[\n\r]/ /g; + + if (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) { + $creditwarning = 1; + } else { + $creditwarning = 0; + } $form->{exchangerate} = $form->format_amount(\%myconfig, $form->{exchangerate}); @@ -267,36 +456,33 @@ 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||; + ? qq|\n| + : qq||; $department = qq| | . $locale->text('Department') . qq| - - + + | if $form->{selectdepartment}; @@ -306,9 +492,9 @@ sub form_header { if ($form->{business}) { $business = qq| - | . $locale->text('Business') . qq| + | . $locale->text('Business') . qq| $form->{business} - | . $locale->text('Trade Discount') . qq| + | . $locale->text('Trade Discount') . qq| | . $form->format_amount(\%myconfig, $form->{tradediscount} * 100) . qq| % @@ -316,181 +502,278 @@ sub form_header { |; } + 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; $jsscript = ""; - if ($form->{jsscript}) { - - # with JavaScript Calendar - $button1 = qq| - {invdate}> - text('button') . qq|> - |; - $button2 = qq| - {duedate}> - text('button') . qq|> - |; - $button3 = qq| - {deliverydate}> - text('button') . qq|> - |; - - #write Trigger - $jsscript = - Form->write_trigger(\%myconfig, "3", "invdate", "BL", "trigger1", - "duedate", "BL", "trigger2", - "deliverydate", "BL", "trigger3"); + if ($form->{type} eq "credit_note") { + if ($form->{jsscript}) { + + # with JavaScript Calendar + $button1 = qq| + + |; + + #write Trigger + $jsscript = + Form->write_trigger(\%myconfig, "1", + "invdate", "BL", + "trigger1"); + } else { + + # without JavaScript Calendar + $button1 = + qq||; + $button2 = + qq||; + } } else { - - # without JavaScript Calendar - $button1 = - qq|{invdate}>|; - $button2 = - qq|{duedate}>|; + if ($form->{jsscript}) { + + # with JavaScript Calendar + $button1 = qq| + + + |; + $button2 = qq| + + + |; + $button3 = qq| + + + |; + + #write Trigger + $jsscript = + Form->write_trigger(\%myconfig, "3", + "invdate", "BL", + "trigger1", "duedate", + "BL", "trigger2", + "deliverydate", "BL", + "trigger3"); + } else { + + # without JavaScript Calendar + $button1 = + qq||; + $button2 = + qq|{duedate}>|; + } } 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()"; } - $form->header; - - print qq| - - -
{script}> + $credittext = $locale->text('Credit Limit exceeded!!!'); + if ($creditwarning) { + $onload = qq|alert('$credittext')|; + } -{id}> -{action}> - -{type}> -{media}> -{format}> - - - - - - -{vc}> - -{discount}> -{creditlimit}> -{creditremaining}> - -{tradediscount}> -{business}> - -{closedto}> -{locked}> + $form->{"javascript"} .= qq||; -{shipped}> - + $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| + + + + + + + +| ; +map({print $cgi->hidden("-name" => $_ , "-value" => $form->{$_});} + qw(id action type media format queued printed emailed title vc discount + creditlimit creditremaining tradediscount business closedto locked shipped storno storno_id)) ; +print ($form->{saved_message} ? qq|

$form->{saved_message}

| : "") ; +print qq| + + + +
$form->{title}
+ + - @@ -502,37 +785,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(); } @@ -550,16 +817,16 @@ sub form_footer { } $rows = ($rows > $introws) ? $rows : $introws; $notes = - qq||; + qq||; $intnotes = - qq||; + qq||; $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; $taxincluded = ""; if ($form->{taxaccounts}) { $taxincluded = qq| - {taxincluded}> | + {taxincluded}> | . $locale->text('Tax Included') . qq|

|; } @@ -577,8 +844,9 @@ sub form_footer { $tax .= qq|
- - + + |; } @@ -589,8 +857,8 @@ sub form_footer { $subtotal = qq| - - + + |; @@ -616,12 +884,13 @@ sub form_footer { $tax .= qq| - - + + - - + + |; } @@ -636,28 +905,31 @@ sub form_footer { print qq|
$form->{title}
- - +
+ + + |; +# +# +# +print qq|
- - - {customer_klass}> - {customer_id}> - - + + + + + - + - + $shipto $business + $dunning - - - + + + + $taxzone $department - - - - {defaultcurrency}> - {fxgain_accno}> - {fxloss_accno}> + + + + + + $exchangerate - - - + + - - - -
| . $locale->text('Customer') . qq|$customer| + | . $locale->text('Customer') . qq|$customer| . $locale->text('Contact Person') . qq|$contact$contact
+ - +
| . $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('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|
+# +# +# +# +# +# +# +# +# +#
+# +# +#
+# +# +#
+#
+ - - - + + + + $salesman +|; +if ($form->{type} eq "credit_note") { +print qq| + + + - - + + $button1 + |; +} else { +print qq| + + - + $button1 - + $button2 - + $button3 + |; +} +print qq| + + + + + + + - - + + + + + + + - - + + - - + +
| . $locale->text('Salesperson') . qq|| . $locale->text('Employee') . 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('Delivery Date') . qq|| . $locale->text('Delivery Date') . qq|
| . $locale->text('Order Number') . qq|
| . $locale->text('Order Date') . qq|
| . $locale->text('Order Number') . qq|| . $locale->text('Quotation Number') . qq|
| . $locale->text('Quotation Date') . qq|
| . $locale->text('Quotation Number') . 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"}
- - +
+ - @@ -669,20 +941,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
+ $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} }) { $webdav_list .= qq| - - + + |; } @@ -693,15 +965,27 @@ sub form_footer { print $webdav_list; } +if ($form->{type} eq "credit_note") { + print qq| + +
DateinameWebdavlink
$file$form->{WEBDAV}{$file}$file$form->{WEBDAV}{$file}
+ + + + +|; +} else { print qq|
| + . $locale->text('Payments') . qq|
- - - - + @@ -800,69 +1083,87 @@ 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| + |; } + # /button for saving history - print qq| - -{rowcount}> - - -{path}> -{login}> -{password}> + 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(path login password)); +print qq| @@ -881,9 +1182,10 @@ sub update { if ($form->{second_run}) { $form->{print_and_post} = 0; } - &check_name(customer); - &check_project; + $form->{update} = 1; + + &check_name(customer); $form->{exchangerate} = $exchangerate if ( @@ -921,7 +1223,7 @@ sub update { $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); &check_form; - } else { + } else { IS->retrieve_item(\%myconfig, \%$form); @@ -940,14 +1242,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+)/); @@ -1031,6 +1338,37 @@ sub update { $lxdebug->leave_sub(); } +sub post_payment { + $lxdebug->enter_sub(); + 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->isblank("invdate", $locale->text('Invoice Date missing!')); @@ -1057,7 +1395,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!')); @@ -1082,20 +1420,29 @@ sub post { $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->{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(); } @@ -1112,6 +1459,47 @@ 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(path login password id type))); } + keys(%{ $form })); + + &invoice_links; + &prepare_invoice; + relink_accounts(); + + $form->{storno_id} = $form->{id}; + $form->{storno} = 1; + $form->{id} = ""; + $form->{invnumber} = "Storno zu " . $form->{invnumber}; + + &post(); + $lxdebug->leave_sub(); + +} + sub preview { $lxdebug->enter_sub(); @@ -1135,7 +1523,7 @@ sub delete { print qq| -{script}> + |; # delete action variable @@ -1143,11 +1531,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') @@ -1155,7 +1543,7 @@ sub delete {

- |; @@ -1163,12 +1551,93 @@ 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->{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); @@ -724,6 +1008,8 @@ sub form_footer { "; + my @triggers = (); + $form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"}); for $i (1 .. $form->{paidaccounts}) { @@ -736,59 +1022,56 @@ 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"}); $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"); } - 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"}>{"datepaid_$i"}> +


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