From 84282c0bed4337bdeb0c8bc3e240c593398fbef4 Mon Sep 17 00:00:00 2001
From: 杜洪波 <1074825718@qq.com>
Date: 星期一, 29 九月 2025 18:12:35 +0800
Subject: [PATCH] 会议看板代码提交

---
 src/main/java/com/product/administration/service/ide/IConferenceManagerService.java  |    6 
 src/main/java/com/product/administration/controller/ConferenceManagerController.java |  342 ++++++++++---------------------------
 src/main/java/com/product/administration/config/CmnConst.java                        |    2 
 src/main/java/com/product/administration/service/ConferenceManagerService.java       |  150 +++++++++++++++-
 4 files changed, 235 insertions(+), 265 deletions(-)

diff --git a/src/main/java/com/product/administration/config/CmnConst.java b/src/main/java/com/product/administration/config/CmnConst.java
index b57d589..b3204b1 100644
--- a/src/main/java/com/product/administration/config/CmnConst.java
+++ b/src/main/java/com/product/administration/config/CmnConst.java
@@ -2,10 +2,10 @@
 
 
 public class CmnConst {
+	
 
     //琛ㄥ悕甯搁噺瀹氫箟
     public static final String PRODUCT_SYS_MODULES = "product_sys_modules";        //妯″潡琛ㄥ悕
-
     public static final String PRODUCT_SYS_DICT = "product_sys_dict";    //鏁版嵁瀛楀吀琛�
     public static final String PRODUCT_SYS_USERS = "product_sys_users";    //鐧诲綍鐢ㄦ埛琛�
     public static final String PRODUCT_SYS_PROMPT = "product_sys_prompt";    //楂樼骇鍙傜収琛�
diff --git a/src/main/java/com/product/administration/controller/ConferenceManagerController.java b/src/main/java/com/product/administration/controller/ConferenceManagerController.java
index 28102cc..eed54ec 100644
--- a/src/main/java/com/product/administration/controller/ConferenceManagerController.java
+++ b/src/main/java/com/product/administration/controller/ConferenceManagerController.java
@@ -11,6 +11,7 @@
 import com.product.administration.service.ide.IConferenceManagerService;
 import com.product.core.config.CoreConst;
 import com.product.core.controller.support.AbstractBaseController;
+import com.product.core.entity.DataTableEntity;
 import com.product.core.entity.FieldSetEntity;
 import com.product.core.entity.RequestParameterEntity;
 import com.product.core.exception.BaseException;
@@ -60,20 +61,7 @@
     public String listConferenceRoom(HttpServletRequest request) {
         try {
             //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG);
             // 鍒ゆ柇鍒嗛〉鍙傛暟鏄惁姝e父
             if (StringUtils.isEmpty(fse.getString(CmnConst.PAGESIZE))
                     || StringUtils.isEmpty(fse.getString(CmnConst.CPAGE))) {
@@ -104,20 +92,7 @@
     public String findCconferenceRoom(HttpServletRequest request) {
         try {
             //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG);
             // 鍒ゆ柇uuid鏄惁姝e父
             if (StringUtils.isEmpty(fse.getUUID())) {
                 return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
@@ -146,21 +121,7 @@
     @ApiVersion(1)
     public String saveCconferenceRoom(HttpServletRequest request) {
         try {
-            //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG);
             //鏁版嵁鎿嶄綔鐨勬潈闄愰獙璇�
             if (!permissionService.validDataPermission(fse, CoreConst.DATA_PERMISSION_VALID_TYPE_ORG)) {
                 return this.error(SystemErrorCode.SYSTEM_NOT_OPER_PERMISSION.getValue(), SystemErrorCode.SYSTEM_NOT_OPER_PERMISSION.getText());
@@ -187,20 +148,7 @@
     public String deleteCconferenceRoom(HttpServletRequest request) {
         try {
             //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG);
             // 鍒ゆ柇uuid鏄惁姝e父
             if (StringUtils.isEmpty(fse.getUUID())) {
                 return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
@@ -222,7 +170,7 @@
 
 
     /**
-     * 浼氳鐢宠
+     * 浼氳瀹ょ敵璇�
      *
      * @param request
      * @return
@@ -232,20 +180,7 @@
     public String listConferenceApply(HttpServletRequest request) {
         try {
             //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_APPLY.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
             // 鍒ゆ柇鍒嗛〉鍙傛暟鏄惁姝e父
             if (StringUtils.isEmpty(fse.getString(CmnConst.PAGESIZE))
                     || StringUtils.isEmpty(fse.getString(CmnConst.CPAGE))) {
@@ -277,20 +212,7 @@
     public String findCconferenceApply(HttpServletRequest request) {
         try {
             //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_APPLY.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
             // 鍒ゆ柇uuid鏄惁姝e父
             if (StringUtils.isEmpty(fse.getUUID())) {
                 return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
@@ -311,7 +233,7 @@
     }
 
     /**
-     * 浼氳瀹や繚瀛�
+     * 浼氳瀹ょ敵璇蜂繚瀛�
      *
      * @param request
      * @return
@@ -320,21 +242,7 @@
     @ApiVersion(1)
     public String saveCconferenceApply(HttpServletRequest request) {
         try {
-            //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_APPLY.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
             //鏁版嵁鎿嶄綔鐨勬潈闄愰獙璇�
             if (!permissionService.validDataPermission(fse, CoreConst.DATA_PERMISSION_VALID_TYPE_ORG)) {
                 return this.error(SystemErrorCode.SYSTEM_NOT_OPER_PERMISSION.getValue(), SystemErrorCode.SYSTEM_NOT_OPER_PERMISSION.getText());
@@ -351,7 +259,7 @@
     }
 
     /**
-     * 浼氳瀹ゅ垹闄�
+     * 浼氳瀹ょ敵璇峰垹闄�
      *
      * @param request
      * @return
@@ -360,21 +268,7 @@
     @ApiVersion(1)
     public String deleteCconferenceApply(HttpServletRequest request) {
         try {
-            //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_APPLY.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
             // 鍒ゆ柇uuid鏄惁姝e父
             if (StringUtils.isEmpty(fse.getUUID())) {
                 return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
@@ -405,23 +299,31 @@
     @ApiVersion(1)
     public String conferenceRoomUsage(HttpServletRequest request) {
         try {
-            //鑾峰彇鍙傛暟
-            FieldSetEntity fse = null;
-            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-            if (bean != null) {
-                RequestParameterEntity reqp = (RequestParameterEntity) bean;
-                fse = reqp.getFormData();
-            }
-            //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-            if (bean == null || fse == null) {
-                return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-            }
-            // 鍒ゆ柇琛ㄥ悕鏄惁姝e父
-            if (fse.getTableName() == null || !CmnConst.PRODUCT_OA_CONFERENCE_APPLY.equals(fse.getTableName())) {
-                return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
-            }
+        	FieldSetEntity fse = BaseUtil.getFieldSetEntity(request, CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
             return conferenceManagerService.getConferenceRoomUsage(fse);
         } catch (BaseException e) {
+            e.printStackTrace();
+            return this.error(e.getCode(), e.getMessage());
+        } catch (Exception e) {
+            e.printStackTrace();
+            return this.error(SystemCode.CONFERENCE_ROOM_GET_FIAL.getValue(), SystemCode.CONFERENCE_ROOM_GET_FIAL.getText() + e.getMessage());
+        }
+    }
+    
+    /**
+     * 浼氳棰勭害鐪嬫澘鍔熻兘
+     * @param request
+     * @return
+     */
+    @PostMapping("/meeting-kanban/{version}")
+    @ApiVersion(1)
+   public String getKanbanData(HttpServletRequest request){
+    	try {
+	        //鑾峰彇鍙傛暟
+	        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+	        DataTableEntity dtKanban = conferenceManagerService.getKanBanData(fse);
+	        return OK_List(dtKanban);
+    	}  catch (BaseException e) {
             e.printStackTrace();
             return this.error(e.getCode(), e.getMessage());
         } catch (Exception e) {
@@ -438,22 +340,18 @@
     @PostMapping("/get_kb_Data/{version}")
     @ApiVersion(1)
    public String getkbData(HttpServletRequest request){
-
-        //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
+    	try {
+	        //鑾峰彇鍙傛暟
+	        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+	        List kbData = conferenceManagerService.getkbData(fse);
+	        return OK(kbData);
+    	}  catch (BaseException e) {
+            e.printStackTrace();
+            return this.error(e.getCode(), e.getMessage());
+        } catch (Exception e) {
+            e.printStackTrace();
+            return this.error(SystemCode.CONFERENCE_ROOM_GET_FIAL.getValue(), SystemCode.CONFERENCE_ROOM_GET_FIAL.getText() + e.getMessage());
         }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
-        List kbData = conferenceManagerService.getKbData(fse);
-
-        return OK(kbData);
-
     }
 
     /**
@@ -464,20 +362,18 @@
     @PostMapping("/get_Meeting_Details/{version}")
     @ApiVersion(1)
     public String getMeetingDetails(HttpServletRequest request){
-        //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
+    	try {
+	        //鑾峰彇鍙傛暟
+	        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+	        List meetingDetails = conferenceManagerService.getMeetingDetails(fse);
+	        return OK(meetingDetails);
+    	}  catch (BaseException e) {
+            e.printStackTrace();
+            return this.error(e.getCode(), e.getMessage());
+        } catch (Exception e) {
+            e.printStackTrace();
+            return this.error(SystemCode.CONFERENCE_ROOM_GET_FIAL.getValue(), SystemCode.CONFERENCE_ROOM_GET_FIAL.getText() + e.getMessage());
         }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
-        List meetingDetails = conferenceManagerService.getMeetingDetails(fse);
-        return  OK(meetingDetails);
-
     }
 
     /**
@@ -489,21 +385,18 @@
     @PostMapping("/save_or_update_meeting_info/{version}")
     @ApiVersion(1)
     public String saveOrUpdateMeetingInfo(HttpServletRequest request){
-
-        //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
+    	try {
+	        //鑾峰彇鍙傛暟
+	        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+	        HashMap hashMap = conferenceManagerService.saveOrUpdateMeetingInfo(fse);
+	        return OK(hashMap);
+    	}  catch (BaseException e) {
+            e.printStackTrace();
+            return this.error(e.getCode(), e.getMessage());
+        } catch (Exception e) {
+            e.printStackTrace();
+            return this.error(SystemCode.CONFERENCE_ROOM_GET_FIAL.getValue(), SystemCode.CONFERENCE_ROOM_GET_FIAL.getText() + e.getMessage());
         }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
-        HashMap hashMap = conferenceManagerService.saveOrUpdateMeetingInfo(fse);
-        return OK(hashMap);
-
     }
 
 
@@ -519,36 +412,28 @@
     public void getQrCode(HttpServletRequest request, HttpServletResponse response) throws IOException, WriterException {
 
         //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
+        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
+        if(!StringUtils.isEmpty(fse.getString("uuid"))){
+        	String uuid = fse.getString("uuid");
+        	// 璁剧疆鍝嶅簲娴佷俊鎭�
+            response.setContentType("image/jpg");
+            response.setHeader("Pragma", "no-cache");
+            response.setHeader("Cache-Control", "no-cache");
+            response.setDateHeader("Expires", 0);
 
-            if(fse!=null &&  !StringUtils.isEmpty(fse.getString("uuid"))){
-                String uuid = fse.getString("uuid");
-                // 璁剧疆鍝嶅簲娴佷俊鎭�
-                response.setContentType("image/jpg");
-                response.setHeader("Pragma", "no-cache");
-                response.setHeader("Cache-Control", "no-cache");
-                response.setDateHeader("Expires", 0);
+            OutputStream stream = response.getOutputStream();
 
-                OutputStream stream = response.getOutputStream();
-
-                JSONObject jsonData = new JSONObject();
-                jsonData.put("uuid",uuid);
-                Date date = new Date();
-                SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-                String formatDate = dateFormat.format(date);
-                jsonData.put("date",formatDate);
-                //鑾峰彇涓�涓簩缁寸爜鍥剧墖
-                BitMatrix bitMatrix = conferenceManagerService.getQrCode(jsonData.toString());
-                //浠ユ祦鐨勫舰寮忚緭鍑哄埌鍓嶇
-                MatrixToImageWriter.writeToStream(bitMatrix , "jpg" , stream);
-           }
+            JSONObject jsonData = new JSONObject();
+            jsonData.put("uuid",uuid);
+            Date date = new Date();
+            SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+            String formatDate = dateFormat.format(date);
+            jsonData.put("date",formatDate);
+            //鑾峰彇涓�涓簩缁寸爜鍥剧墖
+            BitMatrix bitMatrix = conferenceManagerService.getQrCode(jsonData.toString());
+            //浠ユ祦鐨勫舰寮忚緭鍑哄埌鍓嶇
+            MatrixToImageWriter.writeToStream(bitMatrix , "jpg" , stream);
         }
-
-
     }
 
     /**
@@ -558,18 +443,9 @@
      */
     @PostMapping("/cancel_and_start/{version}")
     @ApiVersion(1)
-    public  String CancelAndStart(HttpServletRequest request){
+    public String CancelAndStart(HttpServletRequest request){
         //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
-        }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
+        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
         conferenceManagerService.CancelAndStart(fse);
         return OK();
     }
@@ -583,18 +459,9 @@
      */
     @PostMapping("/conference_sign/{version}")
     @ApiVersion(1)
-    public  String ConferenceSign(HttpServletRequest request) throws ParseException {
+    public String ConferenceSign(HttpServletRequest request) throws ParseException {
         //鑾峰彇鍙傛暟
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
-        }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
+        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
         String s = conferenceManagerService.ConferenceSign(fse);
         return OK(s);
     }
@@ -608,20 +475,9 @@
     @PostMapping("/get_signOrVisit_info/{version}")
     @ApiVersion(1)
     public String getSignOrVisitInfo(HttpServletRequest request){
-
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
-        }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
+        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
         HashMap signInfo = conferenceManagerService.getSignOrVisitInfo(fse);
         return OK(signInfo);
-
     }
 
     /**
@@ -632,20 +488,8 @@
     @PostMapping("/sendMsg/{version}")
     @ApiVersion(1)
     public String sendMsg(HttpServletRequest request){
-        FieldSetEntity fse = null;
-        Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
-        if (bean != null) {
-            RequestParameterEntity reqp = (RequestParameterEntity) bean;
-            fse = reqp.getFormData();
-        }
-        //鍒ゆ柇鍙傛暟鏄惁涓虹┖
-        if (bean == null || fse == null) {
-            return this.error(com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getValue(), com.product.admin.config.SystemCode.SYSTEM_FORM_NODATA.getText());
-        }
+        FieldSetEntity fse = BaseUtil.getFieldSetEntity(request);
         conferenceManagerService.sendMsg(fse);
         return OK();
     }
-
-
-
 }
diff --git a/src/main/java/com/product/administration/service/ConferenceManagerService.java b/src/main/java/com/product/administration/service/ConferenceManagerService.java
index 0474f56..ccae2fc 100644
--- a/src/main/java/com/product/administration/service/ConferenceManagerService.java
+++ b/src/main/java/com/product/administration/service/ConferenceManagerService.java
@@ -36,6 +36,9 @@
 import java.text.Format;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
+import java.time.DayOfWeek;
+import java.time.LocalDate;
+import java.time.format.DateTimeFormatter;
 import java.util.*;
 
 /**
@@ -211,11 +214,138 @@
     public boolean delConferenceApply(FieldSetEntity fse) throws BaseException {
         return baseDao.delete(fse.getTableName(), fse.getUUID().split(","));
     }
+    
+    @Override
+    @Transactional
+    public DataTableEntity getKanBanData(FieldSetEntity fse) {
+    	String queryStartDate = fse.getString("query_start_date");
+    	String queryEndDate = fse.getString("query_end_date");
+    	StringBuilder sbSql = new StringBuilder();
+    	sbSql.append("SELECT \n");
+    	sbSql.append("    A.meeting_room AS meeting_room_uuid, \n");
+    	sbSql.append("    start_time, \n");
+    	sbSql.append("    end_time, \n");
+    	sbSql.append("    DATE(start_time) as start_date, \n");
+    	sbSql.append("    DATE(end_time) as end_date, \n");
+    	sbSql.append("    TIME(start_time) as start_time_part, \n");
+    	sbSql.append("    TIME(end_time) as end_time_part, \n");
+    	sbSql.append("    HOUR(start_time) as start_hour, \n");
+    	sbSql.append("    HOUR(end_time) as end_hour, \n");
+    	sbSql.append("    DATEDIFF(end_time, start_time) AS diff_day, \n");
+    	sbSql.append("    (SELECT room_name FROM product_oa_conference_room_config WHERE uuid = A.meeting_room) as meeting_room \n");
+    	sbSql.append("FROM product_oa_conference_apply A \n");
+    	sbSql.append("WHERE (end_time >= ? AND start_time <= ?)");
+
+    	DataTableEntity dtRecord = baseDao.listTable(sbSql.toString(), new Object[] {queryStartDate, queryEndDate + " 23:59:59"});
+    	DataTableEntity dtRoom = baseDao.listTable(CmnConst.PRODUCT_OA_CONFERENCE_ROOM_CONFIG, "");
+
+    	// 鍒濆鍖栦細璁璁板綍
+    	Map<String, FieldSetEntity> roomRecord = new HashMap<>();
+    	for (int i = 0; i < dtRoom.getRows(); i++) {
+    	    FieldSetEntity fseRoom = dtRoom.getFieldSetEntity(i);
+    	    FieldSetEntity fseRoomMeeting = new FieldSetEntity(CmnConst.PRODUCT_OA_CONFERENCE_APPLY);
+    	    fseRoomMeeting.setValue("room_name", fseRoom.getString("room_name"));
+    	    fseRoomMeeting.setValue("room_uuid", fseRoom.getString("uuid"));
+    	    roomRecord.put(fseRoom.getString("room_name"), fseRoomMeeting);
+    	}
+
+    	DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
+    	LocalDate queryStart = LocalDate.parse(queryStartDate, formatter);
+    	LocalDate queryEnd = LocalDate.parse(queryEndDate, formatter);
+
+    	// 澶勭悊浼氳璁板綍
+    	for (int i = 0; i < dtRecord.getRows(); i++) {
+    	    FieldSetEntity record = dtRecord.getFieldSetEntity(i);
+    	    String meetingRoom = record.getString("meeting_room");
+    	    if (!roomRecord.containsKey(meetingRoom)) continue;
+    	    
+    	    FieldSetEntity roomMeeting = roomRecord.get(meetingRoom);
+    	    
+    	    String startDateStr = record.getString("start_date");
+    	    String endDateStr = record.getString("end_date");
+    	    String startTime = record.getString("start_time_part");
+    	    String endTime = record.getString("end_time_part");
+    	    int startHour = record.getInteger("start_hour");
+    	    int endHour = record.getInteger("end_hour");
+    	    int diffDay = record.getInteger("diff_day");
+    	    
+    	    LocalDate startDate = LocalDate.parse(startDateStr, formatter);
+    	    LocalDate endDate = LocalDate.parse(endDateStr, formatter);
+    	    
+    	    if (diffDay > 0) {
+    	        // 璺ㄥぉ浼氳 - 澶勭悊姣忎竴澶�
+    	        LocalDate currentDate = startDate.isBefore(queryStart) ? queryStart : startDate;
+    	        LocalDate lastDate = endDate.isAfter(queryEnd) ? queryEnd : endDate;
+    	        
+    	        while (!currentDate.isAfter(lastDate)) {
+    	            DayOfWeek dayOfWeek = currentDate.getDayOfWeek();
+    	            boolean isFirstDay = currentDate.equals(startDate);
+    	            boolean isLastDay = currentDate.equals(endDate);
+    	            
+    	            if (isFirstDay) {
+    	                // 寮�濮嬫棩
+    	                if (startHour < 12) {
+    	                    // 涓婂崍寮�濮嬶紝鎷嗗垎鎴愪笂鍗堟鍜屼笅鍗堝叏澶�
+    	                    addTimeSlot(roomMeeting, dayOfWeek + "_AM", startTime + "-12:00:00");
+    	                    addTimeSlot(roomMeeting, dayOfWeek + "_PM", "12:00:00-00:00:00");
+    	                } else {
+    	                    // 涓嬪崍寮�濮嬶紝鍙湁涓嬪崍娈�
+    	                    addTimeSlot(roomMeeting, dayOfWeek + "_PM", startTime + "-00:00:00");
+    	                }
+    	            } else if (isLastDay) {
+    	                // 缁撴潫鏃�
+    	                // 涓婂崍鍏ㄥぉ
+    	                addTimeSlot(roomMeeting, dayOfWeek + "_AM", "00:00:00-12:00:00");
+    	                if (endHour >= 12) {
+    	                    // 缁撴潫鍦ㄤ笅鍗堬紝鎷嗗垎鎴愪笂鍗堝叏澶╁拰涓嬪崍娈�
+    	                    addTimeSlot(roomMeeting, dayOfWeek + "_PM", "12:00:00-" + endTime);
+    	                }
+    	            } else {
+    	                // 涓棿鏃� - 鍏ㄥぉ
+    	                addTimeSlot(roomMeeting, dayOfWeek + "_AM", "00:00:00-12:00:00");
+    	                addTimeSlot(roomMeeting, dayOfWeek + "_PM", "12:00:00-00:00:00");
+    	            }
+    	            
+    	            currentDate = currentDate.plusDays(1);
+    	        }
+    	    } else {
+    	        // 鍗曞ぉ浼氳
+    	        LocalDate date = LocalDate.parse(startDateStr, formatter);
+    	        DayOfWeek dayOfWeek = date.getDayOfWeek();
+    	        
+    	        if (startHour < 12 && endHour > 12) {
+    	            // 璺ㄤ笂涓嬪崍鐨勪細璁紝鎷嗗垎鎴愪笂鍗堟鍜屼笅鍗堟
+    	            addTimeSlot(roomMeeting, dayOfWeek + "_AM", startTime + "-12:00:00");
+    	            addTimeSlot(roomMeeting, dayOfWeek + "_PM", "12:00:00-" + endTime);
+    	        } else if (startHour < 12) {
+    	            // 绾笂鍗堜細璁�
+    	            addTimeSlot(roomMeeting, dayOfWeek + "_AM", startTime + "-" + endTime);
+    	        } else {
+    	            // 绾笅鍗堜細璁�
+    	            addTimeSlot(roomMeeting, dayOfWeek + "_PM", startTime + "-" + endTime);
+    	        }
+    	    }
+    	}
+
+    	DataTableEntity dtKanBan = new DataTableEntity();
+    	for (FieldSetEntity fseKanban : roomRecord.values()) {
+    	    dtKanBan.addFieldSetEntity(fseKanban);
+    	}
+    	return dtKanBan;
+    }
+
+    private void addTimeSlot(FieldSetEntity roomMeeting, String field, String timeSlot) {
+        String existing = roomMeeting.getString(field);
+        if (StringUtils.isEmpty(existing)) {
+            roomMeeting.setValue(field, timeSlot);
+        } else {
+            roomMeeting.setValue(field, existing + "," + timeSlot);
+        }
+    }
 
     @Override
     @Transactional
-    public List getKbData(FieldSetEntity fse) throws BaseException {
-
+    public List getkbData(FieldSetEntity fse) throws BaseException {
         List<Object>param=new ArrayList<>();
         String meeting_date= fse.getString("meeting_date");
         String meeting_date_end= fse.getString("meeting_date_end");
@@ -232,11 +362,8 @@
                 }else {
                     replace_meeting_resource=replace_meeting_resource+"y.meeting_resource like '%"+split[i]+"%'";
                 }
-
             }
-
         }
-
         StringBuilder bs=new StringBuilder();
         bs.append(" SELECT DISTINCT  g.room_name,g.uuid as meet_room_uuid,DATE_FORMAT(y.start_time, \"%d-%m-%Y %H:%i\")  start_time_format,DATE_FORMAT(y.end_time, \"%d-%m-%Y %H:%i\")  end_time_format,y.* ");
         bs.append(" FROM product_oa_conference_room_config g");
@@ -329,8 +456,8 @@
     @Override
     public List getMeetingDetails(FieldSetEntity fse) throws BaseException {
         String meeting_room = fse.getString("meeting_room");
-        String meeting_date = fse.getString("meeting_date");
-        String meeting_date_end = fse.getString("meeting_date_end");
+        String meeting_start_date = fse.getString("meeting_start_date");
+        String meeting_end_date = fse.getString("meeting_end_date");
         String meeting_resource = fse.getString("meeting_resource");
         String replace_meeting_resource="";
         if(!StringUtils.isEmpty(meeting_resource)){
@@ -342,16 +469,13 @@
                 }else {
                     replace_meeting_resource=replace_meeting_resource+"T1.meeting_resource like '%"+split[i]+"%'";
                 }
-
             }
-
         }
-
-        if(!StringUtils.isEmpty(meeting_room)&&!StringUtils.isEmpty(meeting_date)&&!StringUtils.isEmpty(meeting_date_end)){
+        if(!StringUtils.isEmpty(meeting_room)&&!StringUtils.isEmpty(meeting_start_date)&&!StringUtils.isEmpty(meeting_end_date)){
             List<Object>param=new ArrayList<>();
             param.add(meeting_room);
-            param.add(meeting_date);
-            param.add(meeting_date_end);
+            param.add(meeting_start_date);
+            param.add(meeting_end_date);
             StringBuilder sb=new StringBuilder();
             sb.append(" SELECT b.uuid,DATE_FORMAT(b.start_time, \"%Y-%m-%d\")  start_time,b.start_time start_time1,b.end_time,b.meeting_topic,b.status,b.record_man as record_man_uuid, ");
             sb.append(" (select user_name from product_sys_users where user_id=b.record_man) as record_man,");
diff --git a/src/main/java/com/product/administration/service/ide/IConferenceManagerService.java b/src/main/java/com/product/administration/service/ide/IConferenceManagerService.java
index 13db868..d010b43 100644
--- a/src/main/java/com/product/administration/service/ide/IConferenceManagerService.java
+++ b/src/main/java/com/product/administration/service/ide/IConferenceManagerService.java
@@ -36,8 +36,10 @@
     String saveConferenceApply(FieldSetEntity fse)throws BaseException;
 
     boolean delConferenceApply(FieldSetEntity fse)throws BaseException;
-
-    List getKbData(FieldSetEntity fse)throws  BaseException;
+    
+    List getkbData(FieldSetEntity fse)throws  BaseException;
+    
+    DataTableEntity getKanBanData(FieldSetEntity fse)throws  BaseException;
 
     List getMeetingDetails(FieldSetEntity fse)throws  BaseException;
 

--
Gitblit v1.9.2