Revision 25517b3d
Von Bernd Bleßmann vor mehr als 5 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
|
qq| v.vendornumber, v.country, v.ustid, | .
|
||
|
qq| tz.description AS taxzone, | .
|
||
|
qq| pt.description AS payment_terms, | .
|
||
|
qq| department.description AS department, | .
|
||
|
qq{ ( SELECT ch.accno || ' -- ' || ch.description
|
||
|
FROM acc_trans at
|
||
|
LEFT JOIN chart ch ON ch.id = at.chart_id
|
||
| ... | ... | |
|
qq|LEFT JOIN employee e ON (a.employee_id = e.id) | .
|
||
|
qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id) | .
|
||
|
qq|LEFT JOIN tax_zones tz ON (tz.id = a.taxzone_id)| .
|
||
|
qq|LEFT JOIN payment_terms pt ON (pt.id = a.payment_id)|;
|
||
|
qq|LEFT JOIN payment_terms pt ON (pt.id = a.payment_id)| .
|
||
|
qq|LEFT JOIN department ON (department.id = a.department_id)|;
|
||
|
|
||
|
my $where = '';
|
||
|
|
||
| ... | ... | |
|
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
||
|
my $sortorder = join(', ', map { "$_ $sortdir" } @a);
|
||
|
|
||
|
if (grep({ $_ eq $form->{sort} } qw(transdate id invnumber ordnumber name netamount tax amount paid datepaid due duedate notes employee transaction_description direct_debit))) {
|
||
|
if (grep({ $_ eq $form->{sort} } qw(transdate id invnumber ordnumber name netamount tax amount paid datepaid due duedate notes employee transaction_description direct_debit department))) {
|
||
|
$sortorder = $form->{sort} . " $sortdir";
|
||
|
}
|
||
|
|
||
| bin/mozilla/ap.pl | ||
|---|---|---|
|
|
||
|
my @columns =
|
||
|
qw(transdate id type invnumber ordnumber name netamount tax amount paid datepaid
|
||
|
due duedate transaction_description notes employee globalprojectnumber
|
||
|
due duedate transaction_description notes employee globalprojectnumber department
|
||
|
vendornumber country ustid taxzone payment_terms charts direct_debit);
|
||
|
|
||
|
my @hidden_variables = map { "l_${_}" } @columns;
|
||
| ... | ... | |
|
'notes' => { 'text' => $locale->text('Notes'), },
|
||
|
'employee' => { 'text' => $locale->text('Employee'), },
|
||
|
'globalprojectnumber' => { 'text' => $locale->text('Document Project Number'), },
|
||
|
'department' => { 'text' => $locale->text('Department'), },
|
||
|
'vendornumber' => { 'text' => $locale->text('Vendor Number'), },
|
||
|
'country' => { 'text' => $locale->text('Country'), },
|
||
|
'ustid' => { 'text' => $locale->text('USt-IdNr.'), },
|
||
| ... | ... | |
|
'direct_debit' => { 'text' => $locale->text('direct debit'), },
|
||
|
);
|
||
|
|
||
|
foreach my $name (qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia transaction_description direct_debit)) {
|
||
|
foreach my $name (qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia transaction_description direct_debit department)) {
|
||
|
my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
|
||
|
$column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
|
||
|
}
|
||
| templates/webpages/ap/search.html | ||
|---|---|---|
|
<td nowrap>[% 'Notes' | $T8 %]</td>
|
||
|
<td align=right><input name="l_employee" class=checkbox type=checkbox value=Y></td>
|
||
|
<td nowrap>[% 'Employee' | $T8 %]</td>
|
||
|
<td align=right><input name="l_department" class=checkbox type=checkbox value=Y></td>
|
||
|
<td nowrap>[% 'Department' | $T8 %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<td align=right><input name="l_subtotal" class=checkbox type=checkbox value=Y></td>
|
||
Auch abrufbar als: Unified diff
Bericht EK-Rg/Kreditorenbuchungen: Abteilungen anzeigen können