Revision b0d92ef6
Von Tamino Steinert vor fast 2 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
| 449 | 449 |
project_id = ?, serialnumber = ?, price_factor_id = ?, |
| 450 | 450 |
price_factor = (SELECT factor FROM price_factors WHERE id = ?), marge_price_factor = ?, |
| 451 | 451 |
active_price_source = ?, active_discount_source = ? |
| 452 |
,expense_chart_id = ?, tax_id = ?, inventory_chart_id = ?
|
|
| 452 |
,expense_chart_id = ?, inventory_chart_id = ?, tax_id = ?, tax_chart_type = ?
|
|
| 453 | 453 |
WHERE id = ? |
| 454 | 454 |
SQL |
| 455 | 455 |
|
| ... | ... | |
| 460 | 460 |
conv_i($form->{"project_id_$i"}), $form->{"serialnumber_$i"},
|
| 461 | 461 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"marge_price_factor_$i"}),
|
| 462 | 462 |
$form->{"active_price_source_$i"}, $form->{"active_discount_source_$i"},
|
| 463 |
$form->{"expense_chart_id_$i"}, $form->{"tax_id_$i"}, $form->{"inventory_chart_id_$i"},
|
|
| 463 |
$form->{"expense_chart_id_$i"}, $form->{"inventory_chart_id_$i"}, $form->{"tax_id_$i"}, $form->{"tax_chart_type_$i"},
|
|
| 464 | 464 |
conv_i($form->{"invoice_id_$i"}));
|
| 465 | 465 |
do_query($form, $dbh, $query, @values); |
| 466 | 466 |
push @processed_invoice_ids, $form->{"invoice_id_$i"};
|
| ... | ... | |
| 1088 | 1088 |
i.price_factor_id, i.price_factor, i.marge_price_factor, i.discount, i.active_price_source, i.active_discount_source, |
| 1089 | 1089 |
p.partnumber, p.part_type, pr.projectnumber, pg.partsgroup |
| 1090 | 1090 |
,p.classification_id |
| 1091 |
,i.expense_chart_id, i.tax_id, i.inventory_chart_id
|
|
| 1091 |
,i.expense_chart_id, i.inventory_chart_id, i.tax_id, i.tax_chart_type
|
|
| 1092 | 1092 |
|
| 1093 | 1093 |
FROM invoice i |
| 1094 | 1094 |
JOIN parts p ON (i.parts_id = p.id) |
Auch abrufbar als: Unified diff
InvoiceItem: um Datenbankfeld für Warenbuchungsmethode erweitert