Revision ccde19fe
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 690 | 690 |
my $dbh = $form->dbconnect($myconfig); |
| 691 | 691 |
|
| 692 | 692 |
my $query = |
| 693 |
qq|SELECT p.id, p.partnumber, p.description, p.sellprice, p.weight, p.onhand, p.unit, pg.partsgroup |
|
| 693 |
qq|SELECT p.id, p.partnumber, p.description, p.sellprice, p.weight, p.onhand, p.unit, pg.partsgroup, |
|
| 694 |
p.price_factor_id, pfac.factor AS price_factor |
|
| 694 | 695 |
FROM parts p |
| 695 | 696 |
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) |
| 697 |
LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id |
|
| 696 | 698 |
WHERE $where|; |
| 697 | 699 |
$form->{item_list} = selectall_hashref_query($form, $dbh, $query, @values);
|
| 698 | 700 |
|
| bin/mozilla/ic.pl | ||
|---|---|---|
| 1586 | 1586 |
$form->{"partnumber_$i"} =~ s/\"/"/g;
|
| 1587 | 1587 |
|
| 1588 | 1588 |
$linetotal = |
| 1589 |
$form->round_amount($form->{"sellprice_$i"} * $form->{"qty_$i"}, 2);
|
|
| 1589 |
$form->round_amount($form->{"sellprice_$i"} * $form->{"qty_$i"} / ($form->{"price_factor_$i"} || 1), 2);
|
|
| 1590 | 1590 |
$line_purchase_price = |
| 1591 |
$form->round_amount($form->{"lastcost_$i"} * $form->{"qty_$i"}, 2); #lastcost == purchase_price | ungenaue datenbankfeld-übersetzung
|
|
| 1591 |
$form->round_amount($form->{"lastcost_$i"} * $form->{"qty_$i"} / ($form->{"price_factor_$i"} || 1), 2); #lastcost == purchase_price | ungenaue datenbankfeld-übersetzung
|
|
| 1592 | 1592 |
$form->{assemblytotal} += $linetotal;
|
| 1593 | 1593 |
$form->{assembly_purchase_price_total} += $line_purchase_price;
|
| 1594 | 1594 |
|
| ... | ... | |
| 1672 | 1672 |
<input type=hidden name="id_$i" value=$form->{"id_$i"}>
|
| 1673 | 1673 |
<input type=hidden name="sellprice_$i" value=$form->{"sellprice_$i"}>
|
| 1674 | 1674 |
<input type=hidden name="weight_$i" value=$form->{"weight_$i"}>
|
| 1675 |
<input type=hidden name="price_factor_id_$i" value=$form->{"price_factor_id_$i"}>
|
|
| 1676 |
<input type=hidden name="price_factor_$i" value=$form->{"price_factor_$i"}>
|
|
| 1675 | 1677 |
|; |
| 1676 | 1678 |
} |
| 1677 | 1679 |
|
Auch abrufbar als: Unified diff
Pricefaktoren auch im assembly_row flow mitschleifen und berechnen.
Fix für Bug 987