Revision db3dfa92
Von Sven Schöling vor etwa 7 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 599 | 599 |
push @values, like($form->{parts_description});
|
| 600 | 600 |
} |
| 601 | 601 |
|
| 602 |
if ($form->{show_marked_as_closed}) {
|
|
| 603 |
$query .= ' |
|
| 604 |
LEFT JOIN ( |
|
| 605 |
SELECT SUM(acc_trans.amount) AS amount, trans_id |
|
| 606 |
FROM acc_trans |
|
| 607 |
LEFT JOIN chart ON chart.id = chart_id |
|
| 608 |
WHERE chart.link ILIKE ? |
|
| 609 |
GROUP BY trans_id |
|
| 610 |
) AS paid_difference ON (paid_difference.trans_id = a.id) |
|
| 611 |
'; |
|
| 612 |
unshift @values, '%AR_paid%'; |
|
| 613 |
$where .= ' AND COALESCE(paid_difference.amount, 0) + a.paid != 0'; |
|
| 614 |
} |
|
| 615 |
|
|
| 602 | 616 |
my ($cvar_where, @cvar_values) = CVar->build_filter_query('module' => 'CT',
|
| 603 | 617 |
'trans_id_field' => 'c.id', |
| 604 | 618 |
'filter' => $form, |
| bin/mozilla/ar.pl | ||
|---|---|---|
| 996 | 996 |
|
| 997 | 997 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 998 | 998 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto |
| 999 |
employee_id salesman_id business_id parts_partnumber parts_description department_id); |
|
| 999 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed);
|
|
| 1000 | 1000 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
| 1001 | 1001 |
|
| 1002 | 1002 |
$href = build_std_url('action=ar_transactions', grep { $form->{$_} } @hidden_variables);
|
| locale/de/all | ||
|---|---|---|
| 2710 | 2710 |
'Show items from invoices individually' => 'Artikel aus Rechnungen anzeigen', |
| 2711 | 2711 |
'Show mappings (csv_import)' => 'Spaltenzuordnungen anzeigen', |
| 2712 | 2712 |
'Show old dunnings' => 'Alte Mahnungen anzeigen', |
| 2713 |
'Show only marked as paid invoices' => 'Nur "als geschlossen markiert" zeigen', |
|
| 2713 | 2714 |
'Show overdue sales quotations and requests for quotations...' => 'Überfällige Angebote und Preisanfragen anzeigen...', |
| 2714 | 2715 |
'Show parts' => 'Artikel anzeigen', |
| 2715 | 2716 |
'Show parts longdescription (notes) in select list' => 'Langtext in Auswahlliste bei mehreren Treffern im Stammdaten-Bestand anzeigen', |
| templates/webpages/ar/search.html | ||
|---|---|---|
| 64 | 64 |
<td>[% L.select_tag("business_id", ALL_BUSINESS_TYPES, with_empty=1, title_key="description", style=style) %]</td>
|
| 65 | 65 |
</tr> |
| 66 | 66 |
[% END %] |
| 67 |
<tr> |
|
| 68 |
<th>[% 'Show only marked as paid invoices' | $T8 %]</th> |
|
| 69 |
<td>[% L.checkbox_tag('show_marked_as_closed') %]</td>
|
|
| 70 |
</tr> |
|
| 67 | 71 |
<tr> |
| 68 | 72 |
<th align=right nowrap>[% 'Invoice Date' | $T8 %]</th> |
| 69 | 73 |
<td> |
Auch abrufbar als: Unified diff
Rechnungen: Nach »als geschlossen markiert« suchen