Revision 4e35d4c0
Von Thomas Heck vor etwa 11 Jahren hinzugefügt
| SL/Controller/CustomerVendor.pm | ||
|---|---|---|
| 407 | 407 |
$qty_sign = ''; |
| 408 | 408 |
} |
| 409 | 409 |
|
| 410 |
my $where = ' WHERE 1=1 ';
|
|
| 410 |
my $where = ' WHERE 1=1'; |
|
| 411 | 411 |
my @values; |
| 412 | 412 |
|
| 413 | 413 |
if ( !$self->is_vendor() && $::form->{shipto_id} && $::form->{shipto_id} ne 'all' ) {
|
| 414 |
$where .= "AND ${arap}.shipto_id = ?";
|
|
| 414 |
$where .= " AND ${arap}.shipto_id = ?";
|
|
| 415 | 415 |
push(@values, $::form->{shipto_id});
|
| 416 |
} else {
|
|
| 417 |
$where .= " AND ${arap}.${db}_id = ?";
|
|
| 418 |
push(@values, $::form->{id});
|
|
| 416 | 419 |
} |
| 417 | 420 |
|
| 418 | 421 |
if ( $::form->{delivery_from} ) {
|
| 419 |
$where .= "AND ${arap}.transdate >= ?";
|
|
| 422 |
$where .= " AND ${arap}.transdate >= ?";
|
|
| 420 | 423 |
push(@values, conv_date($::form->{delivery_from}));
|
| 421 | 424 |
} |
| 422 | 425 |
|
| 423 | 426 |
if ( $::form->{delivery_to} ) {
|
| 424 |
$where .= "AND ${arap}.transdate <= ?";
|
|
| 427 |
$where .= " AND ${arap}.transdate <= ?";
|
|
| 425 | 428 |
push(@values, conv_date($::form->{delivery_to}));
|
| 426 | 429 |
} |
| 427 | 430 |
|
Auch abrufbar als: Unified diff
Kunden Lieferungen-Tab: bei "Alle" nach der Kundenid suchen
fixt #2393