mapper_bo-user_sql__columns.json

身份证性别、行政区、年龄提取

{
  "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
    },
    "birthday": {
      "tableId": 1,
      "extend": {
        "field": "idCard",
        "encDesMethod": "qt2db", //前端加密    qt db  qt2db```asp

        "idCardBirthDay": true, //从身份证里面提取生日信息
        "idCardSex": true, //从身份证里面提取性别 1：男 0：女
        "idCardAreaCode": true //从身份证里面提取性别 提取行政区信息
      },
      "field": "birthday",
      "dataType": "varchar",
      "title": "生日",
      "remark": "生日",
      "name": "birthday",
      "alias": "birthday",
      "isList": false,
      "isDetail": true,
      "isEdit": false,
      "isAdd": false,
      "isData": true,
      "filter": {},
      "editPropertie": {
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 100
    },
  }
}

身份证MD5 加密

"idCardU": {
      "extend": {
        "field": "idCard",
        "encDesMethod": "qt2db", //前端加密    qt db  qt2db
        "idCardBirthDay": true, //从身份证里面提取生日信息
        "idCardSex": true, //从身份证里面提取性别 1：男 0：女
        "idCardMd5": true //身份证信息MD5
      }
    },

唯一信息MD5 加密

"idCardU": {
      "extend": {
        "field": "idCard",
        "uniqueEncMd5": true //信息MD5加密
      }
    },