Revision eebe8e90
Von Sven Schöling vor etwa 10 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 284 | 284 |
id, delivery_order_id, parts_id, description, longdescription, qty, base_qty, |
| 285 | 285 |
sellprice, discount, unit, reqdate, project_id, serialnumber, |
| 286 | 286 |
ordnumber, transdate, cusordnumber, |
| 287 |
lastcost, price_factor_id, price_factor, marge_price_factor, pricegroup_id) |
|
| 287 |
lastcost, price_factor_id, price_factor, marge_price_factor, pricegroup_id, |
|
| 288 |
active_price_source) |
|
| 288 | 289 |
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, |
| 289 |
(SELECT factor FROM price_factors WHERE id = ?), ?, ?)|; |
|
| 290 |
(SELECT factor FROM price_factors WHERE id = ?), ?, ?, ?)|;
|
|
| 290 | 291 |
my $h_item = prepare_query($form, $dbh, $q_item); |
| 291 | 292 |
|
| 292 | 293 |
my $q_item_stock = |
| ... | ... | |
| 341 | 342 |
$form->{"lastcost_$i"},
|
| 342 | 343 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}),
|
| 343 | 344 |
conv_i($form->{"marge_price_factor_$i"}),
|
| 344 |
$pricegroup_id); |
|
| 345 |
$pricegroup_id, |
|
| 346 |
$form->{"active_price_source_$i"});
|
|
| 345 | 347 |
do_statement($form, $h_item, $q_item, @values); |
| 346 | 348 |
|
| 347 | 349 |
my $stock_info = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_$i"});
|
| ... | ... | |
| 688 | 690 |
doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost, |
| 689 | 691 |
doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription, |
| 690 | 692 |
doi.price_factor_id, doi.price_factor, doi.marge_price_factor, doi.pricegroup_id, |
| 693 |
doi.active_price_source, |
|
| 691 | 694 |
pr.projectnumber, dord.transdate AS dord_transdate, dord.donumber, |
| 692 | 695 |
pg.partsgroup |
| 693 | 696 |
FROM delivery_order_items doi |
Auch abrufbar als: Unified diff
PriceSource: Erste Version
- Preisgruppen und Stammdaten sind implementiert
- Persistenz in allen Belegen funktioniert
- Rudimentäre Visualisierung funktioniert
- Klassen sind alle da
- Doku fehlt
- Verkauf/Einkaufweiche fehlt
- best_price ungetestet
- Preisgruppen hängen noch nicht von Verkäufer ab
- dependancy system fehlt
- verhalten bei fehlerhaften sources
- pricegroup -> active_source migration