X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fis.pl;h=6ef3fb24f71b1f37d99b930eabe5ee4cf1fa3e81;hb=6dc16826718038718653bb07b130299fe2366e45;hp=ae8c7748fcebfa89f0659f3dc22d844d35eaa850;hpb=342c174c0207e8d5d0ea0bd9b5eb7dc17c87d7b2;p=kivitendo-erp.git diff --git a/bin/mozilla/is.pl b/bin/mozilla/is.pl index ae8c7748f..6ef3fb24f 100644 --- a/bin/mozilla/is.pl +++ b/bin/mozilla/is.pl @@ -44,8 +44,18 @@ require "$form->{path}/arap.pl"; sub add { $lxdebug->enter_sub(); + + 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->{title} = $locale->text('Add Sales Invoice'); $form->{callback} = "$form->{script}?action=add&type=$form->{type}&login=$form->{login}&path=$form->{path}&password=$form->{password}" @@ -57,9 +67,10 @@ sub add { { $form->error("Access Denied"); } - &invoice_links; &prepare_invoice; + $form->{format} = "pdf"; + &display_form; $lxdebug->leave_sub(); @@ -67,16 +78,26 @@ sub add { sub edit { $lxdebug->enter_sub(); - print STDERR "is.pl-edit\n"; - $form->{title} = $locale->text('Edit Sales Invoice'); + 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->{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(); @@ -84,7 +105,7 @@ sub edit { sub invoice_links { $lxdebug->enter_sub(); - print STDERR "is.pl-invoice_links\n"; + $form->{vc} = 'customer'; # create links @@ -98,14 +119,51 @@ sub invoice_links { $form->{customer_id} = $form->{all_customer}->[0]->{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]; @@ -113,7 +171,7 @@ sub invoice_links { $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} .= "|; + foreach $item (@{ $form->{payment_terms} }) { + if ($form->{payment_id} eq $item->{id}) { + $payment .= qq||; + } else { + $payment .= qq||; + } + } + + 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); + + 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->{SHIPTO} }) { + $form->{selectshipto} = ""; + foreach $item (@{ $form->{SHIPTO} }) { + if ($item->{shipto_id} == $form->{shipto_id}) { + $form->{selectshipto} .= + ""; + } else { + $form->{selectshipto} .= + ""; + } + + } + } 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| + + |; + + # set option selected - foreach $item (qw(AR customer currency department employee contact)) { + 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}); + #build contacts if ($form->{all_contacts}) { - $form->{selectcontact} = ""; + $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->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) { + $creditwarning = 1; + } else { + $creditwarning = 0; } #else {$form->{all_contacts} = 0;} @@ -282,7 +457,7 @@ sub form_header { #sk $contact = ($form->{selectcontact}) - ? qq|\n| + ? qq|\n| : qq||; $department = qq| @@ -309,46 +484,112 @@ 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|> - |; - - #write Trigger - $jsscript = - Form->write_trigger(\%myconfig, "2", "invdate", "BL", "trigger1", - "duedate", "BL", "trigger2"); + if ($form->{type} eq "credit_note") { + if ($form->{jsscript}) { + + # with JavaScript Calendar + $button1 = qq| + {invdate}> + text('button') . qq|> + |; + + #write Trigger + $jsscript = + Form->write_trigger(\%myconfig, "1", + "invdate", "BL", + "trigger1"); + } else { + + # without JavaScript Calendar + $button1 = + qq|{invdate}>|; + $button2 = + qq|{duedate}>|; + } } else { - - # without JavaScript Calendar - $button1 = - qq|{invdate}>|; - $button2 = - qq|{duedate}>|; + 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"); + } else { + + # without JavaScript Calendar + $button1 = + qq|{invdate}>|; + $button2 = + qq|{duedate}>|; + } } - if ($form->{resubmit}) { - $onload = "document.invoice.submit()"; + 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|document.invoice.submit()|; } else { $onload = "fokus()"; } + + $credittext = $locale->text('Credit Limit exceeded!!!'); + if ($creditwarning) { + $onload = qq|alert('$credittext')|; + } + $form->header; print qq| + + + +
{script}> @@ -379,6 +620,10 @@ sub form_header { {shipped}> +{storno}> +{storno_id}> + + @@ -414,13 +659,16 @@ sub form_header {
+ $shipto $business + $dunning | . $locale->text('Record in') . qq| - + + $taxzone $department | . $locale->text('Currency') . qq| @@ -438,8 +686,28 @@ sub form_header { | . $locale->text('Ship via') . qq| - - + |; +# +# +# +# +# +# +# +# +# +# +# +#
+# +# +#
+# +# +#
+# +# +print qq| @@ -448,8 +716,18 @@ sub form_header { + |; +if ($form->{type} eq "credit_note") { +print qq| + + + + $button1 + |; +} else { +print qq| @@ -462,6 +740,11 @@ sub form_header { $button2 + + $button3 + |; +} +print qq| @@ -520,7 +803,7 @@ $jsscript sub form_footer { $lxdebug->enter_sub(); - print STDERR "is.pl-form_footer\n"; + $form->{invtotal} = $form->{invsubtotal}; if (($rows = $form->numtextrows($form->{notes}, 26, 8)) < 2) { @@ -624,10 +907,13 @@ sub form_footer { + +
| . $locale->text('Credit Note Number') . qq|
| . $locale->text('Credit Note Date') . qq|
| . $locale->text('Invoice Number') . qq|
| . $locale->text('Delivery Date') . qq|
| . $locale->text('Order Number') . qq|
| . $locale->text('Notes') . qq| | . $locale->text('Internal Notes') . qq|| . $locale->text('Payment Terms') . qq|
$notes $intnotes
@@ -674,6 +960,17 @@ sub form_footer { print $webdav_list; } +if ($form->{type} eq "credit_note") { + print qq| + + + + + + +|; +} else { print qq| |; +} if ($form->{currency} eq $form->{defaultcurrency}) { @column_index = qw(datepaid source memo paid AR_paid); @@ -717,8 +1015,10 @@ 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"}); @@ -759,8 +1059,6 @@ sub form_footer { {oldinvtotal}> -{print_and_post}> -{second_run}>
| + . $locale->text('Payments') . qq|
@@ -683,6 +980,7 @@ sub form_footer { . $locale->text('Incoming Payments') . qq|
@@ -791,24 +1089,28 @@ sub form_footer { + . $locale->text('E-mail') . qq|">|; + print qq|| unless ($form->{storno}); + print qq| |; - - if (!$form->{revtrans}) { - if (!$form->{locked}) { - print qq| - - + if ($form->{id} && !($form->{type} eq "credit_note")) { + print qq| + |; - } - } + } + if ($form->{radier}) { + print qq| + +|; + } + if ($invdate > $closedto) { print qq| - |; @@ -864,6 +1166,9 @@ sub update { if ($form->{second_run}) { $form->{print_and_post} = 0; } + + $form->{update} = 1; + &check_name(customer); &check_project; @@ -904,7 +1209,7 @@ sub update { $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); &check_form; - } else { + } else { IS->retrieve_item(\%myconfig, \%$form); @@ -923,15 +1228,19 @@ sub update { } else { - $sellprice = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}); + $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); - #print STDERR " SELLPRICE-111- $sellprice\n"; 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+)/); @@ -1014,6 +1323,36 @@ 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(); @@ -1041,7 +1380,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!')); @@ -1065,8 +1404,15 @@ sub post { $form->{id} = 0 if $form->{postasnew}; - $form->{invnumber} = $form->update_defaults(\%myconfig, "invnumber") - unless $form->{invnumber}; + # get new invnumber in sequence if no invnumber is given or if posasnew was requested + if (!$form->{invnumber} || $form->{postasnew}) { + if ($form->{type} eq "credit_note") { + $form->{invnumber} = $form->update_defaults(\%myconfig, "cnnumber"); + } else { + $form->{invnumber} = $form->update_defaults(\%myconfig, "invnumber"); + } + } + relink_accounts(); if ($print_post) { if (!(IS->post_invoice(\%myconfig, \%$form))) { $form->error($locale->text('Cannot post invoice!')); @@ -1089,7 +1435,25 @@ sub print_and_post { $form->{print_and_post} = 1; &post(); - &display_form(); + &edit(); + $lxdebug->leave_sub(); + +} + +sub storno { + $lxdebug->enter_sub(); + + if ($form->{storno}) { + $form->error($locale->text('Cannot storno storno invoice!')); + } + + $form->{storno_id} = $form->{id}; + $form->{storno} = 1; + $form->{id} = ""; + $form->{invnumber} = "Storno zu " . $form->{invnumber}; + $form->{rowcount}--; + + &post(); $lxdebug->leave_sub(); } @@ -1145,6 +1509,60 @@ sub delete { $lxdebug->leave_sub(); } +sub credit_note { + $lxdebug->enter_sub(); + + $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();