getRankGlobalData.js 561 B

123456789101112131415161718
  1. module.exports = async (ctx, next) => {
  2. if (ctx.state.$wxInfo.loginState === 1) {
  3. const query = ctx.query
  4. const { mysql } = require('../qcloud')
  5. await mysql('cSessionInfo').select('user_info', 'score').orderBy('score', 'desc').limit(10).offset(query.loadNumber * 10).then(res => {//获取原始得分
  6. let arr = []
  7. res.forEach(function (val, i) {
  8. let value = JSON.parse(val.user_info)
  9. value.score = val.score
  10. arr[i] = value
  11. })
  12. ctx.state.data = arr
  13. })
  14. } else {
  15. ctx.state.code = -1
  16. }
  17. }