Revision 2b02691d
Von Tamino Steinert vor etwa 2 Jahren hinzugefügt
SL/DB/DeliveryOrder.pm | ||
---|---|---|
184 | 184 |
# }}} for vim folds |
185 | 185 |
} elsif ( ref($source) eq 'SL::DB::Reclamation' ) { |
186 | 186 |
map{ ( $record_args{$_} = $source->$_ ) } # {{{ for vim folds |
187 |
#billing_address_id #TODO(Tamino): add billing_address_id to reclamation |
|
188 | 187 |
qw( |
188 |
billing_address_id |
|
189 | 189 |
currency_id |
190 | 190 |
customer_id |
191 | 191 |
delivery_term_id |
SL/DB/MetaSetup/Reclamation.pm | ||
---|---|---|
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 | 12 |
amount => { type => 'numeric', precision => 15, scale => 5 }, |
13 |
billing_address_id => { type => 'integer' }, |
|
13 | 14 |
closed => { type => 'boolean', default => 'false', not_null => 1 }, |
14 | 15 |
contact_id => { type => 'integer' }, |
15 | 16 |
currency_id => { type => 'integer', not_null => 1 }, |
... | ... | |
48 | 49 |
__PACKAGE__->meta->allow_inline_column_values(1); |
49 | 50 |
|
50 | 51 |
__PACKAGE__->meta->foreign_keys( |
52 |
billing_address => { |
|
53 |
class => 'SL::DB::AdditionalBillingAddress', |
|
54 |
key_columns => { billing_address_id => 'id' }, |
|
55 |
}, |
|
56 |
|
|
51 | 57 |
contact => { |
52 | 58 |
class => 'SL::DB::Contact', |
53 | 59 |
key_columns => { contact_id => 'cp_id' }, |
SL/DB/Order.pm | ||
---|---|---|
412 | 412 |
: undef |
413 | 413 |
: die "Wrong state for reqdate"; |
414 | 414 |
} elsif ( ref($source) eq 'SL::DB::Reclamation') { |
415 |
#TODO(Tamino): add billing_address_id to reclamation |
|
416 | 415 |
%args = ( map({ ( $_ => $source->$_ ) } qw( |
417 |
amount currency_id customer_id delivery_term_id department_id |
|
416 |
amount billing_address_id currency_id customer_id delivery_term_id department_id
|
|
418 | 417 |
exchangerate globalproject_id intnotes language_id netamount |
419 | 418 |
notes payment_id reqdate salesman_id shippingpoint shipvia taxincluded |
420 | 419 |
tax_point taxzone_id transaction_description vendor_id |
SL/DB/Reclamation.pm | ||
---|---|---|
353 | 353 |
map { $record_args{$_} = $source->$_ } # {{{ for vim folds |
354 | 354 |
qw( |
355 | 355 |
amount |
356 |
billing_address_id |
|
356 | 357 |
contact_id |
357 | 358 |
currency_id |
358 | 359 |
customer_id |
... | ... | |
379 | 380 |
map { $record_args{$_} = $source->$_ } # {{{ for vim folds |
380 | 381 |
qw( |
381 | 382 |
amount |
383 |
billing_address_id |
|
382 | 384 |
currency_id |
383 | 385 |
customer_id |
384 | 386 |
delivery_term_id |
... | ... | |
405 | 407 |
} elsif ( $is_abbr_any->(qw(sdsr pdpr)) ) { #DeliveryOrder |
406 | 408 |
map { $record_args{$_} = $source->$_ } # {{{ for vim folds |
407 | 409 |
qw( |
410 |
billing_address_id |
|
408 | 411 |
currency_id |
409 | 412 |
customer_id |
410 | 413 |
delivery_term_id |
... | ... | |
430 | 433 |
map { $record_args{$_} = $source->$_ } # {{{ for vim folds |
431 | 434 |
qw( |
432 | 435 |
amount |
436 |
billing_address_id |
|
433 | 437 |
currency_id |
434 | 438 |
customer_id |
435 | 439 |
delivery_term_id |
... | ... | |
477 | 481 |
|
478 | 482 |
if ( ($from_to->{from} =~ m{sales}) && ($from_to->{to} =~ m{purchase}) ) { |
479 | 483 |
$record_args{customer_id} = undef; |
484 |
$record_args{billing_address_id} = undef; |
|
480 | 485 |
$record_args{salesman_id} = undef; |
481 | 486 |
$record_args{payment_id} = undef; |
482 | 487 |
$record_args{delivery_term_id} = undef; |
sql/Pg-upgrade2/reclamation_add_additional_billing_addresses.sql | ||
---|---|---|
1 |
-- @tag: reclamation_add_additional_billing_addresses |
|
2 |
-- @description: Kundenstammdaten: zusätzliche Rechnungsadressen auch in Reclamation |
|
3 |
-- @depends: reclamations customer_additional_billing_addresses |
|
4 |
|
|
5 |
ALTER TABLE reclamations |
|
6 |
ADD COLUMN billing_address_id INTEGER, |
|
7 |
ADD FOREIGN KEY (billing_address_id) |
|
8 |
REFERENCES additional_billing_addresses (id); |
t/workflow/invoice_to_reclamation.t | ||
---|---|---|
265 | 265 |
ok Compare($purchase_invoice->strip->as_tree, $converted_purchase_reclamation->strip->as_tree, {ignore_hash_keys => [qw( |
266 | 266 |
id employee_id itime mtime transdate |
267 | 267 |
datepaid deliverydate direct_debit duedate gldate invoice orddate ordnumber paid quodate quonumber storno storno_id type |
268 |
customer_id cv_record_number delivered closed exchangerate reqdate salesman_id shippingpoint shipto_id |
|
268 |
billing_address_id customer_id cv_record_number delivered closed exchangerate reqdate salesman_id shippingpoint shipto_id
|
|
269 | 269 |
cp_id contact_id |
270 | 270 |
invnumber record_number |
271 | 271 |
)]}); |
templates/webpages/reclamation/tabs/basic_data.html | ||
---|---|---|
51 | 51 |
</td> |
52 | 52 |
</tr> |
53 | 53 |
|
54 |
[%- IF SELF.cv == "customer" %] |
|
55 |
<tr id="billing_address_row"[% IF !SELF.reclamation.customer.additional_billing_addresses.as_list.size %] style="display:none"[% END %]> |
|
56 |
<th align="right">[% 'Custom Billing Address' | $T8 %]</th> |
|
57 |
<td> |
|
58 |
[% L.select_tag('reclamation.billing_address_id', |
|
59 |
SELF.reclamation.customer.additional_billing_addresses, |
|
60 |
default=SELF.reclamation.billing_address_id, |
|
61 |
title_key='displayable_id', |
|
62 |
value_key='id', |
|
63 |
with_empty=1, |
|
64 |
style='width: 300px') %] |
|
65 |
</td> |
|
66 |
</tr> |
|
67 |
[%- END %] |
|
68 |
|
|
54 | 69 |
[%- PROCESS reclamation/tabs/basic_data/_business_info_row.html SELF=SELF %] |
55 | 70 |
|
56 | 71 |
<tr> |
Auch abrufbar als: Unified diff
Reclamation: add billing_address_id to reclamation