bug修复

huanghongfa

2021-10-09 3ffc9b04fa6dcd016283e894d74dd4c9522b3864

bug修复

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

@@ -5,6 +5,8 @@
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * title: ComElderAuthElderliesDAO  社区政务》高龄老人认证》高龄老人表mapper类
 * projectName 成都呐喊信息技术有限公司-智慧社区项目
@@ -24,4 +26,10 @@
     * @param isAlive   健在状态（1.健在 0.未健在）
     */
    void editEditIsAlive(@Param("populationId") Long populationId,@Param("isAlive") Integer isAlive);

    /**
     * 高龄认证定时任务查询高龄老人信息
     * @return  高龄老人信息列表
     */
    List<ComElderAuthElderliesDO> getAuthElderLiesList();
}

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

@@ -27,4 +27,10 @@
     * @param isAlive   健在状态（1.健在 0.未健在）
     */
    void editPensionIsAlive(@Param("populationId") Long populationId,@Param("isAlive") Integer isAlive);

    /**
     * 养老认证定时任务查询养老人员列表
     * @return  养老人员列表
     */
    List<ComPensionAuthPensionerDO> getAuthPensionList();
}

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

@@ -585,7 +585,7 @@
        String pensionAuthPeriod = DateUtils.getCurrentDateString_YYYY();

        //查询所有老人信息并加入到老人认证历史记录表中，如果不存在则新增，存在则不做操作
        List<ComElderAuthElderliesDO> authElderliesList = comElderAuthElderliesDAO.selectList(null);
        List<ComElderAuthElderliesDO> authElderliesList = comElderAuthElderliesDAO.getAuthElderLiesList();
        authElderliesList.forEach(authElderlies -> {
            //查询高龄认证记录
            ComEldersAuthHistoryRecordDO authHistoryRecordDO = comEldersAuthHistoryRecordMapper.selectOne(new QueryWrapper<ComEldersAuthHistoryRecordDO>().lambda()
@@ -603,7 +603,7 @@
        });

        //查询所有养老人员信息并加入到老人认证历史记录表中，如果不存在则新增，存在则不做操作
        List<ComPensionAuthPensionerDO> pensionAuthPensionerList = comPensionAuthPensionerDAO.selectList(null);
        List<ComPensionAuthPensionerDO> pensionAuthPensionerList = comPensionAuthPensionerDAO.getAuthPensionList();
        pensionAuthPensionerList.forEach(authPension -> {
            //查询养老认证记录
            ComPensionAuthHistoryRecordDO pensionAuthDO = comPensionAuthHistoryRecordMapper.selectOne(new QueryWrapper<ComPensionAuthHistoryRecordDO>().lambda()

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

@@ -52,4 +52,31 @@
    <update id="editEditIsAlive">
        update com_elder_auth_elderlies set is_alive = #{isAlive} where population_id = #{populationId}
    </update>

    <select id="getAuthElderLiesList" resultType="com.panzhihua.service_community.model.dos.ComElderAuthElderliesDO">
        SELECT
            ceae.id,
            ceae.population_id,
            ceae.street_id,
            ceae.community_id,
            ceae.phone,
            ceae.`name`,
            ceae.id_card,
            ceae.sex,
            ceae.age,
            ceae.birthday,
            ceae.personnel_category,
            ceae.is_register,
            ceae.is_alive,
            ceae.address,
            ceae.remark,
            ceae.receive_allowance_begin,
            ceae.create_at,
            ceae.create_by,
            ceae.update_at,
            ceae.update_by
        FROM
            com_elder_auth_elderlies AS ceae
            INNER JOIN com_mng_population AS cmp ON cmp.id = ceae.population_id
    </select>
</mapper>

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

@@ -52,4 +52,31 @@
    <update id="editPensionIsAlive">
        update com_pension_auth_pensioners set is_alive = #{isAlive} where population_id = #{populationId}
    </update>

    <select id="getAuthPensionList" resultType="com.panzhihua.service_community.model.dos.ComPensionAuthPensionerDO">
        SELECT
            cpap.id,
            cpap.population_id,
            cpap.street_id,
            cpap.community_id,
            cpap.phone,
            cmp.`name`,
            cpap.id_card,
            cpap.sex,
            cpap.age,
            cpap.birthday,
            cpap.personnel_category,
            cpap.is_register,
            cpap.is_alive,
            cpap.address,
            cpap.remark,
            cpap.receive_allowance_begin,
            cpap.create_at,
            cpap.create_by,
            cpap.update_at,
            cpap.update_by
        FROM
            com_pension_auth_pensioners AS cpap
            INNER JOIN com_mng_population AS cmp ON cmp.id = cpap.population_id
    </select>
</mapper>