增加软件筛选条件

whycxzp

2023-08-03 a90d9bcdca6f1d87bda8e76738b488dbfd9b19f5

增加软件筛选条件

 src/main/java/com/whyc/mapper/SoftwareMapper.java

@@ -1,12 +1,11 @@
package com.whyc.mapper;

import com.whyc.pojo.Software;
import org.springframework.scheduling.support.SimpleTriggerContext;

import java.util.List;

public interface SoftwareMapper extends CustomMapper<Software>{

    //查询软件列表的信息
    List getFileUrl(String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber);
    List getFileUrl(Integer lockFlag, String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber);
}

 src/main/java/com/whyc/service/SoftwareService.java

@@ -135,9 +135,9 @@

    }
    //查询软件列表的信息
    public Response getAllSoftware(String fileName,String applyMaterialCode,String applyModel,String owner, String boardNumber,int pageCurr, int pageSize) {
    public Response getAllSoftware(Integer lockFlag, String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber, int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        List list=mapper.getFileUrl(fileName,applyMaterialCode,applyModel,owner,boardNumber);
        List list=mapper.getFileUrl(lockFlag,fileName,applyMaterialCode,applyModel,owner,boardNumber);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list.size()>0,pageInfo,"软件信息返回");
    }

 src/main/resources/mapper/SoftwareMapper.xml

@@ -11,6 +11,17 @@
        select  distinct file_url from tb_software
        <where>
            1=1
            <choose>
                <when test="lockFlag == 0">
                    and lock_flag = 0
                </when>
                <when test="lockFlag == 12">
                    and lock_flag != 0
                </when>
                <when test="lockFlag == -1">
                    and lock_flag = -1
                </when>
            </choose>
            <if test="fileName!=null&amp;&amp;fileName!=''">
            and file_name like '%${fileName}%'
            </if>