package com.jsh.erp.service.msg;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.jsh.erp.constants.BusinessConstants;
|
import com.jsh.erp.constants.ExceptionConstants;
|
import com.jsh.erp.datasource.entities.Msg;
|
import com.jsh.erp.datasource.entities.MsgEx;
|
import com.jsh.erp.datasource.entities.MsgExample;
|
import com.jsh.erp.datasource.entities.User;
|
import com.jsh.erp.datasource.mappers.MsgMapper;
|
import com.jsh.erp.datasource.mappers.MsgMapperEx;
|
import com.jsh.erp.datasource.vo.DepotHeadVo4List;
|
import com.jsh.erp.exception.BusinessRunTimeException;
|
import com.jsh.erp.service.depotHead.DepotHeadService;
|
import com.jsh.erp.service.log.LogService;
|
import com.jsh.erp.service.user.UserService;
|
import com.jsh.erp.utils.StringUtil;
|
import com.jsh.erp.utils.Tools;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.context.request.RequestContextHolder;
|
import org.springframework.web.context.request.ServletRequestAttributes;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import static com.jsh.erp.utils.Tools.getCenternTime;
|
|
@Service
|
public class MsgService {
|
private Logger logger = LoggerFactory.getLogger(MsgService.class);
|
@Resource
|
private MsgMapper msgMapper;
|
|
@Resource
|
private MsgMapperEx msgMapperEx;
|
|
@Resource
|
private DepotHeadService depotHeadService;
|
|
@Resource
|
private UserService userService;
|
|
@Resource
|
private LogService logService;
|
|
public Msg getMsg(long id)throws Exception {
|
Msg result=null;
|
try{
|
result=msgMapper.selectByPrimaryKey(id);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return result;
|
}
|
|
public List<Msg> getMsg()throws Exception {
|
MsgExample example = new MsgExample();
|
example.createCriteria().andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
|
List<Msg> list=null;
|
try{
|
list=msgMapper.selectByExample(example);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return list;
|
}
|
|
public List<MsgEx> select(String name, int offset, int rows)throws Exception {
|
List<MsgEx> list=null;
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
list = msgMapperEx.selectByConditionMsg(userInfo.getId(), name, offset, rows);
|
if (null != list) {
|
for (MsgEx msgEx : list) {
|
if (msgEx.getCreateTime() != null) {
|
msgEx.setCreateTimeStr(getCenternTime(msgEx.getCreateTime()));
|
}
|
}
|
}
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return list;
|
}
|
|
public Long countMsg(String name)throws Exception {
|
Long result=null;
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
result = msgMapperEx.countsByMsg(userInfo.getId(), name);
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return result;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public int insertMsg(JSONObject obj, HttpServletRequest request)throws Exception {
|
Msg msg = JSONObject.parseObject(obj.toJSONString(), Msg.class);
|
int result=0;
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
msg.setCreateTime(new Date());
|
msg.setStatus("1");
|
result=msgMapper.insertSelective(msg);
|
logService.insertLog("消息",
|
new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ADD).append(msg.getMsgTitle()).toString(), request);
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
return result;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public int updateMsg(JSONObject obj, HttpServletRequest request) throws Exception{
|
Msg msg = JSONObject.parseObject(obj.toJSONString(), Msg.class);
|
int result=0;
|
try{
|
result=msgMapper.updateByPrimaryKeySelective(msg);
|
logService.insertLog("消息",
|
new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_EDIT).append(msg.getMsgTitle()).toString(), request);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
return result;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public int deleteMsg(Long id, HttpServletRequest request)throws Exception {
|
int result=0;
|
try{
|
result=msgMapper.deleteByPrimaryKey(id);
|
logService.insertLog("消息",
|
new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_DELETE).append(id).toString(), request);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
return result;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public int batchDeleteMsg(String ids, HttpServletRequest request) throws Exception{
|
List<Long> idList = StringUtil.strToLongList(ids);
|
MsgExample example = new MsgExample();
|
example.createCriteria().andIdIn(idList);
|
int result=0;
|
try{
|
result=msgMapper.deleteByExample(example);
|
logService.insertLog("消息", "批量删除,id集:" + ids, request);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
return result;
|
}
|
|
public int checkIsNameExist(Long id, String name)throws Exception {
|
MsgExample example = new MsgExample();
|
example.createCriteria().andIdNotEqualTo(id).andMsgTitleEqualTo(name).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
|
List<Msg> list=null;
|
try{
|
list= msgMapper.selectByExample(example);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return list==null?0:list.size();
|
}
|
|
/**
|
* create by: qiankunpingtai
|
* 逻辑删除角色信息
|
* create time: 2019/3/28 15:44
|
* @Param: ids
|
* @return int
|
*/
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public int batchDeleteMsgByIds(String ids) throws Exception{
|
logService.insertLog("序列号",
|
new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_DELETE).append(ids).toString(),
|
((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest());
|
String [] idArray=ids.split(",");
|
int result=0;
|
try{
|
result=msgMapperEx.batchDeleteMsgByIds(idArray);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
return result;
|
}
|
|
public List<MsgEx> getMsgByStatus(String status)throws Exception {
|
List<MsgEx> resList=new ArrayList<>();
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
MsgExample example = new MsgExample();
|
example.createCriteria().andStatusEqualTo(status).andUserIdEqualTo(userInfo.getId())
|
.andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
|
example.setOrderByClause("id desc");
|
List<Msg> list = msgMapper.selectByExample(example);
|
if (null != list) {
|
for (Msg msg : list) {
|
if (msg.getCreateTime() != null) {
|
MsgEx msgEx = new MsgEx();
|
msgEx.setId(msg.getId());
|
msgEx.setMsgTitle(msg.getMsgTitle());
|
msgEx.setMsgContent(msg.getMsgContent());
|
msgEx.setStatus(msg.getStatus());
|
msgEx.setType(msg.getType());
|
msgEx.setCreateTimeStr(Tools.getCenternTime(msg.getCreateTime()));
|
resList.add(msgEx);
|
}
|
}
|
}
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return resList;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public void batchUpdateStatus(String ids, String status) throws Exception{
|
List<Long> idList = StringUtil.strToLongList(ids);
|
Msg msg = new Msg();
|
msg.setStatus(status);
|
MsgExample example = new MsgExample();
|
example.createCriteria().andIdIn(idList);
|
try{
|
msgMapper.updateByExampleSelective(msg, example);
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
}
|
|
public Long getMsgCountByStatus(String status)throws Exception {
|
Long result=null;
|
try{
|
User userInfo=userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
result = msgMapperEx.getMsgCountByStatus(status, userInfo.getId());
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return result;
|
}
|
|
public Integer getMsgCountByType(String type)throws Exception {
|
int msgCount = 0;
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
MsgExample example = new MsgExample();
|
example.createCriteria().andTypeEqualTo(type).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
|
List<Msg> list = msgMapper.selectByExample(example);
|
msgCount = list.size();
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_READ_FAIL_CODE, ExceptionConstants.DATA_READ_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_READ_FAIL_CODE,
|
ExceptionConstants.DATA_READ_FAIL_MSG);
|
}
|
return msgCount;
|
}
|
|
@Transactional(value = "transactionManager", rollbackFor = Exception.class)
|
public void readAllMsg() throws Exception{
|
try{
|
User userInfo = userService.getCurrentUser();
|
if(!BusinessConstants.DEFAULT_MANAGER.equals(userInfo.getLoginName())) {
|
Msg msg = new Msg();
|
msg.setStatus("2");
|
MsgExample example = new MsgExample();
|
example.createCriteria();
|
msgMapper.updateByExampleSelective(msg, example);
|
}
|
}catch(Exception e){
|
logger.error("异常码[{}],异常提示[{}],异常[{}]",
|
ExceptionConstants.DATA_WRITE_FAIL_CODE, ExceptionConstants.DATA_WRITE_FAIL_MSG,e);
|
throw new BusinessRunTimeException(ExceptionConstants.DATA_WRITE_FAIL_CODE,
|
ExceptionConstants.DATA_WRITE_FAIL_MSG);
|
}
|
}
|
}
|
