Revision 46b430e4
Von Jan Büren vor fast 9 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 673 | 673 |
my $query = |
| 674 | 674 |
qq|SELECT p.id, p.partnumber, p.description, p.sellprice, |
| 675 | 675 |
p.weight, p.onhand, p.unit, pg.partsgroup, p.lastcost, |
| 676 |
p.price_factor_id, pfac.factor AS price_factor |
|
| 676 |
p.price_factor_id, pfac.factor AS price_factor, p.notes as longdescription
|
|
| 677 | 677 |
FROM parts p |
| 678 | 678 |
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) |
| 679 | 679 |
LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id |
Auch abrufbar als: Unified diff
select_item für Erzeugnisse auch Langtext anzeigen, falls aktiviert