From c18646fe51ad7f329a3430faa56bf0335f8f80f9 Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期一, 17 十一月 2025 13:59:32 +0800
Subject: [PATCH] 列表搜索，取列表别名错误
---
src/main/java/com/product/face/service/FaceApplyService.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/product/face/service/FaceApplyService.java b/src/main/java/com/product/face/service/FaceApplyService.java
index 53392e5..ccc6406 100644
--- a/src/main/java/com/product/face/service/FaceApplyService.java
+++ b/src/main/java/com/product/face/service/FaceApplyService.java
@@ -6,6 +6,7 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.serializer.SerializerFeature;
+import com.aspose.slides.p2cbca448.and;
import com.google.common.collect.Lists;
import com.product.admin.service.SystemFaceService;
import com.product.common.lang.StringUtils;
@@ -79,4 +80,33 @@
return BaseUtil.success(faceFormCache.getData(), MapUtil.builder("drawingList", (Object) faceFormCache.getDrawingList()).map());
}
+ public List<String> getFaceReference(FieldSetEntity fse) throws BaseException {
+ String faceNumber = fse.getString("face_number");
+ if (StringUtils.isEmpty(faceNumber)) {
+ return null;
+ }
+ String[] faceNumberArr = faceNumber.split(",");
+ StringBuilder sql = new StringBuilder();
+ sql.append(" select case when c.property_value like '%prompt' then a.property_value else concat('銆�',a.property_value,'銆�') end as property_value from product_sys_face_control_property a ");
+ sql.append(" join product_sys_face_control_property b on a.group_uuid=b.group_uuid and a.uuid!=b.uuid ");
+ sql.append(" join product_sys_face_control_property c on b.uuid=c.parent_uuid ");
+ sql.append(" where a.property_name='advanceName' and a.master_uuid in (SELECT uuid from product_sys_face where face_type=2 and ").append(BaseUtil.buildQuestionMarkFilter("face_number", faceNumberArr.length, true)).append(") ");
+ sql.append(" and b.property_name='__config__' and c.property_name='tag' GROUP BY 1 ");
+
+
+ DataTableEntity dte = getBaseDao().listTable(sql.toString(), faceNumberArr);
+
+
+ List<String> list = Lists.newArrayList();
+
+ if (DataTableEntity.isEmpty(dte)) {
+ return list;
+ }
+
+ for (int i = 0; i < dte.getRows(); i++) {
+ FieldSetEntity fs = dte.getFieldSetEntity(i);
+ list.add(fs.getString("property_value"));
+ }
+ return list;
+ }
}
--
Gitblit v1.9.2