Revision 9263b0fa
Von Jan Büren vor mehr als 14 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
|
qq| a.marge_total, a.marge_percent, | .
|
||
|
qq| a.transaction_description, | .
|
||
|
qq| pr.projectnumber AS globalprojectnumber, | .
|
||
|
qq| c.name, c.customernumber, c.country, c.ustid, | .
|
||
|
qq| c.name, c.customernumber, c.country, c.ustid, b.description as customertype, | .
|
||
|
qq| e.name AS employee, | .
|
||
|
qq| e2.name AS salesman, | .
|
||
|
qq| tz.description AS taxzone, | .
|
||
| ... | ... | |
|
qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id)| .
|
||
|
qq|LEFT JOIN tax_zones tz ON (tz.id = c.taxzone_id)| .
|
||
|
qq|LEFT JOIN payment_terms pt ON (pt.id = c.payment_id)| .
|
||
|
qq|LEFT JOIN business b ON (b.id = c.business_id)| .
|
||
|
qq|LEFT JOIN department d ON (d.id = a.department_id)|;
|
||
|
|
||
|
my $where = "1 = 1";
|
||
| bin/mozilla/ar.pl | ||
|---|---|---|
|
@columns =
|
||
|
qw(transdate id type invnumber ordnumber name netamount tax amount paid
|
||
|
datepaid due duedate transaction_description notes salesman employee shippingpoint shipvia
|
||
|
marge_total marge_percent globalprojectnumber customernumber country ustid taxzone payment_terms charts);
|
||
|
marge_total marge_percent globalprojectnumber customernumber country ustid taxzone payment_terms charts customertype);
|
||
|
|
||
|
my @hidden_variables = map { "l_${_}" } @columns;
|
||
|
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber transaction_description notes project_id transdatefrom transdateto);
|
||
| ... | ... | |
|
'taxzone' => { 'text' => $locale->text('Steuersatz'), },
|
||
|
'payment_terms' => { 'text' => $locale->text('Payment Terms'), },
|
||
|
'charts' => { 'text' => $locale->text('Buchungskonto'), },
|
||
|
'customertype' => { 'text' => $locale->text('Customer type'), },
|
||
|
);
|
||
|
|
||
|
foreach my $name (qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia transaction_description)) {
|
||
Auch abrufbar als: Unified diff
Kundentyp in Rechnungssuche auch als Wert in Rechnungsübersicht anzeigen und exportieren