package com.doumee.service.business.impl;
|
|
import cn.hutool.core.lang.PatternPool;
|
import cn.hutool.core.lang.Validator;
|
import cn.hutool.core.util.ReUtil;
|
import com.doumee.core.model.PageData;
|
import com.doumee.core.model.PageWrap;
|
import com.doumee.core.utils.Constants;
|
import com.doumee.core.utils.Utils;
|
import com.doumee.dao.admin.request.RetentionQuery;
|
import com.doumee.dao.business.RetentionMapper;
|
import com.doumee.dao.business.join.RetentionJoinMapper;
|
import com.doumee.dao.business.model.*;
|
import com.doumee.dao.system.SystemDictDataMapper;
|
import com.doumee.dao.system.model.SystemDictData;
|
import com.doumee.service.business.RetentionService;
|
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.github.yulichang.wrapper.MPJLambdaWrapper;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
|
import java.util.*;
|
import java.util.function.Function;
|
import java.util.stream.Collectors;
|
|
/**
|
* 在厂人员信息 表（滞留）Service实现
|
* @author 江蹄蹄
|
* @date 2023/11/30 15:33
|
*/
|
@Service
|
public class RetentionServiceImpl implements RetentionService {
|
|
@Autowired
|
private RetentionMapper retentionMapper;
|
|
@Autowired
|
private RetentionJoinMapper retentionJoinMapper;
|
|
@Autowired
|
private SystemDictDataMapper systemDictDataMapper;
|
|
|
@Override
|
public Integer create(Retention retention) {
|
retentionMapper.insert(retention);
|
return retention.getId();
|
}
|
|
@Override
|
public void deleteById(Integer id) {
|
retentionMapper.deleteById(id);
|
}
|
|
@Override
|
public void delete(Retention retention) {
|
UpdateWrapper<Retention> deleteWrapper = new UpdateWrapper<>(retention);
|
retentionMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<Integer> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
retentionMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(Retention retention) {
|
retentionMapper.updateById(retention);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<Retention> retentions) {
|
if (CollectionUtils.isEmpty(retentions)) {
|
return;
|
}
|
for (Retention retention: retentions) {
|
this.updateById(retention);
|
}
|
}
|
|
@Override
|
public Retention findById(Integer id) {
|
return retentionMapper.selectById(id);
|
}
|
|
@Override
|
public Retention findOne(Retention retention) {
|
QueryWrapper<Retention> wrapper = new QueryWrapper<>(retention);
|
return retentionMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<Retention> findList(Retention retention) {
|
QueryWrapper<Retention> wrapper = new QueryWrapper<>(retention);
|
return retentionMapper.selectList(wrapper);
|
}
|
|
@Override
|
public PageData<Retention> findPage(PageWrap<Retention> pageWrap) {
|
IPage<Retention> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
QueryWrapper<Retention> queryWrapper = new QueryWrapper<>();
|
Utils.MP.blankToNull(pageWrap.getModel());
|
if (pageWrap.getModel().getId() != null) {
|
queryWrapper.lambda().eq(Retention::getId, pageWrap.getModel().getId());
|
}
|
if (pageWrap.getModel().getCreator() != null) {
|
queryWrapper.lambda().eq(Retention::getCreator, pageWrap.getModel().getCreator());
|
}
|
if (pageWrap.getModel().getCreateDate() != null) {
|
queryWrapper.lambda().ge(Retention::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
|
queryWrapper.lambda().le(Retention::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
|
}
|
if (pageWrap.getModel().getEditor() != null) {
|
queryWrapper.lambda().eq(Retention::getEditor, pageWrap.getModel().getEditor());
|
}
|
if (pageWrap.getModel().getEditDate() != null) {
|
queryWrapper.lambda().ge(Retention::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
|
queryWrapper.lambda().le(Retention::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
|
}
|
if (pageWrap.getModel().getIsdeleted() != null) {
|
queryWrapper.lambda().eq(Retention::getIsdeleted, pageWrap.getModel().getIsdeleted());
|
}
|
if (pageWrap.getModel().getRemark() != null) {
|
queryWrapper.lambda().eq(Retention::getRemark, pageWrap.getModel().getRemark());
|
}
|
if (pageWrap.getModel().getCompanyId() != null) {
|
queryWrapper.lambda().eq(Retention::getCompanyId, pageWrap.getModel().getCompanyId());
|
}
|
if (pageWrap.getModel().getFaceImg() != null) {
|
queryWrapper.lambda().eq(Retention::getFaceImg, pageWrap.getModel().getFaceImg());
|
}
|
if (pageWrap.getModel().getImgurl() != null) {
|
queryWrapper.lambda().eq(Retention::getImgurl, pageWrap.getModel().getImgurl());
|
}
|
if (pageWrap.getModel().getType() != null) {
|
queryWrapper.lambda().eq(Retention::getType, pageWrap.getModel().getType());
|
}
|
if (pageWrap.getModel().getName() != null) {
|
queryWrapper.lambda().eq(Retention::getName, pageWrap.getModel().getName());
|
}
|
if (pageWrap.getModel().getBirthday() != null) {
|
queryWrapper.lambda().ge(Retention::getBirthday, Utils.Date.getStart(pageWrap.getModel().getBirthday()));
|
queryWrapper.lambda().le(Retention::getBirthday, Utils.Date.getEnd(pageWrap.getModel().getBirthday()));
|
}
|
if (pageWrap.getModel().getPhone() != null) {
|
queryWrapper.lambda().eq(Retention::getPhone, pageWrap.getModel().getPhone());
|
}
|
if (pageWrap.getModel().getIdcardNo() != null) {
|
queryWrapper.lambda().eq(Retention::getIdcardNo, pageWrap.getModel().getIdcardNo());
|
}
|
if (pageWrap.getModel().getIdcardDecode() != null) {
|
queryWrapper.lambda().eq(Retention::getIdcardDecode, pageWrap.getModel().getIdcardDecode());
|
}
|
if (pageWrap.getModel().getCode() != null) {
|
queryWrapper.lambda().eq(Retention::getCode, pageWrap.getModel().getCode());
|
}
|
if (pageWrap.getModel().getClasses() != null) {
|
queryWrapper.lambda().eq(Retention::getClasses, pageWrap.getModel().getClasses());
|
}
|
if (pageWrap.getModel().getEventDate() != null) {
|
queryWrapper.lambda().ge(Retention::getEventDate, Utils.Date.getStart(pageWrap.getModel().getEventDate()));
|
queryWrapper.lambda().le(Retention::getEventDate, Utils.Date.getEnd(pageWrap.getModel().getEventDate()));
|
}
|
if (pageWrap.getModel().getMemberId() != null) {
|
queryWrapper.lambda().eq(Retention::getMemberId, pageWrap.getModel().getMemberId());
|
}
|
if (pageWrap.getModel().getEventCode() != null) {
|
queryWrapper.lambda().eq(Retention::getEventCode, pageWrap.getModel().getEventCode());
|
}
|
for(PageWrap.SortData sortData: pageWrap.getSorts()) {
|
if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
|
queryWrapper.orderByDesc(sortData.getProperty());
|
} else {
|
queryWrapper.orderByAsc(sortData.getProperty());
|
}
|
}
|
return PageData.from(retentionMapper.selectPage(page, queryWrapper));
|
}
|
|
@Override
|
public long count(Retention retention) {
|
QueryWrapper<Retention> wrapper = new QueryWrapper<>(retention);
|
return retentionMapper.selectCount(wrapper);
|
}
|
|
@Override
|
public PageData<Retention> findTrainTimePage(PageWrap<Retention> pageWrap) {
|
Random random = new Random();
|
int randomNumber = random.nextInt(999999);
|
String formattedNumber = String.format("%06d", randomNumber);
|
System.out.println(formattedNumber);
|
//是否是数字
|
boolean number = Validator.isNumber(pageWrap.getModel().getKeyWords());
|
//是否包含中文
|
boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords());
|
//是否包含英文
|
boolean hasWord = ReUtil.contains(PatternPool.WORD, pageWrap.getModel().getKeyWords());
|
|
IPage<Retention> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
MPJLambdaWrapper<Retention> queryWrapper = new MPJLambdaWrapper<>();
|
Utils.MP.blankToNull(pageWrap.getModel());
|
queryWrapper.leftJoin(Company.class,Company::getId,Retention::getId);
|
queryWrapper.selectAll(Retention.class)
|
.selectAs(Company::getName,Retention::getCompanyName);
|
queryWrapper.like(number,Retention::getPhone,pageWrap.getModel().getKeyWords())
|
.like((b||hasWord),Retention::getName,pageWrap.getModel().getKeyWords())
|
.eq(Objects.nonNull(pageWrap.getModel().getType()),
|
Retention::getType,
|
pageWrap.getModel().getType())
|
.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),
|
Company::getName,
|
pageWrap.getModel().getCompanyName())
|
.ge(Objects.nonNull(pageWrap.getModel().getStartTime()),
|
Retention::getEventDate,pageWrap.getModel().getStartTime())
|
.le(Objects.nonNull(pageWrap.getModel().getEndTime()),
|
Retention::getEventDate,pageWrap.getModel().getStartTime());
|
queryWrapper.orderByDesc(Retention::getCreateDate);
|
IPage<Retention> retentionIPage = retentionJoinMapper.selectJoinPage(page, Retention.class, queryWrapper);
|
if(null != retentionIPage && retentionIPage.getRecords().size() > 0) {
|
List<String> codes = Arrays.asList(Constants.FTP_RESOURCE_PATH,Constants.MEMBER_IMG);
|
List<SystemDictData> list = systemDictDataMapper.list(codes);
|
Map<String,SystemDictData> dataMap = list.stream().collect(Collectors.toMap(SystemDictData::getLabel, Function.identity()));
|
retentionIPage.getRecords().stream().forEach(obj->{
|
obj.setFaceImg(dataMap.get(Constants.FTP_RESOURCE_PATH).getCode()
|
+dataMap.get(Constants.MEMBER_IMG).getCode()
|
+obj.getFaceImg());
|
});
|
}
|
return PageData.from(retentionIPage);
|
}
|
}
|
