@lina
2022-07-01T07:03:32.000000Z
字数 5665
阅读 265
@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": ""
}