Revision 98b64fe1
Von Kivitendo Admin vor mehr als 7 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
| 1218 | 1218 |
my $i = $form->{rowcount};
|
| 1219 | 1219 |
|
| 1220 | 1220 |
# don't include assemblies or obsolete parts |
| 1221 |
my $where = "NOT p.assembly = '1' AND NOT p.obsolete = '1'";
|
|
| 1221 |
my $where = "NOT p.part_type = 'assembly' AND NOT p.obsolete = '1'";
|
|
| 1222 | 1222 |
my @values; |
| 1223 | 1223 |
|
| 1224 | 1224 |
foreach my $table_column (qw(p.partnumber p.description pg.partsgroup)) {
|
| ... | ... | |
| 1276 | 1276 |
my $query = |
| 1277 | 1277 |
qq|SELECT |
| 1278 | 1278 |
p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice, |
| 1279 |
p.unit, p.assembly, p.onhand, p.formel,
|
|
| 1279 |
p.unit, p.part_type, p.onhand, p.formel,
|
|
| 1280 | 1280 |
p.notes AS partnotes, p.notes AS longdescription, p.not_discountable, |
| 1281 | 1281 |
p.inventory_accno_id, p.price_factor_id, |
| 1282 | 1282 |
p.ean, |
Auch abrufbar als: Unified diff
Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2
kivitendo Code angepasst.