添加省市区接口

Null

2021-03-21 5adf6fa9e6c3ade88bcbdc4e9aab3f286a669b7c

添加省市区接口

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngCityVO.java

New file
@@ -0,0 +1,19 @@
package com.panzhihua.common.model.vos.community;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ApiModel("城市")
public class ComMngCityVO {

    /**城市名称*/
    @ApiModelProperty("城市名称")
    private String cityName;

    /**城市行政区划代码*/
    @ApiModelProperty("城市行政区划代码")
    private Integer cityAdcode;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngDistrictVO.java

New file
@@ -0,0 +1,17 @@
package com.panzhihua.common.model.vos.community;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ApiModel("区县")
public class ComMngDistrictVO {

    @ApiModelProperty("区县名称")
    private String districtName;

    @ApiModelProperty("区县行政区划代码")
    private Integer districtAdcode;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngProvinceVO.java

New file
@@ -0,0 +1,16 @@
package com.panzhihua.common.model.vos.community;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ApiModel("省份")
public class ComMngProvinceVO {

    @ApiModelProperty("省份名称")
    private String provinceName;

    @ApiModelProperty("省份行政区划代码")
    private Integer provinceAdcode;
}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java

@@ -1272,4 +1272,27 @@
     */
    @PostMapping("/common/data/assets/export")
    R exportRealAssets(ExportRealAssetsExcelDTO exportRealAssetsExcelDTO);

    /**
     * 查询所有省份
     * @return
     */
    @GetMapping("/common/data/province")
    R getProvince();

    /**
     * 查询省份下所有的城市
     * @param provinceAdcode
     * @return
     */
    @GetMapping("/common/data/city")
    R getCityByProvinceCode(@RequestParam(value = "provinceAdcode") Integer provinceAdcode);

    /**
     * 查询城市下所有的区县
     * @param cityAdcode
     * @return
     */
    @GetMapping("/common/data/district")
    R getDistrictByCityCode(@RequestParam(value = "cityAdcode") Integer cityAdcode);
}

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommonDataApi.java

@@ -28,6 +28,7 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.validation.annotation.Validated;
@@ -631,4 +632,36 @@
        }
        return R.fail("未查询到用户");
    }

    /**
     * 查询所有省份
     * @return
     */
    @ApiOperation(value = "查询所有省份" ,response = ComMngProvinceVO.class)
    @GetMapping("/province")
    public R getProvince() {
        return communityService.getProvince();
    }

    /**
     * 查询省份下所有的城市
     * @param provinceAdcode
     * @return
     */
    @ApiOperation(value = "查询省份下所有的城市" ,response = ComMngCityVO.class)
    @GetMapping("/city")
    public R getCityByProvinceCode(@ApiParam(name = "省份编码", required = true) @RequestParam(value = "provinceAdcode") Integer provinceAdcode){
        return communityService.getCityByProvinceCode(provinceAdcode);
    }

    /**
     * 查询城市下所有的区县
     * @param cityAdcode
     * @return
     */
    @ApiOperation(value = "查询城市下所有的区县" ,response = ComMngDistrictVO.class)
    @GetMapping("/district")
    R getDistrictByCityCode(@ApiParam(name = "城市编码", required = true) @RequestParam(value = "cityAdcode") Integer cityAdcode){
        return communityService.getDistrictByCityCode(cityAdcode);
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommonDataApi.java

@@ -4,6 +4,7 @@
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.*;
import com.panzhihua.service_community.service.ComMngCarService;
import com.panzhihua.service_community.service.ComMngProvinceService;
import com.panzhihua.service_community.service.ComMngRealAssetsService;
import com.panzhihua.service_community.service.ComMngRealCompanyService;
import lombok.extern.slf4j.Slf4j;
@@ -30,6 +31,9 @@

    @Resource
    private ComMngRealAssetsService comMngRealAssetsService;

    @Resource
    private ComMngProvinceService comMngProvinceService;

    /**
     * 小程序用户车辆登记
@@ -203,4 +207,33 @@
    public R exportRealAssetsExcel(@RequestBody ExportRealAssetsExcelDTO exportRealAssetsExcelDTO ){
        return comMngRealAssetsService.exportRealAssetsExcel(exportRealAssetsExcelDTO);
    }

    /**
     * 查询所有省份
     * @return
     */
    @GetMapping("/province")
    public R getProvince() {
        return comMngProvinceService.getProvince();
    }

    /**
     * 查询省份下所有的城市
     * @param provinceAdcode
     * @return
     */
    @GetMapping("/city")
    public R getCityByProvinceCode(@RequestParam(value = "provinceAdcode") Integer provinceAdcode){
        return comMngProvinceService.getCityByProvinceCode(provinceAdcode);
    }

    /**
     * 查询城市下所有的区县
     * @param cityAdcode
     * @return
     */
    @GetMapping("/district")
    R getDistrictByCityCode(@RequestParam(value = "cityAdcode") Integer cityAdcode){
        return comMngProvinceService.getDistrictByCityCode(cityAdcode);
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCityDAO.java

New file
@@ -0,0 +1,15 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.model.dos.ComMngCityDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * @description: 城市
 * @author: Null
 * @date: 2021/3/20 23:32
 */
@Mapper
public interface ComMngCityDAO extends BaseMapper<ComMngCityDO> {
    
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngDistrictDAO.java

New file
@@ -0,0 +1,15 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.model.dos.ComMngDistrictDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * @description: 区县
 * @author: Null
 * @date: 2021/3/20 23:32
 */
@Mapper
public interface ComMngDistrictDAO extends BaseMapper<ComMngDistrictDO> {
    
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngProvinceDAO.java

New file
@@ -0,0 +1,15 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.model.dos.ComMngProvinceDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * @description: 省份
 * @author: Null
 * @date: 2021/3/20 23:32
 */
@Mapper
public interface ComMngProvinceDAO extends BaseMapper<ComMngProvinceDO> {

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComMngCityDO.java

New file
@@ -0,0 +1,26 @@
package com.panzhihua.service_community.model.dos;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName(value = "com_mng_struct_area_city")
public class ComMngCityDO {
    /**自增 id*/
    @TableId(type = IdType.AUTO)
    private Integer id;

    /**城市名称*/
    private String cityName;

    /**城市行政区划代码*/
    private Integer cityAdcode;

    /**省份行政区划代码*/
    private Integer provinceAdcode;

    /**省份 id*/
    private Integer provinceId;
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComMngDistrictDO.java

New file
@@ -0,0 +1,36 @@
package com.panzhihua.service_community.model.dos;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

@Data
@TableName(value = "com_mng_struct_area_district")
public class ComMngDistrictDO {
    /**自增 id*/
    @TableId(type = IdType.AUTO)
    private Integer id;

    /**区县名称*/
    private String districtName;

    /**区县行政区划代码*/
    private Integer districtAdcode;

    /**城市行政区划代码*/
    private Integer cityAdcode;

    /**城市 id*/
    private Integer cityId;

    /**省份行政区划代码*/
    private Integer provinceAdcode;

    /**省份 id*/
    private Integer provinceId;
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComMngProvinceDO.java

New file
@@ -0,0 +1,20 @@
package com.panzhihua.service_community.model.dos;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName(value = "com_mng_struct_area_province")
public class ComMngProvinceDO {
    /**自增 id*/
    @TableId(type = IdType.AUTO)
    private Integer id;

    /**省份名称*/
    private String provinceName;

    /**省份行政区划代码*/
    private Integer provinceAdcode;
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComMngProvinceService.java

New file
@@ -0,0 +1,32 @@
package com.panzhihua.service_community.service;

import com.panzhihua.common.model.dtos.community.ComMngCarAppletDTO;
import com.panzhihua.common.model.vos.R;

/**
 * @description: 行政区域接口
 * @author: Null
 * @date: 2021/3/20 23:37
 */
public interface ComMngProvinceService {

    /**
     * 查询所有省份
     * @return
     */
    R getProvince();

    /**
     * 查询省份下所有的城市
     * @param provinceAdcode
     * @return
     */
    R getCityByProvinceCode(Integer provinceAdcode);

    /**
     * 查询城市下所有的区县
     * @param cityAdcode
     * @return
     */
    R getDistrictByCityCode(Integer cityAdcode);
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngProvinceServiceImpl.java

New file
@@ -0,0 +1,70 @@
package com.panzhihua.service_community.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComMngCityVO;
import com.panzhihua.common.model.vos.community.ComMngDistrictVO;
import com.panzhihua.common.model.vos.community.ComMngProvinceVO;
import com.panzhihua.service_community.dao.ComMngCityDAO;
import com.panzhihua.service_community.dao.ComMngDistrictDAO;
import com.panzhihua.service_community.dao.ComMngProvinceDAO;
import com.panzhihua.service_community.model.dos.ComMngCityDO;
import com.panzhihua.service_community.model.dos.ComMngDistrictDO;
import com.panzhihua.service_community.model.dos.ComMngProvinceDO;
import com.panzhihua.service_community.service.ComMngProvinceService;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;

@Service
public class ComMngProvinceServiceImpl implements ComMngProvinceService {

    @Resource
    private ComMngProvinceDAO comMngProvinceDAO;

    @Resource
    private ComMngCityDAO comMngCityDAO;

    @Resource
    private ComMngDistrictDAO comMngDistrictDAO;


    @Override
    public R getProvince() {
        List<ComMngProvinceDO> provinceDOS = comMngProvinceDAO.selectList(null);
        List<ComMngProvinceVO> vos = new ArrayList<>();
        provinceDOS.forEach(p->{
            ComMngProvinceVO vo = new ComMngProvinceVO();
            BeanUtils.copyProperties(p,vo);
            vos.add(vo);
        });
        return R.ok(vos);
    }

    @Override
    public R getCityByProvinceCode(Integer provinceAdcode) {
        List<ComMngCityDO> comMngCityDOS = comMngCityDAO.selectList(new QueryWrapper<ComMngCityDO>().lambda().eq(ComMngCityDO::getProvinceAdcode,provinceAdcode));
        List<ComMngCityVO> vos = new ArrayList<>();
        comMngCityDOS.forEach(c->{
            ComMngCityVO vo = new ComMngCityVO();
            BeanUtils.copyProperties(c,vo);
            vos.add(vo);
        });
        return R.ok(vos);
    }

    @Override
    public R getDistrictByCityCode(Integer cityAdcode) {
        List<ComMngDistrictDO> comMngDistrictDOS = comMngDistrictDAO.selectList(new QueryWrapper<ComMngDistrictDO>().lambda().eq(ComMngDistrictDO::getCityAdcode,cityAdcode));
        List<ComMngDistrictVO> vos = new ArrayList<>();
        comMngDistrictDOS.forEach(c->{
            ComMngDistrictVO vo = new ComMngDistrictVO();
            BeanUtils.copyProperties(c,vo);
            vos.add(vo);
        });
        return R.ok(vos);
    }
}