Revision 98b64fe1
Von Kivitendo Admin vor mehr als 7 Jahren hinzugefügt
| SL/WH.pm | ||
|---|---|---|
| 191 | 191 |
|
| 192 | 192 |
my $query = qq|SELECT assembly.parts_id, assembly.qty, parts.warehouse_id |
| 193 | 193 |
FROM assembly INNER JOIN parts ON assembly.parts_id = parts.id |
| 194 |
WHERE assembly.id = ? AND (inventory_accno_id IS NOT NULL OR parts.assembly = TRUE)|;
|
|
| 194 |
WHERE assembly.id = ? AND parts.part_type != 'service'|;
|
|
| 195 | 195 |
|
| 196 | 196 |
my $sth_part_qty_assembly = prepare_execute_query($form, $dbh, $query, $params{assembly_id});
|
| 197 | 197 |
|
Auch abrufbar als: Unified diff
Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2
kivitendo Code angepasst.