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.