package com.doumee.service.business.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.doumee.service.business.third.model.LoginUserInfo; import com.doumee.service.business.third.model.PageData; import com.doumee.service.business.third.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.business.PositionMapper; import com.doumee.dao.business.model.Position; import com.doumee.service.business.PositionService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.Date; import java.util.List; /** * 访客事由信息表Service实现 * @author 江蹄蹄 * @since 2024/04/28 15:44 */ @Service public class PositionServiceImpl implements PositionService { @Autowired private PositionMapper positionMapper; @Override public Integer create(Position model) { model.setCreator(model.getLoginUserInfo().getId()); model.setEditor(model.getCreator()); model.setIsdeleted(Constants.ZERO); model.setEditDate(new Date()); model.setCreateDate(model.getEditDate()); positionMapper.insert(model); return model.getId(); } @Override public void deleteById(Integer id, LoginUserInfo userInfo) { Position update = new Position(); update.setEditor(userInfo.getId()); update.setEditDate(new Date()); update.setIsdeleted(Constants.ONE); update.setId(id); positionMapper.updateById(update); } @Override public void delete(Position position, LoginUserInfo userInfo) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(position); positionMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids, LoginUserInfo userInfo) { if (CollectionUtils.isEmpty(ids)) { return; } for(Integer id :ids){ deleteById(id,userInfo); } } @Override public void updateById(Position model) { model.setEditor(model.getLoginUserInfo().getId()); model.setEditDate(new Date()); positionMapper.updateById(model); } @Override public void updateByIdInBatch(List positions) { if (CollectionUtils.isEmpty(positions)) { return; } for (Position position: positions) { this.updateById(position); } } @Override public Position findById(Integer id) { return positionMapper.selectById(id); } @Override public Position findOne(Position position) { QueryWrapper wrapper = new QueryWrapper<>(position); return positionMapper.selectOne(wrapper); } @Override public List findList(Position position) { QueryWrapper wrapper = new QueryWrapper<>(position); wrapper.eq("isdeleted",Constants.ZERO); return positionMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); pageWrap.getModel().setIsdeleted(Constants.ZERO); queryWrapper .select("*,(select count(1) from member where member.position_id = position.id and member.type=2 and isdeleted=0) as memberNum" ) .lambda() .eq(pageWrap.getModel().getId() != null, Position::getId, pageWrap.getModel().getId()) .eq(pageWrap.getModel().getCreator() != null, Position::getCreator, pageWrap.getModel().getCreator()) .ge(pageWrap.getModel().getCreateDate() != null, Position::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())) .le(pageWrap.getModel().getCreateDate() != null, Position::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())) .eq(pageWrap.getModel().getEditor() != null, Position::getEditor, pageWrap.getModel().getEditor()) .ge(pageWrap.getModel().getEditDate() != null, Position::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())) .le(pageWrap.getModel().getEditDate() != null, Position::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())) .eq(pageWrap.getModel().getIsdeleted() != null, Position::getIsdeleted, pageWrap.getModel().getIsdeleted()) .eq(pageWrap.getModel().getRemark() != null, Position::getRemark, pageWrap.getModel().getRemark()) .like(pageWrap.getModel().getName() != null, Position::getName, pageWrap.getModel().getName()) .eq(pageWrap.getModel().getSortnum() != null, Position::getSortnum, pageWrap.getModel().getSortnum()) .eq(pageWrap.getModel().getType() != null, Position::getType, pageWrap.getModel().getType()) .orderByAsc(Position::getSortnum) ; for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } return PageData.from(positionMapper.selectPage(page, queryWrapper)); } @Override public long count(Position position) { QueryWrapper wrapper = new QueryWrapper<>(position); return positionMapper.selectCount(wrapper); } }