mapper_bt-insurance-resource_sql__biz.encryption

{
  "rules": {
    "idCard": [
      {
        "type": "maxlength",
        "max": 36,
        "isAdd": true,
        "isEdit": true,
        "message": "【身份证】最大长度为36。"
      },
      {
        "type": "idcard",
        "max": 36,
        "isAdd": true,
        "isEdit": true,
        "message": "【身份证】格式不正确。"
      }
      //,
      //{
      //  "type": "db", //验证身份证号
      //  "url": "~/bo/api/v3/remote/unique/{mkey}/{resField}?ownerId={ownerId}&sysId={sysId}&rule={rule}&{params}",
      //  "sql": "select count(id_card) from bo_user where id_card=@idCard {s-if:userId} and user_id<>@userId {e-if:userId} ",
      //  "isAdd": true,
      //  "isEdit": true,
      //  "message": "【身份证】已存在。"
      //}
    ],
    "telephone": [
      //{
      //  "type": "loadPswd",
      //  "max": 11,
      //  "isEdit": true,
      //  "isAdd": true,
      //  "message": "【手机号码】格式不正确。"
      //},
      {
        "type": "maxlength",
        "max": 11,
        "isEdit": true,
        "isAdd": true,
        "message": "【手机号码】最大长度为11。"
      },
      {
        "type": "mobile",
        "max": 11,
        "isEdit": true,
        "isAdd": true,
        "message": "【手机号码】格式不正确。"
      }
      //,
      //{
      //  "type": "db", //remote db  远程验证 rule 和 sql必须填写；  db：sql必须填写
      //  "url": "~/bo/api/v3/remote/unique/{mkey}/{resField}?ownerId={ownerId}&sysId={sysId}&rule={rule}&{params}",
      //  "sql": "select count(telephone) from bo_user where telephone=@telephone {s-if:userId} and user_id<>@userId {e-if:userId} ",
      //  "isAdd": true,
      //  "isEdit": true,
      //  "message": "【手机号码】已存在。"
      //}
    ]
  },
  "responseField": {},
  "columns": {
    "idCard": {
      "tableId": 1,
      "encDesMethod": "qt2db", //前端加密 和 后端 加密    qt db  qt2db
      "field": "idCard",
      "dataType": "varchar",
      "title": "身份证号",
      "remark": "身份证号",
      "name": "id_card",
      "alias": "id_card",
      "isList": false,
      "isDetail": true,
      "isEdit": false,
      "isAdd": false,
      "isData": true,
      "filter": {},
      //加密前截取后缀用于查询
      "suffix": {
        "field": "idCardSuffix",
        "alias": "id_card_suffix",
        "name": "id_card_suffix",
        "length": 6
      },
      "editPropertie": {
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 100
    },
    "telephone": {
      "tableId": 1,
      "encDesMethod": "qt2db", //qt2db  qt  db
      "field": "telephone",
      "dataType": "varchar",
      "title": "手机号",
      "remark": "手机号",
      "name": "telephone",
      "alias": "telephone",
      "isList": false,
      "isDetail": true,
      "isEdit": false,
      "isAdd": false,
      "isData": true,
      //加密前截取后缀用于查询
      "suffix": {
        "field": "telephoneSuffix",
        "alias": "telephone_suffix",
        "name": "telephone_suffix",
        "length": 4
      },
      "filter": {},
      "editPropertie": {
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 100
    }
  },
  "dimDatas": {}
}