UpdateAccount.js 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. const API = require("../../lib/API.js")
  2. const db = require("../../plugin/DataBase/db.js")
  3. const axios = require('axios')
  4. const EmailTemplate = require('../../plugin/Email/emailTemplate')
  5. const config = require('../../config.json')
  6. const { BaseStdResponse } = require("../../BaseStdResponse.js")
  7. // 客户端上传数据接口
  8. class UpdateAccount extends API {
  9. constructor() {
  10. super();
  11. this.setPath('/Lepao/UpdateAccount')
  12. this.setMethod('POST')
  13. }
  14. async onRequest(req, res) {
  15. let { reqData, resData } = req.body
  16. if ([reqData, resData].some(value => value === '' || value === null || value === undefined))
  17. return res.json({
  18. ...BaseStdResponse.MISSING_PARAMETER,
  19. endpoint: 1513126
  20. })
  21. try {
  22. const endpoint = config.runpy + '/decrypted_data'
  23. const ReqData = await axios.post(endpoint, { data: reqData })
  24. let userData = ReqData.data
  25. if (userData?.code !== 200 || !userData.data)
  26. return res.json({
  27. ...BaseStdResponse.ERR,
  28. msg: '无法解析用户数据,请重试'
  29. })
  30. const { token } = userData.data
  31. if ([token].some(value => value === '' || value === null || value === undefined))
  32. return res.json({
  33. ...BaseStdResponse.ERR,
  34. msg: '未提取出用户登录信息,请重试'
  35. })
  36. const ResData = await axios.post(endpoint, { data: resData })
  37. let userData2 = ResData.data
  38. if (userData2?.code !== 200 || !userData2.data)
  39. return res.json({
  40. ...BaseStdResponse.ERR,
  41. msg: '无法解析用户数据,请重试'
  42. })
  43. const { uid, user_avatar, student_num, school_id, grade_id, class_id, sex, name, academy_name } = userData2.data
  44. if ([uid, user_avatar, student_num, school_id, grade_id, class_id, sex, name, academy_name].some(value => value === '' || value === null || value === undefined))
  45. return res.json({
  46. ...BaseStdResponse.ERR,
  47. msg: '未提取出用户登录信息,请重试'
  48. })
  49. let findSql = 'SELECT email, create_user, auto_run FROM lepao_account WHERE student_num = ?'
  50. let findRows = await db.query(findSql, [student_num])
  51. if (!findRows)
  52. return res.json({
  53. ...BaseStdResponse.ERR,
  54. msg: '无法解析用户数据,请重试'
  55. })
  56. if (findRows.length === 0)
  57. return res.json({
  58. ...BaseStdResponse.ERR,
  59. msg: '该乐跑账号尚未在RunForge系统中添加,请先前往 https://lepao.ctbu.top/ 添加你的账户'
  60. })
  61. const time = new Date().getTime()
  62. let updateSql = 'UPDATE lepao_account SET uid = ?, token = ?, school_id = ?, name = ?, grade_id = ?, class_id = ?, sex = ?, academy_name = ?, update_time = ?, state = 1 WHERE student_num = ?'
  63. let updateRows = await db.query(updateSql, [uid, token, school_id, name, grade_id, class_id, sex, academy_name, time, student_num])
  64. if (updateRows && updateRows.affectedRows > 0) {
  65. res.json({
  66. ...BaseStdResponse.OK,
  67. data: {
  68. name,
  69. sex,
  70. academy_name,
  71. grade_id,
  72. auto_run: findRows[0].auto_run,
  73. account: student_num
  74. }
  75. })
  76. let emailData = {
  77. name,
  78. account: student_num
  79. }
  80. await EmailTemplate.updateSuccess(findRows[0].email, emailData)
  81. }
  82. } catch (error) {
  83. this.logger.error(`更新用户信息时出错。${error.stack}`)
  84. return res.json({
  85. ...BaseStdResponse.ERR,
  86. msg: '更新用户信息失败,请重试'
  87. })
  88. }
  89. }
  90. }
  91. module.exports.UpdateAccount = UpdateAccount;