mapper_activity-config_sql__biz.dim.json

{
  "rules": {},
  "responseField": {},
  "columns": {
    "routerSource": {
      "title": "路由来源",
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": ""
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "act-router",
        "allFilter": "type=='source'"
      }
    },
    "routerOs": {
      "title": "来源应用",
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": ""
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "act-router",
        "allFilter": "type=='os'"
      }
    },
    "routerMethod": {
      "title": "跳转方式",
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": ""
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "act-router",
        "allFilter": "type=='method'"
      }
    },
    "activityType": {
      "title": "活动类别",
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": ""
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "activityType"
        //"allFilter": "type=='method'"
      }
    }
  },
  "dimDatas": {
    "act-router": {
      "dataFromType": "ConfigFile",
      "dimCacheKey": "dim-act-router",
      "allSql": "router"
    },
    // #region 活动类别 start
    "activityType": {
      "allSql": "select type_name name,parent_id,type_id id,type_id value from activity_type where {s-if:_fromPrimaryIds} type_id in @_fromPrimaryIds {e-if:_fromPrimaryIds}",
      "connName": "ConnAct",
      "dataFromType": "Database",
      "name": "活动类别",
      "dimCacheKey": "dim-activity-type"
    }
    // #endregion 活动类别
  }
}