package com.doumee.service.business.impl; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.LoginUserInfo; 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.business.YwAccountMapper; import com.doumee.dao.business.dao.CompanyMapper; import com.doumee.dao.business.model.Company; import com.doumee.dao.business.model.YwAccount; import com.doumee.dao.business.model.YwProject; import com.doumee.service.business.YwAccountService; 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.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 江蹄蹄 * @date 2024/11/19 18:09 */ @Service public class YwAccountServiceImpl implements YwAccountService { @Autowired private YwAccountMapper ywAccountMapper; @Autowired private CompanyMapper companyMapper; @Override public Integer create(YwAccount model) { if(model.getCompanyId()==null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的公司信息"); } Company ywProject = companyMapper.selectById(model.getCompanyId()); if(ywProject ==null || Constants.equalsInteger(ywProject.getIsdeleted(),Constants.ONE) || !Constants.equalsInteger(ywProject.getType(),Constants.TWO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的公司信息!"); } model.setCreator(model.getLoginUserInfo().getId()); model.setIsdeleted(Constants.ZERO); model.setCreateDate(new Date()); model.setStatus(Constants.ZERO); model.setEditDate(model.getCreateDate()); model.setEditor(model.getCreator()); ywAccountMapper.insert(model); return model.getId(); } @Override public void deleteById(Integer id, LoginUserInfo user) { YwAccount model = new YwAccount(); model.setId(id); model.setIsdeleted(Constants.ONE); model.setEditDate(model.getCreateDate()); model.setEditor(model.getCreator()); ywAccountMapper.updateById(model); } @Override public void delete(YwAccount ywAccount) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(ywAccount); ywAccountMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids, LoginUserInfo user) { if (CollectionUtils.isEmpty(ids)) { return; } for(Integer id : ids){ this.deleteById(id,user); } } @Override public void updateById(YwAccount model) { if(model.getCompanyId()==null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的公司信息"); } Company ywProject = companyMapper.selectById(model.getCompanyId()); if(ywProject ==null || Constants.equalsInteger(ywProject.getIsdeleted(),Constants.ONE) || !Constants.equalsInteger(ywProject.getType(),Constants.TWO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的公司信息!"); } model.setEditDate(model.getCreateDate()); model.setEditor(model.getCreator()); ywAccountMapper.updateById(model); } @Override public void updateByIdInBatch(List ywAccounts) { if (CollectionUtils.isEmpty(ywAccounts)) { return; } for (YwAccount ywAccount: ywAccounts) { this.updateById(ywAccount); } } @Override public YwAccount findById(Integer id) { return ywAccountMapper.selectById(id); } @Override public YwAccount findOne(YwAccount ywAccount) { QueryWrapper wrapper = new QueryWrapper<>(ywAccount); return ywAccountMapper.selectOne(wrapper); } @Override public List findList(YwAccount ywAccount) { QueryWrapper wrapper = new QueryWrapper<>(ywAccount); return ywAccountMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(YwAccount.class) .selectAs(Company::getName,YwAccount::getCompanyName) .leftJoin(Company.class,Company::getId,YwAccount::getCompanyId); pageWrap.getModel().setIsdeleted(Constants.ZERO); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(YwAccount::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(YwAccount::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(YwAccount::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(YwAccount::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(YwAccount::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(YwAccount::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(YwAccount::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(YwAccount::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(YwAccount::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(YwAccount::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getTitle() != null) { queryWrapper.like(YwAccount::getTitle, pageWrap.getModel().getTitle()); } if (pageWrap.getModel().getCompanyId() != null) { queryWrapper.eq(YwAccount::getCompanyId, pageWrap.getModel().getCompanyId()); } if (pageWrap.getModel().getType() != null) { queryWrapper.eq(YwAccount::getType, pageWrap.getModel().getType()); } if (pageWrap.getModel().getName() != null) { queryWrapper.eq(YwAccount::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getBankName() != null) { queryWrapper.eq(YwAccount::getBankName, pageWrap.getModel().getBankName()); } if (pageWrap.getModel().getBankNo() != null) { queryWrapper.eq(YwAccount::getBankNo, pageWrap.getModel().getBankNo()); } if (pageWrap.getModel().getBankAddr() != null) { queryWrapper.eq(YwAccount::getBankAddr, pageWrap.getModel().getBankAddr()); } for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } return PageData.from(ywAccountMapper.selectPage(page, queryWrapper)); } @Override public long count(YwAccount ywAccount) { QueryWrapper wrapper = new QueryWrapper<>(ywAccount); return ywAccountMapper.selectCount(wrapper); } }