From a44e41f30ec70520528a5a089d38eb90d78b6842 Mon Sep 17 00:00:00 2001
From: 354798ggg <1074825718@qq.com>
Date: 星期一, 30 十月 2023 14:26:06 +0800
Subject: [PATCH] 项目台账和出库台账策略权限

---
 product-server-project-management/src/main/java/com/product/project/management/service/ProjectOutService.java       |   23 +++++++++++++++++++++++
 product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java      |    9 +--------
 product-server-project-management/src/main/java/com/product/project/management/controller/ProjectOutController.java |   22 ++++++++++++++++++++++
 3 files changed, 46 insertions(+), 8 deletions(-)

diff --git a/product-server-project-management/src/main/java/com/product/project/management/controller/ProjectOutController.java b/product-server-project-management/src/main/java/com/product/project/management/controller/ProjectOutController.java
index d9691de..6a23e4f 100644
--- a/product-server-project-management/src/main/java/com/product/project/management/controller/ProjectOutController.java
+++ b/product-server-project-management/src/main/java/com/product/project/management/controller/ProjectOutController.java
@@ -4,6 +4,7 @@
 import com.product.core.entity.FieldSetEntity;
 import com.product.core.exception.BaseException;
 import com.product.module.sys.version.ApiVersion;
+import com.product.project.management.config.Cmnconst;
 import com.product.project.management.config.SystemCode;
 import com.product.project.management.service.ProjectOutService;
 import com.product.util.BaseUtil;
@@ -24,6 +25,27 @@
 public class ProjectOutController extends AbstractBaseController {
     @Autowired
     ProjectOutService projectOutService;
+    
+    @RequestMapping(value = "/list/{version}", method = RequestMethod.POST)
+    @ApiVersion(1)
+    public String listOutBound(HttpServletRequest request) {
+    	try {
+            // 鑾峰彇鍙傛暟
+            FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+            if (BaseUtil.strIsNull(fse.getString(Cmnconst.CPAGE)) || BaseUtil.strIsNull(fse.getString(Cmnconst.PAGESIZE))) {
+				return this.error(SystemCode.SYSTEM_CPAGES_NOT_NULL.getValue(), SystemCode.SYSTEM_CPAGES_NOT_NULL.getText());
+			}
+            return OK_List(projectOutService.listOutBound(fse.getInteger(Cmnconst.CPAGE), fse.getInteger(Cmnconst.PAGESIZE), fse.getString("filter")));
+        } catch (BaseException e) {
+            e.printStackTrace();
+            return this.error(e);
+        } catch (Exception e) {
+            e.printStackTrace();
+            return this.error(SystemCode.PROJeCT_OUT_CANCELOUTBOUND_ERROR.getValue(),
+                    SystemCode.PROJeCT_OUT_CANCELOUTBOUND_ERROR.getText() + e.getMessage());
+        }
+    }
+    
     /**
      * 	鎾ら攢鍑哄簱
      *
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 d129de1..b1babe8 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
@@ -13,7 +13,6 @@
 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;
@@ -38,13 +37,7 @@
     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);
+    	DataTableEntity dt = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_QXLW, queryFilter, new Object [] {}, null, Cmnconst.CREATED_UTC_DATETIME_DESC, pageSize, cpage);
     	baseDao.loadPromptData(dt);
     	return dt;
     }
diff --git a/product-server-project-management/src/main/java/com/product/project/management/service/ProjectOutService.java b/product-server-project-management/src/main/java/com/product/project/management/service/ProjectOutService.java
index 978b649..35cdb70 100644
--- a/product-server-project-management/src/main/java/com/product/project/management/service/ProjectOutService.java
+++ b/product-server-project-management/src/main/java/com/product/project/management/service/ProjectOutService.java
@@ -1,8 +1,13 @@
 package com.product.project.management.service;
 
 import com.product.core.dao.BaseDao;
+import com.product.core.entity.DataTableEntity;
 import com.product.core.entity.FieldSetEntity;
+import com.product.core.permission.PermissionService;
 import com.product.core.service.support.AbstractBaseService;
+import com.product.project.management.config.Cmnconst;
+import com.product.util.BaseUtil;
+
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Component;
 
@@ -14,6 +19,24 @@
  */
 @Component
 public class ProjectOutService  extends AbstractBaseService {
+	
+	@Autowired
+    PermissionService permissionService;
+	
+	
+	public DataTableEntity listOutBound(Integer cpage, Integer pageSize, String filter) {
+		
+		String queryFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
+		if (!BaseUtil.strIsNull(queryFilter)) {
+			filter += " AND " + queryFilter;
+		}
+		
+		String sql = "SELECT * FROM product_project_outbound A LEFT JOIN product_project_qxlw B ON A.project_uuid = B.uuid  WHERE " + filter;
+		DataTableEntity dt = baseDao.listTable(sql, new Object[] {}, pageSize, cpage);
+		baseDao.loadPromptData(dt);
+		return dt;
+	}
+	
     /**
      * 鍑哄簱鎾ら攢
      */

--
Gitblit v1.9.2