优化采购申请查询慢的问题

wuxw

2024-09-02 5c355e4a32605c88ee87df99502cbdf649a47c1c

优化采购申请查询慢的问题

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

@@ -349,14 +349,21 @@
        r.price,r.price standardPrice,rstime.stock,rst.name rstName,rst1.name parentRstName,rss.spec_name
        specName,rs.supplier_name supplierName,
        td1.name unitCodeName,
        td2.name miniUnitCodeName
        td2.name miniUnitCodeName,
        r.sh_id shId,
        sh.sh_name shName,
        r.is_fixed isFixed,
        td3.name isFixedName
        from
        purchase_apply_detail p
        inner join resource_store r on p.res_id = r.res_id and r.status_cd = '0'
        left join storehouse sh on r.sh_id = sh.sh_id and sh.status_cd = '0'
        left join t_dict td1 on r.unit_code = td1.status_cd and td1.table_name = 'resource_store' and td1.table_columns
        = 'unit_code'
        left join t_dict td2 on r.mini_unit_code = td2.status_cd and td2.table_name = 'resource_store' and
        td2.table_columns = 'unit_code'
        left join t_dict td3 on r.is_fixed = td3.status_cd and td3.table_name = 'resource_store' and
        td3.table_columns = 'is_fixed'
        LEFT JOIN resource_supplier rs on p.rs_id=rs.rs_id
        LEFT JOIN resource_store_type rst on r.rst_id=rst.rst_id
        LEFT JOIN resource_store_type rst1 on r.parent_rst_id=rst1.rst_id

 service-store/src/main/java/com/java110/store/cmd/purchaseApply/ListPurchaseApplysCmd.java

@@ -145,30 +145,14 @@
            BigDecimal purchaseTotalPrice = new BigDecimal(0);
            Integer cursor = 0;
            for (PurchaseApplyDetailVo purchaseApplyDetailVo : applyDetailList) {
                ResourceStoreDto resourceStoreDto = new ResourceStoreDto();
                resourceStoreDto.setResId(purchaseApplyDetailVo.getResId());
                List<ResourceStoreDto> resourceStoreDtos = resourceStoreInnerServiceSMOImpl.queryResourceStores(resourceStoreDto);

                if (resourceStoreDtos == null || resourceStoreDtos.size() < 1) {
                    continue;
                }
                purchaseApplyDetailVo.setTimes(resourceStoreDtos.get(0).getTimes());
                //todo 是否是固定物品
                apiPurchaseApplyDataVo.setIsFixed(resourceStoreDtos.get(0).getIsFixed());
                apiPurchaseApplyDataVo.setIsFixedName(resourceStoreDtos.get(0).getIsFixedName());
                purchaseApplyDetailVo.setIsFixed(resourceStoreDtos.get(0).getIsFixed());
                purchaseApplyDetailVo.setIsFixedName(resourceStoreDtos.get(0).getIsFixedName());
                //todo 获取仓库名称
                String shName = resourceStoreDtos.get(0).getShName();
                String shId = resourceStoreDtos.get(0).getShId();
                purchaseApplyDetailVo.setShName(shName);
                purchaseApplyDetailVo.setShId(shId);
                apiPurchaseApplyDataVo.setShId(shId);
                apiPurchaseApplyDataVo.setIsFixed(purchaseApplyDetailVo.getIsFixed());

                cursor++;
                if(!StringUtil.isEmpty(purchaseApplyDetailVo.getSpecName())){
                if (!StringUtil.isEmpty(purchaseApplyDetailVo.getSpecName())) {
                    resNames.append(cursor + "：" + purchaseApplyDetailVo.getResName() + "(" + purchaseApplyDetailVo.getSpecName() + ")      ");
                }else{
                    resNames.append(cursor+":"+purchaseApplyDetailVo.getResName());
                } else {
                    resNames.append(cursor + ":" + purchaseApplyDetailVo.getResName());
                }
                BigDecimal price = new BigDecimal(purchaseApplyDetailVo.getPrice());
                BigDecimal quantity = new BigDecimal(purchaseApplyDetailVo.getQuantity());