package com.project.system.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.project.common.exception.base.BaseException;
|
import com.project.common.utils.StringUtils;
|
import com.project.common.utils.TreeManager;
|
import com.project.system.domain.bo.queryBo.RegionQueryBo;
|
import com.project.system.domain.vo.RegionVO;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.project.system.domain.SysRegion;
|
import com.project.system.mapper.SysRegionMapper;
|
import com.project.system.service.ISysRegionService;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.List;
|
|
/**
|
* 行政区划Service业务层处理
|
*
|
* @author manton
|
* @date 2023-04-13
|
*/
|
@Service
|
@RequiredArgsConstructor(onConstructor_ = @Autowired)
|
public class SysRegionServiceImpl extends ServiceImpl<SysRegionMapper, SysRegion> implements ISysRegionService {
|
|
|
@Override
|
public String regionCode(String parentId)
|
{
|
String maxCode = baseMapper.regionCode(parentId);
|
if (StringUtils.isNotEmpty(maxCode)){
|
int i = Integer.parseInt(maxCode) + 1;
|
return String.valueOf(i);
|
} else {
|
return parentId+"01";
|
}
|
}
|
|
@Override
|
public List<RegionVO> regionTree(String parentCode, String name)
|
{
|
List<RegionVO> voList = baseMapper.regionTree(parentCode, name);
|
return TreeManager.merge(voList);
|
}
|
|
@Override
|
public List<SysRegion> queryList(RegionQueryBo dto)
|
{
|
QueryWrapper<SysRegion> qw = getqw(dto);
|
return this.list(qw);
|
}
|
|
@Override
|
@Transactional
|
public Boolean addRegion(SysRegion region)
|
{
|
validEntityBeforeSave(region);
|
return this.save(region);
|
}
|
|
@Override
|
@Transactional
|
public Boolean updRegion(SysRegion region)
|
{
|
validEntityBeforeSave(region);
|
return this.updateById(region);
|
}
|
|
@Override
|
@Transactional
|
public Boolean deleteByIds(List<String> codes)
|
{
|
return this.removeByIds(codes);
|
}
|
|
|
//-------------------------------------------------------------------------------------
|
|
//保存前校验
|
private void validEntityBeforeSave(SysRegion entity)
|
{
|
|
if (StringUtils.isEmpty(entity.getParentCode())){
|
throw new BaseException("参数有误，编号不可为空");
|
}
|
if (StringUtils.isEmpty(entity.getParentCode())){
|
//新增判断父级下名字是否重复
|
if (this.count(lq().eq(SysRegion::getName,entity.getName()).eq(SysRegion::getParentCode,entity.getCode()))>0){
|
throw new BaseException("参数有误，该"+entity.getParentCode()+"编码下已存在"+entity.getName());
|
}
|
//设置编码
|
String regionCode = this.regionCode(entity.getParentCode());
|
entity.setCode(regionCode);
|
}
|
|
}
|
|
//获取查询参数
|
private QueryWrapper<SysRegion> getqw(RegionQueryBo dto)
|
{
|
QueryWrapper<SysRegion> qw = Wrappers.query();
|
|
qw.eq(StringUtils.isNotEmpty(dto.getParentCode()), "parentCode", dto.getParentCode());
|
qw.eq(StringUtils.isNotEmpty(dto.getAncestors()), "ancestors", dto.getAncestors());
|
qw.like(StringUtils.isNotEmpty(dto.getName()), "name", dto.getName());
|
qw.eq(StringUtils.isNotEmpty(dto.getProvinceCode()), "provinceCode", dto.getProvinceCode());
|
qw.like(StringUtils.isNotEmpty(dto.getProvinceName()), "provinceName", dto.getProvinceName());
|
qw.eq(StringUtils.isNotEmpty(dto.getCityCode()), "cityCode", dto.getCityCode());
|
qw.like(StringUtils.isNotEmpty(dto.getCityName()), "cityName", dto.getCityName());
|
qw.eq(StringUtils.isNotEmpty(dto.getDistrictCode()), "districtCode", dto.getDistrictCode());
|
qw.like(StringUtils.isNotEmpty(dto.getDistrictName()), "districtName", dto.getDistrictName());
|
qw.eq(StringUtils.isNotEmpty(dto.getTownCode()), "townCode", dto.getTownCode());
|
qw.like(StringUtils.isNotEmpty(dto.getTownName()), "townName", dto.getTownName());
|
qw.eq(StringUtils.isNotEmpty(dto.getVillageCode()), "villageCode", dto.getVillageCode());
|
qw.like(StringUtils.isNotEmpty(dto.getVillageName()), "villageName", dto.getVillageName());
|
qw.eq(dto.getRegionLevel() != null, "regionLevel", dto.getRegionLevel());
|
|
if (StringUtils.isNotEmpty(dto.getIsAsc()) && StringUtils.isNotEmpty(dto.getOrderByColumn())){
|
if ("acs".equals(dto.getIsAsc())) {
|
qw.orderByAsc(dto.getOrderByColumn());
|
} else if ("desc".equals(dto.getIsAsc())) {
|
qw.orderByDesc(dto.getOrderByColumn());
|
}
|
}
|
qw.orderByAsc( "sort");
|
|
|
|
return qw;
|
}
|
|
|
}
|
