From 19737470afef2563d99ac133a5498ed845f1d822 Mon Sep 17 00:00:00 2001
From: 354798ggg <1074825718@qq.com>
Date: 星期四, 19 十月 2023 16:42:24 +0800
Subject: [PATCH] bug测试

---
 product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java |   27 ++++++++++++++++++++++++++-
 1 files changed, 26 insertions(+), 1 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 21dd0f8..d129de1 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
@@ -11,7 +11,9 @@
 import com.product.core.entity.DataTableEntity;
 import com.product.core.entity.FieldSetEntity;
 import com.product.core.exception.BaseException;
+import com.product.core.permission.PermissionService;
 import com.product.core.service.support.AbstractBaseService;
+import com.product.core.spring.context.SpringMVCContextHolder;
 import com.product.project.management.config.Cmnconst;
 import com.product.project.management.config.SystemCode;
 import com.product.util.BaseUtil;
@@ -23,7 +25,30 @@
 
     @Autowired
     BaseDao baseDao;
+    
+    @Autowired
+    PermissionService permissionService;
+    
+    /**
+     * 	椤圭洰淇℃伅鍒楄〃
+     * @param cpage
+     * @param pageSize
+     * @return
+     */
+    public DataTableEntity listProjectByCreated(Integer cpage, Integer pageSize) {
 
+    	String queryFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
+    	
+    	
+    	FieldSetEntity fseCurrentUser = SpringMVCContextHolder.getCurrentUser().getCurrentStaff();
+    	String leaderCode = fseCurrentUser.getString("leader_tricode")+"%";
+    	
+    	String filter =" project_leader in (select user_id from product_sys_staffs where leader_tricode like ?) OR materialman in (select user_id from product_sys_staffs where leader_tricode like ?)";
+    	DataTableEntity dt = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_QXLW, filter, new Object [] {leaderCode, leaderCode}, null, Cmnconst.CREATED_UTC_DATETIME_DESC, pageSize, cpage);
+    	baseDao.loadPromptData(dt);
+    	return dt;
+    }
+    
     /**
      * 閫氳繃椤圭洰绫诲瀷鑾峰彇椤圭洰鍒嗛」锛堣幏鍙栨ā鏉垮垎椤癸級
      *
@@ -60,7 +85,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;

--
Gitblit v1.9.2