多字段模糊查询

  "show": "level,pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,head_icon,'00000000000000000' push_name",

 "pushName": {
      "extendAlias": "search_like",
      "isData": false,
      "tableId": 1,
      "field": "pushName",
      "dataType": "varchar",
      "title": "发布名称",
      "name": "real_name",
      "alias": "push_name",
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "isSearch": true,
      "filter": {
        "method": "like",
        //扩展列 模糊查询  如  (telephone like  '%'+@realName+'%' or real_name like  '%'+@realName+'%')
        "columnName": [ "telephone_suffix", "email", "user_name", "nike_name", "pin_yin", "id_card_suffix" ]
      },
      "maxLength": 200
    },

 "basis": {
      //列表情况默认显示条数，如果自定义通过 参数pageSize控制 
      //"pageSize": 1,
      "bridgeColumn": "address,birthday,city,create_time,email,head_icon,level,id_card,is_guide,is_hide_phone,nike_name,pin_yin,post_code,province,real_name,remark,sex,sort_id,telephone,user_id,view_count,push_name",
      //,image_id,bit_val,distance_val,geography_val,geography_val_text,role_val,json_val,money,
      "auth": true,
      //"show": "user_id,null user_name,{geography_val},null sys_id,null role_id,null dep_id,sex,real_name,telephone,user_status,bit_val,distance_val distance,json_val,is_hide_phone,create_time",
      //"original": "'' account,'' role,'' sys,'' merger,'' job,'' dep,role_val,0.0 lng,0.0 lat,view_count",
      "original": "null account,user_status,null user_name,null dep_id,null role_id,null role,null dep,null area,null job",
      "show": "pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,level,head_icon,'00000000000000000' push_name",
      "all": "",
      "base64": "",
      "field": {
        "sort": {
          "createTime": {
            "column": "create_time",
            "dateDiffMinute": 30
          }
        },
        //手机号编码
        "enc": {
          //"telephone": {
          //  "columnName": "telephone"
          //}
        },
        //字段格式化显示
        "format": {
          "createTime": "yyyy-MM-dd"
        },
        //bit类型转换
        "bit": {
          "bitVal": "bit_val"
        },
        //字符正则方式替换展示
        "rep": {
          //"telephone": [
          //  {
          //    "regex": "\\d",
          //    "key": "",
          //    "value": "#",
          //    "sortId": 1
          //  }
          //]
        },
        //图片补全转换
        "doUrl": {
          "headIcon": {
            "beforeRoot": "beforeRoot:fileWebRoot",
            "beforeChar": []
          }
        },
        //多名字情况，按优先基本有数据展示 
        "doName": {
          "pushName": [
            {
              "name": "push_name",
              "path": "real_name",
              "sortId": 1
            },
            {
              "key": "user_id", //主键别名  使用于  1对1
              "path": "account:nike_name", // : 前面为主表列 ，  后面为1对1里面表列
              "value": "-",
              "sortId": 2
            },
            {
              "path": "email",
              "sortId": 3
            },
            {
              "path": "telephone",
              "value": "-",
              "sortId": 4
            }
          ]
        }
      },
      "where": "{where_sql}",
      "dimField": [ "isHidePhone", "sex" ],
      //添加额外扩展 
      //"where": "{where_sql} and user_id in @fieldWhere",
      //"fieldWhere": {
      //  "filterDemo": {
      //    "enabled": true,
      //    "moduleKey": "",
      //    "responseField": "",
      //    "sql": "aaaadddd"
      //  }
      //},
      //自定义sql方式  sqlPage:[] 优先， 其次： page:"", 最后 动态拼接
      //"selectSql": {
      //  "sqlPage": [
      //    {
      //      "sortId": 1,
      //      "value": "sss"
      //    },
      //    {
      //      "sortId": 0,
      //      "value": "aaa"
      //    }
      //  ],
      //  "sqlDetail": [
      //    {
      //      "sortId": 1,
      //      "value": "sss"
      //    },
      //    {
      //      "sortId": 0,
      //      "value": "aaa"
      //    }
      //  ],
      //  "sqlCount": [
      //    {
      //      "sortId": 1,
      //      "value": "sss"
      //    },
      //    {
      //      "sortId": 0,
      //      "value": "aaa"
      //    }
      //  ],
      //  "sqlList": [
      //    {
      //      "sortId": 1,
      //      "value": "sss"
      //    },
      //    {
      //      "sortId": 0,
      //      "value": "aaa"
      //    }
      //  ]
      //},
      "fieldChild": {
        //1对多  1对1 情况下 继承操作
        "account": {
          "moduleKey": "bo-user-account",
          "responseField": "basis_detail",
          "showMethod": "childobject"
        },
        "role": {
          "moduleKey": "bo-user-role",
          "responseField": "basis_detail"
        }
        //,
        //"roleVal": {
        //  "moduleKey": "bo-sys-role",
        //  "responseField": "user-role"
        //}
      },
      "columns": {
        //"geographyVal": {
        //  "geography": {
        //    "outPut": "lnglat" //lnglat json  geography
        //  }
        //},
        "createTime": {
          "detailPropertie": {
            "showMethodOut": "kv" // n v kv sn
          },
          "addPropertie": {

          },
          "editPropertie": {

          },
          "pagePropertie": {
            "showMethodOut": "kv" // n v kv sn
          },
          "listPropertie": {

          }
        }
        //,
        //"distance": {
        //  "detailPropertie": {
        //    "showMethodOut": "n" // n v kv sn

        //  },
        //  "addPropertie": {

        //  },
        //  "editPropertie": {

        //  },
        //  "pagePropertie": {
        //    "showMethodOut": "kv" // n v kv sn
        //  },
        //  "listPropertie": {

        //  }
        //}
      }
      //,
      ////点击后累加数
      //"viewCount": [
      //  {
      //    "name": "view_count",
      //    "alias": "view_count",
      //    "field": "viewCount"
      //  }
      //]
    },