mapperType二次处理（过滤、字段）

项目成员 project_id

    "manager": {
      "guidMethod": 0,
      "guidMethodSn": "none",
      "dataFromType": 0,
      "dataFromTypeSn": "database",
      "viewCountClosed": false,
      "wheres": [
        "{where_sql} ",
        "{s-if:_mapperType}",
        "{op-eq:defv}",
        " and (",
        "   @_developer=1 or create_by=@_userId or create_by in @_mergeUserId",
        "   or project_id in (",
        "     select project_id from pm_project_member where (user_id=@_userId or user_id in @_mergeUserId) and is_enabled=1",
        "   )",
        ")",
        "{op-eq:defv}",
        "{e-if:_mapperType}"
      ]
    },

mappers、wheres

"my": {
      //#region child 1对多/chilobject1对1
      "showExtand": "null reader",
      //reader
      "bridgeColumnExtand": "",
      "fieldChild": {
        "reader": {
          "moduleKey": "bs-msg-notice-site",
          "responseField": "showmy",
          "showMethod": "childobject"
        }
      },
      //#endregion child 1对多/chilobject1对1
      "extend": "basis",
      "auth": true,
      // #region 开启扩展入库配置
      "saveSqlExtand": true,
      // #endregion 开启扩展入库配置
      // #region 移除多余字段
      "bridgeColumnRemoves": "audit_opinion",
      // #endregion 移除多余字段
      // #region 5分钟内数据置顶,sort_id
      "order": "{date_diff_sort},modify_time desc",
      //"whereSql": "{where_sql}",
      "field": {
        "sort": {
          "createTime": {
            "column": "create_time",
            "dateDiffMinute": 5
          }
        }
      },
      // #endregion 5分钟内数据置顶
      //#region _mapperType
      "mappers": {
        // 默认工单
        "default": {
          "columnAlias": "title,sign,open_method,notice_id,img_url,content"
        },
        // 未读的消息
        "0": {
          "columnAlias": "default"
        }
      },
      //#endregion _mapperType
      "wheres": [
        "{where_sql} and audit_status=1",
        // #region 未读取的消息
        "{s-if:_mapperType}",
        "{op-eq:0}",
        //bs_msg_notice.notice_id=bs_msg_notice_site.notice_id and
        " and not exists (select notice_id from bs_msg_notice_site where user_id=@_userId) ",
        "{op-eq:0}",
        "{e-if:_mapperType}"
        // #endregion 未读取的消息
      ]
    },

项目条件

{
  "responseField": {
    "manager": {
      "where": "{where_sql} and (@_developer=1 or create_by=@_userId  or create_by in @_mergeUserId)",
      "searchColumnRemoves": "",
      "showExtand": "'' users,'' installs,'' pays,'' views,'' files,'' steps,'' needs,'' tasks",
      "bridgeColumnExtand": "users,installs,pays,views,files,steps,needs,tasks",
      "extend": "basis",
      "auth": true,
      "columns": {},
      "order": "{date_diff_sort},update_time desc",
      "field": {
        "sort": {
          "createTime": {
            "column": "create_time",
            "dateDiffMinute": 5
          }
        }
      },
      "wheres": [
        "{where_sql} ",
        "{s-if:_mapperType}",
        "{op-eq:defv}",
        " and (",
        "   @_developer=1 or create_by=@_userId or create_by in @_mergeUserId",
        "   or create_by in (",
        "     select user_id from pm_project_member where (user_id=@_userId or user_id in @_mergeUserId) and is_enabled=1",
        "   )",
        ")",
        "{op-eq:defv}",
        "{e-if:_mapperType}"
      ]
    },
    "manager_detail": {
      "guidMethod": 0,
      "guidMethodSn": "none",
      "dataFromType": 0,
      "dataFromTypeSn": "database",
      "viewCountClosed": false
    }
  },
  "saveSqlExtand": {},
  "dimDatas": {},
  "rules": {}
}