| | |
| | | private String tags; |
| | | |
| | | @ExcelProperty(value = "报名状态",index = 5) |
| | | private Integer status; |
| | | private String status; |
| | | |
| | | @ExcelProperty(value = "取消原因", index = 6) |
| | | private String reason; |
| | |
| | | <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, |