futian.liu
2023-12-12 b4c27cf4af545af1a240f56d34702d38a783062d
consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java
@@ -34,8 +34,9 @@
        }
        //机构
        if (param.getAgencyId() != null) {
            sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId");
            paramts.put("lengthAgencyId", param.getAgencyId());
//            sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId");
            sql.append(" and ware.AGENCY_ID = :agencyId");
//            paramts.put("lengthAgencyId", param.getAgencyId());
            paramts.put("agencyId", param.getAgencyId());
        }
        //仓库类型
@@ -141,8 +142,9 @@
        }
        //机构
        if (param.getAgencyId() != null) {
            sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId");
            paramts.put("lengthAgencyId", param.getAgencyId());
//            sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId");
            sql.append(" and ware.AGENCY_ID = :agencyId");
//            paramts.put("lengthAgencyId", param.getAgencyId());
            paramts.put("agencyId", param.getAgencyId());
        }
        //仓库类型