Revision 252d90ef
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