package com.doumee.service.business.impl;
|
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import com.doumee.core.model.PageData;
|
import com.doumee.core.model.PageWrap;
|
import com.doumee.core.utils.Utils;
|
import com.doumee.dao.business.TrainTimeMapper;
|
import com.doumee.dao.business.join.TrainTimeJoinMapper;
|
import com.doumee.dao.business.model.Company;
|
import com.doumee.dao.business.model.Member;
|
import com.doumee.dao.business.model.TrainTime;
|
import com.doumee.dao.business.model.Visits;
|
import com.doumee.dao.system.model.SystemUser;
|
import com.doumee.service.business.TrainTimeService;
|
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.List;
|
|
/**
|
* 人员培训有效期记录Service实现
|
* @author 江蹄蹄
|
* @date 2023/11/30 15:33
|
*/
|
@Service
|
public class TrainTimeServiceImpl implements TrainTimeService {
|
|
@Autowired
|
private TrainTimeMapper trainTimeMapper;
|
@Autowired
|
private TrainTimeJoinMapper trainTimeJoinMapper;
|
|
|
|
|
@Override
|
public Integer create(TrainTime trainTime) {
|
trainTimeMapper.insert(trainTime);
|
return trainTime.getId();
|
}
|
|
@Override
|
public void deleteById(Integer id) {
|
trainTimeMapper.deleteById(id);
|
}
|
|
@Override
|
public void delete(TrainTime trainTime) {
|
UpdateWrapper<TrainTime> deleteWrapper = new UpdateWrapper<>(trainTime);
|
trainTimeMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<Integer> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
trainTimeMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(TrainTime trainTime) {
|
trainTimeMapper.updateById(trainTime);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<TrainTime> trainTimes) {
|
if (CollectionUtils.isEmpty(trainTimes)) {
|
return;
|
}
|
for (TrainTime trainTime: trainTimes) {
|
this.updateById(trainTime);
|
}
|
}
|
|
@Override
|
public TrainTime findById(Integer id) {
|
return trainTimeMapper.selectById(id);
|
}
|
|
@Override
|
public TrainTime findOne(TrainTime trainTime) {
|
QueryWrapper<TrainTime> wrapper = new QueryWrapper<>(trainTime);
|
return trainTimeMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<TrainTime> findList(TrainTime trainTime) {
|
QueryWrapper<TrainTime> wrapper = new QueryWrapper<>(trainTime);
|
return trainTimeMapper.selectList(wrapper);
|
}
|
|
@Override
|
public PageData<TrainTime> findPage(PageWrap<TrainTime> pageWrap) {
|
IPage<TrainTime> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
MPJLambdaWrapper<TrainTime> queryWrapper = new MPJLambdaWrapper<>();
|
|
queryWrapper.leftJoin(Member.class,Member::getId,TrainTime::getMemberId);
|
queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
|
queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,TrainTime::getCreator);
|
|
queryWrapper.selectAll(TrainTime.class);
|
queryWrapper.selectAs(Member::getName,TrainTime::getName);
|
queryWrapper.selectAs(Member::getPhone,TrainTime::getPhone);
|
queryWrapper.selectAs(Member::getIdcardNo,TrainTime::getIdcardNo);
|
queryWrapper.selectAs(Company::getName,TrainTime::getCompanyName);
|
queryWrapper.selectAs(SystemUser::getUsername,TrainTime::getCreateName);
|
|
queryWrapper.eq(TrainTime::getIsdeleted, Constants.ZERO);
|
queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()), ms->ms.like(Member::getPhone,pageWrap.getModel().getName())
|
.or().like(Member::getName,pageWrap.getModel().getName()));
|
queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getName,pageWrap.getModel().getCompanyName());
|
queryWrapper.orderByDesc(TrainTime::getCreateDate);
|
IPage<TrainTime> result = trainTimeJoinMapper.selectJoinPage(page, TrainTime.class,queryWrapper);
|
return PageData.from(result);
|
}
|
|
@Override
|
public long count(TrainTime trainTime) {
|
QueryWrapper<TrainTime> wrapper = new QueryWrapper<>(trainTime);
|
return trainTimeMapper.selectCount(wrapper);
|
}
|
|
|
}
|
