X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FCT.pm;h=e5ee4af82af93e5d3691456d01070bbd09b8fed2;hb=a59350b1434707a1fe65058938ef3f20ee2dca99;hp=db715ba0126fda3a36aa557ea75a082f16af955c;hpb=52c9a08d4fc28b6027b8f6044e85043ec9e75335;p=kivitendo-erp.git diff --git a/SL/CT.pm b/SL/CT.pm index db715ba01..e5ee4af82 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -499,22 +499,31 @@ sub save_vendor { conv_i( $form->{language_id}), $form->{username}, $form->{user_password}, - conv_i($form->{v_customer_id}), + $form->{v_customer_id}, $form->{id} ); do_query($form, $dbh, $query, @values); $query = undef; if ( $form->{cp_id} ) { - $query = - qq|UPDATE contacts SET | . - qq| cp_greeting = ?, | . - qq| cp_title = ?, | . - qq| cp_givenname = ?, | . - qq| cp_name = ?, | . - qq| cp_email = ?, | . - qq| cp_phone1 = ?, | . - qq| cp_phone2 = ? | . + $query = qq|UPDATE contacts SET | . + qq|cp_greeting = ?, | . + qq|cp_title = ?, | . + qq|cp_givenname = ?, | . + qq|cp_name = ?, | . + qq|cp_email = ?, | . + qq|cp_phone1 = ?, | . + qq|cp_phone2 = ?, | . + qq|cp_abteilung = ?, | . + qq|cp_fax = ?, | . + qq|cp_mobile1 = ?, | . + qq|cp_mobile2 = ?, | . + qq|cp_satphone = ?, | . + qq|cp_satfax = ?, | . + qq|cp_project = ?, | . + qq|cp_privatphone = ?, | . + qq|cp_privatemail = ?, | . + qq|cp_birthday = ? | . qq|WHERE cp_id = ?|; @values = ( $form->{cp_greeting}, @@ -524,20 +533,45 @@ sub save_vendor { $form->{cp_email}, $form->{cp_phone1}, $form->{cp_phone2}, - $form->{cp_id}); + $form->{cp_abteilung}, + $form->{cp_fax}, + $form->{cp_mobile1}, + $form->{cp_mobile2}, + $form->{cp_satphone}, + $form->{cp_satfax}, + $form->{cp_project}, + $form->{cp_privatphone}, + $form->{cp_privatemail}, + $form->{cp_birthday}, + $form->{cp_id} + ); } elsif ( $form->{cp_name} || $form->{cp_givenname} ) { $query = - qq|INSERT INTO contacts ( cp_cv_id, cp_greeting, cp_title, cp_givenname, cp_name, cp_email, cp_phone1, cp_phone2) | . - qq|VALUES (?, ?, ?, ?, ?, ?, ?, ?)|; + qq|INSERT INTO contacts ( cp_cv_id, cp_greeting, cp_title, cp_givenname, | . + qq| cp_name, cp_email, cp_phone1, cp_phone2, cp_abteilung, cp_fax, cp_mobile1, | . + qq| cp_mobile2, cp_satphone, cp_satfax, cp_project, cp_privatphone, cp_privatemail, | . + qq| cp_birthday) | . + qq|VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)|; @values = ( - conv_i($form->{id}), + $form->{id}, $form->{cp_greeting}, $form->{cp_title}, $form->{cp_givenname}, $form->{cp_name}, $form->{cp_email}, $form->{cp_phone1}, - $form->{cp_phone2}); + $form->{cp_phone2}, + $form->{cp_abteilung}, + $form->{cp_fax}, + $form->{cp_mobile1}, + $form->{cp_mobile2}, + $form->{cp_satphone}, + $form->{cp_satfax}, + $form->{cp_project}, + $form->{cp_privatphone}, + $form->{cp_privatemail}, + $form->{cp_birthday} + ); } do_query($form, $dbh, $query, @values) if ($query);