Revision 53db54a8
Von Moritz Bunkus vor fast 5 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 1030 | 1030 |
my $sortorder = ""; |
| 1031 | 1031 |
if ($form->{groupitems}) {
|
| 1032 | 1032 |
$sortorder = |
| 1033 |
qq|ORDER BY pg.partsgroup, a.id|;
|
|
| 1033 |
qq|ORDER BY pg.partsgroup, a.position|;
|
|
| 1034 | 1034 |
} else {
|
| 1035 |
$sortorder = qq|ORDER BY a.id|;
|
|
| 1035 |
$sortorder = qq|ORDER BY a.position|;
|
|
| 1036 | 1036 |
} |
| 1037 | 1037 |
|
| 1038 | 1038 |
do_statement($form, $h_pg, $q_pg, conv_i($form->{"id_$i"}));
|
| SL/IS.pm | ||
|---|---|---|
| 442 | 442 |
my $sortorder = ""; |
| 443 | 443 |
if ($form->{groupitems}) {
|
| 444 | 444 |
$sortorder = |
| 445 |
qq|ORDER BY pg.partsgroup, a.id|;
|
|
| 445 |
qq|ORDER BY pg.partsgroup, a.position|;
|
|
| 446 | 446 |
} else {
|
| 447 |
$sortorder = qq|ORDER BY a.id|;
|
|
| 447 |
$sortorder = qq|ORDER BY a.position|;
|
|
| 448 | 448 |
} |
| 449 | 449 |
|
| 450 | 450 |
my $query = |
| SL/OE.pm | ||
|---|---|---|
| 1528 | 1528 |
# get parts and push them onto the stack |
| 1529 | 1529 |
my $sortorder = ""; |
| 1530 | 1530 |
if ($form->{groupitems}) {
|
| 1531 |
$sortorder = qq|ORDER BY pg.partsgroup, a.id|;
|
|
| 1531 |
$sortorder = qq|ORDER BY pg.partsgroup, a.position|;
|
|
| 1532 | 1532 |
} else {
|
| 1533 |
$sortorder = qq|ORDER BY a.id|;
|
|
| 1533 |
$sortorder = qq|ORDER BY a.position|;
|
|
| 1534 | 1534 |
} |
| 1535 | 1535 |
|
| 1536 | 1536 |
$query = qq|SELECT p.partnumber, p.description, p.unit, a.qty, | . |
Auch abrufbar als: Unified diff
Unterstützung für PostgreSQL 12 Teil 3
Sortierung der Erzeugnisse nach der dafür vorgesehenen
Positionsspalte, nicht ID.