Revision bf2e0489
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
SL/WH.pm | ||
---|---|---|
648 | 648 |
( grep( { !/qty/ and !/^l_cvar/ and /^l_/ and $form->{$_} eq 'Y' } keys %$form), |
649 | 649 |
qw(l_parts_id l_partunit) ); |
650 | 650 |
|
651 |
my @join_values = (); |
|
651 | 652 |
my %join_tokens = ( |
652 | 653 |
"stock_value" => "LEFT JOIN price_factors pfac ON (p.price_factor_id = pfac.id)", |
653 | 654 |
); |
... | ... | |
669 | 670 |
SELECT text_value as $sort_name, trans_id |
670 | 671 |
FROM custom_variable_configs cvar_cfg |
671 | 672 |
LEFT JOIN custom_variables cvar |
672 |
ON (cvar_cfg.module = 'IC' AND cvar_cfg.name = '$cvar_name'
|
|
673 |
ON (cvar_cfg.module = 'IC' AND cvar_cfg.name = ?
|
|
673 | 674 |
AND cvar_cfg.id = cvar.config_id) |
674 | 675 |
) cvar_fields ON (cvar_fields.trans_id = p.id) |
675 | 676 |
|; |
677 |
push @join_values, $cvar_name |
|
676 | 678 |
} |
679 |
@filter_vars = (@join_values, @filter_vars); |
|
677 | 680 |
|
678 | 681 |
my ($cvar_where, @cvar_values) = CVar->build_filter_query( |
679 | 682 |
module => 'IC', |
Auch abrufbar als: Unified diff
FIX: Lagerbestand BDVs: Wert für sql als Parameter übergeben