app_sql_extend.json

{
  "columns": {
    "insurance_type": {
      "title": "保险种类",
      "alias": "insurance_type",
      "isSearch": true,
      "filter": {
        "method": "iteration",
        //"sql": " and user_id in (select user_id from bo_user_dep where  dep_id in @depId)",
        "tableName": "bt_insurance_type",
        "whereSql": " ",
        "iterationId": "it_id",
        "iterationParentId": "parent_id",
        "connName": null
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "insuranceType"
      }
    }
  },
  "dimDatas": {
    "insuranceType": {
      "allSql": "select it_name name,parent_id,it_id id,it_id value from bt_insurance_type t where is_enabled=1 {s-if:_fromPrimaryIds} and it_id in @_fromPrimaryIds {e-if:_fromPrimaryIds} order by (select max(sort_id) from bt_insurance_type where parent_id=t.it_id),sort_id",
      "connName": "ConnBt",
      "name": "保险种类",
      "dimCacheKey": "dim-insurance_type",
      "fromExtend": true
    }
  }
}