Revision bb7e2e85
Von Moritz Bunkus vor etwa 11 Jahren hinzugefügt
| SL/DB/MetaSetup/InvoiceItem.pm | ||
|---|---|---|
|
description => { type => 'text' },
|
||
|
discount => { type => 'float', precision => 4 },
|
||
|
fxsellprice => { type => 'numeric', precision => 5, scale => 15 },
|
||
|
donumber => { type => 'text' },
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'invoiceid' },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
lastcost => { type => 'numeric', precision => 5, scale => 15 },
|
||
| SL/DO.pm | ||
|---|---|---|
|
doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost,
|
||
|
doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription,
|
||
|
doi.price_factor_id, doi.price_factor, doi.marge_price_factor, doi.pricegroup_id,
|
||
|
pr.projectnumber, dord.transdate AS dord_transdate,
|
||
|
pr.projectnumber, dord.transdate AS dord_transdate, dord.donumber,
|
||
|
pg.partsgroup
|
||
|
FROM delivery_order_items doi
|
||
|
JOIN parts p ON (doi.parts_id = p.id)
|
||
| SL/IS.pm | ||
|---|---|---|
|
|
||
|
my @arrays =
|
||
|
qw(runningnumber number description longdescription qty ship unit bin
|
||
|
deliverydate_oe ordnumber_oe transdate_oe validuntil
|
||
|
deliverydate_oe ordnumber_oe donumber_do transdate_oe validuntil
|
||
|
partnotes serialnumber reqdate sellprice listprice netprice
|
||
|
discount p_discount discount_sub nodiscount_sub
|
||
|
linetotal nodiscount_linetotal tax_rate projectnumber projectdescription
|
||
| ... | ... | |
|
push @{ $form->{TEMPLATE_ARRAYS}->{sellprice} }, $form->{"sellprice_$i"};
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{sellprice_nofmt} }, $form->parse_amount($myconfig, $form->{"sellprice_$i"});
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{ordnumber_oe} }, $form->{"ordnumber_$i"};
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{donumber_do} }, $form->{"donumber_$i"};
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{transdate_oe} }, $form->{"transdate_$i"};
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{invnumber} }, $form->{"invnumber"};
|
||
|
push @{ $form->{TEMPLATE_ARRAYS}->{invdate} }, $form->{"invdate"};
|
||
| ... | ... | |
|
qq|INSERT INTO invoice (id, trans_id, parts_id, description, longdescription, qty,
|
||
|
sellprice, fxsellprice, discount, allocated, assemblyitem,
|
||
|
unit, deliverydate, project_id, serialnumber, pricegroup_id,
|
||
|
ordnumber, transdate, cusordnumber, base_qty, subtotal,
|
||
|
ordnumber, donumber, transdate, cusordnumber, base_qty, subtotal,
|
||
|
marge_percent, marge_total, lastcost,
|
||
|
price_factor_id, price_factor, marge_price_factor)
|
||
|
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
|
||
|
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
|
||
|
(SELECT factor FROM price_factors WHERE id = ?), ?)|;
|
||
|
|
||
|
@values = ($invoice_id, conv_i($form->{id}), conv_i($form->{"id_$i"}),
|
||
| ... | ... | |
|
$form->{"discount_$i"}, $allocated, 'f',
|
||
|
$form->{"unit_$i"}, conv_date($form->{"reqdate_$i"}), conv_i($form->{"project_id_$i"}),
|
||
|
$form->{"serialnumber_$i"}, $pricegroup_id,
|
||
|
$form->{"ordnumber_$i"}, conv_date($form->{"transdate_$i"}),
|
||
|
$form->{"ordnumber_$i"}, $form->{"donumber_$i"}, conv_date($form->{"transdate_$i"}),
|
||
|
$form->{"cusordnumber_$i"}, $baseqty, $form->{"subtotal_$i"} ? 't' : 'f',
|
||
|
$form->{"marge_percent_$i"}, $form->{"marge_absolut_$i"},
|
||
|
$form->{"lastcost_$i"},
|
||
| ... | ... | |
|
|
||
|
i.id AS invoice_id,
|
||
|
i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.discount, i.parts_id AS id, i.unit, i.deliverydate AS reqdate,
|
||
|
i.project_id, i.serialnumber, i.id AS invoice_pos, i.pricegroup_id, i.ordnumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost,
|
||
|
i.project_id, i.serialnumber, i.id AS invoice_pos, i.pricegroup_id, i.ordnumber, i.donumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost,
|
||
|
i.price_factor_id, i.price_factor, i.marge_price_factor,
|
||
|
p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,
|
||
|
pr.projectnumber, pg.partsgroup, prg.pricegroup
|
||
| bin/mozilla/do.pl | ||
|---|---|---|
|
}
|
||
|
}
|
||
|
map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"} } qw(ship qty sellprice listprice lastcost basefactor);
|
||
|
$form->{"donumber_$i"} = $form->{donumber};
|
||
|
}
|
||
|
|
||
|
$form->{type} = "invoice";
|
||
| bin/mozilla/io.pl | ||
|---|---|---|
|
$cgi->hidden("-name" => "price_new_$i", "-value" => $form->format_amount(\%myconfig, $form->{"price_new_$i"})),
|
||
|
map { ($cgi->hidden("-name" => $_, "-id" => $_, "-value" => $form->{$_})); } map { $_."_$i" }
|
||
|
(qw(orderitems_id bo pricegroup_old price_old id inventory_accno bin partsgroup partnotes
|
||
|
income_accno expense_accno listprice assembly taxaccounts ordnumber transdate cusordnumber
|
||
|
income_accno expense_accno listprice assembly taxaccounts ordnumber donumber transdate cusordnumber
|
||
|
longdescription basefactor marge_absolut marge_percent marge_price_factor weight), @hidden_vars)
|
||
|
);
|
||
|
|
||
| ... | ... | |
|
taxaccounts bin assembly weight projectnumber project_id
|
||
|
oldprojectnumber runningnumber serialnumber partsgroup payment_id
|
||
|
not_discountable shop ve gv buchungsgruppen_id language_values
|
||
|
sellprice_pg pricegroup_old price_old price_new unit_old ordnumber
|
||
|
sellprice_pg pricegroup_old price_old price_new unit_old ordnumber donumber
|
||
|
transdate longdescription basefactor marge_total marge_percent
|
||
|
marge_price_factor lastcost price_factor_id partnotes
|
||
|
stock_out stock_in has_sernumber reqdate);
|
||
| doc/dokumentation.xml | ||
|---|---|---|
|
</listitem>
|
||
|
</varlistentry>
|
||
|
|
||
|
<varlistentry>
|
||
|
<term><varname>donumber_do</varname></term>
|
||
|
|
||
|
<listitem>
|
||
|
<para>Lieferscheinnummer desjenigen Lieferscheins, aus dem die Position stammt, sofern die Rechnung aus einem oder
|
||
|
mehreren Lieferscheinen erstellt wurde</para>
|
||
|
</listitem>
|
||
|
</varlistentry>
|
||
|
|
||
|
<varlistentry>
|
||
|
<term><varname>p_discount</varname></term>
|
||
|
|
||
| sql/Pg-upgrade2/invoice_add_donumber.sql | ||
|---|---|---|
|
-- @tag: invoice_add_donumber
|
||
|
-- @description: invoice_add_donumber
|
||
|
-- @depends: release_3_0_0
|
||
|
ALTER TABLE invoice ADD COLUMN donumber TEXT;
|
||
Auch abrufbar als: Unified diff
Lieferscheine -> Rechnungen wandeln: Lieferscheinnummer in jeder Rechnungsposition speichern
Dies geschieht analog zu invoice.ordnumber als invoice.donumber. In
Druckvorlagen steht sie als Variable donumber_do zur Verfügung (auch
dies angelehnt an invoice.ordnumber, die als ordnumber_oe zur
Verfügung steht).