Revision 4791d8a3
Von Bernd Blessmann vor fast 13 Jahren hinzugefügt
SL/DO.pm | ||
---|---|---|
252 | 252 |
id, delivery_order_id, parts_id, description, longdescription, qty, base_qty, |
253 | 253 |
sellprice, discount, unit, reqdate, project_id, serialnumber, |
254 | 254 |
ordnumber, transdate, cusordnumber, |
255 |
lastcost, price_factor_id, price_factor, marge_price_factor) |
|
255 |
lastcost, price_factor_id, price_factor, marge_price_factor, pricegroup_id)
|
|
256 | 256 |
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, |
257 |
(SELECT factor FROM price_factors WHERE id = ?), ?)|; |
|
257 |
(SELECT factor FROM price_factors WHERE id = ?), ?, ?)|;
|
|
258 | 258 |
my $h_item = prepare_query($form, $dbh, $q_item); |
259 | 259 |
|
260 | 260 |
my $q_item_stock = |
... | ... | |
301 | 301 |
$form->{"cusordnumber_$i"}, |
302 | 302 |
$form->{"lastcost_$i"}, |
303 | 303 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}), |
304 |
conv_i($form->{"marge_price_factor_$i"})); |
|
304 |
conv_i($form->{"marge_price_factor_$i"}), |
|
305 |
conv_i($form->{"pricegroup_id_$i"})); |
|
305 | 306 |
do_statement($form, $h_item, $q_item, @values); |
306 | 307 |
|
307 | 308 |
my $stock_info = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_$i"}); |
... | ... | |
670 | 671 |
doi.sellprice, doi.parts_id AS id, doi.unit, doi.discount, p.bin, p.notes AS partnotes, |
671 | 672 |
doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost, |
672 | 673 |
doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription, |
673 |
doi.price_factor_id, doi.price_factor, doi.marge_price_factor, |
|
674 |
doi.price_factor_id, doi.price_factor, doi.marge_price_factor, doi.pricegroup_id,
|
|
674 | 675 |
pr.projectnumber, dord.transdate AS dord_transdate, |
675 | 676 |
pg.partsgroup |
676 | 677 |
FROM delivery_order_items doi |
Auch abrufbar als: Unified diff
Bugfix für Bug 1770 (zweiter Teil):
Preisgruppen überleben jetzt Workflow über Lieferschein.