Revision 73c6a726
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 80 | 80 |
$query = |
| 81 | 81 |
qq|SELECT p.id, p.partnumber, p.description, |
| 82 | 82 |
p.sellprice, p.lastcost, p.weight, a.qty, a.bom, p.unit, |
| 83 |
pg.partsgroup |
|
| 83 |
pg.partsgroup, p.price_factor_id, pfac.factor AS price_factor
|
|
| 84 | 84 |
FROM parts p |
| 85 | 85 |
JOIN assembly a ON (a.parts_id = p.id) |
| 86 | 86 |
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) |
| 87 |
LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id |
|
| 87 | 88 |
WHERE (a.id = ?) |
| 88 | 89 |
ORDER BY $oid{$myconfig->{dbdriver}}|;
|
| 89 | 90 |
$sth = prepare_execute_query($form, $dbh, $query, conv_i($form->{id}));
|
Auch abrufbar als: Unified diff
Erzueugnisse mit Preisfaktoren beim laden mit auslesen.