Revision 98b64fe1
Von Kivitendo Admin vor fast 8 Jahren hinzugefügt
| SL/Common.pm | ||
|---|---|---|
| 67 | 67 |
} |
| 68 | 68 |
|
| 69 | 69 |
if ($form->{no_assemblies}) {
|
| 70 |
$filter .= qq| AND (NOT COALESCE(assembly, FALSE))|;
|
|
| 70 |
$filter .= qq| AND (NOT part_type = 'assembly')|;
|
|
| 71 | 71 |
} |
| 72 | 72 |
if ($form->{assemblies}) {
|
| 73 |
$filter .= qq| AND assembly=TRUE|;
|
|
| 73 |
$filter .= qq| AND part_type = 'assembly'|;
|
|
| 74 | 74 |
} |
| 75 | 75 |
|
| 76 | 76 |
if ($form->{no_services}) {
|
| 77 |
$filter .= qq| AND (inventory_accno_id is not NULL or assembly=TRUE)|;
|
|
| 77 |
$filter .= qq| AND NOT (part_type = 'service' OR part_type = 'assembly')|;
|
|
| 78 | 78 |
} |
| 79 | 79 |
|
| 80 | 80 |
substr($filter, 1, 3) = "WHERE" if ($filter); |
Auch abrufbar als: Unified diff
Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2
kivitendo Code angepasst.