Revision 028a4707
Von Sven Schöling vor fast 19 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
| 561 | 561 |
# save detail record in invoice table |
| 562 | 562 |
$query = qq|INSERT INTO invoice (trans_id, parts_id, description, qty, |
| 563 | 563 |
sellprice, fxsellprice, discount, allocated, assemblyitem, |
| 564 |
unit, deliverydate, project_id, serialnumber, pricegroup_id) |
|
| 564 |
unit, deliverydate, project_id, serialnumber, pricegroup_id, |
|
| 565 |
ordnumber, transdate, cusordnumber) |
|
| 565 | 566 |
VALUES ($form->{id}, $form->{"id_$i"},
|
| 566 | 567 |
'$form->{"description_$i"}', $form->{"qty_$i"},
|
| 567 | 568 |
$form->{"sellprice_$i"}, $fxsellprice,
|
| 568 | 569 |
$form->{"discount_$i"}, $allocated, 'f',
|
| 569 | 570 |
'$form->{"unit_$i"}', $deliverydate, (SELECT id from project where projectnumber = '$project_id'),
|
| 570 |
'$form->{"serialnumber_$i"}',
|
|
| 571 |
'$pricegroup_id')|;
|
|
| 571 |
'$form->{"serialnumber_$i"}', '$pricegroup_id',
|
|
| 572 |
'$form->{"ordnumber_$i"}', '$form->{"transdate_$i"}', '$form->{"cusordnumber_$i"}')|;
|
|
| 572 | 573 |
$dbh->do($query) || $form->dberror($query); |
| 573 | 574 |
|
| 574 | 575 |
if ($form->{lizenzen}) {
|
| ... | ... | |
| 1221 | 1222 |
i.discount, i.parts_id AS id, i.unit, i.deliverydate, |
| 1222 | 1223 |
i.project_id, pr.projectnumber, i.serialnumber, |
| 1223 | 1224 |
p.partnumber, p.assembly, p.bin, p.notes AS partnotes, i.id AS invoice_pos, |
| 1224 |
pg.partsgroup, i.pricegroup_id, (SELECT pricegroup FROM pricegroup WHERE id=i.pricegroup_id) as pricegroup |
|
| 1225 |
pg.partsgroup, i.pricegroup_id, (SELECT pricegroup FROM pricegroup WHERE id=i.pricegroup_id) as pricegroup, |
|
| 1226 |
i.ordnumber, i.transdate, i.cusordnumber |
|
| 1225 | 1227 |
FROM invoice i |
| 1226 | 1228 |
JOIN parts p ON (i.parts_id = p.id) |
| 1227 | 1229 |
LEFT JOIN project pr ON (i.project_id = pr.id) |
Auch abrufbar als: Unified diff
DB-Schema geaendert um in invoice und orderitems die Variablen ordnumber_$i, transdate_$i, cusordnumber_$i zu speichern.
Speichern/Laden von Auftraegen und Buchen/Laden von Rechnungen modifiziert um diese Variablen zu halten.