优化 查询物品 代码

Your Name

2023-01-19 968793858b70252ae6a4e6dd6d24086fae2b33f9

优化 查询物品 代码

 java110-bean/src/main/java/com/java110/dto/resourceStore/ResourceStoreDto.java

@@ -1,6 +1,7 @@
package com.java110.dto.resourceStore;

import com.java110.dto.PageDto;
import com.java110.dto.resourceStoreTimes.ResourceStoreTimesDto;

import java.io.Serializable;
import java.util.Date;
@@ -73,6 +74,8 @@
    //是否是固定物品
    private String isFixed;
    private String isFixedName;

    private List<ResourceStoreTimesDto> times;

    public String getResName() {
        return resName;
@@ -401,4 +404,12 @@
    public void setShObjIds(String[] shObjIds) {
        this.shObjIds = shObjIds;
    }

    public List<ResourceStoreTimesDto> getTimes() {
        return times;
    }

    public void setTimes(List<ResourceStoreTimesDto> times) {
        this.times = times;
    }
}

 java110-bean/src/main/java/com/java110/dto/resourceStoreTimes/ResourceStoreTimesDto.java

@@ -23,6 +23,7 @@

    private String hasStock;
    private String resCode;
    private String[] resCodes;
    private String timesId;


@@ -111,4 +112,12 @@
    public void setTotalPrice(String totalPrice) {
        this.totalPrice = totalPrice;
    }

    public String[] getResCodes() {
        return resCodes;
    }

    public void setResCodes(String[] resCodes) {
        this.resCodes = resCodes;
    }
}

 java110-db/src/main/resources/mapper/store/ResourceStoreTimesV1ServiceDaoImplMapper.xml

@@ -43,6 +43,12 @@
        <if test="resCode !=null and resCode != ''">
            and t.res_code= #{resCode}
        </if>
        <if test="resCodes != null ">
            and t.res_code in
            <foreach collection="resCodes" item="item" open="(" close=")" separator=",">
                #{item}
            </foreach>
        </if>
        <if test="timesId !=null and timesId != ''">
            and t.times_id= #{timesId}
        </if>
@@ -108,6 +114,12 @@
        <if test="resCode !=null and resCode != ''">
            and t.res_code= #{resCode}
        </if>
        <if test="resCodes != null ">
            and t.res_code in
            <foreach collection="resCodes" item="item" open="(" close=")" separator=",">
                #{item}
            </foreach>
        </if>
        <if test="timesId !=null and timesId != ''">
            and t.times_id= #{timesId}
        </if>

 service-store/src/main/java/com/java110/store/cmd/resourceStore/ListResourceStoresCmd.java

@@ -26,6 +26,10 @@
import java.util.List;
import java.util.Map;

/**
 * 查询物品
 * add by wuxw 2023-01-19
 */
@Java110Cmd(serviceCode = "resourceStore.listResourceStores")
public class ListResourceStoresCmd extends Cmd {


 service-store/src/main/java/com/java110/store/smo/impl/ResourceStoreInnerServiceSMOImpl.java

@@ -5,8 +5,10 @@
import com.java110.dto.file.FileRelDto;
import com.java110.dto.purchaseApply.PurchaseApplyDto;
import com.java110.dto.resourceStore.ResourceStoreDto;
import com.java110.dto.resourceStoreTimes.ResourceStoreTimesDto;
import com.java110.intf.common.IFileRelInnerServiceSMO;
import com.java110.intf.store.IResourceStoreInnerServiceSMO;
import com.java110.intf.store.IResourceStoreTimesV1InnerServiceSMO;
import com.java110.intf.user.IUserInnerServiceSMO;
import com.java110.po.purchase.ResourceStorePo;
import com.java110.store.dao.IResourceStoreServiceDao;
@@ -43,6 +45,9 @@
    @Autowired
    private IFileRelInnerServiceSMO fileRelInnerServiceSMOImpl;

    @Autowired
    private IResourceStoreTimesV1InnerServiceSMO resourceStoreTimesV1InnerServiceSMOImpl;

    @Override
    public List<ResourceStoreDto> queryResourceStores(@RequestBody ResourceStoreDto resourceResourceStoreDto) {
        //校验是否传了 分页信息
@@ -53,7 +58,10 @@
        List<ResourceStoreDto> resourceResourceStores = BeanConvertUtil.covertBeanList(resourceResourceStoreServiceDaoImpl.getResourceStoreInfo(BeanConvertUtil.beanCovertMap(resourceResourceStoreDto)), ResourceStoreDto.class);
        //获取图片地址
        List<ResourceStoreDto> resourceStoreDtos = new ArrayList<>();
        List<String> resCodes = new ArrayList<>();
        for (ResourceStoreDto resourceStoreDto : resourceResourceStores) {

            resCodes.add(resourceStoreDto.getResCode());
            //获取资源id
            String resId = resourceStoreDto.getResId();
            FileRelDto fileRelDto = new FileRelDto();
@@ -69,6 +77,26 @@
            }
            resourceStoreDtos.add(resourceStoreDto);
        }

        ResourceStoreTimesDto resourceStoreTimesDto = new ResourceStoreTimesDto();
        resourceStoreTimesDto.setStoreId(resourceResourceStoreDto.getStoreId());
        resourceStoreTimesDto.setResCodes(resCodes.toArray(new String[resCodes.size()]));
        List<ResourceStoreTimesDto> resourceStoreTimesDtos = resourceStoreTimesV1InnerServiceSMOImpl.queryResourceStoreTimess(resourceStoreTimesDto);

        if(resourceStoreTimesDtos == null || resourceStoreTimesDtos.size()< 1){
            return resourceStoreDtos;
        }

        List<ResourceStoreTimesDto> times = null;
        for (ResourceStoreDto resourceStoreDto : resourceResourceStores) {
            times = new ArrayList<>();
            for(ResourceStoreTimesDto tmpResourceStoreTimesDto: resourceStoreTimesDtos){
                if(resourceStoreDto.getResCode().equals(tmpResourceStoreTimesDto.getResCode())){
                    times.add(tmpResourceStoreTimesDto);
                }
            }
            resourceStoreDto.setTimes(times);
        }
        return resourceStoreDtos;
    }