package com.project.system.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import cn.hutool.core.convert.Convert;
|
import com.project.common.utils.StringUtils;
|
import org.springframework.stereotype.Service;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import org.springframework.transaction.annotation.Transactional;
|
import com.project.system.domain.vo.SysCompanyVo;
|
import com.project.system.domain.bo.editBo.SysCompanyBo;
|
import com.project.system.domain.bo.queryBo.SysCompanyQueryBo;
|
import com.project.system.domain.SysCompany;
|
import com.project.system.mapper.SysCompanyMapper;
|
import com.project.system.service.ISysCompanyService;
|
|
import java.util.Collection;
|
import java.util.List;
|
|
/**
|
* 企业信息Service业务层处理
|
*
|
* @author manton
|
*/
|
@Service
|
@RequiredArgsConstructor(onConstructor_ = @Autowired)
|
public class SysCompanyServiceImpl extends ServiceImpl<SysCompanyMapper, SysCompany> implements ISysCompanyService {
|
|
|
|
@Override//列表查询
|
public List<SysCompanyVo> queryList(SysCompanyQueryBo bo)
|
{
|
QueryWrapper<SysCompany> qw = getQw(bo);
|
List<SysCompany> list = this.list(qw);
|
return Convert.toList(SysCompanyVo.class , list);
|
}
|
|
@Override//id查询
|
public SysCompanyVo queryById(Long companyId)
|
{
|
SysCompany db = this.baseMapper.selectById(companyId);
|
return Convert.convert(SysCompanyVo.class , db);
|
}
|
|
|
@Override//添加
|
@Transactional
|
public Boolean insertByBo(SysCompanyBo bo)
|
{
|
SysCompany add = Convert.convert(SysCompany.class, bo);
|
validEntityBeforeSave(add);
|
return this.save(add);
|
}
|
|
@Override//修改
|
@Transactional
|
public Boolean updateByBo(SysCompanyBo bo)
|
{
|
SysCompany update = Convert.convert(SysCompany.class, bo);
|
validEntityBeforeSave(update);
|
return this.updateById(update);
|
}
|
|
@Override//删除
|
@Transactional
|
public Boolean deleteByIds(Collection<Long> ids)
|
{
|
|
//做一些业务上的校验,判断是否需要校验
|
|
return this.removeByIds(ids);
|
}
|
|
|
//-------------------------------------------------------------------------------------
|
|
//保存前校验
|
private void validEntityBeforeSave(SysCompany entity)
|
{
|
//做一些数据校验,如唯一约束
|
}
|
|
//获取查询参数
|
private QueryWrapper<SysCompany> getQw(SysCompanyQueryBo bo)
|
{
|
QueryWrapper<SysCompany> qw = Wrappers.query();
|
|
qw.like(StringUtils.isNotEmpty(bo.getCompanyName()), "company_name", bo.getCompanyName());
|
qw.eq(StringUtils.isNotEmpty(bo.getCompanyCode()), "company_code", bo.getCompanyCode());
|
qw.eq(StringUtils.isNotEmpty(bo.getCompanyUser()), "company_user", bo.getCompanyUser());
|
qw.eq(StringUtils.isNotEmpty(bo.getCompanyPhone()), "company_phone", bo.getCompanyPhone());
|
qw.eq(StringUtils.isNotEmpty(bo.getCompanyAddress()), "company_address", bo.getCompanyAddress());
|
qw.eq(StringUtils.isNotEmpty(bo.getCompanyImg()), "company_img", bo.getCompanyImg());
|
qw.eq(bo.getCompanyStatus() != null, "company_status", bo.getCompanyStatus());
|
qw.eq(StringUtils.isNotEmpty(bo.getRegionCode()), "region_code", bo.getRegionCode());
|
qw.like(StringUtils.isNotEmpty(bo.getRegionName()), "region_name", bo.getRegionName());
|
qw.eq(bo.getCheckStatus() != null, "check_status", bo.getCheckStatus());
|
qw.eq(bo.getSortNum() != null, "sort_num", bo.getSortNum());
|
if (StringUtils.isNotEmpty(bo.getIsAsc()) && StringUtils.isNotEmpty(bo.getOrderByColumn())){
|
if ("acs".equals(bo.getIsAsc())) {
|
qw.orderByAsc(bo.getOrderByColumn());
|
} else if ("desc".equals(bo.getIsAsc())) {
|
qw.orderByDesc(bo.getOrderByColumn());
|
}
|
}
|
return qw;
|
}
|
}
|
