Revision e6af833d
Von Tamino Steinert vor 12 Tagen hinzugefügt
- ID e6af833dc4ff65761a67a176c6ebfc04132bdaa6
- Vorgänger efc07572
| SL/DB/Manager/EmailJournal.pm | ||
|---|---|---|
| 33 | 33 |
) |
| 34 | 34 |
)} => \'TRUE'; |
| 35 | 35 |
}, |
| 36 |
unprocessed_attachment_names => sub {
|
|
| 37 |
my ($key, $value, $prefix) = @_; |
|
| 38 |
return ( |
|
| 39 |
and => [ |
|
| 40 |
'attachments.name' => $value, |
|
| 41 |
'attachments.processed' => 0, |
|
| 42 |
], |
|
| 43 |
'attachments' |
|
| 44 |
) |
|
| 45 |
}, |
|
| 36 | 46 |
has_unprocessed_attachments => sub {
|
| 37 | 47 |
my ($key, $value, $prefix) = @_; |
| 38 | 48 |
|
| ... | ... | |
| 68 | 78 |
AND record_links.to_id = email_journal.id |
| 69 | 79 |
) |
| 70 | 80 |
)}, |
| 71 |
attachment => qq{(
|
|
| 81 |
attachment_names => qq{(
|
|
| 82 |
SELECT STRING_AGG( |
|
| 83 |
email_journal_attachments.name, |
|
| 84 |
', ' |
|
| 85 |
ORDER BY email_journal_attachments.position ASC |
|
| 86 |
) |
|
| 87 |
FROM email_journal_attachments |
|
| 88 |
WHERE |
|
| 89 |
email_journal_attachments.email_journal_id = email_journal.id |
|
| 90 |
)}, |
|
| 91 |
unprocessed_attachment_names => qq{(
|
|
| 72 | 92 |
SELECT STRING_AGG( |
| 73 | 93 |
email_journal_attachments.name, |
| 74 | 94 |
', ' |
| ... | ... | |
| 77 | 97 |
FROM email_journal_attachments |
| 78 | 98 |
WHERE |
| 79 | 99 |
email_journal_attachments.email_journal_id = email_journal.id |
| 100 |
AND email_journal_attachments.processed = FALSE |
|
| 80 | 101 |
)}, |
| 81 | 102 |
has_unprocessed_attachments => qq{(
|
| 82 | 103 |
SELECT count(*) |
Auch abrufbar als: Unified diff
EmailJournal: Komplexer Bericht mit komplexen Filter