From 96b6c0cf5b5a55cb9681ba832ad1278945e5ff78 Mon Sep 17 00:00:00 2001 From: 354798ggg <1074825718@qq.com> Date: 星期四, 17 八月 2023 14:42:43 +0800 Subject: [PATCH] 按节点生成预算 --- product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java | 35 +++++++++++------------------------ 1 files changed, 11 insertions(+), 24 deletions(-) diff --git a/product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java b/product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java index bc24ed8..e4e30ef 100644 --- a/product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java +++ b/product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java @@ -1,8 +1,5 @@ package com.product.project.management.service; -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; import java.util.Map; import com.alibaba.fastjson.JSONArray; @@ -63,7 +60,7 @@ * @return */ public DataTableEntity getProjectAllItem(String uuid) { - DataTableEntity dtProjectItemize = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid=?", new Object[]{uuid}, new Object[]{CoreConst.UUID, Cmnconst.ITEMIZE, Cmnconst.ITEMIZE_CODE, Cmnconst.ITEMIZE_PARENT_CODE}); + DataTableEntity dtProjectItemize = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid=?", new Object[]{uuid}, new Object[]{CoreConst.UUID, Cmnconst.ITEMIZE, Cmnconst.ITEMIZE_CODE, Cmnconst.ITEMIZE_PARENT_CODE, Cmnconst.ITEMIZE_FULL_NAME}); if (!BaseUtil.dataTableIsEmpty(dtProjectItemize)) { DataTableEntity newDtProjectItem = BaseUtil.dataTableToTreeTable(dtProjectItemize, Cmnconst.ITEMIZE_CODE, Cmnconst.ITEMIZE_PARENT_CODE, null); return newDtProjectItem; @@ -97,30 +94,20 @@ /** * 鑾峰彇鍒嗛」棰勭畻淇℃伅 * - * @param projectUUID 椤圭洰UUID - * @param itemizeCode 鍒嗛」缂栫爜 + * @param itemizeUUID 鍒嗛」UUID * @param capge 褰撳墠椤� * @param pageSize 椤靛ぇ灏� * @return */ - public DataTableEntity listItemizeBudget(String projectUUID, String itemizeCode, Integer capge, Integer pageSize) { - - - String filter; - List<String> params = new ArrayList<>(); - if (BaseUtil.strIsNull(itemizeCode)) { - filter = "project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=?)"; - params.add(projectUUID); - } else { - filter = "project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=? AND itemize_code like ?)"; - params.add(projectUUID); - params.add(itemizeCode + "%"); - } - DataTableEntity dtItemizeBudget = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_BUDGET, filter, params.toArray(), null, null, pageSize, capge); - if (!BaseUtil.dataTableIsEmpty(dtItemizeBudget)) { - baseDao.loadPromptData(dtItemizeBudget); - } - return dtItemizeBudget; + public DataTableEntity listItemizeBudget(String itemizeUUID, Integer capge, Integer pageSize) { + if (!BaseUtil.strIsNull(itemizeUUID)) { + DataTableEntity dtItemizeBudget = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_BUDGET, "project_itemize_uuid = ?", new Object[] {itemizeUUID}, null, null, pageSize, capge); + if (!BaseUtil.dataTableIsEmpty(dtItemizeBudget)) { + baseDao.loadPromptData(dtItemizeBudget); + } + return dtItemizeBudget; + } + return null; } /** -- Gitblit v1.9.2