Revision 7b18afd5
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 88 | 88 |
"ustid" => "ct.ustid", |
| 89 | 89 |
"creditlimit" => "ct.creditlimit", |
| 90 | 90 |
"commercial_court" => "ct.commercial_court", |
| 91 |
"dunning_lock" => "ct.dunning_lock", |
|
| 91 | 92 |
); |
| 92 | 93 |
|
| 93 | 94 |
$form->{sort} ||= "name";
|
| ... | ... | |
| 102 | 103 |
} |
| 103 | 104 |
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
| 104 | 105 |
|
| 105 |
if ($sortorder !~ /(business|creditlimit|id|discount|itime)/ && !$join_records) {
|
|
| 106 |
if ($sortorder !~ /(business|creditlimit|id|discount|itime|dunning_lock)/ && !$join_records) {
|
|
| 106 | 107 |
$sortorder = "lower($sortorder) ${sortdir}";
|
| 107 | 108 |
} else {
|
| 108 | 109 |
$sortorder .= " ${sortdir}";
|
| ... | ... | |
| 231 | 232 |
push @values, conv_date($form->{insertdateto});
|
| 232 | 233 |
} |
| 233 | 234 |
|
| 235 |
if($form->{dunning_lock} ne '') {
|
|
| 236 |
$where .= qq| AND ct.dunning_lock = ?|; |
|
| 237 |
push @values, $form->{dunning_lock};
|
|
| 238 |
} |
|
| 239 |
|
|
| 234 | 240 |
if ($form->{all}) {
|
| 235 | 241 |
my @tokens = parse_line('\s+', 0, $form->{all});
|
| 236 | 242 |
$where .= qq| AND ( |
Auch abrufbar als: Unified diff
customer: Mahnsperre in Bericht anzeigen, sortieren und filtern