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)
|
InvoiceItem: um Datenbankfeld für Warenbuchungsmethode erweitert