package com.product.administration.service;
|
|
import com.product.common.lang.StringUtils;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.permission.PermissionService;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.service.support.QueryFilterService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* Copyright LX
|
* @Title: NewsAccountService
|
* @Project: product-server
|
* @date: 2021-06-08 14:24
|
* @author: ZhouJie
|
* @Description: 消息台账
|
*/
|
@Component
|
@Service
|
public class NewsAccountService extends AbstractBaseService {
|
@Autowired
|
public BaseDao baseDao;
|
@Autowired
|
PermissionService permissionService;
|
@Autowired
|
QueryFilterService queryFilterService;
|
public DataTableEntity NewsAccountList(FieldSetEntity fs) {
|
int user_id = SpringMVCContextHolder.getCurrentUser().getUser_id();
|
StringBuffer str = new StringBuffer();
|
str.append(" select * FROM product_sys_message where uuid in( ");
|
str.append(" select message_uuid FROM product_sys_message_user where user_id=? ) ");
|
List<Object> params = new ArrayList<Object>();
|
params.add(user_id);
|
if(!StringUtils.isEmpty(fs.getString("message_type"))){
|
str.append(" and message_type=? ");
|
params.add(fs.getString("message_type"));
|
}
|
if(!StringUtils.isEmpty(fs.getString("send_user_id"))){
|
str.append(" and send_user_id=? ");
|
params.add(fs.getString("send_user_id"));
|
}
|
DataTableEntity dt = baseDao.listTable(str.toString(),params.toArray());
|
baseDao.loadPromptData(dt);
|
return dt;
|
}
|
|
|
}
|