18 package org.turro.dossier.issue;
20 import java.util.Date;
21 import java.util.List;
22 import org.turro.dossier.db.DossierPU;
23 import org.turro.dossier.entity.Issue;
24 import org.turro.dossier.entity.IssueStatus;
25 import org.turro.elephant.context.ElephantContext;
26 import org.turro.elephant.db.WhereClause;
27 import org.turro.i18n.I_;
28 import org.turro.mail.impl.MessagePool;
29 import org.turro.scheduler.motor.DefaultTask;
39 return I_.
get(
"Issue notifier");
44 Date now =
new Date();
46 for(
Issue issue : getIssues(now)) {
47 if((issue.getControlDate() !=
null && now.after(issue.getControlDate())) ||
48 (issue.getDelivery() !=
null && now.after(issue.getDelivery()))) {
54 ,
"IMailPool_Dossier");
57 private List<Issue> getIssues(Date now) {
59 wc.
addClause(
"select distinct issue from Issue as issue");
60 wc.
addClause(
"where issue.status <> :status");
62 wc.
addClause(
"and (issue.startDate is null or issue.startDate <= :date)");
void poolMail(IConstructor constructor, MessagePool pool)
static String getSiteName()
void addClause(String clause)
void addNamedValue(String name, Object value)
static String get(String msg)
void sendIt(String subject, String implementation)