From b7ef4bb09e69ba27c29ea06a7f348f753c530a44 Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期二, 24 九月 2024 17:54:27 +0800
Subject: [PATCH] CRM邮箱配置调整
---
src/com/yc/crm/schedule/MessagePopSchedule.java | 13 +++----------
1 files changed, 3 insertions(+), 10 deletions(-)
diff --git a/src/com/yc/crm/schedule/MessagePopSchedule.java b/src/com/yc/crm/schedule/MessagePopSchedule.java
index 2e03c7b..c68ec50 100644
--- a/src/com/yc/crm/schedule/MessagePopSchedule.java
+++ b/src/com/yc/crm/schedule/MessagePopSchedule.java
@@ -49,17 +49,10 @@
}
//鍥犱负鐢ㄦ埛宸蹭笅绾匡紝涓轰簡閬垮厤鍙戦�佸け璐ュ鑷寸敤鎴蜂笅娆＄櫥褰曟敹涓嶅埌閫氱煡鐨勬儏鍐碉紝鍙栨暟鍙婃洿鏂版鏁板垎寮�澶勭悊
final List<MessageTipsEntity> list = doIfc.doQuery("set nocount on ; declare @UserCodes varchar(max) =" +GridUtils.prossSqlParm(joiner.toString())+
- "\n select a.messid,a.messagetxt,a.unvaliddate,a.createuser,a.createtime,\n" +
- " a.rejustsrvflag,a.Readers,a.UsrReaded,a.tipcount,a.formid,\n" +
- " a.formtype,a.origfields,a.linkfields,a.linkmode,a.self_datafields,\n" +
- " a.link_datafields,a.efilter , b.usercode ,a.url ,\n" +
- " a.createusername ,a.topic ,a.messagetype ,a.isPublicUser,"+dataSourceEntity.getDbId()+"as dbid\n" +
- " from _sysMessageCount b \n" +
- " join _sysmessage a on a.messid = b.messid\n" +
+ "\n select refid as id,userCode,userName,title,"+dataSourceEntity.getDbId()+"as dbid\n" +
+ " from t482114 b \n" +
" where b.usercode in (select list from getinstr(@UserCodes)) \n" +
- " and b.tipcount < a.tipcount\n" +
- " and a.unvaliddate >= getdate() \n" +
- " and b.isRead = 0 ", MessageTipsEntity.class);
+ " and b.isPost = 0 ", MessageTipsEntity.class);
if (list != null && list.size() > 0) {
final StringJoiner updateJoiner=new StringJoiner("\n");
list.stream().unordered().distinct().forEach(x -> {
--
Gitblit v1.8.0