Revision 7bad0cfe
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
SL/IC.pm | ||
---|---|---|
944 | 944 |
push @bsooqr_tokens, q|module = 'oe' AND quotation AND cv = 'vendor'| if $form->{rfq}; |
945 | 945 |
push @where_tokens, join ' OR ', map { "($_)" } @bsooqr_tokens if $bsooqr; |
946 | 946 |
|
947 |
$renamed_columns{onhand} = 'onhand_before_bsooqr'; |
|
948 |
$renamed_columns{qty} = 'onhand'; |
|
949 |
|
|
950 | 947 |
$joins_needed{partsgroup} = 1; |
951 | 948 |
$joins_needed{pfac} = 1; |
952 | 949 |
$joins_needed{makemodel} = 1 if grep { $form->{$_} || $form->{"l_$_"} } @makemodel_filters; |
... | ... | |
954 | 951 |
$joins_needed{apoe} = 1 if $joins_needed{cv} || grep { $form->{$_} || $form->{"l_$_"} } @apoe_filters; |
955 | 952 |
$joins_needed{invoice_oi} = 1 if $joins_needed{apoe} || grep { $form->{$_} || $form->{"l_$_"} } @invoice_oi_filters; |
956 | 953 |
|
954 |
# in bsoorq, use qtys instead of onhand |
|
955 |
if ($joins_needed{invoice_oi}) { |
|
956 |
$renamed_columns{onhand} = 'onhand_before_bsooqr'; |
|
957 |
$renamed_columns{qty} = 'onhand'; |
|
958 |
} |
|
959 |
|
|
957 | 960 |
# special case for description search. |
958 | 961 |
# up in the simple filter section the description filter got interpreted as something like: WHERE description ILIKE '%$form->{description}%' |
959 | 962 |
# now we'd like to search also for the masked description entered in orderitems and invoice, so... |
Auch abrufbar als: Unified diff
Bugfix: Mnge wurde nicht korrekt auf onhand gemappt.