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