Revision c09208f2
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/WH.pm | ||
|---|---|---|
| 656 | 656 |
( grep( { !/qty/ and !/^l_cvar/ and /^l_/ and $form->{$_} eq 'Y' } keys %$form),
|
| 657 | 657 |
qw(l_parts_id l_qty l_partunit) ); |
| 658 | 658 |
|
| 659 |
# add cvar for sorting |
|
| 660 |
if ($form->{sort} =~ /^cvar_/) {
|
|
| 661 |
my $sort_name = $form->{sort};
|
|
| 662 |
my $cvar_name = $sort_name; |
|
| 663 |
$cvar_name =~ s/^cvar_//; |
|
| 664 |
|
|
| 665 |
$select_clause .= ", cvar_fields.$sort_name"; |
|
| 666 |
$group_clause .= ", cvar_fields.$sort_name"; |
|
| 667 |
$joins .= qq| |
|
| 668 |
LEFT JOIN ( |
|
| 669 |
SELECT text_value as $sort_name, trans_id |
|
| 670 |
FROM custom_variable_configs cvar_cfg |
|
| 671 |
LEFT JOIN custom_variables cvar |
|
| 672 |
ON (cvar_cfg.module = 'IC' AND cvar_cfg.name = '$cvar_name' |
|
| 673 |
AND cvar_cfg.id = cvar.config_id) |
|
| 674 |
) cvar_fields ON (cvar_fields.trans_id = p.id) |
|
| 675 |
|; |
|
| 676 |
} |
|
| 677 |
|
|
| 659 | 678 |
my ($cvar_where, @cvar_values) = CVar->build_filter_query( |
| 660 | 679 |
module => 'IC', |
| 661 | 680 |
trans_id_field => 'p.id', |
| bin/mozilla/wh.pl | ||
|---|---|---|
| 978 | 978 |
my $href = build_std_url('action=generate_report', grep { $form->{$_} } @hidden_variables);
|
| 979 | 979 |
$href .= "&maxrows=".$form->{maxrows};
|
| 980 | 980 |
|
| 981 |
map { $column_defs{$_}->{link} = $href . "&page=".$page."&sort=${_}&order=" . Q($_ eq $sort_col ? 1 - $form->{order} : $form->{order}) } grep {!/^cvar_/} @columns;
|
|
| 981 |
my %cvar_is_text = (); |
|
| 982 |
$cvar_is_text{"cvar_$_->{name}"} = 1 for
|
|
| 983 |
grep {$_->{type} =~ m/text|textfield|htmlfield/}
|
|
| 984 |
@$cvar_configs; |
|
| 985 |
|
|
| 986 |
map { $column_defs{$_}->{link} = $href . "&page=".$page."&sort=${_}&order=" . Q($_ eq $sort_col ? 1 - $form->{order} : $form->{order}) }
|
|
| 987 |
grep {!/^cvar_/ or $cvar_is_text{$_}}
|
|
| 988 |
@columns; |
|
| 982 | 989 |
|
| 983 | 990 |
my %column_alignment = map { $_ => 'right' } qw(qty list_price purchase_price stock_value);
|
| 984 | 991 |
|
| doc/changelog | ||
|---|---|---|
| 14 | 14 |
- Volltextsuche auch für Lieferscheine |
| 15 | 15 |
- weitere Filtermöglichkeiten wie Zahlungsbedingen und Typ bei Mahnungen erzeugen |
| 16 | 16 |
- In diversen Formularfeldern Kunden/Lieferanten trailing withespaces nicht speichern |
| 17 |
- Bericht Lagerbestand nach text-artigen benutzer definierten Variablen |
|
| 18 |
sortieren lassen |
|
| 17 | 19 |
|
| 18 | 20 |
2023-04-05 - Release 3.8.0 |
| 19 | 21 |
|
Auch abrufbar als: Unified diff
Lagerbestand nach textartigen BDVs sortieren