简要描述：

  • 【活动】乱序抽奖，当前活动配置数据

接口版本：

版本号 制定人 制定日期 修订日期
v3 陈碧贵 2024-01-01 xxxx-xx-xx

请求URL:

请求方式：

  • POST

请求头：

参数名 是否必须 类型 说明
XownerId 是 string 项目唯一ID,对应bo_project {ownerId}
XsysId 否 string 所属系统 对应 bo_system 表
XuserFromFirstShareId string 否 一级分享用户ID， bo_user user_id
XuserFromSecondShareId string 否 二级分享用户ID， bo_user user_id
XverifyApi 是 string 加密规则encryptByDES(`${newGuid()}
XfilterAreaCode 否 string 行政区编码， 对应 bo_sys_area area_code
Content-Type: 是 string application/json; charset=utf-8 请求类型

请求参数:

{}
参数名 是否必须 类型 说明
roundId 是 int 轮次编号
activityId 是 string 活动编号
_nodejs 是 string common-data 对应/Config/AppNodeJs/Plugins/fn- common-data.js， 通过nodejs插件，对响应结果进行二次处理 common-data 普通数据（小写驼峰）common-data-under 普通数据下划线

返回示例:

正确时返回:

{
    "data": [
        {
            "id": "4248218677855391745",
            "value": "4248218677855391745",
            "name": "活动标题",
            "type": "config",
            "activityId": "4248218677855391745",
            "diffTableNo": 0,
            "startDate": {
                "name": "2024-01-26 02:02:02",
                "value": "2024-01-26T02:02:02"
            },
            "endDate": {
                "name": "2024-01-24 00:00:00",
                "value": "2024-01-24T00:00:00"
            }
        },
        {
            "id": "4260202088757202945",
            "status": 1,
            "count": 1,
            "value": "4260202088757202945",
            "name": "第二轮",
            "type": "round",
            "activityId": "4260202088757202945",
            "diffTableNo": 0,
            "startDate": {
                "name": "2024-02-01 00:00:00",
                "value": "2024-02-01T00:00:00"
            },
            "endDate": {
                "name": "2024-01-31 00:00:00",
                "value": "2024-01-31T00:00:00"
            }
        },
        {
            "id": "4259109054598615048",
            "value": "pv",
            "type": "lottery",
            "activityId": "4259109054598615048",
            "diffTableNo": 0,
            "startDate": {},
            "endDate": {},
            "bizUserId": {
                "name": "开发管理员",
                "value": "pv",
                "path": "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLgZK43CgcILomCcd3JuydTkl29ARyt3dajia3QNGIwCmwd1lu0vzdPcIQjOqMY2CQibJFzoHYybZAA/132"
            }
        },
        {
            "id": "4259109054598615048",
            "value": "pv",
            "type": "sign",
            "activityId": "4259109054598615048",
            "diffTableNo": 0,
            "startDate": {},
            "endDate": {},
            "bizUserId": {
                "name": "开发管理员",
                "value": "pv",
                "path": "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLgZK43CgcILomCcd3JuydTkl29ARyt3dajia3QNGIwCmwd1lu0vzdPcIQjOqMY2CQibJFzoHYybZAA/132"
            }
        }
    ],
    "currentDay": "2024-01-01",
    "cacheDateTimestamp": 0,
    "code": "0",
    "retCode": "0",
    "success": true
}

错误时返回:

{
    "code": 0,
    "message": ""
    "error":{
      errorCode:null，
      errorText:null
    }
    "success": false,
}

返回参数说明:

参数名 类型 说明
success bool true 表示数据请求成功（跟code=0一致）,调用者优先使用
code int true 表示数据请求成功（跟code=0一致）,调用者优先使用
data array type: sign签到，round轮次，config活动配置，lottery抽奖记录
cacheType string redis/sqlite/local 数据来源缓存 的类型（便于开发调试和性能优化）
cacheDate date 最后数据获取时间
参数名 类型 说明
bizUserId object 用户信息
type string 数据类别标识
status int 数据状态

活动mapper_activity-config_sql__responsefield.json

"lottery": {
  "isList": true,
  //不使用分页拼接 SQL语句
  "selectSql": {
    "page": null,
    "detail": null,
    "list": null,
    "auth": true,
    "sqlList": [
      {
        "value": "select * from (",
        "sortId": 1
      },
      {
        "value": "select  null biz_user_id,activity_id,activity_id id,0 status,0 count,ACTIVITY_ID value,ACTIVITY_NAME name,ACTIVITY_START_DATE start_date,ACTIVITY_END_DATE end_date, 'config' type from activity_config where ACTIVITY_ID=@activityId and  IS_ENABLED =1",
        "sortId": 2
      },
      {
        "value": " union all ",
        "sortId": 3
      },
      {
        "value": "{s-if:roundId} select null biz_user_id,round_id activity_id,round_id id,status,award_num num,round_id value,round_name  name,start_date start_date,end_date end_date, 'round' type from activity_lottery_round where round_id=@roundId union all {e-if:roundId}",
        "sortId": 4
      },
      {
        "value": "select CREATE_USER_ID biz_user_id,log_id activity_id,log_id id,0 status,0 num,CREATE_USER_ID value,null name,null start_date,null end_date, 'sign' type from activity_logs_sign where ACTIVITY_ID=@activityId  and  IS_ENABLED =1",
        "sortId": 5
      },
      {
        "value": " union all ",
        "sortId": 6
      },
      {
        "value": " select  CREATE_USER_ID biz_user_id,log_id activity_id,log_id id,status,0 num,CREATE_USER_ID value,null name,null start_date,null end_date, 'lottery' type from activity_lottery_log where ACTIVITY_ID=@activityId {s-if:roundId} and round_id=@roundId {e-if:roundId} ",
        "sortId": 7
      },
      {
        "value": ") t",
        "sortId": 8
      }
    ],
    "count": null,
    "show": "biz_user_id,activity_id,id,status,count,value,name,start_date,end_date,type",
    "listField": "*",
    "pageField": "*",
    "detailField": "*"
  }
}
文档更新时间: 2024-01-10 13:28   作者：admin