package com.example.jz.service.impl;
|
|
import com.alibaba.excel.EasyExcel;
|
import com.alibaba.excel.context.AnalysisContext;
|
import com.alibaba.excel.event.AnalysisEventListener;
|
import com.alibaba.excel.metadata.data.ReadCellData;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.example.jz.dao.PublicityDao;
|
import com.example.jz.dao.UserDao;
|
import com.example.jz.modle.PageParam;
|
import com.example.jz.modle.dto.CauseLoadDto;
|
import com.example.jz.modle.dto.PublicityDto;
|
import com.example.jz.modle.dto.PublicityLoadDto;
|
import com.example.jz.modle.entity.Publicity;
|
import com.example.jz.modle.entity.User;
|
import com.example.jz.service.PublicityService;
|
import lombok.SneakyThrows;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.annotation.Resource;
|
import java.io.Serializable;
|
import java.util.Date;
|
import java.util.Map;
|
|
/**
|
* 公共宣传表(Publicity)表服务实现类
|
*
|
* @author makejava
|
* @since 2022-07-11 16:35:57
|
*/
|
@Service("publicityService")
|
public class PublicityServiceImpl extends ServiceImpl<PublicityDao, Publicity> implements PublicityService {
|
|
@Resource
|
private PublicityDao publicityDao;
|
|
@Resource
|
private UserDao userDao;
|
|
@Override
|
public Boolean undercarriage(Serializable id) {
|
Publicity publicity = publicityDao.selectById(id);
|
publicity.setStatus(2);
|
if (publicityDao.updateById(publicity) == 1) {
|
return true;
|
}
|
return false;
|
}
|
|
@Override
|
public Boolean grounding(Serializable id) {
|
Publicity publicity = publicityDao.selectById(id);
|
publicity.setStatus(1);
|
publicity.setReleaseTime(new Date());
|
if (publicityDao.updateById(publicity) == 1) {
|
return true;
|
}
|
return false;
|
}
|
|
@Override
|
public IPage<PublicityDto> findByPage(PageParam<PublicityDto> page, QueryWrapper<PublicityDto> publicityDtoQueryWrapper) {
|
return publicityDao.findByPage(page, publicityDtoQueryWrapper);
|
}
|
|
@Override
|
@SneakyThrows
|
public void loadFile(MultipartFile multipartFile) {
|
EasyExcel.read(multipartFile.getInputStream(), PublicityLoadDto.class, new AnalysisEventListener<PublicityLoadDto>(){
|
|
@Override
|
public void invoke(PublicityLoadDto data, AnalysisContext context) {
|
if (StringUtils.isNotBlank(data.getPublicityTitle()) && StringUtils.isNotBlank(data.getUserName())) {
|
Publicity publicity = new Publicity();
|
publicity.setStatus(0);
|
BeanUtils.copyProperties(data,publicity);
|
publicity.setCtime(new Date());
|
publicity.setCreator(userDao.selectOne(new QueryWrapper<User>().eq("real_name",data.getUserName())).getId());
|
publicityDao.insert(publicity);
|
}
|
|
}
|
|
@Override
|
public void doAfterAllAnalysed(AnalysisContext context) {
|
|
}
|
}) .autoCloseStream(true)
|
.doReadAll();
|
}
|
}
|
