mapper_mall-supplier-user_sql__responsefield.json

{
  "responseField": {
    "global": {
      "dataFromType": "Database",
      "show": "su_id",
      "auth": true
    },    
    // #reigon 1对多配置
    "manager": {
      "where": " {where_sql} and supplier_id = @supplierId"
    },
    "supplier_detail": {
      "guidMethod": "None",
      "dataFromType": "Database",
      "extend": "basis_detail",
      "bridgeColumn": "su_id,supplier_id,user_id,user_show_name,user_type,is_enabled",
      "auth": true,
      "viewCountClosed": false,
      "where": "and supplier_id in @_filterPrimaryIds",
      "saveSqlPrimary": {
        //"primaryWhere": " monitor_id = @monitorId and data_date = @dataDate  ",
        "primaryWhere": " supplier_id = @supplierId and user_id = @userId ",
        "primaryColumn": [
          {
            "colName": "supplier_id",
            "field": "supplierId", //存储子表里面关联主表对应的字段列
            "isIdentity": false,
            "primaryColumn": "supplier_id",
            "primaryField": "supplierId", //来源主表的字段列
            "tableId": 1
          }
        ],
        "childPrimaryColumn": [
          {
            //多对多情况关联表主键
            "colName": "supplier_id",
            "field": "supplierId",
            "tableId": 1
          },
          {
            //多对多情况关联表主键
            "colName": "user_id",
            "field": "user_Id",
            "tableId": 1
          }
        ]
      },
      "columns": {
        "suId": {
          //每次保存时候都重置主键，用于多列更新
          "guidMethod": "NEW_ID"
        }
      }
    }
    // #endreigon 1对多配置
  }
}