设置前效果
数据库字典值数据插入(新建需要替换对应的值)
1、smdcm_auth_bo 中 bo_sys_enum_sign
2、smdcm_auth_bo 中 bo_sys_enum
insert into bo_sys_enum(enum_vt,enum_id,sign_id,enum_value,enum_name, first_pinyin,enum_vn,enum_vd,enum_vs,enum_ve,sort_id,is_enabled)
select DISTINCT null enum_vt,CONCAT('221',LPAD('0',2,'0')) enum_id,221 sign_id,0 enum_value,'未知' enum_name,null first_pinyin,null enum_vn,null enum_vd,null enum_vs,null enum_ve,22100 sort_id,1 is_enabled
union
select DISTINCT null enum_vt,CONCAT('221',LPAD('1',2,'0')) enum_id,221 sign_id,'1' enum_value,'拜经' enum_name,null first_pinyin,null enum_vn,null enum_vd,null enum_vs,null enum_ve,12101 sort_id,1 is_enabled
union
select DISTINCT null enum_vt,CONCAT('221',LPAD('2',2,'0')) enum_id,221 sign_id,'2' enum_value,'拜忏' enum_name,null first_pinyin,null enum_vn,null enum_vd,null enum_vs,null enum_ve,12102 sort_id,1 is_enabled
1、进入接口工具(form-bs-select-boenums)mapper
mapper配置(mapper_zt-scripture_sql__biz.dimboenums.json)
C:\0_RG\Code\RG6.PF\rg3-pf\RG3.Web.Host.PaaS\Config\Mapper\basis\zentao\mapper_zt-scripture_sql__biz.dimboenums.json
{
"rules": {},
"responseField": {},
"columns": {
"vipLevel": {
"filter": {
"method": "eq"
},
"editPropertie": {
"showMethodOut": "kv",
"showMethod": "text",
"type": null,
"format": null,
"defaultValue": null
},
"pagePropertie": {
"showMethodOut": "kv",
"showMethod": "text",
"type": null,
"format": null,
"defaultValue": null
},
"dimJoin": {
"fromDimField": "sysEnum",
"allFilter": "parent_id==122"
},
"dimSqlRep": [
{
"key": "_fromPrimaryIds",
"value": "_filterDimVipLevel",
"name": "vipLevel",
"alias": "vip_level"
}
],
"tableId": 1,
"isData": true,
"isList": false,
"maxLength": 2
}
},
"dimDatas": {}
}
推送并令配置生效(build-mapper-used)
http://localhost:5775/auth/main-content
2、进入接口工具(form-bs-select-boenums)bridge
bridge配置(bridge_zt-scripture__biz.dimboenums.json)
C:\0_RG\Code\RG6.PF\rg3-pf\RG3.Web.Host.PaaS\Config\Bridge\basis\zentao\bridge_zt-scripture__biz.dimboenums.json
替换zt-scripture、vipLevel、vip_level、VIP等级
dimDataType 根据实际改成int 或string
{
"table": {
"columns": {
"vipLevel": {
"dim-data-name": null,
"sortId": 9999,
"alias": "vip_level",
"field": "vipLevel",
"events": {},
"attrs": {
"type": "main",
"label": "VIP等级",
"maxlength": 10,
"clearable": 10,
"multiple": false,
"remote": true,
"filterable": true
},
"meta": {
"edit": true,
"fromValue": true,
"dimSessionKey": "dim-zt-scripture",
"dimLocalKey": "dim-zt-scripture",
"dimMkey": "zt-scripture",
"dimResField": "manager",
"dimColumnField": "vipLevel",
"dimDataType": "int", //int string
"dimRemote": true,
"dimUrl": null,
"prop": "vipLevel",
"rowId": 1,
"type": "basis",
"span": 12,
"auth": true,
"component": "bs-text",
"componentOp": "bs-select"
}
}
}
},
"form": {
"columns": {
"vipLevel": {
"sortId": 9999,
"alias": "vip_level",
"field": "vipLevel",
"events": {},
"attrs": {
"label": "VIP等级",
"maxlength": 10,
"clearable": 10,
"multiple": false,
"remote": true,
"filterable": true
},
"meta": {
"edit": true,
"fromValue": true,
"dimSessionKey": "dim-zt-scripture",
"dimLocalKey": "dim-zt-scripture",
"dimMkey": "zt-scripture",
"dimResField": "manager",
"dimColumnField": "vipLevel",
"dimDataType": "int",
"dimRemote": true,
"dimUrl": null,
"prop": "vipLevel",
"rowId": 1,
"type": "basis",
"span": 12,
"auth": true,
"component": "bs-select"
}
}
}
},
"search": {
"columns": {
"vipLevel": {
"sortId": 10000,
"alias": "vip_level",
"field": "vipLevel",
"events": {},
"attrs": {
"placeholder": "VIP等级",
"label": "VIP等级",
"maxlength": 10,
"clearable": true,
"component-type": "custom",
"lazy-renger": true,
"multiple": false
},
"attrsInt": {},
"meta": {
"fromValue": true,
"dimSessionKey": "dim-zt-scripture",
"dimLocalKey": "dim-zt-scripture",
"dimMkey": "zt-scripture",
"dimResField": "manager",
"dimColumnField": "vipLevel",
"dimDataType": "int",
"dimRemote": true,
"dimUrl": null,
"prop": "vipLevel",
"rowId": 1,
"type": "basis",
"span": 12,
"auth": true,
"component": "bs-select"
}
}
}
}
}
推送并令配置生效(build-bridge-used)
http://localhost:5775/auth/main-content
设置后效果
文档更新时间: 2023-06-12 11:17 作者:admin