puhanshu
2021-12-03 5b845e7b86ed4abc6b95df6da7bdc89d9bf2088f
修改活动bug
2个文件已修改
11 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActActSignExcelVO.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActSignMapper.xml 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActActSignExcelVO.java
@@ -36,7 +36,7 @@
    private String tags;
    @ExcelProperty(value = "报名状态",index = 5)
    private Integer status;
    private String status;
    @ExcelProperty(value = "取消原因", index = 6)
    private String reason;
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActSignMapper.xml
@@ -21,10 +21,13 @@
    <select id="getSignLists" resultType="com.panzhihua.common.model.vos.community.ComActActSignExcelVO">
        SELECT
        caas.create_at,
        r.times,
        caas.status,
        IF(r.times IS NULL, 0, r.times) AS times,
        CASE
        WHEN caas.status = 1 THEN
        '已报名' ELSE '已取消'
        END status,
        caas.reason,
        r.award * r.times as award,
        IF(r.times IS NULL, 0, r.award * r.times) AS award,
        t.limit,
        su.`name`,
        su.phone,