Merge von 578 aus unstable: Bug Nr 190 geloest. Abteilung1 und 2 wurden bei der Liefe...

DB-Schema ändert sich!

diff --git a/SL/Form.pm b/SL/Form.pm
index ebc7e82f8c2e3c776863fca080ebd7c3ce12cb27..62a76e7100c3fcf881e166ffda38bceef6eae945 100644 (file)
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -1253,7 +1253,7 @@ sub add_shipto {
 ##LINET
   my $shipto;
   foreach
 ##LINET
   my $shipto;
   foreach

-    my $item (qw(name street zipcode city country contact phone fax email)) {
+    my $item (qw(name department_1 department_2 street zipcode city country contact phone fax email)) {

     if ($self->{"shipto$item"}) {
       $shipto = 1 if ($self->{$item} ne $self->{"shipto$item"});
     }
     if ($self->{"shipto$item"}) {
       $shipto = 1 if ($self->{$item} ne $self->{"shipto$item"});
     }


@@ -1261,10 +1261,10 @@ sub add_shipto {
   }
 
   if ($shipto) {
   }
 
   if ($shipto) {

-    my $query = qq|INSERT INTO shipto (trans_id, shiptoname, shiptostreet,
+    my $query = qq|INSERT INTO shipto (trans_id, shiptoname, shiptodepartment_1, shiptodepartment_2, shiptostreet,

                    shiptozipcode, shiptocity, shiptocountry, shiptocontact,
                   shiptophone, shiptofax, shiptoemail) VALUES ($id,
                    shiptozipcode, shiptocity, shiptocountry, shiptocontact,
                   shiptophone, shiptofax, shiptoemail) VALUES ($id,

-                  '$self->{shiptoname}', '$self->{shiptostreet}',
+                  '$self->{shiptoname}', '$self->{shiptodepartment_1}', '$self->{shiptodepartment_2}', '$self->{shiptostreet}',

                   '$self->{shiptozipcode}', '$self->{shiptocity}',
                   '$self->{shiptocountry}', '$self->{shiptocontact}',
                   '$self->{shiptophone}', '$self->{shiptofax}',
                   '$self->{shiptozipcode}', '$self->{shiptocity}',
                   '$self->{shiptocountry}', '$self->{shiptocontact}',
                   '$self->{shiptophone}', '$self->{shiptofax}',

diff --git a/SL/IS.pm b/SL/IS.pm
index b74a7944bb2c91345f2c7b4b16109c46592e540a..eac4440ae513329182f29f1d103c84bfe8d4179d 100644 (file)
--- a/SL/IS.pm
+++ b/SL/IS.pm
@@ -1357,7 +1357,7 @@ sub get_customer {
   # get shipto if we did not converted an order or invoice
   if (!$form->{shipto}) {
     map { delete $form->{$_} }
   # get shipto if we did not converted an order or invoice
   if (!$form->{shipto}) {
     map { delete $form->{$_} }

-      qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail);
+      qw(shiptoname shiptodepartment_1 shiptodepartment_2 shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail);

 
     $query = qq|SELECT s.* FROM shipto s
                 WHERE s.trans_id = $form->{customer_id}|;
 
     $query = qq|SELECT s.* FROM shipto s
                 WHERE s.trans_id = $form->{customer_id}|;

diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql
index d6b0ebb0ab8afca591fa850e9e4f98b3f4d10964..476e4020bd68c0d8af4ddc67171d4e28e765f314 100644 (file)
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -128,6 +128,10 @@ alter table vendor add column user_password varchar(12);
 alter table customer add column salesman_id integer;
 alter table vendor add column salesman_id integer;
 
 alter table customer add column salesman_id integer;
 alter table vendor add column salesman_id integer;
 

+-- Shipto
+alter table shipto add column shiptodepartment_1 varchar(75);
+alter table shipto add column shiptodepartment_2 varchar(75);
+

 -- Addon for business
 alter table business add column salesman boolean;
 alter table business alter column salesman set default 'false';
 -- Addon for business
 alter table business add column salesman boolean;
 alter table business alter column salesman set default 'false';

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index d2c0bca27b925363873d17595910e85dbac5bd9b..3be0a85465669e8f402a68fc556349f9af8021e4 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -417,6 +417,8 @@ CREATE TABLE "employee" (
 CREATE TABLE "shipto" (
        "trans_id" integer,
        "shiptoname" character varying(75),
 CREATE TABLE "shipto" (
        "trans_id" integer,
        "shiptoname" character varying(75),

+        "shiptodepartment_1" character varying(75),
+        "shiptodepartment_2" character varying(75),

        "shiptostreet" character varying(75),
        "shiptozipcode" character varying(75),
        "shiptocity" character varying(75),
        "shiptostreet" character varying(75),
        "shiptozipcode" character varying(75),
        "shiptocity" character varying(75),