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 params = new ArrayList(); 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; } }