部门分发添加,分发单型号查询

futian.liu

2023-12-02 edc87e2fc3760cd7d1230bc058acf5620ea2c465

 consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java

@@ -42,8 +42,9 @@
        HashMap<String, Object> paramts = new HashMap<>();
        //机构
        if (param.getAgencyId() != null) {
            sqlCangKuWhere.append(" AND left(tenant.id, length(:lengthAgencyId)) = :agencyId");
            paramts.put("lengthAgencyId", param.getAgencyId());
//            sqlCangKuWhere.append(" AND left(tenant.id, length(:lengthAgencyId)) = :agencyId");
            sqlCangKuWhere.append(" AND tenant.id = :agencyId");
//            paramts.put("lengthAgencyId", param.getAgencyId());
            paramts.put("agencyId", param.getAgencyId());
        }
        // 部门