自定义SQL权限过滤

sql

 "childCount": {
      "extendAlias": "input_basis",
      "fieldSort": 9999,
      "tableId": 1,
      "dataType": "varchar",
      "title": "子系统数",
      "isData": false,
      "filter": {
        "isMust": false
      },
      "sql": "(select count(sys_id) from bo_system tb_child where tb_child.parent_id=bo_system.sys_id) child_count",
      "selectSql": {
        "oracle": null,
        "sqlserver": null,
        "mysql": null,
        "sqlite": null
      },
      "field": "childCount",
      "name": "child_count",
      "alias": "child_count",
      "isDate": false,
      "isPrimary": false,
      "isIdentity": false,
      "maxLength": 200
    }
  },

“showExtand”: “{child_count}

{
  "responseField": {
    "global": {
      "dataFromType": "Database",
      "show": "sys_id",
      "auth": true
    },
    "manager": {
      "where": "{where_sql} and (@_developer=1 or create_user_id=@_userId  or create_user_id in @_mergeUserId)",
      "bridgeColumnRemoves": "",
      "showExtand": "{child_count},null parent_name,'' users,'' roles,'' deps,'' cults,'' areas,'' menus",
      "bridgeColumnExtand": "child_count,parent_name,users,roles,deps,cults,areas,menus",
      "searchColumnRemoves": "",
      "extend": "basis",
      "auth": true,
      "columns": {},
      "order": "{date_diff_sort},modify_time desc",
      "field": {
        "sort": {
          "createTime": {
            "column": "create_time",
            "dateDiffMinute": 5
          }
        }
      },
      "wheres": [
        "{where_sql} ",
        "{s-if:_mapperType}",
        "{op-eq:defv}",
        " and (",
        "   @_developer=1 or create_user_id=@_userId or create_user_id in @_mergeUserId",
        "   or create_user_id in (",
        "     select user_id from bo_user_system where (user_id=@_userId or user_id in @_mergeUserId) and is_enabled=1",
        "   )",
        ")",
        "{op-eq:defv}",
        "{e-if:_mapperType}"
      ]
    },
    "manager_detail": {
      "bridgeColumnExtand": "",
      "showExtand": "",
      "extend": "basis_detail",
      "auth": true,
      "field": {
        "query": {
          "parentId": "parentId"
        }
      },
      "fieldChild": {}
    }
  }
}