Mapper

复制后重命名

调整参数

开启

"manager": {
      // #region 开启扩展入库配置
      "saveSqlExtand": true,
      // #endregion 开启扩展入库配置
      "show": "{geography},null lng_lat,business_id,business_name,create_user_id,modify_user_id,audit_user_id,create_date,modify_date,audit_status,audit_date,opinion,img_url,content,area_code,address,tags,vr,ar,video,three_d",
      //geography,lng,lat,
      "bridgeColumn": "lng_lat,is_enabled,business_id,business_name,create_user_id,modify_user_id,audit_user_id,create_date,modify_date,audit_status,audit_date,opinion,img_url,content,area_code,address,tags,vr,ar,video,three_d",
      "original": "is_enabled,0.0 lng,0.0 lat"
    },
    "manager_detail": {
      // #region 开启扩展入库配置
      "saveSqlExtand": true,
      // #endregion 开启扩展入库配置
      "show": "{geography},null lng_lat,business_id,business_name,audit_status,opinion,img_url,content,area_code,address,tags,vr,ar,video,three_d",
      //geography,lng,lat,
      "bridgeColumn": "lng_lat,is_enabled,business_id,business_name,audit_status,opinion,img_url,content,area_code,address,tags,vr,ar,video,three_d",
      "original": "is_enabled,0.0 lng,0.0 lat"
    }

主表开启插入审核日志

1、mall_supplier_audit 替换对应表
2、supplierId替换对应列

{
  // #region 开启扩展入库配置
  "saveSqlExtand": {
    "mall-supplier-audit": {
      "sortId": 1,
      "connName": "ConnMall",
      "sqlUpdate": null,
      "sqlInsert": "insert into mall_supplier_audit (audit_id,audit_user_name,audit_user_id,audit_status,audit_date,opinion,object_id) values  (@_primaryIdV,@_userPushName,@_userId,@auditStatus,@_currentDate,@opinion,@supplierId);"
    }
  }
  // #endregion 开启扩展入库配置
}

column添加列引用

  // #region 审核状态
    "auditUserId": {
      "field": "auditUserId",
      "name": "audit_user_id",
      "alias": "audit_user_id",
      "extend": {
        // 如果opinion有变更，把paramField参数对应的值赋予field
        "paramField": "_userId",
        // 通知列，如果列变更了，通知列需要进行二次变更
        "noticeField": "auditStatus,opinion"
      }
    },
    "auditDate": {
      "field": "auditDate",
      "name": "audit_date",
      "alias": "audit_date",
      "extend": {
        // 如果opinion有变更，把paramField参数对应的值赋予field
        "paramField": "_currentDate",
        // 通知列，如果列变更了，通知列需要进行二次变更
        "noticeField": "auditStatus,opinion"
      }
    }
    // #region 审核状态

重新运行配置