app_sql_extend.json

{
  "columns": {
    "insurance_company": {
      "title": "保险公司",
      "alias": "insurance_company",
      "isSearch": true,
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "dimJoin": {
        "fromDimField": "insuranceCompany"
      }
    }
  },
  "dimDatas": {
    "bzJfMethod": {
      //MapperDim/Basis/mapper_dim_sys-type.json
      "dataFromType": "ConfigFile",
      "allSql": "bz-jf-method",
      "name": "缴费方式",
      "fromExtend": true
    },
    "insuranceCompany": {
      "allSql": "select ic_name name,ic_id id,0 parent_id,ic_id value from bt_company t {s-if:_fromPrimaryIds} where  ic_id in @_fromPrimaryIds {e-if:_fromPrimaryIds} order by sort_id",
      "connName": "ConnBt",
      "name": "保险公司",
      "dimCacheKey": "dim-insurance_comany",
      "fromExtend": true
    }
  }
}