场所新增地址编码绑定初始化接口

zhongrj

2024-02-29 ccca3f92e450392072f64f7781e6a25162ca81b0

场所新增地址编码绑定初始化接口

 src/main/java/org/springblade/modules/place/controller/PlaceController.java

@@ -294,4 +294,12 @@
    public R placeGridCodeHandle() {
        return R.data(placeService.placeGridCodeHandle());
    }

    /**
     * 场所二维码绑定处理
     */
    @GetMapping("/placeDoorBindHandle")
    public R placeDoorBindHandle() {
        return R.data(placeService.placeDoorBindHandle());
    }
}

 src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java

@@ -174,4 +174,10 @@
     * @return
     */
    List<PlaceEntity> getPlaceNotGridCode();

    /**
     * 查询对应未的场所 house_code_binds 为空，source = 1 的
     * @return
     */
    List<PlaceEntity> selectPlaceNotDoorBindList();
}

 src/main/java/org/springblade/modules/place/mapper/PlaceMapper.xml

@@ -761,4 +761,10 @@
         and lng != ''
    </select>

    <!--查询对应未的场所 house_code_binds 为空，source = 1 的-->
    <select id="selectPlaceNotDoorBindList" resultType="org.springblade.modules.place.entity.PlaceEntity">
        select * from jczz_place where is_deleted = 0
         and source = 1 and house_code_binds is null
    </select>

</mapper>

 src/main/java/org/springblade/modules/place/service/IPlaceService.java

@@ -170,4 +170,9 @@
     * 场所综治网格处理
     */
    Object placeGridCodeHandle();

    /**
     * 场所二维码绑定处理
     */
    Object placeDoorBindHandle();
}

 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java

@@ -1419,4 +1419,33 @@
        }
        return null;
    }

    /**
     * 场所二维码绑定处理
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Object placeDoorBindHandle() {
        // 查询对应未的场所 house_code_binds 为空，source = 1 的
        List<PlaceEntity> list = baseMapper.selectPlaceNotDoorBindList();
        // 遍历
        for (PlaceEntity placeEntity : list) {
            // 更新
            placeEntity.setHouseCodeBinds(placeEntity.getHouseCode());
            updateById(placeEntity);
            // 查询绑定关系是否已存在
            QueryWrapper<PlaceDoorEntity> wrapper = new QueryWrapper<>();
            wrapper.eq("house_code",placeEntity.getHouseCode()).eq("place_id",placeEntity.getId());
            // 查询
            PlaceDoorEntity one = placeDoorService.getOne(wrapper);
            if (null==one){
                // 新增
                PlaceDoorEntity placeDoorEntity = new PlaceDoorEntity();
                placeDoorEntity.setPlaceId(placeEntity.getId());
                placeDoorEntity.setHouseCode(placeEntity.getHouseCode());
                placeDoorService.save(placeDoorEntity);
            }
        }
        return null;
    }
}

 src/main/resources/application.yml

@@ -239,6 +239,7 @@
      - /blade-topics/topics/lists
      - /blade-household/household/getHouseholdOtherInfo
      - /blade-resource/oss/endpoint/put-file
      - /blade-resource/oss/endpoint/put-file-attach-by-prefix-path
      - /blade-hiddenDangerRecord/**
#      - /blade-doorplateAddress/doorplateAddress/**
#      - /blade-house/house/**