From 15e3714a4402c3771d539cdf7703fd374d2b77e1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Tue, 25 Aug 2020 15:12:07 +0200 Subject: [PATCH] =?utf8?q?Individuelle=20Lieferadresse=20hinzuf=C3=BCgen:?= =?utf8?q?=20falsche=20Reihenfolge=20der=20Werte=20korrigiert?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit kam mit "Individuelle Lieferadresse hinzufügen: cp_gender nicht vergessen" (commit bca91008eddc6a1734a75fcd555f10d1c8ac65f6), bzw. "Individuelle Lieferadresse hinzufügen: cp_gender nicht auf leer prüfen …" (commit b8fa93b5d2cfff453fd8a82206d1a288407a8be6) rein. Bezieht sich auch auf #410 (redmine) Refs #410 Behebt #438 (redmine). --- SL/Form.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/SL/Form.pm b/SL/Form.pm index c758659d4..63e072a1b 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -1898,10 +1898,10 @@ sub add_shipto { shiptocountry = ?, shiptogln = ?, shiptocontact = ?, - shiptocp_gender = ?, shiptophone = ?, shiptofax = ?, shiptoemail = ? + shiptocp_gender = ?, WHERE shipto_id = ?|; do_query($self, $dbh, $query, @values, $self->{shipto_id}); } else { @@ -1915,10 +1915,10 @@ sub add_shipto { shiptocountry = ? AND shiptogln = ? AND shiptocontact = ? AND - shiptocp_gender = ? AND shiptophone = ? AND shiptofax = ? AND shiptoemail = ? AND + shiptocp_gender = ? AND module = ? AND trans_id = ?|; my $insert_check = selectfirst_hashref_query($self, $dbh, $query, @values, $module, $id); @@ -1926,7 +1926,7 @@ sub add_shipto { my $insert_query = qq|INSERT INTO shipto (trans_id, shiptoname, shiptodepartment_1, shiptodepartment_2, shiptostreet, shiptozipcode, shiptocity, shiptocountry, shiptogln, - shiptocontact, shiptocp_gender, shiptophone, shiptofax, shiptoemail, module) + shiptocontact, shiptophone, shiptofax, shiptoemail, shiptocp_gender, module) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)|; do_query($self, $dbh, $insert_query, $id, @values, $module); -- 2.20.1