From 517ed14d9733e94411274bd2b9fb59cef9e632ff Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Thu, 18 Jun 2020 13:51:44 +0200 Subject: [PATCH] =?utf8?q?Lieferdatum=20in=20Einkaufsrechnung=20erfassen?= =?utf8?q?=20k=C3=B6nnen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Das DB-Feld gab es schon, wurde aber nicht befüllt. --- SL/IR.pm | 12 ++++++------ templates/webpages/ir/form_header.html | 3 +++ 2 files changed, 9 insertions(+), 6 deletions(-) diff --git a/SL/IR.pm b/SL/IR.pm index aec03dcc7..402454d17 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -730,10 +730,10 @@ SQL # save AP record $query = qq|UPDATE ap SET - invnumber = ?, ordnumber = ?, quonumber = ?, transdate = ?, - orddate = ?, quodate = ?, vendor_id = ?, amount = ?, - netamount = ?, paid = ?, duedate = ?, - invoice = ?, taxzone_id = ?, notes = ?, taxincluded = ?, + invnumber = ?, ordnumber = ?, quonumber = ?, transdate = ?, + orddate = ?, quodate = ?, vendor_id = ?, amount = ?, + netamount = ?, paid = ?, duedate = ?, deliverydate = ?, + invoice = ?, taxzone_id = ?, notes = ?, taxincluded = ?, intnotes = ?, storno_id = ?, storno = ?, cp_id = ?, employee_id = ?, department_id = ?, delivery_term_id = ?, currency_id = (SELECT id FROM currencies WHERE name = ?), @@ -742,7 +742,7 @@ SQL @values = ( $form->{invnumber}, $form->{ordnumber}, $form->{quonumber}, conv_date($form->{invdate}), conv_date($form->{orddate}), conv_date($form->{quodate}), conv_i($form->{vendor_id}), $amount, - $netamount, $form->{paid}, conv_date($form->{duedate}), + $netamount, $form->{paid}, conv_date($form->{duedate}), conv_date($form->{deliverydate}), '1', $taxzone_id, $restricter->process($form->{notes}), $form->{taxincluded} ? 't' : 'f', $form->{intnotes}, conv_i($form->{storno_id}), $form->{storno} ? 't' : 'f', conv_i($form->{cp_id}), conv_i($form->{employee_id}), conv_i($form->{department_id}), conv_i($form->{delivery_term_id}), @@ -999,7 +999,7 @@ sub retrieve_invoice { # retrieve invoice $query = qq|SELECT cp_id, invnumber, transdate AS invdate, duedate, - orddate, quodate, globalproject_id, + orddate, quodate, deliverydate, globalproject_id, ordnumber, quonumber, paid, taxincluded, notes, taxzone_id, storno, gldate, mtime, itime, intnotes, (SELECT cu.name FROM currencies cu WHERE cu.id=ap.currency_id) AS currency, direct_debit, diff --git a/templates/webpages/ir/form_header.html b/templates/webpages/ir/form_header.html index 4389cd1b8..5b983c975 100644 --- a/templates/webpages/ir/form_header.html +++ b/templates/webpages/ir/form_header.html @@ -153,6 +153,9 @@ + + [% 'Delivery Date' | $T8 %] + [% L.date_tag('deliverydate', deliverydate) %] [% 'Order Number' | $T8 %] -- 2.20.1