mapper_mall-business_sql__responsefield.json

{
  "responseField": {
    // #region 查找带回
    "manager-business-all": {
      "auth": true,
      "show": "business_id,business_name,null right_business_id",
      "original": "",
      "extend": "basis",
      "order": "business_id",
      "where": " {where_sql} and is_enabled=1 and audit_status=1",
      "fieldChild": {}
    }
    // #endregion 查找带回
  },
  "columns": { 
    // #region 查找带回
    "rightBusinessId": {
      "fieldSort": 9999,
      "tableId": 1,
      "dataType": "varchar",
      "title": "右侧市场",
      "remark": "用于搜索",
      "guidMethod": "None",
      "isRequired": false,
      "isSearch": true,
      "isData": false,
      "editPropertie": {
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethod": "text"
      },
      "filter": {
        "method": "custom",
        "isMust": false,
        //"sql": " and parent_id in (select menu_id from bo_sys_menu where menu_name like CONCAT('%',@parentName,'%'))",
        //如果 sqlCustom 没找到,使用 sql     sqlserver   mysql  oracle sqlite  SqlCustom
        "sqlCustom": {
          "mysql": " and business_id<>@rightBusinessId",
          "oracle": "",
          "sqlserver": ""
        }
      },
      "field": "rightBusinessId",
      "name": "right_business_id",
      "alias": "right_business_id",
      "isDate": false,
      "isPrimary": false,
      "isIdentity": false,
      "maxLength": 50
    }
    // #endregion 查找带回
  }
}