党建相关bug修改

101captain

2022-03-30 c577d573c345ae29a6895721e324c13145c509a0

党建相关bug修改

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

@@ -30,7 +30,7 @@
    IPage<ComElderAuthRecordVO> pageElderAuthRecords(Page page,
                                               @Param("pageElderAuthRecordsDTO") PageElderAuthRecordsDTO pageElderAuthRecordsDTO);

    List<ComElderAuthRecordVO> export(@Param("pageElderAuthRecordsDTO") PageElderAuthRecordsDTO pageElderAuthRecordsDTO);
    List<ComElderAuthRecordExcleVO> export(@Param("pageElderAuthRecordsDTO") PageElderAuthRecordsDTO pageElderAuthRecordsDTO);

    ComElderAuthRecordVO detailElderAuthRecords(@Param("authRecordId") Long authRecordId);


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

@@ -90,23 +90,28 @@
        order by cear.create_at desc
    </select>

    <select id="export" resultType="com.panzhihua.common.model.vos.community.ComElderAuthRecordVO">
    <select id="export" resultType="com.panzhihua.common.model.vos.community.ComElderAuthRecordExcleVO">
        SELECT
        cear.id,
        su.`name` submitUserName,
        ceae.phone,
        ceae.`name`,
        ceae.id_card,
        case when caea.sex = 1 then '男' when caea.sex = 2 then '女'  end
        ceae.sex,
        ceae.birthday,
        case when caea.personnel_category = 1 then '80-89周岁' when caea.personnel_category = 2 then '90-99周岁' when caea.personnel_category = 3 then '100周岁（含）以上' end
        ceae.personnel_category,
        cear.address,
        case when caea.is_alive = 1 then '是' when caea.is_alive = 2 then '否'  end
        ceae.is_alive,
        case when caea.auth_method = 1 then '视频认证' when caea.auth_method = 2 then '人脸认证' when caea.auth_method = 3 then '线下认证' end
        cear.auth_method,
        cear.auth_period,
        cear.auth_video,
        cear.auth_date,
        cear.mark,
        case when caea.approval_status = 1 then '待审核' when caea.approval_status = 2 then '驳回' when caea.approval_status = 3 then '通过'  end
        cear.approval_status,
        cear.approver_id,
        su1.`name` as approverName,