Revision b213d89c
Von Sven Schöling vor mehr als 12 Jahren hinzugefügt
| SL/DB/OrderItem.pm | ||
|---|---|---|
| 68 | 68 |
qty => [ 'qty' ], |
| 69 | 69 |
ordnumber => [ 'order.ordnumber' ], |
| 70 | 70 |
customer => [ 'lower(customer.name)', ], |
| 71 |
position => [ 'trans_id' ], |
|
| 72 |
reqdate => [ 'COALESCE(orderitems.reqdate, order.transdate)' ],
|
|
| 71 |
position => [ 'trans_id', 'runningnumber' ],
|
|
| 72 |
reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ],
|
|
| 73 | 73 |
orddate => [ 'order.orddate' ], |
| 74 | 74 |
sellprice => [ 'sellprice' ], |
| 75 | 75 |
discount => [ 'discount' ], |
| 76 |
transdate => [ 'transdate::date', 'order.reqdate' ], |
|
| 76 | 77 |
}, |
| 77 | 78 |
default => [ 'position', 1 ], |
| 78 | 79 |
nulls => { }
|
Auch abrufbar als: Unified diff
DeliveryPlan
Erste Version squashed (überspringt 10 Commits, in denen das Query unbrauchbar langsam ist)