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 未读取的消息
      ]
    },
文档更新时间: 2022-09-18 13:25   作者:admin