修改导入高龄人口表报错

lidongdong

2023-08-02 c6c983fbe99024ef7c32d222a39724447abea082

修改导入高龄人口表报错

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

@@ -81,6 +81,9 @@
        + "</script>")
    List<ComMngPopulationVO> listPopulation(ComMngPopulationDTO populationVO);


    List<ComMngPopulationDO> selectListIds();

    @Select("select id,user_id,relationship,`name`,id_card,phone,age,health,job,create_at,update_at,card_photo_front,card_photo_back,family_book from com_mng_family_info where user_id=#{userId} order by create_at desc ")
    List<ComMngFamilyInfoVO> listFamilyByUserId(Long userId);


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

@@ -243,7 +243,8 @@
        List<ComElderAuthRecordImportMistakeExcelVO> mistakes = new ArrayList<>();
        try {
            // 查询所有人口数据放入HashMap中
            List<ComMngPopulationDO> populationList = comMngPopulationDAO.selectList(null);
//            List<ComMngPopulationDO> populationList = comMngPopulationDAO.selectList(null);
            List<ComMngPopulationDO> populationList = comMngPopulationDAO.selectListIds();
            HashMap<String, Object> populationMap = new HashMap<>();
            populationList.forEach(population -> {
                String key = population.getCardNo();

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml

@@ -274,6 +274,10 @@
        select t.village_id as villageId,concat(t.alley,t.house_num,'号') as villageName,t1.id,concat(t1.unit_no,'栋') as name  from com_mng_village t left join com_mng_population_house t1  on t.village_id = t1.village_id where t.community_id = ${communityId} GROUP BY t.village_id,t1.unit_no
    </select>

    <select id="selectListIds" resultType="com.panzhihua.service_community.model.dos.ComMngPopulationDO">
        SELECT id,name,card_no FROM com_mng_population
    </select>



    <delete id="deletePopulaitonRelation">