@RequestMapping("/cancelScheduledJob")
public String cancelScheduledJob(
HttpServletRequest request,
HttpServletResponse response,
@RequestParam("theJobName") String theJobName,
@RequestParam("theJobGroupName") String theJobGroupName,
@RequestParam("theTriggerName") String triggerName,
@RequestParam("theTriggerGroupName") String triggerGroupName,
@RequestParam("redirection") String redirection,
ModelMap model)
throws SchedulerException {
scheduler.getJobDetail(theJobName, theJobGroupName);
logger.debug("About to pause the job-->" + theJobName + "Job Group Name -->" + theJobGroupName);
SimpleTrigger oldTrigger = (SimpleTrigger) scheduler.getTrigger(triggerName, triggerGroupName);
if (oldTrigger != null) {
Date startTime =
new Date(oldTrigger.getStartTime().getTime() + oldTrigger.getRepeatInterval());
if (triggerGroupName.equals(ExtractController.TRIGGER_GROUP_NAME)) {
interruptQuartzJob(scheduler, theJobName, theJobGroupName);
}
scheduler.pauseJob(theJobName, theJobGroupName);
SimpleTrigger newTrigger = new SimpleTrigger(triggerName, triggerGroupName);
newTrigger.setJobName(theJobName);
newTrigger.setJobGroup(theJobGroupName);
newTrigger.setJobDataMap(oldTrigger.getJobDataMap());
newTrigger.setVolatility(false);
newTrigger.setRepeatCount(oldTrigger.getRepeatCount());
newTrigger.setRepeatInterval(oldTrigger.getRepeatInterval());
newTrigger.setMisfireInstruction(
SimpleTrigger.MISFIRE_INSTRUCTION_RESCHEDULE_NEXT_WITH_REMAINING_COUNT);
newTrigger.setStartTime(startTime);
newTrigger.setRepeatInterval(oldTrigger.getRepeatInterval());
scheduler.unscheduleJob(
triggerName,
triggerGroupName); // these are the jobs which are from extract data and are not not
// required to be rescheduled.
ArrayList<String> pageMessages = new ArrayList<String>();
if (triggerGroupName.equals(ExtractController.TRIGGER_GROUP_NAME)) {
scheduler.rescheduleJob(triggerName, triggerGroupName, newTrigger);
pageMessages.add("The Job " + theJobName + " has been cancelled");
} else if (triggerGroupName.equals(XsltTriggerService.TRIGGER_GROUP_NAME)) {
JobDetailBean jobDetailBean = new JobDetailBean();
jobDetailBean.setGroup(XsltTriggerService.TRIGGER_GROUP_NAME);
jobDetailBean.setName(newTrigger.getName());
jobDetailBean.setJobClass(org.akaza.openclinica.job.XsltStatefulJob.class);
jobDetailBean.setJobDataMap(newTrigger.getJobDataMap());
jobDetailBean.setDurability(true); // need durability?
jobDetailBean.setVolatility(false);
scheduler.deleteJob(theJobName, theJobGroupName);
scheduler.scheduleJob(jobDetailBean, newTrigger);
pageMessages.add("The Job " + theJobName + " has been rescheduled");
}
request.setAttribute("pageMessages", pageMessages);
logger.debug("jobDetails>" + scheduler.getJobDetail(theJobName, theJobGroupName));
}
sdvUtil.forwardRequestFromController(request, response, "/pages/" + redirection);
return null;
}
@RequestMapping("/listCurrentScheduledJobs")
public ModelMap listScheduledJobs(HttpServletRequest request, HttpServletResponse response)
throws SchedulerException {
Locale locale = LocaleResolver.getLocale(request);
ResourceBundleProvider.updateLocale(locale);
ModelMap gridMap = new ModelMap();
String[] triggerNames;
boolean showMoreLink = false;
if (request.getParameter("showMoreLink") != null) {
showMoreLink = Boolean.parseBoolean(request.getParameter("showMoreLink").toString());
} else {
showMoreLink = true;
}
request.setAttribute("showMoreLink", showMoreLink + "");
// request.setAttribute("studySubjectId",studySubjectId);
/*SubjectIdSDVFactory tableFactory = new SubjectIdSDVFactory();
* @RequestParam("studySubjectId") int studySubjectId,*/
request.setAttribute("imagePathPrefix", "../");
ArrayList<String> pageMessages = (ArrayList<String>) request.getAttribute("pageMessages");
if (pageMessages == null) {
pageMessages = new ArrayList<String>();
}
request.setAttribute("pageMessages", pageMessages);
List<JobExecutionContext> listCurrentJobs = new ArrayList<JobExecutionContext>();
listCurrentJobs = scheduler.getCurrentlyExecutingJobs();
Iterator<JobExecutionContext> itCurrentJobs = listCurrentJobs.iterator();
List<String> currentJobList = new ArrayList<String>();
while (itCurrentJobs.hasNext()) {
JobExecutionContext temp = itCurrentJobs.next();
currentJobList.add(temp.getTrigger().getJobName() + temp.getTrigger().getGroup());
}
String[] triggerGroups = scheduler.getTriggerGroupNames();
List<SimpleTrigger> simpleTriggers = new ArrayList<SimpleTrigger>();
int index1 = 0;
for (String triggerGroup : triggerGroups) {
logger.debug("Group: " + triggerGroup + " contains the following triggers");
triggerNames = scheduler.getTriggerNames(triggerGroup);
for (String triggerName : triggerNames) {
int state = scheduler.getTriggerState(triggerName, triggerGroup);
logger.debug("- " + triggerName);
if (state != Trigger.STATE_PAUSED) {
simpleTriggers.add(
index1, (SimpleTrigger) scheduler.getTrigger(triggerName, triggerGroup));
index1++;
}
}
}
List<ScheduledJobs> jobsScheduled = new ArrayList<ScheduledJobs>();
int index = 0;
for (SimpleTrigger st : simpleTriggers) {
boolean isExecuting = currentJobList.contains(st.getJobName() + st.getGroup());
ScheduledJobs jobs = new ScheduledJobs();
ExtractPropertyBean epBean = null;
if (st.getJobDataMap() != null) {
epBean = (ExtractPropertyBean) st.getJobDataMap().get(EP_BEAN);
}
if (epBean != null) {
StringBuilder checkbox = new StringBuilder();
checkbox.append("<input style='margin-right: 5px' type='checkbox'/>");
StringBuilder actions = new StringBuilder("<table><tr><td>");
if (isExecuting) {
actions.append(" ");
} else {
String contextPath = request.getContextPath();
StringBuilder jsCodeString =
new StringBuilder("this.form.method='GET'; this.form.action='")
.append(contextPath)
.append("/pages/cancelScheduledJob")
.append("';")
.append("this.form.theJobName.value='")
.append(st.getJobName())
.append("';")
.append("this.form.theJobGroupName.value='")
.append(st.getJobGroup())
.append("';")
.append("this.form.theTriggerName.value='")
.append(st.getName())
.append("';")
.append("this.form.theTriggerGroupName.value='")
.append(st.getGroup())
.append("';")
.append("this.form.submit();");
actions
.append("<td><input type=\"submit\" class=\"button\" value=\"Cancel Job\" ")
.append("name=\"cancelJob\" onclick=\"")
.append(jsCodeString.toString())
.append("\" />");
}
actions.append("</td></tr></table>");
jobs.setCheckbox(checkbox.toString());
jobs.setDatasetId(epBean.getDatasetName());
String fireTime =
st.getStartTime() != null ? longFormat(locale).format(st.getStartTime()) : "";
jobs.setFireTime(fireTime);
if (st.getNextFireTime() != null) {
jobs.setScheduledFireTime(longFormat(locale).format(st.getNextFireTime()));
}
jobs.setExportFileName(epBean.getExportFileName()[0]);
jobs.setAction(actions.toString());
jobs.setJobStatus(isExecuting ? "Currently Executing" : "Scheduled");
jobsScheduled.add(index, jobs);
index++;
}
}
logger.debug("totalRows" + index);
request.setAttribute("totalJobs", index);
request.setAttribute("jobs", jobsScheduled);
TableFacade facade = scheduledJobTableFactory.createTable(request, response);
String sdvMatrix = facade.render();
gridMap.addAttribute(SCHEDULED_TABLE_ATTRIBUTE, sdvMatrix);
return gridMap;
}
@Override
protected void executeInternal(JobExecutionContext context) throws JobExecutionException {
// need to generate a Locale so that user beans and other things will
// generate normally
Locale locale = new Locale("en-US");
ResourceBundleProvider.updateLocale(locale);
ResourceBundle pageMessages = ResourceBundleProvider.getPageMessagesBundle();
// logger.debug("--");
// logger.debug("-- executing a job " + message + " at " + new
// java.util.Date().toString());
JobDataMap dataMap = context.getMergedJobDataMap();
SimpleTrigger trigger = (SimpleTrigger) context.getTrigger();
try {
ApplicationContext appContext =
(ApplicationContext) context.getScheduler().getContext().get("applicationContext");
String studySubjectNumber =
((CoreResources) appContext.getBean("coreResources")).getField("extract.number");
coreResources = (CoreResources) appContext.getBean("coreResources");
ruleSetRuleDao = (RuleSetRuleDao) appContext.getBean("ruleSetRuleDao");
dataSource = (DataSource) appContext.getBean("dataSource");
mailSender = (OpenClinicaMailSender) appContext.getBean("openClinicaMailSender");
AuditEventDAO auditEventDAO = new AuditEventDAO(dataSource);
// Scheduler scheduler = context.getScheduler();
// JobDetail detail = context.getJobDetail();
// jobDetailBean = (JobDetailBean) detail;
/*
* data map here should coincide with the job data map found in
* CreateJobExportServlet, with the following code: jobDataMap = new
* JobDataMap(); jobDataMap.put(DATASET_ID, datasetId);
* jobDataMap.put(PERIOD, period); jobDataMap.put(EMAIL, email);
* jobDataMap.put(TAB, tab); jobDataMap.put(CDISC, cdisc);
* jobDataMap.put(SPSS, spss);
*/
String alertEmail = dataMap.getString(EMAIL);
String localeStr = dataMap.getString(LOCALE);
if (localeStr != null) {
locale = new Locale(localeStr);
ResourceBundleProvider.updateLocale(locale);
pageMessages = ResourceBundleProvider.getPageMessagesBundle();
}
int dsId = dataMap.getInt(DATASET_ID);
String tab = dataMap.getString(TAB);
String cdisc = dataMap.getString(CDISC);
String cdisc12 = dataMap.getString(CDISC12);
if (cdisc12 == null) {
cdisc12 = "0";
}
String cdisc13 = dataMap.getString(CDISC13);
if (cdisc13 == null) {
cdisc13 = "0";
}
String cdisc13oc = dataMap.getString(CDISC13OC);
if (cdisc13oc == null) {
cdisc13oc = "0";
}
String spss = dataMap.getString(SPSS);
int userId = dataMap.getInt(USER_ID);
int studyId = dataMap.getInt(STUDY_ID);
// String datasetId = dataMap.getString(DATASET_ID);
// int dsId = new Integer(datasetId).intValue();
// String userAcctId = dataMap.getString(USER_ID);
// int userId = new Integer(userAcctId).intValue();
// why the flip-flop? if one property is set to 'true' we can
// see jobs in another screen but all properties have to be
// strings
logger.debug("-- found the job: " + dsId + " dataset id");
// for (Iterator it = dataMap.entrySet().iterator(); it.hasNext();)
// {
// java.util.Map.Entry entry = (java.util.Map.Entry) it.next();
// Object key = entry.getKey();
// Object value = entry.getValue();
// // logger.debug("-- found datamap property: " + key.toString() +
// // " : " + value.toString());
// }
HashMap fileName = new HashMap<String, Integer>();
if (dsId > 0) {
// trying to not throw an error if there's no dataset id
DatasetDAO dsdao = new DatasetDAO(dataSource);
DatasetBean datasetBean = (DatasetBean) dsdao.findByPK(dsId);
StudyDAO studyDao = new StudyDAO(dataSource);
UserAccountDAO userAccountDAO = new UserAccountDAO(dataSource);
// hmm, three lines in the if block DRY?
String generalFileDir = "";
String generalFileDirCopy = "";
String exportFilePath = SQLInitServlet.getField("exportFilePath");
String pattern =
"yyyy"
+ File.separator
+ "MM"
+ File.separator
+ "dd"
+ File.separator
+ "HHmmssSSS"
+ File.separator;
SimpleDateFormat sdfDir = new SimpleDateFormat(pattern);
generalFileDir =
DATASET_DIR
+ datasetBean.getId()
+ File.separator
+ sdfDir.format(new java.util.Date());
if (!"".equals(exportFilePath)) {
generalFileDirCopy =
SQLInitServlet.getField("filePath") + exportFilePath + File.separator;
}
// logger.debug("-- created the following dir: " +
// generalFileDir);
long sysTimeBegin = System.currentTimeMillis();
// set up the user bean here, tbh
// logger.debug("-- gen tab file 00");
userBean = (UserAccountBean) userAccountDAO.findByPK(userId);
// needs to also be captured by the servlet, tbh
// logger.debug("-- gen tab file 00");
generateFileService =
new GenerateExtractFileService(dataSource, userBean, coreResources, ruleSetRuleDao);
// logger.debug("-- gen tab file 00");
// tbh #5796 - covers a bug when the user changes studies, 10/2010
StudyBean activeStudy = (StudyBean) studyDao.findByPK(studyId);
StudyBean parentStudy = new StudyBean();
logger.debug(
"active study: " + studyId + " parent study: " + activeStudy.getParentStudyId());
if (activeStudy.getParentStudyId() > 0) {
// StudyDAO sdao = new StudyDAO(sm.getDataSource());
parentStudy = (StudyBean) studyDao.findByPK(activeStudy.getParentStudyId());
} else {
parentStudy = activeStudy;
// covers a bug in tab file creation, tbh 01/2009
}
logger.debug("-- found extract bean ");
ExtractBean eb =
generateFileService.generateExtractBean(datasetBean, activeStudy, parentStudy);
MessageFormat mf = new MessageFormat("");
StringBuffer message = new StringBuffer();
StringBuffer auditMessage = new StringBuffer();
// use resource bundle page messages to generate the email, tbh
// 02/2009
// message.append(pageMessages.getString("html_email_header_1")
// + " " + alertEmail +
// pageMessages.getString("html_email_header_2") + "<br/>");
message.append(
"<p>"
+ pageMessages.getString("email_header_1")
+ " "
+ EmailEngine.getAdminEmail()
+ " "
+ pageMessages.getString("email_header_2")
+ " Job Execution "
+ pageMessages.getString("email_header_3")
+ "</p>");
message.append("<P>Dataset: " + datasetBean.getName() + "</P>");
message.append("<P>Study: " + activeStudy.getName() + "</P>");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_1")
+ datasetBean.getName()
+ pageMessages.getString("html_email_body_2")
+ SQLInitServlet.getField("sysURL")
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// logger.debug("-- gen tab file 00");
if ("1".equals(tab)) {
logger.debug("-- gen tab file 01");
fileName =
generateFileService.createTabFile(
eb,
sysTimeBegin,
generalFileDir,
datasetBean,
activeStudy.getId(),
parentStudy.getId(),
generalFileDirCopy);
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// MessageFormat mf = new MessageFormat("");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_tab_delimited"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// auditMessage.append(
// "You can access your tab-delimited file <a href='AccessFile?fileId="
// + getFileIdInt(fileName) + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_tab_delimited")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
if ("1".equals(cdisc)) {
String odmVersion = "oc1.2";
fileName =
generateFileService.createODMFile(
odmVersion,
sysTimeBegin,
generalFileDir,
datasetBean,
activeStudy,
generalFileDirCopy,
eb,
activeStudy.getId(),
parentStudy.getId(),
studySubjectNumber,
true,
true,
true,
null);
logger.debug("-- gen odm file");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// MessageFormat mf = new MessageFormat("");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_odm_12"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// auditMessage.append(
// "You can access your ODM 1.2 w/OpenClinica Extension XML file <a
// href='AccessFile?fileId="
// + getFileIdInt(fileName)
// + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_odm_12")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
if ("1".equals(cdisc12)) {
String odmVersion = "1.2";
fileName =
generateFileService.createODMFile(
odmVersion,
sysTimeBegin,
generalFileDir,
datasetBean,
activeStudy,
generalFileDirCopy,
eb,
activeStudy.getId(),
parentStudy.getId(),
studySubjectNumber,
true,
true,
true,
null);
logger.debug("-- gen odm file 1.2 default");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_odm_12_xml"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// // auditMessage.append(
// "You can access your ODM 1.2 XML file <a href='AccessFile?fileId="
// + getFileIdInt(fileName) + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_odm_12_xml")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
if ("1".equals(cdisc13)) {
String odmVersion = "1.3";
fileName =
generateFileService.createODMFile(
odmVersion,
sysTimeBegin,
generalFileDir,
datasetBean,
activeStudy,
generalFileDirCopy,
eb,
activeStudy.getId(),
parentStudy.getId(),
studySubjectNumber,
true,
true,
true,
null);
logger.debug("-- gen odm file 1.3");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// MessageFormat mf = new MessageFormat("");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_odm_13"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// auditMessage.append(
// "You can access your ODM 1.3 XML file <a href='AccessFile?fileId="
// + getFileIdInt(fileName) + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_odm_13")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
if ("1".equals(cdisc13oc)) {
String odmVersion = "oc1.3";
fileName =
generateFileService.createODMFile(
odmVersion,
sysTimeBegin,
generalFileDir,
datasetBean,
activeStudy,
generalFileDirCopy,
eb,
activeStudy.getId(),
parentStudy.getId(),
studySubjectNumber,
true,
true,
true,
null);
logger.debug("-- gen odm file 1.3 oc");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// MessageFormat mf = new MessageFormat("");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_odm_13_xml"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// auditMessage.append(
// "You can access your ODM 1.3 w/OpenClinica Extension XML file <a
// href='AccessFile?fileId="
// + getFileIdInt(fileName)
// + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_odm_13_xml")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
if ("1".equals(spss)) {
SPSSReportBean answer = new SPSSReportBean();
fileName =
generateFileService.createSPSSFile(
datasetBean,
eb,
activeStudy,
parentStudy,
sysTimeBegin,
generalFileDir,
answer,
generalFileDirCopy);
logger.debug("-- gen spss file");
message.append(
"<p>"
+ pageMessages.getString("html_email_body_4")
+ " "
+ getFileNameStr(fileName)
+ pageMessages.getString("html_email_body_4_5")
+ SQLInitServlet.getField("sysURL.base")
+ "AccessFile?fileId="
+ getFileIdInt(fileName)
+ pageMessages.getString("html_email_body_3")
+ "</p>");
// MessageFormat mf = new MessageFormat("");
// mf.applyPattern(pageMessages.getString(
// "you_can_access_spss"));
// Object[] arguments = { getFileIdInt(fileName) };
// auditMessage.append(mf.format(arguments));
// auditMessage.append(
// "You can access your SPSS files <a href='AccessFile?fileId="
// + getFileIdInt(fileName) + "'>here</a>.<br/>");
auditMessage.append(
pageMessages.getString("you_can_access_spss")
+ getFileIdInt(fileName)
+ pageMessages.getString("access_end"));
}
// wrap up the message, and send the email
message.append(
"<p>"
+ pageMessages.getString("html_email_body_5")
+ "</P><P>"
+ pageMessages.getString("email_footer"));
try {
mailSender.sendEmail(
alertEmail.trim(),
pageMessages.getString("job_ran_for") + " " + datasetBean.getName(),
message.toString(),
true);
} catch (OpenClinicaSystemException ose) {
// Do Nothing, In the future we might want to have an email
// status added to system.
}
TriggerBean triggerBean = new TriggerBean();
triggerBean.setDataset(datasetBean);
triggerBean.setUserAccount(userBean);
triggerBean.setFullName(trigger.getName());
auditEventDAO.createRowForExtractDataJobSuccess(triggerBean, auditMessage.toString());
} else {
TriggerBean triggerBean = new TriggerBean();
// triggerBean.setDataset(datasetBean);
triggerBean.setUserAccount(userBean);
triggerBean.setFullName(trigger.getName());
auditEventDAO.createRowForExtractDataJobFailure(triggerBean);
// logger.debug("-- made it here for some reason, ds id: "
// + dsId);
}
// logger.debug("-- generated file: " + fileNameStr);
// dataSource.
} catch (Exception e) {
// TODO Auto-generated catch block -- ideally should generate a fail
// msg here, tbh 02/2009
logger.debug("-- found exception: " + e.getMessage());
e.printStackTrace();
}
}