Revision 64089bbe
Von Jan Büren vor etwa 6 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 620 | 620 |
push @values, like($form->{parts_description});
|
| 621 | 621 |
} |
| 622 | 622 |
|
| 623 |
if ($form->{show_not_mailed}) {
|
|
| 624 |
$where .= <<SQL; |
|
| 625 |
AND NOT EXISTS ( |
|
| 626 |
SELECT rl.to_id |
|
| 627 |
FROM record_links rl |
|
| 628 |
WHERE (rl.from_id = a.id) |
|
| 629 |
AND (rl.to_table = 'email_journal') |
|
| 630 |
LIMIT 1 |
|
| 631 |
) |
|
| 632 |
SQL |
|
| 633 |
} |
|
| 634 |
|
|
| 623 | 635 |
if ($form->{show_marked_as_closed}) {
|
| 624 | 636 |
$query .= ' |
| 625 | 637 |
LEFT JOIN ( |
| bin/mozilla/ar.pl | ||
|---|---|---|
| 1000 | 1000 |
|
| 1001 | 1001 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 1002 | 1002 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto |
| 1003 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed); |
|
| 1003 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed show_not_mailed);
|
|
| 1004 | 1004 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
| 1005 | 1005 |
|
| 1006 | 1006 |
$href = build_std_url('action=ar_transactions', grep { $form->{$_} } @hidden_variables);
|
| locale/de/all | ||
|---|---|---|
| 2911 | 2911 |
'Show mappings (csv_import)' => 'Spaltenzuordnungen anzeigen', |
| 2912 | 2912 |
'Show old dunnings' => 'Alte Mahnungen anzeigen', |
| 2913 | 2913 |
'Show only marked as paid invoices' => 'Nur "als geschlossen markiert" zeigen', |
| 2914 |
'Show only not mailed invoices' => 'Nur "nicht per E-Mail versendete" anzeigen', |
|
| 2914 | 2915 |
'Show order' => 'Bestellung anzeigen', |
| 2915 | 2916 |
'Show overdue sales quotations and requests for quotations...' => 'Überfällige Angebote und Preisanfragen anzeigen...', |
| 2916 | 2917 |
'Show parts' => 'Artikel anzeigen', |
| templates/webpages/ar/search.html | ||
|---|---|---|
| 68 | 68 |
<th>[% 'Show only marked as paid invoices' | $T8 %]</th> |
| 69 | 69 |
<td>[% L.checkbox_tag('show_marked_as_closed') %]</td>
|
| 70 | 70 |
</tr> |
| 71 |
[% IF INSTANCE_CONF.get_email_journal %] |
|
| 72 |
<tr> |
|
| 73 |
<th>[% 'Show only not mailed invoices' | $T8 %]</th> |
|
| 74 |
<td>[% L.checkbox_tag('show_not_mailed') %]</td>
|
|
| 75 |
</tr> |
|
| 76 |
[% END %] |
|
| 71 | 77 |
<tr> |
| 72 | 78 |
<th align=right nowrap>[% 'Invoice Date' | $T8 %]</th> |
| 73 | 79 |
<td> |
Auch abrufbar als: Unified diff
Verkauf->Rechnungsbericht Filter nach nicht per E-Mail verschickten Belegen