统计分析mapper

{
  "rules": {},
  "responseField": {
    // 首页数据
    "analyze": {
      //控制第三方权限配置
      "presetSql": [
        //{
        //  "connName": "ConnCpc",
        //  "value": "",
        //  "name": ""
        //}
      ],
      // #region 数据二次处理插件
      //请求的结果处理
      //"njcResult": {
      //  "args": [],
      //  "moduleName": "~/Config/AppNodeJs/{ownerId}/plugins/{mkey}/{resField}",
      //  "functionName": null
      //},
      ////请求的参数设置
      //"njcArgs": {
      //  "args": [],
      //  "moduleName": "~/Config/AppNodeJs/{ownerId}/plugins/{mkey}/{resField}-query",
      //  "functionName": null
      //},
      // #endregion 数据二次处理插件
      "guidMethod": "None",
      //来源组合接口
      "dataFromType": "Merge",
      "original": "",
      "auth": true,
      //开启只执行responseField里面配置
      "onlySqlList": true,
      "source": [
        {
          // 我的工厂
          "field": "my",
          "connName": "ConnCpc",
          "dataFromType": "Database",
          //多条数据
          "multi": true,
          "sql": [
            {
              "value": "select count(factory_id) value,audit_status status,'' name,'' sub,'' icon from cpc_ws_factory_user where user_id=@_userId and factory_id not in (select fact_id from cpc_ws_factory where create_user_id=_userId) group by audit_status",
              "sortId": 1
            },
            {
              "value": " union",
              "sortId": 5
            },
            {
              "value": " select count(fact_id) value,4 status,'' name,'' sub,'' icon from cpc_ws_factory where create_user_id=@_userId group by create_user_id",
              "sortId": 10
            }
          ]
        },
        {
          // 申请加入工厂的成员
          "field": "audit",
          "connName": "ConnCpc",
          "dataFromType": "Database",
          //多条数据
          "multi": true,
          //user_type 0 未知 1 管理员 2 法人 3 员工 4 会计 5 财务 6 采购员 7 生产员 8 班长 9 厂长 10 仓管 11 供应商 12 客户
          "sql": [
            {
              "value": "select count(*) value,audit_status status,'' name,'' sub,'' icon  from cpc_ws_factory_user",
              "sortId": 1

            },
            {
              "value": " where audit_status=0",
              "sortId": 5
            },
            {
              "value": " and factory_id in (select factory_id from cpc_ws_factory_user where user_type in (9,1) and user_id=@_userId)",
              "sortId": 10
            }
          ]
        }
      ]
    }
  },
  "columns": {},
  "dimDatas": {}
}