101captain
2021-10-18 0b387284f10ffff8816779ac9b54f91908703932
爱心义仓修改
2个文件已修改
27 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/warehouse/ComActWarehouseApplyExcelVO.java 21 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActWarehouseApplyMapper.xml 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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>