| | |
| | | * @author fengjin |
| | | * @since 2022-09-20 |
| | | */ |
| | | @TableName("area_code_2022") |
| | | @TableName("automessage_area_code_2022") |
| | | @Data |
| | | @ApiModel("所属地区实体类") |
| | | public class AreaCode2022 implements Serializable { |
| | |
| | | public List<AreaCode2022> getListByPCode(String id){ |
| | | List<AreaCode2022> areaCode2022s = baseMapper.selectList(new QueryWrapper<AreaCode2022>().lambda().eq(AreaCode2022::getPcode, id)); |
| | | for (AreaCode2022 areaCode2022:areaCode2022s) { |
| | | if (areaCode2022.getLevel()!=4) |
| | | if (areaCode2022.getLevel()!=3) |
| | | areaCode2022.setChild(this.getListByPCode(areaCode2022.getCode().toString())); |
| | | } |
| | | return areaCode2022s; |
| | |
| | | </resultMap> |
| | | |
| | | <sql id="selectAreaCode"> |
| | | select code,name,level,pcode FROM area_code_2022 |
| | | select code,name,level,pcode FROM automessage_area_code_2022 |
| | | </sql> |
| | | |
| | | <select id="selectByIdSet" resultMap="AreaCodeResult"> |
| | |
| | | city, |
| | | district, |
| | | village, |
| | | (select name from area_code_2022 where city=area_code_2022.code) as cityName, |
| | | (select name from area_code_2022 where district=area_code_2022.code) as districtName, |
| | | (select name from area_code_2022 where village=area_code_2022.code) as villageName, |
| | | (select name from automessage_area_code_2022 where city=automessage_area_code_2022.code) as cityName, |
| | | (select name from automessage_area_code_2022 where district=automessage_area_code_2022.code) as districtName, |
| | | (select name from automessage_area_code_2022 where village=automessage_area_code_2022.code) as villageName, |
| | | detailed_address, |
| | | grade, |
| | | area_list |