Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 1 | package eu.mulk.mulkcms2.benki.newsletter; |
| 2 | |
| 3 | import static java.util.stream.Collectors.partitioningBy; |
| 4 | import static java.util.stream.Collectors.toList; |
| 5 | |
| 6 | import eu.mulk.mulkcms2.benki.bookmarks.Bookmark; |
| 7 | import eu.mulk.mulkcms2.benki.lazychat.LazychatMessage; |
| 8 | import eu.mulk.mulkcms2.benki.posts.Post; |
| 9 | import io.quarkus.mailer.MailTemplate.MailTemplateInstance; |
| 10 | import io.quarkus.panache.common.Sort; |
Matthias Andreas Benkard | 49b0151 | 2021-07-05 06:45:54 +0200 | [diff] [blame] | 11 | import io.quarkus.qute.CheckedTemplate; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 12 | import io.quarkus.qute.TemplateExtension; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 13 | import io.quarkus.scheduler.Scheduled; |
Matthias Andreas Benkard | e3bc3ee | 2023-08-06 16:21:11 +0200 | [diff] [blame] | 14 | import jakarta.enterprise.context.Dependent; |
| 15 | import jakarta.persistence.EntityManager; |
| 16 | import jakarta.persistence.PersistenceContext; |
| 17 | import jakarta.transaction.Transactional; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 18 | import java.time.LocalDate; |
| 19 | import java.time.OffsetDateTime; |
| 20 | import java.time.ZoneId; |
| 21 | import java.time.format.DateTimeFormatter; |
| 22 | import java.time.format.FormatStyle; |
| 23 | import java.util.List; |
| 24 | import java.util.concurrent.ExecutionException; |
| 25 | import java.util.concurrent.TimeUnit; |
| 26 | import java.util.concurrent.TimeoutException; |
| 27 | import javax.annotation.CheckForNull; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 28 | import org.eclipse.microprofile.config.inject.ConfigProperty; |
| 29 | import org.hibernate.Session; |
| 30 | |
| 31 | @Dependent |
| 32 | public class NewsletterSender { |
| 33 | |
| 34 | private static final DateTimeFormatter humanDateFormatter = |
| 35 | DateTimeFormatter.ofLocalizedDate(FormatStyle.LONG); |
| 36 | |
| 37 | @ConfigProperty(name = "mulkcms.newsletter.time-zone") |
| 38 | ZoneId newsletterTimeZone; |
| 39 | |
Matthias Andreas Benkard | d4df22d | 2021-02-06 11:31:27 +0100 | [diff] [blame] | 40 | @ConfigProperty(name = "quarkus.mailer.from") |
| 41 | String senderAddress; |
| 42 | |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 43 | @PersistenceContext EntityManager em; |
| 44 | |
| 45 | @CheckedTemplate |
| 46 | static class Templates { |
| 47 | public static native MailTemplateInstance newsletter( |
| 48 | Newsletter newsletter, List<Bookmark> bookmarks, List<LazychatMessage> lazychatMessages); |
| 49 | } |
| 50 | |
| 51 | @Scheduled(cron = "0 0 0 ? * Mon") |
| 52 | @Transactional |
| 53 | void run() throws InterruptedException, TimeoutException, ExecutionException { |
| 54 | var session = em.unwrap(Session.class); |
| 55 | |
Matthias Andreas Benkard | 475bf00 | 2023-08-06 20:56:30 +0200 | [diff] [blame] | 56 | List<Post> posts = |
Matthias Andreas Benkard | 601508f | 2022-11-08 21:42:59 +0100 | [diff] [blame] | 57 | Post.find( |
| 58 | """ |
| 59 | SELECT DISTINCT p FROM Post p |
| 60 | JOIN p.targets r |
| 61 | JOIN r.tags tag |
| 62 | WHERE p.newsletter IS NULL |
| 63 | AND p.scope = 'top_level' |
| 64 | AND tag = 'world' |
| 65 | """, |
| 66 | Sort.ascending("date")) |
Matthias Andreas Benkard | 601508f | 2022-11-08 21:42:59 +0100 | [diff] [blame] | 67 | .list(); |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 68 | Post.fetchTexts(posts); |
| 69 | |
| 70 | if (posts.isEmpty()) { |
| 71 | return; |
| 72 | } |
| 73 | |
| 74 | var postsByClass = posts.stream().collect(partitioningBy(Post::isBookmark)); |
| 75 | var bookmarks = |
| 76 | postsByClass.getOrDefault(Boolean.TRUE, List.of()).stream() |
| 77 | .map(x -> (Bookmark) x) |
| 78 | .collect(toList()); |
| 79 | var lazychatMessages = |
| 80 | postsByClass.getOrDefault(Boolean.FALSE, List.of()).stream() |
| 81 | .map(x -> (LazychatMessage) x) |
| 82 | .collect(toList()); |
| 83 | |
| 84 | var date = OffsetDateTime.now(newsletterTimeZone); |
| 85 | var newsletterNumber = |
| 86 | (int) |
| 87 | session |
| 88 | .createQuery("SELECT max(id) FROM Newsletter", Integer.class) |
| 89 | .uniqueResultOptional() |
| 90 | .map(x -> x + 1) |
| 91 | .orElse(1); |
| 92 | |
| 93 | var newsletter = new Newsletter(); |
| 94 | newsletter.id = newsletterNumber; |
| 95 | newsletter.date = date; |
| 96 | newsletter.persist(); |
| 97 | |
| 98 | posts.forEach(post -> post.newsletter = newsletter); |
| 99 | |
| 100 | var subscriberEmails = |
Matthias Andreas Benkard | ff35894 | 2020-11-03 06:16:17 +0100 | [diff] [blame] | 101 | NewsletterSubscription.<NewsletterSubscription>stream("registrationKey IS NULL") |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 102 | .map(x -> x.email) |
| 103 | .toArray(String[]::new); |
| 104 | |
| 105 | var mailText = Templates.newsletter(newsletter, bookmarks, lazychatMessages); |
| 106 | var sendJob = |
| 107 | mailText |
| 108 | .subject(String.format("MulkCMS newsletter #%d", newsletterNumber)) |
Matthias Andreas Benkard | d4df22d | 2021-02-06 11:31:27 +0100 | [diff] [blame] | 109 | .to(senderAddress) |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 110 | .bcc(subscriberEmails) |
| 111 | .send(); |
Matthias Andreas Benkard | a50ac8d | 2021-06-28 19:58:36 +0200 | [diff] [blame] | 112 | sendJob.subscribe().asCompletionStage().get(10000, TimeUnit.SECONDS); |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame] | 113 | } |
| 114 | |
| 115 | @TemplateExtension |
| 116 | @CheckForNull |
| 117 | static String humanDate(@CheckForNull LocalDate x) { |
| 118 | if (x == null) { |
| 119 | return null; |
| 120 | } |
| 121 | return humanDateFormatter.format(x); |
| 122 | } |
| 123 | |
| 124 | @TemplateExtension |
| 125 | @CheckForNull |
| 126 | static String humanDate(@CheckForNull OffsetDateTime x) { |
| 127 | if (x == null) { |
| 128 | return null; |
| 129 | } |
| 130 | return humanDateFormatter.format(x); |
| 131 | } |
| 132 | } |