@lina
2022-07-01T07:03:32.000000Z
字数 5665
阅读 210
@lina 2022-06-16 15:27
1.1 API Base Url
【测试url】https://hwl.guangying.link/api/
【线上url】
1.2 header头 token验证
X-auth-token : [string] 登录后获取的 session_token 信息, 取window.token 请求头带此字段
1 答题表
id
int(11) NOT NULL AUTO_INCREMENT,
day_id
int(11) NOT NULL COMMENT 'dayid',
grade_id
int(11) NOT NULL COMMENT '班级id',
subject
varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '题目',
option
varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '选项',
created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
答题记录表
id
int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
user_id
int(11) NOT NULL COMMENT '用户ID',
day_id
int(5) NOT NULL COMMENT '第几天题库',
grade_id
int(5) NOT NULL COMMENT '年级id',
coin
int(11) NOT NULL DEFAULT '0' COMMENT '获取金币',
wrong
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '错题',
created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
获取金币记录表
id
int(11) NOT NULL AUTO_INCREMENT,
user_id
int(11) NOT NULL COMMENT '用户id',
content
varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '内容',
coin
int(11) NOT NULL COMMENT '金币',
type
int(5) NOT NULL COMMENT '1提交答案,2关注,3邀请',
created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
id
int(11) NOT NULL AUTO_INCREMENT, grade_id
int(11) DEFAULT NULL COMMENT '年级id', day
varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '天数', created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',id
int(11) NOT NULL AUTO_INCREMENT, grade
varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '年级', created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',id
int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', coin
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '金币', group
varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '组名', created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,id
int(11) NOT NULL AUTO_INCREMENT, open_id
char(64) CHARACTER SET utf8mb4 NOT NULL, union_id
char(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '开放平台的唯一标识符', grade_id
int(5) NOT NULL COMMENT '班级id', session_key
char(64) CHARACTER SET utf8mb4 NOT NULL, session_token
char(64) CHARACTER SET utf8mb4 NOT NULL, invite_num
int(5) NOT NULL DEFAULT '0' COMMENT '邀请人数', name
char(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '孩子名称', phone
varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '手机号', coin
int(11) NOT NULL DEFAULT '0' COMMENT '金币', follow_status
tinyint(4) NOT NULL COMMENT '0未关注 1已关注微信公众号', status
tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未绑定 1已绑定', last_date
date DEFAULT NULL COMMENT '上一次答题时间', group
varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '获取金币组', answer_num
int(5) NOT NULL DEFAULT '0' COMMENT '答题次数', created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,请求URL
GET
api/login
请求参数
响应
{
"status": 0,
"msg": "获取成功",
"data": {
"sessionToken":"c6beae16acf7fa4f71c33650bdf19c3f"
}
请求URL
GET
api/Home
请求参数
响应
{
"status": 0,
"msg": "获取成功",
"data": {
"grade": [ //年级
{
"id": 1, //年级id
"grade": "grade 1" //年级名称
}
],
"day": [ //天
{
"id": 1, //day_id
"day": "day 1", //天名称
"grade_id": 1 , //所属天的年级ID
"status":1 //1=已完成 0 = 未完成
},
{
"id": 2,
"day": "day 2",
"grade_id": 1,
"status":0
}
],
"share": [
{
"invite_num": 1, //邀请人数
"coin":20 //获取的金币
}
],
"user": {
"open_id": "o5RBi5EH2dc5SkQjJvo_ZPExmX2w",
"invite_num": 1, //邀请人数
"follow_status": 1, //0未关注 1已关注微信公众号
"status": 0, //0未绑定 1已绑定
"phone": "13466667777", //手机号
"name": "[\"姓名1\",\"姓名2\"]", //孩子名称
"grade_id": 1, //年级id 未选择=''
"grade": "grade 1" //年级名称 未选择=''
}
}
}
请求URL
GET
api/Answer
请求参数
day_id: [int] 天id
grade_id: [int] 年级ID
响应
{
"status": 0,
"msg": "获取成功",
"data": [
{
"id": 1,
"day_id": 1,
"grade_id": 1,
"subject": {
"subject": "Calculate: 16 + 7 + 3 =",
"img": []
},
"option": [
{
"key": "A",
"value": "10",
"type": "text"
},
{
"key": "B",
"value": "16",
"type": "text"
},
{
"key": "C",
"value": "25",
"type": "text"
},
{
"key": "D",
"value": "26",
"type": "text"
}
],
"answer": "D",
"created_at": "2022-06-13 15:08:21",
"updated_at": "2022-06-27 22:47:35"
},
.....
}
请求URL
post
api/Grade
请求参数
grade_id: [int] 年级ID
响应
{
"status": 0,
"msg": "绑定成功",
"data": [],
}
请求URL
post
api/AnwserSubmit
请求参数
day_id: [int] 1
grade_id: [int] 1
wrong: [array] [{"id":"1","option":"C"},{"id":"2","option":"B"}]
响应
{
"status": 0,
"msg": "提交成功",
"data": {
"coin": "200",//当前获取金币
"total_coin": 200,//累计获取金币
"rightCount": 3//答题正确数量
"answer": [ //答题历史
{
"id": 1,
"subject_name": "{\"subject\":\"ceshitimu\",\"img\":[\"https:\\/\\/yuandajiaixao.oss-cn-hangzhou.aliyuncs.com\\/routePic\\/2022-04\\/747711649581120.jpg\"]}",//问题
"option": "{"A":"daan1","B":"dana2","C":"daan3","D":"daan4","answer":"A","wrong":"B","type":"text"}", //答案 wrong =错题选项
},
.....
}
}
请求URL
get
api/AnwserNote
请求参数
day_id: [int] 天id
响应
{
"status": 0,
"msg": "提交成功",
"data": [
{
"id": 1,
"subject": {
"subject": "Calculate: 16 + 7 + 3 =",
"img": []
},
"option": [
{
"key": "A",
"value": "10",
"type": "text"
},
{
"key": "B",
"value": "16",
"type": "text"
},
{
"key": "C",
"value": "25",
"type": "text"
},
{
"key": "D",
"value": "26",
"type": "text"
}
],
"answers": {
"right_key": "D",
"answer_key": "C"
}
},
.....
}
}
请求URL
GET
/api/CoinList
请求参数
响应
{
"status": 0,
"msg": "获取成功",
"data": {
"list": [
{
"id": 77,
"content": "第3天答题奖励",
"coin": 400,
"date": "2022-06-24 16:26:42"
},
{
"id": 76,
"content": "第2天答题奖励",
"coin": 200,
"date": "2022-06-24 16:26:39"
},
{
"id": 75,
"content": "第1天答题奖励",
"coin": 300,
"date": "2022-06-24 16:26:37"
}
],
"coinTotal": 6700
}
}
请求URL
post
api/Bind
请求参数
phone: [string] 13466667777
name: [array] ["姓名1","姓名2"]
academy_status[int] 是否绑定academy 默认0 ,1=已绑定
ascription[string] +86
响应
{
"status": 0,
"msg": "绑定成功",
"data": ""
}
请求URL
get
api/Share
请求参数
响应
{
"status": 0,
"msg": "关联成功",
"data": ""
}
请求URL
get
api/Share
请求参数
响应
{
}
请求URL
get
api/ShareData
请求参数
open_id: oFaJb0UsnMVGIbq9ZIwZKAqlQoZY
响应
{
"status": 0,
"msg": "关联成功",
"data": ""
}