From 9824fc1a7b71cb4d617ea18cab36b8c179e6a37c Mon Sep 17 00:00:00 2001 From: 许鹏程 <1821349743@qq.com> Date: 星期二, 05 十一月 2024 17:34:16 +0800 Subject: [PATCH] commit --- 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