Revision a5dff514
Von Tamino Steinert vor 30 Tagen hinzugefügt
SL/Controller/EmailJournal.pm | ||
---|---|---|
801 | 801 |
from => t8('From'), |
802 | 802 |
recipients => t8('Recipients'), |
803 | 803 |
subject => t8('Subject'), |
804 |
attachments => t8('Attachments'), |
|
804 | 805 |
sent_on => t8('Sent on'), |
805 | 806 |
status => t8('Status'), |
806 | 807 |
extended_status => t8('Extended status'), |
SL/DB/Manager/EmailJournal.pm | ||
---|---|---|
68 | 68 |
AND record_links.to_id = email_journal.id |
69 | 69 |
) |
70 | 70 |
)}, |
71 |
attachment => qq{( |
|
72 |
SELECT STRING_AGG( |
|
73 |
email_journal_attachments.name, |
|
74 |
', ' |
|
75 |
ORDER BY email_journal_attachments.position ASC |
|
76 |
) |
|
77 |
FROM email_journal_attachments |
|
78 |
WHERE |
|
79 |
email_journal_attachments.email_journal_id = email_journal.id |
|
80 |
)}, |
|
71 | 81 |
has_unprocessed_attachments => qq{( |
72 | 82 |
SELECT count(*) |
73 | 83 |
FROM email_journal_attachments |
templates/design40_webpages/email_journal/list.html | ||
---|---|---|
23 | 23 |
<th>[% L.sortable_table_header("recipients") %]</th> |
24 | 24 |
<th>[% L.sortable_table_header("subject") %]</th> |
25 | 25 |
<th>[% L.sortable_table_header("sent_on") %]</th> |
26 |
<th>[% L.sortable_table_header("attachments") %]</th> |
|
26 | 27 |
<th>[% L.sortable_table_header("status") %]</th> |
27 | 28 |
<th>[% L.sortable_table_header("extended_status") %]</th> |
28 | 29 |
<th>[% L.sortable_table_header("record_type") %]</th> |
... | ... | |
45 | 46 |
<td>[% HTML.escape(entry.recipients) %]</td> |
46 | 47 |
<td><a href="[% action_show_link %]"> [% HTML.escape(entry.subject) %] </a></td> |
47 | 48 |
<td>[% HTML.escape(entry.sent_on.to_lxoffice('precision' => 'second')) %]</td> |
49 |
<td> |
|
50 |
[% FOREACH attachment = entry.attachments %] |
|
51 |
<span>[% HTML.escape(attachment.name) %]</span> |
|
52 |
[% END %] |
|
53 |
</td> |
|
48 | 54 |
<td> [% P.email_journal.entry_status(entry) %] </td> |
49 | 55 |
<td>[% HTML.escape(entry.extended_status) %]</td> |
50 | 56 |
<td>[% HTML.escape(RECORD_TYPES_TO_TEXT.${entry.record_type}) %]</td> |
templates/webpages/email_journal/list.html | ||
---|---|---|
22 | 22 |
<th>[% L.sortable_table_header("recipients") %]</th> |
23 | 23 |
<th>[% L.sortable_table_header("subject") %]</th> |
24 | 24 |
<th>[% L.sortable_table_header("sent_on") %]</th> |
25 |
<th>[% L.sortable_table_header("attachments") %]</th> |
|
25 | 26 |
<th>[% L.sortable_table_header("status") %]</th> |
26 | 27 |
<th>[% L.sortable_table_header("extended_status") %]</th> |
27 | 28 |
<th>[% L.sortable_table_header("record_type") %]</th> |
... | ... | |
51 | 52 |
<td>[%- HTML.escape(entry.recipients) %]</td> |
52 | 53 |
<td><a href="[% action_show_link %]">[%- HTML.escape(entry.subject) %]</a></td> |
53 | 54 |
<td>[%- HTML.escape(entry.sent_on.to_lxoffice('precision' => 'second')) %]</td> |
55 |
<td> |
|
56 |
[% FOREACH attachment = entry.attachments %] |
|
57 |
<span>[% HTML.escape(attachment.name) %]</span> |
|
58 |
[% END %] |
|
59 |
</td> |
|
54 | 60 |
<td> [% P.email_journal.entry_status(entry) %] </td> |
55 | 61 |
<td>[%- HTML.escape(entry.extended_status) %]</td> |
56 | 62 |
<td>[% HTML.escape(RECORD_TYPES_TO_TEXT.${entry.record_type}) %]</td> |
Auch abrufbar als: Unified diff
EmailJournal: Anhänge in Bericht anzeigen und sortieren