Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision a5dff514

Von Tamino Steinert vor 30 Tagen hinzugefügt

EmailJournal: Anhänge in Bericht anzeigen und sortieren

Unterschiede anzeigen:

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