采购明细查询修改，查询本级及以下

WangHan

2024-12-19 fae8a9349499cd045bc73e8fd22aeae52618a46c

采购明细查询修改，查询本级及以下

 consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java

@@ -305,7 +305,9 @@
        if (sysInfo == null) {
            return ResponseValue.error("登录用户信息不存在");
        }
        // formProcureQry.setAgencyId(Long.valueOf(sysInfo.getTenantId()));
        if (param2.getAgencyId() == null) {
            formProcureQry.setAgencyId(Long.valueOf(sysInfo.getTenantId()));
        }
        GenericPager genericPager = lWhFormProcureService.queryFormProcureDetailList(formProcureQry);
        return ResponseValue.success(genericPager);
    }

 consum-base/src/main/java/com/consum/base/service/impl/LWhFormProcureServiceImpl.java

@@ -129,8 +129,8 @@
                + "LEFT JOIN l_wh_procure_model pm ON pm.FROM_PROCURE_GOODS_ID = fpg.id WHERE pm.BUSINESS_TYPE = 1 ");
        // 只查询本机构的采购单
        if (param.getAgencyId() != null) {
            sql.append("and fp.AGENCY_ID = :agencyId ");
            paramts.put("agencyId", param.getAgencyId());
            sql.append("and AGENCY_ID like :agencyId ");
            paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT);
        }

        // 入库单号