mapper 数据库模板

{
    "diffTableNo": 0,
    "isRESTful": true,
    "base": {
      "connName": "ConnBt",
      "isRearEnd": true,
      "isFrontEnd": true
    },
    "responseField": {
      "statistics-my": {
"njcResult": {
        "args": [],
        "moduleName": "~/Config/AppNodeJs/idc-plugins/dcim-ring-move/cure",
        "functionName": null
      },
      "njcArgs": {
        "args": [],
        "moduleName": "~/Config/AppNodeJs/idc-plugins/dcim-ring-move/cure-query",
        "functionName": null
      },
        "isList": true,
        //自定义SQL语句
        "selectSql": {
          //where tb_f.create_user_id=@_userId  where tb_f.create_user_id=@_userId
          "list": "select family_id,img_url,family_name,(select count(policy_id) from bt_policy tb_p where bt_family.family_id=tb_p.family_id) policy_count,(select count(bd_bbr) from bt_policy tb_p where bt_family.family_id=tb_p.family_id and tb_p.bd_bbr is not null and  tb_p.bd_bbr!='') bbr_count from bt_family",
          "detail": null,
          "page": null,
          "count": null,
          "listField": "*",
          "pageField": "*",
          "detailField": "*"
        }
      },
      "statistics-my-new": {
        //动态构建sql语句方式  start
        "show": "family_id,img_url,family_name,{policy_count},{bbr_count}",
        "where": " and create_user_id=@_userId",
        //动态构建sql语句方式 end
        "isList": true
        //自定义SQL语句  start
        //"selectSql": {
        //  //where tb_f.create_user_id=@_userId
        //  "list": "select family_id,img_url,family_name,{policy_count},{bbr_count} from bt_family ",
        //  "detail": null,
        //  "page": null,
        //  "count": null,
        //  "listField": "*",
        //  "pageField": "*",
        //  "detailField": "*"
        //}
        //自定义SQL语句  end
      }
    },
    "tables": [
      {
        "id": 1,
        //对应表名
        "name": "bt_family",
        "isPrimary": true,
        "primaryColumn": [
          {
            "colName": "family_id",
            "alias": "family_id",
            "field": "familyId"
          }
        ],
        "type": "Table"
      }
    ],
    //统计时候节点可以不要
    "selectSql": {
      "auth": false,
      "primaryWhere": "family_id =@familyId",
      "tableName": "bt_family",
      "order": "family_id",
      "listField": "*",
      "detailField": "*"
    },
    //字段如果没有特殊处理，节点可以不要
    "columns": {
      "imgUrl": {
        "fieldSort": 9999,
        "extendAlias": "image",
        "tableId": 1,
        "dataType": "varchar",
        "title": "图片地址",
        "remark": "图片地址，库里面存储相对路径，返回前台是完整路径",
        "guidMethod": 0,
        "isRequired": false,
        "isData": true,
        "filter": {
          "isMust": false
        },
        "field": "imgUrl",
        "name": "img_url",
        "alias": "img_url",
        "isDate": false,
        "isPrimary": false,
        "isIdentity": false,
        "maxLength": 255
      },
      "policyCount": {
        "extendAlias": "input_basis",
        "fieldSort": 9999,
        "tableId": 1,
        "dataType": "varchar",
        "title": "保单数",
        "isData": false,
        "filter": {
          "isMust": false
        },
        "sql": "(select count(policy_id) from bt_policy tb_p where bt_family.family_id=tb_p.family_id) policy_count",
        "selectSql": {
          "oracle": null,
          "sqlserver": null,
          "mysql": null,
          "sqlite": null
        },
        "field": "policyCount",
        "name": "policy_count",
        "alias": "policy_count",
        "isDate": false,
        "isPrimary": false,
        "isIdentity": false,
        "maxLength": 200
      },
      "bbrCount": {
        "extendAlias": "input_basis",
        "fieldSort": 9999,
        "tableId": 1,
        "dataType": "varchar",
        "title": "被保人数",
        "isData": false,
        "filter": {
          "isMust": false
        },
        "sql": "(select count(bd_bbr) from bt_policy tb_p where bt_family.family_id=tb_p.family_id and tb_p.bd_bbr is not null and  tb_p.bd_bbr!='') bbr_count",
        "selectSql": {
          "oracle": null,
          "sqlserver": null,
          "mysql": null,
          "sqlite": null
        },
        "field": "bbrCount",
        "name": "bbr_count",
        "alias": "bbr_count",
        "isDate": false,
        "isPrimary": false,
        "isIdentity": false,
        "maxLength": 200
      }
    }
  }