From ee2316e2cb7afde1c54f5e4216a1b0d1e055749e Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期五, 27 九月 2024 17:33:14 +0800
Subject: [PATCH] CRM邮箱配置调整
---
src/com/yc/crm/mail/service/MailAccountImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/com/yc/crm/mail/service/MailAccountImpl.java b/src/com/yc/crm/mail/service/MailAccountImpl.java
index 05b8740..a62ae7f 100644
--- a/src/com/yc/crm/mail/service/MailAccountImpl.java
+++ b/src/com/yc/crm/mail/service/MailAccountImpl.java
@@ -146,8 +146,8 @@
sql += "select companyId,companyName,email,password,alias_email as aliasEmail,userCode,userName,accountId,receive_server_user_name as receiveServerUserName," +
"isnull(bisync_flag,0) as biSyncFlag,isnull(proxyFlag,0) as proxyFlag,mailDomain,isnull(mailType,0) as mailType,mailStatus,keywordList,siteUrl,receiveProtocol," +
"receiveEmail,receivePassword,receiveSSL,receivePort,receiveHost,smtpEmail,smtpPassword,smtpSSL,smtpPort,smtpHost," +
- "isnull(invalid,0) as invalid,create_time as createTime,update_time as updateTime,DocVersion " +
- "from t482102 " +
+ "isnull(invalid,0) as invalid,create_time as createTime,update_time as updateTime,DocVersion, " +
+ "(case when isnull(mailStatus,'')='姝ｅ父' then 0 else -1 end) as mailStatusCode from t482102 " +
"where userCode=" + GridUtils.prossSqlParm(userCode);
sql += " order by accountId";
return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(T482102Entity.class));
--
Gitblit v1.8.0