Revision 98b64fe1
Von Kivitendo Admin vor mehr als 7 Jahren hinzugefügt
| sql/Pg-upgrade2/erzeugnisnummern.pl | ||
|---|---|---|
| 79 | 79 |
} |
| 80 | 80 |
|
| 81 | 81 |
if ($::form->{filter_type} eq 'assembly') {
|
| 82 |
$where .= ' AND assembly';
|
|
| 82 |
$where .= " AND part_type = 'assembly'";
|
|
| 83 | 83 |
} |
| 84 | 84 |
|
| 85 | 85 |
if ($::form->{filter_type} eq 'service') {
|
| 86 |
$where .= ' AND inventory_accno_id IS NULL AND NOT assembly';
|
|
| 86 |
$where .= " AND part_type = 'service'";
|
|
| 87 | 87 |
} |
| 88 | 88 |
|
| 89 | 89 |
if ($::form->{filter_type} eq 'part') {
|
| 90 |
$where .= ' AND inventory_accno_id IS NOT NULL'; |
|
| 91 |
$where .= ' AND NOT assembly'; |
|
| 90 |
$where .= " AND part_type = 'part'"; |
|
| 92 | 91 |
} |
| 93 | 92 |
|
| 94 | 93 |
if ($::form->{filter_obsolete} eq 'obsolete') {
|
Auch abrufbar als: Unified diff
Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2
kivitendo Code angepasst.