springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/warehouse/ComActWarehouseApplyExcelVO.java
@@ -3,6 +3,7 @@ import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.converters.string.StringImageConverter; import com.fasterxml.jackson.annotation.JsonFormat; import com.panzhihua.common.utlis.StringUtils; import lombok.Data; import java.net.URL; @@ -98,4 +99,24 @@ */ @ExcelProperty(value = "物品图片",index = 5) private URL image; public void setStatus(String status) { if(StringUtils.isNotEmpty(status)){ if("-1".equals(status)){ status="已取消"; }else if("0".equals(status)){ status="待处理"; } else if("1".equals(status)){ status="待领取"; } else if("2".equals(status)){ status="已驳回"; } else if("3".equals(status)){ status="已领取"; } this.status=status; } } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActWarehouseApplyMapper.xml
@@ -44,6 +44,12 @@ <if test="commonPage.userId !=null"> and t.apply_user_id = #{commonPage.userId} </if> <if test="commonPage.beginTime !=null"> and t.actual_time >=#{commonPage.beginTime} </if> <if test="commonPage.endTime !=null"> and #{commonPage.endTime} >=t.actual_time </if> </where> order by t.actual_time desc </select>