设置前效果

数据库字典值数据插入(新建需要替换对应的值)

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 根据实际改成intstring
{
  "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