From 45430b88dab1451ecff39236dab01d5668b5b9c8 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期三, 21 五月 2025 14:06:22 +0800
Subject: [PATCH] no message

---
 rsf-server/src/main/java/com/vincent/rsf/server/common/utils/FieldsUtils.java |   38 +++++++++++++++++++++++++++++++++++---
 1 files changed, 35 insertions(+), 3 deletions(-)

diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/common/utils/FieldsUtils.java b/rsf-server/src/main/java/com/vincent/rsf/server/common/utils/FieldsUtils.java
index 16a1c10..039e485 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/common/utils/FieldsUtils.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/common/utils/FieldsUtils.java
@@ -1,8 +1,14 @@
 package com.vincent.rsf.server.common.utils;
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.TableInfo;
+import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
+import com.vincent.rsf.framework.common.Cools;
 import com.vincent.rsf.framework.common.SpringUtils;
 import com.vincent.rsf.framework.exception.CoolException;
+import com.vincent.rsf.server.common.domain.BaseParam;
+import com.vincent.rsf.server.common.domain.PageParam;
 import com.vincent.rsf.server.system.entity.Fields;
 import com.vincent.rsf.server.system.entity.FieldsItem;
 import com.vincent.rsf.server.system.service.FieldsItemService;
@@ -107,7 +113,7 @@
                     FieldsItem item = new FieldsItem();
                     item.setUuid(uuid)
                             .setValue(template.get(obj.getFields()).toString())
-                            .setMatnrId(Long.parseLong(template.get("matnrId").toString()))
+                            .setMatnrId(!Objects.isNull(template.get("matnrId")) ? Long.parseLong(template.get("matnrId").toString()) : null)
                             .setFieldsId(obj.getId());
                     fieldsItems.add(item);
                 }
@@ -140,7 +146,7 @@
      * @time 2025/4/7 15:28
      */
     @Transactional(rollbackFor = Exception.class)
-    public static void updateFieldsValue(Map<String, Object> params) throws Exception {
+    public static synchronized  void updateFieldsValue(Map<String, Object> params) throws Exception {
         List<Fields> fields = getFieldsSta();
         if (fields.isEmpty()) { return; }
         Object fieldsIndex = params.get("fieldsIndex");
@@ -174,4 +180,30 @@
             saveFields(params, params.get("index").toString());
         }
     }
-}
+
+    public static <T> QueryWrapper<T> setFieldsFilters(QueryWrapper<T> queryWrapper, PageParam<T, BaseParam> pageParam, Class<T> entityClass) {
+        // 鍔ㄦ�佽幏鍙栬〃鍚�
+        TableInfo tableInfo = TableInfoHelper.getTableInfo(entityClass);
+        String tableName = tableInfo.getTableName();
+
+        FieldsService fieldsService = SpringUtils.getBean(FieldsService.class);
+        Map<String, Object> map = pageParam.getWhere().getFields();
+
+        for (String key : map.keySet()) {
+            Object val = map.get(key);
+            Fields fields = fieldsService.getOne(new LambdaQueryWrapper<Fields>().eq(Fields::getFields, key));
+            if (!Cools.isEmpty(fields)) {
+                String applySql = String.format(
+                    "EXISTS (SELECT 1 FROM sys_fields_item fie " +
+                    "WHERE %s.fields_index IS NOT NULL " +
+                    "AND fie.uuid = %s.fields_index " +
+                    "AND fie.fields_id = '%s' " +
+                    "AND fie.value = '%s')",
+                    tableName, tableName, fields.getId(), val
+                );
+                queryWrapper.apply(applySql);
+            }
+        }
+        return queryWrapper;
+    }
+}
\ No newline at end of file

--
Gitblit v1.9.1