WechatSubscribeV1ServiceDaoImpl.java
4.81 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
/*
* Copyright 2017-2020 吴学文 and java110 team.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.java110.user.dao.impl;
import com.alibaba.fastjson.JSONObject;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
import com.java110.core.base.dao.BaseServiceDao;
import com.java110.user.dao.IWechatSubscribeV1ServiceDao;
import com.java110.utils.util.ListUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
import java.util.Map;
/**
* 类表述：
* add by 吴学文 at 2022-02-22 16:17:23 mail: 928255095@qq.com
* open source address: https://gitee.com/wuxw7/MicroCommunity
* 官网：http://www.homecommunity.cn
* 温馨提示：如果您对此文件进行修改 请不要删除原有作者及注释信息，请补充您的 修改的原因以及联系邮箱如下
* // modify by 张三 at 2021-09-12 第10行在某种场景下存在某种bug 需要修复，注释10至20行 加入 20行至30行
*/
@Service("wechatSubscribeV1ServiceDaoImpl")
public class WechatSubscribeV1ServiceDaoImpl extends BaseServiceDao implements IWechatSubscribeV1ServiceDao {
private static Logger logger = LoggerFactory.getLogger(WechatSubscribeV1ServiceDaoImpl.class);
/**
* 保存微信关注信息 到 instance
* @param info bId 信息
* @throws DAOException DAO异常
*/
@Override
public int saveWechatSubscribeInfo(Map info) throws DAOException {
logger.debug("保存 saveWechatSubscribeInfo 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.insert("wechatSubscribeV1ServiceDaoImpl.saveWechatSubscribeInfo",info);
return saveFlag;
}
@Override
public int saveWechatSubscribeInfos(Map info) throws DAOException {
logger.debug("保存 saveWechatSubscribeInfos 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.insert("wechatSubscribeV1ServiceDaoImpl.saveWechatSubscribeInfos",info);
return saveFlag;
}
/**
* 查询微信关注信息（instance）
* @param info bId 信息
* @return List<Map>
* @throws DAOException DAO异常
*/
@Override
public List<Map> getWechatSubscribeInfo(Map info) throws DAOException {
logger.debug("查询 getWechatSubscribeInfo 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("wechatSubscribeV1ServiceDaoImpl.getWechatSubscribeInfo",info);
return infos;
}
/**
* 查询微信关注信息（instance）
* @param info bId 信息
* @return List<Map>
* @throws DAOException DAO异常
*/
@Override
public List<Map> queryDistinctWechatSubscribes(Map info) throws DAOException {
logger.debug("查询 queryDistinctWechatSubscribes 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("wechatSubscribeV1ServiceDaoImpl.queryDistinctWechatSubscribes",info);
return infos;
}
/**
* 修改微信关注信息
* @param info 修改信息
* @throws DAOException DAO异常
*/
@Override
public int updateWechatSubscribeInfo(Map info) throws DAOException {
logger.debug("修改 updateWechatSubscribeInfo 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.update("wechatSubscribeV1ServiceDaoImpl.updateWechatSubscribeInfo",info);
return saveFlag;
}
/**
* 查询微信关注数量
* @param info 微信关注信息
* @return 微信关注数量
*/
@Override
public int queryWechatSubscribesCount(Map info) {
logger.debug("查询 queryWechatSubscribesCount 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("wechatSubscribeV1ServiceDaoImpl.queryWechatSubscribesCount", info);
if (ListUtil.isNull(infos)) {
return 0;
}
return Integer.parseInt(infos.get(0).get("count").toString());
}
@Override
public int deleteWechatSubscribe(Map info) {
logger.debug("修改 deleteWechatSubscribe 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.update("wechatSubscribeV1ServiceDaoImpl.deleteWechatSubscribe",info);
return saveFlag;
}
}