Revision 0f89f464
Von Bernd Bleßmann vor etwa 4 Jahren hinzugefügt
SL/Controller/CustomerVendorTurnover.pm | ||
---|---|---|
27 | 27 |
amount => { lt => \'paid'}, |
28 | 28 |
], |
29 | 29 |
], |
30 |
sort_by => 'transdate DESC', |
|
30 | 31 |
with_objects => [ 'dunnings' ], |
31 | 32 |
); |
32 | 33 |
} else { |
... | ... | |
38 | 39 |
amount => { lt => \'paid'}, |
39 | 40 |
], |
40 | 41 |
], |
41 |
sort_by => 'invnumber DESC',
|
|
42 |
sort_by => 'transdate DESC',
|
|
42 | 43 |
); |
43 | 44 |
} |
44 | 45 |
my $open_items; |
... | ... | |
180 | 181 |
if ( $::form->{db} eq 'customer' ) { |
181 | 182 |
$invoices = SL::DB::Manager::Invoice->get_all( |
182 | 183 |
query => [ customer_id => $cv, ], |
183 |
sort_by => 'invnumber DESC',
|
|
184 |
sort_by => 'transdate DESC',
|
|
184 | 185 |
); |
185 | 186 |
} else { |
186 | 187 |
$invoices = SL::DB::Manager::PurchaseInvoice->get_all( |
187 | 188 |
query => [ vendor_id => $cv, ], |
188 |
sort_by => 'invnumber DESC',
|
|
189 |
sort_by => 'transdate DESC',
|
|
189 | 190 |
); |
190 | 191 |
} |
191 | 192 |
$self->render('customer_vendor_turnover/invoices_statistic', { layout => 0 }, invoices => $invoices); |
... | ... | |
205 | 206 |
customer_id => $cv, |
206 | 207 |
quotation => ($type eq 'quotation' ? 'T' : 'F') |
207 | 208 |
], |
208 |
sort_by => ( $type eq 'order' ? 'ordnumber DESC' : 'quonumber DESC'),
|
|
209 |
sort_by => 'transdate DESC',
|
|
209 | 210 |
); |
210 | 211 |
} else { |
211 | 212 |
$orders = SL::DB::Manager::Order->get_all( |
... | ... | |
213 | 214 |
vendor_id => $cv, |
214 | 215 |
quotation => ($type eq 'quotation' ? 'T' : 'F') |
215 | 216 |
], |
216 |
sort_by => ( $type eq 'order' ? 'ordnumber DESC' : 'quonumber DESC'),
|
|
217 |
sort_by => 'transdate DESC',
|
|
217 | 218 |
); |
218 | 219 |
} |
219 | 220 |
if ( $type eq 'order') { |
... | ... | |
236 | 237 |
customer_id => $cv, |
237 | 238 |
closed => 'F', |
238 | 239 |
], |
239 |
sort_by => 'ordnumber DESC',
|
|
240 |
sort_by => 'transdate DESC',
|
|
240 | 241 |
); |
241 | 242 |
} else { |
242 | 243 |
$open_orders = SL::DB::Manager::Order->get_all( |
... | ... | |
244 | 245 |
vendor_id => $cv, |
245 | 246 |
closed => 'F', |
246 | 247 |
], |
247 |
sort_by => 'ordnumber DESC',
|
|
248 |
sort_by => 'transdate DESC',
|
|
248 | 249 |
); |
249 | 250 |
} |
250 | 251 |
|
Auch abrufbar als: Unified diff
S:C:CustomerVendorTurnover: Sortierung der Belege absteigend nach Datum