List<Object> pObjects = new ArrayList<Object>();
//pObjects.add(MailStatus.COMPLETE.toString());
//pObjects.add(MailStatus.FAILURE.toString());
pObjects.add(MailStatus.NOSEND.toString());
SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection());
Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
String sqlText=pagination.getPaginationSql("SELECT * FROM FIXFLOW_MAIL WHERE MAIL_STATUS=?", 1, 10, "*", null);
List<Map<String, Object>> dataList = sqlCommand.queryForList(sqlText, pObjects);
for (Map<String, Object> mapData : dataList) {
try {
FixMailTo fixMailTo = new FixMailTo();
fixMailTo.persistentInit(mapData);
MailUtil mailUtil = new MailUtil();
mailUtil.setSmtpHost(mailInfoObj.getSmtpHost(), StringUtil.getInt(mailInfoObj.getSmtpPort()));
mailUtil.setSmtpAuthentication(mailInfoObj.getUserName(), mailInfoObj.getPassWord());
// 支持发送多人邮件 #4185
String to = fixMailTo.getMailTo();
if (to == null || to.equals("")) {
throw new FixFlowBizException("mailTo is null");
}
String[] str = to.split(",");
List<String> userMailToList=new ArrayList<String>();
for (String userMail : str) {
if(userMail==null||userMail.equals("")||userMail.trim().equals("")){
}
else{
userMailToList.add(userMail);
}
}
if(userMailToList.size()==0){
throw new FixFlowBizException("Mail toaddress is null");
}
String[] userMailToFinStrings=(String[])userMailToList.toArray(new String[userMailToList.size()]);
mailUtil.setTo(userMailToFinStrings);
String cc = fixMailTo.getMailCc();
if (cc != null && !cc.equals("")) {
String[] strCC = cc.split(",");
List<String> userMailCCList=new ArrayList<String>();
for (String userMail : strCC) {
if(userMail==null||userMail.equals("")||userMail.trim().equals("")){
}
else{
userMailCCList.add(userMail);
}
}
if(userMailCCList.size()==0){
throw new FixFlowBizException("Mail ccaddress is null");
}
String[] userMailCCFinStrings=(String[])userMailCCList.toArray(new String[userMailCCList.size()]);
mailUtil.setCC(userMailCCFinStrings);
}
String title = fixMailTo.getMailSubject();
String mailContent = fixMailTo.getMailBody();
mailUtil.setFrom(mailInfoObj.getMailAddress());
mailUtil.setSubject(title);
mailUtil.setBody(mailContent);
mailUtil.setContentType(mailUtil.MODE_HTML);
Map<String, Object> objectParam = new HashMap<String, Object>();
objectParam.put("MAIL_STATUS", MailStatus.COMPLETE.toString());
// 构建Where查询参数
Object[] objectParamWhere = { StringUtil.getString(mapData.get("MAIL_ID")) };
sqlCommand.update("FIXFLOW_MAIL", objectParam, " MAIL_ID=?", objectParamWhere);
// 异步发送
mailUtil.send();
} catch (Exception e) {
try {
Map<String, Object> objectParam = new HashMap<String, Object>();
objectParam.put("MAIL_STATUS", MailStatus.FAILURE.toString());
objectParam.put("FAILURE_REASON", e.getMessage());
// 构建Where查询参数
Object[] objectParamWhere = { StringUtil.getString(mapData.get("MAIL_ID")) };
sqlCommand.update("FIXFLOW_MAIL", objectParam, " MAIL_ID=?", objectParamWhere);
} catch (Exception e2) {
e.printStackTrace();
e2.printStackTrace();
//throw new FixFlowException("邮件发送失败",e2);
}
} finally {
try {
Map<String, Object> objectParam = new HashMap<String, Object>();
objectParam.put("SEND_TIME", new Date());
// 构建Where查询参数
Object[] objectParamWhere = { StringUtil.getString(mapData.get("MAIL_ID")) };
sqlCommand.update("FIXFLOW_MAIL", objectParam, " MAIL_ID=?", objectParamWhere);
} catch (Exception e) {
e.printStackTrace();
//throw new FixFlowException("邮件发送失败",e);
}