lin
2024-03-18 2482d916fb1322eb814a03f7ef27fff0c20e77e5
地址总表详情查询添加房屋标签
7 files modified
105 ■■■■ changed files
src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java 36 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java 4 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/task/controller/TaskPlaceSelfCheckController.java 11 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/task/mapper/TaskPlaceSelfCheckMapper.java 7 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/task/mapper/TaskPlaceSelfCheckMapper.xml 34 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/task/service/ITaskPlaceSelfCheckService.java 8 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/task/service/impl/TaskPlaceSelfCheckServiceImpl.java 5 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
@@ -27,6 +27,7 @@
import org.springblade.common.param.CommonParamSet;
import org.springblade.common.utils.ComplexNumberStringComparator;
import org.springblade.common.utils.NodeTreeUtil;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.category.dto.CategoryDTO;
import org.springblade.modules.category.service.ICategoryService;
@@ -45,9 +46,11 @@
import org.springblade.modules.grid.service.IGridService;
import org.springblade.modules.grid.service.IGridmanService;
import org.springblade.modules.house.entity.HouseEntity;
import org.springblade.modules.house.entity.UserHouseLabelEntity;
import org.springblade.modules.house.service.IHouseRentalService;
import org.springblade.modules.house.service.IHouseService;
import org.springblade.modules.house.service.IHouseholdService;
import org.springblade.modules.house.service.IUserHouseLabelService;
import org.springblade.modules.house.vo.HouseParam;
import org.springblade.modules.house.vo.HouseRentalVO;
import org.springblade.modules.house.vo.HouseholdVO;
@@ -581,6 +584,7 @@
    /**
     * 判断是否包含数字
     *
     * @param str
     * @return
     */
@@ -592,6 +596,7 @@
    /**
     * 取出字符串中的数字
     *
     * @param str
     * @return
     */
@@ -899,6 +904,7 @@
    /**
     * 新增场所详情
     *
     * @param placeEntity
     */
    public void savePlaceExtAndTaskInfo(PlaceEntity placeEntity) {
@@ -929,10 +935,10 @@
    public Object getDetail(DoorplateAddressVO doorplateAddress) {
        List<String> list = new ArrayList<>();
        // 扫码时调用,需判断是否有权限查看
        DoorplateAddressVO one = baseMapper.getDoorplateAddressVODetail(doorplateAddress);
        if (null != one) {
        DoorplateAddressVO doorplateAddressVO = baseMapper.getDoorplateAddressVODetail(doorplateAddress);
        if (null != doorplateAddressVO) {
            // 不限制
            one.setIsJur(1);
            doorplateAddressVO.setIsJur(1);
            if (!Strings.isBlank(doorplateAddress.getRoleName())) {
                // 判断是否有权限
                if (doorplateAddress.getRoleName().equals("网格员")) {
@@ -940,27 +946,35 @@
                    boolean contains = list.contains(doorplateAddress.getAddressCode());
                    if (list.size() == 0 || !contains) {
                        // 无权限
                        one.setIsJur(2);
                        doorplateAddressVO.setIsJur(2);
                    } else {
                        one.setIsJur(1);
                        doorplateAddressVO.setIsJur(1);
                    }
                } else if (doorplateAddress.getRoleName().equals("民警")) {
                    // 无权限
                    one.setIsJur(2);
                    doorplateAddressVO.setIsJur(2);
                    // 查询对应的社区code
                    list = policeAffairsGridService.getCommunityCodeListByUserId(AuthUtil.getUserId());
                    if (null!=list && list.size()>0){
                        boolean contains = list.contains(one.getNeiCode());
                        boolean contains = list.contains(doorplateAddressVO.getNeiCode());
                        if (contains) {
                            one.setIsJur(1);
                            doorplateAddressVO.setIsJur(1);
                        }
                    }
                } else {
                    // 不限制
                    one.setIsJur(1);
                    doorplateAddressVO.setIsJur(1);
                }
            }
            return one;
            if(doorplateAddressVO != null ){
                //  获取房屋标签
                IUserHouseLabelService userHouseLabelService = SpringUtils.getBean(IUserHouseLabelService.class);
                List<UserHouseLabelEntity> houseLabelEntityList = userHouseLabelService.list(Wrappers.<UserHouseLabelEntity>lambdaQuery()
                    .eq(UserHouseLabelEntity::getHouseCode, doorplateAddressVO.getAddressCode())
                    .eq(UserHouseLabelEntity::getLableType, 2));
                doorplateAddressVO.setUserHouseLabelVOList(houseLabelEntityList);
            }
            return doorplateAddressVO;
        }
        return null;
    }
@@ -996,6 +1010,7 @@
    /**
     * 查询场所标准地址数据
     *
     * @param doorplateAddress
     * @param size
     * @return
@@ -1014,6 +1029,7 @@
    /**
     * 通过小区id 查询楼栋编码
     *
     * @param districtId
     * @return
     */
src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java
@@ -3,9 +3,9 @@
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.house.entity.UserHouseLabelEntity;
import org.springblade.modules.house.vo.HouseRentalVO;
import org.springblade.modules.house.vo.HouseholdVO;
import org.springblade.modules.place.entity.PlaceEntity;
import org.springblade.modules.place.vo.PlaceVO;
import java.util.ArrayList;
@@ -26,6 +26,8 @@
    private List<HouseholdVO> householdList = new ArrayList<>();
    private List<UserHouseLabelEntity> userHouseLabelVOList = new ArrayList<>();
    private PlaceVO place;
    //对应address_code
src/main/java/org/springblade/modules/task/controller/TaskPlaceSelfCheckController.java
@@ -80,6 +80,17 @@
        TaskPlaceSelfCheckEntity detail = taskPlaceSelfCheckService.getOne(Condition.getQueryWrapper(taskPlaceSelfCheck));
        return R.data(TaskPlaceSelfCheckWrapper.build().entityVO(detail));
    }
    /**
     * 消防自查记任务表 自定义详情
     */
    @GetMapping("/detailByTaskId")
    @ApiOperationSupport(order = 1)
    @ApiOperation(value = "自定义详情", notes = "传入taskPlaceSelfCheck")
    public R<TaskPlaceSelfCheckVO> detailByTaskId(Long taskId) {
        TaskPlaceSelfCheckEntity detail = taskPlaceSelfCheckService.getDetailByTaskId( taskId);
        return R.data(TaskPlaceSelfCheckWrapper.build().entityVO(detail));
    }
    /**
     * 消防自查记任务表 分页
     */
src/main/java/org/springblade/modules/task/mapper/TaskPlaceSelfCheckMapper.java
@@ -79,4 +79,11 @@
                                                           @Param("gridCodeList") List<String> gridCodeList);
    Integer getCount(String neiCode, int i,Long userId);
    /**
     * 消防自查详情查询
     * @param taskId
     * @return
     */
    TaskPlaceSelfCheckEntity getDetailByTaskId(Long taskId);
}
src/main/java/org/springblade/modules/task/mapper/TaskPlaceSelfCheckMapper.xml
@@ -489,8 +489,40 @@
        SELECT count(1)
        FROM jczz_task_place_self_check jtpsc
                 LEFT JOIN jczz_place jp ON jp.house_code = jtpsc.house_code
                 LEFT JOIN jczz_grid jg on jg.grid_code=jp.grid_code
        WHERE jp.jw_grid_code IN
              (SELECT jpag.jw_grid_code FROM jczz_police_affairs_grid jpag WHERE jpag.police_user_id like concat('%',${userId},'%') )
              (SELECT jpag.jw_grid_code FROM jczz_police_affairs_grid jpag WHERE jpag.police_user_id like concat('%',#{userId},'%') )
          AND jtpsc.`status` = 1
          AND jg.community_code=#{neiCode}
    </select>
    <select id="getDetailByTaskId" resultType="org.springblade.modules.task.entity.TaskPlaceSelfCheckEntity">
            SELECT
                jtpsc.*,
                jp.id jpid,
                jp.place_name,
                jp.location,
                jg.grid_name,
                jp.principal,
                jp.principal_phone,
                br.town_name,
                br.village_name,
                bu.`name`,
                jpe.legal_tel,
                jpe.legal_person,
                jt.remark reasonFailure,
                jda.address_name
            FROM
                    jczz_task_place_self_check jtpsc
                    LEFT JOIN jczz_task jt on jt.id = jtpsc.task_id
                    LEFT JOIN jczz_place jp ON jtpsc.house_code = jp.house_code
                    LEFT JOIN jczz_grid jg ON jg.grid_code = jp.grid_code
                    LEFT JOIN blade_region br ON br.`code` = jg.community_code
                    LEFT JOIN jczz_place_ext jpe ON jpe.place_id = jp.id
                    LEFT JOIN blade_user bu ON bu.id = jtpsc.create_user
                    LEFT JOIN jczz_doorplate_address jda on jda.address_code=jtpsc.house_code
            WHERE jtpsc.task_id = #{taskId}
    </select>
</mapper>
src/main/java/org/springblade/modules/task/service/ITaskPlaceSelfCheckService.java
@@ -16,6 +16,7 @@
 */
package org.springblade.modules.task.service;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.IService;
import org.springblade.modules.task.dto.TaskPlaceSelfCheckDTO;
import org.springblade.modules.task.entity.TaskPlaceSelfCheckEntity;
@@ -70,4 +71,11 @@
    List<TaskPlaceSelfCheckExcel> exportTaskPlaceSelfCheck(TaskPlaceSelfCheckVO taskPlaceSelfCheck);
    Integer getCount(String neiCode, int i);
    /**
     *
     * @param taskId
     * @return
     */
    TaskPlaceSelfCheckEntity getDetailByTaskId(Long taskId);
}
src/main/java/org/springblade/modules/task/service/impl/TaskPlaceSelfCheckServiceImpl.java
@@ -251,4 +251,9 @@
        }
        return 0;
    }
    @Override
    public TaskPlaceSelfCheckEntity getDetailByTaskId(Long taskId) {
        return baseMapper.getDetailByTaskId( taskId);
    }
}