UpdateAccountiPhone.js 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174
  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.js')
  5. const config = require('../../../../config.json')
  6. const lepao = require("../../../../lib/Lepao/Lepao.js").lepao
  7. const mq = require('../../../../plugin/mq')
  8. const { BaseStdResponse } = require("../../../../BaseStdResponse.js")
  9. const { dataDecrypt } = require('../../../../plugin/Lepao/Crypto')
  10. // 客户端上传数据接口
  11. class UpdateAccountiPhone extends API {
  12. constructor() {
  13. super()
  14. this.messageQueue = 'runforge_message_queue'
  15. this.runpy = config.runpy
  16. this.noEncrypt()
  17. this.setPath('/Lepao/UpdateAccountiPhone')
  18. this.setMethod('POST')
  19. }
  20. async onRequest(req, res) {
  21. let { reqData, resData, headers } = req.body
  22. if ([reqData, resData, headers].some(value => value === '' || value === null || value === undefined))
  23. return res.json({
  24. ...BaseStdResponse.MISSING_PARAMETER,
  25. msg: '账号信息不完整,请稍后再试获联系客服处理'
  26. })
  27. try {
  28. const userData = JSON.parse(dataDecrypt(reqData) || '{}')
  29. if (!userData || Object.keys(userData).length === 0)
  30. return res.json({
  31. ...BaseStdResponse.ERR,
  32. msg: '无法解析用户数据,请重试'
  33. })
  34. const { token } = userData
  35. if ([token].some(value => value === '' || value === null || value === undefined))
  36. return res.json({
  37. ...BaseStdResponse.ERR,
  38. msg: '未提取出用户登录信息,请重试'
  39. })
  40. const userData2 = JSON.parse(dataDecrypt(resData) || '{}')
  41. if (!userData2 || Object.keys(userData2).length === 0)
  42. return res.json({
  43. ...BaseStdResponse.ERR,
  44. msg: '无法解析用户数据,请重试'
  45. })
  46. const { uid, user_avatar, student_num, school_id, grade_id, class_id, sex, name, academy_name } = userData2
  47. if ([uid, student_num, school_id, grade_id, class_id, sex, name, academy_name].some(value => value === '' || value === null || value === undefined))
  48. return res.json({
  49. ...BaseStdResponse.ERR,
  50. msg: '未提取出用户登录信息,请重试'
  51. })
  52. let findSql = `
  53. SELECT
  54. a.email, a.create_user, a.auto_run, a.auto_day, a.notice_type, e.bot_umo
  55. FROM
  56. lepao_account a
  57. LEFT JOIN
  58. lepao_extra e
  59. ON
  60. a.student_num = e.student_num
  61. WHERE
  62. a.student_num = ? AND a.create_user IS NOT NULL
  63. `
  64. let findRows = await db.query(findSql, [student_num])
  65. if (!findRows)
  66. return res.json({
  67. ...BaseStdResponse.ERR,
  68. msg: '无法解析用户数据,请重试'
  69. })
  70. if (findRows.length === 0)
  71. return res.json({
  72. ...BaseStdResponse.ERR,
  73. msg: '该乐跑账号尚未在RunForge系统中添加,请先添加你的账户'
  74. })
  75. const time = new Date().getTime()
  76. let updateSql = 'UPDATE lepao_account SET uid = ?, token = ?, school_id = ?, name = ?, grade_id = ?, class_id = ?, sex = ?, academy_name = ?, update_time = ?, user_avatar = ?, state = 1, userAgent = ?, deviceModel = ? WHERE student_num = ?'
  77. let updateRows = await db.query(updateSql, [uid, token, school_id, name, grade_id, class_id, sex, academy_name, time, user_avatar ?? 'https://lepao-cloud.xxoo365.top/view.php/25aa126dc406974ff3579a99a2c6501a.png', headers["User-Agent"] ?? 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.29(0x18001d21) NetType/WIFI Language/zh_CN wxwork/5.0.6', 'unknown<iPhone18,3>', student_num])
  78. if (updateRows && updateRows.affectedRows > 0) {
  79. let msg
  80. if (findRows[0].auto_run === 1) {
  81. msg = `当前已开启自动乐跑,系统将自动进行乐跑。后续通知将发送到您的邮箱:${findRows[0].email}。请留意邮箱提醒。`
  82. }
  83. else {
  84. msg = `当前未开启自动乐跑,如需进行乐跑,请前往 RunForge 手动执行乐跑操作。后续通知将发送到您的邮箱:${findRows[0].email},请留意邮箱提醒。`
  85. }
  86. res.json({
  87. ...BaseStdResponse.OK,
  88. data: {
  89. name,
  90. user_avatar,
  91. sex,
  92. academy_name,
  93. grade_id,
  94. auto_run: findRows[0].auto_run,
  95. account: student_num,
  96. msg
  97. }
  98. })
  99. let emailData = {
  100. name,
  101. type: 'lepao_update',
  102. umo: findRows[0].bot_umo,
  103. account: student_num,
  104. academy_name,
  105. grade_id,
  106. auto_run: findRows[0].auto_run
  107. }
  108. if (findRows[0].notice_type === 'bot' && findRows[0].bot_umo) {
  109. this.logger.info(`${student_num}发送乐跑更新Bot通知,UMO=${findRows[0].bot_umo}`)
  110. const ch = await mq.getChannel(this.messageQueue)
  111. await ch.assertQueue(this.messageQueue, {
  112. durable: true
  113. })
  114. ch.sendToQueue(
  115. this.messageQueue,
  116. Buffer.from(JSON.stringify(emailData)),
  117. {
  118. persistent: true,
  119. contentType: 'application/json'
  120. }
  121. )
  122. this.logger.info(`${student_num}乐跑更新Bot通知发送完成`)
  123. } else if (findRows[0].notice_type === 'email' && findRows[0].email) {
  124. await EmailTemplate.updateSuccess(findRows[0].email, emailData)
  125. this.logger.info(`${student_num}乐跑更新邮件发送完成`)
  126. }
  127. if (findRows[0].auto_run === 1 && Array.isArray(findRows[0].auto_day) && findRows[0].auto_day.includes(new Date().getDay())) {
  128. lepao.beginLepao(findRows[0].create_user, student_num, token, uid, school_id, 1)
  129. }
  130. }
  131. // 获取新加账号中存在的路径
  132. try {
  133. let sql = 'SELECT id FROM lepao_record WHERE lepao_account = ?'
  134. let rows = await db.query(sql, [student_num])
  135. // 不是老帐号就不获取
  136. if (!rows || rows.length !== 0) return
  137. const reqData = { uid, token, school_id, student_id: student_num }
  138. this.logger.info(`开始请求获取跑步记录 uid=${uid} student_id=${student_num}`)
  139. const recordUrl = this.runpy + '/get_path_data'
  140. await axios.post(recordUrl, reqData)
  141. } catch (error) {
  142. this.logger.info(`获取跑步记录出错 ${error.stack}`)
  143. }
  144. } catch (error) {
  145. this.logger.error(`更新用户信息时出错。${error.stack}`)
  146. return res.json({
  147. ...BaseStdResponse.ERR,
  148. msg: '更新用户信息失败,请重试'
  149. })
  150. }
  151. }
  152. }
  153. module.exports.UpdateAccountiPhone = UpdateAccountiPhone